ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Clear Creek" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174450 | 2174450 | 2022-02-02 | Clear Creek | Colorado | 8019 | 1452 | 10 |
2171197 | 2171197 | 2022-02-01 | Clear Creek | Colorado | 8019 | 1445 | 10 |
2167944 | 2167944 | 2022-01-31 | Clear Creek | Colorado | 8019 | 1442 | 10 |
2164689 | 2164689 | 2022-01-30 | Clear Creek | Colorado | 8019 | 1435 | 10 |
2161434 | 2161434 | 2022-01-29 | Clear Creek | Colorado | 8019 | 1431 | 10 |
2158178 | 2158178 | 2022-01-28 | Clear Creek | Colorado | 8019 | 1435 | 10 |
2154925 | 2154925 | 2022-01-27 | Clear Creek | Colorado | 8019 | 1431 | 10 |
2151672 | 2151672 | 2022-01-26 | Clear Creek | Colorado | 8019 | 1421 | 10 |
2148420 | 2148420 | 2022-01-25 | Clear Creek | Colorado | 8019 | 1404 | 10 |
2145168 | 2145168 | 2022-01-24 | Clear Creek | Colorado | 8019 | 1394 | 10 |
2141913 | 2141913 | 2022-01-23 | Clear Creek | Colorado | 8019 | 1381 | 10 |
2138658 | 2138658 | 2022-01-22 | Clear Creek | Colorado | 8019 | 1381 | 10 |
2135402 | 2135402 | 2022-01-21 | Clear Creek | Colorado | 8019 | 1381 | 10 |
2132150 | 2132150 | 2022-01-20 | Clear Creek | Colorado | 8019 | 1355 | 10 |
2128897 | 2128897 | 2022-01-19 | Clear Creek | Colorado | 8019 | 1322 | 10 |
2125643 | 2125643 | 2022-01-18 | Clear Creek | Colorado | 8019 | 1315 | 10 |
2122391 | 2122391 | 2022-01-17 | Clear Creek | Colorado | 8019 | 1277 | 10 |
2119139 | 2119139 | 2022-01-16 | Clear Creek | Colorado | 8019 | 1254 | 10 |
2115887 | 2115887 | 2022-01-15 | Clear Creek | Colorado | 8019 | 1254 | 10 |
2112636 | 2112636 | 2022-01-14 | Clear Creek | Colorado | 8019 | 1254 | 10 |
2109384 | 2109384 | 2022-01-13 | Clear Creek | Colorado | 8019 | 1227 | 10 |
2106133 | 2106133 | 2022-01-12 | Clear Creek | Colorado | 8019 | 1193 | 9 |
2102882 | 2102882 | 2022-01-11 | Clear Creek | Colorado | 8019 | 1184 | 9 |
2099631 | 2099631 | 2022-01-10 | Clear Creek | Colorado | 8019 | 1161 | 9 |
2096380 | 2096380 | 2022-01-09 | Clear Creek | Colorado | 8019 | 1066 | 8 |
2093128 | 2093128 | 2022-01-08 | Clear Creek | Colorado | 8019 | 1066 | 8 |
2089876 | 2089876 | 2022-01-07 | Clear Creek | Colorado | 8019 | 1066 | 8 |
2086625 | 2086625 | 2022-01-06 | Clear Creek | Colorado | 8019 | 1064 | 8 |
2083373 | 2083373 | 2022-01-05 | Clear Creek | Colorado | 8019 | 1061 | 7 |
2080121 | 2080121 | 2022-01-04 | Clear Creek | Colorado | 8019 | 1046 | 7 |
2076869 | 2076869 | 2022-01-03 | Clear Creek | Colorado | 8019 | 1039 | 7 |
2073618 | 2073618 | 2022-01-02 | Clear Creek | Colorado | 8019 | 1006 | 7 |
2070367 | 2070367 | 2022-01-01 | Clear Creek | Colorado | 8019 | 1006 | 7 |
2067116 | 2067116 | 2021-12-31 | Clear Creek | Colorado | 8019 | 1006 | 7 |
2063865 | 2063865 | 2021-12-30 | Clear Creek | Colorado | 8019 | 986 | 7 |
2060615 | 2060615 | 2021-12-29 | Clear Creek | Colorado | 8019 | 979 | 7 |
2057366 | 2057366 | 2021-12-28 | Clear Creek | Colorado | 8019 | 972 | 7 |
2054117 | 2054117 | 2021-12-27 | Clear Creek | Colorado | 8019 | 967 | 7 |
2050867 | 2050867 | 2021-12-26 | Clear Creek | Colorado | 8019 | 954 | 7 |
2047617 | 2047617 | 2021-12-25 | Clear Creek | Colorado | 8019 | 954 | 7 |
2044367 | 2044367 | 2021-12-24 | Clear Creek | Colorado | 8019 | 954 | 7 |
2041118 | 2041118 | 2021-12-23 | Clear Creek | Colorado | 8019 | 947 | 7 |
2037868 | 2037868 | 2021-12-22 | Clear Creek | Colorado | 8019 | 941 | 7 |
2034618 | 2034618 | 2021-12-21 | Clear Creek | Colorado | 8019 | 940 | 7 |
2031368 | 2031368 | 2021-12-20 | Clear Creek | Colorado | 8019 | 935 | 7 |
2028117 | 2028117 | 2021-12-19 | Clear Creek | Colorado | 8019 | 929 | 7 |
2024866 | 2024866 | 2021-12-18 | Clear Creek | Colorado | 8019 | 929 | 7 |
2021615 | 2021615 | 2021-12-17 | Clear Creek | Colorado | 8019 | 929 | 7 |
2018364 | 2018364 | 2021-12-16 | Clear Creek | Colorado | 8019 | 925 | 7 |
2015114 | 2015114 | 2021-12-15 | Clear Creek | Colorado | 8019 | 923 | 7 |
2011863 | 2011863 | 2021-12-14 | Clear Creek | Colorado | 8019 | 921 | 7 |
2008612 | 2008612 | 2021-12-13 | Clear Creek | Colorado | 8019 | 920 | 7 |
2005361 | 2005361 | 2021-12-12 | Clear Creek | Colorado | 8019 | 917 | 7 |
2002110 | 2002110 | 2021-12-11 | Clear Creek | Colorado | 8019 | 917 | 7 |
1998860 | 1998860 | 2021-12-10 | Clear Creek | Colorado | 8019 | 917 | 7 |
1995609 | 1995609 | 2021-12-09 | Clear Creek | Colorado | 8019 | 914 | 7 |
1992358 | 1992358 | 2021-12-08 | Clear Creek | Colorado | 8019 | 911 | 7 |
1989107 | 1989107 | 2021-12-07 | Clear Creek | Colorado | 8019 | 910 | 7 |
1985857 | 1985857 | 2021-12-06 | Clear Creek | Colorado | 8019 | 904 | 6 |
1982607 | 1982607 | 2021-12-05 | Clear Creek | Colorado | 8019 | 899 | 6 |
1979357 | 1979357 | 2021-12-04 | Clear Creek | Colorado | 8019 | 899 | 6 |
1976107 | 1976107 | 2021-12-03 | Clear Creek | Colorado | 8019 | 899 | 6 |
1972858 | 1972858 | 2021-12-02 | Clear Creek | Colorado | 8019 | 895 | 6 |
1969608 | 1969608 | 2021-12-01 | Clear Creek | Colorado | 8019 | 895 | 6 |
1966358 | 1966358 | 2021-11-30 | Clear Creek | Colorado | 8019 | 894 | 6 |
1963106 | 1963106 | 2021-11-29 | Clear Creek | Colorado | 8019 | 891 | 6 |
1959855 | 1959855 | 2021-11-28 | Clear Creek | Colorado | 8019 | 885 | 6 |
1956604 | 1956604 | 2021-11-27 | Clear Creek | Colorado | 8019 | 884 | 6 |
1953353 | 1953353 | 2021-11-26 | Clear Creek | Colorado | 8019 | 884 | 6 |
1950102 | 1950102 | 2021-11-25 | Clear Creek | Colorado | 8019 | 884 | 6 |
1946851 | 1946851 | 2021-11-24 | Clear Creek | Colorado | 8019 | 878 | 6 |
1943600 | 1943600 | 2021-11-23 | Clear Creek | Colorado | 8019 | 875 | 6 |
1940350 | 1940350 | 2021-11-22 | Clear Creek | Colorado | 8019 | 875 | 6 |
1937100 | 1937100 | 2021-11-21 | Clear Creek | Colorado | 8019 | 862 | 6 |
1933850 | 1933850 | 2021-11-20 | Clear Creek | Colorado | 8019 | 862 | 6 |
1930598 | 1930598 | 2021-11-19 | Clear Creek | Colorado | 8019 | 862 | 6 |
1927348 | 1927348 | 2021-11-18 | Clear Creek | Colorado | 8019 | 857 | 6 |
1924098 | 1924098 | 2021-11-17 | Clear Creek | Colorado | 8019 | 845 | 6 |
1920849 | 1920849 | 2021-11-16 | Clear Creek | Colorado | 8019 | 840 | 6 |
1917599 | 1917599 | 2021-11-15 | Clear Creek | Colorado | 8019 | 836 | 6 |
1914349 | 1914349 | 2021-11-14 | Clear Creek | Colorado | 8019 | 823 | 6 |
1911099 | 1911099 | 2021-11-13 | Clear Creek | Colorado | 8019 | 823 | 6 |
1907850 | 1907850 | 2021-11-12 | Clear Creek | Colorado | 8019 | 823 | 6 |
1904601 | 1904601 | 2021-11-11 | Clear Creek | Colorado | 8019 | 820 | 6 |
1901351 | 1901351 | 2021-11-10 | Clear Creek | Colorado | 8019 | 815 | 6 |
1898101 | 1898101 | 2021-11-09 | Clear Creek | Colorado | 8019 | 811 | 6 |
1894851 | 1894851 | 2021-11-08 | Clear Creek | Colorado | 8019 | 811 | 5 |
1891601 | 1891601 | 2021-11-07 | Clear Creek | Colorado | 8019 | 804 | 5 |
1888351 | 1888351 | 2021-11-06 | Clear Creek | Colorado | 8019 | 804 | 5 |
1885101 | 1885101 | 2021-11-05 | Clear Creek | Colorado | 8019 | 804 | 5 |
1881852 | 1881852 | 2021-11-04 | Clear Creek | Colorado | 8019 | 799 | 5 |
1878603 | 1878603 | 2021-11-03 | Clear Creek | Colorado | 8019 | 797 | 5 |
1875354 | 1875354 | 2021-11-02 | Clear Creek | Colorado | 8019 | 793 | 5 |
1872105 | 1872105 | 2021-11-01 | Clear Creek | Colorado | 8019 | 791 | 5 |
1868856 | 1868856 | 2021-10-31 | Clear Creek | Colorado | 8019 | 779 | 5 |
1865607 | 1865607 | 2021-10-30 | Clear Creek | Colorado | 8019 | 779 | 5 |
1862358 | 1862358 | 2021-10-29 | Clear Creek | Colorado | 8019 | 779 | 5 |
1859109 | 1859109 | 2021-10-28 | Clear Creek | Colorado | 8019 | 779 | 5 |
1855860 | 1855860 | 2021-10-27 | Clear Creek | Colorado | 8019 | 775 | 5 |
1852611 | 1852611 | 2021-10-26 | Clear Creek | Colorado | 8019 | 774 | 5 |
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);