This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Running, Chasing, Eating, Foraging, Quaas, Moans, Tail twitches, Indifferent, Runs from, Zip Codes, Community Districts, Police Precincts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
616 | 616 | -73.9556937218252 | 40.7990928062435 | 42C-AM-1007-04 | 42C | AM | 10072018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | young adult | Ground Plane | FALSE | false | false | false | false | false | walking | false | false | false | false | false | false | true | false | POINT (-73.9556937218252 40.7990928062435) | 19 | 4 | 19 | 13 | |||
1577 | 1577 | -73.965390623703 | 40.7807731363782 | 20F-PM-1007-08 | 20F | PM | 10072018 | 8 | Adult | Cinnamon | White | Cinnamon+White | white tail/belly | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.965390623703 40.7807731363782) | 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 | |||
1466 | 1466 | -73.9651177657676 | 40.7812408103825 | 20F-PM-1007-05 | 20F | PM | 10072018 | 5 | Juvenile | Gray | White | Gray+White | white tail | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9651177657676 40.781240810382506) | 19 | 4 | 19 | 13 | ||||
247 | 247 | -73.9733117663541 | 40.7694584620114 | 6F-PM-1008-05 | 06F | PM | 10082018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white patch | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.97331176635412 40.7694584620114) | 19 | 4 | 19 | 13 | ||||
2040 | 2040 | -73.9648167334089 | 40.7811164976329 | 20F-PM-1007-02 | 20F | PM | 10072018 | 2 | Adult | Gray | White | Gray+White | white on tail | Ground Plane | FALSE | false | false | false | true | true | digging one hole w/ determination | false | false | false | false | true | false | false | true | POINT (-73.96481673340891 40.7811164976329) | 19 | 4 | 19 | 13 | |||
2145 | 2145 | -73.9651250402583 | 40.7812884929069 | 20F-PM-1007-04 | 20F | PM | 10072018 | 4 | Juvenile | Gray | White | Gray+White | white on tail | Above Ground | 20 | climbed tree | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9651250402583 40.7812884929069) | 19 | 4 | 19 | 13 | |||
269 | 269 | -73.9591400366159 | 40.7891708599318 | 31F-PM-1007-01 | 31F | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | white neck and belly | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9591400366159 40.7891708599318) | 19 | 4 | 19 | 13 | ||||
1246 | 1246 | -73.9543044385367 | 40.7984498571338 | 41E-AM-1007-04 | 41E | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white haunches/tail | Ground Plane | FALSE | rubbing belly on ground | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9543044385367 40.798449857133804) | 19 | 4 | 19 | 13 | |||
817 | 817 | -73.9540022445432 | 40.7979409854977 | 41E-AM-1007-01 | 41E | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | white haunches | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9540022445432 40.7979409854977) | 19 | 4 | 19 | 13 | ||||
953 | 953 | -73.9547959269955 | 40.7925162926273 | 36H-PM-1008-01 | 36H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | white belly | Above Ground | 20 | true | false | true | false | true | true | true | false | false | false | false | true | false | POINT (-73.9547959269955 40.7925162926273) | 19 | 4 | 19 | 13 | ||||
1421 | 1421 | -73.9595022290348 | 40.7831151330074 | 25I-PM-1007-02 | 25I | PM | 10072018 | 2 | Adult | Gray | White | Gray+White | white belly | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | true | false | false | true | POINT (-73.9595022290348 40.783115133007406) | 19 | 4 | 19 | 13 | ||||
1914 | 1914 | -73.9588714413332 | 40.7895787115444 | 31F-PM-1007-03 | 31F | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | white belly | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9588714413332 40.7895787115444) | 19 | 4 | 19 | 13 | ||||
1999 | 1999 | -73.9549860947234 | 40.7911550328309 | 34H-PM-1006-07 | 34H | PM | 10062018 | 7 | Juvenile | Gray | White | Gray+White | white belly | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9549860947234 40.7911550328309) | 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 | ||||
1129 | 1129 | -73.9744906832678 | 40.7699948746776 | 6E-PM-1010-05 | 06E | PM | 10102018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | false | false | false | true | false | could this squirrel be eating a white mushroom? | false | false | false | false | false | false | true | false | POINT (-73.9744906832678 40.76999487467761) | 19 | 4 | 19 | 13 | |||
1282 | 1282 | -73.974451175321 | 40.7701294635264 | 6E-PM-1010-04 | 06E | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | false | true | false | true | false | chasing #3 | false | false | false | false | false | false | true | false | POINT (-73.974451175321 40.7701294635264) | 19 | 4 | 19 | 13 | ||
1536 | 1536 | -73.9746128451271 | 40.7700957046709 | 6E-PM-1010-02 | 06E | PM | 10102018 | 2 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9746128451271 40.7700957046709) | 19 | 4 | 19 | 13 | |||
2946 | 2946 | -73.974515099169 | 40.7700650799886 | 6E-PM-1010-03 | 06E | PM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | false | true | false | true | false | chasing #4 | false | false | false | false | false | false | true | false | POINT (-73.974515099169 40.770065079988605) | 19 | 4 | 19 | 13 | ||
1769 | 1769 | -73.9721086069437 | 40.7698172190404 | 6G-AM-1008-06 | 06G | AM | 10082018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | white at end of tail | Ground Plane | FALSE | grass | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9721086069437 40.7698172190404) | 19 | 4 | 19 | 13 | |||
1500 | 1500 | -73.9769969548024 | 40.7710711265211 | 6C-AM-1007-01 | 06C | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | vid! | Above Ground | 15 | false | false | true | false | false | false | false | false | false | true | false | false | false | curious,but wary | POINT (-73.97699695480242 40.7710711265211) | 19 | 4 | 19 | 13 | |||
1079 | 1079 | -73.9722737593623 | 40.768963018754 | 6G-AM-1008-04 | 06G | AM | 10082018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | very long tail | Above Ground | 20 | tree | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9722737593623 40.768963018754) | 19 | 4 | 19 | 13 | |||
1778 | 1778 | -73.9685598106128 | 40.7807054868066 | 19D-PM-1008-02 | 19D | PM | 10082018 | 2 | + | unknown - cannot see, only hear | Above Ground | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9685598106128 40.7807054868066) | 19 | 4 | 19 | 13 | ||||||||
2397 | 2397 | -73.9704592500888 | 40.772962887933 | 10G-AM-1006-03 | 10G | AM | 10062018 | 3 | Juvenile | Gray | White | Gray+White | tuft on butt | Above Ground | 10 | false | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9704592500888 40.772962887933) | 19 | 4 | 19 | 13 | ||||
373 | 373 | -73.9672127283283 | 40.7810666805133 | 20D-AM-1007-01 | 20D | AM | 10072018 | 1 | Adult | Gray | Gray+ | too far to note 30' | Ground Plane | FALSE | true | false | true | true | false | a lot of activity | false | false | false | true | false | false | false | false | POINT (-73.9672127283283 40.7810666805133) | 19 | 4 | 19 | 13 | ||||
2273 | 2273 | -73.9671534029191 | 40.7810849804467 | 20D-AM-1007-02 | 20D | AM | 10072018 | 2 | Adult | Gray | Gray+ | too far to note 30' | Ground Plane | FALSE | false | false | false | false | true | quieter | false | false | false | false | true | false | false | false | POINT (-73.9671534029191 40.7810849804467) | 19 | 4 | 19 | 13 | ||||
1190 | 1190 | -73.9728069355821 | 40.7794458131748 | 15A-AM-1007-01 | 15A | AM | 10072018 | 1 | Adult | Gray | Gray+ | tbd | Ground Plane | FALSE | false | false | false | false | true | hopping | false | false | false | false | false | false | true | false | in fenced in lawn (chill) | POINT (-73.9728069355821 40.7794458131748) | 19 | 4 | 19 | 13 | |||
2596 | 2596 | -73.9729786570879 | 40.7778238570396 | 14B-AM-1007-01 | 14B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | tail straight | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.97297865708792 40.7778238570396) | 19 | 4 | 19 | 13 | ||||
1181 | 1181 | -73.9690395363594 | 40.771128205027 | 9I-PM-1010-01 | 09I | PM | 10102018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | standard coloration | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9690395363594 40.771128205027) | 19 | 4 | 19 | 13 | ||||
2500 | 2500 | -73.9689703880705 | 40.7712025611298 | 9I-PM-1010-02 | 09I | PM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | standard coloration | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.96897038807052 40.7712025611298) | 19 | 4 | 19 | 13 | ||||
1301 | 1301 | -73.9552146665714 | 40.7892909102377 | 32I-PM-1007-03 | 32I | PM | 10072018 | 3 | Adult | Gray | Gray+ | small adult | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9552146665714 40.7892909102377) | 19 | 4 | 19 | 13 | |||||
1172 | 1172 | -73.9706929270645 | 40.7727841119424 | 10G-AM-1006-06 | 10G | AM | 10062018 | 6 | Juvenile | Gray | Gray+ | skinny tail | Ground Plane | FALSE | false | true | false | false | false | chasing (#5) | true | false | false | false | false | false | false | false | POINT (-73.9706929270645 40.7727841119424) | 19 | 4 | 19 | 13 | ||||
2034 | 2034 | -73.9699135187297 | 40.7782354186163 | 16D-AM-1007-03 | 16D | AM | 10072018 | 3 | Adult | + | ran away before I could take a good look | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9699135187297 40.7782354186163) | 19 | 4 | 19 | 13 | ||||||
2732 | 2732 | -73.9694185786221 | 40.7787189999566 | 16D-AM-1007-06 | 16D | AM | 10072018 | 6 | Adult | Cinnamon | White | Cinnamon+White | primary color: brown ( I marked cinnamon as closest to brown - JO) | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9694185786221 40.7787189999566) | 19 | 4 | 19 | 13 | ||||
897 | 897 | -73.9734687538064 | 40.7694308959222 | 6F-PM-1008-04 | 06F | PM | 10082018 | 4 | Adult | Cinnamon | White | Cinnamon+White | patches of white on haunches | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9734687538064 40.7694308959222) | 19 | 4 | 19 | 13 | ||||
972 | 972 | -73.9704591091677 | 40.7729175143429 | 10G-AM-1006-02 | 10G | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | notch on tail | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9704591091677 40.7729175143429) | 19 | 4 | 19 | 13 | ||||
2457 | 2457 | -73.9569896638974 | 40.7911914507504 | 33G-PM-1006-02 | 33G | PM | 10062018 | 2 | Adult | Gray | Gray+ | my favorite | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | engaged w/ me | POINT (-73.9569896638974 40.7911914507504) | 19 | 4 | 19 | 13 | ||||
1863 | 1863 | -73.9682830510954 | 40.7810151087286 | 19D-PM-1008-03 | 19D | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | may be same squirrel as #1 - male | Above Ground | 5 | on branch of dead tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9682830510954 40.7810151087286) | 19 | 4 | 19 | 13 | |||
660 | 660 | -73.9638298997554 | 40.7825966332367 | 22F-AM-1007-03 | 22F | AM | 10072018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | large white highlight | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9638298997554 40.7825966332367) | 19 | 4 | 19 | 13 | ||||
13 | 13 | -73.9541201789795 | 40.7931811701082 | 36H-AM-1010-02 | 36H | AM | 10102018 | 2 | Adult | Gray | Gray+ | just outside hectare | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9541201789795 40.7931811701082) | 19 | 4 | 19 | 13 | |||||
876 | 876 | -73.9672789573537 | 40.7874778720268 | 26A-PM-1006-02 | 26A | PM | 10062018 | 2 | Juvenile | Gray | Gray+ | injured | Ground Plane | FALSE | false | false | false | false | false | not moving | false | false | false | false | false | false | false | false | POINT (-73.96727895735371 40.7874778720268) | 19 | 4 | 19 | 13 | ||||
1425 | 1425 | -73.9586252875856 | 40.7852027586217 | 27I-AM-1007-03 | 27I | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | had .5 of a tail | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586252875856 40.7852027586217) | 19 | 4 | 19 | 13 | ||||
604 | 604 | -73.9540908513075 | 40.794201225045 | 37G-PM-1007-04 | 37G | PM | 10072018 | 4 | Cinnamon | Gray | Cinnamon+Gray | gray tail | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540908513075 40.794201225045) | 19 | 4 | 19 | 13 | |||||
2518 | 2518 | -73.9647219419257 | 40.7812084402932 | 20F-PM-1007-03 | 20F | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | gray on haunches white on tail | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9647219419257 40.7812084402932) | 19 | 4 | 19 | 13 | ||||
2209 | 2209 | -73.9697583235533 | 40.7787320391004 | 16D-AM-1007-05 | 16D | AM | 10072018 | 5 | Adult | Gray | Gray+ | didn't get a good look | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96975832355331 40.7787320391004) | 19 | 4 | 19 | 13 | |||||
1727 | 1727 | -73.9692472299565 | 40.7722592187215 | 10H-PM-1007-01 | 10H | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | dark gray | Above Ground | 15 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9692472299565 40.7722592187215) | 19 | 4 | 19 | 13 | |||
161 | 161 | -73.9649632550828 | 40.7809187761995 | 20F-PM-1007-01 | 20F | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | cinnamon tail | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9649632550828 40.7809187761995) | 19 | 4 | 19 | 13 | ||||
2217 | 2217 | -73.9652746477521 | 40.7809326848536 | 20F-PM-1007-07 | 20F | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | cinnamon tail | Ground Plane | FALSE | true | false | false | false | false | watching | false | false | false | true | false | false | false | true | POINT (-73.96527464775211 40.7809326848536) | 19 | 4 | 19 | 13 | |||
1627 | 1627 | -73.9594391759139 | 40.784115697669 | 26I-PM-1010-03 | 26I | PM | 10102018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | black in tail | Above Ground | 15 | tree | false | false | true | true | true | false | false | false | false | true | false | true | false | POINT (-73.9594391759139 40.784115697669) | 19 | 4 | 19 | 13 | |||
2395 | 2395 | -73.9729603550254 | 40.7660215710657 | 3H-AM-1008-06 | 03H | AM | 10082018 | 6 | Adult | Black | Black+ | beauty! | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.9729603550254 40.7660215710657) | 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 | ||||
646 | 646 | -73.954092292214 | 40.7979800395433 | 41E-PM-1013-05 | 41E | PM | 10132018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.954092292214 40.7979800395433) | 19 | 4 | 19 | 13 | ||||
1118 | 1118 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3 | tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9719460335398 40.7810508156287) | 19 | 4 | 19 | 13 | |||
1870 | 1870 | -73.9542118614769 | 40.7939171395463 | 37G-AM-1014-06 | 37G | AM | 10142018 | 6 | Adult | Gray | White | Gray+White | White tail | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95421186147692 40.7939171395463) | 19 | 4 | 19 | 13 | ||||
1924 | 1924 | -73.9542332505231 | 40.7933475171434 | 37G-AM-1014-01 | 37G | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | White tail | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9542332505231 40.7933475171434) | 19 | 4 | 19 | 13 | ||||
243 | 243 | -73.9754778808471 | 40.7685619029765 | 4E-AM-1020-01 | 04E | AM | 10202018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 7 | false | false | true | false | false | sitting very still | false | false | false | false | false | false | true | false | POINT (-73.9754778808471 40.7685619029765) | 19 | 4 | 19 | 13 | |||
1595 | 1595 | -73.9754696312232 | 40.768191647092 | 4E-AM-1020-02 | 04E | AM | 10202018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 15 | false | false | true | false | true | foraging (on the tree itself) | false | false | false | false | false | false | true | false | POINT (-73.9754696312232 40.768191647092) | 19 | 4 | 19 | 13 | |||
2667 | 2667 | -73.9759510842771 | 40.769288289111 | 5D-AM-1020-04 | 05D | AM | 10202018 | 4 | Adult | Gray | Black, White | Gray+Black, White | White selected as Primary. Black selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9759510842771 40.76928828911101) | 19 | 4 | 19 | 13 | ||||
1659 | 1659 | -73.9690498876944 | 40.7700011818847 | 8I-AM-1006-07 | 08I | AM | 10062018 | 7 | Adult | Gray | White | Gray+White | White ring on short tail | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9690498876944 40.7700011818847) | 19 | 4 | 19 | 13 | ||||
458 | 458 | -73.9735750352959 | 40.7694500333777 | 6F-PM-1008-06 | 06F | PM | 10082018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | White patches. Almost looks like fox squirrel | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9735750352959 40.7694500333777) | 19 | 4 | 19 | 13 | ||||||
845 | 845 | -73.9582850206205 | 40.7978975855555 | 39B-PM-1014-01 | 39B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | White belly | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9582850206205 40.7978975855555) | 19 | 4 | 19 | 13 | ||||
2102 | 2102 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | false | false | false | true | true | watching | false | false | false | false | false | false | false | true | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
1478 | 1478 | -73.9676370985166 | 40.7869888639434 | 25A-AM-1013-01 | 25A | AM | 10132018 | 1 | Gray | White | Gray+White | White Belly | Ground Plane | FALSE | false | false | false | true | false | staring at me | false | false | false | false | false | false | true | false | POINT (-73.96763709851662 40.7869888639434) | 19 | 4 | 19 | 13 | ||||
838 | 838 | -73.9691031094688 | 40.7706693835189 | 9I-AM-1014-02 | 09I | AM | 10142018 | 2 | Adult | Gray | Gray+ | Very far, so appx | Above Ground | 35 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9691031094688 40.7706693835189) | 19 | 4 | 19 | 13 | |||||
198 | 198 | -73.9761107065353 | 40.769642060286 | 5D-AM-1020-01 | 05D | AM | 10202018 | 1 | Adult | + | Too far & cloudy to tell | Above Ground | 30 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9761107065353 40.769642060286) | 19 | 4 | 19 | 13 | ||||||
1875 | 1875 | -73.9527430510248 | 40.7924807950552 | 36I-PM-1007-12 | 36I | PM | 10072018 | 12 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Tiny! So tiny! | Above Ground | 2 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9527430510248 40.7924807950552) | 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 | ||||
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 | |||||
804 | 804 | -73.9697196619878 | 40.7814068507607 | 19B-AM-1019-01 | 19B | AM | 10192018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Side stripes | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | true | indifferent then runs from | POINT (-73.9697196619878 40.7814068507607) | 19 | 4 | 19 | 13 | |||
2051 | 2051 | -73.9544808708211 | 40.7906575852286 | 34I-AM-1012-02 | 34I | AM | 10122018 | 2 | Adult | Gray | White | Gray+White | Short tail | Ground Plane | FALSE | false | false | false | false | false | hiding | false | false | false | false | false | false | false | true | POINT (-73.9544808708211 40.7906575852286) | 19 | 4 | 19 | 13 | |||
627 | 627 | -73.9763791121438 | 40.770281512254 | 5D-PM-1018-04 | 05D | PM | 10182018 | 4 | Adult | Gray | White | Gray+White | Partial missing tail | Ground Plane | FALSE | false | true | false | false | false | chasing (dog chasing) | false | false | false | false | false | false | false | true | POINT (-73.9763791121438 40.770281512254) | 19 | 4 | 19 | 13 | |||
1459 | 1459 | -73.9563847867316 | 40.7906012261163 | 33G-AM-1013-03 | 33G | AM | 10132018 | 3 | ? | + | Only peeked head out | Above Ground | 13 | false | false | false | false | false | peeking out of tree,did *not* come out | false | false | false | false | false | false | false | false | POINT (-73.9563847867316 40.7906012261163) | 19 | 4 | 19 | 13 | |||||
545 | 545 | -73.9756810453606 | 40.7756257458036 | 11A-PM-1013-01 | 11A | PM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Off-white, decorator's white? | Ground Plane | FALSE | false | false | false | true | false | eating (osage orange) | false | false | false | false | false | false | true | false | POINT (-73.9756810453606 40.7756257458036) | 19 | 4 | 19 | 13 | |||
10 | 10 | -73.9596413903948 | 40.7903128889029 | 32E-PM-1017-14 | 32E | PM | 10172018 | 14 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9596413903948 40.7903128889029) | 19 | 4 | 19 | 13 | |||||||
64 | 64 | -73.9595002339508 | 40.7903365788694 | 32E-PM-1017-13 | 32E | PM | 10172018 | 13 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9595002339508 40.7903365788694) | 19 | 4 | 19 | 13 | |||||||
1000 | 1000 | -73.9805137046778 | 40.769275143797 | 2A-AM-1010-08 | 02A | AM | 10102018 | 8 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9805137046778 40.769275143797) | 19 | 4 | 19 | 13 | |||||
2174 | 2174 | -73.9684092812839 | 40.7711445841928 | 9I-AM-1014-07 | 09I | AM | 10142018 | 7 | Adult | Cinnamon | Cinnamon+ | No real highlight, White tail? | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9684092812839 40.7711445841928) | 19 | 4 | 19 | 13 | |||||
299 | 299 | -73.9586214081667 | 40.7937473968735 | 35D-PM-1013-03 | 35D | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | No Tail! | Above Ground | 2 | bench | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9586214081667 40.7937473968735) | 19 | 4 | 19 | 13 | |||
1806 | 1806 | -73.9657504643585 | 40.7831210813592 | 22D-PM-1012-02 | 22D | PM | 10122018 | 2 | Adult | Gray | Black, White | Gray+Black, White | No Primary Fur Color selected. Made executive adjustment based on other squirrels. | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9657504643585 40.7831210813592) | 19 | 4 | 19 | 13 | ||||
2689 | 2689 | -73.9704121989487 | 40.7824040236981 | 19A-PM-1013-02 | 19A | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Looks very brown, not like English red squirrels | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9704121989487 40.7824040236981) | 19 | 4 | 19 | 13 | ||||
555 | 555 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685227310735 40.776599466588) | 19 | 4 | 19 | 13 | ||||
2424 | 2424 | -73.9684752839242 | 40.7765816261518 | 15F-AM-1007-01 | 15F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | true | POINT (-73.9684752839242 40.7765816261518) | 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 | ||||
1034 | 1034 | -73.9553163829551 | 40.7988610926249 | 42D-PM-1013-04 | 42D | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Light Cinnamon | Ground Plane | FALSE | false | false | false | false | false | carrying nut away | false | false | false | false | false | false | true | false | POINT (-73.9553163829551 40.7988610926249) | 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 | ||||||
592 | 592 | -73.9712256765283 | 40.7760942872488 | 13D-PM-1018-13 | 13D | PM | 10182018 | 13 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9712256765283 40.7760942872488) | 19 | 4 | 19 | 13 | |||
309 | 309 | -73.9696001184129 | 40.7820810673532 | 19B-PM-1018-05 | 19B | PM | 10182018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9696001184129 40.7820810673532) | 19 | 4 | 19 | 13 | ||||
1339 | 1339 | -73.9686413326172 | 40.7817423907284 | 19C-PM-1018-08 | 19C | PM | 10182018 | 8 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9686413326172 40.7817423907284) | 19 | 4 | 19 | 13 | ||||
1625 | 1625 | -73.9736873018042 | 40.7649106677138 | 1I-PM-1012-02 | 01I | PM | 10122018 | 2 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | tree | false | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9736873018042 40.7649106677138) | 19 | 4 | 19 | 13 | |||
1840 | 1840 | -73.9733222531339 | 40.7649975371546 | 1I-PM-1012-01 | 01I | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9733222531339 40.7649975371546) | 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 | ||||
568 | 568 | -73.9799441493404 | 40.7671499997527 | 1C-AM-1012-01 | 01C | AM | 10122018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9799441493404 40.7671499997527) | 12081 | 11 | 4 | 51 | 10 | |||
1601 | 1601 | -73.9544278270221 | 40.7987827316512 | 42D-PM-1013-02 | 42D | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail, Cinnamon feet | Ground Plane | FALSE | false | true | false | false | true | chasing (chased by #1),found a nut,buried it | false | false | false | false | false | false | true | false | POINT (-73.9544278270221 40.7987827316512) | 19 | 4 | 19 | 13 | |||
1572 | 1572 | -73.9540197079615 | 40.798039260983 | 41E-PM-1013-03 | 41E | PM | 10132018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray on legs | Above Ground | 20 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540197079615 40.798039260983) | 19 | 4 | 19 | 13 | ||||
2989 | 2989 | -73.9643538221947 | 40.7917565604735 | 31A-PM-1017-01 | 31A | PM | 10172018 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9643538221947 40.7917565604735) | 19 | 4 | 19 | 13 | ||||
35 | 35 | -73.9756976076707 | 40.7753897331918 | 10A-PM-1014-01 | 10A | PM | 10142018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray & White selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | in b/w trees | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9756976076707 40.7753897331918) | 19 | 4 | 19 | 13 | |||
1977 | 1977 | -73.9586570546871 | 40.796349417475 | 38C-AM-1019-09 | 38C | AM | 10192018 | 9 | Adult | Gray | White | Gray+White | Gray & White selected as Primary & Highlights. Made executive adjustments. | Above Ground | 3 | Between ground & tree | false | false | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.9586570546871 40.796349417475) | 19 | 4 | 19 | 13 | |||
2770 | 2770 | -73.9637983513789 | 40.7828712516396 | 23F-PM-1013-04 | 23F | PM | 10132018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary: "much browner, like 1/2 & 1/2". | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | indifferent (busy foraging) | POINT (-73.9637983513789 40.7828712516396) | 19 | 4 | 19 | 13 | |||
1686 | 1686 | -73.9593373093799 | 40.7982428507976 | 39A-PM-1014-03 | 39A | PM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. | Above Ground | 6 | Jumped from ground onto branch | false | false | false | false | true | digging? | false | false | false | false | true | false | true | false | POINT (-73.95933730937992 40.7982428507976) | 19 | 4 | 19 | 13 | ||
443 | 443 | -73.9720887275538 | 40.7760799537976 | 13D-PM-1018-08 | 13D | PM | 10182018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9720887275538 40.7760799537976) | 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 );