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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | |||||
2647 | 2647 | -73.954499539822 | 40.7949716693686 | 38F-AM-1018-01 | 38F | AM | 10182018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.954499539822 40.7949716693686) | 19 | 4 | 19 | 13 | |||||
27 | 27 | -73.9670628558161 | 40.7734991420941 | 12I-AM-1013-01 | 12I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on tree roots | false | false | false | false | false | sitting | false | false | false | false | true | false | false | true | POINT (-73.9670628558161 40.77349914209411) | 19 | 4 | 19 | 13 | |||
268 | 268 | -73.968107276769 | 40.7768612676036 | 15F-AM-1007-09 | 15F | AM | 10072018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.968107276769 40.7768612676036) | 19 | 4 | 19 | 13 | |||||
376 | 376 | -73.9698817079185 | 40.7758322627711 | 13E-PM-1008-10 | 13E | PM | 10082018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.9698817079185 40.7758322627711) | 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 | |||||
667 | 667 | -73.9624538733037 | 40.7883829851518 | 28D-AM-1012-04 | 28D | AM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9624538733037 40.7883829851518) | 19 | 4 | 19 | 13 | |||||
1075 | 1075 | -73.9640534906634 | 40.7777383899836 | 17I-AM-1014-02 | 17I | AM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | standing upright | false | false | false | false | false | true | false | true | runs from (only ran away when a grandpa chased it off) | POINT (-73.9640534906634 40.7777383899836) | 19 | 4 | 19 | 13 | |||
1077 | 1077 | -73.9541837143178 | 40.7944340477396 | 38G-PM-1020-06 | 38G | PM | 10202018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | true | false | false | false | false | false | true | POINT (-73.9541837143178 40.7944340477396) | 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 | |||||
1577 | 1577 | -73.965390623703 | 40.7807731363782 | 20F-PM-1007-08 | 20F | PM | 10072018 | 8 | Adult | Cinnamon | White | Cinnamon+White | white tail/belly | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.965390623703 40.7807731363782) | 19 | 4 | 19 | 13 | ||||
1617 | 1617 | -73.9752029513644 | 40.7671734667361 | 3F-AM-1006-04 | 03F | AM | 10062018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on a rock | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9752029513644 40.7671734667361) | 19 | 4 | 19 | 13 | ||||
1652 | 1652 | -73.9498421746221 | 40.7969397424182 | 42I-PM-1014-02 | 42I | PM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 8 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9498421746221 40.7969397424182) | 19 | 4 | 19 | 13 | |||||
2102 | 2102 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | false | false | false | true | true | watching | false | false | false | false | false | false | false | true | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
2278 | 2278 | -73.964539031099 | 40.7809916310012 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.964539031099 40.7809916310012) | 19 | 4 | 19 | 13 | |||||
2620 | 2620 | -73.9771800098131 | 40.7708863131336 | 5C-PM-1010-03 | 05C | PM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9771800098131 40.7708863131336) | 19 | 4 | 19 | 13 | |||||
2742 | 2742 | -73.9628041577934 | 40.7884180156055 | 28D-AM-1012-06 | 28D | AM | 10122018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 5 | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9628041577934 40.78841801560551) | 19 | 4 | 19 | 13 | |||||
2745 | 2745 | -73.97296259363 | 40.7652601851275 | 1I-PM-1012-04 | 01I | PM | 10122018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 2 | on ledge | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.97296259363 40.7652601851275) | 19 | 4 | 19 | 13 | |||
2779 | 2779 | -73.9767835160078 | 40.7674030330482 | 2E-PM-1014-04 | 02E | PM | 10142018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9767835160078 40.7674030330482) | 19 | 4 | 19 | 13 | |||||
2794 | 2794 | -73.9712187890707 | 40.7750640173134 | 12E-PM-1018-01 | 12E | PM | 10182018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | true | false | false | true | false | false | true | false | false | false | true | POINT (-73.9712187890707 40.7750640173134) | 19 | 4 | 19 | 13 | |||||
2886 | 2886 | -73.9729265300533 | 40.7741768291642 | 10D-AM-1008-02 | 10D | 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.9729265300533 40.7741768291642) | 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 | ||||||
10 | 10 | -73.9596413903948 | 40.7903128889029 | 32E-PM-1017-14 | 32E | PM | 10172018 | 14 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9596413903948 40.7903128889029) | 19 | 4 | 19 | 13 | |||||||
84 | 84 | -73.9701824825872 | 40.7766530579293 | 14E-AM-1008-09 | 14E | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.9701824825872 40.7766530579293) | 19 | 4 | 19 | 13 | ||||||
95 | 95 | -73.9692883970928 | 40.7768553703082 | 14E-AM-1008-02 | 14E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | walking | false | false | false | false | false | false | false | true | POINT (-73.9692883970928 40.7768553703082) | 19 | 4 | 19 | 13 | |||||
98 | 98 | -73.9730277911422 | 40.7712145488828 | 7F-AM-1008-16 | 07F | AM | 10082018 | 16 | Juvenile | Gray | Gray+ | Above Ground | 2 | tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9730277911422 40.7712145488828) | 19 | 4 | 19 | 13 | |||||
103 | 103 | -73.9607701370443 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 10132018 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | false | true | false | false | false | chasing #8 | false | false | false | false | false | false | false | true | POINT (-73.9607701370443 40.7955418990855) | 19 | 4 | 19 | 13 | |||||
108 | 108 | -73.9574809028248 | 40.7950013620207 | 37D-PM-1014-04 | 37D | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | chasing (a chipmunk) | false | false | false | false | false | false | false | true | POINT (-73.9574809028248 40.7950013620207) | 19 | 4 | 19 | 13 | |||||
109 | 109 | -73.967097592707 | 40.7854119342538 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | true | false | false | true | false | took nut to bury | false | false | false | false | true | false | false | true | POINT (-73.967097592707 40.7854119342538) | 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 | ||||||
159 | 159 | -73.9638270331336 | 40.7810450065235 | 21G-PM-1007-02 | 21G | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9638270331336 40.7810450065235) | 19 | 4 | 19 | 13 | ||||||
177 | 177 | -73.9554432393295 | 40.7945669054449 | 37F-PM-1014-01 | 37F | PM | 10142018 | 1 | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9554432393295 40.7945669054449) | 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 | ||||||
225 | 225 | -73.963842266151 | 40.7887340867773 | 28C-PM-1006-02 | 28C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Near rock | true | false | false | false | false | false | false | false | false | false | false | false | true | dog | POINT (-73.963842266151 40.7887340867773) | 19 | 4 | 19 | 13 | ||||
235 | 235 | -73.9753574279936 | 40.7683211694257 | 4E-PM-1008-08 | 04E | PM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9753574279936 40.7683211694257) | 19 | 4 | 19 | 13 | ||||||
237 | 237 | -73.967895656898 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 3 | on fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
244 | 244 | -73.9597648775789 | 40.7903443029725 | 32E-AM-1007-01 | 32E | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9597648775789 40.7903443029725) | 19 | 4 | 19 | 13 | ||||||
245 | 245 | -73.9589414339242 | 40.7907073888277 | 32E-PM-1017-04 | 32E | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9589414339242 40.7907073888277) | 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 | |||||
283 | 283 | -73.9529060669193 | 40.7927909735388 | 37I-AM-1010-01 | 37I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9529060669193 40.7927909735388) | 19 | 4 | 19 | 13 | ||||||
322 | 322 | -73.9546042927016 | 40.7898133734952 | 33I-PM-1006-07 | 33I | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9546042927016 40.7898133734952) | 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 | ||||||
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 | ||||||
402 | 402 | -73.9681917366128 | 40.7723298813768 | 11I-PM-1012-03 | 11I | PM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | true | runs from the dog | POINT (-73.9681917366128 40.7723298813768) | 19 | 4 | 19 | 13 | |||||
409 | 409 | -73.9530809650496 | 40.7959176317705 | 40G-PM-1013-02 | 40G | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | hiding from dog | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9530809650496 40.79591763177051) | 19 | 4 | 19 | 13 | ||||
417 | 417 | -73.9639888092327 | 40.791449395909 | 31A-AM-1010-01 | 31A | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9639888092327 40.791449395909005) | 19 | 4 | 19 | 13 | ||||||
425 | 425 | -73.9704485231855 | 40.7717290560806 | 9G-AM-1007-02 | 09G | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | true | kids were trying to poke it with a stick | POINT (-73.9704485231855 40.7717290560806) | 19 | 4 | 19 | 13 | |||||
427 | 427 | -73.9589367709165 | 40.7896465303483 | 31F-PM-1007-04 | 31F | PM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9589367709165 40.7896465303483) | 19 | 4 | 19 | 13 | ||||||
434 | 434 | -73.9676639740486 | 40.7745369616499 | 13H-PM-1010-07 | 13H | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9676639740486 40.7745369616499) | 19 | 4 | 19 | 13 | ||||||
463 | 463 | -73.9592103064327 | 40.7904390691553 | 32E-PM-1017-10 | 32E | PM | 10172018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9592103064327 40.7904390691553) | 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 | ||||||
507 | 507 | -73.9744835563086 | 40.7729521433235 | 9D-AM-1008-01 | 09D | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9744835563086 40.7729521433235) | 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 | ||||||
529 | 529 | -73.9635290751183 | 40.7820936628202 | 22G-AM-1018-02 | 22G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9635290751183 40.7820936628202) | 19 | 4 | 19 | 13 | ||||||
550 | 550 | -73.9714465493257 | 40.7772135587308 | 14C-PM-1006-02 | 14C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9714465493257 40.7772135587308) | 19 | 4 | 19 | 13 | ||||||
554 | 554 | -73.973351945818 | 40.768814796037 | 5G-PM-1010-03 | 05G | PM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.973351945818 40.768814796037) | 19 | 4 | 19 | 13 | ||||||
558 | 558 | -73.9579335275486 | 40.7953080673706 | 37D-PM-1014-05 | 37D | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9579335275486 40.7953080673706) | 19 | 4 | 19 | 13 | ||||||
598 | 598 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 10182018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
618 | 618 | -73.957976896139 | 40.797027128241 | 39C-AM-1017-04 | 39C | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.957976896139 40.797027128241005) | 19 | 4 | 19 | 13 | ||||||
621 | 621 | -73.9588886083793 | 40.7909991733435 | 32E-PM-1017-01 | 32E | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9588886083793 40.7909991733435) | 19 | 4 | 19 | 13 | ||||||
623 | 623 | -73.9662939630722 | 40.7878502338031 | 26B-AM-1010-01 | 26B | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | running across bridle path | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9662939630722 40.7878502338031) | 19 | 4 | 19 | 13 | |||||
648 | 648 | -73.9539400028236 | 40.79800412717 | 41E-AM-1007-02 | 41E | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9539400028236 40.79800412717) | 19 | 4 | 19 | 13 | ||||||
652 | 652 | -73.9570056123953 | 40.7878756067582 | 30I-PM-1006-02 | 30I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9570056123953 40.7878756067582) | 19 | 4 | 19 | 13 | ||||||
653 | 653 | -73.9703401385684 | 40.7795238784266 | 17C-PM-1013-01 | 17C | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | then perched on 2-ft high border fencing | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9703401385684 40.7795238784266) | 19 | 4 | 19 | 13 | |||||
663 | 663 | -73.9766440589836 | 40.7682390282581 | 3E-AM-1006-02 | 03E | AM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9766440589836 40.7682390282581) | 19 | 4 | 19 | 13 | ||||||
671 | 671 | -73.9709244006956 | 40.7676942639697 | 5I-AM-1010-02 | 05I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9709244006956 40.7676942639697) | 19 | 4 | 19 | 13 | ||||||
675 | 675 | -73.9759830650957 | 40.7683034739069 | 3E-AM-1006-01 | 03E | AM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9759830650957 40.7683034739069) | 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 | ||||||
717 | 717 | -73.9574749571848 | 40.7981898890735 | 40C-PM-1006-08 | 40C | PM | 10062018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | By the main road | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9574749571848 40.7981898890735) | 19 | 4 | 19 | 13 | |||||
724 | 724 | -73.9532952763106 | 40.7920074462622 | 36I-AM-1017-08 | 36I | AM | 10172018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#7) | false | false | false | false | true | false | false | true | runs from (me) | POINT (-73.95329527631061 40.7920074462622) | 19 | 4 | 19 | 13 | ||||
730 | 730 | -73.9607280801601 | 40.7901506706248 | 31D-PM-1006-01 | 31D | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | false | false | true | POINT (-73.9607280801601 40.7901506706248) | 19 | 4 | 19 | 13 | ||||||
774 | 774 | -73.9673603655908 | 40.7876974177782 | 26A-PM-1006-03 | 26A | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9673603655908 40.7876974177782) | 19 | 4 | 19 | 13 | ||||||
777 | 777 | -73.9654210263521 | 40.7782529692575 | 17G-AM-1018-01 | 17G | AM | 10182018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9654210263521 40.77825296925751) | 19 | 4 | 19 | 13 | ||||||
785 | 785 | -73.9619417432685 | 40.7930365939865 | 33B-PM-1010-12 | 33B | PM | 10102018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9619417432685 40.7930365939865) | 19 | 4 | 19 | 13 | ||||||
793 | 793 | -73.9730111650468 | 40.7782157736204 | 14B-PM-1014-05 | 14B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9730111650468 40.7782157736204) | 19 | 4 | 19 | 13 | ||||||
824 | 824 | -73.9606344681252 | 40.7958337780644 | 37B-PM-1013-04 | 37B | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9606344681252 40.795833778064406) | 19 | 4 | 19 | 13 | ||||||
825 | 825 | -73.9580105174865 | 40.7974468322692 | 39C-PM-1006-03 | 39C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9580105174865 40.7974468322692) | 19 | 4 | 19 | 13 | ||||||
833 | 833 | -73.9741846413977 | 40.7762518164182 | 12B-PM-1018-01 | 12B | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Climbing up rocks | false | false | true | false | true | climbing (up rocks) | false | false | false | false | false | false | false | true | POINT (-73.9741846413977 40.7762518164182) | 19 | 4 | 19 | 13 | ||||
869 | 869 | -73.9629483374528 | 40.7936809905265 | 33A-PM-1018-03 | 33A | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9629483374528 40.7936809905265) | 19 | 4 | 19 | 13 | ||||||
888 | 888 | -73.9674177504573 | 40.7769569731993 | 15G-PM-1019-03 | 15G | PM | 10192018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674177504573 40.7769569731993) | 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 | |||||
898 | 898 | -73.9542828053256 | 40.7941797320355 | 37G-AM-1014-03 | 37G | AM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9542828053256 40.7941797320355) | 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 | ||||||
914 | 914 | -73.9760801742337 | 40.7674218954729 | 3E-AM-1006-04 | 03E | AM | 10062018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9760801742337 40.7674218954729) | 19 | 4 | 19 | 13 | ||||||
923 | 923 | -73.9578924882613 | 40.789806297824 | 32G-AM-1010-02 | 32G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | false | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9578924882613 40.789806297824) | 19 | 4 | 19 | 13 | ||||||
932 | 932 | -73.9718597156773 | 40.7765858763313 | 13C-PM-1019-04 | 13C | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9718597156773 40.7765858763313) | 19 | 4 | 19 | 13 | ||||||
951 | 951 | -73.971791854883 | 40.7802971729784 | 17B-PM-1012-01 | 17B | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | climbed a fence | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.971791854883 40.7802971729784) | 19 | 4 | 19 | 13 | |||||
955 | 955 | -73.960657061561 | 40.7956150744102 | 36A-PM-1013-08 | 36A | PM | 10132018 | 8 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | true | false | false | false | false | running from #7 | false | false | false | false | false | false | false | true | POINT (-73.960657061561 40.7956150744102) | 19 | 4 | 19 | 13 | |||||
963 | 963 | -73.9621066718851 | 40.7942427079733 | 34A-AM-1012-03 | 34A | AM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9621066718851 40.7942427079733) | 19 | 4 | 19 | 13 | ||||||
974 | 974 | -73.9753744539307 | 40.7671162211032 | 2F-PM-1014-12 | 02F | PM | 10142018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97537445393071 40.7671162211032) | 19 | 4 | 19 | 13 | ||||||
979 | 979 | -73.9612349421547 | 40.7959586475744 | 36A-PM-1013-09 | 36A | PM | 10132018 | 9 | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9612349421547 40.7959586475744) | 19 | 4 | 19 | 13 | ||||||
980 | 980 | -73.9709817796369 | 40.7773554311586 | 14D-PM-1019-07 | 14D | PM | 10192018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9709817796369 40.7773554311586) | 19 | 4 | 19 | 13 | ||||||
1005 | 1005 | -73.9558268731771 | 40.7952074193788 | 38E-PM-1014-04 | 38E | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9558268731771 40.7952074193788) | 19 | 4 | 19 | 13 | |||||
1011 | 1011 | -73.9719111470164 | 40.7758789855474 | 12D-AM-1013-02 | 12D | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 7 | Was on top of the edge of Bow Bridge | false | false | false | false | false | jumped off | false | false | false | true | false | false | false | true | POINT (-73.9719111470164 40.7758789855474) | 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 | ||||||
1040 | 1040 | -73.9702588981432 | 40.776610754288 | 14E-AM-1008-08 | 14E | AM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9702588981432 40.776610754288) | 19 | 4 | 19 | 13 | ||||||
1051 | 1051 | -73.9613747032702 | 40.7920483852431 | 33C-PM-1007-01 | 33C | PM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9613747032702 40.792048385243106) | 19 | 4 | 19 | 13 | ||||||
1053 | 1053 | -73.9685859705486 | 40.7848805065322 | 23A-AM-1018-04 | 23A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | Tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685859705486 40.7848805065322) | 19 | 4 | 19 | 13 | |||||
1070 | 1070 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 10172018 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2 | Fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674631254594 40.7790076357696) | 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 );