squirrels

Custom SQL query returning 15 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 "Date" = :p1 and "Hectare Squirrel Number" = :p2 and "Tail twitches" = :p3 order by [Hectare Squirrel Number] 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	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
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)
593	-73.95933528061751	40.7918150568046	33E-AM-1014-02	33E	AM	10142018	2	Juvenile	Black		Black+		Above Ground	10		0	0	1	0	0		0	0	0	0	1		POINT (-73.9593352806175 40.7918150568046)
755	-73.9579941847434	40.7991216713328	41B-PM-1014-02	41B	PM	10142018	2	Adult	Black		Black+		Above Ground	28		0	0	1	0	0		0	0	0	0	0		POINT (-73.9579941847434 40.7991216713328)
767	-73.9655734633649	40.7805366922231	20F-AM-1014-02	20F	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0	pulling leaves	1	0	0	0	0		POINT (-73.9655734633649 40.7805366922231)
838	-73.96910310946879	40.77066938351889	9I-AM-1014-02	09I	AM	10142018	2	Adult	Gray		Gray+	Very far, so appx	Above Ground	35		0	0	1	0	0		0	0	0	0	0		POINT (-73.9691031094688 40.7706693835189)
1041	-73.9643236505425	40.7887854771596	28C-AM-1014-02	28C	AM	10142018	2	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		0	0	0	1	0		POINT (-73.9643236505425 40.7887854771596)
1163	-73.9677096985223	40.7825358361204	21C-AM-1014-02	21C	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	50		1	1	1	0	1		0	1	0	0	0	looked at us from tree	POINT (-73.9677096985223 40.7825358361204)
1732	-73.97671414072741	40.7737313251559	8A-PM-1014-02	08A	PM	10142018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	1	runs from (goes up a tree)	POINT (-73.9767141407274 40.7737313251559)
1807	-73.9581366214863	40.7988964092722	40B-PM-1014-02	40B	PM	10142018	2	Adult	Gray		Gray+		Above Ground	20		0	0	1	0	0		1	1	0	0	1		POINT (-73.9581366214863 40.7988964092722)
2243	-73.9579967047318	40.7948682042252	37D-PM-1014-02	37D	PM	10142018	2	Adult	Gray		Gray+		Above Ground	40		0	0	1	0	0		0	0	0	0	0		POINT (-73.95799670473181 40.7948682042252)
2639	-73.9543832609857	40.795355063970106	39F-AM-1014-02	39F	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	rocks	1	0	1	0	1		0	0	0	0	0		POINT (-73.9543832609857 40.7953550639701)
2663	-73.96134291849741	40.79121580572671	32C-AM-1014-02	32C	AM	10142018	2	Adult	Gray		Gray+		Above Ground	3		0	1	1	0	0		0	0	0	0	0		POINT (-73.9613429184974 40.7912158057267)
2762	-73.9656324462902	40.783403475308106	22E-PM-1014-02	22E	PM	10142018	2	Adult	Gray		Gray+		Above Ground	6		0	0	1	0	0		0	0	1	0	0		POINT (-73.9656324462902 40.7834034753081)
2916	-73.95175251116791	40.7974407641075	42G-PM-1014-02	42G	PM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	14		0	0	1	1	0		0	0	0	1	0		POINT (-73.9517525111679 40.7974407641075)