This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3022 | 3022 | -73.9639941227864 | 40.7899152327912 | 29B-PM-1010-02 | 29B | PM | 10102018 | 2 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9639941227864 40.7899152327912) | 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 | |||||
3009 | 3009 | -73.9675637870968 | 40.7823880671728 | 21D-PM-1008-02 | 21D | PM | 10082018 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9675637870968 40.7823880671728) | 19 | 4 | 19 | 13 | ||||||
3006 | 3006 | -73.9744390217386 | 40.7663168362582 | 2G-AM-1010-02 | 02G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9744390217386 40.7663168362582) | 19 | 4 | 19 | 13 | ||||||
2982 | 2982 | -73.9513477815203 | 40.7945259614138 | 39I-PM-1013-02 | 39I | PM | 10132018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | along the road | false | true | true | false | false | playing | false | false | false | false | false | false | false | false | POINT (-73.9513477815203 40.7945259614138) | 19 | 4 | 19 | 13 | ||||
2979 | 2979 | -73.9571808775915 | 40.7934443866725 | 35E-AM-1020-02 | 35E | AM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | false | false | false | false | false | cleaning herself | false | false | false | false | false | false | true | false | POINT (-73.9571808775915 40.7934443866725) | 19 | 4 | 19 | 13 | ||||
2968 | 2968 | -73.9587236619579 | 40.7991850180434 | 40A-AM-1010-02 | 40A | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park at 108th West | true | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9587236619579 40.7991850180434) | 19 | 4 | 19 | 13 | ||||
2955 | 2955 | -73.9711666523376 | 40.7761513057034 | 13D-AM-1014-02 | 13D | AM | 10142018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9711666523376 40.7761513057034) | 19 | 4 | 19 | 13 | ||||||
2949 | 2949 | -73.9651206201297 | 40.7785279064847 | 18G-AM-1014-02 | 18G | AM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9651206201297 40.7785279064847) | 19 | 4 | 19 | 13 | |||||
2916 | 2916 | -73.9517525111679 | 40.7974407641075 | 42G-PM-1014-02 | 42G | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 14 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9517525111679 40.7974407641075) | 19 | 4 | 19 | 13 | |||||
2915 | 2915 | -73.9734630412566 | 40.7653097139415 | 1H-PM-1013-02 | 01H | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9734630412566 40.7653097139415) | 19 | 4 | 19 | 13 | |||||
2908 | 2908 | -73.9654288151266 | 40.7815953970174 | 21E-AM-1017-02 | 21E | AM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 7 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9654288151266 40.7815953970174) | 19 | 4 | 19 | 13 | ||||||
2893 | 2893 | -73.9793101482654 | 40.7692600238491 | 3B-PM-1007-02 | 03B | PM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | in tree | false | false | false | false | false | chased by dog | false | false | false | false | false | false | false | false | POINT (-73.9793101482654 40.7692600238491) | 19 | 4 | 19 | 13 | ||||
2887 | 2887 | -73.964593167562 | 40.7780374890066 | 18H-PM-1014-02 | 18H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.964593167562 40.7780374890066) | 19 | 4 | 19 | 13 | |||||
2886 | 2886 | -73.9729265300533 | 40.7741768291642 | 10D-AM-1008-02 | 10D | AM | 10082018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9729265300533 40.7741768291642) | 19 | 4 | 19 | 13 | |||||
2885 | 2885 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9530811255728 40.79830691185791) | 19 | 4 | 19 | 13 | |||||
2881 | 2881 | -73.9541629063295 | 40.7934259301577 | 37G-AM-1014-02 | 37G | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | ran away & disappeared | false | false | false | false | false | false | false | false | POINT (-73.9541629063295 40.7934259301577) | 19 | 4 | 19 | 13 | |||||
2870 | 2870 | -73.9538475741188 | 40.796479421955 | 40F-PM-1006-02 | 40F | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9538475741188 40.796479421955) | 19 | 4 | 19 | 13 | |||||
2857 | 2857 | -73.9649230271173 | 40.7821766215675 | 22F-PM-1014-02 | 22F | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9649230271173 40.7821766215675) | 19 | 4 | 19 | 13 | |||||
2846 | 2846 | -73.9661570478029 | 40.7807271518813 | 20E-AM-1014-02 | 20E | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9661570478029 40.7807271518813) | 19 | 4 | 19 | 13 | |||||
2838 | 2838 | -73.9507699667119 | 40.7955166039555 | 40I-AM-1018-02 | 40I | AM | 10182018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9507699667119 40.795516603955505) | 19 | 4 | 19 | 13 | ||||||
2834 | 2834 | -73.9651132904127 | 40.7905384124102 | 29A-PM-1019-02 | 29A | PM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9651132904127 40.7905384124102) | 19 | 4 | 19 | 13 | |||||
2830 | 2830 | -73.9556083695689 | 40.7965223709493 | 39E-AM-1018-02 | 39E | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9556083695689 40.7965223709493) | 19 | 4 | 19 | 13 | ||||||
2829 | 2829 | -73.9565230963554 | 40.798556387711 | 41C-PM-1007-02 | 41C | PM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565230963554 40.798556387711) | 19 | 4 | 19 | 13 | |||||
2819 | 2819 | -73.9550350096938 | 40.797694218705 | 41E-PM-1013-02 | 41E | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9550350096938 40.797694218705004) | 19 | 4 | 19 | 13 | |||||
2818 | 2818 | -73.9681664642028 | 40.7724669681958 | 11I-PM-1012-02 | 11I | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 4 | true | false | true | false | true | false | false | false | false | false | false | false | true | runs away from the ball | POINT (-73.9681664642028 40.7724669681958) | 19 | 4 | 19 | 13 | |||||
2813 | 2813 | -73.9659118189359 | 40.7765739928504 | 15H-AM-1013-02 | 15H | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9659118189359 40.7765739928504) | 19 | 4 | 19 | 13 | ||||||
2808 | 2808 | -73.9765027953575 | 40.7717327360835 | 7C-AM-1012-02 | 07C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | hopping around | false | false | false | false | false | false | true | false | POINT (-73.9765027953575 40.7717327360835) | 19 | 4 | 19 | 13 | ||||
2807 | 2807 | -73.9618213644671 | 40.7927648819738 | 33B-AM-1010-02 | 33B | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96182136446711 40.7927648819738) | 19 | 4 | 19 | 13 | ||||||
2806 | 2806 | -73.9714298880357 | 40.77410578689 | 11E-PM-1012-02 | 11E | PM | 10122018 | 2 | 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.9714298880357 40.77410578689) | 19 | 4 | 19 | 13 | |||||
2796 | 2796 | -73.9631089011412 | 40.789191946875 | 29C-PM-1006-02 | 29C | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9631089011412 40.789191946875) | 19 | 4 | 19 | 13 | |||||
2793 | 2793 | -73.9742847552668 | 40.7731740123046 | 9D-AM-1008-02 | 09D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9742847552668 40.7731740123046) | 19 | 4 | 19 | 13 | ||||||
2791 | 2791 | -73.9593624259363 | 40.7905522356793 | 32E-AM-1007-02 | 32E | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9593624259363 40.7905522356793) | 19 | 4 | 19 | 13 | ||||||
2785 | 2785 | -73.9729105002306 | 40.7672758037086 | 4H-PM-1006-02 | 04H | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9729105002306 40.7672758037086) | 19 | 4 | 19 | 13 | |||||
2783 | 2783 | -73.9791767156268 | 40.7714445258765 | 5A-AM-1006-02 | 05A | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | in tall shrubs near wall next to CPW | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9791767156268 40.7714445258765) | 19 | 4 | 19 | 13 | ||||
2762 | 2762 | -73.9656324462902 | 40.7834034753081 | 22E-PM-1014-02 | 22E | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | true | false | false | POINT (-73.9656324462902 40.7834034753081) | 19 | 4 | 19 | 13 | ||||||
2717 | 2717 | -73.9632238528617 | 40.7920328991252 | 32B-PM-1010-02 | 32B | PM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9632238528617 40.7920328991252) | 19 | 4 | 19 | 13 | ||||||
2705 | 2705 | -73.9748962681637 | 40.76787782717 | 4F-PM-1013-02 | 04F | PM | 10132018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9748962681637 40.76787782717) | 19 | 4 | 19 | 13 | |||||
2699 | 2699 | -73.9743509423821 | 40.7690043677328 | 5F-AM-1007-02 | 05F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.97435094238212 40.7690043677328) | 19 | 4 | 19 | 13 | |||||
2698 | 2698 | -73.9744917362668 | 40.77783887377 | 13A-AM-1017-02 | 13A | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744917362668 40.77783887377) | 19 | 4 | 19 | 13 | ||||||
2689 | 2689 | -73.9704121989487 | 40.7824040236981 | 19A-PM-1013-02 | 19A | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Looks very brown, not like English red squirrels | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9704121989487 40.7824040236981) | 19 | 4 | 19 | 13 | ||||
2688 | 2688 | -73.9799302952205 | 40.7677207209798 | 1B-PM-1019-02 | 01B | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9799302952205 40.7677207209798) | 19 | 4 | 19 | 13 | |||||
2681 | 2681 | -73.968807163616 | 40.7812018159499 | 19C-PM-1018-02 | 19C | PM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.968807163616 40.7812018159499) | 19 | 4 | 19 | 13 | |||||
2677 | 2677 | -73.97348276186 | 40.7656171832911 | 2H-PM-1006-02 | 02H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.97348276186 40.7656171832911) | 19 | 4 | 19 | 13 | ||||||
2675 | 2675 | -73.9762227323096 | 40.768453603768 | 3E-PM-1008-02 | 03E | PM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9762227323096 40.768453603768) | 19 | 4 | 19 | 13 | |||||
2663 | 2663 | -73.9613429184974 | 40.7912158057267 | 32C-AM-1014-02 | 32C | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9613429184974 40.7912158057267) | 19 | 4 | 19 | 13 | ||||||
2643 | 2643 | -73.9693719015914 | 40.7768710160557 | 14E-PM-1017-02 | 14E | PM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | staring | false | false | false | false | false | false | false | false | POINT (-73.9693719015914 40.7768710160557) | 19 | 4 | 19 | 13 | ||||
2639 | 2639 | -73.9543832609857 | 40.7953550639701 | 39F-AM-1014-02 | 39F | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | rocks | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9543832609857 40.7953550639701) | 19 | 4 | 19 | 13 | ||||
2632 | 2632 | -73.950827557335 | 40.797579073666 | 42H-PM-1014-02 | 42H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | Running along stone ledge | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.950827557335 40.797579073666) | 18 | 4 | 36 | 18 | |||||
2626 | 2626 | -73.9737329655838 | 40.7726424441344 | 8D-PM-1007-02 | 08D | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9737329655838 40.7726424441344) | 19 | 4 | 19 | 13 | |||||
2622 | 2622 | -73.9697159562944 | 40.7730671417653 | 11G-PM-1013-02 | 11G | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Near Summerstage | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9697159562944 40.7730671417653) | 19 | 4 | 19 | 13 | ||||
2616 | 2616 | -73.9675917702187 | 40.7789922281625 | 17E-AM-1017-02 | 17E | AM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 8 | Shore | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9675917702187 40.7789922281625) | 19 | 4 | 19 | 13 | |||||
2615 | 2615 | -73.9734605176646 | 40.7686218881386 | 5G-PM-1010-02 | 05G | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9734605176646 40.7686218881386) | 19 | 4 | 19 | 13 | |||||
2611 | 2611 | -73.951448051873 | 40.7973951649254 | 42G-AM-1018-02 | 42G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.951448051873 40.7973951649254) | 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 | |||||
2594 | 2594 | -73.9638812060405 | 40.7923714941429 | 32A-PM-1013-02 | 32A | PM | 10132018 | 2 | ? | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9638812060405 40.792371494142905) | 19 | 4 | 19 | 13 | |||||
2584 | 2584 | -73.9727187453699 | 40.7669595710626 | 3H-AM-1008-02 | 03H | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9727187453699 40.7669595710626) | 19 | 4 | 19 | 13 | |||||||
2578 | 2578 | -73.9765386965371 | 40.766371971273 | 1F-AM-1010-02 | 01F | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9765386965371 40.766371971273) | 19 | 4 | 19 | 13 | ||||||
2564 | 2564 | -73.970996228532 | 40.7715540712285 | 9G-PM-1007-02 | 09G | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.970996228532 40.7715540712285) | 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 | |||||
2551 | 2551 | -73.970138810251 | 40.770579297644 | 8H-PM-1014-02 | 08H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | froze & watched me,then went back to eating | POINT (-73.970138810251 40.770579297644) | 19 | 4 | 19 | 13 | ||||
2543 | 2543 | -73.9691424997919 | 40.780542852496 | 18C-AM-1018-02 | 18C | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691424997919 40.780542852496) | 19 | 4 | 19 | 13 | |||||
2525 | 2525 | -73.9612352611518 | 40.7944813634744 | 35B-AM-1010-02 | 35B | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | landscaped area | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9612352611518 40.7944813634744) | 19 | 4 | 19 | 13 | ||||
2516 | 2516 | -73.9649823687651 | 40.7763395359636 | 16I-AM-1008-02 | 16I | AM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9649823687651 40.7763395359636) | 19 | 4 | 19 | 13 | |||||
2512 | 2512 | -73.974275954985 | 40.7754723879307 | 11B-AM-1007-02 | 11B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.974275954985 40.7754723879307) | 19 | 4 | 19 | 13 | ||||||
2510 | 2510 | -73.9748635473782 | 40.7742591029151 | 10C-AM-1018-02 | 10C | AM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | sitting in the sun | false | false | false | false | false | false | true | false | POINT (-73.9748635473782 40.7742591029151) | 19 | 4 | 19 | 13 | ||||
2509 | 2509 | -73.9714295102249 | 40.776954371947 | 14D-PM-1019-02 | 14D | PM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9714295102249 40.776954371947) | 19 | 4 | 19 | 13 | ||||||
2504 | 2504 | -73.9550131837533 | 40.7958617258176 | 39E-PM-1013-02 | 39E | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail & butt | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | true | false | POINT (-73.9550131837533 40.7958617258176) | 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 | |||||||
2500 | 2500 | -73.9689703880705 | 40.7712025611298 | 9I-PM-1010-02 | 09I | PM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | standard coloration | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.96897038807052 40.7712025611298) | 19 | 4 | 19 | 13 | ||||
2498 | 2498 | -73.9674556940019 | 40.7875399402461 | 26A-AM-1014-02 | 26A | AM | 10142018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | could not get close due to fences | POINT (-73.9674556940019 40.7875399402461) | 19 | 4 | 19 | 13 | |||||
2481 | 2481 | -73.9719068478565 | 40.7789062312585 | 15B-AM-1014-02 | 15B | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | false | false | grooming,scratching | false | false | false | false | false | false | true | false | POINT (-73.9719068478565 40.7789062312585) | 19 | 4 | 19 | 13 | ||||
2474 | 2474 | -73.9721448879766 | 40.7762112840981 | 13C-AM-1010-02 | 13C | AM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 7 | false | false | true | false | false | burying | false | false | false | false | false | false | true | false | POINT (-73.9721448879766 40.7762112840981) | 19 | 4 | 19 | 13 | ||||
2473 | 2473 | -73.9613347295946 | 40.7938900965153 | 34B-AM-1013-02 | 34B | AM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9613347295946 40.7938900965153) | 19 | 4 | 19 | 13 | |||||
2470 | 2470 | -73.96388775887 | 40.7915477304252 | 31A-AM-1010-02 | 31A | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | scratching | false | false | false | false | false | false | true | false | POINT (-73.96388775887 40.7915477304252) | 19 | 4 | 19 | 13 | |||||
2458 | 2458 | -73.969517504176 | 40.7820741344297 | 20B-PM-1013-02 | 20B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.969517504176 40.7820741344297) | 19 | 4 | 19 | 13 | |||||
2457 | 2457 | -73.9569896638974 | 40.7911914507504 | 33G-PM-1006-02 | 33G | PM | 10062018 | 2 | Adult | Gray | Gray+ | my favorite | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | engaged w/ me | POINT (-73.9569896638974 40.7911914507504) | 19 | 4 | 19 | 13 | ||||
2448 | 2448 | -73.9668230576555 | 40.7870637233327 | 25B-PM-1007-02 | 25B | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9668230576555 40.7870637233327) | 19 | 4 | 19 | 13 | |||||
2444 | 2444 | -73.966590487009 | 40.7802469052891 | 19E-PM-1018-02 | 19E | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.96659048700901 40.7802469052891) | 19 | 4 | 19 | 13 | |||||
2432 | 2432 | -73.9657203199746 | 40.775173008911 | 14I-PM-1018-02 | 14I | PM | 10182018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9657203199746 40.775173008911) | 19 | 4 | 19 | 13 | |||||
2426 | 2426 | -73.9790203973636 | 40.7688837114832 | 3B-AM-1010-02 | 03B | AM | 10102018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | together w/ #3 | false | false | false | false | false | false | false | true | POINT (-73.9790203973636 40.7688837114832) | 19 | 4 | 19 | 13 | ||||
2421 | 2421 | -73.9682278905989 | 40.7733027508057 | 11H-PM-1013-02 | 11H | PM | 10132018 | 2 | Adult | Gray | Black | Gray+Black | Above Ground | 10 | false | false | false | false | false | digging | false | false | false | false | false | false | true | false | POINT (-73.9682278905989 40.7733027508057) | 19 | 4 | 19 | 13 | ||||
2405 | 2405 | -73.9588361742943 | 40.791115225155 | 33E-PM-1012-02 | 33E | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9588361742943 40.791115225155) | 19 | 4 | 19 | 13 | |||||
2400 | 2400 | -73.9768268467857 | 40.7714608041933 | 6B-PM-1017-02 | 06B | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9768268467857 40.7714608041933) | 19 | 4 | 19 | 13 | |||||
2398 | 2398 | -73.958713848373 | 40.7963918051751 | 38C-PM-1014-02 | 38C | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.958713848373 40.7963918051751) | 19 | 4 | 19 | 13 | |||||
2394 | 2394 | -73.9785829546046 | 40.7719652299132 | 6A-PM-1012-02 | 06A | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9785829546046 40.7719652299132) | 19 | 4 | 19 | 13 | |||||
2391 | 2391 | -73.9721497679014 | 40.7716160199386 | 8F-PM-1012-02 | 08F | PM | 10122018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9721497679014 40.7716160199386) | 19 | 4 | 19 | 13 | ||||||
2380 | 2380 | -73.9761375729505 | 40.7662231892125 | 1F-PM-1019-02 | 01F | PM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9761375729505 40.7662231892125) | 19 | 4 | 19 | 13 | |||||
2368 | 2368 | -73.9731925179247 | 40.7748962746181 | 11D-PM-1006-02 | 11D | PM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9731925179247 40.7748962746181) | 19 | 4 | 19 | 13 | |||||
2364 | 2364 | -73.9587183039085 | 40.7909209137969 | 32E-PM-1017-02 | 32E | PM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9587183039085 40.7909209137969) | 19 | 4 | 19 | 13 | ||||||
2361 | 2361 | -73.9708032298419 | 40.7784265674544 | 15C-AM-1010-02 | 15C | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | nest building | false | false | false | false | false | false | true | false | POINT (-73.9708032298419 40.77842656745441) | 19 | 4 | 19 | 13 | |||||
2356 | 2356 | -73.9611355303487 | 40.793069353224 | 34C-AM-1007-02 | 34C | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611355303487 40.793069353224) | 19 | 4 | 19 | 13 | ||||||
2352 | 2352 | -73.9727310397798 | 40.7787016773517 | 15B-PM-1017-02 | 15B | PM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | tree | false | false | true | true | true | digging,chewing on tree—has nut in mouth! | false | false | false | false | false | false | false | true | POINT (-73.97273103977982 40.7787016773517) | 19 | 4 | 19 | 13 | |||
2347 | 2347 | -73.9663124560664 | 40.779544003786 | 18F-PM-1008-02 | 18F | PM | 10082018 | 2 | Adult | Gray | Gray+ | false | false | false | false | false | hopping around | false | false | false | false | false | false | false | true | POINT (-73.9663124560664 40.779544003786) | 19 | 4 | 19 | 13 | |||||||
2337 | 2337 | -73.9673490137465 | 40.7782728130401 | 17F-PM-1020-02 | 17F | PM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9673490137465 40.7782728130401) | 19 | 4 | 19 | 13 | |||||
2318 | 2318 | -73.967458693983 | 40.7769922522105 | 15G-AM-1008-02 | 15G | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967458693983 40.7769922522105) | 19 | 4 | 19 | 13 | ||||||
2307 | 2307 | -73.9736997033862 | 40.778497952406 | 14A-PM-1014-02 | 14A | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9736997033862 40.778497952406) | 19 | 4 | 19 | 13 | |||||
2300 | 2300 | -73.9789251806378 | 40.7699558513225 | 4B-AM-1010-02 | 04B | AM | 10102018 | 2 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 30 | false | false | true | true | true | true | false | false | false | false | false | true | false | POINT (-73.9789251806378 40.7699558513225) | 19 | 4 | 19 | 13 | |||||
2298 | 2298 | -73.9755371849972 | 40.7733561233828 | 9C-PM-1006-02 | 09C | PM | 10062018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9755371849972 40.7733561233828) | 19 | 4 | 19 | 13 | |||||
2296 | 2296 | -73.965596981561 | 40.7797738845824 | 19F-PM-1017-02 | 19F | PM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.965596981561 40.7797738845824) | 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 );