squirrels

Custom SQL query returning 10 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 "Approaches" = :p0 and "Primary Fur Color" = :p1 and "Tail twitches" = :p2 order by Climbing 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	Chasing	Eating	Foraging	Other Activities	Tail flags	Tail twitches	Approaches	Runs from	Lat/Long
79	-73.9610705592868	40.7914829661051	32D-AM-1013-06	32D	AM	10132018	6	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	1	1	eating (a mushroom),circles around us,really fat,scratching himself,grooming activity	0	1	1	0	POINT (-73.9610705592868 40.7914829661051)
298	-73.957342596188	40.7944359654227	37E-PM-1006-09	37E	PM	10062018	9	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	moseying	0	1	1	0	POINT (-73.957342596188 40.7944359654227)
982	-73.9676424599715	40.777776610680704	16F-AM-1008-01	16F	AM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	near fence	0	0	0	1		0	1	1	0	POINT (-73.9676424599715 40.7777766106807)
1138	-73.9594357049738	40.7840678890949	25I-AM-1012-01	25I	AM	10122018	1	Adult	Cinnamon		Cinnamon+		Above Ground	4	on bar	0	0	1	0		1	1	1	0	POINT (-73.9594357049738 40.7840678890949)
1294	-73.9604089940153	40.7910028063138	32D-AM-1013-04	32D	AM	10132018	4	Adult	Cinnamon		Cinnamon+	Brown legs	Ground Plane	FALSE		1	0	0	0		0	1	1	1	POINT (-73.9604089940153 40.7910028063138)
1725	-73.96574800660741	40.7753465489231	14I-PM-1018-04	14I	PM	10182018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	1		0	1	1	0	POINT (-73.9657480066074 40.7753465489231)
1808	-73.9698870647042	40.7826510985538	20B-AM-1007-02	20B	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1		1	1	1	0	POINT (-73.9698870647042 40.7826510985538)
2030	-73.9749251267433	40.7679111971294	4F-PM-1013-01	04F	PM	10132018	1	Adult	Cinnamon	Gray, Black	Cinnamon+Gray, Black		Ground Plane	FALSE		0	0	1	0		0	1	1	0	POINT (-73.9749251267433 40.7679111971294)
2205	-73.9594986107981	40.7840083040604	25I-AM-1012-03	25I	AM	10122018	3	Adult	Cinnamon		Cinnamon+		Above Ground	8	on turn, see map	1	1	1	0		0	1	1	0	POINT (-73.9594986107981 40.7840083040604)
2998	-73.97520792474191	40.775537697900205	11B-AM-1007-01	11B	AM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0		0	1	1	0	POINT (-73.9752079247419 40.7755376979002)