This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1125 | 1125 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | on stone arch | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9775735077285 40.7692872082165) | 19 | 4 | 19 | 13 | ||||
186 | 186 | -73.9788138172962 | 40.7693001754769 | 3B-AM-1010-09 | 03B | AM | 10102018 | 9 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9788138172962 40.7693001754769) | 19 | 4 | 19 | 13 | ||||||
2889 | 2889 | -73.9771646835311 | 40.7693049165084 | 4C-PM-1010-05 | 04C | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9771646835311 40.7693049165084) | 19 | 4 | 19 | 13 | |||||
2944 | 2944 | -73.9739403850622 | 40.7693162287509 | 5F-AM-1007-05 | 05F | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 2 | tree | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9739403850622 40.7693162287509) | 19 | 4 | 19 | 13 | ||||
658 | 658 | -73.9704575848926 | 40.7693499326095 | 7H-PM-1006-09 | 07H | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | by tree | false | false | false | true | true | false | false | false | true | false | true | false | true | POINT (-73.9704575848926 40.7693499326095) | 19 | 4 | 19 | 13 | |||||
1871 | 1871 | -73.9748367344424 | 40.7693513000034 | 5E-PM-1012-06 | 05E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | oak tree at end of ramp from Chess House | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9748367344424 40.7693513000034) | 19 | 4 | 19 | 13 | ||||
2403 | 2403 | -73.9777879635216 | 40.769359455673 | 4C-AM-1006-03 | 04C | AM | 10062018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9777879635216 40.769359455673) | 19 | 4 | 19 | 13 | ||||||
126 | 126 | -73.9792155473689 | 40.7693711799946 | 3B-PM-1007-11 | 03B | PM | 10072018 | 11 | Adult | Gray | Gray+ | Above Ground | 5 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9792155473689 40.7693711799946) | 19 | 4 | 19 | 13 | |||||
813 | 813 | -73.9758959798289 | 40.7694125671679 | 4D-PM-1008-01 | 04D | PM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9758959798289 40.7694125671679) | 19 | 4 | 19 | 13 | |||||
897 | 897 | -73.9734687538064 | 40.7694308959222 | 6F-PM-1008-04 | 06F | PM | 10082018 | 4 | Adult | Cinnamon | White | Cinnamon+White | patches of white on haunches | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9734687538064 40.7694308959222) | 19 | 4 | 19 | 13 | ||||
416 | 416 | -73.9702788578386 | 40.7694484997295 | 7I-PM-1013-05 | 07I | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Rock | false | false | false | true | false | false | false | false | true | false | false | false | false | POINT (-73.9702788578386 40.7694484997295) | 19 | 4 | 19 | 13 | ||||
303 | 303 | -73.9762348224648 | 40.7694522315322 | 4D-PM-1008-08 | 04D | PM | 10082018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | true | true | climbed fence staring at me - went up tree | false | false | false | false | false | false | false | true | POINT (-73.97623482246482 40.7694522315322) | 19 | 4 | 19 | 13 | ||||
1202 | 1202 | -73.9694979297007 | 40.7694667408721 | 7I-PM-1013-02 | 07I | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Construction materials | true | false | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9694979297007 40.7694667408721) | 19 | 4 | 19 | 13 | ||||
2633 | 2633 | -73.9776151109912 | 40.7694681558386 | 4C-PM-1010-09 | 04C | PM | 10102018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9776151109912 40.7694681558386) | 19 | 4 | 19 | 13 | |||||
151 | 151 | -73.9714789136757 | 40.7694886645194 | 6H-AM-1008-01 | 06H | AM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9714789136757 40.7694886645194) | 19 | 4 | 19 | 13 | |||||
1755 | 1755 | -73.9714798196777 | 40.7695231949631 | 6H-PM-1020-02 | 06H | PM | 10202018 | 2 | Adult | + | Above Ground | Fence pole | false | false | true | false | false | false | false | false | false | false | false | false | true | runs from (me) | POINT (-73.9714798196777 40.7695231949631) | 19 | 4 | 19 | 13 | ||||||
1636 | 1636 | -73.9701408623121 | 40.7695511718541 | 7I-PM-1013-04 | 07I | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | Grass | true | false | false | true | false | false | false | false | true | false | false | false | false | POINT (-73.9701408623121 40.7695511718541) | 19 | 4 | 19 | 13 | ||||
820 | 820 | -73.9801902133148 | 40.769557595068 | 3A-AM-1012-03 | 03A | AM | 10122018 | 3 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Above Ground | 1 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9801902133148 40.769557595068) | 19 | 4 | 19 | 13 | ||||
962 | 962 | -73.9715466850324 | 40.7695584933538 | 6H-PM-1020-03 | 06H | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | runs from (kids kicking the fence) | POINT (-73.9715466850324 40.7695584933538) | 19 | 4 | 19 | 13 | |||
2574 | 2574 | -73.978199543688 | 40.7695660563362 | 4C-PM-1010-17 | 04C | PM | 10102018 | 17 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | climbed up tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.978199543688 40.7695660563362) | 19 | 4 | 19 | 13 | ||||
1712 | 1712 | -73.9801899519657 | 40.7695777009264 | 3A-PM-1017-02 | 03A | PM | 10172018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9801899519657 40.7695777009264) | 19 | 4 | 19 | 13 | |||||
1996 | 1996 | -73.977641787698 | 40.7695830265784 | 4C-PM-1010-10 | 04C | PM | 10102018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.977641787698 40.7695830265784) | 19 | 4 | 19 | 13 | |||||
1799 | 1799 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 10102018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | false | true | false | false | false | chasing squirrel #6 | true | true | false | false | true | false | false | false | POINT (-73.978844141973 40.7696046074378) | 19 | 4 | 19 | 13 | ||||
2624 | 2624 | -73.9706308500637 | 40.7696174874596 | 7H-PM-1006-10 | 07H | PM | 10062018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9706308500637 40.7696174874596) | 19 | 4 | 19 | 13 | ||||||
2610 | 2610 | -73.9713379914423 | 40.7696367609606 | 7H-PM-1006-01 | 07H | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | middle of grass | false | false | false | true | true | false | false | false | false | true | true | false | false | POINT (-73.9713379914423 40.7696367609606) | 19 | 4 | 19 | 13 | ||||
2640 | 2640 | -73.9788304714091 | 40.7696373635315 | 4B-AM-1010-06 | 04B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Above Ground | 12 | true | false | false | false | false | running from squirrel #5 | false | false | false | false | false | false | false | false | POINT (-73.9788304714091 40.7696373635315) | 19 | 4 | 19 | 13 | |||||
3023 | 3023 | -73.9754794191553 | 40.7696404489025 | 5E-PM-1012-01 | 05E | PM | 10122018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9754794191553 40.7696404489025) | 19 | 4 | 19 | 13 | |||||
198 | 198 | -73.9761107065353 | 40.769642060286 | 5D-AM-1020-01 | 05D | AM | 10202018 | 1 | Adult | + | Too far & cloudy to tell | Above Ground | 30 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9761107065353 40.769642060286) | 19 | 4 | 19 | 13 | ||||||
2453 | 2453 | -73.9756105226696 | 40.7696531972655 | 5D-AM-1020-03 | 05D | AM | 10202018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9756105226696 40.7696531972655) | 19 | 4 | 19 | 13 | |||||
2535 | 2535 | -73.9700101107283 | 40.7696729501144 | 7I-PM-1013-08 | 07I | PM | 10132018 | 8 | Adult | Black | Black+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.9700101107283 40.7696729501144) | 19 | 4 | 19 | 13 | ||||||
70 | 70 | -73.9804528867547 | 40.7696753655986 | 3A-PM-1017-05 | 03A | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9804528867547 40.76967536559861) | 19 | 4 | 19 | 13 | |||||
579 | 579 | -73.9786714207307 | 40.7696870806229 | 4B-PM-1018-01 | 04B | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9786714207307 40.7696870806229) | 19 | 4 | 19 | 13 | ||||||
1106 | 1106 | -73.9702970919317 | 40.7696883113413 | 7H-PM-1006-08 | 07H | PM | 10062018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass | false | false | false | false | true | false | false | false | false | true | true | false | true | POINT (-73.9702970919317 40.7696883113413) | 19 | 4 | 19 | 13 | ||||
2274 | 2274 | -73.9698044218476 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | false | false | false | true | false | playing,interacting with #7 | false | false | false | false | true | false | false | true | POINT (-73.9698044218476 40.7697007833531) | 19 | 4 | 19 | 13 | |||
4 | 4 | -73.9757249834141 | 40.7697032606755 | 5D-PM-1018-05 | 05D | PM | 10182018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9757249834141 40.7697032606755) | 19 | 4 | 19 | 13 | ||||||
1797 | 1797 | -73.9697178096275 | 40.7697036696301 | 7I-PM-1013-07 | 07I | PM | 10132018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | Under the tree | false | true | false | false | false | playing,interacting with #6 | false | false | false | false | true | false | false | false | POINT (-73.9697178096275 40.769703669630104) | 19 | 4 | 19 | 13 | |||
1474 | 1474 | -73.9801971465604 | 40.7697081749827 | 3A-PM-1017-04 | 03A | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9801971465604 40.7697081749827) | 19 | 4 | 19 | 13 | |||||
2644 | 2644 | -73.9775445441194 | 40.7697096533728 | 4C-PM-1010-13 | 04C | PM | 10102018 | 13 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9775445441194 40.7697096533728) | 19 | 4 | 19 | 13 | |||||
678 | 678 | -73.977447585355 | 40.7697167828003 | 4C-PM-1010-11 | 04C | PM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.977447585355 40.7697167828003) | 19 | 4 | 19 | 13 | |||||
266 | 266 | -73.9786481009499 | 40.7697372811949 | 4B-PM-1018-03 | 04B | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9786481009499 40.7697372811949) | 19 | 4 | 19 | 13 | ||||||
1597 | 1597 | -73.9789401448556 | 40.7697373141498 | 4B-AM-1010-04 | 04B | AM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9789401448556 40.7697373141498) | 19 | 4 | 19 | 13 | |||||
882 | 882 | -73.9786805884996 | 40.7697559231927 | 4B-PM-1018-02 | 04B | PM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9786805884996 40.7697559231927) | 19 | 4 | 19 | 13 | ||||||
2428 | 2428 | -73.9755643404768 | 40.7697569149388 | 5E-PM-1012-03 | 05E | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9755643404768 40.7697569149388) | 19 | 4 | 19 | 13 | |||||
1822 | 1822 | -73.9775099290913 | 40.7697609063137 | 4C-PM-1010-14 | 04C | PM | 10102018 | 14 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | true | false | false | false | chasing #15 | false | false | false | false | false | false | false | false | POINT (-73.9775099290913 40.7697609063137) | 19 | 4 | 19 | 13 | ||||
435 | 435 | -73.9702963056917 | 40.7697928730791 | 7H-AM-1006-11 | 07H | AM | 10062018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9702963056917 40.7697928730791) | 19 | 4 | 19 | 13 | |||||
651 | 651 | -73.9801661903932 | 40.7697950141751 | 3A-PM-1017-03 | 03A | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9801661903932 40.7697950141751) | 19 | 4 | 19 | 13 | |||||
677 | 677 | -73.9799155966086 | 40.7698034314993 | 3A-PM-1017-08 | 03A | PM | 10172018 | 8 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9799155966086 40.7698034314993) | 19 | 4 | 19 | 13 | |||||
1567 | 1567 | -73.9774407362587 | 40.7698056129554 | 4C-PM-1010-12 | 04C | PM | 10102018 | 12 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9774407362587 40.7698056129554) | 19 | 4 | 19 | 13 | |||||
1285 | 1285 | -73.9705115189429 | 40.7698395577068 | 7H-AM-1006-08 | 07H | AM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9705115189429 40.7698395577068) | 19 | 4 | 19 | 13 | |||||
2821 | 2821 | -73.9754536566013 | 40.7698604918771 | 5E-PM-1012-04 | 05E | PM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9754536566013 40.7698604918771) | 19 | 4 | 19 | 13 | |||||
61 | 61 | -73.9797084866613 | 40.7698885241349 | 3A-PM-1017-06 | 03A | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9797084866613 40.7698885241349) | 19 | 4 | 19 | 13 | |||||
1033 | 1033 | -73.975673607467 | 40.7699044294204 | 5D-PM-1018-01 | 05D | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.975673607467 40.7699044294204) | 19 | 4 | 19 | 13 | ||||||
476 | 476 | -73.9690968160819 | 40.769923269444 | 8I-AM-1006-08 | 08I | AM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | tree | false | false | false | false | false | true | true | false | false | false | false | false | false | not backing down | POINT (-73.9690968160819 40.769923269444) | 19 | 4 | 19 | 13 | |||
1215 | 1215 | -73.9728895595977 | 40.7699378332299 | 6F-AM-1006-01 | 06F | AM | 10062018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9728895595977 40.7699378332299) | 19 | 4 | 19 | 13 | |||||
2024 | 2024 | -73.9722472286151 | 40.7699550476176 | 6G-PM-1020-04 | 06G | PM | 10202018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9722472286151 40.7699550476176) | 19 | 4 | 19 | 13 | ||||||
1557 | 1557 | -73.9705331808443 | 40.7699943571296 | 7H-AM-1006-09 | 07H | AM | 10062018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9705331808443 40.7699943571296) | 19 | 4 | 19 | 13 | |||||||
2393 | 2393 | -73.9729190572117 | 40.770018150905 | 6F-PM-1008-03 | 06F | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | top of tree | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9729190572117 40.770018150905) | 19 | 4 | 19 | 13 | |||||
2595 | 2595 | -73.9692676659807 | 40.7700678919108 | 8I-PM-1013-08 | 08I | PM | 10132018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.96926766598071 40.7700678919108) | 19 | 4 | 19 | 13 | |||||
138 | 138 | -73.9721442939797 | 40.7700750802317 | 7G-PM-1018-03 | 07G | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9721442939797 40.7700750802317) | 19 | 4 | 19 | 13 | ||||||
1132 | 1132 | -73.9798390387307 | 40.7700761090896 | 3A-PM-1017-07 | 03A | PM | 10172018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9798390387307 40.7700761090896) | 19 | 4 | 19 | 13 | |||||
2756 | 2756 | -73.9787312025627 | 40.7701071405918 | 4B-PM-1018-04 | 04B | PM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9787312025627 40.7701071405918) | 19 | 4 | 19 | 13 | ||||||
1720 | 1720 | -73.9725844658514 | 40.7701092834201 | 7F-PM-1012-02 | 07F | PM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | observes | POINT (-73.9725844658514 40.7701092834201) | 19 | 4 | 19 | 13 | ||||
697 | 697 | -73.970465600402 | 40.7701125773248 | 7H-PM-1006-05 | 07H | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ran across path to eat behind fence, next to the fence. | true | false | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.970465600402 40.7701125773248) | 19 | 4 | 19 | 13 | ||||
144 | 144 | -73.9730750601212 | 40.7701304211944 | 6F-PM-1008-01 | 06F | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9730750601212 40.7701304211944) | 19 | 4 | 19 | 13 | |||||
1960 | 1960 | -73.9730158913661 | 40.7701310707272 | 6F-PM-1008-02 | 06F | PM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | true | true | false | false | false | chasing #2 | false | false | false | false | false | false | false | false | POINT (-73.9730158913661 40.7701310707272) | 19 | 4 | 19 | 13 | ||||
110 | 110 | -73.9711318790279 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9711318790279 40.7701941550273) | 19 | 4 | 19 | 13 | ||||||
870 | 870 | -73.9718720403657 | 40.7702335056337 | 7G-PM-1018-04 | 07G | PM | 10182018 | 4 | 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.9718720403657 40.7702335056337) | 19 | 4 | 19 | 13 | |||||
2529 | 2529 | -73.9800271487863 | 40.7702554167042 | 4A-PM-1007-06 | 04A | PM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | A rock | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9800271487863 40.7702554167042) | 19 | 4 | 19 | 13 | ||||
341 | 341 | -73.9703161745884 | 40.7702610461336 | 8H-PM-1014-05 | 08H | PM | 10142018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9703161745884 40.7702610461336) | 19 | 4 | 19 | 13 | ||||||
19 | 19 | -73.9768603630674 | 40.7702795904962 | 5C-PM-1010-09 | 05C | PM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9768603630674 40.7702795904962) | 19 | 4 | 19 | 13 | |||||
627 | 627 | -73.9763791121438 | 40.770281512254 | 5D-PM-1018-04 | 05D | PM | 10182018 | 4 | Adult | Gray | White | Gray+White | Partial missing tail | Ground Plane | FALSE | false | true | false | false | false | chasing (dog chasing) | false | false | false | false | false | false | false | true | POINT (-73.9763791121438 40.770281512254) | 19 | 4 | 19 | 13 | |||
1814 | 1814 | -73.9722359401242 | 40.7702891474555 | 7G-AM-1010-07 | 07G | AM | 10102018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9722359401242 40.7702891474555) | 19 | 4 | 19 | 13 | |||||
250 | 250 | -73.9726747666002 | 40.7703022669308 | 7F-AM-1008-02 | 07F | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | see stories and locations | POINT (-73.9726747666002 40.7703022669308) | 19 | 4 | 19 | 13 | ||||
1434 | 1434 | -73.9760749752948 | 40.7703284894392 | 5D-PM-1018-02 | 05D | PM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | On low fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9760749752948 40.7703284894392) | 19 | 4 | 19 | 13 | |||||
3016 | 3016 | -73.9756457597888 | 40.7703559775625 | 6D-PM-1020-02 | 06D | PM | 10202018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9756457597888 40.7703559775625) | 19 | 4 | 19 | 13 | ||||||
241 | 241 | -73.9760256477558 | 40.7703573131398 | 5D-AM-1020-02 | 05D | AM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | small jumps | false | false | false | false | false | false | false | false | POINT (-73.9760256477558 40.7703573131398) | 19 | 4 | 19 | 13 | ||||
2765 | 2765 | -73.971525123573 | 40.7703685359842 | 7G-PM-1018-06 | 07G | PM | 10182018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | grooming | false | false | false | false | false | false | false | false | POINT (-73.971525123573 40.7703685359842) | 19 | 4 | 19 | 13 | ||||
202 | 202 | -73.9718729101676 | 40.7703692621371 | 7G-PM-1018-05 | 07G | PM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9718729101676 40.7703692621371) | 19 | 4 | 19 | 13 | ||||||
903 | 903 | -73.9719941577406 | 40.77037129313 | 7G-AM-1010-04 | 07G | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9719941577406 40.77037129313) | 19 | 4 | 19 | 13 | ||||||
2131 | 2131 | -73.9752225195115 | 40.7703747669865 | 6D-PM-1020-05 | 06D | PM | 10202018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9752225195115 40.7703747669865) | 19 | 4 | 19 | 13 | ||||||
1788 | 1788 | -73.9685567075413 | 40.7703797723105 | 8I-AM-1006-10 | 08I | AM | 10062018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | bush | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.96855670754131 40.7703797723105) | 19 | 4 | 19 | 13 | ||||
2207 | 2207 | -73.9748943397482 | 40.7703992564272 | 6E-AM-1014-01 | 06E | AM | 10142018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9748943397482 40.7703992564272) | 19 | 4 | 19 | 13 | |||||
572 | 572 | -73.9763622269272 | 40.7704671295941 | 5C-PM-1010-10 | 05C | PM | 10102018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | fed by woman | POINT (-73.9763622269272 40.7704671295941) | 19 | 4 | 19 | 13 | ||||
666 | 666 | -73.9687027782726 | 40.7705162616199 | 9I-AM-1014-09 | 09I | AM | 10142018 | 9 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.96870277827261 40.7705162616199) | 19 | 4 | 19 | 13 | ||||||
111 | 111 | -73.9763243383771 | 40.7705409315703 | 5C-PM-1010-13 | 05C | PM | 10102018 | 13 | Adult | Gray | White | Gray+White | Above Ground | 20 | way up a tree! | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9763243383771 40.7705409315703) | 19 | 4 | 19 | 13 | ||||
2827 | 2827 | -73.9778578822323 | 40.7705432705286 | 5B-PM-1013-03 | 05B | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | grooming | false | false | false | false | false | false | false | false | POINT (-73.9778578822323 40.7705432705286) | 19 | 4 | 19 | 13 | |||||
356 | 356 | -73.9761036400144 | 40.7705482684594 | 6D-PM-1020-03 | 06D | PM | 10202018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9761036400144 40.7705482684594) | 19 | 4 | 19 | 13 | ||||||
1158 | 1158 | -73.9763894759543 | 40.7705523372364 | 5C-PM-1010-12 | 05C | PM | 10102018 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9763894759543 40.7705523372364) | 19 | 4 | 19 | 13 | |||||
1335 | 1335 | -73.969560591279 | 40.7705619840715 | 8I-AM-1006-09 | 08I | AM | 10062018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | very curious,looked like it expected food | POINT (-73.969560591279 40.7705619840715) | 19 | 4 | 19 | 13 | ||||
1259 | 1259 | -73.976864402584 | 40.7705663751959 | 5C-PM-1010-05 | 05C | PM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.976864402584 40.7705663751959) | 19 | 4 | 19 | 13 | |||||
2152 | 2152 | -73.9686925781295 | 40.7705688673142 | 9I-PM-1010-05 | 09I | PM | 10102018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9686925781295 40.7705688673142) | 19 | 4 | 19 | 13 | |||||
1599 | 1599 | -73.9782603348665 | 40.7705790257951 | 5B-PM-1013-06 | 05B | PM | 10132018 | 6 | Adult | Gray | Gray+ | Above Ground | 5 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9782603348665 40.7705790257951) | 19 | 4 | 19 | 13 | ||||||
2551 | 2551 | -73.970138810251 | 40.770579297644 | 8H-PM-1014-02 | 08H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | froze & watched me,then went back to eating | POINT (-73.970138810251 40.770579297644) | 19 | 4 | 19 | 13 | ||||
1726 | 1726 | -73.9686479277215 | 40.7705815354769 | 9I-AM-1014-08 | 09I | AM | 10142018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9686479277215 40.7705815354769) | 19 | 4 | 19 | 13 | |||||
625 | 625 | -73.9764235373322 | 40.770606513989 | 5C-PM-1010-11 | 05C | PM | 10102018 | 11 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.97642353733221 40.770606513989) | 19 | 4 | 19 | 13 | |||||
2450 | 2450 | -73.9756273257684 | 40.7706539186221 | 6D-AM-1008-04 | 06D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9756273257684 40.7706539186221) | 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 | |||||
838 | 838 | -73.9691031094688 | 40.7706693835189 | 9I-AM-1014-02 | 09I | AM | 10142018 | 2 | Adult | Gray | Gray+ | Very far, so appx | Above Ground | 35 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9691031094688 40.7706693835189) | 19 | 4 | 19 | 13 | |||||
2044 | 2044 | -73.9771552326199 | 40.7706917595308 | 5C-AM-1006-01 | 05C | AM | 10062018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | true | false | false | POINT (-73.9771552326199 40.7706917595308) | 19 | 4 | 19 | 13 | |||||
2587 | 2587 | -73.9789971286844 | 40.7707024146365 | 5A-PM-1010-04 | 05A | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9789971286844 40.7707024146365) | 19 | 4 | 19 | 13 |
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 );