ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 87 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
782451 | 782451 | 2020-11-30 | Mercer | Missouri | 29129 | 87 | 1 |
636427 | 636427 | 2020-10-16 | Iron | Missouri | 29093 | 87 | 0 |
594296 | 594296 | 2020-10-03 | Montgomery | Missouri | 29139 | 87 | 1 |
591055 | 591055 | 2020-10-02 | Montgomery | Missouri | 29139 | 87 | 1 |
587806 | 587806 | 2020-10-01 | Maries | Missouri | 29125 | 87 | 0 |
587813 | 587813 | 2020-10-01 | Monroe | Missouri | 29137 | 87 | 1 |
587814 | 587814 | 2020-10-01 | Montgomery | Missouri | 29139 | 87 | 1 |
584562 | 584562 | 2020-09-30 | Linn | Missouri | 29115 | 87 | 1 |
568352 | 568352 | 2020-09-25 | Lewis | Missouri | 29111 | 87 | 2 |
565125 | 565125 | 2020-09-24 | Monroe | Missouri | 29137 | 87 | 0 |
561832 | 561832 | 2020-09-23 | Carter | Missouri | 29035 | 87 | 1 |
558675 | 558675 | 2020-09-22 | Shannon | Missouri | 29203 | 87 | 1 |
552122 | 552122 | 2020-09-20 | Cedar | Missouri | 29039 | 87 | 0 |
552145 | 552145 | 2020-09-20 | Hickory | Missouri | 29085 | 87 | 2 |
548883 | 548883 | 2020-09-19 | Cedar | Missouri | 29039 | 87 | 0 |
532713 | 532713 | 2020-09-14 | Dent | Missouri | 29065 | 87 | 0 |
532759 | 532759 | 2020-09-14 | Ozark | Missouri | 29153 | 87 | 0 |
513328 | 513328 | 2020-09-08 | Macon | Missouri | 29121 | 87 | 0 |
497178 | 497178 | 2020-09-03 | Osage | Missouri | 29151 | 87 | 1 |
490747 | 490747 | 2020-09-01 | Wayne | Missouri | 29223 | 87 | 0 |
484259 | 484259 | 2020-08-30 | Ripley | Missouri | 29181 | 87 | 0 |
458355 | 458355 | 2020-08-22 | Gentry | Missouri | 29075 | 87 | 9 |
455127 | 455127 | 2020-08-21 | Gentry | Missouri | 29075 | 87 | 9 |
451870 | 451870 | 2020-08-20 | Bollinger | Missouri | 29017 | 87 | 1 |
451899 | 451899 | 2020-08-20 | Gentry | Missouri | 29075 | 87 | 9 |
448642 | 448642 | 2020-08-19 | Bollinger | Missouri | 29017 | 87 | 1 |
448671 | 448671 | 2020-08-19 | Gentry | Missouri | 29075 | 87 | 9 |
445445 | 445445 | 2020-08-18 | Gentry | Missouri | 29075 | 87 | 9 |
445497 | 445497 | 2020-08-18 | Randolph | Missouri | 29175 | 87 | 1 |
442219 | 442219 | 2020-08-17 | Gentry | Missouri | 29075 | 87 | 9 |
438992 | 438992 | 2020-08-16 | Gentry | Missouri | 29075 | 87 | 9 |
435767 | 435767 | 2020-08-15 | Gentry | Missouri | 29075 | 87 | 9 |
426125 | 426125 | 2020-08-12 | Morgan | Missouri | 29141 | 87 | 0 |
422903 | 422903 | 2020-08-11 | Morgan | Missouri | 29141 | 87 | 0 |
422943 | 422943 | 2020-08-11 | Washington | Missouri | 29221 | 87 | 1 |
419642 | 419642 | 2020-08-10 | Douglas | Missouri | 29067 | 87 | 2 |
416389 | 416389 | 2020-08-09 | Andrew | Missouri | 29003 | 87 | 1 |
406735 | 406735 | 2020-08-06 | Benton | Missouri | 29015 | 87 | 1 |
403511 | 403511 | 2020-08-05 | Andrew | Missouri | 29003 | 87 | 1 |
387519 | 387519 | 2020-07-31 | Ray | Missouri | 29177 | 87 | 0 |
368209 | 368209 | 2020-07-25 | Moniteau | Missouri | 29135 | 87 | 2 |
361738 | 361738 | 2020-07-23 | Callaway | Missouri | 29027 | 87 | 1 |
361839 | 361839 | 2020-07-23 | Webster | Missouri | 29225 | 87 | 1 |
345770 | 345770 | 2020-07-18 | Lawrence | Missouri | 29109 | 87 | 2 |
329756 | 329756 | 2020-07-13 | Camden | Missouri | 29029 | 87 | 2 |
326610 | 326610 | 2020-07-12 | Laclede | Missouri | 29105 | 87 | 1 |
317023 | 317023 | 2020-07-09 | Barry | Missouri | 29009 | 87 | 0 |
279161 | 279161 | 2020-06-27 | Lafayette | Missouri | 29107 | 87 | 2 |
276013 | 276013 | 2020-06-26 | Lafayette | Missouri | 29107 | 87 | 2 |
272870 | 272870 | 2020-06-25 | Lafayette | Missouri | 29107 | 87 | 2 |
269678 | 269678 | 2020-06-24 | Adair | Missouri | 29001 | 87 | 0 |
250979 | 250979 | 2020-06-18 | Johnson | Missouri | 29101 | 87 | 0 |
251007 | 251007 | 2020-06-18 | Perry | Missouri | 29157 | 87 | 0 |
247894 | 247894 | 2020-06-17 | Perry | Missouri | 29157 | 87 | 0 |
244760 | 244760 | 2020-06-16 | Lincoln | Missouri | 29113 | 87 | 1 |
241649 | 241649 | 2020-06-15 | Lincoln | Missouri | 29113 | 87 | 1 |
238539 | 238539 | 2020-06-14 | Lincoln | Missouri | 29113 | 87 | 1 |
235432 | 235432 | 2020-06-13 | Lincoln | Missouri | 29113 | 87 | 1 |
229222 | 229222 | 2020-06-11 | Lincoln | Missouri | 29113 | 87 | 1 |
229247 | 229247 | 2020-06-11 | Platte | Missouri | 29165 | 87 | 3 |
226119 | 226119 | 2020-06-10 | Lincoln | Missouri | 29113 | 87 | 1 |
223020 | 223020 | 2020-06-09 | Lincoln | Missouri | 29113 | 87 | 1 |
219886 | 219886 | 2020-06-08 | Cape Girardeau | Missouri | 29031 | 87 | 3 |
219925 | 219925 | 2020-06-08 | Lincoln | Missouri | 29113 | 87 | 1 |
216833 | 216833 | 2020-06-07 | Lincoln | Missouri | 29113 | 87 | 1 |
201467 | 201467 | 2020-06-02 | Stoddard | Missouri | 29207 | 87 | 5 |
198369 | 198369 | 2020-06-01 | Pemiscot | Missouri | 29155 | 87 | 4 |
155742 | 155742 | 2020-05-18 | Scott | Missouri | 29201 | 87 | 7 |
152728 | 152728 | 2020-05-17 | Scott | Missouri | 29201 | 87 | 6 |
102415 | 102415 | 2020-04-30 | Buchanan | Missouri | 29021 | 87 | 1 |
57802 | 57802 | 2020-04-14 | Boone | Missouri | 29019 | 87 | 1 |
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);