squirrels

129 rows where Hectare Squirrel Number = 4, Runs from = "false" and Shift = "AM"

- 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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts

= != contains ends with starts with > ≥ < ≤ 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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts

= != contains ends with starts with > ≥ < ≤ 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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts

= != contains ends with starts with > ≥ < ≤ 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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts

= != contains ends with starts with > ≥ < ≤ 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 Sort by Zip Codes Sort by Community Districts Sort by Borough Boundaries Sort by City Council Districts Sort by Police Precincts

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, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts

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	Zip Codes	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
100	100	-73.9761592532482	40.7747213585387	10A-AM-1006-04	10A	AM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10	tree near large rock on Bridle Path	false	false	false	false	false	walking on branch	false	false	false	false	true	false	false	false		POINT (-73.9761592532482 40.7747213585387)		19	4	19	13
145	145	-73.971970670614	40.7720868124544	9F-AM-1013-04	09F	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.971970670614 40.7720868124544)		19	4	19	13
157	157	-73.9637946878735	40.7915700446878	31A-AM-1010-04	31A	AM	10102018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	false	false		POINT (-73.9637946878735 40.7915700446878)		19	4	19	13
163	163	-73.9712308864394	40.7714534847379	9G-AM-1007-04	09G	AM	10072018	4	Adult	Gray	White	Gray+White		Above Ground	15		false	false	false	false	false	grooming	false	false	false	false	false	false	true	false		POINT (-73.9712308864394 40.7714534847379)		19	4	19	13
175	175	-73.9720065066618	40.7764043782924	13C-AM-1010-04	13C	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	true	false		POINT (-73.9720065066618 40.7764043782924)		19	4	19	13
273	273	-73.9579218587172	40.7960605028848	38C-AM-1019-04	38C	AM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		true	true	false	false	false	false	true	false		POINT (-73.9579218587172 40.79606050288481)		19	4	19	13
293	293	-73.9696173677837	40.7705202790525	8H-AM-1017-04	08H	AM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9696173677837 40.7705202790525)		19	4	19	13
349	349	-73.9689657039917	40.7767834276767	15F-AM-1007-04	15F	AM	10072018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	false	false		POINT (-73.9689657039917 40.7767834276767)		19	4	19	13
441	441	-73.9742973420446	40.7691801644292	5F-AM-1007-04	05F	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		rocks	false	false	false	true	true		false	false	false	false	false	false	false	false		POINT (-73.9742973420446 40.7691801644292)		19	4	19	13
455	455	-73.9688574691102	40.7837825208444	21B-AM-1019-04	21B	AM	10192018	4				+					false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9688574691102 40.7837825208444)		19	4	19	13
459	459	-73.9624546917649	40.7888234959792	29D-AM-1014-04	29D	AM	10142018	4	Juvenile	Gray		Gray+		Ground Plane	FALSE	Rock a	false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9624546917649 40.78882349597921)		19	4	19	13
481	481	-73.9714303315699	40.7745934947706	11E-AM-1013-04	11E	AM	10132018	4	Adult	Black		Black+		Ground Plane	FALSE		false	false	false	false	true	burying	false	false	false	false	false	false	true	false		POINT (-73.9714303315699 40.7745934947706)		19	4	19	13
486	486	-73.971213385696	40.769872094337	7H-AM-1006-04	07H	AM	10062018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.97121338569602 40.769872094337)		19	4	19	13
537	537	-73.9682803241007	40.7724510558327	11H-AM-1010-04	11H	AM	10102018	4		Gray	White	Gray+White					false	false	false	false	true		false	false	false	false	true	false	false	false		POINT (-73.9682803241007 40.7724510558327)		19	4	19	13
541	541	-73.9617612388703	40.7952875954297	35A-AM-1014-04	35A	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9617612388703 40.7952875954297)		19	4	19	13
584	584	-73.9720553753548	40.7664488175384	3I-AM-1010-04	03I	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9720553753548 40.7664488175384)		19	4	19	13
589	589	-73.97826438139	40.7717086090782	6A-AM-1006-04	06A	AM	10062018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	true	false	false	true		false	false	false	false	true	false	false	false	curious	POINT (-73.97826438139 40.7717086090782)		19	4	19	13
616	616	-73.9556937218252	40.7990928062435	42C-AM-1007-04	42C	AM	10072018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	young adult	Ground Plane	FALSE		false	false	false	false	false	walking	false	false	false	false	false	false	true	false		POINT (-73.9556937218252 40.7990928062435)		19	4	19	13
626	626	-73.9705053821577	40.7787503220242	16C-AM-1014-04	16C	AM	10142018	4	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9705053821577 40.7787503220242)		19	4	19	13
631	631	-73.9548877830136	40.7950157489103	38F-AM-1018-04	38F	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.95488778301362 40.7950157489103)		19	4	19	13
654	654	-73.976769659152	40.7741908010484	9A-AM-1013-04	09A	AM	10132018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	false	false		POINT (-73.976769659152 40.7741908010484)		19	4	19	13
681	681	-73.9552880892701	40.7889040503316	32I-AM-1013-04	32I	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9552880892701 40.7889040503316)		19	4	19	13
687	687	-73.9636971843665	40.7825638537362	22F-AM-1007-04	22F	AM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray					false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9636971843665 40.7825638537362)		19	4	19	13
731	731	-73.9733545802515	40.7675056025357	4G-AM-1006-04	04G	AM	10062018	4	Adult	Black		Black+		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9733545802515 40.7675056025357)		19	4	19	13
753	753	-73.9729378674198	40.7672407594559	4H-AM-1006-04	04H	AM	10062018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true	met #3 while foraging and briefly tussled	false	false	false	false	false	false	true	false		POINT (-73.9729378674198 40.7672407594559)		19	4	19	13
823	823	-73.954595058342	40.7956567934304	39F-AM-1014-04	39F	AM	10142018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.954595058342 40.7956567934304)		19	4	19	13
842	842	-73.9645147011741	40.7772566833799	17I-AM-1014-04	17I	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	true	false		POINT (-73.9645147011741 40.7772566833799)		19	4	19	13
849	849	-73.9736165917399	40.7724543901497	8D-AM-1007-04	08D	AM	10072018	4	Adult	Gray		Gray+		Above Ground	3		false	true	false	false	false	chasing squirrel #3	false	false	false	false	false	false	false	false		POINT (-73.9736165917399 40.7724543901497)		19	4	19	13
851	851	-73.9528462779437	40.7923843043685	36I-AM-1017-04	36I	AM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9528462779437 40.7923843043685)		19	4	19	13
873	873	-73.9770948563006	40.7724063459185	7B-AM-1008-04	07B	AM	10082018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9770948563006 40.7724063459185)		19	4	19	13
886	886	-73.9696517826558	40.7769658302844	14E-AM-1008-04	14E	AM	10082018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9696517826558 40.7769658302844)		19	4	19	13
903	903	-73.9719941577406	40.77037129313	7G-AM-1010-04	07G	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9719941577406 40.77037129313)		19	4	19	13
1003	1003	-73.9645547556826	40.776877007081	16I-AM-1008-04	16I	AM	10082018	4	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	9	tree hollow	false	false	false	false	false	in hollow	false	false	false	false	false	false	false	false	curious	POINT (-73.9645547556826 40.776877007081)		19	4	19	13
1036	1036	-73.9709207551033	40.7767932008037	14D-AM-1014-04	14D	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	true	false	false		POINT (-73.9709207551033 40.7767932008037)		19	4	19	13
1056	1056	-73.9811078442462	40.767515940567	1A-AM-1007-04	01A	AM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9811078442462 40.767515940567)	12081	11	4	51	10
1072	1072	-73.9566571713254	40.7989855775435	41C-AM-1017-04	41C	AM	10172018	4		Gray		Gray+		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9566571713254 40.7989855775435)		19	4	19	13
1088	1088	-73.9770985425092	40.7665926744505	1E-AM-1006-04	01E	AM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9770985425092 40.7665926744505)		19	4	19	13
1113	1113	-73.9679309130266	40.7792437838039	17E-AM-1017-04	17E	AM	10172018	4	Adult	Gray		Gray+		Ground Plane	FALSE	Shore	false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9679309130266 40.779243783803906)		19	4	19	13
1195	1195	-73.9801698909399	40.7683721553321	2B-AM-1010-04	02B	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9801698909399 40.7683721553321)		19	4	19	13
1223	1223	-73.9591298551111	40.7919612446005	33E-AM-1014-04	33E	AM	10142018	4	Adult	Black	Cinnamon, White	Black+Cinnamon, White		Ground Plane	FALSE		true	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9591298551111 40.7919612446005)		19	4	19	13
1227	1227	-73.9527924755398	40.7934366260533	37I-AM-1010-04	37I	AM	10102018	4	Adult	Gray		Gray+		Above Ground	50	in tree	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9527924755398 40.7934366260533)		19	4	19	13
1246	1246	-73.9543044385367	40.7984498571338	41E-AM-1007-04	41E	AM	10072018	4	Adult	Cinnamon	White	Cinnamon+White	white haunches/tail	Ground Plane	FALSE	rubbing belly on ground	false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9543044385367 40.798449857133804)		19	4	19	13
1280	1280	-73.9562469727195	40.79685907654	39D-AM-1008-04	39D	AM	10082018	4	Adult	Gray		Gray+		Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9562469727195 40.79685907654)		19	4	19	13
1302	1302	-73.9704024529864	40.7729256063889	10G-AM-1006-04	10G	AM	10062018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		false	true	false	false	false	chasing (#3)	true	false	false	false	false	false	false	false		POINT (-73.9704024529864 40.7729256063889)		19	4	19	13
1365	1365	-73.9791648157033	40.767625444347	2C-AM-1010-04	02C	AM	10102018	4	Adult	Gray		Gray+		Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9791648157033 40.767625444347)		19	4	19	13
1391	1391	-73.9578658632957	40.7933712188923	35E-AM-1020-04	35E	AM	10202018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		false	false	false	false	false	hunkered down,tail over body; sitting perfectly still	false	false	false	false	false	false	true	false		POINT (-73.9578658632957 40.7933712188923)		19	4	19	13
1436	1436	-73.9766779585686	40.7669673778105	2E-AM-1010-04	02E	AM	10102018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	false		true	false	false	false	false	false	true	false		POINT (-73.9766779585686 40.7669673778105)		19	4	19	13
1453	1453	-73.9555856074105	40.7969457685677	40E-AM-1014-04	40E	AM	10142018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	on rocks/bushy rocks	true	false	false	false	false	hiding from bird	false	true	false	false	true	false	true	false		POINT (-73.9555856074105 40.79694576856771)		19	4	19	13
1457	1457	-73.9697744662785	40.7755950428973	13F-AM-1007-04	13F	AM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9697744662785 40.7755950428973)		19	4	19	13
1492	1492	-73.9807078515193	40.7683335292642	2A-AM-1010-04	02A	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	true	false	true	false		POINT (-73.9807078515193 40.7683335292642)		19	4	19	13
1509	1509	-73.9556450015702	40.7967188058002	39E-AM-1018-04	39E	AM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	true	false	false	false		false	false	false	true	false	false	true	false		POINT (-73.9556450015702 40.7967188058002)		19	4	19	13
1518	1518	-73.9632265832593	40.7816914475461	22G-AM-1018-04	22G	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9632265832593 40.78169144754611)		19	4	19	13
1529	1529	-73.9692401421068	40.7707128895661	8I-AM-1006-04	08I	AM	10062018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		true	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9692401421068 40.7707128895661)		19	4	19	13
1563	1563	-73.9676270670996	40.776391443152	15G-AM-1008-04	15G	AM	10082018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	true	false	false	false		true	false	false	false	false	false	false	false		POINT (-73.9676270670996 40.776391443152)		19	4	19	13
1583	1583	-73.9701030393506	40.7838953063625	21A-AM-1019-04	21A	AM	10192018	4	Juvenile	Gray	Black	Gray+Black		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9701030393506 40.7838953063625)		19	4	19	13
1591	1591	-73.9576223390082	40.7979746639647	40B-AM-1019-04	40B	AM	10192018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	true	false	true		false	false	false	false	false	true	true	false		POINT (-73.9576223390082 40.79797466396471)		19	4	19	13
1597	1597	-73.9789401448556	40.7697373141498	4B-AM-1010-04	04B	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false		POINT (-73.9789401448556 40.7697373141498)		19	4	19	13
1600	1600	-73.9753093777	40.7666673897583	2F-AM-1006-04	02F	AM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Beautiful white puff at the end of its tail	Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	true	false	true	false		POINT (-73.97530937770001 40.7666673897583)		19	4	19	13
1623	1623	-73.9770119133023	40.7732949090005	8A-AM-1013-04	08A	AM	10132018	4	Juvenile			+		Above Ground	4	fence	true	true	false	true	true	playing tag together	false	false	false	false	false	true	false	false		POINT (-73.9770119133023 40.7732949090005)		19	4	19	13
1663	1663	-73.9696720362627	40.7791851598197	17D-AM-1008-04	17D	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	false	false		false	false	false	false	true	false	true	false		POINT (-73.9696720362627 40.7791851598197)		19	4	19	13
1675	1675	-73.9777497645834	40.7677344709178	2D-AM-1007-04	02D	AM	10072018	4	Adult	Gray		Gray+		Above Ground	100		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9777497645834 40.7677344709178)		19	4	19	13
1709	1709	-73.9771696835698	40.7697011100487	4C-AM-1006-04	04C	AM	10062018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	true	false	true	false		POINT (-73.9771696835698 40.7697011100487)		19	4	19	13
1710	1710	-73.9545438656122	40.7902168635009	34I-AM-1012-04	34I	AM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9545438656122 40.7902168635009)		19	4	19	13
1729	1729	-73.9765046109019	40.7736674124746	8B-AM-1007-04	08B	AM	10072018	4	Adult	Gray		Gray+		Above Ground	2		false	false	true	false	true		false	false	false	false	false	false	true	false		POINT (-73.9765046109019 40.7736674124746)		19	4	19	13
1736	1736	-73.9743873549635	40.7745426051392	10C-AM-1018-04	10C	AM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9743873549635 40.7745426051392)		19	4	19	13
1752	1752	-73.9561091686663	40.7981463047425	41D-AM-1014-04	41D	AM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9561091686663 40.7981463047425)		19	4	19	13
1790	1790	-73.9730592548116	40.7740879251541	10D-AM-1008-04	10D	AM	10082018	4	Juvenile	Gray		Gray+		Above Ground	25		false	true	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9730592548116 40.7740879251541)		19	4	19	13
1811	1811	-73.9788088165392	40.7690153025878	3B-AM-1010-04	03B	AM	10102018	4	Juvenile	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9788088165392 40.7690153025878)		19	4	19	13
1828	1828	-73.9682965197661	40.7805378963883	18D-AM-1018-04	18D	AM	10182018	4	Adult	Gray		Gray+		Above Ground	2		false	false	true	false	true		false	false	false	false	false	false	false	false		POINT (-73.9682965197661 40.7805378963883)		19	4	19	13
1901	1901	-73.9680237209555	40.7717022208225	10I-AM-1010-04	10I	AM	10102018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9680237209555 40.7717022208225)		19	4	19	13
1919	1919	-73.9637440847107	40.7891427419372	29C-AM-1007-04	29C	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	true	false	false		POINT (-73.9637440847107 40.7891427419372)		19	4	19	13
1969	1969	-73.9689051473072	40.7764511282884	14F-AM-1007-04	14F	AM	10072018	4	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9689051473072 40.7764511282884)		19	4	19	13
1993	1993	-73.9546367558712	40.789840987798	33I-AM-1008-04	33I	AM	10082018	4	Adult			+		Above Ground	100		false	false	true	false	true		false	false	false	false	false	false	true	false		POINT (-73.9546367558712 40.789840987798)		19	4	19	13
2001	2001	-73.9521655419974	40.7948785497717	39H-AM-1007-04	39H	AM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	false	false		POINT (-73.9521655419974 40.7948785497717)		19	4	19	13
2050	2050	-73.9555255950648	40.7977720808005	40D-AM-1013-04	40D	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9555255950648 40.7977720808005)		19	4	19	13
2059	2059	-73.9710026704697	40.7761052764621	13D-AM-1014-04	13D	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9710026704697 40.7761052764621)		19	4	19	13
2103	2103	-73.9782983634755	40.7668314364263	1D-AM-1006-04	01D	AM	10062018	4	Adult	Gray	White	Gray+White		Above Ground	30		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9782983634755 40.7668314364263)		19	4	19	13
2113	2113	-73.9582904814652	40.7905915749564	32F-AM-1012-04	32F	AM	10122018	4	Adult	Black		Black+		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9582904814652 40.7905915749564)		19	4	19	13
2140	2140	-73.9598875541307	40.7973415580717	38A-AM-1019-04	38A	AM	10192018	4	Adult	Gray		Gray+		Above Ground	2		false	false	false	false	false	walking	false	false	false	false	false	false	true	false		POINT (-73.9598875541307 40.7973415580717)		19	4	19	13
2156	2156	-73.9650387848001	40.7814134438394	21F-AM-1018-04	21F	AM	10182018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	false	false		POINT (-73.9650387848001 40.7814134438394)		19	4	19	13
2219	2219	-73.9709242364673	40.7684217215595	5I-AM-1010-04	05I	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	true	false	true	false		POINT (-73.9709242364673 40.7684217215595)		19	4	19	13
2227	2227	-73.9792814244424	40.770503194056	4A-AM-1007-04	04A	AM	10072018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9792814244424 40.770503194056)		19	4	19	13
2246	2246	-73.9711607544742	40.774988247642	12E-AM-1017-04	12E	AM	10172018	4	Adult	Gray		Gray+		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9711607544742 40.774988247642)		19	4	19	13
2248	2248	-73.9766477027266	40.7712737417779	6C-AM-1007-04	06C	AM	10072018	4	Adult	Gray		Gray+		Above Ground	20		false	true	true	false	false	chasing #5	false	false	false	false	false	false	true	false		POINT (-73.9766477027266 40.7712737417779)		19	4	19	13
2264	2264	-73.9773520582734	40.7708198505781	5B-AM-1008-04	05B	AM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9773520582734 40.7708198505781)		19	4	19	13
2285	2285	-73.9576325087936	40.7988448745116	41B-AM-1010-04	41B	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9576325087936 40.7988448745116)		19	4	19	13
2295	2295	-73.9590632051055	40.7963146584827	38B-AM-1019-04	38B	AM	10192018	4	Adult	Gray		Gray+		Above Ground	20		false	false	false	false	false	sitting in tree	true	true	false	true	false	false	true	false	observant	POINT (-73.9590632051055 40.7963146584827)		19	4	19	13
2322	2322	-73.9723677854798	40.7667315410871	3H-AM-1008-04	03H	AM	10082018	4	Adult	Black		Black+		Above Ground	50		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9723677854798 40.7667315410871)		19	4	19	13
2340	2340	-73.9730284815849	40.7702462529502	7F-AM-1008-04	07F	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	bush	false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9730284815849 40.7702462529502)		19	4	19	13
2343	2343	-73.9719194877439	40.7748000962909	11D-AM-1010-04	11D	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	true	false	false	false		POINT (-73.9719194877439 40.7748000962909)		19	4	19	13
2355	2355	-73.9728654439465	40.7724853142211	9E-AM-1008-04	09E	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9728654439465 40.7724853142211)		19	4	19	13
2367	2367	-73.9681671864047	40.7753770538635	14G-AM-1012-04	14G	AM	10122018	4	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	true	false		POINT (-73.9681671864047 40.7753770538635)		19	4	19	13
2404	2404	-73.9665309689616	40.7775271020244	16G-AM-1010-04	16G	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9665309689616 40.7775271020244)		19	4	19	13
2425	2425	-73.9791141532217	40.7714888835416	5A-AM-1006-04	05A	AM	10062018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9791141532217 40.77148888354161)		19	4	19	13
2447	2447	-73.9589670987899	40.7952127039287	37C-AM-1012-04	37C	AM	10122018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon flanks	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9589670987899 40.7952127039287)		19	4	19	13
2450	2450	-73.9756273257684	40.7706539186221	6D-AM-1008-04	06D	AM	10082018	4	Adult	Gray		Gray+		Above Ground			false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9756273257684 40.7706539186221)		19	4	19	13
2461	2461	-73.9605347462123	40.7942075448387	35B-AM-1010-04	35B	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	lawn	false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9605347462123 40.7942075448387)		19	4	19	13
2475	2475	-73.9736489041867	40.7712143385426	7E-AM-1006-04	07E	AM	10062018	4	Adult	Gray		Gray+		Ground Plane	FALSE	under a tree	false	false	false	true	false		false	false	false	false	false	false	false	false		POINT (-73.9736489041867 40.7712143385426)		19	4	19	13
2478	2478	-73.9674931070324	40.7783693690954	17F-AM-1007-04	17F	AM	10072018	4	Adult	Cinnamon	White	Cinnamon+White		Above Ground	4		false	false	false	true	false	chilling	true	false	false	false	false	false	true	false		POINT (-73.9674931070324 40.7783693690954)		19	4	19	13
2514	2514	-73.95744422055	40.7961046528557	38D-AM-1017-04	38D	AM	10172018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.95744422055 40.7961046528557)		19	4	19	13

Next page

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "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" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);