2018_Central_Park_Squirrel_Census_-_Squirrel_Data

168 rows where Hectare Squirrel Number = 2, Running = 0, Runs from = 0 and Shift = "PM"

- 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

- 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

- 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

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

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent

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
40	40	-73.9535410657077	40.7928711760061	36H-PM-1008-02	36H	PM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9535410657077 40.79287117600611)
46	46	-73.9673253417305	40.7749505252981	13H-PM-1010-02	13H	PM	10102018	2	Adult	Gray		Gray+		Above Ground	5	tree	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9673253417305 40.7749505252981)
119	119	-73.9592038887673	40.796382675378	38B-PM-1018-02	38B	PM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1	burying nut	0	0	0	0	0	0	0	0		POINT (-73.9592038887673 40.796382675378)
155	155	-73.9522142360388	40.7949598486683	39H-PM-1013-02	39H	PM	10132018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9522142360388 40.7949598486683)
156	156	-73.9576589997493	40.7972751877447	39C-PM-1006-02	39C	PM	10062018	2	Adult	Gray		Gray+		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0	unaware of	POINT (-73.95765899974931 40.7972751877447)
158	158	-73.9710991123992	40.77238897266471	9F-PM-1014-02	09F	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9710991123992 40.7723889726647)
167	167	-73.95976427784271	40.7976368003915	39A-PM-1014-02	39A	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9597642778427 40.7976368003915)
192	192	-73.9651654887991	40.7777806006951	17H-PM-1007-02	17H	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9651654887991 40.7777806006951)
246	246	-73.9779805668091	40.768093156679704	2D-PM-1012-02	02D	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9779805668091 40.7680931566797)
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)
249	249	-73.9786339295735	40.7684918638639	3C-PM-1008-02	03C	PM	10082018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9786339295735 40.7684918638639)
253	253	-73.95896270565609	40.7847591558491	26I-PM-1010-02	26I	PM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	hiding food	0	0	0	0	1	0	1	0		POINT (-73.9589627056561 40.7847591558491)
267	267	-73.97547422950909	40.769699832724704	5E-PM-1012-02	05E	PM	10122018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9754742295091 40.7696998327247)
328	328	-73.96523572796708	40.781929688714705	21E-PM-1012-02	21E	PM	10122018	2	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9652357279671 40.7819296887147)
359	359	-73.9716404781264	40.7753181851766	12D-PM-1014-02	12D	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground	15		0	0	1	0	0	seems to be grinding teeth on a piece of material (sounds from grinding)	0	0	0	0	0	0	1	0		POINT (-73.9716404781264 40.7753181851766)
362	362	-73.9571407991577	40.793191739640605	35E-PM-1006-02	35E	PM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0	begging for food	POINT (-73.9571407991577 40.7931917396406)
367	367	-73.9704862864304	40.773958311167604	11F-PM-1006-02	11F	PM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9704862864304 40.7739583111676)
368	368	-73.970315671921	40.77209053954721	10G-PM-1017-02	10G	PM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.970315671921 40.7720905395472)
423	423	-73.97567542977471	40.7738518843446	9B-PM-1013-02	09B	PM	10132018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9756754297747 40.7738518843446)
453	453	-73.959514034869	40.789911786416	31E-PM-1006-02	31E	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	under bushes	0	0	0	1	1		0	1	0	0	0	0	1	0		POINT (-73.959514034869 40.789911786416)
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)
515	515	-73.9601486483164	40.7943724108626	35C-PM-1013-02	35C	PM	10132018	2		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0	approaches (when i crouched down)	POINT (-73.9601486483164 40.7943724108626)
519	519	-73.96590102384171	40.7791683666215	18G-PM-1013-02	18G	PM	10132018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9659010238417 40.779168366621505)
600	600	-73.9808202088503	40.7682921842325	1A-PM-1014-02	01A	PM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9808202088503 40.7682921842325)
638	638	-73.9562765288004	40.78806179638679	31I-PM-1019-02	31I	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9562765288004 40.7880617963868)
639	639	-73.9558589529608	40.789240039494096	32H-PM-1006-02	32H	PM	10062018	2		Gray		Gray+		Above Ground	8		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9558589529608 40.7892400394941)
655	655	-73.9728783802067	40.7731671049246	9E-PM-1014-02	09E	PM	10142018	2	Juvenile	Gray	Black, Cinnamon	Gray+Black, Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9728783802067 40.7731671049246)
679	679	-73.955018489069	40.7971235333699	40E-PM-1017-02	40E	PM	10172018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.955018489069 40.7971235333699)
721	721	-73.97182620344691	40.76667717974421	4I-PM-1007-02	04I	PM	10072018	2	Adult	Black		Black+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9718262034469 40.7666771797442)
742	742	-73.9767016963397	40.7674012784541	2E-PM-1014-02	02E	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9767016963397 40.7674012784541)
744	744	-73.97456876537909	40.7776396926997	13A-PM-1014-02	13A	PM	10142018	2	Adult	Gray		Gray+		Above Ground	45		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9745687653791 40.7776396926997)
755	755	-73.9579941847434	40.7991216713328	41B-PM-1014-02	41B	PM	10142018	2	Adult	Black		Black+		Above Ground	28		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9579941847434 40.7991216713328)
776	776	-73.9686816795392	40.775770422666994	14F-PM-1012-02	14F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9686816795392 40.775770422667)
815	815	-73.9753283783695	40.7733043910649	8C-PM-1013-02	08C	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9753283783695 40.7733043910649)
826	826	-73.95572635334891	40.7939505791448	37F-PM-1014-02	37F	PM	10142018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	LAWN	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.95572635334891 40.7939505791448)
831	831	-73.9587712679442	40.7944502501428	36D-PM-1007-02	36D	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	1	0		POINT (-73.9587712679442 40.7944502501428)
854	854	-73.95771130260559	40.7904332453456	32G-PM-1013-02	32G	PM	10132018	2	Juvenile	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9577113026056 40.7904332453456)
857	857	-73.9714243547433	40.7713973982359	8G-PM-1017-02	08G	PM	10172018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9714243547433 40.7713973982359)
871	871	-73.9583738783348	40.7979302775527	39B-PM-1014-02	39B	PM	10142018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9583738783348 40.7979302775527)
876	876	-73.96727895735371	40.7874778720268	26A-PM-1006-02	26A	PM	10062018	2	Juvenile	Gray		Gray+	injured	Ground Plane	FALSE		0	0	0	0	0	not moving	0	0	0	0	0	0	0	0		POINT (-73.96727895735371 40.7874778720268)
880	880	-73.95656845779891	40.79360039404129	36F-PM-1012-02	36F	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9565684577989 40.7936003940413)
882	882	-73.9786805884996	40.769755923192704	4B-PM-1018-02	04B	PM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9786805884996 40.7697559231927)
934	934	-73.9772053786965	40.766390657333204	1E-PM-1007-02	01E	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9772053786965 40.7663906573332)
938	938	-73.96994511963959	40.7710409982701	9H-PM-1018-02	09H	PM	10182018	2	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.9699451196396 40.7710409982701)
939	939	-73.97614477914841	40.7690147873986	4D-PM-1008-02	04D	PM	10082018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9761447791484 40.7690147873986)
1067	1067	-73.9695305996721	40.774538689695895	12F-PM-1007-02	12F	PM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9695305996721 40.7745386896959)
1085	1085	-73.9722265046794	40.7700916895929	7G-PM-1018-02	07G	PM	10182018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9722265046794 40.7700916895929)
1086	1086	-73.9713399316534	40.77506780267571	12E-PM-1018-02	12E	PM	10182018	2	Adult	Black	Cinnamon, White	Black+Cinnamon, White	Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Above Ground	3		0	0	1	0	0	lounging on tree upside down	0	0	0	0	1	0	1	0		POINT (-73.9713399316534 40.7750678026757)
1093	1093	-73.9584106786233	40.7902777556926	32F-PM-1008-02	32F	PM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9584106786233 40.7902777556926)
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)
1154	1154	-73.9786936992465	40.771394367466606	5A-PM-1010-02	05A	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9786936992465 40.7713943674666)
1168	1168	-73.9779874405715	40.7730765377366	7A-PM-1007-02	07A	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9779874405715 40.7730765377366)
1187	1187	-73.97933344163779	40.7674142089209	1C-PM-1013-02	01C	PM	10132018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	0	0	0	0	0		POINT (-73.9793334416378 40.7674142089209)
1218	1218	-73.953375642605	40.7947144477885	38G-PM-1020-02	38G	PM	10202018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.953375642605 40.7947144477885)
1238	1238	-73.97736921314409	40.767977115014894	3D-PM-1010-02	03D	PM	10102018	2	Adult	Gray		Gray+		Above Ground	8		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9773692131441 40.7679771150149)
1252	1252	-73.9777998932399	40.770981586533395	5B-PM-1013-02	05B	PM	10132018	2	Adult	Gray	White	Gray+White		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9777998932399 40.7709815865334)
1263	1263	-73.9770873939997	40.771037966210606	6C-PM-1020-02	06C	PM	10202018	2	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9770873939997 40.7710379662106)
1265	1265	-73.96035971176191	40.7824399298414	23I-PM-1019-02	23I	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9603597117619 40.7824399298414)
1267	1267	-73.9701010964667	40.768891931450796	6I-PM-1013-02	06I	PM	10132018	2	Adult	Black		Black+		Ground Plane	FALSE	Bushes	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9701010964667 40.76889193145081)
1333	1333	-73.9754527701832	40.7656088463928	1G-PM-1010-02	01G	PM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	0	0	0	laying on tree branch	0	0	0	1	1	0	0	0		POINT (-73.9754527701832 40.7656088463928)
1372	1372	-73.95283537022091	40.7976456178263	41F-PM-1019-02	41F	PM	10192018	2				+					0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9528353702209 40.7976456178263)
1374	1374	-73.9653739273979	40.788976209696706	28B-PM-1010-02	28B	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9653739273979 40.7889762096967)
1377	1377	-73.9752263564287	40.772084917017004	7C-PM-1020-02	07C	PM	10202018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9752263564287 40.772084917017)
1385	1385	-73.9615649773504	40.7954761311501	36A-PM-1013-02	36A	PM	10132018	2		Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9615649773504 40.7954761311501)
1396	1396	-73.9704677007779	40.7786860108302	16C-PM-1018-02	16C	PM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6		0	1	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9704677007779 40.7786860108302)
1409	1409	-73.95815446824221	40.7958081306449	37C-PM-1013-02	37C	PM	10132018	2	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.9581544682422 40.7958081306449)
1415	1415	-73.9678561384348	40.77828773978221	16E-PM-1018-02	16E	PM	10182018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	0	0	gets distance from people but then continues to chase #1	POINT (-73.9678561384348 40.7782877397822)
1422	1422	-73.9537356145842	40.7917273773486	35I-PM-1006-02	35I	PM	10062018	2	Adult	Gray		Gray+		Above Ground	6		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9537356145842 40.7917273773486)
1437	1437	-73.97212798086831	40.7661158663901	3I-PM-1013-02	03I	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9721279808683 40.7661158663901)
1480	1480	-73.96285255338309	40.793844934501706	34A-PM-1013-02	34A	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	1	1	eating upside down on tree trunk	0	0	0	0	0	0	0	0		POINT (-73.9628525533831 40.7938449345017)
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)
1525	1525	-73.97271159154221	40.7782929320632	14B-PM-1014-02	14B	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9727115915422 40.7782929320632)
1531	1531	-73.9630381400083	40.7807571827321	21H-PM-1018-02	21H	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9630381400083 40.7807571827321)
1536	1536	-73.9746128451271	40.770095704670894	6E-PM-1010-02	06E	PM	10102018	2	Adult	Cinnamon	White	Cinnamon+White	white back legs	Ground Plane	FALSE	small open area but w/ 7 large oak trees	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9746128451271 40.7700957046709)
1552	1552	-73.9695655231393	40.769832465951296	8I-PM-1013-02	08I	PM	10132018	2	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.9695655231393 40.7698324659513)
1561	1561	-73.9642397829547	40.7918992406575	31A-PM-1017-02	31A	PM	10172018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.96423978295472 40.7918992406575)
1564	1564	-73.9703816112358	40.777384606591895	15D-PM-1017-02	15D	PM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9703816112358 40.7773846065919)
1589	1589	-73.9567062023419	40.797482865196	40C-PM-1006-02	40C	PM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9567062023419 40.797482865196)
1601	1601	-73.9544278270221	40.7987827316512	42D-PM-1013-02	42D	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Gray tail, Cinnamon feet	Ground Plane	FALSE		0	1	0	0	1	chasing (chased by #1),found a nut,buried it	0	0	0	0	0	0	1	0		POINT (-73.9544278270221 40.7987827316512)
1618	1618	-73.9755836827968	40.7670239327996	2F-PM-1014-02	02F	PM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9755836827968 40.7670239327996)
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)
1668	1668	-73.97469348106671	40.7659431884158	2G-PM-1007-02	02G	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	burying nut	0	0	0	0	1	0	1	0		POINT (-73.9746934810667 40.7659431884158)
1673	1673	-73.9746940851342	40.7760966488186	11B-PM-1014-02	11B	PM	10142018	2	Juvenile	Gray		Gray+		Above Ground	10		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9746940851342 40.7760966488186)
1677	1677	-73.9594332600733	40.7960622445291	37B-PM-1013-02	37B	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9594332600733 40.7960622445291)
1691	1691	-73.9703705008688	40.7818586173755	19B-PM-1018-02	19B	PM	10182018	2	Adult	Gray	Black, Cinnamon	Gray+Black, Cinnamon	Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9703705008688 40.7818586173755)
1697	1697	-73.9568610943394	40.7935959584643	36E-PM-1012-02	36E	PM	10122018	2	Adult	Gray		Gray+		Above Ground	28	on tree branch	0	0	1	0	1	picking acorns off oak tree	0	0	0	0	0	0	1	0		POINT (-73.95686109433942 40.7935959584643)
1702	1702	-73.9752699507508	40.7688069184057	4E-PM-1008-02	04E	PM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9752699507508 40.76880691840571)
1712	1712	-73.9801899519657	40.7695777009264	3A-PM-1017-02	03A	PM	10172018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9801899519657 40.7695777009264)
1720	1720	-73.9725844658514	40.7701092834201	7F-PM-1012-02	07F	PM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0	observes	POINT (-73.9725844658514 40.7701092834201)
1778	1778	-73.96855981061279	40.7807054868066	19D-PM-1008-02	19D	PM	10082018	2				+	unknown - cannot see, only hear	Above Ground			0	0	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9685598106128 40.7807054868066)
1782	1782	-73.9549133872427	40.7946871036949	38F-PM-1013-02	38F	PM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9549133872427 40.7946871036949)
1785	1785	-73.9550627447399	40.7910104700332	34H-PM-1006-02	34H	PM	10062018	2		Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9550627447399 40.7910104700332)
1806	1806	-73.9657504643585	40.783121081359205	22D-PM-1012-02	22D	PM	10122018	2	Adult	Gray	Black, White	Gray+Black, White	No Primary Fur Color selected. Made executive adjustment based on other squirrels.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9657504643585 40.7831210813592)
1838	1838	-73.9686622009739	40.776729438050204	15F-PM-1010-02	15F	PM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9686622009739 40.7767294380502)
1847	1847	-73.9782283921819	40.766793260207706	1D-PM-1007-02	01D	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9782283921819 40.7667932602077)
1872	1872	-73.9613998967903	40.7912437235667	32C-PM-1013-02	32C	PM	10132018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9613998967903 40.7912437235667)
1873	1873	-73.955754300682	40.795681399740005	38E-PM-1014-02	38E	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.955754300682 40.79568139974)
1887	1887	-73.95861842328891	40.7993153832942	41A-PM-1007-02	41A	PM	10072018	2	Adult	Black		Black+		Above Ground	15		0	0	1	0	0	jumping	0	0	0	0	0	0	0	0	stared at me	POINT (-73.9586184232889 40.7993153832942)
1904	1904	-73.9684058476942	40.7753959833776	13G-PM-1008-02	13G	PM	10082018	2	Juvenile	Gray		Gray+		Above Ground	15	willow oak tree	0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9684058476942 40.7753959833776)
1916	1916	-73.9693504617353	40.7830678709405	21B-PM-1017-02	21B	PM	10172018	2	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1		0	1	0	0	0		0	1	0	0	0	0	0	0	stood on hind legs with front legs on the chest	POINT (-73.9693504617353 40.7830678709405)

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