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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2690 | 2690 | -73.9572840457971 | 40.788693337174394 | 31H-PM-1008-04 | 31H | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | Also way up | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95728404579711 40.7886933371744) | |||||
1450 | 1450 | -73.9580813119325 | 40.79055382370421 | 32F-PM-1008-04 | 32F | PM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9580813119325 40.7905538237042) | |||||
1432 | 1432 | -73.9632577850183 | 40.793112839016 | 33A-AM-1008-01 | 33A | AM | 10082018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | acknowledged | POINT (-73.9632577850183 40.793112839016) | |||
1101 | 1101 | -73.95912925497 | 40.7925530280455 | 34D-AM-1008-01 | 34D | AM | 10082018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | staring at us | POINT (-73.95912925497001 40.7925530280455) | ||||
665 | 665 | -73.95636612568751 | 40.796682311450795 | 39D-AM-1008-03 | 39D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9563661256875 40.7966823114508) | |||||
1162 | 1162 | -73.95685442708809 | 40.7972517274475 | 39D-AM-1008-06 | 39D | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 3 | on rock | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9568544270881 40.7972517274475) | ||||
1280 | 1280 | -73.9562469727195 | 40.79685907654 | 39D-AM-1008-04 | 39D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9562469727195 40.79685907654) | |||||
1319 | 1319 | -73.9562105506291 | 40.796699119790894 | 39D-AM-1008-02 | 39D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9562105506291 40.7966991197909) | |||||
1835 | 1835 | -73.9562068537632 | 40.796733285323796 | 39D-AM-1008-01 | 39D | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9562068537632 40.7967332853238) | |||||
1883 | 1883 | -73.9568108465086 | 40.7971727026108 | 39D-AM-1008-05 | 39D | AM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95681084650862 40.7971727026108) |
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 );