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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1977 | 1977 | -73.9586570546871 | 40.796349417475 | 38C-AM-1019-09 | 38C | AM | 10192018 | 9 | Adult | Gray | White | Gray+White | Gray & White selected as Primary & Highlights. Made executive adjustments. | Above Ground | 3 | Between ground & tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9586570546871 40.796349417475) | ||
1381 | 1381 | -73.9586077039567 | 40.796189647707706 | 38C-AM-1019-10 | 38C | AM | 10192018 | 10 | Adult | Gray | White | Gray+White | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9586077039567 40.7961896477077) | ||||
1410 | 1410 | -73.95879132892291 | 40.7961707624534 | 38C-AM-1019-11 | 38C | AM | 10192018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9587913289229 40.7961707624534) | ||||
1062 | 1062 | -73.957259673402 | 40.7974442913898 | 39C-AM-1017-02 | 39C | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957259673402 40.7974442913898) | ||||
304 | 304 | -73.9523001834395 | 40.7949231000186 | 39H-AM-1007-02 | 39H | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9523001834395 40.7949231000186) | ||||
2389 | 2389 | -73.9801343393329 | 40.769151245340204 | 3A-AM-1012-01 | 03A | AM | 10122018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801343393329 40.7691512453402) | |||
2776 | 2776 | -73.9789687905912 | 40.769269313932796 | 3B-PM-1007-04 | 03B | PM | 10072018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | At fence | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9789687905912 40.7692693139328) | |||
2202 | 2202 | -73.95560399976209 | 40.7977549157287 | 40D-AM-1013-05 | 40D | AM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9556039997621 40.7977549157287) | |||||
2508 | 2508 | -73.97938145045201 | 40.770903369788705 | 4A-PM-1007-01 | 04A | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.979381450452 40.770903369788705) | ||||
2221 | 2221 | -73.9771847728747 | 40.769597116498105 | 4C-AM-1006-01 | 04C | AM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771847728747 40.7695971164981) | ||||
756 | 756 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9773079154219 40.7696506688861) | ||||
1709 | 1709 | -73.9771696835698 | 40.76970111004871 | 4C-AM-1006-04 | 04C | AM | 10062018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771696835698 40.7697011100487) | ||||
522 | 522 | -73.97738211356109 | 40.769045349438294 | 4C-PM-1010-06 | 04C | PM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | behind playground benches | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9773821135611 40.7690453494383) | |||
1975 | 1975 | -73.9753291616796 | 40.7687376032936 | 4E-PM-1008-01 | 04E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9753291616796 40.7687376032936) | ||||
2030 | 2030 | -73.9749251267433 | 40.7679111971294 | 4F-PM-1013-01 | 04F | PM | 10132018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9749251267433 40.7679111971294) | ||||
2587 | 2587 | -73.97899712868441 | 40.7707024146365 | 5A-PM-1010-04 | 05A | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9789971286844 40.7707024146365) | ||||
2382 | 2382 | -73.97439704555329 | 40.7687880243986 | 5F-PM-1007-01 | 05F | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9743970455533 40.7687880243986) | ||||
2219 | 2219 | -73.9709242364673 | 40.7684217215595 | 5I-AM-1010-04 | 05I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9709242364673 40.7684217215595) | |||||
676 | 676 | -73.9710207438538 | 40.7682187144432 | 5I-AM-1010-05 | 05I | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9710207438538 40.7682187144432) | |||||
335 | 335 | -73.97823514358521 | 40.7715896672335 | 6A-AM-1006-03 | 06A | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | POINT (-73.9782351435852 40.7715896672335) | |||
816 | 816 | -73.9785300509908 | 40.772112774842704 | 6A-AM-1006-07 | 06A | AM | 10062018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9785300509908 40.7721127748427) | ||||
895 | 895 | -73.97868986562791 | 40.7720833097065 | 6A-AM-1006-08 | 06A | AM | 10062018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9786898656279 40.77208330970651) | ||||
1296 | 1296 | -73.97055091705421 | 40.7689416540228 | 6I-PM-1013-04 | 06I | PM | 10132018 | 4 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Grass | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9705509170542 40.7689416540228) | |||
868 | 868 | -73.9738481771673 | 40.7706540698938 | 7E-PM-1013-04 | 07E | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9738481771673 40.7706540698938) | ||||
595 | 595 | -73.9742804552383 | 40.7707167671865 | 7E-PM-1013-05 | 07E | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | On rocks | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9742804552383 40.7707167671865) | |||
1091 | 1091 | -73.97055600790999 | 40.7698499183436 | 7H-AM-1006-07 | 07H | AM | 10062018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97055600791 40.7698499183436) | ||||||
2610 | 2610 | -73.9713379914423 | 40.7696367609606 | 7H-PM-1006-01 | 07H | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | middle of grass | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9713379914423 40.7696367609606) | |||
697 | 697 | -73.97046560040201 | 40.770112577324795 | 7H-PM-1006-05 | 07H | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ran across path to eat behind fence, next to the fence. | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.970465600402 40.7701125773248) | |||
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) | ||
3015 | 3015 | -73.97591633005351 | 40.7736180793606 | 9B-AM-1010-08 | 09B | AM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon head, White (Almost Silver) | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9759163300535 40.7736180793606) | |||
2124 | 2124 | -73.97300395815209 | 40.7730688398468 | 9E-PM-1014-03 | 09E | PM | 10142018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | underneath a tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9730039581521 40.7730688398468) |
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 );