squirrels

Custom SQL query returning 9 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 Squirrel Number" = :p1 and "Runs from" = :p2 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	Other Activities	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
1361	-73.961934398055	40.79247895485221	33B-PM-1010-07	33B	PM	10102018	7	Adult			+	Ground Plane	FALSE		0	0	1	0		0	0	1		POINT (-73.961934398055 40.7924789548522)
2879	-73.9744080700098	40.773151572182606	9C-PM-1006-07	09C	PM	10062018	7	Adult	Black	Cinnamon, White	Black+Cinnamon, White	Ground Plane	FALSE	on top of tarped sand pile	0	0	1	0		0	0	1	(me)	POINT (-73.9744080700098 40.7731515721826)
980	-73.9709817796369	40.7773554311586	14D-PM-1019-07	14D	PM	10192018	7	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	1	0		0	0	1		POINT (-73.9709817796369 40.7773554311586)
1080	-73.96902119353459	40.773038298158	11H-AM-1010-07	11H	AM	10102018	7	Adult	Gray	White	Gray+White	Above Ground	4		0	0	1	0		0	0	1		POINT (-73.9690211935346 40.773038298158)
1231	-73.9555583724966	40.7932879745739	36F-PM-1012-07	36F	PM	10122018	7	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	0		0	0	1		POINT (-73.9555583724966 40.7932879745739)
1442	-73.961241953418	40.7941677113011	35B-PM-1013-07	35B	PM	10132018	7	Adult	Gray		Gray+	Ground Plane	FALSE		1	1	1	0	got fed twice by grandpa,grabbed from grass and ate in tree	1	1	1	approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up.	POINT (-73.961241953418 40.7941677113011)
1814	-73.97223594012421	40.7702891474555	7G-AM-1010-07	07G	AM	10102018	7	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	0		0	0	1		POINT (-73.9722359401242 40.7702891474555)
2100	-73.9638312025305	40.7903826659569	30B-AM-1007-07	30B	AM	10072018	7	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	1	1		0	0	1		POINT (-73.9638312025305 40.7903826659569)
2825	-73.96435075880079	40.790432469329204	30B-PM-1019-07	30B	PM	10192018	7	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Ground Plane	FALSE		0	0	1	1		0	0	1		POINT (-73.96435075880082 40.7904324693292)