This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53 | 53 | -73.9584970643213 | 40.7982886348696 | 40B-AM-1019-03 | 40B | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | true | false | false | POINT (-73.9584970643213 40.7982886348696) | 19 | 4 | 19 | 13 | |||||
172 | 172 | -73.958535640774 | 40.7982737896998 | 40B-AM-1019-02 | 40B | AM | 10192018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.958535640774 40.7982737896998) | 19 | 4 | 19 | 13 | |||||
222 | 222 | -73.9770273553525 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 10132018 | 3 | Juvenile | + | Above Ground | 3 | fence | true | true | true | true | false | playing tag together | false | false | false | false | false | true | false | false | POINT (-73.9770273553525 40.7732399463626) | 19 | 4 | 19 | 13 | |||||
596 | 596 | -73.9769319450348 | 40.7743883576247 | 9A-AM-1013-11 | 09A | AM | 10132018 | 11 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | foot of tree | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9769319450348 40.7743883576247) | 19 | 4 | 19 | 13 | ||||
608 | 608 | -73.9589675995517 | 40.7913119223584 | 33E-AM-1014-09 | 33E | AM | 10142018 | 9 | Juvenile | Black | Black+ | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9589675995517 40.7913119223584) | 19 | 4 | 19 | 13 | ||||||
725 | 725 | -73.9689627791 | 40.776062004359 | 14F-AM-1007-06 | 14F | AM | 10072018 | 6 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9689627791 40.776062004359) | 19 | 4 | 19 | 13 | |||||
729 | 729 | -73.9776044578446 | 40.7697607308033 | 4C-PM-1010-15 | 04C | PM | 10102018 | 15 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on tree | false | true | false | false | false | chasing #14 | false | false | false | false | false | false | true | false | POINT (-73.9776044578446 40.7697607308033) | 19 | 4 | 19 | 13 | ||||
751 | 751 | -73.9683479943823 | 40.7815827298303 | 20C-PM-1018-01 | 20C | PM | 10182018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9683479943823 40.7815827298303) | 19 | 4 | 19 | 13 | ||||||
1004 | 1004 | -73.9670850805619 | 40.7833747810387 | 22C-PM-1006-01 | 22C | PM | 10062018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | for food | false | true | false | false | false | false | false | false | POINT (-73.9670850805619 40.7833747810387) | 19 | 4 | 19 | 13 | |||||
1068 | 1068 | -73.96660639702 | 40.7756655031741 | 14H-AM-1007-03 | 14H | AM | 10072018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.96660639702002 40.7756655031741) | 19 | 4 | 19 | 13 | |||||
1172 | 1172 | -73.9706929270645 | 40.7727841119424 | 10G-AM-1006-06 | 10G | AM | 10062018 | 6 | Juvenile | Gray | Gray+ | skinny tail | Ground Plane | FALSE | false | true | false | false | false | chasing (#5) | true | false | false | false | false | false | false | false | POINT (-73.9706929270645 40.7727841119424) | 19 | 4 | 19 | 13 | ||||
1302 | 1302 | -73.9704024529864 | 40.7729256063889 | 10G-AM-1006-04 | 10G | AM | 10062018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | chasing (#3) | true | false | false | false | false | false | false | false | POINT (-73.9704024529864 40.7729256063889) | 19 | 4 | 19 | 13 | ||||
1411 | 1411 | -73.9802840031759 | 40.7678599069819 | 1B-PM-1019-04 | 01B | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9802840031759 40.7678599069819) | 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 | ||||
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 | |||||
1623 | 1623 | -73.9770119133023 | 40.7732949090005 | 8A-AM-1013-04 | 08A | AM | 10132018 | 4 | Juvenile | + | Above Ground | 4 | fence | true | true | false | true | true | playing tag together | false | false | false | false | false | true | false | false | POINT (-73.9770119133023 40.7732949090005) | 19 | 4 | 19 | 13 | |||||
1673 | 1673 | -73.9746940851342 | 40.7760966488186 | 11B-PM-1014-02 | 11B | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9746940851342 40.7760966488186) | 19 | 4 | 19 | 13 | ||||||
1705 | 1705 | -73.9765417282001 | 40.7740994735325 | 9A-AM-1013-05 | 09A | AM | 10132018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9765417282001 40.7740994735325) | 19 | 4 | 19 | 13 | |||||
1790 | 1790 | -73.9730592548116 | 40.7740879251541 | 10D-AM-1008-04 | 10D | AM | 10082018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 25 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9730592548116 40.7740879251541) | 19 | 4 | 19 | 13 | ||||||
1822 | 1822 | -73.9775099290913 | 40.7697609063137 | 4C-PM-1010-14 | 04C | PM | 10102018 | 14 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | true | false | false | false | chasing #15 | false | false | false | false | false | false | false | false | POINT (-73.9775099290913 40.7697609063137) | 19 | 4 | 19 | 13 | ||||
1832 | 1832 | -73.9693159934697 | 40.7831212338295 | 21B-PM-1017-03 | 21B | PM | 10172018 | 3 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 1 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9693159934697 40.7831212338295) | 19 | 4 | 19 | 13 | |||||
1916 | 1916 | -73.9693504617353 | 40.7830678709405 | 21B-PM-1017-02 | 21B | PM | 10172018 | 2 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 1 | false | true | false | false | false | false | true | false | false | false | false | false | false | stood on hind legs with front legs on the chest | POINT (-73.9693504617353 40.7830678709405) | 19 | 4 | 19 | 13 | ||||
2029 | 2029 | -73.9687213827744 | 40.7843586374648 | 22B-PM-1014-02 | 22B | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9687213827744 40.7843586374648) | 19 | 4 | 19 | 13 | |||||
2303 | 2303 | -73.9589470461357 | 40.7912817646361 | 33E-AM-1014-10 | 33E | AM | 10142018 | 10 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9589470461357 40.7912817646361) | 19 | 4 | 19 | 13 | |||||
2465 | 2465 | -73.9686999860219 | 40.7844014735136 | 22B-PM-1014-03 | 22B | PM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686999860219 40.7844014735136) | 19 | 4 | 19 | 13 | |||||
2653 | 2653 | -73.958932543729 | 40.7913445531266 | 33E-AM-1014-11 | 33E | AM | 10142018 | 11 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.958932543729 40.7913445531266) | 19 | 4 | 19 | 13 | |||||
2708 | 2708 | -73.9528429238071 | 40.7922651848867 | 36I-PM-1007-09 | 36I | PM | 10072018 | 9 | Juvenile | Gray | Gray+ | Above Ground | 5 | true | true | false | false | false | burying nut | false | false | false | false | true | false | false | false | POINT (-73.9528429238071 40.7922651848867) | 19 | 4 | 19 | 13 | |||||
2845 | 2845 | -73.9765016413674 | 40.7740672862953 | 9A-AM-1013-06 | 09A | AM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9765016413674 40.7740672862953) | 19 | 4 | 19 | 13 | |||||
2865 | 2865 | -73.9802842404016 | 40.7678257384977 | 1B-PM-1019-03 | 01B | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.98028424040162 40.7678257384977) | 19 | 4 | 19 | 13 | ||||
2919 | 2919 | -73.9768563402344 | 40.7744487310786 | 9A-AM-1013-12 | 09A | AM | 10132018 | 12 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | foot of tree | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9768563402344 40.7744487310786) | 19 | 4 | 19 | 13 | ||||
2982 | 2982 | -73.9513477815203 | 40.7945259614138 | 39I-PM-1013-02 | 39I | PM | 10132018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | along the road | false | true | true | false | false | playing | false | false | false | false | false | false | false | false | POINT (-73.9513477815203 40.7945259614138) | 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 );