squirrels

Custom SQL query returning 7 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 "Highlight Fur Color" = :p1 and "Runs from" = :p2 order by Date 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	Climbing	Eating	Foraging	Other Activities	Tail flags	Approaches	Runs from	Lat/Long
1619	-73.9744555348544	40.772849810635705	8D-PM-1007-03	08D	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray				0	0	0	1		0	0	1	POINT (-73.9744555348544 40.7728498106357)
204	-73.96795381633409	40.7837103696906	22C-AM-1013-03	22C	AM	10132018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	1	eating (mushroom)	0	0	1	POINT (-73.9679538163341 40.7837103696906)
852	-73.9609704650925	40.7938786854735	34B-AM-1013-03	34B	AM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	15		1	1	0	0	hopping	0	1	1	POINT (-73.9609704650925 40.7938786854735)
2992	-73.9746063250438	40.7687654196811	4F-PM-1013-03	04F	PM	10132018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		1	0	1	POINT (-73.9746063250438 40.7687654196811)
224	-73.9520592496349	40.797507629981105	42G-PM-1014-03	42G	PM	10142018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	4	on fence	1	0	0	0	prancing	0	0	1	POINT (-73.9520592496349 40.7975076299811)
2234	-73.9734741818047	40.766328451425	3H-PM-1014-03	03H	PM	10142018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	0	1	POINT (-73.9734741818047 40.766328451425)
2043	-73.9643223016635	40.781431908715	21F-AM-1018-03	21F	AM	10182018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	0	dead	0	0	1	POINT (-73.9643223016635 40.781431908715)