This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Climbing, Eating, Foraging, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches
Other Activities ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
111 | 111 | -73.9763243383771 | 40.770540931570295 | 5C-PM-1010-13 | 05C | PM | 10102018 | 13 | Adult | Gray | White | Gray+White | Above Ground | 20 | way up a tree! | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9763243383771 40.7705409315703) | |||
113 | 113 | -73.9700100617602 | 40.7815739959357 | 19B-PM-1018-01 | 19B | PM | 10182018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 20 | 1 | 0 | 0 | 0 | 0 | flying | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9700100617602 40.7815739959357) | |||
306 | 306 | -73.96897001002671 | 40.7775169562765 | 15E-PM-1008-05 | 15E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9689700100267 40.7775169562765) | ||||
555 | 555 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685227310735 40.776599466588) | |||
698 | 698 | -73.95855376683821 | 40.7903905787005 | 32F-AM-1012-03 | 32F | AM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | bringing green leaves to nest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9585537668382 40.7903905787005) | |||
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) | ||||
917 | 917 | -73.9676514056678 | 40.7730853732876 | 11H-AM-1010-01 | 11H | AM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | started climbing down to me | POINT (-73.9676514056678 40.7730853732876) | |||
1079 | 1079 | -73.9722737593623 | 40.768963018754 | 6G-AM-1008-04 | 06G | AM | 10082018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | very long tail | Above Ground | 20 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9722737593623 40.768963018754) | ||
1148 | 1148 | -73.9707339200738 | 40.7796333355689 | 17C-PM-1013-03 | 17C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 20 | in a tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707339200738 40.7796333355689) | ||||
1371 | 1371 | -73.9542733797804 | 40.795578653743 | 39F-PM-1006-02 | 39F | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran up tree when approached | POINT (-73.9542733797804 40.795578653743) | |||
1381 | 1381 | -73.9586077039567 | 40.796189647707706 | 38C-AM-1019-10 | 38C | AM | 10192018 | 10 | Adult | Gray | White | Gray+White | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9586077039567 40.7961896477077) | ||||
1410 | 1410 | -73.95879132892291 | 40.7961707624534 | 38C-AM-1019-11 | 38C | AM | 10192018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9587913289229 40.7961707624534) | ||||
1431 | 1431 | -73.9601918930677 | 40.7944134683406 | 35C-AM-1007-01 | 35C | AM | 10072018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | (white oak) | 0 | 0 | 0 | 0 | 0 | sitting still | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9601918930677 40.7944134683406) | ||
1466 | 1466 | -73.96511776576759 | 40.7812408103825 | 20F-PM-1007-05 | 20F | PM | 10072018 | 5 | Juvenile | Gray | White | Gray+White | white tail | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9651177657676 40.781240810382506) | |||
1506 | 1506 | -73.9728339757306 | 40.7782891207966 | 14B-PM-1014-04 | 14B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | running up and down | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9728339757306 40.7782891207966) | |||
1508 | 1508 | -73.96938943057859 | 40.775690674802604 | 13F-PM-1008-04 | 13F | PM | 10082018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9693894305786 40.7756906748026) | ||||
1512 | 1512 | -73.97338823645741 | 40.768307870659704 | 5G-AM-1006-01 | 05G | AM | 10062018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | made eye contact with me | POINT (-73.9733882364574 40.7683078706597) | |||
1641 | 1641 | -73.96531352771491 | 40.7817434070169 | 21E-PM-1012-01 | 21E | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9653135277149 40.7817434070169) | ||||
1807 | 1807 | -73.9581366214863 | 40.7988964092722 | 40B-PM-1014-02 | 40B | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9581366214863 40.7988964092722) | |||||
1925 | 1925 | -73.95813898706442 | 40.7993081122523 | 41A-PM-1007-04 | 41A | PM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | laid down on the branch | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9581389870644 40.799308112252305) | ||||
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) | |||
2010 | 2010 | -73.9673821557469 | 40.7786375267659 | 17F-PM-1020-06 | 17F | PM | 10202018 | 6 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.96738215574692 40.7786375267659) | |||||
2145 | 2145 | -73.96512504025829 | 40.7812884929069 | 20F-PM-1007-04 | 20F | PM | 10072018 | 4 | Juvenile | Gray | White | Gray+White | white on tail | Above Ground | 20 | climbed tree | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9651250402583 40.7812884929069) | ||
2251 | 2251 | -73.9587678566254 | 40.7962656030995 | 38C-PM-1014-01 | 38C | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9587678566254 40.7962656030995) | ||||
2390 | 2390 | -73.9680741975294 | 40.7847036778165 | 23B-PM-1012-04 | 23B | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | watching me - didn't move | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9680741975294 40.7847036778165) | |||
2443 | 2443 | -73.96670731869591 | 40.7840581361598 | 23C-PM-1014-01 | 23C | PM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.96670731869591 40.7840581361598) | |||||
2729 | 2729 | -73.9615429203441 | 40.7907417648701 | 31D-AM-1014-01 | 31D | AM | 10142018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | Ground then up tree | 0 | 0 | 1 | 0 | 0 | chased by a doggo | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | runs from (dogs!) | POINT (-73.9615429203441 40.7907417648701) | ||
2730 | 2730 | -73.96535757586871 | 40.78053399533721 | 20F-PM-1007-12 | 20F | PM | 10072018 | 12 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9653575758687 40.7805339953372) | |||
2877 | 2877 | -73.9730027200009 | 40.7798000868804 | 16A-PM-1019-05 | 16A | PM | 10192018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9730027200009 40.7798000868804) | ||||
1333 | 1333 | -73.9754527701832 | 40.7656088463928 | 1G-PM-1010-02 | 01G | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | laying on tree branch | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | POINT (-73.9754527701832 40.7656088463928) | |||
2335 | 2335 | -73.9704679459444 | 40.7773384236212 | 14D-PM-1019-10 | 14D | PM | 10192018 | 10 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9704679459444 40.7773384236212) |
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 );