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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2735 | 2735 | -73.97680969536471 | 40.7708185213129 | 5C-PM-1010-08 | 05C | PM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768096953647 40.7708185213129) | ||||
2801 | 2801 | -73.9697665830132 | 40.7759094917104 | 13E-PM-1008-08 | 13E | PM | 10082018 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9697665830132 40.7759094917104) | ||||
2826 | 2826 | -73.9600357018376 | 40.790653976688105 | 32E-AM-1007-08 | 32E | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 65 | tree top | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9600357018376 40.7906539766881) | ||||
2901 | 2901 | -73.9735833104203 | 40.7786318041581 | 14A-PM-1014-08 | 14A | PM | 10142018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | new movement flailing arms while foraging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9735833104203 40.7786318041581) | |||
2939 | 2939 | -73.9680204438195 | 40.774388232265395 | 13H-PM-1010-08 | 13H | PM | 10102018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9680204438195 40.77438823226541) | |||||
2945 | 2945 | -73.9649103330443 | 40.7823913860445 | 22F-PM-1014-08 | 22F | PM | 10142018 | 8 | Adult | Gray | Gray+ | Above Ground | 10 | CLIMBED THE TREE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9649103330443 40.7823913860445) | ||||
2950 | 2950 | -73.9790980124501 | 40.7685934093915 | 2B-PM-1013-08 | 02B | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790980124501 40.7685934093915) | ||||
2963 | 2963 | -73.9687020800791 | 40.7735903424522 | 11H-AM-1010-08 | 11H | AM | 10102018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9687020800791 40.7735903424522) | ||||
2976 | 2976 | -73.97240833205379 | 40.7744163768061 | 11D-AM-1010-08 | 11D | AM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | drinking | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9724083320538 40.7744163768061) | |||
2996 | 2996 | -73.970033345821 | 40.777259393859 | 15E-PM-1008-08 | 15E | PM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970033345821 40.777259393859) | |||||
3004 | 3004 | -73.9528482858163 | 40.7922056218325 | 36I-PM-1007-08 | 36I | PM | 10072018 | 8 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9528482858163 40.7922056218325) | ||||
902 | 902 | -73.969105907 | 40.782047490919204 | 20B-PM-1013-08 | 20B | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | (very brown) | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | being chased by dog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.969105907 40.7820474909192) | ||
3015 | 3015 | -73.97591633005351 | 40.7736180793606 | 9B-AM-1010-08 | 09B | AM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon head, White (Almost Silver) | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9759163300535 40.7736180793606) | |||
122 | 122 | -73.9712527809516 | 40.7763310392591 | 13D-AM-1014-08 | 13D | AM | 10142018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Gray & Cinnamon selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9712527809516 40.7763310392591) | |||
443 | 443 | -73.9720887275538 | 40.776079953797606 | 13D-PM-1018-08 | 13D | PM | 10182018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9720887275538 40.7760799537976) | |||
1339 | 1339 | -73.96864133261721 | 40.7817423907284 | 19C-PM-1018-08 | 19C | PM | 10182018 | 8 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686413326172 40.7817423907284) | |||
1000 | 1000 | -73.9805137046778 | 40.769275143797 | 2A-AM-1010-08 | 02A | AM | 10102018 | 8 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9805137046778 40.769275143797) | ||||
2931 | 2931 | -73.9730926233232 | 40.7781330751738 | 14B-PM-1014-08 | 14B | PM | 10142018 | 8 | Gray | Cinnamon, White | Gray+Cinnamon, White | White belly & stripes on tail, Cinnamon face & stripes on back | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9730926233232 40.7781330751738) | ||||
1577 | 1577 | -73.965390623703 | 40.7807731363782 | 20F-PM-1007-08 | 20F | PM | 10072018 | 8 | Adult | Cinnamon | White | Cinnamon+White | white tail/belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.965390623703 40.7807731363782) |
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 );