squirrels

Custom SQL query returning 11 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 "Chasing" = :p0 and "Hectare Squirrel Number" = :p1 and "Tail twitches" = :p2 order by Indifferent 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	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long
53	-73.95849706432129	40.7982886348696	40B-AM-1019-03	40B	AM	10192018	3	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		1	1	0	0	0		0	1	1	0	0	POINT (-73.9584970643213 40.7982886348696)
335	-73.97823514358521	40.7715896672335	6A-AM-1006-03	06A	AM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	30	tree	0	1	0	1	0		1	1	0	0	0	POINT (-73.9782351435852 40.7715896672335)
356	-73.97610364001441	40.77054826845939	6D-PM-1020-03	06D	PM	10202018	3	Juvenile	Gray		Gray+	Ground Plane	FALSE		0	1	0	0	0		0	1	0	0	1	POINT (-73.9761036400144 40.7705482684594)
361	-73.96148244372509	40.7912929799884	32C-PM-1013-03	32C	PM	10132018	3	Adult	Gray		Gray+	Ground Plane	FALSE		0	1	0	0	0		0	1	0	0	0	POINT (-73.9614824437251 40.7912929799884)
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		0	1	0	0	1	POINT (-73.9600165785486 40.7952466761832)
2205	-73.9594986107981	40.7840083040604	25I-AM-1012-03	25I	AM	10122018	3	Adult	Cinnamon		Cinnamon+	Above Ground	8	on turn, see map	1	1	0	1	0		0	1	1	0	0	POINT (-73.9594986107981 40.7840083040604)
2328	-73.9678620840741	40.784719027304	23B-PM-1012-03	23B	PM	10122018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	1	0	0	1	2/3 were chasing each other	0	1	0	0	1	POINT (-73.96786208407411 40.784719027304)
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	0	1	1		0	1	0	1	0	POINT (-73.9593244415072 40.794964729747)
1988	-73.957138794884	40.7985389822719	40C-AM-1017-03	40C	AM	10172018	3	Adult	Gray	White	Gray+White				1	1	1	0	0	chasing (#4),digging	0	1	0	1	0	POINT (-73.957138794884 40.7985389822719)
2213	-73.9707487237344	40.7800822831001	17B-PM-1012-03	17B	PM	10122018	3	Adult	Gray	White	Gray+White	Above Ground	10		1	1	0	0	0	2/3 chasing each other	0	1	0	1	0	POINT (-73.9707487237344 40.7800822831001)
2598	-73.976658503418	40.768686845691704	4D-AM-1012-03	04D	AM	10122018	3	Adult	Gray		Gray+	Ground Plane	FALSE		0	1	1	0	0		0	1	0	1	0	POINT (-73.976658503418 40.7686868456917)