Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||
| 5616 | 5616 | -73.97471754195459 | 40.769282003087795 | 5E-PM-1012-05 | 05E | PM | 1012 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | begging | POINT (-73.9747175419546 40.7692820030878) | 19 | 4 | 19 | 13 | ||||
| 5669 | 5669 | -73.97876087620051 | 40.7686062296462 | 3C-PM-1008-01 | 03C | PM | 1008 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3.0 | 0 | 0 | 0 | 0 | 0 | walked between trees | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9787608762005 40.7686062296462) | 19 | 4 | 19 | 13 | ||||
| 5796 | 5796 | -73.97547941915529 | 40.7696404489025 | 5E-PM-1012-01 | 05E | PM | 1012 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9754794191553 40.7696404489025) | 19 | 4 | 19 | 13 | |||||
| 5822 | 5822 | -73.9645060433292 | 40.7768322057794 | 16I-AM-1008-03 | 16I | AM | 1008 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9645060433292 40.7768322057794) | 19 | 4 | 19 | 13 | |||||
| 5848 | 5848 | -73.9690540696008 | 40.7766014124609 | 14F-PM-1012-08 | 14F | PM | 1012 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690540696008 40.7766014124609) | 19 | 4 | 19 | 13 | |||||
| 5886 | 5886 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 1008 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | was chased by # 11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763236949008 40.7686815615335) | 19 | 4 | 19 | 13 | ||||
| 5933 | 5933 | -73.97634308293419 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 1008 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3.0 | on tree facing downward | 0 | 1 | 0 | 0 | 0 | chased #12 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
| 301 | 301 | -73.9594676326588 | 40.7984457363388 | 39A-AM-1013-01 | 39A | AM | 1013 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9594676326588 40.7984457363388) | 19 | 4 | 19 | 13 | |||||
| 679 | 679 | -73.9643538221947 | 40.7917565604735 | 31A-PM-1017-01 | 31A | PM | 1017 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9643538221947 40.7917565604735) | 19 | 4 | 19 | 13 | ||||
| 2043 | 2043 | -73.95813265542058 | 40.7918074743129 | 34E-PM-1006-02 | 34E | PM | 1006 | 2 | Juvenile | Black | Gray, White | Black+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9581326554206 40.7918074743129) | 19 | 4 | 19 | 13 | |||||
| 2279 | 2279 | -73.9791826197108 | 40.768577844752 | 2B-AM-1010-08 | 02B | AM | 1010 | 8 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9791826197108 40.768577844752) | 19 | 4 | 19 | 13 | |||||
| 2977 | 2977 | -73.9789251806378 | 40.7699558513225 | 4B-AM-1010-02 | 04B | AM | 1010 | 2 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 30.0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9789251806378 40.7699558513225) | 19 | 4 | 19 | 13 | |||||
| 3324 | 3324 | -73.9594676326588 | 40.7984457363388 | 39A-AM-1013-01 | 39A | AM | 1013 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9594676326588 40.7984457363388) | 19 | 4 | 19 | 13 | |||||
| 3702 | 3702 | -73.9643538221947 | 40.7917565604735 | 31A-PM-1017-01 | 31A | PM | 1017 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9643538221947 40.7917565604735) | 19 | 4 | 19 | 13 | ||||
| 5066 | 5066 | -73.95813265542058 | 40.7918074743129 | 34E-PM-1006-02 | 34E | PM | 1006 | 2 | Juvenile | Black | Gray, White | Black+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9581326554206 40.7918074743129) | 19 | 4 | 19 | 13 | |||||
| 5302 | 5302 | -73.9791826197108 | 40.768577844752 | 2B-AM-1010-08 | 02B | AM | 1010 | 8 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9791826197108 40.768577844752) | 19 | 4 | 19 | 13 | |||||
| 6000 | 6000 | -73.9789251806378 | 40.7699558513225 | 4B-AM-1010-02 | 04B | AM | 1010 | 2 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 30.0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9789251806378 40.7699558513225) | 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 )