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 "Hectare" = :p0 and "Tail twitches" = :p1 order by Date 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	Indifferent	Runs from	Lat/Long
268	-73.968107276769	40.7768612676036	15F-AM-1007-09	15F	AM	10072018	9	Adult	Cinnamon	White	Cinnamon+White		Above Ground	20		0	0	1	0	1		0	1	POINT (-73.968107276769 40.7768612676036)
349	-73.9689657039917	40.776783427676705	15F-AM-1007-04	15F	AM	10072018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	1		0	0	POINT (-73.9689657039917 40.7767834276767)
555	-73.9685227310735	40.776599466588	15F-AM-1007-02	15F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Above Ground	20		1	0	1	0	0		0	1	POINT (-73.9685227310735 40.776599466588)
800	-73.96821440393342	40.7773070675393	15F-AM-1007-08	15F	AM	10072018	8	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		1	0	POINT (-73.9682144039334 40.7773070675393)
1081	-73.9680855277775	40.7769251965381	15F-AM-1007-10	15F	AM	10072018	10	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	20		1	0	1	0	0		0	1	POINT (-73.9680855277775 40.7769251965381)
1843	-73.9685940262068	40.776932102013	15F-AM-1007-07	15F	AM	10072018	7	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE		0	0	0	0	1		1	0	POINT (-73.9685940262068 40.776932102013)
2365	-73.96887733063241	40.7766669852358	15F-AM-1007-05	15F	AM	10072018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	0		0	1	POINT (-73.9688773306324 40.7766669852358)
2424	-73.9684752839242	40.776581626151795	15F-AM-1007-01	15F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Ground Plane	FALSE		1	0	0	1	1		1	1	POINT (-73.9684752839242 40.7765816261518)
2637	-73.968891673893	40.776700147172896	15F-AM-1007-06	15F	AM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	pair with #5	0	1	POINT (-73.968891673893 40.7767001471729)
2789	-73.96868007849409	40.77667390291379	15F-AM-1007-03	15F	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Ground Plane	FALSE		0	0	0	0	1		1	0	POINT (-73.9686800784941 40.7766739029138)
59	-73.9684910712272	40.776881164002106	15F-PM-1010-05	15F	PM	10102018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		1	0	POINT (-73.9684910712272 40.7768811640021)
89	-73.968052057989	40.777338666528	15F-PM-1010-06	15F	PM	10102018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		1	0	POINT (-73.968052057989 40.777338666528)
237	-73.96789565689801	40.7767409597341	15F-PM-1010-07	15F	PM	10102018	7	Adult	Gray		Gray+		Above Ground	3	on fence	1	0	0	0	0		0	1	POINT (-73.967895656898 40.7767409597341)
297	-73.9685604013735	40.7773439909065	15F-PM-1010-03	15F	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		1	0	POINT (-73.9685604013735 40.7773439909065)
1156	-73.9688929282726	40.7768899536946	15F-PM-1010-01	15F	PM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		1	0	POINT (-73.9688929282726 40.7768899536946)
1718	-73.96826762377029	40.7772653590224	15F-PM-1010-04	15F	PM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE	on path	0	0	0	0	1		1	0	POINT (-73.9682676237703 40.7772653590224)
1838	-73.9686622009739	40.776729438050204	15F-PM-1010-02	15F	PM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		1	0	POINT (-73.9686622009739 40.7767294380502)