This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Location, Running, Chasing, Foraging, Kuks, Quaas, Tail twitches, Approaches, Indifferent, Runs from
Combination of Primary and Highlight Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2696 | 2696 | -73.9501457233643 | 40.797094356558 | 42I-PM-1014-01 | 42I | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9501457233643 40.797094356558) | 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 | ||||
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 | |||||
601 | 601 | -73.9522291603405 | 40.7976985385835 | 42G-PM-1014-01 | 42G | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 8 | false | false | true | false | true | false | false | true | false | false | false | false | true | POINT (-73.9522291603405 40.7976985385835) | 19 | 4 | 19 | 13 | |||||
525 | 525 | -73.952526164386 | 40.7963759240504 | 40G-AM-1007-02 | 40G | AM | 10072018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 18 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.952526164386 40.7963759240504) | 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 | ||||
1253 | 1253 | -73.9527227282134 | 40.7935061484064 | 37I-AM-1010-03 | 37I | AM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527227282134 40.7935061484064) | 19 | 4 | 19 | 13 | ||||
1227 | 1227 | -73.9527924755398 | 40.7934366260533 | 37I-AM-1010-04 | 37I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Above Ground | 50 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527924755398 40.7934366260533) | 19 | 4 | 19 | 13 | |||||
300 | 300 | -73.9528149779809 | 40.7924984810637 | 36I-AM-1017-06 | 36I | AM | 10172018 | 6 | Adult | Gray | Black | Gray+Black | Darker than others | Above Ground | 10 | Running down tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9528149779809 40.7924984810637) | 19 | 4 | 19 | 13 | |||
1464 | 1464 | -73.9532074573139 | 40.7934669464908 | 37H-PM-1006-06 | 37H | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | tree | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9532074573139 40.7934669464908) | 19 | 4 | 19 | 13 | ||||
861 | 861 | -73.953287300494 | 40.793520326789 | 37H-PM-1006-04 | 37H | PM | 10062018 | 4 | + | Above Ground | 43 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.953287300494 40.793520326789) | 19 | 4 | 19 | 13 | |||||||
1931 | 1931 | -73.9533085932603 | 40.7934877861075 | 37H-PM-1006-03 | 37H | PM | 10062018 | 3 | + | Above Ground | 43 | tree | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9533085932603 40.7934877861075) | 19 | 4 | 19 | 13 | |||||||
1304 | 1304 | -73.9533319519277 | 40.7933647909449 | 37H-AM-1018-02 | 37H | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | Large tree by (fence of the conservatory) about to climb up | false | false | true | false | false | false | false | false | false | false | false | false | false | busy,ready to climb | POINT (-73.9533319519277 40.7933647909449) | 19 | 4 | 19 | 13 | |||||
504 | 504 | -73.9533476020736 | 40.7933003544685 | 37H-PM-1006-02 | 37H | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | tree | true | false | true | false | true | true | false | false | false | false | false | false | true | dogs | POINT (-73.9533476020736 40.7933003544685) | 19 | 4 | 19 | 13 | |||
942 | 942 | -73.9533923917973 | 40.7961701874769 | 40G-AM-1007-01 | 40G | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | large tree | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9533923917973 40.7961701874769) | 19 | 4 | 19 | 13 | ||||
1422 | 1422 | -73.9537356145842 | 40.7917273773486 | 35I-PM-1006-02 | 35I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9537356145842 40.7917273773486) | 19 | 4 | 19 | 13 | ||||||
2252 | 2252 | -73.9537703231359 | 40.7915959393814 | 35I-AM-1013-01 | 35I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | White underbelly | Above Ground | 18 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9537703231359 40.7915959393814) | 19 | 4 | 19 | 13 | ||||
2069 | 2069 | -73.9538377039825 | 40.7980605334961 | 42E-PM-1012-03 | 42E | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | false | false | true | false | true | true | false | false | false | false | false | true | false | POINT (-73.9538377039825 40.7980605334961) | 19 | 4 | 19 | 13 | ||||
1522 | 1522 | -73.9538970554532 | 40.7955196793479 | 39G-PM-1013-03 | 39G | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9538970554532 40.7955196793479) | 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 | ||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | true | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
1882 | 1882 | -73.9541601469123 | 40.7907832744689 | 34I-PM-1010-04 | 34I | PM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | across the lawn and climb up a small tree | true | false | true | false | false | grooming | false | false | false | false | false | false | false | false | POINT (-73.9541601469123 40.79078327446891) | 19 | 4 | 19 | 13 | ||||
1924 | 1924 | -73.9542332505231 | 40.7933475171434 | 37G-AM-1014-01 | 37G | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | White tail | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9542332505231 40.7933475171434) | 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 | ||||
1608 | 1608 | -73.9545425520879 | 40.7956853415959 | 39F-PM-1006-04 | 39F | PM | 10062018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 35 | in tree | false | false | true | false | false | climbing down | false | false | false | false | false | false | false | true | ran when saw me | POINT (-73.9545425520879 40.7956853415959) | 19 | 4 | 19 | 13 | ||
1324 | 1324 | -73.954554245377 | 40.7983935730557 | 41E-AM-1007-05 | 41E | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | man/pit bull mix wandered | POINT (-73.954554245377 40.7983935730557) | 19 | 4 | 19 | 13 | ||||
1483 | 1483 | -73.9545773579075 | 40.7898684635744 | 33I-AM-1008-05 | 33I | AM | 10082018 | 5 | Adult | + | Above Ground | 100 | false | false | true | false | true | false | false | false | false | false | false | true | false | nearly dropped shell on my head! | POINT (-73.9545773579075 40.7898684635744) | 19 | 4 | 19 | 13 | ||||||
1820 | 1820 | -73.9546337446865 | 40.7898772579576 | 33I-PM-1006-08 | 33I | PM | 10062018 | 8 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9546337446865 40.7898772579576) | 19 | 4 | 19 | 13 | ||||||
1993 | 1993 | -73.9546367558712 | 40.789840987798 | 33I-AM-1008-04 | 33I | AM | 10082018 | 4 | Adult | + | Above Ground | 100 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9546367558712 40.789840987798) | 19 | 4 | 19 | 13 | |||||||
2258 | 2258 | -73.9547785081171 | 40.789612183711 | 33I-AM-1008-02 | 33I | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | edge of park @ 98th | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9547785081171 40.789612183711) | 19 | 4 | 19 | 13 | |||||
953 | 953 | -73.9547959269955 | 40.7925162926273 | 36H-PM-1008-01 | 36H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | white belly | Above Ground | 20 | true | false | true | false | true | true | true | false | false | false | false | true | false | POINT (-73.9547959269955 40.7925162926273) | 19 | 4 | 19 | 13 | ||||
496 | 496 | -73.9548430741605 | 40.798207350942 | 41E-AM-1007-06 | 41E | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | tree | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9548430741605 40.798207350942) | 19 | 4 | 19 | 13 | |||||
1951 | 1951 | -73.9548431601579 | 40.7906346271566 | 34I-PM-1010-02 | 34I | PM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9548431601579 40.7906346271566) | 19 | 4 | 19 | 13 | ||||||
1394 | 1394 | -73.95488263914 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 10142018 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2 | up/down tree | true | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.95488263914 40.7959474571251) | 19 | 4 | 19 | 13 | |||||
1022 | 1022 | -73.9548853492712 | 40.7984783584388 | 41D-PM-1014-04 | 41D | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | jumping tree to tree | false | false | false | false | false | false | false | false | POINT (-73.9548853492712 40.7984783584388) | 19 | 4 | 19 | 13 | ||||
631 | 631 | -73.9548877830136 | 40.7950157489103 | 38F-AM-1018-04 | 38F | AM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.95488778301362 40.7950157489103) | 19 | 4 | 19 | 13 | |||||
1999 | 1999 | -73.9549860947234 | 40.7911550328309 | 34H-PM-1006-07 | 34H | PM | 10062018 | 7 | Juvenile | Gray | White | Gray+White | white belly | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9549860947234 40.7911550328309) | 19 | 4 | 19 | 13 | ||||
279 | 279 | -73.9550082056509 | 40.7894521543449 | 33I-AM-1008-03 | 33I | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | 98th @ edge of park | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9550082056509 40.7894521543449) | 19 | 4 | 19 | 13 | |||||
1017 | 1017 | -73.9552035011902 | 40.7889851896334 | 32I-AM-1013-06 | 32I | AM | 10132018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552035011902 40.7889851896334) | 19 | 4 | 19 | 13 | ||||
2851 | 2851 | -73.955208233231 | 40.7890574331084 | 32I-PM-1007-02 | 32I | PM | 10072018 | 2 | Adult | + | Above Ground | 30 | false | false | true | false | false | different sound - happy,playful chirps | false | false | false | false | true | false | true | false | POINT (-73.955208233231 40.7890574331084) | 19 | 4 | 19 | 13 | ||||||
1301 | 1301 | -73.9552146665714 | 40.7892909102377 | 32I-PM-1007-03 | 32I | PM | 10072018 | 3 | Adult | Gray | Gray+ | small adult | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9552146665714 40.7892909102377) | 19 | 4 | 19 | 13 | |||||
2833 | 2833 | -73.9552595564798 | 40.7889533029466 | 32I-PM-1007-01 | 32I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | true | true | chirps | false | false | false | false | true | false | true | false | POINT (-73.9552595564798 40.7889533029466) | 19 | 4 | 19 | 13 | ||||
261 | 261 | -73.9552861155228 | 40.788973931872 | 32I-AM-1013-05 | 32I | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552861155228 40.788973931872) | 19 | 4 | 19 | 13 | ||||
2195 | 2195 | -73.955352152771 | 40.7988549523022 | 42D-AM-1014-01 | 42D | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | false | false | true | true | false | true | false | false | false | false | false | true | false | POINT (-73.955352152771 40.7988549523022) | 19 | 4 | 19 | 13 | |||||
649 | 649 | -73.9554891003543 | 40.7968774599654 | 40E-AM-1014-03 | 40E | AM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9554891003543 40.79687745996541) | 19 | 4 | 19 | 13 | |||||
781 | 781 | -73.955516031113 | 40.7923188156277 | 35G-AM-1007-01 | 35G | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.955516031113 40.7923188156277) | 19 | 4 | 19 | 13 | |||||
2262 | 2262 | -73.9556177490335 | 40.7888569161537 | 32I-AM-1013-03 | 32I | AM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | watching me from tree - curious | POINT (-73.9556177490335 40.7888569161537) | 19 | 4 | 19 | 13 | ||||
374 | 374 | -73.9556817958407 | 40.788852000621 | 32I-AM-1013-02 | 32I | AM | 10132018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | watching me from tree - curious | POINT (-73.9556817958407 40.788852000621) | 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 | |||||
1972 | 1972 | -73.9558370309765 | 40.7921977208472 | 35G-AM-1007-02 | 35G | AM | 10072018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9558370309765 40.7921977208472) | 19 | 4 | 19 | 13 | |||||
639 | 639 | -73.9558589529608 | 40.7892400394941 | 32H-PM-1006-02 | 32H | PM | 10062018 | 2 | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9558589529608 40.7892400394941) | 19 | 4 | 19 | 13 | |||||||
1273 | 1273 | -73.9558943880051 | 40.7971535141896 | 40D-PM-1013-06 | 40D | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9558943880051 40.7971535141896) | 19 | 4 | 19 | 13 | |||||
2569 | 2569 | -73.9559663734409 | 40.7945828261377 | 37F-AM-1010-01 | 37F | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | false | false | false | false | false | true | false | false | true | false | POINT (-73.9559663734409 40.7945828261377) | 19 | 4 | 19 | 13 | |||||
2179 | 2179 | -73.9559663949511 | 40.7974497269789 | 40D-AM-1013-07 | 40D | AM | 10132018 | 7 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | true | false | false | false | false | false | false | false | true | curious | POINT (-73.9559663949511 40.7974497269789) | 19 | 4 | 19 | 13 | |||||
1449 | 1449 | -73.9561124892063 | 40.7949440648632 | 37E-AM-1013-04 | 37E | AM | 10132018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | false | false | true | true | false | true | false | false | false | false | false | false | true | POINT (-73.9561124892063 40.7949440648632) | 19 | 4 | 19 | 13 | |||||
2934 | 2934 | -73.9561669236168 | 40.7994737431277 | 42C-PM-1013-04 | 42C | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.9561669236168 40.7994737431277) | 19 | 4 | 19 | 13 | ||||||
916 | 916 | -73.9561887624471 | 40.7958187455815 | 38E-AM-1010-04 | 38E | AM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | false | false | true | me | POINT (-73.95618876244711 40.7958187455815) | 19 | 4 | 19 | 13 | ||||
1776 | 1776 | -73.9562350820255 | 40.7913464147989 | 34G-PM-1006-02 | 34G | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | true | eating bread it found on ground | false | false | false | false | false | false | false | true | POINT (-73.9562350820255 40.7913464147989) | 19 | 4 | 19 | 13 | |||||
1280 | 1280 | -73.9562469727195 | 40.79685907654 | 39D-AM-1008-04 | 39D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562469727195 40.79685907654) | 19 | 4 | 19 | 13 | ||||||
754 | 754 | -73.9563203089105 | 40.7906275357726 | 33G-PM-1006-01 | 33G | PM | 10062018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9563203089105 40.7906275357726) | 19 | 4 | 19 | 13 | ||||||
665 | 665 | -73.9563661256875 | 40.7966823114508 | 39D-AM-1008-03 | 39D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9563661256875 40.7966823114508) | 19 | 4 | 19 | 13 | ||||||
680 | 680 | -73.9564011421122 | 40.7958097849369 | 38E-AM-1010-02 | 38E | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | climbs | POINT (-73.95640114211221 40.7958097849369) | 19 | 4 | 19 | 13 | ||||
147 | 147 | -73.9564023626619 | 40.7905423546155 | 33G-AM-1013-02 | 33G | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | shelter in hole in tree | false | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9564023626619 40.7905423546155) | 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 | |||||
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 | |||||
2242 | 2242 | -73.9565824187667 | 40.797312050952 | 40D-AM-1013-06 | 40D | AM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | true | false | true | false | true | true | false | false | false | true | false | false | true | POINT (-73.9565824187667 40.797312050952) | 19 | 4 | 19 | 13 | |||||
91 | 91 | -73.9565905868276 | 40.7895654068546 | 32H-PM-1006-01 | 32H | PM | 10062018 | 1 | Gray | Gray+ | Above Ground | in the European Beech | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565905868276 40.7895654068546) | 19 | 4 | 19 | 13 | |||||||
773 | 773 | -73.9566189145352 | 40.7883417969746 | 31H-PM-1008-01 | 31H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9566189145352 40.7883417969746) | 19 | 4 | 19 | 13 | |||||
2232 | 2232 | -73.9566277721581 | 40.7966674587803 | 39D-PM-1012-04 | 39D | PM | 10122018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | on tree trunk (descending from height of ~10 ft) | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.95662777215811 40.7966674587803) | 19 | 4 | 19 | 13 | ||||
2720 | 2720 | -73.9566300789162 | 40.7993692120774 | 42C-PM-1013-06 | 42C | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Between park and main drag | false | false | true | true | false | false | false | false | false | false | false | true | true | POINT (-73.9566300789162 40.7993692120774) | 19 | 4 | 19 | 13 | ||||
354 | 354 | -73.9566751022336 | 40.799035789744 | 41C-PM-1007-04 | 41C | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 65 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9566751022336 40.799035789744) | 19 | 4 | 19 | 13 | |||||
1589 | 1589 | -73.9567062023419 | 40.797482865196 | 40C-PM-1006-02 | 40C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9567062023419 40.797482865196) | 19 | 4 | 19 | 13 | ||||||
1886 | 1886 | -73.956806913988 | 40.7987736900857 | 41C-AM-1017-06 | 41C | AM | 10172018 | 6 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.956806913988 40.7987736900857) | 19 | 4 | 19 | 13 | ||||||
2847 | 2847 | -73.9568378330302 | 40.7880317802766 | 30I-PM-1006-04 | 30I | PM | 10062018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9568378330302 40.7880317802766) | 19 | 4 | 19 | 13 | |||||
1697 | 1697 | -73.9568610943394 | 40.7935959584643 | 36E-PM-1012-02 | 36E | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 28 | on tree branch | false | false | true | false | true | picking acorns off oak tree | false | false | false | false | false | false | true | false | POINT (-73.95686109433942 40.7935959584643) | 19 | 4 | 19 | 13 | ||||
2090 | 2090 | -73.9569759970802 | 40.7931497452294 | 35F-PM-1012-03 | 35F | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 7 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9569759970802 40.79314974522941) | 19 | 4 | 19 | 13 | |||||
415 | 415 | -73.9570131890379 | 40.7991786736124 | 41B-PM-1014-05 | 41B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | true | false | false | false | false | false | true | true | POINT (-73.9570131890379 40.7991786736124) | 19 | 4 | 19 | 13 | ||||||
920 | 920 | -73.9571233640232 | 40.7992458980266 | 41B-PM-1014-04 | 41B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | false | false | climbing | POINT (-73.9571233640232 40.7992458980266) | 19 | 4 | 19 | 13 | ||||
1988 | 1988 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | true | true | true | false | false | chasing (#4),digging | false | false | false | false | true | false | true | false | POINT (-73.957138794884 40.7985389822719) | 19 | 4 | 19 | 13 | ||||||
116 | 116 | -73.9572093760529 | 40.7988487300216 | 41B-AM-1010-06 | 41B | AM | 10102018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9572093760529 40.7988487300216) | 19 | 4 | 19 | 13 | |||||
2559 | 2559 | -73.9572383478774 | 40.7876857380722 | 30H-PM-1006-01 | 30H | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9572383478774 40.7876857380722) | 19 | 4 | 19 | 13 | |||||
2690 | 2690 | -73.9572840457971 | 40.7886933371744 | 31H-PM-1008-04 | 31H | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | Also way up | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.95728404579711 40.7886933371744) | 19 | 4 | 19 | 13 | ||||||
1987 | 1987 | -73.9573692542155 | 40.7989252908321 | 41B-PM-1014-03 | 41B | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 28 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9573692542155 40.7989252908321) | 19 | 4 | 19 | 13 | |||||
1433 | 1433 | -73.9574077497624 | 40.8001185184892 | 42B-AM-1014-01 | 42B | AM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9574077497624 40.8001185184892) | 19 | 4 | 19 | 13 | ||||||
2015 | 2015 | -73.9574365550758 | 40.7886924675052 | 31H-PM-1008-03 | 31H | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | no clue, way up a tree! | false | false | true | false | true | throwing down acorns | false | false | false | false | false | false | false | false | POINT (-73.9574365550758 40.7886924675052) | 19 | 4 | 19 | 13 | |||||
43 | 43 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 10082018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9574648097543 40.78925084286221) | 19 | 4 | 19 | 13 | |||||
1592 | 1592 | -73.9575517912392 | 40.7889158268192 | 31H-PM-1008-05 | 31H | PM | 10082018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9575517912392 40.7889158268192) | 19 | 4 | 19 | 13 | ||||||
102 | 102 | -73.9575986161364 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Climbing tree | false | false | true | false | false | climbing (tree) | false | false | false | false | false | false | false | true | POINT (-73.9575986161364 40.799368134968) | 19 | 4 | 19 | 13 | |||
2804 | 2804 | -73.9576094432477 | 40.7965342664074 | 38C-PM-1014-07 | 38C | PM | 10142018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9576094432477 40.7965342664074) | 19 | 4 | 19 | 13 | |||||
1591 | 1591 | -73.9576223390082 | 40.7979746639647 | 40B-AM-1019-04 | 40B | AM | 10192018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | true | true | false | POINT (-73.9576223390082 40.79797466396471) | 19 | 4 | 19 | 13 | |||||
71 | 71 | -73.9576245992455 | 40.7873862510001 | 29H-PM-1006-01 | 29H | PM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9576245992455 40.7873862510001) | 19 | 4 | 19 | 13 | |||||
156 | 156 | -73.9576589997493 | 40.7972751877447 | 39C-PM-1006-02 | 39C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | unaware of | POINT (-73.95765899974931 40.7972751877447) | 19 | 4 | 19 | 13 | |||||
2803 | 2803 | -73.9576652087316 | 40.7875457977801 | 29H-PM-1006-02 | 29H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9576652087316 40.7875457977801) | 19 | 4 | 19 | 13 | ||||||
2288 | 2288 | -73.9577009571427 | 40.796126044521 | 38C-PM-1014-10 | 38C | PM | 10142018 | 10 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | false | false | true | true | true | climbing (down from ~10') | false | false | false | false | false | false | false | true | POINT (-73.9577009571427 40.796126044521) | 19 | 4 | 19 | 13 | ||||
2455 | 2455 | -73.9577297187155 | 40.799225295679 | 41B-AM-1010-08 | 41B | AM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 20 | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9577297187155 40.799225295679) | 19 | 4 | 19 | 13 | |||||
2844 | 2844 | -73.9578840941242 | 40.7955586232429 | 37D-PM-1014-06 | 37D | PM | 10142018 | 6 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9578840941242 40.7955586232429) | 19 | 4 | 19 | 13 | ||||||
923 | 923 | -73.9578924882613 | 40.789806297824 | 32G-AM-1010-02 | 32G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | false | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9578924882613 40.789806297824) | 19 | 4 | 19 | 13 | ||||||
45 | 45 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9579645940414 40.7918613498407) | 19 | 4 | 19 | 13 | |||||
2441 | 2441 | -73.9579865329778 | 40.794906535675 | 37D-PM-1014-03 | 37D | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9579865329778 40.794906535675) | 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 |
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 );