squirrels

Custom SQL query returning 13 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 "Foraging" = :p2 order by [Runs from] 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	Climbing	Eating	Foraging	Other Activities	Kuks	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
625	-73.9764235373322	40.770606513989	5C-PM-1010-11	05C	PM	10102018	11	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	1	0	1		0	0	0	0		POINT (-73.97642353733221 40.770606513989)
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		0	0	1	0		POINT (-73.9594120573719 40.7841945750598)
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		0	0	1	0		POINT (-73.9588809150045 40.7847231576181)
1627	-73.9594391759139	40.784115697669	26I-PM-1010-03	26I	PM	10102018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	black in tail	Above Ground	15	tree	0	1	1	1		0	1	1	0		POINT (-73.9594391759139 40.784115697669)
2009	-73.9639505810228	40.789573183584	29B-PM-1010-01	29B	PM	10102018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	4	climbing trees	0	1	1	1	scratching self	0	1	1	0		POINT (-73.9639505810228 40.789573183584)
2259	-73.975565603566	40.7738462518304	9B-AM-1010-03	09B	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		1	1	0	1		0	0	1	0		POINT (-73.975565603566 40.7738462518304)
2300	-73.9789251806378	40.7699558513225	4B-AM-1010-02	04B	AM	10102018	2	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	30		0	1	1	1		1	0	1	0		POINT (-73.9789251806378 40.7699558513225)
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		0	0	1	0	ran from human w/ dog	POINT (-73.964274290774 40.7795319556023)
2702	-73.9588339897601	40.7848084865431	26I-PM-1010-06	26I	PM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	35	tree	0	1	0	1		0	1	1	0		POINT (-73.9588339897601 40.7848084865431)
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	0	0	1		POINT (-73.9729394928432 40.7743256716496)
1714	-73.9763542780331	40.773653130362206	9B-AM-1010-02	09B	AM	10102018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	in bush	0	1	0	1		0	1	0	1	froze	POINT (-73.9763542780331 40.773653130362206)
2574	-73.978199543688	40.7695660563362	4C-PM-1010-17	04C	PM	10102018	17	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	climbed up tree	1	1	0	1		0	1	0	1		POINT (-73.978199543688 40.7695660563362)
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		0	0	1	1	runs from human w/ dog	POINT (-73.9642988690682 40.7795591281979)