squirrels

Custom SQL query returning 10 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 "Eating" = :p0 and "Highlight Fur Color" = :p1 and "Indifferent" = :p2 and "Shift" = :p3 order by Moans 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	Chasing	Foraging	Other Activities	Tail flags	Indifferent	Lat/Long
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	1		1	1	POINT (-73.9764839973068 40.7691725326976)
249	-73.9786339295735	40.7684918638639	3C-PM-1008-02	03C	PM	10082018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1		0	1	POINT (-73.9786339295735 40.7684918638639)
458	-73.97357503529591	40.7694500333777	6F-PM-1008-06	06F	PM	10082018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	White patches. Almost looks like fox squirrel				0	0	0		0	1	POINT (-73.9735750352959 40.7694500333777)
715	-73.97720265726741	40.7691598773017	4D-PM-1008-14	04D	PM	10082018	14	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1		0	1	POINT (-73.9772026572674 40.7691598773017)
863	-73.97640160306659	40.7689894344251	4D-PM-1008-05	04D	PM	10082018	5	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1		0	1	POINT (-73.9764016030666 40.7689894344251)
1142	-73.9765805609072	40.7692807820935	4D-PM-1008-07	04D	PM	10082018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	hopped over fence and chased # 6 around tree & ran it to end of lawn	1	1	0		0	1	POINT (-73.9765805609072 40.7692807820935)
1384	-73.97876087620051	40.7686062296462	3C-PM-1008-01	03C	PM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	3		0	0	0	walked between trees	0	1	POINT (-73.9787608762005 40.7686062296462)
2787	-73.9765306970303	40.769495687585895	4D-PM-1008-09	04D	PM	10082018	9	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White					0	0	1		0	1	POINT (-73.9765306970303 40.7694956875859)
2837	-73.9772691210241	40.7690960712994	4D-PM-1008-13	04D	PM	10082018	13	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1		0	1	POINT (-73.9772691210241 40.7690960712994)
2952	-73.9763719445827	40.768955141333706	4D-PM-1008-04	04D	PM	10082018	4	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1		0	1	POINT (-73.9763719445827 40.7689551413337)