ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89,600 rows where state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- St. Louis 396
- Greene 390
- Henry 389
- Cass 386
- Boone 385
- Cole 385
- Jackson 385
- St. Louis city 385
- St. Charles 384
- Christian 382
- Dunklin 382
- Kansas City 382
- Pulaski 382
- Scott 382
- Bates 381
- Jasper 381
- Johnson 381
- St. Francois 380
- Taney 380
- Adair 379
- Callaway 379
- Camden 379
- Clay 379
- Clinton 379
- Lafayette 379
- Moniteau 379
- Perry 379
- Cape Girardeau 378
- Franklin 378
- Jefferson 378
- …
state 1
- Missouri · 42,465 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194705 | 1194705 | 2021-04-06 | St. Clair | Missouri | 29185 | 790 | 8 |
1194706 | 1194706 | 2021-04-06 | St. Francois | Missouri | 29187 | 8800 | 110 |
1194707 | 1194707 | 2021-04-06 | St. Louis | Missouri | 29189 | 93620 | 2105 |
1194708 | 1194708 | 2021-04-06 | St. Louis city | Missouri | 29510 | 22798 | 458 |
1194709 | 1194709 | 2021-04-06 | Ste. Genevieve | Missouri | 29186 | 1810 | 16 |
1194710 | 1194710 | 2021-04-06 | Stoddard | Missouri | 29207 | 2494 | 37 |
1194711 | 1194711 | 2021-04-06 | Stone | Missouri | 29209 | 2380 | 40 |
1194712 | 1194712 | 2021-04-06 | Sullivan | Missouri | 29211 | 859 | 14 |
1194713 | 1194713 | 2021-04-06 | Taney | Missouri | 29213 | 5199 | 90 |
1194714 | 1194714 | 2021-04-06 | Texas | Missouri | 29215 | 1827 | 22 |
1194715 | 1194715 | 2021-04-06 | Vernon | Missouri | 29217 | 1973 | 42 |
1194716 | 1194716 | 2021-04-06 | Warren | Missouri | 29219 | 3055 | 30 |
1194717 | 1194717 | 2021-04-06 | Washington | Missouri | 29221 | 2731 | 49 |
1194718 | 1194718 | 2021-04-06 | Wayne | Missouri | 29223 | 1037 | 11 |
1194719 | 1194719 | 2021-04-06 | Webster | Missouri | 29225 | 3526 | 53 |
1194720 | 1194720 | 2021-04-06 | Worth | Missouri | 29227 | 164 | 2 |
1194721 | 1194721 | 2021-04-06 | Wright | Missouri | 29229 | 1556 | 29 |
1191356 | 1191356 | 2021-04-05 | Adair | Missouri | 29001 | 2406 | 20 |
1191357 | 1191357 | 2021-04-05 | Andrew | Missouri | 29003 | 1870 | 18 |
1191358 | 1191358 | 2021-04-05 | Atchison | Missouri | 29005 | 443 | 6 |
1191359 | 1191359 | 2021-04-05 | Audrain | Missouri | 29007 | 2764 | 57 |
1191360 | 1191360 | 2021-04-05 | Barry | Missouri | 29009 | 2892 | 45 |
1191361 | 1191361 | 2021-04-05 | Barton | Missouri | 29011 | 1164 | 14 |
1191362 | 1191362 | 2021-04-05 | Bates | Missouri | 29013 | 1321 | 27 |
1191363 | 1191363 | 2021-04-05 | Benton | Missouri | 29015 | 1668 | 29 |
1191364 | 1191364 | 2021-04-05 | Bollinger | Missouri | 29017 | 1127 | 12 |
1191365 | 1191365 | 2021-04-05 | Boone | Missouri | 29019 | 17951 | 86 |
1191366 | 1191366 | 2021-04-05 | Buchanan | Missouri | 29021 | 10259 | 179 |
1191367 | 1191367 | 2021-04-05 | Butler | Missouri | 29023 | 4157 | 40 |
1191368 | 1191368 | 2021-04-05 | Caldwell | Missouri | 29025 | 769 | 11 |
1191369 | 1191369 | 2021-04-05 | Callaway | Missouri | 29027 | 4909 | 47 |
1191370 | 1191370 | 2021-04-05 | Camden | Missouri | 29029 | 4012 | 85 |
1191371 | 1191371 | 2021-04-05 | Cape Girardeau | Missouri | 29031 | 9376 | 133 |
1191372 | 1191372 | 2021-04-05 | Carroll | Missouri | 29033 | 1063 | 23 |
1191373 | 1191373 | 2021-04-05 | Carter | Missouri | 29035 | 549 | 9 |
1191374 | 1191374 | 2021-04-05 | Cass | Missouri | 29037 | 8989 | 99 |
1191375 | 1191375 | 2021-04-05 | Cedar | Missouri | 29039 | 1092 | 20 |
1191376 | 1191376 | 2021-04-05 | Chariton | Missouri | 29041 | 668 | 6 |
1191377 | 1191377 | 2021-04-05 | Christian | Missouri | 29043 | 8717 | 88 |
1191378 | 1191378 | 2021-04-05 | Clark | Missouri | 29045 | 674 | 7 |
1191379 | 1191379 | 2021-04-05 | Clay | Missouri | 29047 | 9970 | 159 |
1191380 | 1191380 | 2021-04-05 | Clinton | Missouri | 29049 | 2036 | 65 |
1191381 | 1191381 | 2021-04-05 | Cole | Missouri | 29051 | 9062 | 122 |
1191382 | 1191382 | 2021-04-05 | Cooper | Missouri | 29053 | 1908 | 27 |
1191383 | 1191383 | 2021-04-05 | Crawford | Missouri | 29055 | 2521 | 35 |
1191384 | 1191384 | 2021-04-05 | Dade | Missouri | 29057 | 723 | 31 |
1191385 | 1191385 | 2021-04-05 | Dallas | Missouri | 29059 | 1253 | 26 |
1191386 | 1191386 | 2021-04-05 | Daviess | Missouri | 29061 | 738 | 11 |
1191387 | 1191387 | 2021-04-05 | DeKalb | Missouri | 29063 | 1150 | 30 |
1191388 | 1191388 | 2021-04-05 | Dent | Missouri | 29065 | 921 | 17 |
1191389 | 1191389 | 2021-04-05 | Douglas | Missouri | 29067 | 900 | 27 |
1191390 | 1191390 | 2021-04-05 | Dunklin | Missouri | 29069 | 2765 | 19 |
1191391 | 1191391 | 2021-04-05 | Franklin | Missouri | 29071 | 10461 | 177 |
1191392 | 1191392 | 2021-04-05 | Gasconade | Missouri | 29073 | 1569 | 43 |
1191393 | 1191393 | 2021-04-05 | Gentry | Missouri | 29075 | 837 | 20 |
1191394 | 1191394 | 2021-04-05 | Greene | Missouri | 29077 | 28429 | 451 |
1191395 | 1191395 | 2021-04-05 | Grundy | Missouri | 29079 | 1009 | 34 |
1191396 | 1191396 | 2021-04-05 | Harrison | Missouri | 29081 | 924 | 14 |
1191397 | 1191397 | 2021-04-05 | Henry | Missouri | 29083 | 2013 | 38 |
1191398 | 1191398 | 2021-04-05 | Hickory | Missouri | 29085 | 646 | 14 |
1191399 | 1191399 | 2021-04-05 | Holt | Missouri | 29087 | 424 | 11 |
1191400 | 1191400 | 2021-04-05 | Howard | Missouri | 29089 | 1061 | 7 |
1191401 | 1191401 | 2021-04-05 | Howell | Missouri | 29091 | 3501 | 43 |
1191402 | 1191402 | 2021-04-05 | Iron | Missouri | 29093 | 902 | 6 |
1191403 | 1191403 | 2021-04-05 | Jackson | Missouri | 29095 | 37381 | 409 |
1191404 | 1191404 | 2021-04-05 | Jasper | Missouri | 29097 | 9383 | 126 |
1191405 | 1191405 | 2021-04-05 | Jefferson | Missouri | 29099 | 22316 | 234 |
1191406 | 1191406 | 2021-04-05 | Johnson | Missouri | 29101 | 4933 | 49 |
1191407 | 1191407 | 2021-04-05 | Joplin | Missouri | 5979 | 105 | |
1191408 | 1191408 | 2021-04-05 | Kansas City | Missouri | 42763 | 557 | |
1191409 | 1191409 | 2021-04-05 | Knox | Missouri | 29103 | 383 | 2 |
1191410 | 1191410 | 2021-04-05 | Laclede | Missouri | 29105 | 3258 | 68 |
1191411 | 1191411 | 2021-04-05 | Lafayette | Missouri | 29107 | 3079 | 56 |
1191412 | 1191412 | 2021-04-05 | Lawrence | Missouri | 29109 | 3411 | 78 |
1191413 | 1191413 | 2021-04-05 | Lewis | Missouri | 29111 | 1042 | 12 |
1191414 | 1191414 | 2021-04-05 | Lincoln | Missouri | 29113 | 5597 | 39 |
1191415 | 1191415 | 2021-04-05 | Linn | Missouri | 29115 | 1211 | 12 |
1191416 | 1191416 | 2021-04-05 | Livingston | Missouri | 29117 | 1725 | 39 |
1191417 | 1191417 | 2021-04-05 | Macon | Missouri | 29121 | 1577 | 15 |
1191418 | 1191418 | 2021-04-05 | Madison | Missouri | 29123 | 1617 | 16 |
1191419 | 1191419 | 2021-04-05 | Maries | Missouri | 29125 | 629 | 8 |
1191420 | 1191420 | 2021-04-05 | Marion | Missouri | 29127 | 3615 | 43 |
1191421 | 1191421 | 2021-04-05 | McDonald | Missouri | 29119 | 2555 | 34 |
1191422 | 1191422 | 2021-04-05 | Mercer | Missouri | 29129 | 304 | 2 |
1191423 | 1191423 | 2021-04-05 | Miller | Missouri | 29131 | 2514 | 53 |
1191424 | 1191424 | 2021-04-05 | Mississippi | Missouri | 29133 | 1442 | 27 |
1191425 | 1191425 | 2021-04-05 | Moniteau | Missouri | 29135 | 1774 | 31 |
1191426 | 1191426 | 2021-04-05 | Monroe | Missouri | 29137 | 1014 | 11 |
1191427 | 1191427 | 2021-04-05 | Montgomery | Missouri | 29139 | 1031 | 10 |
1191428 | 1191428 | 2021-04-05 | Morgan | Missouri | 29141 | 1707 | 42 |
1191429 | 1191429 | 2021-04-05 | New Madrid | Missouri | 29143 | 2107 | 43 |
1191430 | 1191430 | 2021-04-05 | Newton | Missouri | 29145 | 5258 | 74 |
1191431 | 1191431 | 2021-04-05 | Nodaway | Missouri | 29147 | 2664 | 25 |
1191432 | 1191432 | 2021-04-05 | Oregon | Missouri | 29149 | 849 | 3 |
1191433 | 1191433 | 2021-04-05 | Osage | Missouri | 29151 | 1629 | 14 |
1191434 | 1191434 | 2021-04-05 | Ozark | Missouri | 29153 | 678 | 17 |
1191435 | 1191435 | 2021-04-05 | Pemiscot | Missouri | 29155 | 1545 | 29 |
1191436 | 1191436 | 2021-04-05 | Perry | Missouri | 29157 | 2169 | 29 |
1191437 | 1191437 | 2021-04-05 | Pettis | Missouri | 29159 | 5072 | 78 |
1191438 | 1191438 | 2021-04-05 | Phelps | Missouri | 29161 | 3753 | 127 |
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);