This data as json, CSV (advanced)
Suggested facets: Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Running, Chasing, Eating, Foraging, Kuks, Quaas, Moans, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39 | 39 | -73.9716147061553 | 40.7813911036179 | 18A-PM-1018-01 | 18A | PM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9716147061553 40.7813911036179) | 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 | |||||
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 | |||||||
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 | |||
135 | 135 | -73.9694168118643 | 40.7728877377977 | 11G-PM-1013-01 | 11G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | In the Woods/Brush | false | false | true | false | true | false | false | false | false | false | false | false | true | watching me | POINT (-73.9694168118643 40.7728877377977) | 19 | 4 | 19 | 13 | |||
197 | 197 | -73.9679336341793 | 40.7754186579647 | 14G-PM-1013-01 | 14G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | watching | POINT (-73.9679336341793 40.7754186579647) | 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 | ||||
236 | 236 | -73.9737266070919 | 40.7786338379896 | 14A-PM-1014-01 | 14A | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9737266070919 40.7786338379896) | 19 | 4 | 19 | 13 | |||||
286 | 286 | -73.9720907384613 | 40.7762987836055 | 13C-PM-1019-01 | 13C | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 7 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.9720907384613 40.7762987836055) | 19 | 4 | 19 | 13 | ||||||
288 | 288 | -73.9731113265165 | 40.7786640676355 | 15A-PM-1017-01 | 15A | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | false | false | true | true | false | eating in tree | false | false | false | false | false | false | true | false | POINT (-73.9731113265165 40.7786640676355) | 19 | 4 | 19 | 13 | ||||
294 | 294 | -73.9756573579063 | 40.7656644063024 | 1G-PM-1010-01 | 01G | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | true | false | false | false | false | true | false | false | true | false | too busy eating in his tree | POINT (-73.9756573579063 40.7656644063024) | 19 | 4 | 19 | 13 | ||||
321 | 321 | -73.9694288806212 | 40.7842952265291 | 22A-PM-1017-01 | 22A | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9694288806212 40.7842952265291) | 19 | 4 | 19 | 13 | ||||||
401 | 401 | -73.965862100991 | 40.7825926896917 | 22D-PM-1012-01 | 22D | PM | 10122018 | 1 | Adult | Gray | Black, White | Gray+Black, White | Above Ground | 5 | false | false | true | false | false | true | false | false | false | false | false | false | false | climbing tree | POINT (-73.965862100991 40.7825926896917) | 19 | 4 | 19 | 13 | ||||
457 | 457 | -73.965848283831 | 40.7797243033057 | 19F-PM-1017-01 | 19F | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.965848283831 40.7797243033057) | 19 | 4 | 19 | 13 | |||||
462 | 462 | -73.9661785940531 | 40.7742569936186 | 13I-PM-1008-01 | 13I | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | climbed tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9661785940531 40.7742569936186) | 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 | |||||
643 | 643 | -73.976730206737 | 40.773709213914 | 8A-PM-1014-01 | 08A | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | true | false | false | false | false | false | false | true | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | 19 | 4 | 19 | 13 | ||||
690 | 690 | -73.9767949141123 | 40.774454583585 | 9A-PM-1010-01 | 09A | PM | 10102018 | 1 | Adult | + | Ground Plane | FALSE | by large tree in sectioned off area | false | false | true | false | false | i think it climbed the tree when i first saw it. | false | false | false | false | false | false | true | false | POINT (-73.9767949141123 40.774454583585) | 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 | ||||||
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 | |||||
782 | 782 | -73.9710559113762 | 40.7794279914209 | 16C-PM-1018-01 | 16C | PM | 10182018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | false | disappeared up other side of tree | POINT (-73.9710559113762 40.7794279914209) | 19 | 4 | 19 | 13 | ||||
789 | 789 | -73.9675023138703 | 40.7872554700995 | 25A-PM-1007-01 | 25A | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 40 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9675023138703 40.7872554700995) | 19 | 4 | 19 | 13 | ||||
833 | 833 | -73.9741846413977 | 40.7762518164182 | 12B-PM-1018-01 | 12B | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Climbing up rocks | false | false | true | false | true | climbing (up rocks) | false | false | false | false | false | false | false | true | POINT (-73.9741846413977 40.7762518164182) | 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 | |||||
844 | 844 | -73.9642379942652 | 40.7774792520738 | 17I-PM-1017-01 | 17I | PM | 10172018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | was in a tree,so i couldn't really tell | POINT (-73.9642379942652 40.7774792520738) | 19 | 4 | 19 | 13 | ||||
865 | 865 | -73.9741621946917 | 40.7752481472025 | 11C-PM-1018-01 | 11C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9741621946917 40.7752481472025) | 19 | 4 | 19 | 13 | |||||
931 | 931 | -73.9785948413883 | 40.7718908026758 | 6A-PM-1012-01 | 06A | PM | 10122018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9785948413883 40.7718908026758) | 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 | ||||
984 | 984 | -73.9672950266018 | 40.7782477517567 | 17F-PM-1020-01 | 17F | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9672950266018 40.7782477517567) | 19 | 4 | 19 | 13 | |||||
1051 | 1051 | -73.9613747032702 | 40.7920483852431 | 33C-PM-1007-01 | 33C | PM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9613747032702 40.792048385243106) | 19 | 4 | 19 | 13 | ||||||
1055 | 1055 | -73.9632337134707 | 40.7914682370734 | 31B-PM-1007-01 | 31B | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | true | false | false | chasing #2 and climbing tree w/ #2 | false | false | false | false | false | false | false | true | POINT (-73.9632337134707 40.7914682370734) | 19 | 4 | 19 | 13 | ||||
1206 | 1206 | -73.9748709206354 | 40.77608025411 | 11B-PM-1014-01 | 11B | PM | 10142018 | 1 | Adult | Gray | Gray+ | Fat! | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9748709206354 40.77608025411) | 19 | 4 | 19 | 13 | |||||
1225 | 1225 | -73.9584803513939 | 40.7933802077327 | 35D-PM-1013-01 | 35D | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 12 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9584803513939 40.7933802077327) | 19 | 4 | 19 | 13 | |||||
1315 | 1315 | -73.9595955824812 | 40.7933047943534 | 34D-PM-1007-01 | 34D | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | false | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9595955824812 40.7933047943534) | 19 | 4 | 19 | 13 | |||||
1331 | 1331 | -73.9588809150045 | 40.7847231576181 | 26I-PM-1010-01 | 26I | PM | 10102018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9588809150045 40.7847231576181) | 19 | 4 | 19 | 13 | |||||
1357 | 1357 | -73.9631350020634 | 40.791907210332 | 32B-PM-1010-01 | 32B | PM | 10102018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 25 | in tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9631350020634 40.791907210332) | 19 | 4 | 19 | 13 | |||||
1503 | 1503 | -73.9732193290631 | 40.7748791447746 | 11D-PM-1006-01 | 11D | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9732193290631 40.7748791447746) | 19 | 4 | 19 | 13 | |||||
1581 | 1581 | -73.97157754108 | 40.7776249963967 | 14C-PM-1006-01 | 14C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.97157754108 40.7776249963967) | 19 | 4 | 19 | 13 | |||||
1609 | 1609 | -73.9639024988123 | 40.7776953065849 | 18I-PM-1007-01 | 18I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | false | false | true | true | true | hanging upside down | false | false | false | false | false | false | true | false | POINT (-73.9639024988123 40.7776953065849) | 19 | 4 | 19 | 13 | ||||
1641 | 1641 | -73.9653135277149 | 40.7817434070169 | 21E-PM-1012-01 | 21E | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9653135277149 40.7817434070169) | 19 | 4 | 19 | 13 | |||||
1667 | 1667 | -73.9645989003589 | 40.7782157459155 | 18H-PM-1014-01 | 18H | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9645989003589 40.7782157459155) | 19 | 4 | 19 | 13 | |||||
1683 | 1683 | -73.9790889008147 | 40.7676402781925 | 1C-PM-1013-01 | 01C | PM | 10132018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | true | false | false | POINT (-73.9790889008147 40.7676402781925) | 19 | 4 | 19 | 13 | |||||
1727 | 1727 | -73.9692472299565 | 40.7722592187215 | 10H-PM-1007-01 | 10H | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | dark gray | Above Ground | 15 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9692472299565 40.7722592187215) | 19 | 4 | 19 | 13 | |||
1825 | 1825 | -73.9624209799704 | 40.7910200972752 | 31C-PM-1010-01 | 31C | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9624209799704 40.7910200972752) | 19 | 4 | 19 | 13 | |||||
1837 | 1837 | -73.9710288101006 | 40.7715777109992 | 9G-PM-1007-01 | 09G | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | climbing (down tree) | false | false | false | false | false | false | false | false | POINT (-73.9710288101006 40.7715777109992) | 19 | 4 | 19 | 13 | |||||
1857 | 1857 | -73.9728797531377 | 40.7786733148687 | 15B-PM-1017-01 | 15B | PM | 10172018 | 1 | Gray | Gray+ | Above Ground | 20 | in tree | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9728797531377 40.7786733148687) | 19 | 4 | 19 | 13 | ||||||
1918 | 1918 | -73.9632866142841 | 40.7890043294436 | 29C-PM-1006-01 | 29C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | false | not too shy | POINT (-73.96328661428412 40.78900432944361) | 19 | 4 | 19 | 13 | ||||
1974 | 1974 | -73.9772420734509 | 40.7730025191407 | 7A-PM-1007-01 | 07A | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9772420734509 40.7730025191407) | 19 | 4 | 19 | 13 | ||||||
1976 | 1976 | -73.9770920860805 | 40.7694698040083 | 4C-PM-1010-01 | 04C | PM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | true | false | false | false | true | false | false | false | false | true | false | POINT (-73.9770920860805 40.7694698040083) | 19 | 4 | 19 | 13 | |||||
2009 | 2009 | -73.9639505810228 | 40.789573183584 | 29B-PM-1010-01 | 29B | PM | 10102018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 4 | climbing trees | false | false | true | true | true | scratching self | false | false | false | false | true | false | true | false | POINT (-73.9639505810228 40.789573183584) | 19 | 4 | 19 | 13 | |||
2016 | 2016 | -73.9589492240754 | 40.798901118974 | 40A-PM-1014-01 | 40A | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | false | false | false | false | true | false | true | false | stared & then went back up tree—then ran to different tree | POINT (-73.9589492240754 40.798901118974) | 19 | 4 | 19 | 13 | ||||
2054 | 2054 | -73.9726381234747 | 40.7752694815985 | 12D-PM-1014-01 | 12D | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9726381234747 40.7752694815985) | 19 | 4 | 19 | 13 | |||||
2118 | 2118 | -73.958369699409 | 40.7902456668332 | 32F-PM-1008-01 | 32F | PM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.958369699409 40.7902456668332) | 19 | 4 | 19 | 13 | ||||||
2251 | 2251 | -73.9587678566254 | 40.7962656030995 | 38C-PM-1014-01 | 38C | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9587678566254 40.7962656030995) | 19 | 4 | 19 | 13 | |||||
2423 | 2423 | -73.973552877209 | 40.7715638228207 | 7E-PM-1013-01 | 07E | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | true | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.973552877209 40.7715638228207) | 19 | 4 | 19 | 13 | ||||
2436 | 2436 | -73.95827701417 | 40.7856610238891 | 28I-PM-1007-01 | 28I | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.95827701417 40.7856610238891) | 19 | 4 | 19 | 13 | ||||||
2443 | 2443 | -73.9667073186959 | 40.7840581361598 | 23C-PM-1014-01 | 23C | PM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.96670731869591 40.7840581361598) | 19 | 4 | 19 | 13 | ||||||
2463 | 2463 | -73.9653343572865 | 40.7775286924617 | 17H-PM-1007-01 | 17H | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | true | false | false | false | false | true | false | false | false | true | POINT (-73.9653343572865 40.7775286924617) | 19 | 4 | 19 | 13 | |||||
2497 | 2497 | -73.9622050752008 | 40.7886373772305 | 29D-PM-1010-01 | 29D | PM | 10102018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9622050752008 40.7886373772305) | 19 | 4 | 19 | 13 | |||||
2508 | 2508 | -73.979381450452 | 40.7709033697887 | 4A-PM-1007-01 | 04A | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | true | true | false | false | false | false | true | false | true | false | POINT (-73.979381450452 40.770903369788705) | 19 | 4 | 19 | 13 | |||||
2517 | 2517 | -73.9710221361528 | 40.7724939691584 | 10F-PM-1019-01 | 10F | PM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Above Ground | 2 | Behind fence, tree trunk | false | false | true | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9710221361528 40.7724939691584) | 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 | |||||
2561 | 2561 | -73.9591513028486 | 40.7835978067328 | 25I-PM-1007-01 | 25I | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9591513028486 40.7835978067328) | 19 | 4 | 19 | 13 | ||||||
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 | |||||
2700 | 2700 | -73.9601988871514 | 40.7943473161329 | 35C-PM-1013-01 | 35C | PM | 10132018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | true | true | true | false | true | true | false | true | false | POINT (-73.9601988871514 40.7943473161329) | 19 | 4 | 19 | 13 | ||||||
2724 | 2724 | -73.9611434082667 | 40.7893671772846 | 30E-PM-1008-01 | 30E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | true | false | false | false | false | false | false | POINT (-73.9611434082667 40.7893671772846) | 19 | 4 | 19 | 13 | |||||
2794 | 2794 | -73.9712187890707 | 40.7750640173134 | 12E-PM-1018-01 | 12E | PM | 10182018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | true | false | false | true | false | false | true | false | false | false | true | POINT (-73.9712187890707 40.7750640173134) | 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 | ||||
2864 | 2864 | -73.9761879300037 | 40.7683918970301 | 3E-PM-1008-01 | 03E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9761879300037 40.7683918970301) | 19 | 4 | 19 | 13 | ||||||
2874 | 2874 | -73.9597453664295 | 40.7891382153733 | 30F-PM-1007-01 | 30F | PM | 10072018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 1 | tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9597453664295 40.7891382153733) | 19 | 4 | 19 | 13 | ||||
2942 | 2942 | -73.9672063784809 | 40.7826070395665 | 21D-PM-1008-01 | 21D | PM | 10082018 | 1 | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | true | false | false | POINT (-73.9672063784809 40.7826070395665) | 19 | 4 | 19 | 13 | |||||||
2956 | 2956 | -73.9654741695628 | 40.7890427851106 | 28B-PM-1010-01 | 28B | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9654741695628 40.7890427851106) | 19 | 4 | 19 | 13 | ||||
2973 | 2973 | -73.9766693184436 | 40.7708879215854 | 6C-PM-1020-01 | 06C | PM | 10202018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Across Transverse | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9766693184436 40.7708879215854) | 19 | 4 | 19 | 13 | ||||
935 | 935 | -73.9666195118963 | 40.7839216739357 | 22C-PM-1006-10 | 22C | PM | 10062018 | 10 | Adult | Gray | Gray+ | Above Ground | 13 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9666195118963 40.78392167393571) | 19 | 4 | 19 | 13 | ||||||
2153 | 2153 | -73.9797122322834 | 40.7678347587435 | 1B-PM-1019-10 | 01B | PM | 10192018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | Dog chased up tree | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.97971223228342 40.7678347587435) | 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 | ||||
2335 | 2335 | -73.9704679459444 | 40.7773384236212 | 14D-PM-1019-10 | 14D | PM | 10192018 | 10 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9704679459444 40.7773384236212) | 19 | 4 | 19 | 13 | ||||||
2965 | 2965 | -73.9767389132988 | 40.7689323691424 | 4D-PM-1008-10 | 04D | PM | 10082018 | 10 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 6 | climbed the fence & posed for a picture | false | false | true | false | true | false | false | false | false | false | true | false | false | POINT (-73.9767389132988 40.7689323691424) | 19 | 4 | 19 | 13 | ||||
126 | 126 | -73.9792155473689 | 40.7693711799946 | 3B-PM-1007-11 | 03B | PM | 10072018 | 11 | Adult | Gray | Gray+ | Above Ground | 5 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9792155473689 40.7693711799946) | 19 | 4 | 19 | 13 | |||||
366 | 366 | -73.9673548527075 | 40.7765669058396 | 15G-PM-1019-11 | 15G | PM | 10192018 | 11 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared | POINT (-73.9673548527075 40.7765669058396) | 19 | 4 | 19 | 13 | |||||
625 | 625 | -73.9764235373322 | 40.770606513989 | 5C-PM-1010-11 | 05C | PM | 10102018 | 11 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.97642353733221 40.770606513989) | 19 | 4 | 19 | 13 | |||||
1596 | 1596 | -73.9666945123922 | 40.7839956493194 | 22C-PM-1006-11 | 22C | PM | 10062018 | 11 | Juvenile | Gray | Gray+ | Above Ground | 13 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9666945123922 40.7839956493194) | 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 | ||||
1787 | 1787 | -73.9720365327715 | 40.7762329714016 | 13D-PM-1018-11 | 13D | PM | 10182018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | true | false | false | false | false | false | true | false | true | false | POINT (-73.9720365327715 40.7762329714016) | 19 | 4 | 19 | 13 | |||||
2868 | 2868 | -73.9653873284496 | 40.7804699882574 | 20F-PM-1007-11 | 20F | PM | 10072018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 10 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9653873284496 40.7804699882574) | 19 | 4 | 19 | 13 | ||||
981 | 981 | -73.9673160165357 | 40.7766158001202 | 15G-PM-1019-12 | 15G | PM | 10192018 | 12 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared | POINT (-73.9673160165357 40.7766158001202) | 19 | 4 | 19 | 13 | |||||
2730 | 2730 | -73.9653575758687 | 40.7805339953372 | 20F-PM-1007-12 | 20F | PM | 10072018 | 12 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.9653575758687 40.7805339953372) | 19 | 4 | 19 | 13 | ||||
111 | 111 | -73.9763243383771 | 40.7705409315703 | 5C-PM-1010-13 | 05C | PM | 10102018 | 13 | Adult | Gray | White | Gray+White | Above Ground | 20 | way up a tree! | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9763243383771 40.7705409315703) | 19 | 4 | 19 | 13 | ||||
2927 | 2927 | -73.9650120066074 | 40.7805932882407 | 20F-PM-1007-13 | 20F | PM | 10072018 | 13 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9650120066074 40.78059328824071) | 19 | 4 | 19 | 13 | |||||
2187 | 2187 | -73.9699134052609 | 40.774446589038 | 12F-PM-1007-14 | 12F | PM | 10072018 | 14 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | true | true | false | POINT (-73.9699134052609 40.774446589038) | 19 | 4 | 19 | 13 | |||||
2822 | 2822 | -73.9711120079542 | 40.7760801911766 | 13D-PM-1018-14 | 13D | PM | 10182018 | 14 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | true | false | false | climbing (down) | false | false | false | false | false | false | true | false | POINT (-73.9711120079542 40.7760801911766) | 19 | 4 | 19 | 13 | ||||
2574 | 2574 | -73.978199543688 | 40.7695660563362 | 4C-PM-1010-17 | 04C | PM | 10102018 | 17 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | climbed up tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.978199543688 40.7695660563362) | 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 | |||||
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 | |||||
262 | 262 | -73.9712876234172 | 40.7695885530701 | 7H-PM-1006-02 | 07H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 25 | tree | true | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9712876234172 40.7695885530701) | 19 | 4 | 19 | 13 | |||||
359 | 359 | -73.9716404781264 | 40.7753181851766 | 12D-PM-1014-02 | 12D | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | seems to be grinding teeth on a piece of material (sounds from grinding) | false | false | false | false | false | false | true | false | POINT (-73.9716404781264 40.7753181851766) | 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 | |||||
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 | |||
505 | 505 | -73.9677387336667 | 40.7742695912 | 12H-PM-1007-02 | 12H | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | in tree | false | false | true | true | false | peanuts | false | false | false | false | false | false | true | false | POINT (-73.9677387336667 40.7742695912) | 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 |
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 );