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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2357 | 2357 | -73.96323010348829 | 40.7925707244111 | 32A-PM-1013-06 | 32A | PM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9632301034883 40.7925707244111) | ||||
2366 | 2366 | -73.96761918469849 | 40.777641740816996 | 16F-PM-1013-04 | 16F | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9676191846985 40.777641740817) | ||||
2371 | 2371 | -73.9769520212123 | 40.774006725862996 | 9A-AM-1013-01 | 09A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9769520212123 40.774006725863) | ||||
2423 | 2423 | -73.973552877209 | 40.7715638228207 | 7E-PM-1013-01 | 07E | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.973552877209 40.7715638228207) | |||
2434 | 2434 | -73.9545912098958 | 40.7948301813102 | 38F-PM-1013-06 | 38F | PM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9545912098958 40.7948301813102) | ||||
2446 | 2446 | -73.95227045119691 | 40.796566887896105 | 41G-AM-1013-01 | 41G | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9522704511969 40.7965668878961) | ||||
2473 | 2473 | -73.9613347295946 | 40.7938900965153 | 34B-AM-1013-02 | 34B | AM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9613347295946 40.7938900965153) | ||||
2520 | 2520 | -73.95482071063391 | 40.7946991812402 | 38F-PM-1013-04 | 38F | PM | 10132018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9548207106339 40.7946991812402) | ||||
2530 | 2530 | -73.95610768244549 | 40.7981145780509 | 40D-AM-1013-01 | 40D | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9561076824455 40.7981145780509) | ||||
2562 | 2562 | -73.9615643742864 | 40.7944678447843 | 35B-PM-1013-06 | 35B | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | chased by dog #2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9615643742864 40.7944678447843) | ||
2585 | 2585 | -73.9771726831497 | 40.7732320781799 | 8A-AM-1013-01 | 08A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | trail | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9771726831497 40.7732320781799) | |||
2622 | 2622 | -73.96971595629441 | 40.773067141765296 | 11G-PM-1013-02 | 11G | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Near Summerstage | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9697159562944 40.7730671417653) | |||
2664 | 2664 | -73.95983503855409 | 40.7973274000224 | 38A-PM-1013-04 | 38A | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9598350385541 40.7973274000224) | ||||
2668 | 2668 | -73.95486485185579 | 40.7946730924872 | 38F-PM-1013-03 | 38F | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9548648518558 40.7946730924872) | ||||
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) | |||
2700 | 2700 | -73.9601988871514 | 40.7943473161329 | 35C-PM-1013-01 | 35C | PM | 10132018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9601988871514 40.7943473161329) | |||||
2711 | 2711 | -73.96288429601181 | 40.793804857240296 | 34A-PM-1013-01 | 34A | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | took a chestnut | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9628842960118 40.7938048572403) | |||
2720 | 2720 | -73.9566300789162 | 40.7993692120774 | 42C-PM-1013-06 | 42C | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Between park and main drag | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9566300789162 40.7993692120774) | |||
2798 | 2798 | -73.9753825640019 | 40.767166201386104 | 3F-PM-1013-04 | 03F | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9753825640019 40.7671662013861) | ||||
2810 | 2810 | -73.9614659899028 | 40.7945562907624 | 35A-PM-1013-10 | 35A | PM | 10132018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9614659899028 40.7945562907624) | ||||
2812 | 2812 | -73.963209639301 | 40.7926138443715 | 32A-PM-1013-07 | 32A | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.963209639301 40.7926138443715) | ||||
2845 | 2845 | -73.9765016413674 | 40.77406728629529 | 9A-AM-1013-06 | 09A | AM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765016413674 40.7740672862953) | ||||
2969 | 2969 | -73.9654409838612 | 40.7901338748522 | 29A-AM-1013-01 | 29A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | climbed tree (oak) | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9654409838612 40.7901338748522) | |||
2985 | 2985 | -73.9721159387757 | 40.766050318863705 | 3I-PM-1013-03 | 03I | PM | 10132018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9721159387757 40.7660503188637) | ||||
271 | 271 | -73.9661262885099 | 40.7844085550945 | 23D-AM-1013-01 | 23D | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (he saw me,came towards,then darted up) | POINT (-73.9661262885099 40.7844085550945) | |||
478 | 478 | -73.954482814186 | 40.7987031768001 | 42D-PM-1013-01 | 42D | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Drawing included. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | watching passers-by | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.954482814186 40.7987031768001) | ||
515 | 515 | -73.9601486483164 | 40.7943724108626 | 35C-PM-1013-02 | 35C | PM | 10132018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (when i crouched down) | POINT (-73.9601486483164 40.7943724108626) | ||||
797 | 797 | -73.969345754447 | 40.7770429650288 | 15E-AM-1013-02 | 15E | AM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.969345754447 40.7770429650288) | ||||
1205 | 1205 | -73.9611118778753 | 40.7952007875354 | 36A-PM-1013-01 | 36A | PM | 10132018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9611118778753 40.7952007875354) | ||||
1533 | 1533 | -73.95200246546021 | 40.794732982815496 | 39I-PM-1013-04 | 39I | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Gray & Cinnamon selected as both Primary and Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.95200246546021 40.7947329828155) | ||
2161 | 2161 | -73.9715375915057 | 40.7751212088827 | 12D-AM-1013-01 | 12D | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9715375915057 40.7751212088827) | ||||
2275 | 2275 | -73.96142184133559 | 40.793894505879294 | 34B-AM-1013-01 | 34B | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | hopping | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9614218413356 40.7938945058793) |
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 );