Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Combination_of_Primary_and_Highlight_Color, Location, Above_Ground_Sighter_Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail_flags, Tail_twitches, Approaches, Runs_from, Zip_Codes, Community_Districts, City_Council_Districts, Police_Precincts
Highlight_Fur_Color ✖
Link | rowid | Longitude | Latitude | Unique_Squirrel_ID | Hectare | Shift | Date | Hectare_Squirrel_Number | Age | Primary_Fur_Color | Highlight_Fur_Color | Combination_of_Primary_and_Highlight_Color | Color_notes | Location | Above_Ground_Sighter_Measurement | Specific_Location | Running | Chasing | Climbing | Eating | Foraging | Other_Activities | Kuks | Quaas | Moans | Tail_flags | Tail_twitches | Approaches | Indifferent | Runs_from | Other_Interactions | Latlong ▼ | Zip_Codes | Community_Districts | Borough_Boundaries | City_Council_Districts | Police_Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1633 | 1633 | -73.9497217674555 | 40.796517007214 | 42I-PM-1014-03 | 42I | PM | 1014 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9497217674555 40.796517007214) | 19 | 4 | 19 | 13 | ||||||
4656 | 4656 | -73.9497217674555 | 40.796517007214 | 42I-PM-1014-03 | 42I | PM | 1014 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9497217674555 40.796517007214) | 19 | 4 | 19 | 13 | ||||||
1482 | 1482 | -73.9507140045973 | 40.7957700986293 | 41I-PM-1017-01 | 41I | PM | 1017 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon oval on back | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507140045973 40.7957700986293) | 19 | 4 | 19 | 13 | ||||
4505 | 4505 | -73.9507140045973 | 40.7957700986293 | 41I-PM-1017-01 | 41I | PM | 1017 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon oval on back | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507140045973 40.7957700986293) | 19 | 4 | 19 | 13 | ||||
1792 | 1792 | -73.9507772992986 | 40.7949188960194 | 40I-PM-1013-01 | 40I | PM | 1013 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7.0 | 0 | 0 | 0 | 1 | 0 | eating (berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507772992986 40.7949188960194) | 19 | 4 | 19 | 13 | ||||
4815 | 4815 | -73.9507772992986 | 40.7949188960194 | 40I-PM-1013-01 | 40I | PM | 1013 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7.0 | 0 | 0 | 0 | 1 | 0 | eating (berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507772992986 40.7949188960194) | 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 | |||||
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 | |||||
1693 | 1693 | -73.9510747586301 | 40.7973106833951 | 42H-AM-1019-02 | 42H | AM | 1019 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9510747586301 40.7973106833951) | 19 | 4 | 19 | 13 | |||||
4716 | 4716 | -73.9510747586301 | 40.7973106833951 | 42H-AM-1019-02 | 42H | AM | 1019 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9510747586301 40.7973106833951) | 19 | 4 | 19 | 13 | |||||
901 | 901 | -73.951448051873 | 40.7973951649254 | 42G-AM-1018-02 | 42G | AM | 1018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.951448051873 40.7973951649254) | 19 | 4 | 19 | 13 | ||||||
3924 | 3924 | -73.951448051873 | 40.7973951649254 | 42G-AM-1018-02 | 42G | AM | 1018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.951448051873 40.7973951649254) | 19 | 4 | 19 | 13 | ||||||
1660 | 1660 | -73.9515907796216 | 40.795268423547704 | 40H-AM-1017-02 | 40H | AM | 1017 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9515907796216 40.7952684235477) | 19 | 4 | 19 | 13 | ||||||
4683 | 4683 | -73.9515907796216 | 40.795268423547704 | 40H-AM-1017-02 | 40H | AM | 1017 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9515907796216 40.7952684235477) | 19 | 4 | 19 | 13 | ||||||
2270 | 2270 | -73.95175251116791 | 40.7974407641075 | 42G-PM-1014-02 | 42G | PM | 1014 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 14.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9517525111679 40.7974407641075) | 19 | 4 | 19 | 13 | |||||
5293 | 5293 | -73.95175251116791 | 40.7974407641075 | 42G-PM-1014-02 | 42G | PM | 1014 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 14.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9517525111679 40.7974407641075) | 19 | 4 | 19 | 13 | |||||
490 | 490 | -73.95190816277679 | 40.7973148719421 | 41G-AM-1013-02 | 41G | AM | 1013 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9519081627768 40.7973148719421) | 19 | 4 | 19 | 13 | |||||
3513 | 3513 | -73.95190816277679 | 40.7973148719421 | 41G-AM-1013-02 | 41G | AM | 1013 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9519081627768 40.7973148719421) | 19 | 4 | 19 | 13 | |||||
1706 | 1706 | -73.9519639918804 | 40.79499117023921 | 39H-AM-1007-01 | 39H | AM | 1007 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9519639918804 40.7949911702392) | 19 | 4 | 19 | 13 | ||||||
4729 | 4729 | -73.9519639918804 | 40.79499117023921 | 39H-AM-1007-01 | 39H | AM | 1007 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9519639918804 40.7949911702392) | 19 | 4 | 19 | 13 | ||||||
699 | 699 | -73.9521514669041 | 40.7949515182825 | 39H-PM-1013-03 | 39H | PM | 1013 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | POINT (-73.9521514669041 40.7949515182825) | 19 | 4 | 19 | 13 | |||||
3722 | 3722 | -73.9521514669041 | 40.7949515182825 | 39H-PM-1013-03 | 39H | PM | 1013 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | POINT (-73.9521514669041 40.7949515182825) | 19 | 4 | 19 | 13 | |||||
1955 | 1955 | -73.9521950056404 | 40.794937340844996 | 39H-PM-1013-01 | 39H | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ran away when a human approached with a dog | POINT (-73.9521950056404 40.794937340845) | 19 | 4 | 19 | 13 | ||||
4978 | 4978 | -73.9521950056404 | 40.794937340844996 | 39H-PM-1013-01 | 39H | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ran away when a human approached with a dog | POINT (-73.9521950056404 40.794937340845) | 19 | 4 | 19 | 13 | ||||
2660 | 2660 | -73.9522142360388 | 40.7949598486683 | 39H-PM-1013-02 | 39H | PM | 1013 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9522142360388 40.7949598486683) | 19 | 4 | 19 | 13 | |||||
5683 | 5683 | -73.9522142360388 | 40.7949598486683 | 39H-PM-1013-02 | 39H | PM | 1013 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9522142360388 40.7949598486683) | 19 | 4 | 19 | 13 | |||||
2493 | 2493 | -73.9523001834395 | 40.7949231000186 | 39H-AM-1007-02 | 39H | AM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9523001834395 40.7949231000186) | 19 | 4 | 19 | 13 | |||||
5516 | 5516 | -73.9523001834395 | 40.7949231000186 | 39H-AM-1007-02 | 39H | AM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9523001834395 40.7949231000186) | 19 | 4 | 19 | 13 | |||||
2579 | 2579 | -73.9524490779105 | 40.7936003219524 | 38I-AM-1019-01 | 38I | AM | 1019 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9524490779105 40.7936003219524) | 19 | 4 | 19 | 13 | |||||
5602 | 5602 | -73.9524490779105 | 40.7936003219524 | 38I-AM-1019-01 | 38I | AM | 1019 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9524490779105 40.7936003219524) | 19 | 4 | 19 | 13 | |||||
360 | 360 | -73.95257475169142 | 40.7977257435263 | 42F-PM-1017-02 | 42F | PM | 1017 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9525747516914 40.7977257435263) | 19 | 4 | 19 | 13 | ||||
3383 | 3383 | -73.95257475169142 | 40.7977257435263 | 42F-PM-1017-02 | 42F | PM | 1017 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9525747516914 40.7977257435263) | 19 | 4 | 19 | 13 | ||||
2794 | 2794 | -73.9526681107152 | 40.7977012009146 | 42F-PM-1017-01 | 42F | PM | 1017 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9526681107152 40.7977012009146) | 19 | 4 | 19 | 13 | ||||
5817 | 5817 | -73.9526681107152 | 40.7977012009146 | 42F-PM-1017-01 | 42F | PM | 1017 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9526681107152 40.7977012009146) | 19 | 4 | 19 | 13 | ||||
550 | 550 | -73.9527184914182 | 40.792678590484705 | 37I-PM-1006-02 | 37I | PM | 1006 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9527184914182 40.7926785904847) | 19 | 4 | 19 | 13 | ||||||
3573 | 3573 | -73.9527184914182 | 40.792678590484705 | 37I-PM-1006-02 | 37I | PM | 1006 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9527184914182 40.7926785904847) | 19 | 4 | 19 | 13 | ||||||
703 | 703 | -73.9527924755398 | 40.79343662605329 | 37I-AM-1010-04 | 37I | AM | 1010 | 4 | Adult | Gray | Gray+ | Above Ground | 50.0 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9527924755398 40.7934366260533) | 19 | 4 | 19 | 13 | |||||
3726 | 3726 | -73.9527924755398 | 40.79343662605329 | 37I-AM-1010-04 | 37I | AM | 1010 | 4 | Adult | Gray | Gray+ | Above Ground | 50.0 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9527924755398 40.7934366260533) | 19 | 4 | 19 | 13 | |||||
2974 | 2974 | -73.9528149779809 | 40.7924984810637 | 36I-AM-1017-06 | 36I | AM | 1017 | 6 | Adult | Gray | Black | Gray+Black | Darker than others | Above Ground | 10.0 | Running down tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9528149779809 40.7924984810637) | 19 | 4 | 19 | 13 | |||
5997 | 5997 | -73.9528149779809 | 40.7924984810637 | 36I-AM-1017-06 | 36I | AM | 1017 | 6 | Adult | Gray | Black | Gray+Black | Darker than others | Above Ground | 10.0 | Running down tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9528149779809 40.7924984810637) | 19 | 4 | 19 | 13 | |||
2414 | 2414 | -73.952819267977 | 40.792313040279296 | 36I-AM-1017-02 | 36I | AM | 1017 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon stripe on back | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.952819267977 40.7923130402793) | 19 | 4 | 19 | 13 | ||||
5437 | 5437 | -73.952819267977 | 40.792313040279296 | 36I-AM-1017-02 | 36I | AM | 1017 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon stripe on back | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.952819267977 40.7923130402793) | 19 | 4 | 19 | 13 | ||||
1356 | 1356 | -73.9528462779437 | 40.792384304368504 | 36I-AM-1017-04 | 36I | AM | 1017 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9528462779437 40.7923843043685) | 19 | 4 | 19 | 13 | |||||
4379 | 4379 | -73.9528462779437 | 40.792384304368504 | 36I-AM-1017-04 | 36I | AM | 1017 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9528462779437 40.7923843043685) | 19 | 4 | 19 | 13 | |||||
1316 | 1316 | -73.9530035564643 | 40.792182245761296 | 36I-PM-1007-07 | 36I | PM | 1007 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530035564643 40.7921822457613) | 19 | 4 | 19 | 13 | ||||||
4339 | 4339 | -73.9530035564643 | 40.792182245761296 | 36I-PM-1007-07 | 36I | PM | 1007 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530035564643 40.7921822457613) | 19 | 4 | 19 | 13 | ||||||
411 | 411 | -73.9530040923555 | 40.7922896176936 | 36I-PM-1007-10 | 36I | PM | 1007 | 10 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | stole (found?) an entire sandwich | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530040923555 40.7922896176936) | 19 | 4 | 19 | 13 | ||||
3434 | 3434 | -73.9530040923555 | 40.7922896176936 | 36I-PM-1007-10 | 36I | PM | 1007 | 10 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | stole (found?) an entire sandwich | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530040923555 40.7922896176936) | 19 | 4 | 19 | 13 | ||||
109 | 109 | -73.95302635524891 | 40.7920949788358 | 36I-PM-1007-05 | 36I | PM | 1007 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9530263552489 40.7920949788358) | 19 | 4 | 19 | 13 | ||||||
3132 | 3132 | -73.95302635524891 | 40.7920949788358 | 36I-PM-1007-05 | 36I | PM | 1007 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9530263552489 40.7920949788358) | 19 | 4 | 19 | 13 | ||||||
38 | 38 | -73.9530791622513 | 40.79598856039671 | 40G-PM-1013-03 | 40G | PM | 1013 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530791622513 40.7959885603967) | 19 | 4 | 19 | 13 | ||||||
3061 | 3061 | -73.9530791622513 | 40.79598856039671 | 40G-PM-1013-03 | 40G | PM | 1013 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530791622513 40.7959885603967) | 19 | 4 | 19 | 13 | ||||||
824 | 824 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 1019 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530811255728 40.7983069118579) | 19 | 4 | 19 | 13 | |||||
3847 | 3847 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 1019 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530811255728 40.7983069118579) | 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 | ||||||||
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 | ||||||||
1281 | 1281 | -73.95310419064691 | 40.7919916819219 | 36I-PM-1007-02 | 36I | PM | 1007 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | chased birds (blue jay) | POINT (-73.9531041906469 40.7919916819219) | 19 | 4 | 19 | 13 | |||||
4304 | 4304 | -73.95310419064691 | 40.7919916819219 | 36I-PM-1007-02 | 36I | PM | 1007 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | chased birds (blue jay) | POINT (-73.9531041906469 40.7919916819219) | 19 | 4 | 19 | 13 | |||||
1718 | 1718 | -73.95312632141359 | 40.7965675089932 | 40F-PM-1006-01 | 40F | PM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9531263214136 40.7965675089932) | 19 | 4 | 19 | 13 | |||||
4741 | 4741 | -73.95312632141359 | 40.7965675089932 | 40F-PM-1006-01 | 40F | PM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9531263214136 40.7965675089932) | 19 | 4 | 19 | 13 | |||||
614 | 614 | -73.9531965469704 | 40.794743798397704 | 38G-PM-1020-11 | 38G | PM | 1020 | 11 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | POINT (-73.9531965469704 40.7947437983977) | 19 | 4 | 19 | 13 | |||||
3637 | 3637 | -73.9531965469704 | 40.794743798397704 | 38G-PM-1020-11 | 38G | PM | 1020 | 11 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | POINT (-73.9531965469704 40.7947437983977) | 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 | |||||||||
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 | |||||||||
1038 | 1038 | -73.9532170504865 | 40.7919669739962 | 36I-PM-1007-01 | 36I | PM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532170504865 40.7919669739962) | 19 | 4 | 19 | 13 | |||||
4061 | 4061 | -73.9532170504865 | 40.7919669739962 | 36I-PM-1007-01 | 36I | PM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532170504865 40.7919669739962) | 19 | 4 | 19 | 13 | |||||
793 | 793 | -73.9532427699097 | 40.7962643767092 | 40G-PM-1013-04 | 40G | PM | 1013 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532427699097 40.7962643767092) | 19 | 4 | 19 | 13 | ||||||
3816 | 3816 | -73.9532427699097 | 40.7962643767092 | 40G-PM-1013-04 | 40G | PM | 1013 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532427699097 40.7962643767092) | 19 | 4 | 19 | 13 | ||||||
1377 | 1377 | -73.9532657715601 | 40.7949046809422 | 39G-AM-1018-02 | 39G | AM | 1018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 25.0 | Tree | 0 | 0 | 0 | 0 | 0 | sitting & watching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532657715601 40.7949046809422) | 19 | 4 | 19 | 13 | ||||
4400 | 4400 | -73.9532657715601 | 40.7949046809422 | 39G-AM-1018-02 | 39G | AM | 1018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 25.0 | Tree | 0 | 0 | 0 | 0 | 0 | sitting & watching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532657715601 40.7949046809422) | 19 | 4 | 19 | 13 | ||||
2827 | 2827 | -73.9532838338416 | 40.79311126745829 | 37H-AM-1018-01 | 37H | AM | 1018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Right behind fence of the conservatory | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532838338416 40.7931112674583) | 19 | 4 | 19 | 13 | |||||
5850 | 5850 | -73.9532838338416 | 40.79311126745829 | 37H-AM-1018-01 | 37H | AM | 1018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Right behind fence of the conservatory | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532838338416 40.7931112674583) | 19 | 4 | 19 | 13 | |||||
2094 | 2094 | -73.953296595236 | 40.7927644594513 | 36I-AM-1017-03 | 36I | AM | 1017 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon stripe on back | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.953296595236 40.7927644594513) | 19 | 4 | 19 | 13 | ||||
5117 | 5117 | -73.953296595236 | 40.7927644594513 | 36I-AM-1017-03 | 36I | AM | 1017 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon stripe on back | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.953296595236 40.7927644594513) | 19 | 4 | 19 | 13 | ||||
1777 | 1777 | -73.953375642605 | 40.7947144477885 | 38G-PM-1020-02 | 38G | PM | 1020 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.953375642605 40.7947144477885) | 19 | 4 | 19 | 13 | |||||
4800 | 4800 | -73.953375642605 | 40.7947144477885 | 38G-PM-1020-02 | 38G | PM | 1020 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.953375642605 40.7947144477885) | 19 | 4 | 19 | 13 | |||||
2664 | 2664 | -73.9533923917973 | 40.796170187476896 | 40G-AM-1007-01 | 40G | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25.0 | large tree | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9533923917973 40.7961701874769) | 19 | 4 | 19 | 13 | ||||
5687 | 5687 | -73.9533923917973 | 40.796170187476896 | 40G-AM-1007-01 | 40G | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25.0 | large tree | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9533923917973 40.7961701874769) | 19 | 4 | 19 | 13 | ||||
2010 | 2010 | -73.95343062916791 | 40.7959052073753 | 39G-PM-1013-07 | 39G | PM | 1013 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9534306291679 40.7959052073753) | 19 | 4 | 19 | 13 | |||||
5033 | 5033 | -73.95343062916791 | 40.7959052073753 | 39G-PM-1013-07 | 39G | PM | 1013 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9534306291679 40.7959052073753) | 19 | 4 | 19 | 13 | |||||
2278 | 2278 | -73.9534509627885 | 40.7921084224711 | 36I-AM-1017-07 | 36I | AM | 1017 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (#8),scratching | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9534509627885 40.7921084224711) | 19 | 4 | 19 | 13 | ||||
5301 | 5301 | -73.9534509627885 | 40.7921084224711 | 36I-AM-1017-07 | 36I | AM | 1017 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (#8),scratching | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9534509627885 40.7921084224711) | 19 | 4 | 19 | 13 | ||||
1170 | 1170 | -73.9535410657077 | 40.7928711760061 | 36H-PM-1008-02 | 36H | PM | 1008 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9535410657077 40.7928711760061) | 19 | 4 | 19 | 13 | ||||||
4193 | 4193 | -73.9535410657077 | 40.7928711760061 | 36H-PM-1008-02 | 36H | PM | 1008 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9535410657077 40.7928711760061) | 19 | 4 | 19 | 13 | ||||||
1659 | 1659 | -73.95361987261741 | 40.798013510222795 | 41E-AM-1007-03 | 41E | AM | 1007 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9536198726174 40.7980135102228) | 19 | 4 | 19 | 13 | ||||||
4682 | 4682 | -73.95361987261741 | 40.798013510222795 | 41E-AM-1007-03 | 41E | AM | 1007 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9536198726174 40.7980135102228) | 19 | 4 | 19 | 13 | ||||||
1512 | 1512 | -73.9537356145842 | 40.7917273773486 | 35I-PM-1006-02 | 35I | PM | 1006 | 2 | Adult | Gray | Gray+ | Above Ground | 6.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9537356145842 40.7917273773486) | 19 | 4 | 19 | 13 | ||||||
4535 | 4535 | -73.9537356145842 | 40.7917273773486 | 35I-PM-1006-02 | 35I | PM | 1006 | 2 | Adult | Gray | Gray+ | Above Ground | 6.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9537356145842 40.7917273773486) | 19 | 4 | 19 | 13 | ||||||
2218 | 2218 | -73.9538251716292 | 40.7919360198175 | 35I-PM-1006-01 | 35I | PM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538251716292 40.7919360198175) | 19 | 4 | 19 | 13 | |||||
5241 | 5241 | -73.9538251716292 | 40.7919360198175 | 35I-PM-1006-01 | 35I | PM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538251716292 40.7919360198175) | 19 | 4 | 19 | 13 | |||||
345 | 345 | -73.9538377039825 | 40.798060533496106 | 42E-PM-1012-03 | 42E | PM | 1012 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | in tree | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538377039825 40.7980605334961) | 19 | 4 | 19 | 13 | ||||
3368 | 3368 | -73.9538377039825 | 40.798060533496106 | 42E-PM-1012-03 | 42E | PM | 1012 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | in tree | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538377039825 40.7980605334961) | 19 | 4 | 19 | 13 | ||||
1021 | 1021 | -73.9538475741188 | 40.796479421955 | 40F-PM-1006-02 | 40F | PM | 1006 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6.0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538475741188 40.796479421955) | 19 | 4 | 19 | 13 | |||||
4044 | 4044 | -73.9538475741188 | 40.796479421955 | 40F-PM-1006-02 | 40F | PM | 1006 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6.0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538475741188 40.796479421955) | 19 | 4 | 19 | 13 | |||||
1898 | 1898 | -73.95385121459 | 40.7981257651433 | 42E-PM-1012-04 | 42E | PM | 1012 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95385121459 40.7981257651433) | 19 | 4 | 19 | 13 | |||||
4921 | 4921 | -73.95385121459 | 40.7981257651433 | 42E-PM-1012-04 | 42E | PM | 1012 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95385121459 40.7981257651433) | 19 | 4 | 19 | 13 | |||||
2525 | 2525 | -73.95388671863759 | 40.794140943400706 | 38G-PM-1020-03 | 38G | PM | 1020 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9538867186376 40.7941409434007) | 19 | 4 | 19 | 13 | |||||
5548 | 5548 | -73.95388671863759 | 40.794140943400706 | 38G-PM-1020-03 | 38G | PM | 1020 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9538867186376 40.7941409434007) | 19 | 4 | 19 | 13 | |||||
1369 | 1369 | -73.9538938706987 | 40.7981150065974 | 42E-PM-1012-05 | 42E | PM | 1012 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538938706987 40.7981150065974) | 19 | 4 | 19 | 13 | |||||
4392 | 4392 | -73.9538938706987 | 40.7981150065974 | 42E-PM-1012-05 | 42E | PM | 1012 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538938706987 40.7981150065974) | 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 )