This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Running, Chasing, Climbing, Eating, Kuks, Quaas, Tail flags, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | 9 | -73.9770718586754 | 40.7729752391435 | 7B-AM-1008-09 | 07B | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9770718586754 40.7729752391435) | 19 | 4 | 19 | 13 | ||||||
13 | 13 | -73.9541201789795 | 40.7931811701082 | 36H-AM-1010-02 | 36H | AM | 10102018 | 2 | Adult | Gray | Gray+ | just outside hectare | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9541201789795 40.7931811701082) | 19 | 4 | 19 | 13 | |||||
14 | 14 | -73.9582694312289 | 40.7917367820255 | 33F-AM-1008-02 | 33F | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9582694312289 40.7917367820255) | 19 | 4 | 19 | 13 | ||||||
22 | 22 | -73.9703925210471 | 40.7765032004992 | 14E-AM-1008-23 | 14E | AM | 10082018 | 23 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | walking | false | false | false | false | false | false | true | false | POINT (-73.9703925210471 40.7765032004992) | 19 | 4 | 19 | 13 | |||||
24 | 24 | -73.9584070974734 | 40.7913812490557 | 33F-AM-1008-01 | 33F | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | moving slowly | false | false | false | false | false | false | true | false | POINT (-73.9584070974734 40.7913812490557) | 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 | |||||
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 | ||||||
52 | 52 | -73.9675634326877 | 40.7813477352507 | 19D-AM-1007-01 | 19D | AM | 10072018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | false | fenced off area can't approach | POINT (-73.9675634326877 40.7813477352507) | 19 | 4 | 19 | 13 | |||||
56 | 56 | -73.9724642436394 | 40.7690526441109 | 6G-AM-1008-02 | 06G | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | bush | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9724642436394 40.7690526441109) | 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 | ||||||
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 | ||||||
95 | 95 | -73.9692883970928 | 40.7768553703082 | 14E-AM-1008-02 | 14E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | walking | false | false | false | false | false | false | false | true | POINT (-73.9692883970928 40.7768553703082) | 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 | ||||||
117 | 117 | -73.9607746337979 | 40.7939581069382 | 35B-AM-1010-01 | 35B | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | lawn | false | false | false | false | false | walking w/ something in mouth | false | false | false | false | false | false | true | false | POINT (-73.9607746337979 40.793958106938206) | 19 | 4 | 19 | 13 | ||||
121 | 121 | -73.9769939796382 | 40.7729537573035 | 7B-AM-1008-10 | 07B | AM | 10082018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9769939796382 40.7729537573035) | 19 | 4 | 19 | 13 | ||||||
127 | 127 | -73.9664100504436 | 40.7828778892276 | 21D-AM-1008-02 | 21D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9664100504436 40.7828778892276) | 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 | |||||
152 | 152 | -73.9755133710665 | 40.7697883435981 | 5E-AM-1008-08 | 05E | AM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9755133710665 40.7697883435981) | 19 | 4 | 19 | 13 | ||||||
175 | 175 | -73.9720065066618 | 40.7764043782924 | 13C-AM-1010-04 | 13C | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9720065066618 40.7764043782924) | 19 | 4 | 19 | 13 | ||||||
183 | 183 | -73.9768434635084 | 40.7728494038744 | 7B-AM-1008-11 | 07B | AM | 10082018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9768434635084 40.7728494038744) | 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 | |||||
186 | 186 | -73.9788138172962 | 40.7693001754769 | 3B-AM-1010-09 | 03B | AM | 10102018 | 9 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9788138172962 40.7693001754769) | 19 | 4 | 19 | 13 | ||||||
203 | 203 | -73.9638774579549 | 40.7913532129148 | 31A-AM-1010-05 | 31A | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | jumping | false | false | false | true | true | false | true | false | eventually ran from lawnmower (tail flag) | POINT (-73.9638774579549 40.7913532129148) | 19 | 4 | 19 | 13 | ||||
206 | 206 | -73.9613643418025 | 40.7892431934209 | 30D-AM-1017-02 | 30D | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9613643418025 40.7892431934209) | 19 | 4 | 19 | 13 | ||||||
215 | 215 | -73.9519639918804 | 40.7949911702392 | 39H-AM-1007-01 | 39H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9519639918804 40.7949911702392) | 19 | 4 | 19 | 13 | ||||||
223 | 223 | -73.9737091707831 | 40.7713732567512 | 7E-AM-1006-03 | 07E | AM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a tree | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9737091707831 40.7713732567512) | 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 | ||||||
228 | 228 | -73.9728660779622 | 40.7753294525644 | 12C-AM-1013-03 | 12C | AM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | burying | false | false | false | false | false | false | true | false | POINT (-73.9728660779622 40.7753294525644) | 19 | 4 | 19 | 13 | |||||
244 | 244 | -73.9597648775789 | 40.7903443029725 | 32E-AM-1007-01 | 32E | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9597648775789 40.7903443029725) | 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 | |||||
264 | 264 | -73.9698714743386 | 40.7743814661685 | 12F-AM-1020-02 | 12F | AM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9698714743386 40.7743814661685) | 19 | 4 | 19 | 13 | ||||||
265 | 265 | -73.9691094942294 | 40.776760392858 | 14E-AM-1008-01 | 14E | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | walking | false | false | false | false | false | false | false | true | POINT (-73.9691094942294 40.776760392858) | 19 | 4 | 19 | 13 | |||||
273 | 273 | -73.9579218587172 | 40.7960605028848 | 38C-AM-1019-04 | 38C | AM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | true | true | false | false | false | false | true | false | POINT (-73.9579218587172 40.79606050288481) | 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 | |||||
283 | 283 | -73.9529060669193 | 40.7927909735388 | 37I-AM-1010-01 | 37I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9529060669193 40.7927909735388) | 19 | 4 | 19 | 13 | ||||||
296 | 296 | -73.9596964641652 | 40.7957753591585 | 37B-AM-1018-03 | 37B | AM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9596964641652 40.7957753591585) | 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 | ||||||
334 | 334 | -73.9687395228846 | 40.7807364481385 | 18D-AM-1018-02 | 18D | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9687395228846 40.7807364481385) | 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 | ||||||
370 | 370 | -73.9548957862084 | 40.7944844464619 | 37G-AM-1014-05 | 37G | AM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9548957862084 40.7944844464619) | 19 | 4 | 19 | 13 | ||||||
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 | ||||||
373 | 373 | -73.9672127283283 | 40.7810666805133 | 20D-AM-1007-01 | 20D | AM | 10072018 | 1 | Adult | Gray | Gray+ | too far to note 30' | Ground Plane | FALSE | true | false | true | true | false | a lot of activity | false | false | false | true | false | false | false | false | POINT (-73.9672127283283 40.7810666805133) | 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 | ||||||
406 | 406 | -73.9766354967197 | 40.7734575166319 | 8B-AM-1007-09 | 08B | AM | 10072018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | shelling and eating a nut then a dog chased it up a tree & squirrel carried its nut up the tree,settled in a branch & resumed eating | false | false | false | false | false | false | true | false | POINT (-73.9766354967197 40.7734575166319) | 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 | ||||||
417 | 417 | -73.9639888092327 | 40.791449395909 | 31A-AM-1010-01 | 31A | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9639888092327 40.791449395909005) | 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 | |||||
442 | 442 | -73.9502466289084 | 40.7959228779883 | 41I-AM-1018-02 | 41I | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | runs off | POINT (-73.9502466289084 40.7959228779883) | 19 | 4 | 19 | 13 | |||||
449 | 449 | -73.9701335162984 | 40.7722051011357 | 10G-AM-1006-10 | 10G | AM | 10062018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9701335162984 40.7722051011357) | 19 | 4 | 19 | 13 | ||||||
451 | 451 | -73.9753140640445 | 40.7734037805101 | 9C-AM-1006-02 | 09C | AM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9753140640445 40.7734037805101) | 19 | 4 | 19 | 13 | ||||||
452 | 452 | -73.960300330029 | 40.7953475871869 | 36B-AM-1013-03 | 36B | AM | 10132018 | 3 | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.960300330029 40.7953475871869) | 19 | 4 | 19 | 13 | |||||||
459 | 459 | -73.9624546917649 | 40.7888234959792 | 29D-AM-1014-04 | 29D | AM | 10142018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | Rock a | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9624546917649 40.78882349597921) | 19 | 4 | 19 | 13 | |||||
466 | 466 | -73.970308716071 | 40.7763985667344 | 14E-AM-1008-20 | 14E | AM | 10082018 | 20 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | walking | false | false | false | false | false | false | true | false | POINT (-73.970308716071 40.7763985667344) | 19 | 4 | 19 | 13 | |||||
471 | 471 | -73.9707215394887 | 40.7727508149058 | 10G-AM-1006-05 | 10G | AM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#6) | true | false | false | false | false | false | false | false | POINT (-73.9707215394887 40.7727508149058) | 19 | 4 | 19 | 13 | |||||
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 | ||||||
491 | 491 | -73.9688470831269 | 40.7844651946415 | 22A-AM-1008-03 | 22A | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9688470831269 40.7844651946415) | 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 | |||||
507 | 507 | -73.9744835563086 | 40.7729521433235 | 9D-AM-1008-01 | 09D | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9744835563086 40.7729521433235) | 19 | 4 | 19 | 13 | ||||||
511 | 511 | -73.9653142636891 | 40.7760015129298 | 15I-AM-1008-04 | 15I | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653142636891 40.7760015129298) | 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 | |||||
524 | 524 | -73.970173142921 | 40.7762349924081 | 14E-AM-1008-19 | 14E | AM | 10082018 | 19 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.970173142921 40.7762349924081) | 19 | 4 | 19 | 13 | ||||||
529 | 529 | -73.9635290751183 | 40.7820936628202 | 22G-AM-1018-02 | 22G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9635290751183 40.7820936628202) | 19 | 4 | 19 | 13 | ||||||
535 | 535 | -73.9772396728545 | 40.7668696411765 | 2E-AM-1010-02 | 02E | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | totally indifferent | POINT (-73.9772396728545 40.7668696411765) | 19 | 4 | 19 | 13 | |||||
543 | 543 | -73.9701310753277 | 40.7768001008083 | 14E-AM-1008-06 | 14E | AM | 10082018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9701310753277 40.7768001008083) | 19 | 4 | 19 | 13 | ||||||
559 | 559 | -73.9704166194815 | 40.7766720346576 | 14E-AM-1008-07 | 14E | AM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | walking | false | false | false | false | false | false | true | false | POINT (-73.9704166194815 40.7766720346576) | 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 | ||||||
573 | 573 | -73.9674688433583 | 40.7789728381912 | 17E-AM-1017-06 | 17E | AM | 10172018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9674688433583 40.7789728381912) | 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 | |||||
584 | 584 | -73.9720553753548 | 40.7664488175384 | 3I-AM-1010-04 | 03I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9720553753548 40.7664488175384) | 19 | 4 | 19 | 13 | ||||||
587 | 587 | -73.9771843912229 | 40.7723666382125 | 7B-AM-1008-01 | 07B | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9771843912229 40.77236663821251) | 19 | 4 | 19 | 13 | ||||||
603 | 603 | -73.9721592378418 | 40.776034583573 | 12C-AM-1013-02 | 12C | AM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9721592378418 40.776034583573) | 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 | ||||
618 | 618 | -73.957976896139 | 40.797027128241 | 39C-AM-1017-04 | 39C | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.957976896139 40.797027128241005) | 19 | 4 | 19 | 13 | ||||||
623 | 623 | -73.9662939630722 | 40.7878502338031 | 26B-AM-1010-01 | 26B | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | running across bridle path | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9662939630722 40.7878502338031) | 19 | 4 | 19 | 13 | |||||
632 | 632 | -73.9767314435027 | 40.7661199889431 | 1F-AM-1010-01 | 01F | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9767314435027 40.7661199889431) | 19 | 4 | 19 | 13 | ||||||
637 | 637 | -73.9675047480308 | 40.7789234397249 | 17E-AM-1017-01 | 17E | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Pond area | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9675047480308 40.7789234397249) | 19 | 4 | 19 | 13 | |||||
648 | 648 | -73.9539400028236 | 40.79800412717 | 41E-AM-1007-02 | 41E | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9539400028236 40.79800412717) | 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 | |||||
661 | 661 | -73.9700759073973 | 40.7680560871695 | 5I-AM-1010-01 | 05I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9700759073973 40.7680560871695) | 10090 | 23 | 4 | 51 | 11 | |||||
662 | 662 | -73.9721854790038 | 40.7761086352438 | 12C-AM-1013-01 | 12C | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | burying | false | false | false | false | false | false | true | false | POINT (-73.9721854790038 40.7761086352438) | 19 | 4 | 19 | 13 | |||||
663 | 663 | -73.9766440589836 | 40.7682390282581 | 3E-AM-1006-02 | 03E | AM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9766440589836 40.7682390282581) | 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 | ||||||
668 | 668 | -73.9706903740547 | 40.7726873760687 | 10G-AM-1006-07 | 10G | AM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9706903740547 40.77268737606871) | 19 | 4 | 19 | 13 | ||||||
671 | 671 | -73.9709244006956 | 40.7676942639697 | 5I-AM-1010-02 | 05I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9709244006956 40.7676942639697) | 19 | 4 | 19 | 13 | ||||||
675 | 675 | -73.9759830650957 | 40.7683034739069 | 3E-AM-1006-01 | 03E | AM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9759830650957 40.7683034739069) | 19 | 4 | 19 | 13 | ||||||
676 | 676 | -73.9710207438538 | 40.7682187144432 | 5I-AM-1010-05 | 05I | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9710207438538 40.7682187144432) | 19 | 4 | 19 | 13 | ||||||
693 | 693 | -73.969353372175 | 40.7838247422369 | 21A-AM-1019-06 | 21A | AM | 10192018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.969353372175 40.7838247422369) | 19 | 4 | 19 | 13 | ||||||
696 | 696 | -73.9656098194149 | 40.7757643078973 | 15I-AM-1008-05 | 15I | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9656098194149 40.7757643078973) | 19 | 4 | 19 | 13 | ||||||
700 | 700 | -73.9691261755936 | 40.7702929428604 | 8I-AM-1006-12 | 08I | AM | 10062018 | 12 | Adult | Gray | Gray+ | Above Ground | 50 | tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691261755936 40.7702929428604) | 19 | 4 | 19 | 13 | |||||
707 | 707 | -73.961547503801 | 40.7931560668672 | 33B-AM-1010-06 | 33B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.961547503801 40.7931560668672) | 19 | 4 | 19 | 13 | ||||||
724 | 724 | -73.9532952763106 | 40.7920074462622 | 36I-AM-1017-08 | 36I | AM | 10172018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#7) | false | false | false | false | true | false | false | true | runs from (me) | POINT (-73.95329527631061 40.7920074462622) | 19 | 4 | 19 | 13 | ||||
747 | 747 | -73.9771422625274 | 40.772361415776 | 7B-AM-1008-02 | 07B | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9771422625274 40.772361415776) | 19 | 4 | 19 | 13 | ||||||
753 | 753 | -73.9729378674198 | 40.7672407594559 | 4H-AM-1006-04 | 04H | AM | 10062018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | met #3 while foraging and briefly tussled | false | false | false | false | false | false | true | false | POINT (-73.9729378674198 40.7672407594559) | 19 | 4 | 19 | 13 | |||||
757 | 757 | -73.9783185278595 | 40.7724861675504 | 7A-AM-1006-03 | 07A | AM | 10062018 | 3 | Adult | Gray | Gray+ | 3/4 length tail, hair loss | Above Ground | 20 | in trees, then to ground | true | false | true | false | false | jumping | false | false | false | false | false | false | true | false | POINT (-73.9783185278595 40.7724861675504) | 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 );