This data as json, CSV (advanced)
Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Location, Above Ground Sighter Measurement, Specific Location, Kuks, Quaas, Approaches, Indifferent, Runs from, Other Interactions
Combination of Primary and Highlight Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8 | 8 | -73.9602609920814 | 40.7942883045566 | 35C-PM-1013-03 | 35C | PM | 10132018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9602609920814 40.79428830455661) | 19 | 4 | 19 | 13 | ||||||
17 | 17 | -73.9695063535333 | 40.7823507678183 | 20B-PM-1013-05 | 20B | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9695063535333 40.7823507678183) | 19 | 4 | 19 | 13 | |||||
29 | 29 | -73.9671786715256 | 40.7867352791232 | 25A-AM-1013-04 | 25A | AM | 10132018 | 4 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9671786715256 40.7867352791232) | 19 | 4 | 19 | 13 | ||||||
30 | 30 | -73.9692943291611 | 40.7769536102488 | 15E-AM-1013-01 | 15E | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9692943291611 40.7769536102488) | 19 | 4 | 19 | 13 | |||||
69 | 69 | -73.9689000978955 | 40.7828364735236 | 20B-PM-1013-10 | 20B | PM | 10132018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | drank from a pond of rain water | false | false | false | false | false | false | true | false | POINT (-73.9689000978955 40.7828364735236) | 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 | ||||
101 | 101 | -73.9544007658685 | 40.7950689723135 | 38F-PM-1013-05 | 38F | PM | 10132018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | being chased,was pushed by other squirrel | true | true | false | false | false | false | false | false | POINT (-73.9544007658685 40.7950689723135) | 19 | 4 | 19 | 13 | ||||
135 | 135 | -73.9694168118643 | 40.7728877377977 | 11G-PM-1013-01 | 11G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | In the Woods/Brush | false | false | true | false | true | false | false | false | false | false | false | false | true | watching me | POINT (-73.9694168118643 40.7728877377977) | 19 | 4 | 19 | 13 | |||
141 | 141 | -73.9590992841423 | 40.793758098573 | 35D-PM-1013-09 | 35D | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9590992841423 40.793758098573) | 19 | 4 | 19 | 13 | |||||
143 | 143 | -73.9661361310677 | 40.7787872561177 | 18G-PM-1013-01 | 18G | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | burying | false | false | false | false | false | false | false | true | POINT (-73.9661361310677 40.7787872561177) | 19 | 4 | 19 | 13 | ||||
145 | 145 | -73.971970670614 | 40.7720868124544 | 9F-AM-1013-04 | 09F | AM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.971970670614 40.7720868124544) | 19 | 4 | 19 | 13 | |||||
149 | 149 | -73.9576349321357 | 40.7904409912437 | 32G-PM-1013-03 | 32G | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon belly | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9576349321357 40.7904409912437) | 19 | 4 | 19 | 13 | ||||
155 | 155 | -73.9522142360388 | 40.7949598486683 | 39H-PM-1013-02 | 39H | PM | 10132018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9522142360388 40.7949598486683) | 19 | 4 | 19 | 13 | |||||
195 | 195 | -73.9737773613311 | 40.7673662611015 | 3G-PM-1013-01 | 03G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9737773613311 40.7673662611015) | 19 | 4 | 19 | 13 | |||||
204 | 204 | -73.9679538163341 | 40.7837103696906 | 22C-AM-1013-03 | 22C | AM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | eating (mushroom) | false | false | false | false | false | false | false | true | POINT (-73.9679538163341 40.7837103696906) | 19 | 4 | 19 | 13 | ||||
228 | 228 | -73.9728660779622 | 40.7753294525644 | 12C-AM-1013-03 | 12C | AM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | burying | false | false | false | false | false | false | true | false | POINT (-73.9728660779622 40.7753294525644) | 19 | 4 | 19 | 13 | |||||
238 | 238 | -73.9760942252437 | 40.7742035674209 | 9B-PM-1013-07 | 09B | PM | 10132018 | 7 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.97609422524371 40.7742035674209) | 19 | 4 | 19 | 13 | |||||
239 | 239 | -73.9758464905133 | 40.7725957408841 | 8C-PM-1013-05 | 08C | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9758464905133 40.7725957408841) | 19 | 4 | 19 | 13 | |||||
252 | 252 | -73.974420668782 | 40.7749628597465 | 10C-PM-1013-04 | 10C | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.974420668782 40.7749628597465) | 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 | ||||
275 | 275 | -73.974467903723 | 40.7686520352868 | 4F-PM-1013-04 | 04F | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.974467903723 40.7686520352868) | 19 | 4 | 19 | 13 | |||||
280 | 280 | -73.9587401274261 | 40.7960322222949 | 37C-PM-1013-03 | 37C | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9587401274261 40.7960322222949) | 19 | 4 | 19 | 13 | |||||||
292 | 292 | -73.9674069524601 | 40.7772529662424 | 16F-PM-1013-02 | 16F | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Woods | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9674069524601 40.7772529662424) | 19 | 4 | 19 | 13 | ||||
301 | 301 | -73.9717425494287 | 40.7664227676653 | 3I-PM-1013-07 | 03I | PM | 10132018 | 7 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9717425494287 40.7664227676653) | 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 | ||||||
308 | 308 | -73.9554095823557 | 40.7887305802044 | 32I-AM-1013-01 | 32I | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9554095823557 40.7887305802044) | 19 | 4 | 19 | 13 | |||||
323 | 323 | -73.9573469787503 | 40.7944044592573 | 36E-AM-1013-03 | 36E | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | indifferent (moving very fast) | POINT (-73.9573469787503 40.7944044592573) | 19 | 4 | 19 | 13 | ||||
327 | 327 | -73.9534306291679 | 40.7959052073753 | 39G-PM-1013-07 | 39G | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9534306291679 40.7959052073753) | 19 | 4 | 19 | 13 | |||||
346 | 346 | -73.9712971568288 | 40.7745520717065 | 11E-AM-1013-02 | 11E | AM | 10132018 | 2 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9712971568288 40.7745520717065) | 19 | 4 | 19 | 13 | |||||
353 | 353 | -73.9740007759509 | 40.7650077086539 | 1H-PM-1013-01 | 01H | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9740007759509 40.7650077086539) | 19 | 4 | 19 | 13 | ||||||
384 | 384 | -73.968045072743 | 40.7836626717225 | 22C-AM-1013-02 | 22C | AM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | false | false | true | false | true | true | false | false | true | false | false | false | true | POINT (-73.968045072743 40.7836626717225) | 19 | 4 | 19 | 13 | |||||
400 | 400 | -73.9590502257662 | 40.794290363687 | 36C-PM-1013-06 | 36C | PM | 10132018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | Running across wide street | true | false | false | false | true | carrying food in mouth | false | false | false | false | false | false | false | false | POINT (-73.9590502257662 40.794290363687) | 19 | 4 | 19 | 13 | ||||
403 | 403 | -73.9597470659927 | 40.7973215935416 | 38A-PM-1013-01 | 38A | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9597470659927 40.7973215935416) | 19 | 4 | 19 | 13 | |||||
412 | 412 | -73.9785675798034 | 40.7672992405289 | 1C-PM-1013-05 | 01C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9785675798034 40.7672992405289) | 19 | 4 | 19 | 13 | ||||||
422 | 422 | -73.9694630409125 | 40.769737659647 | 8I-PM-1013-01 | 08I | PM | 10132018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9694630409125 40.769737659647) | 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 | |||||
474 | 474 | -73.9540652304705 | 40.7955226178199 | 39G-PM-1013-05 | 39G | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540652304705 40.7955226178199) | 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 | |||||
516 | 516 | -73.9597418366664 | 40.7964417084985 | 37B-PM-1013-05 | 37B | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9597418366664 40.7964417084985) | 19 | 4 | 19 | 13 | |||||
519 | 519 | -73.9659010238417 | 40.7791683666215 | 18G-PM-1013-02 | 18G | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9659010238417 40.779168366621505) | 19 | 4 | 19 | 13 | ||||||
523 | 523 | -73.9793103340869 | 40.7678201535968 | 1C-PM-1013-06 | 01C | PM | 10132018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9793103340869 40.76782015359681) | 19 | 4 | 19 | 13 | |||||
595 | 595 | -73.9742804552383 | 40.7707167671865 | 7E-PM-1013-05 | 07E | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | On rocks | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9742804552383 40.7707167671865) | 19 | 4 | 19 | 13 | ||||
636 | 636 | -73.9757536187319 | 40.7755119810678 | 11A-PM-1013-03 | 11A | PM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9757536187319 40.7755119810678) | 19 | 4 | 19 | 13 | |||||
653 | 653 | -73.9703401385684 | 40.7795238784266 | 17C-PM-1013-01 | 17C | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | then perched on 2-ft high border fencing | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9703401385684 40.7795238784266) | 19 | 4 | 19 | 13 | |||||
662 | 662 | -73.9721854790038 | 40.7761086352438 | 12C-AM-1013-01 | 12C | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | burying | false | false | false | false | false | false | true | false | POINT (-73.9721854790038 40.7761086352438) | 19 | 4 | 19 | 13 | |||||
681 | 681 | -73.9552880892701 | 40.7889040503316 | 32I-AM-1013-04 | 32I | AM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552880892701 40.7889040503316) | 19 | 4 | 19 | 13 | |||||
688 | 688 | -73.9580785600617 | 40.7957981310897 | 37C-PM-1013-01 | 37C | PM | 10132018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9580785600617 40.7957981310897) | 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 | |||||
779 | 779 | -73.9745305540008 | 40.7742043234014 | 10C-PM-1013-02 | 10C | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | true | POINT (-73.9745305540008 40.7742043234014) | 19 | 4 | 19 | 13 | |||||
803 | 803 | -73.9697983725608 | 40.7700677022205 | 8I-PM-1013-09 | 08I | PM | 10132018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9697983725608 40.7700677022205) | 19 | 4 | 19 | 13 | |||||
809 | 809 | -73.9633250636501 | 40.7922155082679 | 32A-PM-1013-09 | 32A | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9633250636501 40.7922155082679) | 19 | 4 | 19 | 13 | |||||
815 | 815 | -73.9753283783695 | 40.7733043910649 | 8C-PM-1013-02 | 08C | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9753283783695 40.7733043910649) | 19 | 4 | 19 | 13 | |||||
839 | 839 | -73.9615602805554 | 40.7945662185621 | 35A-PM-1013-08 | 35A | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9615602805554 40.7945662185621) | 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 | ||||||
868 | 868 | -73.9738481771673 | 40.7706540698938 | 7E-PM-1013-04 | 07E | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9738481771673 40.7706540698938) | 19 | 4 | 19 | 13 | |||||
874 | 874 | -73.9591957793992 | 40.7949568873453 | 36C-PM-1013-01 | 36C | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | false | true | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9591957793992 40.7949568873453) | 19 | 4 | 19 | 13 | |||||
887 | 887 | -73.9635028497015 | 40.7928207574906 | 32A-PM-1013-05 | 32A | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9635028497015 40.7928207574906) | 19 | 4 | 19 | 13 | |||||
905 | 905 | -73.9757216124349 | 40.7754310239649 | 11A-PM-1013-05 | 11A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | digging | false | false | false | false | true | false | false | false | POINT (-73.9757216124349 40.7754310239649) | 19 | 4 | 19 | 13 | ||||
915 | 915 | -73.9770235090023 | 40.774135208066 | 9A-AM-1013-02 | 09A | AM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9770235090023 40.774135208066) | 19 | 4 | 19 | 13 | |||||
924 | 924 | -73.9591695545875 | 40.7938116360767 | 35D-PM-1013-08 | 35D | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9591695545875 40.7938116360767) | 19 | 4 | 19 | 13 | |||||
927 | 927 | -73.9609885686834 | 40.7961108640319 | 37A-PM-1013-01 | 37A | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.96098856868342 40.7961108640319) | 19 | 4 | 19 | 13 | |||||
965 | 965 | -73.9708301070924 | 40.7820200927465 | 19A-PM-1013-01 | 19A | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | planting acorns | false | false | false | false | false | false | true | false | POINT (-73.9708301070924 40.7820200927465) | 19 | 4 | 19 | 13 | ||||
989 | 989 | -73.9603031059614 | 40.7943667735668 | 35C-PM-1013-05 | 35C | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9603031059614 40.7943667735668) | 19 | 4 | 19 | 13 | |||||
992 | 992 | -73.9708083587471 | 40.7825429441583 | 19A-PM-1013-03 | 19A | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9708083587471 40.7825429441583) | 19 | 4 | 19 | 13 | ||||||
1014 | 1014 | -73.9694468044483 | 40.770360886038 | 8I-PM-1013-05 | 08I | PM | 10132018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9694468044483 40.770360886038) | 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 | ||||
1027 | 1027 | -73.9640016324897 | 40.7921759097124 | 32A-PM-1013-01 | 32A | PM | 10132018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9640016324897 40.7921759097124) | 19 | 4 | 19 | 13 | |||||
1052 | 1052 | -73.9773858189627 | 40.770807701562 | 5B-PM-1013-01 | 05B | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9773858189627 40.770807701562) | 19 | 4 | 19 | 13 | |||||
1058 | 1058 | -73.9737100743183 | 40.7708360121735 | 7E-PM-1013-03 | 07E | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Ground & Tree Base | false | false | false | false | true | false | false | false | true | true | false | true | false | POINT (-73.9737100743183 40.7708360121735) | 19 | 4 | 19 | 13 | |||||
1083 | 1083 | -73.9788117755401 | 40.7707347137469 | 5B-PM-1013-04 | 05B | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.97881177554011 40.7707347137469) | 19 | 4 | 19 | 13 | |||||
1108 | 1108 | -73.9638397790384 | 40.7828950272904 | 23F-PM-1013-02 | 23F | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | true | false | false | true | false | true | false | indifferent (mostly,did notice me,busy eating,foraging) | POINT (-73.9638397790384 40.7828950272904) | 19 | 4 | 19 | 13 | ||||
1114 | 1114 | -73.9596505138955 | 40.7940367734988 | 35C-PM-1013-06 | 35C | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9596505138955 40.7940367734988) | 19 | 4 | 19 | 13 | |||||
1124 | 1124 | -73.959516757215 | 40.7952545908471 | 36C-PM-1013-04 | 36C | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | On rock | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.959516757215 40.7952545908471) | 19 | 4 | 19 | 13 | |||||
1130 | 1130 | -73.9519081627768 | 40.7973148719421 | 41G-AM-1013-02 | 41G | AM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9519081627768 40.7973148719421) | 19 | 4 | 19 | 13 | |||||
1143 | 1143 | -73.9628349778362 | 40.793887005206 | 34A-PM-1013-03 | 34A | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9628349778362 40.793887005206) | 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 | |||||
1167 | 1167 | -73.9593244415072 | 40.794964729747 | 36C-PM-1013-03 | 36C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | false | true | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9593244415072 40.794964729747) | 19 | 4 | 19 | 13 | |||||
1187 | 1187 | -73.9793334416378 | 40.7674142089209 | 1C-PM-1013-02 | 01C | PM | 10132018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | false | false | POINT (-73.9793334416378 40.7674142089209) | 19 | 4 | 19 | 13 | ||||
1189 | 1189 | -73.9577629744539 | 40.7897460758298 | 32G-PM-1013-01 | 32G | PM | 10132018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon belly | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | allowed me to approach within 10 ft | POINT (-73.9577629744539 40.789746075829804) | 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 | |||||
1200 | 1200 | -73.9657721715305 | 40.778534830257 | 18G-PM-1013-03 | 18G | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9657721715305 40.778534830257) | 19 | 4 | 19 | 13 | ||||||
1211 | 1211 | -73.9549337398033 | 40.7946552731628 | 38F-PM-1013-01 | 38F | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon tail & belly | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9549337398033 40.7946552731628) | 19 | 4 | 19 | 13 | ||||
1221 | 1221 | -73.9796409671481 | 40.7679049871186 | 1C-PM-1013-09 | 01C | PM | 10132018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9796409671481 40.7679049871186) | 19 | 4 | 19 | 13 | |||||
1281 | 1281 | -73.9795728289645 | 40.7678669804787 | 1C-PM-1013-07 | 01C | PM | 10132018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9795728289645 40.7678669804787) | 19 | 4 | 19 | 13 | |||||
1306 | 1306 | -73.9755974646331 | 40.7673435798289 | 3F-PM-1013-01 | 03F | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9755974646331 40.7673435798289) | 19 | 4 | 19 | 13 | |||||
1308 | 1308 | -73.9560396440844 | 40.7945080361909 | 37E-AM-1013-01 | 37E | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9560396440844 40.7945080361909) | 19 | 4 | 19 | 13 | |||||
1341 | 1341 | -73.9611300905602 | 40.7918743735665 | 32C-PM-1013-07 | 32C | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9611300905602 40.7918743735665) | 19 | 4 | 19 | 13 | |||||
1343 | 1343 | -73.9563662963703 | 40.7991952101949 | 42C-PM-1013-01 | 42C | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9563662963703 40.7991952101949) | 19 | 4 | 19 | 13 | ||||||
1344 | 1344 | -73.9618591510932 | 40.7921343738001 | 32C-PM-1013-11 | 32C | PM | 10132018 | 11 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9618591510932 40.7921343738001) | 19 | 4 | 19 | 13 | ||||||
1346 | 1346 | -73.9735655529245 | 40.7716072681474 | 7E-PM-1013-02 | 07E | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9735655529245 40.7716072681474) | 19 | 4 | 19 | 13 | ||||
1352 | 1352 | -73.9616770335086 | 40.7921648631096 | 32C-PM-1013-13 | 32C | PM | 10132018 | 13 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | buried nut | false | false | false | false | true | false | false | false | POINT (-73.9616770335086 40.7921648631096) | 19 | 4 | 19 | 13 | |||||
1379 | 1379 | -73.9796470494747 | 40.7678370925485 | 1C-PM-1013-08 | 01C | PM | 10132018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9796470494747 40.7678370925485) | 19 | 4 | 19 | 13 | ||||||
1385 | 1385 | -73.9615649773504 | 40.7954761311501 | 36A-PM-1013-02 | 36A | PM | 10132018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9615649773504 40.7954761311501) | 19 | 4 | 19 | 13 | ||||||
1405 | 1405 | -73.9589371550945 | 40.7959812504467 | 37C-PM-1013-04 | 37C | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9589371550945 40.7959812504467) | 19 | 4 | 19 | 13 | |||||||
1409 | 1409 | -73.9581544682422 | 40.7958081306449 | 37C-PM-1013-02 | 37C | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9581544682422 40.7958081306449) | 19 | 4 | 19 | 13 | |||||
1412 | 1412 | -73.9594676326588 | 40.7984457363388 | 39A-AM-1013-01 | 39A | AM | 10132018 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9594676326588 40.7984457363388) | 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 | |||||
1437 | 1437 | -73.9721279808683 | 40.7661158663901 | 3I-PM-1013-02 | 03I | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9721279808683 40.7661158663901) | 19 | 4 | 19 | 13 | |||||
1480 | 1480 | -73.9628525533831 | 40.7938449345017 | 34A-PM-1013-02 | 34A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | true | true | eating upside down on tree trunk | false | false | false | false | false | false | false | false | POINT (-73.9628525533831 40.7938449345017) | 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 );