squirrels

Custom SQL query returning 13 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 "Date" = :p1 and "Hectare Squirrel Number" = :p2 order by Approaches 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	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
447	-73.97259060164741	40.7713889729739	8F-PM-1012-05	08F	PM	10122018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0		0	0	1	0	0	0		POINT (-73.9725906016474 40.7713889729739)
571	-73.9659549963516	40.7833659689194	22D-PM-1012-05	22D	PM	10122018	5	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White				0	0	1	0		0	0	0	0	1	0		POINT (-73.9659549963516 40.7833659689194)
590	-73.97851333014259	40.77182602883379	6A-PM-1012-05	06A	PM	10122018	5	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		0	0	0	1		0	0	0	0	0	0		POINT (-73.9785133301426 40.7718260288338)
1165	-73.9689504114652	40.77667701537639	14F-PM-1012-05	14F	PM	10122018	5	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	2	on a fallen branch	1	0	1	0	sitting	0	0	0	0	0	0	looking at me	POINT (-73.9689504114652 40.7766770153764)
1292	-73.959019987128	40.791254669180496	33E-PM-1012-05	33E	PM	10122018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	0	playing	0	0	0	0	0	0		POINT (-73.959019987128 40.7912546691805)
1456	-73.97142424264959	40.774453579812295	11E-PM-1012-05	11E	PM	10122018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	1	1	foraging (foraged,ran to tree root,munched)	0	0	0	0	1	0		POINT (-73.9714242426496 40.7744535798123)
2106	-73.9801651470389	40.767769865693495	1B-AM-1012-05	01B	AM	10122018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	1	1	1		0	0	0	0	1	0		POINT (-73.9801651470389 40.7677698656935)
2155	-73.9538938706987	40.7981150065974	42E-PM-1012-05	42E	PM	10122018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	1		0	0	0	0	1	0		POINT (-73.9538938706987 40.7981150065974)
2176	-73.9583201789615	40.7913938722521	33F-PM-1012-05	33F	PM	10122018	5	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Ground Plane	FALSE		1	0	0	1		1	1	1	0	0	1		POINT (-73.95832017896151 40.7913938722521)
2306	-73.956453902485	40.7936584431012	36F-PM-1012-05	36F	PM	10122018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0		POINT (-73.956453902485 40.7936584431012)
2733	-73.9690082314914	40.7738993942891	12G-AM-1012-05	12G	AM	10122018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	0	0		1	0	0	0	0	1		POINT (-73.9690082314914 40.7738993942891)
1428	-73.9666113598566	40.775266255031205	14H-PM-1012-05	14H	PM	10122018	5	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	1	0		0	0	0	1	0	0	approaches (someone was feeding it)	POINT (-73.9666113598566 40.7752662550312)
1947	-73.97471754195459	40.769282003087795	5E-PM-1012-05	05E	PM	10122018	5	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		1	0	0	1		0	0	0	1	0	0	begging	POINT (-73.9747175419546 40.7692820030878)