This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17 | 17 | -73.9695063535333 | 40.7823507678183 | 20B-PM-1013-05 | 20B | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9695063535333 40.7823507678183) | 19 | 4 | 19 | 13 | |||||
36 | 36 | -73.9662438996681 | 40.7890381809441 | 28A-PM-1007-05 | 28A | PM | 10072018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9662438996681 40.7890381809441) | 19 | 4 | 19 | 13 | ||||||
59 | 59 | -73.9684910712272 | 40.7768811640021 | 15F-PM-1010-05 | 15F | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9684910712272 40.7768811640021) | 19 | 4 | 19 | 13 | ||||||
66 | 66 | -73.9749243901189 | 40.7761393551781 | 11B-PM-1014-05 | 11B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9749243901189 40.7761393551781) | 19 | 4 | 19 | 13 | ||||||
70 | 70 | -73.9804528867547 | 40.7696753655986 | 3A-PM-1017-05 | 03A | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9804528867547 40.76967536559861) | 19 | 4 | 19 | 13 | |||||
90 | 90 | -73.9787180870736 | 40.7715877863274 | 5A-AM-1006-05 | 05A | AM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | near 65th St arch | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9787180870736 40.7715877863274) | 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 | ||||
104 | 104 | -73.9764036522984 | 40.7705846185121 | 5C-AM-1006-05 | 05C | AM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9764036522984 40.7705846185121) | 19 | 4 | 19 | 13 | |||||
128 | 128 | -73.9746229094643 | 40.7748467061969 | 10B-PM-1014-05 | 10B | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | false | false | avoided people | POINT (-73.9746229094643 40.7748467061969) | 19 | 4 | 19 | 13 | ||||
131 | 131 | -73.9755560786227 | 40.7662992317575 | 2F-AM-1006-05 | 02F | AM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | curious but shy | POINT (-73.9755560786227 40.7662992317575) | 19 | 4 | 19 | 13 | ||||
202 | 202 | -73.9718729101676 | 40.7703692621371 | 7G-PM-1018-05 | 07G | PM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9718729101676 40.7703692621371) | 19 | 4 | 19 | 13 | ||||||
203 | 203 | -73.9638774579549 | 40.7913532129148 | 31A-AM-1010-05 | 31A | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | jumping | false | false | false | true | true | false | true | false | eventually ran from lawnmower (tail flag) | POINT (-73.9638774579549 40.7913532129148) | 19 | 4 | 19 | 13 | ||||
208 | 208 | -73.9677646187171 | 40.7746492806333 | 13H-PM-1010-05 | 13H | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9677646187171 40.7746492806333) | 19 | 4 | 19 | 13 | ||||||
231 | 231 | -73.9527808174534 | 40.7924167234441 | 36I-AM-1017-05 | 36I | AM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | runs from (me) | POINT (-73.9527808174534 40.7924167234441) | 19 | 4 | 19 | 13 | ||||
239 | 239 | -73.9758464905133 | 40.7725957408841 | 8C-PM-1013-05 | 08C | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9758464905133 40.7725957408841) | 19 | 4 | 19 | 13 | |||||
247 | 247 | -73.9733117663541 | 40.7694584620114 | 6F-PM-1008-05 | 06F | PM | 10082018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white patch | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.97331176635412 40.7694584620114) | 19 | 4 | 19 | 13 | ||||
263 | 263 | -73.9771069181511 | 40.7670538214988 | 2E-PM-1014-05 | 02E | PM | 10142018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9771069181511 40.7670538214988) | 19 | 4 | 19 | 13 | |||||
313 | 313 | -73.9646610347972 | 40.7790583544252 | 19H-AM-1010-05 | 19H | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | near a brush | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9646610347972 40.7790583544252) | 19 | 4 | 19 | 13 | ||||
355 | 355 | -73.9639635134738 | 40.7900337598704 | 29B-PM-1010-05 | 29B | PM | 10102018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9639635134738 40.7900337598704) | 19 | 4 | 19 | 13 | |||||
357 | 357 | -73.9724801784201 | 40.7790131966689 | 15B-PM-1017-05 | 15B | PM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9724801784201 40.7790131966689) | 19 | 4 | 19 | 13 | |||||
370 | 370 | -73.9548957862084 | 40.7944844464619 | 37G-AM-1014-05 | 37G | AM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9548957862084 40.7944844464619) | 19 | 4 | 19 | 13 | ||||||
397 | 397 | -73.9690416961886 | 40.7716618670996 | 10H-AM-1014-05 | 10H | AM | 10142018 | 5 | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9690416961886 40.7716618670996) | 19 | 4 | 19 | 13 | |||||||
412 | 412 | -73.9785675798034 | 40.7672992405289 | 1C-PM-1013-05 | 01C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9785675798034 40.7672992405289) | 19 | 4 | 19 | 13 | ||||||
436 | 436 | -73.9734695768004 | 40.7716297491384 | 8E-PM-1008-05 | 08E | PM | 10082018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9734695768004 40.7716297491384) | 19 | 4 | 19 | 13 | ||||
439 | 439 | -73.9589770206691 | 40.791240542172 | 33E-AM-1014-05 | 33E | AM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9589770206691 40.791240542172) | 19 | 4 | 19 | 13 | |||||
456 | 456 | -73.9547878025303 | 40.7899151873467 | 33I-PM-1006-05 | 33I | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9547878025303 40.7899151873467) | 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 | |||||
475 | 475 | -73.9697855573137 | 40.7742186391935 | 12F-PM-1007-05 | 12F | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9697855573137 40.7742186391935) | 19 | 4 | 19 | 13 | |||||
516 | 516 | -73.9597418366664 | 40.7964417084985 | 37B-PM-1013-05 | 37B | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9597418366664 40.7964417084985) | 19 | 4 | 19 | 13 | |||||
527 | 527 | -73.9632646049622 | 40.7817401292083 | 22G-AM-1018-05 | 22G | AM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9632646049622 40.7817401292083) | 19 | 4 | 19 | 13 | |||||
538 | 538 | -73.9553113771098 | 40.7978431980204 | 41D-AM-1014-05 | 41D | AM | 10142018 | 5 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9553113771098 40.7978431980204) | 19 | 4 | 19 | 13 | |||||
558 | 558 | -73.9579335275486 | 40.7953080673706 | 37D-PM-1014-05 | 37D | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9579335275486 40.7953080673706) | 19 | 4 | 19 | 13 | ||||||
590 | 590 | -73.9785133301426 | 40.7718260288338 | 6A-PM-1012-05 | 06A | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9785133301426 40.7718260288338) | 19 | 4 | 19 | 13 | |||||
595 | 595 | -73.9742804552383 | 40.7707167671865 | 7E-PM-1013-05 | 07E | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | On rocks | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9742804552383 40.7707167671865) | 19 | 4 | 19 | 13 | ||||
599 | 599 | -73.9530263552489 | 40.7920949788358 | 36I-PM-1007-05 | 36I | PM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9530263552489 40.7920949788358) | 19 | 4 | 19 | 13 | ||||||
644 | 644 | -73.972212563004 | 40.7761311465857 | 13C-PM-1019-05 | 13C | PM | 10192018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | true | true | false | POINT (-73.972212563004 40.7761311465857) | 19 | 4 | 19 | 13 | |||||
672 | 672 | -73.9588708103486 | 40.7905794078843 | 32F-PM-1008-05 | 32F | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9588708103486 40.7905794078843) | 19 | 4 | 19 | 13 | ||||||
689 | 689 | -73.970595381455 | 40.7762912142457 | 13E-PM-1008-05 | 13E | PM | 10082018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.970595381455 40.7762912142457) | 19 | 4 | 19 | 13 | |||||
697 | 697 | -73.970465600402 | 40.7701125773248 | 7H-PM-1006-05 | 07H | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ran across path to eat behind fence, next to the fence. | true | false | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.970465600402 40.7701125773248) | 19 | 4 | 19 | 13 | ||||
735 | 735 | -73.971379936565 | 40.7721434941226 | 9F-PM-1014-05 | 09F | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.971379936565 40.7721434941226) | 19 | 4 | 19 | 13 | |||||
793 | 793 | -73.9730111650468 | 40.7782157736204 | 14B-PM-1014-05 | 14B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9730111650468 40.7782157736204) | 19 | 4 | 19 | 13 | ||||||
810 | 810 | -73.967418114684 | 40.7764595360054 | 15G-AM-1008-05 | 15G | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.967418114684 40.7764595360054) | 19 | 4 | 19 | 13 | |||||
863 | 863 | -73.9764016030666 | 40.7689894344251 | 4D-PM-1008-05 | 04D | PM | 10082018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9764016030666 40.7689894344251) | 19 | 4 | 19 | 13 | |||||
864 | 864 | -73.969485639023 | 40.780519159069 | 18C-PM-1018-05 | 18C | PM | 10182018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.969485639023 40.780519159069) | 19 | 4 | 19 | 13 | |||||
887 | 887 | -73.9635028497015 | 40.7928207574906 | 32A-PM-1013-05 | 32A | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9635028497015 40.7928207574906) | 19 | 4 | 19 | 13 | |||||
905 | 905 | -73.9757216124349 | 40.7754310239649 | 11A-PM-1013-05 | 11A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | digging | false | false | false | false | true | false | false | false | POINT (-73.9757216124349 40.7754310239649) | 19 | 4 | 19 | 13 | ||||
909 | 909 | -73.9665705456197 | 40.7823552871044 | 21D-PM-1008-05 | 21D | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9665705456197 40.7823552871044) | 19 | 4 | 19 | 13 | |||||
921 | 921 | -73.9698959071826 | 40.7716763799299 | 9H-AM-1006-05 | 09H | AM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9698959071826 40.7716763799299) | 19 | 4 | 19 | 13 | |||||
975 | 975 | -73.956869086031 | 40.7988858771114 | 41C-AM-1017-05 | 41C | AM | 10172018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.956869086031 40.7988858771114) | 19 | 4 | 19 | 13 | ||||||
989 | 989 | -73.9603031059614 | 40.7943667735668 | 35C-PM-1013-05 | 35C | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9603031059614 40.7943667735668) | 19 | 4 | 19 | 13 | |||||
994 | 994 | -73.9718553361982 | 40.7748584798761 | 11D-AM-1010-05 | 11D | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9718553361982 40.7748584798761) | 19 | 4 | 19 | 13 | |||||
1014 | 1014 | -73.9694468044483 | 40.770360886038 | 8I-PM-1013-05 | 08I | PM | 10132018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9694468044483 40.770360886038) | 19 | 4 | 19 | 13 | |||||
1043 | 1043 | -73.9758564394842 | 40.7674758942811 | 3E-AM-1006-05 | 03E | AM | 10062018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9758564394842 40.7674758942811) | 19 | 4 | 19 | 13 | ||||||
1196 | 1196 | -73.9580111496275 | 40.7985365971474 | 40B-AM-1019-05 | 40B | AM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | true | true | false | POINT (-73.9580111496275 40.7985365971474) | 19 | 4 | 19 | 13 | |||||
1312 | 1312 | -73.9712034320741 | 40.7764415506669 | 13D-PM-1018-05 | 13D | PM | 10182018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | true | true | false | POINT (-73.9712034320741 40.7764415506669) | 19 | 4 | 19 | 13 | ||||
1320 | 1320 | -73.9554327683595 | 40.7953846381499 | 38E-AM-1010-05 | 38E | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | interested in my presence | POINT (-73.9554327683595 40.7953846381499) | 19 | 4 | 19 | 13 | ||||
1336 | 1336 | -73.9733820053679 | 40.7687330473562 | 5G-PM-1010-05 | 05G | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9733820053679 40.7687330473562) | 19 | 4 | 19 | 13 | |||||
1347 | 1347 | -73.9616693665254 | 40.792971019627 | 33B-AM-1010-05 | 33B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9616693665254 40.792971019627) | 19 | 4 | 19 | 13 | |||||
1366 | 1366 | -73.9711582199102 | 40.7783674409485 | 15C-PM-1017-05 | 15C | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | true | false | false | false | true | true | false | false | POINT (-73.9711582199102 40.7783674409485) | 19 | 4 | 19 | 13 | |||||
1382 | 1382 | -73.9611274898661 | 40.7915250069086 | 32C-AM-1014-05 | 32C | AM | 10142018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9611274898661 40.7915250069086) | 19 | 4 | 19 | 13 | ||||||
1456 | 1456 | -73.9714242426496 | 40.7744535798123 | 11E-PM-1012-05 | 11E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | foraging (foraged,ran to tree root,munched) | false | false | false | false | false | false | true | false | POINT (-73.9714242426496 40.7744535798123) | 19 | 4 | 19 | 13 | ||||
1501 | 1501 | -73.9608167300104 | 40.7954348688268 | 36A-PM-1013-05 | 36A | PM | 10132018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | EDGE OF WOODS | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9608167300104 40.7954348688268) | 19 | 4 | 19 | 13 | |||||
1519 | 1519 | -73.971730277301 | 40.7748805439381 | 11D-PM-1006-05 | 11D | PM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.971730277301 40.7748805439381) | 19 | 4 | 19 | 13 | |||||
1571 | 1571 | -73.9673129010312 | 40.7778169845999 | 16F-PM-1013-05 | 16F | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Pine tree near utility shed | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9673129010312 40.7778169845999) | 19 | 4 | 19 | 13 | ||||
1606 | 1606 | -73.9628932797886 | 40.7923116396365 | 32B-PM-1010-05 | 32B | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9628932797886 40.7923116396365) | 19 | 4 | 19 | 13 | ||||||
1637 | 1637 | -73.9699513151755 | 40.7722062991044 | 10G-PM-1017-05 | 10G | PM | 10172018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9699513151755 40.7722062991044) | 19 | 4 | 19 | 13 | ||||||
1660 | 1660 | -73.9800499498034 | 40.7702181099573 | 4A-PM-1007-05 | 04A | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | At rock | false | false | false | false | true | false | false | false | true | true | false | true | false | POINT (-73.9800499498034 40.770218109957305) | 19 | 4 | 19 | 13 | ||||
1676 | 1676 | -73.9566686940197 | 40.794924397955 | 37E-PM-1006-05 | 37E | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9566686940197 40.794924397955) | 19 | 4 | 19 | 13 | |||||
1711 | 1711 | -73.975836799137 | 40.7691593428471 | 4E-PM-1008-05 | 04E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.975836799137 40.769159342847104) | 19 | 4 | 19 | 13 | ||||||
1722 | 1722 | -73.9802564685265 | 40.7681759098199 | 2B-AM-1010-05 | 02B | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9802564685265 40.7681759098199) | 19 | 4 | 19 | 13 | |||||
1728 | 1728 | -73.9787846880249 | 40.7682545903488 | 2C-PM-1013-05 | 02C | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9787846880249 40.7682545903488) | 19 | 4 | 19 | 13 | |||||
1763 | 1763 | -73.9768286349595 | 40.7687012827059 | 3D-PM-1010-05 | 03D | PM | 10102018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9768286349595 40.7687012827059) | 19 | 4 | 19 | 13 | ||||||
1784 | 1784 | -73.9748318777506 | 40.7771821378056 | 13A-AM-1017-05 | 13A | AM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9748318777506 40.7771821378056) | 19 | 4 | 19 | 13 | |||||
1800 | 1800 | -73.970962498391 | 40.7766899040856 | 14D-AM-1014-05 | 14D | AM | 10142018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.970962498391 40.7766899040856) | 19 | 4 | 19 | 13 | |||||
1812 | 1812 | -73.9590074024938 | 40.7907059424675 | 32E-PM-1017-05 | 32E | PM | 10172018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9590074024938 40.7907059424675) | 19 | 4 | 19 | 13 | |||||
1839 | 1839 | -73.9655925527354 | 40.7760049171097 | 15H-PM-1008-05 | 15H | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | lawn | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9655925527354 40.7760049171097) | 19 | 4 | 19 | 13 | |||||
1849 | 1849 | -73.9788436368415 | 40.7691104998969 | 3B-AM-1010-05 | 03B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9788436368415 40.7691104998969) | 19 | 4 | 19 | 13 | |||||
1944 | 1944 | -73.9743292066413 | 40.7756090404121 | 11B-AM-1007-05 | 11B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | true | false | false | POINT (-73.9743292066413 40.7756090404121) | 19 | 4 | 19 | 13 | ||||||
1947 | 1947 | -73.9747175419546 | 40.7692820030878 | 5E-PM-1012-05 | 05E | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | begging | POINT (-73.9747175419546 40.7692820030878) | 19 | 4 | 19 | 13 | ||||
1950 | 1950 | -73.9643016116839 | 40.7904796216068 | 30B-PM-1019-05 | 30B | PM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | hiding a nut | false | false | false | false | true | false | false | true | POINT (-73.9643016116839 40.7904796216068) | 19 | 4 | 19 | 13 | ||||
2000 | 2000 | -73.9591070579246 | 40.7896776771157 | 31F-PM-1007-05 | 31F | PM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9591070579246 40.7896776771157) | 19 | 4 | 19 | 13 | ||||||
2012 | 2012 | -73.9587464852561 | 40.793496354083 | 35D-PM-1013-05 | 35D | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9587464852561 40.793496354083) | 19 | 4 | 19 | 13 | |||||
2061 | 2061 | -73.9608834102446 | 40.790624710005 | 31D-AM-1014-05 | 31D | AM | 10142018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9608834102446 40.790624710005) | 19 | 4 | 19 | 13 | |||||
2078 | 2078 | -73.9706041173545 | 40.7780152784804 | 15D-PM-1017-05 | 15D | PM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9706041173545 40.7780152784804) | 19 | 4 | 19 | 13 | |||||
2106 | 2106 | -73.9801651470389 | 40.7677698656935 | 1B-AM-1012-05 | 01B | AM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9801651470389 40.7677698656935) | 19 | 4 | 19 | 13 | |||||
2131 | 2131 | -73.9752225195115 | 40.7703747669865 | 6D-PM-1020-05 | 06D | PM | 10202018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9752225195115 40.7703747669865) | 19 | 4 | 19 | 13 | ||||||
2148 | 2148 | -73.9767317539505 | 40.7717600450632 | 6B-PM-1017-05 | 06B | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767317539505 40.7717600450632) | 19 | 4 | 19 | 13 | |||||
2152 | 2152 | -73.9686925781295 | 40.7705688673142 | 9I-PM-1010-05 | 09I | PM | 10102018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9686925781295 40.7705688673142) | 19 | 4 | 19 | 13 | |||||
2155 | 2155 | -73.9538938706987 | 40.7981150065974 | 42E-PM-1012-05 | 42E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9538938706987 40.7981150065974) | 19 | 4 | 19 | 13 | |||||
2176 | 2176 | -73.9583201789615 | 40.7913938722521 | 33F-PM-1012-05 | 33F | PM | 10122018 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | false | false | true | true | false | false | true | true | false | false | true | POINT (-73.95832017896151 40.7913938722521) | 19 | 4 | 19 | 13 | |||||
2196 | 2196 | -73.9623356369432 | 40.7888693815168 | 29D-AM-1014-05 | 29D | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Rocky area | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9623356369432 40.7888693815168) | 19 | 4 | 19 | 13 | ||||
2202 | 2202 | -73.9556039997621 | 40.7977549157287 | 40D-AM-1013-05 | 40D | AM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9556039997621 40.7977549157287) | 19 | 4 | 19 | 13 | ||||||
2240 | 2240 | -73.9697787673802 | 40.7781746195436 | 16D-PM-1010-05 | 16D | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9697787673802 40.7781746195436) | 19 | 4 | 19 | 13 | ||||||
2260 | 2260 | -73.9784685928652 | 40.7669924015341 | 1D-PM-1007-05 | 01D | PM | 10072018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9784685928652 40.7669924015341) | 19 | 4 | 19 | 13 | |||||
2305 | 2305 | -73.9679833225379 | 40.7738547093402 | 12H-PM-1007-05 | 12H | PM | 10072018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9679833225379 40.7738547093402) | 19 | 4 | 19 | 13 | ||||||
2306 | 2306 | -73.956453902485 | 40.7936584431012 | 36F-PM-1012-05 | 36F | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.956453902485 40.7936584431012) | 19 | 4 | 19 | 13 | |||||
2317 | 2317 | -73.9767369686171 | 40.7735074437085 | 8B-PM-1012-05 | 08B | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9767369686171 40.7735074437085) | 19 | 4 | 19 | 13 | |||||
2439 | 2439 | -73.9587459136391 | 40.7982497351812 | 40B-PM-1014-05 | 40B | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9587459136391 40.7982497351812) | 19 | 4 | 19 | 13 | |||||
2464 | 2464 | -73.9691318044969 | 40.7709801974696 | 9I-AM-1014-05 | 09I | AM | 10142018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9691318044969 40.7709801974696) | 19 | 4 | 19 | 13 | ||||||
2483 | 2483 | -73.9596083366477 | 40.7949526729608 | 36C-PM-1013-05 | 36C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | "Warm brown" written in for Primary. | Ground Plane | FALSE | Ran across path in front of people | true | false | false | true | true | false | false | false | false | true | false | true | true | POINT (-73.9596083366477 40.7949526729608) | 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 );