squirrels

Custom SQL query returning 6 rows (hide)

select rowid, longitude, latitude, [Unique Squirrel ID], Hectare, Shift, Date, [Hectare Squirrel Number], Age, [Primary Fur Color], [Highlight Fur Color], [Combination of Primary and Highlight Color], [Color notes], Location, [Above Ground Sighter Measurement], [Specific Location], Running, Chasing, Climbing, Eating, Foraging, [Other Activities], Kuks, Quaas, Moans, [Tail flags], [Tail twitches], Approaches, Indifferent, [Runs from], [Other Interactions], [Lat/Long] from [2018_Central_Park_Squirrel_Census_-_Squirrel_Data] where "Date" = :p0 and "Highlight Fur Color" = :p1 and "Tail twitches" = :p2 order by longitude limit 101

Query parameters

This data as json, CSV

rowid	longitude	latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary Fur Color	Highlight Fur Color	Combination of Primary and Highlight Color	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Eating	Foraging	Other Activities	Quaas	Tail twitches	Indifferent	Other Interactions	Lat/Long
1797	-73.96971780962751	40.769703669630104	7I-PM-1013-07	07I	PM	10132018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	Under the tree	0	1	0	0	playing,interacting with #6	0	1	0		POINT (-73.9697178096275 40.769703669630104)
1108	-73.96383977903841	40.782895027290394	23F-PM-1013-02	23F	PM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	1		1	1	1	indifferent (mostly,did notice me,busy eating,foraging)	POINT (-73.9638397790384 40.7828950272904)
1681	-73.9638141923763	40.782922532628795	23F-PM-1013-03	23F	PM	10132018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1		0	1	1	indifferent (noticed me,busy eating,foraging)	POINT (-73.9638141923763 40.7829225326288)
2770	-73.96379835137891	40.7828712516396	23F-PM-1013-04	23F	PM	10132018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary: "much browner, like 1/2 & 1/2".	Ground Plane	FALSE		0	0	0	1		0	1	1	indifferent (busy foraging)	POINT (-73.9637983513789 40.7828712516396)
1848	-73.96040944813359	40.795145147879296	36B-PM-1013-01	36B	PM	10132018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1		0	1	1		POINT (-73.9604094481336 40.7951451478793)
155	-73.9522142360388	40.7949598486683	39H-PM-1013-02	39H	PM	10132018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1		0	1	1		POINT (-73.9522142360388 40.7949598486683)