This data as json, CSV (advanced)
Suggested facets: Shift, Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Eating, Foraging, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 284 | 284 | -73.9547336666137 | 40.7938937756332 | 37G-PM-1007-07 | 37G | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9547336666137 40.7938937756332) | ||||
| 348 | 348 | -73.9542990150586 | 40.794091530067796 | 37G-PM-1007-09 | 37G | PM | 10072018 | 9 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9542990150586 40.7940915300678) | ||||||
| 591 | 591 | -73.95433237868879 | 40.7943086530436 | 37G-PM-1007-03 | 37G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | lying on belly on branch,eating big nut | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9543323786888 40.7943086530436) | |||
| 604 | 604 | -73.9540908513075 | 40.794201225045 | 37G-PM-1007-04 | 37G | PM | 10072018 | 4 | Cinnamon | Gray | Cinnamon+Gray | gray tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9540908513075 40.794201225045) | ||||
| 898 | 898 | -73.95428280532559 | 40.794179732035495 | 37G-AM-1014-03 | 37G | AM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9542828053256 40.7941797320355) | |||||
| 1115 | 1115 | -73.9545214613307 | 40.7943801121036 | 37G-PM-1007-01 | 37G | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9545214613307 40.7943801121036) | ||||
| 1927 | 1927 | -73.95443722977221 | 40.7942113164104 | 37G-PM-1007-02 | 37G | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | ran under dumpster w/ nut | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9544372297722 40.7942113164104) | ||||
| 2173 | 2173 | -73.95461232594408 | 40.7941434862099 | 37G-PM-1007-05 | 37G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | jumping around! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9546123259441 40.7941434862099) | |||
| 2257 | 2257 | -73.95431338448 | 40.7940537582585 | 37G-PM-1007-08 | 37G | PM | 10072018 | 8 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95431338448 40.7940537582585) | |||||||
| 2795 | 2795 | -73.9541056052047 | 40.793986392323106 | 37G-PM-1007-06 | 37G | PM | 10072018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9541056052047 40.7939863923231) | |||||
| 2881 | 2881 | -73.9541629063295 | 40.7934259301577 | 37G-AM-1014-02 | 37G | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | ran away & disappeared | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9541629063295 40.7934259301577) |
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 );