squirrels

Custom SQL query returning 8 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 "Climbing" = :p0 and "Highlight Fur Color" = :p1 and "Tail flags" = :p2 order by [Other Activities] 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	Climbing	Eating	Foraging	Other Activities	Kuks	Quaas	Tail flags	Tail twitches	Indifferent	Runs from	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	1	0	0		0	0	1	0	0	0	studying us looking for food	POINT (-73.9664711607022 40.787896428768)
210	-73.97112984911321	40.76769026035429	5I-PM-1008-01	05I	PM	10082018	1	Adult	Black	Cinnamon	Black+Cinnamon	Above Ground	15	in tree by arsenal - climbing	0	1	1	0		0	0	1	0	0	0		POINT (-73.9711298491132 40.7676902603543)
916	-73.95618876244708	40.7958187455815	38E-AM-1010-04	38E	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	1	0	0		0	0	1	0	0	1	me	POINT (-73.95618876244711 40.7958187455815)
2463	-73.9653343572865	40.77752869246171	17H-PM-1007-01	17H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	4		0	1	1	0		0	0	1	0	0	1		POINT (-73.9653343572865 40.7775286924617)
2569	-73.9559663734409	40.794582826137706	37F-AM-1010-01	37F	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	4		0	1	0	0		0	0	1	0	1	0		POINT (-73.9559663734409 40.7945828261377)
2700	-73.9601988871514	40.7943473161329	35C-PM-1013-01	35C	PM	10132018	1		Gray	Cinnamon	Gray+Cinnamon	Above Ground	20		0	1	0	1		1	1	1	1	1	0		POINT (-73.9601988871514 40.7943473161329)
2968	-73.9587236619579	40.799185018043396	40A-AM-1010-02	40A	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	edge of park at 108th West	1	1	0	0		0	0	1	0	0	1		POINT (-73.9587236619579 40.7991850180434)
760	-73.97182341595571	40.7810842503715	18A-AM-1012-02	18A	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	4		0	1	1	1	burying	0	0	1	0	0	1		POINT (-73.9718234159557 40.7810842503715)