ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where cases = 19 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 |
---|---|---|---|---|---|---|---|
558693 | 558693 | 2020-09-22 | Worth | Missouri | 29227 | 19 | 0 |
555456 | 555456 | 2020-09-21 | Worth | Missouri | 29227 | 19 | 0 |
552218 | 552218 | 2020-09-20 | Worth | Missouri | 29227 | 19 | 0 |
548979 | 548979 | 2020-09-19 | Worth | Missouri | 29227 | 19 | 0 |
497195 | 497195 | 2020-09-03 | Schuyler | Missouri | 29197 | 19 | 0 |
474558 | 474558 | 2020-08-27 | Reynolds | Missouri | 29179 | 19 | 0 |
471326 | 471326 | 2020-08-26 | Reynolds | Missouri | 29179 | 19 | 0 |
468035 | 468035 | 2020-08-25 | Daviess | Missouri | 29061 | 19 | 0 |
468092 | 468092 | 2020-08-25 | Putnam | Missouri | 29171 | 19 | 1 |
468096 | 468096 | 2020-08-25 | Reynolds | Missouri | 29179 | 19 | 0 |
464806 | 464806 | 2020-08-24 | Daviess | Missouri | 29061 | 19 | 0 |
464863 | 464863 | 2020-08-24 | Putnam | Missouri | 29171 | 19 | 1 |
464867 | 464867 | 2020-08-24 | Reynolds | Missouri | 29179 | 19 | 0 |
461575 | 461575 | 2020-08-23 | Daviess | Missouri | 29061 | 19 | 0 |
458348 | 458348 | 2020-08-22 | Daviess | Missouri | 29061 | 19 | 0 |
451890 | 451890 | 2020-08-20 | Dade | Missouri | 29057 | 19 | 0 |
448636 | 448636 | 2020-08-19 | Atchison | Missouri | 29005 | 19 | 0 |
448662 | 448662 | 2020-08-19 | Dade | Missouri | 29057 | 19 | 0 |
448664 | 448664 | 2020-08-19 | Daviess | Missouri | 29061 | 19 | 0 |
445438 | 445438 | 2020-08-18 | Daviess | Missouri | 29061 | 19 | 0 |
445503 | 445503 | 2020-08-18 | Scotland | Missouri | 29199 | 19 | 1 |
442212 | 442212 | 2020-08-17 | Daviess | Missouri | 29061 | 19 | 0 |
442277 | 442277 | 2020-08-17 | Scotland | Missouri | 29199 | 19 | 1 |
438985 | 438985 | 2020-08-16 | Daviess | Missouri | 29061 | 19 | 0 |
439050 | 439050 | 2020-08-16 | Scotland | Missouri | 29199 | 19 | 1 |
435760 | 435760 | 2020-08-15 | Daviess | Missouri | 29061 | 19 | 0 |
432506 | 432506 | 2020-08-14 | Atchison | Missouri | 29005 | 19 | 0 |
432534 | 432534 | 2020-08-14 | Daviess | Missouri | 29061 | 19 | 0 |
429279 | 429279 | 2020-08-13 | Atchison | Missouri | 29005 | 19 | 0 |
429353 | 429353 | 2020-08-13 | Oregon | Missouri | 29149 | 19 | 0 |
426073 | 426073 | 2020-08-12 | Chariton | Missouri | 29041 | 19 | 0 |
422833 | 422833 | 2020-08-11 | Atchison | Missouri | 29005 | 19 | 0 |
416488 | 416488 | 2020-08-09 | St. Clair | Missouri | 29185 | 19 | 0 |
403610 | 403610 | 2020-08-05 | St. Clair | Missouri | 29185 | 19 | 0 |
400346 | 400346 | 2020-08-04 | Knox | Missouri | 29103 | 19 | 0 |
400393 | 400393 | 2020-08-04 | St. Clair | Missouri | 29185 | 19 | 0 |
397096 | 397096 | 2020-08-03 | Carter | Missouri | 29035 | 19 | 1 |
397132 | 397132 | 2020-08-03 | Knox | Missouri | 29103 | 19 | 0 |
390663 | 390663 | 2020-08-01 | Carter | Missouri | 29035 | 19 | 1 |
387465 | 387465 | 2020-07-31 | Gasconade | Missouri | 29073 | 19 | 0 |
384247 | 384247 | 2020-07-30 | Gasconade | Missouri | 29073 | 19 | 0 |
352121 | 352121 | 2020-07-20 | Bates | Missouri | 29013 | 19 | 1 |
352151 | 352151 | 2020-07-20 | Gasconade | Missouri | 29073 | 19 | 0 |
348927 | 348927 | 2020-07-19 | Caldwell | Missouri | 29025 | 19 | 1 |
345726 | 345726 | 2020-07-18 | Caldwell | Missouri | 29025 | 19 | 1 |
339349 | 339349 | 2020-07-16 | DeKalb | Missouri | 29063 | 19 | 0 |
336153 | 336153 | 2020-07-15 | DeKalb | Missouri | 29063 | 19 | 0 |
320279 | 320279 | 2020-07-10 | Polk | Missouri | 29167 | 19 | 0 |
317046 | 317046 | 2020-07-09 | Crawford | Missouri | 29055 | 19 | 0 |
317104 | 317104 | 2020-07-09 | Polk | Missouri | 29167 | 19 | 0 |
313872 | 313872 | 2020-07-08 | Crawford | Missouri | 29055 | 19 | 0 |
313904 | 313904 | 2020-07-08 | Linn | Missouri | 29115 | 19 | 1 |
310715 | 310715 | 2020-07-07 | Harrison | Missouri | 29081 | 19 | 0 |
310733 | 310733 | 2020-07-07 | Linn | Missouri | 29115 | 19 | 1 |
310766 | 310766 | 2020-07-07 | Ripley | Missouri | 29181 | 19 | 0 |
310780 | 310780 | 2020-07-07 | Stone | Missouri | 29209 | 19 | 0 |
307514 | 307514 | 2020-07-06 | Benton | Missouri | 29015 | 19 | 0 |
307523 | 307523 | 2020-07-06 | Carroll | Missouri | 29033 | 19 | 0 |
307573 | 307573 | 2020-07-06 | Miller | Missouri | 29131 | 19 | 0 |
307578 | 307578 | 2020-07-06 | Morgan | Missouri | 29141 | 19 | 0 |
307598 | 307598 | 2020-07-06 | Ripley | Missouri | 29181 | 19 | 0 |
307603 | 307603 | 2020-07-06 | Shannon | Missouri | 29203 | 19 | 0 |
304406 | 304406 | 2020-07-05 | Miller | Missouri | 29131 | 19 | 0 |
304411 | 304411 | 2020-07-05 | Morgan | Missouri | 29141 | 19 | 0 |
304431 | 304431 | 2020-07-05 | Ripley | Missouri | 29181 | 19 | 0 |
301242 | 301242 | 2020-07-04 | Miller | Missouri | 29131 | 19 | 0 |
301247 | 301247 | 2020-07-04 | Morgan | Missouri | 29141 | 19 | 0 |
301267 | 301267 | 2020-07-04 | Ripley | Missouri | 29181 | 19 | 0 |
298079 | 298079 | 2020-07-03 | Miller | Missouri | 29131 | 19 | 0 |
298104 | 298104 | 2020-07-03 | Ripley | Missouri | 29181 | 19 | 0 |
294946 | 294946 | 2020-07-02 | Ripley | Missouri | 29181 | 19 | 0 |
291740 | 291740 | 2020-07-01 | Grundy | Missouri | 29079 | 19 | 0 |
291764 | 291764 | 2020-07-01 | Marion | Missouri | 29127 | 19 | 0 |
291792 | 291792 | 2020-07-01 | Ripley | Missouri | 29181 | 19 | 0 |
288589 | 288589 | 2020-06-30 | Grundy | Missouri | 29079 | 19 | 0 |
288641 | 288641 | 2020-06-30 | Ripley | Missouri | 29181 | 19 | 0 |
285439 | 285439 | 2020-06-29 | Grundy | Missouri | 29079 | 19 | 0 |
285474 | 285474 | 2020-06-29 | Nodaway | Missouri | 29147 | 19 | 0 |
285491 | 285491 | 2020-06-29 | Ripley | Missouri | 29181 | 19 | 0 |
285503 | 285503 | 2020-06-29 | Ste. Genevieve | Missouri | 29186 | 19 | 1 |
282294 | 282294 | 2020-06-28 | Grundy | Missouri | 29079 | 19 | 0 |
282296 | 282296 | 2020-06-28 | Henry | Missouri | 29083 | 19 | 3 |
279148 | 279148 | 2020-06-27 | Henry | Missouri | 29083 | 19 | 3 |
276000 | 276000 | 2020-06-26 | Henry | Missouri | 29083 | 19 | 3 |
272857 | 272857 | 2020-06-25 | Henry | Missouri | 29083 | 19 | 3 |
272927 | 272927 | 2020-06-25 | Washington | Missouri | 29221 | 19 | 1 |
266597 | 266597 | 2020-06-23 | Laclede | Missouri | 29105 | 19 | 0 |
266599 | 266599 | 2020-06-23 | Lawrence | Missouri | 29109 | 19 | 0 |
251040 | 251040 | 2020-06-18 | Webster | Missouri | 29225 | 19 | 0 |
247927 | 247927 | 2020-06-17 | Webster | Missouri | 29225 | 19 | 0 |
232295 | 232295 | 2020-06-12 | Clinton | Missouri | 29049 | 19 | 0 |
232314 | 232314 | 2020-06-12 | Howell | Missouri | 29091 | 19 | 0 |
229191 | 229191 | 2020-06-11 | Clinton | Missouri | 29049 | 19 | 0 |
226088 | 226088 | 2020-06-10 | Clinton | Missouri | 29049 | 19 | 0 |
222990 | 222990 | 2020-06-09 | Clinton | Missouri | 29049 | 19 | 0 |
219895 | 219895 | 2020-06-08 | Clinton | Missouri | 29049 | 19 | 0 |
216803 | 216803 | 2020-06-07 | Clinton | Missouri | 29049 | 19 | 0 |
213715 | 213715 | 2020-06-06 | Clinton | Missouri | 29049 | 19 | 0 |
210631 | 210631 | 2020-06-05 | Clinton | Missouri | 29049 | 19 | 0 |
201452 | 201452 | 2020-06-02 | Ray | Missouri | 29177 | 19 | 0 |
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);