This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
455 | 455 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 10192018 | 4 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9688574691102 40.7837825208444) | 19 | 4 | 19 | 13 | ||||||||||
861 | 861 | -73.953287300494 | 40.793520326789 | 37H-PM-1006-04 | 37H | PM | 10062018 | 4 | + | Above Ground | 43 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.953287300494 40.793520326789) | 19 | 4 | 19 | 13 | |||||||
1475 | 1475 | -73.9686778167484 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 10122018 | 4 | + | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.96867781674841 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
1623 | 1623 | -73.9770119133023 | 40.7732949090005 | 8A-AM-1013-04 | 08A | AM | 10132018 | 4 | Juvenile | + | Above Ground | 4 | fence | true | true | false | true | true | playing tag together | false | false | false | false | false | true | false | false | POINT (-73.9770119133023 40.7732949090005) | 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 | |||||||
2744 | 2744 | -73.9752915601718 | 40.7739329570033 | 9B-AM-1010-04 | 09B | AM | 10102018 | 4 | + | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9752915601718 40.7739329570033) | 19 | 4 | 19 | 13 | ||||||||
2754 | 2754 | -73.9687025912431 | 40.7719319822619 | 10H-AM-1014-04 | 10H | AM | 10142018 | 4 | Juvenile | + | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9687025912431 40.7719319822619) | 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 | ||||||
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 | |||||
497 | 497 | -73.9602166876979 | 40.7953811003986 | 36B-AM-1013-04 | 36B | AM | 10132018 | 4 | Black | Black+ | Above Ground | 20 | Moved 20+ feet high above top of tree limb | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9602166876979 40.7953811003986) | 19 | 4 | 19 | 13 | ||||||
731 | 731 | -73.9733545802515 | 40.7675056025357 | 4G-AM-1006-04 | 04G | AM | 10062018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9733545802515 40.7675056025357) | 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 | |||||
2113 | 2113 | -73.9582904814652 | 40.7905915749564 | 32F-AM-1012-04 | 32F | AM | 10122018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9582904814652 40.7905915749564) | 19 | 4 | 19 | 13 | ||||||
2270 | 2270 | -73.9703732649257 | 40.7701979377103 | 8H-PM-1014-04 | 08H | PM | 10142018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.97037326492571 40.7701979377103) | 19 | 4 | 19 | 13 | ||||||
2322 | 2322 | -73.9723677854798 | 40.7667315410871 | 3H-AM-1008-04 | 03H | AM | 10082018 | 4 | Adult | Black | Black+ | Above Ground | 50 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9723677854798 40.7667315410871) | 19 | 4 | 19 | 13 | ||||||
2329 | 2329 | -73.9717515173863 | 40.7747999274418 | 11D-PM-1006-04 | 11D | PM | 10062018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9717515173863 40.7747999274418) | 19 | 4 | 19 | 13 | ||||||
2449 | 2449 | -73.9599911537509 | 40.7914452542845 | 33D-AM-1017-04 | 33D | AM | 10172018 | 4 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9599911537509 40.7914452542845) | 19 | 4 | 19 | 13 | ||||||
2909 | 2909 | -73.9564478909357 | 40.7976928775417 | 40C-PM-1006-04 | 40C | PM | 10062018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9564478909357 40.7976928775417) | 19 | 4 | 19 | 13 | ||||||
2325 | 2325 | -73.9728360875598 | 40.7660637295671 | 3H-PM-1014-04 | 03H | PM | 10142018 | 4 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9728360875598 40.7660637295671) | 19 | 4 | 19 | 13 | |||||
1223 | 1223 | -73.9591298551111 | 40.7919612446005 | 33E-AM-1014-04 | 33E | AM | 10142018 | 4 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9591298551111 40.7919612446005) | 19 | 4 | 19 | 13 | |||||
1296 | 1296 | -73.9705509170542 | 40.7689416540228 | 6I-PM-1013-04 | 06I | PM | 10132018 | 4 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Grass | false | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.9705509170542 40.7689416540228) | 19 | 4 | 19 | 13 | ||||
88 | 88 | -73.9683608295976 | 40.7842927405327 | 22B-AM-1013-04 | 22B | AM | 10132018 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Under bench | false | false | false | false | true | false | false | false | false | false | false | false | true | ran from dog-walker | POINT (-73.9683608295976 40.7842927405327) | 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 | |||||||
509 | 509 | -73.9714289592392 | 40.7750670702093 | 12E-PM-1018-04 | 12E | PM | 10182018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9714289592392 40.7750670702093) | 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 | |||||
1294 | 1294 | -73.9604089940153 | 40.7910028063138 | 32D-AM-1013-04 | 32D | AM | 10132018 | 4 | Adult | Cinnamon | Cinnamon+ | Brown legs | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | true | false | true | POINT (-73.9604089940153 40.7910028063138) | 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 | ||||||
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 | |||||
2560 | 2560 | -73.9755459090534 | 40.7680866624003 | 4E-AM-1020-04 | 04E | AM | 10202018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | false | chillin' | false | false | false | false | false | false | false | true | POINT (-73.9755459090534 40.7680866624003) | 19 | 4 | 19 | 13 | ||||
493 | 493 | -73.9776854797916 | 40.7683102295663 | 3D-AM-1006-04 | 03D | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (boy on bike) | POINT (-73.9776854797916 40.7683102295663) | 19 | 4 | 19 | 13 | ||||
604 | 604 | -73.9540908513075 | 40.794201225045 | 37G-PM-1007-04 | 37G | PM | 10072018 | 4 | Cinnamon | Gray | Cinnamon+Gray | gray tail | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540908513075 40.794201225045) | 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 | |||||||
960 | 960 | -73.9623922773932 | 40.7814944428327 | 22H-PM-1007-04 | 22H | PM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9623922773932 40.7814944428327) | 19 | 4 | 19 | 13 | |||||
968 | 968 | -73.9689781843873 | 40.7709333833783 | 9I-PM-1010-04 | 09I | PM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9689781843873 40.7709333833783) | 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 | |||||
1003 | 1003 | -73.9645547556826 | 40.776877007081 | 16I-AM-1008-04 | 16I | AM | 10082018 | 4 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | tree hollow | false | false | false | false | false | in hollow | false | false | false | false | false | false | false | false | curious | POINT (-73.9645547556826 40.776877007081) | 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 | ||||
1088 | 1088 | -73.9770985425092 | 40.7665926744505 | 1E-AM-1006-04 | 01E | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9770985425092 40.7665926744505) | 19 | 4 | 19 | 13 | |||||
1416 | 1416 | -73.9757313481982 | 40.7754704051391 | 11A-PM-1013-04 | 11A | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9757313481982 40.7754704051391) | 19 | 4 | 19 | 13 | |||||
1457 | 1457 | -73.9697744662785 | 40.7755950428973 | 13F-AM-1007-04 | 13F | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9697744662785 40.7755950428973) | 19 | 4 | 19 | 13 | |||||
1492 | 1492 | -73.9807078515193 | 40.7683335292642 | 2A-AM-1010-04 | 02A | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9807078515193 40.7683335292642) | 19 | 4 | 19 | 13 | |||||
1636 | 1636 | -73.9701408623121 | 40.7695511718541 | 7I-PM-1013-04 | 07I | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | Grass | true | false | false | true | false | false | false | false | true | false | false | false | false | POINT (-73.9701408623121 40.7695511718541) | 19 | 4 | 19 | 13 | ||||
1725 | 1725 | -73.9657480066074 | 40.7753465489231 | 14I-PM-1018-04 | 14I | PM | 10182018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | true | false | false | POINT (-73.9657480066074 40.7753465489231) | 19 | 4 | 19 | 13 | |||||
2001 | 2001 | -73.9521655419974 | 40.7948785497717 | 39H-AM-1007-04 | 39H | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9521655419974 40.7948785497717) | 19 | 4 | 19 | 13 | |||||
2060 | 2060 | -73.9575798004084 | 40.795701403549 | 38D-PM-1006-04 | 38D | PM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | near drive -runners -cyclists | POINT (-73.95757980040841 40.795701403549) | 19 | 4 | 19 | 13 | ||||
2156 | 2156 | -73.9650387848001 | 40.7814134438394 | 21F-AM-1018-04 | 21F | AM | 10182018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9650387848001 40.7814134438394) | 19 | 4 | 19 | 13 | |||||
2218 | 2218 | -73.9694382427984 | 40.7846350692923 | 22A-AM-1008-04 | 22A | AM | 10082018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9694382427984 40.7846350692923) | 19 | 4 | 19 | 13 | |||||
2309 | 2309 | -73.966824257293 | 40.7753405377869 | 14H-PM-1012-04 | 14H | PM | 10122018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.966824257293 40.7753405377869) | 19 | 4 | 19 | 13 | |||||
2404 | 2404 | -73.9665309689616 | 40.7775271020244 | 16G-AM-1010-04 | 16G | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9665309689616 40.7775271020244) | 19 | 4 | 19 | 13 | |||||
2461 | 2461 | -73.9605347462123 | 40.7942075448387 | 35B-AM-1010-04 | 35B | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | lawn | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9605347462123 40.7942075448387) | 19 | 4 | 19 | 13 | ||||
2514 | 2514 | -73.95744422055 | 40.7961046528557 | 38D-AM-1017-04 | 38D | AM | 10172018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.95744422055 40.7961046528557) | 19 | 4 | 19 | 13 | |||||
2521 | 2521 | -73.976869549792 | 40.7706982454723 | 5C-AM-1006-04 | 05C | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 12 | thin branch of tree | false | false | false | false | false | relaxing | false | false | false | true | false | false | true | false | POINT (-73.976869549792 40.7706982454723) | 19 | 4 | 19 | 13 | |||
2752 | 2752 | -73.972069937746 | 40.7659402627832 | 3I-PM-1013-04 | 03I | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.97206993774601 40.7659402627832) | 19 | 4 | 19 | 13 | |||||
2878 | 2878 | -73.969720780557 | 40.7741105688757 | 12F-AM-1020-04 | 12F | AM | 10202018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.969720780557 40.7741105688757) | 19 | 4 | 19 | 13 | |||||
2971 | 2971 | -73.9639801411692 | 40.7778921302618 | 18I-PM-1007-04 | 18I | PM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | false | walking sitting up | false | false | false | false | false | false | false | true | POINT (-73.9639801411692 40.7778921302618) | 19 | 4 | 19 | 13 | ||||
233 | 233 | -73.9568343093228 | 40.7949401350882 | 37E-PM-1006-04 | 37E | PM | 10062018 | 4 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | doesn't see me | POINT (-73.9568343093228 40.7949401350882) | 19 | 4 | 19 | 13 | ||||
2895 | 2895 | -73.9747873899653 | 40.7731945258327 | 9C-PM-1006-04 | 09C | PM | 10062018 | 4 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9747873899653 40.7731945258327) | 19 | 4 | 19 | 13 | |||||
2952 | 2952 | -73.9763719445827 | 40.7689551413337 | 4D-PM-1008-04 | 04D | PM | 10082018 | 4 | 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.9763719445827 40.7689551413337) | 19 | 4 | 19 | 13 | |||||
349 | 349 | -73.9689657039917 | 40.7767834276767 | 15F-AM-1007-04 | 15F | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9689657039917 40.7767834276767) | 19 | 4 | 19 | 13 | |||||
375 | 375 | -73.9752000129992 | 40.7732918122239 | 8C-PM-1013-04 | 08C | PM | 10132018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9752000129992 40.7732918122239) | 19 | 4 | 19 | 13 | |||||
490 | 490 | -73.978426472499 | 40.771904101844 | 6A-PM-1012-04 | 06A | PM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.978426472499 40.771904101844) | 19 | 4 | 19 | 13 | |||||
667 | 667 | -73.9624538733037 | 40.7883829851518 | 28D-AM-1012-04 | 28D | AM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9624538733037 40.7883829851518) | 19 | 4 | 19 | 13 | |||||
897 | 897 | -73.9734687538064 | 40.7694308959222 | 6F-PM-1008-04 | 06F | PM | 10082018 | 4 | Adult | Cinnamon | White | Cinnamon+White | patches of white on haunches | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9734687538064 40.7694308959222) | 19 | 4 | 19 | 13 | ||||
1146 | 1146 | -73.9794367096274 | 40.7672720598482 | 1C-PM-1013-04 | 01C | PM | 10132018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9794367096274 40.7672720598482) | 19 | 4 | 19 | 13 | |||||
1177 | 1177 | -73.9807898224726 | 40.768215817511 | 1A-PM-1014-04 | 01A | PM | 10142018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9807898224726 40.768215817511) | 19 | 4 | 19 | 13 | |||||
1246 | 1246 | -73.9543044385367 | 40.7984498571338 | 41E-AM-1007-04 | 41E | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white haunches/tail | Ground Plane | FALSE | rubbing belly on ground | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9543044385367 40.798449857133804) | 19 | 4 | 19 | 13 | |||
1282 | 1282 | -73.974451175321 | 40.7701294635264 | 6E-PM-1010-04 | 06E | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | false | true | false | true | false | chasing #3 | false | false | false | false | false | false | true | false | POINT (-73.974451175321 40.7701294635264) | 19 | 4 | 19 | 13 | ||
1617 | 1617 | -73.9752029513644 | 40.7671734667361 | 3F-AM-1006-04 | 03F | AM | 10062018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on a rock | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9752029513644 40.7671734667361) | 19 | 4 | 19 | 13 | ||||
1961 | 1961 | -73.953664715831 | 40.7981256393159 | 41E-PM-1013-04 | 41E | PM | 10132018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.953664715831 40.7981256393159) | 19 | 4 | 19 | 13 | |||||
2478 | 2478 | -73.9674931070324 | 40.7783693690954 | 17F-AM-1007-04 | 17F | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 4 | false | false | false | true | false | chilling | true | false | false | false | false | false | true | false | POINT (-73.9674931070324 40.7783693690954) | 19 | 4 | 19 | 13 | ||||
2587 | 2587 | -73.9789971286844 | 40.7707024146365 | 5A-PM-1010-04 | 05A | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9789971286844 40.7707024146365) | 19 | 4 | 19 | 13 | |||||
2745 | 2745 | -73.97296259363 | 40.7652601851275 | 1I-PM-1012-04 | 01I | PM | 10122018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 2 | on ledge | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.97296259363 40.7652601851275) | 19 | 4 | 19 | 13 | |||
2779 | 2779 | -73.9767835160078 | 40.7674030330482 | 2E-PM-1014-04 | 02E | PM | 10142018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9767835160078 40.7674030330482) | 19 | 4 | 19 | 13 | |||||
96 | 96 | -73.9708549670788 | 40.7699587019058 | 7H-PM-1006-04 | 07H | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 12 | on tree knob | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9708549670788 40.7699587019058) | 19 | 4 | 19 | 13 | ||||
100 | 100 | -73.9761592532482 | 40.7747213585387 | 10A-AM-1006-04 | 10A | AM | 10062018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 10 | tree near large rock on Bridle Path | false | false | false | false | false | walking on branch | false | false | false | false | true | false | false | false | POINT (-73.9761592532482 40.7747213585387) | 19 | 4 | 19 | 13 | ||||
108 | 108 | -73.9574809028248 | 40.7950013620207 | 37D-PM-1014-04 | 37D | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | chasing (a chipmunk) | false | false | false | false | false | false | false | true | POINT (-73.9574809028248 40.7950013620207) | 19 | 4 | 19 | 13 | |||||
175 | 175 | -73.9720065066618 | 40.7764043782924 | 13C-AM-1010-04 | 13C | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9720065066618 40.7764043782924) | 19 | 4 | 19 | 13 | ||||||
178 | 178 | -73.9613780522542 | 40.790786197111 | 31D-PM-1006-04 | 31D | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9613780522542 40.790786197111) | 19 | 4 | 19 | 13 | ||||||
218 | 218 | -73.9712318712643 | 40.7773053099657 | 14D-PM-1019-04 | 14D | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9712318712643 40.7773053099657) | 19 | 4 | 19 | 13 | ||||||
229 | 229 | -73.972416242971 | 40.7714260236636 | 8F-PM-1012-04 | 08F | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.972416242971 40.7714260236636) | 19 | 4 | 19 | 13 | ||||||
245 | 245 | -73.9589414339242 | 40.7907073888277 | 32E-PM-1017-04 | 32E | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9589414339242 40.7907073888277) | 19 | 4 | 19 | 13 | |||||
273 | 273 | -73.9579218587172 | 40.7960605028848 | 38C-AM-1019-04 | 38C | AM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | true | true | false | false | false | false | true | false | POINT (-73.9579218587172 40.79606050288481) | 19 | 4 | 19 | 13 | ||||||
336 | 336 | -73.9757413215621 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757413215621 40.7692582758978) | 19 | 4 | 19 | 13 | ||||||
427 | 427 | -73.9589367709165 | 40.7896465303483 | 31F-PM-1007-04 | 31F | PM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9589367709165 40.7896465303483) | 19 | 4 | 19 | 13 | ||||||
459 | 459 | -73.9624546917649 | 40.7888234959792 | 29D-AM-1014-04 | 29D | AM | 10142018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | Rock a | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9624546917649 40.78882349597921) | 19 | 4 | 19 | 13 | |||||
511 | 511 | -73.9653142636891 | 40.7760015129298 | 15I-AM-1008-04 | 15I | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653142636891 40.7760015129298) | 19 | 4 | 19 | 13 | ||||||
539 | 539 | -73.9761440627966 | 40.7706035301542 | 6D-PM-1020-04 | 06D | PM | 10202018 | 4 | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9761440627966 40.7706035301542) | 19 | 4 | 19 | 13 | |||||||
584 | 584 | -73.9720553753548 | 40.7664488175384 | 3I-AM-1010-04 | 03I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9720553753548 40.7664488175384) | 19 | 4 | 19 | 13 | ||||||
585 | 585 | -73.9700148248402 | 40.7787780193358 | 16D-PM-1010-04 | 16D | PM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9700148248402 40.7787780193358) | 19 | 4 | 19 | 13 | ||||||
618 | 618 | -73.957976896139 | 40.797027128241 | 39C-AM-1017-04 | 39C | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.957976896139 40.797027128241005) | 19 | 4 | 19 | 13 | ||||||
709 | 709 | -73.9519387881692 | 40.7936273636929 | 38I-PM-1014-04 | 38I | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9519387881692 40.7936273636929) | 19 | 4 | 19 | 13 | ||||||
753 | 753 | -73.9729378674198 | 40.7672407594559 | 4H-AM-1006-04 | 04H | AM | 10062018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | met #3 while foraging and briefly tussled | false | false | false | false | false | false | true | false | POINT (-73.9729378674198 40.7672407594559) | 19 | 4 | 19 | 13 | |||||
824 | 824 | -73.9606344681252 | 40.7958337780644 | 37B-PM-1013-04 | 37B | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9606344681252 40.795833778064406) | 19 | 4 | 19 | 13 | ||||||
849 | 849 | -73.9736165917399 | 40.7724543901497 | 8D-AM-1007-04 | 08D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | chasing squirrel #3 | false | false | false | false | false | false | false | false | POINT (-73.9736165917399 40.7724543901497) | 19 | 4 | 19 | 13 | |||||
873 | 873 | -73.9770948563006 | 40.7724063459185 | 7B-AM-1008-04 | 07B | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9770948563006 40.7724063459185) | 19 | 4 | 19 | 13 | ||||||
886 | 886 | -73.9696517826558 | 40.7769658302844 | 14E-AM-1008-04 | 14E | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9696517826558 40.7769658302844) | 19 | 4 | 19 | 13 | ||||||
889 | 889 | -73.9681042612938 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9681042612938 40.772331431865) | 19 | 4 | 19 | 13 | ||||||
903 | 903 | -73.9719941577406 | 40.77037129313 | 7G-AM-1010-04 | 07G | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9719941577406 40.77037129313) | 19 | 4 | 19 | 13 | ||||||
904 | 904 | -73.9531013359625 | 40.7921223556535 | 36I-PM-1007-04 | 36I | PM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9531013359625 40.7921223556535) | 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 );