squirrels

Custom SQL query returning 18 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 "Eating" = :p1 and "Hectare Squirrel Number" = :p2 order by Date 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	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
585	-73.9700148248402	40.778778019335796	16D-PM-1010-04	16D	PM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9700148248402 40.7787780193358)
619	-73.9769887473852	40.7707561532949	5C-PM-1010-04	05C	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	1	0		POINT (-73.97698874738522 40.7707561532949)
692	-73.9594529310985	40.7840492606552	26I-PM-1010-04	26I	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	0		POINT (-73.95945293109851 40.7840492606552)
1282	-73.974451175321	40.770129463526395	6E-PM-1010-04	06E	PM	10102018	4	Adult	Cinnamon	White	Cinnamon+White	white back legs	Ground Plane	FALSE	small open area but w/ 7 large oak trees	0	1	0	1	0	chasing #3	0	0	0	1	0		POINT (-73.974451175321 40.7701294635264)
1436	-73.97667795856859	40.7669673778105	2E-AM-1010-04	02E	AM	10102018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		1	0	0	1	0		POINT (-73.9766779585686 40.7669673778105)
1468	-73.96405889194459	40.790044098464	29B-PM-1010-04	29B	PM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0		POINT (-73.9640588919446 40.790044098464)
1492	-73.9807078515193	40.768333529264204	2A-AM-1010-04	02A	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	1	0	1	0		POINT (-73.9807078515193 40.7683335292642)
1597	-73.9789401448556	40.76973731414979	4B-AM-1010-04	04B	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	0		POINT (-73.9789401448556 40.7697373141498)
1881	-73.9674984567017	40.7745938268705	13H-PM-1010-04	13H	PM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9674984567017 40.7745938268705)
2062	-73.9618173092433	40.7925800181543	33B-PM-1010-04	33B	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9618173092433 40.7925800181543)
2219	-73.9709242364673	40.7684217215595	5I-AM-1010-04	05I	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	1	0	1	0		POINT (-73.9709242364673 40.7684217215595)
2343	-73.9719194877439	40.774800096290896	11D-AM-1010-04	11D	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	1	0	0	0		POINT (-73.9719194877439 40.7748000962909)
2533	-73.9766195697096	40.766190726154704	1F-AM-1010-04	01F	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9766195697096 40.7661907261547)
2575	-73.97357533521291	40.7687061447032	5G-PM-1010-04	05G	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	1	0	0		POINT (-73.9735753352129 40.7687061447032)
2587	-73.97899712868441	40.7707024146365	5A-PM-1010-04	05A	PM	10102018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	1		0	1	0	0	0		POINT (-73.9789971286844 40.7707024146365)
2607	-73.9642988690682	40.779559128197896	19H-AM-1010-04	19H	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	1	1	runs from human w/ dog	POINT (-73.9642988690682 40.7795591281979)
2614	-73.9765877920583	40.7660946071574	1F-AM-1010-04	01F	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9765877920583 40.7660946071574)
2781	-73.9752673884392	40.7662642413761	2G-AM-1010-04	02G	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9752673884392 40.7662642413761)