squirrels

Custom SQL query returning 10 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 "Hectare Squirrel Number" = :p1 and ([Unique Squirrel ID] > :p3 or ([Unique Squirrel ID] = :p3 and rowid > :p2)) order by [Unique Squirrel ID], 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	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Indifferent	Runs from	Lat/Long
2742	-73.96280415779341	40.7884180156055	28D-AM-1012-06	28D	AM	10122018	6	Juvenile	Cinnamon	White	Cinnamon+White	Above Ground	5		0	0	1	0		0	0	0	0	1	POINT (-73.9628041577934 40.78841801560551)
907	-73.95806099213101	40.7907158878729	32F-AM-1012-06	32F	AM	10122018	6	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	POINT (-73.958060992131 40.7907158878729)
1805	-73.9590328527128	40.791221441757706	33E-PM-1012-06	33E	PM	10122018	6	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	0	playing	0	0	0	0	0	POINT (-73.9590328527128 40.7912214417577)
740	-73.95834778506341	40.7914073632782	33F-PM-1012-06	33F	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	1	1		1	0	1	0	0	POINT (-73.9583477850634 40.7914073632782)
2617	-73.9564228238736	40.7936908887644	36F-PM-1012-06	36F	PM	10122018	6	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	0		0	0	0	0	0	POINT (-73.9564228238736 40.7936908887644)
87	-73.95414534658171	40.798216222376396	42E-PM-1012-06	42E	PM	10122018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		1	0	0	1		0	0	0	0	1	POINT (-73.9541453465817 40.79821622237641)
1871	-73.9748367344424	40.7693513000034	5E-PM-1012-06	05E	PM	10122018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	10	oak tree at end of ramp from Chess House	1	0	0	0		0	0	0	0	1	POINT (-73.9748367344424 40.7693513000034)
2591	-73.9786351029146	40.771611416400205	6A-PM-1012-06	06A	PM	10122018	6	Adult	Gray	White	Gray+White	Ground Plane	FALSE	elevated ground	0	1	0	1		0	1	0	1	0	POINT (-73.9786351029146 40.771611416400205)
344	-73.9759432151552	40.7733240612552	8B-PM-1012-06	08B	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	2	on a bench	0	0	1	1		0	0	0	1	0	POINT (-73.9759432151552 40.7733240612552)
1350	-73.9727698663722	40.7714335285174	8F-PM-1012-06	08F	PM	10122018	6	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	1		0	0	0	1	0	POINT (-73.9727698663722 40.7714335285174)