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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2710 | 2710 | -73.9577919365342 | 40.796085328505896 | 38C-PM-1014-08 | 38C | PM | 10142018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9577919365342 40.7960853285059) | ||||
| 2714 | 2714 | -73.9600738985438 | 40.793832879875204 | 35C-PM-1013-08 | 35C | PM | 10132018 | 8 | + | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | did not *see* | POINT (-73.9600738985438 40.7938328798752) | ||||||||
| 2735 | 2735 | -73.97680969536471 | 40.7708185213129 | 5C-PM-1010-08 | 05C | PM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768096953647 40.7708185213129) | ||||
| 2826 | 2826 | -73.9600357018376 | 40.790653976688105 | 32E-AM-1007-08 | 32E | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 65 | tree top | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9600357018376 40.7906539766881) | ||||
| 2901 | 2901 | -73.9735833104203 | 40.7786318041581 | 14A-PM-1014-08 | 14A | PM | 10142018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | new movement flailing arms while foraging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9735833104203 40.7786318041581) | |||
| 2939 | 2939 | -73.9680204438195 | 40.774388232265395 | 13H-PM-1010-08 | 13H | PM | 10102018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9680204438195 40.77438823226541) | |||||
| 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) | ||||
| 2950 | 2950 | -73.9790980124501 | 40.7685934093915 | 2B-PM-1013-08 | 02B | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790980124501 40.7685934093915) | ||||
| 2996 | 2996 | -73.970033345821 | 40.777259393859 | 15E-PM-1008-08 | 15E | PM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970033345821 40.777259393859) |
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 );