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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1981 | 1981 | -73.972154069981 | 40.769012800972206 | 6G-AM-1008-03 | 06G | AM | 10082018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | grass | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.972154069981 40.7690128009722) | |||
1982 | 1982 | -73.9729979174723 | 40.7742904356698 | 10D-PM-1008-01 | 10D | PM | 10082018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9729979174723 40.7742904356698) | ||||
2185 | 2185 | -73.9707571364399 | 40.7758859812524 | 13E-PM-1008-02 | 13E | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9707571364399 40.7758859812524) | ||||
2429 | 2429 | -73.97266996869429 | 40.770112379122295 | 7F-AM-1008-01 | 07F | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bench | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9726699686943 40.7701123791223) | |||
2489 | 2489 | -73.9663168490265 | 40.7825083721362 | 21D-AM-1008-01 | 21D | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9663168490265 40.7825083721362) | ||||
210 | 210 | -73.97112984911321 | 40.76769026035429 | 5I-PM-1008-01 | 05I | PM | 10082018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 15 | in tree by arsenal - climbing | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9711298491132 40.7676902603543) |
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 );