squirrels

Custom SQL query returning 7 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 "Eating" = :p1 and "Hectare Squirrel Number" = :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	Running	Chasing	Eating	Foraging	Other Activities	Tail flags	Tail twitches	Approaches	Indifferent	Lat/Long
2941	-73.96902666603171	40.7853134751509	23A-AM-1018-01	23A	AM	10182018	1	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE	0	0	1	0		0	0	0	1	POINT (-73.9690266660317 40.7853134751509)
82	-73.96882712024009	40.7809719445309	19C-PM-1018-01	19C	PM	10182018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	1	1	1	0		0	1	0	1	POINT (-73.9688271202401 40.7809719445309)
488	-73.9615751148595	40.795455123814605	36A-AM-1018-01	36A	AM	10182018	1	Juvenile	Gray	White	Gray+White		Above Ground	15	0	0	1	0	eating (red berries)	0	0	0	1	POINT (-73.9615751148595 40.7954551238146)
579	-73.9786714207307	40.769687080622894	4B-PM-1018-01	04B	PM	10182018	1	Adult	Gray		Gray+		Ground Plane	FALSE	0	0	1	0		0	0	1	0	POINT (-73.9786714207307 40.7696870806229)
1898	-73.9721263050502	40.7698763846186	7G-PM-1018-01	07G	PM	10182018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	0	0	1	0		0	0	0	1	POINT (-73.9721263050502 40.7698763846186)
2125	-73.9687933229572	40.7788600242549	17E-PM-1018-01	17E	PM	10182018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	0	0	1	1		0	0	0	1	POINT (-73.9687933229572 40.7788600242549)
2294	-73.96308205774409	40.7821632293136	22G-PM-1018-01	22G	PM	10182018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	1	0	1	0		1	0	0	1	POINT (-73.9630820577441 40.7821632293136)