Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Longitude, Latitude, Unique_Squirrel_ID, Shift, Date, Hectare_Squirrel_Number, Combination_of_Primary_and_Highlight_Color, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Climbing, Eating, Foraging, Other_Activities, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Other_Interactions, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61 | 61 | -73.9810149147578 | 40.7683925377714 | 2A-AM-1010-03 | 02A | AM | 1010 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | on trunk | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9810149147578 40.7683925377714) | 19 | 4 | 19 | 13 | ||||
| 305 | 305 | -73.9808247660048 | 40.76894088312871 | 2A-PM-1019-01 | 02A | PM | 1019 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | runs from | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9808247660048 40.7689408831287) | 19 | 4 | 19 | 13 | ||||
| 476 | 476 | -73.98108436110859 | 40.768790549369896 | 2A-PM-1019-05 | 02A | PM | 1019 | 5 | ? | Gray | Gray+ | Above Ground | 50.0 | in tall planetree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9810843611086 40.7687905493699) | 19 | 4 | 19 | 13 | |||||
| 712 | 712 | -73.9805137046778 | 40.769275143797 | 2A-AM-1010-08 | 02A | AM | 1010 | 8 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9805137046778 40.769275143797) | 19 | 4 | 19 | 13 | |||||
| 906 | 906 | -73.9807078515193 | 40.768333529264204 | 2A-AM-1010-04 | 02A | AM | 1010 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9807078515193 40.7683335292642) | 19 | 4 | 19 | 13 | |||||
| 1230 | 1230 | -73.98016364007441 | 40.769019205592606 | 2A-AM-1010-09 | 02A | AM | 1010 | 9 | Adult | Gray | White | Gray+White | Above Ground | climbing in bush | 0 | 0 | 1 | 0 | 0 | hopping & flipping around. this one was very energetic & jumping aorund | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | climbed a foot up a tree and watched me | POINT (-73.9801636400744 40.7690192055926) | 19 | 4 | 19 | 13 | |||
| 1292 | 1292 | -73.980948293606 | 40.76856888506279 | 2A-PM-1019-04 | 02A | PM | 1019 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15.0 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.980948293606 40.7685688850628) | 19 | 4 | 19 | 13 | ||||
| 1333 | 1333 | -73.9806718258385 | 40.7692776896995 | 2A-AM-1010-07 | 02A | AM | 1010 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | couldn't get near | POINT (-73.9806718258385 40.7692776896995) | 19 | 4 | 19 | 13 | ||||
| 1611 | 1611 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9809342290598 40.7687265606227) | 19 | 4 | 19 | 13 | ||||
| 1914 | 1914 | -73.98094464895641 | 40.768503216587895 | 2A-PM-1019-03 | 02A | PM | 1019 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 15.0 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809446489564 40.7685032165879) | 19 | 4 | 19 | 13 | ||||
| 2221 | 2221 | -73.98069592481521 | 40.7684820679479 | 2A-AM-1010-01 | 02A | AM | 1010 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9806959248152 40.7684820679479) | 19 | 4 | 19 | 13 | |||||
| 2536 | 2536 | -73.98089749771201 | 40.7690578709841 | 2A-PM-1019-02 | 02A | PM | 1019 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.980897497712 40.7690578709841) | 19 | 4 | 19 | 13 | |||||
| 2721 | 2721 | -73.9809688694074 | 40.7688535974878 | 2A-PM-1019-06 | 02A | PM | 1019 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809688694074 40.7688535974878) | 19 | 4 | 19 | 13 | |||||
| 2834 | 2834 | -73.98096101171708 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 1010 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
| 3084 | 3084 | -73.9810149147578 | 40.7683925377714 | 2A-AM-1010-03 | 02A | AM | 1010 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | on trunk | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9810149147578 40.7683925377714) | 19 | 4 | 19 | 13 | ||||
| 3328 | 3328 | -73.9808247660048 | 40.76894088312871 | 2A-PM-1019-01 | 02A | PM | 1019 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | runs from | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9808247660048 40.7689408831287) | 19 | 4 | 19 | 13 | ||||
| 3499 | 3499 | -73.98108436110859 | 40.768790549369896 | 2A-PM-1019-05 | 02A | PM | 1019 | 5 | ? | Gray | Gray+ | Above Ground | 50.0 | in tall planetree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9810843611086 40.7687905493699) | 19 | 4 | 19 | 13 | |||||
| 3735 | 3735 | -73.9805137046778 | 40.769275143797 | 2A-AM-1010-08 | 02A | AM | 1010 | 8 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9805137046778 40.769275143797) | 19 | 4 | 19 | 13 | |||||
| 3929 | 3929 | -73.9807078515193 | 40.768333529264204 | 2A-AM-1010-04 | 02A | AM | 1010 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9807078515193 40.7683335292642) | 19 | 4 | 19 | 13 | |||||
| 4253 | 4253 | -73.98016364007441 | 40.769019205592606 | 2A-AM-1010-09 | 02A | AM | 1010 | 9 | Adult | Gray | White | Gray+White | Above Ground | climbing in bush | 0 | 0 | 1 | 0 | 0 | hopping & flipping around. this one was very energetic & jumping aorund | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | climbed a foot up a tree and watched me | POINT (-73.9801636400744 40.7690192055926) | 19 | 4 | 19 | 13 | |||
| 4315 | 4315 | -73.980948293606 | 40.76856888506279 | 2A-PM-1019-04 | 02A | PM | 1019 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15.0 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.980948293606 40.7685688850628) | 19 | 4 | 19 | 13 | ||||
| 4356 | 4356 | -73.9806718258385 | 40.7692776896995 | 2A-AM-1010-07 | 02A | AM | 1010 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | couldn't get near | POINT (-73.9806718258385 40.7692776896995) | 19 | 4 | 19 | 13 | ||||
| 4634 | 4634 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9809342290598 40.7687265606227) | 19 | 4 | 19 | 13 | ||||
| 4937 | 4937 | -73.98094464895641 | 40.768503216587895 | 2A-PM-1019-03 | 02A | PM | 1019 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 15.0 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809446489564 40.7685032165879) | 19 | 4 | 19 | 13 | ||||
| 5244 | 5244 | -73.98069592481521 | 40.7684820679479 | 2A-AM-1010-01 | 02A | AM | 1010 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9806959248152 40.7684820679479) | 19 | 4 | 19 | 13 | |||||
| 5559 | 5559 | -73.98089749771201 | 40.7690578709841 | 2A-PM-1019-02 | 02A | PM | 1019 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.980897497712 40.7690578709841) | 19 | 4 | 19 | 13 | |||||
| 5744 | 5744 | -73.9809688694074 | 40.7688535974878 | 2A-PM-1019-06 | 02A | PM | 1019 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809688694074 40.7688535974878) | 19 | 4 | 19 | 13 | |||||
| 5857 | 5857 | -73.98096101171708 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 1010 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9809610117171 40.7683896665502) | 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 )