⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

18,136 rows where state = "South Dakota" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • South Dakota · 18,136
Link rowid date ▲ county state fips cases deaths
955431 2021-01-22 Aurora South Dakota 46003 440 11
955432 2021-01-22 Beadle South Dakota 46005 2587 39
955433 2021-01-22 Bennett South Dakota 46007 376 8
955434 2021-01-22 Bon Homme South Dakota 46009 1504 23
955435 2021-01-22 Brookings South Dakota 46011 3353 32
955436 2021-01-22 Brown South Dakota 46013 4825 75
955437 2021-01-22 Brule South Dakota 46015 676 7
955438 2021-01-22 Buffalo South Dakota 46017 416 12
955439 2021-01-22 Butte South Dakota 46019 947 20
955440 2021-01-22 Campbell South Dakota 46021 119 4
955441 2021-01-22 Charles Mix South Dakota 46023 1201 14
955442 2021-01-22 Clark South Dakota 46025 329 4
955443 2021-01-22 Clay South Dakota 46027 1739 14
955444 2021-01-22 Codington South Dakota 46029 3705 73
955445 2021-01-22 Corson South Dakota 46031 458 11
955446 2021-01-22 Custer South Dakota 46033 719 10
955447 2021-01-22 Davison South Dakota 46035 2868 57
955448 2021-01-22 Day South Dakota 46037 586 23
955449 2021-01-22 Deuel South Dakota 46039 451 7
955450 2021-01-22 Dewey South Dakota 46041 1381 18
955451 2021-01-22 Douglas South Dakota 46043 409 9
955452 2021-01-22 Edmunds South Dakota 46045 448 5
955453 2021-01-22 Fall River South Dakota 46047 491 14
955454 2021-01-22 Faulk South Dakota 46049 328 13
955455 2021-01-22 Grant South Dakota 46051 889 36
955456 2021-01-22 Gregory South Dakota 46053 496 27
955457 2021-01-22 Haakon South Dakota 46055 240 9
955458 2021-01-22 Hamlin South Dakota 46057 662 38
955459 2021-01-22 Hand South Dakota 46059 321 4
955460 2021-01-22 Hanson South Dakota 46061 329 4
955461 2021-01-22 Harding South Dakota 46063 89 1
955462 2021-01-22 Hughes South Dakota 46065 2168 31
955463 2021-01-22 Hutchinson South Dakota 46067 746 23
955464 2021-01-22 Hyde South Dakota 46069 134 1
955465 2021-01-22 Jackson South Dakota 46071 269 13
955466 2021-01-22 Jerauld South Dakota 46073 265 16
955467 2021-01-22 Jones South Dakota 46075 79 0
955468 2021-01-22 Kingsbury South Dakota 46077 597 13
955469 2021-01-22 Lake South Dakota 46079 1119 16
955470 2021-01-22 Lawrence South Dakota 46081 2725 35
955471 2021-01-22 Lincoln South Dakota 46083 7328 70
955472 2021-01-22 Lyman South Dakota 46085 584 10
955473 2021-01-22 Marshall South Dakota 46091 281 5
955474 2021-01-22 McCook South Dakota 46087 714 22
955475 2021-01-22 McPherson South Dakota 46089 231 4
955476 2021-01-22 Meade South Dakota 46093 2433 28
955477 2021-01-22 Mellette South Dakota 46095 234 2
955478 2021-01-22 Miner South Dakota 46097 258 7
955479 2021-01-22 Minnehaha South Dakota 46099 26676 296
955480 2021-01-22 Moody South Dakota 46101 594 15
955481 2021-01-22 Oglala Lakota South Dakota 46102 2011 40
955482 2021-01-22 Pennington South Dakota 46103 12181 164
955483 2021-01-22 Perkins South Dakota 46105 321 11
955484 2021-01-22 Potter South Dakota 46107 342 3
955485 2021-01-22 Roberts South Dakota 46109 1089 34
955486 2021-01-22 Sanborn South Dakota 46111 323 3
955487 2021-01-22 Spink South Dakota 46115 747 24
955488 2021-01-22 Stanley South Dakota 46117 309 2
955489 2021-01-22 Sully South Dakota 46119 133 3
955490 2021-01-22 Todd South Dakota 46121 1198 22
955491 2021-01-22 Tripp South Dakota 46123 652 15
955492 2021-01-22 Turner South Dakota 46125 1029 49
955493 2021-01-22 Union South Dakota 46127 1830 36
955494 2021-01-22 Walworth South Dakota 46129 692 14
955495 2021-01-22 Yankton South Dakota 46135 2710 27
955496 2021-01-22 Ziebach South Dakota 46137 332 8
952186 2021-01-21 Aurora South Dakota 46003 440 11
952187 2021-01-21 Beadle South Dakota 46005 2587 38
952188 2021-01-21 Bennett South Dakota 46007 373 8
952189 2021-01-21 Bon Homme South Dakota 46009 1504 23
952190 2021-01-21 Brookings South Dakota 46011 3341 32
952191 2021-01-21 Brown South Dakota 46013 4811 75
952192 2021-01-21 Brule South Dakota 46015 672 7
952193 2021-01-21 Buffalo South Dakota 46017 416 12
952194 2021-01-21 Butte South Dakota 46019 944 20
952195 2021-01-21 Campbell South Dakota 46021 117 4
952196 2021-01-21 Charles Mix South Dakota 46023 1198 14
952197 2021-01-21 Clark South Dakota 46025 329 4
952198 2021-01-21 Clay South Dakota 46027 1734 13
952199 2021-01-21 Codington South Dakota 46029 3701 73
952200 2021-01-21 Corson South Dakota 46031 458 11
952201 2021-01-21 Custer South Dakota 46033 718 10
952202 2021-01-21 Davison South Dakota 46035 2860 56
952203 2021-01-21 Day South Dakota 46037 583 23
952204 2021-01-21 Deuel South Dakota 46039 450 7
952205 2021-01-21 Dewey South Dakota 46041 1372 18
952206 2021-01-21 Douglas South Dakota 46043 409 9
952207 2021-01-21 Edmunds South Dakota 46045 446 5
952208 2021-01-21 Fall River South Dakota 46047 489 13
952209 2021-01-21 Faulk South Dakota 46049 327 13
952210 2021-01-21 Grant South Dakota 46051 875 36
952211 2021-01-21 Gregory South Dakota 46053 496 26
952212 2021-01-21 Haakon South Dakota 46055 240 9
952213 2021-01-21 Hamlin South Dakota 46057 658 38
952214 2021-01-21 Hand South Dakota 46059 321 4
952215 2021-01-21 Hanson South Dakota 46061 329 4
952216 2021-01-21 Harding South Dakota 46063 89 1
952217 2021-01-21 Hughes South Dakota 46065 2157 30
952218 2021-01-21 Hutchinson South Dakota 46067 742 23
952219 2021-01-21 Hyde South Dakota 46069 134 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);