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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1926 | 1926 | -73.9742811484852 | 40.775533619083 | 11B-PM-1014-08 | 11B | PM | 10142018 | 8 | Gray | Gray+ | Above Ground | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.97428114848522 40.775533619083) | ||||||
2029 | 2029 | -73.9687213827744 | 40.7843586374648 | 22B-PM-1014-02 | 22B | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687213827744 40.7843586374648) | ||||
2387 | 2387 | -73.98085173247209 | 40.7683154647217 | 1A-PM-1014-01 | 01A | PM | 10142018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9808517324721 40.7683154647217) | ||||
2465 | 2465 | -73.9686999860219 | 40.784401473513604 | 22B-PM-1014-03 | 22B | PM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686999860219 40.7844014735136) | ||||
2498 | 2498 | -73.9674556940019 | 40.7875399402461 | 26A-AM-1014-02 | 26A | AM | 10142018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | could not get close due to fences | POINT (-73.9674556940019 40.7875399402461) | ||||
2663 | 2663 | -73.96134291849741 | 40.79121580572671 | 32C-AM-1014-02 | 32C | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9613429184974 40.7912158057267) | |||||
2809 | 2809 | -73.9686756254868 | 40.777745910265104 | 16E-AM-1014-04 | 16E | AM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9686756254868 40.7777459102651) | ||||
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) | ||||
2933 | 2933 | -73.9677903197449 | 40.7826561917755 | 21C-AM-1014-03 | 21C | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | looked at us from tree | POINT (-73.9677903197449 40.7826561917755) | ||||
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) | ||||
3008 | 3008 | -73.9503533343658 | 40.7976543603953 | 42H-PM-1014-04 | 42H | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9503533343658 40.7976543603953) | ||||
576 | 576 | -73.96220476777009 | 40.7945126358465 | 35A-AM-1014-06 | 35A | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622047677701 40.7945126358465) | ||||
608 | 608 | -73.95896759955171 | 40.791311922358396 | 33E-AM-1014-09 | 33E | AM | 10142018 | 9 | Juvenile | Black | Black+ | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589675995517 40.7913119223584) | |||||
840 | 840 | -73.9598084794625 | 40.797616543450204 | 39A-PM-1014-01 | 39A | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9598084794625 40.7976165434502) | ||||
1417 | 1417 | -73.974828939898 | 40.7668886121909 | 2F-PM-1014-11 | 02F | PM | 10142018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974828939898 40.7668886121909) | |||||
1527 | 1527 | -73.970216605149 | 40.7702960667277 | 8H-PM-1014-08 | 08H | PM | 10142018 | 8 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | chasing (#7),playing? | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970216605149 40.7702960667277) | ||||
1639 | 1639 | -73.9736800575584 | 40.778306973575795 | 14A-PM-1014-04 | 14A | PM | 10142018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#3) | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9736800575584 40.7783069735758) | |||
1666 | 1666 | -73.96494654768709 | 40.7822708362663 | 22F-PM-1014-07 | 22F | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9649465476871 40.7822708362663) | |||||
1817 | 1817 | -73.9703076450783 | 40.770158422628995 | 8H-PM-1014-07 | 08H | PM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | chasing (#8),playing? | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703076450783 40.770158422629) | ||||
1876 | 1876 | -73.973598991549 | 40.7783020016983 | 14A-PM-1014-03 | 14A | PM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#4) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.973598991549 40.7783020016983) | |||
2059 | 2059 | -73.9710026704697 | 40.776105276462104 | 13D-AM-1014-04 | 13D | AM | 10142018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710026704697 40.7761052764621) | |||
2104 | 2104 | -73.9622419917579 | 40.794579797904 | 35A-AM-1014-07 | 35A | AM | 10142018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622419917579 40.794579797904) | ||||
2303 | 2303 | -73.9589470461357 | 40.7912817646361 | 33E-AM-1014-10 | 33E | AM | 10142018 | 10 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589470461357 40.7912817646361) | ||||
2653 | 2653 | -73.958932543729 | 40.7913445531266 | 33E-AM-1014-11 | 33E | AM | 10142018 | 11 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958932543729 40.7913445531266) | ||||
2654 | 2654 | -73.9549261242548 | 40.7944701994615 | 37G-AM-1014-04 | 37G | AM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9549261242548 40.7944701994615) | ||||
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) | ||||
2955 | 2955 | -73.97116665233759 | 40.776151305703394 | 13D-AM-1014-02 | 13D | AM | 10142018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711666523376 40.7761513057034) |
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 );