Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Longitude, Latitude, Unique_Squirrel_ID, Shift, Hectare_Squirrel_Number, Primary_Fur_Color, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Climbing, Eating, Foraging, Kuks, Tail_flags, Tail_twitches, Indifferent, Runs_from, Latlong
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8 | 8 | -73.97296259363002 | 40.7652601851275 | 1I-PM-1012-04 | 01I | PM | 1012 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 2.0 | on ledge | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.97296259363 40.7652601851275) | 19 | 4 | 19 | 13 | |||
110 | 110 | -73.96280415779341 | 40.7884180156055 | 28D-AM-1012-06 | 28D | AM | 1012 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 5.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9628041577934 40.7884180156055) | 19 | 4 | 19 | 13 | |||||
771 | 771 | -73.9626560807032 | 40.7884633049896 | 28D-AM-1012-05 | 28D | AM | 1012 | 5 | Juvenile | Black | Black+ | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9626560807032 40.7884633049896) | 19 | 4 | 19 | 13 | ||||||
966 | 966 | -73.9733222531339 | 40.764997537154606 | 1I-PM-1012-01 | 01I | PM | 1012 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9733222531339 40.7649975371546) | 19 | 4 | 19 | 13 | ||||
1054 | 1054 | -73.96801718943509 | 40.772464442631296 | 11I-PM-1012-07 | 11I | PM | 1012 | 7 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying its food into the ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9680171894351 40.7724644426313) | 19 | 4 | 19 | 13 | |||||
1182 | 1182 | -73.9801343393329 | 40.769151245340204 | 3A-AM-1012-01 | 03A | AM | 1012 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801343393329 40.7691512453402) | 19 | 4 | 19 | 13 | ||||
1350 | 1350 | -73.965215665278 | 40.7761309082202 | 15I-PM-1012-02 | 15I | PM | 1012 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.965215665278 40.7761309082202) | 19 | 4 | 19 | 13 | ||||||
1766 | 1766 | -73.9736873018042 | 40.76491066771379 | 1I-PM-1012-02 | 01I | PM | 1012 | 2 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | tree | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9736873018042 40.7649106677138) | 19 | 4 | 19 | 13 | |||
1797 | 1797 | -73.98020792598659 | 40.7678723471007 | 1B-AM-1012-10 | 01B | AM | 1012 | 10 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9802079259866 40.7678723471007) | 19 | 4 | 19 | 13 | |||||
2442 | 2442 | -73.9801902133148 | 40.769557595068 | 3A-AM-1012-03 | 03A | AM | 1012 | 3 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801902133148 40.769557595068) | 19 | 4 | 19 | 13 | ||||
3031 | 3031 | -73.97296259363002 | 40.7652601851275 | 1I-PM-1012-04 | 01I | PM | 1012 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 2.0 | on ledge | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.97296259363 40.7652601851275) | 19 | 4 | 19 | 13 | |||
3133 | 3133 | -73.96280415779341 | 40.7884180156055 | 28D-AM-1012-06 | 28D | AM | 1012 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 5.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9628041577934 40.7884180156055) | 19 | 4 | 19 | 13 | |||||
3794 | 3794 | -73.9626560807032 | 40.7884633049896 | 28D-AM-1012-05 | 28D | AM | 1012 | 5 | Juvenile | Black | Black+ | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9626560807032 40.7884633049896) | 19 | 4 | 19 | 13 | ||||||
3989 | 3989 | -73.9733222531339 | 40.764997537154606 | 1I-PM-1012-01 | 01I | PM | 1012 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9733222531339 40.7649975371546) | 19 | 4 | 19 | 13 | ||||
4077 | 4077 | -73.96801718943509 | 40.772464442631296 | 11I-PM-1012-07 | 11I | PM | 1012 | 7 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying its food into the ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9680171894351 40.7724644426313) | 19 | 4 | 19 | 13 | |||||
4205 | 4205 | -73.9801343393329 | 40.769151245340204 | 3A-AM-1012-01 | 03A | AM | 1012 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801343393329 40.7691512453402) | 19 | 4 | 19 | 13 | ||||
4373 | 4373 | -73.965215665278 | 40.7761309082202 | 15I-PM-1012-02 | 15I | PM | 1012 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.965215665278 40.7761309082202) | 19 | 4 | 19 | 13 | ||||||
4789 | 4789 | -73.9736873018042 | 40.76491066771379 | 1I-PM-1012-02 | 01I | PM | 1012 | 2 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | tree | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9736873018042 40.7649106677138) | 19 | 4 | 19 | 13 | |||
4820 | 4820 | -73.98020792598659 | 40.7678723471007 | 1B-AM-1012-10 | 01B | AM | 1012 | 10 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9802079259866 40.7678723471007) | 19 | 4 | 19 | 13 | |||||
5465 | 5465 | -73.9801902133148 | 40.769557595068 | 3A-AM-1012-03 | 03A | AM | 1012 | 3 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801902133148 40.769557595068) | 19 | 4 | 19 | 13 | ||||
427 | 427 | -73.95656845779891 | 40.79360039404129 | 36F-PM-1012-02 | 36F | PM | 1012 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9565684577989 40.7936003940413) | 19 | 4 | 19 | 13 | |||||
1764 | 1764 | -73.9566277721581 | 40.7966674587803 | 39D-PM-1012-04 | 39D | PM | 1012 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 10.0 | on tree trunk (descending from height of ~10 ft) | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9566277721581 40.7966674587803) | 19 | 4 | 19 | 13 | ||||
1944 | 1944 | -73.95701325709341 | 40.793201415908705 | 35F-PM-1012-01 | 35F | PM | 1012 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | POINT (-73.9570132570934 40.7932014159087) | 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 | |||||||
3450 | 3450 | -73.95656845779891 | 40.79360039404129 | 36F-PM-1012-02 | 36F | PM | 1012 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9565684577989 40.7936003940413) | 19 | 4 | 19 | 13 | |||||
4787 | 4787 | -73.9566277721581 | 40.7966674587803 | 39D-PM-1012-04 | 39D | PM | 1012 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 10.0 | on tree trunk (descending from height of ~10 ft) | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9566277721581 40.7966674587803) | 19 | 4 | 19 | 13 | ||||
4967 | 4967 | -73.95701325709341 | 40.793201415908705 | 35F-PM-1012-01 | 35F | PM | 1012 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | POINT (-73.9570132570934 40.7932014159087) | 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 |
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 )