ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where "date" is on date 2020-05-29 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
189093 | 189093 | 2020-05-29 | Adair | Missouri | 29001 | 50 | 0 |
189094 | 189094 | 2020-05-29 | Andrew | Missouri | 29003 | 30 | 0 |
189095 | 189095 | 2020-05-29 | Atchison | Missouri | 29005 | 3 | 0 |
189096 | 189096 | 2020-05-29 | Audrain | Missouri | 29007 | 73 | 0 |
189097 | 189097 | 2020-05-29 | Barry | Missouri | 29009 | 9 | 0 |
189098 | 189098 | 2020-05-29 | Bates | Missouri | 29013 | 7 | 1 |
189099 | 189099 | 2020-05-29 | Benton | Missouri | 29015 | 10 | 0 |
189100 | 189100 | 2020-05-29 | Bollinger | Missouri | 29017 | 6 | 0 |
189101 | 189101 | 2020-05-29 | Boone | Missouri | 29019 | 144 | 1 |
189102 | 189102 | 2020-05-29 | Buchanan | Missouri | 29021 | 687 | 2 |
189103 | 189103 | 2020-05-29 | Butler | Missouri | 29023 | 32 | 0 |
189104 | 189104 | 2020-05-29 | Caldwell | Missouri | 29025 | 5 | 0 |
189105 | 189105 | 2020-05-29 | Callaway | Missouri | 29027 | 27 | 1 |
189106 | 189106 | 2020-05-29 | Camden | Missouri | 29029 | 37 | 1 |
189107 | 189107 | 2020-05-29 | Cape Girardeau | Missouri | 29031 | 73 | 2 |
189108 | 189108 | 2020-05-29 | Carroll | Missouri | 29033 | 8 | 0 |
189109 | 189109 | 2020-05-29 | Carter | Missouri | 29035 | 5 | 1 |
189110 | 189110 | 2020-05-29 | Cass | Missouri | 29037 | 86 | 8 |
189111 | 189111 | 2020-05-29 | Cedar | Missouri | 29039 | 9 | 0 |
189112 | 189112 | 2020-05-29 | Chariton | Missouri | 29041 | 6 | 0 |
189113 | 189113 | 2020-05-29 | Christian | Missouri | 29043 | 22 | 0 |
189114 | 189114 | 2020-05-29 | Clark | Missouri | 29045 | 1 | 0 |
189115 | 189115 | 2020-05-29 | Clay | Missouri | 29047 | 169 | 3 |
189116 | 189116 | 2020-05-29 | Clinton | Missouri | 29049 | 18 | 0 |
189117 | 189117 | 2020-05-29 | Cole | Missouri | 29051 | 60 | 1 |
189118 | 189118 | 2020-05-29 | Cooper | Missouri | 29053 | 9 | 0 |
189119 | 189119 | 2020-05-29 | Crawford | Missouri | 29055 | 8 | 0 |
189120 | 189120 | 2020-05-29 | Dallas | Missouri | 29059 | 3 | 0 |
189121 | 189121 | 2020-05-29 | Daviess | Missouri | 29061 | 4 | 0 |
189122 | 189122 | 2020-05-29 | DeKalb | Missouri | 29063 | 6 | 0 |
189123 | 189123 | 2020-05-29 | Dent | Missouri | 29065 | 1 | 0 |
189124 | 189124 | 2020-05-29 | Dunklin | Missouri | 29069 | 33 | 2 |
189125 | 189125 | 2020-05-29 | Franklin | Missouri | 29071 | 139 | 16 |
189126 | 189126 | 2020-05-29 | Gasconade | Missouri | 29073 | 2 | 0 |
189127 | 189127 | 2020-05-29 | Gentry | Missouri | 29075 | 26 | 1 |
189128 | 189128 | 2020-05-29 | Greene | Missouri | 29077 | 136 | 8 |
189129 | 189129 | 2020-05-29 | Grundy | Missouri | 29079 | 2 | 0 |
189130 | 189130 | 2020-05-29 | Harrison | Missouri | 29081 | 9 | 0 |
189131 | 189131 | 2020-05-29 | Henry | Missouri | 29083 | 11 | 3 |
189132 | 189132 | 2020-05-29 | Holt | Missouri | 29087 | 1 | 0 |
189133 | 189133 | 2020-05-29 | Howard | Missouri | 29089 | 3 | 0 |
189134 | 189134 | 2020-05-29 | Howell | Missouri | 29091 | 6 | 0 |
189135 | 189135 | 2020-05-29 | Iron | Missouri | 29093 | 2 | 0 |
189136 | 189136 | 2020-05-29 | Jackson | Missouri | 29095 | 560 | 17 |
189137 | 189137 | 2020-05-29 | Jasper | Missouri | 29097 | 32 | 0 |
189138 | 189138 | 2020-05-29 | Jefferson | Missouri | 29099 | 349 | 16 |
189139 | 189139 | 2020-05-29 | Johnson | Missouri | 29101 | 76 | 0 |
189140 | 189140 | 2020-05-29 | Kansas City | Missouri | 1117 | 26 | |
189141 | 189141 | 2020-05-29 | Laclede | Missouri | 29105 | 3 | 0 |
189142 | 189142 | 2020-05-29 | Lafayette | Missouri | 29107 | 73 | 2 |
189143 | 189143 | 2020-05-29 | Lawrence | Missouri | 29109 | 7 | 0 |
189144 | 189144 | 2020-05-29 | Lewis | Missouri | 29111 | 7 | 1 |
189145 | 189145 | 2020-05-29 | Lincoln | Missouri | 29113 | 81 | 1 |
189146 | 189146 | 2020-05-29 | Linn | Missouri | 29115 | 6 | 1 |
189147 | 189147 | 2020-05-29 | Livingston | Missouri | 29117 | 3 | 0 |
189148 | 189148 | 2020-05-29 | Macon | Missouri | 29121 | 4 | 0 |
189149 | 189149 | 2020-05-29 | Madison | Missouri | 29123 | 3 | 0 |
189150 | 189150 | 2020-05-29 | Maries | Missouri | 29125 | 2 | 0 |
189151 | 189151 | 2020-05-29 | Marion | Missouri | 29127 | 5 | 0 |
189152 | 189152 | 2020-05-29 | McDonald | Missouri | 29119 | 20 | 0 |
189153 | 189153 | 2020-05-29 | Miller | Missouri | 29131 | 4 | 0 |
189154 | 189154 | 2020-05-29 | Mississippi | Missouri | 29133 | 56 | 0 |
189155 | 189155 | 2020-05-29 | Moniteau | Missouri | 29135 | 46 | 1 |
189156 | 189156 | 2020-05-29 | Monroe | Missouri | 29137 | 2 | 0 |
189157 | 189157 | 2020-05-29 | Montgomery | Missouri | 29139 | 9 | 0 |
189158 | 189158 | 2020-05-29 | Morgan | Missouri | 29141 | 9 | 0 |
189159 | 189159 | 2020-05-29 | New Madrid | Missouri | 29143 | 20 | 1 |
189160 | 189160 | 2020-05-29 | Newton | Missouri | 29145 | 18 | 1 |
189161 | 189161 | 2020-05-29 | Nodaway | Missouri | 29147 | 9 | 0 |
189162 | 189162 | 2020-05-29 | Oregon | Missouri | 29149 | 2 | 0 |
189163 | 189163 | 2020-05-29 | Osage | Missouri | 29151 | 5 | 0 |
189164 | 189164 | 2020-05-29 | Pemiscot | Missouri | 29155 | 76 | 4 |
189165 | 189165 | 2020-05-29 | Perry | Missouri | 29157 | 55 | 0 |
189166 | 189166 | 2020-05-29 | Pettis | Missouri | 29159 | 77 | 1 |
189167 | 189167 | 2020-05-29 | Phelps | Missouri | 29161 | 4 | 0 |
189168 | 189168 | 2020-05-29 | Pike | Missouri | 29163 | 17 | 1 |
189169 | 189169 | 2020-05-29 | Platte | Missouri | 29165 | 70 | 3 |
189170 | 189170 | 2020-05-29 | Polk | Missouri | 29167 | 2 | 0 |
189171 | 189171 | 2020-05-29 | Pulaski | Missouri | 29169 | 36 | 1 |
189172 | 189172 | 2020-05-29 | Ralls | Missouri | 29173 | 3 | 0 |
189173 | 189173 | 2020-05-29 | Randolph | Missouri | 29175 | 9 | 0 |
189174 | 189174 | 2020-05-29 | Ray | Missouri | 29177 | 19 | 0 |
189175 | 189175 | 2020-05-29 | Reynolds | Missouri | 29179 | 2 | 0 |
189176 | 189176 | 2020-05-29 | Ripley | Missouri | 29181 | 7 | 0 |
189177 | 189177 | 2020-05-29 | Saline | Missouri | 29195 | 267 | 2 |
189178 | 189178 | 2020-05-29 | Schuyler | Missouri | 29197 | 1 | 0 |
189179 | 189179 | 2020-05-29 | Scotland | Missouri | 29199 | 4 | 0 |
189180 | 189180 | 2020-05-29 | Scott | Missouri | 29201 | 100 | 9 |
189181 | 189181 | 2020-05-29 | Shannon | Missouri | 29203 | 2 | 0 |
189182 | 189182 | 2020-05-29 | Shelby | Missouri | 29205 | 1 | 0 |
189183 | 189183 | 2020-05-29 | St. Charles | Missouri | 29183 | 768 | 57 |
189184 | 189184 | 2020-05-29 | St. Clair | Missouri | 29185 | 2 | 0 |
189185 | 189185 | 2020-05-29 | St. Francois | Missouri | 29187 | 34 | 2 |
189186 | 189186 | 2020-05-29 | St. Louis | Missouri | 29189 | 4730 | 415 |
189187 | 189187 | 2020-05-29 | St. Louis city | Missouri | 29510 | 1916 | 118 |
189188 | 189188 | 2020-05-29 | Ste. Genevieve | Missouri | 29186 | 11 | 1 |
189189 | 189189 | 2020-05-29 | Stoddard | Missouri | 29207 | 78 | 5 |
189190 | 189190 | 2020-05-29 | Stone | Missouri | 29209 | 4 | 0 |
189191 | 189191 | 2020-05-29 | Sullivan | Missouri | 29211 | 55 | 0 |
189192 | 189192 | 2020-05-29 | Taney | Missouri | 29213 | 13 | 2 |
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);