Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Age, Highlight_Fur_Color, Combination_of_Primary_and_Highlight_Color, Location, Running, Chasing, Climbing, Eating, Kuks, Quaas, Moans, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Zip_Codes, Community_Districts, City_Council_Districts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 1019 | 4 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9688574691102 40.7837825208444) | 19 | 4 | 19 | 13 | ||||||||||
3 | 3 | -73.9795454787631 | 40.768802689274104 | 3B-PM-1007-09 | 03B | PM | 1007 | 9 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9795454787631 40.7688026892741) | 19 | 4 | 19 | 13 | |||||||||
67 | 67 | -73.9684657285532 | 40.7840113573723 | 22B-AM-1013-05 | 22B | AM | 1013 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looked down on me like her imperial subject | POINT (-73.9684657285532 40.7840113573723) | 19 | 4 | 19 | 13 | ||||
210 | 210 | -73.9752965316933 | 40.775253857578896 | 10B-AM-1006-03 | 10B | AM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | In tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9752965316933 40.7752538575789) | 19 | 4 | 19 | 13 | |||||
303 | 303 | -73.9561344937861 | 40.794082388408604 | 37F-PM-1014-03 | 37F | PM | 1014 | 3 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
316 | 316 | -73.9575517912392 | 40.788915826819206 | 31H-PM-1008-05 | 31H | PM | 1008 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575517912392 40.7889158268192) | 19 | 4 | 19 | 13 | ||||||
371 | 371 | -73.9756273257684 | 40.7706539186221 | 6D-AM-1008-04 | 06D | AM | 1008 | 4 | Adult | Gray | Gray+ | Above Ground | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9756273257684 40.7706539186221) | 19 | 4 | 19 | 13 | |||||||
425 | 425 | -73.973425927351 | 40.7781929919344 | 14B-AM-1007-03 | 14B | AM | 1007 | 3 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.973425927351 40.7781929919344) | 19 | 4 | 19 | 13 | ||||||||
445 | 445 | -73.9659549963516 | 40.7833659689194 | 22D-PM-1012-05 | 22D | PM | 1012 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9659549963516 40.7833659689194) | 19 | 4 | 19 | 13 | |||||||
485 | 485 | -73.9612854506075 | 40.792083067357105 | 32C-PM-1013-04 | 32C | PM | 1013 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 | |||||||
496 | 496 | -73.96855981061279 | 40.7807054868066 | 19D-PM-1008-02 | 19D | PM | 1008 | 2 | + | unknown - cannot see, only hear | Above Ground | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9685598106128 40.7807054868066) | 19 | 4 | 19 | 13 | ||||||||
505 | 505 | -73.9533319519277 | 40.7933647909449 | 37H-AM-1018-02 | 37H | AM | 1018 | 2 | Adult | Gray | Gray+ | Above Ground | Large tree by (fence of the conservatory) about to climb up | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | busy,ready to climb | POINT (-73.9533319519277 40.7933647909449) | 19 | 4 | 19 | 13 | |||||
530 | 530 | -73.9565759733611 | 40.7992461674802 | 42C-AM-1007-02 | 42C | AM | 1007 | 2 | + | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565759733611 40.7992461674802) | 19 | 4 | 19 | 13 | ||||||||||
542 | 542 | -73.969347812694 | 40.7744098063421 | 12G-PM-1007-02 | 12G | PM | 1007 | 2 | Gray | Gray+ | Above Ground | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969347812694 40.7744098063421) | 19 | 4 | 19 | 13 | |||||||
579 | 579 | -73.9708225719705 | 40.7772497804149 | 14D-PM-1019-13 | 14D | PM | 1019 | 13 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9708225719705 40.7772497804149) | 19 | 4 | 19 | 13 | ||||||||
598 | 598 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 1017 | 4 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
600 | 600 | -73.9762257701293 | 40.7744032758323 | 9A-AM-1013-08 | 09A | AM | 1013 | 8 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9762257701293 40.7744032758323) | 19 | 4 | 19 | 13 | |||||||||
677 | 677 | -73.95283537022091 | 40.7976456178263 | 41F-PM-1019-02 | 41F | PM | 1019 | 2 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9528353702209 40.7976456178263) | 19 | 4 | 19 | 13 | ||||||||||
691 | 691 | -73.96867781674841 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 1012 | 4 | + | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686778167484 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
745 | 745 | -73.97672201797249 | 40.77532621031229 | 10A-PM-1014-03 | 10A | PM | 1014 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | above my head in tree | 0 | 0 | 0 | 1 | 0 | eating (in a tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent (lots of people taking its picture,didn't bother it) | POINT (-73.9767220179725 40.7753262103123) | 12,420 | 20 | 4 | 19 | 12 | ||
819 | 819 | -73.97357503529591 | 40.7694500333777 | 6F-PM-1008-06 | 06F | PM | 1008 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | White patches. Almost looks like fox squirrel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9735750352959 40.7694500333777) | 19 | 4 | 19 | 13 | ||||||
859 | 859 | -73.9583934264026 | 40.7854742185504 | 27I-AM-1007-02 | 27I | AM | 1007 | 2 | + | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9583934264026 40.7854742185504) | 19 | 4 | 19 | 13 | ||||||||||
865 | 865 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 1014 | 7 | Adult | Gray | Gray+ | Above Ground | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
917 | 917 | -73.9532804650089 | 40.7934579333341 | 37H-PM-1006-05 | 37H | PM | 1006 | 5 | + | Above Ground | tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9532804650089 40.7934579333341) | 19 | 4 | 19 | 13 | ||||||||
943 | 943 | -73.95659058682759 | 40.7895654068546 | 32H-PM-1006-01 | 32H | PM | 1006 | 1 | Gray | Gray+ | Above Ground | in the European Beech | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565905868276 40.7895654068546) | 19 | 4 | 19 | 13 | |||||||
945 | 945 | -73.975809362521 | 40.773470273783495 | 8B-PM-1012-09 | 08B | PM | 1012 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.975809362521 40.7734702737835) | 19 | 4 | 19 | 13 | |||||
983 | 983 | -73.96732355553209 | 40.7786749596774 | 17F-PM-1020-04 | 17F | PM | 1020 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9673235555321 40.7786749596774) | 19 | 4 | 19 | 13 | ||||||
1075 | 1075 | -73.97487064155841 | 40.7744174965072 | 10B-AM-1006-02 | 10B | AM | 1006 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | High in a tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9748706415584 40.7744174965072) | 19 | 4 | 19 | 13 | |||||
1134 | 1134 | -73.9678774314725 | 40.7738535171265 | 12H-PM-1007-04 | 12H | PM | 1007 | 4 | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | mushroom | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9678774314725 40.7738535171265) | 19 | 4 | 19 | 13 | |||||||
1165 | 1165 | -73.9593126695714 | 40.797533370163 | 39B-AM-1018-01 | 39B | AM | 1018 | 1 | + | Above Ground | 0 | 0 | 0 | 0 | 0 | unknown | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9593126695714 40.797533370163) | 19 | 4 | 19 | 13 | ||||||||
1204 | 1204 | -73.97055600790999 | 40.7698499183436 | 7H-AM-1006-07 | 07H | AM | 1006 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97055600791 40.7698499183436) | 19 | 4 | 19 | 13 | |||||||
1228 | 1228 | -73.9595485734618 | 40.7835326425693 | 25I-PM-1007-08 | 25I | PM | 1007 | 8 | Adult | Gray | Gray+ | Above Ground | playing very high in tree w/ #7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9595485734618 40.7835326425693) | 19 | 4 | 19 | 13 | ||||||
1230 | 1230 | -73.98016364007441 | 40.769019205592606 | 2A-AM-1010-09 | 02A | AM | 1010 | 9 | Adult | Gray | White | Gray+White | Above Ground | climbing in bush | 0 | 0 | 1 | 0 | 0 | hopping & flipping around. this one was very energetic & jumping aorund | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | climbed a foot up a tree and watched me | POINT (-73.9801636400744 40.7690192055926) | 19 | 4 | 19 | 13 | |||
1273 | 1273 | -73.9663124560664 | 40.779544003786 | 18F-PM-1008-02 | 18F | PM | 1008 | 2 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | hopping around | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9663124560664 40.779544003786) | 19 | 4 | 19 | 13 | |||||||
1308 | 1308 | -73.95348783164721 | 40.7978951981698 | 41F-PM-1019-01 | 41F | PM | 1019 | 1 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9534878316472 40.7978951981698) | 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 | ||||||||
1352 | 1352 | -73.9695745672033 | 40.7791835122147 | 17D-AM-1008-06 | 17D | AM | 1008 | 6 | + | Above Ground | high in tree, couldn't see it, only heard it | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9695745672033 40.7791835122147) | 19 | 4 | 19 | 13 | ||||||||
1400 | 1400 | -73.9669432929573 | 40.779136518298 | 18F-AM-1014-01 | 18F | AM | 1014 | 1 | Adult | Gray | White | Gray+White | Above Ground | Low tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9669432929573 40.779136518298) | 19 | 4 | 19 | 13 | |||||
1421 | 1421 | -73.95947083287321 | 40.791192982895005 | 32E-AM-1007-07 | 32E | AM | 1007 | 7 | Adult | Gray | Gray+ | Above Ground | on tennis club house roof | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9594708328732 40.791192982895) | 19 | 4 | 19 | 13 | ||||||
1484 | 1484 | -73.97071972744808 | 40.777395680343105 | 14D-PM-1019-12 | 14D | PM | 1019 | 12 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707197274481 40.7773956803431) | 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 | ||||
1528 | 1528 | -73.97076836215841 | 40.775981556612294 | 13E-AM-1017-11 | 13E | AM | 1017 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on/in log | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9707683621584 40.7759815566123) | 19 | 4 | 19 | 13 | |||||
1529 | 1529 | -73.9600738985438 | 40.793832879875204 | 35C-PM-1013-08 | 35C | PM | 1013 | 8 | + | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | did not *see* | POINT (-73.9600738985438 40.7938328798752) | 19 | 4 | 19 | 13 | |||||||||
1567 | 1567 | -73.97870151846621 | 40.7690114585688 | 3B-PM-1007-06 | 03B | PM | 1007 | 6 | Juvenile | + | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9787015184662 40.7690114585688) | 19 | 4 | 19 | 13 | |||||||||
1622 | 1622 | -73.9770313887741 | 40.7724869252099 | 7B-AM-1008-05 | 07B | AM | 1008 | 5 | Adult | Gray | Gray+ | Above Ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770313887741 40.7724869252099) | 19 | 4 | 19 | 13 | |||||||
1793 | 1793 | -73.979316275899 | 40.769213472755496 | 3B-PM-1007-01 | 03B | PM | 1007 | 1 | Adult | Gray | White | Gray+White | Above Ground | in tree | 0 | 0 | 0 | 0 | 0 | chased by dog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.979316275899 40.7692134727555) | 19 | 4 | 19 | 13 | ||||
1837 | 1837 | -73.9596006938677 | 40.7834706440535 | 25I-PM-1007-07 | 25I | PM | 1007 | 7 | Adult | Gray | Gray+ | Above Ground | playing very high in tree w/ #8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9596006938677 40.7834706440535) | 19 | 4 | 19 | 13 | ||||||
1875 | 1875 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9647284206644 40.7839611840884) | 19 | 4 | 19 | 13 | |||||
1885 | 1885 | -73.9506062997507 | 40.797618949667395 | 42H-PM-1014-03 | 42H | PM | 1014 | 3 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9506062997507 40.7976189496674) | 12,423 | 18 | 4 | 36 | 18 | ||||||||
2014 | 2014 | -73.95877018015099 | 40.793412394152796 | 35D-PM-1013-04 | 35D | PM | 1013 | 4 | Juvenile | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.958770180151 40.7934123941528) | 19 | 4 | 19 | 13 | |||||||
2039 | 2039 | -73.970720187655 | 40.7774564799983 | 14D-PM-1019-11 | 14D | PM | 1019 | 11 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.970720187655 40.7774564799983) | 19 | 4 | 19 | 13 | ||||||||
2108 | 2108 | -73.9775067398903 | 40.772656614240105 | 7B-AM-1008-14 | 07B | AM | 1008 | 14 | Adult | Gray | Gray+ | Above Ground | on fence | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9775067398903 40.7726566142401) | 19 | 4 | 19 | 13 | ||||||
2158 | 2158 | -73.9586098170241 | 40.793965373389796 | 35D-AM-1019-01 | 35D | AM | 1019 | 1 | + | Above Ground | on tree, blue jays gathering nearby | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9586098170241 40.7939653733898) | 19 | 4 | 19 | 13 | ||||||||
2159 | 2159 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 1017 | 4 | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
2208 | 2208 | -73.96620636423451 | 40.789077866530704 | 28A-PM-1007-04 | 28A | PM | 1007 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 0 | looking at me & #5 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | freezes | POINT (-73.9662063642345 40.7890778665307) | 19 | 4 | 19 | 13 | |||||
2223 | 2223 | -73.95769134926691 | 40.7994216061391 | 41B-AM-1010-11 | 41B | AM | 1010 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | eating a mushroom! | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9576913492669 40.7994216061391) | 19 | 4 | 19 | 13 | ||||||
2235 | 2235 | -73.9704778551644 | 40.77831191136271 | 15D-AM-1007-05 | 15D | AM | 1007 | 5 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9704778551644 40.7783119113627) | 19 | 4 | 19 | 13 | |||||||||
2265 | 2265 | -73.9630822385425 | 40.7914844989865 | 31B-PM-1007-04 | 31B | PM | 1007 | 4 | Juvenile | Gray | Gray+ | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9630822385425 40.7914844989865) | 19 | 4 | 19 | 13 | ||||||||
2322 | 2322 | -73.9619673317128 | 40.7924176673037 | 33B-PM-1010-08 | 33B | PM | 1010 | 8 | Juvenile | Gray | Gray+ | Above Ground | running up tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9619673317128 40.7924176673037) | 19 | 4 | 19 | 13 | ||||||
2369 | 2369 | -73.9763722433833 | 40.7744121430891 | 9A-AM-1013-07 | 09A | AM | 1013 | 7 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763722433833 40.7744121430891) | 19 | 4 | 19 | 13 | |||||||||
2438 | 2438 | -73.9758152322587 | 40.76923774014671 | 4E-PM-1008-03 | 04E | PM | 1008 | 3 | Adult | Gray | Gray+ | 0 | 1 | 0 | 0 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9758152322587 40.7692377401467) | 19 | 4 | 19 | 13 | |||||||
2488 | 2488 | -73.9565260889843 | 40.7991807924337 | 42C-AM-1007-03 | 42C | AM | 1007 | 3 | + | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565260889843 40.7991807924337) | 19 | 4 | 19 | 13 | ||||||||||
2504 | 2504 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 1017 | 3 | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.953092053256 40.7982256930243) | 19 | 4 | 19 | 13 | ||||||||
2578 | 2578 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 1012 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
2587 | 2587 | -73.97760445784459 | 40.7697607308033 | 4C-PM-1010-15 | 04C | PM | 1010 | 15 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on tree | 0 | 1 | 0 | 0 | 0 | chasing #14 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9776044578446 40.7697607308033) | 19 | 4 | 19 | 13 | ||||
2649 | 2649 | -73.9727187453699 | 40.7669595710626 | 3H-AM-1008-02 | 03H | AM | 1008 | 2 | Adult | Gray | Gray+ | Above Ground | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9727187453699 40.7669595710626) | 19 | 4 | 19 | 13 | |||||||
2679 | 2679 | -73.9797122322834 | 40.767834758743504 | 1B-PM-1019-10 | 01B | PM | 1019 | 10 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | Dog chased up tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9797122322834 40.7678347587435) | 19 | 4 | 19 | 13 | |||||
2753 | 2753 | -73.9681960138614 | 40.7726867422002 | 11H-AM-1010-02 | 11H | AM | 1010 | 2 | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9681960138614 40.7726867422002) | 19 | 4 | 19 | 13 | ||||||||
2771 | 2771 | -73.9553038162633 | 40.7909367783223 | 34H-PM-1006-04 | 34H | PM | 1006 | 4 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Elm tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9553038162633 40.7909367783223) | 19 | 4 | 19 | 13 | ||||||
2781 | 2781 | -73.95082755733499 | 40.797579073666 | 42H-PM-1014-02 | 42H | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Above Ground | Running along stone ledge | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.950827557335 40.797579073666) | 18 | 4 | 36 | 18 | |||||
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 | ||||||
2868 | 2868 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 1017 | 3 | Adult | Gray | White | Gray+White | 1 | 1 | 1 | 0 | 0 | chasing (#4),digging | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957138794884 40.7985389822719) | 19 | 4 | 19 | 13 | ||||||
2898 | 2898 | -73.97147981967771 | 40.7695231949631 | 6H-PM-1020-02 | 06H | PM | 1020 | 2 | Adult | + | Above Ground | Fence pole | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (me) | POINT (-73.9714798196777 40.7695231949631) | 19 | 4 | 19 | 13 | ||||||
3024 | 3024 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 1019 | 4 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9688574691102 40.7837825208444) | 19 | 4 | 19 | 13 | ||||||||||
3026 | 3026 | -73.9795454787631 | 40.768802689274104 | 3B-PM-1007-09 | 03B | PM | 1007 | 9 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9795454787631 40.7688026892741) | 19 | 4 | 19 | 13 | |||||||||
3090 | 3090 | -73.9684657285532 | 40.7840113573723 | 22B-AM-1013-05 | 22B | AM | 1013 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looked down on me like her imperial subject | POINT (-73.9684657285532 40.7840113573723) | 19 | 4 | 19 | 13 | ||||
3233 | 3233 | -73.9752965316933 | 40.775253857578896 | 10B-AM-1006-03 | 10B | AM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | In tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9752965316933 40.7752538575789) | 19 | 4 | 19 | 13 | |||||
3326 | 3326 | -73.9561344937861 | 40.794082388408604 | 37F-PM-1014-03 | 37F | PM | 1014 | 3 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
3339 | 3339 | -73.9575517912392 | 40.788915826819206 | 31H-PM-1008-05 | 31H | PM | 1008 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575517912392 40.7889158268192) | 19 | 4 | 19 | 13 | ||||||
3394 | 3394 | -73.9756273257684 | 40.7706539186221 | 6D-AM-1008-04 | 06D | AM | 1008 | 4 | Adult | Gray | Gray+ | Above Ground | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9756273257684 40.7706539186221) | 19 | 4 | 19 | 13 | |||||||
3448 | 3448 | -73.973425927351 | 40.7781929919344 | 14B-AM-1007-03 | 14B | AM | 1007 | 3 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.973425927351 40.7781929919344) | 19 | 4 | 19 | 13 | ||||||||
3468 | 3468 | -73.9659549963516 | 40.7833659689194 | 22D-PM-1012-05 | 22D | PM | 1012 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9659549963516 40.7833659689194) | 19 | 4 | 19 | 13 | |||||||
3508 | 3508 | -73.9612854506075 | 40.792083067357105 | 32C-PM-1013-04 | 32C | PM | 1013 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 | |||||||
3519 | 3519 | -73.96855981061279 | 40.7807054868066 | 19D-PM-1008-02 | 19D | PM | 1008 | 2 | + | unknown - cannot see, only hear | Above Ground | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9685598106128 40.7807054868066) | 19 | 4 | 19 | 13 | ||||||||
3528 | 3528 | -73.9533319519277 | 40.7933647909449 | 37H-AM-1018-02 | 37H | AM | 1018 | 2 | Adult | Gray | Gray+ | Above Ground | Large tree by (fence of the conservatory) about to climb up | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | busy,ready to climb | POINT (-73.9533319519277 40.7933647909449) | 19 | 4 | 19 | 13 | |||||
3553 | 3553 | -73.9565759733611 | 40.7992461674802 | 42C-AM-1007-02 | 42C | AM | 1007 | 2 | + | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565759733611 40.7992461674802) | 19 | 4 | 19 | 13 | ||||||||||
3565 | 3565 | -73.969347812694 | 40.7744098063421 | 12G-PM-1007-02 | 12G | PM | 1007 | 2 | Gray | Gray+ | Above Ground | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969347812694 40.7744098063421) | 19 | 4 | 19 | 13 | |||||||
3602 | 3602 | -73.9708225719705 | 40.7772497804149 | 14D-PM-1019-13 | 14D | PM | 1019 | 13 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9708225719705 40.7772497804149) | 19 | 4 | 19 | 13 | ||||||||
3621 | 3621 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 1017 | 4 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
3623 | 3623 | -73.9762257701293 | 40.7744032758323 | 9A-AM-1013-08 | 09A | AM | 1013 | 8 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9762257701293 40.7744032758323) | 19 | 4 | 19 | 13 | |||||||||
3700 | 3700 | -73.95283537022091 | 40.7976456178263 | 41F-PM-1019-02 | 41F | PM | 1019 | 2 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9528353702209 40.7976456178263) | 19 | 4 | 19 | 13 | ||||||||||
3714 | 3714 | -73.96867781674841 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 1012 | 4 | + | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686778167484 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
3768 | 3768 | -73.97672201797249 | 40.77532621031229 | 10A-PM-1014-03 | 10A | PM | 1014 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | above my head in tree | 0 | 0 | 0 | 1 | 0 | eating (in a tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent (lots of people taking its picture,didn't bother it) | POINT (-73.9767220179725 40.7753262103123) | 12,420 | 20 | 4 | 19 | 12 | ||
3842 | 3842 | -73.97357503529591 | 40.7694500333777 | 6F-PM-1008-06 | 06F | PM | 1008 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | White patches. Almost looks like fox squirrel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9735750352959 40.7694500333777) | 19 | 4 | 19 | 13 | ||||||
3882 | 3882 | -73.9583934264026 | 40.7854742185504 | 27I-AM-1007-02 | 27I | AM | 1007 | 2 | + | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9583934264026 40.7854742185504) | 19 | 4 | 19 | 13 | ||||||||||
3888 | 3888 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 1014 | 7 | Adult | Gray | Gray+ | Above Ground | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
3940 | 3940 | -73.9532804650089 | 40.7934579333341 | 37H-PM-1006-05 | 37H | PM | 1006 | 5 | + | Above Ground | tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9532804650089 40.7934579333341) | 19 | 4 | 19 | 13 | ||||||||
3966 | 3966 | -73.95659058682759 | 40.7895654068546 | 32H-PM-1006-01 | 32H | PM | 1006 | 1 | Gray | Gray+ | Above Ground | in the European Beech | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565905868276 40.7895654068546) | 19 | 4 | 19 | 13 | |||||||
3968 | 3968 | -73.975809362521 | 40.773470273783495 | 8B-PM-1012-09 | 08B | PM | 1012 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.975809362521 40.7734702737835) | 19 | 4 | 19 | 13 | |||||
4006 | 4006 | -73.96732355553209 | 40.7786749596774 | 17F-PM-1020-04 | 17F | PM | 1020 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9673235555321 40.7786749596774) | 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 )