This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
359 | 359 | -73.9716404781264 | 40.7753181851766 | 12D-PM-1014-02 | 12D | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | seems to be grinding teeth on a piece of material (sounds from grinding) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9716404781264 40.7753181851766) | |||
378 | 378 | -73.95848354168459 | 40.7978213396921 | 39B-PM-1014-06 | 39B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584835416846 40.7978213396921) | ||||
415 | 415 | -73.95701318903791 | 40.799178673612396 | 41B-PM-1014-05 | 41B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9570131890379 40.7991786736124) | |||||
428 | 428 | -73.96362827608 | 40.780799459524204 | 21G-AM-1014-02 | 21G | AM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 3 | fence | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96362827608 40.7807994595242) | |||
498 | 498 | -73.9669432929573 | 40.779136518298 | 18F-AM-1014-01 | 18F | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | Low tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9669432929573 40.779136518298) | ||||
518 | 518 | -73.96878474106559 | 40.778185700305 | 16E-AM-1014-09 | 16E | AM | 10142018 | 9 | Adult | Gray | Gray+ | Above Ground | 25 | In tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9687847410656 40.778185700305) | ||||
608 | 608 | -73.95896759955171 | 40.791311922358396 | 33E-AM-1014-09 | 33E | AM | 10142018 | 9 | Juvenile | Black | Black+ | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589675995517 40.7913119223584) | |||||
656 | 656 | -73.9553726714504 | 40.798757854112296 | 41D-AM-1014-02 | 41D | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | jumping | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9553726714504 40.7987578541123) | ||||
835 | 835 | -73.97079005665191 | 40.777167055008896 | 14D-AM-1014-09 | 14D | AM | 10142018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707900566519 40.7771670550089) | ||||
1041 | 1041 | -73.9643236505425 | 40.7887854771596 | 28C-AM-1014-02 | 28C | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9643236505425 40.7887854771596) | |||||
1104 | 1104 | -73.95898529894859 | 40.7912720015917 | 33E-AM-1014-07 | 33E | AM | 10142018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589852989486 40.7912720015917) | ||||
1397 | 1397 | -73.9655233748105 | 40.7792737287734 | 18G-AM-1014-01 | 18G | AM | 10142018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | looking | POINT (-73.9655233748105 40.7792737287734) | |||
1433 | 1433 | -73.9574077497624 | 40.80011851848921 | 42B-AM-1014-01 | 42B | AM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9574077497624 40.8001185184892) | |||||
1527 | 1527 | -73.970216605149 | 40.7702960667277 | 8H-PM-1014-08 | 08H | PM | 10142018 | 8 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | chasing (#7),playing? | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970216605149 40.7702960667277) | ||||
1537 | 1537 | -73.97672201797249 | 40.77532621031229 | 10A-PM-1014-03 | 10A | PM | 10142018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | above my head in tree | 0 | 0 | 0 | 1 | 0 | eating (in a tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent (lots of people taking its picture,didn't bother it) | POINT (-73.9767220179725 40.7753262103123) | ||
1630 | 1630 | -73.9710025484537 | 40.7792529489016 | 16C-AM-1014-01 | 16C | AM | 10142018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 40 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710025484537 40.7792529489016) | |||||
1665 | 1665 | -73.95839443533521 | 40.7979689846815 | 39B-PM-1014-04 | 39B | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | runs from (me—when i approached) | POINT (-73.9583944353352 40.7979689846815) | ||||
1817 | 1817 | -73.9703076450783 | 40.770158422628995 | 8H-PM-1014-07 | 08H | PM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | chasing (#8),playing? | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703076450783 40.770158422629) | ||||
1924 | 1924 | -73.95423325052309 | 40.793347517143395 | 37G-AM-1014-01 | 37G | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | White tail | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9542332505231 40.7933475171434) | |||
2052 | 2052 | -73.97464934414141 | 40.7750478734868 | 11B-PM-1014-06 | 11B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 0 | 0 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9746493441414 40.7750478734868) | |||
2054 | 2054 | -73.97263812347471 | 40.7752694815985 | 12D-PM-1014-01 | 12D | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9726381234747 40.7752694815985) | ||||
2056 | 2056 | -73.9589600626433 | 40.7913690265064 | 33E-AM-1014-08 | 33E | AM | 10142018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589600626433 40.7913690265064) | ||||
2128 | 2128 | -73.9757673193743 | 40.7669614322613 | 2F-PM-1014-04 | 02F | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757673193743 40.766961432261304) | |||||
2195 | 2195 | -73.955352152771 | 40.7988549523022 | 42D-AM-1014-01 | 42D | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.955352152771 40.7988549523022) | ||||
2303 | 2303 | -73.9589470461357 | 40.7912817646361 | 33E-AM-1014-10 | 33E | AM | 10142018 | 10 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589470461357 40.7912817646361) | ||||
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) | |||
2613 | 2613 | -73.96393252683 | 40.7808289765857 | 21G-AM-1014-04 | 21G | AM | 10142018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 6 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96393252683 40.7808289765857) | ||||
2632 | 2632 | -73.95082755733499 | 40.797579073666 | 42H-PM-1014-02 | 42H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | Running along stone ledge | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.950827557335 40.797579073666) | ||||
2653 | 2653 | -73.958932543729 | 40.7913445531266 | 33E-AM-1014-11 | 33E | AM | 10142018 | 11 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958932543729 40.7913445531266) | ||||
2654 | 2654 | -73.9549261242548 | 40.7944701994615 | 37G-AM-1014-04 | 37G | AM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9549261242548 40.7944701994615) | ||||
2763 | 2763 | -73.96260656728941 | 40.788722645116 | 29D-AM-1014-03 | 29D | AM | 10142018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 35 | End of tree limb foraging | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9626065672894 40.788722645116) | ||||
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) | |||||
2916 | 2916 | -73.95175251116791 | 40.7974407641075 | 42G-PM-1014-02 | 42G | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 14 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9517525111679 40.7974407641075) | ||||
2945 | 2945 | -73.9649103330443 | 40.7823913860445 | 22F-PM-1014-08 | 22F | PM | 10142018 | 8 | Adult | Gray | Gray+ | Above Ground | 10 | CLIMBED THE TREE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9649103330443 40.7823913860445) | ||||
3013 | 3013 | -73.964661337306 | 40.7769785494935 | 17I-AM-1014-03 | 17I | AM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon face | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | climbing (dog barked & it ran up tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.964661337306 40.7769785494935) |
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 );