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 "Date" = :p1 and "Highlight Fur Color" = :p2 order by [Specific Location] 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	Indifferent	Runs from	Other Interactions	Lat/Long
116	-73.9572093760529	40.798848730021604	41B-AM-1010-06	41B	AM	10102018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	6		0	1	0	0		0	0		POINT (-73.9572093760529 40.7988487300216)
768	-73.9729394928432	40.774325671649606	11D-AM-1010-01	11D	AM	10102018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	1	1		0	1		POINT (-73.9729394928432 40.7743256716496)
1331	-73.9588809150045	40.7847231576181	26I-PM-1010-01	26I	PM	10102018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	4		0	1	0	1		1	0		POINT (-73.9588809150045 40.7847231576181)
2471	-73.964274290774	40.779531955602295	19H-AM-1010-03	19H	AM	10102018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	1	1		1	0	ran from human w/ dog	POINT (-73.964274290774 40.7795319556023)
2474	-73.97214488797658	40.7762112840981	13C-AM-1010-02	13C	AM	10102018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	7		0	1	0	0	burying	1	0		POINT (-73.9721448879766 40.7762112840981)
2607	-73.9642988690682	40.779559128197896	19H-AM-1010-04	19H	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	1	1		1	1	runs from human w/ dog	POINT (-73.9642988690682 40.7795591281979)
1125	-73.9775735077285	40.7692872082165	4C-PM-1010-08	04C	PM	10102018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	10	on stone arch	1	1	0	0		0	1		POINT (-73.9775735077285 40.7692872082165)
908	-73.9594120573719	40.78419457505979	26I-PM-1010-05	26I	PM	10102018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	10	tree	0	1	0	1		1	0		POINT (-73.9594120573719 40.7841945750598)