squirrels

Custom SQL query returning 11 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 "Hectare Squirrel Number" = :p1 and "Indifferent" = :p2 and "Shift" = :p3 order by [Other Activities] 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	Color notes	Location	Above Ground Sighter Measurement	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
541	-73.9617612388703	40.7952875954297	35A-AM-1014-04	35A	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9617612388703 40.7952875954297)	19	4	19	13
842	-73.9645147011741	40.7772566833799	17I-AM-1014-04	17I	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	false	true	true	false		POINT (-73.9645147011741 40.7772566833799)	19	4	19	13
1436	-73.9766779585686	40.7669673778105	2E-AM-1010-04	02E	AM	10102018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	false	false	false	true	false		true	false	false	false	false	false	true	false		POINT (-73.9766779585686 40.7669673778105)	19	4	19	13
1591	-73.9576223390082	40.7979746639647	40B-AM-1019-04	40B	AM	10192018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	false	false	true	false	true		false	false	false	false	false	true	true	false		POINT (-73.9576223390082 40.79797466396471)	19	4	19	13
1600	-73.9753093777	40.7666673897583	2F-AM-1006-04	02F	AM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Beautiful white puff at the end of its tail	Ground Plane	FALSE	true	false	false	false	false		false	false	false	false	true	false	true	false		POINT (-73.97530937770001 40.7666673897583)	19	4	19	13
1710	-73.9545438656122	40.7902168635009	34I-AM-1012-04	34I	AM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9545438656122 40.7902168635009)	19	4	19	13
2059	-73.9710026704697	40.7761052764621	13D-AM-1014-04	13D	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9710026704697 40.7761052764621)	19	4	19	13
2607	-73.9642988690682	40.7795591281979	19H-AM-1010-04	19H	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	false	false	true	true	true		false	false	false	false	false	false	true	true	runs from human w/ dog	POINT (-73.9642988690682 40.7795591281979)	19	4	19	13
2863	-73.9698246369929	40.7711472794488	9H-AM-1006-04	09H	AM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9698246369929 40.7711472794488)	19	4	19	13
3000	-73.9688293382172	40.7738958027568	12G-AM-1012-04	12G	AM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	true	false	true	false		POINT (-73.9688293382172 40.773895802756805)	19	4	19	13
616	-73.9556937218252	40.7990928062435	42C-AM-1007-04	42C	AM	10072018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	young adult	Ground Plane	FALSE	false	false	false	false	false	walking	false	false	false	false	false	false	true	false		POINT (-73.9556937218252 40.7990928062435)	19	4	19	13