ny_times_us_counties

Table actions
⚠️ 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

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

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