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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2461 | 2461 | -73.9605347462123 | 40.794207544838706 | 35B-AM-1010-04 | 35B | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | lawn | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9605347462123 40.7942075448387) | |||
2514 | 2514 | -73.95744422055 | 40.7961046528557 | 38D-AM-1017-04 | 38D | AM | 10172018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95744422055 40.7961046528557) | ||||
2521 | 2521 | -73.976869549792 | 40.770698245472296 | 5C-AM-1006-04 | 05C | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 12 | thin branch of tree | 0 | 0 | 0 | 0 | 0 | relaxing | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.976869549792 40.7706982454723) | ||
2555 | 2555 | -73.9613127978423 | 40.79293215045679 | 33B-AM-1010-04 | 33B | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9613127978423 40.7929321504568) | |||||
2560 | 2560 | -73.97554590905341 | 40.7680866624003 | 4E-AM-1020-04 | 04E | AM | 10202018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | chillin' | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9755459090534 40.7680866624003) | |||
2619 | 2619 | -73.9739737592602 | 40.772713047677705 | 9D-AM-1008-04 | 09D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9739737592602 40.7727130476777) | |||||
2634 | 2634 | -73.96956851864891 | 40.7788293026327 | 16D-AM-1007-04 | 16D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9695685186489 40.7788293026327) | |||||
2654 | 2654 | -73.9549261242548 | 40.7944701994615 | 37G-AM-1014-04 | 37G | AM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9549261242548 40.7944701994615) | ||||
2667 | 2667 | -73.9759510842771 | 40.769288289110996 | 5D-AM-1020-04 | 05D | AM | 10202018 | 4 | Adult | Gray | Black, White | Gray+Black, White | White selected as Primary. Black selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9759510842771 40.76928828911101) | |||
2738 | 2738 | -73.9691801791373 | 40.770927235357206 | 9I-AM-1014-04 | 09I | AM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9691801791373 40.7709272353572) | ||||
2744 | 2744 | -73.9752915601718 | 40.7739329570033 | 9B-AM-1010-04 | 09B | AM | 10102018 | 4 | + | Above Ground | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9752915601718 40.7739329570033) | |||||||
2754 | 2754 | -73.9687025912431 | 40.7719319822619 | 10H-AM-1014-04 | 10H | AM | 10142018 | 4 | Juvenile | + | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687025912431 40.7719319822619) | ||||||
2790 | 2790 | -73.9673554935258 | 40.782752724959394 | 21C-AM-1014-04 | 21C | AM | 10142018 | 4 | Adult | + | High in tree, unable to tell | Above Ground | 60 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.96735549352582 40.7827527249594) | |||||
2809 | 2809 | -73.9686756254868 | 40.777745910265104 | 16E-AM-1014-04 | 16E | AM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9686756254868 40.7777459102651) | ||||
2828 | 2828 | -73.9587439756541 | 40.7849006107353 | 27I-AM-1007-04 | 27I | AM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9587439756541 40.7849006107353) | ||||
2850 | 2850 | -73.9744847446854 | 40.76924227444 | 5E-AM-1008-04 | 05E | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744847446854 40.76924227444) | |||||
2866 | 2866 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 10172018 | 4 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744025383371 40.7777296605765) | |||||||
2884 | 2884 | -73.9598378495787 | 40.7956843021662 | 37B-AM-1018-04 | 37B | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9598378495787 40.7956843021662) | |||||
2906 | 2906 | -73.9597260014375 | 40.790707423031 | 32E-AM-1007-04 | 32E | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9597260014375 40.790707423031) | ||||
2918 | 2918 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.76554155159081) | |||||
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) | ||||
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) | ||||
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) |
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 );