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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2747 | 2747 | -73.971314838366 | 40.774951285041 | 12E-AM-1017-03 | 12E | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.971314838366 40.774951285041) | 19 | 4 | 19 | 13 | |||||
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 | ||||||
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 | |||||
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 | ||||||
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 | |||||
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 | ||||||
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 | |||||
2934 | 2934 | -73.9561669236168 | 40.7994737431277 | 42C-PM-1013-04 | 42C | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.9561669236168 40.7994737431277) | 19 | 4 | 19 | 13 | ||||||
2965 | 2965 | -73.9767389132988 | 40.7689323691424 | 4D-PM-1008-10 | 04D | PM | 10082018 | 10 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 6 | climbed the fence & posed for a picture | false | false | true | false | true | false | false | false | false | false | true | false | false | POINT (-73.9767389132988 40.7689323691424) | 19 | 4 | 19 | 13 | ||||
760 | 760 | -73.9718234159557 | 40.7810842503715 | 18A-AM-1012-02 | 18A | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | true | true | burying | false | false | false | true | false | false | false | true | POINT (-73.9718234159557 40.7810842503715) | 19 | 4 | 19 | 13 | ||||
1487 | 1487 | -73.965394655961 | 40.7763136791661 | 15I-PM-1012-05 | 15I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | burying the food on ground | false | false | false | false | false | false | false | false | look at us and continue hiding the food | POINT (-73.965394655961 40.7763136791661) | 19 | 4 | 19 | 13 | ||||
2833 | 2833 | -73.9552595564798 | 40.7889533029466 | 32I-PM-1007-01 | 32I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | true | true | chirps | false | false | false | false | true | false | true | false | POINT (-73.9552595564798 40.7889533029466) | 19 | 4 | 19 | 13 | ||||
303 | 303 | -73.9762348224648 | 40.7694522315322 | 4D-PM-1008-08 | 04D | PM | 10082018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | true | true | climbed fence staring at me - went up tree | false | false | false | false | false | false | false | true | POINT (-73.97623482246482 40.7694522315322) | 19 | 4 | 19 | 13 | ||||
2288 | 2288 | -73.9577009571427 | 40.796126044521 | 38C-PM-1014-10 | 38C | PM | 10142018 | 10 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | false | false | true | true | true | climbing (down from ~10') | false | false | false | false | false | false | false | true | POINT (-73.9577009571427 40.796126044521) | 19 | 4 | 19 | 13 | ||||
833 | 833 | -73.9741846413977 | 40.7762518164182 | 12B-PM-1018-01 | 12B | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Climbing up rocks | false | false | true | false | true | climbing (up rocks) | false | false | false | false | false | false | false | true | POINT (-73.9741846413977 40.7762518164182) | 19 | 4 | 19 | 13 | ||||
2583 | 2583 | -73.9769693140651 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 10062018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | up a tree | true | false | true | true | true | digging (?) | false | false | false | true | false | false | false | true | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) | 19 | 4 | 19 | 13 | ||
2352 | 2352 | -73.9727310397798 | 40.7787016773517 | 15B-PM-1017-02 | 15B | PM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | tree | false | false | true | true | true | digging,chewing on tree—has nut in mouth! | false | false | false | false | false | false | false | true | POINT (-73.97273103977982 40.7787016773517) | 19 | 4 | 19 | 13 | |||
1776 | 1776 | -73.9562350820255 | 40.7913464147989 | 34G-PM-1006-02 | 34G | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | true | eating bread it found on ground | false | false | false | false | false | false | false | true | POINT (-73.9562350820255 40.7913464147989) | 19 | 4 | 19 | 13 | |||||
1480 | 1480 | -73.9628525533831 | 40.7938449345017 | 34A-PM-1013-02 | 34A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | true | true | eating upside down on tree trunk | false | false | false | false | false | false | false | false | POINT (-73.9628525533831 40.7938449345017) | 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 | |||
3012 | 3012 | -73.9613701960898 | 40.7943363227822 | 35B-PM-1013-04 | 35B | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | got threatened by dog (same dog,dog #1) | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9613701960898 40.7943363227822) | 19 | 4 | 19 | 13 | ||||
1609 | 1609 | -73.9639024988123 | 40.7776953065849 | 18I-PM-1007-01 | 18I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | false | false | true | true | true | hanging upside down | false | false | false | false | false | false | true | false | POINT (-73.9639024988123 40.7776953065849) | 19 | 4 | 19 | 13 | ||||
2222 | 2222 | -73.9639048209454 | 40.7777373345558 | 18I-PM-1007-02 | 18I | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | false | false | true | true | true | hanging upside down | false | false | false | false | false | false | true | false | POINT (-73.9639048209454 40.7777373345558) | 19 | 4 | 19 | 13 | ||||
1697 | 1697 | -73.9568610943394 | 40.7935959584643 | 36E-PM-1012-02 | 36E | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 28 | on tree branch | false | false | true | false | true | picking acorns off oak tree | false | false | false | false | false | false | true | false | POINT (-73.95686109433942 40.7935959584643) | 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 | |||
241 | 241 | -73.9760256477558 | 40.7703573131398 | 5D-AM-1020-02 | 05D | AM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | small jumps | false | false | false | false | false | false | false | false | POINT (-73.9760256477558 40.7703573131398) | 19 | 4 | 19 | 13 | ||||
2015 | 2015 | -73.9574365550758 | 40.7886924675052 | 31H-PM-1008-03 | 31H | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | no clue, way up a tree! | false | false | true | false | true | throwing down acorns | false | false | false | false | false | false | false | false | POINT (-73.9574365550758 40.7886924675052) | 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 );