Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Age, Primary_Fur_Color, Combination_of_Primary_and_Highlight_Color, Location, Above_Ground_Sighter_Measurement, Running, Chasing, Climbing, Eating, Kuks, Quaas, Moans, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32 | 32 | -73.9682803241007 | 40.772451055832704 | 11H-AM-1010-04 | 11H | AM | 1010 | 4 | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9682803241007 40.7724510558327) | 19 | 4 | 19 | 13 | ||||||||
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 | |||||
229 | 229 | -73.96931200900549 | 40.771096102012 | 9H-PM-1018-07 | 09H | PM | 1018 | 7 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9693120090055 40.771096102012) | 19 | 4 | 19 | 13 | ||||||||
336 | 336 | -73.96942403275091 | 40.7755898126674 | 13F-AM-1007-02 | 13F | AM | 1007 | 2 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694240327509 40.7755898126674) | 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 | ||||||||
429 | 429 | -73.97864748095141 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 1013 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
468 | 468 | -73.9744555348544 | 40.772849810635705 | 8D-PM-1007-03 | 08D | PM | 1007 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9744555348544 40.7728498106357) | 19 | 4 | 19 | 13 | |||||||
527 | 527 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 1013 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | 0 | 0 | 0 | 1 | 1 | watching | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
645 | 645 | -73.95431338448 | 40.7940537582585 | 37G-PM-1007-08 | 37G | PM | 1007 | 8 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95431338448 40.7940537582585) | 19 | 4 | 19 | 13 | ||||||||
647 | 647 | -73.9702676472613 | 40.7762126854894 | 13E-AM-1017-05 | 13E | AM | 1017 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on tree stump | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9702676472613 40.7762126854894) | 19 | 4 | 19 | 13 | |||||
787 | 787 | -73.9686737866872 | 40.773971402373206 | 12G-PM-1007-06 | 12G | PM | 1007 | 6 | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686737866872 40.7739714023732) | 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 | |||||
885 | 885 | -73.9725669210177 | 40.768149698902896 | 5H-AM-1007-01 | 05H | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9725669210177 40.7681496989029) | 19 | 4 | 19 | 13 | |||||||
894 | 894 | -73.96836135162249 | 40.772590884749896 | 11H-AM-1010-03 | 11H | AM | 1010 | 3 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9683613516225 40.7725908847499) | 19 | 4 | 19 | 13 | |||||||
929 | 929 | -73.97083718064292 | 40.7764813666684 | 14D-AM-1014-14 | 14D | AM | 1014 | 14 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9708371806429 40.7764813666684) | 19 | 4 | 19 | 13 | |||||||
1122 | 1122 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 1006 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.7655415515908) | 19 | 4 | 19 | 13 | ||||||
1142 | 1142 | -73.9730181306326 | 40.779460132242704 | 16A-AM-1013-02 | 16A | AM | 1013 | 2 | Adult | Black | Black+ | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9730181306326 40.7794601322427) | 19 | 4 | 19 | 13 | |||||||
1156 | 1156 | -73.96369718436651 | 40.78256385373621 | 22F-AM-1007-04 | 22F | AM | 1007 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9636971843665 40.7825638537362) | 19 | 4 | 19 | 13 | |||||||
1238 | 1238 | -73.95950023395079 | 40.7903365788694 | 32E-PM-1017-13 | 32E | PM | 1017 | 13 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9595002339508 40.7903365788694) | 19 | 4 | 19 | 13 | |||||||
1276 | 1276 | -73.9751729403694 | 40.774328412311796 | 10B-PM-1014-02 | 10B | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Above Ground | gingko tree by traffic light in front of Strawberry Fields | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | came over on tree to see me then disappeared | POINT (-73.9751729403694 40.7743284123118) | 19 | 4 | 19 | 13 | ||||
1289 | 1289 | -73.9765306970303 | 40.769495687585895 | 4D-PM-1008-09 | 04D | PM | 1008 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765306970303 40.7694956875859) | 19 | 4 | 19 | 13 | |||||||
1340 | 1340 | -73.9709407456459 | 40.776423522087 | 14D-AM-1014-13 | 14D | AM | 1014 | 13 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9709407456459 40.776423522087) | 19 | 4 | 19 | 13 | |||||||
1360 | 1360 | -73.9667560049684 | 40.7882333830729 | 27A-PM-1006-01 | 27A | PM | 1006 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | 0 | 0 | 0 | 1 | 1 | walking up & down branches | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9667560049684 40.7882333830729) | 19 | 4 | 19 | 13 | ||||
1509 | 1509 | -73.9587401274261 | 40.7960322222949 | 37C-PM-1013-03 | 37C | PM | 1013 | 3 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9587401274261 40.7960322222949) | 19 | 4 | 19 | 13 | |||||||
1531 | 1531 | -73.9542990150586 | 40.794091530067796 | 37G-PM-1007-09 | 37G | PM | 1007 | 9 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9542990150586 40.7940915300678) | 19 | 4 | 19 | 13 | |||||||
1551 | 1551 | -73.95466167829221 | 40.790974533738996 | 34I-PM-1010-05 | 34I | PM | 1010 | 5 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9546616782922 40.790974533739) | 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 | |||||||
1689 | 1689 | -73.9761223919286 | 40.7685998275864 | 4E-PM-1008-06 | 04E | PM | 1008 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761223919286 40.7685998275864) | 19 | 4 | 19 | 13 | |||||||
1759 | 1759 | -73.9574365550758 | 40.7886924675052 | 31H-PM-1008-03 | 31H | PM | 1008 | 3 | Adult | Gray | Gray+ | Above Ground | no clue, way up a tree! | 0 | 0 | 1 | 0 | 1 | throwing down acorns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9574365550758 40.7886924675052) | 19 | 4 | 19 | 13 | |||||
1859 | 1859 | -73.97036835101758 | 40.774397536395796 | 12F-PM-1007-10 | 12F | PM | 1007 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703683510176 40.7743975363958) | 19 | 4 | 19 | 13 | |||||||
1995 | 1995 | -73.9690080105286 | 40.7710230515054 | 9I-PM-1010-03 | 09I | PM | 1010 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9690080105286 40.7710230515054) | 19 | 4 | 19 | 13 | |||||||
2163 | 2163 | -73.9596413903948 | 40.790312888902896 | 32E-PM-1017-14 | 32E | PM | 1017 | 14 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9596413903948 40.7903128889029) | 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 | |||||
2292 | 2292 | -73.9547711796823 | 40.7908540751983 | 34I-PM-1010-06 | 34I | PM | 1010 | 6 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9547711796823 40.7908540751983) | 19 | 4 | 19 | 13 | ||||||||
2467 | 2467 | -73.9742973420446 | 40.7691801644292 | 5F-AM-1007-04 | 05F | AM | 1007 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | rocks | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9742973420446 40.7691801644292) | 19 | 4 | 19 | 13 | |||||
2588 | 2588 | -73.9572840457971 | 40.788693337174394 | 31H-PM-1008-04 | 31H | PM | 1008 | 4 | Adult | Gray | Gray+ | Above Ground | Also way up | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9572840457971 40.7886933371744) | 19 | 4 | 19 | 13 | ||||||
2818 | 2818 | -73.9705331808443 | 40.769994357129605 | 7H-AM-1006-09 | 07H | AM | 1006 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9705331808443 40.7699943571296) | 19 | 4 | 19 | 13 | |||||||
2861 | 2861 | -73.9694681803635 | 40.770585795359004 | 8I-AM-1006-06 | 08I | AM | 1006 | 6 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694681803635 40.770585795359) | 19 | 4 | 19 | 13 | ||||||
2878 | 2878 | -73.97001860010491 | 40.7826052184658 | 20B-AM-1007-03 | 20B | AM | 1007 | 3 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9700186001049 40.7826052184658) | 19 | 4 | 19 | 13 | ||||||
2911 | 2911 | -73.9589371550945 | 40.7959812504467 | 37C-PM-1013-04 | 37C | PM | 1013 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589371550945 40.7959812504467) | 19 | 4 | 19 | 13 | |||||||
2987 | 2987 | -73.95787795565741 | 40.7934116539732 | 35E-PM-1006-06 | 35E | PM | 1006 | 6 | Adult | Gray | Gray+ | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9578779556574 40.7934116539732) | 19 | 4 | 19 | 13 | |||||||
3055 | 3055 | -73.9682803241007 | 40.772451055832704 | 11H-AM-1010-04 | 11H | AM | 1010 | 4 | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9682803241007 40.7724510558327) | 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 | |||||
3252 | 3252 | -73.96931200900549 | 40.771096102012 | 9H-PM-1018-07 | 09H | PM | 1018 | 7 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9693120090055 40.771096102012) | 19 | 4 | 19 | 13 | ||||||||
3359 | 3359 | -73.96942403275091 | 40.7755898126674 | 13F-AM-1007-02 | 13F | AM | 1007 | 2 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694240327509 40.7755898126674) | 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 | ||||||||
3452 | 3452 | -73.97864748095141 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 1013 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
3491 | 3491 | -73.9744555348544 | 40.772849810635705 | 8D-PM-1007-03 | 08D | PM | 1007 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9744555348544 40.7728498106357) | 19 | 4 | 19 | 13 | |||||||
3550 | 3550 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 1013 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | 0 | 0 | 0 | 1 | 1 | watching | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
3668 | 3668 | -73.95431338448 | 40.7940537582585 | 37G-PM-1007-08 | 37G | PM | 1007 | 8 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95431338448 40.7940537582585) | 19 | 4 | 19 | 13 | ||||||||
3670 | 3670 | -73.9702676472613 | 40.7762126854894 | 13E-AM-1017-05 | 13E | AM | 1017 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on tree stump | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9702676472613 40.7762126854894) | 19 | 4 | 19 | 13 | |||||
3810 | 3810 | -73.9686737866872 | 40.773971402373206 | 12G-PM-1007-06 | 12G | PM | 1007 | 6 | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686737866872 40.7739714023732) | 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 | |||||
3908 | 3908 | -73.9725669210177 | 40.768149698902896 | 5H-AM-1007-01 | 05H | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9725669210177 40.7681496989029) | 19 | 4 | 19 | 13 | |||||||
3917 | 3917 | -73.96836135162249 | 40.772590884749896 | 11H-AM-1010-03 | 11H | AM | 1010 | 3 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9683613516225 40.7725908847499) | 19 | 4 | 19 | 13 | |||||||
3952 | 3952 | -73.97083718064292 | 40.7764813666684 | 14D-AM-1014-14 | 14D | AM | 1014 | 14 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9708371806429 40.7764813666684) | 19 | 4 | 19 | 13 | |||||||
4145 | 4145 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 1006 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.7655415515908) | 19 | 4 | 19 | 13 | ||||||
4165 | 4165 | -73.9730181306326 | 40.779460132242704 | 16A-AM-1013-02 | 16A | AM | 1013 | 2 | Adult | Black | Black+ | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9730181306326 40.7794601322427) | 19 | 4 | 19 | 13 | |||||||
4179 | 4179 | -73.96369718436651 | 40.78256385373621 | 22F-AM-1007-04 | 22F | AM | 1007 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9636971843665 40.7825638537362) | 19 | 4 | 19 | 13 | |||||||
4261 | 4261 | -73.95950023395079 | 40.7903365788694 | 32E-PM-1017-13 | 32E | PM | 1017 | 13 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9595002339508 40.7903365788694) | 19 | 4 | 19 | 13 | |||||||
4299 | 4299 | -73.9751729403694 | 40.774328412311796 | 10B-PM-1014-02 | 10B | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Above Ground | gingko tree by traffic light in front of Strawberry Fields | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | came over on tree to see me then disappeared | POINT (-73.9751729403694 40.7743284123118) | 19 | 4 | 19 | 13 | ||||
4312 | 4312 | -73.9765306970303 | 40.769495687585895 | 4D-PM-1008-09 | 04D | PM | 1008 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765306970303 40.7694956875859) | 19 | 4 | 19 | 13 | |||||||
4363 | 4363 | -73.9709407456459 | 40.776423522087 | 14D-AM-1014-13 | 14D | AM | 1014 | 13 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9709407456459 40.776423522087) | 19 | 4 | 19 | 13 | |||||||
4383 | 4383 | -73.9667560049684 | 40.7882333830729 | 27A-PM-1006-01 | 27A | PM | 1006 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | 0 | 0 | 0 | 1 | 1 | walking up & down branches | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9667560049684 40.7882333830729) | 19 | 4 | 19 | 13 | ||||
4532 | 4532 | -73.9587401274261 | 40.7960322222949 | 37C-PM-1013-03 | 37C | PM | 1013 | 3 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9587401274261 40.7960322222949) | 19 | 4 | 19 | 13 | |||||||
4554 | 4554 | -73.9542990150586 | 40.794091530067796 | 37G-PM-1007-09 | 37G | PM | 1007 | 9 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9542990150586 40.7940915300678) | 19 | 4 | 19 | 13 | |||||||
4574 | 4574 | -73.95466167829221 | 40.790974533738996 | 34I-PM-1010-05 | 34I | PM | 1010 | 5 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9546616782922 40.790974533739) | 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 | |||||||
4712 | 4712 | -73.9761223919286 | 40.7685998275864 | 4E-PM-1008-06 | 04E | PM | 1008 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761223919286 40.7685998275864) | 19 | 4 | 19 | 13 | |||||||
4782 | 4782 | -73.9574365550758 | 40.7886924675052 | 31H-PM-1008-03 | 31H | PM | 1008 | 3 | Adult | Gray | Gray+ | Above Ground | no clue, way up a tree! | 0 | 0 | 1 | 0 | 1 | throwing down acorns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9574365550758 40.7886924675052) | 19 | 4 | 19 | 13 | |||||
4882 | 4882 | -73.97036835101758 | 40.774397536395796 | 12F-PM-1007-10 | 12F | PM | 1007 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703683510176 40.7743975363958) | 19 | 4 | 19 | 13 | |||||||
5018 | 5018 | -73.9690080105286 | 40.7710230515054 | 9I-PM-1010-03 | 09I | PM | 1010 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9690080105286 40.7710230515054) | 19 | 4 | 19 | 13 | |||||||
5186 | 5186 | -73.9596413903948 | 40.790312888902896 | 32E-PM-1017-14 | 32E | PM | 1017 | 14 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9596413903948 40.7903128889029) | 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 | |||||
5315 | 5315 | -73.9547711796823 | 40.7908540751983 | 34I-PM-1010-06 | 34I | PM | 1010 | 6 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9547711796823 40.7908540751983) | 19 | 4 | 19 | 13 | ||||||||
5490 | 5490 | -73.9742973420446 | 40.7691801644292 | 5F-AM-1007-04 | 05F | AM | 1007 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | rocks | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9742973420446 40.7691801644292) | 19 | 4 | 19 | 13 | |||||
5611 | 5611 | -73.9572840457971 | 40.788693337174394 | 31H-PM-1008-04 | 31H | PM | 1008 | 4 | Adult | Gray | Gray+ | Above Ground | Also way up | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9572840457971 40.7886933371744) | 19 | 4 | 19 | 13 | ||||||
5841 | 5841 | -73.9705331808443 | 40.769994357129605 | 7H-AM-1006-09 | 07H | AM | 1006 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9705331808443 40.7699943571296) | 19 | 4 | 19 | 13 | |||||||
5884 | 5884 | -73.9694681803635 | 40.770585795359004 | 8I-AM-1006-06 | 08I | AM | 1006 | 6 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694681803635 40.770585795359) | 19 | 4 | 19 | 13 | ||||||
5901 | 5901 | -73.97001860010491 | 40.7826052184658 | 20B-AM-1007-03 | 20B | AM | 1007 | 3 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9700186001049 40.7826052184658) | 19 | 4 | 19 | 13 | ||||||
5934 | 5934 | -73.9589371550945 | 40.7959812504467 | 37C-PM-1013-04 | 37C | PM | 1013 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589371550945 40.7959812504467) | 19 | 4 | 19 | 13 | |||||||
6010 | 6010 | -73.95787795565741 | 40.7934116539732 | 35E-PM-1006-06 | 35E | PM | 1006 | 6 | Adult | Gray | Gray+ | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9578779556574 40.7934116539732) | 19 | 4 | 19 | 13 | |||||||
547 | 547 | -73.9703816112358 | 40.777384606591895 | 15D-PM-1017-02 | 15D | PM | 1017 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703816112358 40.7773846065919) | 19 | 4 | 19 | 13 | |||||
874 | 874 | -73.9692946938852 | 40.7767389791452 | 14E-AM-1008-13 | 14E | AM | 1008 | 13 | Adult | Gray | Gray+ | Above Ground | 1.0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | curious | POINT (-73.9692946938852 40.7767389791452) | 19 | 4 | 19 | 13 | |||||
1934 | 1934 | -73.9763542780331 | 40.773653130362206 | 9B-AM-1010-02 | 09B | AM | 1010 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | in bush | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | froze | POINT (-73.9763542780331 40.7736531303622) | 19 | 4 | 19 | 13 | |||
2087 | 2087 | -73.9743795190073 | 40.7692030411004 | 5E-AM-1008-05 | 05E | AM | 1008 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9743795190073 40.7692030411004) | 19 | 4 | 19 | 13 | |||||
2356 | 2356 | -73.9753585157592 | 40.7698398607941 | 5E-AM-1008-07 | 05E | AM | 1008 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | on fence | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9753585157592 40.7698398607941) | 19 | 4 | 19 | 13 | ||||
2577 | 2577 | -73.9692676659807 | 40.7700678919108 | 8I-PM-1013-08 | 08I | PM | 1013 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1.0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9692676659807 40.7700678919108) | 19 | 4 | 19 | 13 | |||||
3011 | 3011 | -73.9694066600156 | 40.7805662180672 | 18C-PM-1018-06 | 18C | PM | 1018 | 6 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 1.0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694066600156 40.7805662180672) | 19 | 4 | 19 | 13 | |||||
3570 | 3570 | -73.9703816112358 | 40.777384606591895 | 15D-PM-1017-02 | 15D | PM | 1017 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703816112358 40.7773846065919) | 19 | 4 | 19 | 13 | |||||
3897 | 3897 | -73.9692946938852 | 40.7767389791452 | 14E-AM-1008-13 | 14E | AM | 1008 | 13 | Adult | Gray | Gray+ | Above Ground | 1.0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | curious | POINT (-73.9692946938852 40.7767389791452) | 19 | 4 | 19 | 13 | |||||
4957 | 4957 | -73.9763542780331 | 40.773653130362206 | 9B-AM-1010-02 | 09B | AM | 1010 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | in bush | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | froze | POINT (-73.9763542780331 40.7736531303622) | 19 | 4 | 19 | 13 | |||
5110 | 5110 | -73.9743795190073 | 40.7692030411004 | 5E-AM-1008-05 | 05E | AM | 1008 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9743795190073 40.7692030411004) | 19 | 4 | 19 | 13 | |||||
5379 | 5379 | -73.9753585157592 | 40.7698398607941 | 5E-AM-1008-07 | 05E | AM | 1008 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | on fence | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9753585157592 40.7698398607941) | 19 | 4 | 19 | 13 | ||||
5600 | 5600 | -73.9692676659807 | 40.7700678919108 | 8I-PM-1013-08 | 08I | PM | 1013 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1.0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9692676659807 40.7700678919108) | 19 | 4 | 19 | 13 | |||||
6034 | 6034 | -73.9694066600156 | 40.7805662180672 | 18C-PM-1018-06 | 18C | PM | 1018 | 6 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 1.0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694066600156 40.7805662180672) | 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 | ||||
243 | 243 | -73.9682965197661 | 40.780537896388296 | 18D-AM-1018-04 | 18D | AM | 1018 | 4 | Adult | Gray | Gray+ | Above Ground | 2.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9682965197661 40.7805378963883) | 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 |
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 )