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 | Lat/Long |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2265 | 2265 | -73.97052601032391 | 40.782633368659894 | 19A-PM-1013-04 | 19A | PM | 10132018 | 4 | Adult | Gray | Black, White | Gray+Black, White | Also looks quite brown - minimal body highlight coloring - black edges | Above Ground | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9705260103239 40.78263336865991) | |||
| 2050 | 2050 | -73.9555255950648 | 40.7977720808005 | 40D-AM-1013-04 | 40D | AM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9555255950648 40.7977720808005) | |||
| 1533 | 1533 | -73.95200246546021 | 40.794732982815496 | 39I-PM-1013-04 | 39I | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Gray & Cinnamon selected as both Primary and Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.95200246546021 40.7947329828155) | ||
| 299 | 299 | -73.9586214081667 | 40.7937473968735 | 35D-PM-1013-03 | 35D | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | No Tail! | Above Ground | 2 | bench | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9586214081667 40.7937473968735) | ||
| 545 | 545 | -73.97568104536059 | 40.7756257458036 | 11A-PM-1013-01 | 11A | PM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Off-white, decorator's white? | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | eating (osage orange) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756810453606 40.7756257458036) | ||
| 1478 | 1478 | -73.9676370985166 | 40.7869888639434 | 25A-AM-1013-01 | 25A | AM | 10132018 | 1 | Gray | White | Gray+White | White Belly | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | staring at me | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96763709851662 40.7869888639434) | |||
| 2102 | 2102 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | 0 | 0 | 0 | 1 | 1 | watching | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9593909381748 40.7961036981921) | ||||
| 646 | 646 | -73.954092292214 | 40.7979800395433 | 41E-PM-1013-05 | 41E | PM | 10132018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 10 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954092292214 40.7979800395433) |
JSON shape: default, array, newline-delimited
CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" ( "longitude" REAL, "latitude" REAL, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" INTEGER, "Hectare Squirrel Number" INTEGER, "Age" TEXT, "Primary Fur Color" TEXT, "Highlight Fur Color" TEXT, "Combination of Primary and Highlight Color" TEXT, "Color notes" TEXT, "Location" TEXT, "Above Ground Sighter Measurement" TEXT, "Specific Location" TEXT, "Running" INTEGER, "Chasing" INTEGER, "Climbing" INTEGER, "Eating" INTEGER, "Foraging" INTEGER, "Other Activities" TEXT, "Kuks" INTEGER, "Quaas" INTEGER, "Moans" INTEGER, "Tail flags" INTEGER, "Tail twitches" INTEGER, "Approaches" INTEGER, "Indifferent" INTEGER, "Runs from" INTEGER, "Other Interactions" TEXT, "Lat/Long" TEXT );