This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Zip Codes, Community Districts, City Council Districts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | -73.9768311751004 | 40.7667178072558 | 2E-AM-1010-03 | 02E | AM | 10102018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9768311751004 40.76671780725581) | 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 | ||||||||
11 | 11 | -73.9702676472613 | 40.7762126854894 | 13E-AM-1017-05 | 13E | AM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on tree stump | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9702676472613 40.7762126854894) | 19 | 4 | 19 | 13 | |||||
16 | 16 | -73.9722500196844 | 40.7742879599026 | 11D-AM-1010-03 | 11D | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | grooming | false | false | false | false | false | false | true | false | POINT (-73.9722500196844 40.7742879599026) | 19 | 4 | 19 | 13 | ||||
20 | 20 | -73.9706105896967 | 40.7698124821507 | 7H-AM-1006-05 | 07H | AM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9706105896967 40.7698124821507) | 19 | 4 | 19 | 13 | |||||
25 | 25 | -73.9671130680114 | 40.7784859700171 | 17F-AM-1007-07 | 17F | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 24 | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9671130680114 40.7784859700171) | 19 | 4 | 19 | 13 | |||||
44 | 44 | -73.970252675331 | 40.7705999588222 | 8H-AM-1017-06 | 08H | AM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | true | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.970252675331 40.77059995882221) | 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 | ||||||
50 | 50 | -73.9680635070949 | 40.779249873647 | 17E-AM-1017-05 | 17E | AM | 10172018 | 5 | Adult | Black | Black+ | Above Ground | 10 | Branch | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9680635070949 40.779249873647) | 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 | ||||
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 | ||||||
98 | 98 | -73.9730277911422 | 40.7712145488828 | 7F-AM-1008-16 | 07F | AM | 10082018 | 16 | Juvenile | Gray | Gray+ | Above Ground | 2 | tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9730277911422 40.7712145488828) | 19 | 4 | 19 | 13 | |||||
100 | 100 | -73.9761592532482 | 40.7747213585387 | 10A-AM-1006-04 | 10A | AM | 10062018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 10 | tree near large rock on Bridle Path | false | false | false | false | false | walking on branch | false | false | false | false | true | false | false | false | POINT (-73.9761592532482 40.7747213585387) | 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 | ||||||
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 | ||||||
112 | 112 | -73.9651754464439 | 40.7755181941559 | 15I-AM-1008-01 | 15I | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | tree | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9651754464439 40.7755181941559) | 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 | |||||
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 | |||
139 | 139 | -73.969847380865 | 40.7769884612305 | 14E-AM-1008-05 | 14E | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | nest building | false | false | false | false | false | false | true | false | POINT (-73.969847380865 40.7769884612305) | 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 | |||||
163 | 163 | -73.9712308864394 | 40.7714534847379 | 9G-AM-1007-04 | 09G | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | false | false | false | grooming | false | false | false | false | false | false | true | false | POINT (-73.9712308864394 40.7714534847379) | 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 | |||||
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 | |||||
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 | |||||
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 | ||||
189 | 189 | -73.9735489537928 | 40.7681257911523 | 4G-AM-1006-02 | 04G | AM | 10062018 | 2 | Gray | White | Gray+White | Above Ground | 12 | tree | false | false | false | false | false | sitting in tree | false | false | false | false | false | false | true | false | POINT (-73.9735489537928 40.7681257911523) | 19 | 4 | 19 | 13 | ||||
191 | 191 | -73.9787105069657 | 40.7693708133873 | 3B-AM-1010-08 | 03B | AM | 10102018 | 8 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | together w/ #7 | false | false | false | false | false | false | true | false | POINT (-73.9787105069657 40.7693708133873) | 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 | |||||
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 | |||||
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 | |||||
222 | 222 | -73.9770273553525 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 10132018 | 3 | Juvenile | + | Above Ground | 3 | fence | true | true | true | true | false | playing tag together | false | false | false | false | false | true | false | false | POINT (-73.9770273553525 40.7732399463626) | 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 | ||||||
243 | 243 | -73.9754778808471 | 40.7685619029765 | 4E-AM-1020-01 | 04E | AM | 10202018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 7 | false | false | true | false | false | sitting very still | false | false | false | false | false | false | true | false | POINT (-73.9754778808471 40.7685619029765) | 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 | |||||
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 | ||||
259 | 259 | -73.9726958070536 | 40.7706096126328 | 7F-AM-1008-09 | 07F | AM | 10082018 | 9 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | playing w/ #8 | false | false | false | false | false | false | true | false | POINT (-73.9726958070536 40.7706096126328) | 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 | ||||
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 | |||||
291 | 291 | -73.9679661308374 | 40.7837388390673 | 22C-AM-1013-01 | 22C | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | false | false | sitting still,tail over back | false | false | false | false | false | false | false | false | POINT (-73.9679661308374 40.7837388390673) | 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 | |||
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 | ||||||
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 | ||||
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 | |||||
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 | |||||
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 | ||||
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 | ||||||
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 | |||||
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 | ||||||
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 | |||||
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 | ||||
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 | |||||
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 | |||||
488 | 488 | -73.9615751148595 | 40.7954551238146 | 36A-AM-1018-01 | 36A | AM | 10182018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | false | false | false | true | false | eating (red berries) | false | false | false | false | false | false | true | false | POINT (-73.9615751148595 40.7954551238146) | 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 | |||||
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 | |||||
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 | |||||
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 | |||||
547 | 547 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | true | true | false | false | false | chasing and being chased by #6 | false | false | false | false | true | false | false | true | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
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 | ||||
565 | 565 | -73.9615402629655 | 40.7924082330328 | 33C-AM-1012-02 | 33C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along back & tail | Above Ground | 20 | tree branches | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9615402629655 40.7924082330328) | 19 | 4 | 19 | 13 | |||
566 | 566 | -73.9708364583591 | 40.7723691587433 | 10F-AM-1007-01 | 10F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 60 | false | false | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.9708364583591 40.7723691587433) | 19 | 4 | 19 | 13 | ||||||
582 | 582 | -73.9677779408464 | 40.7867482211349 | 25A-AM-1013-02 | 25A | AM | 10132018 | 2 | Gray | Gray+ | Above Ground | 15 | BIG TREE | false | true | false | false | false | chasing #3 | false | false | false | true | false | false | true | false | POINT (-73.9677779408464 40.7867482211349) | 19 | 4 | 19 | 13 | |||||
588 | 588 | -73.9646597452128 | 40.7827698220703 | 22F-AM-1007-07 | 22F | AM | 10072018 | 7 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | false | false | true | false | false | false | false | false | false | true | false | false | false | alert & aware | POINT (-73.9646597452128 40.7827698220703) | 19 | 4 | 19 | 13 | ||||
593 | 593 | -73.9593352806175 | 40.7918150568046 | 33E-AM-1014-02 | 33E | AM | 10142018 | 2 | Juvenile | Black | Black+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9593352806175 40.7918150568046) | 19 | 4 | 19 | 13 | ||||||
608 | 608 | -73.9589675995517 | 40.7913119223584 | 33E-AM-1014-09 | 33E | AM | 10142018 | 9 | Juvenile | Black | Black+ | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9589675995517 40.7913119223584) | 19 | 4 | 19 | 13 | ||||||
610 | 610 | -73.9671549566066 | 40.7751342870705 | 14H-AM-1007-01 | 14H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 180 | top of tree | true | false | false | false | false | jumping between branches | false | false | false | false | false | false | true | false | POINT (-73.9671549566066 40.7751342870705) | 19 | 4 | 19 | 13 | ||||
615 | 615 | -73.9653279069888 | 40.7758743113817 | 15I-AM-1008-02 | 15I | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Could be same squirrel as #1? | Above Ground | 4 | on fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653279069888 40.7758743113817) | 19 | 4 | 19 | 13 | |||
634 | 634 | -73.9596375907038 | 40.7907347708353 | 32E-AM-1007-05 | 32E | AM | 10072018 | 5 | Adult | Black | Black+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9596375907038 40.79073477083531) | 19 | 4 | 19 | 13 | ||||||
641 | 641 | -73.9719036217446 | 40.7803588122409 | 17A-AM-1017-01 | 17A | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | ground & tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9719036217446 40.7803588122409) | 19 | 4 | 19 | 13 | ||||
647 | 647 | -73.9734762649298 | 40.7663703404546 | 3H-AM-1008-05 | 03H | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.9734762649298 40.7663703404546) | 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 | ||||||
656 | 656 | -73.9553726714504 | 40.7987578541123 | 41D-AM-1014-02 | 41D | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | jumping | false | false | false | false | false | false | true | false | POINT (-73.9553726714504 40.7987578541123) | 19 | 4 | 19 | 13 | |||||
657 | 657 | -73.9679008849677 | 40.7759013923034 | 14G-AM-1012-02 | 14G | AM | 10122018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9679008849677 40.7759013923034) | 19 | 4 | 19 | 13 | ||||||
665 | 665 | -73.9563661256875 | 40.7966823114508 | 39D-AM-1008-03 | 39D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9563661256875 40.7966823114508) | 19 | 4 | 19 | 13 | ||||||
666 | 666 | -73.9687027782726 | 40.7705162616199 | 9I-AM-1014-09 | 09I | AM | 10142018 | 9 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.96870277827261 40.7705162616199) | 19 | 4 | 19 | 13 | ||||||
667 | 667 | -73.9624538733037 | 40.7883829851518 | 28D-AM-1012-04 | 28D | AM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9624538733037 40.7883829851518) | 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 );