This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Tail flags, Approaches, Runs from
Highlight Fur Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65 | 65 | -73.9741824992294 | 40.7689486657963 | 5F-PM-1007-03 | 05F | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hiding nut | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9741824992294 40.7689486657963) | |||
73 | 73 | -73.96148483609001 | 40.7922645521905 | 33C-PM-1007-03 | 33C | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96148483609 40.7922645521905) | ||||
304 | 304 | -73.9523001834395 | 40.7949231000186 | 39H-AM-1007-02 | 39H | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9523001834395 40.7949231000186) | ||||
599 | 599 | -73.95302635524891 | 40.7920949788358 | 36I-PM-1007-05 | 36I | PM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9530263552489 40.7920949788358) | |||||
733 | 733 | -73.9764397550289 | 40.7737004557104 | 8B-AM-1007-01 | 08B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9764397550289 40.7737004557104) | ||||
1169 | 1169 | -73.9570391901515 | 40.7930697207834 | 35F-AM-1007-01 | 35F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9570391901515 40.7930697207834) | ||||
1413 | 1413 | -73.98100322064279 | 40.768162563497896 | 1A-AM-1007-01 | 01A | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9810032206428 40.7681625634979) | ||||
1498 | 1498 | -73.9765064169087 | 40.7737211426714 | 8B-AM-1007-06 | 08B | AM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9765064169087 40.7737211426714) | ||||
1660 | 1660 | -73.98004994980342 | 40.7702181099573 | 4A-PM-1007-05 | 04A | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | At rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9800499498034 40.770218109957305) | |||
1668 | 1668 | -73.97469348106671 | 40.7659431884158 | 2G-PM-1007-02 | 02G | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | burying nut | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9746934810667 40.7659431884158) | |||
1713 | 1713 | -73.97977158132 | 40.7706273151066 | 4A-AM-1007-01 | 04A | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97977158132 40.7706273151066) | |||||
1730 | 1730 | -73.97961428483491 | 40.7702117898305 | 4A-PM-1007-04 | 04A | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9796142848349 40.7702117898305) | ||||
1804 | 1804 | -73.98077710643099 | 40.7681635726316 | 1A-AM-1007-02 | 01A | AM | 10072018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 11 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.980777106431 40.7681635726316) | ||||
1948 | 1948 | -73.9738410069766 | 40.7691686156505 | 5F-PM-1007-06 | 05F | PM | 10072018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | jumping on fence | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9738410069766 40.7691686156505) | |||
2241 | 2241 | -73.95752586279659 | 40.787715550749 | 30H-AM-1007-03 | 30H | AM | 10072018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9575258627966 40.787715550749) | |||||
2321 | 2321 | -73.9743060404813 | 40.7687901781431 | 5F-PM-1007-02 | 05F | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9743060404813 40.7687901781431) | ||||
2382 | 2382 | -73.97439704555329 | 40.7687880243986 | 5F-PM-1007-01 | 05F | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9743970455533 40.7687880243986) | ||||
2486 | 2486 | -73.9766317094163 | 40.7734230472026 | 8B-AM-1007-05 | 08B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9766317094163 40.7734230472026) | |||||
2508 | 2508 | -73.97938145045201 | 40.770903369788705 | 4A-PM-1007-01 | 04A | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.979381450452 40.770903369788705) | ||||
2670 | 2670 | -73.95310419064691 | 40.7919916819219 | 36I-PM-1007-02 | 36I | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | chased birds (blue jay) | POINT (-73.9531041906469 40.7919916819219) | ||||
2776 | 2776 | -73.9789687905912 | 40.769269313932796 | 3B-PM-1007-04 | 03B | PM | 10072018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | At fence | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9789687905912 40.7692693139328) | |||
2833 | 2833 | -73.9552595564798 | 40.7889533029466 | 32I-PM-1007-01 | 32I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | chirps | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9552595564798 40.7889533029466) | |||
2851 | 2851 | -73.955208233231 | 40.7890574331084 | 32I-PM-1007-02 | 32I | PM | 10072018 | 2 | Adult | + | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | different sound - happy,playful chirps | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.955208233231 40.7890574331084) | |||||
2961 | 2961 | -73.9736238258579 | 40.7688712771191 | 5F-PM-1007-04 | 05F | PM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9736238258579 40.7688712771191) | ||||
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) | ||||
161 | 161 | -73.9649632550828 | 40.7809187761995 | 20F-PM-1007-01 | 20F | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | cinnamon tail | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9649632550828 40.7809187761995) |
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 );