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 "Date" = :p0 and "Hectare Squirrel Number" = :p1 and "Shift" = :p2 order by [Tail twitches] 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	Climbing	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Approaches	Indifferent	Other Interactions	Lat/Long
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	0	1	0	1		0	1	0	0	1		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	0	1	0	0		0	0	0	0	0	looked down on me like her imperial subject	POINT (-73.9684657285532 40.7840113573723)
1695	-73.9604083891356	40.7910284106931	32D-AM-1013-05	32D	AM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		1	0	0	1	0		0	0	0	0	1		POINT (-73.9604083891356 40.7910284106931)
1705	-73.97654172820009	40.7740994735325	9A-AM-1013-05	09A	AM	10132018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	1	0	1	0		0	0	0	0	1		POINT (-73.9765417282001 40.7740994735325)
2646	-73.9772239251936	40.7731716665766	8A-AM-1013-05	08A	AM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	20		1	0	1	1	0		0	0	0	1	0		POINT (-73.9772239251936 40.7731716665766)
2693	-73.95614986460359	40.7949288561893	37E-AM-1013-05	37E	AM	10132018	5	?			+	Above Ground	10	unsure, just heard kuks	0	0	0	0	0		1	0	0	0	0		POINT (-73.9561498646036 40.79492885618931)
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	0	1	0	0	d.p.t.	0	1	1	0	1	calm	POINT (-73.96695298359921 40.7871864151365)
2202	-73.95560399976209	40.7977549157287	40D-AM-1013-05	40D	AM	10132018	5	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	1		POINT (-73.9556039997621 40.7977549157287)