squirrels

Custom SQL query returning 14 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 "Hectare Squirrel Number" = :p1 and "Highlight Fur Color" = :p2 order by [Primary Fur Color] 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	Eating	Foraging	Other Activities	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
333	-73.9667560049684	40.7882333830729	27A-PM-1006-01	27A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		on a tree	0	1	1	walking up & down branches	0	0	0	1	0		POINT (-73.9667560049684 40.7882333830729)
622	-73.97548367967059	40.7738879545412	9B-PM-1013-01	09B	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	playing	0	1	0	1	0		POINT (-73.9754836796706 40.7738879545412)
884	-73.96789372898371	40.7782808361645	16E-PM-1018-01	16E	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0		0	1	0	1	0		POINT (-73.9678937289837 40.7782808361645)
1111	-73.96327993398721	40.7808316436308	21H-PM-1018-01	21H	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	staring	0	1	1	0	0		POINT (-73.9632799339872 40.7808316436308)
1189	-73.95776297445391	40.7897460758298	32G-PM-1013-01	32G	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon belly	Ground Plane	FALSE		0	0	1		0	0	0	1	0	allowed me to approach within 10 ft	POINT (-73.9577629744539 40.789746075829804)
1431	-73.9601918930677	40.7944134683406	35C-AM-1007-01	35C	AM	10072018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	(white oak)	0	0	0	sitting still	0	0	0	0	0		POINT (-73.9601918930677 40.7944134683406)
1523	-73.9673103881521	40.78742674096179	26A-PM-1006-01	26A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1		1	0	0	0	1		POINT (-73.9673103881521 40.7874267409618)
1980	-73.9686635017966	40.78431767328279	22B-PM-1014-01	22B	PM	10142018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1		0	0	0	0	0		POINT (-73.96866350179661 40.7843176732828)
2121	-73.9693462354257	40.776444438545205	14E-PM-1017-01	14E	PM	10172018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	1		0	0	0	1	0		POINT (-73.9693462354257 40.7764444385452)
2134	-73.9614373639552	40.7945051962914	35B-PM-1013-01	35B	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	did not notice dog sitting a few yards away (10-20 ft)	1	0	0	1	0		POINT (-73.9614373639552 40.7945051962914)
2207	-73.9748943397482	40.770399256427204	6E-AM-1014-01	06E	AM	10142018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1		0	0	0	0	0		POINT (-73.9748943397482 40.7703992564272)
2324	-73.9737247632185	40.7759469280872	12C-PM-1017-01	12C	PM	10172018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	digging/burying,drinking from lake	0	1	0	1	0		POINT (-73.9737247632185 40.7759469280872)
2386	-73.95657388959721	40.7900160952624	32H-AM-1010-01	32H	AM	10102018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	not sure; walking-stop-walking-stop	0	0	0	1	0	did seem to observe me for a moment	POINT (-73.9565738895972 40.7900160952624)
2522	-73.9658747245917	40.77540337375321	14I-PM-1018-01	14I	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		Fallen branch	1	0	1		0	1	0	0	1		POINT (-73.9658747245917 40.7754033737532)