This data as json, CSV (advanced)
Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8 | 8 | -73.9602609920814 | 40.7942883045566 | 35C-PM-1013-03 | 35C | PM | 10132018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9602609920814 40.79428830455661) | |||||
204 | 204 | -73.96795381633409 | 40.7837103696906 | 22C-AM-1013-03 | 22C | AM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | eating (mushroom) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9679538163341 40.7837103696906) | |||
361 | 361 | -73.96148244372509 | 40.7912929799884 | 32C-PM-1013-03 | 32C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9614824437251 40.7912929799884) | |||||
986 | 986 | -73.978400938697 | 40.7677411911854 | 2C-PM-1013-03 | 02C | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.978400938697 40.7677411911854) | ||||
1137 | 1137 | -73.9520280004414 | 40.7946345014466 | 39I-PM-1013-03 | 39I | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9520280004414 40.7946345014466) | ||||
1143 | 1143 | -73.9628349778362 | 40.793887005205995 | 34A-PM-1013-03 | 34A | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9628349778362 40.793887005206) | ||||
1148 | 1148 | -73.9707339200738 | 40.7796333355689 | 17C-PM-1013-03 | 17C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 20 | in a tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707339200738 40.7796333355689) | ||||
1369 | 1369 | -73.97027172608291 | 40.768951107763 | 6I-PM-1013-03 | 06I | PM | 10132018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Flowers, grass | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9702717260829 40.768951107763) | ||||
1459 | 1459 | -73.95638478673159 | 40.790601226116294 | 33G-AM-1013-03 | 33G | AM | 10132018 | 3 | ? | + | Only peeked head out | Above Ground | 13 | 0 | 0 | 0 | 0 | 0 | peeking out of tree,did *not* come out | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9563847867316 40.7906012261163) | ||||
1522 | 1522 | -73.95389705545321 | 40.7955196793479 | 39G-PM-1013-03 | 39G | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9538970554532 40.7955196793479) | ||||
1553 | 1553 | -73.9690645326017 | 40.7773822116124 | 15E-AM-1013-03 | 15E | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | on fallen log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9690645326017 40.7773822116124) | ||||
1572 | 1572 | -73.9540197079615 | 40.798039260982996 | 41E-PM-1013-03 | 41E | PM | 10132018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray on legs | Above Ground | 20 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9540197079615 40.798039260983) | |||
1967 | 1967 | -73.96472472541271 | 40.780613656578396 | 20G-PM-1013-03 | 20G | PM | 10132018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9647247254127 40.7806136565784) | ||||
2042 | 2042 | -73.9800896621713 | 40.7684379810317 | 2B-PM-1013-03 | 02B | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9800896621713 40.7684379810317) | ||||
2102 | 2102 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | 0 | 0 | 0 | 1 | 1 | watching | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9593909381748 40.7961036981921) | ||||
2132 | 2132 | -73.967472660349 | 40.7772125619715 | 16F-PM-1013-03 | 16F | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | Woods | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.96747266034902 40.7772125619715) | |||
2138 | 2138 | -73.9791536183194 | 40.7672705931866 | 1C-PM-1013-03 | 01C | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9791536183194 40.7672705931866) | ||||
2262 | 2262 | -73.9556177490335 | 40.788856916153705 | 32I-AM-1013-03 | 32I | AM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | watching me from tree - curious | POINT (-73.9556177490335 40.7888569161537) | |||
2377 | 2377 | -73.9704328573603 | 40.7739347247552 | 11F-AM-1013-03 | 11F | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9704328573603 40.7739347247552) | |||||
2496 | 2496 | -73.96962742914171 | 40.7691980808067 | 7I-PM-1013-03 | 07I | PM | 10132018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Trash bins | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9696274291417 40.7691980808067) | |||
2534 | 2534 | -73.9744368038675 | 40.7674281958115 | 3G-PM-1013-03 | 03G | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (climbed tree to run from) | POINT (-73.97443680386752 40.7674281958115) | ||||
2571 | 2571 | -73.9695468150218 | 40.7821142051746 | 20B-PM-1013-03 | 20B | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9695468150218 40.7821142051746) | ||||
2668 | 2668 | -73.95486485185579 | 40.7946730924872 | 38F-PM-1013-03 | 38F | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9548648518558 40.7946730924872) | ||||
2827 | 2827 | -73.9778578822323 | 40.770543270528606 | 5B-PM-1013-03 | 05B | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | grooming | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9778578822323 40.7705432705286) | ||||
2926 | 2926 | -73.9714653576023 | 40.77174001395021 | 9F-AM-1013-03 | 09F | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9714653576023 40.7717400139502) | ||||
2992 | 2992 | -73.9746063250438 | 40.7687654196811 | 4F-PM-1013-03 | 04F | PM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9746063250438 40.7687654196811) |
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 );