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 "Date" = :p0 and "Hectare Squirrel Number" = :p1 and "Tail twitches" = :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	Eating	Foraging	Tail flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
361	-73.96148244372509	40.7912929799884	32C-PM-1013-03	32C	PM	10132018	3	Adult	Gray		Gray+	Ground Plane	FALSE		0	1	0	0	0	1	0	0		POINT (-73.9614824437251 40.7912929799884)
432	-73.9757787135906	40.7737231427345	9B-PM-1013-03	09B	PM	10132018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1	0	1	1	0		POINT (-73.9757787135906 40.7737231427345)
628	-73.96001657854859	40.795246676183204	36B-PM-1013-03	36B	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	1	0	0	0	1	0	1		POINT (-73.9600165785486 40.7952466761832)
748	-73.9756603846107	40.7672531319384	3F-PM-1013-03	03F	PM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1	0	1	1	0		POINT (-73.9756603846107 40.7672531319384)
1058	-73.97371007431829	40.7708360121735	7E-PM-1013-03	07E	PM	10132018	3	Adult	Gray		Gray+	Ground Plane	FALSE	Ground & Tree Base	0	0	0	1	1	1	1	0		POINT (-73.9737100743183 40.7708360121735)
1167	-73.9593244415072	40.794964729747	36C-PM-1013-03	36C	PM	10132018	3	Adult	Gray		Gray+	Ground Plane	FALSE	Clearing near bike path (bikes active)	0	1	1	1	0	1	1	0		POINT (-73.9593244415072 40.794964729747)
1553	-73.9690645326017	40.7773822116124	15E-AM-1013-03	15E	AM	10132018	3	Adult	Gray		Gray+	Above Ground	2	on fallen log	0	0	0	0	0	1	0	1		POINT (-73.9690645326017 40.7773822116124)
1681	-73.9638141923763	40.782922532628795	23F-PM-1013-03	23F	PM	10132018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	1	1	0	1	1	0	indifferent (noticed me,busy eating,foraging)	POINT (-73.9638141923763 40.7829225326288)
2109	-73.9744488584414	40.7741627220859	10C-PM-1013-03	10C	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	1	0	1	1	0		POINT (-73.9744488584414 40.7741627220859)