This data as json, CSV (advanced)
Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27 | 27 | -73.9670628558161 | 40.7734991420941 | 12I-AM-1013-01 | 12I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on tree roots | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9670628558161 40.77349914209411) | ||
109 | 109 | -73.967097592707 | 40.785411934253794 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | 1 | 0 | 0 | 1 | 0 | took nut to bury | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.967097592707 40.7854119342538) | |||||
135 | 135 | -73.9694168118643 | 40.7728877377977 | 11G-PM-1013-01 | 11G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | In the Woods/Brush | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | watching me | POINT (-73.9694168118643 40.7728877377977) | ||
143 | 143 | -73.9661361310677 | 40.7787872561177 | 18G-PM-1013-01 | 18G | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9661361310677 40.7787872561177) | |||
195 | 195 | -73.97377736133109 | 40.7673662611015 | 3G-PM-1013-01 | 03G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9737773613311 40.7673662611015) | ||||
403 | 403 | -73.9597470659927 | 40.797321593541604 | 38A-PM-1013-01 | 38A | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9597470659927 40.7973215935416) | ||||
630 | 630 | -73.9580109357087 | 40.78556544054471 | 28I-AM-1013-01 | 28I | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Jumped onto path & then back into brush | 0 | 0 | 0 | 0 | 0 | stood on fence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9580109357087 40.7855654405447) | ||
653 | 653 | -73.97034013856842 | 40.7795238784266 | 17C-PM-1013-01 | 17C | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | then perched on 2-ft high border fencing | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9703401385684 40.7795238784266) | ||||
1096 | 1096 | -73.95683008997729 | 40.793585574335395 | 36E-AM-1013-01 | 36E | AM | 10132018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (ran into treebrush) | POINT (-73.9568300899773 40.7935855743354) | ||||
1180 | 1180 | -73.9639726817977 | 40.7829083461049 | 23F-PM-1013-01 | 23F | PM | 10132018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dove into some bushes/undergrowth,only saw briefly! → not because of humans tho.) | POINT (-73.9639726817977 40.7829083461049) | |||
1261 | 1261 | -73.9719109949232 | 40.772313852132704 | 9F-AM-1013-01 | 09F | AM | 10132018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9719109949232 40.7723138521327) | |||||
1412 | 1412 | -73.9594676326588 | 40.7984457363388 | 39A-AM-1013-01 | 39A | AM | 10132018 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9594676326588 40.7984457363388) | ||||
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) | ||||
1640 | 1640 | -73.9564632239432 | 40.7904807427954 | 33G-AM-1013-01 | 33G | AM | 10132018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 13 | shelter in hole in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9564632239432 40.7904807427954) | ||||
1707 | 1707 | -73.96045242711669 | 40.7956624328733 | 36B-AM-1013-01 | 36B | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9604524271167 40.7956624328733) | ||||
1865 | 1865 | -73.9558118887106 | 40.796885713436 | 39E-PM-1013-01 | 39E | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9558118887106 40.796885713436005) | |||
1896 | 1896 | -73.973998077367 | 40.773902913391105 | 10C-PM-1013-01 | 10C | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.973998077367 40.7739029133911) | ||||
1939 | 1939 | -73.9540151828782 | 40.7920066170587 | 35H-AM-1013-01 | 35H | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | Climbing up tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9540151828782 40.7920066170587) | |||
1952 | 1952 | -73.96818104666929 | 40.7720638449419 | 10I-PM-1013-01 | 10I | PM | 10132018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9681810466693 40.7720638449419) | ||||
2143 | 2143 | -73.9596232170232 | 40.7959550843229 | 37B-PM-1013-01 | 37B | PM | 10132018 | 1 | Adult | Gray | Gray+ | Sighting was far away | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9596232170232 40.795955084322905) | ||||
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) | |||
2278 | 2278 | -73.96453903109901 | 40.78099163100121 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.964539031099 40.7809916310012) | ||||
2338 | 2338 | -73.9716621112698 | 40.774286221946895 | 11E-AM-1013-01 | 11E | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9716621112698 40.7742862219469) | |||||
2371 | 2371 | -73.9769520212123 | 40.774006725862996 | 9A-AM-1013-01 | 09A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9769520212123 40.774006725863) | ||||
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) | |||
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) | ||||
2585 | 2585 | -73.9771726831497 | 40.7732320781799 | 8A-AM-1013-01 | 08A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | trail | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9771726831497 40.7732320781799) | |||
2969 | 2969 | -73.9654409838612 | 40.7901338748522 | 29A-AM-1013-01 | 29A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | climbed tree (oak) | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9654409838612 40.7901338748522) | |||
2997 | 2997 | -73.96197353854829 | 40.7944667974974 | 35A-PM-1013-01 | 35A | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9619735385483 40.7944667974974) |
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 );