squirrels

Custom SQL query returning 7 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 "Hectare" = :p1 order by [Primary Fur Color] 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	Tail twitches	Indifferent	Runs from	Lat/Long
522	-73.97738211356109	40.769045349438294	4C-PM-1010-06	04C	PM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	behind playground benches	0	0	1	0	1	0	1	POINT (-73.9773821135611 40.7690453494383)
678	-73.977447585355	40.769716782800295	4C-PM-1010-11	04C	PM	10102018	11	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	1	0	0	0	0	POINT (-73.977447585355 40.7697167828003)
756	-73.9773079154219	40.7696506688861	4C-AM-1006-02	04C	AM	10062018	2	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		1	0	1	1	1	1	0	POINT (-73.9773079154219 40.7696506688861)
1709	-73.9771696835698	40.76970111004871	4C-AM-1006-04	04C	AM	10062018	4	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	1	1	1	0	POINT (-73.9771696835698 40.7697011100487)
1827	-73.97797608743551	40.769823093658296	4C-PM-1010-16	04C	PM	10102018	16	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	1	0	1	0	POINT (-73.9779760874355 40.7698230936583)
2221	-73.9771847728747	40.769597116498105	4C-AM-1006-01	04C	AM	10062018	1	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	1	1	1	0	POINT (-73.9771847728747 40.7695971164981)
2854	-73.9772908667333	40.7697207404744	4C-AM-1006-05	04C	AM	10062018	5	Juvenile	Gray	White	Gray+White	Above Ground	20		0	1	1	1	0	1	0	POINT (-73.9772908667333 40.7697207404744)