ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 19189 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110021 | 2110021 | 2022-01-13 | Winnebago | Iowa | 19189 | 2564 | 41 |
2106770 | 2106770 | 2022-01-12 | Winnebago | Iowa | 19189 | 2564 | 41 |
2103519 | 2103519 | 2022-01-11 | Winnebago | Iowa | 19189 | 2481 | 41 |
2100268 | 2100268 | 2022-01-10 | Winnebago | Iowa | 19189 | 2481 | 41 |
2097017 | 2097017 | 2022-01-09 | Winnebago | Iowa | 19189 | 2481 | 41 |
2093765 | 2093765 | 2022-01-08 | Winnebago | Iowa | 19189 | 2481 | 41 |
2090513 | 2090513 | 2022-01-07 | Winnebago | Iowa | 19189 | 2481 | 41 |
2087262 | 2087262 | 2022-01-06 | Winnebago | Iowa | 19189 | 2481 | 41 |
2084010 | 2084010 | 2022-01-05 | Winnebago | Iowa | 19189 | 2481 | 41 |
2080758 | 2080758 | 2022-01-04 | Winnebago | Iowa | 19189 | 2432 | 41 |
2077506 | 2077506 | 2022-01-03 | Winnebago | Iowa | 19189 | 2432 | 41 |
2074255 | 2074255 | 2022-01-02 | Winnebago | Iowa | 19189 | 2432 | 41 |
2071004 | 2071004 | 2022-01-01 | Winnebago | Iowa | 19189 | 2432 | 41 |
2067753 | 2067753 | 2021-12-31 | Winnebago | Iowa | 19189 | 2432 | 41 |
2064502 | 2064502 | 2021-12-30 | Winnebago | Iowa | 19189 | 2432 | 41 |
2061252 | 2061252 | 2021-12-29 | Winnebago | Iowa | 19189 | 2432 | 41 |
2058003 | 2058003 | 2021-12-28 | Winnebago | Iowa | 19189 | 2407 | 41 |
2054754 | 2054754 | 2021-12-27 | Winnebago | Iowa | 19189 | 2407 | 41 |
2051504 | 2051504 | 2021-12-26 | Winnebago | Iowa | 19189 | 2407 | 41 |
2048254 | 2048254 | 2021-12-25 | Winnebago | Iowa | 19189 | 2407 | 41 |
2045004 | 2045004 | 2021-12-24 | Winnebago | Iowa | 19189 | 2407 | 41 |
2041755 | 2041755 | 2021-12-23 | Winnebago | Iowa | 19189 | 2407 | 41 |
2038505 | 2038505 | 2021-12-22 | Winnebago | Iowa | 19189 | 2407 | 41 |
2035255 | 2035255 | 2021-12-21 | Winnebago | Iowa | 19189 | 2372 | 40 |
2032005 | 2032005 | 2021-12-20 | Winnebago | Iowa | 19189 | 2372 | 40 |
2028754 | 2028754 | 2021-12-19 | Winnebago | Iowa | 19189 | 2372 | 40 |
2025503 | 2025503 | 2021-12-18 | Winnebago | Iowa | 19189 | 2372 | 40 |
2022252 | 2022252 | 2021-12-17 | Winnebago | Iowa | 19189 | 2372 | 40 |
2019001 | 2019001 | 2021-12-16 | Winnebago | Iowa | 19189 | 2372 | 40 |
2015751 | 2015751 | 2021-12-15 | Winnebago | Iowa | 19189 | 2372 | 40 |
2012500 | 2012500 | 2021-12-14 | Winnebago | Iowa | 19189 | 2320 | 40 |
2009249 | 2009249 | 2021-12-13 | Winnebago | Iowa | 19189 | 2320 | 40 |
2005998 | 2005998 | 2021-12-12 | Winnebago | Iowa | 19189 | 2320 | 40 |
2002747 | 2002747 | 2021-12-11 | Winnebago | Iowa | 19189 | 2320 | 40 |
1999497 | 1999497 | 2021-12-10 | Winnebago | Iowa | 19189 | 2320 | 40 |
1996246 | 1996246 | 2021-12-09 | Winnebago | Iowa | 19189 | 2320 | 40 |
1992995 | 1992995 | 2021-12-08 | Winnebago | Iowa | 19189 | 2320 | 40 |
1989744 | 1989744 | 2021-12-07 | Winnebago | Iowa | 19189 | 2234 | 39 |
1986494 | 1986494 | 2021-12-06 | Winnebago | Iowa | 19189 | 2234 | 39 |
1983244 | 1983244 | 2021-12-05 | Winnebago | Iowa | 19189 | 2234 | 39 |
1979994 | 1979994 | 2021-12-04 | Winnebago | Iowa | 19189 | 2234 | 39 |
1976744 | 1976744 | 2021-12-03 | Winnebago | Iowa | 19189 | 2234 | 39 |
1973495 | 1973495 | 2021-12-02 | Winnebago | Iowa | 19189 | 2234 | 39 |
1970245 | 1970245 | 2021-12-01 | Winnebago | Iowa | 19189 | 2234 | 39 |
1966995 | 1966995 | 2021-11-30 | Winnebago | Iowa | 19189 | 2171 | 38 |
1963743 | 1963743 | 2021-11-29 | Winnebago | Iowa | 19189 | 2171 | 38 |
1960492 | 1960492 | 2021-11-28 | Winnebago | Iowa | 19189 | 2171 | 38 |
1957241 | 1957241 | 2021-11-27 | Winnebago | Iowa | 19189 | 2171 | 38 |
1953990 | 1953990 | 2021-11-26 | Winnebago | Iowa | 19189 | 2171 | 38 |
1950739 | 1950739 | 2021-11-25 | Winnebago | Iowa | 19189 | 2171 | 38 |
1947488 | 1947488 | 2021-11-24 | Winnebago | Iowa | 19189 | 2171 | 38 |
1944237 | 1944237 | 2021-11-23 | Winnebago | Iowa | 19189 | 2105 | 36 |
1940987 | 1940987 | 2021-11-22 | Winnebago | Iowa | 19189 | 2105 | 36 |
1937737 | 1937737 | 2021-11-21 | Winnebago | Iowa | 19189 | 2105 | 36 |
1934487 | 1934487 | 2021-11-20 | Winnebago | Iowa | 19189 | 2105 | 36 |
1931236 | 1931236 | 2021-11-19 | Winnebago | Iowa | 19189 | 2105 | 36 |
1927985 | 1927985 | 2021-11-18 | Winnebago | Iowa | 19189 | 2105 | 36 |
1924735 | 1924735 | 2021-11-17 | Winnebago | Iowa | 19189 | 2105 | 36 |
1921486 | 1921486 | 2021-11-16 | Winnebago | Iowa | 19189 | 2018 | 34 |
1918236 | 1918236 | 2021-11-15 | Winnebago | Iowa | 19189 | 2018 | 34 |
1914986 | 1914986 | 2021-11-14 | Winnebago | Iowa | 19189 | 2018 | 34 |
1911736 | 1911736 | 2021-11-13 | Winnebago | Iowa | 19189 | 2018 | 34 |
1908487 | 1908487 | 2021-11-12 | Winnebago | Iowa | 19189 | 2018 | 34 |
1905238 | 1905238 | 2021-11-11 | Winnebago | Iowa | 19189 | 2018 | 34 |
1901988 | 1901988 | 2021-11-10 | Winnebago | Iowa | 19189 | 2018 | 34 |
1898738 | 1898738 | 2021-11-09 | Winnebago | Iowa | 19189 | 1952 | 34 |
1895488 | 1895488 | 2021-11-08 | Winnebago | Iowa | 19189 | 1952 | 34 |
1892238 | 1892238 | 2021-11-07 | Winnebago | Iowa | 19189 | 1952 | 34 |
1888988 | 1888988 | 2021-11-06 | Winnebago | Iowa | 19189 | 1952 | 34 |
1885738 | 1885738 | 2021-11-05 | Winnebago | Iowa | 19189 | 1952 | 34 |
1882489 | 1882489 | 2021-11-04 | Winnebago | Iowa | 19189 | 1952 | 34 |
1879240 | 1879240 | 2021-11-03 | Winnebago | Iowa | 19189 | 1952 | 34 |
1875991 | 1875991 | 2021-11-02 | Winnebago | Iowa | 19189 | 1891 | 33 |
1872742 | 1872742 | 2021-11-01 | Winnebago | Iowa | 19189 | 1891 | 33 |
1869493 | 1869493 | 2021-10-31 | Winnebago | Iowa | 19189 | 1891 | 33 |
1866244 | 1866244 | 2021-10-30 | Winnebago | Iowa | 19189 | 1891 | 33 |
1862995 | 1862995 | 2021-10-29 | Winnebago | Iowa | 19189 | 1891 | 33 |
1859746 | 1859746 | 2021-10-28 | Winnebago | Iowa | 19189 | 1891 | 33 |
1856497 | 1856497 | 2021-10-27 | Winnebago | Iowa | 19189 | 1891 | 33 |
1853248 | 1853248 | 2021-10-26 | Winnebago | Iowa | 19189 | 1870 | 33 |
1849999 | 1849999 | 2021-10-25 | Winnebago | Iowa | 19189 | 1870 | 33 |
1846749 | 1846749 | 2021-10-24 | Winnebago | Iowa | 19189 | 1870 | 33 |
1843499 | 1843499 | 2021-10-23 | Winnebago | Iowa | 19189 | 1870 | 33 |
1840249 | 1840249 | 2021-10-22 | Winnebago | Iowa | 19189 | 1870 | 33 |
1837000 | 1837000 | 2021-10-21 | Winnebago | Iowa | 19189 | 1870 | 33 |
1833751 | 1833751 | 2021-10-20 | Winnebago | Iowa | 19189 | 1870 | 33 |
1830502 | 1830502 | 2021-10-19 | Winnebago | Iowa | 19189 | 1856 | 32 |
1827253 | 1827253 | 2021-10-18 | Winnebago | Iowa | 19189 | 1856 | 32 |
1824004 | 1824004 | 2021-10-17 | Winnebago | Iowa | 19189 | 1856 | 32 |
1820755 | 1820755 | 2021-10-16 | Winnebago | Iowa | 19189 | 1856 | 32 |
1817506 | 1817506 | 2021-10-15 | Winnebago | Iowa | 19189 | 1856 | 32 |
1814258 | 1814258 | 2021-10-14 | Winnebago | Iowa | 19189 | 1856 | 32 |
1811009 | 1811009 | 2021-10-13 | Winnebago | Iowa | 19189 | 1856 | 32 |
1807760 | 1807760 | 2021-10-12 | Winnebago | Iowa | 19189 | 1832 | 32 |
1804509 | 1804509 | 2021-10-11 | Winnebago | Iowa | 19189 | 1832 | 32 |
1801260 | 1801260 | 2021-10-10 | Winnebago | Iowa | 19189 | 1832 | 32 |
1798011 | 1798011 | 2021-10-09 | Winnebago | Iowa | 19189 | 1832 | 32 |
1794762 | 1794762 | 2021-10-08 | Winnebago | Iowa | 19189 | 1832 | 32 |
1791514 | 1791514 | 2021-10-07 | Winnebago | Iowa | 19189 | 1832 | 32 |
1788265 | 1788265 | 2021-10-06 | Winnebago | Iowa | 19189 | 1832 | 32 |
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);