squirrels

Custom SQL query returning 9 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 "Climbing" = :p0 and "Foraging" = :p1 and "Hectare Squirrel Number" = :p2 and "Shift" = :p3 order by [Unique Squirrel ID] 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	Climbing	Eating	Other Activities	Kuks	Approaches	Indifferent	Lat/Long
2223	-73.9784863123685	40.7669225020831	1D-AM-1006-08	01D	AM	10062018	8	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	45		1	0		0	0	0	POINT (-73.9784863123685 40.7669225020831)
899	-73.97927540372909	40.7679690700399	2C-AM-1010-08	02C	AM	10102018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	3	stay on side of trunk	1	0		0	0	0	POINT (-73.9792754037291 40.7679690700399)
2826	-73.9600357018376	40.790653976688105	32E-AM-1007-08	32E	AM	10072018	8	Adult	Gray		Gray+	Above Ground	65	tree top	1	0		0	0	0	POINT (-73.9600357018376 40.7906539766881)
2056	-73.9589600626433	40.7913690265064	33E-AM-1014-08	33E	AM	10142018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	5		1	0		1	0	1	POINT (-73.9589600626433 40.7913690265064)
1140	-73.9615817859213	40.7945839663845	35A-AM-1014-08	35A	AM	10142018	8	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		1	0		0	0	1	POINT (-73.9615817859213 40.79458396638451)
191	-73.9787105069657	40.7693708133873	3B-AM-1010-08	03B	AM	10102018	8	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		1	0	together w/ #7	0	0	1	POINT (-73.9787105069657 40.7693708133873)
2455	-73.9577297187155	40.799225295679	41B-AM-1010-08	41B	AM	10102018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	20		1	1		0	1	0	POINT (-73.9577297187155 40.799225295679)
1654	-73.9766342125035	40.7715437147052	6C-AM-1007-08	06C	AM	10072018	8	Adult			+	Above Ground	35		1	0	dropping acorns	0	0	0	POINT (-73.9766342125035 40.7715437147052)
1598	-73.9726828460055	40.770570769482205	7F-AM-1008-08	07F	AM	10082018	8	Adult	Gray		Gray+	Above Ground	20		1	0	playing w/ #9	0	0	1	POINT (-73.9726828460055 40.7705707694822)