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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1677 | 1677 | -73.9594332600733 | 40.7960622445291 | 37B-PM-1013-02 | 37B | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9594332600733 40.7960622445291) | ||||
1691 | 1691 | -73.9703705008688 | 40.7818586173755 | 19B-PM-1018-02 | 19B | PM | 10182018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703705008688 40.7818586173755) | |||
1708 | 1708 | -73.9618486459307 | 40.7946365810826 | 35A-AM-1014-02 | 35A | AM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9618486459307 40.7946365810826) | ||||
1720 | 1720 | -73.9725844658514 | 40.7701092834201 | 7F-PM-1012-02 | 07F | PM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | observes | POINT (-73.9725844658514 40.7701092834201) | |||
1732 | 1732 | -73.97671414072741 | 40.7737313251559 | 8A-PM-1014-02 | 08A | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (goes up a tree) | POINT (-73.9767141407274 40.7737313251559) | ||||
1776 | 1776 | -73.9562350820255 | 40.7913464147989 | 34G-PM-1006-02 | 34G | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 1 | 1 | 1 | eating bread it found on ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9562350820255 40.7913464147989) | ||||
1853 | 1853 | -73.9721210372896 | 40.7667971476099 | 4I-AM-1006-02 | 04I | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721210372896 40.7667971476099) | ||||
1885 | 1885 | -73.9594174605642 | 40.7973128653773 | 38B-AM-1019-02 | 38B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9594174605642 40.7973128653773) | ||||
1934 | 1934 | -73.969756965598 | 40.7786455091699 | 16D-PM-1010-02 | 16D | PM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969756965598 40.7786455091699) | |||||
1936 | 1936 | -73.9667911565238 | 40.779321901098 | 18F-AM-1014-02 | 18F | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | In small tree by water | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9667911565238 40.77932190109801) | ||||
1971 | 1971 | -73.9591880400132 | 40.795007125283604 | 36C-PM-1013-02 | 36C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95918804001322 40.7950071252836) | ||||
1990 | 1990 | -73.9774584305147 | 40.770813398619204 | 5B-AM-1008-02 | 05B | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9774584305147 40.7708133986192) | ||||
2040 | 2040 | -73.96481673340891 | 40.7811164976329 | 20F-PM-1007-02 | 20F | PM | 10072018 | 2 | Adult | Gray | White | Gray+White | white on tail | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | digging one hole w/ determination | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.96481673340891 40.7811164976329) | ||
2048 | 2048 | -73.96276614653759 | 40.7819356810575 | 22G-PM-1018-02 | 22G | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9627661465376 40.7819356810575) | ||||
2093 | 2093 | -73.9597994674082 | 40.797298837759 | 38A-PM-1013-02 | 38A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9597994674082 40.797298837759) | ||||
2208 | 2208 | -73.96149727573321 | 40.7921404951324 | 33C-PM-1007-02 | 33C | PM | 10072018 | 2 | Adult | Gray | Black, White | Gray+Black, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9614972757332 40.7921404951324) | ||||
2222 | 2222 | -73.9639048209454 | 40.777737334555795 | 18I-PM-1007-02 | 18I | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | 0 | 0 | 1 | 1 | 1 | hanging upside down | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9639048209454 40.7777373345558) | |||
2229 | 2229 | -73.9620719414292 | 40.788637452988 | 29D-PM-1010-02 | 29D | PM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9620719414292 40.788637452988) | ||||
2231 | 2231 | -73.95454276114769 | 40.793035381744104 | 36G-PM-1012-02 | 36G | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9545427611477 40.7930353817441) | ||||
2263 | 2263 | -73.95693753558841 | 40.793539800861204 | 36E-AM-1013-02 | 36E | AM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569375355884 40.7935398008612) | |||||
2337 | 2337 | -73.9673490137465 | 40.778272813040104 | 17F-PM-1020-02 | 17F | PM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9673490137465 40.7782728130401) | ||||
2352 | 2352 | -73.9727310397798 | 40.778701677351705 | 15B-PM-1017-02 | 15B | PM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | tree | 0 | 0 | 1 | 1 | 1 | digging,chewing on tree—has nut in mouth! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97273103977982 40.7787016773517) | ||
2370 | 2370 | -73.9573119777312 | 40.7875347862766 | 30H-AM-1007-02 | 30H | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | following #1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9573119777312 40.7875347862766) | ||||
2380 | 2380 | -73.97613757295049 | 40.766223189212496 | 1F-PM-1019-02 | 01F | PM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9761375729505 40.7662231892125) | ||||
2398 | 2398 | -73.95871384837301 | 40.7963918051751 | 38C-PM-1014-02 | 38C | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.958713848373 40.7963918051751) | ||||
2430 | 2430 | -73.9569811285656 | 40.793091234605 | 35F-PM-1012-02 | 35F | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9569811285656 40.793091234605) | ||||
2470 | 2470 | -73.96388775886999 | 40.79154773042521 | 31A-AM-1010-02 | 31A | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | scratching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96388775887 40.7915477304252) | ||||
2510 | 2510 | -73.9748635473782 | 40.7742591029151 | 10C-AM-1018-02 | 10C | AM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | sitting in the sun | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9748635473782 40.7742591029151) | |||
2511 | 2511 | -73.95845615374209 | 40.791121116475395 | 33F-PM-1012-02 | 33F | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9584561537421 40.7911211164754) | ||||
2551 | 2551 | -73.970138810251 | 40.770579297644 | 8H-PM-1014-02 | 08H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | froze & watched me,then went back to eating | POINT (-73.970138810251 40.770579297644) | |||
2578 | 2578 | -73.97653869653709 | 40.766371971272996 | 1F-AM-1010-02 | 01F | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765386965371 40.766371971273) | |||||
2615 | 2615 | -73.97346051766459 | 40.7686218881386 | 5G-PM-1010-02 | 05G | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9734605176646 40.7686218881386) | ||||
2626 | 2626 | -73.9737329655838 | 40.7726424441344 | 8D-PM-1007-02 | 08D | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9737329655838 40.7726424441344) | ||||
2677 | 2677 | -73.97348276186 | 40.7656171832911 | 2H-PM-1006-02 | 02H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97348276186 40.7656171832911) | |||||
2683 | 2683 | -73.972179947936 | 40.7810042827198 | 17A-PM-1013-02 | 17A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | on a little pedestal-shaped part of a tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.972179947936 40.7810042827198) | |||
2783 | 2783 | -73.97917671562679 | 40.7714445258765 | 5A-AM-1006-02 | 05A | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | in tall shrubs near wall next to CPW | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9791767156268 40.7714445258765) | |||
2785 | 2785 | -73.9729105002306 | 40.7672758037086 | 4H-PM-1006-02 | 04H | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729105002306 40.7672758037086) | ||||
2846 | 2846 | -73.96615704780291 | 40.7807271518813 | 20E-AM-1014-02 | 20E | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9661570478029 40.7807271518813) | ||||
2885 | 2885 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530811255728 40.79830691185791) | ||||
2916 | 2916 | -73.95175251116791 | 40.7974407641075 | 42G-PM-1014-02 | 42G | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 14 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9517525111679 40.7974407641075) | ||||
2947 | 2947 | -73.96012151981141 | 40.7909769801241 | 32D-PM-1006-02 | 32D | PM | 10062018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9601215198114 40.7909769801241) | ||||
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) | |||||
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 );