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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1249 | 1249 | -73.9590132705889 | 40.7952248279764 | 37C-AM-1012-03 | 37C | AM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon flanks | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9590132705889 40.7952248279764) | |||
2447 | 2447 | -73.9589670987899 | 40.795212703928705 | 37C-AM-1012-04 | 37C | AM | 10122018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon flanks | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589670987899 40.7952127039287) | |||
1477 | 1477 | -73.9589635326362 | 40.7951748673846 | 37C-AM-1012-02 | 37C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon flanks, light band across nose | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | caching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589635326362 40.7951748673846) | ||
1098 | 1098 | -73.96049542761291 | 40.7965682182001 | 37A-AM-1012-01 | 37A | AM | 10122018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Drawing included on tally sheet | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | scanning (drawing included) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9604954276129 40.7965682182001) | ||
2314 | 2314 | -73.9663961415789 | 40.7750691120996 | 14H-PM-1012-06 | 14H | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary with a note that it was "hard to tell". | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9663961415789 40.7750691120996) | |||
1297 | 1297 | -73.9802831706033 | 40.7692763295564 | 3A-AM-1012-02 | 03A | AM | 10122018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9802831706033 40.7692763295564) | |||
820 | 820 | -73.9801902133148 | 40.769557595068 | 3A-AM-1012-03 | 03A | AM | 10122018 | 3 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Above Ground | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801902133148 40.769557595068) | |||
2389 | 2389 | -73.9801343393329 | 40.769151245340204 | 3A-AM-1012-01 | 03A | AM | 10122018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801343393329 40.7691512453402) | |||
2898 | 2898 | -73.97941182346509 | 40.767449554056896 | 1C-AM-1012-02 | 01C | AM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9794118234651 40.7674495540569) | |||
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) | |||
1721 | 1721 | -73.95873307074629 | 40.7907682009641 | 32F-AM-1012-02 | 32F | AM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray patches on back legs | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | curious about me | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | POINT (-73.9587330707463 40.7907682009641) | ||
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) | |||
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) | |||
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) | ||
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) | |||
1806 | 1806 | -73.9657504643585 | 40.783121081359205 | 22D-PM-1012-02 | 22D | PM | 10122018 | 2 | Adult | Gray | Black, White | Gray+Black, White | No Primary Fur Color selected. Made executive adjustment based on other squirrels. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9657504643585 40.7831210813592) | |||
2051 | 2051 | -73.9544808708211 | 40.7906575852286 | 34I-AM-1012-02 | 34I | AM | 10122018 | 2 | Adult | Gray | White | Gray+White | Short tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hiding | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9544808708211 40.7906575852286) | ||
1118 | 1118 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719460335398 40.7810508156287) |
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 );