ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
687 rows where county = "Clearwater" and fips = 16035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174770 | 2174770 | 2022-02-02 | Clearwater | Idaho | 16035 | 2118 | 31 |
2171517 | 2171517 | 2022-02-01 | Clearwater | Idaho | 16035 | 2113 | 29 |
2168264 | 2168264 | 2022-01-31 | Clearwater | Idaho | 16035 | 2110 | 29 |
2165009 | 2165009 | 2022-01-30 | Clearwater | Idaho | 16035 | 2099 | 29 |
2161754 | 2161754 | 2022-01-29 | Clearwater | Idaho | 16035 | 2099 | 29 |
2158498 | 2158498 | 2022-01-28 | Clearwater | Idaho | 16035 | 2051 | 29 |
2155245 | 2155245 | 2022-01-27 | Clearwater | Idaho | 16035 | 2051 | 29 |
2151992 | 2151992 | 2022-01-26 | Clearwater | Idaho | 16035 | 2039 | 29 |
2148740 | 2148740 | 2022-01-25 | Clearwater | Idaho | 16035 | 2032 | 29 |
2145488 | 2145488 | 2022-01-24 | Clearwater | Idaho | 16035 | 1999 | 29 |
2142233 | 2142233 | 2022-01-23 | Clearwater | Idaho | 16035 | 1986 | 29 |
2138978 | 2138978 | 2022-01-22 | Clearwater | Idaho | 16035 | 1986 | 29 |
2135722 | 2135722 | 2022-01-21 | Clearwater | Idaho | 16035 | 1981 | 29 |
2132470 | 2132470 | 2022-01-20 | Clearwater | Idaho | 16035 | 1942 | 29 |
2129217 | 2129217 | 2022-01-19 | Clearwater | Idaho | 16035 | 1930 | 29 |
2125963 | 2125963 | 2022-01-18 | Clearwater | Idaho | 16035 | 1882 | 29 |
2122711 | 2122711 | 2022-01-17 | Clearwater | Idaho | 16035 | 1859 | 29 |
2119459 | 2119459 | 2022-01-16 | Clearwater | Idaho | 16035 | 1859 | 29 |
2116207 | 2116207 | 2022-01-15 | Clearwater | Idaho | 16035 | 1859 | 29 |
2112956 | 2112956 | 2022-01-14 | Clearwater | Idaho | 16035 | 1859 | 29 |
2109704 | 2109704 | 2022-01-13 | Clearwater | Idaho | 16035 | 1840 | 29 |
2106453 | 2106453 | 2022-01-12 | Clearwater | Idaho | 16035 | 1828 | 29 |
2103202 | 2103202 | 2022-01-11 | Clearwater | Idaho | 16035 | 1809 | 29 |
2099951 | 2099951 | 2022-01-10 | Clearwater | Idaho | 16035 | 1800 | 29 |
2096700 | 2096700 | 2022-01-09 | Clearwater | Idaho | 16035 | 1786 | 29 |
2093448 | 2093448 | 2022-01-08 | Clearwater | Idaho | 16035 | 1786 | 29 |
2090196 | 2090196 | 2022-01-07 | Clearwater | Idaho | 16035 | 1786 | 29 |
2086945 | 2086945 | 2022-01-06 | Clearwater | Idaho | 16035 | 1782 | 29 |
2083693 | 2083693 | 2022-01-05 | Clearwater | Idaho | 16035 | 1773 | 28 |
2080441 | 2080441 | 2022-01-04 | Clearwater | Idaho | 16035 | 1763 | 28 |
2077189 | 2077189 | 2022-01-03 | Clearwater | Idaho | 16035 | 1760 | 28 |
2073938 | 2073938 | 2022-01-02 | Clearwater | Idaho | 16035 | 1760 | 28 |
2070687 | 2070687 | 2022-01-01 | Clearwater | Idaho | 16035 | 1760 | 28 |
2067436 | 2067436 | 2021-12-31 | Clearwater | Idaho | 16035 | 1760 | 28 |
2064185 | 2064185 | 2021-12-30 | Clearwater | Idaho | 16035 | 1760 | 28 |
2060935 | 2060935 | 2021-12-29 | Clearwater | Idaho | 16035 | 1759 | 28 |
2057686 | 2057686 | 2021-12-28 | Clearwater | Idaho | 16035 | 1749 | 28 |
2054437 | 2054437 | 2021-12-27 | Clearwater | Idaho | 16035 | 1749 | 28 |
2051187 | 2051187 | 2021-12-26 | Clearwater | Idaho | 16035 | 1744 | 28 |
2047937 | 2047937 | 2021-12-25 | Clearwater | Idaho | 16035 | 1744 | 28 |
2044687 | 2044687 | 2021-12-24 | Clearwater | Idaho | 16035 | 1744 | 28 |
2041438 | 2041438 | 2021-12-23 | Clearwater | Idaho | 16035 | 1744 | 28 |
2038188 | 2038188 | 2021-12-22 | Clearwater | Idaho | 16035 | 1743 | 28 |
2034938 | 2034938 | 2021-12-21 | Clearwater | Idaho | 16035 | 1738 | 27 |
2031688 | 2031688 | 2021-12-20 | Clearwater | Idaho | 16035 | 1738 | 27 |
2028437 | 2028437 | 2021-12-19 | Clearwater | Idaho | 16035 | 1735 | 27 |
2025186 | 2025186 | 2021-12-18 | Clearwater | Idaho | 16035 | 1735 | 27 |
2021935 | 2021935 | 2021-12-17 | Clearwater | Idaho | 16035 | 1735 | 27 |
2018684 | 2018684 | 2021-12-16 | Clearwater | Idaho | 16035 | 1733 | 27 |
2015434 | 2015434 | 2021-12-15 | Clearwater | Idaho | 16035 | 1733 | 27 |
2012183 | 2012183 | 2021-12-14 | Clearwater | Idaho | 16035 | 1733 | 27 |
2008932 | 2008932 | 2021-12-13 | Clearwater | Idaho | 16035 | 1732 | 27 |
2005681 | 2005681 | 2021-12-12 | Clearwater | Idaho | 16035 | 1732 | 27 |
2002430 | 2002430 | 2021-12-11 | Clearwater | Idaho | 16035 | 1732 | 27 |
1999180 | 1999180 | 2021-12-10 | Clearwater | Idaho | 16035 | 1732 | 27 |
1995929 | 1995929 | 2021-12-09 | Clearwater | Idaho | 16035 | 1728 | 27 |
1992678 | 1992678 | 2021-12-08 | Clearwater | Idaho | 16035 | 1717 | 27 |
1989427 | 1989427 | 2021-12-07 | Clearwater | Idaho | 16035 | 1699 | 27 |
1986177 | 1986177 | 2021-12-06 | Clearwater | Idaho | 16035 | 1695 | 27 |
1982927 | 1982927 | 2021-12-05 | Clearwater | Idaho | 16035 | 1692 | 27 |
1979677 | 1979677 | 2021-12-04 | Clearwater | Idaho | 16035 | 1692 | 27 |
1976427 | 1976427 | 2021-12-03 | Clearwater | Idaho | 16035 | 1688 | 27 |
1973178 | 1973178 | 2021-12-02 | Clearwater | Idaho | 16035 | 1688 | 27 |
1969928 | 1969928 | 2021-12-01 | Clearwater | Idaho | 16035 | 1685 | 27 |
1966678 | 1966678 | 2021-11-30 | Clearwater | Idaho | 16035 | 1681 | 27 |
1963426 | 1963426 | 2021-11-29 | Clearwater | Idaho | 16035 | 1678 | 27 |
1960175 | 1960175 | 2021-11-28 | Clearwater | Idaho | 16035 | 1670 | 27 |
1956924 | 1956924 | 2021-11-27 | Clearwater | Idaho | 16035 | 1670 | 27 |
1953673 | 1953673 | 2021-11-26 | Clearwater | Idaho | 16035 | 1670 | 27 |
1950422 | 1950422 | 2021-11-25 | Clearwater | Idaho | 16035 | 1668 | 27 |
1947171 | 1947171 | 2021-11-24 | Clearwater | Idaho | 16035 | 1668 | 27 |
1943920 | 1943920 | 2021-11-23 | Clearwater | Idaho | 16035 | 1665 | 27 |
1940670 | 1940670 | 2021-11-22 | Clearwater | Idaho | 16035 | 1661 | 26 |
1937420 | 1937420 | 2021-11-21 | Clearwater | Idaho | 16035 | 1656 | 26 |
1934170 | 1934170 | 2021-11-20 | Clearwater | Idaho | 16035 | 1656 | 26 |
1930918 | 1930918 | 2021-11-19 | Clearwater | Idaho | 16035 | 1656 | 26 |
1927668 | 1927668 | 2021-11-18 | Clearwater | Idaho | 16035 | 1656 | 26 |
1924418 | 1924418 | 2021-11-17 | Clearwater | Idaho | 16035 | 1655 | 26 |
1921169 | 1921169 | 2021-11-16 | Clearwater | Idaho | 16035 | 1655 | 26 |
1917919 | 1917919 | 2021-11-15 | Clearwater | Idaho | 16035 | 1654 | 26 |
1914669 | 1914669 | 2021-11-14 | Clearwater | Idaho | 16035 | 1651 | 26 |
1911419 | 1911419 | 2021-11-13 | Clearwater | Idaho | 16035 | 1651 | 26 |
1908170 | 1908170 | 2021-11-12 | Clearwater | Idaho | 16035 | 1642 | 26 |
1904921 | 1904921 | 2021-11-11 | Clearwater | Idaho | 16035 | 1642 | 26 |
1901671 | 1901671 | 2021-11-10 | Clearwater | Idaho | 16035 | 1642 | 26 |
1898421 | 1898421 | 2021-11-09 | Clearwater | Idaho | 16035 | 1639 | 26 |
1895171 | 1895171 | 2021-11-08 | Clearwater | Idaho | 16035 | 1638 | 26 |
1891921 | 1891921 | 2021-11-07 | Clearwater | Idaho | 16035 | 1626 | 26 |
1888671 | 1888671 | 2021-11-06 | Clearwater | Idaho | 16035 | 1626 | 26 |
1885421 | 1885421 | 2021-11-05 | Clearwater | Idaho | 16035 | 1626 | 26 |
1882172 | 1882172 | 2021-11-04 | Clearwater | Idaho | 16035 | 1626 | 26 |
1878923 | 1878923 | 2021-11-03 | Clearwater | Idaho | 16035 | 1623 | 26 |
1875674 | 1875674 | 2021-11-02 | Clearwater | Idaho | 16035 | 1620 | 26 |
1872425 | 1872425 | 2021-11-01 | Clearwater | Idaho | 16035 | 1617 | 26 |
1869176 | 1869176 | 2021-10-31 | Clearwater | Idaho | 16035 | 1614 | 26 |
1865927 | 1865927 | 2021-10-30 | Clearwater | Idaho | 16035 | 1614 | 26 |
1862678 | 1862678 | 2021-10-29 | Clearwater | Idaho | 16035 | 1614 | 26 |
1859429 | 1859429 | 2021-10-28 | Clearwater | Idaho | 16035 | 1614 | 26 |
1856180 | 1856180 | 2021-10-27 | Clearwater | Idaho | 16035 | 1610 | 26 |
1852931 | 1852931 | 2021-10-26 | Clearwater | Idaho | 16035 | 1609 | 25 |
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);