This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, 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 | Lat/Long | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | 10 | -73.9596413903948 | 40.7903128889029 | 32E-PM-1017-14 | 32E | PM | 10172018 | 14 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9596413903948 40.7903128889029) | 19 | 4 | 19 | 13 | |||||||
528 | 528 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9647284206644 40.7839611840884) | 19 | 4 | 19 | 13 | |||||
650 | 650 | -73.9809610117171 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 10102018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
683 | 683 | -73.9707683621584 | 40.7759815566123 | 13E-AM-1017-11 | 13E | AM | 10172018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on/in log | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9707683621584 40.77598155661231) | 19 | 4 | 19 | 13 | |||||
867 | 867 | -73.9762257701293 | 40.7744032758323 | 9A-AM-1013-08 | 09A | AM | 10132018 | 8 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9762257701293 40.7744032758323) | 19 | 4 | 19 | 13 | |||||||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | true | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
1126 | 1126 | -73.9700186001049 | 40.7826052184658 | 20B-AM-1007-03 | 20B | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9700186001049 40.7826052184658) | 19 | 4 | 19 | 13 | ||||||
1429 | 1429 | -73.9706533131129 | 40.768902033819 | 6I-AM-1006-01 | 06I | AM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | true | false | true | true | true | false | false | false | false | false | false | false | true | runs from (someone sneezed) | POINT (-73.9706533131129 40.768902033819) | 19 | 4 | 19 | 13 | |||||
1592 | 1592 | -73.9575517912392 | 40.7889158268192 | 31H-PM-1008-05 | 31H | PM | 10082018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9575517912392 40.7889158268192) | 19 | 4 | 19 | 13 | ||||||
1619 | 1619 | -73.9744555348544 | 40.7728498106357 | 8D-PM-1007-03 | 08D | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9744555348544 40.7728498106357) | 19 | 4 | 19 | 13 | |||||||
1645 | 1645 | -73.9619673317128 | 40.7924176673037 | 33B-PM-1010-08 | 33B | PM | 10102018 | 8 | Juvenile | Gray | Gray+ | Above Ground | running up tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9619673317128 40.7924176673037) | 19 | 4 | 19 | 13 | ||||||
1755 | 1755 | -73.9714798196777 | 40.7695231949631 | 6H-PM-1020-02 | 06H | PM | 10202018 | 2 | Adult | + | Above Ground | Fence pole | false | false | true | false | false | false | false | false | false | false | false | false | true | runs from (me) | POINT (-73.9714798196777 40.7695231949631) | 19 | 4 | 19 | 13 | ||||||
1765 | 1765 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
1850 | 1850 | -73.975809362521 | 40.7734702737835 | 8B-PM-1012-09 | 08B | PM | 10122018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.975809362521 40.7734702737835) | 19 | 4 | 19 | 13 | |||||
2102 | 2102 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | false | false | false | true | true | watching | false | false | false | false | false | false | false | true | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
2347 | 2347 | -73.9663124560664 | 40.779544003786 | 18F-PM-1008-02 | 18F | PM | 10082018 | 2 | Adult | Gray | Gray+ | false | false | false | false | false | hopping around | false | false | false | false | false | false | false | true | POINT (-73.9663124560664 40.779544003786) | 19 | 4 | 19 | 13 | |||||||
2522 | 2522 | -73.9658747245917 | 40.7754033737532 | 14I-PM-1018-01 | 14I | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9658747245917 40.7754033737532) | 19 | 4 | 19 | 13 | |||||
2631 | 2631 | -73.9690080105286 | 40.7710230515054 | 9I-PM-1010-03 | 09I | PM | 10102018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.9690080105286 40.7710230515054) | 19 | 4 | 19 | 13 | |||||||
2784 | 2784 | -73.9763722433833 | 40.7744121430891 | 9A-AM-1013-07 | 09A | AM | 10132018 | 7 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9763722433833 40.7744121430891) | 19 | 4 | 19 | 13 | |||||||||
2910 | 2910 | -73.9506062997507 | 40.7976189496674 | 42H-PM-1014-03 | 42H | PM | 10142018 | 3 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9506062997507 40.7976189496674) | 12423 | 18 | 4 | 36 | 18 | ||||||||
808 | 808 | -73.9716881838671 | 40.778553537087 | 15C-PM-1017-02 | 15C | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 0 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9716881838671 40.778553537087) | 19 | 4 | 19 | 13 | |||||
547 | 547 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | true | true | false | false | false | chasing and being chased by #6 | false | false | false | false | true | false | false | true | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
552 | 552 | -73.9625416200877 | 40.7811302397912 | 21H-AM-1017-02 | 21H | AM | 10172018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9625416200877 40.78113023979121) | 19 | 4 | 19 | 13 | |||||
598 | 598 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 10182018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
602 | 602 | -73.9685751595485 | 40.7709413567859 | 9I-PM-1010-07 | 09I | PM | 10102018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 1 | ran up tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685751595485 40.7709413567859) | 19 | 4 | 19 | 13 | ||||
820 | 820 | -73.9801902133148 | 40.769557595068 | 3A-AM-1012-03 | 03A | AM | 10122018 | 3 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Above Ground | 1 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9801902133148 40.769557595068) | 19 | 4 | 19 | 13 | ||||
1297 | 1297 | -73.9802831706033 | 40.7692763295564 | 3A-AM-1012-02 | 03A | AM | 10122018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 1 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9802831706033 40.7692763295564) | 19 | 4 | 19 | 13 | ||||
1476 | 1476 | -73.976609486498 | 40.7717832922535 | 7C-PM-1020-04 | 07C | PM | 10202018 | 4 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.976609486498 40.7717832922535) | 19 | 4 | 19 | 13 | ||||||
1625 | 1625 | -73.9736873018042 | 40.7649106677138 | 1I-PM-1012-02 | 01I | PM | 10122018 | 2 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | tree | false | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9736873018042 40.7649106677138) | 19 | 4 | 19 | 13 | |||
1662 | 1662 | -73.9561600237284 | 40.7953143196705 | 38E-AM-1010-10 | 38E | AM | 10102018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | over a log across stream | false | false | false | false | false | chillin' | false | false | false | false | false | false | false | true | runs from leaf blower | POINT (-73.9561600237284 40.7953143196705) | 19 | 4 | 19 | 13 | ||
1714 | 1714 | -73.9763542780331 | 40.7736531303622 | 9B-AM-1010-02 | 09B | AM | 10102018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | in bush | false | false | true | false | true | false | false | false | false | true | false | false | true | froze | POINT (-73.9763542780331 40.773653130362206) | 19 | 4 | 19 | 13 | |||
2018 | 2018 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 10182018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
2215 | 2215 | -73.9674978826751 | 40.776288410765 | 15G-PM-1019-10 | 15G | PM | 10192018 | 10 | Adult | Gray | Gray+ | Above Ground | 1 | on a log | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9674978826751 40.776288410765) | 19 | 4 | 19 | 13 | |||||
2389 | 2389 | -73.9801343393329 | 40.7691512453402 | 3A-AM-1012-01 | 03A | AM | 10122018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9801343393329 40.7691512453402) | 19 | 4 | 19 | 13 | ||||
2577 | 2577 | -73.9597048490102 | 40.7955846466241 | 37B-AM-1018-06 | 37B | AM | 10182018 | 6 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9597048490102 40.7955846466241) | 19 | 4 | 19 | 13 | ||||||
2595 | 2595 | -73.9692676659807 | 40.7700678919108 | 8I-PM-1013-08 | 08I | PM | 10132018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.96926766598071 40.7700678919108) | 19 | 4 | 19 | 13 | |||||
2874 | 2874 | -73.9597453664295 | 40.7891382153733 | 30F-PM-1007-01 | 30F | PM | 10072018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 1 | tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9597453664295 40.7891382153733) | 19 | 4 | 19 | 13 | ||||
258 | 258 | -73.9534333425633 | 40.7932564163328 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | false | false | false | true | false | false | true | false | false | false | false | false | true | POINT (-73.9534333425633 40.7932564163328) | 19 | 4 | 19 | 13 | ||||
337 | 337 | -73.9583101927652 | 40.7852649316039 | 27I-PM-1020-05 | 27I | PM | 10202018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | In tree | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (us) | POINT (-73.9583101927652 40.7852649316039) | 19 | 4 | 19 | 13 | |||
509 | 509 | -73.9714289592392 | 40.7750670702093 | 12E-PM-1018-04 | 12E | PM | 10182018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9714289592392 40.7750670702093) | 19 | 4 | 19 | 13 | ||||||
534 | 534 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9650499507011 40.7908191782173) | 19 | 4 | 19 | 13 | |||||
593 | 593 | -73.9593352806175 | 40.7918150568046 | 33E-AM-1014-02 | 33E | AM | 10142018 | 2 | Juvenile | Black | Black+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9593352806175 40.7918150568046) | 19 | 4 | 19 | 13 | ||||||
667 | 667 | -73.9624538733037 | 40.7883829851518 | 28D-AM-1012-04 | 28D | AM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9624538733037 40.7883829851518) | 19 | 4 | 19 | 13 | |||||
858 | 858 | -73.9629383420274 | 40.7889383725489 | 29C-AM-1007-02 | 29C | AM | 10072018 | 2 | Adult | Black | Gray | Black+Gray | Above Ground | 10 | true | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9629383420274 40.7889383725489) | 19 | 4 | 19 | 13 | |||||
865 | 865 | -73.9741621946917 | 40.7752481472025 | 11C-PM-1018-01 | 11C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9741621946917 40.7752481472025) | 19 | 4 | 19 | 13 | |||||
890 | 890 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | oak tree | false | true | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9667755678511 40.7760256836088) | 19 | 4 | 19 | 13 | |||||
930 | 930 | -73.9622030085794 | 40.7917723228749 | 32B-AM-1017-01 | 32B | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | ran up a tree | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9622030085794 40.7917723228749) | 19 | 4 | 19 | 13 | ||||
1055 | 1055 | -73.9632337134707 | 40.7914682370734 | 31B-PM-1007-01 | 31B | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | true | false | false | chasing #2 and climbing tree w/ #2 | false | false | false | false | false | false | false | true | POINT (-73.9632337134707 40.7914682370734) | 19 | 4 | 19 | 13 | ||||
1060 | 1060 | -73.9728871061191 | 40.7712983658944 | 8F-PM-1012-08 | 08F | PM | 10122018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9728871061191 40.7712983658944) | 19 | 4 | 19 | 13 | |||||
1125 | 1125 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | on stone arch | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9775735077285 40.7692872082165) | 19 | 4 | 19 | 13 | ||||
1206 | 1206 | -73.9748709206354 | 40.77608025411 | 11B-PM-1014-01 | 11B | PM | 10142018 | 1 | Adult | Gray | Gray+ | Fat! | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9748709206354 40.77608025411) | 19 | 4 | 19 | 13 | |||||
1268 | 1268 | -73.9623984262936 | 40.7913900453449 | 31C-PM-1010-03 | 31C | PM | 10102018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9623984262936 40.7913900453449) | 19 | 4 | 19 | 13 | |||||
1324 | 1324 | -73.954554245377 | 40.7983935730557 | 41E-AM-1007-05 | 41E | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | man/pit bull mix wandered | POINT (-73.954554245377 40.7983935730557) | 19 | 4 | 19 | 13 | ||||
1581 | 1581 | -73.97157754108 | 40.7776249963967 | 14C-PM-1006-01 | 14C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.97157754108 40.7776249963967) | 19 | 4 | 19 | 13 | |||||
1665 | 1665 | -73.9583944353352 | 40.7979689846815 | 39B-PM-1014-04 | 39B | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | true | runs from (me—when i approached) | POINT (-73.9583944353352 40.7979689846815) | 19 | 4 | 19 | 13 | |||||
1698 | 1698 | -73.9631392113757 | 40.7914635635784 | 31B-PM-1007-02 | 31B | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | true | false | false | chasing #1 and climbing tree w/ #1 | false | false | false | false | false | false | false | true | POINT (-73.9631392113757 40.7914635635784) | 19 | 4 | 19 | 13 | ||||
1871 | 1871 | -73.9748367344424 | 40.7693513000034 | 5E-PM-1012-06 | 05E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | oak tree at end of ramp from Chess House | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9748367344424 40.7693513000034) | 19 | 4 | 19 | 13 | ||||
2206 | 2206 | -73.9594446018346 | 40.7917800352042 | 33D-AM-1017-06 | 33D | AM | 10172018 | 6 | Adult | Black | Black+ | Above Ground | 10 | false | false | true | false | false | true | true | false | false | false | false | false | true | runs from (ran into hole in tree trunk) | POINT (-73.9594446018346 40.7917800352042) | 19 | 4 | 19 | 13 | |||||
2288 | 2288 | -73.9577009571427 | 40.796126044521 | 38C-PM-1014-10 | 38C | PM | 10142018 | 10 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | false | false | true | true | true | climbing (down from ~10') | false | false | false | false | false | false | false | true | POINT (-73.9577009571427 40.796126044521) | 19 | 4 | 19 | 13 | ||||
2366 | 2366 | -73.9676191846985 | 40.777641740817 | 16F-PM-1013-04 | 16F | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9676191846985 40.777641740817) | 19 | 4 | 19 | 13 | |||||
2397 | 2397 | -73.9704592500888 | 40.772962887933 | 10G-AM-1006-03 | 10G | AM | 10062018 | 3 | Juvenile | Gray | White | Gray+White | tuft on butt | Above Ground | 10 | false | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9704592500888 40.772962887933) | 19 | 4 | 19 | 13 | ||||
2927 | 2927 | -73.9650120066074 | 40.7805932882407 | 20F-PM-1007-13 | 20F | PM | 10072018 | 13 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9650120066074 40.78059328824071) | 19 | 4 | 19 | 13 | |||||
2811 | 2811 | -73.9756889766089 | 40.7676078308589 | 3F-AM-1006-14 | 03F | AM | 10062018 | 14 | Adult | Gray | White | Gray+White | Above Ground | 12 | true | false | true | false | false | running from dog | false | false | false | false | false | false | false | true | POINT (-73.9756889766089 40.7676078308589) | 19 | 4 | 19 | 13 | ||||
147 | 147 | -73.9564023626619 | 40.7905423546155 | 33G-AM-1013-02 | 33G | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | shelter in hole in tree | false | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9564023626619 40.7905423546155) | 19 | 4 | 19 | 13 | |||||
364 | 364 | -73.9623696148045 | 40.792184861375 | 32B-AM-1017-04 | 32B | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9623696148045 40.792184861375) | 19 | 4 | 19 | 13 | |||||
923 | 923 | -73.9578924882613 | 40.789806297824 | 32G-AM-1010-02 | 32G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | false | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9578924882613 40.789806297824) | 19 | 4 | 19 | 13 | ||||||
1640 | 1640 | -73.9564632239432 | 40.7904807427954 | 33G-AM-1013-01 | 33G | AM | 10132018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 13 | shelter in hole in tree | false | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9564632239432 40.7904807427954) | 19 | 4 | 19 | 13 | |||||
1949 | 1949 | -73.9605362268777 | 40.7939470599346 | 35C-AM-1007-02 | 35C | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9605362268777 40.7939470599346) | 19 | 4 | 19 | 13 | |||||
2767 | 2767 | -73.9751806727197 | 40.7671940332258 | 3F-PM-1013-05 | 03F | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 13 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97518067271972 40.7671940332258) | 19 | 4 | 19 | 13 | |||||
331 | 331 | -73.95448101115 | 40.7954469678857 | 39F-PM-1006-03 | 39F | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15 | lower branch of tree | false | false | false | true | false | false | false | false | false | false | false | false | true | ran up tree when approached | POINT (-73.95448101115 40.7954469678857) | 19 | 4 | 19 | 13 | |||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | true | false | false | true | false | false | false | false | false | true | false | false | true | ran up tree | POINT (-73.959709414696 40.7919745085986) | 19 | 4 | 19 | 13 | ||||||
503 | 503 | -73.9598340783572 | 40.7915857030295 | 33D-PM-1006-02 | 33D | PM | 10062018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.95983407835722 40.7915857030295) | 19 | 4 | 19 | 13 | ||||||
510 | 510 | -73.9638590768396 | 40.7776782114981 | 18I-AM-1017-02 | 18I | AM | 10172018 | 2 | Adult | Gray | Black | Gray+Black | Above Ground | 15 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9638590768396 40.7776782114981) | 19 | 4 | 19 | 13 | |||||
852 | 852 | -73.9609704650925 | 40.7938786854735 | 34B-AM-1013-03 | 34B | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | true | false | true | false | false | hopping | false | false | false | false | false | true | false | true | POINT (-73.9609704650925 40.7938786854735) | 19 | 4 | 19 | 13 | ||||
1426 | 1426 | -73.9664986446294 | 40.778308334318 | 17G-PM-1017-02 | 17G | PM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664986446294 40.778308334318) | 19 | 4 | 19 | 13 | ||||||
1489 | 1489 | -73.9501762527462 | 40.7975534086077 | 42H-PM-1014-05 | 42H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9501762527462 40.7975534086077) | 12423 | 18 | 4 | 36 | 18 | ||||
1767 | 1767 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 10142018 | 4 | Gray | White | Gray+White | Above Ground | 15 | Ground then tree to eat | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.958719099962 40.7947587726617) | 19 | 4 | 19 | 13 | |||||
1939 | 1939 | -73.9540151828782 | 40.7920066170587 | 35H-AM-1013-01 | 35H | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | Climbing up tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9540151828782 40.7920066170587) | 19 | 4 | 19 | 13 | ||||
2142 | 2142 | -73.9598535425706 | 40.7915589343685 | 33D-PM-1006-01 | 33D | PM | 10062018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | hanging on fence | true | false | false | true | false | false | false | true | POINT (-73.9598535425706 40.7915589343685) | 19 | 4 | 19 | 13 | |||||
2242 | 2242 | -73.9565824187667 | 40.797312050952 | 40D-AM-1013-06 | 40D | AM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | true | false | true | false | true | true | false | false | false | true | false | false | true | POINT (-73.9565824187667 40.797312050952) | 19 | 4 | 19 | 13 | |||||
2779 | 2779 | -73.9767835160078 | 40.7674030330482 | 2E-PM-1014-04 | 02E | PM | 10142018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9767835160078 40.7674030330482) | 19 | 4 | 19 | 13 | |||||
3008 | 3008 | -73.9503533343658 | 40.7976543603953 | 42H-PM-1014-04 | 42H | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | true | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9503533343658 40.7976543603953) | 12423 | 18 | 4 | 36 | 18 | ||||
2815 | 2815 | -73.9747311312394 | 40.7677319725044 | 3F-PM-1013-06 | 03F | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 19 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.97473113123941 40.7677319725044) | 19 | 4 | 19 | 13 | |||||
98 | 98 | -73.9730277911422 | 40.7712145488828 | 7F-AM-1008-16 | 07F | AM | 10082018 | 16 | Juvenile | Gray | Gray+ | Above Ground | 2 | tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9730277911422 40.7712145488828) | 19 | 4 | 19 | 13 | |||||
341 | 341 | -73.9703161745884 | 40.7702610461336 | 8H-PM-1014-05 | 08H | PM | 10142018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9703161745884 40.7702610461336) | 19 | 4 | 19 | 13 | ||||||
506 | 506 | -73.9649611089685 | 40.7814371834837 | 21F-AM-1018-05 | 21F | AM | 10182018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9649611089685 40.7814371834837) | 19 | 4 | 19 | 13 | |||||
951 | 951 | -73.971791854883 | 40.7802971729784 | 17B-PM-1012-01 | 17B | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | climbed a fence | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.971791854883 40.7802971729784) | 19 | 4 | 19 | 13 | |||||
1070 | 1070 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 10172018 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2 | Fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674631254594 40.7790076357696) | 19 | 4 | 19 | 13 | |||||
1395 | 1395 | -73.9710801547498 | 40.7760872452093 | 13D-AM-1014-03 | 13D | AM | 10142018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 2 | false | true | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9710801547498 40.7760872452093) | 19 | 4 | 19 | 13 | |||||
1434 | 1434 | -73.9760749752948 | 40.7703284894392 | 5D-PM-1018-02 | 05D | PM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | On low fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9760749752948 40.7703284894392) | 19 | 4 | 19 | 13 | |||||
1553 | 1553 | -73.9690645326017 | 40.7773822116124 | 15E-AM-1013-03 | 15E | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | on fallen log | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9690645326017 40.7773822116124) | 19 | 4 | 19 | 13 | |||||
2034 | 2034 | -73.9699135187297 | 40.7782354186163 | 16D-AM-1007-03 | 16D | AM | 10072018 | 3 | Adult | + | ran away before I could take a good look | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9699135187297 40.7782354186163) | 19 | 4 | 19 | 13 | ||||||
2067 | 2067 | -73.9725077933574 | 40.7654562710325 | 2I-PM-1006-01 | 02I | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | Sitting on back of bench with food hanging from mouth | false | false | false | false | false | staring at me | false | false | false | false | false | false | false | true | POINT (-73.9725077933574 40.7654562710325) | 19 | 4 | 19 | 13 | |||
2244 | 2244 | -73.9509628195532 | 40.7977775674178 | 42H-PM-1014-01 | 42H | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9509628195532 40.7977775674178) | 12423 | 18 | 4 | 36 | 18 | ||||
2419 | 2419 | -73.9590551473416 | 40.7891607060794 | 31F-PM-1007-02 | 31F | PM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | tree trunk | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.95905514734162 40.7891607060794) | 19 | 4 | 19 | 13 | |||||
2745 | 2745 | -73.97296259363 | 40.7652601851275 | 1I-PM-1012-04 | 01I | PM | 10122018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 2 | on ledge | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.97296259363 40.7652601851275) | 19 | 4 | 19 | 13 | |||
2803 | 2803 | -73.9576652087316 | 40.7875457977801 | 29H-PM-1006-02 | 29H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9576652087316 40.7875457977801) | 19 | 4 | 19 | 13 | ||||||
268 | 268 | -73.968107276769 | 40.7768612676036 | 15F-AM-1007-09 | 15F | AM | 10072018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.968107276769 40.7768612676036) | 19 | 4 | 19 | 13 | |||||
497 | 497 | -73.9602166876979 | 40.7953811003986 | 36B-AM-1013-04 | 36B | AM | 10132018 | 4 | Black | Black+ | Above Ground | 20 | Moved 20+ feet high above top of tree limb | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9602166876979 40.7953811003986) | 19 | 4 | 19 | 13 | ||||||
555 | 555 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685227310735 40.776599466588) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE squirrels( "Longitude" TEXT, "Latitude" TEXT, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" TEXT, "Hectare Squirrel Number" TEXT, "Age" TEXT, "Primary Fur Color" TEXT, "Highlight Fur Color" TEXT, "Combination of Primary and Highlight Color" TEXT, "Color notes" TEXT, "Location" TEXT, "Above Ground Sighter Measurement" TEXT, "Specific Location" TEXT, "Running" TEXT, "Chasing" TEXT, "Climbing" TEXT, "Eating" TEXT, "Foraging" TEXT, "Other Activities" TEXT, "Kuks" TEXT, "Quaas" TEXT, "Moans" TEXT, "Tail flags" TEXT, "Tail twitches" TEXT, "Approaches" TEXT, "Indifferent" TEXT, "Runs from" TEXT, "Other Interactions" TEXT, "Lat/Long" TEXT, "Zip Codes" TEXT, "Community Districts" TEXT, "Borough Boundaries" TEXT, "City Council Districts" TEXT, "Police Precincts" TEXT );