squirrels

Custom SQL query returning 11 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 "Hectare Squirrel Number" = :p0 and "Tail flags" = :p1 order by rowid 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	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Indifferent	Other Interactions	Lat/Long
133	-73.9664711607022	40.787896428768	26A-PM-1006-06	26A	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	Tree 90th left 90th & 89	0	0	1	0	0		0	1	0	0	studying us looking for food	POINT (-73.9664711607022 40.787896428768)
194	-73.9764839973068	40.7691725326976	4D-PM-1008-06	04D	PM	10082018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		0	0	0	0	1		0	1	0	1		POINT (-73.9764839973068 40.7691725326976)
1017	-73.9552035011902	40.7889851896334	32I-AM-1013-06	32I	AM	10132018	6	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	3	In and below shrub	0	0	1	0	1		0	1	0	1		POINT (-73.9552035011902 40.7889851896334)
1815	-73.96032682553171	40.7900154505092	31E-PM-1006-06	31E	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	1	0	0	0		0	1	0	1		POINT (-73.9603268255317 40.7900154505092)
1910	-73.9699876501742	40.774248267675794	12F-PM-1007-06	12F	PM	10072018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		1	1	0	0	1		0	1	0	1		POINT (-73.9699876501742 40.77424826767581)
2203	-73.97105314852979	40.7773757069445	14D-PM-1019-06	14D	PM	10192018	6	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	1	0		0	1	0	1		POINT (-73.97105314852982 40.777375706944504)
2363	-73.9690638424196	40.7713869295685	9H-AM-1006-06	09H	AM	10062018	6	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	0	1		0	1	1	1		POINT (-73.9690638424196 40.7713869295685)
2505	-73.9762974698771	40.7740076116964	9B-PM-1013-06	09B	PM	10132018	6	Adult	Cinnamon		Cinnamon+	Ground Plane	FALSE		0	0	0	0	1		0	1	0	1		POINT (-73.9762974698771 40.7740076116964)
2588	-73.95810074370941	40.795940311272204	38C-AM-1019-06	38C	AM	10192018	6	Adult	Gray		Gray+	Above Ground	23		0	0	1	0	0		1	1	0	1		POINT (-73.9581007437094 40.7959403112722)
2591	-73.9786351029146	40.771611416400205	6A-PM-1012-06	06A	PM	10122018	6	Adult	Gray	White	Gray+White	Ground Plane	FALSE	elevated ground	0	1	0	0	1		0	1	0	1		POINT (-73.9786351029146 40.771611416400205)
2980	-73.97164145863809	40.771760114722	9F-PM-1014-06	09F	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	1	0	running (from birds)	0	1	0	1		POINT (-73.9716414586381 40.771760114722)