This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
778 | 778 | -73.9677054870327 | 40.778992870166 | 17E-AM-1017-03 | 17E | AM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 9 | Tree trunk | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9677054870327 40.778992870166) | 19 | 4 | 19 | 13 | |||||
838 | 838 | -73.9691031094688 | 40.7706693835189 | 9I-AM-1014-02 | 09I | AM | 10142018 | 2 | Adult | Gray | Gray+ | Very far, so appx | Above Ground | 35 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9691031094688 40.7706693835189) | 19 | 4 | 19 | 13 | |||||
919 | 919 | -73.9637279711853 | 40.7905198502307 | 30B-AM-1007-09 | 30B | AM | 10072018 | 9 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | jumping b/w trees | false | false | false | false | false | false | false | false | POINT (-73.9637279711853 40.7905198502307) | 19 | 4 | 19 | 13 | |||||
923 | 923 | -73.9578924882613 | 40.789806297824 | 32G-AM-1010-02 | 32G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | false | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9578924882613 40.789806297824) | 19 | 4 | 19 | 13 | ||||||
958 | 958 | -73.9613862251332 | 40.791282169715 | 32C-AM-1014-03 | 32C | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9613862251332 40.791282169715) | 19 | 4 | 19 | 13 | ||||||
1032 | 1032 | -73.9632868561794 | 40.7907806312915 | 30B-AM-1007-06 | 30B | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9632868561794 40.7907806312915) | 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 | ||||||
1053 | 1053 | -73.9685859705486 | 40.7848805065322 | 23A-AM-1018-04 | 23A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | Tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685859705486 40.7848805065322) | 19 | 4 | 19 | 13 | |||||
1071 | 1071 | -73.9703774000082 | 40.7717607551555 | 9G-AM-1007-01 | 09G | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9703774000082 40.7717607551555) | 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 | ||||||
1144 | 1144 | -73.9743184653765 | 40.7667932997 | 3G-AM-1008-01 | 03G | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9743184653765 40.7667932997) | 19 | 4 | 19 | 13 | ||||||
1188 | 1188 | -73.9669529835992 | 40.7871864151365 | 25A-AM-1013-05 | 25A | AM | 10132018 | 5 | Gray | Gray+ | Ground Plane | FALSE | CROSS BRIDLE - INTO TREE TO AVOID DOGGO | true | false | true | false | false | d.p.t. | false | false | false | true | true | false | true | false | calm | POINT (-73.96695298359921 40.7871864151365) | 19 | 4 | 19 | 13 | ||||
1192 | 1192 | -73.9634811495245 | 40.790705585077 | 30B-AM-1007-10 | 30B | AM | 10072018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.9634811495245 40.790705585077) | 19 | 4 | 19 | 13 | ||||||
1207 | 1207 | -73.9594708328732 | 40.791192982895 | 32E-AM-1007-07 | 32E | AM | 10072018 | 7 | Adult | Gray | Gray+ | Above Ground | on tennis club house roof | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9594708328732 40.791192982895) | 19 | 4 | 19 | 13 | ||||||
1227 | 1227 | -73.9527924755398 | 40.7934366260533 | 37I-AM-1010-04 | 37I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Above Ground | 50 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527924755398 40.7934366260533) | 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 | |||||
1280 | 1280 | -73.9562469727195 | 40.79685907654 | 39D-AM-1008-04 | 39D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562469727195 40.79685907654) | 19 | 4 | 19 | 13 | ||||||
1304 | 1304 | -73.9533319519277 | 40.7933647909449 | 37H-AM-1018-02 | 37H | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | Large tree by (fence of the conservatory) about to climb up | false | false | true | false | false | false | false | false | false | false | false | false | false | busy,ready to climb | POINT (-73.9533319519277 40.7933647909449) | 19 | 4 | 19 | 13 | |||||
1329 | 1329 | -73.9772164524209 | 40.7688399538756 | 3D-AM-1006-06 | 03D | AM | 10062018 | 6 | Gray | Gray+ | Above Ground | 10 | tree | true | false | true | false | false | false | false | false | false | false | false | false | false | did not run from humans,but ran straight to tree & climbed up | POINT (-73.9772164524209 40.7688399538756) | 19 | 4 | 19 | 13 | |||||
1355 | 1355 | -73.9655277320465 | 40.7806120529369 | 20F-AM-1014-03 | 20F | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9655277320465 40.7806120529369) | 19 | 4 | 19 | 13 | ||||||
1365 | 1365 | -73.9791648157033 | 40.767625444347 | 2C-AM-1010-04 | 02C | AM | 10102018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9791648157033 40.767625444347) | 19 | 4 | 19 | 13 | ||||||
1402 | 1402 | -73.9745009906157 | 40.7741574075364 | 10C-AM-1018-01 | 10C | AM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9745009906157 40.7741574075364) | 19 | 4 | 19 | 13 | ||||||
1433 | 1433 | -73.9574077497624 | 40.8001185184892 | 42B-AM-1014-01 | 42B | AM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9574077497624 40.8001185184892) | 19 | 4 | 19 | 13 | ||||||
1507 | 1507 | -73.9699799501516 | 40.7736576286234 | 11F-AM-1013-02 | 11F | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9699799501516 40.7736576286234) | 19 | 4 | 19 | 13 | ||||||
1517 | 1517 | -73.970041085185 | 40.7834427580313 | 21A-AM-1019-07 | 21A | AM | 10192018 | 7 | Adult | Gray | Gray+ | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.970041085185 40.783442758031306) | 19 | 4 | 19 | 13 | ||||||
1566 | 1566 | -73.9695133370801 | 40.7765009796853 | 14E-AM-1008-16 | 14E | AM | 10082018 | 16 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9695133370801 40.7765009796853) | 19 | 4 | 19 | 13 | ||||||
1569 | 1569 | -73.973047824163 | 40.7700873791211 | 7F-AM-1008-03 | 07F | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.973047824163 40.7700873791211) | 19 | 4 | 19 | 13 | ||||||
1598 | 1598 | -73.9726828460055 | 40.7705707694822 | 7F-AM-1008-08 | 07F | AM | 10082018 | 8 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | playing w/ #9 | false | false | false | false | false | false | true | false | POINT (-73.9726828460055 40.7705707694822) | 19 | 4 | 19 | 13 | |||||
1610 | 1610 | -73.9607056611532 | 40.7889786103871 | 30E-AM-1008-03 | 30E | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9607056611532 40.7889786103871) | 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 | ||||||
1630 | 1630 | -73.9710025484537 | 40.7792529489016 | 16C-AM-1014-01 | 16C | AM | 10142018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9710025484537 40.7792529489016) | 19 | 4 | 19 | 13 | ||||||
1675 | 1675 | -73.9777497645834 | 40.7677344709178 | 2D-AM-1007-04 | 02D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 100 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9777497645834 40.7677344709178) | 19 | 4 | 19 | 13 | ||||||
1692 | 1692 | -73.973268329435 | 40.7708296517073 | 7E-AM-1006-05 | 07E | AM | 10062018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.973268329435 40.7708296517073) | 19 | 4 | 19 | 13 | |||||
1696 | 1696 | -73.9694591667705 | 40.7766518221998 | 14E-AM-1008-12 | 14E | AM | 10082018 | 12 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694591667705 40.7766518221998) | 19 | 4 | 19 | 13 | ||||||
1701 | 1701 | -73.9701634768603 | 40.7778691433218 | 15D-AM-1007-03 | 15D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9701634768603 40.7778691433218) | 19 | 4 | 19 | 13 | ||||||
1715 | 1715 | -73.9745709109056 | 40.7672225695415 | 3G-AM-1008-03 | 03G | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | true | false | false | in tree | false | false | false | false | false | false | true | false | POINT (-73.9745709109056 40.7672225695415) | 19 | 4 | 19 | 13 | |||||
1723 | 1723 | -73.9747959143543 | 40.7768078174366 | 12A-AM-1008-01 | 12A | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9747959143543 40.7768078174366) | 19 | 4 | 19 | 13 | ||||||
1729 | 1729 | -73.9765046109019 | 40.7736674124746 | 8B-AM-1007-04 | 08B | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9765046109019 40.7736674124746) | 19 | 4 | 19 | 13 | ||||||
1790 | 1790 | -73.9730592548116 | 40.7740879251541 | 10D-AM-1008-04 | 10D | AM | 10082018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 25 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9730592548116 40.7740879251541) | 19 | 4 | 19 | 13 | ||||||
1796 | 1796 | -73.9765355395622 | 40.7735653237366 | 8B-AM-1007-03 | 08B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97653553956222 40.7735653237366) | 19 | 4 | 19 | 13 | ||||||
1828 | 1828 | -73.9682965197661 | 40.7805378963883 | 18D-AM-1018-04 | 18D | AM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9682965197661 40.7805378963883) | 19 | 4 | 19 | 13 | ||||||
1841 | 1841 | -73.9806377967573 | 40.7681097168268 | 1B-AM-1012-15 | 01B | AM | 10122018 | 15 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9806377967573 40.7681097168268) | 19 | 4 | 19 | 13 | ||||||
1886 | 1886 | -73.956806913988 | 40.7987736900857 | 41C-AM-1017-06 | 41C | AM | 10172018 | 6 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.956806913988 40.7987736900857) | 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 | ||||||
1940 | 1940 | -73.9696445614055 | 40.7791486203627 | 17D-AM-1008-05 | 17D | AM | 10082018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9696445614055 40.7791486203627) | 19 | 4 | 19 | 13 | ||||||
1943 | 1943 | -73.9690447463294 | 40.783913304529 | 21B-AM-1019-06 | 21B | AM | 10192018 | 6 | Juvenile | Gray | Gray+ | Above Ground | 7 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9690447463294 40.78391330452901) | 19 | 4 | 19 | 13 | ||||||
1998 | 1998 | -73.9595686513629 | 40.7906859748696 | 32E-AM-1007-06 | 32E | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9595686513629 40.7906859748696) | 19 | 4 | 19 | 13 | ||||||
2003 | 2003 | -73.9640526358598 | 40.7907411574825 | 30B-AM-1007-01 | 30B | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9640526358598 40.7907411574825) | 19 | 4 | 19 | 13 | ||||||
2017 | 2017 | -73.9775067398903 | 40.7726566142401 | 7B-AM-1008-14 | 07B | AM | 10082018 | 14 | Adult | Gray | Gray+ | Above Ground | on fence | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9775067398903 40.7726566142401) | 19 | 4 | 19 | 13 | ||||||
2064 | 2064 | -73.970260899173 | 40.783651724865 | 21A-AM-1019-05 | 21A | AM | 10192018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.970260899173 40.783651724865) | 19 | 4 | 19 | 13 | ||||||
2076 | 2076 | -73.9712636931964 | 40.77998098773 | 17B-AM-1010-03 | 17B | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9712636931964 40.77998098773) | 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 | ||||||
2098 | 2098 | -73.9700779726297 | 40.7722086251085 | 10G-AM-1006-11 | 10G | AM | 10062018 | 11 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.9700779726297 40.7722086251085) | 19 | 4 | 19 | 13 | ||||||
2122 | 2122 | -73.9692946938852 | 40.7767389791452 | 14E-AM-1008-13 | 14E | AM | 10082018 | 13 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | true | true | false | false | false | false | false | false | true | false | curious | POINT (-73.9692946938852 40.7767389791452) | 19 | 4 | 19 | 13 | |||||
2179 | 2179 | -73.9559663949511 | 40.7974497269789 | 40D-AM-1013-07 | 40D | AM | 10132018 | 7 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | true | false | false | false | false | false | false | false | true | curious | POINT (-73.9559663949511 40.7974497269789) | 19 | 4 | 19 | 13 | |||||
2248 | 2248 | -73.9766477027266 | 40.7712737417779 | 6C-AM-1007-04 | 06C | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | true | true | false | false | chasing #5 | false | false | false | false | false | false | true | false | POINT (-73.9766477027266 40.7712737417779) | 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 | |||||
2297 | 2297 | -73.9787771053108 | 40.769356212275 | 3B-AM-1010-07 | 03B | AM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | together w/ #8 | false | false | false | true | false | false | true | false | POINT (-73.9787771053108 40.76935621227501) | 19 | 4 | 19 | 13 | |||||
2338 | 2338 | -73.9716621112698 | 40.7742862219469 | 11E-AM-1013-01 | 11E | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9716621112698 40.7742862219469) | 19 | 4 | 19 | 13 | ||||||
2354 | 2354 | -73.9636740170308 | 40.7903538224977 | 30B-AM-1007-12 | 30B | AM | 10072018 | 12 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.96367401703081 40.79035382249771) | 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 | ||||||
2361 | 2361 | -73.9708032298419 | 40.7784265674544 | 15C-AM-1010-02 | 15C | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | nest building | false | false | false | false | false | false | true | false | POINT (-73.9708032298419 40.77842656745441) | 19 | 4 | 19 | 13 | |||||
2377 | 2377 | -73.9704328573603 | 40.7739347247552 | 11F-AM-1013-03 | 11F | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9704328573603 40.7739347247552) | 19 | 4 | 19 | 13 | ||||||
2420 | 2420 | -73.9587787592751 | 40.7981699014259 | 40A-AM-1010-01 | 40A | AM | 10102018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 30 | bottom of great hill | false | false | true | false | false | false | false | false | false | false | false | false | false | climbing up a tree | POINT (-73.9587787592751 40.7981699014259) | 19 | 4 | 19 | 13 | ||||
2435 | 2435 | -73.972087127535 | 40.776237268628 | 13C-AM-1010-01 | 13C | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.972087127535 40.776237268628) | 19 | 4 | 19 | 13 | ||||||
2440 | 2440 | -73.9673803508629 | 40.7785245025508 | 17F-AM-1007-01 | 17F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 18 | false | false | true | true | false | false | false | false | true | false | false | true | false | POINT (-73.9673803508629 40.7785245025508) | 19 | 4 | 19 | 13 | ||||||
2450 | 2450 | -73.9756273257684 | 40.7706539186221 | 6D-AM-1008-04 | 06D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9756273257684 40.7706539186221) | 19 | 4 | 19 | 13 | |||||||
2452 | 2452 | -73.9727323797981 | 40.7669035463955 | 3H-AM-1008-03 | 03H | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | building nest | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9727323797981 40.7669035463955) | 19 | 4 | 19 | 13 | |||||
2466 | 2466 | -73.9599419926299 | 40.7972774728811 | 38A-AM-1019-01 | 38A | AM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9599419926299 40.7972774728811) | 19 | 4 | 19 | 13 | ||||||
2552 | 2552 | -73.9724947710698 | 40.7696619340886 | 6G-AM-1008-05 | 06G | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 30 | branch | false | false | true | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9724947710698 40.7696619340886) | 19 | 4 | 19 | 13 | ||||
2577 | 2577 | -73.9597048490102 | 40.7955846466241 | 37B-AM-1018-06 | 37B | AM | 10182018 | 6 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9597048490102 40.7955846466241) | 19 | 4 | 19 | 13 | ||||||
2584 | 2584 | -73.9727187453699 | 40.7669595710626 | 3H-AM-1008-02 | 03H | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9727187453699 40.7669595710626) | 19 | 4 | 19 | 13 | |||||||
2588 | 2588 | -73.9581007437094 | 40.7959403112722 | 38C-AM-1019-06 | 38C | AM | 10192018 | 6 | Adult | Gray | Gray+ | Above Ground | 23 | false | false | true | false | false | true | false | false | true | false | false | true | false | POINT (-73.9581007437094 40.7959403112722) | 19 | 4 | 19 | 13 | ||||||
2598 | 2598 | -73.976658503418 | 40.7686868456917 | 4D-AM-1012-03 | 04D | AM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.976658503418 40.7686868456917) | 19 | 4 | 19 | 13 | ||||||
2603 | 2603 | -73.9708781504528 | 40.7724138070355 | 10F-AM-1007-03 | 10F | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9708781504528 40.7724138070355) | 19 | 4 | 19 | 13 | ||||||
2616 | 2616 | -73.9675917702187 | 40.7789922281625 | 17E-AM-1017-02 | 17E | AM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 8 | Shore | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9675917702187 40.7789922281625) | 19 | 4 | 19 | 13 | |||||
2634 | 2634 | -73.9695685186489 | 40.7788293026327 | 16D-AM-1007-04 | 16D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9695685186489 40.7788293026327) | 19 | 4 | 19 | 13 | ||||||
2663 | 2663 | -73.9613429184974 | 40.7912158057267 | 32C-AM-1014-02 | 32C | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9613429184974 40.7912158057267) | 19 | 4 | 19 | 13 | ||||||
2791 | 2791 | -73.9593624259363 | 40.7905522356793 | 32E-AM-1007-02 | 32E | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9593624259363 40.7905522356793) | 19 | 4 | 19 | 13 | ||||||
2813 | 2813 | -73.9659118189359 | 40.7765739928504 | 15H-AM-1013-02 | 15H | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9659118189359 40.7765739928504) | 19 | 4 | 19 | 13 | ||||||
2826 | 2826 | -73.9600357018376 | 40.7906539766881 | 32E-AM-1007-08 | 32E | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 65 | tree top | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9600357018376 40.7906539766881) | 19 | 4 | 19 | 13 | |||||
2911 | 2911 | -73.9793923984874 | 40.7708475474583 | 5A-AM-1006-01 | 05A | AM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 10 | Oak tree near rock outcropping | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97939239848742 40.7708475474583) | 19 | 4 | 19 | 13 | |||||
2933 | 2933 | -73.9677903197449 | 40.7826561917755 | 21C-AM-1014-03 | 21C | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | true | true | false | false | false | true | false | false | false | false | false | false | looked at us from tree | POINT (-73.9677903197449 40.7826561917755) | 19 | 4 | 19 | 13 | |||||
2988 | 2988 | -73.9766342759486 | 40.7687518380873 | 4D-AM-1012-04 | 04D | AM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | on tree trunk | false | true | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9766342759486 40.7687518380873) | 19 | 4 | 19 | 13 | |||||
2990 | 2990 | -73.9766012108307 | 40.7712310725379 | 6C-AM-1007-05 | 06C | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | true | true | false | false | chasing #4 | false | false | false | false | false | false | true | false | POINT (-73.9766012108307 40.7712310725379) | 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 | |||
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 | |||||
1512 | 1512 | -73.9733882364574 | 40.7683078706597 | 5G-AM-1006-01 | 05G | AM | 10062018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | made eye contact with me | POINT (-73.9733882364574 40.7683078706597) | 19 | 4 | 19 | 13 | ||||
1653 | 1653 | -73.9695881075086 | 40.7842441291991 | 21A-AM-1019-01 | 21A | AM | 10192018 | 1 | Juvenile | Gray | Black | Gray+Black | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | false | keeps to tree,drops down on side away from people | POINT (-73.9695881075086 40.7842441291991) | 19 | 4 | 19 | 13 | ||||
2130 | 2130 | -73.9695572903383 | 40.780822981713 | 18C-AM-1018-01 | 18C | AM | 10182018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9695572903383 40.780822981713) | 19 | 4 | 19 | 13 | |||||
2228 | 2228 | -73.9714045891597 | 40.7715418333976 | 9G-AM-1007-03 | 09G | AM | 10072018 | 3 | Adult | Gray | Black | Gray+Black | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.97140458915972 40.7715418333976) | 19 | 4 | 19 | 13 | |||||
2609 | 2609 | -73.9596865318094 | 40.7893787188526 | 31F-AM-1013-01 | 31F | AM | 10132018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9596865318094 40.7893787188526) | 19 | 4 | 19 | 13 | |||||
820 | 820 | -73.9801902133148 | 40.769557595068 | 3A-AM-1012-03 | 03A | AM | 10122018 | 3 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Above Ground | 1 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9801902133148 40.769557595068) | 19 | 4 | 19 | 13 | ||||
1164 | 1164 | -73.9790226400629 | 40.7698997653792 | 4B-AM-1010-01 | 04B | AM | 10102018 | 1 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Above Ground | 2 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9790226400629 40.7698997653792) | 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 | ||||
97 | 97 | -73.9639744005647 | 40.7825111950764 | 22F-AM-1007-01 | 22F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9639744005647 40.7825111950764) | 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 | ||||
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 | |||||
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 | ||||
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 |
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 );