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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2317 | 2317 | -73.97673696861709 | 40.7735074437085 | 8B-PM-1012-05 | 08B | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767369686171 40.7735074437085) | ||||
2483 | 2483 | -73.9596083366477 | 40.7949526729608 | 36C-PM-1013-05 | 36C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | "Warm brown" written in for Primary. | Ground Plane | FALSE | Ran across path in front of people | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9596083366477 40.7949526729608) | |||
2486 | 2486 | -73.9766317094163 | 40.7734230472026 | 8B-AM-1007-05 | 08B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9766317094163 40.7734230472026) | |||||
2506 | 2506 | -73.9719038949487 | 40.770353349248204 | 7G-AM-1010-05 | 07G | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9719038949487 40.7703533492482) | ||||
2531 | 2531 | -73.9599424115626 | 40.79574725853271 | 37B-AM-1018-05 | 37B | AM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599424115626 40.7957472585327) | ||||
2537 | 2537 | -73.9735533713513 | 40.7690605609001 | 5F-PM-1007-05 | 05F | PM | 10072018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9735533713513 40.7690605609001) | ||||
2581 | 2581 | -73.9635981227569 | 40.7928169540326 | 32A-AM-1018-05 | 32A | AM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9635981227569 40.7928169540326) | |||||
2582 | 2582 | -73.9665004148497 | 40.780565641175606 | 19E-PM-1018-05 | 19E | PM | 10182018 | 5 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665004148497 40.7805656411756) | |||||
2612 | 2612 | -73.97116730065241 | 40.77479796145771 | 12E-PM-1018-05 | 12E | PM | 10182018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9711673006524 40.7747979614577) | |||||
2800 | 2800 | -73.9802983138318 | 40.7676540772339 | 1B-PM-1019-05 | 01B | PM | 10192018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9802983138318 40.7676540772339) | ||||
2805 | 2805 | -73.9711634340673 | 40.7760553338671 | 13D-AM-1014-05 | 13D | AM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711634340673 40.7760553338671) | ||||
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) | |||
2824 | 2824 | -73.97506180080991 | 40.773752116709396 | 9B-AM-1010-05 | 09B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9750618008099 40.7737521167094) | ||||
2854 | 2854 | -73.9772908667333 | 40.7697207404744 | 4C-AM-1006-05 | 04C | AM | 10062018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772908667333 40.7697207404744) | ||||
2859 | 2859 | -73.9786940945874 | 40.769082027688796 | 3B-PM-1007-05 | 03B | PM | 10072018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 6 | on rock | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9786940945874 40.7690820276888) | ||||
2876 | 2876 | -73.95589957376541 | 40.7960097734603 | 39E-AM-1018-05 | 39E | AM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9558995737654 40.7960097734603) | ||||
2907 | 2907 | -73.96852016269341 | 40.783329261225 | 21B-AM-1019-05 | 21B | AM | 10192018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9685201626934 40.783329261225) | |||||
2917 | 2917 | -73.9770313887741 | 40.7724869252099 | 7B-AM-1008-05 | 07B | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770313887741 40.772486925209904) | ||||||
2923 | 2923 | -73.9672160533827 | 40.7830263908749 | 21C-AM-1014-05 | 21C | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9672160533827 40.7830263908749) | ||||
2962 | 2962 | -73.9722530826293 | 40.7667138028361 | 3I-AM-1010-05 | 03I | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722530826293 40.7667138028361) | |||||
2970 | 2970 | -73.9619019299709 | 40.7924476439693 | 33B-PM-1010-05 | 33B | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9619019299709 40.7924476439693) | |||||
3020 | 3020 | -73.97040158596391 | 40.7825600069973 | 19A-PM-1013-05 | 19A | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9704015859639 40.7825600069973) | ||||
2990 | 2990 | -73.97660121083071 | 40.7712310725379 | 6C-AM-1007-05 | 06C | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 1 | 1 | 0 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766012108307 40.7712310725379) | ||||
1783 | 1783 | -73.9730001080547 | 40.7678719218983 | 4G-AM-1006-05 | 04G | AM | 10062018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | climbing (tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent—was in front of my face (we were on a bridge)! | POINT (-73.9730001080547 40.7678719218983) | ||
1129 | 1129 | -73.97449068326779 | 40.7699948746776 | 6E-PM-1010-05 | 06E | PM | 10102018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | could this squirrel be eating a white mushroom? | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744906832678 40.76999487467761) | ||
1188 | 1188 | -73.9669529835992 | 40.787186415136496 | 25A-AM-1013-05 | 25A | AM | 10132018 | 5 | Gray | Gray+ | Ground Plane | FALSE | CROSS BRIDLE - INTO TREE TO AVOID DOGGO | 1 | 0 | 1 | 0 | 0 | d.p.t. | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | calm | POINT (-73.96695298359921 40.7871864151365) | |||
34 | 34 | -73.9704402681017 | 40.77989656212029 | 17C-PM-1013-05 | 17C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | eating (ate upside down on a tree — #jealous) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9704402681017 40.77989656212031) | ||||
2953 | 2953 | -73.9585862117341 | 40.7986549251083 | 40A-PM-1014-05 | 40A | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | eating (in a tree cage thing) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9585862117341 40.7986549251083) | |||
1456 | 1456 | -73.97142424264959 | 40.774453579812295 | 11E-PM-1012-05 | 11E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | foraging (foraged,ran to tree root,munched) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714242426496 40.7744535798123) | |||
276 | 276 | -73.9758579666874 | 40.767932654884504 | 3E-PM-1008-05 | 03E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | jump | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9758579666874 40.7679326548845) | ||||
203 | 203 | -73.96387745795491 | 40.79135321291479 | 31A-AM-1010-05 | 31A | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | jumping | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | eventually ran from lawnmower (tail flag) | POINT (-73.9638774579549 40.7913532129148) | |||
2891 | 2891 | -73.9636482556874 | 40.7775831570186 | 18I-PM-1007-05 | 18I | PM | 10072018 | 5 | Juvenile | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | jumping crazily / digging hole | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9636482556874 40.7775831570186) | |||
139 | 139 | -73.969847380865 | 40.7769884612305 | 14E-AM-1008-05 | 14E | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | 0 | 0 | 1 | 0 | 0 | nest building | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969847380865 40.7769884612305) | ||||
2645 | 2645 | -73.9584967368893 | 40.797732034109394 | 39B-PM-1014-05 | 39B | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous. | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584967368893 40.7977320341094) | |||
2552 | 2552 | -73.97249477106979 | 40.7696619340886 | 6G-AM-1008-05 | 06G | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 30 | branch | 0 | 0 | 1 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9724947710698 40.7696619340886) | |||
2685 | 2685 | -73.9601851468038 | 40.7968698151479 | 38A-AM-1019-05 | 38A | AM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon head, White belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | standing on back legs | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9601851468038 40.7968698151479) | ||
1735 | 1735 | -73.9563652303243 | 40.795512787396795 | 38E-PM-1014-05 | 38E | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | on log | 0 | 0 | 0 | 0 | 0 | statue | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9563652303243 40.7955127873968) |
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 );