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 2021-09-01 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 |
---|---|---|---|---|---|---|---|
1676124 | 1676124 | 2021-09-01 | Aurora | South Dakota | 46003 | 492 | 15 |
1676125 | 1676125 | 2021-09-01 | Beadle | South Dakota | 46005 | 3023 | 42 |
1676126 | 1676126 | 2021-09-01 | Bennett | South Dakota | 46007 | 415 | 9 |
1676127 | 1676127 | 2021-09-01 | Bon Homme | South Dakota | 46009 | 1573 | 29 |
1676128 | 1676128 | 2021-09-01 | Brookings | South Dakota | 46011 | 4512 | 37 |
1676129 | 1676129 | 2021-09-01 | Brown | South Dakota | 46013 | 5828 | 95 |
1676130 | 1676130 | 2021-09-01 | Brule | South Dakota | 46015 | 737 | 11 |
1676131 | 1676131 | 2021-09-01 | Buffalo | South Dakota | 46017 | 431 | 14 |
1676132 | 1676132 | 2021-09-01 | Butte | South Dakota | 46019 | 1336 | 24 |
1676133 | 1676133 | 2021-09-01 | Campbell | South Dakota | 46021 | 143 | 4 |
1676134 | 1676134 | 2021-09-01 | Charles Mix | South Dakota | 46023 | 1506 | 23 |
1676135 | 1676135 | 2021-09-01 | Clark | South Dakota | 46025 | 471 | 5 |
1676136 | 1676136 | 2021-09-01 | Clay | South Dakota | 46027 | 1991 | 15 |
1676137 | 1676137 | 2021-09-01 | Codington | South Dakota | 46029 | 4818 | 82 |
1676138 | 1676138 | 2021-09-01 | Corson | South Dakota | 46031 | 582 | 12 |
1676139 | 1676139 | 2021-09-01 | Custer | South Dakota | 46033 | 1029 | 14 |
1676140 | 1676140 | 2021-09-01 | Davison | South Dakota | 46035 | 3371 | 69 |
1676141 | 1676141 | 2021-09-01 | Day | South Dakota | 46037 | 734 | 30 |
1676142 | 1676142 | 2021-09-01 | Deuel | South Dakota | 46039 | 599 | 10 |
1676143 | 1676143 | 2021-09-01 | Dewey | South Dakota | 46041 | 1591 | 30 |
1676144 | 1676144 | 2021-09-01 | Douglas | South Dakota | 46043 | 479 | 9 |
1676145 | 1676145 | 2021-09-01 | Edmunds | South Dakota | 46045 | 524 | 14 |
1676146 | 1676146 | 2021-09-01 | Fall River | South Dakota | 46047 | 717 | 16 |
1676147 | 1676147 | 2021-09-01 | Faulk | South Dakota | 46049 | 377 | 14 |
1676148 | 1676148 | 2021-09-01 | Grant | South Dakota | 46051 | 1121 | 42 |
1676149 | 1676149 | 2021-09-01 | Gregory | South Dakota | 46053 | 598 | 30 |
1676150 | 1676150 | 2021-09-01 | Haakon | South Dakota | 46055 | 292 | 11 |
1676151 | 1676151 | 2021-09-01 | Hamlin | South Dakota | 46057 | 831 | 39 |
1676152 | 1676152 | 2021-09-01 | Hand | South Dakota | 46059 | 367 | 6 |
1676153 | 1676153 | 2021-09-01 | Hanson | South Dakota | 46061 | 410 | 4 |
1676154 | 1676154 | 2021-09-01 | Harding | South Dakota | 46063 | 117 | 1 |
1676155 | 1676155 | 2021-09-01 | Hughes | South Dakota | 46065 | 2632 | 43 |
1676156 | 1676156 | 2021-09-01 | Hutchinson | South Dakota | 46067 | 947 | 29 |
1676157 | 1676157 | 2021-09-01 | Hyde | South Dakota | 46069 | 145 | 1 |
1676158 | 1676158 | 2021-09-01 | Jackson | South Dakota | 46071 | 323 | 15 |
1676159 | 1676159 | 2021-09-01 | Jerauld | South Dakota | 46073 | 286 | 16 |
1676160 | 1676160 | 2021-09-01 | Jones | South Dakota | 46075 | 102 | 0 |
1676161 | 1676161 | 2021-09-01 | Kingsbury | South Dakota | 46077 | 838 | 18 |
1676162 | 1676162 | 2021-09-01 | Lake | South Dakota | 46079 | 1434 | 20 |
1676163 | 1676163 | 2021-09-01 | Lawrence | South Dakota | 46081 | 3505 | 50 |
1676164 | 1676164 | 2021-09-01 | Lincoln | South Dakota | 46083 | 9151 | 78 |
1676165 | 1676165 | 2021-09-01 | Lyman | South Dakota | 46085 | 678 | 11 |
1676166 | 1676166 | 2021-09-01 | Marshall | South Dakota | 46091 | 389 | 6 |
1676167 | 1676167 | 2021-09-01 | McCook | South Dakota | 46087 | 828 | 25 |
1676168 | 1676168 | 2021-09-01 | McPherson | South Dakota | 46089 | 257 | 4 |
1676169 | 1676169 | 2021-09-01 | Meade | South Dakota | 46093 | 3472 | 32 |
1676170 | 1676170 | 2021-09-01 | Mellette | South Dakota | 46095 | 272 | 2 |
1676171 | 1676171 | 2021-09-01 | Miner | South Dakota | 46097 | 315 | 10 |
1676172 | 1676172 | 2021-09-01 | Minnehaha | South Dakota | 46099 | 33334 | 368 |
1676173 | 1676173 | 2021-09-01 | Moody | South Dakota | 46101 | 703 | 20 |
1676174 | 1676174 | 2021-09-01 | Oglala Lakota | South Dakota | 46102 | 2176 | 51 |
1676175 | 1676175 | 2021-09-01 | Pennington | South Dakota | 46103 | 16026 | 210 |
1676176 | 1676176 | 2021-09-01 | Perkins | South Dakota | 46105 | 367 | 14 |
1676177 | 1676177 | 2021-09-01 | Potter | South Dakota | 46107 | 401 | 4 |
1676178 | 1676178 | 2021-09-01 | Roberts | South Dakota | 46109 | 1438 | 43 |
1676179 | 1676179 | 2021-09-01 | Sanborn | South Dakota | 46111 | 351 | 3 |
1676180 | 1676180 | 2021-09-01 | Spink | South Dakota | 46115 | 889 | 26 |
1676181 | 1676181 | 2021-09-01 | Stanley | South Dakota | 46117 | 371 | 2 |
1676182 | 1676182 | 2021-09-01 | Sully | South Dakota | 46119 | 148 | 3 |
1676183 | 1676183 | 2021-09-01 | Todd | South Dakota | 46121 | 1316 | 33 |
1676184 | 1676184 | 2021-09-01 | Tripp | South Dakota | 46123 | 789 | 17 |
1676185 | 1676185 | 2021-09-01 | Turner | South Dakota | 46125 | 1237 | 59 |
1676186 | 1676186 | 2021-09-01 | Union | South Dakota | 46127 | 2346 | 43 |
1676187 | 1676187 | 2021-09-01 | Walworth | South Dakota | 46129 | 792 | 15 |
1676188 | 1676188 | 2021-09-01 | Yankton | South Dakota | 46135 | 3215 | 33 |
1676189 | 1676189 | 2021-09-01 | Ziebach | South Dakota | 46137 | 349 | 9 |
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);