This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
711 | 711 | -73.9767980925124 | 40.774362775678 | 9A-PM-1010-02 | 09A | PM | 10102018 | 2 | Adult | + | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9767980925124 40.774362775678) | 19 | 4 | 19 | 13 | |||||||
2606 | 2606 | -73.96143417385 | 40.7945464262112 | 35B-PM-1013-02 | 35B | PM | 10132018 | 2 | Juvenile | + | Ground Plane | FALSE | false | false | false | true | false | did not notice dog sitting a few yards away (10-20 ft) | false | false | false | false | true | false | true | false | POINT (-73.96143417385 40.7945464262112) | 19 | 4 | 19 | 13 | ||||||
2851 | 2851 | -73.955208233231 | 40.7890574331084 | 32I-PM-1007-02 | 32I | PM | 10072018 | 2 | Adult | + | Above Ground | 30 | false | false | true | false | false | different sound - happy,playful chirps | false | false | false | false | true | false | true | false | POINT (-73.955208233231 40.7890574331084) | 19 | 4 | 19 | 13 | ||||||
473 | 473 | -73.9570130017159 | 40.7996027428625 | 42B-AM-1014-02 | 42B | AM | 10142018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9570130017159 40.7996027428625) | 19 | 4 | 19 | 13 | |||||
821 | 821 | -73.959077668148 | 40.7926045823346 | 34D-AM-1008-02 | 34D | AM | 10082018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.959077668148 40.7926045823346) | 19 | 4 | 19 | 13 | ||||||
854 | 854 | -73.9577113026056 | 40.7904332453456 | 32G-PM-1013-02 | 32G | PM | 10132018 | 2 | Juvenile | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9577113026056 40.7904332453456) | 19 | 4 | 19 | 13 | ||||||
1528 | 1528 | -73.9690104245067 | 40.7853358193723 | 23A-AM-1018-02 | 23A | AM | 10182018 | 2 | Juvenile | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9690104245067 40.7853358193723) | 19 | 4 | 19 | 13 | ||||||
1959 | 1959 | -73.9707737073771 | 40.7800373465838 | 17B-PM-1012-02 | 17B | PM | 10122018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | true | true | false | false | true | 2/3 chasing each other | true | true | false | true | true | false | true | false | POINT (-73.9707737073771 40.7800373465838) | 19 | 4 | 19 | 13 | |||||
1086 | 1086 | -73.9713399316534 | 40.7750678026757 | 12E-PM-1018-02 | 12E | PM | 10182018 | 2 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Above Ground | 3 | false | false | true | false | false | lounging on tree upside down | false | false | false | false | true | false | true | false | POINT (-73.9713399316534 40.7750678026757) | 19 | 4 | 19 | 13 | |||
2999 | 2999 | -73.972415182837 | 40.773080463452 | 10E-AM-1010-02 | 10E | AM | 10102018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.972415182837 40.773080463452) | 19 | 4 | 19 | 13 | |||||
1558 | 1558 | -73.968200390984 | 40.7837095769482 | 22B-AM-1013-02 | 22B | AM | 10132018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | climbed tree | false | false | false | false | false | false | true | false | POINT (-73.968200390984 40.7837095769482) | 19 | 4 | 19 | 13 | |||||
2838 | 2838 | -73.9507699667119 | 40.7955166039555 | 40I-AM-1018-02 | 40I | AM | 10182018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9507699667119 40.795516603955505) | 19 | 4 | 19 | 13 | ||||||
2955 | 2955 | -73.9711666523376 | 40.7761513057034 | 13D-AM-1014-02 | 13D | AM | 10142018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9711666523376 40.7761513057034) | 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 | |||||
423 | 423 | -73.9756754297747 | 40.7738518843446 | 9B-PM-1013-02 | 09B | PM | 10132018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9756754297747 40.7738518843446) | 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 | |||||
745 | 745 | -73.9671640520938 | 40.7772236833816 | 16G-AM-1010-02 | 16G | AM | 10102018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9671640520938 40.7772236833816) | 19 | 4 | 19 | 13 | |||||
894 | 894 | -73.9675198230918 | 40.778631094685 | 17F-AM-1007-02 | 17F | AM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9675198230918 40.778631094685) | 19 | 4 | 19 | 13 | |||||
1067 | 1067 | -73.9695305996721 | 40.7745386896959 | 12F-PM-1007-02 | 12F | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9695305996721 40.7745386896959) | 19 | 4 | 19 | 13 | |||||
1103 | 1103 | -73.9541500874008 | 40.7920329989756 | 35H-AM-1013-02 | 35H | AM | 10132018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Sitting on tree limb | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | watching me from tree,but calm | POINT (-73.9541500874008 40.7920329989756) | 19 | 4 | 19 | 13 | ||
1266 | 1266 | -73.9709897849823 | 40.768627964006 | 6H-AM-1008-02 | 06H | AM | 10082018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9709897849823 40.768627964006) | 19 | 4 | 19 | 13 | |||||
1437 | 1437 | -73.9721279808683 | 40.7661158663901 | 3I-PM-1013-02 | 03I | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9721279808683 40.7661158663901) | 19 | 4 | 19 | 13 | |||||
1601 | 1601 | -73.9544278270221 | 40.7987827316512 | 42D-PM-1013-02 | 42D | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail, Cinnamon feet | Ground Plane | FALSE | false | true | false | false | true | chasing (chased by #1),found a nut,buried it | false | false | false | false | false | false | true | false | POINT (-73.9544278270221 40.7987827316512) | 19 | 4 | 19 | 13 | |||
1716 | 1716 | -73.9797425262459 | 40.7679120246352 | 1B-AM-1012-02 | 01B | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9797425262459 40.7679120246352) | 19 | 4 | 19 | 13 | |||||
1749 | 1749 | -73.9756825338299 | 40.7755542506699 | 11A-PM-1013-02 | 11A | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756825338299 40.7755542506699) | 19 | 4 | 19 | 13 | |||||
1816 | 1816 | -73.9710187505339 | 40.7797265666746 | 17B-AM-1010-02 | 17B | AM | 10102018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9710187505339 40.7797265666746) | 19 | 4 | 19 | 13 | |||||
1909 | 1909 | -73.9772070122251 | 40.7694343352509 | 4C-PM-1010-02 | 04C | PM | 10102018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.97720701222511 40.7694343352509) | 19 | 4 | 19 | 13 | |||||
2026 | 2026 | -73.9622752768962 | 40.7814921913101 | 22H-PM-1007-02 | 22H | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | low branch | false | false | false | false | false | watching me scratching | true | false | false | true | false | false | true | false | POINT (-73.9622752768962 40.7814921913101) | 19 | 4 | 19 | 13 | |||
2280 | 2280 | -73.9767143644151 | 40.7684756941321 | 3D-AM-1006-02 | 03D | AM | 10062018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 25 | tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9767143644151 40.7684756941321) | 19 | 4 | 19 | 13 | ||||
2487 | 2487 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31 | on tree | true | true | false | false | false | false | false | false | true | true | false | true | false | POINT (-73.9595222999173 40.7833202577782) | 19 | 4 | 19 | 13 | ||||
2504 | 2504 | -73.9550131837533 | 40.7958617258176 | 39E-PM-1013-02 | 39E | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail & butt | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | true | false | POINT (-73.9550131837533 40.7958617258176) | 19 | 4 | 19 | 13 | ||||
2739 | 2739 | -73.9681960138614 | 40.7726867422002 | 11H-AM-1010-02 | 11H | AM | 10102018 | 2 | Cinnamon | Gray | Cinnamon+Gray | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9681960138614 40.7726867422002) | 19 | 4 | 19 | 13 | ||||||||
2915 | 2915 | -73.9734630412566 | 40.7653097139415 | 1H-PM-1013-02 | 01H | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9734630412566 40.7653097139415) | 19 | 4 | 19 | 13 | |||||
249 | 249 | -73.9786339295735 | 40.7684918638639 | 3C-PM-1008-02 | 03C | PM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9786339295735 40.7684918638639) | 19 | 4 | 19 | 13 | |||||
267 | 267 | -73.9754742295091 | 40.7696998327247 | 5E-PM-1012-02 | 05E | PM | 10122018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9754742295091 40.7696998327247) | 19 | 4 | 19 | 13 | |||||
939 | 939 | -73.9761447791484 | 40.7690147873986 | 4D-PM-1008-02 | 04D | PM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9761447791484 40.7690147873986) | 19 | 4 | 19 | 13 | |||||
2300 | 2300 | -73.9789251806378 | 40.7699558513225 | 4B-AM-1010-02 | 04B | AM | 10102018 | 2 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 30 | false | false | true | true | true | true | false | false | false | false | false | true | false | POINT (-73.9789251806378 40.7699558513225) | 19 | 4 | 19 | 13 | |||||
2516 | 2516 | -73.9649823687651 | 40.7763395359636 | 16I-AM-1008-02 | 16I | AM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9649823687651 40.7763395359636) | 19 | 4 | 19 | 13 | |||||
68 | 68 | -73.9694240327509 | 40.7755898126674 | 13F-AM-1007-02 | 13F | AM | 10072018 | 2 | Adult | Cinnamon | White | Cinnamon+White | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.96942403275091 40.7755898126674) | 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 | |||||
485 | 485 | -73.9677423154682 | 40.7728813350245 | 11I-AM-1012-02 | 11I | AM | 10122018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9677423154682 40.77288133502451) | 19 | 4 | 19 | 13 | |||||
1536 | 1536 | -73.9746128451271 | 40.7700957046709 | 6E-PM-1010-02 | 06E | PM | 10102018 | 2 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9746128451271 40.7700957046709) | 19 | 4 | 19 | 13 | |||
7 | 7 | -73.9719735582476 | 40.7693045133578 | 6G-PM-1020-02 | 06G | PM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9719735582476 40.7693045133578) | 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 | ||||||
40 | 40 | -73.9535410657077 | 40.7928711760061 | 36H-PM-1008-02 | 36H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9535410657077 40.79287117600611) | 19 | 4 | 19 | 13 | ||||||
46 | 46 | -73.9673253417305 | 40.7749505252981 | 13H-PM-1010-02 | 13H | PM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | tree | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9673253417305 40.7749505252981) | 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 | |||||
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 | ||||||
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 | |||||
192 | 192 | -73.9651654887991 | 40.7777806006951 | 17H-PM-1007-02 | 17H | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9651654887991 40.7777806006951) | 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 | ||||||
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 | |||||
367 | 367 | -73.9704862864304 | 40.7739583111676 | 11F-PM-1006-02 | 11F | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9704862864304 40.7739583111676) | 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 | ||||||
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 | |||||
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 | |||||
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 | ||||||
638 | 638 | -73.9562765288004 | 40.7880617963868 | 31I-PM-1019-02 | 31I | PM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9562765288004 40.7880617963868) | 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 | |||||
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 | ||||||
766 | 766 | -73.9684463154398 | 40.7834813319352 | 21B-AM-1019-02 | 21B | AM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9684463154398 40.7834813319352) | 19 | 4 | 19 | 13 | ||||||
857 | 857 | -73.9714243547433 | 40.7713973982359 | 8G-PM-1017-02 | 08G | PM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714243547433 40.7713973982359) | 19 | 4 | 19 | 13 | ||||||
892 | 892 | -73.9611368390233 | 40.7815619053395 | 22I-AM-1007-02 | 22I | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9611368390233 40.7815619053395) | 19 | 4 | 19 | 13 | ||||||
936 | 936 | -73.9684758245091 | 40.7858531619022 | 24A-PM-1007-02 | 24A | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9684758245091 40.7858531619022) | 19 | 4 | 19 | 13 | ||||||
1041 | 1041 | -73.9643236505425 | 40.7887854771596 | 28C-AM-1014-02 | 28C | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9643236505425 40.7887854771596) | 19 | 4 | 19 | 13 | ||||||
1061 | 1061 | -73.9532657715601 | 40.7949046809422 | 39G-AM-1018-02 | 39G | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 25 | Tree | false | false | false | false | false | sitting & watching | false | false | false | false | false | false | true | false | POINT (-73.9532657715601 40.7949046809422) | 19 | 4 | 19 | 13 | ||||
1095 | 1095 | -73.9735547926323 | 40.7723420076108 | 8D-AM-1007-02 | 08D | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 12 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9735547926323 40.7723420076108) | 19 | 4 | 19 | 13 | ||||||
1136 | 1136 | -73.9515907796216 | 40.7952684235477 | 40H-AM-1017-02 | 40H | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95159077962161 40.7952684235477) | 19 | 4 | 19 | 13 | ||||||
1228 | 1228 | -73.9729090336637 | 40.7794340052503 | 15A-AM-1007-02 | 15A | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | in fenced in lawn (chill) | POINT (-73.9729090336637 40.7794340052503) | 19 | 4 | 19 | 13 | |||||
1274 | 1274 | -73.9745859998733 | 40.7671634885616 | 3G-AM-1008-02 | 03G | AM | 10082018 | 2 | Adult | Gray | Gray+ | Big one! Beautiful tail | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9745859998733 40.7671634885616) | 19 | 4 | 19 | 13 | |||||
1370 | 1370 | -73.9681627331154 | 40.7785099665602 | 17E-PM-1018-02 | 17E | PM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | On the rock | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9681627331154 40.7785099665602) | 19 | 4 | 19 | 13 | |||||
1422 | 1422 | -73.9537356145842 | 40.7917273773486 | 35I-PM-1006-02 | 35I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9537356145842 40.7917273773486) | 19 | 4 | 19 | 13 | ||||||
1488 | 1488 | -73.9690072647093 | 40.7737712267463 | 12G-AM-1012-02 | 12G | AM | 10122018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9690072647093 40.7737712267463) | 19 | 4 | 19 | 13 | ||||||
1504 | 1504 | -73.9706586108006 | 40.7796357444471 | 17C-PM-1013-02 | 17C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | in a tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9706586108006 40.7796357444471) | 19 | 4 | 19 | 13 | |||||
1570 | 1570 | -73.9662864884789 | 40.7891062338302 | 28A-PM-1007-02 | 28A | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | running from #3 | false | false | false | false | false | false | true | false | POINT (-73.9662864884789 40.7891062338302) | 19 | 4 | 19 | 13 | |||||
1613 | 1613 | -73.9599202233536 | 40.7972599930224 | 38A-AM-1019-02 | 38A | AM | 10192018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9599202233536 40.7972599930224) | 19 | 4 | 19 | 13 | ||||||
1618 | 1618 | -73.9755836827968 | 40.7670239327996 | 2F-PM-1014-02 | 02F | PM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9755836827968 40.7670239327996) | 19 | 4 | 19 | 13 | ||||||
1634 | 1634 | -73.9726459773995 | 40.7656357433691 | 2I-AM-1006-02 | 02I | AM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9726459773995 40.7656357433691) | 19 | 4 | 19 | 13 | ||||||
1697 | 1697 | -73.9568610943394 | 40.7935959584643 | 36E-PM-1012-02 | 36E | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 28 | on tree branch | false | false | true | false | true | picking acorns off oak tree | false | false | false | false | false | false | true | false | POINT (-73.95686109433942 40.7935959584643) | 19 | 4 | 19 | 13 | ||||
1702 | 1702 | -73.9752699507508 | 40.7688069184057 | 4E-PM-1008-02 | 04E | PM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9752699507508 40.76880691840571) | 19 | 4 | 19 | 13 | ||||||
1724 | 1724 | -73.9795492724533 | 40.7709497471738 | 4A-AM-1007-02 | 04A | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9795492724533 40.7709497471738) | 19 | 4 | 19 | 13 | ||||||
1838 | 1838 | -73.9686622009739 | 40.7767294380502 | 15F-PM-1010-02 | 15F | PM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686622009739 40.7767294380502) | 19 | 4 | 19 | 13 | ||||||
1899 | 1899 | -73.9764314091366 | 40.7736458057952 | 8B-AM-1007-02 | 08B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9764314091366 40.773645805795205) | 19 | 4 | 19 | 13 | ||||||
1904 | 1904 | -73.9684058476942 | 40.7753959833776 | 13G-PM-1008-02 | 13G | PM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 15 | willow oak tree | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9684058476942 40.7753959833776) | 19 | 4 | 19 | 13 | |||||
1917 | 1917 | -73.9627819112681 | 40.7886877360376 | 29D-AM-1014-02 | 29D | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9627819112681 40.7886877360376) | 19 | 4 | 19 | 13 | ||||||
1934 | 1934 | -73.969756965598 | 40.7786455091699 | 16D-PM-1010-02 | 16D | PM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.969756965598 40.7786455091699) | 19 | 4 | 19 | 13 | ||||||
1936 | 1936 | -73.9667911565238 | 40.779321901098 | 18F-AM-1014-02 | 18F | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | In small tree by water | false | false | false | true | true | false | true | false | false | false | false | true | false | POINT (-73.9667911565238 40.77932190109801) | 19 | 4 | 19 | 13 | |||||
1955 | 1955 | -73.9606559309874 | 40.7889527629826 | 30E-AM-1008-02 | 30E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9606559309874 40.7889527629826) | 19 | 4 | 19 | 13 | ||||||
1971 | 1971 | -73.9591880400132 | 40.7950071252836 | 36C-PM-1013-02 | 36C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | false | true | false | true | true | true | true | false | false | true | false | true | false | POINT (-73.95918804001322 40.7950071252836) | 19 | 4 | 19 | 13 | |||||
1989 | 1989 | -73.9631646754647 | 40.7925716810884 | 32A-AM-1018-02 | 32A | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9631646754647 40.7925716810884) | 19 | 4 | 19 | 13 | ||||||
2020 | 2020 | -73.9691453885964 | 40.7770524089712 | 15E-PM-1008-02 | 15E | PM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9691453885964 40.7770524089712) | 19 | 4 | 19 | 13 | ||||||
2035 | 2035 | -73.9527184914182 | 40.7926785904847 | 37I-PM-1006-02 | 37I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9527184914182 40.7926785904847) | 19 | 4 | 19 | 13 | ||||||
2095 | 2095 | -73.9747762992858 | 40.7768579078578 | 12A-AM-1008-02 | 12A | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9747762992858 40.7768579078578) | 19 | 4 | 19 | 13 | ||||||
2136 | 2136 | -73.9721897915211 | 40.7660434203132 | 3I-AM-1010-02 | 03I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721897915211 40.76604342031321) | 19 | 4 | 19 | 13 | ||||||
2180 | 2180 | -73.960864328605 | 40.7902122634639 | 31D-PM-1006-02 | 31D | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.960864328605 40.7902122634639) | 19 | 4 | 19 | 13 | ||||||
2200 | 2200 | -73.9698080328304 | 40.7842252948542 | 21A-AM-1019-02 | 21A | AM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Tree & ground | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9698080328304 40.7842252948542) | 19 | 4 | 19 | 13 | |||||
2230 | 2230 | -73.9730813162152 | 40.7779315720879 | 14B-AM-1007-02 | 14B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9730813162152 40.7779315720879) | 19 | 4 | 19 | 13 | ||||||
2258 | 2258 | -73.9547785081171 | 40.789612183711 | 33I-AM-1008-02 | 33I | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | edge of park @ 98th | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9547785081171 40.789612183711) | 19 | 4 | 19 | 13 | |||||
2296 | 2296 | -73.965596981561 | 40.7797738845824 | 19F-PM-1017-02 | 19F | PM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.965596981561 40.7797738845824) | 19 | 4 | 19 | 13 | ||||||
2356 | 2356 | -73.9611355303487 | 40.793069353224 | 34C-AM-1007-02 | 34C | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611355303487 40.793069353224) | 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 );