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-12-08 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
808344 | 808344 | 2020-12-08 | Adair | Missouri | 29001 | 1335 | 3 |
808345 | 808345 | 2020-12-08 | Andrew | Missouri | 29003 | 911 | 12 |
808346 | 808346 | 2020-12-08 | Atchison | Missouri | 29005 | 234 | 4 |
808347 | 808347 | 2020-12-08 | Audrain | Missouri | 29007 | 1504 | 24 |
808348 | 808348 | 2020-12-08 | Barry | Missouri | 29009 | 1560 | 31 |
808349 | 808349 | 2020-12-08 | Barton | Missouri | 29011 | 666 | 6 |
808350 | 808350 | 2020-12-08 | Bates | Missouri | 29013 | 622 | 9 |
808351 | 808351 | 2020-12-08 | Benton | Missouri | 29015 | 911 | 11 |
808352 | 808352 | 2020-12-08 | Bollinger | Missouri | 29017 | 878 | 10 |
808353 | 808353 | 2020-12-08 | Boone | Missouri | 29019 | 11287 | 32 |
808354 | 808354 | 2020-12-08 | Buchanan | Missouri | 29021 | 7021 | 92 |
808355 | 808355 | 2020-12-08 | Butler | Missouri | 29023 | 2407 | 10 |
808356 | 808356 | 2020-12-08 | Caldwell | Missouri | 29025 | 442 | 3 |
808357 | 808357 | 2020-12-08 | Callaway | Missouri | 29027 | 3150 | 13 |
808358 | 808358 | 2020-12-08 | Camden | Missouri | 29029 | 2671 | 51 |
808359 | 808359 | 2020-12-08 | Cape Girardeau | Missouri | 29031 | 6322 | 88 |
808360 | 808360 | 2020-12-08 | Carroll | Missouri | 29033 | 506 | 8 |
808361 | 808361 | 2020-12-08 | Carter | Missouri | 29035 | 323 | 6 |
808362 | 808362 | 2020-12-08 | Cass | Missouri | 29037 | 4357 | 41 |
808363 | 808363 | 2020-12-08 | Cedar | Missouri | 29039 | 459 | 8 |
808364 | 808364 | 2020-12-08 | Chariton | Missouri | 29041 | 268 | 0 |
808365 | 808365 | 2020-12-08 | Christian | Missouri | 29043 | 4592 | 28 |
808366 | 808366 | 2020-12-08 | Clark | Missouri | 29045 | 327 | 4 |
808367 | 808367 | 2020-12-08 | Clay | Missouri | 29047 | 5581 | 84 |
808368 | 808368 | 2020-12-08 | Clinton | Missouri | 29049 | 1014 | 48 |
808369 | 808369 | 2020-12-08 | Cole | Missouri | 29051 | 6728 | 67 |
808370 | 808370 | 2020-12-08 | Cooper | Missouri | 29053 | 1259 | 10 |
808371 | 808371 | 2020-12-08 | Crawford | Missouri | 29055 | 1317 | 14 |
808372 | 808372 | 2020-12-08 | Dade | Missouri | 29057 | 462 | 29 |
808373 | 808373 | 2020-12-08 | Dallas | Missouri | 29059 | 627 | 13 |
808374 | 808374 | 2020-12-08 | Daviess | Missouri | 29061 | 380 | 8 |
808375 | 808375 | 2020-12-08 | DeKalb | Missouri | 29063 | 654 | 16 |
808376 | 808376 | 2020-12-08 | Dent | Missouri | 29065 | 586 | 5 |
808377 | 808377 | 2020-12-08 | Douglas | Missouri | 29067 | 476 | 16 |
808378 | 808378 | 2020-12-08 | Dunklin | Missouri | 29069 | 1798 | 14 |
808379 | 808379 | 2020-12-08 | Franklin | Missouri | 29071 | 5341 | 95 |
808380 | 808380 | 2020-12-08 | Gasconade | Missouri | 29073 | 534 | 25 |
808381 | 808381 | 2020-12-08 | Gentry | Missouri | 29075 | 487 | 14 |
808382 | 808382 | 2020-12-08 | Greene | Missouri | 29077 | 16749 | 247 |
808383 | 808383 | 2020-12-08 | Grundy | Missouri | 29079 | 558 | 14 |
808384 | 808384 | 2020-12-08 | Harrison | Missouri | 29081 | 477 | 4 |
808385 | 808385 | 2020-12-08 | Henry | Missouri | 29083 | 1199 | 14 |
808386 | 808386 | 2020-12-08 | Hickory | Missouri | 29085 | 388 | 6 |
808387 | 808387 | 2020-12-08 | Holt | Missouri | 29087 | 292 | 5 |
808388 | 808388 | 2020-12-08 | Howard | Missouri | 29089 | 541 | 2 |
808389 | 808389 | 2020-12-08 | Howell | Missouri | 29091 | 1681 | 32 |
808390 | 808390 | 2020-12-08 | Iron | Missouri | 29093 | 269 | 1 |
808391 | 808391 | 2020-12-08 | Jackson | Missouri | 29095 | 19335 | 193 |
808392 | 808392 | 2020-12-08 | Jasper | Missouri | 29097 | 5297 | 71 |
808393 | 808393 | 2020-12-08 | Jefferson | Missouri | 29099 | 13745 | 111 |
808394 | 808394 | 2020-12-08 | Johnson | Missouri | 29101 | 2744 | 19 |
808395 | 808395 | 2020-12-08 | Joplin | Missouri | 3486 | 56 | |
808396 | 808396 | 2020-12-08 | Kansas City | Missouri | 25544 | 313 | |
808397 | 808397 | 2020-12-08 | Knox | Missouri | 29103 | 137 | 1 |
808398 | 808398 | 2020-12-08 | Laclede | Missouri | 29105 | 2055 | 35 |
808399 | 808399 | 2020-12-08 | Lafayette | Missouri | 29107 | 1690 | 31 |
808400 | 808400 | 2020-12-08 | Lawrence | Missouri | 29109 | 2044 | 41 |
808401 | 808401 | 2020-12-08 | Lewis | Missouri | 29111 | 473 | 2 |
808402 | 808402 | 2020-12-08 | Lincoln | Missouri | 29113 | 2784 | 13 |
808403 | 808403 | 2020-12-08 | Linn | Missouri | 29115 | 353 | 11 |
808404 | 808404 | 2020-12-08 | Livingston | Missouri | 29117 | 844 | 16 |
808405 | 808405 | 2020-12-08 | Macon | Missouri | 29121 | 738 | 4 |
808406 | 808406 | 2020-12-08 | Madison | Missouri | 29123 | 987 | 10 |
808407 | 808407 | 2020-12-08 | Maries | Missouri | 29125 | 400 | 4 |
808408 | 808408 | 2020-12-08 | Marion | Missouri | 29127 | 1992 | 20 |
808409 | 808409 | 2020-12-08 | McDonald | Missouri | 29119 | 1724 | 24 |
808410 | 808410 | 2020-12-08 | Mercer | Missouri | 29129 | 93 | 1 |
808411 | 808411 | 2020-12-08 | Miller | Missouri | 29131 | 1679 | 27 |
808412 | 808412 | 2020-12-08 | Mississippi | Missouri | 29133 | 984 | 7 |
808413 | 808413 | 2020-12-08 | Moniteau | Missouri | 29135 | 1331 | 15 |
808414 | 808414 | 2020-12-08 | Monroe | Missouri | 29137 | 424 | 5 |
808415 | 808415 | 2020-12-08 | Montgomery | Missouri | 29139 | 381 | 6 |
808416 | 808416 | 2020-12-08 | Morgan | Missouri | 29141 | 1202 | 14 |
808417 | 808417 | 2020-12-08 | New Madrid | Missouri | 29143 | 1431 | 25 |
808418 | 808418 | 2020-12-08 | Newton | Missouri | 29145 | 3096 | 39 |
808419 | 808419 | 2020-12-08 | Nodaway | Missouri | 29147 | 2118 | 16 |
808420 | 808420 | 2020-12-08 | Oregon | Missouri | 29149 | 406 | 2 |
808421 | 808421 | 2020-12-08 | Osage | Missouri | 29151 | 1026 | 6 |
808422 | 808422 | 2020-12-08 | Ozark | Missouri | 29153 | 314 | 3 |
808423 | 808423 | 2020-12-08 | Pemiscot | Missouri | 29155 | 1164 | 19 |
808424 | 808424 | 2020-12-08 | Perry | Missouri | 29157 | 1644 | 13 |
808425 | 808425 | 2020-12-08 | Pettis | Missouri | 29159 | 3658 | 38 |
808426 | 808426 | 2020-12-08 | Phelps | Missouri | 29161 | 2022 | 53 |
808427 | 808427 | 2020-12-08 | Pike | Missouri | 29163 | 1042 | 11 |
808428 | 808428 | 2020-12-08 | Platte | Missouri | 29165 | 1893 | 17 |
808429 | 808429 | 2020-12-08 | Polk | Missouri | 29167 | 2058 | 34 |
808430 | 808430 | 2020-12-08 | Pulaski | Missouri | 29169 | 1995 | 24 |
808431 | 808431 | 2020-12-08 | Putnam | Missouri | 29171 | 175 | 1 |
808432 | 808432 | 2020-12-08 | Ralls | Missouri | 29173 | 542 | 2 |
808433 | 808433 | 2020-12-08 | Randolph | Missouri | 29175 | 1352 | 9 |
808434 | 808434 | 2020-12-08 | Ray | Missouri | 29177 | 809 | 6 |
808435 | 808435 | 2020-12-08 | Reynolds | Missouri | 29179 | 329 | 2 |
808436 | 808436 | 2020-12-08 | Ripley | Missouri | 29181 | 577 | 8 |
808437 | 808437 | 2020-12-08 | Saline | Missouri | 29195 | 1688 | 14 |
808438 | 808438 | 2020-12-08 | Schuyler | Missouri | 29197 | 143 | 1 |
808439 | 808439 | 2020-12-08 | Scotland | Missouri | 29199 | 202 | 1 |
808440 | 808440 | 2020-12-08 | Scott | Missouri | 29201 | 2962 | 43 |
808441 | 808441 | 2020-12-08 | Shannon | Missouri | 29203 | 361 | 9 |
808442 | 808442 | 2020-12-08 | Shelby | Missouri | 29205 | 250 | 1 |
808443 | 808443 | 2020-12-08 | St. Charles | Missouri | 29183 | 24435 | 240 |
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);