2018_Central_Park_Squirrel_Census_-_Squirrel_Data

3,023 rows sorted by Specific Location descending

- 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
372	372	-73.9781303869038	40.7725000348875	7A-AM-1006-02	07A	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8	in tree	0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9781303869038 40.7725000348875)
385	385	-73.979316275899	40.769213472755496	3B-PM-1007-01	03B	PM	10072018	1	Adult	Gray	White	Gray+White		Above Ground		in tree	0	0	0	0	0	chased by dog	0	0	0	0	0	0	0	0		POINT (-73.979316275899 40.7692134727555)
460	460	-73.9549135206961	40.798525897229	42D-PM-1013-03	42D	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25	in tree	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9549135206961 40.798525897229)
505	505	-73.9677387336667	40.774269591199996	12H-PM-1007-02	12H	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	0	1	1	0	peanuts	0	0	0	0	0	0	1	0		POINT (-73.9677387336667 40.7742695912)
526	526	-73.9680833729772	40.774187102511505	12H-PM-1007-08	12H	PM	10072018	8				+		Above Ground	7	in tree	0	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9680833729772 40.7741871025115)
1012	1012	-73.9755569170561	40.7668006977526	2F-AM-1006-03	02F	AM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9755569170561 40.7668006977526)
1109	1109	-73.96781540330991	40.774278348448604	12H-PM-1007-01	12H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9678154033099 40.7742783484486)
1110	1110	-73.96764342569759	40.78623366244479	24A-PM-1007-04	24A	PM	10072018	4	Adult	Gray		Gray+		Above Ground	50	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9676434256976 40.7862336624448)
1227	1227	-73.9527924755398	40.79343662605329	37I-AM-1010-04	37I	AM	10102018	4	Adult	Gray		Gray+		Above Ground	50	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9527924755398 40.7934366260533)
1239	1239	-73.9725897240269	40.7691342079294	6G-AM-1008-01	06G	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	in tree	0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9725897240269 40.7691342079294)
1253	1253	-73.9527227282134	40.7935061484064	37I-AM-1010-03	37I	AM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9527227282134 40.7935061484064)
1357	1357	-73.96313500206341	40.791907210332	32B-PM-1010-01	32B	PM	10102018	1	Juvenile	Gray		Gray+		Above Ground	25	in tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9631350020634 40.791907210332)
1411	1411	-73.98028400317591	40.7678599069819	1B-PM-1019-04	01B	PM	10192018	4	Juvenile	Gray	White	Gray+White		Above Ground	25	in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9802840031759 40.7678599069819)
1420	1420	-73.9647605121306	40.780396153151706	20G-AM-1018-03	20G	AM	10182018	3	Adult	Gray		Gray+		Above Ground	12	in tree	1	0	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9647605121306 40.7803961531517)
1608	1608	-73.9545425520879	40.7956853415959	39F-PM-1006-04	39F	PM	10062018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	35	in tree	0	0	1	0	0	climbing down	0	0	0	0	0	0	0	1	ran when saw me	POINT (-73.9545425520879 40.7956853415959)
1641	1641	-73.96531352771491	40.7817434070169	21E-PM-1012-01	21E	PM	10122018	1	Adult	Gray		Gray+		Above Ground	20	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9653135277149 40.7817434070169)
1649	1649	-73.969347812694	40.7744098063421	12G-PM-1007-02	12G	PM	10072018	2		Gray		Gray+		Above Ground		in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.969347812694 40.7744098063421)
1692	1692	-73.973268329435	40.770829651707295	7E-AM-1006-05	07E	AM	10062018	5	Adult	Gray		Gray+		Above Ground	25	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.973268329435 40.7708296517073)
1727	1727	-73.96924722995651	40.7722592187215	10H-PM-1007-01	10H	PM	10072018	1	Adult	Gray	White	Gray+White	dark gray	Above Ground	15	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9692472299565 40.7722592187215)
1741	1741	-73.9736995552241	40.77227125186371	8E-PM-1008-02	08E	PM	10082018	2	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	10	in tree	1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9736995552241 40.7722712518637)
1854	1854	-73.9618076359384	40.7947808718203	35A-PM-1013-05	35A	PM	10132018	5	Adult	Gray		Gray+		Above Ground	3	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9618076359384 40.7947808718203)
1857	1857	-73.9728797531377	40.778673314868705	15B-PM-1017-01	15B	PM	10172018	1		Gray		Gray+		Above Ground	20	in tree	0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9728797531377 40.7786733148687)
1864	1864	-73.9694344956258	40.7742869276902	12G-PM-1007-01	12G	PM	10072018	1		Gray		Gray+		Above Ground	40	in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9694344956258 40.7742869276902)
1921	1921	-73.97562782402329	40.766952370137204	2F-AM-1006-02	02F	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9756278240233 40.7669523701372)
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)
2074	2074	-73.9676246014119	40.786355136088	24A-PM-1007-05	24A	PM	10072018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	45	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9676246014119 40.786355136088)
2730	2730	-73.96535757586871	40.78053399533721	20F-PM-1007-12	20F	PM	10072018	12	Adult	Gray	White	Gray+White		Above Ground	20	in tree	0	0	1	1	0		0	0	0	0	0	0	0	0		POINT (-73.9653575758687 40.7805339953372)
2865	2865	-73.98028424040159	40.767825738497706	1B-PM-1019-03	01B	PM	10192018	3	Juvenile	Gray	White	Gray+White		Above Ground	25	in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.98028424040162 40.7678257384977)
2868	2868	-73.9653873284496	40.7804699882574	20F-PM-1007-11	20F	PM	10072018	11	Adult	Gray	White	Gray+White		Above Ground	10	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9653873284496 40.7804699882574)
2893	2893	-73.97931014826541	40.7692600238491	3B-PM-1007-02	03B	PM	10072018	2	Adult	Gray		Gray+		Above Ground	10	in tree	0	0	0	0	0	chased by dog	0	0	0	0	0	0	0	0		POINT (-73.9793101482654 40.7692600238491)
828	828	-73.9545101041865	40.790382361678205	34I-PM-1010-03	34I	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE	in the playground.	1	0	0	0	1	with some nuts in the mouth	0	0	0	0	0	0	0	0		POINT (-73.9545101041865 40.7903823616782)
1097	1097	-73.9761579527932	40.7755877312075	10A-PM-1014-02	10A	PM	10142018	2	Adult	Gray	Black, Cinnamon	Gray+Black, Cinnamon		Ground Plane	FALSE	in the bushes beneath a tree	0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9761579527932 40.7755877312075)
91	91	-73.95659058682759	40.7895654068546	32H-PM-1006-01	32H	PM	10062018	1		Gray		Gray+		Above Ground		in the European Beech	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9565905868276 40.7895654068546)
2783	2783	-73.97917671562679	40.7714445258765	5A-AM-1006-02	05A	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	12	in tall shrubs near wall next to CPW	0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9791767156268 40.7714445258765)
2777	2777	-73.98108436110859	40.768790549369896	2A-PM-1019-05	02A	PM	10192018	5	?	Gray		Gray+		Above Ground	50	in tall planetree	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9810843611086 40.7687905493699)
1941	1941	-73.97047902632241	40.776227064566605	13E-AM-1017-01	13E	AM	10172018	1	Adult	Gray		Gray+		Ground Plane	FALSE	in middle of path	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9704790263224 40.7762270645666)
1770	1770	-73.97281709807791	40.770355783043705	7F-AM-1008-06	07F	AM	10082018	6	Adult	Gray		Gray+		Above Ground	28	in hole in tree	0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9728170980779 40.770355783043705)
570	570	-73.9745227769788	40.7673618284782	3F-AM-1006-09	03F	AM	10062018	9	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	in grass by light post	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9745227769788 40.76736182847821)
1802	1802	-73.9736418085696	40.7716931127716	8E-PM-1008-04	08E	PM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in grass by a grove of tall maples	0	0	0	1	1		0	0	0	0	0	0	1	0	there's a family playing soccer	POINT (-73.9736418085696 40.7716931127716)
1106	1106	-73.97029709193171	40.7696883113413	7H-PM-1006-08	07H	PM	10062018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in grass	0	0	0	0	1		0	0	0	0	1	1	0	1		POINT (-73.9702970919317 40.7696883113413)
2814	2814	-73.9551625272308	40.791193071916	34H-PM-1006-06	34H	PM	10062018	6	Adult	Gray		Gray+		Ground Plane	FALSE	in grass	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9551625272308 40.791193071916)
2873	2873	-73.955068474109	40.79117881528779	34H-PM-1006-05	34H	PM	10062018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	white tail tip	Ground Plane	FALSE	in grass	1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.955068474109 40.7911788152878)
396	396	-73.9669206605745	40.7748155701122	13H-PM-1010-03	13H	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE	in glen	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9669206605745 40.7748155701122)
487	487	-73.9666521094255	40.7842753517648	23C-PM-1014-02	23C	PM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE	in bushes, then ran across path	1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9666521094255 40.7842753517648)
1714	1714	-73.9763542780331	40.773653130362206	9B-AM-1010-02	09B	AM	10102018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	in bush	0	0	1	0	1		0	0	0	0	1	0	0	1	froze	POINT (-73.9763542780331 40.773653130362206)
2253	2253	-73.973394428186	40.7722933513053	8E-PM-1008-03	08E	PM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in between 2 trees	0	0	0	1	1		0	0	0	0	0	1	0	0	also being lured by mom & baby w/ food	POINT (-73.973394428186 40.7722933513053)
35	35	-73.97569760767071	40.775389733191794	10A-PM-1014-01	10A	PM	10142018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Gray & White selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	in b/w trees	0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9756976076707 40.7753897331918)
258	258	-73.9534333425633	40.793256416332795	37H-AM-1018-03	37H	AM	10182018	3	Adult	Gray	White	Gray+White		Above Ground	10	in a tree with red berries	0	0	0	1	0		0	1	0	0	0	0	0	1		POINT (-73.9534333425633 40.7932564163328)
1148	1148	-73.9707339200738	40.7796333355689	17C-PM-1013-03	17C	PM	10132018	3	Adult	Gray		Gray+		Above Ground	20	in a tree	0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9707339200738 40.7796333355689)
1504	1504	-73.97065861080058	40.779635744447106	17C-PM-1013-02	17C	PM	10132018	2	Adult	Gray		Gray+		Above Ground	20	in a tree	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9706586108006 40.7796357444471)
2956	2956	-73.9654741695628	40.7890427851106	28B-PM-1010-01	28B	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	10	in a tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9654741695628 40.7890427851106)
1142	1142	-73.9765805609072	40.7692807820935	4D-PM-1008-07	04D	PM	10082018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	hopped over fence and chased # 6 around tree & ran it to end of lawn	1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9765805609072 40.7692807820935)
686	686	-73.9695745672033	40.7791835122147	17D-AM-1008-06	17D	AM	10082018	6				+		Above Ground		high in tree, couldn't see it, only heard it	0	0	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9695745672033 40.7791835122147)
60	60	-73.9768674812942	40.7735232648872	8B-PM-1012-02	08B	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	hiding in bushes	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9768674812942 40.7735232648872)
1028	1028	-73.97070123456609	40.7758938984066	13E-PM-1008-03	13E	PM	10082018	3	Juvenile	Gray	White	Gray+White		Above Ground	10	hanging upside down to get a nut	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9707012345661 40.7758938984066)
2086	2086	-73.9525627119429	40.793860286746394	38I-PM-1014-02	38I	PM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	hanging out w/ Squirrel #1	0	0	0	0	0	scampering w/ squirrel #1	0	0	0	0	1	0	0	1		POINT (-73.9525627119429 40.7938602867464)
641	641	-73.97190362174459	40.7803588122409	17A-AM-1017-01	17A	AM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3	ground & tree	1	0	1	0	1		0	0	0	0	1	0	0	1		POINT (-73.9719036217446 40.7803588122409)
1738	1738	-73.967975586222	40.77356830443129	12H-PM-1007-07	12H	PM	10072018	7		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	grass field	0	0	0	0	1		0	0	0	0	0	0	0	1	humans	POINT (-73.967975586222 40.7735683044313)
1769	1769	-73.9721086069437	40.7698172190404	6G-AM-1008-06	06G	AM	10082018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	white at end of tail	Ground Plane	FALSE	grass	0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9721086069437 40.7698172190404)
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)
248	248	-73.9751729403694	40.774328412311796	10B-PM-1014-02	10B	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground		gingko tree by traffic light in front of Strawberry Fields	0	0	0	0	1		0	0	0	0	1	0	0	0	came over on tree to see me then disappeared	POINT (-73.9751729403694 40.7743284123118)
596	596	-73.9769319450348	40.7743883576247	9A-AM-1013-11	09A	AM	10132018	11	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	foot of tree	1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9769319450348 40.7743883576247)
2919	2919	-73.9768563402344	40.7744487310786	9A-AM-1013-12	09A	AM	10132018	12	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	foot of tree	1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9768563402344 40.7744487310786)
222	222	-73.97702735535249	40.7732399463626	8A-AM-1013-03	08A	AM	10132018	3	Juvenile			+		Above Ground	3	fence	1	1	1	1	0	playing tag together	0	0	0	0	0	1	0	0		POINT (-73.9770273553525 40.7732399463626)
428	428	-73.96362827608	40.780799459524204	21G-AM-1014-02	21G	AM	10142018	2	Adult	Gray	White	Gray+White		Above Ground	3	fence	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.96362827608 40.7807994595242)
1408	1408	-73.973230162241	40.768982453144396	5F-AM-1007-01	05F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	fence	1	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.973230162241 40.7689824531444)
1623	1623	-73.97701191330229	40.773294909000505	8A-AM-1013-04	08A	AM	10132018	4	Juvenile			+		Above Ground	4	fence	1	1	0	1	1	playing tag together	0	0	0	0	0	1	0	0		POINT (-73.9770119133023 40.7732949090005)
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)
640	640	-73.97855365291359	40.7716184505002	6A-PM-1012-07	06A	PM	10122018	7	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	elevated ground	0	1	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9785536529136 40.771618450500206)
2591	2591	-73.9786351029146	40.771611416400205	6A-PM-1012-06	06A	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE	elevated ground	0	1	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9786351029146 40.771611416400205)
2751	2751	-73.956289117157	40.795339399380296	38E-AM-1010-11	38E	AM	10102018	11	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of the stream	0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.956289117157 40.7953393993803)
2968	2968	-73.9587236619579	40.799185018043396	40A-AM-1010-02	40A	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of park at 108th West	1	0	1	0	0		0	0	0	1	0	0	0	1		POINT (-73.9587236619579 40.7991850180434)
2146	2146	-73.95473986848171	40.7896483795302	33I-AM-1008-01	33I	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of park @ 98th (north)	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9547398684817 40.7896483795302)
2258	2258	-73.95477850811709	40.789612183711	33I-AM-1008-02	33I	AM	10082018	2	Adult	Gray		Gray+		Above Ground	3	edge of park @ 98th	0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9547785081171 40.789612183711)
1089	1089	-73.9655955841325	40.7762063860571	15H-PM-1008-04	15H	PM	10082018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of landscape	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9655955841325 40.7762063860571)
2557	2557	-73.97124542516791	40.7674262749891	5I-PM-1008-02	05I	PM	10082018	2	Adult	Black		Black+		Ground Plane	FALSE	crossing pavement in front of arsenal	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9712454251679 40.7674262749891)
1243	1243	-73.97455562298549	40.767292104099795	3F-AM-1006-07	03F	AM	10062018	7	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	close to tall tree & light post	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9745556229855 40.7672921040998)
2289	2289	-73.97458005923929	40.767356541975005	3F-AM-1006-08	03F	AM	10062018	8	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	close to tall tree & light post	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9745800592393 40.767356541975)
2009	2009	-73.9639505810228	40.789573183584	29B-PM-1010-01	29B	PM	10102018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	4	climbing trees	0	0	1	1	1	scratching self	0	0	0	0	1	0	1	0		POINT (-73.9639505810228 40.789573183584)
2692	2692	-73.98016364007441	40.769019205592606	2A-AM-1010-09	02A	AM	10102018	9	Adult	Gray	White	Gray+White		Above Ground		climbing in bush	0	0	1	0	0	hopping & flipping around. this one was very energetic & jumping aorund	0	0	0	0	1	0	0	0	climbed a foot up a tree and watched me	POINT (-73.9801636400744 40.7690192055926)
2574	2574	-73.978199543688	40.7695660563362	4C-PM-1010-17	04C	PM	10102018	17	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	climbed up tree	1	0	1	0	1		0	0	0	0	1	0	0	1		POINT (-73.978199543688 40.7695660563362)
462	462	-73.96617859405309	40.7742569936186	13I-PM-1008-01	13I	PM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	climbed tree	1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9661785940531 40.7742569936186)
2145	2145	-73.96512504025829	40.7812884929069	20F-PM-1007-04	20F	PM	10072018	4	Juvenile	Gray	White	Gray+White	white on tail	Above Ground	20	climbed tree	0	0	1	0	1		0	0	0	0	0	0	0	0		POINT (-73.9651250402583 40.7812884929069)
2965	2965	-73.9767389132988	40.7689323691424	4D-PM-1008-10	04D	PM	10082018	10	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	6	climbed the fence & posed for a picture	0	0	1	0	1		0	0	0	0	0	1	0	0		POINT (-73.9767389132988 40.7689323691424)
951	951	-73.97179185488301	40.78029717297839	17B-PM-1012-01	17B	PM	10122018	1	Adult	Gray		Gray+		Above Ground	2	climbed a fence	1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.971791854883 40.7802971729784)
1576	1576	-73.96199851876159	40.79432777435321	34A-AM-1012-02	34A	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	10	chasing from tree to ground	1	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9619985187616 40.7943277743532)
2652	2652	-73.96205425147491	40.794373172213795	34A-AM-1012-01	34A	AM	10122018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	chasing from tree to ground	1	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9620542514749 40.7943731722138)
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)
765	765	-73.96797780019	40.784762947325795	23B-PM-1012-05	23B	PM	10122018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	chain link fence	0	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.96797780019 40.7847629473258)
2890	2890	-73.9726236083428	40.7788217771475	15B-PM-1017-03	15B	PM	10172018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	by water	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9726236083428 40.778821777147506)
382	382	-73.9735946835545	40.7724155751282	8E-PM-1008-01	08E	PM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	by tree trunk base	0	0	0	1	0		0	0	0	0	0	1	0	0	eating food being thrown at it by a mom & baby	POINT (-73.9735946835545 40.7724155751282)
658	658	-73.9704575848926	40.7693499326095	7H-PM-1006-09	07H	PM	10062018	9	Adult	Black		Black+		Ground Plane	FALSE	by tree	0	0	0	1	1		0	0	0	1	0	1	0	1		POINT (-73.9704575848926 40.7693499326095)
437	437	-73.9793952066038	40.7707837657859	4A-PM-1007-03	04A	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	by rock	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9793952066038 40.77078376578591)
690	690	-73.9767949141123	40.774454583585	9A-PM-1010-01	09A	PM	10102018	1	Adult			+		Ground Plane	FALSE	by large tree in sectioned off area	0	0	1	0	0	i think it climbed the tree when i first saw it.	0	0	0	0	0	0	1	0		POINT (-73.9767949141123 40.774454583585)
2642	2642	-73.97514547259979	40.770291361572	6D-PM-1020-06	06D	PM	10202018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE	by carousel	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9751454725998 40.770291361572006)
1332	1332	-73.97749282457809	40.7720464606979	6B-AM-1012-02	06B	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	by bike racks at Tavern on the Green	0	0	0	0	1	walking,exploring - digging in flower bed	0	0	0	0	0	0	0	1		POINT (-73.9774928245781 40.7720464606979)
1311	1311	-73.9694169352433	40.774440829385796	12G-PM-1007-03	12G	PM	10072018	3		Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	bushes	0	0	0	0	1		0	0	0	0	0	0	0	0	friendly	POINT (-73.9694169352433 40.7744408293858)
56	56	-73.97246424363941	40.7690526441109	6G-AM-1008-02	06G	AM	10082018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE	bush	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9724642436394 40.7690526441109)
1288	1288	-73.97304542959971	40.77029094543921	7F-AM-1008-05	07F	AM	10082018	5	Adult	Gray		Gray+		Ground Plane	FALSE	bush	0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9730454295997 40.7702909454392)
1788	1788	-73.9685567075413	40.7703797723105	8I-AM-1006-10	08I	AM	10062018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3	bush	0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.96855670754131 40.7703797723105)

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
);