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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1287 | 1287 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 10082018 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | 1 | 0 | 0 | 0 | 0 | was chased by # 11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763236949008 40.7686815615335) | |||
1384 | 1384 | -73.97876087620051 | 40.7686062296462 | 3C-PM-1008-01 | 03C | PM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | 0 | 0 | 0 | 0 | 0 | walked between trees | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9787608762005 40.7686062296462) | |||
1433 | 1433 | -73.9574077497624 | 40.80011851848921 | 42B-AM-1014-01 | 42B | AM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9574077497624 40.8001185184892) | |||||
1518 | 1518 | -73.9632265832593 | 40.7816914475461 | 22G-AM-1018-04 | 22G | AM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9632265832593 40.78169144754611) | ||||
1594 | 1594 | -73.9778730762957 | 40.770827251547 | 5B-PM-1013-05 | 05B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9778730762957 40.770827251547) | |||||
1613 | 1613 | -73.95992022335359 | 40.7972599930224 | 38A-AM-1019-02 | 38A | AM | 10192018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599202233536 40.7972599930224) | |||||
1631 | 1631 | -73.9527196716568 | 40.792363826828 | 36I-PM-1007-11 | 36I | PM | 10072018 | 11 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | me! | POINT (-73.9527196716568 40.792363826828) | |||
1653 | 1653 | -73.9695881075086 | 40.7842441291991 | 21A-AM-1019-01 | 21A | AM | 10192018 | 1 | Juvenile | Gray | Black | Gray+Black | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | keeps to tree,drops down on side away from people | POINT (-73.9695881075086 40.7842441291991) | |||
1825 | 1825 | -73.9624209799704 | 40.79102009727521 | 31C-PM-1010-01 | 31C | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9624209799704 40.7910200972752) | ||||
1891 | 1891 | -73.9749641575871 | 40.767330505627704 | 3F-AM-1006-05 | 03F | AM | 10062018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9749641575871 40.7673305056277) | ||||
2175 | 2175 | -73.9657487923637 | 40.7786823090663 | 18G-PM-1013-04 | 18G | PM | 10132018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9657487923637 40.7786823090663) | |||||
2406 | 2406 | -73.9668964315686 | 40.777757799088604 | 16G-AM-1010-01 | 16G | AM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9668964315686 40.7777577990886) | ||||
2433 | 2433 | -73.9706949930717 | 40.772362045852 | 10G-AM-1006-08 | 10G | AM | 10062018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 3 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9706949930717 40.772362045852) | ||||
2466 | 2466 | -73.95994199262991 | 40.797277472881106 | 38A-AM-1019-01 | 38A | AM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599419926299 40.7972774728811) | |||||
2476 | 2476 | -73.9710843362124 | 40.7679739601336 | 5I-AM-1010-03 | 05I | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710843362124 40.7679739601336) | |||||
2663 | 2663 | -73.96134291849741 | 40.79121580572671 | 32C-AM-1014-02 | 32C | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9613429184974 40.7912158057267) | |||||
2864 | 2864 | -73.9761879300037 | 40.7683918970301 | 3E-PM-1008-01 | 03E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761879300037 40.7683918970301) | |||||
1977 | 1977 | -73.9586570546871 | 40.796349417475 | 38C-AM-1019-09 | 38C | AM | 10192018 | 9 | Adult | Gray | White | Gray+White | Gray & White selected as Primary & Highlights. Made executive adjustments. | Above Ground | 3 | Between ground & tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9586570546871 40.796349417475) | ||
1241 | 1241 | -73.9651817987035 | 40.781908283833396 | 21E-AM-1017-01 | 21E | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | Climbs small tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | walks from | POINT (-73.9651817987035 40.7819082838334) | ||
261 | 261 | -73.9552861155228 | 40.788973931872 | 32I-AM-1013-05 | 32I | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9552861155228 40.788973931872) | |||
1017 | 1017 | -73.9552035011902 | 40.7889851896334 | 32I-AM-1013-06 | 32I | AM | 10132018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9552035011902 40.7889851896334) | |||
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) | ||||
2171 | 2171 | -73.9686370726471 | 40.7780382348833 | 16E-PM-1018-09 | 16E | PM | 10182018 | 9 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 3 | On trunk | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9686370726471 40.7780382348833) | |||
1053 | 1053 | -73.96858597054859 | 40.784880506532204 | 23A-AM-1018-04 | 23A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | Tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685859705486 40.7848805065322) | ||||
1788 | 1788 | -73.9685567075413 | 40.7703797723105 | 8I-AM-1006-10 | 08I | AM | 10062018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | bush | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.96855670754131 40.7703797723105) | |||
2258 | 2258 | -73.95477850811709 | 40.789612183711 | 33I-AM-1008-02 | 33I | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | edge of park @ 98th | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9547785081171 40.789612183711) | ||||
222 | 222 | -73.97702735535249 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 10132018 | 3 | Juvenile | + | Above Ground | 3 | fence | 1 | 1 | 1 | 1 | 0 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770273553525 40.7732399463626) | ||||
428 | 428 | -73.96362827608 | 40.780799459524204 | 21G-AM-1014-02 | 21G | AM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 3 | fence | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96362827608 40.7807994595242) | |||
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) | |||
1854 | 1854 | -73.9618076359384 | 40.7947808718203 | 35A-PM-1013-05 | 35A | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 3 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9618076359384 40.7947808718203) | ||||
237 | 237 | -73.96789565689801 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 3 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.967895656898 40.7767409597341) | ||||
1162 | 1162 | -73.95685442708809 | 40.7972517274475 | 39D-AM-1008-06 | 39D | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 3 | on rock | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9568544270881 40.7972517274475) | ||||
150 | 150 | -73.97634308293419 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 10082018 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | on tree facing downward | 0 | 1 | 0 | 0 | 0 | chased #12 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9763430829342 40.7686351097159) | ||
2988 | 2988 | -73.9766342759486 | 40.7687518380873 | 4D-AM-1012-04 | 04D | AM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9766342759486 40.7687518380873) | ||||
394 | 394 | -73.9719888241794 | 40.7667681685356 | 4I-PM-1007-03 | 04I | PM | 10072018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | ran to tree | 0 | 0 | 0 | 0 | 0 | being chased | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9719888241794 40.7667681685356) | ||
899 | 899 | -73.97927540372909 | 40.7679690700399 | 2C-AM-1010-08 | 02C | AM | 10102018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | stay on side of trunk | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9792754037291 40.7679690700399) | |||
80 | 80 | -73.9688454483585 | 40.78453012881629 | 22A-AM-1008-05 | 22A | AM | 10082018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 3 | trash can | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9688454483585 40.7845301288163) | |||
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) |
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 );