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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
292 | 292 | -73.9674069524601 | 40.7772529662424 | 16F-PM-1013-02 | 16F | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Woods | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674069524601 40.7772529662424) | |||
374 | 374 | -73.9556817958407 | 40.788852000621 | 32I-AM-1013-02 | 32I | AM | 10132018 | 2 | 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.9556817958407 40.788852000621) | |||
384 | 384 | -73.968045072743 | 40.783662671722496 | 22C-AM-1013-02 | 22C | AM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.968045072743 40.7836626717225) | ||||
409 | 409 | -73.9530809650496 | 40.7959176317705 | 40G-PM-1013-02 | 40G | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | hiding from dog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9530809650496 40.79591763177051) | |||
515 | 515 | -73.9601486483164 | 40.7943724108626 | 35C-PM-1013-02 | 35C | PM | 10132018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (when i crouched down) | POINT (-73.9601486483164 40.7943724108626) | ||||
519 | 519 | -73.96590102384171 | 40.7791683666215 | 18G-PM-1013-02 | 18G | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9659010238417 40.779168366621505) | |||||
797 | 797 | -73.969345754447 | 40.7770429650288 | 15E-AM-1013-02 | 15E | AM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.969345754447 40.7770429650288) | ||||
819 | 819 | -73.9603620122205 | 40.7955965755851 | 36B-AM-1013-02 | 36B | AM | 10132018 | 2 | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | didn't see me | POINT (-73.9603620122205 40.7955965755851) | |||||
883 | 883 | -73.95655337834991 | 40.7974368491287 | 40D-PM-1013-02 | 40D | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565533783499 40.7974368491287) | ||||
993 | 993 | -73.97724226646571 | 40.773436329163 | 8A-AM-1013-02 | 08A | AM | 10132018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | playground | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9772422664657 40.773436329163) | |||
1011 | 1011 | -73.97191114701641 | 40.7758789855474 | 12D-AM-1013-02 | 12D | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 7 | Was on top of the edge of Bow Bridge | 0 | 0 | 0 | 0 | 0 | jumped off | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9719111470164 40.7758789855474) | |||
1187 | 1187 | -73.97933344163779 | 40.7674142089209 | 1C-PM-1013-02 | 01C | PM | 10132018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9793334416378 40.7674142089209) | |||
1252 | 1252 | -73.9777998932399 | 40.770981586533395 | 5B-PM-1013-02 | 05B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9777998932399 40.7709815865334) | ||||
1267 | 1267 | -73.9701010964667 | 40.768891931450796 | 6I-PM-1013-02 | 06I | PM | 10132018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | Bushes | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9701010964667 40.76889193145081) | ||||
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) | |||
1480 | 1480 | -73.96285255338309 | 40.793844934501706 | 34A-PM-1013-02 | 34A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | eating upside down on tree trunk | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9628525533831 40.7938449345017) | |||
1507 | 1507 | -73.9699799501516 | 40.7736576286234 | 11F-AM-1013-02 | 11F | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9699799501516 40.7736576286234) | |||||
1515 | 1515 | -73.9530326577312 | 40.7956922386395 | 39G-PM-1013-02 | 39G | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9530326577312 40.795692238639504) | ||||
1782 | 1782 | -73.9549133872427 | 40.7946871036949 | 38F-PM-1013-02 | 38F | PM | 10132018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9549133872427 40.7946871036949) | ||||
1938 | 1938 | -73.9719879697272 | 40.7725625124591 | 9F-AM-1013-02 | 09F | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9719879697272 40.7725625124591) | |||||
1953 | 1953 | -73.9644974196807 | 40.7810020292593 | 20G-PM-1013-02 | 20G | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.96449741968071 40.7810020292593) | ||||
2068 | 2068 | -73.9735587560787 | 40.7672346255151 | 3G-PM-1013-02 | 03G | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | wandering,interacting with tourists | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (father - son taking photos,talking about giving him planters peanuts) | POINT (-73.9735587560787 40.7672346255151) | ||
2072 | 2072 | -73.9618709589382 | 40.7944969066792 | 35A-PM-1013-02 | 35A | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9618709589382 40.7944969066792) | ||||
2194 | 2194 | -73.960898739757 | 40.7961393097144 | 37A-PM-1013-02 | 37A | PM | 10132018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.960898739757 40.7961393097144) | ||||
2212 | 2212 | -73.9801138983722 | 40.768572151563504 | 2B-PM-1013-02 | 02B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9801138983722 40.7685721515635) | ||||
2249 | 2249 | -73.9785709201168 | 40.7674391934208 | 2C-PM-1013-02 | 02C | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785709201168 40.7674391934208) | ||||
2263 | 2263 | -73.95693753558841 | 40.793539800861204 | 36E-AM-1013-02 | 36E | AM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569375355884 40.7935398008612) | |||||
2284 | 2284 | -73.9730181306326 | 40.779460132242704 | 16A-AM-1013-02 | 16A | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9730181306326 40.7794601322427) | ||||||
2458 | 2458 | -73.969517504176 | 40.782074134429706 | 20B-PM-1013-02 | 20B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969517504176 40.7820741344297) | ||||
2819 | 2819 | -73.95503500969379 | 40.797694218705004 | 41E-PM-1013-02 | 41E | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9550350096938 40.797694218705004) | ||||
2982 | 2982 | -73.9513477815203 | 40.7945259614138 | 39I-PM-1013-02 | 39I | PM | 10132018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | along the road | 0 | 1 | 1 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9513477815203 40.7945259614138) | |||
859 | 859 | -73.9600964585868 | 40.7952339524416 | 36B-PM-1013-02 | 36B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9600964585868 40.7952339524416) | ||||
1202 | 1202 | -73.9694979297007 | 40.769466740872105 | 7I-PM-1013-02 | 07I | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Construction materials | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9694979297007 40.7694667408721) | |||
1872 | 1872 | -73.9613998967903 | 40.7912437235667 | 32C-PM-1013-02 | 32C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9613998967903 40.7912437235667) | |||||
2467 | 2467 | -73.9755923256429 | 40.7672967972471 | 3F-PM-1013-02 | 03F | PM | 10132018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.97559232564292 40.7672967972471) | ||||
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) |
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 );