squirrels

Custom SQL query returning 8 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 Age 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	Kuks	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
1188	-73.9669529835992	40.787186415136496	25A-AM-1013-05	25A	AM	10132018	5		Gray		Gray+	Ground Plane	FALSE	CROSS BRIDLE - INTO TREE TO AVOID DOGGO	1	1	0	0	d.p.t.	0	1	1	0	1	0	calm	POINT (-73.96695298359921 40.7871864151365)
261	-73.9552861155228	40.788973931872	32I-AM-1013-05	32I	AM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	3	In and below shrub	0	1	0	1		0	1	0	0	1	0		POINT (-73.9552861155228 40.788973931872)
1467	-73.9684657285532	40.7840113573723	22B-AM-1013-05	22B	AM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground		tree	0	1	0	0		0	0	0	0	0	0	looked down on me like her imperial subject	POINT (-73.9684657285532 40.7840113573723)
1587	-73.9805517765469	40.7683044693163	2B-PM-1013-05	02B	PM	10132018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	1	0	0	climbing fence!	0	0	0	0	0	0	snuck into bike cart!	POINT (-73.9805517765469 40.7683044693163)
1594	-73.9778730762957	40.770827251547	5B-PM-1013-05	05B	PM	10132018	5	Adult	Gray		Gray+	Above Ground	3		1	1	0	0		0	0	0	0	0	1		POINT (-73.9778730762957 40.770827251547)
1854	-73.9618076359384	40.7947808718203	35A-PM-1013-05	35A	PM	10132018	5	Adult	Gray		Gray+	Above Ground	3	in tree	0	1	0	0		0	0	0	0	0	0		POINT (-73.9618076359384 40.7947808718203)
2646	-73.9772239251936	40.7731716665766	8A-AM-1013-05	08A	AM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	20		1	1	1	0		0	0	0	1	0	0		POINT (-73.9772239251936 40.7731716665766)
2820	-73.9615926031253	40.7944223235385	35B-PM-1013-05	35B	PM	10132018	5	Adult	Gray		Gray+	Ground Plane	FALSE		1	1	0	0	chased by dog #2	1	0	0	0	0	1	runs from (dog)	POINT (-73.96159260312531 40.7944223235385)