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], [Zip Codes], [Community Districts], [Borough Boundaries], [City Council Districts], [Police Precincts] from squirrels where "Combination of Primary and Highlight Color" = :p0 and "Date" = :p1 and "Eating" = :p2 and "Indifferent" = :p3 and "Runs from" = :p4 order by rowid 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	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
158	-73.9710991123992	40.7723889726647	9F-PM-1014-02	09F	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.9710991123992 40.7723889726647)	19	4	19	13
393	-73.9577212629651	40.7965525296722	38C-PM-1014-06	38C	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9577212629651 40.7965525296722)	19	4	19	13
577	-73.9497217674555	40.796517007214	42I-PM-1014-03	42I	PM	10142018	3		Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.9497217674555 40.796517007214)	19	4	19	13
719	-73.9626881234742	40.7905208345549	30C-AM-1014-01	30C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	true	false	true	false	POINT (-73.9626881234742 40.7905208345549)	19	4	19	13
818	-73.9608757424052	40.7906686504657	31D-AM-1014-06	31D	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.9608757424052 40.7906686504657)	19	4	19	13
878	-73.9757215415855	40.7668205976986	2F-PM-1014-03	02F	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.9757215415855 40.7668205976986)	19	4	19	13
1021	-73.97186968288	40.778926988884	15B-AM-1014-03	15B	AM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	true	false	false	true	true	running (from a dog)	false	false	false	false	false	false	true	false	POINT (-73.97186968288 40.778926988884)	19	4	19	13
2507	-73.964868521585	40.7821064183815	22F-PM-1014-01	22F	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.964868521585 40.7821064183815)	19	4	19	13
2580	-73.970795746101	40.7704727212299	8H-PM-1014-01	08H	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.970795746101 40.7704727212299)	19	4	19	13
2846	-73.9661570478029	40.7807271518813	20E-AM-1014-02	20E	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9661570478029 40.7807271518813)	19	4	19	13
2967	-73.9713257586372	40.7762719619467	13D-AM-1014-09	13D	AM	10142018	9	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9713257586372 40.7762719619467)	19	4	19	13
2980	-73.9716414586381	40.771760114722	9F-PM-1014-06	09F	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	true	false	false	true	false	running (from birds)	false	false	false	true	false	false	true	false	POINT (-73.9716414586381 40.771760114722)	19	4	19	13