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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2358 | 2358 | -73.9788379085607 | 40.7683896583055 | 2C-PM-1013-06 | 02C | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | cleaning face & tail | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9788379085607 40.7683896583055) | |||
1530 | 1530 | -73.96893059787509 | 40.781815249626604 | 19C-PM-1018-06 | 19C | PM | 10182018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | Climbed fence | 1 | 0 | 1 | 0 | 0 | climbing (fence) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689305978751 40.7818152496266) | ||
1194 | 1194 | -73.96874625660729 | 40.783898987005 | 22B-PM-1014-06 | 22B | PM | 10142018 | 6 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687462566073 40.783898987005) | ||||
2075 | 2075 | -73.96362349533341 | 40.7775138547689 | 18I-PM-1007-06 | 18I | PM | 10072018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9636234953334 40.7775138547689) | |||
79 | 79 | -73.9610705592868 | 40.7914829661051 | 32D-AM-1013-06 | 32D | AM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | eating (a mushroom),circles around us,really fat,scratching himself,grooming activity | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9610705592868 40.7914829661051) | ||||
2765 | 2765 | -73.971525123573 | 40.770368535984204 | 7G-PM-1018-06 | 07G | PM | 10182018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | grooming | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.971525123573 40.7703685359842) | |||
2374 | 2374 | -73.9551370586201 | 40.7946465469021 | 38F-AM-1018-06 | 38F | AM | 10182018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hopped away | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.95513705862011 40.7946465469021) | |||
1948 | 1948 | -73.9738410069766 | 40.7691686156505 | 5F-PM-1007-06 | 05F | PM | 10072018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | jumping on fence | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9738410069766 40.7691686156505) | |||
2025 | 2025 | -73.97665418790059 | 40.7674077265375 | 2E-AM-1010-06 | 02E | AM | 10102018 | 6 | Adult | Cinnamon | Cinnamon+ | Above Ground | 35 | 0 | 0 | 0 | 0 | 0 | leaping branch to branch | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766541879006 40.7674077265375) | ||||
2637 | 2637 | -73.968891673893 | 40.776700147172896 | 15F-AM-1007-06 | 15F | AM | 10072018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | pair with #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.968891673893 40.7767001471729) | |||
1805 | 1805 | -73.9590328527128 | 40.791221441757706 | 33E-PM-1012-06 | 33E | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9590328527128 40.7912214417577) | |||
1535 | 1535 | -73.9703921271418 | 40.770027611531404 | 7H-PM-1006-06 | 07H | PM | 10062018 | 6 | Adult | Gray | Gray+ | Above Ground | 15 | 0 | 1 | 1 | 0 | 0 | playing w/ #7 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703921271418 40.770027611531404) | ||||
58 | 58 | -73.9704082821356 | 40.7690280985956 | 6I-PM-1013-06 | 06I | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing with #5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9704082821356 40.7690280985956) | |||
2274 | 2274 | -73.96980442184758 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | 0 | 0 | 0 | 1 | 0 | playing,interacting with #7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9698044218476 40.7697007833531) | ||
2980 | 2980 | -73.97164145863809 | 40.771760114722 | 9F-PM-1014-06 | 09F | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | running (from birds) | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9716414586381 40.771760114722) | |||
2640 | 2640 | -73.9788304714091 | 40.7696373635315 | 4B-AM-1010-06 | 04B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Above Ground | 12 | 1 | 0 | 0 | 0 | 0 | running from squirrel #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9788304714091 40.7696373635315) | ||||
2527 | 2527 | -73.9675697600155 | 40.776679741446294 | 15G-PM-1019-06 | 15G | PM | 10192018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | scratching! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675697600155 40.7766797414463) | |||
1770 | 1770 | -73.97281709807791 | 40.770355783043705 | 7F-AM-1008-06 | 07F | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 28 | in hole in tree | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728170980779 40.770355783043705) | |||
988 | 988 | -73.97870401924729 | 40.767901024728104 | 2C-AM-1010-06 | 02C | AM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | stood still & watched me then jumped on a fence and ran away | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9787040192473 40.7679010247281) | ||||
1555 | 1555 | -73.9784942525972 | 40.767260000368296 | 1D-AM-1006-06 | 01D | AM | 10062018 | 6 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | tumbling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9784942525972 40.7672600003683) | ||
563 | 563 | -73.97003307121192 | 40.778291392572704 | 16D-PM-1010-06 | 16D | PM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | checking me out | POINT (-73.9700330712119 40.7782913925727) | |||
2697 | 2697 | -73.9710674928906 | 40.7778757544025 | 15D-PM-1017-06 | 15D | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | stopped and watched me before slowly moving on | POINT (-73.9710674928906 40.7778757544025) | ||
594 | 594 | -73.9727488640736 | 40.7781916780621 | 14B-PM-1014-06 | 14B | PM | 10142018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | watching me | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | skittish | POINT (-73.9727488640736 40.7781916780621) |
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 );