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 [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	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
565	-73.9615402629655	40.7924082330328	33C-AM-1012-02	33C	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon along back & tail	Above Ground	20	tree branches	0	1	1	0	0		0	0	0	1	0		POINT (-73.9615402629655 40.7924082330328)
657	-73.9679008849677	40.7759013923034	14G-AM-1012-02	14G	AM	10122018	2		Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	1	0	0		0	0	0	1	0		POINT (-73.9679008849677 40.7759013923034)
760	-73.97182341595571	40.7810842503715	18A-AM-1012-02	18A	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	1	1	1	burying	0	1	0	0	1		POINT (-73.9718234159557 40.7810842503715)
776	-73.9686816795392	40.775770422666994	14F-PM-1012-02	14F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3		0	0	1	1	0		0	0	0	1	0		POINT (-73.9686816795392 40.775770422667)
1064	-73.9540257319561	40.798408619116	42E-PM-1012-02	42E	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon					1	0	1	0	0		0	0	0	1	1		POINT (-73.9540257319561 40.798408619116)
1444	-73.9763852372393	40.768876248561	4D-AM-1012-02	04D	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	1	0		0	0	0	1	0		POINT (-73.9763852372393 40.768876248561)
1576	-73.96199851876159	40.79432777435321	34A-AM-1012-02	34A	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	10	chasing from tree to ground	1	1	1	0	0		0	0	0	1	0		POINT (-73.9619985187616 40.7943277743532)
1625	-73.9736873018042	40.76491066771379	1I-PM-1012-02	01I	PM	10122018	2	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments.	Above Ground	1	tree	0	0	1	0	0		1	0	0	0	1		POINT (-73.9736873018042 40.7649106677138)
1697	-73.9568610943394	40.7935959584643	36E-PM-1012-02	36E	PM	10122018	2	Adult	Gray		Gray+		Above Ground	28	on tree branch	0	0	1	0	1	picking acorns off oak tree	0	0	0	1	0		POINT (-73.95686109433942 40.7935959584643)
2394	-73.97858295460459	40.7719652299132	6A-PM-1012-02	06A	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	1	0	0		0	0	0	0	0		POINT (-73.9785829546046 40.7719652299132)
2818	-73.9681664642028	40.77246696819579	11I-PM-1012-02	11I	PM	10122018	2	Adult	Gray		Gray+		Above Ground	4		1	0	1	0	1		0	0	0	0	1	runs away from the ball	POINT (-73.9681664642028 40.7724669681958)
2511	-73.95845615374209	40.791121116475395	33F-PM-1012-02	33F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	1	0	0		POINT (-73.9584561537421 40.7911211164754)
2898	-73.97941182346509	40.767449554056896	1C-AM-1012-02	01C	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	1	0	0		0	0	1	0	1		POINT (-73.9794118234651 40.7674495540569)