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-10-04 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1783338 | 1783338 | 2021-10-04 | Aurora | South Dakota | 46003 | 531 | 16 |
1783339 | 1783339 | 2021-10-04 | Beadle | South Dakota | 46005 | 3174 | 43 |
1783340 | 1783340 | 2021-10-04 | Bennett | South Dakota | 46007 | 437 | 9 |
1783341 | 1783341 | 2021-10-04 | Bon Homme | South Dakota | 46009 | 1604 | 29 |
1783342 | 1783342 | 2021-10-04 | Brookings | South Dakota | 46011 | 4955 | 38 |
1783343 | 1783343 | 2021-10-04 | Brown | South Dakota | 46013 | 6306 | 95 |
1783344 | 1783344 | 2021-10-04 | Brule | South Dakota | 46015 | 783 | 11 |
1783345 | 1783345 | 2021-10-04 | Buffalo | South Dakota | 46017 | 447 | 14 |
1783346 | 1783346 | 2021-10-04 | Butte | South Dakota | 46019 | 1720 | 26 |
1783347 | 1783347 | 2021-10-04 | Campbell | South Dakota | 46021 | 155 | 4 |
1783348 | 1783348 | 2021-10-04 | Charles Mix | South Dakota | 46023 | 1673 | 26 |
1783349 | 1783349 | 2021-10-04 | Clark | South Dakota | 46025 | 492 | 5 |
1783350 | 1783350 | 2021-10-04 | Clay | South Dakota | 46027 | 2108 | 16 |
1783351 | 1783351 | 2021-10-04 | Codington | South Dakota | 46029 | 5240 | 83 |
1783352 | 1783352 | 2021-10-04 | Corson | South Dakota | 46031 | 635 | 13 |
1783353 | 1783353 | 2021-10-04 | Custer | South Dakota | 46033 | 1227 | 15 |
1783354 | 1783354 | 2021-10-04 | Davison | South Dakota | 46035 | 3618 | 71 |
1783355 | 1783355 | 2021-10-04 | Day | South Dakota | 46037 | 779 | 30 |
1783356 | 1783356 | 2021-10-04 | Deuel | South Dakota | 46039 | 623 | 11 |
1783357 | 1783357 | 2021-10-04 | Dewey | South Dakota | 46041 | 1720 | 30 |
1783358 | 1783358 | 2021-10-04 | Douglas | South Dakota | 46043 | 500 | 9 |
1783359 | 1783359 | 2021-10-04 | Edmunds | South Dakota | 46045 | 561 | 14 |
1783360 | 1783360 | 2021-10-04 | Fall River | South Dakota | 46047 | 875 | 22 |
1783361 | 1783361 | 2021-10-04 | Faulk | South Dakota | 46049 | 392 | 14 |
1783362 | 1783362 | 2021-10-04 | Grant | South Dakota | 46051 | 1233 | 43 |
1783363 | 1783363 | 2021-10-04 | Gregory | South Dakota | 46053 | 679 | 30 |
1783364 | 1783364 | 2021-10-04 | Haakon | South Dakota | 46055 | 314 | 11 |
1783365 | 1783365 | 2021-10-04 | Hamlin | South Dakota | 46057 | 976 | 40 |
1783366 | 1783366 | 2021-10-04 | Hand | South Dakota | 46059 | 386 | 6 |
1783367 | 1783367 | 2021-10-04 | Hanson | South Dakota | 46061 | 424 | 4 |
1783368 | 1783368 | 2021-10-04 | Harding | South Dakota | 46063 | 144 | 1 |
1783369 | 1783369 | 2021-10-04 | Hughes | South Dakota | 46065 | 2755 | 43 |
1783370 | 1783370 | 2021-10-04 | Hutchinson | South Dakota | 46067 | 1017 | 28 |
1783371 | 1783371 | 2021-10-04 | Hyde | South Dakota | 46069 | 147 | 1 |
1783372 | 1783372 | 2021-10-04 | Jackson | South Dakota | 46071 | 370 | 15 |
1783373 | 1783373 | 2021-10-04 | Jerauld | South Dakota | 46073 | 293 | 17 |
1783374 | 1783374 | 2021-10-04 | Jones | South Dakota | 46075 | 136 | 0 |
1783375 | 1783375 | 2021-10-04 | Kingsbury | South Dakota | 46077 | 895 | 18 |
1783376 | 1783376 | 2021-10-04 | Lake | South Dakota | 46079 | 1523 | 20 |
1783377 | 1783377 | 2021-10-04 | Lawrence | South Dakota | 46081 | 4097 | 55 |
1783378 | 1783378 | 2021-10-04 | Lincoln | South Dakota | 46083 | 9841 | 78 |
1783379 | 1783379 | 2021-10-04 | Lyman | South Dakota | 46085 | 701 | 11 |
1783380 | 1783380 | 2021-10-04 | Marshall | South Dakota | 46091 | 410 | 6 |
1783381 | 1783381 | 2021-10-04 | McCook | South Dakota | 46087 | 882 | 25 |
1783382 | 1783382 | 2021-10-04 | McPherson | South Dakota | 46089 | 305 | 7 |
1783383 | 1783383 | 2021-10-04 | Meade | South Dakota | 46093 | 4175 | 40 |
1783384 | 1783384 | 2021-10-04 | Mellette | South Dakota | 46095 | 302 | 2 |
1783385 | 1783385 | 2021-10-04 | Miner | South Dakota | 46097 | 327 | 11 |
1783386 | 1783386 | 2021-10-04 | Minnehaha | South Dakota | 46099 | 35860 | 379 |
1783387 | 1783387 | 2021-10-04 | Moody | South Dakota | 46101 | 738 | 20 |
1783388 | 1783388 | 2021-10-04 | Oglala Lakota | South Dakota | 46102 | 2317 | 52 |
1783389 | 1783389 | 2021-10-04 | Pennington | South Dakota | 46103 | 19142 | 236 |
1783390 | 1783390 | 2021-10-04 | Perkins | South Dakota | 46105 | 393 | 14 |
1783391 | 1783391 | 2021-10-04 | Potter | South Dakota | 46107 | 403 | 4 |
1783392 | 1783392 | 2021-10-04 | Roberts | South Dakota | 46109 | 1485 | 43 |
1783393 | 1783393 | 2021-10-04 | Sanborn | South Dakota | 46111 | 366 | 3 |
1783394 | 1783394 | 2021-10-04 | Spink | South Dakota | 46115 | 971 | 27 |
1783395 | 1783395 | 2021-10-04 | Stanley | South Dakota | 46117 | 400 | 3 |
1783396 | 1783396 | 2021-10-04 | Sully | South Dakota | 46119 | 151 | 3 |
1783397 | 1783397 | 2021-10-04 | Todd | South Dakota | 46121 | 1468 | 35 |
1783398 | 1783398 | 2021-10-04 | Tripp | South Dakota | 46123 | 826 | 18 |
1783399 | 1783399 | 2021-10-04 | Turner | South Dakota | 46125 | 1295 | 60 |
1783400 | 1783400 | 2021-10-04 | Union | South Dakota | 46127 | 2490 | 44 |
1783401 | 1783401 | 2021-10-04 | Walworth | South Dakota | 46129 | 845 | 17 |
1783402 | 1783402 | 2021-10-04 | Yankton | South Dakota | 46135 | 3421 | 37 |
1783403 | 1783403 | 2021-10-04 | Ziebach | South Dakota | 46137 | 381 | 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);