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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2135 | 2135 | -73.9596251284566 | 40.7916254797561 | 33D-AM-1017-05 | 33D | AM | 10172018 | 5 | Adult | Black | Black+ | Above Ground | 5 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9596251284566 40.7916254797561) | |||||
2155 | 2155 | -73.9538938706987 | 40.7981150065974 | 42E-PM-1012-05 | 42E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538938706987 40.7981150065974) | ||||
2157 | 2157 | -73.9657171357842 | 40.7773277532224 | 16H-PM-1014-05 | 16H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 5 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9657171357842 40.7773277532224) | |||
2167 | 2167 | -73.9799594281222 | 40.7701978146968 | 4A-AM-1007-05 | 04A | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9799594281222 40.7701978146968) | |||||
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) | |||||
2260 | 2260 | -73.9784685928652 | 40.7669924015341 | 1D-PM-1007-05 | 01D | 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.9784685928652 40.7669924015341) | ||||
2305 | 2305 | -73.9679833225379 | 40.773854709340206 | 12H-PM-1007-05 | 12H | PM | 10072018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9679833225379 40.7738547093402) | |||||
2306 | 2306 | -73.956453902485 | 40.7936584431012 | 36F-PM-1012-05 | 36F | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.956453902485 40.7936584431012) | ||||
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) | ||||
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) | ||||
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) | |||
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) | |||||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | |||||
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) | ||||
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) | ||||
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) | |||
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) | ||
1312 | 1312 | -73.97120343207409 | 40.7764415506669 | 13D-PM-1018-05 | 13D | PM | 10182018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9712034320741 40.7764415506669) | |||
309 | 309 | -73.9696001184129 | 40.782081067353204 | 19B-PM-1018-05 | 19B | PM | 10182018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9696001184129 40.7820810673532) | |||
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) | ||
247 | 247 | -73.97331176635409 | 40.7694584620114 | 6F-PM-1008-05 | 06F | PM | 10082018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white patch | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97331176635412 40.7694584620114) |
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 );