ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Buchanan" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109935 | 2109935 | 2022-01-13 | Buchanan | Iowa | 19019 | 3808 | 46 |
2106684 | 2106684 | 2022-01-12 | Buchanan | Iowa | 19019 | 3808 | 46 |
2103433 | 2103433 | 2022-01-11 | Buchanan | Iowa | 19019 | 3619 | 46 |
2100182 | 2100182 | 2022-01-10 | Buchanan | Iowa | 19019 | 3619 | 46 |
2096931 | 2096931 | 2022-01-09 | Buchanan | Iowa | 19019 | 3619 | 46 |
2093679 | 2093679 | 2022-01-08 | Buchanan | Iowa | 19019 | 3619 | 46 |
2090427 | 2090427 | 2022-01-07 | Buchanan | Iowa | 19019 | 3619 | 46 |
2087176 | 2087176 | 2022-01-06 | Buchanan | Iowa | 19019 | 3619 | 46 |
2083924 | 2083924 | 2022-01-05 | Buchanan | Iowa | 19019 | 3619 | 46 |
2080672 | 2080672 | 2022-01-04 | Buchanan | Iowa | 19019 | 3521 | 44 |
2077420 | 2077420 | 2022-01-03 | Buchanan | Iowa | 19019 | 3521 | 44 |
2074169 | 2074169 | 2022-01-02 | Buchanan | Iowa | 19019 | 3521 | 44 |
2070918 | 2070918 | 2022-01-01 | Buchanan | Iowa | 19019 | 3521 | 44 |
2067667 | 2067667 | 2021-12-31 | Buchanan | Iowa | 19019 | 3521 | 44 |
2064416 | 2064416 | 2021-12-30 | Buchanan | Iowa | 19019 | 3521 | 44 |
2061166 | 2061166 | 2021-12-29 | Buchanan | Iowa | 19019 | 3521 | 44 |
2057917 | 2057917 | 2021-12-28 | Buchanan | Iowa | 19019 | 3472 | 44 |
2054668 | 2054668 | 2021-12-27 | Buchanan | Iowa | 19019 | 3472 | 44 |
2051418 | 2051418 | 2021-12-26 | Buchanan | Iowa | 19019 | 3472 | 44 |
2048168 | 2048168 | 2021-12-25 | Buchanan | Iowa | 19019 | 3472 | 44 |
2044918 | 2044918 | 2021-12-24 | Buchanan | Iowa | 19019 | 3472 | 44 |
2041669 | 2041669 | 2021-12-23 | Buchanan | Iowa | 19019 | 3472 | 44 |
2038419 | 2038419 | 2021-12-22 | Buchanan | Iowa | 19019 | 3472 | 44 |
2035169 | 2035169 | 2021-12-21 | Buchanan | Iowa | 19019 | 3381 | 43 |
2031919 | 2031919 | 2021-12-20 | Buchanan | Iowa | 19019 | 3381 | 43 |
2028668 | 2028668 | 2021-12-19 | Buchanan | Iowa | 19019 | 3381 | 43 |
2025417 | 2025417 | 2021-12-18 | Buchanan | Iowa | 19019 | 3381 | 43 |
2022166 | 2022166 | 2021-12-17 | Buchanan | Iowa | 19019 | 3381 | 43 |
2018915 | 2018915 | 2021-12-16 | Buchanan | Iowa | 19019 | 3381 | 43 |
2015665 | 2015665 | 2021-12-15 | Buchanan | Iowa | 19019 | 3381 | 43 |
2012414 | 2012414 | 2021-12-14 | Buchanan | Iowa | 19019 | 3283 | 43 |
2009163 | 2009163 | 2021-12-13 | Buchanan | Iowa | 19019 | 3283 | 43 |
2005912 | 2005912 | 2021-12-12 | Buchanan | Iowa | 19019 | 3283 | 43 |
2002661 | 2002661 | 2021-12-11 | Buchanan | Iowa | 19019 | 3283 | 43 |
1999411 | 1999411 | 2021-12-10 | Buchanan | Iowa | 19019 | 3283 | 43 |
1996160 | 1996160 | 2021-12-09 | Buchanan | Iowa | 19019 | 3283 | 43 |
1992909 | 1992909 | 2021-12-08 | Buchanan | Iowa | 19019 | 3283 | 43 |
1989658 | 1989658 | 2021-12-07 | Buchanan | Iowa | 19019 | 3150 | 43 |
1986408 | 1986408 | 2021-12-06 | Buchanan | Iowa | 19019 | 3150 | 43 |
1983158 | 1983158 | 2021-12-05 | Buchanan | Iowa | 19019 | 3150 | 43 |
1979908 | 1979908 | 2021-12-04 | Buchanan | Iowa | 19019 | 3150 | 43 |
1976658 | 1976658 | 2021-12-03 | Buchanan | Iowa | 19019 | 3150 | 43 |
1973409 | 1973409 | 2021-12-02 | Buchanan | Iowa | 19019 | 3150 | 43 |
1970159 | 1970159 | 2021-12-01 | Buchanan | Iowa | 19019 | 3150 | 43 |
1966909 | 1966909 | 2021-11-30 | Buchanan | Iowa | 19019 | 3067 | 41 |
1963657 | 1963657 | 2021-11-29 | Buchanan | Iowa | 19019 | 3067 | 41 |
1960406 | 1960406 | 2021-11-28 | Buchanan | Iowa | 19019 | 3067 | 41 |
1957155 | 1957155 | 2021-11-27 | Buchanan | Iowa | 19019 | 3067 | 41 |
1953904 | 1953904 | 2021-11-26 | Buchanan | Iowa | 19019 | 3067 | 41 |
1950653 | 1950653 | 2021-11-25 | Buchanan | Iowa | 19019 | 3067 | 41 |
1947402 | 1947402 | 2021-11-24 | Buchanan | Iowa | 19019 | 3067 | 41 |
1944151 | 1944151 | 2021-11-23 | Buchanan | Iowa | 19019 | 2995 | 39 |
1940901 | 1940901 | 2021-11-22 | Buchanan | Iowa | 19019 | 2995 | 39 |
1937651 | 1937651 | 2021-11-21 | Buchanan | Iowa | 19019 | 2995 | 39 |
1934401 | 1934401 | 2021-11-20 | Buchanan | Iowa | 19019 | 2995 | 39 |
1931150 | 1931150 | 2021-11-19 | Buchanan | Iowa | 19019 | 2995 | 39 |
1927899 | 1927899 | 2021-11-18 | Buchanan | Iowa | 19019 | 2995 | 39 |
1924649 | 1924649 | 2021-11-17 | Buchanan | Iowa | 19019 | 2995 | 39 |
1921400 | 1921400 | 2021-11-16 | Buchanan | Iowa | 19019 | 2946 | 39 |
1918150 | 1918150 | 2021-11-15 | Buchanan | Iowa | 19019 | 2946 | 39 |
1914900 | 1914900 | 2021-11-14 | Buchanan | Iowa | 19019 | 2946 | 39 |
1911650 | 1911650 | 2021-11-13 | Buchanan | Iowa | 19019 | 2946 | 39 |
1908401 | 1908401 | 2021-11-12 | Buchanan | Iowa | 19019 | 2946 | 39 |
1905152 | 1905152 | 2021-11-11 | Buchanan | Iowa | 19019 | 2946 | 39 |
1901902 | 1901902 | 2021-11-10 | Buchanan | Iowa | 19019 | 2946 | 39 |
1898652 | 1898652 | 2021-11-09 | Buchanan | Iowa | 19019 | 2903 | 39 |
1895402 | 1895402 | 2021-11-08 | Buchanan | Iowa | 19019 | 2903 | 39 |
1892152 | 1892152 | 2021-11-07 | Buchanan | Iowa | 19019 | 2903 | 39 |
1888902 | 1888902 | 2021-11-06 | Buchanan | Iowa | 19019 | 2903 | 39 |
1885652 | 1885652 | 2021-11-05 | Buchanan | Iowa | 19019 | 2903 | 39 |
1882403 | 1882403 | 2021-11-04 | Buchanan | Iowa | 19019 | 2903 | 39 |
1879154 | 1879154 | 2021-11-03 | Buchanan | Iowa | 19019 | 2903 | 39 |
1875905 | 1875905 | 2021-11-02 | Buchanan | Iowa | 19019 | 2819 | 39 |
1872656 | 1872656 | 2021-11-01 | Buchanan | Iowa | 19019 | 2819 | 39 |
1869407 | 1869407 | 2021-10-31 | Buchanan | Iowa | 19019 | 2819 | 39 |
1866158 | 1866158 | 2021-10-30 | Buchanan | Iowa | 19019 | 2819 | 39 |
1862909 | 1862909 | 2021-10-29 | Buchanan | Iowa | 19019 | 2819 | 39 |
1859660 | 1859660 | 2021-10-28 | Buchanan | Iowa | 19019 | 2819 | 39 |
1856411 | 1856411 | 2021-10-27 | Buchanan | Iowa | 19019 | 2819 | 39 |
1853162 | 1853162 | 2021-10-26 | Buchanan | Iowa | 19019 | 2790 | 39 |
1849913 | 1849913 | 2021-10-25 | Buchanan | Iowa | 19019 | 2790 | 39 |
1846663 | 1846663 | 2021-10-24 | Buchanan | Iowa | 19019 | 2790 | 39 |
1843413 | 1843413 | 2021-10-23 | Buchanan | Iowa | 19019 | 2790 | 39 |
1840163 | 1840163 | 2021-10-22 | Buchanan | Iowa | 19019 | 2790 | 39 |
1836914 | 1836914 | 2021-10-21 | Buchanan | Iowa | 19019 | 2790 | 39 |
1833665 | 1833665 | 2021-10-20 | Buchanan | Iowa | 19019 | 2790 | 39 |
1830416 | 1830416 | 2021-10-19 | Buchanan | Iowa | 19019 | 2744 | 39 |
1827167 | 1827167 | 2021-10-18 | Buchanan | Iowa | 19019 | 2744 | 39 |
1823918 | 1823918 | 2021-10-17 | Buchanan | Iowa | 19019 | 2744 | 39 |
1820669 | 1820669 | 2021-10-16 | Buchanan | Iowa | 19019 | 2744 | 39 |
1817420 | 1817420 | 2021-10-15 | Buchanan | Iowa | 19019 | 2744 | 39 |
1814172 | 1814172 | 2021-10-14 | Buchanan | Iowa | 19019 | 2744 | 39 |
1810923 | 1810923 | 2021-10-13 | Buchanan | Iowa | 19019 | 2744 | 39 |
1807674 | 1807674 | 2021-10-12 | Buchanan | Iowa | 19019 | 2654 | 39 |
1804423 | 1804423 | 2021-10-11 | Buchanan | Iowa | 19019 | 2654 | 39 |
1801174 | 1801174 | 2021-10-10 | Buchanan | Iowa | 19019 | 2654 | 39 |
1797925 | 1797925 | 2021-10-09 | Buchanan | Iowa | 19019 | 2654 | 39 |
1794676 | 1794676 | 2021-10-08 | Buchanan | Iowa | 19019 | 2654 | 39 |
1791428 | 1791428 | 2021-10-07 | Buchanan | Iowa | 19019 | 2654 | 39 |
1788179 | 1788179 | 2021-10-06 | Buchanan | Iowa | 19019 | 2654 | 39 |
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);