squirrels

Custom SQL query returning 4 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 "Above Ground Sighter Measurement" = :p0 and "Primary Fur Color" = :p1 order by Shift 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	Other Activities	Tail flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
608	-73.95896759955171	40.791311922358396	33E-AM-1014-09	33E	AM	10142018	9	Juvenile	Black		Black+	Above Ground	15		0	1	0	0		0	0	1	0		POINT (-73.9589675995517 40.7913119223584)
210	-73.97112984911321	40.76769026035429	5I-PM-1008-01	05I	PM	10082018	1	Adult	Black	Cinnamon	Black+Cinnamon	Above Ground	15	in tree by arsenal - climbing	0	0	1	1		1	0	0	0		POINT (-73.9711298491132 40.7676902603543)
381	-73.959709414696	40.7919745085986	33D-PM-1006-03	33D	PM	10062018	3		Black		Black+	Above Ground	15		1	0	0	1		0	1	0	1	ran up tree	POINT (-73.959709414696 40.7919745085986)
1887	-73.95861842328891	40.7993153832942	41A-PM-1007-02	41A	PM	10072018	2	Adult	Black		Black+	Above Ground	15		0	0	1	0	jumping	0	0	0	0	stared at me	POINT (-73.9586184232889 40.7993153832942)