This data as json, CSV (advanced)
Highlight Fur Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135 | 135 | -73.9694168118643 | 40.7728877377977 | 11G-PM-1013-01 | 11G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | In the Woods/Brush | false | false | true | false | true | false | false | false | false | false | false | false | true | watching me | POINT (-73.9694168118643 40.7728877377977) | 19 | 4 | 19 | 13 | |||
137 | 137 | -73.9782417115139 | 40.7724665036447 | 7A-AM-1006-01 | 07A | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | in tree | false | false | false | false | true | false | true | false | false | true | false | false | false | looked at us | POINT (-73.9782417115139 40.7724665036447) | 19 | 4 | 19 | 13 | |||
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 | |||||
147 | 147 | -73.9564023626619 | 40.7905423546155 | 33G-AM-1013-02 | 33G | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | shelter in hole in tree | false | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9564023626619 40.7905423546155) | 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 | |||||
166 | 166 | -73.963846339804 | 40.7834051716226 | 23F-AM-1018-01 | 23F | AM | 10182018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.963846339804 40.7834051716226) | 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 | ||||
169 | 169 | -73.9748706415584 | 40.7744174965072 | 10B-AM-1006-02 | 10B | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | High in a tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9748706415584 40.7744174965072) | 19 | 4 | 19 | 13 | |||||
178 | 178 | -73.9613780522542 | 40.790786197111 | 31D-PM-1006-04 | 31D | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9613780522542 40.790786197111) | 19 | 4 | 19 | 13 | ||||||
188 | 188 | -73.9570528770427 | 40.7990973804149 | 41B-AM-1010-07 | 41B | AM | 10102018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | false | false | false | false | false | true | false | false | true | false | true | false | false | mad! | POINT (-73.9570528770427 40.7990973804149) | 19 | 4 | 19 | 13 | ||||
198 | 198 | -73.9761107065353 | 40.769642060286 | 5D-AM-1020-01 | 05D | AM | 10202018 | 1 | Adult | + | Too far & cloudy to tell | Above Ground | 30 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9761107065353 40.769642060286) | 19 | 4 | 19 | 13 | ||||||
199 | 199 | -73.9771614686616 | 40.7709677983247 | 5C-AM-1006-02 | 05C | AM | 10062018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | true | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9771614686616 40.7709677983247) | 19 | 4 | 19 | 13 | |||||
201 | 201 | -73.9598015842806 | 40.7973522744237 | 38A-PM-1013-03 | 38A | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9598015842806 40.7973522744237) | 19 | 4 | 19 | 13 | |||||
207 | 207 | -73.9770824412252 | 40.7709961309457 | 5C-AM-1006-03 | 05C | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97708244122522 40.7709961309457) | 19 | 4 | 19 | 13 | |||||
210 | 210 | -73.9711298491132 | 40.7676902603543 | 5I-PM-1008-01 | 05I | PM | 10082018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 15 | in tree by arsenal - climbing | false | false | true | true | false | false | false | false | true | false | false | false | false | POINT (-73.9711298491132 40.7676902603543) | 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 | |||||
220 | 220 | -73.967181612203 | 40.7787752287055 | 17F-PM-1020-03 | 17F | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 35 | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.967181612203 40.7787752287055) | 19 | 4 | 19 | 13 | |||||
226 | 226 | -73.9775681731459 | 40.7676421190309 | 2D-AM-1007-03 | 02D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 100 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9775681731459 40.7676421190309) | 19 | 4 | 19 | 13 | ||||||
229 | 229 | -73.972416242971 | 40.7714260236636 | 8F-PM-1012-04 | 08F | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.972416242971 40.7714260236636) | 19 | 4 | 19 | 13 | ||||||
237 | 237 | -73.967895656898 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 3 | on fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
248 | 248 | -73.9751729403694 | 40.7743284123118 | 10B-PM-1014-02 | 10B | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | gingko tree by traffic light in front of Strawberry Fields | false | false | false | false | true | false | false | false | false | true | false | false | false | came over on tree to see me then disappeared | POINT (-73.9751729403694 40.7743284123118) | 19 | 4 | 19 | 13 | ||||
255 | 255 | -73.9800669115792 | 40.7676825134384 | 1B-AM-1012-07 | 01B | AM | 10122018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on tree trunk | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9800669115792 40.7676825134384) | 19 | 4 | 19 | 13 | |||||
256 | 256 | -73.976798124308 | 40.7741316574113 | 9A-PM-1010-04 | 09A | PM | 10102018 | 4 | Cinnamon | Cinnamon+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97679812430802 40.7741316574113) | 19 | 4 | 19 | 13 | |||||||
258 | 258 | -73.9534333425633 | 40.7932564163328 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | false | false | false | true | false | false | true | false | false | false | false | false | true | POINT (-73.9534333425633 40.7932564163328) | 19 | 4 | 19 | 13 | ||||
260 | 260 | -73.978436117932 | 40.7724769242403 | 6A-AM-1006-06 | 06A | AM | 10062018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | tree | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.978436117932 40.7724769242403) | 19 | 4 | 19 | 13 | ||||
261 | 261 | -73.9552861155228 | 40.788973931872 | 32I-AM-1013-05 | 32I | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552861155228 40.788973931872) | 19 | 4 | 19 | 13 | ||||
262 | 262 | -73.9712876234172 | 40.7695885530701 | 7H-PM-1006-02 | 07H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 25 | tree | true | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9712876234172 40.7695885530701) | 19 | 4 | 19 | 13 | |||||
268 | 268 | -73.968107276769 | 40.7768612676036 | 15F-AM-1007-09 | 15F | AM | 10072018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.968107276769 40.7768612676036) | 19 | 4 | 19 | 13 | |||||
271 | 271 | -73.9661262885099 | 40.7844085550945 | 23D-AM-1013-01 | 23D | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | true | false | false | approaches (he saw me,came towards,then darted up) | POINT (-73.9661262885099 40.7844085550945) | 19 | 4 | 19 | 13 | ||||
279 | 279 | -73.9550082056509 | 40.7894521543449 | 33I-AM-1008-03 | 33I | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | 98th @ edge of park | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9550082056509 40.7894521543449) | 19 | 4 | 19 | 13 | |||||
281 | 281 | -73.9619411917909 | 40.7923536640283 | 33B-PM-1010-11 | 33B | PM | 10102018 | 11 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9619411917909 40.7923536640283) | 19 | 4 | 19 | 13 | ||||||
284 | 284 | -73.9547336666137 | 40.7938937756332 | 37G-PM-1007-07 | 37G | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9547336666137 40.7938937756332) | 19 | 4 | 19 | 13 | |||||
286 | 286 | -73.9720907384613 | 40.7762987836055 | 13C-PM-1019-01 | 13C | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 7 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.9720907384613 40.7762987836055) | 19 | 4 | 19 | 13 | ||||||
294 | 294 | -73.9756573579063 | 40.7656644063024 | 1G-PM-1010-01 | 01G | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | true | false | false | false | false | true | false | false | true | false | too busy eating in his tree | POINT (-73.9756573579063 40.7656644063024) | 19 | 4 | 19 | 13 | ||||
299 | 299 | -73.9586214081667 | 40.7937473968735 | 35D-PM-1013-03 | 35D | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | No Tail! | Above Ground | 2 | bench | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9586214081667 40.7937473968735) | 19 | 4 | 19 | 13 | |||
300 | 300 | -73.9528149779809 | 40.7924984810637 | 36I-AM-1017-06 | 36I | AM | 10172018 | 6 | Adult | Gray | Black | Gray+Black | Darker than others | Above Ground | 10 | Running down tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9528149779809 40.7924984810637) | 19 | 4 | 19 | 13 | |||
311 | 311 | -73.9578779556574 | 40.7934116539732 | 35E-PM-1006-06 | 35E | PM | 10062018 | 6 | Adult | Gray | Gray+ | Above Ground | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9578779556574 40.7934116539732) | 19 | 4 | 19 | 13 | |||||||
317 | 317 | -73.9545799024508 | 40.7908084039886 | 34I-PM-1010-01 | 34I | PM | 10102018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9545799024508 40.7908084039886) | 19 | 4 | 19 | 13 | ||||||
319 | 319 | -73.9659034359706 | 40.7797516688844 | 19F-AM-1007-02 | 19F | AM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 8 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9659034359706 40.77975166888441) | 19 | 4 | 19 | 13 | |||||
326 | 326 | -73.9699843570636 | 40.7729480440312 | 10G-AM-1006-01 | 10G | AM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 80 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.96998435706361 40.7729480440312) | 19 | 4 | 19 | 13 | ||||||
331 | 331 | -73.95448101115 | 40.7954469678857 | 39F-PM-1006-03 | 39F | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15 | lower branch of tree | false | false | false | true | false | false | false | false | false | false | false | false | true | ran up tree when approached | POINT (-73.95448101115 40.7954469678857) | 19 | 4 | 19 | 13 | |||
335 | 335 | -73.9782351435852 | 40.7715896672335 | 6A-AM-1006-03 | 06A | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | false | true | false | true | false | false | false | false | true | true | false | false | false | POINT (-73.9782351435852 40.7715896672335) | 19 | 4 | 19 | 13 | ||||
336 | 336 | -73.9757413215621 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757413215621 40.7692582758978) | 19 | 4 | 19 | 13 | ||||||
337 | 337 | -73.9583101927652 | 40.7852649316039 | 27I-PM-1020-05 | 27I | PM | 10202018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | In tree | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (us) | POINT (-73.9583101927652 40.7852649316039) | 19 | 4 | 19 | 13 | |||
339 | 339 | -73.965509576403 | 40.7752456763263 | 14I-PM-1018-05 | 14I | PM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | false | false | true | true | false | false | false | false | false | true | false | true | false | POINT (-73.96550957640301 40.7752456763263) | 19 | 4 | 19 | 13 | |||||
341 | 341 | -73.9703161745884 | 40.7702610461336 | 8H-PM-1014-05 | 08H | PM | 10142018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9703161745884 40.7702610461336) | 19 | 4 | 19 | 13 | ||||||
344 | 344 | -73.9759432151552 | 40.7733240612552 | 8B-PM-1012-06 | 08B | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | on a bench | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9759432151552 40.7733240612552) | 19 | 4 | 19 | 13 | ||||
347 | 347 | -73.9611696144784 | 40.7816692895155 | 22I-AM-1007-03 | 22I | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611696144784 40.7816692895155) | 19 | 4 | 19 | 13 | ||||||
352 | 352 | -73.970540988328 | 40.7698103067062 | 7H-AM-1006-06 | 07H | AM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.970540988328 40.7698103067062) | 19 | 4 | 19 | 13 | |||||
354 | 354 | -73.9566751022336 | 40.799035789744 | 41C-PM-1007-04 | 41C | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 65 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9566751022336 40.799035789744) | 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 | ||||||
364 | 364 | -73.9623696148045 | 40.792184861375 | 32B-AM-1017-04 | 32B | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9623696148045 40.792184861375) | 19 | 4 | 19 | 13 | |||||
366 | 366 | -73.9673548527075 | 40.7765669058396 | 15G-PM-1019-11 | 15G | PM | 10192018 | 11 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared | POINT (-73.9673548527075 40.7765669058396) | 19 | 4 | 19 | 13 | |||||
369 | 369 | -73.9596398997228 | 40.7933386953847 | 34D-PM-1007-02 | 34D | PM | 10072018 | 2 | Adult | Black | Black+ | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | cautiously aware | POINT (-73.9596398997228 40.7933386953847) | 19 | 4 | 19 | 13 | |||||
371 | 371 | -73.964080104186 | 40.7907898627287 | 30B-AM-1007-02 | 30B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.964080104186 40.7907898627287) | 19 | 4 | 19 | 13 | ||||||
372 | 372 | -73.9781303869038 | 40.7725000348875 | 7A-AM-1006-02 | 07A | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9781303869038 40.7725000348875) | 19 | 4 | 19 | 13 | ||||
374 | 374 | -73.9556817958407 | 40.788852000621 | 32I-AM-1013-02 | 32I | AM | 10132018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | watching me from tree - curious | POINT (-73.9556817958407 40.788852000621) | 19 | 4 | 19 | 13 | ||||
377 | 377 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 10082018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | went up tree | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
378 | 378 | -73.9584835416846 | 40.7978213396921 | 39B-PM-1014-06 | 39B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9584835416846 40.7978213396921) | 19 | 4 | 19 | 13 | |||||
380 | 380 | -73.9649590119935 | 40.7822107920769 | 21F-AM-1018-01 | 21F | AM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9649590119935 40.7822107920769) | 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 | ||||||
384 | 384 | -73.968045072743 | 40.7836626717225 | 22C-AM-1013-02 | 22C | AM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | false | false | true | false | true | true | false | false | true | false | false | false | true | POINT (-73.968045072743 40.7836626717225) | 19 | 4 | 19 | 13 | |||||
388 | 388 | -73.9592537496995 | 40.7919271821316 | 33E-AM-1014-03 | 33E | AM | 10142018 | 3 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9592537496995 40.7919271821316) | 19 | 4 | 19 | 13 | ||||||
391 | 391 | -73.9790875480358 | 40.7676104780657 | 2C-AM-1010-03 | 02C | AM | 10102018 | 3 | Adult | Black | Gray | Black+Gray | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9790875480358 40.7676104780657) | 19 | 4 | 19 | 13 | |||||
399 | 399 | -73.9763433202401 | 40.7738473490681 | 9B-PM-1013-10 | 09B | PM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | "Brown" written in as Primary | Above Ground | 12 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9763433202401 40.7738473490681) | 19 | 4 | 19 | 13 | ||||
401 | 401 | -73.965862100991 | 40.7825926896917 | 22D-PM-1012-01 | 22D | PM | 10122018 | 1 | Adult | Gray | Black, White | Gray+Black, White | Above Ground | 5 | false | false | true | false | false | true | false | false | false | false | false | false | false | climbing tree | POINT (-73.965862100991 40.7825926896917) | 19 | 4 | 19 | 13 | ||||
414 | 414 | -73.9721899838568 | 40.7761519045651 | 13C-AM-1010-03 | 13C | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721899838568 40.7761519045651) | 19 | 4 | 19 | 13 | ||||||
415 | 415 | -73.9570131890379 | 40.7991786736124 | 41B-PM-1014-05 | 41B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | true | false | false | false | false | false | true | true | POINT (-73.9570131890379 40.7991786736124) | 19 | 4 | 19 | 13 | ||||||
425 | 425 | -73.9704485231855 | 40.7717290560806 | 9G-AM-1007-02 | 09G | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | true | kids were trying to poke it with a stick | POINT (-73.9704485231855 40.7717290560806) | 19 | 4 | 19 | 13 | |||||
426 | 426 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on railing | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9741944367138 40.7769889953596) | 19 | 4 | 19 | 13 | ||||
428 | 428 | -73.96362827608 | 40.7807994595242 | 21G-AM-1014-02 | 21G | AM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 3 | fence | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.96362827608 40.7807994595242) | 19 | 4 | 19 | 13 | ||||
430 | 430 | -73.9710116801402 | 40.7723689301989 | 10G-PM-1017-08 | 10G | PM | 10172018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9710116801402 40.7723689301989) | 19 | 4 | 19 | 13 | |||||
433 | 433 | -73.9558474701153 | 40.7913335515534 | 34H-AM-1007-01 | 34H | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | tree | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.9558474701153 40.7913335515534) | 19 | 4 | 19 | 13 | ||||
440 | 440 | -73.9642717435966 | 40.782087049693 | 22F-AM-1007-05 | 22F | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9642717435966 40.782087049693) | 19 | 4 | 19 | 13 | ||||
441 | 441 | -73.9742973420446 | 40.7691801644292 | 5F-AM-1007-04 | 05F | AM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | rocks | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9742973420446 40.7691801644292) | 19 | 4 | 19 | 13 | |||||
460 | 460 | -73.9549135206961 | 40.798525897229 | 42D-PM-1013-03 | 42D | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | in tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9549135206961 40.798525897229) | 19 | 4 | 19 | 13 | ||||
462 | 462 | -73.9661785940531 | 40.7742569936186 | 13I-PM-1008-01 | 13I | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | climbed tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9661785940531 40.7742569936186) | 19 | 4 | 19 | 13 | ||||
476 | 476 | -73.9690968160819 | 40.769923269444 | 8I-AM-1006-08 | 08I | AM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | tree | false | false | false | false | false | true | true | false | false | false | false | false | false | not backing down | POINT (-73.9690968160819 40.769923269444) | 19 | 4 | 19 | 13 | |||
480 | 480 | -73.9641293283734 | 40.7907654006019 | 30B-AM-1007-03 | 30B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641293283734 40.7907654006019) | 19 | 4 | 19 | 13 | ||||||
483 | 483 | -73.9789952029637 | 40.7697758333099 | 4B-AM-1010-03 | 04B | AM | 10102018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9789952029637 40.7697758333099) | 19 | 4 | 19 | 13 | |||||
496 | 496 | -73.9548430741605 | 40.798207350942 | 41E-AM-1007-06 | 41E | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | tree | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9548430741605 40.798207350942) | 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 | ||||||
498 | 498 | -73.9669432929573 | 40.779136518298 | 18F-AM-1014-01 | 18F | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | Low tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9669432929573 40.779136518298) | 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 | ||||||
506 | 506 | -73.9649611089685 | 40.7814371834837 | 21F-AM-1018-05 | 21F | AM | 10182018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9649611089685 40.7814371834837) | 19 | 4 | 19 | 13 | |||||
508 | 508 | -73.9746918762076 | 40.7655231883678 | 1G-AM-1006-02 | 01G | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 30 | false | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9746918762076 40.7655231883678) | 19 | 4 | 19 | 13 | |||||
509 | 509 | -73.9714289592392 | 40.7750670702093 | 12E-PM-1018-04 | 12E | PM | 10182018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9714289592392 40.7750670702093) | 19 | 4 | 19 | 13 | ||||||
510 | 510 | -73.9638590768396 | 40.7776782114981 | 18I-AM-1017-02 | 18I | AM | 10172018 | 2 | Adult | Gray | Black | Gray+Black | Above Ground | 15 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9638590768396 40.7776782114981) | 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 | ||||||||
518 | 518 | -73.9687847410656 | 40.778185700305 | 16E-AM-1014-09 | 16E | AM | 10142018 | 9 | Adult | Gray | Gray+ | Above Ground | 25 | In tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687847410656 40.778185700305) | 19 | 4 | 19 | 13 | |||||
525 | 525 | -73.952526164386 | 40.7963759240504 | 40G-AM-1007-02 | 40G | AM | 10072018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 18 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.952526164386 40.7963759240504) | 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 | |||||||
528 | 528 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9647284206644 40.7839611840884) | 19 | 4 | 19 | 13 | |||||
530 | 530 | -73.9696360756453 | 40.7786545659072 | 16D-PM-1010-03 | 16D | PM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 18 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9696360756453 40.7786545659072) | 19 | 4 | 19 | 13 | ||||||
534 | 534 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9650499507011 40.7908191782173) | 19 | 4 | 19 | 13 | |||||
539 | 539 | -73.9761440627966 | 40.7706035301542 | 6D-PM-1020-04 | 06D | PM | 10202018 | 4 | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9761440627966 40.7706035301542) | 19 | 4 | 19 | 13 | |||||||
542 | 542 | -73.9713487591577 | 40.7784353043714 | 15C-PM-1017-03 | 15C | PM | 10172018 | 3 | Adult | Black | Black+ | Above Ground | 17 | running across overpass | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9713487591577 40.7784353043714) | 19 | 4 | 19 | 13 | |||||
552 | 552 | -73.9625416200877 | 40.7811302397912 | 21H-AM-1017-02 | 21H | AM | 10172018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9625416200877 40.78113023979121) | 19 | 4 | 19 | 13 | |||||
555 | 555 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685227310735 40.776599466588) | 19 | 4 | 19 | 13 | ||||
561 | 561 | -73.9581982486469 | 40.7992194575293 | 41A-PM-1007-03 | 41A | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 55 | true | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.95819824864691 40.7992194575293) | 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 );