This data as json, CSV (advanced)
Suggested facets: 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, Climbing, Eating, Foraging, Kuks, Quaas, Moans, Tail twitches, Approaches, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1489 | 1489 | -73.9501762527462 | 40.7975534086077 | 42H-PM-1014-05 | 42H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9501762527462 40.7975534086077) | 12423 | 18 | 4 | 36 | 18 | ||||
3008 | 3008 | -73.9503533343658 | 40.7976543603953 | 42H-PM-1014-04 | 42H | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | true | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9503533343658 40.7976543603953) | 12423 | 18 | 4 | 36 | 18 | ||||
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 | ||||
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 | |||||
904 | 904 | -73.9531013359625 | 40.7921223556535 | 36I-PM-1007-04 | 36I | PM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9531013359625 40.7921223556535) | 19 | 4 | 19 | 13 | ||||||
724 | 724 | -73.9532952763106 | 40.7920074462622 | 36I-AM-1017-08 | 36I | AM | 10172018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#7) | false | false | false | false | true | false | false | true | runs from (me) | POINT (-73.95329527631061 40.7920074462622) | 19 | 4 | 19 | 13 | ||||
315 | 315 | -73.9539734770934 | 40.7956055442 | 39G-PM-1013-04 | 39G | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9539734770934 40.7956055442) | 19 | 4 | 19 | 13 | |||||
474 | 474 | -73.9540652304705 | 40.7955226178199 | 39G-PM-1013-05 | 39G | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540652304705 40.7955226178199) | 19 | 4 | 19 | 13 | |||||
1656 | 1656 | -73.9557399927792 | 40.7971563708988 | 40D-PM-1013-07 | 40D | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9557399927792 40.7971563708988) | 19 | 4 | 19 | 13 | |||||
547 | 547 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | true | true | false | false | false | chasing and being chased by #6 | false | false | false | false | true | false | false | true | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
1835 | 1835 | -73.9562068537632 | 40.7967332853238 | 39D-AM-1008-01 | 39D | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562068537632 40.7967332853238) | 19 | 4 | 19 | 13 | ||||||
1319 | 1319 | -73.9562105506291 | 40.7966991197909 | 39D-AM-1008-02 | 39D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562105506291 40.7966991197909) | 19 | 4 | 19 | 13 | ||||||
1038 | 1038 | -73.9563311167069 | 40.7950901563337 | 38E-AM-1010-12 | 38E | AM | 10102018 | 12 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | running on rocks | false | true | false | false | false | false | false | false | true | false | false | false | false | runs toward something | POINT (-73.9563311167069 40.7950901563337) | 19 | 4 | 19 | 13 | ||||
1224 | 1224 | -73.9572530843479 | 40.7987460430546 | 41B-AM-1010-05 | 41B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9572530843479 40.7987460430546) | 19 | 4 | 19 | 13 | |||||
2182 | 2182 | -73.9573656523498 | 40.7979754563974 | 40C-AM-1017-01 | 40C | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#2) | false | false | false | false | false | false | false | true | POINT (-73.9573656523498 40.7979754563974) | 19 | 4 | 19 | 13 | |||||
629 | 629 | -73.9573724133264 | 40.7980080911115 | 40C-AM-1017-02 | 40C | AM | 10172018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | true | false | chasing (#1) | false | false | false | false | false | false | false | true | POINT (-73.9573724133264 40.7980080911115) | 19 | 4 | 19 | 13 | ||||
108 | 108 | -73.9574809028248 | 40.7950013620207 | 37D-PM-1014-04 | 37D | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | chasing (a chipmunk) | false | false | false | false | false | false | false | true | POINT (-73.9574809028248 40.7950013620207) | 19 | 4 | 19 | 13 | |||||
1414 | 1414 | -73.9580513096783 | 40.79909641532 | 41B-AM-1010-02 | 41B | AM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 16 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9580513096783 40.79909641532) | 19 | 4 | 19 | 13 | |||||
1584 | 1584 | -73.9581310602492 | 40.7960214726964 | 38C-PM-1014-05 | 38C | PM | 10142018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | false | false | chasing (#4) | false | false | false | false | false | false | false | true | POINT (-73.9581310602492 40.7960214726964) | 19 | 4 | 19 | 13 | ||||
740 | 740 | -73.9583477850634 | 40.7914073632782 | 33F-PM-1012-06 | 33F | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | true | true | true | false | false | false | true | false | false | false | POINT (-73.9583477850634 40.7914073632782) | 19 | 4 | 19 | 13 | |||||
2214 | 2214 | -73.9583688637255 | 40.791388958496 | 33E-PM-1012-08 | 33E | PM | 10122018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9583688637255 40.791388958496) | 19 | 4 | 19 | 13 | |||||
772 | 772 | -73.9584188461059 | 40.7913241048498 | 33E-PM-1012-07 | 33E | PM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9584188461059 40.7913241048498) | 19 | 4 | 19 | 13 | |||||
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 | |||||
2205 | 2205 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 10122018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8 | on turn, see map | true | true | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
1760 | 1760 | -73.9597072533787 | 40.7905581853786 | 32E-AM-1007-12 | 32E | AM | 10072018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9597072533787 40.79055818537861) | 19 | 4 | 19 | 13 | ||||||
167 | 167 | -73.9597642778427 | 40.7976368003915 | 39A-PM-1014-02 | 39A | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9597642778427 40.7976368003915) | 19 | 4 | 19 | 13 | |||||
2236 | 2236 | -73.9597845469964 | 40.7906179303448 | 32E-AM-1007-11 | 32E | AM | 10072018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9597845469964 40.7906179303448) | 19 | 4 | 19 | 13 | ||||||
503 | 503 | -73.9598340783572 | 40.7915857030295 | 33D-PM-1006-02 | 33D | PM | 10062018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.95983407835722 40.7915857030295) | 19 | 4 | 19 | 13 | ||||||
2142 | 2142 | -73.9598535425706 | 40.7915589343685 | 33D-PM-1006-01 | 33D | PM | 10062018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | hanging on fence | true | false | false | true | false | false | false | true | POINT (-73.9598535425706 40.7915589343685) | 19 | 4 | 19 | 13 | |||||
628 | 628 | -73.9600165785486 | 40.7952466761832 | 36B-PM-1013-03 | 36B | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9600165785486 40.7952466761832) | 19 | 4 | 19 | 13 | |||||
497 | 497 | -73.9602166876979 | 40.7953811003986 | 36B-AM-1013-04 | 36B | AM | 10132018 | 4 | Black | Black+ | Above Ground | 20 | Moved 20+ feet high above top of tree limb | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9602166876979 40.7953811003986) | 19 | 4 | 19 | 13 | ||||||
103 | 103 | -73.9607701370443 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 10132018 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | false | true | false | false | false | chasing #8 | false | false | false | false | false | false | false | true | POINT (-73.9607701370443 40.7955418990855) | 19 | 4 | 19 | 13 | |||||
2663 | 2663 | -73.9613429184974 | 40.7912158057267 | 32C-AM-1014-02 | 32C | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9613429184974 40.7912158057267) | 19 | 4 | 19 | 13 | ||||||
958 | 958 | -73.9613862251332 | 40.791282169715 | 32C-AM-1014-03 | 32C | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9613862251332 40.791282169715) | 19 | 4 | 19 | 13 | ||||||
1872 | 1872 | -73.9613998967903 | 40.7912437235667 | 32C-PM-1013-02 | 32C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9613998967903 40.7912437235667) | 19 | 4 | 19 | 13 | ||||||
361 | 361 | -73.9614824437251 | 40.7912929799884 | 32C-PM-1013-03 | 32C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9614824437251 40.7912929799884) | 19 | 4 | 19 | 13 | ||||||
1143 | 1143 | -73.9628349778362 | 40.793887005206 | 34A-PM-1013-03 | 34A | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9628349778362 40.793887005206) | 19 | 4 | 19 | 13 | |||||
2796 | 2796 | -73.9631089011412 | 40.789191946875 | 29C-PM-1006-02 | 29C | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9631089011412 40.789191946875) | 19 | 4 | 19 | 13 | |||||
1698 | 1698 | -73.9631392113757 | 40.7914635635784 | 31B-PM-1007-02 | 31B | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | true | false | false | chasing #1 and climbing tree w/ #1 | false | false | false | false | false | false | false | true | POINT (-73.9631392113757 40.7914635635784) | 19 | 4 | 19 | 13 | ||||
1055 | 1055 | -73.9632337134707 | 40.7914682370734 | 31B-PM-1007-01 | 31B | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | true | false | false | chasing #2 and climbing tree w/ #2 | false | false | false | false | false | false | false | true | POINT (-73.9632337134707 40.7914682370734) | 19 | 4 | 19 | 13 | ||||
1009 | 1009 | -73.9636551433178 | 40.7901572818776 | 30B-PM-1019-02 | 30B | PM | 10192018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | true | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.9636551433178 40.7901572818776) | 19 | 4 | 19 | 13 | |||||
1128 | 1128 | -73.9638599044346 | 40.7809288795308 | 21G-AM-1014-06 | 21G | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9638599044346 40.7809288795308) | 19 | 4 | 19 | 13 | |||||
212 | 212 | -73.9638837160341 | 40.7809747900833 | 21G-AM-1014-07 | 21G | AM | 10142018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 5 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9638837160341 40.7809747900833) | 19 | 4 | 19 | 13 | |||||
2940 | 2940 | -73.963911430308 | 40.7809127228847 | 21G-AM-1014-05 | 21G | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.963911430308 40.7809127228847) | 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 | ||||
2313 | 2313 | -73.9646174034945 | 40.7781287528262 | 18H-AM-1018-01 | 18H | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Running from one tree to the other | true | true | false | false | false | playing? | false | false | false | false | false | false | false | false | POINT (-73.9646174034945 40.7781287528262) | 19 | 4 | 19 | 13 | |||
682 | 682 | -73.9651828383592 | 40.7802820943863 | 19F-PM-1017-06 | 19F | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | true | false | false | false | false | false | false | true | true | false | false | POINT (-73.9651828383592 40.7802820943863) | 19 | 4 | 19 | 13 | |||||
1754 | 1754 | -73.9652134469963 | 40.7803438278765 | 19F-PM-1017-05 | 19F | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9652134469963 40.7803438278765) | 19 | 4 | 19 | 13 | |||||
533 | 533 | -73.9652584749758 | 40.7803011124382 | 19F-PM-1017-04 | 19F | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9652584749758 40.7803011124382) | 19 | 4 | 19 | 13 | |||||
1700 | 1700 | -73.965675791028 | 40.7887310058451 | 27B-PM-1006-02 | 27B | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | By large tree chasing #1 | false | true | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.965675791028 40.7887310058451) | 19 | 4 | 19 | 13 | |||||
906 | 906 | -73.9664120826015 | 40.7888022709721 | 27A-AM-1008-01 | 27A | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96641208260151 40.7888022709721) | 19 | 4 | 19 | 13 | ||||||
421 | 421 | -73.9664630067791 | 40.7756361515825 | 14H-AM-1007-04 | 14H | AM | 10072018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664630067791 40.7756361515825) | 19 | 4 | 19 | 13 | |||||
72 | 72 | -73.9666007935638 | 40.7845098131567 | 23C-PM-1014-03 | 23C | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | false | true | false | false | false | chasing (#4 across trees) | false | false | false | false | false | false | false | false | POINT (-73.9666007935638 40.7845098131567) | 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 | ||
890 | 890 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | oak tree | false | true | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9667755678511 40.7760256836088) | 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 | |||||
360 | 360 | -73.9672054610151 | 40.7876519923501 | 26A-PM-1006-05 | 26A | PM | 10062018 | 5 | Adult | Gray | Gray+ | Above Ground | 40 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9672054610151 40.7876519923501) | 19 | 4 | 19 | 13 | ||||||
2839 | 2839 | -73.9672252136807 | 40.7876504743212 | 26A-PM-1006-04 | 26A | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 40 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9672252136807 40.7876504743212) | 19 | 4 | 19 | 13 | ||||||
633 | 633 | -73.9673243699918 | 40.7875392957722 | 26A-AM-1014-01 | 26A | AM | 10142018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | could not get close due to fences | POINT (-73.9673243699918 40.7875392957722) | 19 | 4 | 19 | 13 | |||||
2498 | 2498 | -73.9674556940019 | 40.7875399402461 | 26A-AM-1014-02 | 26A | AM | 10142018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | could not get close due to fences | POINT (-73.9674556940019 40.7875399402461) | 19 | 4 | 19 | 13 | |||||
1563 | 1563 | -73.9676270670996 | 40.776391443152 | 15G-AM-1008-04 | 15G | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9676270670996 40.776391443152) | 19 | 4 | 19 | 13 | ||||||
978 | 978 | -73.9676692772518 | 40.7764726688908 | 15G-AM-1008-03 | 15G | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9676692772518 40.7764726688908) | 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 | ||||
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 | |||||||
1688 | 1688 | -73.9677593344667 | 40.7763054313195 | 15G-PM-1019-07 | 15G | PM | 10192018 | 7 | Adult | + | Above Ground | 5 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9677593344667 40.7763054313195) | 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 | |||||
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 | ||||
2328 | 2328 | -73.9678620840741 | 40.784719027304 | 23B-PM-1012-03 | 23B | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | 2/3 were chasing each other | false | false | false | false | true | false | false | true | POINT (-73.96786208407411 40.784719027304) | 19 | 4 | 19 | 13 | ||||
762 | 762 | -73.9679291347956 | 40.7846973096665 | 23B-PM-1012-02 | 23B | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | 2/3 were chasing each other | false | false | false | false | true | false | false | true | POINT (-73.9679291347956 40.7846973096665) | 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 | ||||||
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 | ||||||
2899 | 2899 | -73.9686358129525 | 40.7778035516486 | 16E-AM-1014-05 | 16E | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686358129525 40.7778035516486) | 19 | 4 | 19 | 13 | |||||
2809 | 2809 | -73.9686756254868 | 40.7777459102651 | 16E-AM-1014-04 | 16E | AM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9686756254868 40.7777459102651) | 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 | |||||
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 | |||||
2365 | 2365 | -73.9688773306324 | 40.7766669852358 | 15F-AM-1007-05 | 15F | AM | 10072018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9688773306324 40.7766669852358) | 19 | 4 | 19 | 13 | |||||
2733 | 2733 | -73.9690082314914 | 40.7738993942891 | 12G-AM-1012-05 | 12G | AM | 10122018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.9690082314914 40.7738993942891) | 19 | 4 | 19 | 13 | |||||
2930 | 2930 | -73.9692563597762 | 40.770904999952 | 9H-PM-1018-05 | 09H | PM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9692563597762 40.770904999952) | 19 | 4 | 19 | 13 | ||||||
2676 | 2676 | -73.9692849074642 | 40.7708755098145 | 9H-PM-1018-06 | 09H | PM | 10182018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9692849074642 40.7708755098145) | 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 | |||||
1649 | 1649 | -73.969347812694 | 40.7744098063421 | 12G-PM-1007-02 | 12G | PM | 10072018 | 2 | Gray | Gray+ | Above Ground | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.969347812694 40.7744098063421) | 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 | ||||
1864 | 1864 | -73.9694344956258 | 40.7742869276902 | 12G-PM-1007-01 | 12G | PM | 10072018 | 1 | Gray | Gray+ | Above Ground | 40 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9694344956258 40.7742869276902) | 19 | 4 | 19 | 13 | ||||||
732 | 732 | -73.9695041366722 | 40.7797878809482 | 17D-AM-1008-02 | 17D | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9695041366722 40.7797878809482) | 19 | 4 | 19 | 13 | |||||
1797 | 1797 | -73.9697178096275 | 40.7697036696301 | 7I-PM-1013-07 | 07I | PM | 10132018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | Under the tree | false | true | false | false | false | playing,interacting with #6 | false | false | false | false | true | false | false | false | POINT (-73.9697178096275 40.769703669630104) | 19 | 4 | 19 | 13 | |||
2018 | 2018 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 10182018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
598 | 598 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 10182018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
1267 | 1267 | -73.9701010964667 | 40.7688919314508 | 6I-PM-1013-02 | 06I | PM | 10132018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | Bushes | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9701010964667 40.76889193145081) | 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 | ||||||
84 | 84 | -73.9701824825872 | 40.7766530579293 | 14E-AM-1008-09 | 14E | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.9701824825872 40.7766530579293) | 19 | 4 | 19 | 13 | ||||||
1040 | 1040 | -73.9702588981432 | 40.776610754288 | 14E-AM-1008-08 | 14E | AM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9702588981432 40.776610754288) | 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 | ||||
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 | ||||
471 | 471 | -73.9707215394887 | 40.7727508149058 | 10G-AM-1006-05 | 10G | AM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#6) | true | false | false | false | false | false | false | false | POINT (-73.9707215394887 40.7727508149058) | 19 | 4 | 19 | 13 | |||||
1395 | 1395 | -73.9710801547498 | 40.7760872452093 | 13D-AM-1014-03 | 13D | AM | 10142018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 2 | false | true | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9710801547498 40.7760872452093) | 19 | 4 | 19 | 13 | |||||
2509 | 2509 | -73.9714295102249 | 40.776954371947 | 14D-PM-1019-02 | 14D | PM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9714295102249 40.776954371947) | 19 | 4 | 19 | 13 | ||||||
1997 | 1997 | -73.9714637683084 | 40.7768984561563 | 14D-PM-1019-01 | 14D | PM | 10192018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9714637683084 40.7768984561563) | 19 | 4 | 19 | 13 | ||||||
721 | 721 | -73.9718262034469 | 40.7666771797442 | 4I-PM-1007-02 | 04I | PM | 10072018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9718262034469 40.7666771797442) | 19 | 4 | 19 | 13 | ||||||
1525 | 1525 | -73.9727115915422 | 40.7782929320632 | 14B-PM-1014-02 | 14B | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9727115915422 40.7782929320632) | 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 );