This data as json, CSV (advanced)
Suggested facets: Shift, Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Quaas, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
199 | 199 | -73.97716146866159 | 40.770967798324705 | 5C-AM-1006-02 | 05C | AM | 10062018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771614686616 40.7709677983247) | ||||
593 | 593 | -73.95933528061751 | 40.7918150568046 | 33E-AM-1014-02 | 33E | AM | 10142018 | 2 | Juvenile | Black | Black+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9593352806175 40.7918150568046) | |||||
858 | 858 | -73.96293834202741 | 40.7889383725489 | 29C-AM-1007-02 | 29C | AM | 10072018 | 2 | Adult | Black | Gray | Black+Gray | Above Ground | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9629383420274 40.7889383725489) | ||||
896 | 896 | -73.9755055978764 | 40.77074386817421 | 6D-AM-1008-02 | 06D | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9755055978764 40.7707438681742) | |||||
1103 | 1103 | -73.9541500874008 | 40.7920329989756 | 35H-AM-1013-02 | 35H | AM | 10132018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Sitting on tree limb | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | watching me from tree,but calm | POINT (-73.9541500874008 40.7920329989756) | |
1576 | 1576 | -73.96199851876159 | 40.79432777435321 | 34A-AM-1012-02 | 34A | AM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | chasing from tree to ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9619985187616 40.7943277743532) | |||
1938 | 1938 | -73.9719879697272 | 40.7725625124591 | 9F-AM-1013-02 | 09F | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9719879697272 40.7725625124591) | |||||
2481 | 2481 | -73.9719068478565 | 40.7789062312585 | 15B-AM-1014-02 | 15B | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | grooming,scratching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9719068478565 40.7789062312585) | |||
505 | 505 | -73.9677387336667 | 40.774269591199996 | 12H-PM-1007-02 | 12H | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | in tree | 0 | 0 | 1 | 1 | 0 | peanuts | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677387336667 40.7742695912) | ||
890 | 890 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | oak tree | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9667755678511 40.7760256836088) | ||||
1168 | 1168 | -73.9779874405715 | 40.7730765377366 | 7A-PM-1007-02 | 07A | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9779874405715 40.7730765377366) | ||||
1263 | 1263 | -73.9770873939997 | 40.771037966210606 | 6C-PM-1020-02 | 06C | PM | 10202018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9770873939997 40.7710379662106) | |||||
1673 | 1673 | -73.9746940851342 | 40.7760966488186 | 11B-PM-1014-02 | 11B | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9746940851342 40.7760966488186) | |||||
1698 | 1698 | -73.9631392113757 | 40.791463563578404 | 31B-PM-1007-02 | 31B | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 1 | 1 | 0 | 0 | chasing #1 and climbing tree w/ #1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9631392113757 40.7914635635784) | |||
1741 | 1741 | -73.9736995552241 | 40.77227125186371 | 8E-PM-1008-02 | 08E | PM | 10082018 | 2 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 10 | in tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9736995552241 40.7722712518637) | |||
1960 | 1960 | -73.97301589136609 | 40.7701310707272 | 6F-PM-1008-02 | 06F | PM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 1 | 1 | 0 | 0 | 0 | chasing #2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9730158913661 40.7701310707272) | |||
1970 | 1970 | -73.96314646937691 | 40.793415656751 | 33A-PM-1018-02 | 33A | PM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | Tree cavity [of] London Plane tree | 0 | 0 | 0 | 0 | 0 | hanging out,watching world | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | watching | POINT (-73.9631464693769 40.793415656751) | |
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) | ||||
2194 | 2194 | -73.960898739757 | 40.7961393097144 | 37A-PM-1013-02 | 37A | PM | 10132018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.960898739757 40.7961393097144) | ||||
2226 | 2226 | -73.9624296435843 | 40.791320813687 | 31C-PM-1010-02 | 31C | PM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9624296435843 40.791320813687) | ||||
2231 | 2231 | -73.95454276114769 | 40.793035381744104 | 36G-PM-1012-02 | 36G | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9545427611477 40.7930353817441) | ||||
2421 | 2421 | -73.96822789059891 | 40.773302750805705 | 11H-PM-1013-02 | 11H | PM | 10132018 | 2 | Adult | Gray | Black | Gray+Black | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9682278905989 40.7733027508057) | |||
2893 | 2893 | -73.97931014826541 | 40.7692600238491 | 3B-PM-1007-02 | 03B | PM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | in tree | 0 | 0 | 0 | 0 | 0 | chased by dog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9793101482654 40.7692600238491) |
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 );