This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Kuks, Quaas, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30 | 30 | -73.96929432916109 | 40.776953610248796 | 15E-AM-1013-01 | 15E | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9692943291611 40.7769536102488) | ||||
79 | 79 | -73.9610705592868 | 40.7914829661051 | 32D-AM-1013-06 | 32D | AM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | eating (a mushroom),circles around us,really fat,scratching himself,grooming activity | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9610705592868 40.7914829661051) | ||||
176 | 176 | -73.9618064639153 | 40.792158440043 | 32C-PM-1013-12 | 32C | PM | 10132018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9618064639153 40.792158440043) | |||||
400 | 400 | -73.9590502257662 | 40.794290363687 | 36C-PM-1013-06 | 36C | PM | 10132018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | Running across wide street | 1 | 0 | 0 | 0 | 1 | carrying food in mouth | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9590502257662 40.794290363687) | |||
403 | 403 | -73.9597470659927 | 40.797321593541604 | 38A-PM-1013-01 | 38A | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9597470659927 40.7973215935416) | ||||
868 | 868 | -73.9738481771673 | 40.7706540698938 | 7E-PM-1013-04 | 07E | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9738481771673 40.7706540698938) | ||||
905 | 905 | -73.9757216124349 | 40.7754310239649 | 11A-PM-1013-05 | 11A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9757216124349 40.7754310239649) | |||
1108 | 1108 | -73.96383977903841 | 40.782895027290394 | 23F-PM-1013-02 | 23F | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | indifferent (mostly,did notice me,busy eating,foraging) | POINT (-73.9638397790384 40.7828950272904) | |||
1124 | 1124 | -73.959516757215 | 40.7952545908471 | 36C-PM-1013-04 | 36C | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | On rock | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.959516757215 40.7952545908471) | ||||
1200 | 1200 | -73.9657721715305 | 40.778534830257 | 18G-PM-1013-03 | 18G | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9657721715305 40.778534830257) | |||||
1308 | 1308 | -73.95603964408441 | 40.7945080361909 | 37E-AM-1013-01 | 37E | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9560396440844 40.7945080361909) | ||||
1346 | 1346 | -73.9735655529245 | 40.7716072681474 | 7E-PM-1013-02 | 07E | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9735655529245 40.7716072681474) | |||
1412 | 1412 | -73.9594676326588 | 40.7984457363388 | 39A-AM-1013-01 | 39A | AM | 10132018 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9594676326588 40.7984457363388) | ||||
1416 | 1416 | -73.97573134819821 | 40.7754704051391 | 11A-PM-1013-04 | 11A | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9757313481982 40.7754704051391) | ||||
1623 | 1623 | -73.97701191330229 | 40.773294909000505 | 8A-AM-1013-04 | 08A | AM | 10132018 | 4 | Juvenile | + | Above Ground | 4 | fence | 1 | 1 | 0 | 1 | 1 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770119133023 40.7732949090005) | ||||
1648 | 1648 | -73.97902633720041 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790263372004 40.7683513714892) | ||||||
1719 | 1719 | -73.955429970986 | 40.797816862987496 | 40D-AM-1013-02 | 40D | AM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.955429970986 40.7978168629875) | ||||
1748 | 1748 | -73.955710327539 | 40.797451079756705 | 40D-AM-1013-03 | 40D | AM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.955710327539 40.7974510797567) | ||||
1749 | 1749 | -73.97568253382991 | 40.7755542506699 | 11A-PM-1013-02 | 11A | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756825338299 40.7755542506699) | ||||
1961 | 1961 | -73.953664715831 | 40.7981256393159 | 41E-PM-1013-04 | 41E | PM | 10132018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.953664715831 40.7981256393159) | ||||
2242 | 2242 | -73.9565824187667 | 40.797312050952 | 40D-AM-1013-06 | 40D | AM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9565824187667 40.797312050952) | ||||
2275 | 2275 | -73.96142184133559 | 40.793894505879294 | 34B-AM-1013-01 | 34B | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | hopping | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9614218413356 40.7938945058793) | |||
2278 | 2278 | -73.96453903109901 | 40.78099163100121 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.964539031099 40.7809916310012) | ||||
2373 | 2373 | -73.9613276802049 | 40.7943813964442 | 35B-PM-1013-03 | 35B | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | threatened by approaching dog (dog #1) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.96132768020492 40.7943813964442) | |||
2423 | 2423 | -73.973552877209 | 40.7715638228207 | 7E-PM-1013-01 | 07E | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.973552877209 40.7715638228207) | |||
2483 | 2483 | -73.9596083366477 | 40.7949526729608 | 36C-PM-1013-05 | 36C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | "Warm brown" written in for Primary. | Ground Plane | FALSE | Ran across path in front of people | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9596083366477 40.7949526729608) | |||
2585 | 2585 | -73.9771726831497 | 40.7732320781799 | 8A-AM-1013-01 | 08A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | trail | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9771726831497 40.7732320781799) | |||
2716 | 2716 | -73.9618094076328 | 40.7944097368153 | 35A-PM-1013-03 | 35A | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9618094076328 40.7944097368153) | ||||
2727 | 2727 | -73.974596903918 | 40.7765498215674 | 12A-PM-1013-02 | 12A | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.974596903918 40.7765498215674) | ||||
3012 | 3012 | -73.96137019608979 | 40.7943363227822 | 35B-PM-1013-04 | 35B | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | got threatened by dog (same dog,dog #1) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9613701960898 40.7943363227822) |
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 );