squirrels

Custom SQL query returning 13 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 (Location > :p3 or (Location = :p3 and rowid > :p2)) order by Location, rowid 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	Running	Climbing	Eating	Foraging	Other Activities	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long
1242	-73.9714512125212	40.77602752501139	13D-PM-1018-03	13D	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	1	0	1	1		0	0	0	1	0	POINT (-73.9714512125212 40.7760275250114)
1312	-73.97120343207409	40.7764415506669	13D-PM-1018-05	13D	PM	10182018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	0	0	0	1		0	1	1	1	0	POINT (-73.9712034320741 40.7764415506669)
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	0	1	0		0	0	0	0	0	POINT (-73.9686413326172 40.7817423907284)
1655	-73.96957001271599	40.7816501516863	19B-PM-1018-04	19B	PM	10182018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	0	0	0	1		0	0	0	0	0	POINT (-73.969570012716 40.7816501516863)
1895	-73.954699659637	40.7951308856929	38F-AM-1018-02	38F	AM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	1	0	0	0		0	0	0	1	0	POINT (-73.954699659637 40.7951308856929)
1898	-73.9721263050502	40.7698763846186	7G-PM-1018-01	07G	PM	10182018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	0	0	1	0		0	0	0	1	0	POINT (-73.9721263050502 40.7698763846186)
2048	-73.96276614653759	40.7819356810575	22G-PM-1018-02	22G	PM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	0	0	1	1		0	0	0	1	0	POINT (-73.9627661465376 40.7819356810575)
2082	-73.9696802053043	40.781605740612505	19B-PM-1018-03	19B	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	0	0	0	1		0	0	0	0	0	POINT (-73.9696802053043 40.7816057406125)
2201	-73.9717135461165	40.7761780680083	13D-PM-1018-01	13D	PM	10182018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	0	0	0	1		0	1	0	1	0	POINT (-73.9717135461165 40.776178068008306)
2294	-73.96308205774409	40.7821632293136	22G-PM-1018-01	22G	PM	10182018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	1	0	1	0		1	0	0	1	0	POINT (-73.9630820577441 40.7821632293136)
2301	-73.968906907671	40.781627826784295	19C-PM-1018-07	19C	PM	10182018	7	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	1	1	0	0		0	0	0	0	0	POINT (-73.968906907671 40.7816278267843)
2510	-73.9748635473782	40.7742591029151	10C-AM-1018-02	10C	AM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	0	0	1	0	sitting in the sun	0	0	0	1	0	POINT (-73.9748635473782 40.7742591029151)
2687	-73.9550235589287	40.7951312356844	38F-AM-1018-03	38F	AM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	1	0	0	0		0	0	0	0	1	POINT (-73.9550235589287 40.7951312356844)