ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Hinsdale" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174467 | 2174467 | 2022-02-02 | Hinsdale | Colorado | 8053 | 117 | 0 |
2171214 | 2171214 | 2022-02-01 | Hinsdale | Colorado | 8053 | 117 | 0 |
2167961 | 2167961 | 2022-01-31 | Hinsdale | Colorado | 8053 | 117 | 0 |
2164706 | 2164706 | 2022-01-30 | Hinsdale | Colorado | 8053 | 117 | 0 |
2161451 | 2161451 | 2022-01-29 | Hinsdale | Colorado | 8053 | 117 | 0 |
2158195 | 2158195 | 2022-01-28 | Hinsdale | Colorado | 8053 | 117 | 0 |
2154942 | 2154942 | 2022-01-27 | Hinsdale | Colorado | 8053 | 117 | 0 |
2151689 | 2151689 | 2022-01-26 | Hinsdale | Colorado | 8053 | 114 | 0 |
2148437 | 2148437 | 2022-01-25 | Hinsdale | Colorado | 8053 | 114 | 0 |
2145185 | 2145185 | 2022-01-24 | Hinsdale | Colorado | 8053 | 109 | 0 |
2141930 | 2141930 | 2022-01-23 | Hinsdale | Colorado | 8053 | 106 | 0 |
2138675 | 2138675 | 2022-01-22 | Hinsdale | Colorado | 8053 | 106 | 0 |
2135419 | 2135419 | 2022-01-21 | Hinsdale | Colorado | 8053 | 106 | 0 |
2132167 | 2132167 | 2022-01-20 | Hinsdale | Colorado | 8053 | 106 | 0 |
2128914 | 2128914 | 2022-01-19 | Hinsdale | Colorado | 8053 | 106 | 0 |
2125660 | 2125660 | 2022-01-18 | Hinsdale | Colorado | 8053 | 104 | 0 |
2122408 | 2122408 | 2022-01-17 | Hinsdale | Colorado | 8053 | 104 | 0 |
2119156 | 2119156 | 2022-01-16 | Hinsdale | Colorado | 8053 | 98 | 0 |
2115904 | 2115904 | 2022-01-15 | Hinsdale | Colorado | 8053 | 98 | 0 |
2112653 | 2112653 | 2022-01-14 | Hinsdale | Colorado | 8053 | 98 | 0 |
2109401 | 2109401 | 2022-01-13 | Hinsdale | Colorado | 8053 | 94 | 0 |
2106150 | 2106150 | 2022-01-12 | Hinsdale | Colorado | 8053 | 94 | 0 |
2102899 | 2102899 | 2022-01-11 | Hinsdale | Colorado | 8053 | 81 | 0 |
2099648 | 2099648 | 2022-01-10 | Hinsdale | Colorado | 8053 | 78 | 0 |
2096397 | 2096397 | 2022-01-09 | Hinsdale | Colorado | 8053 | 73 | 0 |
2093145 | 2093145 | 2022-01-08 | Hinsdale | Colorado | 8053 | 73 | 0 |
2089893 | 2089893 | 2022-01-07 | Hinsdale | Colorado | 8053 | 73 | 0 |
2086642 | 2086642 | 2022-01-06 | Hinsdale | Colorado | 8053 | 73 | 0 |
2083390 | 2083390 | 2022-01-05 | Hinsdale | Colorado | 8053 | 72 | 0 |
2080138 | 2080138 | 2022-01-04 | Hinsdale | Colorado | 8053 | 71 | 0 |
2076886 | 2076886 | 2022-01-03 | Hinsdale | Colorado | 8053 | 70 | 0 |
2073635 | 2073635 | 2022-01-02 | Hinsdale | Colorado | 8053 | 70 | 0 |
2070384 | 2070384 | 2022-01-01 | Hinsdale | Colorado | 8053 | 70 | 0 |
2067133 | 2067133 | 2021-12-31 | Hinsdale | Colorado | 8053 | 70 | 0 |
2063882 | 2063882 | 2021-12-30 | Hinsdale | Colorado | 8053 | 69 | 0 |
2060632 | 2060632 | 2021-12-29 | Hinsdale | Colorado | 8053 | 69 | 0 |
2057383 | 2057383 | 2021-12-28 | Hinsdale | Colorado | 8053 | 69 | 0 |
2054134 | 2054134 | 2021-12-27 | Hinsdale | Colorado | 8053 | 69 | 0 |
2050884 | 2050884 | 2021-12-26 | Hinsdale | Colorado | 8053 | 69 | 0 |
2047634 | 2047634 | 2021-12-25 | Hinsdale | Colorado | 8053 | 69 | 0 |
2044384 | 2044384 | 2021-12-24 | Hinsdale | Colorado | 8053 | 69 | 0 |
2041135 | 2041135 | 2021-12-23 | Hinsdale | Colorado | 8053 | 69 | 0 |
2037885 | 2037885 | 2021-12-22 | Hinsdale | Colorado | 8053 | 69 | 0 |
2034635 | 2034635 | 2021-12-21 | Hinsdale | Colorado | 8053 | 69 | 0 |
2031385 | 2031385 | 2021-12-20 | Hinsdale | Colorado | 8053 | 68 | 0 |
2028134 | 2028134 | 2021-12-19 | Hinsdale | Colorado | 8053 | 68 | 0 |
2024883 | 2024883 | 2021-12-18 | Hinsdale | Colorado | 8053 | 68 | 0 |
2021632 | 2021632 | 2021-12-17 | Hinsdale | Colorado | 8053 | 68 | 0 |
2018381 | 2018381 | 2021-12-16 | Hinsdale | Colorado | 8053 | 68 | 0 |
2015131 | 2015131 | 2021-12-15 | Hinsdale | Colorado | 8053 | 67 | 0 |
2011880 | 2011880 | 2021-12-14 | Hinsdale | Colorado | 8053 | 65 | 0 |
2008629 | 2008629 | 2021-12-13 | Hinsdale | Colorado | 8053 | 65 | 0 |
2005378 | 2005378 | 2021-12-12 | Hinsdale | Colorado | 8053 | 65 | 0 |
2002127 | 2002127 | 2021-12-11 | Hinsdale | Colorado | 8053 | 65 | 0 |
1998877 | 1998877 | 2021-12-10 | Hinsdale | Colorado | 8053 | 65 | 0 |
1995626 | 1995626 | 2021-12-09 | Hinsdale | Colorado | 8053 | 65 | 0 |
1992375 | 1992375 | 2021-12-08 | Hinsdale | Colorado | 8053 | 65 | 0 |
1989124 | 1989124 | 2021-12-07 | Hinsdale | Colorado | 8053 | 65 | 0 |
1985874 | 1985874 | 2021-12-06 | Hinsdale | Colorado | 8053 | 65 | 0 |
1982624 | 1982624 | 2021-12-05 | Hinsdale | Colorado | 8053 | 65 | 0 |
1979374 | 1979374 | 2021-12-04 | Hinsdale | Colorado | 8053 | 65 | 0 |
1976124 | 1976124 | 2021-12-03 | Hinsdale | Colorado | 8053 | 65 | 0 |
1972875 | 1972875 | 2021-12-02 | Hinsdale | Colorado | 8053 | 65 | 0 |
1969625 | 1969625 | 2021-12-01 | Hinsdale | Colorado | 8053 | 65 | 0 |
1966375 | 1966375 | 2021-11-30 | Hinsdale | Colorado | 8053 | 64 | 0 |
1963123 | 1963123 | 2021-11-29 | Hinsdale | Colorado | 8053 | 64 | 0 |
1959872 | 1959872 | 2021-11-28 | Hinsdale | Colorado | 8053 | 64 | 0 |
1956621 | 1956621 | 2021-11-27 | Hinsdale | Colorado | 8053 | 64 | 0 |
1953370 | 1953370 | 2021-11-26 | Hinsdale | Colorado | 8053 | 64 | 0 |
1950119 | 1950119 | 2021-11-25 | Hinsdale | Colorado | 8053 | 64 | 0 |
1946868 | 1946868 | 2021-11-24 | Hinsdale | Colorado | 8053 | 64 | 0 |
1943617 | 1943617 | 2021-11-23 | Hinsdale | Colorado | 8053 | 64 | 0 |
1940367 | 1940367 | 2021-11-22 | Hinsdale | Colorado | 8053 | 64 | 0 |
1937117 | 1937117 | 2021-11-21 | Hinsdale | Colorado | 8053 | 64 | 0 |
1933867 | 1933867 | 2021-11-20 | Hinsdale | Colorado | 8053 | 64 | 0 |
1930615 | 1930615 | 2021-11-19 | Hinsdale | Colorado | 8053 | 64 | 0 |
1927365 | 1927365 | 2021-11-18 | Hinsdale | Colorado | 8053 | 64 | 0 |
1924115 | 1924115 | 2021-11-17 | Hinsdale | Colorado | 8053 | 65 | 0 |
1920866 | 1920866 | 2021-11-16 | Hinsdale | Colorado | 8053 | 64 | 0 |
1917616 | 1917616 | 2021-11-15 | Hinsdale | Colorado | 8053 | 64 | 0 |
1914366 | 1914366 | 2021-11-14 | Hinsdale | Colorado | 8053 | 64 | 0 |
1911116 | 1911116 | 2021-11-13 | Hinsdale | Colorado | 8053 | 64 | 0 |
1907867 | 1907867 | 2021-11-12 | Hinsdale | Colorado | 8053 | 64 | 0 |
1904618 | 1904618 | 2021-11-11 | Hinsdale | Colorado | 8053 | 64 | 0 |
1901368 | 1901368 | 2021-11-10 | Hinsdale | Colorado | 8053 | 63 | 0 |
1898118 | 1898118 | 2021-11-09 | Hinsdale | Colorado | 8053 | 62 | 0 |
1894868 | 1894868 | 2021-11-08 | Hinsdale | Colorado | 8053 | 61 | 0 |
1891618 | 1891618 | 2021-11-07 | Hinsdale | Colorado | 8053 | 61 | 0 |
1888368 | 1888368 | 2021-11-06 | Hinsdale | Colorado | 8053 | 61 | 0 |
1885118 | 1885118 | 2021-11-05 | Hinsdale | Colorado | 8053 | 61 | 0 |
1881869 | 1881869 | 2021-11-04 | Hinsdale | Colorado | 8053 | 60 | 0 |
1878620 | 1878620 | 2021-11-03 | Hinsdale | Colorado | 8053 | 60 | 0 |
1875371 | 1875371 | 2021-11-02 | Hinsdale | Colorado | 8053 | 60 | 0 |
1872122 | 1872122 | 2021-11-01 | Hinsdale | Colorado | 8053 | 59 | 0 |
1868873 | 1868873 | 2021-10-31 | Hinsdale | Colorado | 8053 | 59 | 0 |
1865624 | 1865624 | 2021-10-30 | Hinsdale | Colorado | 8053 | 59 | 0 |
1862375 | 1862375 | 2021-10-29 | Hinsdale | Colorado | 8053 | 59 | 0 |
1859126 | 1859126 | 2021-10-28 | Hinsdale | Colorado | 8053 | 59 | 0 |
1855877 | 1855877 | 2021-10-27 | Hinsdale | Colorado | 8053 | 59 | 0 |
1852628 | 1852628 | 2021-10-26 | Hinsdale | Colorado | 8053 | 58 | 0 |
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);