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 489
- Greene 484
- Henry 483
- Cass 480
- Boone 479
- Cole 479
- Jackson 479
- St. Charles 478
- St. Louis city 478
- Christian 476
- Dunklin 476
- Kansas City 476
- Pulaski 476
- Scott 476
- Bates 475
- Jasper 475
- Johnson 475
- Adair 473
- Callaway 473
- Camden 473
- Clay 473
- Clinton 473
- Lafayette 473
- Moniteau 473
- Perry 473
- St. Francois 473
- Taney 473
- Cape Girardeau 472
- Franklin 472
- Jefferson 472
- …
state 1
- Missouri · 53,447 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1496526 | 1496526 | 2021-07-08 | Adair | Missouri | 29001 | 2581 | 20 |
1496527 | 1496527 | 2021-07-08 | Andrew | Missouri | 29003 | 2033 | 21 |
1496528 | 1496528 | 2021-07-08 | Atchison | Missouri | 29005 | 463 | 6 |
1496529 | 1496529 | 2021-07-08 | Audrain | Missouri | 29007 | 2835 | 58 |
1496530 | 1496530 | 2021-07-08 | Barry | Missouri | 29009 | 3150 | 47 |
1496531 | 1496531 | 2021-07-08 | Barton | Missouri | 29011 | 1265 | 16 |
1496532 | 1496532 | 2021-07-08 | Bates | Missouri | 29013 | 1370 | 32 |
1496533 | 1496533 | 2021-07-08 | Benton | Missouri | 29015 | 1757 | 35 |
1496534 | 1496534 | 2021-07-08 | Bollinger | Missouri | 29017 | 1166 | 14 |
1496535 | 1496535 | 2021-07-08 | Boone | Missouri | 29019 | 19341 | 118 |
1496536 | 1496536 | 2021-07-08 | Buchanan | Missouri | 29021 | 11200 | 186 |
1496537 | 1496537 | 2021-07-08 | Butler | Missouri | 29023 | 4337 | 51 |
1496538 | 1496538 | 2021-07-08 | Caldwell | Missouri | 29025 | 887 | 15 |
1496539 | 1496539 | 2021-07-08 | Callaway | Missouri | 29027 | 5211 | 51 |
1496540 | 1496540 | 2021-07-08 | Camden | Missouri | 29029 | 4559 | 92 |
1496541 | 1496541 | 2021-07-08 | Cape Girardeau | Missouri | 29031 | 9616 | 139 |
1496542 | 1496542 | 2021-07-08 | Carroll | Missouri | 29033 | 1083 | 24 |
1496543 | 1496543 | 2021-07-08 | Carter | Missouri | 29035 | 553 | 11 |
1496544 | 1496544 | 2021-07-08 | Cass | Missouri | 29037 | 9699 | 117 |
1496545 | 1496545 | 2021-07-08 | Cedar | Missouri | 29039 | 1190 | 21 |
1496546 | 1496546 | 2021-07-08 | Chariton | Missouri | 29041 | 755 | 8 |
1496547 | 1496547 | 2021-07-08 | Christian | Missouri | 29043 | 9868 | 98 |
1496548 | 1496548 | 2021-07-08 | Clark | Missouri | 29045 | 719 | 8 |
1496549 | 1496549 | 2021-07-08 | Clay | Missouri | 29047 | 10607 | 175 |
1496550 | 1496550 | 2021-07-08 | Clinton | Missouri | 29049 | 2049 | 65 |
1496551 | 1496551 | 2021-07-08 | Cole | Missouri | 29051 | 9514 | 130 |
1496552 | 1496552 | 2021-07-08 | Cooper | Missouri | 29053 | 1970 | 27 |
1496553 | 1496553 | 2021-07-08 | Crawford | Missouri | 29055 | 2690 | 40 |
1496554 | 1496554 | 2021-07-08 | Dade | Missouri | 29057 | 652 | 31 |
1496555 | 1496555 | 2021-07-08 | Dallas | Missouri | 29059 | 1585 | 28 |
1496556 | 1496556 | 2021-07-08 | Daviess | Missouri | 29061 | 766 | 11 |
1496557 | 1496557 | 2021-07-08 | DeKalb | Missouri | 29063 | 1157 | 32 |
1496558 | 1496558 | 2021-07-08 | Dent | Missouri | 29065 | 1073 | 19 |
1496559 | 1496559 | 2021-07-08 | Douglas | Missouri | 29067 | 1060 | 30 |
1496560 | 1496560 | 2021-07-08 | Dunklin | Missouri | 29069 | 3129 | 50 |
1496561 | 1496561 | 2021-07-08 | Franklin | Missouri | 29071 | 10930 | 186 |
1496562 | 1496562 | 2021-07-08 | Gasconade | Missouri | 29073 | 1597 | 47 |
1496563 | 1496563 | 2021-07-08 | Gentry | Missouri | 29075 | 880 | 20 |
1496564 | 1496564 | 2021-07-08 | Greene | Missouri | 29077 | 33629 | 494 |
1496565 | 1496565 | 2021-07-08 | Grundy | Missouri | 29079 | 1147 | 36 |
1496566 | 1496566 | 2021-07-08 | Harrison | Missouri | 29081 | 909 | 14 |
1496567 | 1496567 | 2021-07-08 | Henry | Missouri | 29083 | 2106 | 40 |
1496568 | 1496568 | 2021-07-08 | Hickory | Missouri | 29085 | 732 | 15 |
1496569 | 1496569 | 2021-07-08 | Holt | Missouri | 29087 | 467 | 14 |
1496570 | 1496570 | 2021-07-08 | Howard | Missouri | 29089 | 1096 | 8 |
1496571 | 1496571 | 2021-07-08 | Howell | Missouri | 29091 | 3735 | 47 |
1496572 | 1496572 | 2021-07-08 | Iron | Missouri | 29093 | 928 | 7 |
1496573 | 1496573 | 2021-07-08 | Jackson | Missouri | 29095 | 40184 | 481 |
1496574 | 1496574 | 2021-07-08 | Jasper | Missouri | 29097 | 10438 | 136 |
1496575 | 1496575 | 2021-07-08 | Jefferson | Missouri | 29099 | 23960 | 255 |
1496576 | 1496576 | 2021-07-08 | Johnson | Missouri | 29101 | 4927 | 59 |
1496577 | 1496577 | 2021-07-08 | Joplin | Missouri | 6934 | 113 | |
1496578 | 1496578 | 2021-07-08 | Kansas City | Missouri | 45902 | 601 | |
1496579 | 1496579 | 2021-07-08 | Knox | Missouri | 29103 | 390 | 3 |
1496580 | 1496580 | 2021-07-08 | Laclede | Missouri | 29105 | 3802 | 75 |
1496581 | 1496581 | 2021-07-08 | Lafayette | Missouri | 29107 | 3253 | 57 |
1496582 | 1496582 | 2021-07-08 | Lawrence | Missouri | 29109 | 3840 | 89 |
1496583 | 1496583 | 2021-07-08 | Lewis | Missouri | 29111 | 1087 | 20 |
1496584 | 1496584 | 2021-07-08 | Lincoln | Missouri | 29113 | 6396 | 52 |
1496585 | 1496585 | 2021-07-08 | Linn | Missouri | 29115 | 1614 | 18 |
1496586 | 1496586 | 2021-07-08 | Livingston | Missouri | 29117 | 2178 | 47 |
1496587 | 1496587 | 2021-07-08 | Macon | Missouri | 29121 | 1664 | 18 |
1496588 | 1496588 | 2021-07-08 | Madison | Missouri | 29123 | 1696 | 16 |
1496589 | 1496589 | 2021-07-08 | Maries | Missouri | 29125 | 662 | 8 |
1496590 | 1496590 | 2021-07-08 | Marion | Missouri | 29127 | 3697 | 53 |
1496591 | 1496591 | 2021-07-08 | McDonald | Missouri | 29119 | 2924 | 38 |
1496592 | 1496592 | 2021-07-08 | Mercer | Missouri | 29129 | 313 | 2 |
1496593 | 1496593 | 2021-07-08 | Miller | Missouri | 29131 | 2765 | 57 |
1496594 | 1496594 | 2021-07-08 | Mississippi | Missouri | 29133 | 1511 | 28 |
1496595 | 1496595 | 2021-07-08 | Moniteau | Missouri | 29135 | 1865 | 33 |
1496596 | 1496596 | 2021-07-08 | Monroe | Missouri | 29137 | 1028 | 12 |
1496597 | 1496597 | 2021-07-08 | Montgomery | Missouri | 29139 | 1090 | 13 |
1496598 | 1496598 | 2021-07-08 | Morgan | Missouri | 29141 | 1862 | 44 |
1496599 | 1496599 | 2021-07-08 | New Madrid | Missouri | 29143 | 2161 | 47 |
1496600 | 1496600 | 2021-07-08 | Newton | Missouri | 29145 | 6026 | 80 |
1496601 | 1496601 | 2021-07-08 | Nodaway | Missouri | 29147 | 2773 | 25 |
1496602 | 1496602 | 2021-07-08 | Oregon | Missouri | 29149 | 860 | 5 |
1496603 | 1496603 | 2021-07-08 | Osage | Missouri | 29151 | 1668 | 16 |
1496604 | 1496604 | 2021-07-08 | Ozark | Missouri | 29153 | 690 | 21 |
1496605 | 1496605 | 2021-07-08 | Pemiscot | Missouri | 29155 | 1630 | 39 |
1496606 | 1496606 | 2021-07-08 | Perry | Missouri | 29157 | 2287 | 30 |
1496607 | 1496607 | 2021-07-08 | Pettis | Missouri | 29159 | 5302 | 77 |
1496608 | 1496608 | 2021-07-08 | Phelps | Missouri | 29161 | 4106 | 135 |
1496609 | 1496609 | 2021-07-08 | Pike | Missouri | 29163 | 1836 | 26 |
1496610 | 1496610 | 2021-07-08 | Platte | Missouri | 29165 | 4339 | 50 |
1496611 | 1496611 | 2021-07-08 | Polk | Missouri | 29167 | 3989 | 42 |
1496612 | 1496612 | 2021-07-08 | Pulaski | Missouri | 29169 | 3724 | 56 |
1496613 | 1496613 | 2021-07-08 | Putnam | Missouri | 29171 | 487 | 4 |
1496614 | 1496614 | 2021-07-08 | Ralls | Missouri | 29173 | 1086 | 13 |
1496615 | 1496615 | 2021-07-08 | Randolph | Missouri | 29175 | 2732 | 31 |
1496616 | 1496616 | 2021-07-08 | Ray | Missouri | 29177 | 2069 | 29 |
1496617 | 1496617 | 2021-07-08 | Reynolds | Missouri | 29179 | 497 | 4 |
1496618 | 1496618 | 2021-07-08 | Ripley | Missouri | 29181 | 1120 | 17 |
1496619 | 1496619 | 2021-07-08 | Saline | Missouri | 29195 | 2915 | 38 |
1496620 | 1496620 | 2021-07-08 | Schuyler | Missouri | 29197 | 347 | 7 |
1496621 | 1496621 | 2021-07-08 | Scotland | Missouri | 29199 | 306 | 4 |
1496622 | 1496622 | 2021-07-08 | Scott | Missouri | 29201 | 4761 | 88 |
1496623 | 1496623 | 2021-07-08 | Shannon | Missouri | 29203 | 625 | 12 |
1496624 | 1496624 | 2021-07-08 | Shelby | Missouri | 29205 | 695 | 7 |
1496625 | 1496625 | 2021-07-08 | St. Charles | Missouri | 29183 | 48588 | 589 |
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);