squirrels

Custom SQL query returning 12 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 "Hectare Squirrel Number" = :p0 and "Tail flags" = :p1 and ([Other Activities] is not null or ([Other Activities] is null and rowid > :p2)) order by [Other Activities], 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	Climbing	Eating	Foraging	Other Activities	Kuks	Quaas	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
1367	-73.9542684235907	40.7944237164092	38G-PM-1020-05	38G	PM	10202018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	1	0	0	0		0	1	1	0	0	1	0		POINT (-73.9542684235907 40.7944237164092)
1403	-73.9761632586697	40.7741085606149	9B-PM-1013-05	09B	PM	10132018	5	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0	0		0	0	1	0	0	1	0		POINT (-73.9761632586697 40.7741085606149)
1660	-73.98004994980342	40.7702181099573	4A-PM-1007-05	04A	PM	10072018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE	At rock	0	0	0	0	1		0	0	1	1	0	1	0		POINT (-73.9800499498034 40.770218109957305)
1722	-73.98025646852649	40.768175909819895	2B-AM-1010-05	02B	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	0	1	0		POINT (-73.9802564685265 40.7681759098199)
1944	-73.97432920664129	40.7756090404121	11B-AM-1007-05	11B	AM	10072018	5	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	1	0	0		POINT (-73.9743292066413 40.7756090404121)
1995	-73.9603366992925	40.7899612889539	31E-PM-1006-05	31E	PM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	1	0	0	0		0	0	1	0	0	1	0		POINT (-73.9603366992925 40.789961288953904)
2176	-73.9583201789615	40.7913938722521	33F-PM-1012-05	33F	PM	10122018	5	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Ground Plane	FALSE		1	0	0	0	1		1	0	1	1	0	0	1		POINT (-73.95832017896151 40.7913938722521)
2876	-73.95589957376541	40.7960097734603	39E-AM-1018-05	39E	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	0	1	0		POINT (-73.9558995737654 40.7960097734603)
2923	-73.9672160533827	40.7830263908749	21C-AM-1014-05	21C	AM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0		0	0	1	0	0	1	0		POINT (-73.9672160533827 40.7830263908749)
1188	-73.9669529835992	40.787186415136496	25A-AM-1013-05	25A	AM	10132018	5		Gray		Gray+	Ground Plane	FALSE	CROSS BRIDLE - INTO TREE TO AVOID DOGGO	1	0	1	0	0	d.p.t.	0	0	1	1	0	1	0	calm	POINT (-73.96695298359921 40.7871864151365)
203	-73.96387745795491	40.79135321291479	31A-AM-1010-05	31A	AM	10102018	5	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	1	1	jumping	0	0	1	1	0	1	0	eventually ran from lawnmower (tail flag)	POINT (-73.9638774579549 40.7913532129148)
1174	-73.9682067129876	40.7779911208015	16E-PM-1018-05	16E	PM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	0	staring	0	0	1	0	1	0	0	approaches (very close)	POINT (-73.9682067129876 40.7779911208015)