squirrels

Custom SQL query returning 8 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 ([Highlight Fur Color] is not null or ([Highlight Fur Color] is null and rowid > :p2)) order by [Highlight Fur Color], 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	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long
2902	-73.9673220504383	40.777029634596296	15G-PM-1019-04	15G	PM	10192018	4	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	0	1	0	0	0	0	POINT (-73.9673220504383 40.7770296345963)
2987	-73.9563724838337	40.7882504581015	31I-PM-1019-04	31I	PM	10192018	4	Adult	Gray		Gray+	Ground Plane	FALSE		1	0	0	0	0	0	0	1	0	POINT (-73.95637248383372 40.7882504581015)
1583	-73.97010303935059	40.7838953063625	21A-AM-1019-04	21A	AM	10192018	4	Juvenile	Gray	Black	Gray+Black	Ground Plane	FALSE		0	0	0	0	1	0	0	1	0	POINT (-73.9701030393506 40.7838953063625)
343	-73.9730224561601	40.7796833353894	16A-PM-1019-04	16A	PM	10192018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1	1	0	1	0	POINT (-73.9730224561601 40.7796833353894)
964	-73.9631045499811	40.790618096947206	30B-PM-1019-04	30B	PM	10192018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		1	0	1	1	1	0	0	0	1	POINT (-73.9631045499811 40.7906180969472)
1591	-73.95762233900821	40.79797466396471	40B-AM-1019-04	40B	AM	10192018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	1	0	1	0	1	1	0	POINT (-73.9576223390082 40.79797466396471)
999	-73.980948293606	40.76856888506279	2A-PM-1019-04	02A	PM	10192018	4	Juvenile	Gray	White	Gray+White	Above Ground	15	in tree!	1	0	0	0	0	0	0	1	0	POINT (-73.980948293606 40.7685688850628)
1411	-73.98028400317591	40.7678599069819	1B-PM-1019-04	01B	PM	10192018	4	Juvenile	Gray	White	Gray+White	Above Ground	25	in tree	0	1	0	0	0	0	0	0	0	POINT (-73.9802840031759 40.7678599069819)