This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Other Activities, Tail twitches, Indifferent, Runs from, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
336 | 336 | -73.9757413215621 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757413215621 40.7692582758978) | 19 | 4 | 19 | 13 | ||||||
709 | 709 | -73.9519387881692 | 40.7936273636929 | 38I-PM-1014-04 | 38I | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9519387881692 40.7936273636929) | 19 | 4 | 19 | 13 | ||||||
824 | 824 | -73.9606344681252 | 40.7958337780644 | 37B-PM-1013-04 | 37B | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9606344681252 40.795833778064406) | 19 | 4 | 19 | 13 | ||||||
889 | 889 | -73.9681042612938 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9681042612938 40.772331431865) | 19 | 4 | 19 | 13 | ||||||
903 | 903 | -73.9719941577406 | 40.77037129313 | 7G-AM-1010-04 | 07G | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9719941577406 40.77037129313) | 19 | 4 | 19 | 13 | ||||||
932 | 932 | -73.9718597156773 | 40.7765858763313 | 13C-PM-1019-04 | 13C | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9718597156773 40.7765858763313) | 19 | 4 | 19 | 13 | ||||||
1072 | 1072 | -73.9566571713254 | 40.7989855775435 | 41C-AM-1017-04 | 41C | AM | 10172018 | 4 | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9566571713254 40.7989855775435) | 19 | 4 | 19 | 13 | |||||||
1124 | 1124 | -73.959516757215 | 40.7952545908471 | 36C-PM-1013-04 | 36C | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | On rock | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.959516757215 40.7952545908471) | 19 | 4 | 19 | 13 | |||||
1458 | 1458 | -73.9545037193355 | 40.7900225055417 | 33I-PM-1006-04 | 33I | PM | 10062018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9545037193355 40.7900225055417) | 19 | 4 | 19 | 13 | ||||||
1690 | 1690 | -73.96052295327 | 40.7934359372871 | 34C-PM-1012-04 | 34C | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.96052295327 40.7934359372871) | 19 | 4 | 19 | 13 | ||||||
1736 | 1736 | -73.9743873549635 | 40.7745426051392 | 10C-AM-1018-04 | 10C | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9743873549635 40.7745426051392) | 19 | 4 | 19 | 13 | ||||||
1752 | 1752 | -73.9561091686663 | 40.7981463047425 | 41D-AM-1014-04 | 41D | AM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9561091686663 40.7981463047425) | 19 | 4 | 19 | 13 | ||||||
1794 | 1794 | -73.9757912350482 | 40.7747598621451 | 10B-AM-1006-04 | 10B | AM | 10062018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9757912350482 40.7747598621451) | 19 | 4 | 19 | 13 | ||||||
1823 | 1823 | -73.9612854506075 | 40.7920830673571 | 32C-PM-1013-04 | 32C | PM | 10132018 | 4 | Juvenile | Gray | Gray+ | Above Ground | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 | |||||||
1882 | 1882 | -73.9541601469123 | 40.7907832744689 | 34I-PM-1010-04 | 34I | PM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | across the lawn and climb up a small tree | true | false | true | false | false | grooming | false | false | false | false | false | false | false | false | POINT (-73.9541601469123 40.79078327446891) | 19 | 4 | 19 | 13 | ||||
1925 | 1925 | -73.9581389870644 | 40.7993081122523 | 41A-PM-1007-04 | 41A | PM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | true | false | false | laid down on the branch | false | false | false | false | false | false | false | true | POINT (-73.9581389870644 40.799308112252305) | 19 | 4 | 19 | 13 | |||||
1962 | 1962 | -73.9647318357023 | 40.7760936175332 | 15I-PM-1012-04 | 15I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9647318357023 40.7760936175332) | 19 | 4 | 19 | 13 | ||||||
2018 | 2018 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 10182018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
2101 | 2101 | -73.957600085245 | 40.7936111607879 | 35E-PM-1006-04 | 35E | PM | 10062018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.957600085245 40.7936111607879) | 19 | 4 | 19 | 13 | ||||||
2162 | 2162 | -73.9583300280173 | 40.7853495002675 | 27I-PM-1020-04 | 27I | PM | 10202018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9583300280173 40.7853495002675) | 19 | 4 | 19 | 13 | ||||||
2204 | 2204 | -73.9532427699097 | 40.7962643767092 | 40G-PM-1013-04 | 40G | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9532427699097 40.7962643767092) | 19 | 4 | 19 | 13 | ||||||
2246 | 2246 | -73.9711607544742 | 40.774988247642 | 12E-AM-1017-04 | 12E | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9711607544742 40.774988247642) | 19 | 4 | 19 | 13 | ||||||
2279 | 2279 | -73.9586085858962 | 40.7990326758282 | 40A-PM-1014-04 | 40A | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from path to bushes) | POINT (-73.9586085858962 40.7990326758282) | 19 | 4 | 19 | 13 | |||||
2442 | 2442 | -73.9699369796844 | 40.7720350191273 | 10G-PM-1017-04 | 10G | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9699369796844 40.7720350191273) | 19 | 4 | 19 | 13 | ||||||
2619 | 2619 | -73.9739737592602 | 40.7727130476777 | 9D-AM-1008-04 | 09D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9739737592602 40.7727130476777) | 19 | 4 | 19 | 13 | ||||||
2641 | 2641 | -73.9615516703494 | 40.7905219388359 | 31D-AM-1014-04 | 31D | AM | 10142018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | Open ground | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9615516703494 40.7905219388359) | 19 | 4 | 19 | 13 | |||||
2734 | 2734 | -73.9763629541474 | 40.7682321897044 | 3E-PM-1008-04 | 03E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9763629541474 40.7682321897044) | 19 | 4 | 19 | 13 | ||||||
2840 | 2840 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 10172018 | 4 | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
2866 | 2866 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 10172018 | 4 | Adult | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
2987 | 2987 | -73.9563724838337 | 40.7882504581015 | 31I-PM-1019-04 | 31I | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.95637248383372 40.7882504581015) | 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 |
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 );