This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Zip Codes, Community Districts, City Council Districts
Hectare Squirrel Number ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
526 | 526 | -73.9680833729772 | 40.7741871025115 | 12H-PM-1007-08 | 12H | PM | 10072018 | 8 | + | Above Ground | 7 | in tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680833729772 40.7741871025115) | 19 | 4 | 19 | 13 | |||||||
867 | 867 | -73.9762257701293 | 40.7744032758323 | 9A-AM-1013-08 | 09A | AM | 10132018 | 8 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9762257701293 40.7744032758323) | 19 | 4 | 19 | 13 | |||||||||
1361 | 1361 | -73.961934398055 | 40.7924789548522 | 33B-PM-1010-07 | 33B | PM | 10102018 | 7 | Adult | + | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.961934398055 40.7924789548522) | 19 | 4 | 19 | 13 | |||||||
1755 | 1755 | -73.9714798196777 | 40.7695231949631 | 6H-PM-1020-02 | 06H | PM | 10202018 | 2 | Adult | + | Above Ground | Fence pole | false | false | true | false | false | false | false | false | false | false | false | false | true | runs from (me) | POINT (-73.9714798196777 40.7695231949631) | 19 | 4 | 19 | 13 | ||||||
2034 | 2034 | -73.9699135187297 | 40.7782354186163 | 16D-AM-1007-03 | 16D | AM | 10072018 | 3 | Adult | + | ran away before I could take a good look | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9699135187297 40.7782354186163) | 19 | 4 | 19 | 13 | ||||||
2501 | 2501 | -73.9616944195776 | 40.7927250423024 | 33B-PM-1010-02 | 33B | PM | 10102018 | 2 | Adult | + | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9616944195776 40.7927250423024) | 19 | 4 | 19 | 13 | |||||||
2784 | 2784 | -73.9763722433833 | 40.7744121430891 | 9A-AM-1013-07 | 09A | AM | 10132018 | 7 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9763722433833 40.7744121430891) | 19 | 4 | 19 | 13 | |||||||||
2910 | 2910 | -73.9506062997507 | 40.7976189496674 | 42H-PM-1014-03 | 42H | PM | 10142018 | 3 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9506062997507 40.7976189496674) | 12423 | 18 | 4 | 36 | 18 | ||||||||
130 | 130 | -73.9581655949437 | 40.7997708190022 | 41A-PM-1007-06 | 41A | PM | 10072018 | 6 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9581655949437 40.7997708190022) | 19 | 4 | 19 | 13 | ||||||
325 | 325 | -73.9630990823243 | 40.7885764284016 | 28D-AM-1012-02 | 28D | AM | 10122018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9630990823243 40.7885764284016) | 19 | 4 | 19 | 13 | ||||||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | true | false | false | true | false | false | false | false | false | true | false | false | true | ran up tree | POINT (-73.959709414696 40.7919745085986) | 19 | 4 | 19 | 13 | ||||||
388 | 388 | -73.9592537496995 | 40.7919271821316 | 33E-AM-1014-03 | 33E | AM | 10142018 | 3 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9592537496995 40.7919271821316) | 19 | 4 | 19 | 13 | ||||||
497 | 497 | -73.9602166876979 | 40.7953811003986 | 36B-AM-1013-04 | 36B | AM | 10132018 | 4 | Black | Black+ | Above Ground | 20 | Moved 20+ feet high above top of tree limb | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9602166876979 40.7953811003986) | 19 | 4 | 19 | 13 | ||||||
593 | 593 | -73.9593352806175 | 40.7918150568046 | 33E-AM-1014-02 | 33E | AM | 10142018 | 2 | Juvenile | Black | Black+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9593352806175 40.7918150568046) | 19 | 4 | 19 | 13 | ||||||
658 | 658 | -73.9704575848926 | 40.7693499326095 | 7H-PM-1006-09 | 07H | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | by tree | false | false | false | true | true | false | false | false | true | false | true | false | true | POINT (-73.9704575848926 40.7693499326095) | 19 | 4 | 19 | 13 | |||||
1149 | 1149 | -73.960237785199 | 40.7907831607574 | 32E-PM-1017-16 | 32E | PM | 10172018 | 16 | Adult | Black | Black+ | Ground Plane | FALSE | rocky outcrop | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.960237785199 40.7907831607574) | 19 | 4 | 19 | 13 | |||||
1232 | 1232 | -73.9589254878322 | 40.7914467650712 | 33E-PM-1012-09 | 33E | PM | 10122018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9589254878322 40.7914467650712) | 19 | 4 | 19 | 13 | ||||||
1261 | 1261 | -73.9719109949232 | 40.7723138521327 | 9F-AM-1013-01 | 09F | AM | 10132018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9719109949232 40.7723138521327) | 19 | 4 | 19 | 13 | ||||||
1307 | 1307 | -73.9565197137317 | 40.7986011403785 | 41C-PM-1007-01 | 41C | PM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9565197137317 40.7986011403785) | 19 | 4 | 19 | 13 | ||||||
1486 | 1486 | -73.9545807749923 | 40.7900507537649 | 33I-PM-1006-02 | 33I | PM | 10062018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9545807749923 40.7900507537649) | 19 | 4 | 19 | 13 | ||||||
1833 | 1833 | -73.962516494651 | 40.7884768989902 | 28D-PM-1019-02 | 28D | PM | 10192018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.962516494651 40.7884768989902) | 19 | 4 | 19 | 13 | ||||||
2166 | 2166 | -73.9711178122133 | 40.7672642958437 | 4I-PM-1007-01 | 04I | PM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9711178122133 40.76726429584371) | 19 | 4 | 19 | 13 | ||||||
2206 | 2206 | -73.9594446018346 | 40.7917800352042 | 33D-AM-1017-06 | 33D | AM | 10172018 | 6 | Adult | Black | Black+ | Above Ground | 10 | false | false | true | false | false | true | true | false | false | false | false | false | true | runs from (ran into hole in tree trunk) | POINT (-73.9594446018346 40.7917800352042) | 19 | 4 | 19 | 13 | |||||
2329 | 2329 | -73.9717515173863 | 40.7747999274418 | 11D-PM-1006-04 | 11D | PM | 10062018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9717515173863 40.7747999274418) | 19 | 4 | 19 | 13 | ||||||
2395 | 2395 | -73.9729603550254 | 40.7660215710657 | 3H-AM-1008-06 | 03H | AM | 10082018 | 6 | Adult | Black | Black+ | beauty! | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.9729603550254 40.7660215710657) | 19 | 4 | 19 | 13 | |||||
2449 | 2449 | -73.9599911537509 | 40.7914452542845 | 33D-AM-1017-04 | 33D | AM | 10172018 | 4 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9599911537509 40.7914452542845) | 19 | 4 | 19 | 13 | ||||||
2469 | 2469 | -73.9600963639087 | 40.7934962325313 | 34C-AM-1007-01 | 34C | AM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | dog | POINT (-73.9600963639087 40.7934962325313) | 19 | 4 | 19 | 13 | |||||
2817 | 2817 | -73.9596445861554 | 40.7971948679007 | 38A-PM-1013-05 | 38A | PM | 10132018 | 5 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9596445861554 40.7971948679007) | 19 | 4 | 19 | 13 | ||||||
2909 | 2909 | -73.9564478909357 | 40.7976928775417 | 40C-PM-1006-04 | 40C | PM | 10062018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9564478909357 40.7976928775417) | 19 | 4 | 19 | 13 | ||||||
837 | 837 | -73.9557172336815 | 40.7921125657722 | 35G-PM-1006-01 | 35G | PM | 10062018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9557172336815 40.7921125657722) | 19 | 4 | 19 | 13 | |||||
1392 | 1392 | -73.9648090698176 | 40.7903882097837 | 29A-PM-1019-03 | 29A | PM | 10192018 | 3 | Juvenile | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | true | false | true | ran from,but now approaching. kind of weirding me out. | POINT (-73.9648090698176 40.7903882097837) | 19 | 4 | 19 | 13 | ||||
2731 | 2731 | -73.9595886063173 | 40.7918405182594 | 33D-AM-1017-09 | 33D | AM | 10172018 | 9 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 7 | false | false | true | false | false | true | true | false | false | false | false | true | true | POINT (-73.9595886063173 40.7918405182594) | 19 | 4 | 19 | 13 | |||||
2974 | 2974 | -73.9575791421589 | 40.7959934459432 | 38D-AM-1017-06 | 38D | AM | 10172018 | 6 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9575791421589 40.7959934459432) | 19 | 4 | 19 | 13 | |||||
2975 | 2975 | -73.959412243507 | 40.7917871123534 | 33E-AM-1014-01 | 33E | AM | 10142018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | digging | false | false | false | false | false | false | false | true | POINT (-73.959412243507 40.7917871123534) | 19 | 4 | 19 | 13 | ||||
2985 | 2985 | -73.9721159387757 | 40.7660503188637 | 3I-PM-1013-03 | 03I | PM | 10132018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9721159387757 40.7660503188637) | 19 | 4 | 19 | 13 | |||||
2879 | 2879 | -73.9744080700098 | 40.7731515721826 | 9C-PM-1006-07 | 09C | PM | 10062018 | 7 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | on top of tarped sand pile | false | false | false | true | false | false | false | false | false | false | false | false | true | (me) | POINT (-73.9744080700098 40.7731515721826) | 19 | 4 | 19 | 13 | |||
858 | 858 | -73.9629383420274 | 40.7889383725489 | 29C-AM-1007-02 | 29C | AM | 10072018 | 2 | Adult | Black | Gray | Black+Gray | Above Ground | 10 | true | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9629383420274 40.7889383725489) | 19 | 4 | 19 | 13 | |||||
2467 | 2467 | -73.9755923256429 | 40.7672967972471 | 3F-PM-1013-02 | 03F | PM | 10132018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.97559232564292 40.7672967972471) | 19 | 4 | 19 | 13 | |||||
1345 | 1345 | -73.9581326554206 | 40.7918074743129 | 34E-PM-1006-02 | 34E | PM | 10062018 | 2 | Juvenile | Black | Gray, White | Black+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9581326554206 40.7918074743129) | 19 | 4 | 19 | 13 | |||||
181 | 181 | -73.9708775864433 | 40.772473633538 | 10F-PM-1019-12 | 10F | PM | 10192018 | 12 | Adult | Black | White | Black+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9708775864433 40.772473633538) | 19 | 4 | 19 | 13 | |||||
36 | 36 | -73.9662438996681 | 40.7890381809441 | 28A-PM-1007-05 | 28A | PM | 10072018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9662438996681 40.7890381809441) | 19 | 4 | 19 | 13 | ||||||
83 | 83 | -73.9617088749928 | 40.7944585082367 | 35A-PM-1013-06 | 35A | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9617088749928 40.7944585082367) | 19 | 4 | 19 | 13 | ||||||
88 | 88 | -73.9683608295976 | 40.7842927405327 | 22B-AM-1013-04 | 22B | AM | 10132018 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Under bench | false | false | false | false | true | false | false | false | false | false | false | false | true | ran from dog-walker | POINT (-73.9683608295976 40.7842927405327) | 19 | 4 | 19 | 13 | ||||
509 | 509 | -73.9714289592392 | 40.7750670702093 | 12E-PM-1018-04 | 12E | PM | 10182018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9714289592392 40.7750670702093) | 19 | 4 | 19 | 13 | ||||||
1230 | 1230 | -73.9790822606486 | 40.7714466633386 | 5A-AM-1006-03 | 05A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 8 | false | false | true | true | false | false | false | false | true | false | false | false | true | POINT (-73.9790822606486 40.7714466633386) | 19 | 4 | 19 | 13 | ||||||
1270 | 1270 | -73.967762162893 | 40.7823359027165 | 20C-PM-1018-08 | 20C | PM | 10182018 | 8 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | true | runs from (dog) | POINT (-73.967762162893 40.7823359027165) | 19 | 4 | 19 | 13 | |||||
1294 | 1294 | -73.9604089940153 | 40.7910028063138 | 32D-AM-1013-04 | 32D | AM | 10132018 | 4 | Adult | Cinnamon | Cinnamon+ | Brown legs | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | true | false | true | POINT (-73.9604089940153 40.7910028063138) | 19 | 4 | 19 | 13 | |||||
1543 | 1543 | -73.9713906492842 | 40.7750061310143 | 12E-PM-1018-03 | 12E | PM | 10182018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9713906492842 40.7750061310143) | 19 | 4 | 19 | 13 | ||||||
1640 | 1640 | -73.9564632239432 | 40.7904807427954 | 33G-AM-1013-01 | 33G | AM | 10132018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 13 | shelter in hole in tree | false | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9564632239432 40.7904807427954) | 19 | 4 | 19 | 13 | |||||
1932 | 1932 | -73.9616972557304 | 40.7953872829374 | 36A-PM-1013-03 | 36A | PM | 10132018 | 3 | Juvenile | Cinnamon | Cinnamon+ | COULD HAVE BEEN CHIPPY, DEEP BROWN | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9616972557304 40.7953872829374) | 19 | 4 | 19 | 13 | |||||
2274 | 2274 | -73.9698044218476 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | false | false | false | true | false | playing,interacting with #7 | false | false | false | false | true | false | false | true | POINT (-73.9698044218476 40.7697007833531) | 19 | 4 | 19 | 13 | |||
2483 | 2483 | -73.9596083366477 | 40.7949526729608 | 36C-PM-1013-05 | 36C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | "Warm brown" written in for Primary. | Ground Plane | FALSE | Ran across path in front of people | true | false | false | true | true | false | false | false | false | true | false | true | true | POINT (-73.9596083366477 40.7949526729608) | 19 | 4 | 19 | 13 | ||||
2672 | 2672 | -73.9614599022015 | 40.7945181285991 | 35A-PM-1013-11 | 35A | PM | 10132018 | 11 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9614599022015 40.7945181285991) | 19 | 4 | 19 | 13 | ||||||
2560 | 2560 | -73.9755459090534 | 40.7680866624003 | 4E-AM-1020-04 | 04E | AM | 10202018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | false | chillin' | false | false | false | false | false | false | false | true | POINT (-73.9755459090534 40.7680866624003) | 19 | 4 | 19 | 13 | ||||
2757 | 2757 | -73.9671419119456 | 40.7758602486862 | 14G-AM-1012-01 | 14G | AM | 10122018 | 1 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9671419119456 40.7758602486862) | 19 | 4 | 19 | 13 | |||||
204 | 204 | -73.9679538163341 | 40.7837103696906 | 22C-AM-1013-03 | 22C | AM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | eating (mushroom) | false | false | false | false | false | false | false | true | POINT (-73.9679538163341 40.7837103696906) | 19 | 4 | 19 | 13 | ||||
224 | 224 | -73.9520592496349 | 40.7975076299811 | 42G-PM-1014-03 | 42G | PM | 10142018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | on fence | true | false | false | false | false | prancing | false | false | false | false | false | false | false | true | POINT (-73.9520592496349 40.7975076299811) | 19 | 4 | 19 | 13 | |||
384 | 384 | -73.968045072743 | 40.7836626717225 | 22C-AM-1013-02 | 22C | AM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | false | false | true | false | true | true | false | false | true | false | false | false | true | POINT (-73.968045072743 40.7836626717225) | 19 | 4 | 19 | 13 | |||||
470 | 470 | -73.9581243021722 | 40.794431473386 | 36D-AM-1007-01 | 36D | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | true | avoiding a dog | POINT (-73.95812430217221 40.794431473386) | 19 | 4 | 19 | 13 | ||||
493 | 493 | -73.9776854797916 | 40.7683102295663 | 3D-AM-1006-04 | 03D | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (boy on bike) | POINT (-73.9776854797916 40.7683102295663) | 19 | 4 | 19 | 13 | ||||
506 | 506 | -73.9649611089685 | 40.7814371834837 | 21F-AM-1018-05 | 21F | AM | 10182018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9649611089685 40.7814371834837) | 19 | 4 | 19 | 13 | |||||
534 | 534 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9650499507011 40.7908191782173) | 19 | 4 | 19 | 13 | |||||
552 | 552 | -73.9625416200877 | 40.7811302397912 | 21H-AM-1017-02 | 21H | AM | 10172018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9625416200877 40.78113023979121) | 19 | 4 | 19 | 13 | |||||
852 | 852 | -73.9609704650925 | 40.7938786854735 | 34B-AM-1013-03 | 34B | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | true | false | true | false | false | hopping | false | false | false | false | false | true | false | true | POINT (-73.9609704650925 40.7938786854735) | 19 | 4 | 19 | 13 | ||||
968 | 968 | -73.9689781843873 | 40.7709333833783 | 9I-PM-1010-04 | 09I | PM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9689781843873 40.7709333833783) | 19 | 4 | 19 | 13 | |||||
987 | 987 | -73.9649827807341 | 40.7817322832767 | 21F-AM-1018-06 | 21F | AM | 10182018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9649827807341 40.7817322832767) | 19 | 4 | 19 | 13 | |||||
1081 | 1081 | -73.9680855277775 | 40.7769251965381 | 15F-AM-1007-10 | 15F | AM | 10072018 | 10 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680855277775 40.7769251965381) | 19 | 4 | 19 | 13 | |||||
1098 | 1098 | -73.9604954276129 | 40.7965682182001 | 37A-AM-1012-01 | 37A | AM | 10122018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Drawing included on tally sheet | Ground Plane | FALSE | false | false | false | false | true | scanning (drawing included) | false | false | false | false | false | false | false | true | POINT (-73.9604954276129 40.7965682182001) | 19 | 4 | 19 | 13 | |||
1117 | 1117 | -73.9693465383617 | 40.7744996336934 | 12F-PM-1007-01 | 12F | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9693465383617 40.7744996336934) | 19 | 4 | 19 | 13 | |||||
1155 | 1155 | -73.964572179093 | 40.7811208719018 | 21F-PM-1018-01 | 21F | PM | 10182018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.964572179093 40.7811208719018) | 19 | 4 | 19 | 13 | |||||
1334 | 1334 | -73.957134662576 | 40.7872395604122 | 30I-PM-1006-07 | 30I | PM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.957134662576 40.7872395604122) | 19 | 4 | 19 | 13 | |||||
1354 | 1354 | -73.9765269282059 | 40.7746876635248 | 9A-AM-1013-10 | 09A | AM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9765269282059 40.7746876635248) | 19 | 4 | 19 | 13 | |||||
1560 | 1560 | -73.9587072763996 | 40.7850256219415 | 27I-AM-1007-01 | 27I | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9587072763996 40.7850256219415) | 19 | 4 | 19 | 13 | |||||
1619 | 1619 | -73.9744555348544 | 40.7728498106357 | 8D-PM-1007-03 | 08D | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9744555348544 40.7728498106357) | 19 | 4 | 19 | 13 | |||||||
1631 | 1631 | -73.9527196716568 | 40.792363826828 | 36I-PM-1007-11 | 36I | PM | 10072018 | 11 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | true | me! | POINT (-73.9527196716568 40.792363826828) | 19 | 4 | 19 | 13 | ||||
1891 | 1891 | -73.9749641575871 | 40.7673305056277 | 3F-AM-1006-05 | 03F | AM | 10062018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9749641575871 40.7673305056277) | 19 | 4 | 19 | 13 | |||||
1939 | 1939 | -73.9540151828782 | 40.7920066170587 | 35H-AM-1013-01 | 35H | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | Climbing up tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9540151828782 40.7920066170587) | 19 | 4 | 19 | 13 | ||||
2043 | 2043 | -73.9643223016635 | 40.781431908715 | 21F-AM-1018-03 | 21F | AM | 10182018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | false | dead | false | false | false | false | false | false | false | true | POINT (-73.9643223016635 40.781431908715) | 19 | 4 | 19 | 13 | ||||
2060 | 2060 | -73.9575798004084 | 40.795701403549 | 38D-PM-1006-04 | 38D | PM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | near drive -runners -cyclists | POINT (-73.95757980040841 40.795701403549) | 19 | 4 | 19 | 13 | ||||
2218 | 2218 | -73.9694382427984 | 40.7846350692923 | 22A-AM-1008-04 | 22A | AM | 10082018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9694382427984 40.7846350692923) | 19 | 4 | 19 | 13 | |||||
2234 | 2234 | -73.9734741818047 | 40.766328451425 | 3H-PM-1014-03 | 03H | PM | 10142018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9734741818047 40.766328451425) | 19 | 4 | 19 | 13 | |||||
2244 | 2244 | -73.9509628195532 | 40.7977775674178 | 42H-PM-1014-01 | 42H | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9509628195532 40.7977775674178) | 12423 | 18 | 4 | 36 | 18 | ||||
2245 | 2245 | -73.9774228454023 | 40.7686399839016 | 3D-AM-1006-05 | 03D | AM | 10062018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (chased by boy),wary of humans in playground | POINT (-73.9774228454023 40.7686399839016) | 19 | 4 | 19 | 13 | ||||
2454 | 2454 | -73.9565151662506 | 40.7946647987447 | 37E-PM-1006-07 | 37E | PM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | me | POINT (-73.9565151662506 40.7946647987447) | 19 | 4 | 19 | 13 | ||||
2488 | 2488 | -73.9726920847792 | 40.7794117463889 | 16A-PM-1019-02 | 16A | PM | 10192018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | scared by dog | POINT (-73.9726920847792 40.7794117463889) | 19 | 4 | 19 | 13 | ||||
2583 | 2583 | -73.9769693140651 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 10062018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | up a tree | true | false | true | true | true | digging (?) | false | false | false | true | false | false | false | true | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) | 19 | 4 | 19 | 13 | ||
2608 | 2608 | -73.9522677657659 | 40.7934034811368 | 38I-AM-1019-02 | 38I | AM | 10192018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9522677657659 40.7934034811368) | 19 | 4 | 19 | 13 | |||||
2671 | 2671 | -73.9743369068254 | 40.7675726965985 | 3F-AM-1006-11 | 03F | AM | 10062018 | 11 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9743369068254 40.7675726965985) | 19 | 4 | 19 | 13 | |||||
2727 | 2727 | -73.974596903918 | 40.7765498215674 | 12A-PM-1013-02 | 12A | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.974596903918 40.7765498215674) | 19 | 4 | 19 | 13 | |||||
2788 | 2788 | -73.9647845655965 | 40.7816573808695 | 21F-AM-1018-07 | 21F | AM | 10182018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9647845655965 40.7816573808695) | 19 | 4 | 19 | 13 | |||||
2927 | 2927 | -73.9650120066074 | 40.7805932882407 | 20F-PM-1007-13 | 20F | PM | 10072018 | 13 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9650120066074 40.78059328824071) | 19 | 4 | 19 | 13 | |||||
2971 | 2971 | -73.9639801411692 | 40.7778921302618 | 18I-PM-1007-04 | 18I | PM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | false | walking sitting up | false | false | false | false | false | false | false | true | POINT (-73.9639801411692 40.7778921302618) | 19 | 4 | 19 | 13 | ||||
2992 | 2992 | -73.9746063250438 | 40.7687654196811 | 4F-PM-1013-03 | 04F | PM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9746063250438 40.7687654196811) | 19 | 4 | 19 | 13 | |||||
3018 | 3018 | -73.9645437409662 | 40.7811599933331 | 21F-PM-1018-02 | 21F | PM | 10182018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9645437409662 40.7811599933331) | 19 | 4 | 19 | 13 | |||||
87 | 87 | -73.9541453465817 | 40.7982162223764 | 42E-PM-1012-06 | 42E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9541453465817 40.79821622237641) | 19 | 4 | 19 | 13 | |||||
150 | 150 | -73.9763430829342 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 10082018 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | on tree facing downward | false | true | false | false | false | chased #12 | true | false | false | true | false | false | false | true | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
303 | 303 | -73.9762348224648 | 40.7694522315322 | 4D-PM-1008-08 | 04D | PM | 10082018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | true | true | climbed fence staring at me - went up tree | false | false | false | false | false | false | false | true | POINT (-73.97623482246482 40.7694522315322) | 19 | 4 | 19 | 13 | ||||
813 | 813 | -73.9758959798289 | 40.7694125671679 | 4D-PM-1008-01 | 04D | PM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9758959798289 40.7694125671679) | 19 | 4 | 19 | 13 | |||||
925 | 925 | -73.9763116425885 | 40.7688839576487 | 4D-PM-1008-03 | 04D | PM | 10082018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | ran two feet up tree trunk | POINT (-73.9763116425885 40.7688839576487) | 19 | 4 | 19 | 13 | ||||
1287 | 1287 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 10082018 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | true | false | false | false | false | was chased by # 11 | true | false | false | false | false | false | false | true | POINT (-73.9763236949008 40.7686815615335) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
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 );