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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2906 | 2906 | -73.9597260014375 | 40.790707423031 | 32E-AM-1007-04 | 32E | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9597260014375 40.790707423031) | 19 | 4 | 19 | 13 | |||||
2905 | 2905 | -73.9784872728213 | 40.7688122603932 | 3C-AM-1007-01 | 03C | AM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9784872728213 40.7688122603932) | 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 | |||||
2902 | 2902 | -73.9673220504383 | 40.7770296345963 | 15G-PM-1019-04 | 15G | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9673220504383 40.7770296345963) | 19 | 4 | 19 | 13 | ||||||
2901 | 2901 | -73.9735833104203 | 40.7786318041581 | 14A-PM-1014-08 | 14A | PM | 10142018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | new movement flailing arms while foraging | false | false | false | false | false | false | false | true | POINT (-73.9735833104203 40.7786318041581) | 19 | 4 | 19 | 13 | ||||
2899 | 2899 | -73.9686358129525 | 40.7778035516486 | 16E-AM-1014-05 | 16E | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686358129525 40.7778035516486) | 19 | 4 | 19 | 13 | |||||
2897 | 2897 | -73.9689554458632 | 40.7778593393957 | 16E-PM-1018-10 | 16E | PM | 10182018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9689554458632 40.7778593393957) | 19 | 4 | 19 | 13 | |||||
2895 | 2895 | -73.9747873899653 | 40.7731945258327 | 9C-PM-1006-04 | 09C | PM | 10062018 | 4 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9747873899653 40.7731945258327) | 19 | 4 | 19 | 13 | |||||
2894 | 2894 | -73.979734151564 | 40.7682150214703 | 2B-AM-1010-06 | 02B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.979734151564 40.7682150214703) | 19 | 4 | 19 | 13 | ||||||
2893 | 2893 | -73.9793101482654 | 40.7692600238491 | 3B-PM-1007-02 | 03B | PM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | in tree | false | false | false | false | false | chased by dog | false | false | false | false | false | false | false | false | POINT (-73.9793101482654 40.7692600238491) | 19 | 4 | 19 | 13 | ||||
2892 | 2892 | -73.9688070760806 | 40.7779688294172 | 16E-AM-1014-06 | 16E | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.9688070760806 40.777968829417205) | 19 | 4 | 19 | 13 | |||||
2891 | 2891 | -73.9636482556874 | 40.7775831570186 | 18I-PM-1007-05 | 18I | PM | 10072018 | 5 | Juvenile | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | false | false | false | false | true | jumping crazily / digging hole | false | false | false | false | false | false | true | false | POINT (-73.9636482556874 40.7775831570186) | 19 | 4 | 19 | 13 | ||||
2890 | 2890 | -73.9726236083428 | 40.7788217771475 | 15B-PM-1017-03 | 15B | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by water | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9726236083428 40.778821777147506) | 19 | 4 | 19 | 13 | ||||
2889 | 2889 | -73.9771646835311 | 40.7693049165084 | 4C-PM-1010-05 | 04C | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9771646835311 40.7693049165084) | 19 | 4 | 19 | 13 | |||||
2888 | 2888 | -73.955258162768 | 40.7958147673603 | 39E-AM-1018-01 | 39E | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | standing still | false | false | false | false | false | false | false | true | POINT (-73.955258162768 40.7958147673603) | 19 | 4 | 19 | 13 | ||||
2887 | 2887 | -73.964593167562 | 40.7780374890066 | 18H-PM-1014-02 | 18H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.964593167562 40.7780374890066) | 19 | 4 | 19 | 13 | |||||
2886 | 2886 | -73.9729265300533 | 40.7741768291642 | 10D-AM-1008-02 | 10D | AM | 10082018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9729265300533 40.7741768291642) | 19 | 4 | 19 | 13 | |||||
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 | |||||
2882 | 2882 | -73.956581233786 | 40.7902127690837 | 33H-AM-1019-01 | 33H | AM | 10192018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Cinnamon patches | Ground Plane | FALSE | false | false | false | false | false | wrestling with child | false | false | false | false | false | false | false | false | POINT (-73.956581233786 40.79021276908371) | 19 | 4 | 19 | 13 | |||
2881 | 2881 | -73.9541629063295 | 40.7934259301577 | 37G-AM-1014-02 | 37G | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | ran away & disappeared | false | false | false | false | false | false | false | false | POINT (-73.9541629063295 40.7934259301577) | 19 | 4 | 19 | 13 | |||||
2880 | 2880 | -73.9726598256924 | 40.7707862446236 | 7F-PM-1012-03 | 07F | PM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | false | true | POINT (-73.9726598256924 40.7707862446236) | 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 | |||
2877 | 2877 | -73.9730027200009 | 40.7798000868804 | 16A-PM-1019-05 | 16A | PM | 10192018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9730027200009 40.7798000868804) | 19 | 4 | 19 | 13 | |||||
2876 | 2876 | -73.9558995737654 | 40.7960097734603 | 39E-AM-1018-05 | 39E | AM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9558995737654 40.7960097734603) | 19 | 4 | 19 | 13 | |||||
2873 | 2873 | -73.955068474109 | 40.7911788152878 | 34H-PM-1006-05 | 34H | PM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | white tail tip | Ground Plane | FALSE | in grass | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.955068474109 40.7911788152878) | 19 | 4 | 19 | 13 | |||
2872 | 2872 | -73.9615396457996 | 40.7923594366783 | 33C-AM-1012-01 | 33C | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along tail & back | Above Ground | 20 | tree branches | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9615396457996 40.7923594366783) | 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 | |||||
2870 | 2870 | -73.9538475741188 | 40.796479421955 | 40F-PM-1006-02 | 40F | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9538475741188 40.796479421955) | 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 | ||||||||
2868 | 2868 | -73.9653873284496 | 40.7804699882574 | 20F-PM-1007-11 | 20F | PM | 10072018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 10 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9653873284496 40.7804699882574) | 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 | |||||
2866 | 2866 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 10172018 | 4 | Adult | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
2865 | 2865 | -73.9802842404016 | 40.7678257384977 | 1B-PM-1019-03 | 01B | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.98028424040162 40.7678257384977) | 19 | 4 | 19 | 13 | ||||
2864 | 2864 | -73.9761879300037 | 40.7683918970301 | 3E-PM-1008-01 | 03E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9761879300037 40.7683918970301) | 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 | ||||
2861 | 2861 | -73.9720102361126 | 40.7692143930301 | 6G-PM-1020-01 | 06G | PM | 10202018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9720102361126 40.7692143930301) | 19 | 4 | 19 | 13 | ||||||
2860 | 2860 | -73.9565179671319 | 40.7936663940365 | 36F-PM-1012-03 | 36F | PM | 10122018 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95651796713192 40.7936663940365) | 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 | |||||
2857 | 2857 | -73.9649230271173 | 40.7821766215675 | 22F-PM-1014-02 | 22F | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9649230271173 40.7821766215675) | 19 | 4 | 19 | 13 | |||||
2856 | 2856 | -73.9751615527833 | 40.767013871509 | 3F-AM-1006-03 | 03F | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | on the path | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9751615527833 40.767013871509) | 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 | |||||
2853 | 2853 | -73.9678613185071 | 40.7822170887526 | 20C-PM-1018-03 | 20C | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9678613185071 40.7822170887526) | 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 | ||||
2850 | 2850 | -73.9744847446854 | 40.76924227444 | 5E-AM-1008-04 | 05E | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9744847446854 40.76924227444) | 19 | 4 | 19 | 13 | ||||||
2848 | 2848 | -73.9715977170548 | 40.7742172650622 | 11E-AM-1013-03 | 11E | AM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | burying | false | false | false | false | false | false | true | false | POINT (-73.9715977170548 40.774217265062205) | 19 | 4 | 19 | 13 | |||||
2847 | 2847 | -73.9568378330302 | 40.7880317802766 | 30I-PM-1006-04 | 30I | PM | 10062018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9568378330302 40.7880317802766) | 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 | |||||
2844 | 2844 | -73.9578840941242 | 40.7955586232429 | 37D-PM-1014-06 | 37D | PM | 10142018 | 6 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9578840941242 40.7955586232429) | 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 | |||||
2842 | 2842 | -73.9579292340076 | 40.7976287835027 | 39C-PM-1006-04 | 39C | PM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9579292340076 40.7976287835027) | 19 | 4 | 19 | 13 | |||||
2841 | 2841 | -73.9693262952166 | 40.783260411082 | 21B-AM-1019-01 | 21B | AM | 10192018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9693262952166 40.783260411082) | 19 | 4 | 19 | 13 | ||||||
2840 | 2840 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 10172018 | 4 | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
2838 | 2838 | -73.9507699667119 | 40.7955166039555 | 40I-AM-1018-02 | 40I | AM | 10182018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9507699667119 40.795516603955505) | 19 | 4 | 19 | 13 | ||||||
2837 | 2837 | -73.9772691210241 | 40.7690960712994 | 4D-PM-1008-13 | 04D | PM | 10082018 | 13 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9772691210241 40.7690960712994) | 19 | 4 | 19 | 13 | |||||
2836 | 2836 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 10172018 | 3 | Gray | Cinnamon | Gray+Cinnamon | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.953092053256 40.7982256930243) | 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 | ||||||
2834 | 2834 | -73.9651132904127 | 40.7905384124102 | 29A-PM-1019-02 | 29A | PM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9651132904127 40.7905384124102) | 19 | 4 | 19 | 13 | |||||
2832 | 2832 | -73.958607566971 | 40.7983695505584 | 40B-PM-1014-04 | 40B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.958607566971 40.7983695505584) | 19 | 4 | 19 | 13 | |||||
2831 | 2831 | -73.9753585157592 | 40.7698398607941 | 5E-AM-1008-07 | 05E | AM | 10082018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | on fence | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9753585157592 40.7698398607941) | 19 | 4 | 19 | 13 | ||||
2830 | 2830 | -73.9556083695689 | 40.7965223709493 | 39E-AM-1018-02 | 39E | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9556083695689 40.7965223709493) | 19 | 4 | 19 | 13 | ||||||
2829 | 2829 | -73.9565230963554 | 40.798556387711 | 41C-PM-1007-02 | 41C | PM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565230963554 40.798556387711) | 19 | 4 | 19 | 13 | |||||
2828 | 2828 | -73.9587439756541 | 40.7849006107353 | 27I-AM-1007-04 | 27I | AM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.9587439756541 40.7849006107353) | 19 | 4 | 19 | 13 | |||||
2827 | 2827 | -73.9778578822323 | 40.7705432705286 | 5B-PM-1013-03 | 05B | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | grooming | false | false | false | false | false | false | false | false | POINT (-73.9778578822323 40.7705432705286) | 19 | 4 | 19 | 13 | |||||
2826 | 2826 | -73.9600357018376 | 40.7906539766881 | 32E-AM-1007-08 | 32E | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 65 | tree top | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9600357018376 40.7906539766881) | 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 | |||||
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 | ||||
2821 | 2821 | -73.9754536566013 | 40.7698604918771 | 5E-PM-1012-04 | 05E | PM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9754536566013 40.7698604918771) | 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 | ||||
2819 | 2819 | -73.9550350096938 | 40.797694218705 | 41E-PM-1013-02 | 41E | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9550350096938 40.797694218705004) | 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 | |||||
2817 | 2817 | -73.9596445861554 | 40.7971948679007 | 38A-PM-1013-05 | 38A | PM | 10132018 | 5 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9596445861554 40.7971948679007) | 19 | 4 | 19 | 13 | ||||||
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 | |||||
2814 | 2814 | -73.9551625272308 | 40.791193071916 | 34H-PM-1006-06 | 34H | PM | 10062018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | in grass | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9551625272308 40.791193071916) | 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 | ||||||
2812 | 2812 | -73.963209639301 | 40.7926138443715 | 32A-PM-1013-07 | 32A | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.963209639301 40.7926138443715) | 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 | ||||
2810 | 2810 | -73.9614659899028 | 40.7945562907624 | 35A-PM-1013-10 | 35A | PM | 10132018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9614659899028 40.7945562907624) | 19 | 4 | 19 | 13 | |||||
2809 | 2809 | -73.9686756254868 | 40.7777459102651 | 16E-AM-1014-04 | 16E | AM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9686756254868 40.7777459102651) | 19 | 4 | 19 | 13 | |||||
2808 | 2808 | -73.9765027953575 | 40.7717327360835 | 7C-AM-1012-02 | 07C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | hopping around | false | false | false | false | false | false | true | false | POINT (-73.9765027953575 40.7717327360835) | 19 | 4 | 19 | 13 | ||||
2807 | 2807 | -73.9618213644671 | 40.7927648819738 | 33B-AM-1010-02 | 33B | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96182136446711 40.7927648819738) | 19 | 4 | 19 | 13 | ||||||
2806 | 2806 | -73.9714298880357 | 40.77410578689 | 11E-PM-1012-02 | 11E | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714298880357 40.77410578689) | 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 | |||||
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 | |||||
2799 | 2799 | -73.9682627382073 | 40.7730766743452 | 11H-AM-1010-09 | 11H | AM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9682627382073 40.7730766743452) | 19 | 4 | 19 | 13 | |||||
2798 | 2798 | -73.9753825640019 | 40.7671662013861 | 3F-PM-1013-04 | 03F | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9753825640019 40.7671662013861) | 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 | ||||||
2796 | 2796 | -73.9631089011412 | 40.789191946875 | 29C-PM-1006-02 | 29C | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9631089011412 40.789191946875) | 19 | 4 | 19 | 13 | |||||
2795 | 2795 | -73.9541056052047 | 40.7939863923231 | 37G-PM-1007-06 | 37G | PM | 10072018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9541056052047 40.7939863923231) | 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 | |||||
2793 | 2793 | -73.9742847552668 | 40.7731740123046 | 9D-AM-1008-02 | 09D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9742847552668 40.7731740123046) | 19 | 4 | 19 | 13 | ||||||
2792 | 2792 | -73.9723736494597 | 40.7669501343297 | 4H-AM-1006-01 | 04H | AM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9723736494597 40.7669501343297) | 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 | ||||||
2789 | 2789 | -73.9686800784941 | 40.7766739029138 | 15F-AM-1007-03 | 15F | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686800784941 40.7766739029138) | 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 );