squirrels

Custom SQL query returning 16 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 "Climbing" = :p0 and "Combination of Primary and Highlight Color" = :p1 order by Age 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	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
99	-73.9710541405708	40.7724691605718	10F-PM-1019-05	10F	PM	10192018	5	Adult	Black	Black+	Above Ground	10	Behind fence, tree	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9710541405708 40.7724691605718)	19	4	19	13
130	-73.9581655949437	40.7997708190022	41A-PM-1007-06	41A	PM	10072018	6	Adult	Black	Black+	Ground Plane	FALSE		true	false	true	true	false		false	false	false	false	false	false	false	true		POINT (-73.9581655949437 40.7997708190022)	19	4	19	13
369	-73.9596398997228	40.7933386953847	34D-PM-1007-02	34D	PM	10072018	2	Adult	Black	Black+	Above Ground	25		true	false	true	false	false		false	false	false	false	false	false	false	false	cautiously aware	POINT (-73.9596398997228 40.7933386953847)	19	4	19	13
388	-73.9592537496995	40.7919271821316	33E-AM-1014-03	33E	AM	10142018	3	Adult	Black	Black+	Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9592537496995 40.7919271821316)	19	4	19	13
634	-73.9596375907038	40.7907347708353	32E-AM-1007-05	32E	AM	10072018	5	Adult	Black	Black+	Above Ground	30		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9596375907038 40.79073477083531)	19	4	19	13
755	-73.9579941847434	40.7991216713328	41B-PM-1014-02	41B	PM	10142018	2	Adult	Black	Black+	Above Ground	28		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9579941847434 40.7991216713328)	19	4	19	13
1193	-73.9731880656287	40.7660026186155	2H-AM-1006-01	02H	AM	10062018	1	Adult	Black	Black+	Ground Plane	FALSE		true	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9731880656287 40.7660026186155)	19	4	19	13
1887	-73.9586184232889	40.7993153832942	41A-PM-1007-02	41A	PM	10072018	2	Adult	Black	Black+	Above Ground	15		false	false	true	false	false	jumping	false	false	false	false	false	false	false	false	stared at me	POINT (-73.9586184232889 40.7993153832942)	19	4	19	13
1938	-73.9719879697272	40.7725625124591	9F-AM-1013-02	09F	AM	10132018	2	Adult	Black	Black+	Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9719879697272 40.7725625124591)	19	4	19	13
2135	-73.9596251284566	40.7916254797561	33D-AM-1017-05	33D	AM	10172018	5	Adult	Black	Black+	Above Ground	5		false	false	true	false	true		false	false	false	false	true	false	true	false		POINT (-73.9596251284566 40.7916254797561)	19	4	19	13
2206	-73.9594446018346	40.7917800352042	33D-AM-1017-06	33D	AM	10172018	6	Adult	Black	Black+	Above Ground	10		false	false	true	false	false		true	true	false	false	false	false	false	true	runs from (ran into hole in tree trunk)	POINT (-73.9594446018346 40.7917800352042)	19	4	19	13
2266	-73.9716402454355	40.7665133780672	3I-PM-1013-08	03I	PM	10132018	8	Adult	Black	Black+	Above Ground	2		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9716402454355 40.7665133780672)	19	4	19	13
2449	-73.9599911537509	40.7914452542845	33D-AM-1017-04	33D	AM	10172018	4	Adult	Black	Black+	Above Ground	5		false	false	true	false	false		false	false	false	false	true	false	false	true		POINT (-73.9599911537509 40.7914452542845)	19	4	19	13
2535	-73.9700101107283	40.7696729501144	7I-PM-1013-08	07I	PM	10132018	8	Adult	Black	Black+	Above Ground	4		false	false	true	false	false		false	false	false	false	true	false	false	false		POINT (-73.9700101107283 40.7696729501144)	19	4	19	13
593	-73.9593352806175	40.7918150568046	33E-AM-1014-02	33E	AM	10142018	2	Juvenile	Black	Black+	Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9593352806175 40.7918150568046)	19	4	19	13
1845	-73.9626560807032	40.7884633049896	28D-AM-1012-05	28D	AM	10122018	5	Juvenile	Black	Black+	Above Ground	30		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9626560807032 40.7884633049896)	19	4	19	13