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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
258 | 258 | -73.9534333425633 | 40.7932564163328 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | false | false | false | true | false | false | true | false | false | false | false | false | true | POINT (-73.9534333425633 40.7932564163328) | 19 | 4 | 19 | 13 | ||||
260 | 260 | -73.978436117932 | 40.7724769242403 | 6A-AM-1006-06 | 06A | AM | 10062018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | tree | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.978436117932 40.7724769242403) | 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 | |||||
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 | |||||
271 | 271 | -73.9661262885099 | 40.7844085550945 | 23D-AM-1013-01 | 23D | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | true | false | false | approaches (he saw me,came towards,then darted up) | POINT (-73.9661262885099 40.7844085550945) | 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 | ||||||
289 | 289 | -73.9684254196866 | 40.77809016436 | 16E-AM-1014-02 | 16E | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9684254196866 40.77809016436) | 19 | 4 | 19 | 13 | |||||
291 | 291 | -73.9679661308374 | 40.7837388390673 | 22C-AM-1013-01 | 22C | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | false | false | sitting still,tail over back | false | false | false | false | false | false | false | false | POINT (-73.9679661308374 40.7837388390673) | 19 | 4 | 19 | 13 | ||||
296 | 296 | -73.9596964641652 | 40.7957753591585 | 37B-AM-1018-03 | 37B | AM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9596964641652 40.7957753591585) | 19 | 4 | 19 | 13 | ||||||
313 | 313 | -73.9646610347972 | 40.7790583544252 | 19H-AM-1010-05 | 19H | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | near a brush | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9646610347972 40.7790583544252) | 19 | 4 | 19 | 13 | ||||
324 | 324 | -73.9587879699956 | 40.7908135158551 | 32F-AM-1012-01 | 32F | AM | 10122018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | made a back-door escape from dog off-leash | false | false | false | false | false | false | false | true | POINT (-73.9587879699956 40.7908135158551) | 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 | ||||||
334 | 334 | -73.9687395228846 | 40.7807364481385 | 18D-AM-1018-02 | 18D | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9687395228846 40.7807364481385) | 19 | 4 | 19 | 13 | ||||||
335 | 335 | -73.9782351435852 | 40.7715896672335 | 6A-AM-1006-03 | 06A | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | false | true | false | true | false | false | false | false | true | true | false | false | false | POINT (-73.9782351435852 40.7715896672335) | 19 | 4 | 19 | 13 | ||||
340 | 340 | -73.9744960829844 | 40.7652585501959 | 1H-AM-1012-01 | 01H | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | true | first approaches then runs from - he was less than 1 yd. away from me. | POINT (-73.9744960829844 40.7652585501959) | 19 | 4 | 19 | 13 | ||||
342 | 342 | -73.9605966636226 | 40.7889849108637 | 30E-AM-1008-01 | 30E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | scurried into bushes when jogger ran by | POINT (-73.9605966636226 40.7889849108637) | 19 | 4 | 19 | 13 | ||||
349 | 349 | -73.9689657039917 | 40.7767834276767 | 15F-AM-1007-04 | 15F | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9689657039917 40.7767834276767) | 19 | 4 | 19 | 13 | |||||
350 | 350 | -73.9707471099503 | 40.7759255131734 | 13E-AM-1017-08 | 13E | AM | 10172018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9707471099503 40.7759255131734) | 19 | 4 | 19 | 13 | |||||
364 | 364 | -73.9623696148045 | 40.792184861375 | 32B-AM-1017-04 | 32B | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9623696148045 40.792184861375) | 19 | 4 | 19 | 13 | |||||
372 | 372 | -73.9781303869038 | 40.7725000348875 | 7A-AM-1006-02 | 07A | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9781303869038 40.7725000348875) | 19 | 4 | 19 | 13 | ||||
374 | 374 | -73.9556817958407 | 40.788852000621 | 32I-AM-1013-02 | 32I | AM | 10132018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | watching me from tree - curious | POINT (-73.9556817958407 40.788852000621) | 19 | 4 | 19 | 13 | ||||
384 | 384 | -73.968045072743 | 40.7836626717225 | 22C-AM-1013-02 | 22C | AM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | false | false | true | false | true | true | false | false | true | false | false | false | true | POINT (-73.968045072743 40.7836626717225) | 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 | ||||||
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 | |||||
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 | |||||||
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 | ||||||
421 | 421 | -73.9664630067791 | 40.7756361515825 | 14H-AM-1007-04 | 14H | AM | 10072018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664630067791 40.7756361515825) | 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 | |||||
433 | 433 | -73.9558474701153 | 40.7913335515534 | 34H-AM-1007-01 | 34H | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | tree | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.9558474701153 40.7913335515534) | 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 | |||||
441 | 441 | -73.9742973420446 | 40.7691801644292 | 5F-AM-1007-04 | 05F | AM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | rocks | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9742973420446 40.7691801644292) | 19 | 4 | 19 | 13 | |||||
449 | 449 | -73.9701335162984 | 40.7722051011357 | 10G-AM-1006-10 | 10G | AM | 10062018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9701335162984 40.7722051011357) | 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 | ||||||||||
470 | 470 | -73.9581243021722 | 40.794431473386 | 36D-AM-1007-01 | 36D | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | true | avoiding a dog | POINT (-73.95812430217221 40.794431473386) | 19 | 4 | 19 | 13 | ||||
471 | 471 | -73.9707215394887 | 40.7727508149058 | 10G-AM-1006-05 | 10G | AM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#6) | true | false | false | false | false | false | false | false | POINT (-73.9707215394887 40.7727508149058) | 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 | |||
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 | ||||||
496 | 496 | -73.9548430741605 | 40.798207350942 | 41E-AM-1007-06 | 41E | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | tree | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9548430741605 40.798207350942) | 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 | ||||||
506 | 506 | -73.9649611089685 | 40.7814371834837 | 21F-AM-1018-05 | 21F | AM | 10182018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9649611089685 40.7814371834837) | 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 | ||||||
510 | 510 | -73.9638590768396 | 40.7776782114981 | 18I-AM-1017-02 | 18I | AM | 10172018 | 2 | Adult | Gray | Black | Gray+Black | Above Ground | 15 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9638590768396 40.7776782114981) | 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 | ||||||
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 | ||||||||
537 | 537 | -73.9682803241007 | 40.7724510558327 | 11H-AM-1010-04 | 11H | AM | 10102018 | 4 | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9682803241007 40.7724510558327) | 19 | 4 | 19 | 13 | ||||||||
544 | 544 | -73.9718474480919 | 40.7794963354254 | 16B-AM-1014-01 | 16B | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9718474480919 40.7794963354254) | 19 | 4 | 19 | 13 | |||||
552 | 552 | -73.9625416200877 | 40.7811302397912 | 21H-AM-1017-02 | 21H | AM | 10172018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9625416200877 40.78113023979121) | 19 | 4 | 19 | 13 | |||||
566 | 566 | -73.9708364583591 | 40.7723691587433 | 10F-AM-1007-01 | 10F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 60 | false | false | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.9708364583591 40.7723691587433) | 19 | 4 | 19 | 13 | ||||||
588 | 588 | -73.9646597452128 | 40.7827698220703 | 22F-AM-1007-07 | 22F | AM | 10072018 | 7 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | false | false | true | false | false | false | false | false | false | true | false | false | false | alert & aware | POINT (-73.9646597452128 40.7827698220703) | 19 | 4 | 19 | 13 | ||||
589 | 589 | -73.97826438139 | 40.7717086090782 | 6A-AM-1006-04 | 06A | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | true | false | false | false | curious | POINT (-73.97826438139 40.7717086090782) | 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 | ||||||
615 | 615 | -73.9653279069888 | 40.7758743113817 | 15I-AM-1008-02 | 15I | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Could be same squirrel as #1? | Above Ground | 4 | on fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653279069888 40.7758743113817) | 19 | 4 | 19 | 13 | |||
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 | ||||||
624 | 624 | -73.9613051957306 | 40.7909351393505 | 31D-AM-1014-02 | 31D | AM | 10142018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | Undergrowth | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9613051957306 40.7909351393505) | 19 | 4 | 19 | 13 | ||||
629 | 629 | -73.9573724133264 | 40.7980080911115 | 40C-AM-1017-02 | 40C | AM | 10172018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | true | false | chasing (#1) | false | false | false | false | false | false | false | true | POINT (-73.9573724133264 40.7980080911115) | 19 | 4 | 19 | 13 | ||||
630 | 630 | -73.9580109357087 | 40.7855654405447 | 28I-AM-1013-01 | 28I | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Jumped onto path & then back into brush | false | false | false | false | false | stood on fence | false | false | false | false | false | false | false | true | POINT (-73.9580109357087 40.7855654405447) | 19 | 4 | 19 | 13 | |||
631 | 631 | -73.9548877830136 | 40.7950157489103 | 38F-AM-1018-04 | 38F | AM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.95488778301362 40.7950157489103) | 19 | 4 | 19 | 13 | |||||
633 | 633 | -73.9673243699918 | 40.7875392957722 | 26A-AM-1014-01 | 26A | AM | 10142018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | could not get close due to fences | POINT (-73.9673243699918 40.7875392957722) | 19 | 4 | 19 | 13 | |||||
647 | 647 | -73.9734762649298 | 40.7663703404546 | 3H-AM-1008-05 | 03H | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.9734762649298 40.7663703404546) | 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 | ||||||
650 | 650 | -73.9809610117171 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 10102018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
654 | 654 | -73.976769659152 | 40.7741908010484 | 9A-AM-1013-04 | 09A | AM | 10132018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.976769659152 40.7741908010484) | 19 | 4 | 19 | 13 | |||||
659 | 659 | -73.9572686979412 | 40.796268457326 | 38D-AM-1017-03 | 38D | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | false | false | POINT (-73.9572686979412 40.796268457326) | 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 | ||||||
665 | 665 | -73.9563661256875 | 40.7966823114508 | 39D-AM-1008-03 | 39D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9563661256875 40.7966823114508) | 19 | 4 | 19 | 13 | ||||||
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 | ||||||
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 | |||||
669 | 669 | -73.9802079259866 | 40.7678723471007 | 1B-AM-1012-10 | 01B | AM | 10122018 | 10 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9802079259866 40.7678723471007) | 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 | ||||||
680 | 680 | -73.9564011421122 | 40.7958097849369 | 38E-AM-1010-02 | 38E | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | climbs | POINT (-73.95640114211221 40.7958097849369) | 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 | ||||||||
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 | ||||||
698 | 698 | -73.9585537668382 | 40.7903905787005 | 32F-AM-1012-03 | 32F | AM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | bringing green leaves to nest | false | false | false | false | false | false | false | false | POINT (-73.9585537668382 40.7903905787005) | 19 | 4 | 19 | 13 | ||||
699 | 699 | -73.9504693544225 | 40.797225436004 | 42H-AM-1019-01 | 42H | AM | 10192018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9504693544225 40.797225436004) | 19 | 4 | 19 | 13 | |||||
704 | 704 | -73.9793565564361 | 40.7679259390448 | 2C-AM-1010-09 | 02C | AM | 10102018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | climbed up tree as i neared | POINT (-73.9793565564361 40.7679259390448) | 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 | |||||||
722 | 722 | -73.9745953710328 | 40.7728284025195 | 8D-AM-1007-07 | 08D | AM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9745953710328 40.7728284025195) | 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 | ||||
732 | 732 | -73.9695041366722 | 40.7797878809482 | 17D-AM-1008-02 | 17D | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9695041366722 40.7797878809482) | 19 | 4 | 19 | 13 | |||||
738 | 738 | -73.9725712588741 | 40.7669101832926 | 4H-AM-1006-02 | 04H | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | climbing (over small wire fence then on the ground) | false | false | false | false | false | true | false | true | approaches (saw me & came forward),runs from (startled by another person) | POINT (-73.9725712588741 40.7669101832926) | 19 | 4 | 19 | 13 | |||
760 | 760 | -73.9718234159557 | 40.7810842503715 | 18A-AM-1012-02 | 18A | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | true | true | burying | false | false | false | true | false | false | false | true | POINT (-73.9718234159557 40.7810842503715) | 19 | 4 | 19 | 13 | ||||
767 | 767 | -73.9655734633649 | 40.7805366922231 | 20F-AM-1014-02 | 20F | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | pulling leaves | true | false | false | false | false | false | false | false | POINT (-73.9655734633649 40.7805366922231) | 19 | 4 | 19 | 13 | ||||
768 | 768 | -73.9729394928432 | 40.7743256716496 | 11D-AM-1010-01 | 11D | AM | 10102018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9729394928432 40.7743256716496) | 19 | 4 | 19 | 13 | |||||
769 | 769 | -73.976521916284 | 40.773784724458 | 9B-AM-1010-01 | 09B | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | true | false | false | false | false | false | false | true | POINT (-73.976521916284 40.773784724458) | 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 | ||||||
778 | 778 | -73.9677054870327 | 40.778992870166 | 17E-AM-1017-03 | 17E | AM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 9 | Tree trunk | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9677054870327 40.778992870166) | 19 | 4 | 19 | 13 | |||||
792 | 792 | -73.9730115687964 | 40.7741018274312 | 10D-AM-1008-05 | 10D | AM | 10082018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.9730115687964 40.7741018274312) | 19 | 4 | 19 | 13 | |||||
801 | 801 | -73.9743342303548 | 40.7727742948332 | 8D-AM-1007-08 | 08D | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | false | false | communicating from tree | false | false | false | false | false | false | false | false | POINT (-73.97433423035481 40.7727742948332) | 19 | 4 | 19 | 13 | |||||
806 | 806 | -73.970475755546 | 40.7763348062134 | 13E-AM-1017-02 | 13E | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | begging (came one yard away from me and stood there) | false | false | false | false | false | true | false | false | POINT (-73.970475755546 40.7763348062134) | 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 | ||||
829 | 829 | -73.9711801122578 | 40.7786888942214 | 16C-AM-1014-02 | 16C | AM | 10142018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.97118011225781 40.77868889422141) | 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 | |||||
843 | 843 | -73.9714089647431 | 40.7767916587915 | 14D-AM-1014-12 | 14D | AM | 10142018 | 12 | 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.9714089647431 40.7767916587915) | 19 | 4 | 19 | 13 | |||||
849 | 849 | -73.9736165917399 | 40.7724543901497 | 8D-AM-1007-04 | 08D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | chasing squirrel #3 | false | false | false | false | false | false | false | false | POINT (-73.9736165917399 40.7724543901497) | 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 | ||||||
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 | |||||||||
891 | 891 | -73.9613351649026 | 40.7909866851357 | 31D-AM-1014-03 | 31D | AM | 10142018 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | Undergrowth | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9613351649026 40.7909866851357) | 19 | 4 | 19 | 13 | |||||
896 | 896 | -73.9755055978764 | 40.7707438681742 | 6D-AM-1008-02 | 06D | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9755055978764 40.7707438681742) | 19 | 4 | 19 | 13 | ||||||
899 | 899 | -73.9792754037291 | 40.7679690700399 | 2C-AM-1010-08 | 02C | AM | 10102018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | stay on side of trunk | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9792754037291 40.7679690700399) | 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 );