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, Color notes, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Other Interactions
Location ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2033 | 2033 | -73.9500167570283 | 40.7966185836685 | 41I-AM-1018-01 | 41I | AM | 10182018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | false | cautious,observant,runs off | POINT (-73.9500167570283 40.7966185836685) | 19 | 4 | 19 | 13 | ||||
442 | 442 | -73.9502466289084 | 40.7959228779883 | 41I-AM-1018-02 | 41I | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | runs off | POINT (-73.9502466289084 40.7959228779883) | 19 | 4 | 19 | 13 | |||||
120 | 120 | -73.9511118711108 | 40.7950813345902 | 40I-AM-1018-01 | 40I | AM | 10182018 | 1 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | begging | false | false | false | false | false | false | false | false | POINT (-73.9511118711108 40.7950813345902) | 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 | ||||||
2708 | 2708 | -73.9528429238071 | 40.7922651848867 | 36I-PM-1007-09 | 36I | PM | 10072018 | 9 | Juvenile | Gray | Gray+ | Above Ground | 5 | true | true | false | false | false | burying nut | false | false | false | false | true | false | false | false | POINT (-73.9528429238071 40.7922651848867) | 19 | 4 | 19 | 13 | |||||
1945 | 1945 | -73.9530257401736 | 40.795139740737 | 39G-PM-1013-01 | 39G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9530257401736 40.79513974073701) | 19 | 4 | 19 | 13 | |||||
1515 | 1515 | -73.9530326577312 | 40.7956922386395 | 39G-PM-1013-02 | 39G | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9530326577312 40.795692238639504) | 19 | 4 | 19 | 13 | |||||
2835 | 2835 | -73.9531953594918 | 40.7960413520131 | 40G-PM-1013-01 | 40G | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9531953594918 40.7960413520131) | 19 | 4 | 19 | 13 | ||||||
1464 | 1464 | -73.9532074573139 | 40.7934669464908 | 37H-PM-1006-06 | 37H | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | tree | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9532074573139 40.7934669464908) | 19 | 4 | 19 | 13 | ||||
31 | 31 | -73.9540054100539 | 40.7952445999836 | 39G-PM-1013-06 | 39G | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9540054100539 40.7952445999836) | 19 | 4 | 19 | 13 | |||||
1882 | 1882 | -73.9541601469123 | 40.7907832744689 | 34I-PM-1010-04 | 34I | PM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | across the lawn and climb up a small tree | true | false | true | false | false | grooming | false | false | false | false | false | false | false | false | POINT (-73.9541601469123 40.79078327446891) | 19 | 4 | 19 | 13 | ||||
2881 | 2881 | -73.9541629063295 | 40.7934259301577 | 37G-AM-1014-02 | 37G | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | ran away & disappeared | false | false | false | false | false | false | false | false | POINT (-73.9541629063295 40.7934259301577) | 19 | 4 | 19 | 13 | |||||
2758 | 2758 | -73.9542074814296 | 40.7954322240004 | 39F-AM-1014-01 | 39F | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9542074814296 40.7954322240004) | 19 | 4 | 19 | 13 | |||||
2639 | 2639 | -73.9543832609857 | 40.7953550639701 | 39F-AM-1014-02 | 39F | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | rocks | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9543832609857 40.7953550639701) | 19 | 4 | 19 | 13 | ||||
828 | 828 | -73.9545101041865 | 40.7903823616782 | 34I-PM-1010-03 | 34I | PM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | in the playground. | true | false | false | false | true | with some nuts in the mouth | false | false | false | false | false | false | false | false | POINT (-73.9545101041865 40.7903823616782) | 19 | 4 | 19 | 13 | ||||
2080 | 2080 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 10102018 | 7 | Adult | Gray | Gray+ | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.954530253849 40.7910247489879) | 19 | 4 | 19 | 13 | ||||||||
2173 | 2173 | -73.9546123259441 | 40.7941434862099 | 37G-PM-1007-05 | 37G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | jumping around! | false | false | false | false | false | false | false | false | POINT (-73.9546123259441 40.7941434862099) | 19 | 4 | 19 | 13 | ||||
517 | 517 | -73.954959868822 | 40.7985404965582 | 41D-PM-1014-03 | 41D | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.954959868822 40.7985404965582) | 19 | 4 | 19 | 13 | |||||
2873 | 2873 | -73.955068474109 | 40.7911788152878 | 34H-PM-1006-05 | 34H | PM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | white tail tip | Ground Plane | FALSE | in grass | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.955068474109 40.7911788152878) | 19 | 4 | 19 | 13 | |||
2814 | 2814 | -73.9551625272308 | 40.791193071916 | 34H-PM-1006-06 | 34H | PM | 10062018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | in grass | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9551625272308 40.791193071916) | 19 | 4 | 19 | 13 | |||||
2346 | 2346 | -73.9562177305881 | 40.7983413276331 | 41C-PM-1007-03 | 41C | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562177305881 40.7983413276331) | 19 | 4 | 19 | 13 | |||||
2087 | 2087 | -73.956502663005 | 40.788160908881 | 30I-PM-1006-05 | 30I | PM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.956502663005 40.788160908881) | 19 | 4 | 19 | 13 | |||||
2829 | 2829 | -73.9565230963554 | 40.798556387711 | 41C-PM-1007-02 | 41C | PM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565230963554 40.798556387711) | 19 | 4 | 19 | 13 | |||||
883 | 883 | -73.9565533783499 | 40.7974368491287 | 40D-PM-1013-02 | 40D | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565533783499 40.7974368491287) | 19 | 4 | 19 | 13 | |||||
395 | 395 | -73.9565686300382 | 40.797592846003 | 40C-PM-1006-03 | 40C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565686300382 40.797592846003) | 19 | 4 | 19 | 13 | ||||||
118 | 118 | -73.9566346046453 | 40.7973923396512 | 40D-PM-1013-01 | 40D | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9566346046453 40.7973923396512) | 19 | 4 | 19 | 13 | |||||
1373 | 1373 | -73.956737220098 | 40.797580989255 | 40C-PM-1006-01 | 40C | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.95673722009802 40.797580989255) | 19 | 4 | 19 | 13 | ||||||
479 | 479 | -73.9569403365847 | 40.7956599608798 | 38D-PM-1006-01 | 38D | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | didn't see me or others | POINT (-73.9569403365847 40.7956599608798) | 19 | 4 | 19 | 13 | ||||
2457 | 2457 | -73.9569896638974 | 40.7911914507504 | 33G-PM-1006-02 | 33G | PM | 10062018 | 2 | Adult | Gray | Gray+ | my favorite | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | engaged w/ me | POINT (-73.9569896638974 40.7911914507504) | 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 | |||||
2316 | 2316 | -73.957697363244 | 40.7997576909042 | 42A-PM-1014-01 | 42A | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | up on hind legs looking around | false | false | false | false | false | false | false | false | came to about 10' away then ran off | POINT (-73.957697363244 40.7997576909042) | 19 | 4 | 19 | 13 | |||
1740 | 1740 | -73.9577758125518 | 40.799384716477 | 41B-AM-1010-10 | 41B | AM | 10102018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9577758125518 40.799384716477) | 19 | 4 | 19 | 13 | |||||
1047 | 1047 | -73.9580111056675 | 40.7854339401483 | 27I-PM-1020-02 | 27I | PM | 10202018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9580111056675 40.7854339401483) | 19 | 4 | 19 | 13 | |||||
907 | 907 | -73.958060992131 | 40.7907158878729 | 32F-AM-1012-06 | 32F | AM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.958060992131 40.7907158878729) | 19 | 4 | 19 | 13 | |||||
2002 | 2002 | -73.9581706950566 | 40.7906321397269 | 32F-AM-1012-05 | 32F | AM | 10122018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9581706950566 40.7906321397269) | 19 | 4 | 19 | 13 | |||||
561 | 561 | -73.9581982486469 | 40.7992194575293 | 41A-PM-1007-03 | 41A | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 55 | true | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.95819824864691 40.7992194575293) | 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 | ||||||
2214 | 2214 | -73.9583688637255 | 40.791388958496 | 33E-PM-1012-08 | 33E | PM | 10122018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9583688637255 40.791388958496) | 19 | 4 | 19 | 13 | |||||
772 | 772 | -73.9584188461059 | 40.7913241048498 | 33E-PM-1012-07 | 33E | PM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9584188461059 40.7913241048498) | 19 | 4 | 19 | 13 | |||||
53 | 53 | -73.9584970643213 | 40.7982886348696 | 40B-AM-1019-03 | 40B | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | true | false | false | POINT (-73.9584970643213 40.7982886348696) | 19 | 4 | 19 | 13 | |||||
172 | 172 | -73.958535640774 | 40.7982737896998 | 40B-AM-1019-02 | 40B | AM | 10192018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.958535640774 40.7982737896998) | 19 | 4 | 19 | 13 | |||||
2743 | 2743 | -73.9587179613803 | 40.7992119571657 | 41A-PM-1007-01 | 41A | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9587179613803 40.7992119571657) | 19 | 4 | 19 | 13 | |||||
494 | 494 | -73.958837574505 | 40.7985003987784 | 40A-PM-1014-06 | 40A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.958837574505 40.7985003987784) | 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 | ||||
2205 | 2205 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 10122018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8 | on turn, see map | true | true | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
1272 | 1272 | -73.9595717225279 | 40.7829872498299 | 25I-PM-1007-03 | 25I | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9595717225279 40.7829872498299) | 19 | 4 | 19 | 13 | ||||||
369 | 369 | -73.9596398997228 | 40.7933386953847 | 34D-PM-1007-02 | 34D | PM | 10072018 | 2 | Adult | Black | Black+ | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | cautiously aware | POINT (-73.9596398997228 40.7933386953847) | 19 | 4 | 19 | 13 | |||||
2609 | 2609 | -73.9596865318094 | 40.7893787188526 | 31F-AM-1013-01 | 31F | AM | 10132018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9596865318094 40.7893787188526) | 19 | 4 | 19 | 13 | |||||
2413 | 2413 | -73.959701727877 | 40.790660026971 | 32E-AM-1007-03 | 32E | AM | 10072018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.959701727877 40.790660026971) | 19 | 4 | 19 | 13 | ||||||
819 | 819 | -73.9603620122205 | 40.7955965755851 | 36B-AM-1013-02 | 36B | AM | 10132018 | 2 | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | didn't see me | POINT (-73.9603620122205 40.7955965755851) | 19 | 4 | 19 | 13 | ||||||
2629 | 2629 | -73.9604576237503 | 40.7818120101394 | 23I-PM-1019-01 | 23I | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | true | false | false | false | false | running (across branches) | false | false | false | false | false | false | false | false | POINT (-73.9604576237503 40.7818120101394) | 19 | 4 | 19 | 13 | |||||
79 | 79 | -73.9610705592868 | 40.7914829661051 | 32D-AM-1013-06 | 32D | AM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | true | true | eating (a mushroom),circles around us,really fat,scratching himself,grooming activity | false | false | false | false | true | true | false | false | POINT (-73.9610705592868 40.7914829661051) | 19 | 4 | 19 | 13 | |||||
1823 | 1823 | -73.9612854506075 | 40.7920830673571 | 32C-PM-1013-04 | 32C | PM | 10132018 | 4 | Juvenile | Gray | Gray+ | Above Ground | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 | |||||||
1441 | 1441 | -73.961335649743 | 40.7818876867842 | 23H-PM-1019-01 | 23H | PM | 10192018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.961335649743 40.7818876867842) | 19 | 4 | 19 | 13 | ||||||
2275 | 2275 | -73.9614218413356 | 40.7938945058793 | 34B-AM-1013-01 | 34B | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | hopping | false | false | false | false | true | true | false | false | POINT (-73.9614218413356 40.7938945058793) | 19 | 4 | 19 | 13 | ||||
1496 | 1496 | -73.9615500510038 | 40.7920799263699 | 32C-PM-1013-05 | 32C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9615500510038 40.7920799263699) | 19 | 4 | 19 | 13 | ||||||
1082 | 1082 | -73.9617490680298 | 40.7921537849244 | 32C-PM-1013-06 | 32C | PM | 10132018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9617490680298 40.7921537849244) | 19 | 4 | 19 | 13 | ||||||
176 | 176 | -73.9618064639153 | 40.792158440043 | 32C-PM-1013-12 | 32C | PM | 10132018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | true | false | false | POINT (-73.9618064639153 40.792158440043) | 19 | 4 | 19 | 13 | ||||||
2913 | 2913 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9621297946132 40.7944058222814) | 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 | |||||
1606 | 1606 | -73.9628932797886 | 40.7923116396365 | 32B-PM-1010-05 | 32B | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9628932797886 40.7923116396365) | 19 | 4 | 19 | 13 | ||||||
2900 | 2900 | -73.9631005470369 | 40.7885494057193 | 28D-AM-1012-01 | 28D | AM | 10122018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9631005470369 40.7885494057193) | 19 | 4 | 19 | 13 | |||||
950 | 950 | -73.9637415893182 | 40.7898140363534 | 29B-AM-1007-01 | 29B | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9637415893182 40.7898140363534) | 19 | 4 | 19 | 13 | ||||||
1684 | 1684 | -73.9637824756607 | 40.7904737110761 | 30B-AM-1007-08 | 30B | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9637824756607 40.7904737110761) | 19 | 4 | 19 | 13 | ||||||
371 | 371 | -73.964080104186 | 40.7907898627287 | 30B-AM-1007-02 | 30B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.964080104186 40.7907898627287) | 19 | 4 | 19 | 13 | ||||||
480 | 480 | -73.9641293283734 | 40.7907654006019 | 30B-AM-1007-03 | 30B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641293283734 40.7907654006019) | 19 | 4 | 19 | 13 | ||||||
983 | 983 | -73.9641552070803 | 40.7908479527923 | 30B-AM-1007-05 | 30B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 10 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641552070803 40.7908479527923) | 19 | 4 | 19 | 13 | ||||||
1330 | 1330 | -73.9643032554205 | 40.7794514526463 | 19H-AM-1010-02 | 19H | AM | 10102018 | 2 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near base of small tree | true | false | false | true | true | false | false | false | true | false | true | false | false | ran from human with dog | POINT (-73.9643032554205 40.7794514526463) | 19 | 4 | 19 | 13 | ||||
1451 | 1451 | -73.9645365195454 | 40.7781531021263 | 18H-AM-1018-02 | 18H | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Tree | true | true | false | false | false | playing? | false | false | false | false | false | false | false | false | POINT (-73.9645365195454 40.7781531021263) | 19 | 4 | 19 | 13 | ||||
2313 | 2313 | -73.9646174034945 | 40.7781287528262 | 18H-AM-1018-01 | 18H | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Running from one tree to the other | true | true | false | false | false | playing? | false | false | false | false | false | false | false | false | POINT (-73.9646174034945 40.7781287528262) | 19 | 4 | 19 | 13 | |||
1962 | 1962 | -73.9647318357023 | 40.7760936175332 | 15I-PM-1012-04 | 15I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9647318357023 40.7760936175332) | 19 | 4 | 19 | 13 | ||||||
1420 | 1420 | -73.9647605121306 | 40.7803961531517 | 20G-AM-1018-03 | 20G | AM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 12 | in tree | true | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9647605121306 40.7803961531517) | 19 | 4 | 19 | 13 | |||||
1046 | 1046 | -73.9647891228606 | 40.789853066039 | 29B-AM-1007-02 | 29B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | true | false | false | false | false | POINT (-73.9647891228606 40.789853066039) | 19 | 4 | 19 | 13 | ||||||
771 | 771 | -73.9648626810032 | 40.7804506112843 | 20G-AM-1018-02 | 20G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | Ran up tree | true | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9648626810032 40.7804506112843) | 19 | 4 | 19 | 13 | |||||
1991 | 1991 | -73.965059909327 | 40.7762131886797 | 15I-PM-1012-06 | 15I | PM | 10122018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.965059909327 40.7762131886797) | 19 | 4 | 19 | 13 | ||||||
2147 | 2147 | -73.9651217998407 | 40.7761115392738 | 15I-PM-1012-01 | 15I | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9651217998407 40.7761115392738) | 19 | 4 | 19 | 13 | |||||
125 | 125 | -73.9651601541795 | 40.7761841788025 | 15I-PM-1012-07 | 15I | PM | 10122018 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9651601541795 40.7761841788025) | 19 | 4 | 19 | 13 | ||||||
682 | 682 | -73.9651828383592 | 40.7802820943863 | 19F-PM-1017-06 | 19F | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | true | false | false | false | false | false | false | true | true | false | false | POINT (-73.9651828383592 40.7802820943863) | 19 | 4 | 19 | 13 | |||||
1706 | 1706 | -73.965215665278 | 40.7761309082202 | 15I-PM-1012-02 | 15I | PM | 10122018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.965215665278 40.7761309082202) | 19 | 4 | 19 | 13 | ||||||
1487 | 1487 | -73.965394655961 | 40.7763136791661 | 15I-PM-1012-05 | 15I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | burying the food on ground | false | false | false | false | false | false | false | false | look at us and continue hiding the food | POINT (-73.965394655961 40.7763136791661) | 19 | 4 | 19 | 13 | ||||
946 | 946 | -73.9654093844049 | 40.7806896368469 | 20F-PM-1007-09 | 20F | PM | 10072018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.9654093844049 40.7806896368469) | 19 | 4 | 19 | 13 | |||||
1510 | 1510 | -73.9655670884957 | 40.7763728890554 | 16H-PM-1014-03 | 16H | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | followed man across bridge | POINT (-73.9655670884957 40.7763728890554) | 19 | 4 | 19 | 13 | ||||
2655 | 2655 | -73.9659156108069 | 40.7810709818696 | 20E-AM-1014-01 | 20E | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9659156108069 40.7810709818696) | 19 | 4 | 19 | 13 | |||||
2546 | 2546 | -73.9660267365885 | 40.776444395505 | 16H-AM-1007-01 | 16H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9660267365885 40.776444395505) | 19 | 4 | 19 | 13 | ||||||
2444 | 2444 | -73.966590487009 | 40.7802469052891 | 19E-PM-1018-02 | 19E | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.96659048700901 40.7802469052891) | 19 | 4 | 19 | 13 | |||||
487 | 487 | -73.9666521094255 | 40.7842753517648 | 23C-PM-1014-02 | 23C | PM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | in bushes, then ran across path | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9666521094255 40.7842753517648) | 19 | 4 | 19 | 13 | |||||
411 | 411 | -73.9669366401071 | 40.7836023897982 | 22C-PM-1006-09 | 22C | PM | 10062018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.96693664010711 40.7836023897982) | 19 | 4 | 19 | 13 | ||||||
1646 | 1646 | -73.9669782832746 | 40.7841166727168 | 22C-PM-1006-13 | 22C | PM | 10062018 | 13 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9669782832746 40.7841166727168) | 19 | 4 | 19 | 13 | ||||||
1004 | 1004 | -73.9670850805619 | 40.7833747810387 | 22C-PM-1006-01 | 22C | PM | 10062018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | for food | false | true | false | false | false | false | false | false | POINT (-73.9670850805619 40.7833747810387) | 19 | 4 | 19 | 13 | |||||
420 | 420 | -73.9671851611243 | 40.7750878657618 | 14H-PM-1012-01 | 14H | PM | 10122018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | true | false | false | approaches (came very close to me) | POINT (-73.9671851611243 40.7750878657618) | 19 | 4 | 19 | 13 | ||||
1002 | 1002 | -73.9672070423666 | 40.783337354891 | 22C-PM-1006-02 | 22C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9672070423666 40.783337354891) | 19 | 4 | 19 | 13 | ||||||
373 | 373 | -73.9672127283283 | 40.7810666805133 | 20D-AM-1007-01 | 20D | AM | 10072018 | 1 | Adult | Gray | Gray+ | too far to note 30' | Ground Plane | FALSE | true | false | true | true | false | a lot of activity | false | false | false | true | false | false | false | false | POINT (-73.9672127283283 40.7810666805133) | 19 | 4 | 19 | 13 | ||||
2197 | 2197 | -73.9672413354558 | 40.7838116138235 | 22C-PM-1006-03 | 22C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9672413354558 40.7838116138235) | 19 | 4 | 19 | 13 | ||||||
1888 | 1888 | -73.9673919075839 | 40.7786845769177 | 17F-PM-1020-05 | 17F | PM | 10202018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9673919075839 40.7786845769177) | 19 | 4 | 19 | 13 | ||||||
1163 | 1163 | -73.9677096985223 | 40.7825358361204 | 21C-AM-1014-02 | 21C | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 50 | true | true | true | false | true | false | true | false | false | false | false | false | false | looked at us from tree | POINT (-73.9677096985223 40.7825358361204) | 19 | 4 | 19 | 13 | ||||
2772 | 2772 | -73.9677368646039 | 40.7821550964837 | 20C-PM-1018-06 | 20C | PM | 10182018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.96773686460392 40.782155096483706) | 19 | 4 | 19 | 13 | ||||||
1685 | 1685 | -73.9678822983274 | 40.7802960985637 | 18E-PM-1006-01 | 18E | PM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9678822983274 40.7802960985637) | 19 | 4 | 19 | 13 | |||||
2170 | 2170 | -73.9678923667678 | 40.7819675626236 | 20C-PM-1018-05 | 20C | PM | 10182018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.9678923667678 40.781967562623606) | 19 | 4 | 19 | 13 | ||||||
1889 | 1889 | -73.9679319758284 | 40.7821154802399 | 20C-PM-1018-07 | 20C | PM | 10182018 | 7 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9679319758284 40.7821154802399) | 19 | 4 | 19 | 13 | |||||
1795 | 1795 | -73.968004352343 | 40.7726669278308 | 11I-PM-1012-01 | 11I | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | true | true | false | false | false | look at humans determining | POINT (-73.968004352343 40.7726669278308) | 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 );