This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2961 | 2961 | -73.9736238258579 | 40.7688712771191 | 5F-PM-1007-04 | 05F | PM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9736238258579 40.7688712771191) | ||||
2962 | 2962 | -73.9722530826293 | 40.7667138028361 | 3I-AM-1010-05 | 03I | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722530826293 40.7667138028361) | |||||
2963 | 2963 | -73.9687020800791 | 40.7735903424522 | 11H-AM-1010-08 | 11H | AM | 10102018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9687020800791 40.7735903424522) | ||||
2964 | 2964 | -73.9703604542938 | 40.776269022329394 | 13E-AM-1017-04 | 13E | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9703604542938 40.7762690223294) | |||||
2966 | 2966 | -73.9630596103391 | 40.792572062055605 | 32A-AM-1018-04 | 32A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | Base of tree | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9630596103391 40.7925720620556) | ||||
2967 | 2967 | -73.97132575863719 | 40.776271961946705 | 13D-AM-1014-09 | 13D | AM | 10142018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9713257586372 40.7762719619467) | ||||
2968 | 2968 | -73.9587236619579 | 40.799185018043396 | 40A-AM-1010-02 | 40A | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park at 108th West | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9587236619579 40.7991850180434) | |||
2969 | 2969 | -73.9654409838612 | 40.7901338748522 | 29A-AM-1013-01 | 29A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | climbed tree (oak) | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9654409838612 40.7901338748522) | |||
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) | |||||
2972 | 2972 | -73.9631468456897 | 40.7926110399714 | 32A-AM-1018-03 | 32A | AM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631468456897 40.7926110399714) | |||||
2973 | 2973 | -73.9766693184436 | 40.7708879215854 | 6C-PM-1020-01 | 06C | PM | 10202018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Across Transverse | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766693184436 40.7708879215854) | |||
2977 | 2977 | -73.95806816485471 | 40.799201001265295 | 41B-AM-1010-01 | 41B | AM | 10102018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9580681648547 40.7992010012653) | ||||
2978 | 2978 | -73.96888170064429 | 40.7829120321438 | 20B-PM-1013-09 | 20B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9688817006443 40.7829120321438) | ||||
2979 | 2979 | -73.9571808775915 | 40.793444386672505 | 35E-AM-1020-02 | 35E | AM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | 0 | 0 | 0 | 0 | 0 | cleaning herself | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9571808775915 40.7934443866725) | |||
2980 | 2980 | -73.97164145863809 | 40.771760114722 | 9F-PM-1014-06 | 09F | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | running (from birds) | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9716414586381 40.771760114722) | |||
2981 | 2981 | -73.9800094828465 | 40.7677782585639 | 1B-AM-1012-04 | 01B | AM | 10122018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9800094828465 40.7677782585639) | |||||
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) | |||
2983 | 2983 | -73.9689586689061 | 40.7839613907139 | 21B-PM-1017-04 | 21B | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9689586689061 40.7839613907139) | ||||
2984 | 2984 | -73.9700158929437 | 40.7762359066591 | 14E-AM-1008-18 | 14E | AM | 10082018 | 18 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9700158929437 40.7762359066591) | |||||
2987 | 2987 | -73.9563724838337 | 40.7882504581015 | 31I-PM-1019-04 | 31I | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95637248383372 40.7882504581015) | |||||
2988 | 2988 | -73.9766342759486 | 40.7687518380873 | 4D-AM-1012-04 | 04D | AM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9766342759486 40.7687518380873) | ||||
2990 | 2990 | -73.97660121083071 | 40.7712310725379 | 6C-AM-1007-05 | 06C | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 1 | 1 | 0 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766012108307 40.7712310725379) | ||||
2991 | 2991 | -73.96846326736029 | 40.784890952519795 | 23A-AM-1018-05 | 23A | AM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9684632673603 40.7848909525198) | |||||
2993 | 2993 | -73.95707222626929 | 40.798570614351895 | 40C-AM-1017-04 | 40C | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | chasing (#3) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9570722262693 40.7985706143519) | |||
2994 | 2994 | -73.96172070912449 | 40.792283902593496 | 33B-AM-1010-01 | 33B | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9617207091245 40.7922839025935) | ||||
2995 | 2995 | -73.9668442742942 | 40.7870781042595 | 25B-PM-1007-01 | 25B | PM | 10072018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9668442742942 40.7870781042595) | |||||
2996 | 2996 | -73.970033345821 | 40.777259393859 | 15E-PM-1008-08 | 15E | PM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970033345821 40.777259393859) | |||||
2997 | 2997 | -73.96197353854829 | 40.7944667974974 | 35A-PM-1013-01 | 35A | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9619735385483 40.7944667974974) | ||||
3000 | 3000 | -73.9688293382172 | 40.7738958027568 | 12G-AM-1012-04 | 12G | AM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9688293382172 40.773895802756805) | ||||
3001 | 3001 | -73.97755922284159 | 40.7668485329273 | 1D-PM-1007-01 | 01D | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9775592228416 40.7668485329273) | ||||
3002 | 3002 | -73.9710991846972 | 40.768982782424104 | 6H-PM-1020-01 | 06H | PM | 10202018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710991846972 40.7689827824241) | ||||
3005 | 3005 | -73.96161411525391 | 40.7921803313341 | 33C-PM-1007-04 | 33C | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9616141152539 40.7921803313341) | ||||
3006 | 3006 | -73.97443902173859 | 40.7663168362582 | 2G-AM-1010-02 | 02G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744390217386 40.7663168362582) | |||||
3007 | 3007 | -73.9635140434993 | 40.7912807969365 | 31B-AM-1017-01 | 31B | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9635140434993 40.7912807969365) | |||||
3008 | 3008 | -73.9503533343658 | 40.7976543603953 | 42H-PM-1014-04 | 42H | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9503533343658 40.7976543603953) | ||||
3009 | 3009 | -73.9675637870968 | 40.782388067172796 | 21D-PM-1008-02 | 21D | PM | 10082018 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675637870968 40.7823880671728) | |||||
3010 | 3010 | -73.9580906814132 | 40.7948404060484 | 37D-PM-1014-01 | 37D | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | eyes from a safe distance | POINT (-73.9580906814132 40.7948404060484) | |||
3011 | 3011 | -73.96788313129359 | 40.7847605974975 | 23B-PM-1012-06 | 23B | PM | 10122018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | scolding | POINT (-73.9678831312936 40.7847605974975) | ||||
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) | |||
3013 | 3013 | -73.964661337306 | 40.7769785494935 | 17I-AM-1014-03 | 17I | AM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon face | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | climbing (dog barked & it ran up tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.964661337306 40.7769785494935) | ||
3014 | 3014 | -73.9665572004288 | 40.780434754830296 | 19E-PM-1018-04 | 19E | PM | 10182018 | 4 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665572004288 40.7804347548303) | ||||||
3015 | 3015 | -73.97591633005351 | 40.7736180793606 | 9B-AM-1010-08 | 09B | AM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon head, White (Almost Silver) | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9759163300535 40.7736180793606) | |||
3016 | 3016 | -73.9756457597888 | 40.7703559775625 | 6D-PM-1020-02 | 06D | PM | 10202018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9756457597888 40.7703559775625) | |||||
3017 | 3017 | -73.9662895079734 | 40.7843300758044 | 23C-AM-1019-01 | 23C | AM | 10192018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 7 | 0 | 0 | 1 | 1 | 0 | eating (on branch) | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662895079734 40.7843300758044) | ||
3019 | 3019 | -73.9639431360458 | 40.7908677445466 | 30B-AM-1007-04 | 30B | AM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9639431360458 40.7908677445466) | |||||
3020 | 3020 | -73.97040158596391 | 40.7825600069973 | 19A-PM-1013-05 | 19A | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9704015859639 40.7825600069973) | ||||
3021 | 3021 | -73.96658719935171 | 40.783677506488296 | 22D-PM-1012-07 | 22D | PM | 10122018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665871993517 40.7836775064883) | ||||
3022 | 3022 | -73.9639941227864 | 40.7899152327912 | 29B-PM-1010-02 | 29B | PM | 10102018 | 2 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9639941227864 40.7899152327912) |
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 );