ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
564 rows where deaths = 14 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500374 | 2500374 | 2022-05-13 | Adams | Iowa | 19003 | 820 | 14 |
2497116 | 2497116 | 2022-05-12 | Adams | Iowa | 19003 | 820 | 14 |
2493858 | 2493858 | 2022-05-11 | Adams | Iowa | 19003 | 820 | 14 |
2331191 | 2331191 | 2022-03-22 | Worth | Iowa | 19195 | 1752 | 14 |
2327939 | 2327939 | 2022-03-21 | Worth | Iowa | 19195 | 1752 | 14 |
2324686 | 2324686 | 2022-03-20 | Worth | Iowa | 19195 | 1752 | 14 |
2321432 | 2321432 | 2022-03-19 | Worth | Iowa | 19195 | 1752 | 14 |
2318178 | 2318178 | 2022-03-18 | Worth | Iowa | 19195 | 1752 | 14 |
2314925 | 2314925 | 2022-03-17 | Worth | Iowa | 19195 | 1752 | 14 |
2311672 | 2311672 | 2022-03-16 | Worth | Iowa | 19195 | 1752 | 14 |
2308419 | 2308419 | 2022-03-15 | Worth | Iowa | 19195 | 1750 | 14 |
2305168 | 2305168 | 2022-03-14 | Worth | Iowa | 19195 | 1750 | 14 |
2301916 | 2301916 | 2022-03-13 | Worth | Iowa | 19195 | 1750 | 14 |
2298664 | 2298664 | 2022-03-12 | Worth | Iowa | 19195 | 1750 | 14 |
2295412 | 2295412 | 2022-03-11 | Worth | Iowa | 19195 | 1750 | 14 |
2292160 | 2292160 | 2022-03-10 | Worth | Iowa | 19195 | 1750 | 14 |
2288908 | 2288908 | 2022-03-09 | Worth | Iowa | 19195 | 1750 | 14 |
2285657 | 2285657 | 2022-03-08 | Worth | Iowa | 19195 | 1748 | 14 |
2282405 | 2282405 | 2022-03-07 | Worth | Iowa | 19195 | 1748 | 14 |
2279152 | 2279152 | 2022-03-06 | Worth | Iowa | 19195 | 1748 | 14 |
2275899 | 2275899 | 2022-03-05 | Worth | Iowa | 19195 | 1748 | 14 |
2272646 | 2272646 | 2022-03-04 | Worth | Iowa | 19195 | 1748 | 14 |
2269394 | 2269394 | 2022-03-03 | Worth | Iowa | 19195 | 1748 | 14 |
2266141 | 2266141 | 2022-03-02 | Worth | Iowa | 19195 | 1748 | 14 |
2012431 | 2012431 | 2021-12-14 | Decatur | Iowa | 19053 | 1095 | 14 |
2012440 | 2012440 | 2021-12-14 | Fremont | Iowa | 19071 | 1009 | 14 |
2012491 | 2012491 | 2021-12-14 | Taylor | Iowa | 19173 | 1033 | 14 |
2009180 | 2009180 | 2021-12-13 | Decatur | Iowa | 19053 | 1095 | 14 |
2009189 | 2009189 | 2021-12-13 | Fremont | Iowa | 19071 | 1009 | 14 |
2009240 | 2009240 | 2021-12-13 | Taylor | Iowa | 19173 | 1033 | 14 |
2005929 | 2005929 | 2021-12-12 | Decatur | Iowa | 19053 | 1095 | 14 |
2005938 | 2005938 | 2021-12-12 | Fremont | Iowa | 19071 | 1009 | 14 |
2005989 | 2005989 | 2021-12-12 | Taylor | Iowa | 19173 | 1033 | 14 |
2002678 | 2002678 | 2021-12-11 | Decatur | Iowa | 19053 | 1095 | 14 |
2002687 | 2002687 | 2021-12-11 | Fremont | Iowa | 19071 | 1009 | 14 |
2002738 | 2002738 | 2021-12-11 | Taylor | Iowa | 19173 | 1033 | 14 |
1999428 | 1999428 | 2021-12-10 | Decatur | Iowa | 19053 | 1095 | 14 |
1999437 | 1999437 | 2021-12-10 | Fremont | Iowa | 19071 | 1009 | 14 |
1999488 | 1999488 | 2021-12-10 | Taylor | Iowa | 19173 | 1033 | 14 |
1996177 | 1996177 | 2021-12-09 | Decatur | Iowa | 19053 | 1095 | 14 |
1996186 | 1996186 | 2021-12-09 | Fremont | Iowa | 19071 | 1009 | 14 |
1996237 | 1996237 | 2021-12-09 | Taylor | Iowa | 19173 | 1033 | 14 |
1992926 | 1992926 | 2021-12-08 | Decatur | Iowa | 19053 | 1095 | 14 |
1992935 | 1992935 | 2021-12-08 | Fremont | Iowa | 19071 | 1009 | 14 |
1992986 | 1992986 | 2021-12-08 | Taylor | Iowa | 19173 | 1033 | 14 |
1989735 | 1989735 | 2021-12-07 | Taylor | Iowa | 19173 | 1012 | 14 |
1986485 | 1986485 | 2021-12-06 | Taylor | Iowa | 19173 | 1012 | 14 |
1983235 | 1983235 | 2021-12-05 | Taylor | Iowa | 19173 | 1012 | 14 |
1979985 | 1979985 | 2021-12-04 | Taylor | Iowa | 19173 | 1012 | 14 |
1976735 | 1976735 | 2021-12-03 | Taylor | Iowa | 19173 | 1012 | 14 |
1973486 | 1973486 | 2021-12-02 | Taylor | Iowa | 19173 | 1012 | 14 |
1970236 | 1970236 | 2021-12-01 | Taylor | Iowa | 19173 | 1012 | 14 |
1966986 | 1966986 | 2021-11-30 | Taylor | Iowa | 19173 | 990 | 14 |
1963734 | 1963734 | 2021-11-29 | Taylor | Iowa | 19173 | 990 | 14 |
1960483 | 1960483 | 2021-11-28 | Taylor | Iowa | 19173 | 990 | 14 |
1957232 | 1957232 | 2021-11-27 | Taylor | Iowa | 19173 | 990 | 14 |
1953981 | 1953981 | 2021-11-26 | Taylor | Iowa | 19173 | 990 | 14 |
1950730 | 1950730 | 2021-11-25 | Taylor | Iowa | 19173 | 990 | 14 |
1947479 | 1947479 | 2021-11-24 | Taylor | Iowa | 19173 | 990 | 14 |
1944228 | 1944228 | 2021-11-23 | Taylor | Iowa | 19173 | 955 | 14 |
1940978 | 1940978 | 2021-11-22 | Taylor | Iowa | 19173 | 955 | 14 |
1937728 | 1937728 | 2021-11-21 | Taylor | Iowa | 19173 | 955 | 14 |
1934478 | 1934478 | 2021-11-20 | Taylor | Iowa | 19173 | 955 | 14 |
1931227 | 1931227 | 2021-11-19 | Taylor | Iowa | 19173 | 955 | 14 |
1927976 | 1927976 | 2021-11-18 | Taylor | Iowa | 19173 | 955 | 14 |
1924726 | 1924726 | 2021-11-17 | Taylor | Iowa | 19173 | 955 | 14 |
1921395 | 1921395 | 2021-11-16 | Audubon | Iowa | 19009 | 724 | 14 |
1921477 | 1921477 | 2021-11-16 | Taylor | Iowa | 19173 | 906 | 14 |
1918145 | 1918145 | 2021-11-15 | Audubon | Iowa | 19009 | 724 | 14 |
1918227 | 1918227 | 2021-11-15 | Taylor | Iowa | 19173 | 906 | 14 |
1914895 | 1914895 | 2021-11-14 | Audubon | Iowa | 19009 | 724 | 14 |
1914977 | 1914977 | 2021-11-14 | Taylor | Iowa | 19173 | 906 | 14 |
1911645 | 1911645 | 2021-11-13 | Audubon | Iowa | 19009 | 724 | 14 |
1911727 | 1911727 | 2021-11-13 | Taylor | Iowa | 19173 | 906 | 14 |
1908396 | 1908396 | 2021-11-12 | Audubon | Iowa | 19009 | 724 | 14 |
1908478 | 1908478 | 2021-11-12 | Taylor | Iowa | 19173 | 906 | 14 |
1905147 | 1905147 | 2021-11-11 | Audubon | Iowa | 19009 | 724 | 14 |
1905229 | 1905229 | 2021-11-11 | Taylor | Iowa | 19173 | 906 | 14 |
1901897 | 1901897 | 2021-11-10 | Audubon | Iowa | 19009 | 724 | 14 |
1901979 | 1901979 | 2021-11-10 | Taylor | Iowa | 19173 | 906 | 14 |
1898647 | 1898647 | 2021-11-09 | Audubon | Iowa | 19009 | 698 | 14 |
1895397 | 1895397 | 2021-11-08 | Audubon | Iowa | 19009 | 698 | 14 |
1892147 | 1892147 | 2021-11-07 | Audubon | Iowa | 19009 | 698 | 14 |
1888897 | 1888897 | 2021-11-06 | Audubon | Iowa | 19009 | 698 | 14 |
1885647 | 1885647 | 2021-11-05 | Audubon | Iowa | 19009 | 698 | 14 |
1882398 | 1882398 | 2021-11-04 | Audubon | Iowa | 19009 | 698 | 14 |
1879149 | 1879149 | 2021-11-03 | Audubon | Iowa | 19009 | 698 | 14 |
1875900 | 1875900 | 2021-11-02 | Audubon | Iowa | 19009 | 682 | 14 |
1872651 | 1872651 | 2021-11-01 | Audubon | Iowa | 19009 | 682 | 14 |
1869402 | 1869402 | 2021-10-31 | Audubon | Iowa | 19009 | 682 | 14 |
1866153 | 1866153 | 2021-10-30 | Audubon | Iowa | 19009 | 682 | 14 |
1862904 | 1862904 | 2021-10-29 | Audubon | Iowa | 19009 | 682 | 14 |
1859655 | 1859655 | 2021-10-28 | Audubon | Iowa | 19009 | 682 | 14 |
1856406 | 1856406 | 2021-10-27 | Audubon | Iowa | 19009 | 682 | 14 |
1853157 | 1853157 | 2021-10-26 | Audubon | Iowa | 19009 | 668 | 14 |
1849908 | 1849908 | 2021-10-25 | Audubon | Iowa | 19009 | 668 | 14 |
1846658 | 1846658 | 2021-10-24 | Audubon | Iowa | 19009 | 668 | 14 |
1843408 | 1843408 | 2021-10-23 | Audubon | Iowa | 19009 | 668 | 14 |
1840158 | 1840158 | 2021-10-22 | Audubon | Iowa | 19009 | 668 | 14 |
1836909 | 1836909 | 2021-10-21 | Audubon | Iowa | 19009 | 668 | 14 |
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);