Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Combination_of_Primary_and_Highlight_Color, Color_notes, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | 9 | -73.9707274055755 | 40.772388908037705 | 10G-PM-1017-10 | 10G | PM | 1017 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | playing (with #9) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707274055755 40.7723889080377) | 19 | 4 | 19 | 13 | |||||
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 | |||||
80 | 80 | -73.9765805609072 | 40.7692807820935 | 4D-PM-1008-07 | 04D | PM | 1008 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | hopped over fence and chased # 6 around tree & ran it to end of lawn | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765805609072 40.7692807820935) | 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 | |||||
147 | 147 | -73.9544278270221 | 40.7987827316512 | 42D-PM-1013-02 | 42D | PM | 1013 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail, Cinnamon feet | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (chased by #1),found a nut,buried it | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9544278270221 40.7987827316512) | 19 | 4 | 19 | 13 | |||
157 | 157 | -73.97553718499721 | 40.7733561233828 | 9C-PM-1006-02 | 09C | PM | 1006 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755371849972 40.7733561233828) | 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 | ||||
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 | |||
216 | 216 | -73.96032682553171 | 40.7900154505092 | 31E-PM-1006-06 | 31E | PM | 1006 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9603268255317 40.7900154505092) | 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 | |||||
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 | |||||
304 | 304 | -73.97574132156208 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 1008 | 4 | Adult | Gray | Gray+ | Above Ground | 10.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757413215621 40.7692582758978) | 19 | 4 | 19 | 13 | ||||||
342 | 342 | -73.9716271494641 | 40.7796462634184 | 16B-PM-1017-02 | 16B | PM | 1017 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9716271494641 40.7796462634184) | 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 | |||||
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 | ||||
415 | 415 | -73.974828939898 | 40.7668886121909 | 2F-PM-1014-11 | 02F | PM | 1014 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974828939898 40.7668886121909) | 19 | 4 | 19 | 13 | ||||||
443 | 443 | -73.9699124811406 | 40.7743016981538 | 12F-PM-1007-07 | 12F | PM | 1007 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9699124811406 40.7743016981538) | 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 | ||||||
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 | |||||
460 | 460 | -73.9690551477139 | 40.782368566319604 | 20B-PM-1013-07 | 20B | PM | 1013 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690551477139 40.7823685663196) | 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 | ||||||
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 | ||||
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 | |||||
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 | |||||
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 | |||||
560 | 560 | -73.95427708888809 | 40.794361036685295 | 38G-PM-1020-04 | 38G | PM | 1020 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9542770888881 40.7943610366853) | 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 | ||||||
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 | |||||
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 | ||||||
728 | 728 | -73.9703076450783 | 40.770158422628995 | 8H-PM-1014-07 | 08H | PM | 1014 | 7 | Adult | Gray | Gray+ | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | chasing (#8),playing? | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703076450783 40.770158422629) | 19 | 4 | 19 | 13 | |||||
733 | 733 | -73.9754802138871 | 40.773300804411996 | 9C-PM-1006-03 | 09C | PM | 1006 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754802138871 40.773300804412) | 19 | 4 | 19 | 13 | |||||
775 | 775 | -73.96871341377859 | 40.7812207913391 | 19C-PM-1018-03 | 19C | PM | 1018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9687134137786 40.7812207913391) | 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 | |||||
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 | ||||
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 | |||||
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 | ||||||
931 | 931 | -73.9786351029146 | 40.771611416400205 | 6A-PM-1012-06 | 06A | PM | 1012 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | elevated ground | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9786351029146 40.7716114164002) | 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 | ||||
942 | 942 | -73.974515099169 | 40.770065079988605 | 6E-PM-1010-03 | 06E | PM | 1010 | 3 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | 0 | 1 | 0 | 1 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974515099169 40.7700650799886) | 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 | ||||||
957 | 957 | -73.963209639301 | 40.7926138443715 | 32A-PM-1013-07 | 32A | PM | 1013 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.963209639301 40.7926138443715) | 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 | |||||
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 | ||||
1022 | 1022 | -73.9698762023146 | 40.778205568811295 | 16D-PM-1010-09 | 16D | PM | 1010 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698762023146 40.7782055688113) | 19 | 4 | 19 | 13 | ||||||
1027 | 1027 | -73.958369699409 | 40.79024566683321 | 32F-PM-1008-01 | 32F | PM | 1008 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958369699409 40.7902456668332) | 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 | |||||
1078 | 1078 | -73.9603366992925 | 40.7899612889539 | 31E-PM-1006-05 | 31E | PM | 1006 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9603366992925 40.7899612889539) | 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 | |||||
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 | |||||
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 | ||||||
1111 | 1111 | -73.9783366903829 | 40.7668300056094 | 1D-PM-1007-03 | 01D | PM | 1007 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9783366903829 40.7668300056094) | 19 | 4 | 19 | 13 | |||||
1114 | 1114 | -73.973598991549 | 40.7783020016983 | 14A-PM-1014-03 | 14A | PM | 1014 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#4) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.973598991549 40.7783020016983) | 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 | |||||
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 | ||||
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 | ||||||
1220 | 1220 | -73.9772810073685 | 40.7693577540392 | 4C-PM-1010-03 | 04C | PM | 1010 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772810073685 40.7693577540392) | 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 | ||||||
1234 | 1234 | -73.9719735582476 | 40.769304513357795 | 6G-PM-1020-02 | 06G | PM | 1020 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9719735582476 40.7693045133578) | 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 | ||||||
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 | |||||
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 | ||||||||
1344 | 1344 | -73.9598084794625 | 40.797616543450204 | 39A-PM-1014-01 | 39A | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9598084794625 40.7976165434502) | 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 | ||||||
1391 | 1391 | -73.96624099976421 | 40.789104293543204 | 28A-PM-1007-03 | 28A | PM | 1007 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | chasing #2 took #2 food wrapper and is foraging through it | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662409997642 40.7891042935432) | 19 | 4 | 19 | 13 | ||||
1440 | 1440 | -73.96797780019 | 40.784762947325795 | 23B-PM-1012-05 | 23B | PM | 1012 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | chain link fence | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96797780019 40.7847629473258) | 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 | ||||
1459 | 1459 | -73.9586527721822 | 40.790883111056104 | 32F-PM-1008-08 | 32F | PM | 1008 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9586527721822 40.7908831110561) | 19 | 4 | 19 | 13 | |||||
1462 | 1462 | -73.9782283921819 | 40.766793260207706 | 1D-PM-1007-02 | 01D | PM | 1007 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9782283921819 40.7667932602077) | 19 | 4 | 19 | 13 | |||||
1468 | 1468 | -73.9542684235907 | 40.7944237164092 | 38G-PM-1020-05 | 38G | PM | 1020 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9542684235907 40.7944237164092) | 19 | 4 | 19 | 13 | |||||
1474 | 1474 | -73.96676944398949 | 40.7779501809095 | 17G-PM-1017-03 | 17G | PM | 1017 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | tree & ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9667694439895 40.7779501809095) | 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 |
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 )