ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where date = "2020-11-21" 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 |
---|---|---|---|---|---|---|---|
753175 | 753175 | 2020-11-21 | Adair | Missouri | 29001 | 1062 | 2 |
753176 | 753176 | 2020-11-21 | Andrew | Missouri | 29003 | 702 | 8 |
753177 | 753177 | 2020-11-21 | Atchison | Missouri | 29005 | 184 | 1 |
753178 | 753178 | 2020-11-21 | Audrain | Missouri | 29007 | 1268 | 11 |
753179 | 753179 | 2020-11-21 | Barry | Missouri | 29009 | 1351 | 22 |
753180 | 753180 | 2020-11-21 | Barton | Missouri | 29011 | 595 | 4 |
753181 | 753181 | 2020-11-21 | Bates | Missouri | 29013 | 460 | 8 |
753182 | 753182 | 2020-11-21 | Benton | Missouri | 29015 | 722 | 8 |
753183 | 753183 | 2020-11-21 | Bollinger | Missouri | 29017 | 760 | 7 |
753184 | 753184 | 2020-11-21 | Boone | Missouri | 29019 | 9516 | 23 |
753185 | 753185 | 2020-11-21 | Buchanan | Missouri | 29021 | 5454 | 65 |
753186 | 753186 | 2020-11-21 | Butler | Missouri | 29023 | 1934 | 8 |
753187 | 753187 | 2020-11-21 | Caldwell | Missouri | 29025 | 344 | 1 |
753188 | 753188 | 2020-11-21 | Callaway | Missouri | 29027 | 2520 | 7 |
753189 | 753189 | 2020-11-21 | Camden | Missouri | 29029 | 2281 | 44 |
753190 | 753190 | 2020-11-21 | Cape Girardeau | Missouri | 29031 | 5111 | 63 |
753191 | 753191 | 2020-11-21 | Carroll | Missouri | 29033 | 368 | 5 |
753192 | 753192 | 2020-11-21 | Carter | Missouri | 29035 | 272 | 4 |
753193 | 753193 | 2020-11-21 | Cass | Missouri | 29037 | 3338 | 36 |
753194 | 753194 | 2020-11-21 | Cedar | Missouri | 29039 | 418 | 4 |
753195 | 753195 | 2020-11-21 | Chariton | Missouri | 29041 | 217 | 0 |
753196 | 753196 | 2020-11-21 | Christian | Missouri | 29043 | 3725 | 22 |
753197 | 753197 | 2020-11-21 | Clark | Missouri | 29045 | 269 | 2 |
753198 | 753198 | 2020-11-21 | Clay | Missouri | 29047 | 4213 | 66 |
753199 | 753199 | 2020-11-21 | Clinton | Missouri | 29049 | 814 | 42 |
753200 | 753200 | 2020-11-21 | Cole | Missouri | 29051 | 5523 | 38 |
753201 | 753201 | 2020-11-21 | Cooper | Missouri | 29053 | 1082 | 6 |
753202 | 753202 | 2020-11-21 | Crawford | Missouri | 29055 | 1077 | 11 |
753203 | 753203 | 2020-11-21 | Dade | Missouri | 29057 | 391 | 26 |
753204 | 753204 | 2020-11-21 | Dallas | Missouri | 29059 | 559 | 5 |
753205 | 753205 | 2020-11-21 | Daviess | Missouri | 29061 | 306 | 7 |
753206 | 753206 | 2020-11-21 | DeKalb | Missouri | 29063 | 505 | 9 |
753207 | 753207 | 2020-11-21 | Dent | Missouri | 29065 | 442 | 4 |
753208 | 753208 | 2020-11-21 | Douglas | Missouri | 29067 | 381 | 15 |
753209 | 753209 | 2020-11-21 | Dunklin | Missouri | 29069 | 1578 | 13 |
753210 | 753210 | 2020-11-21 | Franklin | Missouri | 29071 | 4330 | 59 |
753211 | 753211 | 2020-11-21 | Gasconade | Missouri | 29073 | 405 | 24 |
753212 | 753212 | 2020-11-21 | Gentry | Missouri | 29075 | 369 | 11 |
753213 | 753213 | 2020-11-21 | Greene | Missouri | 29077 | 13519 | 188 |
753214 | 753214 | 2020-11-21 | Grundy | Missouri | 29079 | 468 | 13 |
753215 | 753215 | 2020-11-21 | Harrison | Missouri | 29081 | 357 | 1 |
753216 | 753216 | 2020-11-21 | Henry | Missouri | 29083 | 964 | 9 |
753217 | 753217 | 2020-11-21 | Hickory | Missouri | 29085 | 344 | 4 |
753218 | 753218 | 2020-11-21 | Holt | Missouri | 29087 | 232 | 2 |
753219 | 753219 | 2020-11-21 | Howard | Missouri | 29089 | 437 | 2 |
753220 | 753220 | 2020-11-21 | Howell | Missouri | 29091 | 1505 | 26 |
753221 | 753221 | 2020-11-21 | Iron | Missouri | 29093 | 206 | 0 |
753222 | 753222 | 2020-11-21 | Jackson | Missouri | 29095 | 15478 | 171 |
753223 | 753223 | 2020-11-21 | Jasper | Missouri | 29097 | 4660 | 59 |
753224 | 753224 | 2020-11-21 | Jefferson | Missouri | 29099 | 10186 | 96 |
753225 | 753225 | 2020-11-21 | Johnson | Missouri | 29101 | 2301 | 12 |
753226 | 753226 | 2020-11-21 | Joplin | Missouri | 3039 | 45 | |
753227 | 753227 | 2020-11-21 | Kansas City | Missouri | 21042 | 255 | |
753228 | 753228 | 2020-11-21 | Knox | Missouri | 29103 | 124 | 1 |
753229 | 753229 | 2020-11-21 | Laclede | Missouri | 29105 | 1659 | 29 |
753230 | 753230 | 2020-11-21 | Lafayette | Missouri | 29107 | 1355 | 29 |
753231 | 753231 | 2020-11-21 | Lawrence | Missouri | 29109 | 1772 | 33 |
753232 | 753232 | 2020-11-21 | Lewis | Missouri | 29111 | 410 | 2 |
753233 | 753233 | 2020-11-21 | Lincoln | Missouri | 29113 | 2114 | 8 |
753234 | 753234 | 2020-11-21 | Linn | Missouri | 29115 | 283 | 10 |
753235 | 753235 | 2020-11-21 | Livingston | Missouri | 29117 | 730 | 11 |
753236 | 753236 | 2020-11-21 | Macon | Missouri | 29121 | 565 | 2 |
753237 | 753237 | 2020-11-21 | Madison | Missouri | 29123 | 773 | 7 |
753238 | 753238 | 2020-11-21 | Maries | Missouri | 29125 | 330 | 2 |
753239 | 753239 | 2020-11-21 | Marion | Missouri | 29127 | 1593 | 15 |
753240 | 753240 | 2020-11-21 | McDonald | Missouri | 29119 | 1524 | 17 |
753241 | 753241 | 2020-11-21 | Mercer | Missouri | 29129 | 76 | 0 |
753242 | 753242 | 2020-11-21 | Miller | Missouri | 29131 | 1390 | 23 |
753243 | 753243 | 2020-11-21 | Mississippi | Missouri | 29133 | 696 | 6 |
753244 | 753244 | 2020-11-21 | Moniteau | Missouri | 29135 | 1120 | 15 |
753245 | 753245 | 2020-11-21 | Monroe | Missouri | 29137 | 339 | 3 |
753246 | 753246 | 2020-11-21 | Montgomery | Missouri | 29139 | 292 | 5 |
753247 | 753247 | 2020-11-21 | Morgan | Missouri | 29141 | 989 | 9 |
753248 | 753248 | 2020-11-21 | New Madrid | Missouri | 29143 | 1228 | 23 |
753249 | 753249 | 2020-11-21 | Newton | Missouri | 29145 | 2796 | 37 |
753250 | 753250 | 2020-11-21 | Nodaway | Missouri | 29147 | 1844 | 11 |
753251 | 753251 | 2020-11-21 | Oregon | Missouri | 29149 | 346 | 0 |
753252 | 753252 | 2020-11-21 | Osage | Missouri | 29151 | 848 | 3 |
753253 | 753253 | 2020-11-21 | Ozark | Missouri | 29153 | 274 | 2 |
753254 | 753254 | 2020-11-21 | Pemiscot | Missouri | 29155 | 1012 | 16 |
753255 | 753255 | 2020-11-21 | Perry | Missouri | 29157 | 1423 | 8 |
753256 | 753256 | 2020-11-21 | Pettis | Missouri | 29159 | 2997 | 30 |
753257 | 753257 | 2020-11-21 | Phelps | Missouri | 29161 | 1508 | 38 |
753258 | 753258 | 2020-11-21 | Pike | Missouri | 29163 | 797 | 8 |
753259 | 753259 | 2020-11-21 | Platte | Missouri | 29165 | 1534 | 16 |
753260 | 753260 | 2020-11-21 | Polk | Missouri | 29167 | 1622 | 22 |
753261 | 753261 | 2020-11-21 | Pulaski | Missouri | 29169 | 1447 | 15 |
753262 | 753262 | 2020-11-21 | Putnam | Missouri | 29171 | 110 | 1 |
753263 | 753263 | 2020-11-21 | Ralls | Missouri | 29173 | 400 | 1 |
753264 | 753264 | 2020-11-21 | Randolph | Missouri | 29175 | 1106 | 5 |
753265 | 753265 | 2020-11-21 | Ray | Missouri | 29177 | 607 | 4 |
753266 | 753266 | 2020-11-21 | Reynolds | Missouri | 29179 | 260 | 2 |
753267 | 753267 | 2020-11-21 | Ripley | Missouri | 29181 | 453 | 5 |
753268 | 753268 | 2020-11-21 | Saline | Missouri | 29195 | 1464 | 12 |
753269 | 753269 | 2020-11-21 | Schuyler | Missouri | 29197 | 119 | 0 |
753270 | 753270 | 2020-11-21 | Scotland | Missouri | 29199 | 170 | 1 |
753271 | 753271 | 2020-11-21 | Scott | Missouri | 29201 | 2382 | 36 |
753272 | 753272 | 2020-11-21 | Shannon | Missouri | 29203 | 323 | 10 |
753273 | 753273 | 2020-11-21 | Shelby | Missouri | 29205 | 177 | 1 |
753274 | 753274 | 2020-11-21 | St. Charles | Missouri | 29183 | 19231 | 205 |
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);