This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 447 | 447 | -73.97259060164741 | 40.7713889729739 | 8F-PM-1012-05 | 08F | PM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9725906016474 40.7713889729739) | ||||
| 590 | 590 | -73.97851333014259 | 40.77182602883379 | 6A-PM-1012-05 | 06A | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785133301426 40.7718260288338) | ||||
| 1292 | 1292 | -73.959019987128 | 40.791254669180496 | 33E-PM-1012-05 | 33E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.959019987128 40.7912546691805) | |||
| 1428 | 1428 | -73.9666113598566 | 40.775266255031205 | 14H-PM-1012-05 | 14H | PM | 10122018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (someone was feeding it) | POINT (-73.9666113598566 40.7752662550312) | ||||
| 1456 | 1456 | -73.97142424264959 | 40.774453579812295 | 11E-PM-1012-05 | 11E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | foraging (foraged,ran to tree root,munched) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714242426496 40.7744535798123) | |||
| 1947 | 1947 | -73.97471754195459 | 40.769282003087795 | 5E-PM-1012-05 | 05E | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | begging | POINT (-73.9747175419546 40.7692820030878) | |||
| 2106 | 2106 | -73.9801651470389 | 40.767769865693495 | 1B-AM-1012-05 | 01B | AM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801651470389 40.7677698656935) | ||||
| 2155 | 2155 | -73.9538938706987 | 40.7981150065974 | 42E-PM-1012-05 | 42E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538938706987 40.7981150065974) | ||||
| 2176 | 2176 | -73.9583201789615 | 40.7913938722521 | 33F-PM-1012-05 | 33F | PM | 10122018 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | POINT (-73.95832017896151 40.7913938722521) | ||||
| 2306 | 2306 | -73.956453902485 | 40.7936584431012 | 36F-PM-1012-05 | 36F | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.956453902485 40.7936584431012) | ||||
| 2317 | 2317 | -73.97673696861709 | 40.7735074437085 | 8B-PM-1012-05 | 08B | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767369686171 40.7735074437085) | ||||
| 2733 | 2733 | -73.9690082314914 | 40.7738993942891 | 12G-AM-1012-05 | 12G | AM | 10122018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9690082314914 40.7738993942891) |
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 );