This data as json, CSV (advanced)
Suggested facets: 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, Moans, Tail flags, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2815 | 2815 | -73.9747311312394 | 40.7677319725044 | 3F-PM-1013-06 | 03F | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 19 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.97473113123941 40.7677319725044) | 19 | 4 | 19 | 13 | |||||
514 | 514 | -73.9768357173861 | 40.7683813358343 | 3D-PM-1010-12 | 03D | PM | 10102018 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | true | false | false | true | false | true | false | false | false | false | false | false | POINT (-73.9768357173861 40.7683813358343) | 19 | 4 | 19 | 13 | |||||
1768 | 1768 | -73.9773696455031 | 40.7687241866704 | 3D-PM-1010-14 | 03D | PM | 10102018 | 14 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | false | false | crying out | true | true | false | false | false | false | false | false | POINT (-73.9773696455031 40.7687241866704) | 19 | 4 | 19 | 13 | ||||
1799 | 1799 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 10102018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | false | true | false | false | false | chasing squirrel #6 | true | true | false | false | true | false | false | false | POINT (-73.978844141973 40.7696046074378) | 19 | 4 | 19 | 13 | ||||
476 | 476 | -73.9690968160819 | 40.769923269444 | 8I-AM-1006-08 | 08I | AM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | tree | false | false | false | false | false | true | true | false | false | false | false | false | false | not backing down | POINT (-73.9690968160819 40.769923269444) | 19 | 4 | 19 | 13 | |||
1629 | 1629 | -73.9759428006237 | 40.7715081817329 | 7C-PM-1020-06 | 07C | PM | 10202018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9759428006237 40.7715081817329) | 19 | 4 | 19 | 13 | ||||||
449 | 449 | -73.9701335162984 | 40.7722051011357 | 10G-AM-1006-10 | 10G | AM | 10062018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9701335162984 40.7722051011357) | 19 | 4 | 19 | 13 | ||||||
137 | 137 | -73.9782417115139 | 40.7724665036447 | 7A-AM-1006-01 | 07A | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | in tree | false | false | false | false | true | false | true | false | false | true | false | false | false | looked at us | POINT (-73.9782417115139 40.7724665036447) | 19 | 4 | 19 | 13 | |||
1135 | 1135 | -73.9667474482967 | 40.7760643720793 | 15H-PM-1008-01 | 15H | PM | 10082018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Oak tree | false | true | false | false | false | watching me | false | true | false | true | false | false | false | false | observant | POINT (-73.9667474482967 40.7760643720793) | 19 | 4 | 19 | 13 | ||
1037 | 1037 | -73.9677409841969 | 40.7763579140639 | 15G-PM-1019-08 | 15G | PM | 10192018 | 8 | Adult | + | Above Ground | 5 | false | true | false | false | false | false | true | true | false | false | false | false | false | POINT (-73.9677409841969 40.7763579140639) | 19 | 4 | 19 | 13 | |||||||
1475 | 1475 | -73.9686778167484 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 10122018 | 4 | + | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.96867781674841 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
306 | 306 | -73.9689700100267 | 40.7775169562765 | 15E-PM-1008-05 | 15E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | sitting | false | true | false | false | false | false | false | false | POINT (-73.9689700100267 40.7775169562765) | 19 | 4 | 19 | 13 | |||||
1581 | 1581 | -73.97157754108 | 40.7776249963967 | 14C-PM-1006-01 | 14C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.97157754108 40.7776249963967) | 19 | 4 | 19 | 13 | |||||
1163 | 1163 | -73.9677096985223 | 40.7825358361204 | 21C-AM-1014-02 | 21C | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 50 | true | true | true | false | true | false | true | false | false | false | false | false | false | looked at us from tree | POINT (-73.9677096985223 40.7825358361204) | 19 | 4 | 19 | 13 | ||||
2933 | 2933 | -73.9677903197449 | 40.7826561917755 | 21C-AM-1014-03 | 21C | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | true | true | false | false | false | true | false | false | false | false | false | false | looked at us from tree | POINT (-73.9677903197449 40.7826561917755) | 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 | ||||
1554 | 1554 | -73.9597462612063 | 40.7832801145306 | 25I-PM-1007-06 | 25I | PM | 10072018 | 6 | + | Didn't see squirrel size, or colors | Above Ground | 20 | up in tree | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9597462612063 40.7832801145306) | 19 | 4 | 19 | 13 | ||||||
1002 | 1002 | -73.9672070423666 | 40.783337354891 | 22C-PM-1006-02 | 22C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9672070423666 40.783337354891) | 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 | |||||
411 | 411 | -73.9669366401071 | 40.7836023897982 | 22C-PM-1006-09 | 22C | PM | 10062018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.96693664010711 40.7836023897982) | 19 | 4 | 19 | 13 | ||||||
858 | 858 | -73.9629383420274 | 40.7889383725489 | 29C-AM-1007-02 | 29C | AM | 10072018 | 2 | Adult | Black | Gray | Black+Gray | Above Ground | 10 | true | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9629383420274 40.7889383725489) | 19 | 4 | 19 | 13 | |||||
2724 | 2724 | -73.9611434082667 | 40.7893671772846 | 30E-PM-1008-01 | 30E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | true | false | false | false | false | false | false | POINT (-73.9611434082667 40.7893671772846) | 19 | 4 | 19 | 13 | |||||
1789 | 1789 | -73.9596271142953 | 40.7906612313673 | 32E-PM-1017-12 | 32E | PM | 10172018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | true | false | false | false | false | false | false | POINT (-73.9596271142953 40.7906612313673) | 19 | 4 | 19 | 13 | ||||||
433 | 433 | -73.9558474701153 | 40.7913335515534 | 34H-AM-1007-01 | 34H | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | tree | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.9558474701153 40.7913335515534) | 19 | 4 | 19 | 13 | ||||
2206 | 2206 | -73.9594446018346 | 40.7917800352042 | 33D-AM-1017-06 | 33D | AM | 10172018 | 6 | Adult | Black | Black+ | Above Ground | 10 | false | false | true | false | false | true | true | false | false | false | false | false | true | runs from (ran into hole in tree trunk) | POINT (-73.9594446018346 40.7917800352042) | 19 | 4 | 19 | 13 | |||||
258 | 258 | -73.9534333425633 | 40.7932564163328 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | false | false | false | true | false | false | true | false | false | false | false | false | true | POINT (-73.9534333425633 40.7932564163328) | 19 | 4 | 19 | 13 | ||||
1077 | 1077 | -73.9541837143178 | 40.7944340477396 | 38G-PM-1020-06 | 38G | PM | 10202018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | true | false | false | false | false | false | true | POINT (-73.9541837143178 40.7944340477396) | 19 | 4 | 19 | 13 | |||||
101 | 101 | -73.9544007658685 | 40.7950689723135 | 38F-PM-1013-05 | 38F | PM | 10132018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | being chased,was pushed by other squirrel | true | true | false | false | false | false | false | false | POINT (-73.9544007658685 40.7950689723135) | 19 | 4 | 19 | 13 | ||||
2577 | 2577 | -73.9597048490102 | 40.7955846466241 | 37B-AM-1018-06 | 37B | AM | 10182018 | 6 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9597048490102 40.7955846466241) | 19 | 4 | 19 | 13 | ||||||
185 | 185 | -73.9588468413094 | 40.7963852299012 | 38B-AM-1019-05 | 38B | AM | 10192018 | 5 | Adult | Gray | Gray+ | Above Ground | 28 | false | false | true | false | false | sitting still | false | true | false | false | false | false | false | false | POINT (-73.9588468413094 40.7963852299012) | 19 | 4 | 19 | 13 | |||||
1807 | 1807 | -73.9581366214863 | 40.7988964092722 | 40B-PM-1014-02 | 40B | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | true | true | false | false | false | false | false | true | POINT (-73.9581366214863 40.7988964092722) | 19 | 4 | 19 | 13 | ||||||
1244 | 1244 | -73.9565260889843 | 40.7991807924337 | 42C-AM-1007-03 | 42C | AM | 10072018 | 3 | + | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9565260889843 40.79918079243371) | 19 | 4 | 19 | 13 | ||||||||||
92 | 92 | -73.9565759733611 | 40.7992461674802 | 42C-AM-1007-02 | 42C | AM | 10072018 | 2 | + | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9565759733611 40.7992461674802) | 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 );