squirrels

Custom SQL query returning 8 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 "Age" = :p0 and "Date" = :p1 and "Highlight Fur Color" = :p2 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	Location	Above Ground Sighter Measurement	Specific Location	Running	Climbing	Eating	Foraging	Other Activities	Tail flags	Tail twitches	Indifferent	Runs from	Lat/Long
169	-73.97487064155841	40.7744174965072	10B-AM-1006-02	10B	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground		High in a tree	0	1	0	0		0	0	1	0	POINT (-73.9748706415584 40.7744174965072)
333	-73.9667560049684	40.7882333830729	27A-PM-1006-01	27A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground		on a tree	0	0	1	1	walking up & down branches	0	0	1	0	POINT (-73.9667560049684 40.7882333830729)
419	-73.9777328709928	40.7669087724668	1D-AM-1006-02	01D	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0		0	1	0	0	POINT (-73.9777328709928 40.7669087724668)
1523	-73.9673103881521	40.78742674096179	26A-PM-1006-01	26A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		1	0	0	1	POINT (-73.9673103881521 40.7874267409618)
2223	-73.9784863123685	40.7669225020831	1D-AM-1006-08	01D	AM	10062018	8	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	45		0	1	0	0		0	0	0	0	POINT (-73.9784863123685 40.7669225020831)
2368	-73.9731925179247	40.7748962746181	11D-PM-1006-02	11D	PM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	20		0	1	0	0		0	0	1	0	POINT (-73.9731925179247 40.7748962746181)
2425	-73.9791141532217	40.7714888835416	5A-AM-1006-04	05A	AM	10062018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		1	0	1	0	POINT (-73.9791141532217 40.77148888354161)
2783	-73.97917671562679	40.7714445258765	5A-AM-1006-02	05A	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	12	in tall shrubs near wall next to CPW	0	1	1	0		0	0	1	0	POINT (-73.9791767156268 40.7714445258765)