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 "Age" = :p0 and "Date" = :p1 and "Hectare Squirrel Number" = :p2 order by [Specific Location] 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	Quaas	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
754	-73.9563203089105	40.7906275357726	33G-PM-1006-01	33G	PM	10062018	1	Juvenile	Gray		Gray+	Above Ground	2		0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9563203089105 40.7906275357726)
1004	-73.9670850805619	40.7833747810387	22C-PM-1006-01	22C	PM	10062018	1	Juvenile	Gray		Gray+	Ground Plane	FALSE		1	1	0	0	0	for food	1	0	0	0	0	0		POINT (-73.9670850805619 40.7833747810387)
1107	-73.95307395621309	40.7932034409546	37H-PM-1006-01	37H	PM	10062018	1	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	from voice	POINT (-73.95307395621312 40.7932034409546)
1215	-73.9728895595977	40.769937833229896	6F-AM-1006-01	06F	AM	10062018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	1	0		0	0	0	1	0	0		POINT (-73.9728895595977 40.7699378332299)
1523	-73.9673103881521	40.78742674096179	26A-PM-1006-01	26A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	1	0	0	0	1		POINT (-73.9673103881521 40.7874267409618)
1549	-73.97779784978941	40.7668620784309	1D-AM-1006-01	01D	AM	10062018	1	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		1	0	1	0	1		0	0	1	0	0	0		POINT (-73.9777978497894 40.7668620784309)
1685	-73.96788229832741	40.7802960985637	18E-PM-1006-01	18E	PM	10062018	1	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0		POINT (-73.9678822983274 40.7802960985637)
2221	-73.9771847728747	40.769597116498105	4C-AM-1006-01	04C	AM	10062018	1	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	1	0		POINT (-73.9771847728747 40.7695971164981)
333	-73.9667560049684	40.7882333830729	27A-PM-1006-01	27A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground		on a tree	0	0	0	1	1	walking up & down branches	0	0	0	0	1	0		POINT (-73.9667560049684 40.7882333830729)