squirrels

Custom SQL query returning 14 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 "Tail twitches" = :p2 order by [Other Interactions] 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	Climbing	Eating	Foraging	Other Activities	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
100	-73.9761592532482	40.774721358538706	10A-AM-1006-04	10A	AM	10062018	4	Juvenile	Gray		Gray+	Above Ground	10	tree near large rock on Bridle Path	0	0	0	0	walking on branch	1	0	0	0		POINT (-73.9761592532482 40.7747213585387)
314	-73.960601067176	40.7917243850136	32D-PM-1006-09	32D	PM	10062018	9	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Ground Plane	FALSE		0	0	1	0		1	1	0	0		POINT (-73.960601067176 40.7917243850136)
419	-73.9777328709928	40.7669087724668	1D-AM-1006-02	01D	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0		1	0	0	0		POINT (-73.9777328709928 40.7669087724668)
508	-73.97469187620759	40.765523188367794	1G-AM-1006-02	01G	AM	10062018	2	Juvenile	Gray	White	Gray+White	Above Ground	30		0	1	0	1		1	0	1	0		POINT (-73.9746918762076 40.7655231883678)
756	-73.9773079154219	40.7696506688861	4C-AM-1006-02	04C	AM	10062018	2	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		1	0	1	1		1	0	1	0		POINT (-73.9773079154219 40.7696506688861)
1043	-73.9758564394842	40.7674758942811	3E-AM-1006-05	03E	AM	10062018	5	Juvenile	Gray		Gray+	Ground Plane	FALSE		0	0	0	1		1	0	0	0		POINT (-73.9758564394842 40.7674758942811)
1345	-73.95813265542058	40.7918074743129	34E-PM-1006-02	34E	PM	10062018	2	Juvenile	Black	Gray, White	Black+Gray, White	Ground Plane	FALSE		0	0	1	0		1	0	0	1		POINT (-73.9581326554206 40.7918074743129)
1549	-73.97779784978941	40.7668620784309	1D-AM-1006-01	01D	AM	10062018	1	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		1	1	0	1		1	0	0	0		POINT (-73.9777978497894 40.7668620784309)
1709	-73.9771696835698	40.76970111004871	4C-AM-1006-04	04C	AM	10062018	4	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	1		1	0	1	0		POINT (-73.9771696835698 40.7697011100487)
2098	-73.9700779726297	40.7722086251085	10G-AM-1006-11	10G	AM	10062018	11	Juvenile	Gray		Gray+	Above Ground	2		0	1	0	0		1	0	0	0		POINT (-73.9700779726297 40.7722086251085)
2221	-73.9771847728747	40.769597116498105	4C-AM-1006-01	04C	AM	10062018	1	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	1		1	0	1	0		POINT (-73.9771847728747 40.7695971164981)
2604	-73.9605163698302	40.7914179994956	32D-PM-1006-05	32D	PM	10062018	5	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Ground Plane	FALSE		1	1	1	0		1	0	0	1		POINT (-73.9605163698302 40.7914179994956)
2935	-73.96045994773449	40.7915035010169	32D-PM-1006-06	32D	PM	10062018	6	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Ground Plane	FALSE		1	0	0	0		1	0	1	0		POINT (-73.9604599477345 40.7915035010169)
2723	-73.96064260275601	40.791726541984204	32D-PM-1006-08	32D	PM	10062018	8	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Ground Plane	FALSE		0	0	1	0		1	0	0	0	stand on two feet and watching me	POINT (-73.960642602756 40.7917265419842)