2018_Central_Park_Squirrel_Census_-_Squirrel_Data

533 rows where Hectare Squirrel Number = 2 sorted by Runs from 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
2352	2352	-73.9727310397798	40.778701677351705	15B-PM-1017-02	15B	PM	10172018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE	tree	0	0	1	1	1	digging,chewing on tree—has nut in mouth!	0	0	0	0	0	0	0	1		POINT (-73.97273103977982 40.7787016773517)
2405	2405	-73.9588361742943	40.791115225155	33E-PM-1012-02	33E	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9588361742943 40.791115225155)
2419	2419	-73.9590551473416	40.7891607060794	31F-PM-1007-02	31F	PM	10072018	2	Adult	Gray		Gray+		Above Ground	2	tree trunk	0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.95905514734162 40.7891607060794)
2426	2426	-73.9790203973636	40.768883711483205	3B-AM-1010-02	03B	AM	10102018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	together w/ #3	0	0	0	0	0	0	0	1		POINT (-73.9790203973636 40.7688837114832)
2432	2432	-73.9657203199746	40.775173008911	14I-PM-1018-02	14I	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9657203199746 40.775173008911)
2467	2467	-73.9755923256429	40.7672967972471	3F-PM-1013-02	03F	PM	10132018	2	Adult	Black	Gray	Black+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.97559232564292 40.7672967972471)
2488	2488	-73.97269208477921	40.779411746388895	16A-PM-1019-02	16A	PM	10192018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1	scared by dog	POINT (-73.9726920847792 40.7794117463889)
2501	2501	-73.96169441957758	40.7927250423024	33B-PM-1010-02	33B	PM	10102018	2	Adult			+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9616944195776 40.7927250423024)
2608	2608	-73.95226776576591	40.7934034811368	38I-AM-1019-02	38I	AM	10192018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9522677657659 40.7934034811368)
2615	2615	-73.97346051766459	40.7686218881386	5G-PM-1010-02	05G	PM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9734605176646 40.7686218881386)
2727	2727	-73.974596903918	40.7765498215674	12A-PM-1013-02	12A	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	1	0	1		0	0	0	0	1	0	0	1		POINT (-73.974596903918 40.7765498215674)
2803	2803	-73.9576652087316	40.787545797780105	29H-PM-1006-02	29H	PM	10062018	2	Adult	Gray		Gray+		Above Ground	2		1	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9576652087316 40.7875457977801)
2807	2807	-73.9618213644671	40.792764881973795	33B-AM-1010-02	33B	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.96182136446711 40.7927648819738)
2818	2818	-73.9681664642028	40.77246696819579	11I-PM-1012-02	11I	PM	10122018	2	Adult	Gray		Gray+		Above Ground	4		1	0	1	0	1		0	0	0	0	0	0	0	1	runs away from the ball	POINT (-73.9681664642028 40.7724669681958)
2886	2886	-73.9729265300533	40.774176829164205	10D-AM-1008-02	10D	AM	10082018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9729265300533 40.7741768291642)
2898	2898	-73.97941182346509	40.767449554056896	1C-AM-1012-02	01C	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9794118234651 40.7674495540569)
2947	2947	-73.96012151981141	40.7909769801241	32D-PM-1006-02	32D	PM	10062018	2	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9601215198114 40.7909769801241)
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)
3016	3016	-73.9756457597888	40.7703559775625	6D-PM-1020-02	06D	PM	10202018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9756457597888 40.7703559775625)
3018	3018	-73.9645437409662	40.7811599933331	21F-PM-1018-02	21F	PM	10182018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9645437409662 40.7811599933331)
6	6	-73.9565700386162	40.7902561000937	33H-AM-1019-02	33H	AM	10192018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	wrestling with mother	0	0	0	0	0	0	0	0		POINT (-73.9565700386162 40.7902561000937)
7	7	-73.9719735582476	40.769304513357795	6G-PM-1020-02	06G	PM	10202018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9719735582476 40.7693045133578)
13	13	-73.95412017897951	40.793181170108205	36H-AM-1010-02	36H	AM	10102018	2	Adult	Gray		Gray+	just outside hectare	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9541201789795 40.7931811701082)
14	14	-73.9582694312289	40.7917367820255	33F-AM-1008-02	33F	AM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9582694312289 40.7917367820255)
33	33	-73.9738033257473	40.7711846894166	7E-AM-1006-02	07E	AM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE	under a tree	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9738033257473 40.7711846894166)
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)
43	43	-73.9574648097543	40.7892508428622	31H-PM-1008-02	31H	PM	10082018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		1	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9574648097543 40.78925084286221)
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)
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)
62	62	-73.952819267977	40.792313040279296	36I-AM-1017-02	36I	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon stripe on back	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.952819267977 40.7923130402793)
68	68	-73.96942403275091	40.7755898126674	13F-AM-1007-02	13F	AM	10072018	2	Adult	Cinnamon	White	Cinnamon+White					0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.96942403275091 40.7755898126674)
86	86	-73.9708726050721	40.7723572030236	10F-AM-1007-02	10F	AM	10072018	2	Adult	Gray		Gray+		Above Ground	70		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9708726050721 40.7723572030236)
92	92	-73.9565759733611	40.7992461674802	42C-AM-1007-02	42C	AM	10072018	2				+					0	0	0	0	0		0	1	0	0	0	0	0	0		POINT (-73.9565759733611 40.7992461674802)
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)
127	127	-73.96641005044359	40.7828778892276	21D-AM-1008-02	21D	AM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9664100504436 40.7828778892276)
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)
169	169	-73.97487064155841	40.7744174965072	10B-AM-1006-02	10B	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		High in a tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9748706415584 40.7744174965072)
172	172	-73.958535640774	40.7982737896998	40B-AM-1019-02	40B	AM	10192018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.958535640774 40.7982737896998)
184	184	-73.9553811810434	40.7970895007931	40E-AM-1014-02	40E	AM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9553811810434 40.7970895007931)
189	189	-73.9735489537928	40.76812579115229	4G-AM-1006-02	04G	AM	10062018	2		Gray	White	Gray+White		Above Ground	12	tree	0	0	0	0	0	sitting in tree	0	0	0	0	0	0	1	0		POINT (-73.9735489537928 40.7681257911523)
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)
199	199	-73.97716146866159	40.770967798324705	5C-AM-1006-02	05C	AM	10062018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		1	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9771614686616 40.7709677983247)
200	200	-73.9510747586301	40.7973106833951	42H-AM-1019-02	42H	AM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9510747586301 40.7973106833951)
206	206	-73.96136434180251	40.789243193420894	30D-AM-1017-02	30D	AM	10172018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9613643418025 40.7892431934209)
230	230	-73.97314980648721	40.7659963196581	2H-AM-1006-02	02H	AM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	1	0	0		0	0	0	0	0	1	0	0		POINT (-73.9731498064872 40.7659963196581)
234	234	-73.9741401377844	40.7758134257881	12B-AM-1007-02	12B	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9741401377844 40.7758134257881)
241	241	-73.97602564775579	40.7703573131398	5D-AM-1020-02	05D	AM	10202018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1	small jumps	0	0	0	0	0	0	0	0		POINT (-73.9760256477558 40.7703573131398)
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)
251	251	-73.95708175790921	40.7964221087879	38D-AM-1017-02	38D	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	hiding in log	0	0	0	0	0	0	1	0		POINT (-73.9570817579092 40.7964221087879)
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)
262	262	-73.97128762341721	40.7695885530701	7H-PM-1006-02	07H	PM	10062018	2	Adult	Gray		Gray+		Above Ground	25	tree	1	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9712876234172 40.7695885530701)
264	264	-73.9698714743386	40.7743814661685	12F-AM-1020-02	12F	AM	10202018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9698714743386 40.7743814661685)
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)
287	287	-73.9709281471442	40.782809793977705	20A-AM-1010-02	20A	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9709281471442 40.7828097939777)
289	289	-73.9684254196866	40.77809016436	16E-AM-1014-02	16E	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9684254196866 40.77809016436)
304	304	-73.9523001834395	40.7949231000186	39H-AM-1007-02	39H	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9523001834395 40.7949231000186)
319	319	-73.96590343597059	40.779751668884394	19F-AM-1007-02	19F	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	8		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9659034359706 40.77975166888441)
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)
334	334	-73.9687395228846	40.7807364481385	18D-AM-1018-02	18D	AM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9687395228846 40.7807364481385)
346	346	-73.9712971568288	40.7745520717065	11E-AM-1013-02	11E	AM	10132018	2	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9712971568288 40.7745520717065)
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)
369	369	-73.9596398997228	40.793338695384705	34D-PM-1007-02	34D	PM	10072018	2	Adult	Black		Black+		Above Ground	25		1	0	1	0	0		0	0	0	0	0	0	0	0	cautiously aware	POINT (-73.9596398997228 40.7933386953847)
371	371	-73.964080104186	40.79078986272871	30B-AM-1007-02	30B	AM	10072018	2	Adult	Gray		Gray+		Above Ground	15		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.964080104186 40.7907898627287)
374	374	-73.9556817958407	40.788852000621	32I-AM-1013-02	32I	AM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	0	0	watching me from tree - curious	POINT (-73.9556817958407 40.788852000621)
419	419	-73.9777328709928	40.7669087724668	1D-AM-1006-02	01D	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9777328709928 40.7669087724668)
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)
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)
438	438	-73.95257475169142	40.7977257435263	42F-PM-1017-02	42F	PM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	playing	0	0	0	0	0	0	1	0		POINT (-73.95257475169142 40.7977257435263)
442	442	-73.9502466289084	40.795922877988296	41I-AM-1018-02	41I	AM	10182018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0	runs off	POINT (-73.9502466289084 40.7959228779883)
450	450	-73.96442931957729	40.7813829172072	21F-AM-1018-02	21F	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9644293195773 40.7813829172072)
451	451	-73.97531406404451	40.7734037805101	9C-AM-1006-02	09C	AM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9753140640445 40.7734037805101)
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)
469	469	-73.9717201378775	40.776120280884	13D-PM-1018-02	13D	PM	10182018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9717201378775 40.776120280884)
473	473	-73.95701300171591	40.799602742862504	42B-AM-1014-02	42B	AM	10142018	2	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	0	0	0	1	0		POINT (-73.9570130017159 40.7996027428625)
484	484	-73.9666526554772	40.7756111718355	14H-AM-1007-02	14H	AM	10072018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9666526554772 40.77561117183551)
485	485	-73.9677423154682	40.7728813350245	11I-AM-1012-02	11I	AM	10122018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9677423154682 40.77288133502451)
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)
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)
508	508	-73.97469187620759	40.765523188367794	1G-AM-1006-02	01G	AM	10062018	2	Juvenile	Gray	White	Gray+White		Above Ground	30		0	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9746918762076 40.7655231883678)
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)
525	525	-73.952526164386	40.796375924050395	40G-AM-1007-02	40G	AM	10072018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	18		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.952526164386 40.7963759240504)
535	535	-73.9772396728545	40.7668696411765	2E-AM-1010-02	02E	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0	totally indifferent	POINT (-73.9772396728545 40.7668696411765)
553	553	-73.9638526062093	40.782693848993	22F-AM-1007-02	22F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	standing	0	0	0	0	0	0	1	0		POINT (-73.9638526062093 40.782693848993)
565	565	-73.9615402629655	40.7924082330328	33C-AM-1012-02	33C	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon along back & tail	Above Ground	20	tree branches	0	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9615402629655 40.7924082330328)
582	582	-73.9677779408464	40.78674822113489	25A-AM-1013-02	25A	AM	10132018	2		Gray		Gray+		Above Ground	15	BIG TREE	0	1	0	0	0	chasing #3	0	0	0	1	0	0	1	0		POINT (-73.9677779408464 40.7867482211349)
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)
603	603	-73.9721592378418	40.776034583573	12C-AM-1013-02	12C	AM	10132018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		1	0	0	0	0	0	1	0		POINT (-73.9721592378418 40.776034583573)
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)
656	656	-73.9553726714504	40.798757854112296	41D-AM-1014-02	41D	AM	10142018	2	Adult	Gray		Gray+		Above Ground	20		0	0	0	0	0	jumping	0	0	0	0	0	0	1	0		POINT (-73.9553726714504 40.7987578541123)

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