This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
503 | 503 | -73.9598340783572 | 40.7915857030295 | 33D-PM-1006-02 | 33D | PM | 10062018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.95983407835722 40.7915857030295) | |||||
582 | 582 | -73.9677779408464 | 40.78674822113489 | 25A-AM-1013-02 | 25A | AM | 10132018 | 2 | Gray | Gray+ | Above Ground | 15 | BIG TREE | 0 | 1 | 0 | 0 | 0 | chasing #3 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9677779408464 40.7867482211349) | ||||
600 | 600 | -73.9808202088503 | 40.7682921842325 | 1A-PM-1014-02 | 01A | PM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9808202088503 40.7682921842325) | ||||
747 | 747 | -73.97714226252741 | 40.772361415776 | 7B-AM-1008-02 | 07B | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771422625274 40.772361415776) | |||||
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) | ||||
1163 | 1163 | -73.9677096985223 | 40.7825358361204 | 21C-AM-1014-02 | 21C | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 50 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | looked at us from tree | POINT (-73.9677096985223 40.7825358361204) | |||
1201 | 1201 | -73.97828135384209 | 40.7715730368712 | 6A-AM-1006-02 | 06A | AM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9782813538421 40.7715730368712) | |||
1220 | 1220 | -73.97799837948492 | 40.767545209917294 | 2D-AM-1007-02 | 02D | AM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | up tree | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9779983794849 40.7675452099173) | |||
1396 | 1396 | -73.9704677007779 | 40.7786860108302 | 16C-PM-1018-02 | 16C | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9704677007779 40.7786860108302) | ||||
1414 | 1414 | -73.9580513096783 | 40.79909641532 | 41B-AM-1010-02 | 41B | AM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 16 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9580513096783 40.79909641532) | ||||
1451 | 1451 | -73.9645365195454 | 40.778153102126296 | 18H-AM-1018-02 | 18H | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Tree | 1 | 1 | 0 | 0 | 0 | playing? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9645365195454 40.7781531021263) | |||
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) | |||
1613 | 1613 | -73.95992022335359 | 40.7972599930224 | 38A-AM-1019-02 | 38A | AM | 10192018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599202233536 40.7972599930224) | |||||
1649 | 1649 | -73.969347812694 | 40.7744098063421 | 12G-PM-1007-02 | 12G | PM | 10072018 | 2 | Gray | Gray+ | Above Ground | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969347812694 40.7744098063421) | ||||||
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) | |||
1916 | 1916 | -73.9693504617353 | 40.7830678709405 | 21B-PM-1017-02 | 21B | PM | 10172018 | 2 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | stood on hind legs with front legs on the chest | POINT (-73.9693504617353 40.7830678709405) | |||
1955 | 1955 | -73.9606559309874 | 40.7889527629826 | 30E-AM-1008-02 | 30E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9606559309874 40.7889527629826) | |||||
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) | |||
1989 | 1989 | -73.96316467546471 | 40.7925716810884 | 32A-AM-1018-02 | 32A | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631646754647 40.7925716810884) | |||||
2029 | 2029 | -73.9687213827744 | 40.7843586374648 | 22B-PM-1014-02 | 22B | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687213827744 40.7843586374648) | ||||
2298 | 2298 | -73.97553718499721 | 40.7733561233828 | 9C-PM-1006-02 | 09C | PM | 10062018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755371849972 40.7733561233828) | ||||
2487 | 2487 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31 | on tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9595222999173 40.7833202577782) | |||
2663 | 2663 | -73.96134291849741 | 40.79121580572671 | 32C-AM-1014-02 | 32C | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9613429184974 40.7912158057267) | |||||
2699 | 2699 | -73.9743509423821 | 40.7690043677328 | 5F-AM-1007-02 | 05F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.97435094238212 40.7690043677328) | ||||
2908 | 2908 | -73.96542881512659 | 40.7815953970174 | 21E-AM-1017-02 | 21E | AM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9654288151266 40.7815953970174) | |||||
565 | 565 | -73.9615402629655 | 40.7924082330328 | 33C-AM-1012-02 | 33C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along back & tail | Above Ground | 20 | tree branches | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615402629655 40.7924082330328) |
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 );