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-31 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1671911 | 1671911 | 2021-08-31 | Adair | Missouri | 29001 | 3194 | 27 |
1671912 | 1671912 | 2021-08-31 | Andrew | Missouri | 29003 | 2485 | 23 |
1671913 | 1671913 | 2021-08-31 | Atchison | Missouri | 29005 | 565 | 6 |
1671914 | 1671914 | 2021-08-31 | Audrain | Missouri | 29007 | 3415 | 60 |
1671915 | 1671915 | 2021-08-31 | Barry | Missouri | 29009 | 3888 | 56 |
1671916 | 1671916 | 2021-08-31 | Barton | Missouri | 29011 | 1596 | 19 |
1671917 | 1671917 | 2021-08-31 | Bates | Missouri | 29013 | 1881 | 37 |
1671918 | 1671918 | 2021-08-31 | Benton | Missouri | 29015 | 2254 | 40 |
1671919 | 1671919 | 2021-08-31 | Bollinger | Missouri | 29017 | 1342 | 15 |
1671920 | 1671920 | 2021-08-31 | Boone | Missouri | 29019 | 22991 | 140 |
1671921 | 1671921 | 2021-08-31 | Buchanan | Missouri | 29021 | 14095 | 209 |
1671922 | 1671922 | 2021-08-31 | Butler | Missouri | 29023 | 5467 | 60 |
1671923 | 1671923 | 2021-08-31 | Caldwell | Missouri | 29025 | 1044 | 18 |
1671924 | 1671924 | 2021-08-31 | Callaway | Missouri | 29027 | 6661 | 59 |
1671925 | 1671925 | 2021-08-31 | Camden | Missouri | 29029 | 5642 | 114 |
1671926 | 1671926 | 2021-08-31 | Cape Girardeau | Missouri | 29031 | 11169 | 145 |
1671927 | 1671927 | 2021-08-31 | Carroll | Missouri | 29033 | 1253 | 25 |
1671928 | 1671928 | 2021-08-31 | Carter | Missouri | 29035 | 843 | 12 |
1671929 | 1671929 | 2021-08-31 | Cass | Missouri | 29037 | 12271 | 133 |
1671930 | 1671930 | 2021-08-31 | Cedar | Missouri | 29039 | 1565 | 25 |
1671931 | 1671931 | 2021-08-31 | Chariton | Missouri | 29041 | 928 | 8 |
1671932 | 1671932 | 2021-08-31 | Christian | Missouri | 29043 | 12567 | 142 |
1671933 | 1671933 | 2021-08-31 | Clark | Missouri | 29045 | 875 | 12 |
1671934 | 1671934 | 2021-08-31 | Clay | Missouri | 29047 | 12855 | 186 |
1671935 | 1671935 | 2021-08-31 | Clinton | Missouri | 29049 | 2475 | 71 |
1671936 | 1671936 | 2021-08-31 | Cole | Missouri | 29051 | 11978 | 154 |
1671937 | 1671937 | 2021-08-31 | Cooper | Missouri | 29053 | 2372 | 31 |
1671938 | 1671938 | 2021-08-31 | Crawford | Missouri | 29055 | 3190 | 45 |
1671939 | 1671939 | 2021-08-31 | Dade | Missouri | 29057 | 811 | 17 |
1671940 | 1671940 | 2021-08-31 | Dallas | Missouri | 29059 | 2093 | 38 |
1671941 | 1671941 | 2021-08-31 | Daviess | Missouri | 29061 | 908 | 12 |
1671942 | 1671942 | 2021-08-31 | DeKalb | Missouri | 29063 | 1330 | 33 |
1671943 | 1671943 | 2021-08-31 | Dent | Missouri | 29065 | 1616 | 28 |
1671944 | 1671944 | 2021-08-31 | Douglas | Missouri | 29067 | 1467 | 38 |
1671945 | 1671945 | 2021-08-31 | Dunklin | Missouri | 29069 | 3697 | 54 |
1671946 | 1671946 | 2021-08-31 | Franklin | Missouri | 29071 | 12448 | 194 |
1671947 | 1671947 | 2021-08-31 | Gasconade | Missouri | 29073 | 1920 | 47 |
1671948 | 1671948 | 2021-08-31 | Gentry | Missouri | 29075 | 1092 | 23 |
1671949 | 1671949 | 2021-08-31 | Greene | Missouri | 29077 | 41822 | 620 |
1671950 | 1671950 | 2021-08-31 | Grundy | Missouri | 29079 | 1393 | 41 |
1671951 | 1671951 | 2021-08-31 | Harrison | Missouri | 29081 | 1011 | 14 |
1671952 | 1671952 | 2021-08-31 | Henry | Missouri | 29083 | 2783 | 42 |
1671953 | 1671953 | 2021-08-31 | Hickory | Missouri | 29085 | 942 | 17 |
1671954 | 1671954 | 2021-08-31 | Holt | Missouri | 29087 | 566 | 15 |
1671955 | 1671955 | 2021-08-31 | Howard | Missouri | 29089 | 1259 | 10 |
1671956 | 1671956 | 2021-08-31 | Howell | Missouri | 29091 | 5179 | 64 |
1671957 | 1671957 | 2021-08-31 | Iron | Missouri | 29093 | 1117 | 10 |
1671958 | 1671958 | 2021-08-31 | Jackson | Missouri | 29095 | 49894 | 559 |
1671959 | 1671959 | 2021-08-31 | Jasper | Missouri | 29097 | 12747 | 164 |
1671960 | 1671960 | 2021-08-31 | Jefferson | Missouri | 29099 | 27581 | 278 |
1671961 | 1671961 | 2021-08-31 | Johnson | Missouri | 29101 | 6087 | 64 |
1671962 | 1671962 | 2021-08-31 | Joplin | Missouri | 8200 | 141 | |
1671963 | 1671963 | 2021-08-31 | Kansas City | Missouri | 56645 | 697 | |
1671964 | 1671964 | 2021-08-31 | Knox | Missouri | 29103 | 461 | 3 |
1671965 | 1671965 | 2021-08-31 | Laclede | Missouri | 29105 | 4913 | 114 |
1671966 | 1671966 | 2021-08-31 | Lafayette | Missouri | 29107 | 4098 | 62 |
1671967 | 1671967 | 2021-08-31 | Lawrence | Missouri | 29109 | 4809 | 97 |
1671968 | 1671968 | 2021-08-31 | Lewis | Missouri | 29111 | 1432 | 21 |
1671969 | 1671969 | 2021-08-31 | Lincoln | Missouri | 29113 | 7646 | 55 |
1671970 | 1671970 | 2021-08-31 | Linn | Missouri | 29115 | 1743 | 23 |
1671971 | 1671971 | 2021-08-31 | Livingston | Missouri | 29117 | 2426 | 58 |
1671972 | 1671972 | 2021-08-31 | Macon | Missouri | 29121 | 1940 | 19 |
1671973 | 1671973 | 2021-08-31 | Madison | Missouri | 29123 | 1971 | 17 |
1671974 | 1671974 | 2021-08-31 | Maries | Missouri | 29125 | 873 | 15 |
1671975 | 1671975 | 2021-08-31 | Marion | Missouri | 29127 | 4718 | 58 |
1671976 | 1671976 | 2021-08-31 | McDonald | Missouri | 29119 | 3616 | 50 |
1671977 | 1671977 | 2021-08-31 | Mercer | Missouri | 29129 | 372 | 2 |
1671978 | 1671978 | 2021-08-31 | Miller | Missouri | 29131 | 3555 | 68 |
1671979 | 1671979 | 2021-08-31 | Mississippi | Missouri | 29133 | 1796 | 31 |
1671980 | 1671980 | 2021-08-31 | Moniteau | Missouri | 29135 | 2344 | 36 |
1671981 | 1671981 | 2021-08-31 | Monroe | Missouri | 29137 | 1190 | 12 |
1671982 | 1671982 | 2021-08-31 | Montgomery | Missouri | 29139 | 1308 | 17 |
1671983 | 1671983 | 2021-08-31 | Morgan | Missouri | 29141 | 2348 | 52 |
1671984 | 1671984 | 2021-08-31 | New Madrid | Missouri | 29143 | 2642 | 49 |
1671985 | 1671985 | 2021-08-31 | Newton | Missouri | 29145 | 7281 | 108 |
1671986 | 1671986 | 2021-08-31 | Nodaway | Missouri | 29147 | 3087 | 31 |
1671987 | 1671987 | 2021-08-31 | Oregon | Missouri | 29149 | 1168 | 7 |
1671988 | 1671988 | 2021-08-31 | Osage | Missouri | 29151 | 1971 | 19 |
1671989 | 1671989 | 2021-08-31 | Ozark | Missouri | 29153 | 980 | 25 |
1671990 | 1671990 | 2021-08-31 | Pemiscot | Missouri | 29155 | 1849 | 39 |
1671991 | 1671991 | 2021-08-31 | Perry | Missouri | 29157 | 2605 | 32 |
1671992 | 1671992 | 2021-08-31 | Pettis | Missouri | 29159 | 6554 | 88 |
1671993 | 1671993 | 2021-08-31 | Phelps | Missouri | 29161 | 5554 | 164 |
1671994 | 1671994 | 2021-08-31 | Pike | Missouri | 29163 | 2256 | 31 |
1671995 | 1671995 | 2021-08-31 | Platte | Missouri | 29165 | 5304 | 54 |
1671996 | 1671996 | 2021-08-31 | Polk | Missouri | 29167 | 4795 | 52 |
1671997 | 1671997 | 2021-08-31 | Pulaski | Missouri | 29169 | 4622 | 64 |
1671998 | 1671998 | 2021-08-31 | Putnam | Missouri | 29171 | 545 | 6 |
1671999 | 1671999 | 2021-08-31 | Ralls | Missouri | 29173 | 1390 | 14 |
1672000 | 1672000 | 2021-08-31 | Randolph | Missouri | 29175 | 3225 | 34 |
1672001 | 1672001 | 2021-08-31 | Ray | Missouri | 29177 | 2517 | 39 |
1672002 | 1672002 | 2021-08-31 | Reynolds | Missouri | 29179 | 645 | 4 |
1672003 | 1672003 | 2021-08-31 | Ripley | Missouri | 29181 | 1401 | 19 |
1672004 | 1672004 | 2021-08-31 | Saline | Missouri | 29195 | 3469 | 42 |
1672005 | 1672005 | 2021-08-31 | Schuyler | Missouri | 29197 | 386 | 7 |
1672006 | 1672006 | 2021-08-31 | Scotland | Missouri | 29199 | 312 | 4 |
1672007 | 1672007 | 2021-08-31 | Scott | Missouri | 29201 | 5841 | 94 |
1672008 | 1672008 | 2021-08-31 | Shannon | Missouri | 29203 | 857 | 15 |
1672009 | 1672009 | 2021-08-31 | Shelby | Missouri | 29205 | 788 | 7 |
1672010 | 1672010 | 2021-08-31 | St. Charles | Missouri | 29183 | 55465 | 634 |
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);