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 2021-08-09 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1600450 | 1600450 | 2021-08-09 | Adair | Missouri | 29001 | 2888 | 27 |
1600451 | 1600451 | 2021-08-09 | Andrew | Missouri | 29003 | 2296 | 22 |
1600452 | 1600452 | 2021-08-09 | Atchison | Missouri | 29005 | 487 | 6 |
1600453 | 1600453 | 2021-08-09 | Audrain | Missouri | 29007 | 3052 | 58 |
1600454 | 1600454 | 2021-08-09 | Barry | Missouri | 29009 | 3637 | 51 |
1600455 | 1600455 | 2021-08-09 | Barton | Missouri | 29011 | 1476 | 18 |
1600456 | 1600456 | 2021-08-09 | Bates | Missouri | 29013 | 1649 | 33 |
1600457 | 1600457 | 2021-08-09 | Benton | Missouri | 29015 | 2068 | 36 |
1600458 | 1600458 | 2021-08-09 | Bollinger | Missouri | 29017 | 1238 | 15 |
1600459 | 1600459 | 2021-08-09 | Boone | Missouri | 29019 | 21679 | 126 |
1600460 | 1600460 | 2021-08-09 | Buchanan | Missouri | 29021 | 13125 | 200 |
1600461 | 1600461 | 2021-08-09 | Butler | Missouri | 29023 | 4918 | 54 |
1600462 | 1600462 | 2021-08-09 | Caldwell | Missouri | 29025 | 974 | 17 |
1600463 | 1600463 | 2021-08-09 | Callaway | Missouri | 29027 | 6039 | 52 |
1600464 | 1600464 | 2021-08-09 | Camden | Missouri | 29029 | 5289 | 105 |
1600465 | 1600465 | 2021-08-09 | Cape Girardeau | Missouri | 29031 | 10013 | 142 |
1600466 | 1600466 | 2021-08-09 | Carroll | Missouri | 29033 | 1158 | 25 |
1600467 | 1600467 | 2021-08-09 | Carter | Missouri | 29035 | 661 | 11 |
1600468 | 1600468 | 2021-08-09 | Cass | Missouri | 29037 | 11051 | 120 |
1600469 | 1600469 | 2021-08-09 | Cedar | Missouri | 29039 | 1446 | 21 |
1600470 | 1600470 | 2021-08-09 | Chariton | Missouri | 29041 | 858 | 8 |
1600471 | 1600471 | 2021-08-09 | Christian | Missouri | 29043 | 11871 | 112 |
1600472 | 1600472 | 2021-08-09 | Clark | Missouri | 29045 | 783 | 10 |
1600473 | 1600473 | 2021-08-09 | Clay | Missouri | 29047 | 11747 | 178 |
1600474 | 1600474 | 2021-08-09 | Clinton | Missouri | 29049 | 2300 | 65 |
1600475 | 1600475 | 2021-08-09 | Cole | Missouri | 29051 | 11196 | 134 |
1600476 | 1600476 | 2021-08-09 | Cooper | Missouri | 29053 | 2180 | 27 |
1600477 | 1600477 | 2021-08-09 | Crawford | Missouri | 29055 | 2953 | 41 |
1600478 | 1600478 | 2021-08-09 | Dade | Missouri | 29057 | 757 | 17 |
1600479 | 1600479 | 2021-08-09 | Dallas | Missouri | 29059 | 1945 | 35 |
1600480 | 1600480 | 2021-08-09 | Daviess | Missouri | 29061 | 823 | 12 |
1600481 | 1600481 | 2021-08-09 | DeKalb | Missouri | 29063 | 1255 | 33 |
1600482 | 1600482 | 2021-08-09 | Dent | Missouri | 29065 | 1343 | 21 |
1600483 | 1600483 | 2021-08-09 | Douglas | Missouri | 29067 | 1379 | 30 |
1600484 | 1600484 | 2021-08-09 | Dunklin | Missouri | 29069 | 3405 | 50 |
1600485 | 1600485 | 2021-08-09 | Franklin | Missouri | 29071 | 11680 | 188 |
1600486 | 1600486 | 2021-08-09 | Gasconade | Missouri | 29073 | 1740 | 47 |
1600487 | 1600487 | 2021-08-09 | Gentry | Missouri | 29075 | 1022 | 20 |
1600488 | 1600488 | 2021-08-09 | Greene | Missouri | 29077 | 39589 | 566 |
1600489 | 1600489 | 2021-08-09 | Grundy | Missouri | 29079 | 1256 | 36 |
1600490 | 1600490 | 2021-08-09 | Harrison | Missouri | 29081 | 957 | 14 |
1600491 | 1600491 | 2021-08-09 | Henry | Missouri | 29083 | 2457 | 41 |
1600492 | 1600492 | 2021-08-09 | Hickory | Missouri | 29085 | 878 | 16 |
1600493 | 1600493 | 2021-08-09 | Holt | Missouri | 29087 | 531 | 15 |
1600494 | 1600494 | 2021-08-09 | Howard | Missouri | 29089 | 1196 | 9 |
1600495 | 1600495 | 2021-08-09 | Howell | Missouri | 29091 | 4781 | 51 |
1600496 | 1600496 | 2021-08-09 | Iron | Missouri | 29093 | 995 | 7 |
1600497 | 1600497 | 2021-08-09 | Jackson | Missouri | 29095 | 45462 | 505 |
1600498 | 1600498 | 2021-08-09 | Jasper | Missouri | 29097 | 12021 | 146 |
1600499 | 1600499 | 2021-08-09 | Jefferson | Missouri | 29099 | 25838 | 260 |
1600500 | 1600500 | 2021-08-09 | Johnson | Missouri | 29101 | 5548 | 60 |
1600501 | 1600501 | 2021-08-09 | Joplin | Missouri | 7771 | 125 | |
1600502 | 1600502 | 2021-08-09 | Kansas City | Missouri | 51769 | 635 | |
1600503 | 1600503 | 2021-08-09 | Knox | Missouri | 29103 | 406 | 3 |
1600504 | 1600504 | 2021-08-09 | Laclede | Missouri | 29105 | 4566 | 92 |
1600505 | 1600505 | 2021-08-09 | Lafayette | Missouri | 29107 | 3674 | 59 |
1600506 | 1600506 | 2021-08-09 | Lawrence | Missouri | 29109 | 4538 | 94 |
1600507 | 1600507 | 2021-08-09 | Lewis | Missouri | 29111 | 1225 | 21 |
1600508 | 1600508 | 2021-08-09 | Lincoln | Missouri | 29113 | 7022 | 53 |
1600509 | 1600509 | 2021-08-09 | Linn | Missouri | 29115 | 1687 | 21 |
1600510 | 1600510 | 2021-08-09 | Livingston | Missouri | 29117 | 2275 | 51 |
1600511 | 1600511 | 2021-08-09 | Macon | Missouri | 29121 | 1822 | 19 |
1600512 | 1600512 | 2021-08-09 | Madison | Missouri | 29123 | 1809 | 17 |
1600513 | 1600513 | 2021-08-09 | Maries | Missouri | 29125 | 780 | 8 |
1600514 | 1600514 | 2021-08-09 | Marion | Missouri | 29127 | 4307 | 55 |
1600515 | 1600515 | 2021-08-09 | McDonald | Missouri | 29119 | 3388 | 43 |
1600516 | 1600516 | 2021-08-09 | Mercer | Missouri | 29129 | 331 | 2 |
1600517 | 1600517 | 2021-08-09 | Miller | Missouri | 29131 | 3294 | 63 |
1600518 | 1600518 | 2021-08-09 | Mississippi | Missouri | 29133 | 1587 | 28 |
1600519 | 1600519 | 2021-08-09 | Moniteau | Missouri | 29135 | 2096 | 33 |
1600520 | 1600520 | 2021-08-09 | Monroe | Missouri | 29137 | 1115 | 12 |
1600521 | 1600521 | 2021-08-09 | Montgomery | Missouri | 29139 | 1194 | 15 |
1600522 | 1600522 | 2021-08-09 | Morgan | Missouri | 29141 | 2180 | 46 |
1600523 | 1600523 | 2021-08-09 | New Madrid | Missouri | 29143 | 2318 | 48 |
1600524 | 1600524 | 2021-08-09 | Newton | Missouri | 29145 | 6885 | 94 |
1600525 | 1600525 | 2021-08-09 | Nodaway | Missouri | 29147 | 2937 | 30 |
1600526 | 1600526 | 2021-08-09 | Oregon | Missouri | 29149 | 1061 | 6 |
1600527 | 1600527 | 2021-08-09 | Osage | Missouri | 29151 | 1861 | 17 |
1600528 | 1600528 | 2021-08-09 | Ozark | Missouri | 29153 | 878 | 22 |
1600529 | 1600529 | 2021-08-09 | Pemiscot | Missouri | 29155 | 1677 | 39 |
1600530 | 1600530 | 2021-08-09 | Perry | Missouri | 29157 | 2400 | 30 |
1600531 | 1600531 | 2021-08-09 | Pettis | Missouri | 29159 | 6026 | 81 |
1600532 | 1600532 | 2021-08-09 | Phelps | Missouri | 29161 | 5052 | 145 |
1600533 | 1600533 | 2021-08-09 | Pike | Missouri | 29163 | 2037 | 28 |
1600534 | 1600534 | 2021-08-09 | Platte | Missouri | 29165 | 4836 | 53 |
1600535 | 1600535 | 2021-08-09 | Polk | Missouri | 29167 | 4523 | 48 |
1600536 | 1600536 | 2021-08-09 | Pulaski | Missouri | 29169 | 4361 | 59 |
1600537 | 1600537 | 2021-08-09 | Putnam | Missouri | 29171 | 514 | 4 |
1600538 | 1600538 | 2021-08-09 | Ralls | Missouri | 29173 | 1277 | 13 |
1600539 | 1600539 | 2021-08-09 | Randolph | Missouri | 29175 | 3018 | 31 |
1600540 | 1600540 | 2021-08-09 | Ray | Missouri | 29177 | 2263 | 37 |
1600541 | 1600541 | 2021-08-09 | Reynolds | Missouri | 29179 | 558 | 4 |
1600542 | 1600542 | 2021-08-09 | Ripley | Missouri | 29181 | 1261 | 17 |
1600543 | 1600543 | 2021-08-09 | Saline | Missouri | 29195 | 3198 | 40 |
1600544 | 1600544 | 2021-08-09 | Schuyler | Missouri | 29197 | 368 | 7 |
1600545 | 1600545 | 2021-08-09 | Scotland | Missouri | 29199 | 311 | 4 |
1600546 | 1600546 | 2021-08-09 | Scott | Missouri | 29201 | 5099 | 89 |
1600547 | 1600547 | 2021-08-09 | Shannon | Missouri | 29203 | 780 | 13 |
1600548 | 1600548 | 2021-08-09 | Shelby | Missouri | 29205 | 735 | 7 |
1600549 | 1600549 | 2021-08-09 | St. Charles | Missouri | 29183 | 52157 | 607 |
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);