This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail twitches, Approaches, Other Interactions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
447 | 447 | -73.9725906016474 | 40.7713889729739 | 8F-PM-1012-05 | 08F | PM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9725906016474 40.7713889729739) | 19 | 4 | 19 | 13 | |||||
905 | 905 | -73.9757216124349 | 40.7754310239649 | 11A-PM-1013-05 | 11A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | digging | false | false | false | false | true | false | false | false | POINT (-73.9757216124349 40.7754310239649) | 19 | 4 | 19 | 13 | ||||
983 | 983 | -73.9641552070803 | 40.7908479527923 | 30B-AM-1007-05 | 30B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 10 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641552070803 40.7908479527923) | 19 | 4 | 19 | 13 | ||||||
1165 | 1165 | -73.9689504114652 | 40.7766770153764 | 14F-PM-1012-05 | 14F | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2 | on a fallen branch | true | false | false | true | false | sitting | false | false | false | false | false | false | false | false | looking at me | POINT (-73.9689504114652 40.7766770153764) | 19 | 4 | 19 | 13 | ||
1259 | 1259 | -73.976864402584 | 40.7705663751959 | 5C-PM-1010-05 | 05C | PM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.976864402584 40.7705663751959) | 19 | 4 | 19 | 13 | |||||
1366 | 1366 | -73.9711582199102 | 40.7783674409485 | 15C-PM-1017-05 | 15C | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | true | false | false | false | true | true | false | false | POINT (-73.9711582199102 40.7783674409485) | 19 | 4 | 19 | 13 | |||||
1446 | 1446 | -73.9775238847836 | 40.7675792683587 | 2D-AM-1007-05 | 02D | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 100 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9775238847836 40.7675792683587) | 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 | ||||
1496 | 1496 | -73.9615500510038 | 40.7920799263699 | 32C-PM-1013-05 | 32C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9615500510038 40.7920799263699) | 19 | 4 | 19 | 13 | ||||||
1568 | 1568 | -73.9681079869821 | 40.7723494081345 | 11I-PM-1012-05 | 11I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9681079869821 40.7723494081345) | 19 | 4 | 19 | 13 | ||||||
1587 | 1587 | -73.9805517765469 | 40.7683044693163 | 2B-PM-1013-05 | 02B | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | climbing fence! | false | false | false | false | false | false | false | false | snuck into bike cart! | POINT (-73.9805517765469 40.7683044693163) | 19 | 4 | 19 | 13 | |||
1606 | 1606 | -73.9628932797886 | 40.7923116396365 | 32B-PM-1010-05 | 32B | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9628932797886 40.7923116396365) | 19 | 4 | 19 | 13 | ||||||
1763 | 1763 | -73.9768286349595 | 40.7687012827059 | 3D-PM-1010-05 | 03D | PM | 10102018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9768286349595 40.7687012827059) | 19 | 4 | 19 | 13 | ||||||
1888 | 1888 | -73.9673919075839 | 40.7786845769177 | 17F-PM-1020-05 | 17F | PM | 10202018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9673919075839 40.7786845769177) | 19 | 4 | 19 | 13 | ||||||
1947 | 1947 | -73.9747175419546 | 40.7692820030878 | 5E-PM-1012-05 | 05E | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | begging | POINT (-73.9747175419546 40.7692820030878) | 19 | 4 | 19 | 13 | ||||
2002 | 2002 | -73.9581706950566 | 40.7906321397269 | 32F-AM-1012-05 | 32F | AM | 10122018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9581706950566 40.7906321397269) | 19 | 4 | 19 | 13 | |||||
2053 | 2053 | -73.9711810222421 | 40.7773445611969 | 14D-PM-1019-05 | 14D | PM | 10192018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9711810222421 40.7773445611969) | 19 | 4 | 19 | 13 | ||||||
2087 | 2087 | -73.956502663005 | 40.788160908881 | 30I-PM-1006-05 | 30I | PM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.956502663005 40.788160908881) | 19 | 4 | 19 | 13 | |||||
2107 | 2107 | -73.9772624834791 | 40.7692821918543 | 4C-PM-1010-05 | 04C | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9772624834791 40.7692821918543) | 19 | 4 | 19 | 13 | |||||
2148 | 2148 | -73.9767317539505 | 40.7717600450632 | 6B-PM-1017-05 | 06B | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767317539505 40.7717600450632) | 19 | 4 | 19 | 13 | |||||
2170 | 2170 | -73.9678923667678 | 40.7819675626236 | 20C-PM-1018-05 | 20C | PM | 10182018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.9678923667678 40.781967562623606) | 19 | 4 | 19 | 13 | ||||||
2173 | 2173 | -73.9546123259441 | 40.7941434862099 | 37G-PM-1007-05 | 37G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | jumping around! | false | false | false | false | false | false | false | false | POINT (-73.9546123259441 40.7941434862099) | 19 | 4 | 19 | 13 | ||||
2515 | 2515 | -73.9693338657183 | 40.7757055884538 | 13F-PM-1008-05 | 13F | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | tree trunk | true | false | false | true | true | true | false | false | false | true | false | false | false | POINT (-73.9693338657183 40.77570558845381) | 19 | 4 | 19 | 13 | ||||
2646 | 2646 | -73.9772239251936 | 40.7731716665766 | 8A-AM-1013-05 | 08A | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9772239251936 40.7731716665766) | 19 | 4 | 19 | 13 | |||||
2658 | 2658 | -73.9690212174 | 40.7834099404107 | 21B-PM-1017-05 | 21B | PM | 10172018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9690212174 40.7834099404107) | 19 | 4 | 19 | 13 | ||||||
2703 | 2703 | -73.9690174442945 | 40.7817617696508 | 19C-PM-1018-05 | 19C | PM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.9690174442945 40.7817617696508) | 19 | 4 | 19 | 13 | |||||
2777 | 2777 | -73.9810843611086 | 40.7687905493699 | 2A-PM-1019-05 | 02A | PM | 10192018 | 5 | ? | Gray | Gray+ | Above Ground | 50 | in tall planetree | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9810843611086 40.7687905493699) | 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 | |||
2889 | 2889 | -73.9771646835311 | 40.7693049165084 | 4C-PM-1010-05 | 04C | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9771646835311 40.7693049165084) | 19 | 4 | 19 | 13 | |||||
2899 | 2899 | -73.9686358129525 | 40.7778035516486 | 16E-AM-1014-05 | 16E | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686358129525 40.7778035516486) | 19 | 4 | 19 | 13 | |||||
2913 | 2913 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9621297946132 40.7944058222814) | 19 | 4 | 19 | 13 | |||||
2930 | 2930 | -73.9692563597762 | 40.770904999952 | 9H-PM-1018-05 | 09H | PM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9692563597762 40.770904999952) | 19 | 4 | 19 | 13 | ||||||
2944 | 2944 | -73.9739403850622 | 40.7693162287509 | 5F-AM-1007-05 | 05F | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 2 | tree | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9739403850622 40.7693162287509) | 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 );