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 "Hectare Squirrel Number" = :p0 and "Highlight Fur Color" = :p1 and "Tail twitches" = :p2 order by Moans 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	Climbing	Eating	Foraging	Tail flags	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
261	-73.9552861155228	40.788973931872	32I-AM-1013-05	32I	AM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	3	In and below shrub	0	1	0	1	1	0	1	0		POINT (-73.9552861155228 40.788973931872)
263	-73.9771069181511	40.76705382149879	2E-PM-1014-05	02E	PM	10142018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1	0	0	1	0		POINT (-73.9771069181511 40.7670538214988)
928	-73.96704295859901	40.778437071937105	17F-AM-1007-05	17F	AM	10072018	5	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	0	1	0	1	0	1	0		POINT (-73.967042958599 40.7784370719371)
1891	-73.9749641575871	40.767330505627704	3F-AM-1006-05	03F	AM	10062018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	3		0	1	1	0	0	0	0	1		POINT (-73.9749641575871 40.7673305056277)
2245	-73.9774228454023	40.7686399839016	3D-AM-1006-05	03D	AM	10062018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	0	0	0	0	0	0	1	runs from (chased by boy),wary of humans in playground	POINT (-73.9774228454023 40.7686399839016)
2646	-73.9772239251936	40.7731716665766	8A-AM-1013-05	08A	AM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	20		1	1	1	0	0	1	0	0		POINT (-73.9772239251936 40.7731716665766)
2651	-73.9632993246327	40.78881995196561	29C-AM-1007-05	29C	AM	10072018	5	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE		0	0	0	1	0	0	0	0		POINT (-73.9632993246327 40.7888199519656)
2913	-73.9621297946132	40.7944058222814	34A-PM-1013-05	34A	PM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	4		1	0	0	0	0	0	0	0		POINT (-73.9621297946132 40.7944058222814)