squirrels

Custom SQL query returning 9 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 "Combination of Primary and Highlight Color" = :p0 and "Date" = :p1 order by Approaches limit 101

Query parameters

This data as json, CSV

rowid	Longitude	Latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	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
794	-73.9790010565108	40.7685732369544	2C-PM-1013-09	02C	PM	10132018	9	Adult	+		Ground Plane	FALSE		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9790010565108 40.7685732369544)	19	4	19	13
867	-73.9762257701293	40.7744032758323	9A-AM-1013-08	09A	AM	10132018	8	Adult	+					false	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9762257701293 40.7744032758323)	19	4	19	13
1459	-73.9563847867316	40.7906012261163	33G-AM-1013-03	33G	AM	10132018	3	?	+	Only peeked head out	Above Ground	13		false	false	false	false	false	peeking out of tree,did not come out	false	false	false	false	false	false	false	false		POINT (-73.9563847867316 40.7906012261163)	19	4	19	13
2606	-73.96143417385	40.7945464262112	35B-PM-1013-02	35B	PM	10132018	2	Juvenile	+		Ground Plane	FALSE		false	false	false	true	false	did not notice dog sitting a few yards away (10-20 ft)	false	false	false	false	true	false	true	false		POINT (-73.96143417385 40.7945464262112)	19	4	19	13
2693	-73.9561498646036	40.7949288561893	37E-AM-1013-05	37E	AM	10132018	5	?	+		Above Ground	10	unsure, just heard kuks	false	false	false	false	false		true	false	false	false	false	false	false	false		POINT (-73.9561498646036 40.79492885618931)	19	4	19	13
2714	-73.9600738985438	40.7938328798752	35C-PM-1013-08	35C	PM	10132018	8		+					false	false	false	false	false		true	false	false	false	false	false	false	false	did not see	POINT (-73.9600738985438 40.7938328798752)	19	4	19	13
2784	-73.9763722433833	40.7744121430891	9A-AM-1013-07	09A	AM	10132018	7	Adult	+					false	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9763722433833 40.7744121430891)	19	4	19	13
222	-73.9770273553525	40.7732399463626	8A-AM-1013-03	08A	AM	10132018	3	Juvenile	+		Above Ground	3	fence	true	true	true	true	false	playing tag together	false	false	false	false	false	true	false	false		POINT (-73.9770273553525 40.7732399463626)	19	4	19	13
1623	-73.9770119133023	40.7732949090005	8A-AM-1013-04	08A	AM	10132018	4	Juvenile	+		Above Ground	4	fence	true	true	false	true	true	playing tag together	false	false	false	false	false	true	false	false		POINT (-73.9770119133023 40.7732949090005)	19	4	19	13