squirrels

Custom SQL query returning 18 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 "Date" = :p0 and "Hectare Squirrel Number" = :p1 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	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	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
53	-73.9584970643213	40.7982886348696	40B-AM-1019-03	40B	AM	10192018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		true	true	false	false	false		false	false	false	false	true	true	false	false		POINT (-73.9584970643213 40.7982886348696)	19	4	19	13
888	-73.9674177504573	40.7769569731993	15G-PM-1019-03	15G	PM	10192018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9674177504573 40.7769569731993)	19	4	19	13
991	-73.9635689059841	40.790163434915	30B-PM-1019-03	30B	PM	10192018	3	Adult	Gray	Black	Gray+Black		Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9635689059841 40.790163434915)	19	4	19	13
1254	-73.9764013589865	40.7663063499207	1F-PM-1019-03	01F	PM	10192018	3	Juvenile	Gray		Gray+		Above Ground	1		false	false	false	false	false	hiding	false	false	false	false	false	false	false	false		POINT (-73.9764013589865 40.7663063499207)	19	4	19	13
1392	-73.9648090698176	40.7903882097837	29A-PM-1019-03	29A	PM	10192018	3	Juvenile	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		false	false	false	false	false		false	false	false	false	false	true	false	true	ran from,but now approaching. kind of weirding me out.	POINT (-73.9648090698176 40.7903882097837)	19	4	19	13
1465	-73.9720289863666	40.7763749561607	13C-PM-1019-03	13C	PM	10192018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		true	false	false	true	false		false	false	false	false	false	false	false	true		POINT (-73.97202898636661 40.7763749561607)	19	4	19	13
1759	-73.9576219570858	40.7963351225672	38C-AM-1019-03	38C	AM	10192018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	true		POINT (-73.9576219570858 40.7963351225672)	19	4	19	13
1798	-73.9558180952889	40.7886810505944	31I-PM-1019-03	31I	PM	10192018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	true		POINT (-73.9558180952889 40.7886810505944)	19	4	19	13
1907	-73.9689227467959	40.7837541607494	21B-AM-1019-03	21B	AM	10192018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9689227467959 40.7837541607494)	19	4	19	13
1912	-73.9698064901149	40.7842538115839	21A-AM-1019-03	21A	AM	10192018	3	Adult	Gray		Gray+		Ground Plane	FALSE	Tree & ground	false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9698064901149 40.78425381158391)	19	4	19	13
2036	-73.9610266708075	40.7817512107392	23I-PM-1019-03	23I	PM	10192018	3	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9610266708075 40.7817512107392)	19	4	19	13
2117	-73.9597192455543	40.7973316178661	38A-AM-1019-03	38A	AM	10192018	3	Adult	Gray	White	Gray+White	White belly	Ground Plane	FALSE		false	false	false	false	true	stood on back legs	false	false	false	false	false	true	true	true		POINT (-73.9597192455543 40.7973316178661)	19	4	19	13
2254	-73.9709991016317	40.7725756707748	10F-PM-1019-03	10F	PM	10192018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head	Ground Plane	FALSE	Behind fence, grass	false	false	false	true	false	eating (nuts)	false	false	false	false	false	true	false	false	approaches (bad tourists w/ nuts)	POINT (-73.9709991016317 40.772575670774806)	19	4	19	13
2412	-73.9809446489564	40.7685032165879	2A-PM-1019-03	02A	PM	10192018	3	Juvenile	Gray	White	Gray+White		Above Ground	15	in tree!	true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9809446489564 40.7685032165879)	19	4	19	13
2544	-73.9713680837672	40.7771661508364	14D-PM-1019-03	14D	PM	10192018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	true		POINT (-73.9713680837672 40.77716615083641)	19	4	19	13
2660	-73.9726056411971	40.7793467904743	16A-PM-1019-03	16A	PM	10192018	3		Gray		Gray+		Above Ground	15		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9726056411971 40.7793467904743)	19	4	19	13
2736	-73.9593895253501	40.7973085844087	38B-AM-1019-03	38B	AM	10192018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	true	false	true	false		POINT (-73.9593895253501 40.7973085844087)	19	4	19	13
2865	-73.9802842404016	40.7678257384977	1B-PM-1019-03	01B	PM	10192018	3	Juvenile	Gray	White	Gray+White		Above Ground	25	in tree	false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.98028424040162 40.7678257384977)	19	4	19	13