This data as json, CSV (advanced)
Highlight Fur Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2292 | 2292 | -73.96698919404629 | 40.7835635162331 | 22C-PM-1006-07 | 22C | PM | 10062018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9669891940463 40.7835635162331) | |||||
2297 | 2297 | -73.9787771053108 | 40.769356212275 | 3B-AM-1010-07 | 03B | AM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | together w/ #8 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9787771053108 40.76935621227501) | ||||
2707 | 2707 | -73.97431653210991 | 40.775467467857396 | 11B-PM-1014-07 | 11B | PM | 10142018 | 7 | Gray | Gray+ | Above Ground | 10 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9743165321099 40.7754674678574) | ||||||
191 | 191 | -73.9787105069657 | 40.7693708133873 | 3B-AM-1010-08 | 03B | AM | 10102018 | 8 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | together w/ #7 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9787105069657 40.7693708133873) | |||
430 | 430 | -73.9710116801402 | 40.7723689301989 | 10G-PM-1017-08 | 10G | PM | 10172018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9710116801402 40.7723689301989) | ||||
1060 | 1060 | -73.97288710611909 | 40.771298365894395 | 8F-PM-1012-08 | 08F | PM | 10122018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9728871061191 40.7712983658944) | ||||
1125 | 1125 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | on stone arch | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9775735077285 40.7692872082165) | |||
1378 | 1378 | -73.9669762657479 | 40.7835913293646 | 22C-PM-1006-08 | 22C | PM | 10062018 | 8 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9669762657479 40.7835913293646) | |||||
1926 | 1926 | -73.9742811484852 | 40.775533619083 | 11B-PM-1014-08 | 11B | PM | 10142018 | 8 | Gray | Gray+ | Above Ground | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.97428114848522 40.775533619083) | ||||||
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) | ||||
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) | |||
281 | 281 | -73.9619411917909 | 40.7923536640283 | 33B-PM-1010-11 | 33B | PM | 10102018 | 11 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9619411917909 40.7923536640283) | |||||
2868 | 2868 | -73.9653873284496 | 40.7804699882574 | 20F-PM-1007-11 | 20F | PM | 10072018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 10 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9653873284496 40.7804699882574) | |||
1575 | 1575 | -73.9703169373939 | 40.770065882385396 | 7H-AM-1006-13 | 07H | AM | 10062018 | 13 | Adult | Gray | Gray+ | Above Ground | 10 | 1 | 0 | 0 | 0 | 0 | running (up tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703169373939 40.7700658823854) | ||||
2927 | 2927 | -73.96501200660741 | 40.7805932882407 | 20F-PM-1007-13 | 20F | PM | 10072018 | 13 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9650120066074 40.78059328824071) | ||||
1768 | 1768 | -73.97736964550309 | 40.7687241866704 | 3D-PM-1010-14 | 03D | PM | 10102018 | 14 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | crying out | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9773696455031 40.7687241866704) |
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 );