ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where "date" is on date 2020-11-11 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
721687 | 721687 | 2020-11-11 | Aurora | South Dakota | 46003 | 255 | 2 |
721688 | 721688 | 2020-11-11 | Beadle | South Dakota | 46005 | 1743 | 19 |
721689 | 721689 | 2020-11-11 | Bennett | South Dakota | 46007 | 259 | 5 |
721690 | 721690 | 2020-11-11 | Bon Homme | South Dakota | 46009 | 1180 | 4 |
721691 | 721691 | 2020-11-11 | Brookings | South Dakota | 46011 | 1854 | 12 |
721692 | 721692 | 2020-11-11 | Brown | South Dakota | 46013 | 2644 | 8 |
721693 | 721693 | 2020-11-11 | Brule | South Dakota | 46015 | 413 | 3 |
721694 | 721694 | 2020-11-11 | Buffalo | South Dakota | 46017 | 316 | 5 |
721695 | 721695 | 2020-11-11 | Butte | South Dakota | 46019 | 535 | 8 |
721696 | 721696 | 2020-11-11 | Campbell | South Dakota | 46021 | 88 | 1 |
721697 | 721697 | 2020-11-11 | Charles Mix | South Dakota | 46023 | 561 | 1 |
721698 | 721698 | 2020-11-11 | Clark | South Dakota | 46025 | 175 | 1 |
721699 | 721699 | 2020-11-11 | Clay | South Dakota | 46027 | 1008 | 8 |
721700 | 721700 | 2020-11-11 | Codington | South Dakota | 46029 | 2052 | 22 |
721701 | 721701 | 2020-11-11 | Corson | South Dakota | 46031 | 289 | 2 |
721702 | 721702 | 2020-11-11 | Custer | South Dakota | 46033 | 399 | 4 |
721703 | 721703 | 2020-11-11 | Davison | South Dakota | 46035 | 1599 | 14 |
721704 | 721704 | 2020-11-11 | Day | South Dakota | 46037 | 217 | 3 |
721705 | 721705 | 2020-11-11 | Deuel | South Dakota | 46039 | 232 | 2 |
721706 | 721706 | 2020-11-11 | Dewey | South Dakota | 46041 | 607 | 2 |
721707 | 721707 | 2020-11-11 | Douglas | South Dakota | 46043 | 234 | 5 |
721708 | 721708 | 2020-11-11 | Edmunds | South Dakota | 46045 | 190 | 1 |
721709 | 721709 | 2020-11-11 | Fall River | South Dakota | 46047 | 276 | 7 |
721710 | 721710 | 2020-11-11 | Faulk | South Dakota | 46049 | 247 | 5 |
721711 | 721711 | 2020-11-11 | Grant | South Dakota | 46051 | 413 | 4 |
721712 | 721712 | 2020-11-11 | Gregory | South Dakota | 46053 | 332 | 10 |
721713 | 721713 | 2020-11-11 | Haakon | South Dakota | 46055 | 115 | 3 |
721714 | 721714 | 2020-11-11 | Hamlin | South Dakota | 46057 | 285 | 0 |
721715 | 721715 | 2020-11-11 | Hand | South Dakota | 46059 | 209 | 1 |
721716 | 721716 | 2020-11-11 | Hanson | South Dakota | 46061 | 160 | 1 |
721717 | 721717 | 2020-11-11 | Harding | South Dakota | 46063 | 61 | 0 |
721718 | 721718 | 2020-11-11 | Hughes | South Dakota | 46065 | 1161 | 8 |
721719 | 721719 | 2020-11-11 | Hutchinson | South Dakota | 46067 | 351 | 2 |
721720 | 721720 | 2020-11-11 | Hyde | South Dakota | 46069 | 80 | 0 |
721721 | 721721 | 2020-11-11 | Jackson | South Dakota | 46071 | 165 | 4 |
721722 | 721722 | 2020-11-11 | Jerauld | South Dakota | 46073 | 197 | 13 |
721723 | 721723 | 2020-11-11 | Jones | South Dakota | 46075 | 43 | 0 |
721724 | 721724 | 2020-11-11 | Kingsbury | South Dakota | 46077 | 300 | 5 |
721725 | 721725 | 2020-11-11 | Lake | South Dakota | 46079 | 604 | 9 |
721726 | 721726 | 2020-11-11 | Lawrence | South Dakota | 46081 | 1454 | 8 |
721727 | 721727 | 2020-11-11 | Lincoln | South Dakota | 46083 | 3974 | 34 |
721728 | 721728 | 2020-11-11 | Lyman | South Dakota | 46085 | 341 | 7 |
721729 | 721729 | 2020-11-11 | Marshall | South Dakota | 46091 | 91 | 3 |
721730 | 721730 | 2020-11-11 | McCook | South Dakota | 46087 | 411 | 3 |
721731 | 721731 | 2020-11-11 | McPherson | South Dakota | 46089 | 78 | 1 |
721732 | 721732 | 2020-11-11 | Meade | South Dakota | 46093 | 1271 | 10 |
721733 | 721733 | 2020-11-11 | Mellette | South Dakota | 46095 | 114 | 1 |
721734 | 721734 | 2020-11-11 | Miner | South Dakota | 46097 | 166 | 3 |
721735 | 721735 | 2020-11-11 | Minnehaha | South Dakota | 46099 | 15366 | 126 |
721736 | 721736 | 2020-11-11 | Moody | South Dakota | 46101 | 311 | 4 |
721737 | 721737 | 2020-11-11 | Oglala Lakota | South Dakota | 46102 | 1301 | 11 |
721738 | 721738 | 2020-11-11 | Pennington | South Dakota | 46103 | 6175 | 55 |
721739 | 721739 | 2020-11-11 | Perkins | South Dakota | 46105 | 99 | 0 |
721740 | 721740 | 2020-11-11 | Potter | South Dakota | 46107 | 186 | 0 |
721741 | 721741 | 2020-11-11 | Roberts | South Dakota | 46109 | 507 | 10 |
721742 | 721742 | 2020-11-11 | Sanborn | South Dakota | 46111 | 168 | 1 |
721743 | 721743 | 2020-11-11 | Spink | South Dakota | 46115 | 417 | 6 |
721744 | 721744 | 2020-11-11 | Stanley | South Dakota | 46117 | 143 | 0 |
721745 | 721745 | 2020-11-11 | Sully | South Dakota | 46119 | 61 | 0 |
721746 | 721746 | 2020-11-11 | Todd | South Dakota | 46121 | 624 | 10 |
721747 | 721747 | 2020-11-11 | Tripp | South Dakota | 46123 | 360 | 2 |
721748 | 721748 | 2020-11-11 | Turner | South Dakota | 46125 | 652 | 31 |
721749 | 721749 | 2020-11-11 | Union | South Dakota | 46127 | 940 | 17 |
721750 | 721750 | 2020-11-11 | Walworth | South Dakota | 46129 | 337 | 10 |
721751 | 721751 | 2020-11-11 | Yankton | South Dakota | 46135 | 1166 | 8 |
721752 | 721752 | 2020-11-11 | Ziebach | South Dakota | 46137 | 134 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);