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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2815 | 2815 | -73.97473113123941 | 40.76773197250439 | 3F-PM-1013-06 | 03F | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 19 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97473113123941 40.7677319725044) | ||||
2844 | 2844 | -73.9578840941242 | 40.7955586232429 | 37D-PM-1014-06 | 37D | PM | 10142018 | 6 | Adult | Gray | Gray+ | Above Ground | 25 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9578840941242 40.7955586232429) | |||||
2845 | 2845 | -73.9765016413674 | 40.77406728629529 | 9A-AM-1013-06 | 09A | AM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765016413674 40.7740672862953) | ||||
2855 | 2855 | -73.9690832219322 | 40.782343340985996 | 20B-PM-1013-06 | 20B | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96908322193221 40.782343340986) | ||||
2892 | 2892 | -73.9688070760806 | 40.777968829417205 | 16E-AM-1014-06 | 16E | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9688070760806 40.777968829417205) | ||||
2894 | 2894 | -73.979734151564 | 40.7682150214703 | 2B-AM-1010-06 | 02B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.979734151564 40.7682150214703) | |||||
2935 | 2935 | -73.96045994773449 | 40.7915035010169 | 32D-PM-1006-06 | 32D | PM | 10062018 | 6 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9604599477345 40.7915035010169) | ||||
2974 | 2974 | -73.9575791421589 | 40.7959934459432 | 38D-AM-1017-06 | 38D | AM | 10172018 | 6 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575791421589 40.7959934459432) | ||||
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) | |||
3011 | 3011 | -73.96788313129359 | 40.7847605974975 | 23B-PM-1012-06 | 23B | PM | 10122018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | scolding | POINT (-73.9678831312936 40.7847605974975) | ||||
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) | ||
300 | 300 | -73.9528149779809 | 40.7924984810637 | 36I-AM-1017-06 | 36I | AM | 10172018 | 6 | Adult | Gray | Black | Gray+Black | Darker than others | Above Ground | 10 | Running down tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9528149779809 40.7924984810637) | ||
1554 | 1554 | -73.95974626120629 | 40.783280114530605 | 25I-PM-1007-06 | 25I | PM | 10072018 | 6 | + | Didn't see squirrel size, or colors | Above Ground | 20 | up in tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9597462612063 40.7832801145306) | |||||
2314 | 2314 | -73.9663961415789 | 40.7750691120996 | 14H-PM-1012-06 | 14H | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary with a note that it was "hard to tell". | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9663961415789 40.7750691120996) | |||
1556 | 1556 | -73.97462382801159 | 40.7671491962844 | 3F-AM-1006-06 | 03F | AM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9746238280116 40.7671491962844) | |||
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) | ||
2323 | 2323 | -73.9715921982161 | 40.7746153066601 | 11E-PM-1012-06 | 11E | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Above Ground | 5 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9715921982161 40.7746153066601) | |||
458 | 458 | -73.97357503529591 | 40.7694500333777 | 6F-PM-1008-06 | 06F | PM | 10082018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | White patches. Almost looks like fox squirrel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9735750352959 40.7694500333777) | |||||
1870 | 1870 | -73.9542118614769 | 40.7939171395463 | 37G-AM-1014-06 | 37G | AM | 10142018 | 6 | Adult | Gray | White | Gray+White | White tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95421186147692 40.7939171395463) | |||
2395 | 2395 | -73.9729603550254 | 40.7660215710657 | 3H-AM-1008-06 | 03H | AM | 10082018 | 6 | Adult | Black | Black+ | beauty! | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9729603550254 40.7660215710657) | ||||
2732 | 2732 | -73.9694185786221 | 40.7787189999566 | 16D-AM-1007-06 | 16D | AM | 10072018 | 6 | Adult | Cinnamon | White | Cinnamon+White | primary color: brown ( I marked cinnamon as closest to brown - JO) | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694185786221 40.7787189999566) | |||
1172 | 1172 | -73.9706929270645 | 40.77278411194239 | 10G-AM-1006-06 | 10G | AM | 10062018 | 6 | Juvenile | Gray | Gray+ | skinny tail | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#5) | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9706929270645 40.7727841119424) | |||
1769 | 1769 | -73.9721086069437 | 40.7698172190404 | 6G-AM-1008-06 | 06G | AM | 10082018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | white at end of tail | Ground Plane | FALSE | grass | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9721086069437 40.7698172190404) |
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 );