This data as json, CSV (advanced)
Suggested facets: Shift, Hectare Squirrel Number, 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, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40 | 40 | -73.9535410657077 | 40.7928711760061 | 36H-PM-1008-02 | 36H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9535410657077 40.79287117600611) | 19 | 4 | 19 | 13 | ||||||
1483 | 1483 | -73.9545773579075 | 40.7898684635744 | 33I-AM-1008-05 | 33I | AM | 10082018 | 5 | Adult | + | Above Ground | 100 | false | false | true | false | true | false | false | false | false | false | false | true | false | nearly dropped shell on my head! | POINT (-73.9545773579075 40.7898684635744) | 19 | 4 | 19 | 13 | ||||||
1993 | 1993 | -73.9546367558712 | 40.789840987798 | 33I-AM-1008-04 | 33I | AM | 10082018 | 4 | Adult | + | Above Ground | 100 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9546367558712 40.789840987798) | 19 | 4 | 19 | 13 | |||||||
2146 | 2146 | -73.9547398684817 | 40.7896483795302 | 33I-AM-1008-01 | 33I | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park @ 98th (north) | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9547398684817 40.7896483795302) | 19 | 4 | 19 | 13 | ||||
2258 | 2258 | -73.9547785081171 | 40.789612183711 | 33I-AM-1008-02 | 33I | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | edge of park @ 98th | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9547785081171 40.789612183711) | 19 | 4 | 19 | 13 | |||||
953 | 953 | -73.9547959269955 | 40.7925162926273 | 36H-PM-1008-01 | 36H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | white belly | Above Ground | 20 | true | false | true | false | true | true | true | false | false | false | false | true | false | POINT (-73.9547959269955 40.7925162926273) | 19 | 4 | 19 | 13 | ||||
279 | 279 | -73.9550082056509 | 40.7894521543449 | 33I-AM-1008-03 | 33I | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | 98th @ edge of park | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9550082056509 40.7894521543449) | 19 | 4 | 19 | 13 | |||||
1835 | 1835 | -73.9562068537632 | 40.7967332853238 | 39D-AM-1008-01 | 39D | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562068537632 40.7967332853238) | 19 | 4 | 19 | 13 | ||||||
1319 | 1319 | -73.9562105506291 | 40.7966991197909 | 39D-AM-1008-02 | 39D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562105506291 40.7966991197909) | 19 | 4 | 19 | 13 | ||||||
1280 | 1280 | -73.9562469727195 | 40.79685907654 | 39D-AM-1008-04 | 39D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562469727195 40.79685907654) | 19 | 4 | 19 | 13 | ||||||
665 | 665 | -73.9563661256875 | 40.7966823114508 | 39D-AM-1008-03 | 39D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9563661256875 40.7966823114508) | 19 | 4 | 19 | 13 | ||||||
773 | 773 | -73.9566189145352 | 40.7883417969746 | 31H-PM-1008-01 | 31H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9566189145352 40.7883417969746) | 19 | 4 | 19 | 13 | |||||
1883 | 1883 | -73.9568108465086 | 40.7971727026108 | 39D-AM-1008-05 | 39D | AM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.95681084650862 40.7971727026108) | 19 | 4 | 19 | 13 | ||||||
1162 | 1162 | -73.9568544270881 | 40.7972517274475 | 39D-AM-1008-06 | 39D | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 3 | on rock | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9568544270881 40.7972517274475) | 19 | 4 | 19 | 13 | |||||
2690 | 2690 | -73.9572840457971 | 40.7886933371744 | 31H-PM-1008-04 | 31H | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | Also way up | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.95728404579711 40.7886933371744) | 19 | 4 | 19 | 13 | ||||||
2015 | 2015 | -73.9574365550758 | 40.7886924675052 | 31H-PM-1008-03 | 31H | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | no clue, way up a tree! | false | false | true | false | true | throwing down acorns | false | false | false | false | false | false | false | false | POINT (-73.9574365550758 40.7886924675052) | 19 | 4 | 19 | 13 | |||||
43 | 43 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 10082018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9574648097543 40.78925084286221) | 19 | 4 | 19 | 13 | |||||
1592 | 1592 | -73.9575517912392 | 40.7889158268192 | 31H-PM-1008-05 | 31H | PM | 10082018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9575517912392 40.7889158268192) | 19 | 4 | 19 | 13 | ||||||
1450 | 1450 | -73.9580813119325 | 40.7905538237042 | 32F-PM-1008-04 | 32F | PM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9580813119325 40.7905538237042) | 19 | 4 | 19 | 13 | ||||||
14 | 14 | -73.9582694312289 | 40.7917367820255 | 33F-AM-1008-02 | 33F | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9582694312289 40.7917367820255) | 19 | 4 | 19 | 13 | ||||||
2118 | 2118 | -73.958369699409 | 40.7902456668332 | 32F-PM-1008-01 | 32F | PM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.958369699409 40.7902456668332) | 19 | 4 | 19 | 13 | ||||||
24 | 24 | -73.9584070974734 | 40.7913812490557 | 33F-AM-1008-01 | 33F | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | moving slowly | false | false | false | false | false | false | true | false | POINT (-73.9584070974734 40.7913812490557) | 19 | 4 | 19 | 13 | |||||
1093 | 1093 | -73.9584106786233 | 40.7902777556926 | 32F-PM-1008-02 | 32F | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9584106786233 40.7902777556926) | 19 | 4 | 19 | 13 | |||||
2485 | 2485 | -73.9584950620879 | 40.7902770710643 | 32F-PM-1008-03 | 32F | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9584950620879 40.7902770710643) | 19 | 4 | 19 | 13 | |||||
957 | 957 | -73.9586527721822 | 40.7908831110561 | 32F-PM-1008-08 | 32F | PM | 10082018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586527721822 40.7908831110561) | 19 | 4 | 19 | 13 | |||||
1078 | 1078 | -73.9586591455169 | 40.7906243901309 | 32F-PM-1008-06 | 32F | PM | 10082018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586591455169 40.7906243901309) | 19 | 4 | 19 | 13 | ||||||
28 | 28 | -73.958736593111 | 40.7908524370626 | 32F-PM-1008-07 | 32F | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.958736593111 40.7908524370626) | 19 | 4 | 19 | 13 | ||||||
672 | 672 | -73.9588708103486 | 40.7905794078843 | 32F-PM-1008-05 | 32F | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9588708103486 40.7905794078843) | 19 | 4 | 19 | 13 | ||||||
2268 | 2268 | -73.9590191655172 | 40.7926139425111 | 34D-AM-1008-03 | 34D | AM | 10082018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9590191655172 40.7926139425111) | 19 | 4 | 19 | 13 | |||||
821 | 821 | -73.959077668148 | 40.7926045823346 | 34D-AM-1008-02 | 34D | AM | 10082018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.959077668148 40.7926045823346) | 19 | 4 | 19 | 13 | ||||||
1101 | 1101 | -73.95912925497 | 40.7925530280455 | 34D-AM-1008-01 | 34D | AM | 10082018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | staring at us | POINT (-73.95912925497001 40.7925530280455) | 19 | 4 | 19 | 13 | |||||
342 | 342 | -73.9605966636226 | 40.7889849108637 | 30E-AM-1008-01 | 30E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | scurried into bushes when jogger ran by | POINT (-73.9605966636226 40.7889849108637) | 19 | 4 | 19 | 13 | ||||
1955 | 1955 | -73.9606559309874 | 40.7889527629826 | 30E-AM-1008-02 | 30E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9606559309874 40.7889527629826) | 19 | 4 | 19 | 13 | ||||||
1610 | 1610 | -73.9607056611532 | 40.7889786103871 | 30E-AM-1008-03 | 30E | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9607056611532 40.7889786103871) | 19 | 4 | 19 | 13 | ||||||
2724 | 2724 | -73.9611434082667 | 40.7893671772846 | 30E-PM-1008-01 | 30E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | true | false | false | false | false | false | false | POINT (-73.9611434082667 40.7893671772846) | 19 | 4 | 19 | 13 | |||||
2431 | 2431 | -73.9630054996358 | 40.7905225147022 | 30C-PM-1008-01 | 30C | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9630054996358 40.7905225147022) | 19 | 4 | 19 | 13 | |||||
1432 | 1432 | -73.9632577850183 | 40.793112839016 | 33A-AM-1008-01 | 33A | AM | 10082018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | acknowledged | POINT (-73.9632577850183 40.793112839016) | 19 | 4 | 19 | 13 | ||||
1121 | 1121 | -73.9645060433292 | 40.7768322057794 | 16I-AM-1008-03 | 16I | AM | 10082018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9645060433292 40.7768322057794) | 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 | ||
2526 | 2526 | -73.9646495450499 | 40.7791203699027 | 19H-PM-1008-01 | 19H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9646495450499 40.7791203699027) | 19 | 4 | 19 | 13 | |||||
2516 | 2516 | -73.9649823687651 | 40.7763395359636 | 16I-AM-1008-02 | 16I | AM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9649823687651 40.7763395359636) | 19 | 4 | 19 | 13 | |||||
26 | 26 | -73.9649866016038 | 40.7764929694457 | 16I-AM-1008-01 | 16I | AM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9649866016038 40.7764929694457) | 19 | 4 | 19 | 13 | |||||
2630 | 2630 | -73.965019827314 | 40.7759864291323 | 15I-AM-1008-03 | 15I | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.965019827314 40.7759864291323) | 19 | 4 | 19 | 13 | ||||||
112 | 112 | -73.9651754464439 | 40.7755181941559 | 15I-AM-1008-01 | 15I | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | tree | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9651754464439 40.7755181941559) | 19 | 4 | 19 | 13 | ||||
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 | ||||||
615 | 615 | -73.9653279069888 | 40.7758743113817 | 15I-AM-1008-02 | 15I | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Could be same squirrel as #1? | Above Ground | 4 | on fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653279069888 40.7758743113817) | 19 | 4 | 19 | 13 | |||
1839 | 1839 | -73.9655925527354 | 40.7760049171097 | 15H-PM-1008-05 | 15H | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | lawn | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9655925527354 40.7760049171097) | 19 | 4 | 19 | 13 | |||||
1089 | 1089 | -73.9655955841325 | 40.7762063860571 | 15H-PM-1008-04 | 15H | PM | 10082018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of landscape | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9655955841325 40.7762063860571) | 19 | 4 | 19 | 13 | |||||
696 | 696 | -73.9656098194149 | 40.7757643078973 | 15I-AM-1008-05 | 15I | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9656098194149 40.7757643078973) | 19 | 4 | 19 | 13 | ||||||
2190 | 2190 | -73.9657040391563 | 40.7755567428199 | 15I-AM-1008-06 | 15I | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 12 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9657040391563 40.7755567428199) | 19 | 4 | 19 | 13 | |||||
196 | 196 | -73.965796978969 | 40.7760402842845 | 15H-PM-1008-03 | 15H | PM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | lawn moving east over Park path | false | false | false | false | false | not sure walk-pause-walk | false | false | false | false | false | false | true | false | POINT (-73.96579697896901 40.7760402842845) | 19 | 4 | 19 | 13 | ||||
2725 | 2725 | -73.9658867660358 | 40.7756523577509 | 15H-PM-1008-06 | 15H | PM | 10082018 | 6 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | base of gingko tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9658867660358 40.7756523577509) | 19 | 4 | 19 | 13 | ||||
718 | 718 | -73.9661694463488 | 40.7757530583569 | 15H-PM-1008-07 | 15H | PM | 10082018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | along bottom of rock outcropping | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9661694463488 40.7757530583569) | 19 | 4 | 19 | 13 | ||||
462 | 462 | -73.9661785940531 | 40.7742569936186 | 13I-PM-1008-01 | 13I | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | climbed tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9661785940531 40.7742569936186) | 19 | 4 | 19 | 13 | ||||
2347 | 2347 | -73.9663124560664 | 40.779544003786 | 18F-PM-1008-02 | 18F | PM | 10082018 | 2 | Adult | Gray | Gray+ | false | false | false | false | false | hopping around | false | false | false | false | false | false | false | true | POINT (-73.9663124560664 40.779544003786) | 19 | 4 | 19 | 13 | |||||||
2489 | 2489 | -73.9663168490265 | 40.7825083721362 | 21D-AM-1008-01 | 21D | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | true | false | true | false | POINT (-73.9663168490265 40.7825083721362) | 19 | 4 | 19 | 13 | |||||
127 | 127 | -73.9664100504436 | 40.7828778892276 | 21D-AM-1008-02 | 21D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9664100504436 40.7828778892276) | 19 | 4 | 19 | 13 | ||||||
906 | 906 | -73.9664120826015 | 40.7888022709721 | 27A-AM-1008-01 | 27A | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96641208260151 40.7888022709721) | 19 | 4 | 19 | 13 | ||||||
464 | 464 | -73.9664450399121 | 40.7887844904695 | 27A-AM-1008-02 | 27A | AM | 10082018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664450399121 40.7887844904695) | 19 | 4 | 19 | 13 | |||||
2563 | 2563 | -73.9664536611195 | 40.7827694131949 | 21D-AM-1008-03 | 21D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9664536611195 40.7827694131949) | 19 | 4 | 19 | 13 | ||||||
909 | 909 | -73.9665705456197 | 40.7823552871044 | 21D-PM-1008-05 | 21D | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9665705456197 40.7823552871044) | 19 | 4 | 19 | 13 | |||||
1135 | 1135 | -73.9667474482967 | 40.7760643720793 | 15H-PM-1008-01 | 15H | PM | 10082018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Oak tree | false | true | false | false | false | watching me | false | true | false | true | false | false | false | false | observant | POINT (-73.9667474482967 40.7760643720793) | 19 | 4 | 19 | 13 | ||
890 | 890 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | oak tree | false | true | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9667755678511 40.7760256836088) | 19 | 4 | 19 | 13 | |||||
1290 | 1290 | -73.9668140804066 | 40.7768100147333 | 15G-AM-1008-06 | 15G | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9668140804066 40.7768100147333) | 19 | 4 | 19 | 13 | |||||
2239 | 2239 | -73.9668922014699 | 40.7823535653774 | 21D-AM-1008-06 | 21D | AM | 10082018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9668922014699 40.7823535653774) | 19 | 4 | 19 | 13 | ||||||
2058 | 2058 | -73.9669017345324 | 40.7766928987073 | 15G-AM-1008-01 | 15G | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9669017345324 40.7766928987073) | 19 | 4 | 19 | 13 | |||||
1545 | 1545 | -73.9669207809051 | 40.7792767850126 | 18F-PM-1008-01 | 18F | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9669207809051 40.7792767850126) | 19 | 4 | 19 | 13 | |||||
1247 | 1247 | -73.9670904869871 | 40.7832091658006 | 21D-PM-1008-06 | 21D | PM | 10082018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9670904869871 40.7832091658006) | 19 | 4 | 19 | 13 | |||||
2942 | 2942 | -73.9672063784809 | 40.7826070395665 | 21D-PM-1008-01 | 21D | PM | 10082018 | 1 | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | true | false | false | POINT (-73.9672063784809 40.7826070395665) | 19 | 4 | 19 | 13 | |||||||
2925 | 2925 | -73.9672152696834 | 40.7823874581829 | 21D-AM-1008-05 | 21D | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9672152696834 40.7823874581829) | 19 | 4 | 19 | 13 | |||||
2271 | 2271 | -73.9673949458096 | 40.7826218539496 | 21D-AM-1008-04 | 21D | AM | 10082018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9673949458096 40.78262185394961) | 19 | 4 | 19 | 13 | |||||
810 | 810 | -73.967418114684 | 40.7764595360054 | 15G-AM-1008-05 | 15G | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.967418114684 40.7764595360054) | 19 | 4 | 19 | 13 | |||||
2318 | 2318 | -73.967458693983 | 40.7769922522105 | 15G-AM-1008-02 | 15G | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967458693983 40.7769922522105) | 19 | 4 | 19 | 13 | ||||||
2862 | 2862 | -73.967466716152 | 40.7824346548278 | 21D-PM-1008-04 | 21D | PM | 10082018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | false | false | false | true | false | false | false | false | false | false | false | false | true | i scared it | POINT (-73.967466716152 40.7824346548278) | 19 | 4 | 19 | 13 | ||||
3009 | 3009 | -73.9675637870968 | 40.7823880671728 | 21D-PM-1008-02 | 21D | PM | 10082018 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9675637870968 40.7823880671728) | 19 | 4 | 19 | 13 | ||||||
2091 | 2091 | -73.9676112864286 | 40.7772792086081 | 16F-AM-1008-03 | 16F | AM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | road | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9676112864286 40.7772792086081) | 19 | 4 | 19 | 13 | ||||
1563 | 1563 | -73.9676270670996 | 40.776391443152 | 15G-AM-1008-04 | 15G | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9676270670996 40.776391443152) | 19 | 4 | 19 | 13 | ||||||
982 | 982 | -73.9676424599715 | 40.7777766106807 | 16F-AM-1008-01 | 16F | AM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | near fence | false | false | false | false | true | false | false | false | false | true | true | false | false | POINT (-73.9676424599715 40.7777766106807) | 19 | 4 | 19 | 13 | ||||
2528 | 2528 | -73.9676529780724 | 40.7823206990549 | 21D-PM-1008-03 | 21D | PM | 10082018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9676529780724 40.7823206990549) | 19 | 4 | 19 | 13 | |||||
1593 | 1593 | -73.9676539688726 | 40.7777229934129 | 16F-AM-1008-02 | 16F | AM | 10082018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near fence | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9676539688726 40.7777229934129) | 19 | 4 | 19 | 13 | ||||
978 | 978 | -73.9676692772518 | 40.7764726688908 | 15G-AM-1008-03 | 15G | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9676692772518 40.7764726688908) | 19 | 4 | 19 | 13 | ||||||
1401 | 1401 | -73.9681202146851 | 40.7743979416812 | 13G-PM-1008-04 | 13G | PM | 10082018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | lawn @ edge of landscaped area | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9681202146851 40.7743979416812) | 19 | 4 | 19 | 13 | ||||
1863 | 1863 | -73.9682830510954 | 40.7810151087286 | 19D-PM-1008-03 | 19D | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | may be same squirrel as #1 - male | Above Ground | 5 | on branch of dead tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9682830510954 40.7810151087286) | 19 | 4 | 19 | 13 | |||
2415 | 2415 | -73.9683598086625 | 40.7811150451315 | 19D-PM-1008-01 | 19D | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9683598086625 40.7811150451315) | 19 | 4 | 19 | 13 | |||||
2786 | 2786 | -73.9683883750097 | 40.7754344396847 | 13G-PM-1008-01 | 13G | PM | 10082018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 20 | willow oak tree | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9683883750097 40.7754344396847) | 19 | 4 | 19 | 13 | |||||
1904 | 1904 | -73.9684058476942 | 40.7753959833776 | 13G-PM-1008-02 | 13G | PM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 15 | willow oak tree | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9684058476942 40.7753959833776) | 19 | 4 | 19 | 13 | |||||
695 | 695 | -73.9685080639873 | 40.7745309794155 | 13G-PM-1008-03 | 13G | PM | 10082018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | maple tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9685080639873 40.77453097941551) | 19 | 4 | 19 | 13 | ||||
1778 | 1778 | -73.9685598106128 | 40.7807054868066 | 19D-PM-1008-02 | 19D | PM | 10082018 | 2 | + | unknown - cannot see, only hear | Above Ground | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9685598106128 40.7807054868066) | 19 | 4 | 19 | 13 | ||||||||
749 | 749 | -73.9686304581526 | 40.7773631337117 | 15E-PM-1008-01 | 15E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 4 | on fallen tree | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9686304581526 40.7773631337117) | 19 | 4 | 19 | 13 | |||||
2713 | 2713 | -73.9687214684206 | 40.7792841720164 | 17D-AM-1008-07 | 17D | AM | 10082018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687214684206 40.7792841720164) | 19 | 4 | 19 | 13 | |||||
80 | 80 | -73.9688454483585 | 40.7845301288163 | 22A-AM-1008-05 | 22A | AM | 10082018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 3 | trash can | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9688454483585 40.7845301288163) | 19 | 4 | 19 | 13 | ||||
491 | 491 | -73.9688470831269 | 40.7844651946415 | 22A-AM-1008-03 | 22A | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9688470831269 40.7844651946415) | 19 | 4 | 19 | 13 | ||||||
1153 | 1153 | -73.9688523924488 | 40.7844018035948 | 22A-AM-1008-02 | 22A | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9688523924488 40.7844018035948) | 19 | 4 | 19 | 13 | ||||||
306 | 306 | -73.9689700100267 | 40.7775169562765 | 15E-PM-1008-05 | 15E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | sitting | false | true | false | false | false | false | false | false | POINT (-73.9689700100267 40.7775169562765) | 19 | 4 | 19 | 13 | |||||
2499 | 2499 | -73.9690079924094 | 40.7845473505585 | 22A-AM-1008-06 | 22A | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9690079924094 40.7845473505585) | 19 | 4 | 19 | 13 | ||||||
265 | 265 | -73.9691094942294 | 40.776760392858 | 14E-AM-1008-01 | 14E | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | walking | false | false | false | false | false | false | false | true | POINT (-73.9691094942294 40.776760392858) | 19 | 4 | 19 | 13 | |||||
1222 | 1222 | -73.9691420412059 | 40.7773492582138 | 15E-PM-1008-03 | 15E | PM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | walking | false | false | false | false | false | false | true | false | POINT (-73.9691420412059 40.7773492582138) | 19 | 4 | 19 | 13 | |||||
2020 | 2020 | -73.9691453885964 | 40.7770524089712 | 15E-PM-1008-02 | 15E | PM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9691453885964 40.7770524089712) | 19 | 4 | 19 | 13 | ||||||
1905 | 1905 | -73.9691968748482 | 40.7765862996192 | 14E-AM-1008-14 | 14E | AM | 10082018 | 14 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691968748482 40.7765862996192) | 19 | 4 | 19 | 13 | ||||||
2722 | 2722 | -73.9692271132136 | 40.777528508844 | 15E-PM-1008-04 | 15E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9692271132136 40.777528508844) | 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 );