ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where deaths = 209 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 8
- Boone 10
- Buchanan 8
- Cape Girardeau 8
- Clay 7
- Joplin 6
- Phelps 4
- St. Francois 4
- Howell 3
state 1
- Missouri · 50 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338348 | 2338348 | 2022-03-24 | Howell | Missouri | 29091 | 8935 | 209 |
2335094 | 2335094 | 2022-03-23 | Howell | Missouri | 29091 | 8922 | 209 |
2331840 | 2331840 | 2022-03-22 | Howell | Missouri | 29091 | 8918 | 209 |
2237536 | 2237536 | 2022-02-21 | Joplin | Missouri | 13607 | 209 | |
2234285 | 2234285 | 2022-02-20 | Joplin | Missouri | 13607 | 209 | |
2231034 | 2231034 | 2022-02-19 | Joplin | Missouri | 13607 | 209 | |
2227783 | 2227783 | 2022-02-18 | Joplin | Missouri | 13607 | 209 | |
2224532 | 2224532 | 2022-02-17 | Joplin | Missouri | 13598 | 209 | |
2221281 | 2221281 | 2022-02-16 | Joplin | Missouri | 13582 | 209 | |
2126895 | 2126895 | 2022-01-18 | Boone | Missouri | 29019 | 35969 | 209 |
2126901 | 2126901 | 2022-01-18 | Cape Girardeau | Missouri | 29031 | 15542 | 209 |
2126968 | 2126968 | 2022-01-18 | Phelps | Missouri | 29161 | 8689 | 209 |
2123643 | 2123643 | 2022-01-17 | Boone | Missouri | 29019 | 35011 | 209 |
2123649 | 2123649 | 2022-01-17 | Cape Girardeau | Missouri | 29031 | 15229 | 209 |
2123716 | 2123716 | 2022-01-17 | Phelps | Missouri | 29161 | 8542 | 209 |
2120391 | 2120391 | 2022-01-16 | Boone | Missouri | 29019 | 35011 | 209 |
2120397 | 2120397 | 2022-01-16 | Cape Girardeau | Missouri | 29031 | 15229 | 209 |
2120464 | 2120464 | 2022-01-16 | Phelps | Missouri | 29161 | 8542 | 209 |
2117139 | 2117139 | 2022-01-15 | Boone | Missouri | 29019 | 35010 | 209 |
2117145 | 2117145 | 2022-01-15 | Cape Girardeau | Missouri | 29031 | 15228 | 209 |
2117212 | 2117212 | 2022-01-15 | Phelps | Missouri | 29161 | 8542 | 209 |
2113888 | 2113888 | 2022-01-14 | Boone | Missouri | 29019 | 34238 | 209 |
2113894 | 2113894 | 2022-01-14 | Cape Girardeau | Missouri | 29031 | 14993 | 209 |
2110642 | 2110642 | 2022-01-13 | Cape Girardeau | Missouri | 29031 | 14885 | 209 |
2107391 | 2107391 | 2022-01-12 | Cape Girardeau | Missouri | 29031 | 14743 | 209 |
2104140 | 2104140 | 2022-01-11 | Cape Girardeau | Missouri | 29031 | 14645 | 209 |
2100883 | 2100883 | 2022-01-10 | Boone | Missouri | 29019 | 31704 | 209 |
2097632 | 2097632 | 2022-01-09 | Boone | Missouri | 29019 | 31485 | 209 |
2094380 | 2094380 | 2022-01-08 | Boone | Missouri | 29019 | 31232 | 209 |
2091128 | 2091128 | 2022-01-07 | Boone | Missouri | 29019 | 30737 | 209 |
2087877 | 2087877 | 2022-01-06 | Boone | Missouri | 29019 | 30460 | 209 |
1944944 | 1944944 | 2021-11-23 | St. Francois | Missouri | 29187 | 12554 | 209 |
1938443 | 1938443 | 2021-11-21 | St. Francois | Missouri | 29187 | 12522 | 209 |
1935193 | 1935193 | 2021-11-20 | St. Francois | Missouri | 29187 | 12512 | 209 |
1931943 | 1931943 | 2021-11-19 | St. Francois | Missouri | 29187 | 12480 | 209 |
1808389 | 1808389 | 2021-10-12 | Clay | Missouri | 29047 | 14601 | 209 |
1805138 | 1805138 | 2021-10-11 | Clay | Missouri | 29047 | 14565 | 209 |
1801889 | 1801889 | 2021-10-10 | Clay | Missouri | 29047 | 14549 | 209 |
1798640 | 1798640 | 2021-10-09 | Clay | Missouri | 29047 | 14534 | 209 |
1795391 | 1795391 | 2021-10-08 | Clay | Missouri | 29047 | 14508 | 209 |
1788893 | 1788893 | 2021-10-06 | Clay | Missouri | 29047 | 14428 | 209 |
1785645 | 1785645 | 2021-10-05 | Clay | Missouri | 29047 | 14387 | 209 |
1691416 | 1691416 | 2021-09-06 | Buchanan | Missouri | 29021 | 14197 | 209 |
1688166 | 1688166 | 2021-09-05 | Buchanan | Missouri | 29021 | 14197 | 209 |
1684916 | 1684916 | 2021-09-04 | Buchanan | Missouri | 29021 | 14197 | 209 |
1681665 | 1681665 | 2021-09-03 | Buchanan | Missouri | 29021 | 14197 | 209 |
1678417 | 1678417 | 2021-09-02 | Buchanan | Missouri | 29021 | 14197 | 209 |
1675169 | 1675169 | 2021-09-01 | Buchanan | Missouri | 29021 | 14095 | 209 |
1671921 | 1671921 | 2021-08-31 | Buchanan | Missouri | 29021 | 14095 | 209 |
1668674 | 1668674 | 2021-08-30 | Buchanan | Missouri | 29021 | 14095 | 209 |
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);