This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Other Activities, Tail flags, Tail twitches, Approaches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32 | 32 | -73.9576530157255 | 40.7868659490397 | 29I-PM-1007-01 | 29I | PM | 10072018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9576530157255 40.7868659490397) | 19 | 4 | 19 | 13 | ||||||
213 | 213 | -73.968367485157 | 40.7838472644815 | 22B-PM-1014-05 | 22B | PM | 10142018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | eating (eats with head tilted far to the right (tooth issue?)) | false | false | false | false | false | false | false | false | POINT (-73.968367485157 40.7838472644815) | 19 | 4 | 19 | 13 | |||||
252 | 252 | -73.974420668782 | 40.7749628597465 | 10C-PM-1013-04 | 10C | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.974420668782 40.7749628597465) | 19 | 4 | 19 | 13 | ||||||
446 | 446 | -73.9678774314725 | 40.7738535171265 | 12H-PM-1007-04 | 12H | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | false | mushroom | false | false | false | false | false | false | true | false | POINT (-73.9678774314725 40.7738535171265) | 19 | 4 | 19 | 13 | |||||||
577 | 577 | -73.9497217674555 | 40.796517007214 | 42I-PM-1014-03 | 42I | PM | 10142018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9497217674555 40.796517007214) | 19 | 4 | 19 | 13 | ||||||
727 | 727 | -73.9634563222926 | 40.780992836417 | 21G-PM-1007-04 | 21G | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9634563222926 40.780992836417) | 19 | 4 | 19 | 13 | ||||||
761 | 761 | -73.975062146111 | 40.7723417173451 | 8C-PM-1013-07 | 08C | PM | 10132018 | 7 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.975062146111 40.7723417173451) | 19 | 4 | 19 | 13 | ||||||
814 | 814 | -73.9607608482656 | 40.7954687648248 | 36A-PM-1013-06 | 36A | PM | 10132018 | 6 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | EDGE OF WOODS | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9607608482656 40.7954687648248) | 19 | 4 | 19 | 13 | |||||
1029 | 1029 | -73.9601259189134 | 40.7955350609057 | 36B-PM-1013-04 | 36B | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9601259189134 40.7955350609057) | 19 | 4 | 19 | 13 | ||||||
1330 | 1330 | -73.9643032554205 | 40.7794514526463 | 19H-AM-1010-02 | 19H | AM | 10102018 | 2 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near base of small tree | true | false | false | true | true | false | false | false | true | false | true | false | false | ran from human with dog | POINT (-73.9643032554205 40.7794514526463) | 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 | ||||
1622 | 1622 | -73.9615090149261 | 40.7945150173918 | 35A-PM-1013-09 | 35A | PM | 10132018 | 9 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9615090149261 40.7945150173918) | 19 | 4 | 19 | 13 | ||||||
1767 | 1767 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 10142018 | 4 | Gray | White | Gray+White | Above Ground | 15 | Ground then tree to eat | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.958719099962 40.7947587726617) | 19 | 4 | 19 | 13 | |||||
1966 | 1966 | -73.9750911996499 | 40.7722445210179 | 8C-PM-1013-06 | 08C | PM | 10132018 | 6 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9750911996499 40.7722445210179) | 19 | 4 | 19 | 13 | ||||||
2163 | 2163 | -73.9643664403785 | 40.7793670703727 | 19H-AM-1010-01 | 19H | AM | 10102018 | 1 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near base of small tree | true | false | false | true | true | false | false | false | false | false | false | true | false | run from human w/ dog | POINT (-73.9643664403785 40.7793670703727) | 19 | 4 | 19 | 13 | ||||
2339 | 2339 | -73.9695117797648 | 40.7802675743233 | 18C-PM-1018-07 | 18C | PM | 10182018 | 7 | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9695117797648 40.780267574323304) | 19 | 4 | 19 | 13 | |||||||
2707 | 2707 | -73.9743165321099 | 40.7754674678574 | 11B-PM-1014-07 | 11B | PM | 10142018 | 7 | Gray | Gray+ | Above Ground | 10 | true | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9743165321099 40.7754674678574) | 19 | 4 | 19 | 13 | |||||||
2931 | 2931 | -73.9730926233232 | 40.7781330751738 | 14B-PM-1014-08 | 14B | PM | 10142018 | 8 | Gray | Cinnamon, White | Gray+Cinnamon, White | White belly & stripes on tail, Cinnamon face & stripes on back | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9730926233232 40.7781330751738) | 19 | 4 | 19 | 13 | |||||
2951 | 2951 | -73.9742986032935 | 40.7770454318226 | 13A-PM-1014-04 | 13A | PM | 10142018 | 4 | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9742986032935 40.7770454318226) | 19 | 4 | 19 | 13 | |||||||
2954 | 2954 | -73.9677474313377 | 40.7742119240825 | 12H-PM-1007-03 | 12H | PM | 10072018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | peanuts | false | false | false | false | false | false | true | false | POINT (-73.9677474313377 40.7742119240825) | 19 | 4 | 19 | 13 | |||||
2981 | 2981 | -73.9800094828465 | 40.7677782585639 | 1B-AM-1012-04 | 01B | AM | 10122018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9800094828465 40.7677782585639) | 19 | 4 | 19 | 13 | ||||||
2995 | 2995 | -73.9668442742942 | 40.7870781042595 | 25B-PM-1007-01 | 25B | PM | 10072018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9668442742942 40.7870781042595) | 19 | 4 | 19 | 13 | ||||||
3014 | 3014 | -73.9665572004288 | 40.7804347548303 | 19E-PM-1018-04 | 19E | PM | 10182018 | 4 | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9665572004288 40.7804347548303) | 19 | 4 | 19 | 13 | |||||||
3022 | 3022 | -73.9639941227864 | 40.7899152327912 | 29B-PM-1010-02 | 29B | PM | 10102018 | 2 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9639941227864 40.7899152327912) | 19 | 4 | 19 | 13 | ||||||
109 | 109 | -73.967097592707 | 40.7854119342538 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | true | false | false | true | false | took nut to bury | false | false | false | false | true | false | false | true | POINT (-73.967097592707 40.7854119342538) | 19 | 4 | 19 | 13 | ||||||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | true | false | false | true | false | false | false | false | false | true | false | false | true | ran up tree | POINT (-73.959709414696 40.7919745085986) | 19 | 4 | 19 | 13 | ||||||
650 | 650 | -73.9809610117171 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 10102018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
2739 | 2739 | -73.9681960138614 | 40.7726867422002 | 11H-AM-1010-02 | 11H | AM | 10102018 | 2 | Cinnamon | Gray | Cinnamon+Gray | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9681960138614 40.7726867422002) | 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 |
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 );