Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Primary_Fur_Color, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Climbing, Eating, Foraging, Kuks, Moans, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Other_Interactions, Community_Districts, City_Council_Districts, Police_Precincts
Highlight_Fur_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 | Latlong | Zip_Codes | Community_Districts | Borough_Boundaries | City_Council_Districts | Police_Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23 | 23 | -73.9540652304705 | 40.7955226178199 | 39G-PM-1013-05 | 39G | PM | 1013 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9540652304705 40.7955226178199) | 19 | 4 | 19 | 13 | |||||
29 | 29 | -73.97142951022491 | 40.776954371947 | 14D-PM-1019-02 | 14D | PM | 1019 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9714295102249 40.776954371947) | 19 | 4 | 19 | 13 | ||||||
36 | 36 | -73.9664120826015 | 40.7888022709721 | 27A-AM-1008-01 | 27A | AM | 1008 | 1 | Adult | Gray | Gray+ | Above Ground | 3.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9664120826015 40.7888022709721) | 19 | 4 | 19 | 13 | ||||||
53 | 53 | -73.9573656523498 | 40.7979754563974 | 40C-AM-1017-01 | 40C | AM | 1017 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#2) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9573656523498 40.7979754563974) | 19 | 4 | 19 | 13 | |||||
77 | 77 | -73.9532952763106 | 40.792007446262204 | 36I-AM-1017-08 | 36I | AM | 1017 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#7) | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | runs from (me) | POINT (-73.9532952763106 40.7920074462622) | 19 | 4 | 19 | 13 | ||||
125 | 125 | -73.963911430308 | 40.7809127228847 | 21G-AM-1014-05 | 21G | AM | 1014 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4.0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.963911430308 40.7809127228847) | 19 | 4 | 19 | 13 | |||||
159 | 159 | -73.9632337134707 | 40.791468237073396 | 31B-PM-1007-01 | 31B | PM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 0 | 1 | 1 | 0 | 0 | chasing #2 and climbing tree w/ #2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9632337134707 40.7914682370734) | 19 | 4 | 19 | 13 | ||||
185 | 185 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 1012 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8.0 | on turn, see map | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
228 | 228 | -73.9667474482967 | 40.7760643720793 | 15H-PM-1008-01 | 15H | PM | 1008 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | Oak tree | 0 | 1 | 0 | 0 | 0 | watching me | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | observant | POINT (-73.9667474482967 40.7760643720793) | 19 | 4 | 19 | 13 | ||
241 | 241 | -73.9808202088503 | 40.7682921842325 | 1A-PM-1014-02 | 01A | PM | 1014 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9808202088503 40.7682921842325) | 19 | 4 | 19 | 13 | |||||
346 | 346 | -73.9562105506291 | 40.796699119790894 | 39D-AM-1008-02 | 39D | AM | 1008 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9562105506291 40.7966991197909) | 19 | 4 | 19 | 13 | ||||||
373 | 373 | -73.9583688637255 | 40.791388958496 | 33E-PM-1012-08 | 33E | PM | 1012 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9583688637255 40.791388958496) | 19 | 4 | 19 | 13 | |||||
399 | 399 | -73.9651828383592 | 40.780282094386294 | 19F-PM-1017-06 | 19F | PM | 1017 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9651828383592 40.7802820943863) | 19 | 4 | 19 | 13 | |||||
456 | 456 | -73.9503533343658 | 40.7976543603953 | 42H-PM-1014-04 | 42H | PM | 1014 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9503533343658 40.7976543603953) | 12,423 | 18 | 4 | 36 | 18 | ||||
459 | 459 | -73.9701010964667 | 40.768891931450796 | 6I-PM-1013-02 | 06I | PM | 1013 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | Bushes | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9701010964667 40.7688919314508) | 19 | 4 | 19 | 13 | |||||
472 | 472 | -73.9597845469964 | 40.790617930344794 | 32E-AM-1007-11 | 32E | AM | 1007 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9597845469964 40.7906179303448) | 19 | 4 | 19 | 13 | ||||||
483 | 483 | -73.9574809028248 | 40.7950013620207 | 37D-PM-1014-04 | 37D | PM | 1014 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (a chipmunk) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9574809028248 40.7950013620207) | 19 | 4 | 19 | 13 | |||||
488 | 488 | -73.9677903197449 | 40.7826561917755 | 21C-AM-1014-03 | 21C | AM | 1014 | 3 | Adult | Gray | Gray+ | Above Ground | 30.0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | looked at us from tree | POINT (-73.9677903197449 40.7826561917755) | 19 | 4 | 19 | 13 | |||||
502 | 502 | -73.9767080512177 | 40.7717708794221 | 6B-PM-1017-04 | 06B | PM | 1017 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9767080512177 40.7717708794221) | 19 | 4 | 19 | 13 | |||||
509 | 509 | -73.97182620344691 | 40.76667717974421 | 4I-PM-1007-02 | 04I | PM | 1007 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9718262034469 40.7666771797442) | 19 | 4 | 19 | 13 | ||||||
532 | 532 | -73.96792913479558 | 40.7846973096665 | 23B-PM-1012-02 | 23B | PM | 1012 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 2/3 were chasing each other | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9679291347956 40.7846973096665) | 19 | 4 | 19 | 13 | ||||
538 | 538 | -73.9776151109912 | 40.7694681558386 | 4C-PM-1010-09 | 04C | PM | 1010 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9776151109912 40.7694681558386) | 19 | 4 | 19 | 13 | |||||
549 | 549 | -73.97828135384209 | 40.7715730368712 | 6A-AM-1006-02 | 06A | AM | 1006 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30.0 | tree | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9782813538421 40.7715730368712) | 19 | 4 | 19 | 13 | ||||
556 | 556 | -73.9628349778362 | 40.793887005205995 | 34A-PM-1013-03 | 34A | PM | 1013 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9628349778362 40.793887005206) | 19 | 4 | 19 | 13 | |||||
603 | 603 | -73.9676692772518 | 40.7764726688908 | 15G-AM-1008-03 | 15G | AM | 1008 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9676692772518 40.7764726688908) | 19 | 4 | 19 | 13 | ||||||
606 | 606 | -73.9557399927792 | 40.7971563708988 | 40D-PM-1013-07 | 40D | PM | 1013 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9557399927792 40.7971563708988) | 19 | 4 | 19 | 13 | |||||
648 | 648 | -73.97826438139 | 40.7717086090782 | 6A-AM-1006-04 | 06A | AM | 1006 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | curious | POINT (-73.97826438139 40.7717086090782) | 19 | 4 | 19 | 13 | ||||
784 | 784 | -73.95397347709341 | 40.7956055442 | 39G-PM-1013-04 | 39G | PM | 1013 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9539734770934 40.7956055442) | 19 | 4 | 19 | 13 | |||||
790 | 790 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 1008 | 2 | Adult | Gray | Gray+ | Above Ground | 10.0 | oak tree | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9667755678511 40.7760256836088) | 19 | 4 | 19 | 13 | |||||
818 | 818 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 1010 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | 0 | 1 | 0 | 0 | 0 | chasing squirrel #6 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.978844141973 40.7696046074378) | 19 | 4 | 19 | 13 | ||||
820 | 820 | -73.9743509423821 | 40.7690043677328 | 5F-AM-1007-02 | 05F | AM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9743509423821 40.7690043677328) | 19 | 4 | 19 | 13 | |||||
823 | 823 | -73.95737241332641 | 40.7980080911115 | 40C-AM-1017-02 | 40C | AM | 1017 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | chasing (#1) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9573724133264 40.7980080911115) | 19 | 4 | 19 | 13 | ||||
828 | 828 | -73.9681874036914 | 40.7817948690964 | 20C-PM-1018-02 | 20C | PM | 1018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681874036914 40.7817948690964) | 19 | 4 | 19 | 13 | ||||||
830 | 830 | -73.96310890114121 | 40.789191946875 | 29C-PM-1006-02 | 29C | PM | 1006 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9631089011412 40.789191946875) | 19 | 4 | 19 | 13 | |||||
938 | 938 | -73.9581310602492 | 40.7960214726964 | 38C-PM-1014-05 | 38C | PM | 1014 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#4) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9581310602492 40.7960214726964) | 19 | 4 | 19 | 13 | ||||
948 | 948 | -73.974275954985 | 40.775472387930705 | 11B-AM-1007-02 | 11B | AM | 1007 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.974275954985 40.7754723879307) | 19 | 4 | 19 | 13 | ||||||
987 | 987 | -73.97684509716998 | 40.7709430375069 | 5C-PM-1010-07 | 05C | PM | 1010 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 13.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.97684509717 40.7709430375069) | 19 | 4 | 19 | 13 | |||||
999 | 999 | -73.97799837948492 | 40.767545209917294 | 2D-AM-1007-02 | 02D | AM | 1007 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6.0 | up tree | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9779983794849 40.7675452099173) | 19 | 4 | 19 | 13 | ||||
1013 | 1013 | -73.9631392113757 | 40.791463563578404 | 31B-PM-1007-02 | 31B | PM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 0 | 1 | 1 | 0 | 0 | chasing #1 and climbing tree w/ #1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9631392113757 40.7914635635784) | 19 | 4 | 19 | 13 | ||||
1014 | 1014 | -73.9636551433178 | 40.790157281877605 | 30B-PM-1019-02 | 30B | PM | 1019 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9636551433178 40.7901572818776) | 19 | 4 | 19 | 13 | |||||
1053 | 1053 | -73.96001657854859 | 40.795246676183204 | 36B-PM-1013-03 | 36B | PM | 1013 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9600165785486 40.7952466761832) | 19 | 4 | 19 | 13 | |||||
1084 | 1084 | -73.9638599044346 | 40.7809288795308 | 21G-AM-1014-06 | 21G | AM | 1014 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9638599044346 40.7809288795308) | 19 | 4 | 19 | 13 | |||||
1085 | 1085 | -73.9701824825872 | 40.776653057929295 | 14E-AM-1008-09 | 14E | AM | 1008 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9701824825872 40.7766530579293) | 19 | 4 | 19 | 13 | ||||||
1089 | 1089 | -73.97072153948871 | 40.7727508149058 | 10G-AM-1006-05 | 10G | AM | 1006 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#6) | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707215394887 40.7727508149058) | 19 | 4 | 19 | 13 | |||||
1102 | 1102 | -73.9652584749758 | 40.7803011124382 | 19F-PM-1017-04 | 19F | PM | 1017 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9652584749758 40.7803011124382) | 19 | 4 | 19 | 13 | |||||
1103 | 1103 | -73.9767590273554 | 40.7717561807266 | 6B-PM-1017-07 | 06B | PM | 1017 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9767590273554 40.7717561807266) | 19 | 4 | 19 | 13 | |||||
1137 | 1137 | -73.9580513096783 | 40.79909641532 | 41B-AM-1010-02 | 41B | AM | 1010 | 2 | Adult | Gray | White | Gray+White | Above Ground | 16.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9580513096783 40.79909641532) | 19 | 4 | 19 | 13 | |||||
1155 | 1155 | -73.9501762527462 | 40.797553408607705 | 42H-PM-1014-05 | 42H | PM | 1014 | 5 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9501762527462 40.7975534086077) | 12,423 | 18 | 4 | 36 | 18 | ||||
1227 | 1227 | -73.96762706709958 | 40.776391443152 | 15G-AM-1008-04 | 15G | AM | 1008 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9676270670996 40.776391443152) | 19 | 4 | 19 | 13 | ||||||
1229 | 1229 | -73.96148244372509 | 40.7912929799884 | 32C-PM-1013-03 | 32C | PM | 1013 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9614824437251 40.7912929799884) | 19 | 4 | 19 | 13 | ||||||
1271 | 1271 | -73.9563311167069 | 40.79509015633371 | 38E-AM-1010-12 | 38E | AM | 1010 | 12 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | running on rocks | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | runs toward something | POINT (-73.9563311167069 40.7950901563337) | 19 | 4 | 19 | 13 | ||||
1307 | 1307 | -73.95841884610591 | 40.7913241048498 | 33E-PM-1012-07 | 33E | PM | 1012 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9584188461059 40.7913241048498) | 19 | 4 | 19 | 13 | |||||
1311 | 1311 | -73.97314980648721 | 40.7659963196581 | 2H-AM-1006-02 | 02H | AM | 1006 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9731498064872 40.7659963196581) | 19 | 4 | 19 | 13 | |||||
1378 | 1378 | -73.95970725337871 | 40.79055818537861 | 32E-AM-1007-12 | 32E | AM | 1007 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9597072533787 40.7905581853786) | 19 | 4 | 19 | 13 | ||||||
1388 | 1388 | -73.97823514358521 | 40.7715896672335 | 6A-AM-1006-03 | 06A | AM | 1006 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30.0 | tree | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | POINT (-73.9782351435852 40.7715896672335) | 19 | 4 | 19 | 13 | ||||
1417 | 1417 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 1010 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
1453 | 1453 | -73.97920390711141 | 40.76787494712671 | 2C-AM-1010-07 | 02C | AM | 1010 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | #7 & #8 chased each other up diff tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9792039071114 40.7678749471267) | 19 | 4 | 19 | 13 | ||||
1485 | 1485 | -73.9645365195454 | 40.778153102126296 | 18H-AM-1018-02 | 18H | AM | 1018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Tree | 1 | 1 | 0 | 0 | 0 | playing? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9645365195454 40.7781531021263) | 19 | 4 | 19 | 13 | ||||
1499 | 1499 | -73.9638837160341 | 40.7809747900833 | 21G-AM-1014-07 | 21G | AM | 1014 | 7 | Adult | Gray | White | Gray+White | Above Ground | 5.0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9638837160341 40.7809747900833) | 19 | 4 | 19 | 13 | |||||
1508 | 1508 | -73.9646174034945 | 40.778128752826206 | 18H-AM-1018-01 | 18H | AM | 1018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Running from one tree to the other | 1 | 1 | 0 | 0 | 0 | playing? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9646174034945 40.7781287528262) | 19 | 4 | 19 | 13 | |||
1521 | 1521 | -73.9736165917399 | 40.772454390149704 | 8D-AM-1007-04 | 08D | AM | 1007 | 4 | Adult | Gray | Gray+ | Above Ground | 3.0 | 0 | 1 | 0 | 0 | 0 | chasing squirrel #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9736165917399 40.7724543901497) | 19 | 4 | 19 | 13 | |||||
1589 | 1589 | -73.95725308434791 | 40.7987460430546 | 41B-AM-1010-05 | 41B | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9572530843479 40.7987460430546) | 19 | 4 | 19 | 13 | |||||
1605 | 1605 | -73.95834778506341 | 40.7914073632782 | 33F-PM-1012-06 | 33F | PM | 1012 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9583477850634 40.7914073632782) | 19 | 4 | 19 | 13 | |||||
1607 | 1607 | -73.9692563597762 | 40.770904999952 | 9H-PM-1018-05 | 09H | PM | 1018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9692563597762 40.770904999952) | 19 | 4 | 19 | 13 | ||||||
1621 | 1621 | -73.97271159154221 | 40.7782929320632 | 14B-PM-1014-02 | 14B | PM | 1014 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9727115915422 40.7782929320632) | 19 | 4 | 19 | 13 | |||||
1642 | 1642 | -73.9768357173861 | 40.7683813358343 | 3D-PM-1010-12 | 03D | PM | 1010 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768357173861 40.7683813358343) | 19 | 4 | 19 | 13 | |||||
1686 | 1686 | -73.97858295460459 | 40.7719652299132 | 6A-PM-1012-02 | 06A | PM | 1012 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785829546046 40.7719652299132) | 19 | 4 | 19 | 13 | |||||
1691 | 1691 | -73.9652134469963 | 40.7803438278765 | 19F-PM-1017-05 | 19F | PM | 1017 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9652134469963 40.7803438278765) | 19 | 4 | 19 | 13 | |||||
1692 | 1692 | -73.9767455430709 | 40.7717866237826 | 6B-PM-1017-06 | 06B | PM | 1017 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9767455430709 40.7717866237826) | 19 | 4 | 19 | 13 | |||||
1727 | 1727 | -73.97301589136609 | 40.7701310707272 | 6F-PM-1008-02 | 06F | PM | 1008 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 1 | 1 | 0 | 0 | 0 | chasing #2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9730158913661 40.7701310707272) | 19 | 4 | 19 | 13 | ||||
1746 | 1746 | -73.9743877909071 | 40.7754706115974 | 11B-AM-1007-03 | 11B | AM | 1007 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9743877909071 40.7754706115974) | 19 | 4 | 19 | 13 | ||||||
1773 | 1773 | -73.9702588981432 | 40.776610754288 | 14E-AM-1008-08 | 14E | AM | 1008 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9702588981432 40.776610754288) | 19 | 4 | 19 | 13 | ||||||
1775 | 1775 | -73.96134291849741 | 40.79121580572671 | 32C-AM-1014-02 | 32C | AM | 1014 | 2 | Adult | Gray | Gray+ | Above Ground | 3.0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9613429184974 40.7912158057267) | 19 | 4 | 19 | 13 | ||||||
1796 | 1796 | -73.9785114291288 | 40.771977958944895 | 6A-PM-1012-03 | 06A | PM | 1012 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785114291288 40.7719779589449) | 19 | 4 | 19 | 13 | |||||
1897 | 1897 | -73.9759428006237 | 40.7715081817329 | 7C-PM-1020-06 | 07C | PM | 1020 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9759428006237 40.7715081817329) | 19 | 4 | 19 | 13 | ||||||
1927 | 1927 | -73.9745908987975 | 40.7655191512308 | 1G-AM-1006-03 | 01G | AM | 1006 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9745908987975 40.7655191512308) | 19 | 4 | 19 | 13 | |||||
1953 | 1953 | -73.9613998967903 | 40.7912437235667 | 32C-PM-1013-02 | 32C | PM | 1013 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9613998967903 40.7912437235667) | 19 | 4 | 19 | 13 | ||||||
1976 | 1976 | -73.9695041366722 | 40.779787880948206 | 17D-AM-1008-02 | 17D | AM | 1008 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9695041366722 40.7797878809482) | 19 | 4 | 19 | 13 | |||||
2044 | 2044 | -73.9785709201168 | 40.7674391934208 | 2C-PM-1013-02 | 02C | PM | 1013 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785709201168 40.7674391934208) | 19 | 4 | 19 | 13 | |||||
2068 | 2068 | -73.9613862251332 | 40.791282169715 | 32C-AM-1014-03 | 32C | AM | 1014 | 3 | Adult | Gray | Gray+ | Above Ground | 3.0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9613862251332 40.791282169715) | 19 | 4 | 19 | 13 | ||||||
2074 | 2074 | -73.97637911214379 | 40.770281512254 | 5D-PM-1018-04 | 05D | PM | 1018 | 4 | Adult | Gray | White | Gray+White | Partial missing tail | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (dog chasing) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763791121438 40.770281512254) | 19 | 4 | 19 | 13 | |||
2081 | 2081 | -73.9677096985223 | 40.7825358361204 | 21C-AM-1014-02 | 21C | AM | 1014 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 50.0 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | looked at us from tree | POINT (-73.9677096985223 40.7825358361204) | 19 | 4 | 19 | 13 | ||||
2101 | 2101 | -73.96774098419691 | 40.776357914063894 | 15G-PM-1019-08 | 15G | PM | 1019 | 8 | Adult | + | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9677409841969 40.7763579140639) | 19 | 4 | 19 | 13 | |||||||
2128 | 2128 | -73.9672252136807 | 40.787650474321204 | 26A-PM-1006-04 | 26A | PM | 1006 | 4 | Adult | Gray | Gray+ | Above Ground | 40.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9672252136807 40.7876504743212) | 19 | 4 | 19 | 13 | ||||||
2248 | 2248 | -73.95976427784271 | 40.7976368003915 | 39A-PM-1014-02 | 39A | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9597642778427 40.7976368003915) | 19 | 4 | 19 | 13 | |||||
2275 | 2275 | -73.9672054610151 | 40.7876519923501 | 26A-PM-1006-05 | 26A | PM | 1006 | 5 | Adult | Gray | Gray+ | Above Ground | 40.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9672054610151 40.7876519923501) | 19 | 4 | 19 | 13 | ||||||
2343 | 2343 | -73.9686756254868 | 40.777745910265104 | 16E-AM-1014-04 | 16E | AM | 1014 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9686756254868 40.7777459102651) | 19 | 4 | 19 | 13 | |||||
2346 | 2346 | -73.96971780962751 | 40.769703669630104 | 7I-PM-1013-07 | 07I | PM | 1013 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | Under the tree | 0 | 1 | 0 | 0 | 0 | playing,interacting with #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9697178096275 40.7697036696301) | 19 | 4 | 19 | 13 | |||
2358 | 2358 | -73.9811585807616 | 40.768706748732 | 2A-AM-1010-06 | 02A | AM | 1010 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | chasing #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9811585807616 40.768706748732) | 19 | 4 | 19 | 13 | |||||
2361 | 2361 | -73.9734654671008 | 40.7715988711659 | 8E-PM-1008-06 | 08E | PM | 1008 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734654671008 40.7715988711659) | 19 | 4 | 19 | 13 | ||||
2417 | 2417 | -73.9677593344667 | 40.7763054313195 | 15G-PM-1019-07 | 15G | PM | 1019 | 7 | Adult | + | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9677593344667 40.7763054313195) | 19 | 4 | 19 | 13 | |||||||
2438 | 2438 | -73.9758152322587 | 40.76923774014671 | 4E-PM-1008-03 | 04E | PM | 1008 | 3 | Adult | Gray | Gray+ | 0 | 1 | 0 | 0 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9758152322587 40.7692377401467) | 19 | 4 | 19 | 13 | |||||||
2464 | 2464 | -73.9666007935638 | 40.7845098131567 | 23C-PM-1014-03 | 23C | PM | 1014 | 3 | Adult | Gray | Gray+ | Above Ground | 8.0 | 0 | 1 | 0 | 0 | 0 | chasing (#4 across trees) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9666007935638 40.7845098131567) | 19 | 4 | 19 | 13 | |||||
2466 | 2466 | -73.97853537753821 | 40.7674923683184 | 2C-PM-1013-01 | 02C | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785353775382 40.7674923683184) | 19 | 4 | 19 | 13 | |||||
2512 | 2512 | -73.9678620840741 | 40.784719027304 | 23B-PM-1012-03 | 23B | PM | 1012 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 2/3 were chasing each other | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9678620840741 40.784719027304) | 19 | 4 | 19 | 13 | ||||
2529 | 2529 | -73.9531013359625 | 40.792122355653504 | 36I-PM-1007-04 | 36I | PM | 1007 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9531013359625 40.7921223556535) | 19 | 4 | 19 | 13 | ||||||
2535 | 2535 | -73.9692849074642 | 40.7708755098145 | 9H-PM-1018-06 | 09H | PM | 1018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9692849074642 40.7708755098145) | 19 | 4 | 19 | 13 | ||||||
2572 | 2572 | -73.9701335162984 | 40.772205101135704 | 10G-AM-1006-10 | 10G | AM | 1006 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9701335162984 40.7722051011357) | 19 | 4 | 19 | 13 | ||||||
2594 | 2594 | -73.9562068537632 | 40.796733285323796 | 39D-AM-1008-01 | 39D | AM | 1008 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9562068537632 40.7967332853238) | 19 | 4 | 19 | 13 | ||||||
2637 | 2637 | -73.9690082314914 | 40.7738993942891 | 12G-AM-1012-05 | 12G | AM | 1012 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9690082314914 40.7738993942891) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE "2018_Central_Park_Squirrel_Census" ( "Longitude" REAL, "Latitude" REAL, "Unique_Squirrel_ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" INTEGER, "Hectare_Squirrel_Number" INTEGER, "Age" REAL, "Primary_Fur_Color" REAL, "Highlight_Fur_Color" REAL, "Combination_of_Primary_and_Highlight_Color" TEXT, "Color_notes" REAL, "Location" REAL, "Above_Ground_Sighter_Measurement" REAL, "Specific_Location" REAL, "Running" INTEGER, "Chasing" INTEGER, "Climbing" INTEGER, "Eating" INTEGER, "Foraging" INTEGER, "Other_Activities" REAL, "Kuks" INTEGER, "Quaas" INTEGER, "Moans" INTEGER, "Tail_flags" INTEGER, "Tail_twitches" INTEGER, "Approaches" INTEGER, "Indifferent" INTEGER, "Runs_from" INTEGER, "Other_Interactions" REAL, "Latlong" TEXT, "Zip_Codes" REAL, "Community_Districts" INTEGER, "Borough_Boundaries" INTEGER, "City_Council_Districts" INTEGER, "Police_Precincts" INTEGER )