squirrels

Custom SQL query returning 18 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] from [2018_Central_Park_Squirrel_Census_-_Squirrel_Data] where "Climbing" = :p0 and "Hectare Squirrel Number" = :p1 and "Highlight Fur Color" = :p2 order by Climbing 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	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long
199	-73.97716146866159	40.770967798324705	5C-AM-1006-02	05C	AM	10062018	2	Adult	Cinnamon	White	Cinnamon+White	Above Ground	10		1	0	1	1	0		0	0	0	1	0	POINT (-73.9771614686616 40.7709677983247)
359	-73.9716404781264	40.7753181851766	12D-PM-1014-02	12D	PM	10142018	2	Adult	Gray	White	Gray+White	Above Ground	15		0	0	1	0	0	seems to be grinding teeth on a piece of material (sounds from grinding)	0	0	0	1	0	POINT (-73.9716404781264 40.7753181851766)
428	-73.96362827608	40.780799459524204	21G-AM-1014-02	21G	AM	10142018	2	Adult	Gray	White	Gray+White	Above Ground	3	fence	0	0	1	0	0		0	0	0	1	0	POINT (-73.96362827608 40.7807994595242)
508	-73.97469187620759	40.765523188367794	1G-AM-1006-02	01G	AM	10062018	2	Juvenile	Gray	White	Gray+White	Above Ground	30		0	0	1	0	1		0	1	0	1	0	POINT (-73.9746918762076 40.7655231883678)
859	-73.9600964585868	40.7952339524416	36B-PM-1013-02	36B	PM	10132018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	1	0	0		0	1	1	0	1	POINT (-73.9600964585868 40.7952339524416)
1093	-73.9584106786233	40.7902777556926	32F-PM-1008-02	32F	PM	10082018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	1	1		0	0	0	1	0	POINT (-73.9584106786233 40.7902777556926)
1154	-73.9786936992465	40.771394367466606	5A-PM-1010-02	05A	PM	10102018	2	Adult	Gray	White	Gray+White	Above Ground	50		0	0	1	0	0		0	0	0	0	0	POINT (-73.9786936992465 40.7713943674666)
1252	-73.9777998932399	40.770981586533395	5B-PM-1013-02	05B	PM	10132018	2	Adult	Gray	White	Gray+White	Above Ground	5		0	0	1	0	0		0	0	0	0	0	POINT (-73.9777998932399 40.7709815865334)
1374	-73.9653739273979	40.788976209696706	28B-PM-1010-02	28B	PM	10102018	2	Adult	Gray	White	Gray+White	Above Ground	4		0	0	1	0	0		0	0	0	0	0	POINT (-73.9653739273979 40.7889762096967)
1804	-73.98077710643099	40.7681635726316	1A-AM-1007-02	01A	AM	10072018	2	Adult	Gray	White	Gray+White	Above Ground	11		0	0	1	0	0		0	1	0	1	0	POINT (-73.980777106431 40.7681635726316)
1933	-73.95848243616551	40.7934247634031	35D-PM-1013-02	35D	PM	10132018	2	Adult	Gray	White	Gray+White	Above Ground	24		0	0	1	0	0		0	0	0	1	0	POINT (-73.9584824361655 40.7934247634031)
1972	-73.9558370309765	40.7921977208472	35G-AM-1007-02	35G	AM	10072018	2	Adult	Gray	White	Gray+White	Above Ground	30		0	0	1	0	0		0	0	0	1	0	POINT (-73.9558370309765 40.7921977208472)
1984	-73.9739249209875	40.7768528386853	13B-PM-1008-02	13B	PM	10082018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	POINT (-73.9739249209875 40.7768528386853)
2216	-73.97351950184459	40.778714727971504	14A-AM-1014-02	14A	AM	10142018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	0	1		0	1	0	0	0	POINT (-73.9735195018446 40.7787147279715)
2226	-73.9624296435843	40.791320813687	31C-PM-1010-02	31C	PM	10102018	2	Adult	Gray	White	Gray+White	Above Ground	10		0	0	1	0	0		0	0	0	1	0	POINT (-73.9624296435843 40.791320813687)
2352	-73.9727310397798	40.778701677351705	15B-PM-1017-02	15B	PM	10172018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE	tree	0	0	1	1	1	digging,chewing on tree—has nut in mouth!	0	0	0	0	1	POINT (-73.97273103977982 40.7787016773517)
2394	-73.97858295460459	40.7719652299132	6A-PM-1012-02	06A	PM	10122018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	1	1	0	0		0	0	0	0	0	POINT (-73.9785829546046 40.7719652299132)
2444	-73.966590487009	40.780246905289104	19E-PM-1018-02	19E	PM	10182018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	1	0	0		1	0	0	0	0	POINT (-73.96659048700901 40.7802469052891)