This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Running, Chasing, Climbing, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
690 | 690 | -73.9767949141123 | 40.774454583585 | 9A-PM-1010-01 | 09A | PM | 10102018 | 1 | Adult | + | Ground Plane | FALSE | by large tree in sectioned off area | false | false | true | false | false | i think it climbed the tree when i first saw it. | false | false | false | false | false | false | true | false | POINT (-73.9767949141123 40.774454583585) | 19 | 4 | 19 | 13 | |||||
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 | |||||||
1406 | 1406 | -73.9746204802221 | 40.7699294840733 | 6E-PM-1010-01 | 06E | PM | 10102018 | 1 | Juvenile | + | Ground Plane | FALSE | along dirt path by cross-town car road. saw movement in a shrub/then caught sight a little fluffy tail | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9746204802221 40.7699294840733) | 19 | 4 | 19 | 13 | ||||||
1483 | 1483 | -73.9545773579075 | 40.7898684635744 | 33I-AM-1008-05 | 33I | AM | 10082018 | 5 | Adult | + | Above Ground | 100 | false | false | true | false | true | false | false | false | false | false | false | true | false | nearly dropped shell on my head! | POINT (-73.9545773579075 40.7898684635744) | 19 | 4 | 19 | 13 | ||||||
1993 | 1993 | -73.9546367558712 | 40.789840987798 | 33I-AM-1008-04 | 33I | AM | 10082018 | 4 | Adult | + | Above Ground | 100 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9546367558712 40.789840987798) | 19 | 4 | 19 | 13 | |||||||
2031 | 2031 | -73.9795454787631 | 40.7688026892741 | 3B-PM-1007-09 | 03B | PM | 10072018 | 9 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9795454787631 40.7688026892741) | 19 | 4 | 19 | 13 | |||||||||
2790 | 2790 | -73.9673554935258 | 40.7827527249594 | 21C-AM-1014-04 | 21C | AM | 10142018 | 4 | Adult | + | High in tree, unable to tell | Above Ground | 60 | false | false | true | false | false | false | false | false | true | false | false | true | false | POINT (-73.96735549352582 40.7827527249594) | 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 | ||||||
50 | 50 | -73.9680635070949 | 40.779249873647 | 17E-AM-1017-05 | 17E | AM | 10172018 | 5 | Adult | Black | Black+ | Above Ground | 10 | Branch | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9680635070949 40.779249873647) | 19 | 4 | 19 | 13 | |||||
99 | 99 | -73.9710541405708 | 40.7724691605718 | 10F-PM-1019-05 | 10F | PM | 10192018 | 5 | Adult | Black | Black+ | Above Ground | 10 | Behind fence, tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9710541405708 40.7724691605718) | 19 | 4 | 19 | 13 | |||||
182 | 182 | -73.9691050656013 | 40.7808139538222 | 18C-PM-1018-01 | 18C | PM | 10182018 | 1 | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9691050656013 40.7808139538222) | 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 | |||||
481 | 481 | -73.9714303315699 | 40.7745934947706 | 11E-AM-1013-04 | 11E | AM | 10132018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | burying | false | false | false | false | false | false | true | false | POINT (-73.9714303315699 40.7745934947706) | 19 | 4 | 19 | 13 | |||||
542 | 542 | -73.9713487591577 | 40.7784353043714 | 15C-PM-1017-03 | 15C | PM | 10172018 | 3 | Adult | Black | Black+ | Above Ground | 17 | running across overpass | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9713487591577 40.7784353043714) | 19 | 4 | 19 | 13 | |||||
546 | 546 | -73.9547423290276 | 40.7899702628835 | 33I-PM-1006-09 | 33I | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9547423290276 40.7899702628835) | 19 | 4 | 19 | 13 | ||||||
608 | 608 | -73.9589675995517 | 40.7913119223584 | 33E-AM-1014-09 | 33E | AM | 10142018 | 9 | Juvenile | Black | Black+ | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9589675995517 40.7913119223584) | 19 | 4 | 19 | 13 | ||||||
634 | 634 | -73.9596375907038 | 40.7907347708353 | 32E-AM-1007-05 | 32E | AM | 10072018 | 5 | Adult | Black | Black+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9596375907038 40.79073477083531) | 19 | 4 | 19 | 13 | ||||||
746 | 746 | -73.9591407691 | 40.7960846903122 | 37B-AM-1018-01 | 37B | AM | 10182018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9591407691 40.7960846903122) | 19 | 4 | 19 | 13 | ||||||
770 | 770 | -73.9597782762029 | 40.7920773376757 | 33D-AM-1017-07 | 33D | AM | 10172018 | 7 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | true | false | true | false | false | true | false | POINT (-73.9597782762029 40.7920773376757) | 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 | ||||||
1026 | 1026 | -73.9710951149579 | 40.772501245008 | 10F-PM-1019-04 | 10F | PM | 10192018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | Behind fence, grass | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9710951149579 40.772501245008) | 19 | 4 | 19 | 13 | |||||
1193 | 1193 | -73.9731880656287 | 40.7660026186155 | 2H-AM-1006-01 | 02H | AM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9731880656287 40.7660026186155) | 19 | 4 | 19 | 13 | ||||||
1516 | 1516 | -73.9625383795297 | 40.7883862331728 | 28D-AM-1012-03 | 28D | AM | 10122018 | 3 | Adult | Black | Black+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9625383795297 40.7883862331728) | 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 | |||||
1979 | 1979 | -73.9612759291399 | 40.7930468323219 | 33B-AM-1010-03 | 33B | AM | 10102018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9612759291399 40.7930468323219) | 19 | 4 | 19 | 13 | ||||||
2135 | 2135 | -73.9596251284566 | 40.7916254797561 | 33D-AM-1017-05 | 33D | AM | 10172018 | 5 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9596251284566 40.7916254797561) | 19 | 4 | 19 | 13 | ||||||
2192 | 2192 | -73.9593410965431 | 40.7923134010383 | 33D-AM-1017-08 | 33D | AM | 10172018 | 8 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9593410965431 40.7923134010383) | 19 | 4 | 19 | 13 | ||||||
2266 | 2266 | -73.9716402454355 | 40.7665133780672 | 3I-PM-1013-08 | 03I | PM | 10132018 | 8 | Adult | Black | Black+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9716402454355 40.7665133780672) | 19 | 4 | 19 | 13 | ||||||
2351 | 2351 | -73.9745818450109 | 40.7654498873627 | 1G-AM-1006-01 | 01G | AM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9745818450109 40.7654498873627) | 19 | 4 | 19 | 13 | ||||||
2395 | 2395 | -73.9729603550254 | 40.7660215710657 | 3H-AM-1008-06 | 03H | AM | 10082018 | 6 | Adult | Black | Black+ | beauty! | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.9729603550254 40.7660215710657) | 19 | 4 | 19 | 13 | |||||
2427 | 2427 | -73.9729297485331 | 40.7673278541438 | 4H-AM-1006-03 | 04H | AM | 10062018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | met #4 while foraging and briefly tussled | false | false | false | false | false | false | true | false | POINT (-73.9729297485331 40.7673278541438) | 19 | 4 | 19 | 13 | |||||
2572 | 2572 | -73.9719901848577 | 40.7720525965356 | 9F-PM-1014-07 | 09F | PM | 10142018 | 7 | Adult | Black | Black+ | !!! | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9719901848577 40.7720525965356) | 19 | 4 | 19 | 13 | |||||
2638 | 2638 | -73.9598973337711 | 40.7933346360478 | 34C-PM-1012-01 | 34C | PM | 10122018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9598973337711 40.7933346360478) | 19 | 4 | 19 | 13 | |||||
2755 | 2755 | -73.9712022111028 | 40.7672504368263 | 4I-AM-1006-01 | 04I | AM | 10062018 | 1 | Adult | Black | Black+ | Above Ground | 3 | On top of park lamp | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9712022111028 40.7672504368263) | 19 | 4 | 19 | 13 | |||||
2768 | 2768 | -73.9641088172632 | 40.7886555184212 | 28C-AM-1014-01 | 28C | AM | 10142018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9641088172632 40.7886555184212) | 19 | 4 | 19 | 13 | ||||||
2773 | 2773 | -73.9625932664956 | 40.7885379477349 | 29D-AM-1014-01 | 29D | AM | 10142018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9625932664956 40.7885379477349) | 19 | 4 | 19 | 13 | ||||||
2540 | 2540 | -73.959127912788 | 40.7921197130403 | 33E-AM-1014-13 | 33E | AM | 10142018 | 13 | Adult | Black | Cinnamon | Black+Cinnamon | Cinnamon on the tail | Ground Plane | FALSE | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.959127912788 40.7921197130403) | 19 | 4 | 19 | 13 | |||
2731 | 2731 | -73.9595886063173 | 40.7918405182594 | 33D-AM-1017-09 | 33D | AM | 10172018 | 9 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 7 | false | false | true | false | false | true | true | false | false | false | false | true | true | POINT (-73.9595886063173 40.7918405182594) | 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 | |||||
1210 | 1210 | -73.9707937464541 | 40.7725282708448 | 10G-PM-1017-07 | 10G | PM | 10172018 | 7 | Adult | Black | White | Black+White | Ground Plane | FALSE | false | false | false | false | false | traveling | false | false | false | false | false | false | true | false | POINT (-73.9707937464541 40.7725282708448) | 19 | 4 | 19 | 13 | ||||
3 | 3 | -73.9768311751004 | 40.7667178072558 | 2E-AM-1010-03 | 02E | AM | 10102018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9768311751004 40.76671780725581) | 19 | 4 | 19 | 13 | ||||||
217 | 217 | -73.9712327308512 | 40.7748702909218 | 12E-PM-1018-06 | 12E | PM | 10182018 | 6 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9712327308512 40.7748702909218) | 19 | 4 | 19 | 13 | ||||||
255 | 255 | -73.9800669115792 | 40.7676825134384 | 1B-AM-1012-07 | 01B | AM | 10122018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on tree trunk | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9800669115792 40.7676825134384) | 19 | 4 | 19 | 13 | |||||
256 | 256 | -73.976798124308 | 40.7741316574113 | 9A-PM-1010-04 | 09A | PM | 10102018 | 4 | Cinnamon | Cinnamon+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97679812430802 40.7741316574113) | 19 | 4 | 19 | 13 | |||||||
454 | 454 | -73.9752793195744 | 40.7733960128931 | 9C-AM-1006-03 | 09C | AM | 10062018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9752793195744 40.7733960128931) | 19 | 4 | 19 | 13 | ||||||
805 | 805 | -73.9706851546184 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 10172018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on fence | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9706851546184 40.7780777016038) | 19 | 4 | 19 | 13 | |||||
893 | 893 | -73.9799311173259 | 40.7685576997559 | 2B-AM-1010-03 | 02B | AM | 10102018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9799311173259 40.7685576997559) | 19 | 4 | 19 | 13 | ||||||
1199 | 1199 | -73.9756993198381 | 40.7681956641913 | 3E-PM-1008-08 | 03E | PM | 10082018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756993198381 40.7681956641913) | 19 | 4 | 19 | 13 | ||||||
1212 | 1212 | -73.9761792189352 | 40.7745745517215 | 9A-AM-1013-09 | 09A | AM | 10132018 | 9 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9761792189352 40.7745745517215) | 19 | 4 | 19 | 13 | ||||||
1323 | 1323 | -73.9744387347626 | 40.7776953143835 | 13A-AM-1017-03 | 13A | AM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744387347626 40.7776953143835) | 19 | 4 | 19 | 13 | ||||||||
1363 | 1363 | -73.972112497276 | 40.7702759037428 | 7G-AM-1010-08 | 07G | AM | 10102018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.972112497276 40.7702759037428) | 19 | 4 | 19 | 13 | ||||||
1394 | 1394 | -73.95488263914 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 10142018 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2 | up/down tree | true | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.95488263914 40.7959474571251) | 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 | |||||
1640 | 1640 | -73.9564632239432 | 40.7904807427954 | 33G-AM-1013-01 | 33G | AM | 10132018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 13 | shelter in hole in tree | false | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9564632239432 40.7904807427954) | 19 | 4 | 19 | 13 | |||||
2025 | 2025 | -73.9766541879006 | 40.7674077265375 | 2E-AM-1010-06 | 02E | AM | 10102018 | 6 | Adult | Cinnamon | Cinnamon+ | Above Ground | 35 | false | false | false | false | false | leaping branch to branch | false | false | false | false | false | false | true | false | POINT (-73.9766541879006 40.7674077265375) | 19 | 4 | 19 | 13 | |||||
2241 | 2241 | -73.9575258627966 | 40.787715550749 | 30H-AM-1007-03 | 30H | AM | 10072018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9575258627966 40.787715550749) | 19 | 4 | 19 | 13 | ||||||
2401 | 2401 | -73.972010921173 | 40.7701626919216 | 7G-AM-1010-09 | 07G | AM | 10102018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.972010921173 40.7701626919216) | 19 | 4 | 19 | 13 | ||||||
2411 | 2411 | -73.9686907918759 | 40.7839462261858 | 22B-AM-1013-03 | 22B | AM | 10132018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686907918759 40.7839462261858) | 19 | 4 | 19 | 13 | ||||||
2492 | 2492 | -73.9801619956135 | 40.7678576697542 | 1B-AM-1012-09 | 01B | AM | 10122018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9801619956135 40.7678576697542) | 19 | 4 | 19 | 13 | ||||||
2505 | 2505 | -73.9762974698771 | 40.7740076116964 | 9B-PM-1013-06 | 09B | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9762974698771 40.7740076116964) | 19 | 4 | 19 | 13 | ||||||
2601 | 2601 | -73.979636950073 | 40.7677999753976 | 1C-PM-1013-10 | 01C | PM | 10132018 | 10 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.979636950073 40.7677999753976) | 19 | 4 | 19 | 13 | ||||||
2612 | 2612 | -73.9711673006524 | 40.7747979614577 | 12E-PM-1018-05 | 12E | PM | 10182018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9711673006524 40.7747979614577) | 19 | 4 | 19 | 13 | ||||||
2753 | 2753 | -73.9681090824978 | 40.7838275830328 | 22B-PM-1014-04 | 22B | PM | 10142018 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9681090824978 40.7838275830328) | 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 | ||||||
358 | 358 | -73.9635658786416 | 40.7777291777901 | 18I-AM-1017-03 | 18I | AM | 10172018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9635658786416 40.77772917779011) | 19 | 4 | 19 | 13 | |||||
620 | 620 | -73.9655905300923 | 40.7752614638023 | 14I-PM-1018-06 | 14I | PM | 10182018 | 6 | Adult | Cinnamon | Black | Cinnamon+Black | Above Ground | 2 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9655905300923 40.7752614638023) | 19 | 4 | 19 | 13 | |||||
1843 | 1843 | -73.9685940262068 | 40.776932102013 | 15F-AM-1007-07 | 15F | AM | 10072018 | 7 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9685940262068 40.776932102013) | 19 | 4 | 19 | 13 | |||||
2291 | 2291 | -73.9756894776708 | 40.7681638218212 | 4E-AM-1020-03 | 04E | AM | 10202018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756894776708 40.7681638218212) | 19 | 4 | 19 | 13 | |||||
2367 | 2367 | -73.9681671864047 | 40.7753770538635 | 14G-AM-1012-04 | 14G | AM | 10122018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9681671864047 40.7753770538635) | 19 | 4 | 19 | 13 | |||||
1198 | 1198 | -73.9762187733662 | 40.7739282973004 | 9B-PM-1013-08 | 09B | PM | 10132018 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9762187733662 40.7739282973004) | 19 | 4 | 19 | 13 | |||||
2761 | 2761 | -73.9689204258063 | 40.7712540588951 | 9I-AM-1014-01 | 09I | AM | 10142018 | 1 | Adult | Cinnamon | Black, White | Cinnamon+Black, White | Black on body, White Belly, White tail | Ground Plane | FALSE | false | false | false | false | true | digging deeeep | false | false | false | false | false | false | true | false | POINT (-73.9689204258063 40.7712540588951) | 19 | 4 | 19 | 13 | |||
67 | 67 | -73.968381325559 | 40.7780143443779 | 16E-PM-1018-06 | 16E | PM | 10182018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | On a rock | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.968381325559 40.7780143443779) | 19 | 4 | 19 | 13 | ||||
166 | 166 | -73.963846339804 | 40.7834051716226 | 23F-AM-1018-01 | 23F | AM | 10182018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.963846339804 40.7834051716226) | 19 | 4 | 19 | 13 | |||||
261 | 261 | -73.9552861155228 | 40.788973931872 | 32I-AM-1013-05 | 32I | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552861155228 40.788973931872) | 19 | 4 | 19 | 13 | ||||
263 | 263 | -73.9771069181511 | 40.7670538214988 | 2E-PM-1014-05 | 02E | PM | 10142018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9771069181511 40.7670538214988) | 19 | 4 | 19 | 13 | |||||
305 | 305 | -73.9750283794865 | 40.7724101927821 | 8C-PM-1013-08 | 08C | PM | 10132018 | 8 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9750283794865 40.7724101927821) | 19 | 4 | 19 | 13 | ||||||
377 | 377 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 10082018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | went up tree | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
392 | 392 | -73.9802376131034 | 40.7680707516627 | 1B-AM-1012-12 | 01B | AM | 10122018 | 12 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9802376131034 40.7680707516627) | 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 | |||||
432 | 432 | -73.9757787135906 | 40.7737231427345 | 9B-PM-1013-03 | 09B | PM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9757787135906 40.7737231427345) | 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 | |||||
557 | 557 | -73.9792153893146 | 40.7688272492961 | 3B-AM-1010-01 | 03B | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9792153893146 40.7688272492961) | 19 | 4 | 19 | 13 | |||||
685 | 685 | -73.9658181813014 | 40.7798160637561 | 19F-AM-1007-01 | 19F | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | bit scared | POINT (-73.9658181813014 40.7798160637561) | 19 | 4 | 19 | 13 | ||||
687 | 687 | -73.9636971843665 | 40.7825638537362 | 22F-AM-1007-04 | 22F | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9636971843665 40.7825638537362) | 19 | 4 | 19 | 13 | |||||||
695 | 695 | -73.9685080639873 | 40.7745309794155 | 13G-PM-1008-03 | 13G | PM | 10082018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | maple tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9685080639873 40.77453097941551) | 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 | |||||
748 | 748 | -73.9756603846107 | 40.7672531319384 | 3F-PM-1013-03 | 03F | PM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9756603846107 40.7672531319384) | 19 | 4 | 19 | 13 | |||||
788 | 788 | -73.9687476703117 | 40.7742856696093 | 12G-AM-1012-01 | 12G | AM | 10122018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687476703117 40.7742856696093) | 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 | |||||
937 | 937 | -73.9706323458769 | 40.7713196034265 | 9G-PM-1007-03 | 09G | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9706323458769 40.771319603426505) | 19 | 4 | 19 | 13 | |||||
971 | 971 | -73.978392591149 | 40.7668993398193 | 1D-PM-1007-04 | 01D | PM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.978392591149 40.7668993398193) | 19 | 4 | 19 | 13 | |||||
1017 | 1017 | -73.9552035011902 | 40.7889851896334 | 32I-AM-1013-06 | 32I | AM | 10132018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552035011902 40.7889851896334) | 19 | 4 | 19 | 13 | ||||
1034 | 1034 | -73.9553163829551 | 40.7988610926249 | 42D-PM-1013-04 | 42D | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Light Cinnamon | Ground Plane | FALSE | false | false | false | false | false | carrying nut away | false | false | false | false | false | false | true | false | POINT (-73.9553163829551 40.7988610926249) | 19 | 4 | 19 | 13 | |||
1056 | 1056 | -73.9811078442462 | 40.767515940567 | 1A-AM-1007-04 | 01A | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9811078442462 40.767515940567) | 12081 | 11 | 4 | 51 | 10 | ||||
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 | ||
1145 | 1145 | -73.9611446263364 | 40.7911003407299 | 32D-AM-1013-03 | 32D | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611446263364 40.7911003407299) | 19 | 4 | 19 | 13 | |||||
1253 | 1253 | -73.9527227282134 | 40.7935061484064 | 37I-AM-1010-03 | 37I | AM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527227282134 40.7935061484064) | 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 );