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 "Date" = :p0 and "Location" = :p1 and "Running" = :p2 order by latitude 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	Foraging	Other Activities	Tail twitches	Indifferent	Runs from	Lat/Long
2136	-73.97218979152109	40.7660434203132	3I-AM-1010-02	03I	AM	10102018	2	Adult	Gray		Gray+	Above Ground	40		1	0	0	0		0	1	0	POINT (-73.9721897915211 40.76604342031321)
2914	-73.9722053355548	40.7662094993614	3I-AM-1010-03	03I	AM	10102018	3	Adult	Gray		Gray+	Above Ground	50		1	0	0	0		0	1	0	POINT (-73.9722053355548 40.7662094993614)
2385	-73.9787552947847	40.7690779628762	3B-AM-1010-06	03B	AM	10102018	6	Adult	Gray		Gray+	Above Ground	20		1	0	0	0		0	1	0	POINT (-73.9787552947847 40.7690779628762)
1125	-73.9775735077285	40.7692872082165	4C-PM-1010-08	04C	PM	10102018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	10	on stone arch	1	0	1	0		0	0	1	POINT (-73.9775735077285 40.7692872082165)
2640	-73.9788304714091	40.7696373635315	4B-AM-1010-06	04B	AM	10102018	6	Adult	Gray		Gray+	Above Ground	12		1	0	0	0	running from squirrel #5	0	0	0	POINT (-73.9788304714091 40.7696373635315)
110	-73.97113187902791	40.7701941550273	7G-AM-1010-02	07G	AM	10102018	2	Adult	Gray		Gray+	Above Ground	3		1	0	0	0		1	0	1	POINT (-73.9711318790279 40.7701941550273)
602	-73.96857515954851	40.7709413567859	9I-PM-1010-07	09I	PM	10102018	7	Adult	Gray	White	Gray+White	Above Ground	1	ran up tree	1	0	0	0		0	0	1	POINT (-73.9685751595485 40.7709413567859)
2259	-73.975565603566	40.7738462518304	9B-AM-1010-03	09B	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	4		1	0	1	1		0	1	0	POINT (-73.975565603566 40.7738462518304)
2744	-73.9752915601718	40.7739329570033	9B-AM-1010-04	09B	AM	10102018	4				+	Above Ground	10		1	0	1	0		0	0	0	POINT (-73.9752915601718 40.7739329570033)
256	-73.976798124308	40.774131657411296	9A-PM-1010-04	09A	PM	10102018	4		Cinnamon		Cinnamon+	Above Ground	20		1	0	1	0		0	1	0	POINT (-73.97679812430802 40.7741316574113)
237	-73.96789565689801	40.7767409597341	15F-PM-1010-07	15F	PM	10102018	7	Adult	Gray		Gray+	Above Ground	3	on fence	1	0	0	0		0	0	1	POINT (-73.967895656898 40.7767409597341)
534	-73.9650499507011	40.7908191782173	30A-AM-1010-01	30A	AM	10102018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	10		1	0	1	0		1	0	1	POINT (-73.9650499507011 40.7908191782173)
2247	-73.95595201371721	40.7950536287174	38E-AM-1010-06	38E	AM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1	branches	1	1	0	0	chasing and being chased by #7	1	1	0	POINT (-73.95595201371721 40.7950536287174)
547	-73.9559677963727	40.7951124076946	38E-AM-1010-07	38E	AM	10102018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1	branches	1	1	0	0	chasing and being chased by #6	1	0	1	POINT (-73.9559677963727 40.7951124076946)