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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82 | 82 | -73.96882712024009 | 40.7809719445309 | 19C-PM-1018-01 | 19C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9688271202401 40.7809719445309) | ||||
| 450 | 450 | -73.96442931957729 | 40.7813829172072 | 21F-AM-1018-02 | 21F | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9644293195773 40.7813829172072) | ||||
| 2255 | 2255 | -73.96429678758571 | 40.78156523539371 | 21F-AM-1018-08 | 21F | AM | 10182018 | 8 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9642967875857 40.7815652353937) | ||||
| 1339 | 1339 | -73.96864133261721 | 40.7817423907284 | 19C-PM-1018-08 | 19C | PM | 10182018 | 8 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686413326172 40.7817423907284) | |||
| 1691 | 1691 | -73.9703705008688 | 40.7818586173755 | 19B-PM-1018-02 | 19B | PM | 10182018 | 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) | |||
| 2048 | 2048 | -73.96276614653759 | 40.7819356810575 | 22G-PM-1018-02 | 22G | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9627661465376 40.7819356810575) | ||||
| 309 | 309 | -73.9696001184129 | 40.782081067353204 | 19B-PM-1018-05 | 19B | PM | 10182018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9696001184129 40.7820810673532) | |||
| 2294 | 2294 | -73.96308205774409 | 40.7821632293136 | 22G-PM-1018-01 | 22G | PM | 10182018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9630820577441 40.7821632293136) | |||
| 1620 | 1620 | -73.96356061997841 | 40.782206970617 | 22G-AM-1018-03 | 22G | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9635606199784 40.782206970617) | ||||
| 2941 | 2941 | -73.96902666603171 | 40.7853134751509 | 23A-AM-1018-01 | 23A | AM | 10182018 | 1 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690266660317 40.7853134751509) | |||||
| 1528 | 1528 | -73.9690104245067 | 40.7853358193723 | 23A-AM-1018-02 | 23A | AM | 10182018 | 2 | Juvenile | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690104245067 40.7853358193723) | |||||
| 258 | 258 | -73.9534333425633 | 40.793256416332795 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9534333425633 40.7932564163328) | |||
| 1203 | 1203 | -73.9616999731028 | 40.7954126939561 | 36A-AM-1018-02 | 36A | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | eating (red berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9616999731028 40.7954126939561) | |||
| 488 | 488 | -73.9615751148595 | 40.795455123814605 | 36A-AM-1018-01 | 36A | AM | 10182018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | eating (red berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615751148595 40.7954551238146) | |||
| 1632 | 1632 | -73.9592392692535 | 40.796186995179795 | 37B-AM-1018-02 | 37B | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9592392692535 40.7961869951798) |
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 );