ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 221 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1834472 | 1834472 | 2021-10-20 | Worth | Missouri | 29227 | 221 | 2 |
1009652 | 1009652 | 2021-02-08 | Putnam | Missouri | 29171 | 221 | 2 |
1006405 | 1006405 | 2021-02-07 | Putnam | Missouri | 29171 | 221 | 2 |
759688 | 759688 | 2020-11-23 | Chariton | Missouri | 29041 | 221 | 0 |
688379 | 688379 | 2020-11-01 | Ralls | Missouri | 29173 | 221 | 0 |
685135 | 685135 | 2020-10-31 | Ralls | Missouri | 29173 | 221 | 0 |
665619 | 665619 | 2020-10-25 | Daviess | Missouri | 29061 | 221 | 4 |
649401 | 649401 | 2020-10-20 | Gasconade | Missouri | 29073 | 221 | 24 |
646157 | 646157 | 2020-10-19 | Gasconade | Missouri | 29073 | 221 | 24 |
636387 | 636387 | 2020-10-16 | Bates | Missouri | 29013 | 221 | 3 |
636412 | 636412 | 2020-10-16 | DeKalb | Missouri | 29063 | 221 | 2 |
636413 | 636413 | 2020-10-16 | Dent | Missouri | 29065 | 221 | 2 |
607233 | 607233 | 2020-10-07 | Grundy | Missouri | 29079 | 221 | 4 |
594332 | 594332 | 2020-10-03 | Sullivan | Missouri | 29211 | 221 | 0 |
584616 | 584616 | 2020-09-30 | Wayne | Missouri | 29223 | 221 | 0 |
565079 | 565079 | 2020-09-24 | Clinton | Missouri | 29049 | 221 | 0 |
552104 | 552104 | 2020-09-20 | Andrew | Missouri | 29003 | 221 | 1 |
516528 | 516528 | 2020-09-09 | Crawford | Missouri | 29055 | 221 | 2 |
474535 | 474535 | 2020-08-27 | Mississippi | Missouri | 29133 | 221 | 0 |
435784 | 435784 | 2020-08-15 | Laclede | Missouri | 29105 | 221 | 1 |
435805 | 435805 | 2020-08-15 | Nodaway | Missouri | 29147 | 221 | 0 |
432558 | 432558 | 2020-08-14 | Laclede | Missouri | 29105 | 221 | 1 |
429388 | 429388 | 2020-08-13 | Warren | Missouri | 29219 | 221 | 0 |
371409 | 371409 | 2020-07-26 | Lincoln | Missouri | 29113 | 221 | 1 |
307522 | 307522 | 2020-07-06 | Cape Girardeau | Missouri | 29031 | 221 | 3 |
39429 | 39429 | 2020-04-07 | St. Charles | Missouri | 29183 | 221 | 9 |
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);