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 596
- Greene 590
- Henry 589
- Cass 586
- Boone 585
- Cole 585
- Jackson 585
- St. Louis city 585
- St. Charles 584
- Christian 582
- Dunklin 582
- Kansas City 582
- Pulaski 582
- Scott 582
- Bates 581
- Jasper 581
- Johnson 581
- St. Francois 580
- Taney 580
- Adair 579
- Callaway 579
- Camden 579
- Clay 579
- Clinton 579
- Lafayette 579
- Moniteau 579
- Perry 579
- Cape Girardeau 578
- Franklin 578
- Jefferson 578
- …
state 1
- Missouri · 65,866 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1844205 | 1844205 | 2021-10-23 | St. Clair | Missouri | 29185 | 1251 | 14 |
1844206 | 1844206 | 2021-10-23 | St. Francois | Missouri | 29187 | 11930 | 164 |
1844207 | 1844207 | 2021-10-23 | St. Louis | Missouri | 29189 | 128895 | 2540 |
1844208 | 1844208 | 2021-10-23 | St. Louis city | Missouri | 29510 | 32350 | 602 |
1844209 | 1844209 | 2021-10-23 | Ste. Genevieve | Missouri | 29186 | 2392 | 29 |
1844210 | 1844210 | 2021-10-23 | Stoddard | Missouri | 29207 | 4373 | 69 |
1844211 | 1844211 | 2021-10-23 | Stone | Missouri | 29209 | 3951 | 84 |
1844212 | 1844212 | 2021-10-23 | Sullivan | Missouri | 29211 | 1208 | 14 |
1844213 | 1844213 | 2021-10-23 | Taney | Missouri | 29213 | 8976 | 151 |
1844214 | 1844214 | 2021-10-23 | Texas | Missouri | 29215 | 2953 | 42 |
1844215 | 1844215 | 2021-10-23 | Vernon | Missouri | 29217 | 3035 | 64 |
1844216 | 1844216 | 2021-10-23 | Warren | Missouri | 29219 | 4987 | 45 |
1844217 | 1844217 | 2021-10-23 | Washington | Missouri | 29221 | 3913 | 66 |
1844218 | 1844218 | 2021-10-23 | Wayne | Missouri | 29223 | 1585 | 18 |
1844219 | 1844219 | 2021-10-23 | Webster | Missouri | 29225 | 5712 | 90 |
1844220 | 1844220 | 2021-10-23 | Worth | Missouri | 29227 | 223 | 2 |
1844221 | 1844221 | 2021-10-23 | Wright | Missouri | 29229 | 2540 | 49 |
1840855 | 1840855 | 2021-10-22 | Adair | Missouri | 29001 | 3609 | 34 |
1840856 | 1840856 | 2021-10-22 | Andrew | Missouri | 29003 | 2749 | 24 |
1840857 | 1840857 | 2021-10-22 | Atchison | Missouri | 29005 | 669 | 7 |
1840858 | 1840858 | 2021-10-22 | Audrain | Missouri | 29007 | 3721 | 64 |
1840859 | 1840859 | 2021-10-22 | Barry | Missouri | 29009 | 4282 | 60 |
1840860 | 1840860 | 2021-10-22 | Barton | Missouri | 29011 | 1782 | 27 |
1840861 | 1840861 | 2021-10-22 | Bates | Missouri | 29013 | 2292 | 43 |
1840862 | 1840862 | 2021-10-22 | Benton | Missouri | 29015 | 2593 | 45 |
1840863 | 1840863 | 2021-10-22 | Bollinger | Missouri | 29017 | 1757 | 20 |
1840864 | 1840864 | 2021-10-22 | Boone | Missouri | 29019 | 25341 | 169 |
1840865 | 1840865 | 2021-10-22 | Buchanan | Missouri | 29021 | 15135 | 222 |
1840866 | 1840866 | 2021-10-22 | Butler | Missouri | 29023 | 6679 | 71 |
1840867 | 1840867 | 2021-10-22 | Caldwell | Missouri | 29025 | 1126 | 20 |
1840868 | 1840868 | 2021-10-22 | Callaway | Missouri | 29027 | 7403 | 69 |
1840869 | 1840869 | 2021-10-22 | Camden | Missouri | 29029 | 6295 | 123 |
1840870 | 1840870 | 2021-10-22 | Cape Girardeau | Missouri | 29031 | 13041 | 153 |
1840871 | 1840871 | 2021-10-22 | Carroll | Missouri | 29033 | 1373 | 27 |
1840872 | 1840872 | 2021-10-22 | Carter | Missouri | 29035 | 1073 | 14 |
1840873 | 1840873 | 2021-10-22 | Cass | Missouri | 29037 | 14264 | 162 |
1840874 | 1840874 | 2021-10-22 | Cedar | Missouri | 29039 | 1670 | 30 |
1840875 | 1840875 | 2021-10-22 | Chariton | Missouri | 29041 | 1032 | 8 |
1840876 | 1840876 | 2021-10-22 | Christian | Missouri | 29043 | 12876 | 157 |
1840877 | 1840877 | 2021-10-22 | Clark | Missouri | 29045 | 981 | 12 |
1840878 | 1840878 | 2021-10-22 | Clay | Missouri | 29047 | 14847 | 215 |
1840879 | 1840879 | 2021-10-22 | Clinton | Missouri | 29049 | 2839 | 77 |
1840880 | 1840880 | 2021-10-22 | Cole | Missouri | 29051 | 12842 | 171 |
1840881 | 1840881 | 2021-10-22 | Cooper | Missouri | 29053 | 2737 | 33 |
1840882 | 1840882 | 2021-10-22 | Crawford | Missouri | 29055 | 3596 | 57 |
1840883 | 1840883 | 2021-10-22 | Dade | Missouri | 29057 | 865 | 17 |
1840884 | 1840884 | 2021-10-22 | Dallas | Missouri | 29059 | 2254 | 42 |
1840885 | 1840885 | 2021-10-22 | Daviess | Missouri | 29061 | 1023 | 14 |
1840886 | 1840886 | 2021-10-22 | DeKalb | Missouri | 29063 | 1465 | 33 |
1840887 | 1840887 | 2021-10-22 | Dent | Missouri | 29065 | 1923 | 41 |
1840888 | 1840888 | 2021-10-22 | Douglas | Missouri | 29067 | 1627 | 46 |
1840889 | 1840889 | 2021-10-22 | Dunklin | Missouri | 29069 | 4318 | 61 |
1840890 | 1840890 | 2021-10-22 | Franklin | Missouri | 29071 | 14361 | 219 |
1840891 | 1840891 | 2021-10-22 | Gasconade | Missouri | 29073 | 2174 | 50 |
1840892 | 1840892 | 2021-10-22 | Gentry | Missouri | 29075 | 1283 | 26 |
1840893 | 1840893 | 2021-10-22 | Greene | Missouri | 29077 | 44625 | 665 |
1840894 | 1840894 | 2021-10-22 | Grundy | Missouri | 29079 | 1573 | 47 |
1840895 | 1840895 | 2021-10-22 | Harrison | Missouri | 29081 | 1106 | 17 |
1840896 | 1840896 | 2021-10-22 | Henry | Missouri | 29083 | 3271 | 49 |
1840897 | 1840897 | 2021-10-22 | Hickory | Missouri | 29085 | 1087 | 21 |
1840898 | 1840898 | 2021-10-22 | Holt | Missouri | 29087 | 611 | 16 |
1840899 | 1840899 | 2021-10-22 | Howard | Missouri | 29089 | 1415 | 12 |
1840900 | 1840900 | 2021-10-22 | Howell | Missouri | 29091 | 5695 | 74 |
1840901 | 1840901 | 2021-10-22 | Iron | Missouri | 29093 | 1355 | 14 |
1840902 | 1840902 | 2021-10-22 | Jackson | Missouri | 29095 | 55516 | 683 |
1840903 | 1840903 | 2021-10-22 | Jasper | Missouri | 29097 | 13660 | 196 |
1840904 | 1840904 | 2021-10-22 | Jefferson | Missouri | 29099 | 32056 | 326 |
1840905 | 1840905 | 2021-10-22 | Johnson | Missouri | 29101 | 7145 | 73 |
1840906 | 1840906 | 2021-10-22 | Joplin | Missouri | 8681 | 150 | |
1840907 | 1840907 | 2021-10-22 | Kansas City | Missouri | 62985 | 817 | |
1840908 | 1840908 | 2021-10-22 | Knox | Missouri | 29103 | 512 | 3 |
1840909 | 1840909 | 2021-10-22 | Laclede | Missouri | 29105 | 5253 | 128 |
1840910 | 1840910 | 2021-10-22 | Lafayette | Missouri | 29107 | 4613 | 73 |
1840911 | 1840911 | 2021-10-22 | Lawrence | Missouri | 29109 | 5175 | 104 |
1840912 | 1840912 | 2021-10-22 | Lewis | Missouri | 29111 | 1668 | 22 |
1840913 | 1840913 | 2021-10-22 | Lincoln | Missouri | 29113 | 9216 | 68 |
1840914 | 1840914 | 2021-10-22 | Linn | Missouri | 29115 | 1834 | 26 |
1840915 | 1840915 | 2021-10-22 | Livingston | Missouri | 29117 | 2556 | 62 |
1840916 | 1840916 | 2021-10-22 | Macon | Missouri | 29121 | 2180 | 20 |
1840917 | 1840917 | 2021-10-22 | Madison | Missouri | 29123 | 2322 | 25 |
1840918 | 1840918 | 2021-10-22 | Maries | Missouri | 29125 | 981 | 19 |
1840919 | 1840919 | 2021-10-22 | Marion | Missouri | 29127 | 5146 | 63 |
1840920 | 1840920 | 2021-10-22 | McDonald | Missouri | 29119 | 4000 | 58 |
1840921 | 1840921 | 2021-10-22 | Mercer | Missouri | 29129 | 444 | 3 |
1840922 | 1840922 | 2021-10-22 | Miller | Missouri | 29131 | 3993 | 77 |
1840923 | 1840923 | 2021-10-22 | Mississippi | Missouri | 29133 | 2184 | 39 |
1840924 | 1840924 | 2021-10-22 | Moniteau | Missouri | 29135 | 2579 | 38 |
1840925 | 1840925 | 2021-10-22 | Monroe | Missouri | 29137 | 1318 | 13 |
1840926 | 1840926 | 2021-10-22 | Montgomery | Missouri | 29139 | 1525 | 19 |
1840927 | 1840927 | 2021-10-22 | Morgan | Missouri | 29141 | 2610 | 58 |
1840928 | 1840928 | 2021-10-22 | New Madrid | Missouri | 29143 | 3297 | 55 |
1840929 | 1840929 | 2021-10-22 | Newton | Missouri | 29145 | 7723 | 125 |
1840930 | 1840930 | 2021-10-22 | Nodaway | Missouri | 29147 | 3329 | 34 |
1840931 | 1840931 | 2021-10-22 | Oregon | Missouri | 29149 | 1330 | 11 |
1840932 | 1840932 | 2021-10-22 | Osage | Missouri | 29151 | 2125 | 23 |
1840933 | 1840933 | 2021-10-22 | Ozark | Missouri | 29153 | 1102 | 30 |
1840934 | 1840934 | 2021-10-22 | Pemiscot | Missouri | 29155 | 2046 | 43 |
1840935 | 1840935 | 2021-10-22 | Perry | Missouri | 29157 | 3099 | 33 |
1840936 | 1840936 | 2021-10-22 | Pettis | Missouri | 29159 | 7290 | 103 |
1840937 | 1840937 | 2021-10-22 | Phelps | Missouri | 29161 | 6170 | 182 |
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);