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, Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Moans, Tail_flags, Tail_twitches, Approaches, Indifferent, Zip_Codes, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24 | 24 | -73.9613351649026 | 40.79098668513571 | 31D-AM-1014-03 | 31D | AM | 1014 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | Undergrowth | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9613351649026 40.7909866851357) | 19 | 4 | 19 | 13 | |||||
194 | 194 | -73.96081673001041 | 40.795434868826796 | 36A-PM-1013-05 | 36A | PM | 1013 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | EDGE OF WOODS | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9608167300104 40.7954348688268) | 19 | 4 | 19 | 13 | |||||
338 | 338 | -73.9615090149261 | 40.794515017391795 | 35A-PM-1013-09 | 35A | PM | 1013 | 9 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9615090149261 40.7945150173918) | 19 | 4 | 19 | 13 | ||||||
376 | 376 | -73.9615429203441 | 40.7907417648701 | 31D-AM-1014-01 | 31D | AM | 1014 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20.0 | Ground then up tree | 0 | 0 | 1 | 0 | 0 | chased by a doggo | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | runs from (dogs!) | POINT (-73.9615429203441 40.7907417648701) | 19 | 4 | 19 | 13 | |||
511 | 511 | -73.967975586222 | 40.77356830443129 | 12H-PM-1007-07 | 12H | PM | 1007 | 7 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | grass field | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | humans | POINT (-73.967975586222 40.7735683044313) | 19 | 4 | 19 | 13 | ||||
546 | 546 | -73.9609692861012 | 40.790502891247 | 31D-AM-1014-07 | 31D | AM | 1014 | 7 | Gray | Gray+ | Ground Plane | FALSE | Crossing path to tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9609692861012 40.790502891247) | 19 | 4 | 19 | 13 | ||||||
668 | 668 | -73.96065706156101 | 40.79561507441021 | 36A-PM-1013-08 | 36A | PM | 1013 | 8 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | 1 | 0 | 0 | 0 | 0 | running from #7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.960657061561 40.7956150744102) | 19 | 4 | 19 | 13 | |||||
918 | 918 | -73.9680833729772 | 40.774187102511505 | 12H-PM-1007-08 | 12H | PM | 1007 | 8 | + | Above Ground | 7.0 | in tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9680833729772 40.7741871025115) | 19 | 4 | 19 | 13 | |||||||
1048 | 1048 | -73.9587879699956 | 40.7908135158551 | 32F-AM-1012-01 | 32F | AM | 1012 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | made a back-door escape from dog off-leash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9587879699956 40.7908135158551) | 19 | 4 | 19 | 13 | |||||
1177 | 1177 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 1014 | 4 | Gray | White | Gray+White | Above Ground | 15.0 | Ground then tree to eat | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.958719099962 40.7947587726617) | 19 | 4 | 19 | 13 | |||||
1413 | 1413 | -73.96717867152559 | 40.7867352791232 | 25A-AM-1013-04 | 25A | AM | 1013 | 4 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9671786715256 40.7867352791232) | 19 | 4 | 19 | 13 | ||||||
1456 | 1456 | -73.9602609920814 | 40.7942883045566 | 35C-PM-1013-03 | 35C | PM | 1013 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9602609920814 40.7942883045566) | 19 | 4 | 19 | 13 | ||||||
1550 | 1550 | -73.96077013704429 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 1013 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | 0 | 1 | 0 | 0 | 0 | chasing #8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9607701370443 40.7955418990855) | 19 | 4 | 19 | 13 | |||||
1697 | 1697 | -73.9634563222926 | 40.780992836417 | 21G-PM-1007-04 | 21G | PM | 1007 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9634563222926 40.780992836417) | 19 | 4 | 19 | 13 | ||||||
1742 | 1742 | -73.96021668769791 | 40.7953811003986 | 36B-AM-1013-04 | 36B | AM | 1013 | 4 | Black | Black+ | Above Ground | 20.0 | Moved 20+ feet high above top of tree limb | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9602166876979 40.7953811003986) | 19 | 4 | 19 | 13 | ||||||
1984 | 1984 | -73.9601259189134 | 40.795535060905706 | 36B-PM-1013-04 | 36B | PM | 1013 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9601259189134 40.7955350609057) | 19 | 4 | 19 | 13 | ||||||
2006 | 2006 | -73.9586085843149 | 40.7946617684536 | 36C-AM-1014-03 | 36C | AM | 1014 | 3 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9586085843149 40.7946617684536) | 19 | 4 | 19 | 13 | |||||||
2097 | 2097 | -73.9603245806655 | 40.79427124776971 | 35C-PM-1013-04 | 35C | PM | 1013 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9603245806655 40.7942712477697) | 19 | 4 | 19 | 13 | ||||||
2143 | 2143 | -73.95985354257058 | 40.7915589343685 | 33D-PM-1006-01 | 33D | PM | 1006 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | hanging on fence | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9598535425706 40.7915589343685) | 19 | 4 | 19 | 13 | |||||
2250 | 2250 | -73.967097592707 | 40.785411934253794 | 24B-AM-1013-01 | 24B | AM | 1013 | 1 | Gray | Gray+ | Above Ground | 50.0 | 1 | 0 | 0 | 1 | 0 | took nut to bury | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.967097592707 40.7854119342538) | 19 | 4 | 19 | 13 | ||||||
2330 | 2330 | -73.9612349421547 | 40.795958647574395 | 36A-PM-1013-09 | 36A | PM | 1013 | 9 | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9612349421547 40.7959586475744) | 19 | 4 | 19 | 13 | ||||||
2433 | 2433 | -73.9695176417703 | 40.7741725190048 | 12G-PM-1007-04 | 12G | PM | 1007 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9695176417703 40.7741725190048) | 19 | 4 | 19 | 13 | ||||||
2604 | 2604 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 1006 | 3 | Black | Black+ | Above Ground | 15.0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ran up tree | POINT (-73.959709414696 40.7919745085986) | 19 | 4 | 19 | 13 | ||||||
2834 | 2834 | -73.98096101171708 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 1010 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
2931 | 2931 | -73.9598340783572 | 40.7915857030295 | 33D-PM-1006-02 | 33D | PM | 1006 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9598340783572 40.7915857030295) | 19 | 4 | 19 | 13 | ||||||
3013 | 3013 | -73.9554432393295 | 40.794566905444896 | 37F-PM-1014-01 | 37F | PM | 1014 | 1 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9554432393295 40.7945669054449) | 19 | 4 | 19 | 13 | |||||||
3047 | 3047 | -73.9613351649026 | 40.79098668513571 | 31D-AM-1014-03 | 31D | AM | 1014 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | Undergrowth | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9613351649026 40.7909866851357) | 19 | 4 | 19 | 13 | |||||
3217 | 3217 | -73.96081673001041 | 40.795434868826796 | 36A-PM-1013-05 | 36A | PM | 1013 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | EDGE OF WOODS | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9608167300104 40.7954348688268) | 19 | 4 | 19 | 13 | |||||
3361 | 3361 | -73.9615090149261 | 40.794515017391795 | 35A-PM-1013-09 | 35A | PM | 1013 | 9 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9615090149261 40.7945150173918) | 19 | 4 | 19 | 13 | ||||||
3399 | 3399 | -73.9615429203441 | 40.7907417648701 | 31D-AM-1014-01 | 31D | AM | 1014 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20.0 | Ground then up tree | 0 | 0 | 1 | 0 | 0 | chased by a doggo | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | runs from (dogs!) | POINT (-73.9615429203441 40.7907417648701) | 19 | 4 | 19 | 13 | |||
3534 | 3534 | -73.967975586222 | 40.77356830443129 | 12H-PM-1007-07 | 12H | PM | 1007 | 7 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | grass field | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | humans | POINT (-73.967975586222 40.7735683044313) | 19 | 4 | 19 | 13 | ||||
3569 | 3569 | -73.9609692861012 | 40.790502891247 | 31D-AM-1014-07 | 31D | AM | 1014 | 7 | Gray | Gray+ | Ground Plane | FALSE | Crossing path to tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9609692861012 40.790502891247) | 19 | 4 | 19 | 13 | ||||||
3691 | 3691 | -73.96065706156101 | 40.79561507441021 | 36A-PM-1013-08 | 36A | PM | 1013 | 8 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | 1 | 0 | 0 | 0 | 0 | running from #7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.960657061561 40.7956150744102) | 19 | 4 | 19 | 13 | |||||
3941 | 3941 | -73.9680833729772 | 40.774187102511505 | 12H-PM-1007-08 | 12H | PM | 1007 | 8 | + | Above Ground | 7.0 | in tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9680833729772 40.7741871025115) | 19 | 4 | 19 | 13 | |||||||
4071 | 4071 | -73.9587879699956 | 40.7908135158551 | 32F-AM-1012-01 | 32F | AM | 1012 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | made a back-door escape from dog off-leash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9587879699956 40.7908135158551) | 19 | 4 | 19 | 13 | |||||
4200 | 4200 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 1014 | 4 | Gray | White | Gray+White | Above Ground | 15.0 | Ground then tree to eat | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.958719099962 40.7947587726617) | 19 | 4 | 19 | 13 | |||||
4436 | 4436 | -73.96717867152559 | 40.7867352791232 | 25A-AM-1013-04 | 25A | AM | 1013 | 4 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9671786715256 40.7867352791232) | 19 | 4 | 19 | 13 | ||||||
4479 | 4479 | -73.9602609920814 | 40.7942883045566 | 35C-PM-1013-03 | 35C | PM | 1013 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9602609920814 40.7942883045566) | 19 | 4 | 19 | 13 | ||||||
4573 | 4573 | -73.96077013704429 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 1013 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | 0 | 1 | 0 | 0 | 0 | chasing #8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9607701370443 40.7955418990855) | 19 | 4 | 19 | 13 | |||||
4720 | 4720 | -73.9634563222926 | 40.780992836417 | 21G-PM-1007-04 | 21G | PM | 1007 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9634563222926 40.780992836417) | 19 | 4 | 19 | 13 | ||||||
4765 | 4765 | -73.96021668769791 | 40.7953811003986 | 36B-AM-1013-04 | 36B | AM | 1013 | 4 | Black | Black+ | Above Ground | 20.0 | Moved 20+ feet high above top of tree limb | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9602166876979 40.7953811003986) | 19 | 4 | 19 | 13 | ||||||
5007 | 5007 | -73.9601259189134 | 40.795535060905706 | 36B-PM-1013-04 | 36B | PM | 1013 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9601259189134 40.7955350609057) | 19 | 4 | 19 | 13 | ||||||
5029 | 5029 | -73.9586085843149 | 40.7946617684536 | 36C-AM-1014-03 | 36C | AM | 1014 | 3 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9586085843149 40.7946617684536) | 19 | 4 | 19 | 13 | |||||||
5120 | 5120 | -73.9603245806655 | 40.79427124776971 | 35C-PM-1013-04 | 35C | PM | 1013 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9603245806655 40.7942712477697) | 19 | 4 | 19 | 13 | ||||||
5166 | 5166 | -73.95985354257058 | 40.7915589343685 | 33D-PM-1006-01 | 33D | PM | 1006 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | hanging on fence | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9598535425706 40.7915589343685) | 19 | 4 | 19 | 13 | |||||
5273 | 5273 | -73.967097592707 | 40.785411934253794 | 24B-AM-1013-01 | 24B | AM | 1013 | 1 | Gray | Gray+ | Above Ground | 50.0 | 1 | 0 | 0 | 1 | 0 | took nut to bury | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.967097592707 40.7854119342538) | 19 | 4 | 19 | 13 | ||||||
5353 | 5353 | -73.9612349421547 | 40.795958647574395 | 36A-PM-1013-09 | 36A | PM | 1013 | 9 | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9612349421547 40.7959586475744) | 19 | 4 | 19 | 13 | ||||||
5456 | 5456 | -73.9695176417703 | 40.7741725190048 | 12G-PM-1007-04 | 12G | PM | 1007 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9695176417703 40.7741725190048) | 19 | 4 | 19 | 13 | ||||||
5627 | 5627 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 1006 | 3 | Black | Black+ | Above Ground | 15.0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ran up tree | POINT (-73.959709414696 40.7919745085986) | 19 | 4 | 19 | 13 | ||||||
5857 | 5857 | -73.98096101171708 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 1010 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
5954 | 5954 | -73.9598340783572 | 40.7915857030295 | 33D-PM-1006-02 | 33D | PM | 1006 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9598340783572 40.7915857030295) | 19 | 4 | 19 | 13 | ||||||
6036 | 6036 | -73.9554432393295 | 40.794566905444896 | 37F-PM-1014-01 | 37F | PM | 1014 | 1 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9554432393295 40.7945669054449) | 19 | 4 | 19 | 13 | |||||||
4 | 4 | -73.95394000282359 | 40.79800412717 | 41E-AM-1007-02 | 41E | AM | 1007 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9539400028236 40.79800412717) | 19 | 4 | 19 | 13 | ||||||
22 | 22 | -73.9618094076328 | 40.7944097368153 | 35A-PM-1013-03 | 35A | PM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9618094076328 40.7944097368153) | 19 | 4 | 19 | 13 | |||||
28 | 28 | -73.9623696148045 | 40.792184861375 | 32B-AM-1017-04 | 32B | AM | 1017 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9623696148045 40.792184861375) | 19 | 4 | 19 | 13 | |||||
34 | 34 | -73.95693753558841 | 40.793539800861204 | 36E-AM-1013-02 | 36E | AM | 1013 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569375355884 40.7935398008612) | 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 | ||||||
41 | 41 | -73.9741621946917 | 40.775248147202504 | 11C-PM-1018-01 | 11C | PM | 1018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9741621946917 40.7752481472025) | 19 | 4 | 19 | 13 | |||||
44 | 44 | -73.9802831706033 | 40.7692763295564 | 3A-AM-1012-02 | 03A | AM | 1012 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9802831706033 40.7692763295564) | 19 | 4 | 19 | 13 | ||||
48 | 48 | -73.9584064203778 | 40.7912272455454 | 33F-PM-1012-04 | 33F | PM | 1012 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9584064203778 40.7912272455454) | 19 | 4 | 19 | 13 | |||||
50 | 50 | -73.955258162768 | 40.7958147673603 | 39E-AM-1018-01 | 39E | AM | 1018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | standing still | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.955258162768 40.7958147673603) | 19 | 4 | 19 | 13 | ||||
51 | 51 | -73.957600085245 | 40.7936111607879 | 35E-PM-1006-04 | 35E | PM | 1006 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.957600085245 40.7936111607879) | 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 | |||||
56 | 56 | -73.967767372181 | 40.784702631615 | 23B-PM-1012-07 | 23B | PM | 1012 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.967767372181 40.784702631615) | 19 | 4 | 19 | 13 | |||||
59 | 59 | -73.9520592496349 | 40.797507629981105 | 42G-PM-1014-03 | 42G | PM | 1014 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4.0 | on fence | 1 | 0 | 0 | 0 | 0 | prancing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9520592496349 40.7975076299811) | 19 | 4 | 19 | 13 | |||
65 | 65 | -73.9735833104203 | 40.7786318041581 | 14A-PM-1014-08 | 14A | PM | 1014 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | new movement flailing arms while foraging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9735833104203 40.7786318041581) | 19 | 4 | 19 | 13 | ||||
68 | 68 | -73.9718597156773 | 40.776585876331296 | 13C-PM-1019-04 | 13C | PM | 1019 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9718597156773 40.7765858763313) | 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 | ||||
78 | 78 | -73.97554590905341 | 40.7680866624003 | 4E-AM-1020-04 | 04E | AM | 1020 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | chillin' | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9755459090534 40.7680866624003) | 19 | 4 | 19 | 13 | ||||
83 | 83 | -73.9586570546871 | 40.796349417475 | 38C-AM-1019-09 | 38C | AM | 1019 | 9 | Adult | Gray | White | Gray+White | Gray & White selected as Primary & Highlights. Made executive adjustments. | Above Ground | 3.0 | Between ground & tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9586570546871 40.796349417475) | 19 | 4 | 19 | 13 | |||
91 | 91 | -73.95759861613641 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25.0 | Climbing tree | 0 | 0 | 1 | 0 | 0 | climbing (tree) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575986161364 40.799368134968) | 19 | 4 | 19 | 13 | |||
93 | 93 | -73.9727230609785 | 40.7795341640894 | 16A-PM-1019-01 | 16A | PM | 1019 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9727230609785 40.7795341640894) | 19 | 4 | 19 | 13 | ||||||
97 | 97 | -73.9596445861554 | 40.79719486790071 | 38A-PM-1013-05 | 38A | PM | 1013 | 5 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9596445861554 40.7971948679007) | 19 | 4 | 19 | 13 | ||||||
99 | 99 | -73.97487092063541 | 40.77608025411 | 11B-PM-1014-01 | 11B | PM | 1014 | 1 | Adult | Gray | Gray+ | Fat! | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9748709206354 40.77608025411) | 19 | 4 | 19 | 13 | |||||
104 | 104 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 1007 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9579645940414 40.7918613498407) | 19 | 4 | 19 | 13 | |||||
107 | 107 | -73.95874591363909 | 40.7982497351812 | 40B-PM-1014-05 | 40B | PM | 1014 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9587459136391 40.7982497351812) | 19 | 4 | 19 | 13 | |||||
108 | 108 | -73.954554245377 | 40.7983935730557 | 41E-AM-1007-05 | 41E | AM | 1007 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | man/pit bull mix wandered | POINT (-73.954554245377 40.7983935730557) | 19 | 4 | 19 | 13 | ||||
111 | 111 | -73.9558118887106 | 40.796885713436 | 39E-PM-1013-01 | 39E | PM | 1013 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9558118887106 40.796885713436) | 19 | 4 | 19 | 13 | ||||
114 | 114 | -73.96721526968341 | 40.782387458182896 | 21D-AM-1008-05 | 21D | AM | 1008 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9672152696834 40.7823874581829) | 19 | 4 | 19 | 13 | |||||
126 | 126 | -73.9725700261894 | 40.7668793330427 | 3H-PM-1014-01 | 03H | PM | 1014 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a parked car | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9725700261894 40.7668793330427) | 19 | 4 | 19 | 13 | |||||
143 | 143 | -73.9590074024938 | 40.7907059424675 | 32E-PM-1017-05 | 32E | PM | 1017 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9590074024938 40.7907059424675) | 19 | 4 | 19 | 13 | |||||
145 | 145 | -73.97535742799359 | 40.768321169425704 | 4E-PM-1008-08 | 04E | PM | 1008 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9753574279936 40.7683211694257) | 19 | 4 | 19 | 13 | ||||||
146 | 146 | -73.9564777440695 | 40.7993068355401 | 42C-AM-1007-01 | 42C | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | nut in mouth | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9564777440695 40.7993068355401) | 19 | 4 | 19 | 13 | ||||
155 | 155 | -73.9649611089685 | 40.7814371834837 | 21F-AM-1018-05 | 21F | AM | 1018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9649611089685 40.7814371834837) | 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 | ||||
163 | 163 | -73.96294833745279 | 40.7936809905265 | 33A-PM-1018-03 | 33A | PM | 1018 | 3 | Adult | Gray | Gray+ | Above Ground | 6.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9629483374528 40.7936809905265) | 19 | 4 | 19 | 13 | ||||||
171 | 171 | -73.9550235589287 | 40.7951312356844 | 38F-AM-1018-03 | 38F | AM | 1018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9550235589287 40.7951312356844) | 19 | 4 | 19 | 13 | |||||
191 | 191 | -73.9680855277775 | 40.7769251965381 | 15F-AM-1007-10 | 15F | AM | 1007 | 10 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9680855277775 40.7769251965381) | 19 | 4 | 19 | 13 | |||||
193 | 193 | -73.9577919365342 | 40.796085328505896 | 38C-PM-1014-08 | 38C | PM | 1014 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9577919365342 40.7960853285059) | 19 | 4 | 19 | 13 | |||||
196 | 196 | -73.960237785199 | 40.7907831607574 | 32E-PM-1017-16 | 32E | PM | 1017 | 16 | Adult | Black | Black+ | Ground Plane | FALSE | rocky outcrop | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.960237785199 40.7907831607574) | 19 | 4 | 19 | 13 | |||||
203 | 203 | -73.9688070760806 | 40.777968829417205 | 16E-AM-1014-06 | 16E | AM | 1014 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9688070760806 40.7779688294172) | 19 | 4 | 19 | 13 | |||||
207 | 207 | -73.9587072763996 | 40.7850256219415 | 27I-AM-1007-01 | 27I | AM | 1007 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9587072763996 40.7850256219415) | 19 | 4 | 19 | 13 | |||||
212 | 212 | -73.9544808708211 | 40.7906575852286 | 34I-AM-1012-02 | 34I | AM | 1012 | 2 | Adult | Gray | White | Gray+White | Short tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hiding | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9544808708211 40.7906575852286) | 19 | 4 | 19 | 13 | |||
218 | 218 | -73.959412243507 | 40.7917871123534 | 33E-AM-1014-01 | 33E | AM | 1014 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.959412243507 40.7917871123534) | 19 | 4 | 19 | 13 | ||||
222 | 222 | -73.9545399102352 | 40.7898646267709 | 33I-PM-1006-06 | 33I | PM | 1006 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9545399102352 40.7898646267709) | 19 | 4 | 19 | 13 | ||||||
230 | 230 | -73.953123365424 | 40.7941113777459 | 38H-PM-1012-01 | 38H | PM | 1012 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.953123365424 40.7941113777459) | 19 | 4 | 19 | 13 | ||||||
231 | 231 | -73.9653142636891 | 40.776001512929795 | 15I-AM-1008-04 | 15I | AM | 1008 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9653142636891 40.7760015129298) | 19 | 4 | 19 | 13 | ||||||
234 | 234 | -73.9769520212123 | 40.774006725862996 | 9A-AM-1013-01 | 09A | AM | 1013 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9769520212123 40.774006725863) | 19 | 4 | 19 | 13 | |||||
235 | 235 | -73.96137019608979 | 40.7943363227822 | 35B-PM-1013-04 | 35B | PM | 1013 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | got threatened by dog (same dog,dog #1) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9613701960898 40.7943363227822) | 19 | 4 | 19 | 13 | ||||
249 | 249 | -73.9597048490102 | 40.7955846466241 | 37B-AM-1018-06 | 37B | AM | 1018 | 6 | Adult | Gray | Gray+ | Above Ground | 1.0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9597048490102 40.7955846466241) | 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 )