This data as json, CSV (advanced)
Suggested facets: Shift, Date, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Tail flags, Indifferent
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
581 | 581 | -73.9556218199258 | 40.7980460204041 | 41D-PM-1014-01 | 41D | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | digging,drinking | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9556218199258 40.7980460204041) | |||
1115 | 1115 | -73.9545214613307 | 40.7943801121036 | 37G-PM-1007-01 | 37G | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9545214613307 40.7943801121036) | ||||
1429 | 1429 | -73.9706533131129 | 40.768902033818996 | 6I-AM-1006-01 | 06I | AM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (someone sneezed) | POINT (-73.9706533131129 40.768902033819) | ||||
1499 | 1499 | -73.96252055381709 | 40.7810785055136 | 21H-AM-1017-01 | 21H | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9625205538171 40.7810785055136) | ||||
1621 | 1621 | -73.97349693209429 | 40.7722754599865 | 8E-AM-1013-01 | 08E | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9734969320943 40.7722754599865) | ||||
2183 | 2183 | -73.967334936601 | 40.7773289724189 | 16F-PM-1013-01 | 16F | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Woods | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.967334936601 40.7773289724189) | |||
2423 | 2423 | -73.973552877209 | 40.7715638228207 | 7E-PM-1013-01 | 07E | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.973552877209 40.7715638228207) | |||
2424 | 2424 | -73.9684752839242 | 40.776581626151795 | 15F-AM-1007-01 | 15F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9684752839242 40.7765816261518) | |||
2446 | 2446 | -73.95227045119691 | 40.796566887896105 | 41G-AM-1013-01 | 41G | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9522704511969 40.7965668878961) | ||||
2463 | 2463 | -73.9653343572865 | 40.77752869246171 | 17H-PM-1007-01 | 17H | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9653343572865 40.7775286924617) | ||||
2682 | 2682 | -73.97110012783891 | 40.778746609584104 | 15C-PM-1017-01 | 15C | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9711001278389 40.7787466095841) |
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 );