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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2515 | 2515 | -73.9693338657183 | 40.775705588453796 | 13F-PM-1008-05 | 13F | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | tree trunk | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9693338657183 40.77570558845381) | |||
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) | ||||
2606 | 2606 | -73.96143417385001 | 40.794546426211205 | 35B-PM-1013-02 | 35B | PM | 10132018 | 2 | Juvenile | + | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | did not notice dog sitting a few yards away (10-20 ft) | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96143417385 40.7945464262112) | |||||
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) | |||
2641 | 2641 | -73.96155167034941 | 40.790521938835894 | 31D-AM-1014-04 | 31D | AM | 10142018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | Open ground | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9615516703494 40.7905219388359) | ||||
2655 | 2655 | -73.9659156108069 | 40.781070981869604 | 20E-AM-1014-01 | 20E | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9659156108069 40.7810709818696) | ||||
2683 | 2683 | -73.972179947936 | 40.7810042827198 | 17A-PM-1013-02 | 17A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | on a little pedestal-shaped part of a tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.972179947936 40.7810042827198) | |||
2723 | 2723 | -73.96064260275601 | 40.791726541984204 | 32D-PM-1006-08 | 32D | PM | 10062018 | 8 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | stand on two feet and watching me | POINT (-73.960642602756 40.7917265419842) | |||
2736 | 2736 | -73.95938952535009 | 40.797308584408704 | 38B-AM-1019-03 | 38B | AM | 10192018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9593895253501 40.7973085844087) | |||||
2739 | 2739 | -73.9681960138614 | 40.7726867422002 | 11H-AM-1010-02 | 11H | AM | 10102018 | 2 | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9681960138614 40.7726867422002) | |||||||
2766 | 2766 | -73.95516398474659 | 40.790858199891 | 34H-PM-1006-03 | 34H | PM | 10062018 | 3 | Gray | White | Gray+White | white belly | Ground Plane | FALSE | Under Tupelo Tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9551639847466 40.790858199891) | |||
2801 | 2801 | -73.9697665830132 | 40.7759094917104 | 13E-PM-1008-08 | 13E | PM | 10082018 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9697665830132 40.7759094917104) | ||||
2816 | 2816 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9809342290598 40.7687265606227) | |||
2878 | 2878 | -73.969720780557 | 40.774110568875706 | 12F-AM-1020-04 | 12F | AM | 10202018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.969720780557 40.7741105688757) | ||||
2947 | 2947 | -73.96012151981141 | 40.7909769801241 | 32D-PM-1006-02 | 32D | PM | 10062018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9601215198114 40.7909769801241) | ||||
3004 | 3004 | -73.9528482858163 | 40.7922056218325 | 36I-PM-1007-08 | 36I | PM | 10072018 | 8 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9528482858163 40.7922056218325) | ||||
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) | |||
339 | 339 | -73.965509576403 | 40.7752456763263 | 14I-PM-1018-05 | 14I | PM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96550957640301 40.7752456763263) | ||||
461 | 461 | -73.96481954331921 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | staring | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9648195433192 40.7796399955868) | ||||
923 | 923 | -73.9578924882613 | 40.789806297824 | 32G-AM-1010-02 | 32G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9578924882613 40.789806297824) | |||||
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) | ||||
1627 | 1627 | -73.9594391759139 | 40.784115697669 | 26I-PM-1010-03 | 26I | PM | 10102018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | black in tail | Above Ground | 15 | tree | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9594391759139 40.784115697669) | ||
1787 | 1787 | -73.9720365327715 | 40.7762329714016 | 13D-PM-1018-11 | 13D | PM | 10182018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9720365327715 40.7762329714016) | ||||
2009 | 2009 | -73.9639505810228 | 40.789573183584 | 29B-PM-1010-01 | 29B | PM | 10102018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 4 | climbing trees | 0 | 0 | 1 | 1 | 1 | scratching self | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9639505810228 40.789573183584) | ||
2495 | 2495 | -73.9621253644004 | 40.7912082086879 | 31C-AM-1017-01 | 31C | AM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9621253644004 40.7912082086879) | ||||
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) | ||||
2511 | 2511 | -73.95845615374209 | 40.791121116475395 | 33F-PM-1012-02 | 33F | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9584561537421 40.7911211164754) | ||||
2604 | 2604 | -73.9605163698302 | 40.7914179994956 | 32D-PM-1006-05 | 32D | PM | 10062018 | 5 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9605163698302 40.7914179994956) | ||||
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) | |||
2833 | 2833 | -73.9552595564798 | 40.7889533029466 | 32I-PM-1007-01 | 32I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | chirps | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9552595564798 40.7889533029466) |
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 );