Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Longitude, Latitude, Unique_Squirrel_ID, Hectare, Shift, Date, Hectare_Squirrel_Number, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Chasing, Climbing, Eating, Foraging, Other_Activities, Kuks, Tail_flags, Tail_twitches, Indifferent, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 255 | 255 | -73.9763116425885 | 40.768883957648704 | 4D-PM-1008-03 | 04D | PM | 1008 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran two feet up tree trunk | POINT (-73.9763116425885 40.7688839576487) | 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 | |||||
| 390 | 390 | -73.951965247933 | 40.7938167628067 | 38I-PM-1014-03 | 38I | PM | 1014 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.951965247933 40.7938167628067) | 19 | 4 | 19 | 13 | |||||
| 470 | 470 | -73.95414534658171 | 40.798216222376396 | 42E-PM-1012-06 | 42E | PM | 1012 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9541453465817 40.7982162223764) | 19 | 4 | 19 | 13 | |||||
| 741 | 741 | -73.9686925781295 | 40.7705688673142 | 9I-PM-1010-05 | 09I | PM | 1010 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9686925781295 40.7705688673142) | 19 | 4 | 19 | 13 | |||||
| 916 | 916 | -73.978199543688 | 40.7695660563362 | 4C-PM-1010-17 | 04C | PM | 1010 | 17 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | climbed up tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.978199543688 40.7695660563362) | 19 | 4 | 19 | 13 | ||||
| 1063 | 1063 | -73.9748367344424 | 40.7693513000034 | 5E-PM-1012-06 | 05E | PM | 1012 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10.0 | oak tree at end of ramp from Chess House | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9748367344424 40.7693513000034) | 19 | 4 | 19 | 13 | ||||
| 1637 | 1637 | -73.9758959798289 | 40.7694125671679 | 4D-PM-1008-01 | 04D | PM | 1008 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9758959798289 40.7694125671679) | 19 | 4 | 19 | 13 | |||||
| 1798 | 1798 | -73.9724618533895 | 40.7745021602455 | 11D-AM-1010-02 | 11D | AM | 1010 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9724618533895 40.7745021602455) | 19 | 4 | 19 | 13 | ||||
| 1915 | 1915 | -73.9762348224648 | 40.7694522315322 | 4D-PM-1008-08 | 04D | PM | 1008 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | climbed fence staring at me - went up tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9762348224648 40.7694522315322) | 19 | 4 | 19 | 13 | ||||
| 2142 | 2142 | -73.954499539822 | 40.7949716693686 | 38F-AM-1018-01 | 38F | AM | 1018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.954499539822 40.7949716693686) | 19 | 4 | 19 | 13 | |||||
| 2577 | 2577 | -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 | |||||
| 2863 | 2863 | -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 | ||||
| 2910 | 2910 | -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 | |||
| 3278 | 3278 | -73.9763116425885 | 40.768883957648704 | 4D-PM-1008-03 | 04D | PM | 1008 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran two feet up tree trunk | POINT (-73.9763116425885 40.7688839576487) | 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 | |||||
| 3413 | 3413 | -73.951965247933 | 40.7938167628067 | 38I-PM-1014-03 | 38I | PM | 1014 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.951965247933 40.7938167628067) | 19 | 4 | 19 | 13 | |||||
| 3493 | 3493 | -73.95414534658171 | 40.798216222376396 | 42E-PM-1012-06 | 42E | PM | 1012 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9541453465817 40.7982162223764) | 19 | 4 | 19 | 13 | |||||
| 3764 | 3764 | -73.9686925781295 | 40.7705688673142 | 9I-PM-1010-05 | 09I | PM | 1010 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9686925781295 40.7705688673142) | 19 | 4 | 19 | 13 | |||||
| 3939 | 3939 | -73.978199543688 | 40.7695660563362 | 4C-PM-1010-17 | 04C | PM | 1010 | 17 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | climbed up tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.978199543688 40.7695660563362) | 19 | 4 | 19 | 13 | ||||
| 4086 | 4086 | -73.9748367344424 | 40.7693513000034 | 5E-PM-1012-06 | 05E | PM | 1012 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10.0 | oak tree at end of ramp from Chess House | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9748367344424 40.7693513000034) | 19 | 4 | 19 | 13 | ||||
| 4660 | 4660 | -73.9758959798289 | 40.7694125671679 | 4D-PM-1008-01 | 04D | PM | 1008 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9758959798289 40.7694125671679) | 19 | 4 | 19 | 13 | |||||
| 4821 | 4821 | -73.9724618533895 | 40.7745021602455 | 11D-AM-1010-02 | 11D | AM | 1010 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9724618533895 40.7745021602455) | 19 | 4 | 19 | 13 | ||||
| 4938 | 4938 | -73.9762348224648 | 40.7694522315322 | 4D-PM-1008-08 | 04D | PM | 1008 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | climbed fence staring at me - went up tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9762348224648 40.7694522315322) | 19 | 4 | 19 | 13 | ||||
| 5165 | 5165 | -73.954499539822 | 40.7949716693686 | 38F-AM-1018-01 | 38F | AM | 1018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.954499539822 40.7949716693686) | 19 | 4 | 19 | 13 | |||||
| 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 | |||||
| 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 |
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 )