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 "Approaches" = :p0 and "Hectare Squirrel Number" = :p1 and "Running" = :p2 and ([Color notes] is not null or ([Color notes] is null and rowid > :p3)) order by [Color notes], 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	Specific Location	Climbing	Eating	Foraging	Other Activities	Tail twitches	Approaches	Indifferent	Other Interactions	Lat/Long
2312	-73.97658670292259	40.7674304266107	2E-PM-1014-01	02E	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1		1	1	0		POINT (-73.9765867029226 40.7674304266107)
2333	-73.9771924901559	40.766672272947105	1E-PM-1007-01	01E	PM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1		0	1	0	people feeding squirrel	POINT (-73.9771924901559 40.7666722729471)
2536	-73.96850872880721	40.7779068128051	16E-AM-1014-01	16E	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	burying food	0	1	0		POINT (-73.9685087288072 40.7779068128051)
2610	-73.9713379914423	40.7696367609606	7H-PM-1006-01	07H	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	middle of grass	0	1	1		1	1	0		POINT (-73.9713379914423 40.7696367609606)
2636	-73.9700264128414	40.7692014637698	7I-PM-1013-01	07I	PM	10132018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	Bench	0	1	0		0	1	0		POINT (-73.9700264128414 40.7692014637698)
2922	-73.97034213914421	40.7773706575356	14D-AM-1014-01	14D	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1		0	1	0		POINT (-73.9703421391442 40.7773706575356)
2942	-73.9672063784809	40.7826070395665	21D-PM-1008-01	21D	PM	10082018	1		Gray		Gray+		Above Ground	8		1	0	0		0	1	0		POINT (-73.9672063784809 40.7826070395665)
3023	-73.97547941915529	40.7696404489025	5E-PM-1012-01	05E	PM	10122018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	1	1		0	1	0		POINT (-73.9754794191553 40.7696404489025)
478	-73.954482814186	40.7987031768001	42D-PM-1013-01	42D	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Drawing included.	Ground Plane	FALSE		0	0	1	watching passers-by	0	1	1		POINT (-73.954482814186 40.7987031768001)