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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 203 | 203 | -73.96387745795491 | 40.79135321291479 | 31A-AM-1010-05 | 31A | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | jumping | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | eventually ran from lawnmower (tail flag) | POINT (-73.9638774579549 40.7913532129148) | |||
| 159 | 159 | -73.9638270331336 | 40.7810450065235 | 21G-PM-1007-02 | 21G | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9638270331336 40.7810450065235) | |||||
| 727 | 727 | -73.9634563222926 | 40.780992836417 | 21G-PM-1007-04 | 21G | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9634563222926 40.780992836417) | |||||
| 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) | |||
| 2134 | 2134 | -73.9614373639552 | 40.7945051962914 | 35B-PM-1013-01 | 35B | PM | 10132018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | did not notice dog sitting a few yards away (10-20 ft) | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9614373639552 40.7945051962914) | |||
| 730 | 730 | -73.9607280801601 | 40.7901506706248 | 31D-PM-1006-01 | 31D | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9607280801601 40.7901506706248) | |||||
| 379 | 379 | -73.9606817053484 | 40.7917320450401 | 32D-PM-1006-07 | 32D | PM | 10062018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9606817053484 40.7917320450401) | ||||
| 1138 | 1138 | -73.9594357049738 | 40.7840678890949 | 25I-AM-1012-01 | 25I | AM | 10122018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | on bar | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | POINT (-73.9594357049738 40.7840678890949) | ||||
| 124 | 124 | -73.9588660250232 | 40.7982597947515 | 40A-AM-1010-03 | 40A | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | bottom of great hill | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | dog chased | POINT (-73.9588660250232 40.7982597947515) | ||
| 2618 | 2618 | -73.95795157569 | 40.7961254697958 | 38C-PM-1014-04 | 38C | PM | 10142018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.95795157569 40.7961254697958) | ||||
| 706 | 706 | -73.95701325709341 | 40.793201415908705 | 35F-PM-1012-01 | 35F | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | POINT (-73.9570132570934 40.7932014159087) | ||||
| 1514 | 1514 | -73.9548006161673 | 40.7945503341011 | 38G-PM-1020-08 | 38G | PM | 10202018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9548006161673 40.7945503341011) | ||||
| 74 | 74 | -73.95466541841459 | 40.7947639241491 | 38G-PM-1020-09 | 38G | PM | 10202018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9546654184146 40.7947639241491) | ||||
| 2348 | 2348 | -73.9531965469704 | 40.794743798397704 | 38G-PM-1020-11 | 38G | PM | 10202018 | 11 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | POINT (-73.9531965469704 40.7947437983977) |
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 );