ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 201 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1629797 | 1629797 | 2021-08-18 | Worth | Missouri | 29227 | 201 | 2 |
1626550 | 1626550 | 2021-08-17 | Worth | Missouri | 29227 | 201 | 2 |
1623303 | 1623303 | 2021-08-16 | Worth | Missouri | 29227 | 201 | 2 |
1620056 | 1620056 | 2021-08-15 | Worth | Missouri | 29227 | 201 | 2 |
1616808 | 1616808 | 2021-08-14 | Worth | Missouri | 29227 | 201 | 2 |
1613560 | 1613560 | 2021-08-13 | Worth | Missouri | 29227 | 201 | 2 |
1610311 | 1610311 | 2021-08-12 | Worth | Missouri | 29227 | 201 | 2 |
1607063 | 1607063 | 2021-08-11 | Worth | Missouri | 29227 | 201 | 2 |
1603814 | 1603814 | 2021-08-10 | Worth | Missouri | 29227 | 201 | 2 |
1600565 | 1600565 | 2021-08-09 | Worth | Missouri | 29227 | 201 | 2 |
1597317 | 1597317 | 2021-08-08 | Worth | Missouri | 29227 | 201 | 2 |
1594068 | 1594068 | 2021-08-07 | Worth | Missouri | 29227 | 201 | 2 |
1590819 | 1590819 | 2021-08-06 | Worth | Missouri | 29227 | 201 | 2 |
902550 | 902550 | 2021-01-06 | Putnam | Missouri | 29171 | 201 | 2 |
899305 | 899305 | 2021-01-05 | Putnam | Missouri | 29171 | 201 | 2 |
896060 | 896060 | 2021-01-04 | Putnam | Missouri | 29171 | 201 | 1 |
892813 | 892813 | 2021-01-03 | Putnam | Missouri | 29171 | 201 | 1 |
889567 | 889567 | 2021-01-02 | Putnam | Missouri | 29171 | 201 | 1 |
805194 | 805194 | 2020-12-07 | Scotland | Missouri | 29199 | 201 | 1 |
801949 | 801949 | 2020-12-06 | Scotland | Missouri | 29199 | 201 | 1 |
701282 | 701282 | 2020-11-05 | Carter | Missouri | 29035 | 201 | 3 |
688328 | 688328 | 2020-11-01 | Gentry | Missouri | 29075 | 201 | 10 |
672132 | 672132 | 2020-10-27 | Lewis | Missouri | 29111 | 201 | 2 |
662422 | 662422 | 2020-10-24 | Ozark | Missouri | 29153 | 201 | 1 |
629926 | 629926 | 2020-10-14 | Gasconade | Missouri | 29073 | 201 | 24 |
591013 | 591013 | 2020-10-02 | Dallas | Missouri | 29059 | 201 | 1 |
584607 | 584607 | 2020-09-30 | Ste. Genevieve | Missouri | 29186 | 201 | 1 |
545715 | 545715 | 2020-09-18 | Randolph | Missouri | 29175 | 201 | 2 |
474581 | 474581 | 2020-08-27 | Webster | Missouri | 29225 | 201 | 1 |
455158 | 455158 | 2020-08-21 | Mississippi | Missouri | 29133 | 201 | 0 |
448689 | 448689 | 2020-08-19 | Lafayette | Missouri | 29107 | 201 | 2 |
419673 | 419673 | 2020-08-10 | Marion | Missouri | 29127 | 201 | 1 |
387509 | 387509 | 2020-07-31 | Perry | Missouri | 29157 | 201 | 4 |
374574 | 374574 | 2020-07-27 | Butler | Missouri | 29023 | 201 | 2 |
272851 | 272851 | 2020-06-25 | Franklin | Missouri | 29071 | 201 | 18 |
229176 | 229176 | 2020-06-11 | Boone | Missouri | 29019 | 201 | 1 |
223003 | 223003 | 2020-06-09 | Greene | Missouri | 29077 | 201 | 8 |
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);