squirrels

Custom SQL query returning 12 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 "Hectare Squirrel Number" = :p1 and "Running" = :p2 order by Quaas 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	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
165	-73.969058856545	40.776635622697896	14F-PM-1012-06	14F	PM	10122018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1	1		0	0	1	1	0		POINT (-73.969058856545 40.7766356226979)
344	-73.9759432151552	40.7733240612552	8B-PM-1012-06	08B	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	2	on a bench	0	0	1	1		0	0	0	1	0		POINT (-73.9759432151552 40.7733240612552)
740	-73.95834778506341	40.7914073632782	33F-PM-1012-06	33F	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	1		1	0	1	0	0		POINT (-73.9583477850634 40.7914073632782)
1166	-73.980048119915	40.7676638655026	1B-AM-1012-06	01B	AM	10122018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0		0	0	0	1	0		POINT (-73.980048119915 40.7676638655026)
1350	-73.9727698663722	40.7714335285174	8F-PM-1012-06	08F	PM	10122018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1		0	0	0	1	0		POINT (-73.9727698663722 40.7714335285174)
1805	-73.9590328527128	40.791221441757706	33E-PM-1012-06	33E	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	playing	0	0	0	0	0		POINT (-73.9590328527128 40.7912214417577)
2314	-73.9663961415789	40.7750691120996	14H-PM-1012-06	14H	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary with a note that it was "hard to tell".	Ground Plane	FALSE		0	0	1	1		0	0	1	1	0		POINT (-73.9663961415789 40.7750691120996)
2323	-73.9715921982161	40.7746153066601	11E-PM-1012-06	11E	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Above Ground	5		0	1	1	0		0	0	0	1	0		POINT (-73.9715921982161 40.7746153066601)
2591	-73.9786351029146	40.771611416400205	6A-PM-1012-06	06A	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE	elevated ground	1	0	0	1		0	1	0	1	0		POINT (-73.9786351029146 40.771611416400205)
2617	-73.9564228238736	40.7936908887644	36F-PM-1012-06	36F	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0		0	0	0	0	0		POINT (-73.9564228238736 40.7936908887644)
2742	-73.96280415779341	40.7884180156055	28D-AM-1012-06	28D	AM	10122018	6	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	5		0	0	1	0		0	0	0	0	1		POINT (-73.9628041577934 40.78841801560551)
3011	-73.96788313129359	40.7847605974975	23B-PM-1012-06	23B	PM	10122018	6	Adult	Gray		Gray+		Above Ground	30		0	0	0	0		1	0	0	0	0	scolding	POINT (-73.9678831312936 40.7847605974975)