This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Tail flags, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43 | 43 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 10082018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9574648097543 40.78925084286221) | ||||
158 | 158 | -73.9710991123992 | 40.77238897266471 | 9F-PM-1014-02 | 09F | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710991123992 40.7723889726647) | ||||
169 | 169 | -73.97487064155841 | 40.7744174965072 | 10B-AM-1006-02 | 10B | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | High in a tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9748706415584 40.7744174965072) | ||||
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) | ||||
251 | 251 | -73.95708175790921 | 40.7964221087879 | 38D-AM-1017-02 | 38D | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hiding in log | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9570817579092 40.7964221087879) | |||
368 | 368 | -73.970315671921 | 40.77209053954721 | 10G-PM-1017-02 | 10G | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970315671921 40.7720905395472) | ||||
438 | 438 | -73.95257475169142 | 40.7977257435263 | 42F-PM-1017-02 | 42F | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95257475169142 40.7977257435263) | |||
450 | 450 | -73.96442931957729 | 40.7813829172072 | 21F-AM-1018-02 | 21F | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9644293195773 40.7813829172072) | ||||
484 | 484 | -73.9666526554772 | 40.7756111718355 | 14H-AM-1007-02 | 14H | AM | 10072018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9666526554772 40.77561117183551) | |||
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) | ||
553 | 553 | -73.9638526062093 | 40.782693848993 | 22F-AM-1007-02 | 22F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | standing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9638526062093 40.782693848993) | |||
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) | ||
657 | 657 | -73.9679008849677 | 40.7759013923034 | 14G-AM-1012-02 | 14G | AM | 10122018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9679008849677 40.7759013923034) | |||||
1062 | 1062 | -73.957259673402 | 40.7974442913898 | 39C-AM-1017-02 | 39C | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957259673402 40.7974442913898) | ||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9540257319561 40.798408619116) | ||||||
1444 | 1444 | -73.9763852372393 | 40.768876248561 | 4D-AM-1012-02 | 04D | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9763852372393 40.768876248561) | ||||
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) | ||||
1668 | 1668 | -73.97469348106671 | 40.7659431884158 | 2G-PM-1007-02 | 02G | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | burying nut | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9746934810667 40.7659431884158) | |||
1921 | 1921 | -73.97562782402329 | 40.766952370137204 | 2F-AM-1006-02 | 02F | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756278240233 40.7669523701372) | |||
1990 | 1990 | -73.9774584305147 | 40.770813398619204 | 5B-AM-1008-02 | 05B | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9774584305147 40.7708133986192) | ||||
2093 | 2093 | -73.9597994674082 | 40.797298837759 | 38A-PM-1013-02 | 38A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9597994674082 40.797298837759) | ||||
2320 | 2320 | -73.9576897478787 | 40.796469532845705 | 38C-AM-1019-02 | 38C | AM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9576897478787 40.7964695328457) | ||||
2368 | 2368 | -73.9731925179247 | 40.7748962746181 | 11D-PM-1006-02 | 11D | PM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9731925179247 40.7748962746181) | ||||
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) | |||
2543 | 2543 | -73.96914249979191 | 40.780542852496 | 18C-AM-1018-02 | 18C | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691424997919 40.780542852496) | ||||
2626 | 2626 | -73.9737329655838 | 40.7726424441344 | 8D-PM-1007-02 | 08D | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9737329655838 40.7726424441344) | ||||
2683 | 2683 | -73.972179947936 | 40.7810042827198 | 17A-PM-1013-02 | 17A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | on a little pedestal-shaped part of a tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.972179947936 40.7810042827198) | |||
2783 | 2783 | -73.97917671562679 | 40.7714445258765 | 5A-AM-1006-02 | 05A | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | in tall shrubs near wall next to CPW | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9791767156268 40.7714445258765) | |||
2979 | 2979 | -73.9571808775915 | 40.793444386672505 | 35E-AM-1020-02 | 35E | AM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | 0 | 0 | 0 | 0 | 0 | cleaning herself | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9571808775915 40.7934443866725) |
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 );