ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
753 rows where county = "Humboldt" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175037 | 2175037 | 2022-02-02 | Humboldt | Iowa | 19091 | 2549 | 35 |
2171784 | 2171784 | 2022-02-01 | Humboldt | Iowa | 19091 | 2513 | 35 |
2168531 | 2168531 | 2022-01-31 | Humboldt | Iowa | 19091 | 2513 | 35 |
2165276 | 2165276 | 2022-01-30 | Humboldt | Iowa | 19091 | 2513 | 35 |
2162021 | 2162021 | 2022-01-29 | Humboldt | Iowa | 19091 | 2513 | 35 |
2158766 | 2158766 | 2022-01-28 | Humboldt | Iowa | 19091 | 2513 | 35 |
2155512 | 2155512 | 2022-01-27 | Humboldt | Iowa | 19091 | 2513 | 35 |
2152259 | 2152259 | 2022-01-26 | Humboldt | Iowa | 19091 | 2513 | 35 |
2149007 | 2149007 | 2022-01-25 | Humboldt | Iowa | 19091 | 2443 | 35 |
2145755 | 2145755 | 2022-01-24 | Humboldt | Iowa | 19091 | 2443 | 35 |
2142500 | 2142500 | 2022-01-23 | Humboldt | Iowa | 19091 | 2443 | 35 |
2139245 | 2139245 | 2022-01-22 | Humboldt | Iowa | 19091 | 2443 | 35 |
2135989 | 2135989 | 2022-01-21 | Humboldt | Iowa | 19091 | 2443 | 35 |
2132737 | 2132737 | 2022-01-20 | Humboldt | Iowa | 19091 | 2443 | 35 |
2129484 | 2129484 | 2022-01-19 | Humboldt | Iowa | 19091 | 2443 | 35 |
2126230 | 2126230 | 2022-01-18 | Humboldt | Iowa | 19091 | 2347 | 35 |
2122978 | 2122978 | 2022-01-17 | Humboldt | Iowa | 19091 | 2347 | 35 |
2119726 | 2119726 | 2022-01-16 | Humboldt | Iowa | 19091 | 2347 | 35 |
2116474 | 2116474 | 2022-01-15 | Humboldt | Iowa | 19091 | 2347 | 35 |
2113223 | 2113223 | 2022-01-14 | Humboldt | Iowa | 19091 | 2347 | 35 |
2109971 | 2109971 | 2022-01-13 | Humboldt | Iowa | 19091 | 2347 | 35 |
2106720 | 2106720 | 2022-01-12 | Humboldt | Iowa | 19091 | 2347 | 35 |
2103469 | 2103469 | 2022-01-11 | Humboldt | Iowa | 19091 | 2213 | 33 |
2100218 | 2100218 | 2022-01-10 | Humboldt | Iowa | 19091 | 2213 | 33 |
2096967 | 2096967 | 2022-01-09 | Humboldt | Iowa | 19091 | 2213 | 33 |
2093715 | 2093715 | 2022-01-08 | Humboldt | Iowa | 19091 | 2213 | 33 |
2090463 | 2090463 | 2022-01-07 | Humboldt | Iowa | 19091 | 2213 | 33 |
2087212 | 2087212 | 2022-01-06 | Humboldt | Iowa | 19091 | 2213 | 33 |
2083960 | 2083960 | 2022-01-05 | Humboldt | Iowa | 19091 | 2213 | 33 |
2080708 | 2080708 | 2022-01-04 | Humboldt | Iowa | 19091 | 2110 | 33 |
2077456 | 2077456 | 2022-01-03 | Humboldt | Iowa | 19091 | 2110 | 33 |
2074205 | 2074205 | 2022-01-02 | Humboldt | Iowa | 19091 | 2110 | 33 |
2070954 | 2070954 | 2022-01-01 | Humboldt | Iowa | 19091 | 2110 | 33 |
2067703 | 2067703 | 2021-12-31 | Humboldt | Iowa | 19091 | 2110 | 33 |
2064452 | 2064452 | 2021-12-30 | Humboldt | Iowa | 19091 | 2110 | 33 |
2061202 | 2061202 | 2021-12-29 | Humboldt | Iowa | 19091 | 2110 | 33 |
2057953 | 2057953 | 2021-12-28 | Humboldt | Iowa | 19091 | 2020 | 33 |
2054704 | 2054704 | 2021-12-27 | Humboldt | Iowa | 19091 | 2020 | 33 |
2051454 | 2051454 | 2021-12-26 | Humboldt | Iowa | 19091 | 2020 | 33 |
2048204 | 2048204 | 2021-12-25 | Humboldt | Iowa | 19091 | 2020 | 33 |
2044954 | 2044954 | 2021-12-24 | Humboldt | Iowa | 19091 | 2020 | 33 |
2041705 | 2041705 | 2021-12-23 | Humboldt | Iowa | 19091 | 2020 | 33 |
2038455 | 2038455 | 2021-12-22 | Humboldt | Iowa | 19091 | 2020 | 33 |
2035205 | 2035205 | 2021-12-21 | Humboldt | Iowa | 19091 | 1976 | 33 |
2031955 | 2031955 | 2021-12-20 | Humboldt | Iowa | 19091 | 1976 | 33 |
2028704 | 2028704 | 2021-12-19 | Humboldt | Iowa | 19091 | 1976 | 33 |
2025453 | 2025453 | 2021-12-18 | Humboldt | Iowa | 19091 | 1976 | 33 |
2022202 | 2022202 | 2021-12-17 | Humboldt | Iowa | 19091 | 1976 | 33 |
2018951 | 2018951 | 2021-12-16 | Humboldt | Iowa | 19091 | 1976 | 33 |
2015701 | 2015701 | 2021-12-15 | Humboldt | Iowa | 19091 | 1976 | 33 |
2012450 | 2012450 | 2021-12-14 | Humboldt | Iowa | 19091 | 1934 | 33 |
2009199 | 2009199 | 2021-12-13 | Humboldt | Iowa | 19091 | 1934 | 33 |
2005948 | 2005948 | 2021-12-12 | Humboldt | Iowa | 19091 | 1934 | 33 |
2002697 | 2002697 | 2021-12-11 | Humboldt | Iowa | 19091 | 1934 | 33 |
1999447 | 1999447 | 2021-12-10 | Humboldt | Iowa | 19091 | 1934 | 33 |
1996196 | 1996196 | 2021-12-09 | Humboldt | Iowa | 19091 | 1934 | 33 |
1992945 | 1992945 | 2021-12-08 | Humboldt | Iowa | 19091 | 1934 | 33 |
1989694 | 1989694 | 2021-12-07 | Humboldt | Iowa | 19091 | 1886 | 31 |
1986444 | 1986444 | 2021-12-06 | Humboldt | Iowa | 19091 | 1886 | 31 |
1983194 | 1983194 | 2021-12-05 | Humboldt | Iowa | 19091 | 1886 | 31 |
1979944 | 1979944 | 2021-12-04 | Humboldt | Iowa | 19091 | 1886 | 31 |
1976694 | 1976694 | 2021-12-03 | Humboldt | Iowa | 19091 | 1886 | 31 |
1973445 | 1973445 | 2021-12-02 | Humboldt | Iowa | 19091 | 1886 | 31 |
1970195 | 1970195 | 2021-12-01 | Humboldt | Iowa | 19091 | 1886 | 31 |
1966945 | 1966945 | 2021-11-30 | Humboldt | Iowa | 19091 | 1854 | 30 |
1963693 | 1963693 | 2021-11-29 | Humboldt | Iowa | 19091 | 1854 | 30 |
1960442 | 1960442 | 2021-11-28 | Humboldt | Iowa | 19091 | 1854 | 30 |
1957191 | 1957191 | 2021-11-27 | Humboldt | Iowa | 19091 | 1854 | 30 |
1953940 | 1953940 | 2021-11-26 | Humboldt | Iowa | 19091 | 1854 | 30 |
1950689 | 1950689 | 2021-11-25 | Humboldt | Iowa | 19091 | 1854 | 30 |
1947438 | 1947438 | 2021-11-24 | Humboldt | Iowa | 19091 | 1854 | 30 |
1944187 | 1944187 | 2021-11-23 | Humboldt | Iowa | 19091 | 1825 | 29 |
1940937 | 1940937 | 2021-11-22 | Humboldt | Iowa | 19091 | 1825 | 29 |
1937687 | 1937687 | 2021-11-21 | Humboldt | Iowa | 19091 | 1825 | 29 |
1934437 | 1934437 | 2021-11-20 | Humboldt | Iowa | 19091 | 1825 | 29 |
1931186 | 1931186 | 2021-11-19 | Humboldt | Iowa | 19091 | 1825 | 29 |
1927935 | 1927935 | 2021-11-18 | Humboldt | Iowa | 19091 | 1825 | 29 |
1924685 | 1924685 | 2021-11-17 | Humboldt | Iowa | 19091 | 1825 | 29 |
1921436 | 1921436 | 2021-11-16 | Humboldt | Iowa | 19091 | 1789 | 29 |
1918186 | 1918186 | 2021-11-15 | Humboldt | Iowa | 19091 | 1789 | 29 |
1914936 | 1914936 | 2021-11-14 | Humboldt | Iowa | 19091 | 1789 | 29 |
1911686 | 1911686 | 2021-11-13 | Humboldt | Iowa | 19091 | 1789 | 29 |
1908437 | 1908437 | 2021-11-12 | Humboldt | Iowa | 19091 | 1789 | 29 |
1905188 | 1905188 | 2021-11-11 | Humboldt | Iowa | 19091 | 1789 | 29 |
1901938 | 1901938 | 2021-11-10 | Humboldt | Iowa | 19091 | 1789 | 29 |
1898688 | 1898688 | 2021-11-09 | Humboldt | Iowa | 19091 | 1762 | 28 |
1895438 | 1895438 | 2021-11-08 | Humboldt | Iowa | 19091 | 1762 | 28 |
1892188 | 1892188 | 2021-11-07 | Humboldt | Iowa | 19091 | 1762 | 28 |
1888938 | 1888938 | 2021-11-06 | Humboldt | Iowa | 19091 | 1762 | 28 |
1885688 | 1885688 | 2021-11-05 | Humboldt | Iowa | 19091 | 1762 | 28 |
1882439 | 1882439 | 2021-11-04 | Humboldt | Iowa | 19091 | 1762 | 28 |
1879190 | 1879190 | 2021-11-03 | Humboldt | Iowa | 19091 | 1762 | 28 |
1875941 | 1875941 | 2021-11-02 | Humboldt | Iowa | 19091 | 1715 | 27 |
1872692 | 1872692 | 2021-11-01 | Humboldt | Iowa | 19091 | 1715 | 27 |
1869443 | 1869443 | 2021-10-31 | Humboldt | Iowa | 19091 | 1715 | 27 |
1866194 | 1866194 | 2021-10-30 | Humboldt | Iowa | 19091 | 1715 | 27 |
1862945 | 1862945 | 2021-10-29 | Humboldt | Iowa | 19091 | 1715 | 27 |
1859696 | 1859696 | 2021-10-28 | Humboldt | Iowa | 19091 | 1715 | 27 |
1856447 | 1856447 | 2021-10-27 | Humboldt | Iowa | 19091 | 1715 | 27 |
1853198 | 1853198 | 2021-10-26 | Humboldt | Iowa | 19091 | 1677 | 27 |
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);