This data as json, CSV (advanced)
Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Kuks, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
401 | 401 | -73.965862100991 | 40.782592689691704 | 22D-PM-1012-01 | 22D | PM | 10122018 | 1 | Adult | Gray | Black, White | Gray+Black, White | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | climbing tree | POINT (-73.965862100991 40.7825926896917) | |||
402 | 402 | -73.9681917366128 | 40.7723298813768 | 11I-PM-1012-03 | 11I | PM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from the dog | POINT (-73.9681917366128 40.7723298813768) | ||||
765 | 765 | -73.96797780019 | 40.784762947325795 | 23B-PM-1012-05 | 23B | PM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | chain link fence | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96797780019 40.7847629473258) | |||
776 | 776 | -73.9686816795392 | 40.775770422666994 | 14F-PM-1012-02 | 14F | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686816795392 40.775770422667) | ||||
889 | 889 | -73.96810426129379 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681042612938 40.772331431865) | |||||
931 | 931 | -73.97859484138829 | 40.7718908026758 | 6A-PM-1012-01 | 06A | PM | 10122018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785948413883 40.7718908026758) | ||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9540257319561 40.798408619116) | ||||||
1317 | 1317 | -73.9680522379372 | 40.772389813511 | 11I-PM-1012-06 | 11I | PM | 10122018 | 6 | Adult | Gray | Gray+ | Above Ground | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9680522379372 40.772389813511) | |||||
1487 | 1487 | -73.96539465596099 | 40.7763136791661 | 15I-PM-1012-05 | 15I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | 1 | 0 | 1 | 0 | 1 | burying the food on ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | look at us and continue hiding the food | POINT (-73.965394655961 40.7763136791661) | |||
1551 | 1551 | -73.9785114291288 | 40.771977958944895 | 6A-PM-1012-03 | 06A | PM | 10122018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785114291288 40.7719779589449) | ||||
1568 | 1568 | -73.96810798698209 | 40.772349408134495 | 11I-PM-1012-05 | 11I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681079869821 40.7723494081345) | |||||
1625 | 1625 | -73.9736873018042 | 40.76491066771379 | 1I-PM-1012-02 | 01I | PM | 10122018 | 2 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | tree | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9736873018042 40.7649106677138) | ||
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) | ||||
1697 | 1697 | -73.9568610943394 | 40.7935959584643 | 36E-PM-1012-02 | 36E | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 28 | on tree branch | 0 | 0 | 1 | 0 | 1 | picking acorns off oak tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95686109433942 40.7935959584643) | |||
1850 | 1850 | -73.975809362521 | 40.773470273783495 | 8B-PM-1012-09 | 08B | PM | 10122018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.975809362521 40.7734702737835) | ||||
1962 | 1962 | -73.9647318357023 | 40.7760936175332 | 15I-PM-1012-04 | 15I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9647318357023 40.7760936175332) | |||||
2069 | 2069 | -73.9538377039825 | 40.798060533496106 | 42E-PM-1012-03 | 42E | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538377039825 40.7980605334961) | |||
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) | ||||
2232 | 2232 | -73.9566277721581 | 40.7966674587803 | 39D-PM-1012-04 | 39D | PM | 10122018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | on tree trunk (descending from height of ~10 ft) | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95662777215811 40.7966674587803) | |||
2317 | 2317 | -73.97673696861709 | 40.7735074437085 | 8B-PM-1012-05 | 08B | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767369686171 40.7735074437085) | ||||
2323 | 2323 | -73.9715921982161 | 40.7746153066601 | 11E-PM-1012-06 | 11E | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Above Ground | 5 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9715921982161 40.7746153066601) | |||
2372 | 2372 | -73.9724879969884 | 40.771098202397 | 8F-PM-1012-07 | 08F | PM | 10122018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 17 | 0 | 0 | 1 | 0 | 0 | gathering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9724879969884 40.771098202397) | |||
2394 | 2394 | -73.97858295460459 | 40.7719652299132 | 6A-PM-1012-02 | 06A | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785829546046 40.7719652299132) | ||||
2818 | 2818 | -73.9681664642028 | 40.77246696819579 | 11I-PM-1012-02 | 11I | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 4 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs away from the ball | POINT (-73.9681664642028 40.7724669681958) |
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 );