squirrels

Custom SQL query returning 12 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	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
246	-73.9779805668091	40.7680931566797	2D-PM-1012-02	02D	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false		POINT (-73.9779805668091 40.7680931566797)	19	4	19	13
340	-73.9744960829844	40.7652585501959	1H-AM-1012-01	01H	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	true	false	true	first approaches then runs from - he was less than 1 yd. away from me.	POINT (-73.9744960829844 40.7652585501959)	19	4	19	13
420	-73.9671851611243	40.7750878657618	14H-PM-1012-01	14H	PM	10122018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		true	false	false	true	false		false	false	false	false	false	true	false	false	approaches (came very close to me)	POINT (-73.9671851611243 40.7750878657618)	19	4	19	13
669	-73.9802079259866	40.7678723471007	1B-AM-1012-10	01B	AM	10122018	10	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false		POINT (-73.9802079259866 40.7678723471007)	19	4	19	13
1138	-73.9594357049738	40.7840678890949	25I-AM-1012-01	25I	AM	10122018	1	Adult	Cinnamon		Cinnamon+		Above Ground	4	on bar	false	false	false	true	false		false	false	false	true	true	true	false	false		POINT (-73.9594357049738 40.7840678890949)	19	4	19	13
1428	-73.9666113598566	40.7752662550312	14H-PM-1012-05	14H	PM	10122018	5	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	true	false	false	approaches (someone was feeding it)	POINT (-73.9666113598566 40.7752662550312)	19	4	19	13
1721	-73.9587330707463	40.7907682009641	32F-AM-1012-02	32F	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray patches on back legs	Ground Plane	FALSE		false	false	false	false	false	curious about me	false	false	false	false	false	true	false	true		POINT (-73.9587330707463 40.7907682009641)	19	4	19	13
1947	-73.9747175419546	40.7692820030878	5E-PM-1012-05	05E	PM	10122018	5	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	true	false	false	begging	POINT (-73.9747175419546 40.7692820030878)	19	4	19	13
2019	-73.9566705412766	40.7935560645735	36F-PM-1012-01	36F	PM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	Near rock	false	false	false	false	true		false	false	false	false	false	true	false	false		POINT (-73.9566705412766 40.7935560645735)	19	4	19	13
2205	-73.9594986107981	40.7840083040604	25I-AM-1012-03	25I	AM	10122018	3	Adult	Cinnamon		Cinnamon+		Above Ground	8	on turn, see map	true	true	false	true	false		false	false	false	false	true	true	false	false		POINT (-73.9594986107981 40.7840083040604)	19	4	19	13
2428	-73.9755643404768	40.7697569149388	5E-PM-1012-03	05E	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false		POINT (-73.9755643404768 40.7697569149388)	19	4	19	13
3023	-73.9754794191553	40.7696404489025	5E-PM-1012-01	05E	PM	10122018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false		POINT (-73.9754794191553 40.7696404489025)	19	4	19	13