This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Running, Chasing, Climbing, Eating, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | -73.9561344937861 | 40.7940823884086 | 37F-PM-1014-03 | 37F | PM | 10142018 | 3 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
5 | 5 | -73.9593126695714 | 40.797533370163 | 39B-AM-1018-01 | 39B | AM | 10182018 | 1 | + | Above Ground | false | false | false | false | false | unknown | true | false | false | false | false | false | false | false | POINT (-73.9593126695714 40.797533370163) | 19 | 4 | 19 | 13 | ||||||||
91 | 91 | -73.9565905868276 | 40.7895654068546 | 32H-PM-1006-01 | 32H | PM | 10062018 | 1 | Gray | Gray+ | Above Ground | in the European Beech | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565905868276 40.7895654068546) | 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 | ||||||||||
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 | |||||
109 | 109 | -73.967097592707 | 40.7854119342538 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | true | false | false | true | false | took nut to bury | false | false | false | false | true | false | false | true | POINT (-73.967097592707 40.7854119342538) | 19 | 4 | 19 | 13 | ||||||
213 | 213 | -73.968367485157 | 40.7838472644815 | 22B-PM-1014-05 | 22B | PM | 10142018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | eating (eats with head tilted far to the right (tooth issue?)) | false | false | false | false | false | false | false | false | POINT (-73.968367485157 40.7838472644815) | 19 | 4 | 19 | 13 | |||||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | true | false | false | true | false | false | false | false | false | true | false | false | true | ran up tree | POINT (-73.959709414696 40.7919745085986) | 19 | 4 | 19 | 13 | ||||||
455 | 455 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 10192018 | 4 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9688574691102 40.7837825208444) | 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 | ||||||
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 | ||||||
512 | 512 | -73.9586098170241 | 40.7939653733898 | 35D-AM-1019-01 | 35D | AM | 10192018 | 1 | + | Above Ground | on tree, blue jays gathering nearby | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9586098170241 40.7939653733898) | 19 | 4 | 19 | 13 | ||||||||
526 | 526 | -73.9680833729772 | 40.7741871025115 | 12H-PM-1007-08 | 12H | PM | 10072018 | 8 | + | Above Ground | 7 | in tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680833729772 40.7741871025115) | 19 | 4 | 19 | 13 | |||||||
613 | 613 | -73.9688466874605 | 40.7737911559867 | 12G-PM-1007-05 | 12G | PM | 10072018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9688466874605 40.7737911559867) | 19 | 4 | 19 | 13 | ||||||
639 | 639 | -73.9558589529608 | 40.7892400394941 | 32H-PM-1006-02 | 32H | PM | 10062018 | 2 | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9558589529608 40.7892400394941) | 19 | 4 | 19 | 13 | |||||||
650 | 650 | -73.9809610117171 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 10102018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
686 | 686 | -73.9695745672033 | 40.7791835122147 | 17D-AM-1008-06 | 17D | AM | 10082018 | 6 | + | Above Ground | high in tree, couldn't see it, only heard it | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9695745672033 40.7791835122147) | 19 | 4 | 19 | 13 | ||||||||
727 | 727 | -73.9634563222926 | 40.780992836417 | 21G-PM-1007-04 | 21G | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9634563222926 40.780992836417) | 19 | 4 | 19 | 13 | ||||||
752 | 752 | -73.9768617690725 | 40.7741877060705 | 9A-PM-1010-03 | 09A | PM | 10102018 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | froze - standing on hind legs for ~10 seconds then scampered off | POINT (-73.97686176907251 40.7741877060705) | 19 | 4 | 19 | 13 | |||||
819 | 819 | -73.9603620122205 | 40.7955965755851 | 36B-AM-1013-02 | 36B | AM | 10132018 | 2 | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | didn't see me | POINT (-73.9603620122205 40.7955965755851) | 19 | 4 | 19 | 13 | ||||||
861 | 861 | -73.953287300494 | 40.793520326789 | 37H-PM-1006-04 | 37H | PM | 10062018 | 4 | + | Above Ground | 43 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.953287300494 40.793520326789) | 19 | 4 | 19 | 13 | |||||||
955 | 955 | -73.960657061561 | 40.7956150744102 | 36A-PM-1013-08 | 36A | PM | 10132018 | 8 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | true | false | false | false | false | running from #7 | false | false | false | false | false | false | false | true | POINT (-73.960657061561 40.7956150744102) | 19 | 4 | 19 | 13 | |||||
979 | 979 | -73.9612349421547 | 40.7959586475744 | 36A-PM-1013-09 | 36A | PM | 10132018 | 9 | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9612349421547 40.7959586475744) | 19 | 4 | 19 | 13 | ||||||
1008 | 1008 | -73.9553038162633 | 40.7909367783223 | 34H-PM-1006-04 | 34H | PM | 10062018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Elm tree | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9553038162633 40.790936778322305) | 19 | 4 | 19 | 13 | ||||||
1029 | 1029 | -73.9601259189134 | 40.7955350609057 | 36B-PM-1013-04 | 36B | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9601259189134 40.7955350609057) | 19 | 4 | 19 | 13 | ||||||
1112 | 1112 | -73.9583934264026 | 40.7854742185504 | 27I-AM-1007-02 | 27I | AM | 10072018 | 2 | + | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9583934264026 40.785474218550405) | 19 | 4 | 19 | 13 | ||||||||||
1194 | 1194 | -73.9687462566073 | 40.783898987005 | 22B-PM-1014-06 | 22B | PM | 10142018 | 6 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | false | false | digging | false | false | false | false | false | false | false | false | POINT (-73.9687462566073 40.783898987005) | 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 | ||||||||||
1329 | 1329 | -73.9772164524209 | 40.7688399538756 | 3D-AM-1006-06 | 03D | AM | 10062018 | 6 | Gray | Gray+ | Above Ground | 10 | tree | true | false | true | false | false | false | false | false | false | false | false | false | false | did not run from humans,but ran straight to tree & climbed up | POINT (-73.9772164524209 40.7688399538756) | 19 | 4 | 19 | 13 | |||||
1372 | 1372 | -73.9528353702209 | 40.7976456178263 | 41F-PM-1019-02 | 41F | PM | 10192018 | 2 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9528353702209 40.7976456178263) | 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 | ||||||||||
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 | ||||||
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 | |||||||
1764 | 1764 | -73.9534878316472 | 40.7978951981698 | 41F-PM-1019-01 | 41F | PM | 10192018 | 1 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9534878316472 40.7978951981698) | 19 | 4 | 19 | 13 | ||||||||||
1767 | 1767 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 10142018 | 4 | Gray | White | Gray+White | Above Ground | 15 | Ground then tree to eat | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.958719099962 40.7947587726617) | 19 | 4 | 19 | 13 | |||||
1778 | 1778 | -73.9685598106128 | 40.7807054868066 | 19D-PM-1008-02 | 19D | PM | 10082018 | 2 | + | unknown - cannot see, only hear | Above Ground | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9685598106128 40.7807054868066) | 19 | 4 | 19 | 13 | ||||||||
1831 | 1831 | -73.9746877519291 | 40.7761402808083 | 11B-PM-1014-03 | 11B | PM | 10142018 | 3 | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9746877519291 40.7761402808083) | 19 | 4 | 19 | 13 | |||||||
1842 | 1842 | -73.9532804650089 | 40.7934579333341 | 37H-PM-1006-05 | 37H | PM | 10062018 | 5 | + | Above Ground | tree | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9532804650089 40.7934579333341) | 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 | ||||||
1926 | 1926 | -73.9742811484852 | 40.775533619083 | 11B-PM-1014-08 | 11B | PM | 10142018 | 8 | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.97428114848522 40.775533619083) | 19 | 4 | 19 | 13 | |||||||
1931 | 1931 | -73.9533085932603 | 40.7934877861075 | 37H-PM-1006-03 | 37H | PM | 10062018 | 3 | + | Above Ground | 43 | tree | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9533085932603 40.7934877861075) | 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 | |||||
2261 | 2261 | -73.9609692861012 | 40.790502891247 | 31D-AM-1014-07 | 31D | AM | 10142018 | 7 | Gray | Gray+ | Ground Plane | FALSE | Crossing path to tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9609692861012 40.790502891247) | 19 | 4 | 19 | 13 | ||||||
2327 | 2327 | -73.9567801028221 | 40.7960096659564 | 38D-AM-1017-01 | 38D | AM | 10172018 | 1 | + | Above Ground | 30 | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9567801028221 40.7960096659564) | 19 | 4 | 19 | 13 | ||||||||
2660 | 2660 | -73.9726056411971 | 40.7793467904743 | 16A-PM-1019-03 | 16A | PM | 10192018 | 3 | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9726056411971 40.7793467904743) | 19 | 4 | 19 | 13 | |||||||
2714 | 2714 | -73.9600738985438 | 40.7938328798752 | 35C-PM-1013-08 | 35C | PM | 10132018 | 8 | + | false | false | false | false | false | true | false | false | false | false | false | false | false | did not *see* | POINT (-73.9600738985438 40.7938328798752) | 19 | 4 | 19 | 13 | |||||||||
2729 | 2729 | -73.9615429203441 | 40.7907417648701 | 31D-AM-1014-01 | 31D | AM | 10142018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | Ground then up tree | false | false | true | false | false | chased by a doggo | false | false | true | false | false | false | false | true | runs from (dogs!) | POINT (-73.9615429203441 40.7907417648701) | 19 | 4 | 19 | 13 | |||
2744 | 2744 | -73.9752915601718 | 40.7739329570033 | 9B-AM-1010-04 | 09B | AM | 10102018 | 4 | + | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9752915601718 40.7739329570033) | 19 | 4 | 19 | 13 | ||||||||
2766 | 2766 | -73.9551639847466 | 40.790858199891 | 34H-PM-1006-03 | 34H | PM | 10062018 | 3 | Gray | White | Gray+White | white belly | Ground Plane | FALSE | Under Tupelo Tree | false | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.9551639847466 40.790858199891) | 19 | 4 | 19 | 13 | ||||
2942 | 2942 | -73.9672063784809 | 40.7826070395665 | 21D-PM-1008-01 | 21D | PM | 10082018 | 1 | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | true | false | false | POINT (-73.9672063784809 40.7826070395665) | 19 | 4 | 19 | 13 | |||||||
2951 | 2951 | -73.9742986032935 | 40.7770454318226 | 13A-PM-1014-04 | 13A | PM | 10142018 | 4 | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9742986032935 40.7770454318226) | 19 | 4 | 19 | 13 | |||||||
1459 | 1459 | -73.9563847867316 | 40.7906012261163 | 33G-AM-1013-03 | 33G | AM | 10132018 | 3 | ? | + | Only peeked head out | Above Ground | 13 | false | false | false | false | false | peeking out of tree,did *not* come out | false | false | false | false | false | false | false | false | POINT (-73.9563847867316 40.7906012261163) | 19 | 4 | 19 | 13 | |||||
2693 | 2693 | -73.9561498646036 | 40.7949288561893 | 37E-AM-1013-05 | 37E | AM | 10132018 | 5 | ? | + | Above Ground | 10 | unsure, just heard kuks | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9561498646036 40.79492885618931) | 19 | 4 | 19 | 13 | ||||||
2777 | 2777 | -73.9810843611086 | 40.7687905493699 | 2A-PM-1019-05 | 02A | PM | 10192018 | 5 | ? | Gray | Gray+ | Above Ground | 50 | in tall planetree | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9810843611086 40.7687905493699) | 19 | 4 | 19 | 13 | |||||
2 | 2 | -73.9570437717691 | 40.7948509408039 | 37E-PM-1006-03 | 37E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | me | POINT (-73.9570437717691 40.794850940803904) | 19 | 4 | 19 | 13 | ||||
15 | 15 | -73.9674285955293 | 40.7829723919744 | 21C-PM-1006-01 | 21C | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | true | true | false | false | false | POINT (-73.9674285955293 40.7829723919744) | 19 | 4 | 19 | 13 | ||||||
19 | 19 | -73.9768603630674 | 40.7702795904962 | 5C-PM-1010-09 | 05C | PM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9768603630674 40.7702795904962) | 19 | 4 | 19 | 13 | |||||
27 | 27 | -73.9670628558161 | 40.7734991420941 | 12I-AM-1013-01 | 12I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on tree roots | false | false | false | false | false | sitting | false | false | false | false | true | false | false | true | POINT (-73.9670628558161 40.77349914209411) | 19 | 4 | 19 | 13 | |||
31 | 31 | -73.9540054100539 | 40.7952445999836 | 39G-PM-1013-06 | 39G | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9540054100539 40.7952445999836) | 19 | 4 | 19 | 13 | |||||
33 | 33 | -73.9738033257473 | 40.7711846894166 | 7E-AM-1006-02 | 07E | AM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a tree | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9738033257473 40.7711846894166) | 19 | 4 | 19 | 13 | |||||
37 | 37 | -73.9643153920428 | 40.7820818516957 | 22F-PM-1014-05 | 22F | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9643153920428 40.7820818516957) | 19 | 4 | 19 | 13 | |||||
39 | 39 | -73.9716147061553 | 40.7813911036179 | 18A-PM-1018-01 | 18A | PM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9716147061553 40.7813911036179) | 19 | 4 | 19 | 13 | ||||||
41 | 41 | -73.9639159298446 | 40.7891774637988 | 29C-AM-1007-06 | 29C | AM | 10072018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9639159298446 40.7891774637988) | 19 | 4 | 19 | 13 | |||||
42 | 42 | -73.9579564338627 | 40.7959337795027 | 38C-PM-1014-09 | 38C | PM | 10142018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9579564338627 40.7959337795027) | 19 | 4 | 19 | 13 | ||||||
45 | 45 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9579645940414 40.7918613498407) | 19 | 4 | 19 | 13 | |||||
48 | 48 | -73.9595933195409 | 40.7905847332369 | 32E-AM-1007-13 | 32E | AM | 10072018 | 13 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9595933195409 40.7905847332369) | 19 | 4 | 19 | 13 | ||||||
49 | 49 | -73.9602222116708 | 40.793779699421 | 35C-AM-1007-05 | 35C | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9602222116708 40.793779699421) | 19 | 4 | 19 | 13 | ||||||
51 | 51 | -73.9801666435401 | 40.7686905339212 | 2B-PM-1013-01 | 02B | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | running (with nut) | false | false | false | false | false | false | false | false | POINT (-73.9801666435401 40.7686905339212) | 19 | 4 | 19 | 13 | ||||
58 | 58 | -73.9704082821356 | 40.7690280985956 | 6I-PM-1013-06 | 06I | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | playing with #5 | false | false | false | false | true | false | false | false | POINT (-73.9704082821356 40.7690280985956) | 19 | 4 | 19 | 13 | ||||
63 | 63 | -73.9745630038492 | 40.7692602628745 | 5E-AM-1008-06 | 05E | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.9745630038492 40.7692602628745) | 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 | |||||
78 | 78 | -73.964474836001 | 40.7883840104749 | 28C-PM-1006-01 | 28C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | gathering acorns | false | false | false | true | false | false | false | true | gnd to tree | POINT (-73.964474836001 40.7883840104749) | 19 | 4 | 19 | 13 | |||
80 | 80 | -73.9688454483585 | 40.7845301288163 | 22A-AM-1008-05 | 22A | AM | 10082018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 3 | trash can | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9688454483585 40.7845301288163) | 19 | 4 | 19 | 13 | ||||
83 | 83 | -73.9617088749928 | 40.7944585082367 | 35A-PM-1013-06 | 35A | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9617088749928 40.7944585082367) | 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 | ||||||
85 | 85 | -73.9676410497481 | 40.7766043512974 | 15G-PM-1019-05 | 15G | PM | 10192018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9676410497481 40.7766043512974) | 19 | 4 | 19 | 13 | |||||
86 | 86 | -73.9708726050721 | 40.7723572030236 | 10F-AM-1007-02 | 10F | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 70 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9708726050721 40.7723572030236) | 19 | 4 | 19 | 13 | ||||||
102 | 102 | -73.9575986161364 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Climbing tree | false | false | true | false | false | climbing (tree) | false | false | false | false | false | false | false | true | POINT (-73.9575986161364 40.799368134968) | 19 | 4 | 19 | 13 | |||
107 | 107 | -73.9521110154872 | 40.7978449143313 | 42G-AM-1018-03 | 42G | AM | 10182018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | stop to look at me—then ran | false | false | false | false | false | false | false | true | POINT (-73.9521110154872 40.7978449143313) | 19 | 4 | 19 | 13 | ||||
110 | 110 | -73.9711318790279 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9711318790279 40.7701941550273) | 19 | 4 | 19 | 13 | ||||||
111 | 111 | -73.9763243383771 | 40.7705409315703 | 5C-PM-1010-13 | 05C | PM | 10102018 | 13 | Adult | Gray | White | Gray+White | Above Ground | 20 | way up a tree! | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9763243383771 40.7705409315703) | 19 | 4 | 19 | 13 | ||||
113 | 113 | -73.9700100617602 | 40.7815739959357 | 19B-PM-1018-01 | 19B | PM | 10182018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 20 | true | false | false | false | false | flying | false | false | false | false | false | false | false | false | POINT (-73.9700100617602 40.7815739959357) | 19 | 4 | 19 | 13 | ||||
116 | 116 | -73.9572093760529 | 40.7988487300216 | 41B-AM-1010-06 | 41B | AM | 10102018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9572093760529 40.7988487300216) | 19 | 4 | 19 | 13 | |||||
118 | 118 | -73.9566346046453 | 40.7973923396512 | 40D-PM-1013-01 | 40D | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9566346046453 40.7973923396512) | 19 | 4 | 19 | 13 | |||||
126 | 126 | -73.9792155473689 | 40.7693711799946 | 3B-PM-1007-11 | 03B | PM | 10072018 | 11 | Adult | Gray | Gray+ | Above Ground | 5 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9792155473689 40.7693711799946) | 19 | 4 | 19 | 13 | |||||
130 | 130 | -73.9581655949437 | 40.7997708190022 | 41A-PM-1007-06 | 41A | PM | 10072018 | 6 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9581655949437 40.7997708190022) | 19 | 4 | 19 | 13 | ||||||
133 | 133 | -73.9664711607022 | 40.787896428768 | 26A-PM-1006-06 | 26A | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Tree 90th left 90th & 89 | false | false | true | false | false | false | false | false | true | false | false | false | false | studying us looking for food | POINT (-73.9664711607022 40.787896428768) | 19 | 4 | 19 | 13 | |||
136 | 136 | -73.9528682507794 | 40.7925807808307 | 36I-PM-1007-13 | 36I | PM | 10072018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9528682507794 40.7925807808307) | 19 | 4 | 19 | 13 | |||||
140 | 140 | -73.9768652785664 | 40.7684838168207 | 3D-PM-1010-03 | 03D | PM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.97686527856641 40.7684838168207) | 19 | 4 | 19 | 13 | |||||
144 | 144 | -73.9730750601212 | 40.7701304211944 | 6F-PM-1008-01 | 06F | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9730750601212 40.7701304211944) | 19 | 4 | 19 | 13 | |||||
148 | 148 | -73.9532620128307 | 40.7952475548048 | 39G-AM-1018-01 | 39G | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | dead (something ran over it) | false | false | false | false | false | false | false | false | POINT (-73.9532620128307 40.7952475548048) | 19 | 4 | 19 | 13 | ||||
150 | 150 | -73.9763430829342 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 10082018 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | on tree facing downward | false | true | false | false | false | chased #12 | true | false | false | true | false | false | false | true | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
151 | 151 | -73.9714789136757 | 40.7694886645194 | 6H-AM-1008-01 | 06H | AM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9714789136757 40.7694886645194) | 19 | 4 | 19 | 13 | |||||
156 | 156 | -73.9576589997493 | 40.7972751877447 | 39C-PM-1006-02 | 39C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | unaware of | POINT (-73.95765899974931 40.7972751877447) | 19 | 4 | 19 | 13 | |||||
159 | 159 | -73.9638270331336 | 40.7810450065235 | 21G-PM-1007-02 | 21G | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9638270331336 40.7810450065235) | 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 | |||||
168 | 168 | -73.9745691353018 | 40.7771035589298 | 13A-PM-1014-03 | 13A | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | false | true | child chasing | POINT (-73.9745691353018 40.7771035589298) | 19 | 4 | 19 | 13 | ||||
170 | 170 | -73.9597205966324 | 40.7969409510133 | 38B-AM-1019-01 | 38B | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9597205966324 40.7969409510133) | 19 | 4 | 19 | 13 | |||||
171 | 171 | -73.971086588091 | 40.7719703235178 | 9G-PM-1007-06 | 09G | PM | 10072018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.971086588091 40.7719703235178) | 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 |
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 );