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, Running, Chasing, Eating, Kuks, Quaas, Tail flags, Tail twitches
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20 | 20 | -73.9706105896967 | 40.769812482150705 | 7H-AM-1006-05 | 07H | AM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706105896967 40.7698124821507) | ||||
34 | 34 | -73.9704402681017 | 40.77989656212029 | 17C-PM-1013-05 | 17C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | eating (ate upside down on a tree — #jealous) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9704402681017 40.77989656212031) | ||||
57 | 57 | -73.9690175838534 | 40.77604327200171 | 14F-AM-1007-05 | 14F | AM | 10072018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690175838534 40.7760432720017) | ||||
276 | 276 | -73.9758579666874 | 40.767932654884504 | 3E-PM-1008-05 | 03E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | jump | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9758579666874 40.7679326548845) | ||||
309 | 309 | -73.9696001184129 | 40.782081067353204 | 19B-PM-1018-05 | 19B | PM | 10182018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9696001184129 40.7820810673532) | |||
532 | 532 | -73.96854290608391 | 40.7724786961619 | 11H-AM-1010-05 | 11H | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9685429060839 40.7724786961619) | ||||
562 | 562 | -73.972467515471 | 40.7659131865172 | 3I-PM-1013-05 | 03I | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.972467515471 40.7659131865172) | ||||
571 | 571 | -73.9659549963516 | 40.7833659689194 | 22D-PM-1012-05 | 22D | PM | 10122018 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9659549963516 40.7833659689194) | ||||||
676 | 676 | -73.9710207438538 | 40.7682187144432 | 5I-AM-1010-05 | 05I | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9710207438538 40.7682187144432) | |||||
928 | 928 | -73.96704295859901 | 40.778437071937105 | 17F-AM-1007-05 | 17F | AM | 10072018 | 5 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.967042958599 40.7784370719371) | ||||
977 | 977 | -73.9764601882854 | 40.766070446642 | 1F-AM-1010-05 | 01F | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9764601882854 40.766070446642) | |||||
1122 | 1122 | -73.9728700359494 | 40.7659842666881 | 3H-PM-1014-05 | 03H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728700359494 40.7659842666881) | ||||
1129 | 1129 | -73.97449068326779 | 40.7699948746776 | 6E-PM-1010-05 | 06E | PM | 10102018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | could this squirrel be eating a white mushroom? | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744906832678 40.76999487467761) | ||
1141 | 1141 | -73.9664669369583 | 40.7774085361976 | 16G-AM-1010-05 | 16G | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9664669369583 40.7774085361976) | ||||
1288 | 1288 | -73.97304542959971 | 40.77029094543921 | 7F-AM-1008-05 | 07F | AM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | bush | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9730454295997 40.7702909454392) | ||||
1367 | 1367 | -73.9542684235907 | 40.7944237164092 | 38G-PM-1020-05 | 38G | PM | 10202018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9542684235907 40.7944237164092) | ||||
1403 | 1403 | -73.9761632586697 | 40.7741085606149 | 9B-PM-1013-05 | 09B | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9761632586697 40.7741085606149) | ||||
1491 | 1491 | -73.97130702170709 | 40.7753795014815 | 12E-AM-1017-05 | 12E | AM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9713070217071 40.7753795014815) | ||||
1574 | 1574 | -73.95618409358029 | 40.799203782149704 | 42C-PM-1013-05 | 42C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9561840935803 40.7992037821497) | |||||
1604 | 1604 | -73.9734644470766 | 40.7782766486921 | 14A-PM-1014-05 | 14A | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97346444707661 40.7782766486921) | ||||
1682 | 1682 | -73.97592584072879 | 40.7667622711142 | 2F-PM-1014-05 | 02F | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9759258407288 40.7667622711142) | |||||
1695 | 1695 | -73.9604083891356 | 40.7910284106931 | 32D-AM-1013-05 | 32D | AM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9604083891356 40.7910284106931) | ||||
1705 | 1705 | -73.97654172820009 | 40.7740994735325 | 9A-AM-1013-05 | 09A | AM | 10132018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765417282001 40.7740994735325) | ||||
1735 | 1735 | -73.9563652303243 | 40.795512787396795 | 38E-PM-1014-05 | 38E | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | on log | 0 | 0 | 0 | 0 | 0 | statue | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9563652303243 40.7955127873968) | ||
1856 | 1856 | -73.97829402311491 | 40.7694236097224 | 4B-PM-1018-05 | 04B | PM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9782940231149 40.7694236097224) | |||||
1995 | 1995 | -73.9603366992925 | 40.7899612889539 | 31E-PM-1006-05 | 31E | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9603366992925 40.789961288953904) | ||||
2032 | 2032 | -73.9590157104896 | 40.7956884493421 | 37C-PM-1013-05 | 37C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9590157104896 40.7956884493421) | |||||
2167 | 2167 | -73.9799594281222 | 40.7701978146968 | 4A-AM-1007-05 | 04A | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9799594281222 40.7701978146968) | |||||
2581 | 2581 | -73.9635981227569 | 40.7928169540326 | 32A-AM-1018-05 | 32A | AM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9635981227569 40.7928169540326) | |||||
2800 | 2800 | -73.9802983138318 | 40.7676540772339 | 1B-PM-1019-05 | 01B | PM | 10192018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9802983138318 40.7676540772339) | ||||
2917 | 2917 | -73.9770313887741 | 40.7724869252099 | 7B-AM-1008-05 | 07B | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770313887741 40.772486925209904) | ||||||
2923 | 2923 | -73.9672160533827 | 40.7830263908749 | 21C-AM-1014-05 | 21C | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9672160533827 40.7830263908749) | ||||
2970 | 2970 | -73.9619019299709 | 40.7924476439693 | 33B-PM-1010-05 | 33B | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9619019299709 40.7924476439693) |
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 );