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-10-28 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 |
---|---|---|---|---|---|---|---|
676280 | 676280 | 2020-10-28 | Aurora | South Dakota | 46003 | 176 | 0 |
676281 | 676281 | 2020-10-28 | Beadle | South Dakota | 46005 | 1240 | 13 |
676282 | 676282 | 2020-10-28 | Bennett | South Dakota | 46007 | 183 | 5 |
676283 | 676283 | 2020-10-28 | Bon Homme | South Dakota | 46009 | 920 | 1 |
676284 | 676284 | 2020-10-28 | Brookings | South Dakota | 46011 | 1426 | 5 |
676285 | 676285 | 2020-10-28 | Brown | South Dakota | 46013 | 2014 | 4 |
676286 | 676286 | 2020-10-28 | Brule | South Dakota | 46015 | 282 | 2 |
676287 | 676287 | 2020-10-28 | Buffalo | South Dakota | 46017 | 249 | 4 |
676288 | 676288 | 2020-10-28 | Butte | South Dakota | 46019 | 355 | 3 |
676289 | 676289 | 2020-10-28 | Campbell | South Dakota | 46021 | 74 | 1 |
676290 | 676290 | 2020-10-28 | Charles Mix | South Dakota | 46023 | 391 | 0 |
676291 | 676291 | 2020-10-28 | Clark | South Dakota | 46025 | 114 | 0 |
676292 | 676292 | 2020-10-28 | Clay | South Dakota | 46027 | 817 | 8 |
676293 | 676293 | 2020-10-28 | Codington | South Dakota | 46029 | 1479 | 12 |
676294 | 676294 | 2020-10-28 | Corson | South Dakota | 46031 | 176 | 1 |
676295 | 676295 | 2020-10-28 | Custer | South Dakota | 46033 | 315 | 3 |
676296 | 676296 | 2020-10-28 | Davison | South Dakota | 46035 | 915 | 9 |
676297 | 676297 | 2020-10-28 | Day | South Dakota | 46037 | 159 | 2 |
676298 | 676298 | 2020-10-28 | Deuel | South Dakota | 46039 | 184 | 0 |
676299 | 676299 | 2020-10-28 | Dewey | South Dakota | 46041 | 327 | 0 |
676300 | 676300 | 2020-10-28 | Douglas | South Dakota | 46043 | 165 | 4 |
676301 | 676301 | 2020-10-28 | Edmunds | South Dakota | 46045 | 142 | 1 |
676302 | 676302 | 2020-10-28 | Fall River | South Dakota | 46047 | 203 | 6 |
676303 | 676303 | 2020-10-28 | Faulk | South Dakota | 46049 | 206 | 1 |
676304 | 676304 | 2020-10-28 | Grant | South Dakota | 46051 | 304 | 2 |
676305 | 676305 | 2020-10-28 | Gregory | South Dakota | 46053 | 224 | 10 |
676306 | 676306 | 2020-10-28 | Haakon | South Dakota | 46055 | 96 | 1 |
676307 | 676307 | 2020-10-28 | Hamlin | South Dakota | 46057 | 198 | 0 |
676308 | 676308 | 2020-10-28 | Hand | South Dakota | 46059 | 121 | 1 |
676309 | 676309 | 2020-10-28 | Hanson | South Dakota | 46061 | 93 | 1 |
676310 | 676310 | 2020-10-28 | Harding | South Dakota | 46063 | 52 | 0 |
676311 | 676311 | 2020-10-28 | Hughes | South Dakota | 46065 | 846 | 6 |
676312 | 676312 | 2020-10-28 | Hutchinson | South Dakota | 46067 | 229 | 2 |
676313 | 676313 | 2020-10-28 | Hyde | South Dakota | 46069 | 42 | 0 |
676314 | 676314 | 2020-10-28 | Jackson | South Dakota | 46071 | 121 | 1 |
676315 | 676315 | 2020-10-28 | Jerauld | South Dakota | 46073 | 158 | 12 |
676316 | 676316 | 2020-10-28 | Jones | South Dakota | 46075 | 32 | 0 |
676317 | 676317 | 2020-10-28 | Kingsbury | South Dakota | 46077 | 186 | 2 |
676318 | 676318 | 2020-10-28 | Lake | South Dakota | 46079 | 378 | 9 |
676319 | 676319 | 2020-10-28 | Lawrence | South Dakota | 46081 | 896 | 6 |
676320 | 676320 | 2020-10-28 | Lincoln | South Dakota | 46083 | 2759 | 18 |
676321 | 676321 | 2020-10-28 | Lyman | South Dakota | 46085 | 267 | 5 |
676322 | 676322 | 2020-10-28 | Marshall | South Dakota | 46091 | 64 | 1 |
676323 | 676323 | 2020-10-28 | McCook | South Dakota | 46087 | 234 | 1 |
676324 | 676324 | 2020-10-28 | McPherson | South Dakota | 46089 | 69 | 0 |
676325 | 676325 | 2020-10-28 | Meade | South Dakota | 46093 | 944 | 10 |
676326 | 676326 | 2020-10-28 | Mellette | South Dakota | 46095 | 80 | 1 |
676327 | 676327 | 2020-10-28 | Miner | South Dakota | 46097 | 142 | 1 |
676328 | 676328 | 2020-10-28 | Minnehaha | South Dakota | 46099 | 11281 | 107 |
676329 | 676329 | 2020-10-28 | Moody | South Dakota | 46101 | 213 | 2 |
676330 | 676330 | 2020-10-28 | Oglala Lakota | South Dakota | 46102 | 907 | 6 |
676331 | 676331 | 2020-10-28 | Pennington | South Dakota | 46103 | 4381 | 48 |
676332 | 676332 | 2020-10-28 | Perkins | South Dakota | 46105 | 78 | 0 |
676333 | 676333 | 2020-10-28 | Potter | South Dakota | 46107 | 103 | 0 |
676334 | 676334 | 2020-10-28 | Roberts | South Dakota | 46109 | 342 | 4 |
676335 | 676335 | 2020-10-28 | Sanborn | South Dakota | 46111 | 99 | 0 |
676336 | 676336 | 2020-10-28 | Spink | South Dakota | 46115 | 272 | 1 |
676337 | 676337 | 2020-10-28 | Stanley | South Dakota | 46117 | 90 | 0 |
676338 | 676338 | 2020-10-28 | Sully | South Dakota | 46119 | 41 | 0 |
676339 | 676339 | 2020-10-28 | Todd | South Dakota | 46121 | 453 | 6 |
676340 | 676340 | 2020-10-28 | Tripp | South Dakota | 46123 | 269 | 2 |
676341 | 676341 | 2020-10-28 | Turner | South Dakota | 46125 | 475 | 11 |
676342 | 676342 | 2020-10-28 | Union | South Dakota | 46127 | 747 | 11 |
676343 | 676343 | 2020-10-28 | Walworth | South Dakota | 46129 | 268 | 4 |
676344 | 676344 | 2020-10-28 | Yankton | South Dakota | 46135 | 842 | 5 |
676345 | 676345 | 2020-10-28 | Ziebach | South Dakota | 46137 | 92 | 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);