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, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23 | 23 | -73.9638179439747 | 40.7924173263904 | 32A-PM-1013-03 | 32A | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9638179439747 40.7924173263904) | ||||
149 | 149 | -73.9576349321357 | 40.7904409912437 | 32G-PM-1013-03 | 32G | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9576349321357 40.7904409912437) | |||
201 | 201 | -73.9598015842806 | 40.7973522744237 | 38A-PM-1013-03 | 38A | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9598015842806 40.7973522744237) | ||||
228 | 228 | -73.97286607796221 | 40.7753294525644 | 12C-AM-1013-03 | 12C | AM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728660779622 40.7753294525644) | ||||
280 | 280 | -73.9587401274261 | 40.7960322222949 | 37C-PM-1013-03 | 37C | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9587401274261 40.7960322222949) | ||||||
299 | 299 | -73.9586214081667 | 40.7937473968735 | 35D-PM-1013-03 | 35D | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | No Tail! | Above Ground | 2 | bench | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9586214081667 40.7937473968735) | ||
323 | 323 | -73.9573469787503 | 40.7944044592573 | 36E-AM-1013-03 | 36E | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent (moving very fast) | POINT (-73.9573469787503 40.7944044592573) | |||
432 | 432 | -73.9757787135906 | 40.7737231427345 | 9B-PM-1013-03 | 09B | PM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9757787135906 40.7737231427345) | ||||
460 | 460 | -73.9549135206961 | 40.798525897229 | 42D-PM-1013-03 | 42D | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | in tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9549135206961 40.798525897229) | |||
636 | 636 | -73.97575361873191 | 40.775511981067794 | 11A-PM-1013-03 | 11A | PM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757536187319 40.7755119810678) | ||||
748 | 748 | -73.9756603846107 | 40.7672531319384 | 3F-PM-1013-03 | 03F | PM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9756603846107 40.7672531319384) | ||||
783 | 783 | -73.96776542897571 | 40.786785529449 | 25A-AM-1013-03 | 25A | AM | 10132018 | 3 | Gray | Gray+ | Above Ground | 15 | BIG TREE | 0 | 0 | 0 | 0 | 0 | being chased by #2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677654289757 40.786785529449) | ||||
992 | 992 | -73.97080835874709 | 40.782542944158294 | 19A-PM-1013-03 | 19A | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9708083587471 40.7825429441583) | |||||
1024 | 1024 | -73.9521514669041 | 40.7949515182825 | 39H-PM-1013-03 | 39H | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | POINT (-73.9521514669041 40.7949515182825) | ||||
1058 | 1058 | -73.97371007431829 | 40.7708360121735 | 7E-PM-1013-03 | 07E | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Ground & Tree Base | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9737100743183 40.7708360121735) | ||||
1145 | 1145 | -73.9611446263364 | 40.7911003407299 | 32D-AM-1013-03 | 32D | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9611446263364 40.7911003407299) | ||||
1167 | 1167 | -73.9593244415072 | 40.794964729747 | 36C-PM-1013-03 | 36C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9593244415072 40.794964729747) | ||||
1291 | 1291 | -73.96859351775 | 40.7735537139641 | 11H-PM-1013-03 | 11H | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | planting nut | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96859351775 40.7735537139641) | ||||
1681 | 1681 | -73.9638141923763 | 40.782922532628795 | 23F-PM-1013-03 | 23F | PM | 10132018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | indifferent (noticed me,busy eating,foraging) | POINT (-73.9638141923763 40.7829225326288) | |||
1747 | 1747 | -73.96657637976071 | 40.7761316400012 | 15H-AM-1013-03 | 15H | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665763797607 40.7761316400012) | ||||
1836 | 1836 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9751056714758 40.7732060035215) | ||||
2065 | 2065 | -73.9768411547701 | 40.7741377018895 | 9A-AM-1013-03 | 09A | AM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768411547701 40.7741377018895) | ||||
2077 | 2077 | -73.95627335110309 | 40.799314210183894 | 42C-PM-1013-03 | 42C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Crossing street | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9562733511031 40.7993142101839) | ||||
2109 | 2109 | -73.9744488584414 | 40.7741627220859 | 10C-PM-1013-03 | 10C | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9744488584414 40.7741627220859) | ||||
2178 | 2178 | -73.9557918001972 | 40.797922887804205 | 40D-PM-1013-03 | 40D | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9557918001972 40.7979228878042) | ||||
2186 | 2186 | -73.9561103688639 | 40.794914085004 | 37E-AM-1013-03 | 37E | AM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9561103688639 40.794914085004) | ||||
2282 | 2282 | -73.9722056538718 | 40.7805111762703 | 17A-PM-1013-03 | 17A | PM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 15 | tree | 0 | 0 | 0 | 0 | 0 | grooming! & scratching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722056538718 40.7805111762703) | |||
2411 | 2411 | -73.9686907918759 | 40.7839462261858 | 22B-AM-1013-03 | 22B | AM | 10132018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686907918759 40.7839462261858) | |||||
2589 | 2589 | -73.9694166642262 | 40.7697788641081 | 8I-PM-1013-03 | 08I | PM | 10132018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694166642262 40.7697788641081) | ||||
2848 | 2848 | -73.97159771705479 | 40.774217265062205 | 11E-AM-1013-03 | 11E | AM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9715977170548 40.774217265062205) |
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 );