squirrels

Custom SQL query returning 12 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 "Primary Fur Color" = :p1 order by [Color notes] 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	Other Activities	Quaas	Tail flags	Indifferent	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	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	0	0		POINT (-73.9598155300913 40.7905887826983)
369	-73.9596398997228	40.793338695384705	34D-PM-1007-02	34D	PM	10072018	2	Adult	Black		Black+	Above Ground	25	1	0	1	0	0		0	0	0	0	cautiously aware	POINT (-73.9596398997228 40.7933386953847)
634	-73.95963759070379	40.79073477083529	32E-AM-1007-05	32E	AM	10072018	5	Adult	Black		Black+	Above Ground	30	0	0	1	0	0		0	0	1	0		POINT (-73.9596375907038 40.79073477083531)
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	0	0		POINT (-73.9718262034469 40.7666771797442)
858	-73.96293834202741	40.7889383725489	29C-AM-1007-02	29C	AM	10072018	2	Adult	Black	Gray	Black+Gray	Above Ground	10	1	0	1	0	0		1	0	0	1		POINT (-73.9629383420274 40.7889383725489)
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	0	0	1		POINT (-73.9565197137317 40.7986011403785)
1887	-73.95861842328891	40.7993153832942	41A-PM-1007-02	41A	PM	10072018	2	Adult	Black		Black+	Above Ground	15	0	0	1	0	0	jumping	0	0	0	0	stared at me	POINT (-73.9586184232889 40.7993153832942)
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	0	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	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		0	1	0	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	0	0		POINT (-73.9632993246327 40.7888199519656)