ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 136 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2351372 | 2351372 | 2022-03-28 | Lincoln | Missouri | 29113 | 15125 | 136 |
2351426 | 2351426 | 2022-03-28 | Washington | Missouri | 29221 | 5958 | 136 |
2348120 | 2348120 | 2022-03-27 | Lincoln | Missouri | 29113 | 15125 | 136 |
2348174 | 2348174 | 2022-03-27 | Washington | Missouri | 29221 | 5949 | 136 |
2344867 | 2344867 | 2022-03-26 | Lincoln | Missouri | 29113 | 15125 | 136 |
2344921 | 2344921 | 2022-03-26 | Washington | Missouri | 29221 | 5949 | 136 |
2341614 | 2341614 | 2022-03-25 | Lincoln | Missouri | 29113 | 15125 | 136 |
2341668 | 2341668 | 2022-03-25 | Washington | Missouri | 29221 | 5949 | 136 |
2338361 | 2338361 | 2022-03-24 | Lincoln | Missouri | 29113 | 15123 | 136 |
2335107 | 2335107 | 2022-03-23 | Lincoln | Missouri | 29113 | 15117 | 136 |
2331853 | 2331853 | 2022-03-22 | Lincoln | Missouri | 29113 | 15116 | 136 |
2328600 | 2328600 | 2022-03-21 | Lincoln | Missouri | 29113 | 15110 | 136 |
2325348 | 2325348 | 2022-03-20 | Lincoln | Missouri | 29113 | 15109 | 136 |
2322094 | 2322094 | 2022-03-19 | Lincoln | Missouri | 29113 | 15109 | 136 |
2318840 | 2318840 | 2022-03-18 | Lincoln | Missouri | 29113 | 15109 | 136 |
2315587 | 2315587 | 2022-03-17 | Lincoln | Missouri | 29113 | 15108 | 136 |
2312334 | 2312334 | 2022-03-16 | Lincoln | Missouri | 29113 | 15104 | 136 |
2309081 | 2309081 | 2022-03-15 | Lincoln | Missouri | 29113 | 15102 | 136 |
2244037 | 2244037 | 2022-02-23 | Johnson | Missouri | 29101 | 11938 | 136 |
2240786 | 2240786 | 2022-02-22 | Johnson | Missouri | 29101 | 11931 | 136 |
2237535 | 2237535 | 2022-02-21 | Johnson | Missouri | 29101 | 11889 | 136 |
2234284 | 2234284 | 2022-02-20 | Johnson | Missouri | 29101 | 11889 | 136 |
2231033 | 2231033 | 2022-02-19 | Johnson | Missouri | 29101 | 11889 | 136 |
2227782 | 2227782 | 2022-02-18 | Johnson | Missouri | 29101 | 11889 | 136 |
2224531 | 2224531 | 2022-02-17 | Johnson | Missouri | 29101 | 11882 | 136 |
2221280 | 2221280 | 2022-02-16 | Johnson | Missouri | 29101 | 11864 | 136 |
2218029 | 2218029 | 2022-02-15 | Johnson | Missouri | 29101 | 11842 | 136 |
2110723 | 2110723 | 2022-01-13 | Scott | Missouri | 29201 | 8740 | 136 |
2107472 | 2107472 | 2022-01-12 | Scott | Missouri | 29201 | 8636 | 136 |
2104221 | 2104221 | 2022-01-11 | Scott | Missouri | 29201 | 8557 | 136 |
2100970 | 2100970 | 2022-01-10 | Scott | Missouri | 29201 | 8464 | 136 |
2097719 | 2097719 | 2022-01-09 | Scott | Missouri | 29201 | 8444 | 136 |
2094467 | 2094467 | 2022-01-08 | Scott | Missouri | 29201 | 8440 | 136 |
2091215 | 2091215 | 2022-01-07 | Scott | Missouri | 29201 | 8324 | 136 |
2087964 | 2087964 | 2022-01-06 | Scott | Missouri | 29201 | 8240 | 136 |
2084712 | 2084712 | 2022-01-05 | Scott | Missouri | 29201 | 8166 | 136 |
1987156 | 1987156 | 2021-12-06 | Lawrence | Missouri | 29109 | 5466 | 136 |
1983906 | 1983906 | 2021-12-05 | Lawrence | Missouri | 29109 | 5453 | 136 |
1980656 | 1980656 | 2021-12-04 | Lawrence | Missouri | 29109 | 5444 | 136 |
1977406 | 1977406 | 2021-12-03 | Lawrence | Missouri | 29109 | 5432 | 136 |
1974156 | 1974156 | 2021-12-02 | Lawrence | Missouri | 29109 | 5432 | 136 |
1970907 | 1970907 | 2021-12-01 | Lawrence | Missouri | 29109 | 5421 | 136 |
1967657 | 1967657 | 2021-11-30 | Lawrence | Missouri | 29109 | 5408 | 136 |
1964405 | 1964405 | 2021-11-29 | Lawrence | Missouri | 29109 | 5395 | 136 |
1961154 | 1961154 | 2021-11-28 | Lawrence | Missouri | 29109 | 5352 | 136 |
1957903 | 1957903 | 2021-11-27 | Lawrence | Missouri | 29109 | 5352 | 136 |
1954652 | 1954652 | 2021-11-26 | Lawrence | Missouri | 29109 | 5352 | 136 |
1951401 | 1951401 | 2021-11-25 | Lawrence | Missouri | 29109 | 5352 | 136 |
1948150 | 1948150 | 2021-11-24 | Lawrence | Missouri | 29109 | 5352 | 136 |
1944899 | 1944899 | 2021-11-23 | Lawrence | Missouri | 29109 | 5343 | 136 |
1941648 | 1941648 | 2021-11-22 | Lawrence | Missouri | 29109 | 5339 | 136 |
1928647 | 1928647 | 2021-11-18 | Lawrence | Missouri | 29109 | 5322 | 136 |
1698011 | 1698011 | 2021-09-08 | Taney | Missouri | 29213 | 8533 | 136 |
1668715 | 1668715 | 2021-08-30 | Joplin | Missouri | 8187 | 136 | |
1665468 | 1665468 | 2021-08-29 | Joplin | Missouri | 8176 | 136 | |
1662220 | 1662220 | 2021-08-28 | Joplin | Missouri | 8167 | 136 | |
1658972 | 1658972 | 2021-08-27 | Joplin | Missouri | 8153 | 136 | |
1655723 | 1655723 | 2021-08-26 | Joplin | Missouri | 8131 | 136 | |
1652434 | 1652434 | 2021-08-25 | Boone | Missouri | 29019 | 22684 | 136 |
1652476 | 1652476 | 2021-08-25 | Joplin | Missouri | 8110 | 136 | |
1649228 | 1649228 | 2021-08-24 | Joplin | Missouri | 8088 | 136 | |
1512839 | 1512839 | 2021-07-13 | Phelps | Missouri | 29161 | 4207 | 136 |
1509558 | 1509558 | 2021-07-12 | Jasper | Missouri | 29097 | 10595 | 136 |
1506312 | 1506312 | 2021-07-11 | Jasper | Missouri | 29097 | 10589 | 136 |
1503066 | 1503066 | 2021-07-10 | Jasper | Missouri | 29097 | 10568 | 136 |
1499820 | 1499820 | 2021-07-09 | Jasper | Missouri | 29097 | 10531 | 136 |
1496574 | 1496574 | 2021-07-08 | Jasper | Missouri | 29097 | 10438 | 136 |
1493327 | 1493327 | 2021-07-07 | Jasper | Missouri | 29097 | 10389 | 136 |
681851 | 681851 | 2020-10-30 | Jackson | Missouri | 29095 | 10365 | 136 |
610535 | 610535 | 2020-10-08 | St. Charles | Missouri | 29183 | 8796 | 136 |
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);