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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2554 | 2554 | -73.9701505245419 | 40.768998364571 | 6I-PM-1013-07 | 06I | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 11 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9701505245419 40.768998364571004) | |||||
2669 | 2669 | -73.9615900833886 | 40.7945431292846 | 35A-PM-1013-07 | 35A | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9615900833886 40.7945431292846) | ||||
2784 | 2784 | -73.9763722433833 | 40.7744121430891 | 9A-AM-1013-07 | 09A | AM | 10132018 | 7 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763722433833 40.7744121430891) | ||||||||
103 | 103 | -73.96077013704429 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 10132018 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | 0 | 1 | 0 | 0 | 0 | chasing #8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9607701370443 40.7955418990855) | ||||
1656 | 1656 | -73.9557399927792 | 40.7971563708988 | 40D-PM-1013-07 | 40D | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9557399927792 40.7971563708988) | ||||
1797 | 1797 | -73.96971780962751 | 40.769703669630104 | 7I-PM-1013-07 | 07I | PM | 10132018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | Under the tree | 0 | 1 | 0 | 0 | 0 | playing,interacting with #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9697178096275 40.769703669630104) | ||
2085 | 2085 | -73.9690551477139 | 40.782368566319604 | 20B-PM-1013-07 | 20B | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690551477139 40.7823685663196) | ||||
2812 | 2812 | -73.963209639301 | 40.7926138443715 | 32A-PM-1013-07 | 32A | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.963209639301 40.7926138443715) |
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 );