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, Above_Ground_Sighter_Measurement, Chasing, Climbing, Eating, Kuks, Quaas, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Zip_Codes, Community_Districts, City_Council_Districts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189 | 189 | -73.9658747245917 | 40.77540337375321 | 14I-PM-1018-01 | 14I | PM | 1018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9658747245917 40.7754033737532) | 19 | 4 | 19 | 13 | |||||
358 | 358 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 1010 | 7 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954530253849 40.7910247489879) | 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 | |||||||
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 | ||||||||
820 | 820 | -73.9743509423821 | 40.7690043677328 | 5F-AM-1007-02 | 05F | AM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9743509423821 40.7690043677328) | 19 | 4 | 19 | 13 | |||||
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 | ||||||
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 | |||||
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 | |||||
1676 | 1676 | -73.97902633720041 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 1013 | 7 | Adult | Gray | White | Gray+White | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790263372004 40.7683513714892) | 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 | |||||
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 | |||||||||
2176 | 2176 | -73.9706533131129 | 40.768902033818996 | 6I-AM-1006-01 | 06I | AM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (someone sneezed) | POINT (-73.9706533131129 40.768902033819) | 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 | |||||||
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 | |||||
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 | ||||||
3212 | 3212 | -73.9658747245917 | 40.77540337375321 | 14I-PM-1018-01 | 14I | PM | 1018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9658747245917 40.7754033737532) | 19 | 4 | 19 | 13 | |||||
3381 | 3381 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 1010 | 7 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954530253849 40.7910247489879) | 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 | |||||||
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 | ||||||||
3843 | 3843 | -73.9743509423821 | 40.7690043677328 | 5F-AM-1007-02 | 05F | AM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9743509423821 40.7690043677328) | 19 | 4 | 19 | 13 | |||||
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 | ||||||
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 | |||||
4508 | 4508 | -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 | ||||
4551 | 4551 | -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 | |||||
4699 | 4699 | -73.97902633720041 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 1013 | 7 | Adult | Gray | White | Gray+White | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790263372004 40.7683513714892) | 19 | 4 | 19 | 13 | |||||||
4898 | 4898 | -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 | |||||
5182 | 5182 | -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 | |||||||||
5199 | 5199 | -73.9706533131129 | 40.768902033818996 | 6I-AM-1006-01 | 06I | AM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (someone sneezed) | POINT (-73.9706533131129 40.768902033819) | 19 | 4 | 19 | 13 | |||||
5527 | 5527 | -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 | ||||||||
5601 | 5601 | -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 | |||||||
5804 | 5804 | -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 | |||||
5891 | 5891 | -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 | ||||||
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 | ||||
810 | 810 | -73.95595201371721 | 40.7950536287174 | 38E-AM-1010-06 | 38E | AM | 1010 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #7 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9559520137172 40.7950536287174) | 19 | 4 | 19 | 13 | |||
1203 | 1203 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 1018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
1417 | 1417 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 1010 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
2123 | 2123 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 1018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
2927 | 2927 | -73.96857515954851 | 40.7709413567859 | 9I-PM-1010-07 | 09I | PM | 1010 | 7 | Adult | Gray | White | Gray+White | Above Ground | 1.0 | ran up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685751595485 40.7709413567859) | 19 | 4 | 19 | 13 | ||||
3067 | 3067 | -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 | ||||
3833 | 3833 | -73.95595201371721 | 40.7950536287174 | 38E-AM-1010-06 | 38E | AM | 1010 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #7 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9559520137172 40.7950536287174) | 19 | 4 | 19 | 13 | |||
4226 | 4226 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 1018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
4440 | 4440 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 1010 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
5146 | 5146 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 1018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
5950 | 5950 | -73.96857515954851 | 40.7709413567859 | 9I-PM-1010-07 | 09I | PM | 1010 | 7 | Adult | Gray | White | Gray+White | Above Ground | 1.0 | ran up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685751595485 40.7709413567859) | 19 | 4 | 19 | 13 | ||||
33 | 33 | -73.969628583287 | 40.770406779793205 | 8H-AM-1017-03 | 08H | AM | 1017 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969628583287 40.7704067797932) | 19 | 4 | 19 | 13 | ||||
161 | 161 | -73.9693338657183 | 40.775705588453796 | 13F-PM-1008-05 | 13F | PM | 1008 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | tree trunk | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9693338657183 40.7757055884538) | 19 | 4 | 19 | 13 | ||||
278 | 278 | -73.96810426129379 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 1012 | 4 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681042612938 40.772331431865) | 19 | 4 | 19 | 13 | ||||||
534 | 534 | -73.9576652087316 | 40.787545797780105 | 29H-PM-1006-02 | 29H | PM | 1006 | 2 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9576652087316 40.7875457977801) | 19 | 4 | 19 | 13 | ||||||
726 | 726 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 1008 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2.0 | went up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
796 | 796 | -73.95488263914001 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 1014 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2.0 | up/down tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95488263914 40.7959474571251) | 19 | 4 | 19 | 13 | |||||
1162 | 1162 | -73.9543832609857 | 40.795355063970106 | 39F-AM-1014-02 | 39F | AM | 1014 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | rocks | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9543832609857 40.7953550639701) | 19 | 4 | 19 | 13 | ||||
1416 | 1416 | -73.9689504114652 | 40.77667701537639 | 14F-PM-1012-05 | 14F | PM | 1012 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2.0 | on a fallen branch | 1 | 0 | 0 | 1 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looking at me | POINT (-73.9689504114652 40.7766770153764) | 19 | 4 | 19 | 13 | ||
1582 | 1582 | -73.9655905300923 | 40.775261463802295 | 14I-PM-1018-06 | 14I | PM | 1018 | 6 | Adult | Cinnamon | Black | Cinnamon+Black | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9655905300923 40.7752614638023) | 19 | 4 | 19 | 13 | |||||
1653 | 1653 | -73.96893059787509 | 40.781815249626604 | 19C-PM-1018-06 | 19C | PM | 1018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | Climbed fence | 1 | 0 | 1 | 0 | 0 | climbing (fence) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689305978751 40.7818152496266) | 19 | 4 | 19 | 13 | |||
1769 | 1769 | -73.97068515461841 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 1017 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706851546184 40.7780777016038) | 19 | 4 | 19 | 13 | |||||
1826 | 1826 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 1008 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2.0 | on railing | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9741944367138 40.7769889953596) | 19 | 4 | 19 | 13 | ||||
1856 | 1856 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 1017 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2.0 | Fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674631254594 40.7790076357696) | 19 | 4 | 19 | 13 | |||||
1857 | 1857 | -73.9680522379372 | 40.772389813511 | 11I-PM-1012-06 | 11I | PM | 1012 | 6 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9680522379372 40.772389813511) | 19 | 4 | 19 | 13 | ||||||
1945 | 1945 | -73.97394038506219 | 40.769316228750895 | 5F-AM-1007-05 | 05F | AM | 1007 | 5 | Adult | Gray | White | Gray+White | Above Ground | 2.0 | tree | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9739403850622 40.7693162287509) | 19 | 4 | 19 | 13 | ||||
2260 | 2260 | -73.96539465596099 | 40.7763136791661 | 15I-PM-1012-05 | 15I | PM | 1012 | 5 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 1 | burying the food on ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | look at us and continue hiding the food | POINT (-73.965394655961 40.7763136791661) | 19 | 4 | 19 | 13 | ||||
2297 | 2297 | -73.96810798698209 | 40.772349408134495 | 11I-PM-1012-05 | 11I | PM | 1012 | 5 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681079869821 40.7723494081345) | 19 | 4 | 19 | 13 | ||||||
2873 | 2873 | -73.97179185488301 | 40.78029717297839 | 17B-PM-1012-01 | 17B | PM | 1012 | 1 | Adult | Gray | Gray+ | Above Ground | 2.0 | climbed a fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.971791854883 40.7802971729784) | 19 | 4 | 19 | 13 | |||||
3056 | 3056 | -73.969628583287 | 40.770406779793205 | 8H-AM-1017-03 | 08H | AM | 1017 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969628583287 40.7704067797932) | 19 | 4 | 19 | 13 | ||||
3184 | 3184 | -73.9693338657183 | 40.775705588453796 | 13F-PM-1008-05 | 13F | PM | 1008 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | tree trunk | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9693338657183 40.7757055884538) | 19 | 4 | 19 | 13 | ||||
3301 | 3301 | -73.96810426129379 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 1012 | 4 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681042612938 40.772331431865) | 19 | 4 | 19 | 13 | ||||||
3557 | 3557 | -73.9576652087316 | 40.787545797780105 | 29H-PM-1006-02 | 29H | PM | 1006 | 2 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9576652087316 40.7875457977801) | 19 | 4 | 19 | 13 | ||||||
3749 | 3749 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 1008 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2.0 | went up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
3819 | 3819 | -73.95488263914001 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 1014 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2.0 | up/down tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95488263914 40.7959474571251) | 19 | 4 | 19 | 13 | |||||
4185 | 4185 | -73.9543832609857 | 40.795355063970106 | 39F-AM-1014-02 | 39F | AM | 1014 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | rocks | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9543832609857 40.7953550639701) | 19 | 4 | 19 | 13 | ||||
4439 | 4439 | -73.9689504114652 | 40.77667701537639 | 14F-PM-1012-05 | 14F | PM | 1012 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2.0 | on a fallen branch | 1 | 0 | 0 | 1 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looking at me | POINT (-73.9689504114652 40.7766770153764) | 19 | 4 | 19 | 13 | ||
4605 | 4605 | -73.9655905300923 | 40.775261463802295 | 14I-PM-1018-06 | 14I | PM | 1018 | 6 | Adult | Cinnamon | Black | Cinnamon+Black | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9655905300923 40.7752614638023) | 19 | 4 | 19 | 13 | |||||
4676 | 4676 | -73.96893059787509 | 40.781815249626604 | 19C-PM-1018-06 | 19C | PM | 1018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | Climbed fence | 1 | 0 | 1 | 0 | 0 | climbing (fence) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689305978751 40.7818152496266) | 19 | 4 | 19 | 13 | |||
4792 | 4792 | -73.97068515461841 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 1017 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706851546184 40.7780777016038) | 19 | 4 | 19 | 13 | |||||
4849 | 4849 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 1008 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2.0 | on railing | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9741944367138 40.7769889953596) | 19 | 4 | 19 | 13 | ||||
4879 | 4879 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 1017 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2.0 | Fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674631254594 40.7790076357696) | 19 | 4 | 19 | 13 | |||||
4880 | 4880 | -73.9680522379372 | 40.772389813511 | 11I-PM-1012-06 | 11I | PM | 1012 | 6 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9680522379372 40.772389813511) | 19 | 4 | 19 | 13 | ||||||
4968 | 4968 | -73.97394038506219 | 40.769316228750895 | 5F-AM-1007-05 | 05F | AM | 1007 | 5 | Adult | Gray | White | Gray+White | Above Ground | 2.0 | tree | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9739403850622 40.7693162287509) | 19 | 4 | 19 | 13 | ||||
5283 | 5283 | -73.96539465596099 | 40.7763136791661 | 15I-PM-1012-05 | 15I | PM | 1012 | 5 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 1 | burying the food on ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | look at us and continue hiding the food | POINT (-73.965394655961 40.7763136791661) | 19 | 4 | 19 | 13 | ||||
5320 | 5320 | -73.96810798698209 | 40.772349408134495 | 11I-PM-1012-05 | 11I | PM | 1012 | 5 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681079869821 40.7723494081345) | 19 | 4 | 19 | 13 | ||||||
5896 | 5896 | -73.97179185488301 | 40.78029717297839 | 17B-PM-1012-01 | 17B | PM | 1012 | 1 | Adult | Gray | Gray+ | Above Ground | 2.0 | climbed a fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.971791854883 40.7802971729784) | 19 | 4 | 19 | 13 | |||||
259 | 259 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 1012 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3.0 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719460335398 40.7810508156287) | 19 | 4 | 19 | 13 | |||
344 | 344 | -73.9712022111028 | 40.767250436826295 | 4I-AM-1006-01 | 04I | AM | 1006 | 1 | Adult | Black | Black+ | Above Ground | 3.0 | On top of park lamp | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712022111028 40.7672504368263) | 19 | 4 | 19 | 13 | |||||
388 | 388 | -73.97702735535249 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 1013 | 3 | Juvenile | + | Above Ground | 3.0 | fence | 1 | 1 | 1 | 1 | 0 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770273553525 40.7732399463626) | 19 | 4 | 19 | 13 | |||||
1171 | 1171 | -73.97190362174459 | 40.7803588122409 | 17A-AM-1017-01 | 17A | AM | 1017 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | ground & tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719036217446 40.7803588122409) | 19 | 4 | 19 | 13 | ||||
1277 | 1277 | -73.95994199262991 | 40.797277472881106 | 38A-AM-1019-01 | 38A | AM | 1019 | 1 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599419926299 40.7972774728811) | 19 | 4 | 19 | 13 | ||||||
1463 | 1463 | -73.97447264347429 | 40.776729630785 | 12A-PM-1013-03 | 12A | PM | 1013 | 3 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | chased up a tree by #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744726434743 40.776729630785) | 19 | 4 | 19 | 13 | |||||
1998 | 1998 | -73.95992022335359 | 40.7972599930224 | 38A-AM-1019-02 | 38A | AM | 1019 | 2 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599202233536 40.7972599930224) | 19 | 4 | 19 | 13 | ||||||
2366 | 2366 | -73.97113187902791 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 1010 | 2 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9711318790279 40.7701941550273) | 19 | 4 | 19 | 13 | ||||||
2682 | 2682 | -73.9679686793869 | 40.7825993867876 | 21C-AM-1014-01 | 21C | AM | 1014 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | jumping back & forth on tree | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9679686793869 40.7825993867876) | 19 | 4 | 19 | 13 | ||||
2863 | 2863 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 1008 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | was chased by # 11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763236949008 40.7686815615335) | 19 | 4 | 19 | 13 | ||||
2892 | 2892 | -73.9778730762957 | 40.770827251547 | 5B-PM-1013-05 | 05B | PM | 1013 | 5 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9778730762957 40.770827251547) | 19 | 4 | 19 | 13 | ||||||
2920 | 2920 | -73.96789565689801 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 1010 | 7 | Adult | Gray | Gray+ | Above Ground | 3.0 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
3282 | 3282 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 1012 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3.0 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719460335398 40.7810508156287) | 19 | 4 | 19 | 13 | |||
3367 | 3367 | -73.9712022111028 | 40.767250436826295 | 4I-AM-1006-01 | 04I | AM | 1006 | 1 | Adult | Black | Black+ | Above Ground | 3.0 | On top of park lamp | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712022111028 40.7672504368263) | 19 | 4 | 19 | 13 | |||||
3411 | 3411 | -73.97702735535249 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 1013 | 3 | Juvenile | + | Above Ground | 3.0 | fence | 1 | 1 | 1 | 1 | 0 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770273553525 40.7732399463626) | 19 | 4 | 19 | 13 | |||||
4194 | 4194 | -73.97190362174459 | 40.7803588122409 | 17A-AM-1017-01 | 17A | AM | 1017 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | ground & tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719036217446 40.7803588122409) | 19 | 4 | 19 | 13 | ||||
4300 | 4300 | -73.95994199262991 | 40.797277472881106 | 38A-AM-1019-01 | 38A | AM | 1019 | 1 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599419926299 40.7972774728811) | 19 | 4 | 19 | 13 | ||||||
4486 | 4486 | -73.97447264347429 | 40.776729630785 | 12A-PM-1013-03 | 12A | PM | 1013 | 3 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | chased up a tree by #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744726434743 40.776729630785) | 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 )