ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Washington" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174796 | 2174796 | 2022-02-02 | Washington | Idaho | 16087 | 2113 | 52 |
2171543 | 2171543 | 2022-02-01 | Washington | Idaho | 16087 | 2107 | 52 |
2168290 | 2168290 | 2022-01-31 | Washington | Idaho | 16087 | 2099 | 52 |
2165035 | 2165035 | 2022-01-30 | Washington | Idaho | 16087 | 2093 | 52 |
2161780 | 2161780 | 2022-01-29 | Washington | Idaho | 16087 | 2093 | 52 |
2158525 | 2158525 | 2022-01-28 | Washington | Idaho | 16087 | 2095 | 52 |
2155271 | 2155271 | 2022-01-27 | Washington | Idaho | 16087 | 2095 | 52 |
2152018 | 2152018 | 2022-01-26 | Washington | Idaho | 16087 | 2091 | 52 |
2148766 | 2148766 | 2022-01-25 | Washington | Idaho | 16087 | 2073 | 52 |
2145514 | 2145514 | 2022-01-24 | Washington | Idaho | 16087 | 2053 | 52 |
2142259 | 2142259 | 2022-01-23 | Washington | Idaho | 16087 | 2047 | 52 |
2139004 | 2139004 | 2022-01-22 | Washington | Idaho | 16087 | 2047 | 52 |
2135748 | 2135748 | 2022-01-21 | Washington | Idaho | 16087 | 2043 | 52 |
2132496 | 2132496 | 2022-01-20 | Washington | Idaho | 16087 | 2035 | 52 |
2129243 | 2129243 | 2022-01-19 | Washington | Idaho | 16087 | 2022 | 52 |
2125989 | 2125989 | 2022-01-18 | Washington | Idaho | 16087 | 2011 | 52 |
2122737 | 2122737 | 2022-01-17 | Washington | Idaho | 16087 | 1988 | 51 |
2119485 | 2119485 | 2022-01-16 | Washington | Idaho | 16087 | 1988 | 51 |
2116233 | 2116233 | 2022-01-15 | Washington | Idaho | 16087 | 1988 | 51 |
2112982 | 2112982 | 2022-01-14 | Washington | Idaho | 16087 | 1985 | 50 |
2109730 | 2109730 | 2022-01-13 | Washington | Idaho | 16087 | 1983 | 50 |
2106479 | 2106479 | 2022-01-12 | Washington | Idaho | 16087 | 1978 | 50 |
2103228 | 2103228 | 2022-01-11 | Washington | Idaho | 16087 | 1973 | 50 |
2099977 | 2099977 | 2022-01-10 | Washington | Idaho | 16087 | 1964 | 50 |
2096726 | 2096726 | 2022-01-09 | Washington | Idaho | 16087 | 1962 | 50 |
2093474 | 2093474 | 2022-01-08 | Washington | Idaho | 16087 | 1962 | 50 |
2090222 | 2090222 | 2022-01-07 | Washington | Idaho | 16087 | 1962 | 50 |
2086971 | 2086971 | 2022-01-06 | Washington | Idaho | 16087 | 1959 | 50 |
2083719 | 2083719 | 2022-01-05 | Washington | Idaho | 16087 | 1957 | 50 |
2080467 | 2080467 | 2022-01-04 | Washington | Idaho | 16087 | 1955 | 48 |
2077215 | 2077215 | 2022-01-03 | Washington | Idaho | 16087 | 1951 | 48 |
2073964 | 2073964 | 2022-01-02 | Washington | Idaho | 16087 | 1949 | 47 |
2070713 | 2070713 | 2022-01-01 | Washington | Idaho | 16087 | 1949 | 47 |
2067462 | 2067462 | 2021-12-31 | Washington | Idaho | 16087 | 1949 | 47 |
2064211 | 2064211 | 2021-12-30 | Washington | Idaho | 16087 | 1949 | 47 |
2060961 | 2060961 | 2021-12-29 | Washington | Idaho | 16087 | 1948 | 47 |
2057712 | 2057712 | 2021-12-28 | Washington | Idaho | 16087 | 1947 | 47 |
2054463 | 2054463 | 2021-12-27 | Washington | Idaho | 16087 | 1947 | 47 |
2051213 | 2051213 | 2021-12-26 | Washington | Idaho | 16087 | 1943 | 47 |
2047963 | 2047963 | 2021-12-25 | Washington | Idaho | 16087 | 1943 | 47 |
2044713 | 2044713 | 2021-12-24 | Washington | Idaho | 16087 | 1943 | 47 |
2041464 | 2041464 | 2021-12-23 | Washington | Idaho | 16087 | 1943 | 47 |
2038214 | 2038214 | 2021-12-22 | Washington | Idaho | 16087 | 1941 | 47 |
2034964 | 2034964 | 2021-12-21 | Washington | Idaho | 16087 | 1939 | 47 |
2031714 | 2031714 | 2021-12-20 | Washington | Idaho | 16087 | 1939 | 47 |
2028463 | 2028463 | 2021-12-19 | Washington | Idaho | 16087 | 1939 | 47 |
2025212 | 2025212 | 2021-12-18 | Washington | Idaho | 16087 | 1939 | 47 |
2021961 | 2021961 | 2021-12-17 | Washington | Idaho | 16087 | 1937 | 47 |
2018710 | 2018710 | 2021-12-16 | Washington | Idaho | 16087 | 1937 | 47 |
2015460 | 2015460 | 2021-12-15 | Washington | Idaho | 16087 | 1937 | 47 |
2012209 | 2012209 | 2021-12-14 | Washington | Idaho | 16087 | 1936 | 47 |
2008958 | 2008958 | 2021-12-13 | Washington | Idaho | 16087 | 1934 | 47 |
2005707 | 2005707 | 2021-12-12 | Washington | Idaho | 16087 | 1932 | 47 |
2002456 | 2002456 | 2021-12-11 | Washington | Idaho | 16087 | 1932 | 47 |
1999206 | 1999206 | 2021-12-10 | Washington | Idaho | 16087 | 1930 | 47 |
1995955 | 1995955 | 2021-12-09 | Washington | Idaho | 16087 | 1930 | 47 |
1992704 | 1992704 | 2021-12-08 | Washington | Idaho | 16087 | 1930 | 47 |
1989453 | 1989453 | 2021-12-07 | Washington | Idaho | 16087 | 1929 | 47 |
1986203 | 1986203 | 2021-12-06 | Washington | Idaho | 16087 | 1927 | 47 |
1982953 | 1982953 | 2021-12-05 | Washington | Idaho | 16087 | 1922 | 47 |
1979703 | 1979703 | 2021-12-04 | Washington | Idaho | 16087 | 1922 | 47 |
1976453 | 1976453 | 2021-12-03 | Washington | Idaho | 16087 | 1919 | 47 |
1973204 | 1973204 | 2021-12-02 | Washington | Idaho | 16087 | 1919 | 47 |
1969954 | 1969954 | 2021-12-01 | Washington | Idaho | 16087 | 1914 | 47 |
1966704 | 1966704 | 2021-11-30 | Washington | Idaho | 16087 | 1913 | 47 |
1963452 | 1963452 | 2021-11-29 | Washington | Idaho | 16087 | 1912 | 47 |
1960201 | 1960201 | 2021-11-28 | Washington | Idaho | 16087 | 1913 | 47 |
1956950 | 1956950 | 2021-11-27 | Washington | Idaho | 16087 | 1913 | 47 |
1953699 | 1953699 | 2021-11-26 | Washington | Idaho | 16087 | 1913 | 47 |
1950448 | 1950448 | 2021-11-25 | Washington | Idaho | 16087 | 1913 | 47 |
1947197 | 1947197 | 2021-11-24 | Washington | Idaho | 16087 | 1913 | 47 |
1943946 | 1943946 | 2021-11-23 | Washington | Idaho | 16087 | 1913 | 47 |
1940696 | 1940696 | 2021-11-22 | Washington | Idaho | 16087 | 1912 | 47 |
1937446 | 1937446 | 2021-11-21 | Washington | Idaho | 16087 | 1910 | 47 |
1934196 | 1934196 | 2021-11-20 | Washington | Idaho | 16087 | 1910 | 47 |
1930945 | 1930945 | 2021-11-19 | Washington | Idaho | 16087 | 1909 | 47 |
1927694 | 1927694 | 2021-11-18 | Washington | Idaho | 16087 | 1909 | 47 |
1924444 | 1924444 | 2021-11-17 | Washington | Idaho | 16087 | 1905 | 47 |
1921195 | 1921195 | 2021-11-16 | Washington | Idaho | 16087 | 1904 | 47 |
1917945 | 1917945 | 2021-11-15 | Washington | Idaho | 16087 | 1903 | 47 |
1914695 | 1914695 | 2021-11-14 | Washington | Idaho | 16087 | 1899 | 47 |
1911445 | 1911445 | 2021-11-13 | Washington | Idaho | 16087 | 1898 | 47 |
1908196 | 1908196 | 2021-11-12 | Washington | Idaho | 16087 | 1896 | 47 |
1904947 | 1904947 | 2021-11-11 | Washington | Idaho | 16087 | 1896 | 47 |
1901697 | 1901697 | 2021-11-10 | Washington | Idaho | 16087 | 1896 | 47 |
1898447 | 1898447 | 2021-11-09 | Washington | Idaho | 16087 | 1896 | 47 |
1895197 | 1895197 | 2021-11-08 | Washington | Idaho | 16087 | 1892 | 47 |
1891947 | 1891947 | 2021-11-07 | Washington | Idaho | 16087 | 1892 | 47 |
1888697 | 1888697 | 2021-11-06 | Washington | Idaho | 16087 | 1892 | 47 |
1885447 | 1885447 | 2021-11-05 | Washington | Idaho | 16087 | 1892 | 47 |
1882198 | 1882198 | 2021-11-04 | Washington | Idaho | 16087 | 1891 | 47 |
1878949 | 1878949 | 2021-11-03 | Washington | Idaho | 16087 | 1892 | 47 |
1875700 | 1875700 | 2021-11-02 | Washington | Idaho | 16087 | 1888 | 47 |
1872451 | 1872451 | 2021-11-01 | Washington | Idaho | 16087 | 1874 | 47 |
1869202 | 1869202 | 2021-10-31 | Washington | Idaho | 16087 | 1873 | 46 |
1865953 | 1865953 | 2021-10-30 | Washington | Idaho | 16087 | 1873 | 46 |
1862704 | 1862704 | 2021-10-29 | Washington | Idaho | 16087 | 1872 | 46 |
1859455 | 1859455 | 2021-10-28 | Washington | Idaho | 16087 | 1866 | 46 |
1856206 | 1856206 | 2021-10-27 | Washington | Idaho | 16087 | 1862 | 46 |
1852957 | 1852957 | 2021-10-26 | Washington | Idaho | 16087 | 1846 | 46 |
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);