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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1941 | 1941 | -73.9704790263224 | 40.7762270645666 | 13E-AM-1017-01 | 13E | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | in middle of path | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9704790263224 40.7762270645666) | 19 | 4 | 19 | 13 | |||||
1942 | 1942 | -73.96249054313 | 40.7935389038787 | 33A-PM-1018-01 | 33A | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | stopped to see what i would do 1st | POINT (-73.96249054313 40.7935389038787) | 19 | 4 | 19 | 13 | |||||
1945 | 1945 | -73.9530257401736 | 40.795139740737 | 39G-PM-1013-01 | 39G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9530257401736 40.79513974073701) | 19 | 4 | 19 | 13 | |||||
1952 | 1952 | -73.9681810466693 | 40.7720638449419 | 10I-PM-1013-01 | 10I | PM | 10132018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9681810466693 40.7720638449419) | 19 | 4 | 19 | 13 | |||||
1957 | 1957 | -73.9684187207423 | 40.780592789876 | 18D-AM-1018-01 | 18D | AM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | cleaning | false | false | false | false | false | false | false | false | POINT (-73.9684187207423 40.780592789876) | 19 | 4 | 19 | 13 | |||||
1965 | 1965 | -73.9719359643975 | 40.772699885583 | 9F-PM-1014-01 | 09F | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | he is fed every day by a woman who calls him "chiquita"! he ran right up to her. | POINT (-73.9719359643975 40.772699885583) | 19 | 4 | 19 | 13 | ||||
1974 | 1974 | -73.9772420734509 | 40.7730025191407 | 7A-PM-1007-01 | 07A | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9772420734509 40.7730025191407) | 19 | 4 | 19 | 13 | ||||||
1975 | 1975 | -73.9753291616796 | 40.7687376032936 | 4E-PM-1008-01 | 04E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9753291616796 40.7687376032936) | 19 | 4 | 19 | 13 | |||||
1976 | 1976 | -73.9770920860805 | 40.7694698040083 | 4C-PM-1010-01 | 04C | PM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | true | false | false | false | true | false | false | false | false | true | false | POINT (-73.9770920860805 40.7694698040083) | 19 | 4 | 19 | 13 | |||||
1980 | 1980 | -73.9686635017966 | 40.7843176732828 | 22B-PM-1014-01 | 22B | PM | 10142018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.96866350179661 40.7843176732828) | 19 | 4 | 19 | 13 | |||||
1982 | 1982 | -73.9729979174723 | 40.7742904356698 | 10D-PM-1008-01 | 10D | PM | 10082018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9729979174723 40.7742904356698) | 19 | 4 | 19 | 13 | |||||
1983 | 1983 | -73.9784144867639 | 40.7718177667511 | 6A-AM-1006-01 | 06A | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | false | false | POINT (-73.9784144867639 40.7718177667511) | 19 | 4 | 19 | 13 | |||||
1997 | 1997 | -73.9714637683084 | 40.7768984561563 | 14D-PM-1019-01 | 14D | PM | 10192018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9714637683084 40.7768984561563) | 19 | 4 | 19 | 13 | ||||||
2003 | 2003 | -73.9640526358598 | 40.7907411574825 | 30B-AM-1007-01 | 30B | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9640526358598 40.7907411574825) | 19 | 4 | 19 | 13 | ||||||
2005 | 2005 | -73.9755259087781 | 40.7707256124181 | 6D-AM-1008-01 | 06D | AM | 10082018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | false | false | true | true | false | true | false | false | false | false | true | false | false | POINT (-73.9755259087781 40.7707256124181) | 19 | 4 | 19 | 13 | |||||
2008 | 2008 | -73.9524364087437 | 40.792846505434 | 37I-PM-1006-01 | 37I | PM | 10062018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Above Ground | 5 | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9524364087437 40.792846505434) | 19 | 4 | 19 | 13 | |||||
2009 | 2009 | -73.9639505810228 | 40.789573183584 | 29B-PM-1010-01 | 29B | PM | 10102018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 4 | climbing trees | false | false | true | true | true | scratching self | false | false | false | false | true | false | true | false | POINT (-73.9639505810228 40.789573183584) | 19 | 4 | 19 | 13 | |||
2016 | 2016 | -73.9589492240754 | 40.798901118974 | 40A-PM-1014-01 | 40A | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | false | false | false | false | true | false | true | false | stared & then went back up tree—then ran to different tree | POINT (-73.9589492240754 40.798901118974) | 19 | 4 | 19 | 13 | ||||
2019 | 2019 | -73.9566705412766 | 40.7935560645735 | 36F-PM-1012-01 | 36F | PM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | Near rock | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9566705412766 40.7935560645735) | 19 | 4 | 19 | 13 | ||||
2030 | 2030 | -73.9749251267433 | 40.7679111971294 | 4F-PM-1013-01 | 04F | PM | 10132018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9749251267433 40.7679111971294) | 19 | 4 | 19 | 13 | |||||
2033 | 2033 | -73.9500167570283 | 40.7966185836685 | 41I-AM-1018-01 | 41I | AM | 10182018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | false | cautious,observant,runs off | POINT (-73.9500167570283 40.7966185836685) | 19 | 4 | 19 | 13 | ||||
2044 | 2044 | -73.9771552326199 | 40.7706917595308 | 5C-AM-1006-01 | 05C | AM | 10062018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | true | false | false | POINT (-73.9771552326199 40.7706917595308) | 19 | 4 | 19 | 13 | |||||
2046 | 2046 | -73.9706414863639 | 40.7732754837144 | 11F-PM-1006-01 | 11F | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9706414863639 40.7732754837144) | 19 | 4 | 19 | 13 | |||||
2054 | 2054 | -73.9726381234747 | 40.7752694815985 | 12D-PM-1014-01 | 12D | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9726381234747 40.7752694815985) | 19 | 4 | 19 | 13 | |||||
2058 | 2058 | -73.9669017345324 | 40.7766928987073 | 15G-AM-1008-01 | 15G | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9669017345324 40.7766928987073) | 19 | 4 | 19 | 13 | |||||
2067 | 2067 | -73.9725077933574 | 40.7654562710325 | 2I-PM-1006-01 | 02I | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | Sitting on back of bench with food hanging from mouth | false | false | false | false | false | staring at me | false | false | false | false | false | false | false | true | POINT (-73.9725077933574 40.7654562710325) | 19 | 4 | 19 | 13 | |||
2070 | 2070 | -73.9725700261894 | 40.7668793330427 | 3H-PM-1014-01 | 03H | PM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a parked car | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9725700261894 40.7668793330427) | 19 | 4 | 19 | 13 | |||||
2073 | 2073 | -73.9661108248377 | 40.7891945123815 | 28A-AM-1014-01 | 28A | AM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9661108248377 40.7891945123815) | 19 | 4 | 19 | 13 | ||||||
2088 | 2088 | -73.9651155880346 | 40.790694632578 | 30A-PM-1020-01 | 30A | PM | 10202018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9651155880346 40.790694632578) | 19 | 4 | 19 | 13 | |||||
2089 | 2089 | -73.9535980341677 | 40.7981186822179 | 42E-PM-1012-01 | 42E | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9535980341677 40.7981186822179) | 19 | 4 | 19 | 13 | |||||
2105 | 2105 | -73.9738723117119 | 40.7786845612246 | 14A-AM-1014-01 | 14A | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | foraging?,crossing road | false | false | false | false | false | false | true | true | runs from (dogs) | POINT (-73.9738723117119 40.7786845612246) | 19 | 4 | 19 | 13 | |||
2111 | 2111 | -73.968446056806 | 40.785824818871 | 24A-PM-1007-01 | 24A | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.96844605680602 40.785824818871) | 19 | 4 | 19 | 13 | |||||
2114 | 2114 | -73.9651541395415 | 40.7798283208748 | 19G-PM-1017-01 | 19G | PM | 10172018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 12 | false | false | false | false | false | watching | false | false | false | false | false | true | false | false | POINT (-73.9651541395415 40.7798283208748) | 19 | 4 | 19 | 13 | ||||
2115 | 2115 | -73.9658203999388 | 40.7775874026824 | 17G-PM-1017-01 | 17G | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | base of tree | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9658203999388 40.7775874026824) | 19 | 4 | 19 | 13 | |||||
2116 | 2116 | -73.9801562527339 | 40.7687267327113 | 2B-AM-1010-01 | 02B | AM | 10102018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9801562527339 40.7687267327113) | 19 | 4 | 19 | 13 | |||||
2118 | 2118 | -73.958369699409 | 40.7902456668332 | 32F-PM-1008-01 | 32F | PM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.958369699409 40.7902456668332) | 19 | 4 | 19 | 13 | ||||||
2119 | 2119 | -73.9641584395299 | 40.7816571644072 | 21G-AM-1014-01 | 21G | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9641584395299 40.7816571644072) | 19 | 4 | 19 | 13 | |||||
2121 | 2121 | -73.9693462354257 | 40.7764444385452 | 14E-PM-1017-01 | 14E | PM | 10172018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9693462354257 40.7764444385452) | 19 | 4 | 19 | 13 | |||||
2125 | 2125 | -73.9687933229572 | 40.7788600242549 | 17E-PM-1018-01 | 17E | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9687933229572 40.7788600242549) | 19 | 4 | 19 | 13 | |||||
2130 | 2130 | -73.9695572903383 | 40.780822981713 | 18C-AM-1018-01 | 18C | AM | 10182018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9695572903383 40.780822981713) | 19 | 4 | 19 | 13 | |||||
2134 | 2134 | -73.9614373639552 | 40.7945051962914 | 35B-PM-1013-01 | 35B | PM | 10132018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | did not notice dog sitting a few yards away (10-20 ft) | false | false | false | true | false | false | true | false | POINT (-73.9614373639552 40.7945051962914) | 19 | 4 | 19 | 13 | ||||
2142 | 2142 | -73.9598535425706 | 40.7915589343685 | 33D-PM-1006-01 | 33D | PM | 10062018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | hanging on fence | true | false | false | true | false | false | false | true | POINT (-73.9598535425706 40.7915589343685) | 19 | 4 | 19 | 13 | |||||
2143 | 2143 | -73.9596232170232 | 40.7959550843229 | 37B-PM-1013-01 | 37B | PM | 10132018 | 1 | Adult | Gray | Gray+ | Sighting was far away | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9596232170232 40.795955084322905) | 19 | 4 | 19 | 13 | |||||
2146 | 2146 | -73.9547398684817 | 40.7896483795302 | 33I-AM-1008-01 | 33I | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park @ 98th (north) | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9547398684817 40.7896483795302) | 19 | 4 | 19 | 13 | ||||
2147 | 2147 | -73.9651217998407 | 40.7761115392738 | 15I-PM-1012-01 | 15I | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9651217998407 40.7761115392738) | 19 | 4 | 19 | 13 | |||||
2150 | 2150 | -73.9557710118271 | 40.7919161185557 | 34G-PM-1006-01 | 34G | PM | 10062018 | 1 | Adult | Black | Black+ | Skinny, thin tail | Ground Plane | FALSE | false | false | false | false | false | digging | false | false | false | false | false | false | false | false | POINT (-73.9557710118271 40.7919161185557) | 19 | 4 | 19 | 13 | ||||
2161 | 2161 | -73.9715375915057 | 40.7751212088827 | 12D-AM-1013-01 | 12D | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9715375915057 40.7751212088827) | 19 | 4 | 19 | 13 | |||||
2163 | 2163 | -73.9643664403785 | 40.7793670703727 | 19H-AM-1010-01 | 19H | AM | 10102018 | 1 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near base of small tree | true | false | false | true | true | false | false | false | false | false | false | true | false | run from human w/ dog | POINT (-73.9643664403785 40.7793670703727) | 19 | 4 | 19 | 13 | ||||
2166 | 2166 | -73.9711178122133 | 40.7672642958437 | 4I-PM-1007-01 | 04I | PM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9711178122133 40.76726429584371) | 19 | 4 | 19 | 13 | ||||||
2169 | 2169 | -73.9787736280005 | 40.7676126748454 | 2C-AM-1010-01 | 02C | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9787736280005 40.7676126748454) | 19 | 4 | 19 | 13 | |||||
2181 | 2181 | -73.9702530172652 | 40.7736241205021 | 11F-AM-1013-01 | 11F | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9702530172652 40.7736241205021) | 19 | 4 | 19 | 13 | ||||||
2182 | 2182 | -73.9573656523498 | 40.7979754563974 | 40C-AM-1017-01 | 40C | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#2) | false | false | false | false | false | false | false | true | POINT (-73.9573656523498 40.7979754563974) | 19 | 4 | 19 | 13 | |||||
2183 | 2183 | -73.967334936601 | 40.7773289724189 | 16F-PM-1013-01 | 16F | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Woods | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.967334936601 40.7773289724189) | 19 | 4 | 19 | 13 | ||||
2195 | 2195 | -73.955352152771 | 40.7988549523022 | 42D-AM-1014-01 | 42D | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | false | false | true | true | false | true | false | false | false | false | false | true | false | POINT (-73.955352152771 40.7988549523022) | 19 | 4 | 19 | 13 | |||||
2199 | 2199 | -73.9677500862135 | 40.7726060987821 | 11I-AM-1012-01 | 11I | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9677500862135 40.7726060987821) | 19 | 4 | 19 | 13 | |||||
2201 | 2201 | -73.9717135461165 | 40.7761780680083 | 13D-PM-1018-01 | 13D | PM | 10182018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9717135461165 40.776178068008306) | 19 | 4 | 19 | 13 | |||||
2207 | 2207 | -73.9748943397482 | 40.7703992564272 | 6E-AM-1014-01 | 06E | AM | 10142018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9748943397482 40.7703992564272) | 19 | 4 | 19 | 13 | |||||
2220 | 2220 | -73.963716747038 | 40.7892160137944 | 29C-AM-1007-01 | 29C | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.96371674703802 40.7892160137944) | 19 | 4 | 19 | 13 | |||||
2221 | 2221 | -73.9771847728747 | 40.7695971164981 | 4C-AM-1006-01 | 04C | AM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9771847728747 40.7695971164981) | 19 | 4 | 19 | 13 | |||||
2224 | 2224 | -73.9662310606968 | 40.7747758221226 | 14I-AM-1013-01 | 14I | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9662310606968 40.7747758221226) | 19 | 4 | 19 | 13 | |||||
2235 | 2235 | -73.9748522796455 | 40.7719586621003 | 7D-PM-1010-01 | 07D | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | outside fenced hectare | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9748522796455 40.7719586621003) | 19 | 4 | 19 | 13 | ||||
2244 | 2244 | -73.9509628195532 | 40.7977775674178 | 42H-PM-1014-01 | 42H | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9509628195532 40.7977775674178) | 12423 | 18 | 4 | 36 | 18 | ||||
2251 | 2251 | -73.9587678566254 | 40.7962656030995 | 38C-PM-1014-01 | 38C | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9587678566254 40.7962656030995) | 19 | 4 | 19 | 13 | |||||
2252 | 2252 | -73.9537703231359 | 40.7915959393814 | 35I-AM-1013-01 | 35I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | White underbelly | Above Ground | 18 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9537703231359 40.7915959393814) | 19 | 4 | 19 | 13 | ||||
2275 | 2275 | -73.9614218413356 | 40.7938945058793 | 34B-AM-1013-01 | 34B | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | hopping | false | false | false | false | true | true | false | false | POINT (-73.9614218413356 40.7938945058793) | 19 | 4 | 19 | 13 | ||||
2278 | 2278 | -73.964539031099 | 40.7809916310012 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.964539031099 40.7809916310012) | 19 | 4 | 19 | 13 | |||||
2283 | 2283 | -73.9628982772673 | 40.7884304803386 | 28D-PM-1019-01 | 28D | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9628982772673 40.7884304803386) | 19 | 4 | 19 | 13 | |||||
2287 | 2287 | -73.9768173303165 | 40.7661261813557 | 1F-PM-1019-01 | 01F | PM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9768173303165 40.7661261813557) | 19 | 4 | 19 | 13 | |||||
2294 | 2294 | -73.9630820577441 | 40.7821632293136 | 22G-PM-1018-01 | 22G | PM | 10182018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9630820577441 40.7821632293136) | 19 | 4 | 19 | 13 | ||||
2302 | 2302 | -73.9754333866435 | 40.7732390916138 | 8C-PM-1013-01 | 08C | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9754333866435 40.7732390916138) | 19 | 4 | 19 | 13 | |||||
2310 | 2310 | -73.9712863172608 | 40.774698758184 | 12E-AM-1017-01 | 12E | AM | 10172018 | 1 | 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.9712863172608 40.774698758184) | 19 | 4 | 19 | 13 | |||||
2312 | 2312 | -73.9765867029226 | 40.7674304266107 | 2E-PM-1014-01 | 02E | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | true | false | false | POINT (-73.9765867029226 40.7674304266107) | 19 | 4 | 19 | 13 | |||||
2313 | 2313 | -73.9646174034945 | 40.7781287528262 | 18H-AM-1018-01 | 18H | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Running from one tree to the other | true | true | false | false | false | playing? | false | false | false | false | false | false | false | false | POINT (-73.9646174034945 40.7781287528262) | 19 | 4 | 19 | 13 | |||
2316 | 2316 | -73.957697363244 | 40.7997576909042 | 42A-PM-1014-01 | 42A | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | up on hind legs looking around | false | false | false | false | false | false | false | false | came to about 10' away then ran off | POINT (-73.957697363244 40.7997576909042) | 19 | 4 | 19 | 13 | |||
2324 | 2324 | -73.9737247632185 | 40.7759469280872 | 12C-PM-1017-01 | 12C | PM | 10172018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | digging/burying,drinking from lake | false | false | false | false | true | false | true | false | POINT (-73.9737247632185 40.7759469280872) | 19 | 4 | 19 | 13 | ||||
2327 | 2327 | -73.9567801028221 | 40.7960096659564 | 38D-AM-1017-01 | 38D | AM | 10172018 | 1 | + | Above Ground | 30 | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9567801028221 40.7960096659564) | 19 | 4 | 19 | 13 | ||||||||
2333 | 2333 | -73.9771924901559 | 40.7666722729471 | 1E-PM-1007-01 | 01E | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | people feeding squirrel | POINT (-73.9771924901559 40.7666722729471) | 19 | 4 | 19 | 13 | ||||
2336 | 2336 | -73.9531263214136 | 40.7965675089932 | 40F-PM-1006-01 | 40F | PM | 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.9531263214136 40.7965675089932) | 19 | 4 | 19 | 13 | |||||
2338 | 2338 | -73.9716621112698 | 40.7742862219469 | 11E-AM-1013-01 | 11E | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9716621112698 40.7742862219469) | 19 | 4 | 19 | 13 | ||||||
2342 | 2342 | -73.9533645762606 | 40.7983709215535 | 42F-AM-1019-01 | 42F | AM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | true | false | false | true | runs from (me) | POINT (-73.9533645762606 40.7983709215535) | 19 | 4 | 19 | 13 | ||||
2345 | 2345 | -73.965738547469 | 40.7886962740167 | 27B-PM-1006-01 | 27B | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | By large tree | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.965738547469 40.7886962740167) | 19 | 4 | 19 | 13 | |||||
2350 | 2350 | -73.9564777440695 | 40.7993068355401 | 42C-AM-1007-01 | 42C | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | nut in mouth | false | false | false | false | false | false | false | true | POINT (-73.9564777440695 40.7993068355401) | 19 | 4 | 19 | 13 | ||||
2351 | 2351 | -73.9745818450109 | 40.7654498873627 | 1G-AM-1006-01 | 01G | AM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9745818450109 40.7654498873627) | 19 | 4 | 19 | 13 | ||||||
2359 | 2359 | -73.9700785314537 | 40.777714111862 | 15D-AM-1007-01 | 15D | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9700785314537 40.777714111862) | 19 | 4 | 19 | 13 | ||||||
2360 | 2360 | -73.9573325001041 | 40.7874662104558 | 30H-AM-1007-01 | 30H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9573325001041 40.7874662104558) | 19 | 4 | 19 | 13 | ||||||
2371 | 2371 | -73.9769520212123 | 40.774006725863 | 9A-AM-1013-01 | 09A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9769520212123 40.774006725863) | 19 | 4 | 19 | 13 | |||||
2375 | 2375 | -73.9563720614251 | 40.7879453306251 | 31I-PM-1019-01 | 31I | PM | 10192018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9563720614251 40.7879453306251) | 19 | 4 | 19 | 13 | ||||||
2378 | 2378 | -73.9747592855901 | 40.7763762870413 | 12A-PM-1013-01 | 12A | PM | 10132018 | 1 | Adult | Gray | Gray+ | But it was kind of dark? | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9747592855901 40.7763762870413) | 19 | 4 | 19 | 13 | |||||
2381 | 2381 | -73.9588414980489 | 40.7953525481367 | 37C-AM-1012-01 | 37C | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | caching | false | false | false | false | false | false | false | true | POINT (-73.9588414980489 40.7953525481367) | 19 | 4 | 19 | 13 | ||||
2382 | 2382 | -73.9743970455533 | 40.7687880243986 | 5F-PM-1007-01 | 05F | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9743970455533 40.7687880243986) | 19 | 4 | 19 | 13 | |||||
2386 | 2386 | -73.9565738895972 | 40.7900160952624 | 32H-AM-1010-01 | 32H | AM | 10102018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | not sure; walking-stop-walking-stop | false | false | false | false | false | false | true | false | did seem to observe me for a moment | POINT (-73.9565738895972 40.7900160952624) | 19 | 4 | 19 | 13 | |||
2387 | 2387 | -73.9808517324721 | 40.7683154647217 | 1A-PM-1014-01 | 01A | PM | 10142018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9808517324721 40.7683154647217) | 19 | 4 | 19 | 13 | |||||
2389 | 2389 | -73.9801343393329 | 40.7691512453402 | 3A-AM-1012-01 | 03A | AM | 10122018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9801343393329 40.7691512453402) | 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 | |||||
2409 | 2409 | -73.9725947179952 | 40.7794481577234 | 16A-AM-1013-01 | 16A | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9725947179952 40.7794481577234) | 19 | 4 | 19 | 13 | ||||||
2415 | 2415 | -73.9683598086625 | 40.7811150451315 | 19D-PM-1008-01 | 19D | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9683598086625 40.7811150451315) | 19 | 4 | 19 | 13 | |||||
2417 | 2417 | -73.9720323148189 | 40.7729703459618 | 10E-PM-1007-01 | 10E | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9720323148189 40.7729703459618) | 19 | 4 | 19 | 13 | ||||||
2418 | 2418 | -73.9683653449966 | 40.7719661592206 | 10I-AM-1010-01 | 10I | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9683653449966 40.7719661592206) | 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 | ||||
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 |
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 );