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, Location, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Runs from, Zip Codes, Community Districts, City Council Districts
Link | rowid | Longitude | Latitude | Unique Squirrel ID | Hectare | Shift | Date | Hectare Squirrel Number | Age | Primary Fur Color | Highlight Fur Color | Combination of Primary and Highlight Color ▼ | Color notes | Location | Above Ground Sighter Measurement | Specific Location | Running | Chasing | Climbing | Eating | Foraging | Other Activities | Kuks | Quaas | Moans | Tail flags | Tail twitches | Approaches | Indifferent | Runs from | Other Interactions | Lat/Long | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | -73.9561344937861 | 40.7940823884086 | 37F-PM-1014-03 | 37F | PM | 10142018 | 3 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
5 | 5 | -73.9593126695714 | 40.797533370163 | 39B-AM-1018-01 | 39B | AM | 10182018 | 1 | + | Above Ground | false | false | false | false | false | unknown | true | false | false | false | false | false | false | false | POINT (-73.9593126695714 40.797533370163) | 19 | 4 | 19 | 13 | ||||||||
92 | 92 | -73.9565759733611 | 40.7992461674802 | 42C-AM-1007-02 | 42C | AM | 10072018 | 2 | + | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9565759733611 40.7992461674802) | 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 | ||||||
455 | 455 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 10192018 | 4 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9688574691102 40.7837825208444) | 19 | 4 | 19 | 13 | ||||||||||
512 | 512 | -73.9586098170241 | 40.7939653733898 | 35D-AM-1019-01 | 35D | AM | 10192018 | 1 | + | Above Ground | on tree, blue jays gathering nearby | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9586098170241 40.7939653733898) | 19 | 4 | 19 | 13 | ||||||||
526 | 526 | -73.9680833729772 | 40.7741871025115 | 12H-PM-1007-08 | 12H | PM | 10072018 | 8 | + | Above Ground | 7 | in tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680833729772 40.7741871025115) | 19 | 4 | 19 | 13 | |||||||
686 | 686 | -73.9695745672033 | 40.7791835122147 | 17D-AM-1008-06 | 17D | AM | 10082018 | 6 | + | Above Ground | high in tree, couldn't see it, only heard it | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9695745672033 40.7791835122147) | 19 | 4 | 19 | 13 | ||||||||
708 | 708 | -73.9592819491968 | 40.7941062008626 | 35C-AM-1007-06 | 35C | AM | 10072018 | 6 | Adult | + | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9592819491968 40.7941062008626) | 19 | 4 | 19 | 13 | |||||||
794 | 794 | -73.9790010565108 | 40.7685732369544 | 2C-PM-1013-09 | 02C | PM | 10132018 | 9 | Adult | + | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9790010565108 40.7685732369544) | 19 | 4 | 19 | 13 | |||||||
861 | 861 | -73.953287300494 | 40.793520326789 | 37H-PM-1006-04 | 37H | PM | 10062018 | 4 | + | Above Ground | 43 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.953287300494 40.793520326789) | 19 | 4 | 19 | 13 | |||||||
867 | 867 | -73.9762257701293 | 40.7744032758323 | 9A-AM-1013-08 | 09A | AM | 10132018 | 8 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9762257701293 40.7744032758323) | 19 | 4 | 19 | 13 | |||||||||
1037 | 1037 | -73.9677409841969 | 40.7763579140639 | 15G-PM-1019-08 | 15G | PM | 10192018 | 8 | Adult | + | Above Ground | 5 | false | true | false | false | false | false | true | true | false | false | false | false | false | POINT (-73.9677409841969 40.7763579140639) | 19 | 4 | 19 | 13 | |||||||
1112 | 1112 | -73.9583934264026 | 40.7854742185504 | 27I-AM-1007-02 | 27I | AM | 10072018 | 2 | + | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9583934264026 40.785474218550405) | 19 | 4 | 19 | 13 | ||||||||||
1244 | 1244 | -73.9565260889843 | 40.7991807924337 | 42C-AM-1007-03 | 42C | AM | 10072018 | 3 | + | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9565260889843 40.79918079243371) | 19 | 4 | 19 | 13 | ||||||||||
1248 | 1248 | -73.9719729323923 | 40.7668318394546 | 4I-AM-1006-03 | 04I | AM | 10062018 | 3 | Adult | + | Can't tell :( | Above Ground | 28 | Tree | false | false | true | false | false | building nest! | false | false | false | false | false | false | false | false | POINT (-73.9719729323923 40.7668318394546) | 19 | 4 | 19 | 13 | ||||
1361 | 1361 | -73.961934398055 | 40.7924789548522 | 33B-PM-1010-07 | 33B | PM | 10102018 | 7 | Adult | + | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.961934398055 40.7924789548522) | 19 | 4 | 19 | 13 | |||||||
1372 | 1372 | -73.9528353702209 | 40.7976456178263 | 41F-PM-1019-02 | 41F | PM | 10192018 | 2 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9528353702209 40.7976456178263) | 19 | 4 | 19 | 13 | ||||||||||
1388 | 1388 | -73.9685709455958 | 40.7744877026506 | 12G-PM-1007-07 | 12G | PM | 10072018 | 7 | Juvenile | + | Above Ground | 45 | false | false | false | true | false | acorns | false | false | false | false | false | false | false | false | POINT (-73.9685709455958 40.7744877026506) | 19 | 4 | 19 | 13 | ||||||
1407 | 1407 | -73.9704778551644 | 40.7783119113627 | 15D-AM-1007-05 | 15D | AM | 10072018 | 5 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9704778551644 40.7783119113627) | 19 | 4 | 19 | 13 | |||||||||
1459 | 1459 | -73.9563847867316 | 40.7906012261163 | 33G-AM-1013-03 | 33G | AM | 10132018 | 3 | ? | + | Only peeked head out | Above Ground | 13 | false | false | false | false | false | peeking out of tree,did *not* come out | false | false | false | false | false | false | false | false | POINT (-73.9563847867316 40.7906012261163) | 19 | 4 | 19 | 13 | |||||
1475 | 1475 | -73.9686778167484 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 10122018 | 4 | + | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.96867781674841 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
1554 | 1554 | -73.9597462612063 | 40.7832801145306 | 25I-PM-1007-06 | 25I | PM | 10072018 | 6 | + | Didn't see squirrel size, or colors | Above Ground | 20 | up in tree | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9597462612063 40.7832801145306) | 19 | 4 | 19 | 13 | ||||||
1607 | 1607 | -73.9770508584979 | 40.7710769301257 | 6C-AM-1007-02 | 06C | AM | 10072018 | 2 | Adult | + | Above Ground | 15 | false | false | true | false | false | pulling things off branches | false | false | false | false | false | false | false | false | POINT (-73.9770508584979 40.7710769301257) | 19 | 4 | 19 | 13 | ||||||
1654 | 1654 | -73.9766342125035 | 40.7715437147052 | 6C-AM-1007-08 | 06C | AM | 10072018 | 8 | Adult | + | Above Ground | 35 | false | false | true | false | false | dropping acorns | false | false | false | false | false | false | false | false | POINT (-73.9766342125035 40.7715437147052) | 19 | 4 | 19 | 13 | ||||||
1688 | 1688 | -73.9677593344667 | 40.7763054313195 | 15G-PM-1019-07 | 15G | PM | 10192018 | 7 | Adult | + | Above Ground | 5 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9677593344667 40.7763054313195) | 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 | ||||||
1764 | 1764 | -73.9534878316472 | 40.7978951981698 | 41F-PM-1019-01 | 41F | PM | 10192018 | 1 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9534878316472 40.7978951981698) | 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 | ||||||||
1842 | 1842 | -73.9532804650089 | 40.7934579333341 | 37H-PM-1006-05 | 37H | PM | 10062018 | 5 | + | Above Ground | tree | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9532804650089 40.7934579333341) | 19 | 4 | 19 | 13 | ||||||||
1931 | 1931 | -73.9533085932603 | 40.7934877861075 | 37H-PM-1006-03 | 37H | PM | 10062018 | 3 | + | Above Ground | 43 | tree | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9533085932603 40.7934877861075) | 19 | 4 | 19 | 13 | |||||||
2028 | 2028 | -73.9687347731861 | 40.7718955594385 | 10H-AM-1014-03 | 10H | AM | 10142018 | 3 | Juvenile | + | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9687347731861 40.7718955594385) | 19 | 4 | 19 | 13 | |||||||
2034 | 2034 | -73.9699135187297 | 40.7782354186163 | 16D-AM-1007-03 | 16D | AM | 10072018 | 3 | Adult | + | ran away before I could take a good look | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9699135187297 40.7782354186163) | 19 | 4 | 19 | 13 | ||||||
2327 | 2327 | -73.9567801028221 | 40.7960096659564 | 38D-AM-1017-01 | 38D | AM | 10172018 | 1 | + | Above Ground | 30 | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9567801028221 40.7960096659564) | 19 | 4 | 19 | 13 | ||||||||
2388 | 2388 | -73.9604476047877 | 40.7938014328732 | 35C-AM-1007-03 | 35C | AM | 10072018 | 3 | Adult | + | Above Ground | 40 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9604476047877 40.7938014328732) | 19 | 4 | 19 | 13 | |||||||
2392 | 2392 | -73.9578981223015 | 40.7989967754358 | 41B-AM-1010-03 | 41B | AM | 10102018 | 3 | Adult | + | Above Ground | 60 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9578981223015 40.7989967754358) | 19 | 4 | 19 | 13 | |||||||
2501 | 2501 | -73.9616944195776 | 40.7927250423024 | 33B-PM-1010-02 | 33B | PM | 10102018 | 2 | Adult | + | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9616944195776 40.7927250423024) | 19 | 4 | 19 | 13 | |||||||
2693 | 2693 | -73.9561498646036 | 40.7949288561893 | 37E-AM-1013-05 | 37E | AM | 10132018 | 5 | ? | + | Above Ground | 10 | unsure, just heard kuks | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9561498646036 40.79492885618931) | 19 | 4 | 19 | 13 | ||||||
2714 | 2714 | -73.9600738985438 | 40.7938328798752 | 35C-PM-1013-08 | 35C | PM | 10132018 | 8 | + | false | false | false | false | false | true | false | false | false | false | false | false | false | did not *see* | POINT (-73.9600738985438 40.7938328798752) | 19 | 4 | 19 | 13 | |||||||||
2754 | 2754 | -73.9687025912431 | 40.7719319822619 | 10H-AM-1014-04 | 10H | AM | 10142018 | 4 | Juvenile | + | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9687025912431 40.7719319822619) | 19 | 4 | 19 | 13 | |||||||
2784 | 2784 | -73.9763722433833 | 40.7744121430891 | 9A-AM-1013-07 | 09A | AM | 10132018 | 7 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9763722433833 40.7744121430891) | 19 | 4 | 19 | 13 | |||||||||
2910 | 2910 | -73.9506062997507 | 40.7976189496674 | 42H-PM-1014-03 | 42H | PM | 10142018 | 3 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9506062997507 40.7976189496674) | 12423 | 18 | 4 | 36 | 18 | ||||||||
42 | 42 | -73.9579564338627 | 40.7959337795027 | 38C-PM-1014-09 | 38C | PM | 10142018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9579564338627 40.7959337795027) | 19 | 4 | 19 | 13 | ||||||
227 | 227 | -73.9598155300913 | 40.7905887826983 | 32E-AM-1007-10 | 32E | AM | 10072018 | 10 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9598155300913 40.7905887826983) | 19 | 4 | 19 | 13 | ||||||
325 | 325 | -73.9630990823243 | 40.7885764284016 | 28D-AM-1012-02 | 28D | AM | 10122018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9630990823243 40.7885764284016) | 19 | 4 | 19 | 13 | ||||||
388 | 388 | -73.9592537496995 | 40.7919271821316 | 33E-AM-1014-03 | 33E | AM | 10142018 | 3 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9592537496995 40.7919271821316) | 19 | 4 | 19 | 13 | ||||||
497 | 497 | -73.9602166876979 | 40.7953811003986 | 36B-AM-1013-04 | 36B | AM | 10132018 | 4 | Black | Black+ | Above Ground | 20 | Moved 20+ feet high above top of tree limb | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9602166876979 40.7953811003986) | 19 | 4 | 19 | 13 | ||||||
593 | 593 | -73.9593352806175 | 40.7918150568046 | 33E-AM-1014-02 | 33E | AM | 10142018 | 2 | Juvenile | Black | Black+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9593352806175 40.7918150568046) | 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 | |||||
691 | 691 | -73.9695964983454 | 40.7802302192799 | 18C-PM-1018-08 | 18C | PM | 10182018 | 8 | Juvenile | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9695964983454 40.7802302192799) | 19 | 4 | 19 | 13 | ||||||
721 | 721 | -73.9718262034469 | 40.7666771797442 | 4I-PM-1007-02 | 04I | PM | 10072018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9718262034469 40.7666771797442) | 19 | 4 | 19 | 13 | ||||||
755 | 755 | -73.9579941847434 | 40.7991216713328 | 41B-PM-1014-02 | 41B | PM | 10142018 | 2 | Adult | Black | Black+ | Above Ground | 28 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9579941847434 40.7991216713328) | 19 | 4 | 19 | 13 | ||||||
872 | 872 | -73.9551524422379 | 40.7910535596756 | 34H-PM-1006-01 | 34H | PM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9551524422379 40.7910535596756) | 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 | |||||
1149 | 1149 | -73.960237785199 | 40.7907831607574 | 32E-PM-1017-16 | 32E | PM | 10172018 | 16 | Adult | Black | Black+ | Ground Plane | FALSE | rocky outcrop | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.960237785199 40.7907831607574) | 19 | 4 | 19 | 13 | |||||
1232 | 1232 | -73.9589254878322 | 40.7914467650712 | 33E-PM-1012-09 | 33E | PM | 10122018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9589254878322 40.7914467650712) | 19 | 4 | 19 | 13 | ||||||
1261 | 1261 | -73.9719109949232 | 40.7723138521327 | 9F-AM-1013-01 | 09F | AM | 10132018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9719109949232 40.7723138521327) | 19 | 4 | 19 | 13 | ||||||
1267 | 1267 | -73.9701010964667 | 40.7688919314508 | 6I-PM-1013-02 | 06I | PM | 10132018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | Bushes | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9701010964667 40.76889193145081) | 19 | 4 | 19 | 13 | |||||
1486 | 1486 | -73.9545807749923 | 40.7900507537649 | 33I-PM-1006-02 | 33I | PM | 10062018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9545807749923 40.7900507537649) | 19 | 4 | 19 | 13 | ||||||
1833 | 1833 | -73.962516494651 | 40.7884768989902 | 28D-PM-1019-02 | 28D | PM | 10192018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.962516494651 40.7884768989902) | 19 | 4 | 19 | 13 | ||||||
1845 | 1845 | -73.9626560807032 | 40.7884633049896 | 28D-AM-1012-05 | 28D | AM | 10122018 | 5 | Juvenile | Black | Black+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9626560807032 40.7884633049896) | 19 | 4 | 19 | 13 | ||||||
1887 | 1887 | -73.9586184232889 | 40.7993153832942 | 41A-PM-1007-02 | 41A | PM | 10072018 | 2 | Adult | Black | Black+ | Above Ground | 15 | false | false | true | false | false | jumping | false | false | false | false | false | false | false | false | stared at me | POINT (-73.9586184232889 40.7993153832942) | 19 | 4 | 19 | 13 | ||||
1938 | 1938 | -73.9719879697272 | 40.7725625124591 | 9F-AM-1013-02 | 09F | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9719879697272 40.7725625124591) | 19 | 4 | 19 | 13 | ||||||
2150 | 2150 | -73.9557710118271 | 40.7919161185557 | 34G-PM-1006-01 | 34G | PM | 10062018 | 1 | Adult | Black | Black+ | Skinny, thin tail | Ground Plane | FALSE | false | false | false | false | false | digging | false | false | false | false | false | false | false | false | POINT (-73.9557710118271 40.7919161185557) | 19 | 4 | 19 | 13 | ||||
2206 | 2206 | -73.9594446018346 | 40.7917800352042 | 33D-AM-1017-06 | 33D | AM | 10172018 | 6 | Adult | Black | Black+ | Above Ground | 10 | false | false | true | false | false | true | true | false | false | false | false | false | true | runs from (ran into hole in tree trunk) | POINT (-73.9594446018346 40.7917800352042) | 19 | 4 | 19 | 13 | |||||
2284 | 2284 | -73.9730181306326 | 40.7794601322427 | 16A-AM-1013-02 | 16A | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9730181306326 40.7794601322427) | 19 | 4 | 19 | 13 | |||||||
2322 | 2322 | -73.9723677854798 | 40.7667315410871 | 3H-AM-1008-04 | 03H | AM | 10082018 | 4 | Adult | Black | Black+ | Above Ground | 50 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9723677854798 40.7667315410871) | 19 | 4 | 19 | 13 | ||||||
2449 | 2449 | -73.9599911537509 | 40.7914452542845 | 33D-AM-1017-04 | 33D | AM | 10172018 | 4 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9599911537509 40.7914452542845) | 19 | 4 | 19 | 13 | ||||||
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 | ||||||
2817 | 2817 | -73.9596445861554 | 40.7971948679007 | 38A-PM-1013-05 | 38A | PM | 10132018 | 5 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9596445861554 40.7971948679007) | 19 | 4 | 19 | 13 | ||||||
210 | 210 | -73.9711298491132 | 40.7676902603543 | 5I-PM-1008-01 | 05I | PM | 10082018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 15 | in tree by arsenal - climbing | false | false | true | true | false | false | false | false | true | false | false | false | false | POINT (-73.9711298491132 40.7676902603543) | 19 | 4 | 19 | 13 | ||||
430 | 430 | -73.9710116801402 | 40.7723689301989 | 10G-PM-1017-08 | 10G | PM | 10172018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9710116801402 40.7723689301989) | 19 | 4 | 19 | 13 | |||||
1057 | 1057 | -73.9594406225891 | 40.7918533707789 | 33D-AM-1017-02 | 33D | AM | 10172018 | 2 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | true | false | false | POINT (-73.9594406225891 40.7918533707789) | 19 | 4 | 19 | 13 | |||||
1392 | 1392 | -73.9648090698176 | 40.7903882097837 | 29A-PM-1019-03 | 29A | PM | 10192018 | 3 | Juvenile | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | true | false | true | ran from,but now approaching. kind of weirding me out. | POINT (-73.9648090698176 40.7903882097837) | 19 | 4 | 19 | 13 | ||||
1892 | 1892 | -73.9745908987975 | 40.7655191512308 | 1G-AM-1006-03 | 01G | AM | 10062018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9745908987975 40.7655191512308) | 19 | 4 | 19 | 13 | |||||
2159 | 2159 | -73.9696688162449 | 40.7741422177187 | 12F-AM-1020-05 | 12F | AM | 10202018 | 5 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.9696688162449 40.7741422177187) | 19 | 4 | 19 | 13 | |||||
2975 | 2975 | -73.959412243507 | 40.7917871123534 | 33E-AM-1014-01 | 33E | AM | 10142018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | digging | false | false | false | false | false | false | false | true | POINT (-73.959412243507 40.7917871123534) | 19 | 4 | 19 | 13 | ||||
2879 | 2879 | -73.9744080700098 | 40.7731515721826 | 9C-PM-1006-07 | 09C | PM | 10062018 | 7 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | on top of tarped sand pile | false | false | false | true | false | false | false | false | false | false | false | false | true | (me) | POINT (-73.9744080700098 40.7731515721826) | 19 | 4 | 19 | 13 | |||
391 | 391 | -73.9790875480358 | 40.7676104780657 | 2C-AM-1010-03 | 02C | AM | 10102018 | 3 | Adult | Black | Gray | Black+Gray | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9790875480358 40.7676104780657) | 19 | 4 | 19 | 13 | |||||
1296 | 1296 | -73.9705509170542 | 40.7689416540228 | 6I-PM-1013-04 | 06I | PM | 10132018 | 4 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Grass | false | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.9705509170542 40.7689416540228) | 19 | 4 | 19 | 13 | ||||
2467 | 2467 | -73.9755923256429 | 40.7672967972471 | 3F-PM-1013-02 | 03F | PM | 10132018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.97559232564292 40.7672967972471) | 19 | 4 | 19 | 13 | |||||
2496 | 2496 | -73.9696274291417 | 40.7691980808067 | 7I-PM-1013-03 | 07I | PM | 10132018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Trash bins | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9696274291417 40.7691980808067) | 19 | 4 | 19 | 13 | ||||
2651 | 2651 | -73.9632993246327 | 40.7888199519656 | 29C-AM-1007-05 | 29C | AM | 10072018 | 5 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9632993246327 40.7888199519656) | 19 | 4 | 19 | 13 | |||||
1345 | 1345 | -73.9581326554206 | 40.7918074743129 | 34E-PM-1006-02 | 34E | PM | 10062018 | 2 | Juvenile | Black | Gray, White | Black+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9581326554206 40.7918074743129) | 19 | 4 | 19 | 13 | |||||
88 | 88 | -73.9683608295976 | 40.7842927405327 | 22B-AM-1013-04 | 22B | AM | 10132018 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Under bench | false | false | false | false | true | false | false | false | false | false | false | false | true | ran from dog-walker | POINT (-73.9683608295976 40.7842927405327) | 19 | 4 | 19 | 13 | ||||
254 | 254 | -73.9762246600197 | 40.775164077652 | 10A-AM-1006-03 | 10A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Bridle Path lawn | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9762246600197 40.775164077652) | 19 | 4 | 19 | 13 | |||||
397 | 397 | -73.9690416961886 | 40.7716618670996 | 10H-AM-1014-05 | 10H | AM | 10142018 | 5 | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9690416961886 40.7716618670996) | 19 | 4 | 19 | 13 | |||||||
412 | 412 | -73.9785675798034 | 40.7672992405289 | 1C-PM-1013-05 | 01C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9785675798034 40.7672992405289) | 19 | 4 | 19 | 13 | ||||||
461 | 461 | -73.9648195433192 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | staring | false | false | false | false | true | false | false | false | POINT (-73.9648195433192 40.7796399955868) | 19 | 4 | 19 | 13 | |||||
509 | 509 | -73.9714289592392 | 40.7750670702093 | 12E-PM-1018-04 | 12E | PM | 10182018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9714289592392 40.7750670702093) | 19 | 4 | 19 | 13 | ||||||
850 | 850 | -73.9642288873015 | 40.7820439983567 | 22F-AM-1007-06 | 22F | AM | 10072018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9642288873015 40.7820439983567) | 19 | 4 | 19 | 13 | ||||||
954 | 954 | -73.9658443548822 | 40.7796704898979 | 19F-AM-1007-03 | 19F | AM | 10072018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | scared | POINT (-73.9658443548822 40.7796704898979) | 19 | 4 | 19 | 13 | |||||
1038 | 1038 | -73.9563311167069 | 40.7950901563337 | 38E-AM-1010-12 | 38E | AM | 10102018 | 12 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | running on rocks | false | true | false | false | false | false | false | false | true | false | false | false | false | runs toward something | POINT (-73.9563311167069 40.7950901563337) | 19 | 4 | 19 | 13 | ||||
1138 | 1138 | -73.9594357049738 | 40.7840678890949 | 25I-AM-1012-01 | 25I | AM | 10122018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | on bar | false | false | false | true | false | false | false | false | true | true | true | false | false | POINT (-73.9594357049738 40.7840678890949) | 19 | 4 | 19 | 13 | |||||
1230 | 1230 | -73.9790822606486 | 40.7714466633386 | 5A-AM-1006-03 | 05A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 8 | false | false | true | true | false | false | false | false | true | false | false | false | true | POINT (-73.9790822606486 40.7714466633386) | 19 | 4 | 19 | 13 | ||||||
1369 | 1369 | -73.9702717260829 | 40.768951107763 | 6I-PM-1013-03 | 06I | PM | 10132018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Flowers, grass | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9702717260829 40.768951107763) | 19 | 4 | 19 | 13 | |||||
1379 | 1379 | -73.9796470494747 | 40.7678370925485 | 1C-PM-1013-08 | 01C | PM | 10132018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9796470494747 40.7678370925485) | 19 | 4 | 19 | 13 | ||||||
1543 | 1543 | -73.9713906492842 | 40.7750061310143 | 12E-PM-1018-03 | 12E | PM | 10182018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9713906492842 40.7750061310143) | 19 | 4 | 19 | 13 | ||||||
2165 | 2165 | -73.9794371709817 | 40.768387910254 | 2B-PM-1013-07 | 02B | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9794371709817 40.768387910254) | 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 |
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 );