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 "Date" = :p0 and "Highlight Fur Color" = :p1 and "Primary Fur Color" = :p2 order by Shift 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	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
199	-73.97716146866159	40.770967798324705	5C-AM-1006-02	05C	AM	10062018	2	Adult	Cinnamon	White	Cinnamon+White	Above Ground	10		1	1	1	0		0	0	0	1	0		POINT (-73.9771614686616 40.7709677983247)
405	-73.97866031471492	40.7671937837017	1D-AM-1006-09	01D	AM	10062018	9	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		1	0	0	1		0	1	0	1	0		POINT (-73.9786603147149 40.7671937837017)
1617	-73.97520295136441	40.767173466736104	3F-AM-1006-04	03F	AM	10062018	4	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE	on a rock	0	0	0	1		0	0	0	0	1		POINT (-73.9752029513644 40.7671734667361)
1650	-73.97624942397191	40.775017530671605	10A-AM-1006-01	10A	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE	near Strawberry Fields	0	0	1	0	eating (a peanut)	0	0	1	0	0		POINT (-73.9762494239719 40.7750175306716)
2044	-73.97715523261991	40.7706917595308	5C-AM-1006-01	05C	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		1	1	0	0		1	0	1	0	0		POINT (-73.9771552326199 40.7706917595308)
2344	-73.9786310308892	40.766934936818295	1D-AM-1006-05	01D	AM	10062018	5	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		0	0	1	0		0	1	0	0	0		POINT (-73.9786310308892 40.7669349368183)
2503	-73.974382557804	40.7674812627373	3F-AM-1006-10	03F	AM	10062018	10	Adult	Cinnamon	White	Cinnamon+White	Above Ground	6	on fence	0	1	0	0		0	0	0	0	0	clueless	POINT (-73.974382557804 40.7674812627373)
2539	-73.97810334484679	40.766672406621296	1D-AM-1006-03	01D	AM	10062018	3	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		0	0	0	1		0	1	0	1	0		POINT (-73.9781033448468 40.7666724066213)
2547	-73.9743393747021	40.767634679832504	3F-AM-1006-12	03F	AM	10062018	12	Juvenile	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		0	0	0	1		1	0	0	1	0		POINT (-73.9743393747021 40.7676346798325)