This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Quaas, Approaches
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25 | 25 | -73.96711306801141 | 40.7784859700171 | 17F-AM-1007-07 | 17F | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 24 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9671130680114 40.7784859700171) | ||||
38 | 38 | -73.9742073452913 | 40.7757957380463 | 12B-AM-1007-01 | 12B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9742073452913 40.7757957380463) | ||||
94 | 94 | -73.9641971813967 | 40.781353795943495 | 21G-PM-1007-01 | 21G | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9641971813967 40.7813537959435) | ||||
234 | 234 | -73.9741401377844 | 40.7758134257881 | 12B-AM-1007-02 | 12B | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9741401377844 40.7758134257881) | ||||
294 | 294 | -73.9756573579063 | 40.7656644063024 | 1G-PM-1010-01 | 01G | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | too busy eating in his tree | POINT (-73.9756573579063 40.7656644063024) | |||
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) | ||||
569 | 569 | -73.9709040623777 | 40.7701163892686 | 7H-PM-1006-03 | 07H | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9709040623777 40.7701163892686) | ||||
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) | ||||
928 | 928 | -73.96704295859901 | 40.778437071937105 | 17F-AM-1007-05 | 17F | AM | 10072018 | 5 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.967042958599 40.7784370719371) | ||||
1007 | 1007 | -73.96353178229771 | 40.7821352080233 | 22G-AM-1018-01 | 22G | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9635317822977 40.7821352080233) | ||||
1367 | 1367 | -73.9542684235907 | 40.7944237164092 | 38G-PM-1020-05 | 38G | PM | 10202018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9542684235907 40.7944237164092) | ||||
1368 | 1368 | -73.95427708888809 | 40.794361036685295 | 38G-PM-1020-04 | 38G | PM | 10202018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9542770888881 40.79436103668531) | ||||
1403 | 1403 | -73.9761632586697 | 40.7741085606149 | 9B-PM-1013-05 | 09B | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9761632586697 40.7741085606149) | ||||
1481 | 1481 | -73.95388671863759 | 40.794140943400706 | 38G-PM-1020-03 | 38G | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9538867186376 40.7941409434007) | ||||
1509 | 1509 | -73.9556450015702 | 40.796718805800204 | 39E-AM-1018-04 | 39E | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9556450015702 40.7967188058002) | |||||
1531 | 1531 | -73.9630381400083 | 40.7807571827321 | 21H-PM-1018-02 | 21H | PM | 10182018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9630381400083 40.7807571827321) | ||||
1815 | 1815 | -73.96032682553171 | 40.7900154505092 | 31E-PM-1006-06 | 31E | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9603268255317 40.7900154505092) | ||||
1836 | 1836 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9751056714758 40.7732060035215) | ||||
1995 | 1995 | -73.9603366992925 | 40.7899612889539 | 31E-PM-1006-05 | 31E | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9603366992925 40.789961288953904) | ||||
2026 | 2026 | -73.9622752768962 | 40.7814921913101 | 22H-PM-1007-02 | 22H | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | low branch | 0 | 0 | 0 | 0 | 0 | watching me scratching | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9622752768962 40.7814921913101) | ||
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) | |||
2203 | 2203 | -73.97105314852979 | 40.7773757069445 | 14D-PM-1019-06 | 14D | PM | 10192018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.97105314852982 40.777375706944504) | |||||
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) | |||
2295 | 2295 | -73.9590632051055 | 40.79631465848271 | 38B-AM-1019-04 | 38B | AM | 10192018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | sitting in tree | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | observant | POINT (-73.9590632051055 40.7963146584827) | |||
2297 | 2297 | -73.9787771053108 | 40.769356212275 | 3B-AM-1010-07 | 03B | AM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | together w/ #8 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9787771053108 40.76935621227501) | ||||
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) | ||||
2440 | 2440 | -73.96738035086291 | 40.778524502550795 | 17F-AM-1007-01 | 17F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 18 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9673803508629 40.7785245025508) | |||||
2521 | 2521 | -73.976869549792 | 40.770698245472296 | 5C-AM-1006-04 | 05C | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 12 | thin branch of tree | 0 | 0 | 0 | 0 | 0 | relaxing | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.976869549792 40.7706982454723) | ||
2569 | 2569 | -73.9559663734409 | 40.794582826137706 | 37F-AM-1010-01 | 37F | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9559663734409 40.7945828261377) | ||||
2588 | 2588 | -73.95810074370941 | 40.795940311272204 | 38C-AM-1019-06 | 38C | AM | 10192018 | 6 | Adult | Gray | Gray+ | Above Ground | 23 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9581007437094 40.7959403112722) | |||||
2705 | 2705 | -73.9748962681637 | 40.76787782717 | 4F-PM-1013-02 | 04F | PM | 10132018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9748962681637 40.76787782717) | ||||
2790 | 2790 | -73.9673554935258 | 40.782752724959394 | 21C-AM-1014-04 | 21C | AM | 10142018 | 4 | Adult | + | High in tree, unable to tell | Above Ground | 60 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.96735549352582 40.7827527249594) | |||||
2923 | 2923 | -73.9672160533827 | 40.7830263908749 | 21C-AM-1014-05 | 21C | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9672160533827 40.7830263908749) | ||||
2980 | 2980 | -73.97164145863809 | 40.771760114722 | 9F-PM-1014-06 | 09F | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | running (from birds) | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9716414586381 40.771760114722) |
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 );