This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331 | 331 | -73.95448101115 | 40.7954469678857 | 39F-PM-1006-03 | 39F | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15 | lower branch of tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran up tree when approached | POINT (-73.95448101115 40.7954469678857) | ||
335 | 335 | -73.97823514358521 | 40.7715896672335 | 6A-AM-1006-03 | 06A | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | POINT (-73.9782351435852 40.7715896672335) | |||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ran up tree | POINT (-73.959709414696 40.7919745085986) | |||||
728 | 728 | -73.96029131055779 | 40.7910635810038 | 32D-PM-1006-03 | 32D | PM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9602913105578 40.7910635810038) | ||||
1230 | 1230 | -73.9790822606486 | 40.7714466633386 | 5A-AM-1006-03 | 05A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 8 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9790822606486 40.7714466633386) | |||||
591 | 591 | -73.95433237868879 | 40.7943086530436 | 37G-PM-1007-03 | 37G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | lying on belly on branch,eating big nut | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9543323786888 40.7943086530436) | |||
1701 | 1701 | -73.9701634768603 | 40.777869143321794 | 15D-AM-1007-03 | 15D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9701634768603 40.7778691433218) | |||||
1018 | 1018 | -73.96953055553921 | 40.7757541971012 | 13F-PM-1008-03 | 13F | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 15 | tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695305555392 40.7757541971012) | ||||
1863 | 1863 | -73.96828305109541 | 40.7810151087286 | 19D-PM-1008-03 | 19D | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | may be same squirrel as #1 - male | Above Ground | 5 | on branch of dead tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9682830510954 40.7810151087286) | ||
530 | 530 | -73.9696360756453 | 40.7786545659072 | 16D-PM-1010-03 | 16D | PM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 18 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9696360756453 40.7786545659072) | |||||
1627 | 1627 | -73.9594391759139 | 40.784115697669 | 26I-PM-1010-03 | 26I | PM | 10102018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | black in tail | Above Ground | 15 | tree | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9594391759139 40.784115697669) | ||
2379 | 2379 | -73.97118651343641 | 40.7785039981892 | 15C-AM-1010-03 | 15C | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 0 | 1 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711865134364 40.7785039981892) | ||||
2573 | 2573 | -73.9810149147578 | 40.7683925377714 | 2A-AM-1010-03 | 02A | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | on trunk | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9810149147578 40.7683925377714) | |||
2912 | 2912 | -73.9632164738341 | 40.7921270121312 | 32B-PM-1010-03 | 32B | PM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9632164738341 40.7921270121312) | ||||
2090 | 2090 | -73.9569759970802 | 40.7931497452294 | 35F-PM-1012-03 | 35F | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 7 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569759970802 40.79314974522941) | ||||
2205 | 2205 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 10122018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8 | on turn, see map | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9594986107981 40.7840083040604) | ||||
2903 | 2903 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9670432105975 40.7753462013506) | ||||
222 | 222 | -73.97702735535249 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 10132018 | 3 | Juvenile | + | Above Ground | 3 | fence | 1 | 1 | 1 | 1 | 0 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770273553525 40.7732399463626) | ||||
299 | 299 | -73.9586214081667 | 40.7937473968735 | 35D-PM-1013-03 | 35D | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | No Tail! | Above Ground | 2 | bench | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9586214081667 40.7937473968735) | ||
460 | 460 | -73.9549135206961 | 40.798525897229 | 42D-PM-1013-03 | 42D | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | in tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9549135206961 40.798525897229) | |||
1395 | 1395 | -73.9710801547498 | 40.7760872452093 | 13D-AM-1014-03 | 13D | AM | 10142018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 2 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9710801547498 40.7760872452093) | ||||
1537 | 1537 | -73.97672201797249 | 40.77532621031229 | 10A-PM-1014-03 | 10A | PM | 10142018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | above my head in tree | 0 | 0 | 0 | 1 | 0 | eating (in a tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent (lots of people taking its picture,didn't bother it) | POINT (-73.9767220179725 40.7753262103123) | ||
2154 | 2154 | -73.976716425804 | 40.7736889979965 | 8A-PM-1014-03 | 08A | PM | 10142018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 23 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.976716425804 40.7736889979965) | |||||
105 | 105 | -73.9589249555235 | 40.7908193284981 | 32E-PM-1017-03 | 32E | PM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | bottom of tree | 0 | 0 | 0 | 1 | 0 | still | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589249555235 40.7908193284981) | |||
21 | 21 | -73.9703781726172 | 40.778752613032104 | 16C-PM-1018-03 | 16C | PM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703781726172 40.7787526130321) | ||||
258 | 258 | -73.9534333425633 | 40.793256416332795 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9534333425633 40.7932564163328) | |||
220 | 220 | -73.96718161220299 | 40.7787752287055 | 17F-PM-1020-03 | 17F | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 35 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.967181612203 40.7787752287055) |
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 );