squirrels

Custom SQL query returning 8 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 "Location" = :p1 and "Primary Fur Color" = :p2 order by [Tail twitches] 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	Running	Chasing	Climbing	Eating	Foraging	Tail flags	Runs from	Other Interactions	Lat/Long
130	-73.95816559494371	40.799770819002205	41A-PM-1007-06	41A	PM	10072018	6	Adult	Black		Black+	Ground Plane	FALSE	1	0	1	1	0	0	1		POINT (-73.9581655949437 40.7997708190022)
227	-73.95981553009129	40.7905887826983	32E-AM-1007-10	32E	AM	10072018	10	Adult	Black		Black+	Ground Plane	FALSE	0	0	0	0	1	0	0		POINT (-73.9598155300913 40.7905887826983)
721	-73.97182620344691	40.76667717974421	4I-PM-1007-02	04I	PM	10072018	2	Adult	Black		Black+	Ground Plane	FALSE	0	1	0	0	0	0	0		POINT (-73.9718262034469 40.7666771797442)
1307	-73.9565197137317	40.7986011403785	41C-PM-1007-01	41C	PM	10072018	1	Adult	Black		Black+	Ground Plane	FALSE	1	0	0	1	0	0	1		POINT (-73.9565197137317 40.7986011403785)
2166	-73.9711178122133	40.7672642958437	4I-PM-1007-01	04I	PM	10072018	1	Adult	Black		Black+	Ground Plane	FALSE	1	0	0	0	1	0	1		POINT (-73.9711178122133 40.76726429584371)
2413	-73.959701727877	40.790660026971004	32E-AM-1007-03	32E	AM	10072018	3	Adult	Black		Black+	Ground Plane	FALSE	1	0	0	0	0	0	0		POINT (-73.959701727877 40.790660026971)
2469	-73.9600963639087	40.7934962325313	34C-AM-1007-01	34C	AM	10072018	1	Adult	Black		Black+	Ground Plane	FALSE	1	0	0	0	0	1	1	dog	POINT (-73.9600963639087 40.7934962325313)
2651	-73.9632993246327	40.78881995196561	29C-AM-1007-05	29C	AM	10072018	5	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE	0	0	0	0	1	0	0		POINT (-73.9632993246327 40.7888199519656)