This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Climbing, Eating, Foraging, Kuks, Indifferent, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1142 | 1142 | -73.9765805609072 | 40.7692807820935 | 4D-PM-1008-07 | 04D | PM | 10082018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | hopped over fence and chased # 6 around tree & ran it to end of lawn | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765805609072 40.7692807820935) | |||
28 | 28 | -73.958736593111 | 40.790852437062604 | 32F-PM-1008-07 | 32F | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958736593111 40.7908524370626) | |||||
84 | 84 | -73.9701824825872 | 40.776653057929295 | 14E-AM-1008-09 | 14E | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9701824825872 40.7766530579293) | |||||
873 | 873 | -73.9770948563006 | 40.7724063459185 | 7B-AM-1008-04 | 07B | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770948563006 40.7724063459185) | |||||
978 | 978 | -73.9676692772518 | 40.7764726688908 | 15G-AM-1008-03 | 15G | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9676692772518 40.7764726688908) | |||||
1040 | 1040 | -73.9702588981432 | 40.776610754288 | 14E-AM-1008-08 | 14E | AM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9702588981432 40.776610754288) | |||||
1288 | 1288 | -73.97304542959971 | 40.77029094543921 | 7F-AM-1008-05 | 07F | AM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | bush | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9730454295997 40.7702909454392) | ||||
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) | |||||
1563 | 1563 | -73.96762706709958 | 40.776391443152 | 15G-AM-1008-04 | 15G | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9676270670996 40.776391443152) | |||||
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) | |||||
2118 | 2118 | -73.958369699409 | 40.79024566683321 | 32F-PM-1008-01 | 32F | PM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958369699409 40.7902456668332) | |||||
2485 | 2485 | -73.9584950620879 | 40.790277071064295 | 32F-PM-1008-03 | 32F | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584950620879 40.7902770710643) | ||||
732 | 732 | -73.9695041366722 | 40.779787880948206 | 17D-AM-1008-02 | 17D | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9695041366722 40.7797878809482) | ||||
879 | 879 | -73.9735120882106 | 40.7715915415169 | 8E-PM-1008-07 | 08E | PM | 10082018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9735120882106 40.7715915415169) | |||
957 | 957 | -73.9586527721822 | 40.790883111056104 | 32F-PM-1008-08 | 32F | PM | 10082018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9586527721822 40.7908831110561) | ||||
1644 | 1644 | -73.9734654671008 | 40.7715988711659 | 8E-PM-1008-06 | 08E | PM | 10082018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734654671008 40.7715988711659) | |||
2340 | 2340 | -73.9730284815849 | 40.7702462529502 | 7F-AM-1008-04 | 07F | AM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | bush | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9730284815849 40.7702462529502) |
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 );