This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Kuks, Tail flags, 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
673 | 673 | -73.958417813526 | 40.792730121447605 | 34E-PM-1006-01 | 34E | PM | 10062018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | sitting and watching on a tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958417813526 40.7927301214476) | |||
2874 | 2874 | -73.9597453664295 | 40.7891382153733 | 30F-PM-1007-01 | 30F | PM | 10072018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 1 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9597453664295 40.7891382153733) | |||
2947 | 2947 | -73.96012151981141 | 40.7909769801241 | 32D-PM-1006-02 | 32D | PM | 10062018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9601215198114 40.7909769801241) | ||||
2935 | 2935 | -73.96045994773449 | 40.7915035010169 | 32D-PM-1006-06 | 32D | PM | 10062018 | 6 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9604599477345 40.7915035010169) | ||||
2604 | 2604 | -73.9605163698302 | 40.7914179994956 | 32D-PM-1006-05 | 32D | PM | 10062018 | 5 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9605163698302 40.7914179994956) | ||||
314 | 314 | -73.960601067176 | 40.7917243850136 | 32D-PM-1006-09 | 32D | PM | 10062018 | 9 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.960601067176 40.7917243850136) | ||||
2723 | 2723 | -73.96064260275601 | 40.791726541984204 | 32D-PM-1006-08 | 32D | PM | 10062018 | 8 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | stand on two feet and watching me | POINT (-73.960642602756 40.7917265419842) | |||
379 | 379 | -73.9606817053484 | 40.7917320450401 | 32D-PM-1006-07 | 32D | PM | 10062018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9606817053484 40.7917320450401) | ||||
328 | 328 | -73.96523572796708 | 40.781929688714705 | 21E-PM-1012-02 | 21E | PM | 10122018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9652357279671 40.7819296887147) | ||||
571 | 571 | -73.9659549963516 | 40.7833659689194 | 22D-PM-1012-05 | 22D | PM | 10122018 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9659549963516 40.7833659689194) | ||||||
1219 | 1219 | -73.96618922004741 | 40.7836798072777 | 22D-PM-1012-06 | 22D | PM | 10122018 | 6 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9661892200474 40.7836798072777) | ||||
420 | 420 | -73.96718516112429 | 40.7750878657618 | 14H-PM-1012-01 | 14H | PM | 10122018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (came very close to me) | POINT (-73.9671851611243 40.7750878657618) | |||
1969 | 1969 | -73.96890514730721 | 40.7764511282884 | 14F-AM-1007-04 | 14F | AM | 10072018 | 4 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689051473072 40.7764511282884) | ||||
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) | |||
2852 | 2852 | -73.9728146482385 | 40.7652951714745 | 1I-PM-1012-03 | 01I | PM | 10122018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.97281464823851 40.765295171474506) | |||
1840 | 1840 | -73.9733222531339 | 40.764997537154606 | 1I-PM-1012-01 | 01I | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9733222531339 40.7649975371546) | |||
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) | ||
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) | ||
568 | 568 | -73.97994414934041 | 40.767149999752704 | 1C-AM-1012-01 | 01C | AM | 10122018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9799441493404 40.7671499997527) |
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 );