This data as json, CSV (advanced)
Date ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2546 | 2546 | -73.9660267365885 | 40.776444395505 | 16H-AM-1007-01 | 16H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9660267365885 40.776444395505) | |||||
2570 | 2570 | -73.9721064150173 | 40.7667053821991 | 3I-AM-1010-01 | 03I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721064150173 40.7667053821991) | |||||
2609 | 2609 | -73.95968653180941 | 40.7893787188526 | 31F-AM-1013-01 | 31F | AM | 10132018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 25 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9596865318094 40.7893787188526) | ||||
2621 | 2621 | -73.9596904740342 | 40.7897200025671 | 31E-AM-1014-01 | 31E | AM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9596904740342 40.7897200025671) | |||||
2627 | 2627 | -73.97663480786329 | 40.7717715634438 | 7C-AM-1012-01 | 07C | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | hopping around grass | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766348078633 40.7717715634438) | |||
2629 | 2629 | -73.9604576237503 | 40.7818120101394 | 23I-PM-1019-01 | 23I | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | 1 | 0 | 0 | 0 | 0 | running (across branches) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9604576237503 40.7818120101394) | ||||
2647 | 2647 | -73.954499539822 | 40.7949716693686 | 38F-AM-1018-01 | 38F | AM | 10182018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.954499539822 40.7949716693686) | ||||
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) | ||||
2673 | 2673 | -73.9768867959365 | 40.7734803954589 | 8B-PM-1012-01 | 08B | PM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9768867959365 40.7734803954589) | ||||
2678 | 2678 | -73.95629468736941 | 40.7938593012595 | 36F-AM-1017-01 | 36F | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9562946873694 40.7938593012595) | ||||
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) | ||||
2691 | 2691 | -73.9564599077179 | 40.7965185098695 | 39D-PM-1012-01 | 39D | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9564599077179 40.7965185098695) | ||||
2743 | 2743 | -73.9587179613803 | 40.7992119571657 | 41A-PM-1007-01 | 41A | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9587179613803 40.7992119571657) | ||||
2758 | 2758 | -73.95420748142959 | 40.79543222400039 | 39F-AM-1014-01 | 39F | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9542074814296 40.7954322240004) | ||||
2768 | 2768 | -73.96410881726321 | 40.7886555184212 | 28C-AM-1014-01 | 28C | AM | 10142018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9641088172632 40.7886555184212) | |||||
2794 | 2794 | -73.9712187890707 | 40.7750640173134 | 12E-PM-1018-01 | 12E | PM | 10182018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9712187890707 40.7750640173134) | ||||
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) | |||||
2849 | 2849 | -73.9709912560997 | 40.77589655951979 | 13D-AM-1014-01 | 13D | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9709912560997 40.7758965595198) | ||||
2861 | 2861 | -73.9720102361126 | 40.7692143930301 | 6G-PM-1020-01 | 06G | PM | 10202018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9720102361126 40.7692143930301) | |||||
2900 | 2900 | -73.9631005470369 | 40.788549405719294 | 28D-AM-1012-01 | 28D | AM | 10122018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9631005470369 40.7885494057193) | ||||
2905 | 2905 | -73.9784872728213 | 40.768812260393204 | 3C-AM-1007-01 | 03C | AM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9784872728213 40.7688122603932) | ||||
2920 | 2920 | -73.9657391918196 | 40.776502470347 | 16H-PM-1014-01 | 16H | PM | 10142018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9657391918196 40.776502470347) | ||||
2998 | 2998 | -73.97520792474191 | 40.775537697900205 | 11B-AM-1007-01 | 11B | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9752079247419 40.7755376979002) | ||||
2522 | 2522 | -73.9658747245917 | 40.77540337375321 | 14I-PM-1018-01 | 14I | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9658747245917 40.7754033737532) | ||||
2423 | 2423 | -73.973552877209 | 40.7715638228207 | 7E-PM-1013-01 | 07E | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.973552877209 40.7715638228207) | |||
2755 | 2755 | -73.9712022111028 | 40.767250436826295 | 4I-AM-1006-01 | 04I | AM | 10062018 | 1 | Adult | Black | Black+ | Above Ground | 3 | On top of park lamp | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712022111028 40.7672504368263) | ||||
1739 | 1739 | -73.96397004344492 | 40.777500305002796 | 17I-AM-1014-01 | 17I | AM | 10142018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | Running across fence between statue & swings | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9639700434449 40.7775003050028) | |||
2313 | 2313 | -73.9646174034945 | 40.778128752826206 | 18H-AM-1018-01 | 18H | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Running from one tree to the other | 1 | 1 | 0 | 0 | 0 | playing? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9646174034945 40.7781287528262) | ||
1579 | 1579 | -73.97683095561271 | 40.7717803706095 | 6B-AM-1012-01 | 06B | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Started in field, crossed busy street, ran up tree | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97683095561271 40.7717803706095) | |||
1867 | 1867 | -73.9745204169071 | 40.7736282868469 | 9C-AM-1006-01 | 09C | AM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 40 | Tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9745204169071 40.7736282868469) | ||||
1612 | 1612 | -73.97460490884751 | 40.772877688739705 | 8C-AM-1007-01 | 08C | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | behind fence, safe | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9746049088475 40.7728776887397) | ||||
2652 | 2652 | -73.96205425147491 | 40.794373172213795 | 34A-AM-1012-01 | 34A | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | chasing from tree to ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9620542514749 40.7943731722138) | |||
951 | 951 | -73.97179185488301 | 40.78029717297839 | 17B-PM-1012-01 | 17B | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | climbed a fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.971791854883 40.7802971729784) | ||||
462 | 462 | -73.96617859405309 | 40.7742569936186 | 13I-PM-1008-01 | 13I | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | climbed tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9661785940531 40.7742569936186) | |||
1408 | 1408 | -73.973230162241 | 40.768982453144396 | 5F-AM-1007-01 | 05F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | fence | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.973230162241 40.7689824531444) | |||
641 | 641 | -73.97190362174459 | 40.7803588122409 | 17A-AM-1017-01 | 17A | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | ground & tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719036217446 40.7803588122409) | |||
2163 | 2163 | -73.9643664403785 | 40.77936707037271 | 19H-AM-1010-01 | 19H | AM | 10102018 | 1 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near base of small tree | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | run from human w/ dog | POINT (-73.9643664403785 40.7793670703727) | |||
528 | 528 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9647284206644 40.7839611840884) | ||||
749 | 749 | -73.96863045815259 | 40.7773631337117 | 15E-PM-1008-01 | 15E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 4 | on fallen tree | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686304581526 40.7773631337117) | ||||
426 | 426 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on railing | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9741944367138 40.7769889953596) | |||
520 | 520 | -73.97494466297059 | 40.77206596960671 | 7D-PM-1010-01 | 07D | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | outside fenced hectare | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9749446629706 40.7720659696067) | |||
2235 | 2235 | -73.9748522796455 | 40.771958662100296 | 7D-PM-1010-01 | 07D | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | outside fenced hectare | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9748522796455 40.7719586621003) | |||
930 | 930 | -73.96220300857941 | 40.7917723228749 | 32B-AM-1017-01 | 32B | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | ran up a tree | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9622030085794 40.7917723228749) | |||
623 | 623 | -73.9662939630722 | 40.7878502338031 | 26B-AM-1010-01 | 26B | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | running across bridle path | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9662939630722 40.7878502338031) | ||||
610 | 610 | -73.96715495660659 | 40.7751342870705 | 14H-AM-1007-01 | 14H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 180 | top of tree | 1 | 0 | 0 | 0 | 0 | jumping between branches | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9671549566066 40.7751342870705) | |||
2585 | 2585 | -73.9771726831497 | 40.7732320781799 | 8A-AM-1013-01 | 08A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | trail | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9771726831497 40.7732320781799) | |||
1118 | 1118 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719460335398 40.7810508156287) | ||
2070 | 2070 | -73.9725700261894 | 40.7668793330427 | 3H-PM-1014-01 | 03H | PM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a parked car | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9725700261894 40.7668793330427) | ||||
2583 | 2583 | -73.97696931406509 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 10062018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | up a tree | 1 | 0 | 1 | 1 | 1 | digging (?) | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) |
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 );