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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2602 | 2602 | -73.97548229388691 | 40.771776689383294 | 7C-PM-1020-01 | 07C | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9754822938869 40.7717766893833) | ||||
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) | ||||
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) | |||
2615 | 2615 | -73.97346051766459 | 40.7686218881386 | 5G-PM-1010-02 | 05G | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9734605176646 40.7686218881386) | ||||
2618 | 2618 | -73.95795157569 | 40.7961254697958 | 38C-PM-1014-04 | 38C | PM | 10142018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.95795157569 40.7961254697958) | ||||
2636 | 2636 | -73.9700264128414 | 40.7692014637698 | 7I-PM-1013-01 | 07I | PM | 10132018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | Bench | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9700264128414 40.7692014637698) | |||
2646 | 2646 | -73.9772239251936 | 40.7731716665766 | 8A-AM-1013-05 | 08A | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9772239251936 40.7731716665766) | ||||
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) | ||||
2659 | 2659 | -73.95536034380208 | 40.7985282963244 | 41D-PM-1014-05 | 41D | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 12 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9553603438021 40.7985282963244) | ||||
2671 | 2671 | -73.97433690682541 | 40.7675726965985 | 3F-AM-1006-11 | 03F | AM | 10062018 | 11 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9743369068254 40.7675726965985) | ||||
2682 | 2682 | -73.97110012783891 | 40.778746609584104 | 15C-PM-1017-01 | 15C | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9711001278389 40.7787466095841) | ||||
2701 | 2701 | -73.97912175106559 | 40.767658347539395 | 2C-AM-1010-05 | 02C | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | right at the base of the same tree as #3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9791217510656 40.7676583475394) | |||
2707 | 2707 | -73.97431653210991 | 40.775467467857396 | 11B-PM-1014-07 | 11B | PM | 10142018 | 7 | Gray | Gray+ | Above Ground | 10 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9743165321099 40.7754674678574) | ||||||
2711 | 2711 | -73.96288429601181 | 40.793804857240296 | 34A-PM-1013-01 | 34A | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | took a chestnut | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9628842960118 40.7938048572403) | |||
2716 | 2716 | -73.9618094076328 | 40.7944097368153 | 35A-PM-1013-03 | 35A | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9618094076328 40.7944097368153) | ||||
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) | |||
2730 | 2730 | -73.96535757586871 | 40.78053399533721 | 20F-PM-1007-12 | 20F | PM | 10072018 | 12 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9653575758687 40.7805339953372) | |||
2740 | 2740 | -73.96126586889142 | 40.7912119940469 | 32C-AM-1014-04 | 32C | AM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9612658688914 40.7912119940469) | |||||
2742 | 2742 | -73.96280415779341 | 40.7884180156055 | 28D-AM-1012-06 | 28D | AM | 10122018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9628041577934 40.78841801560551) | ||||
2750 | 2750 | -73.957775998085 | 40.7932880937406 | 35E-PM-1006-05 | 35E | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.957775998085 40.7932880937406) | |||||
2756 | 2756 | -73.9787312025627 | 40.7701071405918 | 4B-PM-1018-04 | 04B | PM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9787312025627 40.7701071405918) | |||||
2764 | 2764 | -73.9692660977515 | 40.7830532310766 | 21B-PM-1017-01 | 21B | PM | 10172018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | paused to look at me | POINT (-73.9692660977515 40.7830532310766) | |||
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) | |||
2769 | 2769 | -73.9769885189342 | 40.7708936173356 | 5C-PM-1010-06 | 05C | PM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9769885189342 40.7708936173356) | ||||
2774 | 2774 | -73.9705409446299 | 40.7764608087703 | 14E-PM-1017-03 | 14E | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9705409446299 40.7764608087703) | ||||
2825 | 2825 | -73.96435075880079 | 40.790432469329204 | 30B-PM-1019-07 | 30B | PM | 10192018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.96435075880082 40.7904324693292) | ||||
2835 | 2835 | -73.9531953594918 | 40.7960413520131 | 40G-PM-1013-01 | 40G | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9531953594918 40.7960413520131) | |||||
2852 | 2852 | -73.9728146482385 | 40.7652951714745 | 1I-PM-1012-03 | 01I | PM | 10122018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.97281464823851 40.765295171474506) | |||
2858 | 2858 | -73.9728723853967 | 40.7670816164986 | 4H-PM-1006-01 | 04H | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9728723853967 40.7670816164986) | ||||
2862 | 2862 | -73.967466716152 | 40.782434654827796 | 21D-PM-1008-04 | 21D | PM | 10082018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | i scared it | POINT (-73.967466716152 40.7824346548278) | |||
2867 | 2867 | -73.969370141813 | 40.7840721191988 | 22A-PM-1017-03 | 22A | PM | 10172018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969370141813 40.7840721191988) | ||||
2869 | 2869 | -73.9630822385425 | 40.7914844989865 | 31B-PM-1007-04 | 31B | PM | 10072018 | 4 | Juvenile | Gray | Gray+ | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9630822385425 40.7914844989865) | |||||||
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) | ||||
2879 | 2879 | -73.9744080700098 | 40.773151572182606 | 9C-PM-1006-07 | 09C | PM | 10062018 | 7 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | on top of tarped sand pile | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | (me) | POINT (-73.9744080700098 40.7731515721826) | ||
2912 | 2912 | -73.9632164738341 | 40.7921270121312 | 32B-PM-1010-03 | 32B | PM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9632164738341 40.7921270121312) | ||||
2925 | 2925 | -73.96721526968341 | 40.782387458182896 | 21D-AM-1008-05 | 21D | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9672152696834 40.7823874581829) | ||||
2926 | 2926 | -73.9714653576023 | 40.77174001395021 | 9F-AM-1013-03 | 09F | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9714653576023 40.7717400139502) | ||||
2931 | 2931 | -73.9730926233232 | 40.7781330751738 | 14B-PM-1014-08 | 14B | PM | 10142018 | 8 | Gray | Cinnamon, White | Gray+Cinnamon, White | White belly & stripes on tail, Cinnamon face & stripes on back | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9730926233232 40.7781330751738) | ||||
2936 | 2936 | -73.9809876538513 | 40.768322324214296 | 1A-PM-1014-05 | 01A | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9809876538513 40.7683223242143) | ||||
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) | ||||
2950 | 2950 | -73.9790980124501 | 40.7685934093915 | 2B-PM-1013-08 | 02B | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790980124501 40.7685934093915) | ||||
2951 | 2951 | -73.9742986032935 | 40.7770454318226 | 13A-PM-1014-04 | 13A | PM | 10142018 | 4 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9742986032935 40.7770454318226) | ||||||
2957 | 2957 | -73.97473131521521 | 40.7653888351839 | 1G-PM-1010-03 | 01G | PM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9747313152152 40.7653888351839) | ||||
2959 | 2959 | -73.9747963162162 | 40.7745023355775 | 10B-PM-1014-04 | 10B | PM | 10142018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | avoided people | POINT (-73.9747963162162 40.7745023355775) | |||
2976 | 2976 | -73.97240833205379 | 40.7744163768061 | 11D-AM-1010-08 | 11D | AM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | drinking | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9724083320538 40.7744163768061) | |||
2983 | 2983 | -73.9689586689061 | 40.7839613907139 | 21B-PM-1017-04 | 21B | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9689586689061 40.7839613907139) | ||||
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) | |||
3019 | 3019 | -73.9639431360458 | 40.7908677445466 | 30B-AM-1007-04 | 30B | AM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9639431360458 40.7908677445466) | |||||
3023 | 3023 | -73.97547941915529 | 40.7696404489025 | 5E-PM-1012-01 | 05E | PM | 10122018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9754794191553 40.7696404489025) |
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 );