squirrels

Custom SQL query returning 17 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 "Hectare Squirrel Number" = :p0 and "Primary Fur Color" = :p1 and "Tail twitches" = :p2 order by Moans 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	Climbing	Eating	Foraging	Other Activities	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
26	-73.9649866016038	40.776492969445705	16I-AM-1008-01	16I	AM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	0	1		0	1	0	1	0		POINT (-73.9649866016038 40.7764929694457)
27	-73.9670628558161	40.7734991420941	12I-AM-1013-01	12I	AM	10132018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	on tree roots	0	0	0	0	0	sitting	0	1	0	0	1		POINT (-73.9670628558161 40.77349914209411)
534	-73.9650499507011	40.7908191782173	30A-AM-1010-01	30A	AM	10102018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10		1	0	1	0	0		0	1	0	0	1		POINT (-73.9650499507011 40.7908191782173)
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	0	1		0	1	1	0	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	0	1	0		1	1	1	0	0		POINT (-73.9594357049738 40.7840678890949)
1939	-73.9540151828782	40.7920066170587	35H-AM-1013-01	35H	AM	10132018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15	Climbing up tree	0	0	1	0	0		0	1	0	0	1		POINT (-73.9540151828782 40.7920066170587)
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	0	1	1	1	scratching self	0	1	0	1	0		POINT (-73.9639505810228 40.789573183584)
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	0	1	0		0	1	1	0	0		POINT (-73.9749251267433 40.7679111971294)
2033	-73.9500167570283	40.7966185836685	41I-AM-1018-01	41I	AM	10182018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	1	0	0	0	cautious,observant,runs off	POINT (-73.9500167570283 40.7966185836685)
2244	-73.9509628195532	40.797777567417796	42H-PM-1014-01	42H	PM	10142018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	2		0	0	0	0	0		0	1	0	0	1		POINT (-73.9509628195532 40.7977775674178)
2278	-73.96453903109901	40.78099163100121	20G-PM-1013-01	20G	PM	10132018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	1	0	0	1		POINT (-73.964539031099 40.7809916310012)
2387	-73.98085173247209	40.7683154647217	1A-PM-1014-01	01A	PM	10142018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6		0	1	0	0	0		0	1	0	0	0		POINT (-73.9808517324721 40.7683154647217)
2696	-73.9501457233643	40.797094356558	42I-PM-1014-01	42I	PM	10142018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	0	0		0	1	0	1	0		POINT (-73.9501457233643 40.797094356558)
2757	-73.96714191194559	40.77586024868621	14G-AM-1012-01	14G	AM	10122018	1	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE		0	0	0	0	1		0	1	0	0	1		POINT (-73.9671419119456 40.7758602486862)
2900	-73.9631005470369	40.788549405719294	28D-AM-1012-01	28D	AM	10122018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	1	0	0	0		POINT (-73.9631005470369 40.7885494057193)
2989	-73.9643538221947	40.7917565604735	31A-PM-1017-01	31A	PM	10172018	1	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White	Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	1	0	0	0		POINT (-73.9643538221947 40.7917565604735)
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		0	1	1	0	0		POINT (-73.9752079247419 40.7755376979002)