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] from [2018_Central_Park_Squirrel_Census_-_Squirrel_Data] where "Age" = :p0 and "Date" = :p1 and "Hectare Squirrel Number" = :p2 order by [Runs from] 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 twitches	Indifferent	Runs from	Other Interactions	Lat/Long
155	-73.9522142360388	40.7949598486683	39H-PM-1013-02	39H	PM	10132018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	0	1		1	1	0		POINT (-73.9522142360388 40.7949598486683)
374	-73.9556817958407	40.788852000621	32I-AM-1013-02	32I	AM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	15		0	0	1	0	0		0	0	0	watching me from tree - curious	POINT (-73.9556817958407 40.788852000621)
423	-73.97567542977471	40.7738518843446	9B-PM-1013-02	09B	PM	10132018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	0	1		1	1	0		POINT (-73.9756754297747 40.7738518843446)
854	-73.95771130260559	40.7904332453456	32G-PM-1013-02	32G	PM	10132018	2	Juvenile	Black		Black+	Ground Plane	FALSE		0	0	0	0	1		0	1	0		POINT (-73.9577113026056 40.7904332453456)
1103	-73.9541500874008	40.7920329989756	35H-AM-1013-02	35H	AM	10132018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Above Ground	10	Sitting on tree limb	0	0	0	0	0	sitting	0	1	0	watching me from tree,but calm	POINT (-73.9541500874008 40.7920329989756)
1782	-73.9549133872427	40.7946871036949	38F-PM-1013-02	38F	PM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	0		POINT (-73.9549133872427 40.7946871036949)
2606	-73.96143417385001	40.794546426211205	35B-PM-1013-02	35B	PM	10132018	2	Juvenile			+	Ground Plane	FALSE		0	0	0	1	0	did not notice dog sitting a few yards away (10-20 ft)	1	1	0		POINT (-73.96143417385 40.7945464262112)
2982	-73.9513477815203	40.7945259614138	39I-PM-1013-02	39I	PM	10132018	2	Juvenile	Gray		Gray+	Ground Plane	FALSE	along the road	0	1	1	0	0	playing	0	0	0		POINT (-73.9513477815203 40.7945259614138)
993	-73.97724226646571	40.773436329163	8A-AM-1013-02	08A	AM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	playground	1	0	0	0	0		0	0	1		POINT (-73.9772422664657 40.773436329163)