This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32 | 32 | -73.9576530157255 | 40.7868659490397 | 29I-PM-1007-01 | 29I | PM | 10072018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9576530157255 40.7868659490397) | |||||
57 | 57 | -73.9690175838534 | 40.77604327200171 | 14F-AM-1007-05 | 14F | AM | 10072018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690175838534 40.7760432720017) | ||||
94 | 94 | -73.9641971813967 | 40.781353795943495 | 21G-PM-1007-01 | 21G | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9641971813967 40.7813537959435) | ||||
136 | 136 | -73.9528682507794 | 40.792580780830704 | 36I-PM-1007-13 | 36I | PM | 10072018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9528682507794 40.7925807808307) | ||||
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) | |||
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) | ||||
441 | 441 | -73.9742973420446 | 40.7691801644292 | 5F-AM-1007-04 | 05F | AM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | rocks | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9742973420446 40.7691801644292) | ||||
446 | 446 | -73.9678774314725 | 40.7738535171265 | 12H-PM-1007-04 | 12H | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | mushroom | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9678774314725 40.7738535171265) | ||||||
505 | 505 | -73.9677387336667 | 40.774269591199996 | 12H-PM-1007-02 | 12H | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | in tree | 0 | 0 | 1 | 1 | 0 | peanuts | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677387336667 40.7742695912) | ||
591 | 591 | -73.95433237868879 | 40.7943086530436 | 37G-PM-1007-03 | 37G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | lying on belly on branch,eating big nut | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9543323786888 40.7943086530436) | |||
722 | 722 | -73.9745953710328 | 40.7728284025195 | 8D-AM-1007-07 | 08D | AM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9745953710328 40.7728284025195) | ||||
727 | 727 | -73.9634563222926 | 40.780992836417 | 21G-PM-1007-04 | 21G | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9634563222926 40.780992836417) | |||||
942 | 942 | -73.9533923917973 | 40.796170187476896 | 40G-AM-1007-01 | 40G | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | large tree | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9533923917973 40.7961701874769) | |||
1109 | 1109 | -73.96781540330991 | 40.774278348448604 | 12H-PM-1007-01 | 12H | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | in tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9678154033099 40.7742783484486) | |||
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) | ||||
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) | ||||
1208 | 1208 | -73.96628049257741 | 40.7890284642399 | 28A-PM-1007-01 | 28A | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662804925774 40.7890284642399) | ||||
1216 | 1216 | -73.9707245013626 | 40.778065658833704 | 15D-AM-1007-06 | 15D | AM | 10072018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707245013626 40.7780656588337) | ||||
1404 | 1404 | -73.9700666654946 | 40.774285704258105 | 12F-PM-1007-08 | 12F | PM | 10072018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | stared | POINT (-73.9700666654946 40.7742857042581) | |||
1609 | 1609 | -73.96390249881229 | 40.777695306584896 | 18I-PM-1007-01 | 18I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | 0 | 0 | 1 | 1 | 1 | hanging upside down | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9639024988123 40.7776953065849) | |||
1906 | 1906 | -73.9700066659086 | 40.7744028820163 | 12F-PM-1007-13 | 12F | PM | 10072018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9700066659086 40.7744028820163) | ||||
1963 | 1963 | -73.96515918613991 | 40.781183828857 | 20F-PM-1007-06 | 20F | PM | 10072018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9651591861399 40.781183828857) | ||||
2222 | 2222 | -73.9639048209454 | 40.777737334555795 | 18I-PM-1007-02 | 18I | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | 0 | 0 | 1 | 1 | 1 | hanging upside down | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9639048209454 40.7777373345558) | |||
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) | ||||
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) | ||||
2472 | 2472 | -73.9596820155238 | 40.7932886803231 | 34D-PM-1007-03 | 34D | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9596820155238 40.7932886803231) | ||||
2626 | 2626 | -73.9737329655838 | 40.7726424441344 | 8D-PM-1007-02 | 08D | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9737329655838 40.7726424441344) | ||||
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) | |||
2954 | 2954 | -73.9677474313377 | 40.7742119240825 | 12H-PM-1007-03 | 12H | PM | 10072018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | peanuts | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677474313377 40.7742119240825) | ||||
2995 | 2995 | -73.9668442742942 | 40.7870781042595 | 25B-PM-1007-01 | 25B | PM | 10072018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9668442742942 40.7870781042595) | |||||
1408 | 1408 | -73.973230162241 | 40.768982453144396 | 5F-AM-1007-01 | 05F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | fence | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.973230162241 40.7689824531444) | |||
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) |
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 );