This data as json, CSV (advanced)
Combination of Primary and Highlight Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2185 | 2185 | -73.9707571364399 | 40.7758859812524 | 13E-PM-1008-02 | 13E | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9707571364399 40.7758859812524) | ||||
2213 | 2213 | -73.9707487237344 | 40.7800822831001 | 17B-PM-1012-03 | 17B | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | 1 | 1 | 0 | 0 | 0 | 2/3 chasing each other | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9707487237344 40.7800822831001) | |||
2224 | 2224 | -73.9662310606968 | 40.7747758221226 | 14I-AM-1013-01 | 14I | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662310606968 40.7747758221226) | ||||
2226 | 2226 | -73.9624296435843 | 40.791320813687 | 31C-PM-1010-02 | 31C | PM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9624296435843 40.791320813687) | ||||
2232 | 2232 | -73.9566277721581 | 40.7966674587803 | 39D-PM-1012-04 | 39D | PM | 10122018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | on tree trunk (descending from height of ~10 ft) | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95662777215811 40.7966674587803) | |||
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) | ||||
2408 | 2408 | -73.9596949258862 | 40.79000794792171 | 31E-PM-1006-04 | 31E | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9596949258862 40.7900079479217) | |||||
2421 | 2421 | -73.96822789059891 | 40.773302750805705 | 11H-PM-1013-02 | 11H | PM | 10132018 | 2 | Adult | Gray | Black | Gray+Black | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9682278905989 40.7733027508057) | |||
2481 | 2481 | -73.9719068478565 | 40.7789062312585 | 15B-AM-1014-02 | 15B | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | grooming,scratching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9719068478565 40.7789062312585) | |||
2497 | 2497 | -73.9622050752008 | 40.7886373772305 | 29D-PM-1010-01 | 29D | PM | 10102018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622050752008 40.7886373772305) | ||||
2652 | 2652 | -73.96205425147491 | 40.794373172213795 | 34A-AM-1012-01 | 34A | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | chasing from tree to ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9620542514749 40.7943731722138) | |||
2722 | 2722 | -73.96922711321359 | 40.777528508844 | 15E-PM-1008-04 | 15E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9692271132136 40.777528508844) | |||||
2896 | 2896 | -73.970595860252 | 40.7832060751268 | 20A-AM-1010-01 | 20A | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.970595860252 40.7832060751268) | ||||
2911 | 2911 | -73.9793923984874 | 40.770847547458295 | 5A-AM-1006-01 | 05A | AM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 10 | Oak tree near rock outcropping | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97939239848742 40.7708475474583) | ||||
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) | ||||
3013 | 3013 | -73.964661337306 | 40.7769785494935 | 17I-AM-1014-03 | 17I | AM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon face | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | climbing (dog barked & it ran up tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.964661337306 40.7769785494935) |
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 );