This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Runs from, Zip Codes, Community Districts, City Council Districts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
198 | 198 | -73.9761107065353 | 40.769642060286 | 5D-AM-1020-01 | 05D | AM | 10202018 | 1 | Adult | + | Too far & cloudy to tell | Above Ground | 30 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9761107065353 40.769642060286) | 19 | 4 | 19 | 13 | ||||||
708 | 708 | -73.9592819491968 | 40.7941062008626 | 35C-AM-1007-06 | 35C | AM | 10072018 | 6 | Adult | + | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9592819491968 40.7941062008626) | 19 | 4 | 19 | 13 | |||||||
794 | 794 | -73.9790010565108 | 40.7685732369544 | 2C-PM-1013-09 | 02C | PM | 10132018 | 9 | Adult | + | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9790010565108 40.7685732369544) | 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 | |||||||||
1248 | 1248 | -73.9719729323923 | 40.7668318394546 | 4I-AM-1006-03 | 04I | AM | 10062018 | 3 | Adult | + | Can't tell :( | Above Ground | 28 | Tree | false | false | true | false | false | building nest! | false | false | false | false | false | false | false | false | POINT (-73.9719729323923 40.7668318394546) | 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 | |||||||
1407 | 1407 | -73.9704778551644 | 40.7783119113627 | 15D-AM-1007-05 | 15D | AM | 10072018 | 5 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9704778551644 40.7783119113627) | 19 | 4 | 19 | 13 | |||||||||
1607 | 1607 | -73.9770508584979 | 40.7710769301257 | 6C-AM-1007-02 | 06C | AM | 10072018 | 2 | Adult | + | Above Ground | 15 | false | false | true | false | false | pulling things off branches | false | false | false | false | false | false | false | false | POINT (-73.9770508584979 40.7710769301257) | 19 | 4 | 19 | 13 | ||||||
1654 | 1654 | -73.9766342125035 | 40.7715437147052 | 6C-AM-1007-08 | 06C | AM | 10072018 | 8 | Adult | + | Above Ground | 35 | false | false | true | false | false | dropping acorns | false | false | false | false | false | false | false | false | POINT (-73.9766342125035 40.7715437147052) | 19 | 4 | 19 | 13 | ||||||
1688 | 1688 | -73.9677593344667 | 40.7763054313195 | 15G-PM-1019-07 | 15G | PM | 10192018 | 7 | Adult | + | Above Ground | 5 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9677593344667 40.7763054313195) | 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 | ||||||
2388 | 2388 | -73.9604476047877 | 40.7938014328732 | 35C-AM-1007-03 | 35C | AM | 10072018 | 3 | Adult | + | Above Ground | 40 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9604476047877 40.7938014328732) | 19 | 4 | 19 | 13 | |||||||
2392 | 2392 | -73.9578981223015 | 40.7989967754358 | 41B-AM-1010-03 | 41B | AM | 10102018 | 3 | Adult | + | Above Ground | 60 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9578981223015 40.7989967754358) | 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 | ||||||||
42 | 42 | -73.9579564338627 | 40.7959337795027 | 38C-PM-1014-09 | 38C | PM | 10142018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9579564338627 40.7959337795027) | 19 | 4 | 19 | 13 | ||||||
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 | ||||||
227 | 227 | -73.9598155300913 | 40.7905887826983 | 32E-AM-1007-10 | 32E | AM | 10072018 | 10 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9598155300913 40.7905887826983) | 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 | ||||||
369 | 369 | -73.9596398997228 | 40.7933386953847 | 34D-PM-1007-02 | 34D | PM | 10072018 | 2 | Adult | Black | Black+ | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | cautiously aware | POINT (-73.9596398997228 40.7933386953847) | 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 | ||||||
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 | |||||
721 | 721 | -73.9718262034469 | 40.7666771797442 | 4I-PM-1007-02 | 04I | PM | 10072018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9718262034469 40.7666771797442) | 19 | 4 | 19 | 13 | ||||||
755 | 755 | -73.9579941847434 | 40.7991216713328 | 41B-PM-1014-02 | 41B | PM | 10142018 | 2 | Adult | Black | Black+ | Above Ground | 28 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9579941847434 40.7991216713328) | 19 | 4 | 19 | 13 | ||||||
872 | 872 | -73.9551524422379 | 40.7910535596756 | 34H-PM-1006-01 | 34H | PM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9551524422379 40.7910535596756) | 19 | 4 | 19 | 13 | ||||||
1101 | 1101 | -73.95912925497 | 40.7925530280455 | 34D-AM-1008-01 | 34D | AM | 10082018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | staring at us | POINT (-73.95912925497001 40.7925530280455) | 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 | ||||||
1267 | 1267 | -73.9701010964667 | 40.7688919314508 | 6I-PM-1013-02 | 06I | PM | 10132018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | Bushes | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9701010964667 40.76889193145081) | 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 | ||||||
1887 | 1887 | -73.9586184232889 | 40.7993153832942 | 41A-PM-1007-02 | 41A | PM | 10072018 | 2 | Adult | Black | Black+ | Above Ground | 15 | false | false | true | false | false | jumping | false | false | false | false | false | false | false | false | stared at me | POINT (-73.9586184232889 40.7993153832942) | 19 | 4 | 19 | 13 | ||||
1938 | 1938 | -73.9719879697272 | 40.7725625124591 | 9F-AM-1013-02 | 09F | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9719879697272 40.7725625124591) | 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 | ||||||
2150 | 2150 | -73.9557710118271 | 40.7919161185557 | 34G-PM-1006-01 | 34G | PM | 10062018 | 1 | Adult | Black | Black+ | Skinny, thin tail | Ground Plane | FALSE | false | false | false | false | false | digging | false | false | false | false | false | false | false | false | POINT (-73.9557710118271 40.7919161185557) | 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 | ||||||
2284 | 2284 | -73.9730181306326 | 40.7794601322427 | 16A-AM-1013-02 | 16A | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9730181306326 40.7794601322427) | 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 | ||||||
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 | ||||||
2413 | 2413 | -73.959701727877 | 40.790660026971 | 32E-AM-1007-03 | 32E | AM | 10072018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.959701727877 40.790660026971) | 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 | |||||
2535 | 2535 | -73.9700101107283 | 40.7696729501144 | 7I-PM-1013-08 | 07I | PM | 10132018 | 8 | Adult | Black | Black+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.9700101107283 40.7696729501144) | 19 | 4 | 19 | 13 | ||||||
2557 | 2557 | -73.9712454251679 | 40.7674262749891 | 5I-PM-1008-02 | 05I | PM | 10082018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | crossing pavement in front of arsenal | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9712454251679 40.7674262749891) | 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 | ||||||
210 | 210 | -73.9711298491132 | 40.7676902603543 | 5I-PM-1008-01 | 05I | PM | 10082018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 15 | in tree by arsenal - climbing | false | false | true | true | false | false | false | false | true | false | false | false | false | POINT (-73.9711298491132 40.7676902603543) | 19 | 4 | 19 | 13 | ||||
430 | 430 | -73.9710116801402 | 40.7723689301989 | 10G-PM-1017-08 | 10G | PM | 10172018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9710116801402 40.7723689301989) | 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 | |||||
1057 | 1057 | -73.9594406225891 | 40.7918533707789 | 33D-AM-1017-02 | 33D | AM | 10172018 | 2 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | true | false | false | POINT (-73.9594406225891 40.7918533707789) | 19 | 4 | 19 | 13 | |||||
1741 | 1741 | -73.9736995552241 | 40.7722712518637 | 8E-PM-1008-02 | 08E | PM | 10082018 | 2 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 10 | in tree | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9736995552241 40.7722712518637) | 19 | 4 | 19 | 13 | ||||
1892 | 1892 | -73.9745908987975 | 40.7655191512308 | 1G-AM-1006-03 | 01G | AM | 10062018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9745908987975 40.7655191512308) | 19 | 4 | 19 | 13 | |||||
2159 | 2159 | -73.9696688162449 | 40.7741422177187 | 12F-AM-1020-05 | 12F | AM | 10202018 | 5 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.9696688162449 40.7741422177187) | 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 | |||
391 | 391 | -73.9790875480358 | 40.7676104780657 | 2C-AM-1010-03 | 02C | AM | 10102018 | 3 | Adult | Black | Gray | Black+Gray | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9790875480358 40.7676104780657) | 19 | 4 | 19 | 13 | |||||
1296 | 1296 | -73.9705509170542 | 40.7689416540228 | 6I-PM-1013-04 | 06I | PM | 10132018 | 4 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Grass | false | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.9705509170542 40.7689416540228) | 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 | |||||
2496 | 2496 | -73.9696274291417 | 40.7691980808067 | 7I-PM-1013-03 | 07I | PM | 10132018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Trash bins | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9696274291417 40.7691980808067) | 19 | 4 | 19 | 13 | ||||
2651 | 2651 | -73.9632993246327 | 40.7888199519656 | 29C-AM-1007-05 | 29C | AM | 10072018 | 5 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9632993246327 40.7888199519656) | 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 | ||||||
79 | 79 | -73.9610705592868 | 40.7914829661051 | 32D-AM-1013-06 | 32D | AM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | true | true | eating (a mushroom),circles around us,really fat,scratching himself,grooming activity | false | false | false | false | true | true | false | false | POINT (-73.9610705592868 40.7914829661051) | 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 | ||||
120 | 120 | -73.9511118711108 | 40.7950813345902 | 40I-AM-1018-01 | 40I | AM | 10182018 | 1 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | begging | false | false | false | false | false | false | false | false | POINT (-73.9511118711108 40.7950813345902) | 19 | 4 | 19 | 13 | |||||
125 | 125 | -73.9651601541795 | 40.7761841788025 | 15I-PM-1012-07 | 15I | PM | 10122018 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9651601541795 40.7761841788025) | 19 | 4 | 19 | 13 | ||||||
320 | 320 | -73.9684376038582 | 40.7824275067237 | 20C-PM-1018-09 | 20C | PM | 10182018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9684376038582 40.7824275067237) | 19 | 4 | 19 | 13 | ||||||
412 | 412 | -73.9785675798034 | 40.7672992405289 | 1C-PM-1013-05 | 01C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9785675798034 40.7672992405289) | 19 | 4 | 19 | 13 | ||||||
461 | 461 | -73.9648195433192 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | staring | false | false | false | false | true | false | false | false | POINT (-73.9648195433192 40.7796399955868) | 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 | ||||||
850 | 850 | -73.9642288873015 | 40.7820439983567 | 22F-AM-1007-06 | 22F | AM | 10072018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9642288873015 40.7820439983567) | 19 | 4 | 19 | 13 | ||||||
1038 | 1038 | -73.9563311167069 | 40.7950901563337 | 38E-AM-1010-12 | 38E | AM | 10102018 | 12 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | running on rocks | false | true | false | false | false | false | false | false | true | false | false | false | false | runs toward something | POINT (-73.9563311167069 40.7950901563337) | 19 | 4 | 19 | 13 | ||||
1138 | 1138 | -73.9594357049738 | 40.7840678890949 | 25I-AM-1012-01 | 25I | AM | 10122018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | on bar | false | false | false | true | false | false | false | false | true | true | true | false | false | POINT (-73.9594357049738 40.7840678890949) | 19 | 4 | 19 | 13 | |||||
1260 | 1260 | -73.9811585807616 | 40.768706748732 | 2A-AM-1010-06 | 02A | AM | 10102018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | true | false | false | false | chasing #5 | false | false | false | false | false | false | false | false | POINT (-73.9811585807616 40.768706748732) | 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 | |||||
1369 | 1369 | -73.9702717260829 | 40.768951107763 | 6I-PM-1013-03 | 06I | PM | 10132018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Flowers, grass | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9702717260829 40.768951107763) | 19 | 4 | 19 | 13 | |||||
1379 | 1379 | -73.9796470494747 | 40.7678370925485 | 1C-PM-1013-08 | 01C | PM | 10132018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9796470494747 40.7678370925485) | 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 | ||||||
1763 | 1763 | -73.9768286349595 | 40.7687012827059 | 3D-PM-1010-05 | 03D | PM | 10102018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9768286349595 40.7687012827059) | 19 | 4 | 19 | 13 | ||||||
2165 | 2165 | -73.9794371709817 | 40.768387910254 | 2B-PM-1013-07 | 02B | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9794371709817 40.768387910254) | 19 | 4 | 19 | 13 | ||||||
2205 | 2205 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 10122018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8 | on turn, see map | true | true | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9594986107981 40.7840083040604) | 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 | |||
2464 | 2464 | -73.9691318044969 | 40.7709801974696 | 9I-AM-1014-05 | 09I | AM | 10142018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9691318044969 40.7709801974696) | 19 | 4 | 19 | 13 | ||||||
2554 | 2554 | -73.9701505245419 | 40.768998364571 | 6I-PM-1013-07 | 06I | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 11 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9701505245419 40.768998364571004) | 19 | 4 | 19 | 13 | ||||||
677 | 677 | -73.9799155966086 | 40.7698034314993 | 3A-PM-1017-08 | 03A | PM | 10172018 | 8 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9799155966086 40.7698034314993) | 19 | 4 | 19 | 13 | |||||
2453 | 2453 | -73.9756105226696 | 40.7696531972655 | 5D-AM-1020-03 | 05D | AM | 10202018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9756105226696 40.7696531972655) | 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 | |||||
19 | 19 | -73.9768603630674 | 40.7702795904962 | 5C-PM-1010-09 | 05C | PM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9768603630674 40.7702795904962) | 19 | 4 | 19 | 13 | |||||
214 | 214 | -73.9772576561244 | 40.7679895093963 | 3D-AM-1006-08 | 03D | AM | 10062018 | 8 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | approaches (food stand) | POINT (-73.9772576561244 40.7679895093963) | 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 | |||
298 | 298 | -73.957342596188 | 40.7944359654227 | 37E-PM-1006-09 | 37E | PM | 10062018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | false | moseying | false | false | false | false | true | true | false | false | POINT (-73.957342596188 40.7944359654227) | 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 |
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 );