squirrels

Custom SQL query returning 18 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 "Age" = :p0 and "Eating" = :p1 and "Highlight Fur Color" = :p2 order by latitude 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
2783	-73.97917671562679	40.7714445258765	5A-AM-1006-02	05A	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	12	in tall shrubs near wall next to CPW	0	0	1	1	0		0	0	0	1	0		POINT (-73.9791767156268 40.7714445258765)
1025	-73.9763506612375	40.771611393182	7C-PM-1020-05	07C	PM	10202018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0		POINT (-73.9763506612375 40.771611393182)
2254	-73.9709991016317	40.7725756707748	10F-PM-1019-03	10F	PM	10192018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head	Ground Plane	FALSE	Behind fence, grass	0	0	0	1	0	eating (nuts)	0	0	1	0	0	approaches (bad tourists w/ nuts)	POINT (-73.9709991016317 40.772575670774806)
2845	-73.9765016413674	40.77406728629529	9A-AM-1013-06	09A	AM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	0		0	0	0	1	0		POINT (-73.9765016413674 40.7740672862953)
1705	-73.97654172820009	40.7740994735325	9A-AM-1013-05	09A	AM	10132018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	0		0	0	0	1	0		POINT (-73.9765417282001 40.7740994735325)
654	-73.976769659152	40.7741908010484	9A-AM-1013-04	09A	AM	10132018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0		POINT (-73.976769659152 40.7741908010484)
1777	-73.9711751356843	40.775242275820204	12E-AM-1017-06	12E	AM	10172018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		0	0	0	1	1		0	0	0	1	0		POINT (-73.9711751356843 40.7752422758202)
2324	-73.9737247632185	40.7759469280872	12C-PM-1017-01	12C	PM	10172018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0	digging/burying,drinking from lake	0	1	0	1	0		POINT (-73.9737247632185 40.7759469280872)
57	-73.9690175838534	40.77604327200171	14F-AM-1007-05	14F	AM	10072018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9690175838534 40.7760432720017)
2121	-73.9693462354257	40.776444438545205	14E-PM-1017-01	14E	PM	10172018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0		POINT (-73.9693462354257 40.7764444385452)
635	-73.96732355553209	40.7786749596774	17F-PM-1020-04	17F	PM	10202018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground			0	0	0	1	0		0	0	0	0	0		POINT (-73.9673235555321 40.7786749596774)
1021	-73.97186968288	40.778926988884	15B-AM-1014-03	15B	AM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1	running (from a dog)	0	0	0	1	0		POINT (-73.97186968288 40.778926988884)
1963	-73.96515918613991	40.781183828857	20F-PM-1007-06	20F	PM	10072018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9651591861399 40.781183828857)
1620	-73.96356061997841	40.782206970617	22G-AM-1018-03	22G	AM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1		POINT (-73.9635606199784 40.782206970617)
2867	-73.969370141813	40.7840721191988	22A-PM-1017-03	22A	PM	10172018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0		POINT (-73.969370141813 40.7840721191988)
333	-73.9667560049684	40.7882333830729	27A-PM-1006-01	27A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		on a tree	0	0	0	1	1	walking up & down branches	0	0	0	1	0		POINT (-73.9667560049684 40.7882333830729)
23	-73.9638179439747	40.7924173263904	32A-PM-1013-03	32A	PM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9638179439747 40.7924173263904)
2134	-73.9614373639552	40.7945051962914	35B-PM-1013-01	35B	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	did not notice dog sitting a few yards away (10-20 ft)	1	0	0	1	0		POINT (-73.9614373639552 40.7945051962914)