squirrels

Custom SQL query returning 14 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 "Date" = :p0 and "Eating" = :p1 and "Indifferent" = :p2 order by Age 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	Climbing	Eating	Foraging	Quaas	Tail twitches	Approaches	Runs from	Lat/Long
2339	-73.9695117797648	40.7802675743233	18C-PM-1018-07	18C	PM	10182018	7		Gray		Gray+		Ground Plane	FALSE		0	1	1	0	0	0	0	POINT (-73.9695117797648 40.780267574323304)
258	-73.9534333425633	40.793256416332795	37H-AM-1018-03	37H	AM	10182018	3	Adult	Gray	White	Gray+White		Above Ground	10	in a tree with red berries	0	1	0	1	0	0	1	POINT (-73.9534333425633 40.7932564163328)
266	-73.97864810094991	40.7697372811949	4B-PM-1018-03	04B	PM	10182018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0	1	0	POINT (-73.9786481009499 40.7697372811949)
579	-73.9786714207307	40.769687080622894	4B-PM-1018-01	04B	PM	10182018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0	1	0	POINT (-73.9786714207307 40.7696870806229)
882	-73.9786805884996	40.769755923192704	4B-PM-1018-02	04B	PM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0	1	0	POINT (-73.9786805884996 40.7697559231927)
970	-73.97035767623	40.77140364877471	9H-PM-1018-09	09H	PM	10182018	9	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	1	0	0	0	0	POINT (-73.97035767623 40.7714036487747)
1434	-73.9760749752948	40.7703284894392	5D-PM-1018-02	05D	PM	10182018	2	Adult	Gray		Gray+		Above Ground	2	On low fence	0	1	0	0	0	0	1	POINT (-73.9760749752948 40.7703284894392)
1632	-73.9592392692535	40.796186995179795	37B-AM-1018-02	37B	AM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0	0	1	POINT (-73.9592392692535 40.7961869951798)
1725	-73.96574800660741	40.7753465489231	14I-PM-1018-04	14I	PM	10182018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	1	1	0	1	1	0	POINT (-73.9657480066074 40.7753465489231)
2188	-73.9676113345824	40.7803482448467	19E-PM-1018-03	19E	PM	10182018	3	Adult	Gray		Gray+		Ground Plane	FALSE	Baseball field #3	0	1	0	0	0	0	0	POINT (-73.9676113345824 40.7803482448467)
2756	-73.9787312025627	40.7701071405918	4B-PM-1018-04	04B	PM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0	0	0	POINT (-73.9787312025627 40.7701071405918)
1240	-73.96961191797891	40.780292611186496	18C-PM-1018-09	18C	PM	10182018	9	Juvenile	Gray		Gray+		Above Ground	5		1	1	1	0	0	0	0	POINT (-73.9696119179789 40.7802926111865)
1339	-73.96864133261721	40.7817423907284	19C-PM-1018-08	19C	PM	10182018	8	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	1	0	0	0	0	0	POINT (-73.9686413326172 40.7817423907284)
1620	-73.96356061997841	40.782206970617	22G-AM-1018-03	22G	AM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0	0	1	POINT (-73.9635606199784 40.782206970617)