This data as json, CSV (advanced)
Highlight Fur Color ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
439 | 439 | -73.9589770206691 | 40.791240542172 | 33E-AM-1014-05 | 33E | AM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589770206691 40.791240542172) | ||||
2061 | 2061 | -73.9608834102446 | 40.790624710005005 | 31D-AM-1014-05 | 31D | AM | 10142018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9608834102446 40.790624710005) | ||||
1382 | 1382 | -73.9611274898661 | 40.7915250069086 | 32C-AM-1014-05 | 32C | AM | 10142018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9611274898661 40.7915250069086) | |||||
277 | 277 | -73.96190702296741 | 40.795255669250004 | 35A-AM-1014-05 | 35A | AM | 10142018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9619070229674 40.79525566925) | ||||
2196 | 2196 | -73.96233563694321 | 40.7888693815168 | 29D-AM-1014-05 | 29D | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Rocky area | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9623356369432 40.7888693815168) | |||
2940 | 2940 | -73.963911430308 | 40.7809127228847 | 21G-AM-1014-05 | 21G | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.963911430308 40.7809127228847) | ||||
37 | 37 | -73.96431539204279 | 40.78208185169571 | 22F-PM-1014-05 | 22F | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9643153920428 40.7820818516957) | ||||
2157 | 2157 | -73.9657171357842 | 40.7773277532224 | 16H-PM-1014-05 | 16H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 5 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9657171357842 40.7773277532224) | |||
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) | ||||
213 | 213 | -73.968367485157 | 40.7838472644815 | 22B-PM-1014-05 | 22B | PM | 10142018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | eating (eats with head tilted far to the right (tooth issue?)) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.968367485157 40.7838472644815) | ||||
2899 | 2899 | -73.9686358129525 | 40.7778035516486 | 16E-AM-1014-05 | 16E | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686358129525 40.7778035516486) | ||||
397 | 397 | -73.9690416961886 | 40.7716618670996 | 10H-AM-1014-05 | 10H | AM | 10142018 | 5 | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9690416961886 40.7716618670996) | ||||||
2464 | 2464 | -73.96913180449691 | 40.770980197469605 | 9I-AM-1014-05 | 09I | AM | 10142018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9691318044969 40.7709801974696) | |||||
341 | 341 | -73.9703161745884 | 40.7702610461336 | 8H-PM-1014-05 | 08H | PM | 10142018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9703161745884 40.7702610461336) | |||||
1800 | 1800 | -73.970962498391 | 40.7766899040856 | 14D-AM-1014-05 | 14D | AM | 10142018 | 5 | 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.970962498391 40.7766899040856) | ||||
2805 | 2805 | -73.9711634340673 | 40.7760553338671 | 13D-AM-1014-05 | 13D | AM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711634340673 40.7760553338671) | ||||
735 | 735 | -73.971379936565 | 40.7721434941226 | 9F-PM-1014-05 | 09F | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.971379936565 40.7721434941226) | ||||
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) | ||||
793 | 793 | -73.9730111650468 | 40.7782157736204 | 14B-PM-1014-05 | 14B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9730111650468 40.7782157736204) | |||||
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) | ||||
128 | 128 | -73.97462290946429 | 40.7748467061969 | 10B-PM-1014-05 | 10B | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | avoided people | POINT (-73.9746229094643 40.7748467061969) | |||
66 | 66 | -73.9749243901189 | 40.7761393551781 | 11B-PM-1014-05 | 11B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9749243901189 40.7761393551781) | |||||
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) | |||||
263 | 263 | -73.9771069181511 | 40.76705382149879 | 2E-PM-1014-05 | 02E | PM | 10142018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771069181511 40.7670538214988) | ||||
2936 | 2936 | -73.9809876538513 | 40.768322324214296 | 1A-PM-1014-05 | 01A | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9809876538513 40.7683223242143) |
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 );