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, Quaas, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
94 | 94 | -73.9676314068477 | 40.7788030406918 | 17E-AM-1017-08 | 17E | AM | 1017 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9676314068477 40.7788030406918) | 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 | |||||
182 | 182 | -73.9615402629655 | 40.7924082330328 | 33C-AM-1012-02 | 33C | AM | 1012 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along back & tail | Above Ground | 20.0 | tree branches | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615402629655 40.7924082330328) | 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 | |||||
251 | 251 | -73.96996720741642 | 40.777438934574796 | 15D-AM-1007-07 | 15D | AM | 1007 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing #8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699672074164 40.7774389345748) | 19 | 4 | 19 | 13 | ||||
253 | 253 | -73.9801956082236 | 40.767836440957 | 1B-AM-1012-08 | 01B | AM | 1012 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801956082236 40.767836440957) | 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 | ||||||
394 | 394 | -73.96199851876159 | 40.79432777435321 | 34A-AM-1012-02 | 34A | AM | 1012 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10.0 | chasing from tree to ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9619985187616 40.7943277743532) | 19 | 4 | 19 | 13 | ||||
448 | 448 | -73.9730284815849 | 40.7702462529502 | 7F-AM-1008-04 | 07F | AM | 1008 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | bush | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9730284815849 40.7702462529502) | 19 | 4 | 19 | 13 | ||||
454 | 454 | -73.97714226252741 | 40.772361415776 | 7B-AM-1008-02 | 07B | AM | 1008 | 2 | Adult | Gray | Gray+ | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771422625274 40.772361415776) | 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 | ||||||
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 | |||||
499 | 499 | -73.97458184501092 | 40.765449887362706 | 1G-AM-1006-01 | 01G | AM | 1006 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745818450109 40.7654498873627) | 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 | ||||
552 | 552 | -73.9741401377844 | 40.7758134257881 | 12B-AM-1007-02 | 12B | AM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9741401377844 40.7758134257881) | 19 | 4 | 19 | 13 | |||||
559 | 559 | -73.9622419917579 | 40.794579797904 | 35A-AM-1014-07 | 35A | AM | 1014 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622419917579 40.794579797904) | 19 | 4 | 19 | 13 | |||||
575 | 575 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693209851947 40.7707450042769) | 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 | ||||||
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 | ||||
661 | 661 | -73.96316467546471 | 40.7925716810884 | 32A-AM-1018-02 | 32A | AM | 1018 | 2 | Adult | Gray | Gray+ | Above Ground | 15.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631646754647 40.7925716810884) | 19 | 4 | 19 | 13 | ||||||
693 | 693 | -73.96542881512659 | 40.7815953970174 | 21E-AM-1017-02 | 21E | AM | 1017 | 2 | Adult | Gray | Gray+ | Above Ground | 7.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9654288151266 40.7815953970174) | 19 | 4 | 19 | 13 | ||||||
757 | 757 | -73.9766342759486 | 40.7687518380873 | 4D-AM-1012-04 | 04D | AM | 1012 | 4 | Adult | Gray | Gray+ | Above Ground | 3.0 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9766342759486 40.7687518380873) | 19 | 4 | 19 | 13 | |||||
810 | 810 | -73.95595201371721 | 40.7950536287174 | 38E-AM-1010-06 | 38E | AM | 1010 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #7 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9559520137172 40.7950536287174) | 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 | |||||
822 | 822 | -73.9770948563006 | 40.7724063459185 | 7B-AM-1008-04 | 07B | AM | 1008 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770948563006 40.7724063459185) | 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 | ||||
925 | 925 | -73.97116665233759 | 40.776151305703394 | 13D-AM-1014-02 | 13D | AM | 1014 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711666523376 40.7761513057034) | 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 | ||||||
955 | 955 | -73.9677146741772 | 40.77882313323371 | 17E-AM-1017-07 | 17E | AM | 1017 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677146741772 40.7788231332337) | 19 | 4 | 19 | 13 | ||||||
977 | 977 | -73.96353178229771 | 40.7821352080233 | 22G-AM-1018-01 | 22G | AM | 1018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9635317822977 40.7821352080233) | 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 | ||||
1046 | 1046 | -73.9698064901149 | 40.7842538115839 | 21A-AM-1019-03 | 21A | AM | 1019 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Tree & ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698064901149 40.7842538115839) | 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 | |||||
1109 | 1109 | -73.9655238539833 | 40.7815633947684 | 21E-AM-1017-03 | 21E | AM | 1017 | 3 | Adult | Gray | Gray+ | Above Ground | 7.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9655238539833 40.7815633947684) | 19 | 4 | 19 | 13 | ||||||
1122 | 1122 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 1006 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.7655415515908) | 19 | 4 | 19 | 13 | ||||||
1135 | 1135 | -73.96205425147491 | 40.794373172213795 | 34A-AM-1012-01 | 34A | AM | 1012 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | chasing from tree to ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9620542514749 40.7943731722138) | 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 | |||||
1184 | 1184 | -73.96318185288159 | 40.7925332194132 | 32A-AM-1018-01 | 32A | AM | 1018 | 1 | Adult | Gray | Gray+ | Above Ground | 15.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631818528816 40.7925332194132) | 19 | 4 | 19 | 13 | ||||||
1194 | 1194 | -73.976658503418 | 40.768686845691704 | 4D-AM-1012-03 | 04D | AM | 1012 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.976658503418 40.7686868456917) | 19 | 4 | 19 | 13 | ||||||
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 | ||||||
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 | ||||
1277 | 1277 | -73.95994199262991 | 40.797277472881106 | 38A-AM-1019-01 | 38A | AM | 1019 | 1 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599419926299 40.7972774728811) | 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 | |||||
1319 | 1319 | -73.97443873476259 | 40.7776953143835 | 13A-AM-1017-03 | 13A | AM | 1017 | 3 | Adult | Cinnamon | Cinnamon+ | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744387347626 40.7776953143835) | 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 | ||||
1478 | 1478 | -73.9693876553956 | 40.7707232748402 | 8I-AM-1006-02 | 08I | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693876553956 40.7707232748402) | 19 | 4 | 19 | 13 | |||||
1479 | 1479 | -73.9606559309874 | 40.7889527629826 | 30E-AM-1008-02 | 30E | AM | 1008 | 2 | Adult | Gray | Gray+ | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9606559309874 40.7889527629826) | 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 | |||||
1622 | 1622 | -73.9770313887741 | 40.7724869252099 | 7B-AM-1008-05 | 07B | AM | 1008 | 5 | Adult | Gray | Gray+ | Above Ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770313887741 40.7724869252099) | 19 | 4 | 19 | 13 | |||||||
1638 | 1638 | -73.96980803283041 | 40.7842252948542 | 21A-AM-1019-02 | 21A | AM | 1019 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Tree & ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698080328304 40.7842252948542) | 19 | 4 | 19 | 13 | |||||
1680 | 1680 | -73.9766477027266 | 40.7712737417779 | 6C-AM-1007-04 | 06C | AM | 1007 | 4 | Adult | Gray | Gray+ | Above Ground | 20.0 | 0 | 1 | 1 | 0 | 0 | chasing #5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766477027266 40.7712737417779) | 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 | ||||||
1771 | 1771 | -73.9801651470389 | 40.767769865693495 | 1B-AM-1012-05 | 01B | AM | 1012 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801651470389 40.7677698656935) | 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 | ||||||
1804 | 1804 | -73.970540988328 | 40.769810306706205 | 7H-AM-1006-06 | 07H | AM | 1006 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970540988328 40.7698103067062) | 19 | 4 | 19 | 13 | |||||
1810 | 1810 | -73.9684834138222 | 40.772428912021105 | 11H-AM-1010-06 | 11H | AM | 1010 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9684834138222 40.7724289120211) | 19 | 4 | 19 | 13 | |||||
1884 | 1884 | -73.9556450015702 | 40.796718805800204 | 39E-AM-1018-04 | 39E | AM | 1018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9556450015702 40.7967188058002) | 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 | |||||
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 | |||||
1979 | 1979 | -73.9721592378418 | 40.776034583573 | 12C-AM-1013-02 | 12C | AM | 1013 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721592378418 40.776034583573) | 19 | 4 | 19 | 13 | ||||||
1992 | 1992 | -73.96992856882959 | 40.7774474015189 | 15D-AM-1007-08 | 15D | AM | 1007 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing #7 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699285688296 40.7774474015189) | 19 | 4 | 19 | 13 | |||||
1998 | 1998 | -73.95992022335359 | 40.7972599930224 | 38A-AM-1019-02 | 38A | AM | 1019 | 2 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599202233536 40.7972599930224) | 19 | 4 | 19 | 13 | ||||||
2040 | 2040 | -73.9711634340673 | 40.7760553338671 | 13D-AM-1014-05 | 13D | AM | 1014 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711634340673 40.7760553338671) | 19 | 4 | 19 | 13 | |||||
2053 | 2053 | -73.980048119915 | 40.7676638655026 | 1B-AM-1012-06 | 01B | AM | 1012 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.980048119915 40.7676638655026) | 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 | ||||||
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 | ||||
2245 | 2245 | -73.9691293546408 | 40.7703219076549 | 8I-AM-1006-11 | 08I | AM | 1006 | 11 | Adult | Gray | Gray+ | Above Ground | 50.0 | tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691293546408 40.7703219076549) | 19 | 4 | 19 | 13 | |||||
2278 | 2278 | -73.9534509627885 | 40.7921084224711 | 36I-AM-1017-07 | 36I | AM | 1017 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (#8),scratching | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9534509627885 40.7921084224711) | 19 | 4 | 19 | 13 | ||||
2284 | 2284 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 1012 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31.0 | on tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9595222999173 40.7833202577782) | 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 | |||||
2344 | 2344 | -73.970252675331 | 40.7705999588222 | 8H-AM-1017-06 | 08H | AM | 1017 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6.0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970252675331 40.7705999588222) | 19 | 4 | 19 | 13 | |||||
2354 | 2354 | -73.95707222626929 | 40.798570614351895 | 40C-AM-1017-04 | 40C | AM | 1017 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | chasing (#3) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9570722262693 40.7985706143519) | 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 | |||||
2377 | 2377 | -73.9549261242548 | 40.7944701994615 | 37G-AM-1014-04 | 37G | AM | 1014 | 4 | Adult | Gray | Gray+ | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9549261242548 40.7944701994615) | 19 | 4 | 19 | 13 | |||||
2454 | 2454 | -73.97660121083071 | 40.7712310725379 | 6C-AM-1007-05 | 06C | AM | 1007 | 5 | Adult | Gray | Gray+ | Above Ground | 20.0 | 0 | 1 | 1 | 0 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766012108307 40.7712310725379) | 19 | 4 | 19 | 13 | |||||
2468 | 2468 | -73.96153964579959 | 40.792359436678296 | 33C-AM-1012-01 | 33C | AM | 1012 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along tail & back | Above Ground | 20.0 | tree branches | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615396457996 40.7923594366783) | 19 | 4 | 19 | 13 | |||
2477 | 2477 | -73.9800669115792 | 40.767682513438395 | 1B-AM-1012-07 | 01B | AM | 1012 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9800669115792 40.7676825134384) | 19 | 4 | 19 | 13 | |||||
2534 | 2534 | -73.96854290608391 | 40.7724786961619 | 11H-AM-1010-05 | 11H | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9685429060839 40.7724786961619) | 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 | ||||||
2590 | 2590 | -73.9576559099012 | 40.7992598626483 | 41B-AM-1010-09 | 41B | AM | 1010 | 9 | Adult | Gray | Gray+ | Above Ground | 3.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9576559099012 40.7992598626483) | 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 | ||||||
2631 | 2631 | -73.9706105896967 | 40.769812482150705 | 7H-AM-1006-05 | 07H | AM | 1006 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706105896967 40.7698124821507) | 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 | |||||
2762 | 2762 | -73.96887733063241 | 40.7766669852358 | 15F-AM-1007-05 | 15F | AM | 1007 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9688773306324 40.7766669852358) | 19 | 4 | 19 | 13 | |||||
2768 | 2768 | -73.97304542959971 | 40.77029094543921 | 7F-AM-1008-05 | 07F | AM | 1008 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | bush | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9730454295997 40.7702909454392) | 19 | 4 | 19 | 13 | |||||
2775 | 2775 | -73.9771695272048 | 40.772427727626294 | 7B-AM-1008-03 | 07B | AM | 1008 | 3 | Adult | Gray | Gray+ | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771695272048 40.7724277276263) | 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 )