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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1731 | 1731 | -73.9692846326638 | 40.7841049008492 | 22A-PM-1017-02 | 22A | PM | 10172018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9692846326638 40.7841049008492) | |||||
2698 | 2698 | -73.9744917362668 | 40.77783887377 | 13A-AM-1017-02 | 13A | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744917362668 40.77783887377) | |||||
442 | 442 | -73.9502466289084 | 40.795922877988296 | 41I-AM-1018-02 | 41I | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | runs off | POINT (-73.9502466289084 40.7959228779883) | ||||
469 | 469 | -73.9717201378775 | 40.776120280884 | 13D-PM-1018-02 | 13D | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9717201378775 40.776120280884) | ||||
529 | 529 | -73.96352907511829 | 40.7820936628202 | 22G-AM-1018-02 | 22G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9635290751183 40.7820936628202) | |||||
771 | 771 | -73.9648626810032 | 40.7804506112843 | 20G-AM-1018-02 | 20G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | Ran up tree | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9648626810032 40.7804506112843) | ||||
995 | 995 | -73.9698843507358 | 40.780375418758105 | 18C-PM-1018-02 | 18C | PM | 10182018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9698843507358 40.7803754187581) | ||||
1370 | 1370 | -73.9681627331154 | 40.7785099665602 | 17E-PM-1018-02 | 17E | PM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | On the rock | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9681627331154 40.7785099665602) | ||||
1451 | 1451 | -73.9645365195454 | 40.778153102126296 | 18H-AM-1018-02 | 18H | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Tree | 1 | 1 | 0 | 0 | 0 | playing? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9645365195454 40.7781531021263) | |||
1539 | 1539 | -73.9681874036914 | 40.7817948690964 | 20C-PM-1018-02 | 20C | PM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681874036914 40.7817948690964) | |||||
1895 | 1895 | -73.954699659637 | 40.7951308856929 | 38F-AM-1018-02 | 38F | AM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.954699659637 40.7951308856929) | ||||
1989 | 1989 | -73.96316467546471 | 40.7925716810884 | 32A-AM-1018-02 | 32A | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631646754647 40.7925716810884) | |||||
2444 | 2444 | -73.966590487009 | 40.780246905289104 | 19E-PM-1018-02 | 19E | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.96659048700901 40.7802469052891) | ||||
2543 | 2543 | -73.96914249979191 | 40.780542852496 | 18C-AM-1018-02 | 18C | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691424997919 40.780542852496) | ||||
2611 | 2611 | -73.951448051873 | 40.7973951649254 | 42G-AM-1018-02 | 42G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.951448051873 40.7973951649254) | |||||
2838 | 2838 | -73.9507699667119 | 40.7955166039555 | 40I-AM-1018-02 | 40I | AM | 10182018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507699667119 40.795516603955505) | |||||
172 | 172 | -73.958535640774 | 40.7982737896998 | 40B-AM-1019-02 | 40B | AM | 10192018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.958535640774 40.7982737896998) | ||||
209 | 209 | -73.97107601968679 | 40.7725506006789 | 10F-PM-1019-02 | 10F | PM | 10192018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Ground Plane | FALSE | Behind fence, grass | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9710760196868 40.7725506006789) | ||
1186 | 1186 | -73.96740331258341 | 40.7769132902037 | 15G-PM-1019-02 | 15G | PM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674033125834 40.7769132902037) | ||||
1613 | 1613 | -73.95992022335359 | 40.7972599930224 | 38A-AM-1019-02 | 38A | AM | 10192018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599202233536 40.7972599930224) | |||||
1956 | 1956 | -73.98089749771201 | 40.7690578709841 | 2A-PM-1019-02 | 02A | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.980897497712 40.7690578709841) | ||||
2320 | 2320 | -73.9576897478787 | 40.796469532845705 | 38C-AM-1019-02 | 38C | AM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9576897478787 40.7964695328457) | ||||
2688 | 2688 | -73.9799302952205 | 40.767720720979796 | 1B-PM-1019-02 | 01B | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9799302952205 40.7677207209798) | ||||
2904 | 2904 | -73.97203897567171 | 40.7763524091989 | 13C-PM-1019-02 | 13C | PM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9720389756717 40.7763524091989) | |||||
7 | 7 | -73.9719735582476 | 40.769304513357795 | 6G-PM-1020-02 | 06G | PM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9719735582476 40.7693045133578) | |||||
264 | 264 | -73.9698714743386 | 40.7743814661685 | 12F-AM-1020-02 | 12F | AM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9698714743386 40.7743814661685) | |||||
1047 | 1047 | -73.9580111056675 | 40.785433940148295 | 27I-PM-1020-02 | 27I | PM | 10202018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9580111056675 40.7854339401483) |
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 );