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 "Above Ground Sighter Measurement" = :p0 and "Highlight Fur Color" = :p1 order by [Hectare Squirrel Number] 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	Climbing	Eating	Foraging	Other Activities	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
782	-73.9710559113762	40.779427991420896	16C-PM-1018-01	16C	PM	10182018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3		0	1	0	0		0	0	0	disappeared up other side of tree	POINT (-73.9710559113762 40.7794279914209)
1118	-73.9719460335398	40.7810508156287	18A-AM-1012-01	18A	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	White tail	Above Ground	3	tree	1	1	0	1		1	0	1		POINT (-73.9719460335398 40.7810508156287)
776	-73.9686816795392	40.775770422666994	14F-PM-1012-02	14F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3		0	1	1	0		0	1	0		POINT (-73.9686816795392 40.775770422667)
1086	-73.9713399316534	40.77506780267571	12E-PM-1018-02	12E	PM	10182018	2	Adult	Black	Cinnamon, White	Black+Cinnamon, White	Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Above Ground	3		0	1	0	0	lounging on tree upside down	1	1	0		POINT (-73.9713399316534 40.7750678026757)
394	-73.9719888241794	40.7667681685356	4I-PM-1007-03	04I	PM	10072018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3	ran to tree	0	0	0	0	being chased	0	0	0		POINT (-73.9719888241794 40.7667681685356)
1788	-73.9685567075413	40.7703797723105	8I-AM-1006-10	08I	AM	10062018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3	bush	0	1	0	0		0	0	1		POINT (-73.96855670754131 40.7703797723105)