Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Longitude, Latitude, Hectare, Shift, Age, Color_notes, Location, Above_Ground_Sighter_Measurement, Running, Climbing, Eating, Tail_flags, Tail_twitches, Indifferent, Runs_from, Latlong
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408 | 408 | -73.9748962681637 | 40.76787782717 | 4F-PM-1013-02 | 04F | PM | 1013 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9748962681637 40.76787782717) | 19 | 4 | 19 | 13 | |||||
3431 | 3431 | -73.9748962681637 | 40.76787782717 | 4F-PM-1013-02 | 04F | PM | 1013 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9748962681637 40.76787782717) | 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 | ||||
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 | ||||
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 | ||||
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 | ||||
644 | 644 | -73.97902264006291 | 40.76989976537921 | 4B-AM-1010-01 | 04B | AM | 1010 | 1 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Above Ground | 2.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9790226400629 40.7698997653792) | 19 | 4 | 19 | 13 | |||||
3667 | 3667 | -73.97902264006291 | 40.76989976537921 | 4B-AM-1010-01 | 04B | AM | 1010 | 1 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Above Ground | 2.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9790226400629 40.7698997653792) | 19 | 4 | 19 | 13 | |||||
636 | 636 | -73.9728783802067 | 40.7731671049246 | 9E-PM-1014-02 | 09E | PM | 1014 | 2 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9728783802067 40.7731671049246) | 19 | 4 | 19 | 13 | |||||
3659 | 3659 | -73.9728783802067 | 40.7731671049246 | 9E-PM-1014-02 | 09E | PM | 1014 | 2 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9728783802067 40.7731671049246) | 19 | 4 | 19 | 13 | |||||
172 | 172 | -73.9761579527932 | 40.7755877312075 | 10A-PM-1014-02 | 10A | PM | 1014 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | in the bushes beneath a tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9761579527932 40.7755877312075) | 19 | 4 | 19 | 13 | ||||
3195 | 3195 | -73.9761579527932 | 40.7755877312075 | 10A-PM-1014-02 | 10A | PM | 1014 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | in the bushes beneath a tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9761579527932 40.7755877312075) | 19 | 4 | 19 | 13 | ||||
2989 | 2989 | -73.9703705008688 | 40.7818586173755 | 19B-PM-1018-02 | 19B | PM | 1018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703705008688 40.7818586173755) | 19 | 4 | 19 | 13 | ||||
6012 | 6012 | -73.9703705008688 | 40.7818586173755 | 19B-PM-1018-02 | 19B | PM | 1018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703705008688 40.7818586173755) | 19 | 4 | 19 | 13 | ||||
2752 | 2752 | -73.95763044737221 | 40.795981062234205 | 38D-AM-1017-05 | 38D | AM | 1017 | 5 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Black stripe along sides | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | eating (nut) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9576304473722 40.7959810622342) | 19 | 4 | 19 | 13 | |||
5775 | 5775 | -73.95763044737221 | 40.795981062234205 | 38D-AM-1017-05 | 38D | AM | 1017 | 5 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Black stripe along sides | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | eating (nut) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9576304473722 40.7959810622342) | 19 | 4 | 19 | 13 | |||
2994 | 2994 | -73.95544156650821 | 40.798420141601795 | 41D-AM-1014-03 | 41D | AM | 1014 | 3 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9554415665082 40.7984201416018) | 19 | 4 | 19 | 13 | |||||
6017 | 6017 | -73.95544156650821 | 40.798420141601795 | 41D-AM-1014-03 | 41D | AM | 1014 | 3 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9554415665082 40.7984201416018) | 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 )