This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103 | 103 | -73.96077013704429 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 10132018 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | 0 | 1 | 0 | 0 | 0 | chasing #8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9607701370443 40.7955418990855) | ||||
188 | 188 | -73.9570528770427 | 40.7990973804149 | 41B-AM-1010-07 | 41B | AM | 10102018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | mad! | POINT (-73.9570528770427 40.7990973804149) | |||
212 | 212 | -73.9638837160341 | 40.7809747900833 | 21G-AM-1014-07 | 21G | AM | 10142018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9638837160341 40.7809747900833) | ||||
482 | 482 | -73.97217978245759 | 40.7801213843628 | 16A-PM-1019-07 | 16A | PM | 10192018 | 7 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | approaches (very friendly) | POINT (-73.9721797824576 40.7801213843628) | |||
588 | 588 | -73.9646597452128 | 40.7827698220703 | 22F-AM-1007-07 | 22F | AM | 10072018 | 7 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | alert & aware | POINT (-73.9646597452128 40.7827698220703) | |||
879 | 879 | -73.9735120882106 | 40.7715915415169 | 8E-PM-1008-07 | 08E | PM | 10082018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9735120882106 40.7715915415169) | |||
926 | 926 | -73.9596006938677 | 40.7834706440535 | 25I-PM-1007-07 | 25I | PM | 10072018 | 7 | Adult | Gray | Gray+ | Above Ground | playing very high in tree w/ #8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9596006938677 40.7834706440535) | |||||
1127 | 1127 | -73.9776445567926 | 40.768119107973 | 3D-PM-1010-07 | 03D | PM | 10102018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9776445567926 40.768119107973) | ||||
1132 | 1132 | -73.9798390387307 | 40.7700761090896 | 3A-PM-1017-07 | 03A | PM | 10172018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9798390387307 40.7700761090896) | ||||
1173 | 1173 | -73.959070754026 | 40.790667514341294 | 32E-PM-1017-07 | 32E | PM | 10172018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.959070754026 40.7906675143413) | ||||
1226 | 1226 | -73.97684509716998 | 40.7709430375069 | 5C-PM-1010-07 | 05C | PM | 10102018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 13 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.97684509717 40.7709430375069) | ||||
1281 | 1281 | -73.9795728289645 | 40.7678669804787 | 1C-PM-1013-07 | 01C | PM | 10132018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9795728289645 40.7678669804787) | ||||
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) | ||||
1389 | 1389 | -73.9580021017892 | 40.7955140102242 | 37D-PM-1014-07 | 37D | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9580021017892 40.7955140102242) | |||||
1688 | 1688 | -73.9677593344667 | 40.7763054313195 | 15G-PM-1019-07 | 15G | PM | 10192018 | 7 | Adult | + | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9677593344667 40.7763054313195) | ||||||
1738 | 1738 | -73.967975586222 | 40.77356830443129 | 12H-PM-1007-07 | 12H | PM | 10072018 | 7 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | grass field | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | humans | POINT (-73.967975586222 40.7735683044313) | |||
1753 | 1753 | -73.9733437449715 | 40.778240154836205 | 14B-PM-1014-07 | 14B | PM | 10142018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9733437449715 40.7782401548362) | ||||
1797 | 1797 | -73.96971780962751 | 40.769703669630104 | 7I-PM-1013-07 | 07I | PM | 10132018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | Under the tree | 0 | 1 | 0 | 0 | 0 | playing,interacting with #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9697178096275 40.769703669630104) | ||
1861 | 1861 | -73.97555625268109 | 40.7678821029525 | 3E-AM-1006-07 | 03E | AM | 10062018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | burying nuts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9755562526811 40.7678821029525) | |||
1862 | 1862 | -73.97648512317541 | 40.771573686286104 | 6C-AM-1007-07 | 06C | AM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | ambling | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | trucks | POINT (-73.9764851231754 40.7715736862861) | ||
1922 | 1922 | -73.9602197762862 | 40.7936850570022 | 35C-PM-1013-07 | 35C | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9602197762862 40.7936850570022) | |||||
1958 | 1958 | -73.96931200900549 | 40.771096102012 | 9H-PM-1018-07 | 09H | PM | 10182018 | 7 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9693120090055 40.771096102012) | |||||||
1999 | 1999 | -73.95498609472341 | 40.79115503283089 | 34H-PM-1006-07 | 34H | PM | 10062018 | 7 | Juvenile | Gray | White | Gray+White | white belly | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9549860947234 40.7911550328309) | |||
2057 | 2057 | -73.9579659543224 | 40.7905646887034 | 32F-AM-1012-07 | 32F | AM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9579659543224 40.7905646887034) | ||||
2179 | 2179 | -73.95596639495109 | 40.7974497269789 | 40D-AM-1013-07 | 40D | AM | 10132018 | 7 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | curious | POINT (-73.9559663949511 40.7974497269789) | ||||
2292 | 2292 | -73.96698919404629 | 40.7835635162331 | 22C-PM-1006-07 | 22C | PM | 10062018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9669891940463 40.7835635162331) | |||||
2311 | 2311 | -73.96801718943509 | 40.772464442631296 | 11I-PM-1012-07 | 11I | PM | 10122018 | 7 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying its food into the ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.96801718943512 40.7724644426313) | ||||
2332 | 2332 | -73.9709797467807 | 40.776909571067904 | 14D-AM-1014-07 | 14D | AM | 10142018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9709797467807 40.7769095710679) | ||||
2372 | 2372 | -73.9724879969884 | 40.771098202397 | 8F-PM-1012-07 | 08F | PM | 10122018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 17 | 0 | 0 | 1 | 0 | 0 | gathering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9724879969884 40.771098202397) | |||
2554 | 2554 | -73.9701505245419 | 40.768998364571 | 6I-PM-1013-07 | 06I | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 11 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9701505245419 40.768998364571004) | |||||
2669 | 2669 | -73.9615900833886 | 40.7945431292846 | 35A-PM-1013-07 | 35A | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9615900833886 40.7945431292846) | ||||
2784 | 2784 | -73.9763722433833 | 40.7744121430891 | 9A-AM-1013-07 | 09A | AM | 10132018 | 7 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763722433833 40.7744121430891) |
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 );