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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2921 | 2921 | -73.9699573485164 | 40.7765857838015 | 14E-AM-1008-10 | 14E | AM | 10082018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9699573485164 40.7765857838015) | 19 | 4 | 19 | 13 | ||||||
2916 | 2916 | -73.9517525111679 | 40.7974407641075 | 42G-PM-1014-02 | 42G | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 14 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9517525111679 40.7974407641075) | 19 | 4 | 19 | 13 | |||||
2915 | 2915 | -73.9734630412566 | 40.7653097139415 | 1H-PM-1013-02 | 01H | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9734630412566 40.7653097139415) | 19 | 4 | 19 | 13 | |||||
2912 | 2912 | -73.9632164738341 | 40.7921270121312 | 32B-PM-1010-03 | 32B | PM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9632164738341 40.7921270121312) | 19 | 4 | 19 | 13 | |||||
2903 | 2903 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9670432105975 40.7753462013506) | 19 | 4 | 19 | 13 | |||||
2885 | 2885 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9530811255728 40.79830691185791) | 19 | 4 | 19 | 13 | |||||
2879 | 2879 | -73.9744080700098 | 40.7731515721826 | 9C-PM-1006-07 | 09C | PM | 10062018 | 7 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | on top of tarped sand pile | false | false | false | true | false | false | false | false | false | false | false | false | true | (me) | POINT (-73.9744080700098 40.7731515721826) | 19 | 4 | 19 | 13 | |||
2878 | 2878 | -73.969720780557 | 40.7741105688757 | 12F-AM-1020-04 | 12F | AM | 10202018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.969720780557 40.7741105688757) | 19 | 4 | 19 | 13 | |||||
2871 | 2871 | -73.9777124331985 | 40.7704051056666 | 5B-AM-1008-03 | 05B | AM | 10082018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9777124331985 40.7704051056666) | 19 | 4 | 19 | 13 | |||||
2869 | 2869 | -73.9630822385425 | 40.7914844989865 | 31B-PM-1007-04 | 31B | PM | 10072018 | 4 | Juvenile | Gray | Gray+ | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9630822385425 40.7914844989865) | 19 | 4 | 19 | 13 | ||||||||
2867 | 2867 | -73.969370141813 | 40.7840721191988 | 22A-PM-1017-03 | 22A | PM | 10172018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.969370141813 40.7840721191988) | 19 | 4 | 19 | 13 | |||||
2863 | 2863 | -73.9698246369929 | 40.7711472794488 | 9H-AM-1006-04 | 09H | AM | 10062018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9698246369929 40.7711472794488) | 19 | 4 | 19 | 13 | |||||
2862 | 2862 | -73.967466716152 | 40.7824346548278 | 21D-PM-1008-04 | 21D | PM | 10082018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | false | false | false | true | false | false | false | false | false | false | false | false | true | i scared it | POINT (-73.967466716152 40.7824346548278) | 19 | 4 | 19 | 13 | ||||
2859 | 2859 | -73.9786940945874 | 40.7690820276888 | 3B-PM-1007-05 | 03B | PM | 10072018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 6 | on rock | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9786940945874 40.7690820276888) | 19 | 4 | 19 | 13 | |||||
2858 | 2858 | -73.9728723853967 | 40.7670816164986 | 4H-PM-1006-01 | 04H | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9728723853967 40.7670816164986) | 19 | 4 | 19 | 13 | |||||
2854 | 2854 | -73.9772908667333 | 40.7697207404744 | 4C-AM-1006-05 | 04C | AM | 10062018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9772908667333 40.7697207404744) | 19 | 4 | 19 | 13 | |||||
2852 | 2852 | -73.9728146482385 | 40.7652951714745 | 1I-PM-1012-03 | 01I | PM | 10122018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.97281464823851 40.765295171474506) | 19 | 4 | 19 | 13 | ||||
2846 | 2846 | -73.9661570478029 | 40.7807271518813 | 20E-AM-1014-02 | 20E | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9661570478029 40.7807271518813) | 19 | 4 | 19 | 13 | |||||
2845 | 2845 | -73.9765016413674 | 40.7740672862953 | 9A-AM-1013-06 | 09A | AM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9765016413674 40.7740672862953) | 19 | 4 | 19 | 13 | |||||
2843 | 2843 | -73.9714787178201 | 40.7798049470745 | 16B-PM-1017-01 | 16B | PM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9714787178201 40.7798049470745) | 19 | 4 | 19 | 13 | |||||
2835 | 2835 | -73.9531953594918 | 40.7960413520131 | 40G-PM-1013-01 | 40G | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9531953594918 40.7960413520131) | 19 | 4 | 19 | 13 | ||||||
2833 | 2833 | -73.9552595564798 | 40.7889533029466 | 32I-PM-1007-01 | 32I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | true | true | chirps | false | false | false | false | true | false | true | false | POINT (-73.9552595564798 40.7889533029466) | 19 | 4 | 19 | 13 | ||||
2825 | 2825 | -73.9643507588008 | 40.7904324693292 | 30B-PM-1019-07 | 30B | PM | 10192018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.96435075880082 40.7904324693292) | 19 | 4 | 19 | 13 | |||||
2823 | 2823 | -73.9664054327771 | 40.7756180893318 | 14H-PM-1012-07 | 14H | PM | 10122018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9664054327771 40.7756180893318) | 19 | 4 | 19 | 13 | |||||
2816 | 2816 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | false | false | false | true | true | false | false | false | false | true | true | true | false | POINT (-73.9809342290598 40.7687265606227) | 19 | 4 | 19 | 13 | ||||
2805 | 2805 | -73.9711634340673 | 40.7760553338671 | 13D-AM-1014-05 | 13D | AM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9711634340673 40.7760553338671) | 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 | |||||
2802 | 2802 | -73.9533101544112 | 40.7938634280159 | 38H-AM-1019-01 | 38H | AM | 10192018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9533101544112 40.7938634280159) | 19 | 4 | 19 | 13 | |||||
2801 | 2801 | -73.9697665830132 | 40.7759094917104 | 13E-PM-1008-08 | 13E | PM | 10082018 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9697665830132 40.7759094917104) | 19 | 4 | 19 | 13 | |||||
2800 | 2800 | -73.9802983138318 | 40.7676540772339 | 1B-PM-1019-05 | 01B | PM | 10192018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9802983138318 40.7676540772339) | 19 | 4 | 19 | 13 | |||||
2797 | 2797 | -73.9576913492669 | 40.7994216061391 | 41B-AM-1010-11 | 41B | AM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | false | eating a mushroom! | false | false | false | false | false | false | true | false | POINT (-73.9576913492669 40.7994216061391) | 19 | 4 | 19 | 13 | ||||||
2785 | 2785 | -73.9729105002306 | 40.7672758037086 | 4H-PM-1006-02 | 04H | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9729105002306 40.7672758037086) | 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 | ||||
2781 | 2781 | -73.9752673884392 | 40.7662642413761 | 2G-AM-1010-04 | 02G | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9752673884392 40.7662642413761) | 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 | ||||
2775 | 2775 | -73.9697109398302 | 40.7776218260789 | 15E-PM-1008-06 | 15E | PM | 10082018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | burying | false | false | false | false | false | false | true | false | POINT (-73.9697109398302 40.7776218260789) | 19 | 4 | 19 | 13 | |||||
2774 | 2774 | -73.9705409446299 | 40.7764608087703 | 14E-PM-1017-03 | 14E | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9705409446299 40.7764608087703) | 19 | 4 | 19 | 13 | |||||
2769 | 2769 | -73.9769885189342 | 40.7708936173356 | 5C-PM-1010-06 | 05C | PM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9769885189342 40.7708936173356) | 19 | 4 | 19 | 13 | |||||
2766 | 2766 | -73.9551639847466 | 40.790858199891 | 34H-PM-1006-03 | 34H | PM | 10062018 | 3 | Gray | White | Gray+White | white belly | Ground Plane | FALSE | Under Tupelo Tree | false | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.9551639847466 40.790858199891) | 19 | 4 | 19 | 13 | ||||
2764 | 2764 | -73.9692660977515 | 40.7830532310766 | 21B-PM-1017-01 | 21B | PM | 10172018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | paused to look at me | POINT (-73.9692660977515 40.7830532310766) | 19 | 4 | 19 | 13 | ||||
2756 | 2756 | -73.9787312025627 | 40.7701071405918 | 4B-PM-1018-04 | 04B | PM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9787312025627 40.7701071405918) | 19 | 4 | 19 | 13 | ||||||
2750 | 2750 | -73.957775998085 | 40.7932880937406 | 35E-PM-1006-05 | 35E | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.957775998085 40.7932880937406) | 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 | |||||
2740 | 2740 | -73.9612658688914 | 40.7912119940469 | 32C-AM-1014-04 | 32C | AM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9612658688914 40.7912119940469) | 19 | 4 | 19 | 13 | ||||||
2739 | 2739 | -73.9681960138614 | 40.7726867422002 | 11H-AM-1010-02 | 11H | AM | 10102018 | 2 | Cinnamon | Gray | Cinnamon+Gray | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9681960138614 40.7726867422002) | 19 | 4 | 19 | 13 | ||||||||
2736 | 2736 | -73.9593895253501 | 40.7973085844087 | 38B-AM-1019-03 | 38B | AM | 10192018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9593895253501 40.7973085844087) | 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 | ||||
2726 | 2726 | -73.9734206435334 | 40.7657854684194 | 2H-PM-1006-01 | 02H | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9734206435334 40.7657854684194) | 19 | 4 | 19 | 13 | ||||||
2725 | 2725 | -73.9658867660358 | 40.7756523577509 | 15H-PM-1008-06 | 15H | PM | 10082018 | 6 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | base of gingko tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9658867660358 40.7756523577509) | 19 | 4 | 19 | 13 | ||||
2723 | 2723 | -73.960642602756 | 40.7917265419842 | 32D-PM-1006-08 | 32D | PM | 10062018 | 8 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | false | stand on two feet and watching me | POINT (-73.960642602756 40.7917265419842) | 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 | ||||
2716 | 2716 | -73.9618094076328 | 40.7944097368153 | 35A-PM-1013-03 | 35A | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9618094076328 40.7944097368153) | 19 | 4 | 19 | 13 | |||||
2711 | 2711 | -73.9628842960118 | 40.7938048572403 | 34A-PM-1013-01 | 34A | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | took a chestnut | false | false | false | false | false | false | false | false | POINT (-73.9628842960118 40.7938048572403) | 19 | 4 | 19 | 13 | ||||
2707 | 2707 | -73.9743165321099 | 40.7754674678574 | 11B-PM-1014-07 | 11B | PM | 10142018 | 7 | Gray | Gray+ | Above Ground | 10 | true | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9743165321099 40.7754674678574) | 19 | 4 | 19 | 13 | |||||||
2706 | 2706 | -73.9745141185576 | 40.7691479781207 | 5E-AM-1008-01 | 05E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on a checker table | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9745141185576 40.7691479781207) | 19 | 4 | 19 | 13 | ||||
2701 | 2701 | -73.9791217510656 | 40.7676583475394 | 2C-AM-1010-05 | 02C | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | right at the base of the same tree as #3 | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9791217510656 40.7676583475394) | 19 | 4 | 19 | 13 | ||||
2683 | 2683 | -73.972179947936 | 40.7810042827198 | 17A-PM-1013-02 | 17A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | on a little pedestal-shaped part of a tree | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.972179947936 40.7810042827198) | 19 | 4 | 19 | 13 | ||||
2682 | 2682 | -73.9711001278389 | 40.7787466095841 | 15C-PM-1017-01 | 15C | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9711001278389 40.7787466095841) | 19 | 4 | 19 | 13 | |||||
2677 | 2677 | -73.97348276186 | 40.7656171832911 | 2H-PM-1006-02 | 02H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.97348276186 40.7656171832911) | 19 | 4 | 19 | 13 | ||||||
2671 | 2671 | -73.9743369068254 | 40.7675726965985 | 3F-AM-1006-11 | 03F | AM | 10062018 | 11 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9743369068254 40.7675726965985) | 19 | 4 | 19 | 13 | |||||
2665 | 2665 | -73.969784066769 | 40.7766940405403 | 14E-AM-1008-11 | 14E | AM | 10082018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | burying | false | false | false | false | false | false | true | false | curious | POINT (-73.969784066769 40.7766940405403) | 19 | 4 | 19 | 13 | |||
2659 | 2659 | -73.9553603438021 | 40.7985282963244 | 41D-PM-1014-05 | 41D | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 12 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9553603438021 40.7985282963244) | 19 | 4 | 19 | 13 | |||||
2655 | 2655 | -73.9659156108069 | 40.7810709818696 | 20E-AM-1014-01 | 20E | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9659156108069 40.7810709818696) | 19 | 4 | 19 | 13 | |||||
2648 | 2648 | -73.9729410488021 | 40.7709484964577 | 7F-AM-1008-13 | 07F | AM | 10082018 | 13 | Adult | Gray | Gray+ | Above Ground | 4 | to tree | true | false | false | true | true | ran up tree 4 feet and ate leaves | false | false | false | false | false | false | true | false | POINT (-73.9729410488021 40.7709484964577) | 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 | |||||
2645 | 2645 | -73.9584967368893 | 40.7977320341094 | 39B-PM-1014-05 | 39B | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous. | false | false | false | false | false | false | true | false | POINT (-73.9584967368893 40.7977320341094) | 19 | 4 | 19 | 13 | ||||
2641 | 2641 | -73.9615516703494 | 40.7905219388359 | 31D-AM-1014-04 | 31D | AM | 10142018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | Open ground | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9615516703494 40.7905219388359) | 19 | 4 | 19 | 13 | |||||
2636 | 2636 | -73.9700264128414 | 40.7692014637698 | 7I-PM-1013-01 | 07I | PM | 10132018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | Bench | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9700264128414 40.7692014637698) | 19 | 4 | 19 | 13 | ||||
2635 | 2635 | -73.9763836740342 | 40.7706121151491 | 5C-AM-1006-06 | 05C | AM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9763836740342 40.7706121151491) | 19 | 4 | 19 | 13 | |||||
2626 | 2626 | -73.9737329655838 | 40.7726424441344 | 8D-PM-1007-02 | 08D | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9737329655838 40.7726424441344) | 19 | 4 | 19 | 13 | |||||
2625 | 2625 | -73.9699188544459 | 40.7772180370053 | 15E-PM-1008-09 | 15E | PM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9699188544459 40.7772180370053) | 19 | 4 | 19 | 13 | ||||||
2618 | 2618 | -73.95795157569 | 40.7961254697958 | 38C-PM-1014-04 | 38C | PM | 10142018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.95795157569 40.7961254697958) | 19 | 4 | 19 | 13 | |||||
2615 | 2615 | -73.9734605176646 | 40.7686218881386 | 5G-PM-1010-02 | 05G | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9734605176646 40.7686218881386) | 19 | 4 | 19 | 13 | |||||
2614 | 2614 | -73.9765877920583 | 40.7660946071574 | 1F-AM-1010-04 | 01F | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9765877920583 40.7660946071574) | 19 | 4 | 19 | 13 | ||||||
2613 | 2613 | -73.96393252683 | 40.7808289765857 | 21G-AM-1014-04 | 21G | AM | 10142018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 6 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.96393252683 40.7808289765857) | 19 | 4 | 19 | 13 | |||||
2610 | 2610 | -73.9713379914423 | 40.7696367609606 | 7H-PM-1006-01 | 07H | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | middle of grass | false | false | false | true | true | false | false | false | false | true | true | false | false | POINT (-73.9713379914423 40.7696367609606) | 19 | 4 | 19 | 13 | ||||
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 | ||||
2606 | 2606 | -73.96143417385 | 40.7945464262112 | 35B-PM-1013-02 | 35B | PM | 10132018 | 2 | Juvenile | + | Ground Plane | FALSE | false | false | false | true | false | did not notice dog sitting a few yards away (10-20 ft) | false | false | false | false | true | false | true | false | POINT (-73.96143417385 40.7945464262112) | 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 | |||||
2602 | 2602 | -73.9754822938869 | 40.7717766893833 | 7C-PM-1020-01 | 07C | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9754822938869 40.7717766893833) | 19 | 4 | 19 | 13 | |||||
2600 | 2600 | -73.9544553697736 | 40.7912866208106 | 34I-AM-1012-01 | 34I | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9544553697736 40.7912866208106) | 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 | |||||
2593 | 2593 | -73.9590191812452 | 40.7906166981409 | 32E-PM-1017-08 | 32E | PM | 10172018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9590191812452 40.7906166981409) | 19 | 4 | 19 | 13 | |||||
2589 | 2589 | -73.9694166642262 | 40.7697788641081 | 8I-PM-1013-03 | 08I | PM | 10132018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694166642262 40.7697788641081) | 19 | 4 | 19 | 13 | |||||
2587 | 2587 | -73.9789971286844 | 40.7707024146365 | 5A-PM-1010-04 | 05A | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9789971286844 40.7707024146365) | 19 | 4 | 19 | 13 | |||||
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 | ||
2580 | 2580 | -73.970795746101 | 40.7704727212299 | 8H-PM-1014-01 | 08H | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.970795746101 40.7704727212299) | 19 | 4 | 19 | 13 | |||||
2579 | 2579 | -73.9698130452581 | 40.7745000645436 | 12F-PM-1007-15 | 12F | PM | 10072018 | 15 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9698130452581 40.7745000645436) | 19 | 4 | 19 | 13 | |||||
2578 | 2578 | -73.9765386965371 | 40.766371971273 | 1F-AM-1010-02 | 01F | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9765386965371 40.766371971273) | 19 | 4 | 19 | 13 | ||||||
2575 | 2575 | -73.9735753352129 | 40.7687061447032 | 5G-PM-1010-04 | 05G | PM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9735753352129 40.7687061447032) | 19 | 4 | 19 | 13 | |||||
2573 | 2573 | -73.9810149147578 | 40.7683925377714 | 2A-AM-1010-03 | 02A | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | on trunk | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9810149147578 40.7683925377714) | 19 | 4 | 19 | 13 | ||||
2566 | 2566 | -73.9744226682925 | 40.7755625717273 | 11B-AM-1007-04 | 11B | AM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9744226682925 40.7755625717273) | 19 | 4 | 19 | 13 | ||||||
2551 | 2551 | -73.970138810251 | 40.770579297644 | 8H-PM-1014-02 | 08H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | froze & watched me,then went back to eating | POINT (-73.970138810251 40.770579297644) | 19 | 4 | 19 | 13 | ||||
2549 | 2549 | -73.972248505758 | 40.7659043693008 | 3I-PM-1013-01 | 03I | PM | 10132018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.972248505758 40.765904369300806) | 19 | 4 | 19 | 13 | ||||||
2545 | 2545 | -73.9617594316752 | 40.7946803725236 | 35A-AM-1014-01 | 35A | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9617594316752 40.7946803725236) | 19 | 4 | 19 | 13 | |||||
2533 | 2533 | -73.9766195697096 | 40.7661907261547 | 1F-AM-1010-04 | 01F | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9766195697096 40.7661907261547) | 19 | 4 | 19 | 13 | ||||||
2526 | 2526 | -73.9646495450499 | 40.7791203699027 | 19H-PM-1008-01 | 19H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9646495450499 40.7791203699027) | 19 | 4 | 19 | 13 | |||||
2515 | 2515 | -73.9693338657183 | 40.7757055884538 | 13F-PM-1008-05 | 13F | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | tree trunk | true | false | false | true | true | true | false | false | false | true | false | false | false | POINT (-73.9693338657183 40.77570558845381) | 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 | |||||
2510 | 2510 | -73.9748635473782 | 40.7742591029151 | 10C-AM-1018-02 | 10C | AM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | sitting in the sun | false | false | false | false | false | false | true | false | POINT (-73.9748635473782 40.7742591029151) | 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 );