ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 66 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
759783 | 759783 | 2020-11-23 | Worth | Missouri | 29227 | 66 | 0 |
746749 | 746749 | 2020-11-19 | Mercer | Missouri | 29129 | 66 | 0 |
704594 | 704594 | 2020-11-06 | Putnam | Missouri | 29171 | 66 | 1 |
685100 | 685100 | 2020-10-31 | Knox | Missouri | 29103 | 66 | 1 |
568395 | 568395 | 2020-09-25 | St. Clair | Missouri | 29185 | 66 | 0 |
542401 | 542401 | 2020-09-17 | Caldwell | Missouri | 29025 | 66 | 1 |
542452 | 542452 | 2020-09-17 | Maries | Missouri | 29125 | 66 | 0 |
529475 | 529475 | 2020-09-13 | Daviess | Missouri | 29061 | 66 | 0 |
526306 | 526306 | 2020-09-12 | Shannon | Missouri | 29203 | 66 | 1 |
513343 | 513343 | 2020-09-08 | Oregon | Missouri | 29149 | 66 | 0 |
510077 | 510077 | 2020-09-07 | Hickory | Missouri | 29085 | 66 | 1 |
500377 | 500377 | 2020-09-04 | Hickory | Missouri | 29085 | 66 | 1 |
497140 | 497140 | 2020-09-03 | Grundy | Missouri | 29079 | 66 | 1 |
497143 | 497143 | 2020-09-03 | Hickory | Missouri | 29085 | 66 | 0 |
477706 | 477706 | 2020-08-28 | Bates | Missouri | 29013 | 66 | 1 |
477770 | 477770 | 2020-08-28 | Monroe | Missouri | 29137 | 66 | 0 |
451939 | 451939 | 2020-08-20 | Osage | Missouri | 29151 | 66 | 1 |
448711 | 448711 | 2020-08-19 | Osage | Missouri | 29151 | 66 | 1 |
448744 | 448744 | 2020-08-19 | Vernon | Missouri | 29217 | 66 | 0 |
439068 | 439068 | 2020-08-16 | Wayne | Missouri | 29223 | 66 | 0 |
432565 | 432565 | 2020-08-14 | Macon | Missouri | 29121 | 66 | 0 |
432608 | 432608 | 2020-08-14 | Ste. Genevieve | Missouri | 29186 | 66 | 1 |
429338 | 429338 | 2020-08-13 | Macon | Missouri | 29121 | 66 | 0 |
406733 | 406733 | 2020-08-06 | Barton | Missouri | 29011 | 66 | 0 |
403515 | 403515 | 2020-08-05 | Barton | Missouri | 29011 | 66 | 0 |
403622 | 403622 | 2020-08-05 | Washington | Missouri | 29221 | 66 | 1 |
400298 | 400298 | 2020-08-04 | Barton | Missouri | 29011 | 66 | 0 |
384218 | 384218 | 2020-07-30 | Benton | Missouri | 29015 | 66 | 1 |
381077 | 381077 | 2020-07-29 | Phelps | Missouri | 29161 | 66 | 0 |
352116 | 352116 | 2020-07-20 | Andrew | Missouri | 29003 | 66 | 1 |
329779 | 329779 | 2020-07-13 | Gentry | Missouri | 29075 | 66 | 9 |
326593 | 326593 | 2020-07-12 | Gentry | Missouri | 29075 | 66 | 9 |
317056 | 317056 | 2020-07-09 | Gentry | Missouri | 29075 | 66 | 9 |
298027 | 298027 | 2020-07-03 | Camden | Missouri | 29029 | 66 | 1 |
294859 | 294859 | 2020-07-02 | Barry | Missouri | 29009 | 66 | 0 |
291715 | 291715 | 2020-07-01 | Camden | Missouri | 29029 | 66 | 1 |
288564 | 288564 | 2020-06-30 | Camden | Missouri | 29029 | 66 | 1 |
260390 | 260390 | 2020-06-21 | St. Francois | Missouri | 29187 | 66 | 2 |
254079 | 254079 | 2020-06-19 | Dunklin | Missouri | 29069 | 66 | 3 |
226129 | 226129 | 2020-06-10 | Mississippi | Missouri | 29133 | 66 | 0 |
216881 | 216881 | 2020-06-07 | Sullivan | Missouri | 29211 | 66 | 0 |
170879 | 170879 | 2020-05-23 | Platte | Missouri | 29165 | 66 | 1 |
167840 | 167840 | 2020-05-22 | Platte | Missouri | 29165 | 66 | 1 |
119741 | 119741 | 2020-05-06 | Cass | Missouri | 29037 | 66 | 6 |
36874 | 36874 | 2020-04-06 | Greene | Missouri | 29077 | 66 | 7 |
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);