squirrels

Custom SQL query returning 6 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 latitude 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	Climbing	Eating	Foraging	Other Activities	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
2116	-73.9801562527339	40.76872673271129	2B-AM-1010-01	02B	AM	10102018	1	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		0	1	1		0	1	0		POINT (-73.9801562527339 40.7687267327113)
1406	-73.97462048022209	40.769929484073295	6E-PM-1010-01	06E	PM	10102018	1	Juvenile			+	Ground Plane	FALSE	along dirt path by cross-town car road. saw movement in a shrub/then caught sight a little fluffy tail	0	0	0		0	1	0		POINT (-73.9746204802221 40.7699294840733)
2497	-73.9622050752008	40.7886373772305	29D-PM-1010-01	29D	PM	10102018	1	Juvenile	Gray	White	Gray+White	Above Ground	10		1	1	0		0	1	0		POINT (-73.9622050752008 40.7886373772305)
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	1	0	did seem to observe me for a moment	POINT (-73.9565738895972 40.7900160952624)
1357	-73.96313500206341	40.791907210332	32B-PM-1010-01	32B	PM	10102018	1	Juvenile	Gray		Gray+	Above Ground	25	in tree	1	0	0		1	0	1		POINT (-73.9631350020634 40.791907210332)
2420	-73.95877875927509	40.7981699014259	40A-AM-1010-01	40A	AM	10102018	1	Juvenile	Gray		Gray+	Above Ground	30	bottom of great hill	1	0	0		0	0	0	climbing up a tree	POINT (-73.9587787592751 40.7981699014259)