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 "Date" = :p0 and "Hectare Squirrel Number" = :p1 and "Indifferent" = :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	Climbing	Foraging	Tail flags	Indifferent	Lat/Long
305	-73.9750283794865	40.772410192782104	8C-PM-1013-08	08C	PM	10132018	8		Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	0	1	0	1	POINT (-73.9750283794865 40.7724101927821)
924	-73.9591695545875	40.793811636076704	35D-PM-1013-08	35D	PM	10132018	8	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	1	0	1	POINT (-73.9591695545875 40.7938116360767)
1198	-73.9762187733662	40.7739282973004	9B-PM-1013-08	09B	PM	10132018	8	Juvenile	Cinnamon	Black, White	Cinnamon+Black, White	Ground Plane	FALSE	0	1	1	1	POINT (-73.9762187733662 40.7739282973004)
1559	-73.9631648674122	40.7926529617419	32A-PM-1013-08	32A	PM	10132018	8	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	1	0	1	POINT (-73.9631648674122 40.7926529617419)
2266	-73.9716402454355	40.7665133780672	3I-PM-1013-08	03I	PM	10132018	8	Adult	Black		Black+	Above Ground	2	1	0	0	1	POINT (-73.9716402454355 40.7665133780672)