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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2822 | 2822 | -73.9711120079542 | 40.7760801911766 | 13D-PM-1018-14 | 13D | PM | 10182018 | 14 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | true | false | false | climbing (down) | false | false | false | false | false | false | true | false | POINT (-73.9711120079542 40.7760801911766) | 19 | 4 | 19 | 13 | ||||
2820 | 2820 | -73.9615926031253 | 40.7944223235385 | 35B-PM-1013-05 | 35B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | chased by dog #2 | true | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.96159260312531 40.7944223235385) | 19 | 4 | 19 | 13 | ||||
2818 | 2818 | -73.9681664642028 | 40.7724669681958 | 11I-PM-1012-02 | 11I | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 4 | true | false | true | false | true | false | false | false | false | false | false | false | true | runs away from the ball | POINT (-73.9681664642028 40.7724669681958) | 19 | 4 | 19 | 13 | |||||
2815 | 2815 | -73.9747311312394 | 40.7677319725044 | 3F-PM-1013-06 | 03F | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 19 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.97473113123941 40.7677319725044) | 19 | 4 | 19 | 13 | |||||
2813 | 2813 | -73.9659118189359 | 40.7765739928504 | 15H-AM-1013-02 | 15H | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9659118189359 40.7765739928504) | 19 | 4 | 19 | 13 | ||||||
2811 | 2811 | -73.9756889766089 | 40.7676078308589 | 3F-AM-1006-14 | 03F | AM | 10062018 | 14 | Adult | Gray | White | Gray+White | Above Ground | 12 | true | false | true | false | false | running from dog | false | false | false | false | false | false | false | true | POINT (-73.9756889766089 40.7676078308589) | 19 | 4 | 19 | 13 | ||||
2804 | 2804 | -73.9576094432477 | 40.7965342664074 | 38C-PM-1014-07 | 38C | PM | 10142018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9576094432477 40.7965342664074) | 19 | 4 | 19 | 13 | |||||
2803 | 2803 | -73.9576652087316 | 40.7875457977801 | 29H-PM-1006-02 | 29H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9576652087316 40.7875457977801) | 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 | |||||
2791 | 2791 | -73.9593624259363 | 40.7905522356793 | 32E-AM-1007-02 | 32E | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9593624259363 40.7905522356793) | 19 | 4 | 19 | 13 | ||||||
2790 | 2790 | -73.9673554935258 | 40.7827527249594 | 21C-AM-1014-04 | 21C | AM | 10142018 | 4 | Adult | + | High in tree, unable to tell | Above Ground | 60 | false | false | true | false | false | false | false | false | true | false | false | true | false | POINT (-73.96735549352582 40.7827527249594) | 19 | 4 | 19 | 13 | ||||||
2783 | 2783 | -73.9791767156268 | 40.7714445258765 | 5A-AM-1006-02 | 05A | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | in tall shrubs near wall next to CPW | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9791767156268 40.7714445258765) | 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 | |||||
2776 | 2776 | -73.9789687905912 | 40.7692693139328 | 3B-PM-1007-04 | 03B | PM | 10072018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | At fence | true | false | true | true | false | false | false | false | false | true | false | true | true | POINT (-73.9789687905912 40.7692693139328) | 19 | 4 | 19 | 13 | ||||
2762 | 2762 | -73.9656324462902 | 40.7834034753081 | 22E-PM-1014-02 | 22E | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | true | false | false | POINT (-73.9656324462902 40.7834034753081) | 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 | |||||||
2748 | 2748 | -73.960094705031 | 40.7916066137699 | 33D-AM-1017-01 | 33D | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.960094705031 40.7916066137699) | 19 | 4 | 19 | 13 | |||||
2747 | 2747 | -73.971314838366 | 40.774951285041 | 12E-AM-1017-03 | 12E | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.971314838366 40.774951285041) | 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 | |||
2744 | 2744 | -73.9752915601718 | 40.7739329570033 | 9B-AM-1010-04 | 09B | AM | 10102018 | 4 | + | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9752915601718 40.7739329570033) | 19 | 4 | 19 | 13 | ||||||||
2734 | 2734 | -73.9763629541474 | 40.7682321897044 | 3E-PM-1008-04 | 03E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9763629541474 40.7682321897044) | 19 | 4 | 19 | 13 | ||||||
2731 | 2731 | -73.9595886063173 | 40.7918405182594 | 33D-AM-1017-09 | 33D | AM | 10172018 | 9 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 7 | false | false | true | false | false | true | true | false | false | false | false | true | true | POINT (-73.9595886063173 40.7918405182594) | 19 | 4 | 19 | 13 | |||||
2730 | 2730 | -73.9653575758687 | 40.7805339953372 | 20F-PM-1007-12 | 20F | PM | 10072018 | 12 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.9653575758687 40.7805339953372) | 19 | 4 | 19 | 13 | ||||
2729 | 2729 | -73.9615429203441 | 40.7907417648701 | 31D-AM-1014-01 | 31D | AM | 10142018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | Ground then up tree | false | false | true | false | false | chased by a doggo | false | false | true | false | false | false | false | true | runs from (dogs!) | POINT (-73.9615429203441 40.7907417648701) | 19 | 4 | 19 | 13 | |||
2727 | 2727 | -73.974596903918 | 40.7765498215674 | 12A-PM-1013-02 | 12A | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.974596903918 40.7765498215674) | 19 | 4 | 19 | 13 | |||||
2724 | 2724 | -73.9611434082667 | 40.7893671772846 | 30E-PM-1008-01 | 30E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | true | false | false | false | false | false | false | POINT (-73.9611434082667 40.7893671772846) | 19 | 4 | 19 | 13 | |||||
2722 | 2722 | -73.9692271132136 | 40.777528508844 | 15E-PM-1008-04 | 15E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9692271132136 40.777528508844) | 19 | 4 | 19 | 13 | ||||||
2720 | 2720 | -73.9566300789162 | 40.7993692120774 | 42C-PM-1013-06 | 42C | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Between park and main drag | false | false | true | true | false | false | false | false | false | false | false | true | true | POINT (-73.9566300789162 40.7993692120774) | 19 | 4 | 19 | 13 | ||||
2702 | 2702 | -73.9588339897601 | 40.7848084865431 | 26I-PM-1010-06 | 26I | PM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 35 | tree | false | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9588339897601 40.7848084865431) | 19 | 4 | 19 | 13 | ||||
2700 | 2700 | -73.9601988871514 | 40.7943473161329 | 35C-PM-1013-01 | 35C | PM | 10132018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | true | true | true | false | true | true | false | true | false | POINT (-73.9601988871514 40.7943473161329) | 19 | 4 | 19 | 13 | ||||||
2696 | 2696 | -73.9501457233643 | 40.797094356558 | 42I-PM-1014-01 | 42I | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9501457233643 40.797094356558) | 19 | 4 | 19 | 13 | |||||
2692 | 2692 | -73.9801636400744 | 40.7690192055926 | 2A-AM-1010-09 | 02A | AM | 10102018 | 9 | Adult | Gray | White | Gray+White | Above Ground | climbing in bush | false | false | true | false | false | hopping & flipping around. this one was very energetic & jumping aorund | false | false | false | false | true | false | false | false | climbed a foot up a tree and watched me | POINT (-73.9801636400744 40.7690192055926) | 19 | 4 | 19 | 13 | |||
2690 | 2690 | -73.9572840457971 | 40.7886933371744 | 31H-PM-1008-04 | 31H | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | Also way up | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.95728404579711 40.7886933371744) | 19 | 4 | 19 | 13 | ||||||
2664 | 2664 | -73.9598350385541 | 40.7973274000224 | 38A-PM-1013-04 | 38A | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9598350385541 40.7973274000224) | 19 | 4 | 19 | 13 | |||||
2663 | 2663 | -73.9613429184974 | 40.7912158057267 | 32C-AM-1014-02 | 32C | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9613429184974 40.7912158057267) | 19 | 4 | 19 | 13 | ||||||
2660 | 2660 | -73.9726056411971 | 40.7793467904743 | 16A-PM-1019-03 | 16A | PM | 10192018 | 3 | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9726056411971 40.7793467904743) | 19 | 4 | 19 | 13 | |||||||
2652 | 2652 | -73.9620542514749 | 40.7943731722138 | 34A-AM-1012-01 | 34A | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | chasing from tree to ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9620542514749 40.7943731722138) | 19 | 4 | 19 | 13 | ||||
2646 | 2646 | -73.9772239251936 | 40.7731716665766 | 8A-AM-1013-05 | 08A | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9772239251936 40.7731716665766) | 19 | 4 | 19 | 13 | |||||
2639 | 2639 | -73.9543832609857 | 40.7953550639701 | 39F-AM-1014-02 | 39F | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | rocks | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9543832609857 40.7953550639701) | 19 | 4 | 19 | 13 | ||||
2634 | 2634 | -73.9695685186489 | 40.7788293026327 | 16D-AM-1007-04 | 16D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9695685186489 40.7788293026327) | 19 | 4 | 19 | 13 | ||||||
2616 | 2616 | -73.9675917702187 | 40.7789922281625 | 17E-AM-1017-02 | 17E | AM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 8 | Shore | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9675917702187 40.7789922281625) | 19 | 4 | 19 | 13 | |||||
2609 | 2609 | -73.9596865318094 | 40.7893787188526 | 31F-AM-1013-01 | 31F | AM | 10132018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9596865318094 40.7893787188526) | 19 | 4 | 19 | 13 | |||||
2607 | 2607 | -73.9642988690682 | 40.7795591281979 | 19H-AM-1010-04 | 19H | AM | 10102018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | true | runs from human w/ dog | POINT (-73.9642988690682 40.7795591281979) | 19 | 4 | 19 | 13 | ||||
2604 | 2604 | -73.9605163698302 | 40.7914179994956 | 32D-PM-1006-05 | 32D | PM | 10062018 | 5 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9605163698302 40.7914179994956) | 19 | 4 | 19 | 13 | |||||
2603 | 2603 | -73.9708781504528 | 40.7724138070355 | 10F-AM-1007-03 | 10F | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9708781504528 40.7724138070355) | 19 | 4 | 19 | 13 | ||||||
2599 | 2599 | -73.9689893412693 | 40.785308737683 | 23A-AM-1018-03 | 23A | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | Tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9689893412693 40.785308737683) | 19 | 4 | 19 | 13 | ||||
2598 | 2598 | -73.976658503418 | 40.7686868456917 | 4D-AM-1012-03 | 04D | AM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.976658503418 40.7686868456917) | 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 | |||||
2592 | 2592 | -73.9758128509653 | 40.7715946097064 | 7C-PM-1020-03 | 07C | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9758128509653 40.7715946097064) | 19 | 4 | 19 | 13 | |||||
2588 | 2588 | -73.9581007437094 | 40.7959403112722 | 38C-AM-1019-06 | 38C | AM | 10192018 | 6 | Adult | Gray | Gray+ | Above Ground | 23 | false | false | true | false | false | true | false | false | true | false | false | true | false | POINT (-73.9581007437094 40.7959403112722) | 19 | 4 | 19 | 13 | ||||||
2586 | 2586 | -73.9752965316933 | 40.7752538575789 | 10B-AM-1006-03 | 10B | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | In tree | false | false | true | false | false | false | false | false | false | true | true | false | false | POINT (-73.9752965316933 40.7752538575789) | 19 | 4 | 19 | 13 | |||||
2584 | 2584 | -73.9727187453699 | 40.7669595710626 | 3H-AM-1008-02 | 03H | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9727187453699 40.7669595710626) | 19 | 4 | 19 | 13 | |||||||
2583 | 2583 | -73.9769693140651 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 10062018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | up a tree | true | false | true | true | true | digging (?) | false | false | false | true | false | false | false | true | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) | 19 | 4 | 19 | 13 | ||
2577 | 2577 | -73.9597048490102 | 40.7955846466241 | 37B-AM-1018-06 | 37B | AM | 10182018 | 6 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9597048490102 40.7955846466241) | 19 | 4 | 19 | 13 | ||||||
2574 | 2574 | -73.978199543688 | 40.7695660563362 | 4C-PM-1010-17 | 04C | PM | 10102018 | 17 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | climbed up tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.978199543688 40.7695660563362) | 19 | 4 | 19 | 13 | ||||
2569 | 2569 | -73.9559663734409 | 40.7945828261377 | 37F-AM-1010-01 | 37F | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | false | false | false | false | false | true | false | false | true | false | POINT (-73.9559663734409 40.7945828261377) | 19 | 4 | 19 | 13 | |||||
2562 | 2562 | -73.9615643742864 | 40.7944678447843 | 35B-PM-1013-06 | 35B | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | chased by dog #2 | true | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9615643742864 40.7944678447843) | 19 | 4 | 19 | 13 | |||
2561 | 2561 | -73.9591513028486 | 40.7835978067328 | 25I-PM-1007-01 | 25I | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9591513028486 40.7835978067328) | 19 | 4 | 19 | 13 | ||||||
2559 | 2559 | -73.9572383478774 | 40.7876857380722 | 30H-PM-1006-01 | 30H | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9572383478774 40.7876857380722) | 19 | 4 | 19 | 13 | |||||
2554 | 2554 | -73.9701505245419 | 40.768998364571 | 6I-PM-1013-07 | 06I | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 11 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9701505245419 40.768998364571004) | 19 | 4 | 19 | 13 | ||||||
2552 | 2552 | -73.9724947710698 | 40.7696619340886 | 6G-AM-1008-05 | 06G | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 30 | branch | false | false | true | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9724947710698 40.7696619340886) | 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 | ||||||
2534 | 2534 | -73.9744368038675 | 40.7674281958115 | 3G-PM-1013-03 | 03G | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | runs from (climbed tree to run from) | POINT (-73.97443680386752 40.7674281958115) | 19 | 4 | 19 | 13 | |||||
2528 | 2528 | -73.9676529780724 | 40.7823206990549 | 21D-PM-1008-03 | 21D | PM | 10082018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9676529780724 40.7823206990549) | 19 | 4 | 19 | 13 | |||||
2519 | 2519 | -73.9589475065438 | 40.7934846881536 | 35D-PM-1013-06 | 35D | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9589475065438 40.7934846881536) | 19 | 4 | 19 | 13 | |||||
2517 | 2517 | -73.9710221361528 | 40.7724939691584 | 10F-PM-1019-01 | 10F | PM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Above Ground | 2 | Behind fence, tree trunk | false | false | true | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9710221361528 40.7724939691584) | 19 | 4 | 19 | 13 | ||
2516 | 2516 | -73.9649823687651 | 40.7763395359636 | 16I-AM-1008-02 | 16I | AM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9649823687651 40.7763395359636) | 19 | 4 | 19 | 13 | |||||
2511 | 2511 | -73.9584561537421 | 40.7911211164754 | 33F-PM-1012-02 | 33F | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | true | false | false | false | POINT (-73.9584561537421 40.7911211164754) | 19 | 4 | 19 | 13 | |||||
2508 | 2508 | -73.979381450452 | 40.7709033697887 | 4A-PM-1007-01 | 04A | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | true | true | false | false | false | false | true | false | true | false | POINT (-73.979381450452 40.770903369788705) | 19 | 4 | 19 | 13 | |||||
2503 | 2503 | -73.974382557804 | 40.7674812627373 | 3F-AM-1006-10 | 03F | AM | 10062018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | on fence | false | false | true | false | false | false | false | false | false | false | false | false | false | clueless | POINT (-73.974382557804 40.7674812627373) | 19 | 4 | 19 | 13 | |||
2497 | 2497 | -73.9622050752008 | 40.7886373772305 | 29D-PM-1010-01 | 29D | PM | 10102018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9622050752008 40.7886373772305) | 19 | 4 | 19 | 13 | |||||
2495 | 2495 | -73.9621253644004 | 40.7912082086879 | 31C-AM-1017-01 | 31C | AM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | true | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9621253644004 40.7912082086879) | 19 | 4 | 19 | 13 | |||||
2485 | 2485 | -73.9584950620879 | 40.7902770710643 | 32F-PM-1008-03 | 32F | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9584950620879 40.7902770710643) | 19 | 4 | 19 | 13 | |||||
2479 | 2479 | -73.9657958433575 | 40.7763496875058 | 15H-AM-1013-01 | 15H | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9657958433575 40.7763496875058) | 19 | 4 | 19 | 13 | |||||
2474 | 2474 | -73.9721448879766 | 40.7762112840981 | 13C-AM-1010-02 | 13C | AM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 7 | false | false | true | false | false | burying | false | false | false | false | false | false | true | false | POINT (-73.9721448879766 40.7762112840981) | 19 | 4 | 19 | 13 | ||||
2471 | 2471 | -73.964274290774 | 40.7795319556023 | 19H-AM-1010-03 | 19H | AM | 10102018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | ran from human w/ dog | POINT (-73.964274290774 40.7795319556023) | 19 | 4 | 19 | 13 | ||||
2466 | 2466 | -73.9599419926299 | 40.7972774728811 | 38A-AM-1019-01 | 38A | AM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9599419926299 40.7972774728811) | 19 | 4 | 19 | 13 | ||||||
2463 | 2463 | -73.9653343572865 | 40.7775286924617 | 17H-PM-1007-01 | 17H | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | true | false | false | false | false | true | false | false | false | true | POINT (-73.9653343572865 40.7775286924617) | 19 | 4 | 19 | 13 | |||||
2455 | 2455 | -73.9577297187155 | 40.799225295679 | 41B-AM-1010-08 | 41B | AM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 20 | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9577297187155 40.799225295679) | 19 | 4 | 19 | 13 | |||||
2452 | 2452 | -73.9727323797981 | 40.7669035463955 | 3H-AM-1008-03 | 03H | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | building nest | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9727323797981 40.7669035463955) | 19 | 4 | 19 | 13 | |||||
2450 | 2450 | -73.9756273257684 | 40.7706539186221 | 6D-AM-1008-04 | 06D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9756273257684 40.7706539186221) | 19 | 4 | 19 | 13 | |||||||
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 | ||||||
2448 | 2448 | -73.9668230576555 | 40.7870637233327 | 25B-PM-1007-02 | 25B | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9668230576555 40.7870637233327) | 19 | 4 | 19 | 13 | |||||
2444 | 2444 | -73.966590487009 | 40.7802469052891 | 19E-PM-1018-02 | 19E | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.96659048700901 40.7802469052891) | 19 | 4 | 19 | 13 | |||||
2443 | 2443 | -73.9667073186959 | 40.7840581361598 | 23C-PM-1014-01 | 23C | PM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.96670731869591 40.7840581361598) | 19 | 4 | 19 | 13 | ||||||
2441 | 2441 | -73.9579865329778 | 40.794906535675 | 37D-PM-1014-03 | 37D | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9579865329778 40.794906535675) | 19 | 4 | 19 | 13 | ||||||
2440 | 2440 | -73.9673803508629 | 40.7785245025508 | 17F-AM-1007-01 | 17F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 18 | false | false | true | true | false | false | false | false | true | false | false | true | false | POINT (-73.9673803508629 40.7785245025508) | 19 | 4 | 19 | 13 | ||||||
2436 | 2436 | -73.95827701417 | 40.7856610238891 | 28I-PM-1007-01 | 28I | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.95827701417 40.7856610238891) | 19 | 4 | 19 | 13 | ||||||
2435 | 2435 | -73.972087127535 | 40.776237268628 | 13C-AM-1010-01 | 13C | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.972087127535 40.776237268628) | 19 | 4 | 19 | 13 | ||||||
2423 | 2423 | -73.973552877209 | 40.7715638228207 | 7E-PM-1013-01 | 07E | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | true | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.973552877209 40.7715638228207) | 19 | 4 | 19 | 13 | ||||
2420 | 2420 | -73.9587787592751 | 40.7981699014259 | 40A-AM-1010-01 | 40A | AM | 10102018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 30 | bottom of great hill | false | false | true | false | false | false | false | false | false | false | false | false | false | climbing up a tree | POINT (-73.9587787592751 40.7981699014259) | 19 | 4 | 19 | 13 | ||||
2408 | 2408 | -73.9596949258862 | 40.7900079479217 | 31E-PM-1006-04 | 31E | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9596949258862 40.7900079479217) | 19 | 4 | 19 | 13 | ||||||
2406 | 2406 | -73.9668964315686 | 40.7777577990886 | 16G-AM-1010-01 | 16G | AM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9668964315686 40.7777577990886) | 19 | 4 | 19 | 13 | |||||
2404 | 2404 | -73.9665309689616 | 40.7775271020244 | 16G-AM-1010-04 | 16G | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9665309689616 40.7775271020244) | 19 | 4 | 19 | 13 | |||||
2397 | 2397 | -73.9704592500888 | 40.772962887933 | 10G-AM-1006-03 | 10G | AM | 10062018 | 3 | Juvenile | Gray | White | Gray+White | tuft on butt | Above Ground | 10 | false | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9704592500888 40.772962887933) | 19 | 4 | 19 | 13 | ||||
2396 | 2396 | -73.9704339422613 | 40.7740149529644 | 11F-PM-1006-03 | 11F | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9704339422613 40.7740149529644) | 19 | 4 | 19 | 13 | ||||||
2394 | 2394 | -73.9785829546046 | 40.7719652299132 | 6A-PM-1012-02 | 06A | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9785829546046 40.7719652299132) | 19 | 4 | 19 | 13 | |||||
2380 | 2380 | -73.9761375729505 | 40.7662231892125 | 1F-PM-1019-02 | 01F | PM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9761375729505 40.7662231892125) | 19 | 4 | 19 | 13 | |||||
2377 | 2377 | -73.9704328573603 | 40.7739347247552 | 11F-AM-1013-03 | 11F | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9704328573603 40.7739347247552) | 19 | 4 | 19 | 13 | ||||||
2372 | 2372 | -73.9724879969884 | 40.771098202397 | 8F-PM-1012-07 | 08F | PM | 10122018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 17 | false | false | true | false | false | gathering | false | false | false | false | false | false | false | false | POINT (-73.9724879969884 40.771098202397) | 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 );