ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 214 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1762991 | 1762991 | 2021-09-28 | Worth | Missouri | 29227 | 214 | 2 |
1759742 | 1759742 | 2021-09-27 | Worth | Missouri | 29227 | 214 | 2 |
1756494 | 1756494 | 2021-09-26 | Worth | Missouri | 29227 | 214 | 2 |
1753246 | 1753246 | 2021-09-25 | Worth | Missouri | 29227 | 214 | 2 |
1749998 | 1749998 | 2021-09-24 | Worth | Missouri | 29227 | 214 | 2 |
1746748 | 1746748 | 2021-09-23 | Worth | Missouri | 29227 | 214 | 2 |
1743499 | 1743499 | 2021-09-22 | Worth | Missouri | 29227 | 214 | 2 |
1740250 | 1740250 | 2021-09-21 | Worth | Missouri | 29227 | 214 | 2 |
1737001 | 1737001 | 2021-09-20 | Worth | Missouri | 29227 | 214 | 2 |
957720 | 957720 | 2021-01-23 | Putnam | Missouri | 29171 | 214 | 2 |
954475 | 954475 | 2021-01-22 | Putnam | Missouri | 29171 | 214 | 2 |
834407 | 834407 | 2020-12-16 | Scotland | Missouri | 29199 | 214 | 2 |
788876 | 788876 | 2020-12-02 | Atchison | Missouri | 29005 | 214 | 3 |
785631 | 785631 | 2020-12-01 | Atchison | Missouri | 29005 | 214 | 3 |
749949 | 749949 | 2020-11-20 | Chariton | Missouri | 29041 | 214 | 0 |
685063 | 685063 | 2020-10-31 | Carroll | Missouri | 29033 | 214 | 4 |
675396 | 675396 | 2020-10-28 | Ozark | Missouri | 29153 | 214 | 1 |
655952 | 655952 | 2020-10-22 | Shannon | Missouri | 29203 | 214 | 3 |
652686 | 652686 | 2020-10-21 | Oregon | Missouri | 29149 | 214 | 0 |
633179 | 633179 | 2020-10-15 | Howard | Missouri | 29089 | 214 | 2 |
584536 | 584536 | 2020-09-30 | Douglas | Missouri | 29067 | 214 | 3 |
519805 | 519805 | 2020-09-10 | Moniteau | Missouri | 29135 | 214 | 4 |
481046 | 481046 | 2020-08-29 | Webster | Missouri | 29225 | 214 | 1 |
471280 | 471280 | 2020-08-26 | Howell | Missouri | 29091 | 214 | 3 |
468073 | 468073 | 2020-08-25 | Mississippi | Missouri | 29133 | 214 | 0 |
464844 | 464844 | 2020-08-24 | Mississippi | Missouri | 29133 | 214 | 0 |
461613 | 461613 | 2020-08-23 | Mississippi | Missouri | 29133 | 214 | 0 |
403590 | 403590 | 2020-08-05 | Perry | Missouri | 29157 | 214 | 4 |
397158 | 397158 | 2020-08-03 | Pemiscot | Missouri | 29155 | 214 | 8 |
317037 | 317037 | 2020-07-09 | Cass | Missouri | 29037 | 214 | 9 |
304355 | 304355 | 2020-07-05 | Cape Girardeau | Missouri | 29031 | 214 | 3 |
125760 | 125760 | 2020-05-08 | Saline | Missouri | 29195 | 214 | 0 |
71528 | 71528 | 2020-04-19 | Jefferson | Missouri | 29099 | 214 | 3 |
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);