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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2218 | 2218 | -73.9694382427984 | 40.7846350692923 | 22A-AM-1008-04 | 22A | AM | 10082018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9694382427984 40.7846350692923) | ||||
| 2239 | 2239 | -73.9668922014699 | 40.7823535653774 | 21D-AM-1008-06 | 21D | AM | 10082018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9668922014699 40.7823535653774) | |||||
| 2271 | 2271 | -73.96739494580959 | 40.7826218539496 | 21D-AM-1008-04 | 21D | AM | 10082018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9673949458096 40.78262185394961) | ||||
| 2318 | 2318 | -73.967458693983 | 40.7769922522105 | 15G-AM-1008-02 | 15G | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.967458693983 40.7769922522105) | |||||
| 2347 | 2347 | -73.9663124560664 | 40.779544003786 | 18F-PM-1008-02 | 18F | PM | 10082018 | 2 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | hopping around | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9663124560664 40.779544003786) | ||||||
| 2734 | 2734 | -73.9763629541474 | 40.7682321897044 | 3E-PM-1008-04 | 03E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763629541474 40.7682321897044) | |||||
| 2749 | 2749 | -73.972967003211 | 40.7711848438157 | 7F-AM-1008-17 | 07F | AM | 10082018 | 17 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | scratching self | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.972967003211 40.7711848438157) | ||||
| 2862 | 2862 | -73.967466716152 | 40.782434654827796 | 21D-PM-1008-04 | 21D | PM | 10082018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | i scared it | POINT (-73.967466716152 40.7824346548278) | |||
| 2886 | 2886 | -73.9729265300533 | 40.774176829164205 | 10D-AM-1008-02 | 10D | AM | 10082018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9729265300533 40.7741768291642) | ||||
| 2925 | 2925 | -73.96721526968341 | 40.782387458182896 | 21D-AM-1008-05 | 21D | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9672152696834 40.7823874581829) |
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 );