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 "Date" = :p0 and "Tail flags" = :p1 order by Longitude 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
2489	-73.9663168490265	40.7825083721362	21D-AM-1008-01	21D	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	true	true		false	false	false	true	true	false	true	false		POINT (-73.9663168490265 40.7825083721362)	19	4	19	13
1135	-73.9667474482967	40.7760643720793	15H-PM-1008-01	15H	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	10	Oak tree	false	true	false	false	false	watching me	false	true	false	true	false	false	false	false	observant	POINT (-73.9667474482967 40.7760643720793)	19	4	19	13
80	-73.9688454483585	40.7845301288163	22A-AM-1008-05	22A	AM	10082018	5	Adult	Gray	White	Gray+White	Above Ground	3	trash can	false	false	false	true	false		false	false	false	true	false	false	false	true		POINT (-73.9688454483585 40.7845301288163)	19	4	19	13
2185	-73.9707571364399	40.7758859812524	13E-PM-1008-02	13E	PM	10082018	2	Adult	Gray	White	Gray+White	Above Ground	10		false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9707571364399 40.7758859812524)	19	4	19	13
210	-73.9711298491132	40.7676902603543	5I-PM-1008-01	05I	PM	10082018	1	Adult	Black	Cinnamon	Black+Cinnamon	Above Ground	15	in tree by arsenal - climbing	false	false	true	true	false		false	false	false	true	false	false	false	false		POINT (-73.9711298491132 40.7676902603543)	19	4	19	13
1981	-73.972154069981	40.7690128009722	6G-AM-1008-03	06G	AM	10082018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE	grass	false	false	false	true	true		false	false	false	true	false	false	true	false		POINT (-73.972154069981 40.7690128009722)	19	4	19	13
2429	-73.9726699686943	40.7701123791223	7F-AM-1008-01	07F	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	under bench	false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9726699686943 40.7701123791223)	19	4	19	13
1982	-73.9729979174723	40.7742904356698	10D-PM-1008-01	10D	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9729979174723 40.7742904356698)	19	4	19	13
507	-73.9744835563086	40.7729521433235	9D-AM-1008-01	09D	AM	10082018	1	Adult	Gray		Gray+	Ground Plane	FALSE		false	false	false	false	true		false	false	false	true	false	false	false	true		POINT (-73.9744835563086 40.7729521433235)	19	4	19	13
150	-73.9763430829342	40.7686351097159	4D-PM-1008-11	04D	PM	10082018	11	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	3	on tree facing downward	false	true	false	false	false	chased #12	true	false	false	true	false	false	false	true		POINT (-73.9763430829342 40.7686351097159)	19	4	19	13
194	-73.9764839973068	40.7691725326976	4D-PM-1008-06	04D	PM	10082018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9764839973068 40.7691725326976)	19	4	19	13