squirrels

Custom SQL query returning 17 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 "Date" = :p0 and "Indifferent" = :p1 and "Primary Fur Color" = :p2 order by [Tail twitches] 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	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Quaas	Tail twitches	Approaches	Runs from	Other Interactions	Lat/Long
552	-73.9625416200877	40.7811302397912	21H-AM-1017-02	21H	AM	10172018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	1	0	0	1	0	0		0	0	0	1		POINT (-73.9625416200877 40.78113023979121)
651	-73.9801661903932	40.7697950141751	3A-PM-1017-03	03A	PM	10172018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	0	0	0	0	1		0	0	1	0		POINT (-73.9801661903932 40.7697950141751)
677	-73.97991559660859	40.7698034314993	3A-PM-1017-08	03A	PM	10172018	8	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE	0	0	0	1	1		0	0	1	0		POINT (-73.9799155966086 40.7698034314993)
723	-73.9654397484763	40.7798863522904	19F-PM-1017-03	19F	PM	10172018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	0	0	0	1	1		0	0	1	0		POINT (-73.9654397484763 40.7798863522904)
844	-73.9642379942652	40.777479252073796	17I-PM-1017-01	17I	PM	10172018	1	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	15	0	0	1	0	0		0	0	0	0	was in a tree,so i couldn't really tell	POINT (-73.9642379942652 40.7774792520738)
1050	-73.9562642076935	40.798333876307396	41C-AM-1017-02	41C	AM	10172018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	0	0	0	0	1		0	0	1	0		POINT (-73.9562642076935 40.7983338763074)
1132	-73.9798390387307	40.7700761090896	3A-PM-1017-07	03A	PM	10172018	7	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	0	0	0	0	1		0	0	1	0		POINT (-73.9798390387307 40.7700761090896)
1276	-73.9798005188704	40.7691868791734	3A-PM-1017-01	03A	PM	10172018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	0	0	0	0	1		0	0	1	0		POINT (-73.97980051887042 40.7691868791734)
1561	-73.9642397829547	40.7918992406575	31A-PM-1017-02	31A	PM	10172018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	0	0	0	1	0		0	0	0	0		POINT (-73.96423978295472 40.7918992406575)
1712	-73.9801899519657	40.7695777009264	3A-PM-1017-02	03A	PM	10172018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	0	0	0	0	1		0	0	0	0		POINT (-73.9801899519657 40.7695777009264)
1832	-73.9693159934697	40.7831212338295	21B-PM-1017-03	21B	PM	10172018	3	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1	0	1	0	0	0		0	0	0	0		POINT (-73.9693159934697 40.7831212338295)
1916	-73.9693504617353	40.7830678709405	21B-PM-1017-02	21B	PM	10172018	2	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1	0	1	0	0	0		1	0	0	0	stood on hind legs with front legs on the chest	POINT (-73.9693504617353 40.7830678709405)
2114	-73.9651541395415	40.7798283208748	19G-PM-1017-01	19G	PM	10172018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	12	0	0	0	0	0	watching	0	0	1	0		POINT (-73.9651541395415 40.7798283208748)
2514	-73.95744422055	40.7961046528557	38D-AM-1017-04	38D	AM	10172018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	1	0	0	0	0		0	0	0	0		POINT (-73.95744422055 40.7961046528557)
2764	-73.9692660977515	40.7830532310766	21B-PM-1017-01	21B	PM	10172018	1	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	0	0	0	1	0		0	0	0	0	paused to look at me	POINT (-73.9692660977515 40.7830532310766)
461	-73.96481954331921	40.7796399955868	19G-PM-1017-03	19G	PM	10172018	3	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE	0	0	1	1	0	staring	0	1	0	0		POINT (-73.9648195433192 40.7796399955868)
2989	-73.9643538221947	40.7917565604735	31A-PM-1017-01	31A	PM	10172018	1	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White	Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	0	0	0	0	1		0	1	0	0		POINT (-73.9643538221947 40.7917565604735)