squirrels

Custom SQL query returning 7 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 "Above Ground Sighter Measurement" = :p0 and "Foraging" = :p1 order by Shift 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	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
1714	-73.9763542780331	40.7736531303622	9B-AM-1010-02	09B	AM	10102018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1	in bush	false	false	true	false	true	false	false	false	false	true	false	false	true	froze	POINT (-73.9763542780331 40.773653130362206)	19	4	19	13
1923	-73.9743795190073	40.7692030411004	5E-AM-1008-05	05E	AM	10082018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1		false	false	false	false	true	false	false	false	false	false	false	true	false		POINT (-73.9743795190073 40.7692030411004)	19	4	19	13
2122	-73.9692946938852	40.7767389791452	14E-AM-1008-13	14E	AM	10082018	13	Adult	Gray		Gray+	Above Ground	1		false	false	true	true	true	false	false	false	false	false	false	true	false	curious	POINT (-73.9692946938852 40.7767389791452)	19	4	19	13
2831	-73.9753585157592	40.7698398607941	5E-AM-1008-07	05E	AM	10082018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1	on fence	false	false	false	false	true	false	false	false	false	false	false	true	false		POINT (-73.9753585157592 40.7698398607941)	19	4	19	13
1161	-73.9694066600156	40.7805662180672	18C-PM-1018-06	18C	PM	10182018	6	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	1		false	false	true	true	true	false	false	false	false	false	false	true	false		POINT (-73.9694066600156 40.7805662180672)	19	4	19	13
1564	-73.9703816112358	40.7773846065919	15D-PM-1017-02	15D	PM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1		false	false	true	false	true	false	false	false	false	false	false	true	false		POINT (-73.9703816112358 40.7773846065919)	19	4	19	13
2595	-73.9692676659807	40.7700678919108	8I-PM-1013-08	08I	PM	10132018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	1		false	false	true	true	true	false	false	false	false	false	false	false	true		POINT (-73.96926766598071 40.7700678919108)	19	4	19	13