This data as json, CSV (advanced)
Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Eating, Kuks, Quaas, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102 | 102 | -73.95759861613641 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Climbing tree | 0 | 0 | 1 | 0 | 0 | climbing (tree) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575986161364 40.799368134968) | ||
168 | 168 | -73.9745691353018 | 40.777103558929795 | 13A-PM-1014-03 | 13A | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | child chasing | POINT (-73.9745691353018 40.7771035589298) | |||
236 | 236 | -73.9737266070919 | 40.7786338379896 | 14A-PM-1014-01 | 14A | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9737266070919 40.7786338379896) | ||||
341 | 341 | -73.9703161745884 | 40.7702610461336 | 8H-PM-1014-05 | 08H | PM | 10142018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9703161745884 40.7702610461336) | |||||
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) | |||||
601 | 601 | -73.9522291603405 | 40.7976985385835 | 42G-PM-1014-01 | 42G | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 8 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9522291603405 40.7976985385835) | ||||
643 | 643 | -73.976730206737 | 40.773709213913996 | 8A-PM-1014-01 | 08A | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | |||
726 | 726 | -73.973305698325 | 40.778382331129606 | 14A-PM-1014-06 | 14A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.973305698325 40.7783823311296) | ||||
755 | 755 | -73.9579941847434 | 40.7991216713328 | 41B-PM-1014-02 | 41B | PM | 10142018 | 2 | Adult | Black | Black+ | Above Ground | 28 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9579941847434 40.7991216713328) | |||||
920 | 920 | -73.9571233640232 | 40.7992458980266 | 41B-PM-1014-04 | 41B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | climbing | POINT (-73.9571233640232 40.7992458980266) | |||
1022 | 1022 | -73.95488534927121 | 40.7984783584388 | 41D-PM-1014-04 | 41D | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | jumping tree to tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9548853492712 40.7984783584388) | |||
1206 | 1206 | -73.97487092063541 | 40.77608025411 | 11B-PM-1014-01 | 11B | PM | 10142018 | 1 | Adult | Gray | Gray+ | Fat! | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9748709206354 40.77608025411) | ||||
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) | ||||
1667 | 1667 | -73.96459890035891 | 40.778215745915496 | 18H-PM-1014-01 | 18H | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9645989003589 40.7782157459155) | ||||
1732 | 1732 | -73.97671414072741 | 40.7737313251559 | 8A-PM-1014-02 | 08A | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (goes up a tree) | POINT (-73.9767141407274 40.7737313251559) | ||||
1807 | 1807 | -73.9581366214863 | 40.7988964092722 | 40B-PM-1014-02 | 40B | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9581366214863 40.7988964092722) | |||||
1987 | 1987 | -73.9573692542155 | 40.7989252908321 | 41B-PM-1014-03 | 41B | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 28 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9573692542155 40.7989252908321) | ||||
2016 | 2016 | -73.9589492240754 | 40.798901118974 | 40A-PM-1014-01 | 40A | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | stared & then went back up tree—then ran to different tree | POINT (-73.9589492240754 40.798901118974) | |||
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) | ||||
2154 | 2154 | -73.976716425804 | 40.7736889979965 | 8A-PM-1014-03 | 08A | PM | 10142018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 23 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.976716425804 40.7736889979965) | |||||
2157 | 2157 | -73.9657171357842 | 40.7773277532224 | 16H-PM-1014-05 | 16H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 5 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9657171357842 40.7773277532224) | |||
2243 | 2243 | -73.9579967047318 | 40.7948682042252 | 37D-PM-1014-02 | 37D | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95799670473181 40.7948682042252) | |||||
2251 | 2251 | -73.9587678566254 | 40.7962656030995 | 38C-PM-1014-01 | 38C | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9587678566254 40.7962656030995) | ||||
2288 | 2288 | -73.9577009571427 | 40.796126044520996 | 38C-PM-1014-10 | 38C | PM | 10142018 | 10 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 1 | 1 | climbing (down from ~10') | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9577009571427 40.796126044521) | |||
2441 | 2441 | -73.9579865329778 | 40.794906535675004 | 37D-PM-1014-03 | 37D | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9579865329778 40.794906535675) | |||||
2443 | 2443 | -73.96670731869591 | 40.7840581361598 | 23C-PM-1014-01 | 23C | PM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.96670731869591 40.7840581361598) | |||||
2696 | 2696 | -73.9501457233643 | 40.797094356558 | 42I-PM-1014-01 | 42I | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9501457233643 40.797094356558) | ||||
2762 | 2762 | -73.9656324462902 | 40.783403475308106 | 22E-PM-1014-02 | 22E | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9656324462902 40.7834034753081) | |||||
2779 | 2779 | -73.9767835160078 | 40.767403033048204 | 2E-PM-1014-04 | 02E | PM | 10142018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9767835160078 40.7674030330482) | ||||
2804 | 2804 | -73.9576094432477 | 40.7965342664074 | 38C-PM-1014-07 | 38C | PM | 10142018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9576094432477 40.7965342664074) | ||||
2844 | 2844 | -73.9578840941242 | 40.7955586232429 | 37D-PM-1014-06 | 37D | PM | 10142018 | 6 | Adult | Gray | Gray+ | Above Ground | 25 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9578840941242 40.7955586232429) | |||||
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) |
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 );