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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 332 | 332 | -73.9705123624953 | 40.7731723757869 | 10F-PM-1019-11 | 10F | PM | 10192018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Grassy area | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9705123624953 40.7731723757869) | |||
| 1229 | 1229 | -73.9677751507448 | 40.779099006665795 | 17E-AM-1017-11 | 17E | AM | 10172018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | Shore | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677751507448 40.7790990066658) | ||||
| 2751 | 2751 | -73.956289117157 | 40.795339399380296 | 38E-AM-1010-11 | 38E | AM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of the stream | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.956289117157 40.7953393993803) | |||
| 596 | 596 | -73.9769319450348 | 40.7743883576247 | 9A-AM-1013-11 | 09A | AM | 10132018 | 11 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | foot of tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9769319450348 40.7743883576247) | |||
| 126 | 126 | -73.97921554736891 | 40.7693711799946 | 3B-PM-1007-11 | 03B | PM | 10072018 | 11 | Adult | Gray | Gray+ | Above Ground | 5 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9792155473689 40.7693711799946) | ||||
| 2868 | 2868 | -73.9653873284496 | 40.7804699882574 | 20F-PM-1007-11 | 20F | PM | 10072018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 10 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9653873284496 40.7804699882574) | |||
| 150 | 150 | -73.97634308293419 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 10082018 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | on tree facing downward | 0 | 1 | 0 | 0 | 0 | chased #12 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9763430829342 40.7686351097159) | ||
| 683 | 683 | -73.97076836215841 | 40.775981556612294 | 13E-AM-1017-11 | 13E | AM | 10172018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on/in log | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9707683621584 40.77598155661231) | ||||
| 1016 | 1016 | -73.9691293546408 | 40.7703219076549 | 8I-AM-1006-11 | 08I | AM | 10062018 | 11 | Adult | Gray | Gray+ | Above Ground | 50 | tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691293546408 40.77032190765491) |
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 );