This data as json, CSV (advanced)
Suggested facets: Shift, 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, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions
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 | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
450 | 450 | -73.9644293195773 | 40.7813829172072 | 21F-AM-1018-02 | 21F | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9644293195773 40.7813829172072) | 19 | 4 | 19 | 13 | |||||
469 | 469 | -73.9717201378775 | 40.776120280884 | 13D-PM-1018-02 | 13D | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9717201378775 40.776120280884) | 19 | 4 | 19 | 13 | |||||
529 | 529 | -73.9635290751183 | 40.7820936628202 | 22G-AM-1018-02 | 22G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9635290751183 40.7820936628202) | 19 | 4 | 19 | 13 | ||||||
771 | 771 | -73.9648626810032 | 40.7804506112843 | 20G-AM-1018-02 | 20G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | Ran up tree | true | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9648626810032 40.7804506112843) | 19 | 4 | 19 | 13 | |||||
882 | 882 | -73.9786805884996 | 40.7697559231927 | 4B-PM-1018-02 | 04B | PM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9786805884996 40.7697559231927) | 19 | 4 | 19 | 13 | ||||||
1061 | 1061 | -73.9532657715601 | 40.7949046809422 | 39G-AM-1018-02 | 39G | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 25 | Tree | false | false | false | false | false | sitting & watching | false | false | false | false | false | false | true | false | POINT (-73.9532657715601 40.7949046809422) | 19 | 4 | 19 | 13 | ||||
1085 | 1085 | -73.9722265046794 | 40.7700916895929 | 7G-PM-1018-02 | 07G | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9722265046794 40.7700916895929) | 19 | 4 | 19 | 13 | |||||
1086 | 1086 | -73.9713399316534 | 40.7750678026757 | 12E-PM-1018-02 | 12E | PM | 10182018 | 2 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Above Ground | 3 | false | false | true | false | false | lounging on tree upside down | false | false | false | false | true | false | true | false | POINT (-73.9713399316534 40.7750678026757) | 19 | 4 | 19 | 13 | |||
1203 | 1203 | -73.9616999731028 | 40.7954126939561 | 36A-AM-1018-02 | 36A | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | false | false | false | true | false | eating (red berries) | false | false | false | false | false | false | true | false | POINT (-73.9616999731028 40.7954126939561) | 19 | 4 | 19 | 13 | ||||
1304 | 1304 | -73.9533319519277 | 40.7933647909449 | 37H-AM-1018-02 | 37H | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | Large tree by (fence of the conservatory) about to climb up | false | false | true | false | false | false | false | false | false | false | false | false | false | busy,ready to climb | POINT (-73.9533319519277 40.7933647909449) | 19 | 4 | 19 | 13 | |||||
1370 | 1370 | -73.9681627331154 | 40.7785099665602 | 17E-PM-1018-02 | 17E | PM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | On the rock | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9681627331154 40.7785099665602) | 19 | 4 | 19 | 13 | |||||
1415 | 1415 | -73.9678561384348 | 40.7782877397822 | 16E-PM-1018-02 | 16E | PM | 10182018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | false | false | gets distance from people but then continues to chase #1 | POINT (-73.9678561384348 40.7782877397822) | 19 | 4 | 19 | 13 | ||||
1434 | 1434 | -73.9760749752948 | 40.7703284894392 | 5D-PM-1018-02 | 05D | PM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | On low fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9760749752948 40.7703284894392) | 19 | 4 | 19 | 13 | |||||
1451 | 1451 | -73.9645365195454 | 40.7781531021263 | 18H-AM-1018-02 | 18H | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Tree | true | true | false | false | false | playing? | false | false | false | false | false | false | false | false | POINT (-73.9645365195454 40.7781531021263) | 19 | 4 | 19 | 13 | ||||
1528 | 1528 | -73.9690104245067 | 40.7853358193723 | 23A-AM-1018-02 | 23A | AM | 10182018 | 2 | Juvenile | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9690104245067 40.7853358193723) | 19 | 4 | 19 | 13 | ||||||
1531 | 1531 | -73.9630381400083 | 40.7807571827321 | 21H-PM-1018-02 | 21H | PM | 10182018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9630381400083 40.7807571827321) | 19 | 4 | 19 | 13 | |||||
1539 | 1539 | -73.9681874036914 | 40.7817948690964 | 20C-PM-1018-02 | 20C | PM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9681874036914 40.7817948690964) | 19 | 4 | 19 | 13 | ||||||
1632 | 1632 | -73.9592392692535 | 40.7961869951798 | 37B-AM-1018-02 | 37B | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9592392692535 40.7961869951798) | 19 | 4 | 19 | 13 | ||||||
1691 | 1691 | -73.9703705008688 | 40.7818586173755 | 19B-PM-1018-02 | 19B | PM | 10182018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9703705008688 40.7818586173755) | 19 | 4 | 19 | 13 | ||||
1895 | 1895 | -73.954699659637 | 40.7951308856929 | 38F-AM-1018-02 | 38F | AM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.954699659637 40.7951308856929) | 19 | 4 | 19 | 13 | |||||
1970 | 1970 | -73.9631464693769 | 40.793415656751 | 33A-PM-1018-02 | 33A | PM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | Tree cavity [of] London Plane tree | false | false | false | false | false | hanging out,watching world | false | false | false | false | false | false | false | false | watching | POINT (-73.9631464693769 40.793415656751) | 19 | 4 | 19 | 13 | ||
1989 | 1989 | -73.9631646754647 | 40.7925716810884 | 32A-AM-1018-02 | 32A | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9631646754647 40.7925716810884) | 19 | 4 | 19 | 13 | ||||||
2444 | 2444 | -73.966590487009 | 40.7802469052891 | 19E-PM-1018-02 | 19E | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.96659048700901 40.7802469052891) | 19 | 4 | 19 | 13 | |||||
2510 | 2510 | -73.9748635473782 | 40.7742591029151 | 10C-AM-1018-02 | 10C | AM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | sitting in the sun | false | false | false | false | false | false | true | false | POINT (-73.9748635473782 40.7742591029151) | 19 | 4 | 19 | 13 | ||||
2543 | 2543 | -73.9691424997919 | 40.780542852496 | 18C-AM-1018-02 | 18C | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691424997919 40.780542852496) | 19 | 4 | 19 | 13 | |||||
2611 | 2611 | -73.951448051873 | 40.7973951649254 | 42G-AM-1018-02 | 42G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.951448051873 40.7973951649254) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE squirrels( "Longitude" TEXT, "Latitude" TEXT, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" TEXT, "Hectare Squirrel Number" TEXT, "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" TEXT, "Chasing" TEXT, "Climbing" TEXT, "Eating" TEXT, "Foraging" TEXT, "Other Activities" TEXT, "Kuks" TEXT, "Quaas" TEXT, "Moans" TEXT, "Tail flags" TEXT, "Tail twitches" TEXT, "Approaches" TEXT, "Indifferent" TEXT, "Runs from" TEXT, "Other Interactions" TEXT, "Lat/Long" TEXT, "Zip Codes" TEXT, "Community Districts" TEXT, "Borough Boundaries" TEXT, "City Council Districts" TEXT, "Police Precincts" TEXT );