ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 56 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
727277 | 727277 | 2020-11-13 | Mercer | Missouri | 29129 | 56 | 0 |
668920 | 668920 | 2020-10-26 | Putnam | Missouri | 29171 | 56 | 1 |
665676 | 665676 | 2020-10-25 | Putnam | Missouri | 29171 | 56 | 1 |
652630 | 652630 | 2020-10-21 | Chariton | Missouri | 29041 | 56 | 1 |
597519 | 597519 | 2020-10-04 | Knox | Missouri | 29103 | 56 | 1 |
590986 | 590986 | 2020-10-02 | Atchison | Missouri | 29005 | 56 | 0 |
584549 | 584549 | 2020-09-30 | Iron | Missouri | 29093 | 56 | 0 |
581308 | 581308 | 2020-09-29 | Iron | Missouri | 29093 | 56 | 0 |
578067 | 578067 | 2020-09-28 | Iron | Missouri | 29093 | 56 | 0 |
574826 | 574826 | 2020-09-27 | Iron | Missouri | 29093 | 56 | 0 |
565083 | 565083 | 2020-09-24 | Dade | Missouri | 29057 | 56 | 0 |
545724 | 545724 | 2020-09-18 | Shelby | Missouri | 29205 | 56 | 1 |
536014 | 536014 | 2020-09-15 | Shelby | Missouri | 29205 | 56 | 1 |
532779 | 532779 | 2020-09-14 | Shelby | Missouri | 29205 | 56 | 1 |
529457 | 529457 | 2020-09-13 | Caldwell | Missouri | 29025 | 56 | 1 |
529543 | 529543 | 2020-09-13 | Shelby | Missouri | 29205 | 56 | 1 |
526307 | 526307 | 2020-09-12 | Shelby | Missouri | 29205 | 56 | 1 |
523071 | 523071 | 2020-09-11 | Shelby | Missouri | 29205 | 56 | 1 |
513299 | 513299 | 2020-09-08 | Dent | Missouri | 29065 | 56 | 0 |
500406 | 500406 | 2020-09-04 | Montgomery | Missouri | 29139 | 56 | 1 |
500432 | 500432 | 2020-09-04 | Shannon | Missouri | 29203 | 56 | 1 |
490705 | 490705 | 2020-09-01 | Montgomery | Missouri | 29139 | 56 | 1 |
487472 | 487472 | 2020-08-31 | Montgomery | Missouri | 29139 | 56 | 1 |
484238 | 484238 | 2020-08-30 | Montgomery | Missouri | 29139 | 56 | 1 |
481003 | 481003 | 2020-08-29 | Montgomery | Missouri | 29139 | 56 | 1 |
477757 | 477757 | 2020-08-28 | Lewis | Missouri | 29111 | 56 | 2 |
468075 | 468075 | 2020-08-25 | Monroe | Missouri | 29137 | 56 | 0 |
451868 | 451868 | 2020-08-20 | Bates | Missouri | 29013 | 56 | 1 |
448640 | 448640 | 2020-08-19 | Bates | Missouri | 29013 | 56 | 1 |
426163 | 426163 | 2020-08-12 | Vernon | Missouri | 29217 | 56 | 0 |
416492 | 416492 | 2020-08-09 | Ste. Genevieve | Missouri | 29186 | 56 | 1 |
406789 | 406789 | 2020-08-06 | Macon | Missouri | 29121 | 56 | 0 |
397087 | 397087 | 2020-08-03 | Bollinger | Missouri | 29017 | 56 | 0 |
397191 | 397191 | 2020-08-03 | Washington | Missouri | 29221 | 56 | 1 |
393871 | 393871 | 2020-08-02 | Bollinger | Missouri | 29017 | 56 | 0 |
393890 | 393890 | 2020-08-02 | Crawford | Missouri | 29055 | 56 | 0 |
393975 | 393975 | 2020-08-02 | Washington | Missouri | 29221 | 56 | 1 |
390654 | 390654 | 2020-08-01 | Bollinger | Missouri | 29017 | 56 | 0 |
387437 | 387437 | 2020-07-31 | Bollinger | Missouri | 29017 | 56 | 0 |
387545 | 387545 | 2020-07-31 | Wright | Missouri | 29229 | 56 | 0 |
381028 | 381028 | 2020-07-29 | Douglas | Missouri | 29067 | 56 | 2 |
374646 | 374646 | 2020-07-27 | Pike | Missouri | 29163 | 56 | 1 |
364999 | 364999 | 2020-07-24 | Miller | Missouri | 29131 | 56 | 0 |
339363 | 339363 | 2020-07-16 | Howell | Missouri | 29091 | 56 | 0 |
307508 | 307508 | 2020-07-06 | Andrew | Missouri | 29003 | 56 | 0 |
301189 | 301189 | 2020-07-04 | Callaway | Missouri | 29027 | 56 | 1 |
282362 | 282362 | 2020-06-28 | Taney | Missouri | 29213 | 56 | 2 |
272853 | 272853 | 2020-06-25 | Gentry | Missouri | 29075 | 56 | 9 |
266582 | 266582 | 2020-06-23 | Gentry | Missouri | 29075 | 56 | 9 |
229238 | 229238 | 2020-06-11 | Newton | Missouri | 29145 | 56 | 1 |
189154 | 189154 | 2020-05-29 | Mississippi | Missouri | 29133 | 56 | 0 |
173849 | 173849 | 2020-05-24 | Audrain | Missouri | 29007 | 56 | 0 |
164744 | 164744 | 2020-05-21 | Cape Girardeau | Missouri | 29031 | 56 | 2 |
155681 | 155681 | 2020-05-18 | Cole | Missouri | 29051 | 56 | 1 |
131681 | 131681 | 2020-05-10 | Cole | Missouri | 29051 | 56 | 1 |
122767 | 122767 | 2020-05-07 | Pettis | Missouri | 29159 | 56 | 0 |
68740 | 68740 | 2020-04-18 | Clay | Missouri | 29047 | 56 | 1 |
41937 | 41937 | 2020-04-08 | Franklin | Missouri | 29071 | 56 | 3 |
20723 | 20723 | 2020-03-30 | Jackson | Missouri | 29095 | 56 | 1 |
20752 | 20752 | 2020-03-30 | St. Charles | Missouri | 29183 | 56 | 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);