squirrels

Custom SQL query returning 14 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 "Approaches" = :p0 and "Date" = :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	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
188	-73.9570528770427	40.7990973804149	41B-AM-1010-07	41B	AM	10102018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	10		false	false	false	false	false		true	false	false	true	false	true	false	false	mad!	POINT (-73.9570528770427 40.7990973804149)	19	4	19	13
572	-73.9763622269272	40.7704671295941	5C-PM-1010-10	05C	PM	10102018	10	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	true	false	false	fed by woman	POINT (-73.9763622269272 40.7704671295941)	19	4	19	13
692	-73.9594529310985	40.7840492606552	26I-PM-1010-04	26I	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false		POINT (-73.95945293109851 40.7840492606552)	19	4	19	13
917	-73.9676514056678	40.7730853732876	11H-AM-1010-01	11H	AM	10102018	1	Adult	Gray	White	Gray+White	Above Ground	20		false	false	true	false	false		false	false	false	false	false	true	false	false	started climbing down to me	POINT (-73.9676514056678 40.7730853732876)	19	4	19	13
1330	-73.9643032554205	40.7794514526463	19H-AM-1010-02	19H	AM	10102018	2		Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE	near base of small tree	true	false	false	true	true		false	false	false	true	false	true	false	false	ran from human with dog	POINT (-73.9643032554205 40.7794514526463)	19	4	19	13
1336	-73.9733820053679	40.7687330473562	5G-PM-1010-05	05G	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false		POINT (-73.9733820053679 40.7687330473562)	19	4	19	13
1597	-73.9789401448556	40.7697373141498	4B-AM-1010-04	04B	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false		POINT (-73.9789401448556 40.7697373141498)	19	4	19	13
1672	-73.9640989602986	40.7899295439265	29B-PM-1010-03	29B	PM	10102018	3	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false		POINT (-73.9640989602986 40.7899295439265)	19	4	19	13
2455	-73.9577297187155	40.799225295679	41B-AM-1010-08	41B	AM	10102018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	20		false	false	true	true	false		false	false	false	false	false	true	false	false		POINT (-73.9577297187155 40.799225295679)	19	4	19	13
2523	-73.9619016393127	40.7925160126921	33B-PM-1010-06	33B	PM	10102018	6	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	true	false	false		POINT (-73.9619016393127 40.7925160126921)	19	4	19	13
2575	-73.9735753352129	40.7687061447032	5G-PM-1010-04	05G	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	true	false	false		POINT (-73.9735753352129 40.7687061447032)	19	4	19	13
2816	-73.9809342290598	40.7687265606227	2A-AM-1010-05	02A	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE	base of tree with ~ 30 small birds all eating	false	false	false	true	true		false	false	false	false	true	true	true	false		POINT (-73.9809342290598 40.7687265606227)	19	4	19	13
2957	-73.9747313152152	40.7653888351839	1G-PM-1010-03	01G	PM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false		POINT (-73.9747313152152 40.7653888351839)	19	4	19	13
2976	-73.9724083320538	40.7744163768061	11D-AM-1010-08	11D	AM	10102018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		false	false	false	true	true	drinking	false	false	false	false	false	true	false	false		POINT (-73.9724083320538 40.7744163768061)	19	4	19	13