squirrels

Custom SQL query returning 4 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 "Foraging" = :p0 and "Hectare Squirrel Number" = :p1 and "Highlight Fur Color" = :p2 order by Age 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	Eating	Tail twitches	Indifferent	Runs from	Lat/Long
1966	-73.97509119964991	40.772244521017896	8C-PM-1013-06	08C	PM	10132018	6		Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	1	0	1	0	POINT (-73.9750911996499 40.7722445210179)
987	-73.96498278073409	40.7817322832767	21F-AM-1018-06	21F	AM	10182018	6	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	0	1	0	1	POINT (-73.9649827807341 40.7817322832767)
780	-73.9675472064204	40.7835947167436	22C-PM-1006-06	22C	PM	10062018	6	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Above Ground	10	on tree	0	1	0	0	0	POINT (-73.9675472064204 40.7835947167436)
2725	-73.9658867660358	40.7756523577509	15H-PM-1008-06	15H	PM	10082018	6	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	base of gingko tree	0	1	0	1	0	POINT (-73.9658867660358 40.7756523577509)