squirrels

Custom SQL query returning 5 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 Hectare 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	Running	Foraging	Other Activities	Tail twitches	Runs from	Other Interactions	Lat/Long
493	-73.97768547979159	40.768310229566296	3D-AM-1006-04	03D	AM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	1	0		0	1	runs from (boy on bike)	POINT (-73.9776854797916 40.7683102295663)
968	-73.9689781843873	40.7709333833783	9I-PM-1010-04	09I	PM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	0	1		0	1		POINT (-73.9689781843873 40.7709333833783)
2971	-73.9639801411692	40.7778921302618	18I-PM-1007-04	18I	PM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	0	0	walking sitting up	0	1		POINT (-73.9639801411692 40.7778921302618)
2218	-73.9694382427984	40.7846350692923	22A-AM-1008-04	22A	AM	10082018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	0	1		1	1		POINT (-73.9694382427984 40.7846350692923)
2060	-73.9575798004084	40.795701403548996	38D-PM-1006-04	38D	PM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	1	0		0	1	near drive -runners -cyclists	POINT (-73.95757980040841 40.795701403549)