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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2425 | 2425 | -73.9791141532217 | 40.7714888835416 | 5A-AM-1006-04 | 05A | AM | 10062018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9791141532217 40.77148888354161) | 19 | 4 | 19 | 13 | |||||
2429 | 2429 | -73.9726699686943 | 40.7701123791223 | 7F-AM-1008-01 | 07F | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bench | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9726699686943 40.7701123791223) | 19 | 4 | 19 | 13 | ||||
2433 | 2433 | -73.9706949930717 | 40.772362045852 | 10G-AM-1006-08 | 10G | AM | 10062018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 3 | false | false | false | true | false | false | false | false | true | true | false | true | false | POINT (-73.9706949930717 40.772362045852) | 19 | 4 | 19 | 13 | |||||
2440 | 2440 | -73.9673803508629 | 40.7785245025508 | 17F-AM-1007-01 | 17F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 18 | false | false | true | true | false | false | false | false | true | false | false | true | false | POINT (-73.9673803508629 40.7785245025508) | 19 | 4 | 19 | 13 | ||||||
2487 | 2487 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31 | on tree | true | true | false | false | false | false | false | false | true | true | false | true | false | POINT (-73.9595222999173 40.7833202577782) | 19 | 4 | 19 | 13 | ||||
2489 | 2489 | -73.9663168490265 | 40.7825083721362 | 21D-AM-1008-01 | 21D | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | true | false | true | false | POINT (-73.9663168490265 40.7825083721362) | 19 | 4 | 19 | 13 | |||||
2505 | 2505 | -73.9762974698771 | 40.7740076116964 | 9B-PM-1013-06 | 09B | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9762974698771 40.7740076116964) | 19 | 4 | 19 | 13 | ||||||
2547 | 2547 | -73.9743393747021 | 40.7676346798325 | 3F-AM-1006-12 | 03F | AM | 10062018 | 12 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9743393747021 40.7676346798325) | 19 | 4 | 19 | 13 | |||||
2569 | 2569 | -73.9559663734409 | 40.7945828261377 | 37F-AM-1010-01 | 37F | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | false | false | false | false | false | true | false | false | true | false | POINT (-73.9559663734409 40.7945828261377) | 19 | 4 | 19 | 13 | |||||
2588 | 2588 | -73.9581007437094 | 40.7959403112722 | 38C-AM-1019-06 | 38C | AM | 10192018 | 6 | Adult | Gray | Gray+ | Above Ground | 23 | false | false | true | false | false | true | false | false | true | false | false | true | false | POINT (-73.9581007437094 40.7959403112722) | 19 | 4 | 19 | 13 | ||||||
2591 | 2591 | -73.9786351029146 | 40.7716114164002 | 6A-PM-1012-06 | 06A | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | elevated ground | false | true | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9786351029146 40.771611416400205) | 19 | 4 | 19 | 13 | ||||
2700 | 2700 | -73.9601988871514 | 40.7943473161329 | 35C-PM-1013-01 | 35C | PM | 10132018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | true | true | true | false | true | true | false | true | false | POINT (-73.9601988871514 40.7943473161329) | 19 | 4 | 19 | 13 | ||||||
2705 | 2705 | -73.9748962681637 | 40.76787782717 | 4F-PM-1013-02 | 04F | PM | 10132018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9748962681637 40.76787782717) | 19 | 4 | 19 | 13 | |||||
2751 | 2751 | -73.956289117157 | 40.7953393993803 | 38E-AM-1010-11 | 38E | AM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of the stream | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.956289117157 40.7953393993803) | 19 | 4 | 19 | 13 | ||||
2759 | 2759 | -73.9543373703455 | 40.7943889087123 | 38G-PM-1020-07 | 38G | PM | 10202018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | true | false | true | false | false | true | false | POINT (-73.9543373703455 40.7943889087123) | 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 | ||||||
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 | |||||
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 | |||||
2923 | 2923 | -73.9672160533827 | 40.7830263908749 | 21C-AM-1014-05 | 21C | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9672160533827 40.7830263908749) | 19 | 4 | 19 | 13 | |||||
2966 | 2966 | -73.9630596103391 | 40.7925720620556 | 32A-AM-1018-04 | 32A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | Base of tree | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9630596103391 40.7925720620556) | 19 | 4 | 19 | 13 | |||||
1959 | 1959 | -73.9707737073771 | 40.7800373465838 | 17B-PM-1012-02 | 17B | PM | 10122018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | true | true | false | false | true | 2/3 chasing each other | true | true | false | true | true | false | true | false | POINT (-73.9707737073771 40.7800373465838) | 19 | 4 | 19 | 13 | |||||
582 | 582 | -73.9677779408464 | 40.7867482211349 | 25A-AM-1013-02 | 25A | AM | 10132018 | 2 | Gray | Gray+ | Above Ground | 15 | BIG TREE | false | true | false | false | false | chasing #3 | false | false | false | true | false | false | true | false | POINT (-73.9677779408464 40.7867482211349) | 19 | 4 | 19 | 13 | |||||
1188 | 1188 | -73.9669529835992 | 40.7871864151365 | 25A-AM-1013-05 | 25A | AM | 10132018 | 5 | Gray | Gray+ | Ground Plane | FALSE | CROSS BRIDLE - INTO TREE TO AVOID DOGGO | true | false | true | false | false | d.p.t. | false | false | false | true | true | false | true | false | calm | POINT (-73.96695298359921 40.7871864151365) | 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 | ||||
203 | 203 | -73.9638774579549 | 40.7913532129148 | 31A-AM-1010-05 | 31A | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | jumping | false | false | false | true | true | false | true | false | eventually ran from lawnmower (tail flag) | POINT (-73.9638774579549 40.7913532129148) | 19 | 4 | 19 | 13 | ||||
1235 | 1235 | -73.9679686793869 | 40.7825993867876 | 21C-AM-1014-01 | 21C | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | true | false | false | false | false | jumping back & forth on tree | false | false | false | true | true | false | true | false | POINT (-73.9679686793869 40.7825993867876) | 19 | 4 | 19 | 13 | ||||
2521 | 2521 | -73.976869549792 | 40.7706982454723 | 5C-AM-1006-04 | 05C | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 12 | thin branch of tree | false | false | false | false | false | relaxing | false | false | false | true | false | false | true | false | POINT (-73.976869549792 40.7706982454723) | 19 | 4 | 19 | 13 | |||
2980 | 2980 | -73.9716414586381 | 40.771760114722 | 9F-PM-1014-06 | 09F | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | running (from birds) | false | false | false | true | false | false | true | false | POINT (-73.9716414586381 40.771760114722) | 19 | 4 | 19 | 13 | ||||
2295 | 2295 | -73.9590632051055 | 40.7963146584827 | 38B-AM-1019-04 | 38B | AM | 10192018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | sitting in tree | true | true | false | true | false | false | true | false | observant | POINT (-73.9590632051055 40.7963146584827) | 19 | 4 | 19 | 13 | ||||
2297 | 2297 | -73.9787771053108 | 40.769356212275 | 3B-AM-1010-07 | 03B | AM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | together w/ #8 | false | false | false | true | false | false | true | false | POINT (-73.9787771053108 40.76935621227501) | 19 | 4 | 19 | 13 | |||||
2026 | 2026 | -73.9622752768962 | 40.7814921913101 | 22H-PM-1007-02 | 22H | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | low branch | false | false | false | false | false | watching me scratching | true | false | false | true | false | false | true | false | POINT (-73.9622752768962 40.7814921913101) | 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 );