ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where "date" is on date 2020-09-17 and state = "Missouri" 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 |
---|---|---|---|---|---|---|---|
542389 | 542389 | 2020-09-17 | Adair | Missouri | 29001 | 328 | 0 |
542390 | 542390 | 2020-09-17 | Andrew | Missouri | 29003 | 194 | 1 |
542391 | 542391 | 2020-09-17 | Atchison | Missouri | 29005 | 43 | 0 |
542392 | 542392 | 2020-09-17 | Audrain | Missouri | 29007 | 386 | 2 |
542393 | 542393 | 2020-09-17 | Barry | Missouri | 29009 | 420 | 6 |
542394 | 542394 | 2020-09-17 | Barton | Missouri | 29011 | 161 | 0 |
542395 | 542395 | 2020-09-17 | Bates | Missouri | 29013 | 92 | 1 |
542396 | 542396 | 2020-09-17 | Benton | Missouri | 29015 | 200 | 2 |
542397 | 542397 | 2020-09-17 | Bollinger | Missouri | 29017 | 287 | 1 |
542398 | 542398 | 2020-09-17 | Boone | Missouri | 29019 | 4288 | 7 |
542399 | 542399 | 2020-09-17 | Buchanan | Missouri | 29021 | 1871 | 19 |
542400 | 542400 | 2020-09-17 | Butler | Missouri | 29023 | 519 | 4 |
542401 | 542401 | 2020-09-17 | Caldwell | Missouri | 29025 | 66 | 1 |
542402 | 542402 | 2020-09-17 | Callaway | Missouri | 29027 | 553 | 2 |
542403 | 542403 | 2020-09-17 | Camden | Missouri | 29029 | 747 | 10 |
542404 | 542404 | 2020-09-17 | Cape Girardeau | Missouri | 29031 | 1419 | 15 |
542405 | 542405 | 2020-09-17 | Carroll | Missouri | 29033 | 131 | 1 |
542406 | 542406 | 2020-09-17 | Carter | Missouri | 29035 | 59 | 1 |
542407 | 542407 | 2020-09-17 | Cass | Missouri | 29037 | 1404 | 18 |
542408 | 542408 | 2020-09-17 | Cedar | Missouri | 29039 | 77 | 0 |
542409 | 542409 | 2020-09-17 | Chariton | Missouri | 29041 | 42 | 0 |
542410 | 542410 | 2020-09-17 | Christian | Missouri | 29043 | 1169 | 4 |
542411 | 542411 | 2020-09-17 | Clark | Missouri | 29045 | 59 | 0 |
542412 | 542412 | 2020-09-17 | Clay | Missouri | 29047 | 1672 | 40 |
542413 | 542413 | 2020-09-17 | Clinton | Missouri | 29049 | 190 | 0 |
542414 | 542414 | 2020-09-17 | Cole | Missouri | 29051 | 1289 | 14 |
542415 | 542415 | 2020-09-17 | Cooper | Missouri | 29053 | 362 | 2 |
542416 | 542416 | 2020-09-17 | Crawford | Missouri | 29055 | 330 | 2 |
542417 | 542417 | 2020-09-17 | Dade | Missouri | 29057 | 44 | 0 |
542418 | 542418 | 2020-09-17 | Dallas | Missouri | 29059 | 164 | 1 |
542419 | 542419 | 2020-09-17 | Daviess | Missouri | 29061 | 73 | 0 |
542420 | 542420 | 2020-09-17 | DeKalb | Missouri | 29063 | 104 | 2 |
542421 | 542421 | 2020-09-17 | Dent | Missouri | 29065 | 106 | 0 |
542422 | 542422 | 2020-09-17 | Douglas | Missouri | 29067 | 149 | 3 |
542423 | 542423 | 2020-09-17 | Dunklin | Missouri | 29069 | 693 | 6 |
542424 | 542424 | 2020-09-17 | Franklin | Missouri | 29071 | 1426 | 23 |
542425 | 542425 | 2020-09-17 | Gasconade | Missouri | 29073 | 148 | 15 |
542426 | 542426 | 2020-09-17 | Gentry | Missouri | 29075 | 110 | 9 |
542427 | 542427 | 2020-09-17 | Greene | Missouri | 29077 | 5233 | 49 |
542428 | 542428 | 2020-09-17 | Grundy | Missouri | 29079 | 158 | 2 |
542429 | 542429 | 2020-09-17 | Harrison | Missouri | 29081 | 99 | 1 |
542430 | 542430 | 2020-09-17 | Henry | Missouri | 29083 | 151 | 4 |
542431 | 542431 | 2020-09-17 | Hickory | Missouri | 29085 | 78 | 2 |
542432 | 542432 | 2020-09-17 | Holt | Missouri | 29087 | 72 | 0 |
542433 | 542433 | 2020-09-17 | Howard | Missouri | 29089 | 161 | 2 |
542434 | 542434 | 2020-09-17 | Howell | Missouri | 29091 | 467 | 3 |
542435 | 542435 | 2020-09-17 | Iron | Missouri | 29093 | 47 | 0 |
542436 | 542436 | 2020-09-17 | Jackson | Missouri | 29095 | 6796 | 90 |
542437 | 542437 | 2020-09-17 | Jasper | Missouri | 29097 | 2105 | 20 |
542438 | 542438 | 2020-09-17 | Jefferson | Missouri | 29099 | 3789 | 54 |
542439 | 542439 | 2020-09-17 | Johnson | Missouri | 29101 | 966 | 4 |
542440 | 542440 | 2020-09-17 | Joplin | Missouri | 1243 | 23 | |
542441 | 542441 | 2020-09-17 | Kansas City | Missouri | 10404 | 103 | |
542442 | 542442 | 2020-09-17 | Knox | Missouri | 29103 | 46 | 1 |
542443 | 542443 | 2020-09-17 | Laclede | Missouri | 29105 | 472 | 3 |
542444 | 542444 | 2020-09-17 | Lafayette | Missouri | 29107 | 368 | 2 |
542445 | 542445 | 2020-09-17 | Lawrence | Missouri | 29109 | 475 | 2 |
542446 | 542446 | 2020-09-17 | Lewis | Missouri | 29111 | 71 | 2 |
542447 | 542447 | 2020-09-17 | Lincoln | Missouri | 29113 | 694 | 3 |
542448 | 542448 | 2020-09-17 | Linn | Missouri | 29115 | 58 | 1 |
542449 | 542449 | 2020-09-17 | Livingston | Missouri | 29117 | 367 | 1 |
542450 | 542450 | 2020-09-17 | Macon | Missouri | 29121 | 119 | 0 |
542451 | 542451 | 2020-09-17 | Madison | Missouri | 29123 | 255 | 0 |
542452 | 542452 | 2020-09-17 | Maries | Missouri | 29125 | 66 | 0 |
542453 | 542453 | 2020-09-17 | Marion | Missouri | 29127 | 620 | 7 |
542454 | 542454 | 2020-09-17 | McDonald | Missouri | 29119 | 1093 | 11 |
542455 | 542455 | 2020-09-17 | Mercer | Missouri | 29129 | 28 | 0 |
542456 | 542456 | 2020-09-17 | Miller | Missouri | 29131 | 405 | 1 |
542457 | 542457 | 2020-09-17 | Mississippi | Missouri | 29133 | 277 | 3 |
542458 | 542458 | 2020-09-17 | Moniteau | Missouri | 29135 | 258 | 4 |
542459 | 542459 | 2020-09-17 | Monroe | Missouri | 29137 | 84 | 0 |
542460 | 542460 | 2020-09-17 | Montgomery | Missouri | 29139 | 75 | 1 |
542461 | 542461 | 2020-09-17 | Morgan | Missouri | 29141 | 235 | 1 |
542462 | 542462 | 2020-09-17 | New Madrid | Missouri | 29143 | 493 | 12 |
542463 | 542463 | 2020-09-17 | Newton | Missouri | 29145 | 1274 | 14 |
542464 | 542464 | 2020-09-17 | Nodaway | Missouri | 29147 | 589 | 1 |
542465 | 542465 | 2020-09-17 | Oregon | Missouri | 29149 | 88 | 0 |
542466 | 542466 | 2020-09-17 | Osage | Missouri | 29151 | 119 | 1 |
542467 | 542467 | 2020-09-17 | Ozark | Missouri | 29153 | 99 | 0 |
542468 | 542468 | 2020-09-17 | Pemiscot | Missouri | 29155 | 443 | 9 |
542469 | 542469 | 2020-09-17 | Perry | Missouri | 29157 | 554 | 4 |
542470 | 542470 | 2020-09-17 | Pettis | Missouri | 29159 | 927 | 11 |
542471 | 542471 | 2020-09-17 | Phelps | Missouri | 29161 | 376 | 1 |
542472 | 542472 | 2020-09-17 | Pike | Missouri | 29163 | 215 | 3 |
542473 | 542473 | 2020-09-17 | Platte | Missouri | 29165 | 629 | 11 |
542474 | 542474 | 2020-09-17 | Polk | Missouri | 29167 | 535 | 4 |
542475 | 542475 | 2020-09-17 | Pulaski | Missouri | 29169 | 509 | 5 |
542476 | 542476 | 2020-09-17 | Putnam | Missouri | 29171 | 30 | 1 |
542477 | 542477 | 2020-09-17 | Ralls | Missouri | 29173 | 138 | 0 |
542478 | 542478 | 2020-09-17 | Randolph | Missouri | 29175 | 196 | 2 |
542479 | 542479 | 2020-09-17 | Ray | Missouri | 29177 | 153 | 0 |
542480 | 542480 | 2020-09-17 | Reynolds | Missouri | 29179 | 28 | 0 |
542481 | 542481 | 2020-09-17 | Ripley | Missouri | 29181 | 133 | 0 |
542482 | 542482 | 2020-09-17 | Saline | Missouri | 29195 | 635 | 9 |
542483 | 542483 | 2020-09-17 | Schuyler | Missouri | 29197 | 22 | 0 |
542484 | 542484 | 2020-09-17 | Scotland | Missouri | 29199 | 26 | 1 |
542485 | 542485 | 2020-09-17 | Scott | Missouri | 29201 | 788 | 15 |
542486 | 542486 | 2020-09-17 | Shannon | Missouri | 29203 | 73 | 1 |
542487 | 542487 | 2020-09-17 | Shelby | Missouri | 29205 | 57 | 1 |
542488 | 542488 | 2020-09-17 | St. Charles | Missouri | 29183 | 7014 | 124 |
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);