2018_Central_Park_Squirrel_Census_-_Squirrel_Data

441 rows where Hectare Squirrel Number = 3 sorted by Indifferent descending

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by longitude Sort by latitude Sort by Unique Squirrel ID Sort by Hectare Sort by Shift Sort by Date Sort by Hectare Squirrel Number Sort by Age Sort by Primary Fur Color Sort by Highlight Fur Color Sort by Combination of Primary and Highlight Color Sort by Color notes Sort by Location Sort by Above Ground Sighter Measurement Sort by Specific Location Sort by Running Sort by Chasing Sort by Climbing Sort by Eating Sort by Foraging Sort by Other Activities Sort by Kuks Sort by Quaas Sort by Moans Sort by Tail flags Sort by Tail twitches Sort by Approaches Sort by Indifferent Sort by Runs from Sort by Other Interactions Sort by Lat/Long

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	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
1516	1516	-73.9625383795297	40.7883862331728	28D-AM-1012-03	28D	AM	10122018	3	Adult	Black		Black+		Above Ground	30		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9625383795297 40.7883862331728)
1537	1537	-73.97672201797249	40.77532621031229	10A-PM-1014-03	10A	PM	10142018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Above Ground		above my head in tree	0	0	0	1	0	eating (in a tree)	0	0	0	0	0	0	1	0	indifferent (lots of people taking its picture,didn't bother it)	POINT (-73.9767220179725 40.7753262103123)
1542	1542	-73.960876728048	40.790357245370004	31D-PM-1006-03	31D	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.960876728048 40.79035724537)
1569	1569	-73.973047824163	40.7700873791211	7F-AM-1008-03	07F	AM	10082018	3	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.973047824163 40.7700873791211)
1586	1586	-73.9714150090362	40.7774976423922	14C-PM-1006-03	14C	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9714150090362 40.7774976423922)
1610	1610	-73.9607056611532	40.788978610387105	30E-AM-1008-03	30E	AM	10082018	3	Adult	Gray		Gray+		Above Ground	6		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9607056611532 40.7889786103871)
1611	1611	-73.9655238539833	40.7815633947684	21E-AM-1017-03	21E	AM	10172018	3	Adult	Gray		Gray+		Above Ground	7		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9655238539833 40.7815633947684)
1616	1616	-73.9642666013207	40.7810384867375	21G-PM-1007-03	21G	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.96426660132072 40.7810384867375)
1627	1627	-73.9594391759139	40.784115697669	26I-PM-1010-03	26I	PM	10102018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	black in tail	Above Ground	15	tree	0	0	1	1	1		0	0	0	0	1	0	1	0		POINT (-73.9594391759139 40.784115697669)
1664	1664	-73.97291429122029	40.772409114667795	9E-AM-1008-03	09E	AM	10082018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9729142912203 40.7724091146678)
1681	1681	-73.9638141923763	40.782922532628795	23F-PM-1013-03	23F	PM	10132018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0	indifferent (noticed me,busy eating,foraging)	POINT (-73.9638141923763 40.7829225326288)
1686	1686	-73.9593373093799	40.7982428507976	39A-PM-1014-03	39A	PM	10142018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments.	Above Ground	6	Jumped from ground onto branch	0	0	0	0	1	digging?	0	0	0	0	1	0	1	0		POINT (-73.95933730937992 40.7982428507976)
1701	1701	-73.9701634768603	40.777869143321794	15D-AM-1007-03	15D	AM	10072018	3	Adult	Gray		Gray+		Above Ground	10		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9701634768603 40.7778691433218)
1715	1715	-73.97457091090558	40.7672225695415	3G-AM-1008-03	03G	AM	10082018	3	Adult	Gray		Gray+		Above Ground	40		1	0	1	0	0	in tree	0	0	0	0	0	0	1	0		POINT (-73.9745709109056 40.7672225695415)
1747	1747	-73.96657637976071	40.7761316400012	15H-AM-1013-03	15H	AM	10132018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9665763797607 40.7761316400012)
1748	1748	-73.955710327539	40.797451079756705	40D-AM-1013-03	40D	AM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.955710327539 40.7974510797567)
1750	1750	-73.9684806250183	40.7858776210151	24A-PM-1007-03	24A	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9684806250183 40.7858776210151)
1773	1773	-73.9611126813593	40.7943113021522	35B-AM-1010-03	35B	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9611126813593 40.7943113021522)
1775	1775	-73.951965247933	40.7938167628067	38I-PM-1014-03	38I	PM	10142018	3	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	1		POINT (-73.951965247933 40.7938167628067)
1779	1779	-73.9695560376915	40.7708835103516	9H-AM-1006-03	09H	AM	10062018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.96955603769152 40.7708835103516)
1796	1796	-73.9765355395622	40.7735653237366	8B-AM-1007-03	08B	AM	10072018	3	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.97653553956222 40.7735653237366)
1819	1819	-73.9711378905748	40.7696218346333	7H-AM-1006-03	07H	AM	10062018	3	Adult	Gray		Gray+		Ground Plane	FALSE	on rock (large)	0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9711378905748 40.769621834633305)
1829	1829	-73.9746965894947	40.766435172430896	2G-AM-1010-03	02G	AM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9746965894947 40.7664351724309)
1834	1834	-73.97390388321558	40.7730354890554	9D-AM-1008-03	09D	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9739038832156 40.7730354890554)
1836	1836	-73.9751056714758	40.7732060035215	8C-PM-1013-03	08C	PM	10132018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.9751056714758 40.7732060035215)
1851	1851	-73.9623621412501	40.7814673556041	22H-PM-1007-03	22H	PM	10072018	3	Adult	Gray	White	Gray+White		Above Ground	4	chased squirrel #2 away	0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9623621412501 40.7814673556041)
1860	1860	-73.9767100101318	40.7675779951996	2E-PM-1014-03	02E	PM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9767100101318 40.7675779951996)
1863	1863	-73.96828305109541	40.7810151087286	19D-PM-1008-03	19D	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	may be same squirrel as #1 - male	Above Ground	5	on branch of dead tree	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9682830510954 40.7810151087286)
1874	1874	-73.96573273328491	40.7747554568985	14I-PM-1018-03	14I	PM	10182018	3	Juvenile	Gray	Black	Gray+Black		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9657327332849 40.7747554568985)
1876	1876	-73.973598991549	40.7783020016983	14A-PM-1014-03	14A	PM	10142018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0	chasing (#4)	0	0	0	0	0	0	1	0		POINT (-73.973598991549 40.7783020016983)
1907	1907	-73.9689227467959	40.783754160749396	21B-AM-1019-03	21B	AM	10192018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9689227467959 40.7837541607494)
1912	1912	-73.9698064901149	40.7842538115839	21A-AM-1019-03	21A	AM	10192018	3	Adult	Gray		Gray+		Ground Plane	FALSE	Tree & ground	0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9698064901149 40.78425381158391)
1937	1937	-73.9565549485301	40.7989823714955	41C-AM-1017-03	41C	AM	10172018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9565549485301 40.7989823714955)
1979	1979	-73.96127592913992	40.7930468323219	33B-AM-1010-03	33B	AM	10102018	3	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9612759291399 40.7930468323219)
1981	1981	-73.972154069981	40.769012800972206	6G-AM-1008-03	06G	AM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	grass	0	0	0	1	1		0	0	0	1	0	0	1	0		POINT (-73.972154069981 40.7690128009722)
1985	1985	-73.9530791622513	40.79598856039671	40G-PM-1013-03	40G	PM	10132018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9530791622513 40.7959885603967)
1988	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	0	0	0	1	0	1	0		POINT (-73.957138794884 40.7985389822719)
2006	2006	-73.9695641121727	40.7769562886685	14E-AM-1008-03	14E	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	walking	0	0	0	0	0	0	1	0	unaware of	POINT (-73.9695641121727 40.7769562886685)
2021	2021	-73.95828003055091	40.798947371297395	40B-PM-1014-03	40B	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9582800305509 40.7989473712974)
2041	2041	-73.9651796685091	40.7785578267586	18G-AM-1014-03	18G	AM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9651796685091 40.7785578267586)
2063	2063	-73.95447632818859	40.7969645476349	40F-PM-1006-03	40F	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9544763281886 40.7969645476349)
2065	2065	-73.9768411547701	40.7741377018895	9A-AM-1013-03	09A	AM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9768411547701 40.7741377018895)
2069	2069	-73.9538377039825	40.798060533496106	42E-PM-1012-03	42E	PM	10122018	3	Adult	Gray	White	Gray+White		Above Ground	20	in tree	0	0	1	0	1		1	0	0	0	0	0	1	0		POINT (-73.9538377039825 40.7980605334961)
2071	2071	-73.96676944398949	40.7779501809095	17G-PM-1017-03	17G	PM	10172018	3	Adult	Gray	White	Gray+White		Above Ground	10	tree & ground	1	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9667694439895 40.7779501809095)
2077	2077	-73.95627335110309	40.799314210183894	42C-PM-1013-03	42C	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE	Crossing street	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9562733511031 40.7993142101839)
2083	2083	-73.9702382274798	40.7721754848905	10G-PM-1017-03	10G	PM	10172018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9702382274798 40.7721754848905)
2091	2091	-73.96761128642859	40.7772792086081	16F-AM-1008-03	16F	AM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	road	1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9676112864286 40.7772792086081)
2096	2096	-73.97089038621759	40.778737067464206	16C-AM-1014-03	16C	AM	10142018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9708903862176 40.7787370674642)
2109	2109	-73.9744488584414	40.7741627220859	10C-PM-1013-03	10C	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9744488584414 40.7741627220859)
2117	2117	-73.9597192455543	40.7973316178661	38A-AM-1019-03	38A	AM	10192018	3	Adult	Gray	White	Gray+White	White belly	Ground Plane	FALSE		0	0	0	0	1	stood on back legs	0	0	0	0	0	1	1	1		POINT (-73.9597192455543 40.7973316178661)
2120	2120	-73.9733905460282	40.7656337147768	2H-PM-1006-03	02H	PM	10062018	3	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9733905460282 40.7656337147768)
2129	2129	-73.9701182454818	40.777280550087106	15D-PM-1017-03	15D	PM	10172018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9701182454818 40.7772805500871)
2151	2151	-73.96971787697879	40.77915441024221	17D-AM-1008-03	17D	AM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.96971787697882 40.7791544102422)
2172	2172	-73.9642900903774	40.791701716884205	31A-AM-1010-03	31A	AM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9642900903774 40.7917017168842)
2178	2178	-73.9557918001972	40.797922887804205	40D-PM-1013-03	40D	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9557918001972 40.7979228878042)
2184	2184	-73.9694938608335	40.7745700102115	12F-PM-1007-03	12F	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9694938608335 40.7745700102115)
2186	2186	-73.9561103688639	40.794914085004	37E-AM-1013-03	37E	AM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9561103688639 40.794914085004)
2191	2191	-73.9734108731087	40.767605139269705	4G-AM-1006-03	04G	AM	10062018	3		Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9734108731087 40.7676051392697)
2211	2211	-73.9799250782277	40.767610659888895	1B-AM-1012-03	01B	AM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.97992507822771 40.7676106598889)
2213	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	0	0	0	1	0	1	0		POINT (-73.9707487237344 40.7800822831001)
2238	2238	-73.95361987261741	40.798013510222795	41E-AM-1007-03	41E	AM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9536198726174 40.7980135102228)
2241	2241	-73.95752586279659	40.787715550749	30H-AM-1007-03	30H	AM	10072018	3	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9575258627966 40.787715550749)
2256	2256	-73.9720050204318	40.769941909416794	7G-AM-1010-03	07G	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9720050204318 40.7699419094168)
2259	2259	-73.975565603566	40.7738462518304	9B-AM-1010-03	09B	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		1	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.975565603566 40.7738462518304)
2268	2268	-73.9590191655172	40.7926139425111	34D-AM-1008-03	34D	AM	10082018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9590191655172 40.7926139425111)
2282	2282	-73.9722056538718	40.7805111762703	17A-PM-1013-03	17A	PM	10132018	3	Adult	Gray		Gray+		Above Ground	15	tree	0	0	0	0	0	grooming! & scratching	0	0	0	0	0	0	1	0		POINT (-73.9722056538718 40.7805111762703)
2286	2286	-73.95544156650821	40.798420141601795	41D-AM-1014-03	41D	AM	10142018	3	Adult	Gray	Black, Cinnamon	Gray+Black, Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9554415665082 40.7984201416018)
2290	2290	-73.95656457165641	40.795903994957705	38D-PM-1006-03	38D	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9565645716564 40.795903994957705)
2291	2291	-73.9756894776708	40.768163821821204	4E-AM-1020-03	04E	AM	10202018	3	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9756894776708 40.7681638218212)
2379	2379	-73.97118651343641	40.7785039981892	15C-AM-1010-03	15C	AM	10102018	3	Adult	Gray		Gray+		Above Ground	6		0	0	0	1	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9711865134364 40.7785039981892)
2396	2396	-73.9704339422613	40.77401495296439	11F-PM-1006-03	11F	PM	10062018	3	Adult	Gray		Gray+		Above Ground	4		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9704339422613 40.7740149529644)
2407	2407	-73.95557243517759	40.7967602498249	39E-AM-1018-03	39E	AM	10182018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9555724351776 40.7967602498249)
2411	2411	-73.9686907918759	40.7839462261858	22B-AM-1013-03	22B	AM	10132018	3	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9686907918759 40.7839462261858)
2412	2412	-73.98094464895641	40.768503216587895	2A-PM-1019-03	02A	PM	10192018	3	Juvenile	Gray	White	Gray+White		Above Ground	15	in tree!	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9809446489564 40.7685032165879)
2427	2427	-73.97292974853309	40.767327854143794	4H-AM-1006-03	04H	AM	10062018	3	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1	met #4 while foraging and briefly tussled	0	0	0	0	0	0	1	0		POINT (-73.9729297485331 40.7673278541438)
2452	2452	-73.9727323797981	40.766903546395504	3H-AM-1008-03	03H	AM	10082018	3	Adult	Gray		Gray+		Above Ground	40	building nest	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9727323797981 40.7669035463955)
2471	2471	-73.964274290774	40.779531955602295	19H-AM-1010-03	19H	AM	10102018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0	ran from human w/ dog	POINT (-73.964274290774 40.7795319556023)
2476	2476	-73.9710843362124	40.7679739601336	5I-AM-1010-03	05I	AM	10102018	3	Adult	Gray		Gray+		Above Ground	3		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9710843362124 40.7679739601336)
2477	2477	-73.9663297144622	40.7837932023685	22D-PM-1012-03	22D	PM	10122018	3	Adult	Gray	Black, White	Gray+Black, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9663297144622 40.7837932023685)
2480	2480	-73.9546780963388	40.790321652211105	34I-AM-1012-03	34I	AM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	0	nut in mouth	0	0	0	0	0	0	1	0		POINT (-73.9546780963388 40.7903216522111)
2485	2485	-73.9584950620879	40.790277071064295	32F-PM-1008-03	32F	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9584950620879 40.7902770710643)
2491	2491	-73.98069052596709	40.76811522108579	1A-AM-1007-03	01A	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	looking in bush	0	0	0	0	0	0	1	0		POINT (-73.9806905259671 40.7681152210858)
2493	2493	-73.954767265558	40.7973243644491	40E-PM-1017-03	40E	PM	10172018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.954767265558 40.7973243644491)
2539	2539	-73.97810334484679	40.766672406621296	1D-AM-1006-03	01D	AM	10062018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9781033448468 40.7666724066213)
2542	2542	-73.9754802138871	40.773300804411996	9C-PM-1006-03	09C	PM	10062018	3	Adult	Gray	White	Gray+White		Above Ground	15		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9754802138871 40.773300804412)
2563	2563	-73.9664536611195	40.7827694131949	21D-AM-1008-03	21D	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9664536611195 40.7827694131949)
2573	2573	-73.9810149147578	40.7683925377714	2A-AM-1010-03	02A	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	on trunk	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9810149147578 40.7683925377714)
2589	2589	-73.9694166642262	40.7697788641081	8I-PM-1013-03	08I	PM	10132018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9694166642262 40.7697788641081)
2598	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	0	0	0	1	0	1	0		POINT (-73.976658503418 40.7686868456917)
2599	2599	-73.96898934126929	40.785308737683	23A-AM-1018-03	23A	AM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8	Tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9689893412693 40.785308737683)
2630	2630	-73.965019827314	40.775986429132296	15I-AM-1008-03	15I	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.965019827314 40.7759864291323)
2631	2631	-73.9690080105286	40.7710230515054	9I-PM-1010-03	09I	PM	10102018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White					0	0	0	0	1		0	0	0	0	0	0	1	1		POINT (-73.9690080105286 40.7710230515054)
2666	2666	-73.9763593390732	40.771729705854895	7C-AM-1012-03	07C	AM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	foraging (loving the acorns!)	0	0	0	0	0	0	1	0		POINT (-73.97635933907321 40.7717297058549)
2679	2679	-73.9794481602391	40.770638572864	4A-AM-1007-03	04A	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9794481602391 40.770638572864)
2686	2686	-73.97755714038921	40.766531658519796	1E-PM-1007-03	01E	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9775571403892 40.7665316585198)
2694	2694	-73.969628583287	40.770406779793205	8H-AM-1017-03	08H	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	fence	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.969628583287 40.7704067797932)
2695	2695	-73.962800448652	40.7915532640139	31B-PM-1007-03	31B	PM	10072018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.962800448652 40.7915532640139)
2736	2736	-73.95938952535009	40.797308584408704	38B-AM-1019-03	38B	AM	10192018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9593895253501 40.7973085844087)
2747	2747	-73.971314838366	40.774951285041	12E-AM-1017-03	12E	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.971314838366 40.774951285041)
2763	2763	-73.96260656728941	40.788722645116	29D-AM-1014-03	29D	AM	10142018	3	Juvenile	Gray		Gray+		Above Ground	35	End of tree limb foraging	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9626065672894 40.788722645116)

Next page

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "Age" TEXT,
  "Primary Fur Color" TEXT,
  "Highlight Fur Color" TEXT,
  "Combination of Primary and Highlight Color" TEXT,
  "Color notes" TEXT,
  "Location" TEXT,
  "Above Ground Sighter Measurement" TEXT,
  "Specific Location" TEXT,
  "Running" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);