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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1757 | 1757 | -73.9601561064548 | 40.7900513933531 | 31E-PM-1006-08 | 31E | PM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9601561064548 40.7900513933531) | ||||
775 | 775 | -73.95957577926829 | 40.7899242643847 | 31E-PM-1006-01 | 31E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9595757792683 40.7899242643847) | |||
830 | 830 | -73.95956459625391 | 40.7899599350145 | 31E-PM-1006-03 | 31E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | 0 | 0 | 0 | 1 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9595645962539 40.7899599350145) | ||
453 | 453 | -73.959514034869 | 40.789911786416 | 31E-PM-1006-02 | 31E | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.959514034869 40.789911786416) | |||
825 | 825 | -73.9580105174865 | 40.7974468322692 | 39C-PM-1006-03 | 39C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9580105174865 40.7974468322692) | |||||
2842 | 2842 | -73.9579292340076 | 40.7976287835027 | 39C-PM-1006-04 | 39C | PM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579292340076 40.7976287835027) | ||||
311 | 311 | -73.95787795565741 | 40.7934116539732 | 35E-PM-1006-06 | 35E | PM | 10062018 | 6 | Adult | Gray | Gray+ | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9578779556574 40.7934116539732) | ||||||
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) | |||||
134 | 134 | -73.9575943815564 | 40.7933755266787 | 35E-PM-1006-07 | 35E | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9575943815564 40.7933755266787) | |||||
418 | 418 | -73.9573604880421 | 40.7930844158021 | 35E-PM-1006-03 | 35E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9573604880421 40.7930844158021) | ||||
162 | 162 | -73.957219204335 | 40.7931529059779 | 35E-PM-1006-01 | 35E | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | looking/begging for food | POINT (-73.957219204335 40.7931529059779) | |||
362 | 362 | -73.9571407991577 | 40.793191739640605 | 35E-PM-1006-02 | 35E | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | begging for food | POINT (-73.9571407991577 40.7931917396406) | |||
1973 | 1973 | -73.957138759793 | 40.795592603505504 | 38D-PM-1006-02 | 38D | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957138759793 40.7955926035055) | ||||
1334 | 1334 | -73.957134662576 | 40.7872395604122 | 30I-PM-1006-07 | 30I | PM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.957134662576 40.7872395604122) | ||||
564 | 564 | -73.95700862122851 | 40.7946679755816 | 37E-PM-1006-08 | 37E | PM | 10062018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95700862122851 40.7946679755816) | |||||
1703 | 1703 | -73.956998502609 | 40.7948117428147 | 37E-PM-1006-01 | 37E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.956998502609 40.7948117428147) | ||||
55 | 55 | -73.9568802149818 | 40.7972399133816 | 39C-PM-1006-01 | 39C | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9568802149818 40.7972399133816) | |||||
1678 | 1678 | -73.95687265085459 | 40.7878795081255 | 30I-PM-1006-03 | 30I | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | up tree | POINT (-73.9568726508546 40.7878795081255) | ||||
2590 | 2590 | -73.9568524771058 | 40.7974664985551 | 40C-PM-1006-06 | 40C | PM | 10062018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | By The Road | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9568524771058 40.7974664985551) | ||||
233 | 233 | -73.9568343093228 | 40.794940135088204 | 37E-PM-1006-04 | 37E | PM | 10062018 | 4 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | doesn't see me | POINT (-73.9568343093228 40.7949401350882) | |||
1676 | 1676 | -73.9566686940197 | 40.794924397955 | 37E-PM-1006-05 | 37E | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9566686940197 40.794924397955) | ||||
2290 | 2290 | -73.95656457165641 | 40.795903994957705 | 38D-PM-1006-03 | 38D | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9565645716564 40.795903994957705) | ||||
2782 | 2782 | -73.9563473341712 | 40.7893712398425 | 32H-PM-1006-03 | 32H | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9563473341712 40.78937123984251) | ||||
1776 | 1776 | -73.9562350820255 | 40.7913464147989 | 34G-PM-1006-02 | 34G | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 1 | 1 | 1 | eating bread it found on ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9562350820255 40.7913464147989) | ||||
290 | 290 | -73.95606798644259 | 40.7947887062326 | 37E-PM-1006-06 | 37E | PM | 10062018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9560679864426 40.7947887062326) | ||||
872 | 872 | -73.9551524422379 | 40.7910535596756 | 34H-PM-1006-01 | 34H | PM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9551524422379 40.7910535596756) | |||||
2873 | 2873 | -73.955068474109 | 40.79117881528779 | 34H-PM-1006-05 | 34H | PM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | white tail tip | Ground Plane | FALSE | in grass | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.955068474109 40.7911788152878) | ||
1785 | 1785 | -73.9550627447399 | 40.7910104700332 | 34H-PM-1006-02 | 34H | PM | 10062018 | 2 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9550627447399 40.7910104700332) | ||||||
456 | 456 | -73.9547878025303 | 40.7899151873467 | 33I-PM-1006-05 | 33I | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9547878025303 40.7899151873467) | |||||
546 | 546 | -73.9547423290276 | 40.7899702628835 | 33I-PM-1006-09 | 33I | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9547423290276 40.7899702628835) | |||||
2741 | 2741 | -73.9545877741228 | 40.79000012103529 | 33I-PM-1006-01 | 33I | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9545877741228 40.7900001210353) | |||||
1486 | 1486 | -73.9545807749923 | 40.790050753764895 | 33I-PM-1006-02 | 33I | PM | 10062018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9545807749923 40.7900507537649) | |||||
1920 | 1920 | -73.95453837191879 | 40.7899711263765 | 33I-PM-1006-03 | 33I | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.95453837191882 40.7899711263765) | |||||
2958 | 2958 | -73.9541748083177 | 40.795275844289705 | 39F-PM-1006-01 | 39F | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | carrying leaves | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9541748083177 40.7952758442897) | ||||
2870 | 2870 | -73.9538475741188 | 40.796479421955 | 40F-PM-1006-02 | 40F | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538475741188 40.796479421955) | ||||
2650 | 2650 | -73.9538251716292 | 40.7919360198175 | 35I-PM-1006-01 | 35I | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538251716292 40.7919360198175) | ||||
504 | 504 | -73.95334760207359 | 40.7933003544685 | 37H-PM-1006-02 | 37H | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | tree | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | dogs | POINT (-73.9533476020736 40.7933003544685) | ||
2336 | 2336 | -73.95312632141359 | 40.7965675089932 | 40F-PM-1006-01 | 40F | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9531263214136 40.7965675089932) | ||||
1107 | 1107 | -73.95307395621309 | 40.7932034409546 | 37H-PM-1006-01 | 37H | PM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | from voice | POINT (-73.95307395621312 40.7932034409546) | |||
2035 | 2035 | -73.9527184914182 | 40.792678590484705 | 37I-PM-1006-02 | 37I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9527184914182 40.7926785904847) | |||||
2008 | 2008 | -73.95243640874371 | 40.792846505434 | 37I-PM-1006-01 | 37I | PM | 10062018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Above Ground | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9524364087437 40.792846505434) |
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 );