This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from
Location ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63 | 63 | -73.9745630038492 | 40.7692602628745 | 5E-AM-1008-06 | 05E | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9745630038492 40.7692602628745) | ||||
448 | 448 | -73.9706929341294 | 40.7760473872395 | 13E-PM-1008-06 | 13E | PM | 10082018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706929341294 40.77604738723951) | ||||
468 | 468 | -73.9780659679557 | 40.7672382282781 | 1D-PM-1007-06 | 01D | PM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9780659679557 40.7672382282781) | ||||
477 | 477 | -73.97014812002979 | 40.7751110354034 | 12F-AM-1020-06 | 12F | AM | 10202018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9701481200298 40.7751110354034) | ||||
737 | 737 | -73.97111769994709 | 40.7724278547281 | 10F-PM-1019-06 | 10F | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | Different tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711176999471 40.7724278547281) | |||
907 | 907 | -73.95806099213101 | 40.7907158878729 | 32F-AM-1012-06 | 32F | AM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.958060992131 40.7907158878729) | ||||
967 | 967 | -73.9683994064731 | 40.7710765500799 | 9I-AM-1014-06 | 09I | AM | 10142018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96839940647311 40.7710765500799) | ||||
1049 | 1049 | -73.9564606426367 | 40.788054657260794 | 30I-PM-1006-06 | 30I | PM | 10062018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ran up tree | POINT (-73.9564606426367 40.7880546572608) | |||
1133 | 1133 | -73.9712550584322 | 40.7764273475386 | 13D-PM-1018-06 | 13D | PM | 10182018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712550584322 40.7764273475386) | |||
1233 | 1233 | -73.9722281263634 | 40.770408328801295 | 7G-AM-1010-06 | 07G | AM | 10102018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722281263634 40.7704083288013) | ||||
1290 | 1290 | -73.96681408040659 | 40.77681001473329 | 15G-AM-1008-06 | 15G | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9668140804066 40.7768100147333) | ||||
1498 | 1498 | -73.9765064169087 | 40.7737211426714 | 8B-AM-1007-06 | 08B | AM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9765064169087 40.7737211426714) | ||||
1644 | 1644 | -73.9734654671008 | 40.7715988711659 | 8E-PM-1008-06 | 08E | PM | 10082018 | 6 | 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.9734654671008 40.7715988711659) | |||
1699 | 1699 | -73.9706968708903 | 40.7821499135828 | 19A-PM-1013-06 | 19A | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9706968708903 40.7821499135828) | ||||
1803 | 1803 | -73.9588076804698 | 40.7912942607296 | 33E-AM-1014-06 | 33E | AM | 10142018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9588076804698 40.7912942607296) | ||||
1805 | 1805 | -73.9590328527128 | 40.791221441757706 | 33E-PM-1012-06 | 33E | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9590328527128 40.7912214417577) | |||
1870 | 1870 | -73.9542118614769 | 40.7939171395463 | 37G-AM-1014-06 | 37G | AM | 10142018 | 6 | Adult | Gray | White | Gray+White | White tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95421186147692 40.7939171395463) | |||
2007 | 2007 | -73.9684834138222 | 40.772428912021105 | 11H-AM-1010-06 | 11H | AM | 10102018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9684834138222 40.7724289120211) | ||||
2190 | 2190 | -73.9657040391563 | 40.7755567428199 | 15I-AM-1008-06 | 15I | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 12 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9657040391563 40.7755567428199) | ||||
2331 | 2331 | -73.9694681803635 | 40.770585795359004 | 8I-AM-1006-06 | 08I | AM | 10062018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694681803635 40.770585795359) | |||||
2358 | 2358 | -73.9788379085607 | 40.7683896583055 | 2C-PM-1013-06 | 02C | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | cleaning face & tail | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9788379085607 40.7683896583055) | |||
2363 | 2363 | -73.9690638424196 | 40.7713869295685 | 9H-AM-1006-06 | 09H | AM | 10062018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9690638424196 40.7713869295685) | ||||
2410 | 2410 | -73.97551920769341 | 40.7664413570796 | 2F-PM-1014-06 | 02F | PM | 10142018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755192076934 40.7664413570796) | ||||
2519 | 2519 | -73.9589475065438 | 40.7934846881536 | 35D-PM-1013-06 | 35D | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9589475065438 40.7934846881536) | ||||
2529 | 2529 | -73.98002714878629 | 40.7702554167042 | 4A-PM-1007-06 | 04A | PM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | A rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9800271487863 40.7702554167042) | |||
2591 | 2591 | -73.9786351029146 | 40.771611416400205 | 6A-PM-1012-06 | 06A | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | elevated ground | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9786351029146 40.771611416400205) | |||
2617 | 2617 | -73.9564228238736 | 40.7936908887644 | 36F-PM-1012-06 | 36F | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9564228238736 40.7936908887644) | ||||
2642 | 2642 | -73.97514547259979 | 40.770291361572 | 6D-PM-1020-06 | 06D | PM | 10202018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by carousel | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9751454725998 40.770291361572006) | |||
2674 | 2674 | -73.97710090245809 | 40.7688793288864 | 3D-PM-1010-06 | 03D | PM | 10102018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9771009024581 40.7688793288864) | ||||
2684 | 2684 | -73.9809688694074 | 40.7688535974878 | 2A-PM-1019-06 | 02A | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809688694074 40.7688535974878) | ||||
2732 | 2732 | -73.9694185786221 | 40.7787189999566 | 16D-AM-1007-06 | 16D | AM | 10072018 | 6 | Adult | Cinnamon | White | Cinnamon+White | primary color: brown ( I marked cinnamon as closest to brown - JO) | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694185786221 40.7787189999566) | |||
2815 | 2815 | -73.97473113123941 | 40.76773197250439 | 3F-PM-1013-06 | 03F | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 19 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97473113123941 40.7677319725044) | ||||
2855 | 2855 | -73.9690832219322 | 40.782343340985996 | 20B-PM-1013-06 | 20B | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96908322193221 40.782343340986) | ||||
495 | 495 | -73.9801007327506 | 40.7677455633932 | 1B-PM-1019-06 | 01B | PM | 10192018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801007327506 40.7677455633932) | ||||
1077 | 1077 | -73.9541837143178 | 40.7944340477396 | 38G-PM-1020-06 | 38G | PM | 10202018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9541837143178 40.7944340477396) | ||||
1540 | 1540 | -73.957710975899 | 40.79840556140471 | 40B-AM-1019-06 | 40B | AM | 10192018 | 6 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.957710975899 40.7984055614047) | ||||
2081 | 2081 | -73.96757180595391 | 40.7786049141486 | 17F-AM-1007-06 | 17F | AM | 10072018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9675718059539 40.7786049141486) | ||||
2144 | 2144 | -73.975198284551 | 40.7740343763399 | 9B-AM-1010-06 | 09B | AM | 10102018 | 6 | Juvenile | Gray | White | Gray+White | Above Ground | 16 | tree | 0 | 0 | 1 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975198284551 40.7740343763399) | ||
2168 | 2168 | -73.95823634371351 | 40.7987752300505 | 40B-AM-1019-06 | 40B | AM | 10192018 | 6 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9582363437135 40.7987752300505) | ||||
2742 | 2742 | -73.96280415779341 | 40.7884180156055 | 28D-AM-1012-06 | 28D | AM | 10122018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9628041577934 40.78841801560551) |
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 );