squirrels

Custom SQL query returning 10 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 "Chasing" = :p0 and "Highlight Fur Color" = :p1 and "Indifferent" = :p2 order by Date 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	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Approaches	Runs from	Lat/Long
230	-73.97314980648721	40.7659963196581	2H-AM-1006-02	02H	AM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	1	0	0		0	0	0	1	0	POINT (-73.9731498064872 40.7659963196581)
335	-73.97823514358521	40.7715896672335	6A-AM-1006-03	06A	AM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	30	tree	0	1	0	1	0		0	1	1	0	0	POINT (-73.9782351435852 40.7715896672335)
1201	-73.97828135384209	40.7715730368712	6A-AM-1006-02	06A	AM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	30	tree	0	1	1	0	0		0	1	0	0	0	POINT (-73.9782813538421 40.7715730368712)
1220	-73.97799837948492	40.767545209917294	2D-AM-1007-02	02D	AM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	6	up tree	0	1	1	0	0		0	0	0	0	0	POINT (-73.9779983794849 40.7675452099173)
1236	-73.97920390711141	40.76787494712671	2C-AM-1010-07	02C	AM	10102018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		1	1	0	0	0	#7 & #8 chased each other up diff tree	0	0	0	0	1	POINT (-73.9792039071114 40.76787494712671)
740	-73.95834778506341	40.7914073632782	33F-PM-1012-06	33F	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	0	1	1		1	0	1	0	0	POINT (-73.9583477850634 40.7914073632782)
2733	-73.9690082314914	40.7738993942891	12G-AM-1012-05	12G	AM	10122018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	0	0	0		1	0	0	0	1	POINT (-73.9690082314914 40.7738993942891)
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	0	playing,interacting with #6	0	0	1	0	0	POINT (-73.9697178096275 40.769703669630104)
1584	-73.9581310602492	40.7960214726964	38C-PM-1014-05	38C	PM	10142018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	0	0	0	chasing (#4)	0	0	0	0	1	POINT (-73.9581310602492 40.7960214726964)
629	-73.95737241332641	40.7980080911115	40C-AM-1017-02	40C	AM	10172018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	0	1	0	chasing (#1)	0	0	0	0	1	POINT (-73.9573724133264 40.7980080911115)