ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 80 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 |
---|---|---|---|---|---|---|---|
795479 | 795479 | 2020-12-04 | Worth | Missouri | 29227 | 80 | 0 |
698041 | 698041 | 2020-11-04 | Chariton | Missouri | 29041 | 80 | 0 |
685142 | 685142 | 2020-10-31 | Scotland | Missouri | 29199 | 80 | 1 |
678562 | 678562 | 2020-10-29 | Atchison | Missouri | 29005 | 80 | 1 |
672166 | 672166 | 2020-10-27 | Reynolds | Missouri | 29179 | 80 | 1 |
613776 | 613776 | 2020-10-09 | Shelby | Missouri | 29205 | 80 | 1 |
604051 | 604051 | 2020-10-06 | St. Clair | Missouri | 29185 | 80 | 0 |
597494 | 597494 | 2020-10-04 | Dade | Missouri | 29057 | 80 | 0 |
594253 | 594253 | 2020-10-03 | Dade | Missouri | 29057 | 80 | 0 |
584546 | 584546 | 2020-09-30 | Holt | Missouri | 29087 | 80 | 1 |
529521 | 529521 | 2020-09-13 | Oregon | Missouri | 29149 | 80 | 0 |
526241 | 526241 | 2020-09-12 | Dent | Missouri | 29065 | 80 | 0 |
519742 | 519742 | 2020-09-10 | Bates | Missouri | 29013 | 80 | 1 |
516507 | 516507 | 2020-09-09 | Bates | Missouri | 29013 | 80 | 1 |
513273 | 513273 | 2020-09-08 | Bates | Missouri | 29013 | 80 | 1 |
510066 | 510066 | 2020-09-07 | DeKalb | Missouri | 29063 | 80 | 1 |
506833 | 506833 | 2020-09-06 | DeKalb | Missouri | 29063 | 80 | 1 |
490695 | 490695 | 2020-09-01 | Macon | Missouri | 29121 | 80 | 0 |
487478 | 487478 | 2020-08-31 | Osage | Missouri | 29151 | 80 | 1 |
481042 | 481042 | 2020-08-29 | Vernon | Missouri | 29217 | 80 | 0 |
477810 | 477810 | 2020-08-28 | Vernon | Missouri | 29217 | 80 | 0 |
474577 | 474577 | 2020-08-27 | Vernon | Missouri | 29217 | 80 | 0 |
458406 | 458406 | 2020-08-22 | Ralls | Missouri | 29173 | 80 | 0 |
432512 | 432512 | 2020-08-14 | Bollinger | Missouri | 29017 | 80 | 1 |
387535 | 387535 | 2020-07-31 | Stone | Missouri | 29209 | 80 | 1 |
384212 | 384212 | 2020-07-30 | Andrew | Missouri | 29003 | 80 | 1 |
380996 | 380996 | 2020-07-29 | Andrew | Missouri | 29003 | 80 | 1 |
377815 | 377815 | 2020-07-28 | Gentry | Missouri | 29075 | 80 | 9 |
365001 | 365001 | 2020-07-24 | Moniteau | Missouri | 29135 | 80 | 2 |
355431 | 355431 | 2020-07-21 | Webster | Missouri | 29225 | 80 | 1 |
348928 | 348928 | 2020-07-19 | Callaway | Missouri | 29027 | 80 | 1 |
269744 | 269744 | 2020-06-24 | Mississippi | Missouri | 29133 | 80 | 0 |
266611 | 266611 | 2020-06-23 | Mississippi | Missouri | 29133 | 80 | 0 |
241642 | 241642 | 2020-06-15 | Johnson | Missouri | 29101 | 80 | 0 |
238484 | 238484 | 2020-06-14 | Adair | Missouri | 29001 | 80 | 0 |
238532 | 238532 | 2020-06-14 | Johnson | Missouri | 29101 | 80 | 0 |
235377 | 235377 | 2020-06-13 | Adair | Missouri | 29001 | 80 | 0 |
235425 | 235425 | 2020-06-13 | Johnson | Missouri | 29101 | 80 | 0 |
232347 | 232347 | 2020-06-12 | Perry | Missouri | 29157 | 80 | 0 |
229213 | 229213 | 2020-06-11 | Jasper | Missouri | 29097 | 80 | 0 |
219950 | 219950 | 2020-06-08 | Platte | Missouri | 29165 | 80 | 2 |
210658 | 210658 | 2020-06-05 | Lafayette | Missouri | 29107 | 80 | 2 |
207577 | 207577 | 2020-06-04 | Lafayette | Missouri | 29107 | 80 | 2 |
176906 | 176906 | 2020-05-25 | Cass | Missouri | 29037 | 80 | 8 |
176941 | 176941 | 2020-05-25 | Lincoln | Missouri | 29113 | 80 | 1 |
134731 | 134731 | 2020-05-11 | Scott | Missouri | 29201 | 80 | 6 |
131740 | 131740 | 2020-05-10 | Scott | Missouri | 29201 | 80 | 5 |
52422 | 52422 | 2020-04-12 | Boone | Missouri | 29019 | 80 | 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);