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 193
- Greene 188
- Henry 187
- Cass 184
- Boone 183
- Cole 183
- Jackson 183
- St. Charles 182
- St. Louis city 182
- Christian 180
- Dunklin 180
- Kansas City 180
- Pulaski 180
- Scott 180
- Bates 179
- Jasper 179
- Johnson 179
- Adair 177
- Callaway 177
- Camden 177
- Clay 177
- Clinton 177
- Lafayette 177
- Moniteau 177
- Perry 177
- St. Francois 177
- Taney 177
- Cape Girardeau 176
- Franklin 176
- Jefferson 176
- …
state 1
- Missouri · 18,814 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535916 | 535916 | 2020-09-15 | Adair | Missouri | 29001 | 315 | 0 |
535917 | 535917 | 2020-09-15 | Andrew | Missouri | 29003 | 189 | 1 |
535918 | 535918 | 2020-09-15 | Atchison | Missouri | 29005 | 41 | 0 |
535919 | 535919 | 2020-09-15 | Audrain | Missouri | 29007 | 372 | 2 |
535920 | 535920 | 2020-09-15 | Barry | Missouri | 29009 | 411 | 5 |
535921 | 535921 | 2020-09-15 | Barton | Missouri | 29011 | 153 | 0 |
535922 | 535922 | 2020-09-15 | Bates | Missouri | 29013 | 84 | 1 |
535923 | 535923 | 2020-09-15 | Benton | Missouri | 29015 | 188 | 2 |
535924 | 535924 | 2020-09-15 | Bollinger | Missouri | 29017 | 263 | 1 |
535925 | 535925 | 2020-09-15 | Boone | Missouri | 29019 | 4182 | 7 |
535926 | 535926 | 2020-09-15 | Buchanan | Missouri | 29021 | 1800 | 19 |
535927 | 535927 | 2020-09-15 | Butler | Missouri | 29023 | 492 | 4 |
535928 | 535928 | 2020-09-15 | Caldwell | Missouri | 29025 | 60 | 1 |
535929 | 535929 | 2020-09-15 | Callaway | Missouri | 29027 | 532 | 2 |
535930 | 535930 | 2020-09-15 | Camden | Missouri | 29029 | 722 | 10 |
535931 | 535931 | 2020-09-15 | Cape Girardeau | Missouri | 29031 | 1389 | 15 |
535932 | 535932 | 2020-09-15 | Carroll | Missouri | 29033 | 128 | 1 |
535933 | 535933 | 2020-09-15 | Carter | Missouri | 29035 | 53 | 1 |
535934 | 535934 | 2020-09-15 | Cass | Missouri | 29037 | 1366 | 18 |
535935 | 535935 | 2020-09-15 | Cedar | Missouri | 29039 | 70 | 0 |
535936 | 535936 | 2020-09-15 | Chariton | Missouri | 29041 | 42 | 0 |
535937 | 535937 | 2020-09-15 | Christian | Missouri | 29043 | 1169 | 4 |
535938 | 535938 | 2020-09-15 | Clark | Missouri | 29045 | 55 | 0 |
535939 | 535939 | 2020-09-15 | Clay | Missouri | 29047 | 1642 | 39 |
535940 | 535940 | 2020-09-15 | Clinton | Missouri | 29049 | 185 | 0 |
535941 | 535941 | 2020-09-15 | Cole | Missouri | 29051 | 1233 | 12 |
535942 | 535942 | 2020-09-15 | Cooper | Missouri | 29053 | 350 | 2 |
535943 | 535943 | 2020-09-15 | Crawford | Missouri | 29055 | 294 | 2 |
535944 | 535944 | 2020-09-15 | Dade | Missouri | 29057 | 44 | 0 |
535945 | 535945 | 2020-09-15 | Dallas | Missouri | 29059 | 154 | 1 |
535946 | 535946 | 2020-09-15 | Daviess | Missouri | 29061 | 69 | 0 |
535947 | 535947 | 2020-09-15 | DeKalb | Missouri | 29063 | 101 | 2 |
535948 | 535948 | 2020-09-15 | Dent | Missouri | 29065 | 94 | 0 |
535949 | 535949 | 2020-09-15 | Douglas | Missouri | 29067 | 139 | 3 |
535950 | 535950 | 2020-09-15 | Dunklin | Missouri | 29069 | 647 | 6 |
535951 | 535951 | 2020-09-15 | Franklin | Missouri | 29071 | 1376 | 23 |
535952 | 535952 | 2020-09-15 | Gasconade | Missouri | 29073 | 140 | 6 |
535953 | 535953 | 2020-09-15 | Gentry | Missouri | 29075 | 109 | 9 |
535954 | 535954 | 2020-09-15 | Greene | Missouri | 29077 | 5034 | 46 |
535955 | 535955 | 2020-09-15 | Grundy | Missouri | 29079 | 141 | 2 |
535956 | 535956 | 2020-09-15 | Harrison | Missouri | 29081 | 97 | 1 |
535957 | 535957 | 2020-09-15 | Henry | Missouri | 29083 | 149 | 4 |
535958 | 535958 | 2020-09-15 | Hickory | Missouri | 29085 | 74 | 2 |
535959 | 535959 | 2020-09-15 | Holt | Missouri | 29087 | 72 | 0 |
535960 | 535960 | 2020-09-15 | Howard | Missouri | 29089 | 151 | 2 |
535961 | 535961 | 2020-09-15 | Howell | Missouri | 29091 | 431 | 3 |
535962 | 535962 | 2020-09-15 | Iron | Missouri | 29093 | 43 | 0 |
535963 | 535963 | 2020-09-15 | Jackson | Missouri | 29095 | 6609 | 88 |
535964 | 535964 | 2020-09-15 | Jasper | Missouri | 29097 | 2035 | 20 |
535965 | 535965 | 2020-09-15 | Jefferson | Missouri | 29099 | 3579 | 52 |
535966 | 535966 | 2020-09-15 | Johnson | Missouri | 29101 | 905 | 4 |
535967 | 535967 | 2020-09-15 | Joplin | Missouri | 1159 | 22 | |
535968 | 535968 | 2020-09-15 | Kansas City | Missouri | 10404 | 103 | |
535969 | 535969 | 2020-09-15 | Knox | Missouri | 29103 | 46 | 0 |
535970 | 535970 | 2020-09-15 | Laclede | Missouri | 29105 | 437 | 2 |
535971 | 535971 | 2020-09-15 | Lafayette | Missouri | 29107 | 350 | 2 |
535972 | 535972 | 2020-09-15 | Lawrence | Missouri | 29109 | 454 | 2 |
535973 | 535973 | 2020-09-15 | Lewis | Missouri | 29111 | 69 | 2 |
535974 | 535974 | 2020-09-15 | Lincoln | Missouri | 29113 | 682 | 2 |
535975 | 535975 | 2020-09-15 | Linn | Missouri | 29115 | 52 | 1 |
535976 | 535976 | 2020-09-15 | Livingston | Missouri | 29117 | 360 | 1 |
535977 | 535977 | 2020-09-15 | Macon | Missouri | 29121 | 109 | 0 |
535978 | 535978 | 2020-09-15 | Madison | Missouri | 29123 | 247 | 0 |
535979 | 535979 | 2020-09-15 | Maries | Missouri | 29125 | 62 | 0 |
535980 | 535980 | 2020-09-15 | Marion | Missouri | 29127 | 610 | 7 |
535981 | 535981 | 2020-09-15 | McDonald | Missouri | 29119 | 1079 | 11 |
535982 | 535982 | 2020-09-15 | Mercer | Missouri | 29129 | 28 | 0 |
535983 | 535983 | 2020-09-15 | Miller | Missouri | 29131 | 375 | 1 |
535984 | 535984 | 2020-09-15 | Mississippi | Missouri | 29133 | 270 | 3 |
535985 | 535985 | 2020-09-15 | Moniteau | Missouri | 29135 | 251 | 4 |
535986 | 535986 | 2020-09-15 | Monroe | Missouri | 29137 | 82 | 0 |
535987 | 535987 | 2020-09-15 | Montgomery | Missouri | 29139 | 68 | 1 |
535988 | 535988 | 2020-09-15 | Morgan | Missouri | 29141 | 220 | 1 |
535989 | 535989 | 2020-09-15 | New Madrid | Missouri | 29143 | 489 | 12 |
535990 | 535990 | 2020-09-15 | Newton | Missouri | 29145 | 1229 | 14 |
535991 | 535991 | 2020-09-15 | Nodaway | Missouri | 29147 | 578 | 1 |
535992 | 535992 | 2020-09-15 | Oregon | Missouri | 29149 | 82 | 0 |
535993 | 535993 | 2020-09-15 | Osage | Missouri | 29151 | 115 | 1 |
535994 | 535994 | 2020-09-15 | Ozark | Missouri | 29153 | 92 | 0 |
535995 | 535995 | 2020-09-15 | Pemiscot | Missouri | 29155 | 434 | 9 |
535996 | 535996 | 2020-09-15 | Perry | Missouri | 29157 | 533 | 4 |
535997 | 535997 | 2020-09-15 | Pettis | Missouri | 29159 | 919 | 10 |
535998 | 535998 | 2020-09-15 | Phelps | Missouri | 29161 | 353 | 1 |
535999 | 535999 | 2020-09-15 | Pike | Missouri | 29163 | 209 | 2 |
536000 | 536000 | 2020-09-15 | Platte | Missouri | 29165 | 605 | 11 |
536001 | 536001 | 2020-09-15 | Polk | Missouri | 29167 | 519 | 4 |
536002 | 536002 | 2020-09-15 | Pulaski | Missouri | 29169 | 489 | 4 |
536003 | 536003 | 2020-09-15 | Putnam | Missouri | 29171 | 30 | 1 |
536004 | 536004 | 2020-09-15 | Ralls | Missouri | 29173 | 137 | 0 |
536005 | 536005 | 2020-09-15 | Randolph | Missouri | 29175 | 187 | 2 |
536006 | 536006 | 2020-09-15 | Ray | Missouri | 29177 | 146 | 0 |
536007 | 536007 | 2020-09-15 | Reynolds | Missouri | 29179 | 27 | 0 |
536008 | 536008 | 2020-09-15 | Ripley | Missouri | 29181 | 137 | 0 |
536009 | 536009 | 2020-09-15 | Saline | Missouri | 29195 | 624 | 9 |
536010 | 536010 | 2020-09-15 | Schuyler | Missouri | 29197 | 22 | 0 |
536011 | 536011 | 2020-09-15 | Scotland | Missouri | 29199 | 24 | 1 |
536012 | 536012 | 2020-09-15 | Scott | Missouri | 29201 | 756 | 15 |
536013 | 536013 | 2020-09-15 | Shannon | Missouri | 29203 | 69 | 1 |
536014 | 536014 | 2020-09-15 | Shelby | Missouri | 29205 | 56 | 1 |
536015 | 536015 | 2020-09-15 | St. Charles | Missouri | 29183 | 6924 | 123 |
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);