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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1389 | 1389 | -73.9580021017892 | 40.7955140102242 | 37D-PM-1014-07 | 37D | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9580021017892 40.7955140102242) | |||||
2057 | 2057 | -73.9579659543224 | 40.7905646887034 | 32F-AM-1012-07 | 32F | AM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9579659543224 40.7905646887034) | ||||
134 | 134 | -73.9575943815564 | 40.7933755266787 | 35E-PM-1006-07 | 35E | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9575943815564 40.7933755266787) | |||||
1334 | 1334 | -73.957134662576 | 40.7872395604122 | 30I-PM-1006-07 | 30I | PM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.957134662576 40.7872395604122) | ||||
188 | 188 | -73.9570528770427 | 40.7990973804149 | 41B-AM-1010-07 | 41B | AM | 10102018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | mad! | POINT (-73.9570528770427 40.7990973804149) | |||
2193 | 2193 | -73.95693181052529 | 40.7973442139041 | 40C-PM-1006-07 | 40C | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569318105253 40.7973442139041) | |||||
642 | 642 | -73.9568382279233 | 40.7975685470963 | 40C-AM-1017-07 | 40C | AM | 10172018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9568382279233 40.7975685470963) | |||
2454 | 2454 | -73.9565151662506 | 40.794664798744705 | 37E-PM-1006-07 | 37E | PM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | me | POINT (-73.9565151662506 40.7946647987447) | |||
2746 | 2746 | -73.95614328368629 | 40.798266534723396 | 41C-AM-1017-07 | 41C | AM | 10172018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9561432836863 40.7982665347234) | ||||
547 | 547 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9559677963727 40.7951124076946) | ||
2179 | 2179 | -73.95596639495109 | 40.7974497269789 | 40D-AM-1013-07 | 40D | AM | 10132018 | 7 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | curious | POINT (-73.9559663949511 40.7974497269789) | ||||
1656 | 1656 | -73.9557399927792 | 40.7971563708988 | 40D-PM-1013-07 | 40D | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9557399927792 40.7971563708988) | ||||
1999 | 1999 | -73.95498609472341 | 40.79115503283089 | 34H-PM-1006-07 | 34H | PM | 10062018 | 7 | Juvenile | Gray | White | Gray+White | white belly | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9549860947234 40.7911550328309) | |||
284 | 284 | -73.9547336666137 | 40.7938937756332 | 37G-PM-1007-07 | 37G | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9547336666137 40.7938937756332) | ||||
322 | 322 | -73.9546042927016 | 40.7898133734952 | 33I-PM-1006-07 | 33I | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9546042927016 40.7898133734952) | |||||
2080 | 2080 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 10102018 | 7 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954530253849 40.7910247489879) | |||||||
2759 | 2759 | -73.9543373703455 | 40.7943889087123 | 38G-PM-1020-07 | 38G | PM | 10202018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9543373703455 40.7943889087123) | ||||
853 | 853 | -73.9534509627885 | 40.7921084224711 | 36I-AM-1017-07 | 36I | AM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (#8),scratching | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9534509627885 40.7921084224711) | |||
327 | 327 | -73.95343062916791 | 40.7959052073753 | 39G-PM-1013-07 | 39G | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9534306291679 40.7959052073753) | ||||
76 | 76 | -73.9530035564643 | 40.792182245761296 | 36I-PM-1007-07 | 36I | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530035564643 40.7921822457613) |
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 );