ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Chaffee" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2167942 | 2167942 | 2022-01-31 | Chaffee | Colorado | 8015 | 4013 | 40 |
2164687 | 2164687 | 2022-01-30 | Chaffee | Colorado | 8015 | 3972 | 39 |
2161432 | 2161432 | 2022-01-29 | Chaffee | Colorado | 8015 | 3953 | 39 |
2158176 | 2158176 | 2022-01-28 | Chaffee | Colorado | 8015 | 3972 | 39 |
2154923 | 2154923 | 2022-01-27 | Chaffee | Colorado | 8015 | 3953 | 39 |
2151670 | 2151670 | 2022-01-26 | Chaffee | Colorado | 8015 | 3932 | 39 |
2148418 | 2148418 | 2022-01-25 | Chaffee | Colorado | 8015 | 3891 | 39 |
2145166 | 2145166 | 2022-01-24 | Chaffee | Colorado | 8015 | 3848 | 39 |
2141911 | 2141911 | 2022-01-23 | Chaffee | Colorado | 8015 | 3806 | 39 |
2138656 | 2138656 | 2022-01-22 | Chaffee | Colorado | 8015 | 3806 | 39 |
2135400 | 2135400 | 2022-01-21 | Chaffee | Colorado | 8015 | 3806 | 39 |
2132148 | 2132148 | 2022-01-20 | Chaffee | Colorado | 8015 | 3766 | 39 |
2128895 | 2128895 | 2022-01-19 | Chaffee | Colorado | 8015 | 3731 | 39 |
2125641 | 2125641 | 2022-01-18 | Chaffee | Colorado | 8015 | 3700 | 39 |
2122389 | 2122389 | 2022-01-17 | Chaffee | Colorado | 8015 | 3672 | 39 |
2119137 | 2119137 | 2022-01-16 | Chaffee | Colorado | 8015 | 3613 | 38 |
2115885 | 2115885 | 2022-01-15 | Chaffee | Colorado | 8015 | 3613 | 38 |
2112634 | 2112634 | 2022-01-14 | Chaffee | Colorado | 8015 | 3613 | 38 |
2109382 | 2109382 | 2022-01-13 | Chaffee | Colorado | 8015 | 3520 | 38 |
2106131 | 2106131 | 2022-01-12 | Chaffee | Colorado | 8015 | 3420 | 38 |
2102880 | 2102880 | 2022-01-11 | Chaffee | Colorado | 8015 | 3353 | 38 |
2099629 | 2099629 | 2022-01-10 | Chaffee | Colorado | 8015 | 3304 | 38 |
2096378 | 2096378 | 2022-01-09 | Chaffee | Colorado | 8015 | 3120 | 38 |
2093126 | 2093126 | 2022-01-08 | Chaffee | Colorado | 8015 | 3120 | 38 |
2089874 | 2089874 | 2022-01-07 | Chaffee | Colorado | 8015 | 3120 | 38 |
2086623 | 2086623 | 2022-01-06 | Chaffee | Colorado | 8015 | 3062 | 38 |
2083371 | 2083371 | 2022-01-05 | Chaffee | Colorado | 8015 | 3047 | 38 |
2080119 | 2080119 | 2022-01-04 | Chaffee | Colorado | 8015 | 3003 | 38 |
2076867 | 2076867 | 2022-01-03 | Chaffee | Colorado | 8015 | 2947 | 38 |
2073616 | 2073616 | 2022-01-02 | Chaffee | Colorado | 8015 | 2868 | 38 |
2070365 | 2070365 | 2022-01-01 | Chaffee | Colorado | 8015 | 2868 | 38 |
2067114 | 2067114 | 2021-12-31 | Chaffee | Colorado | 8015 | 2868 | 38 |
2063863 | 2063863 | 2021-12-30 | Chaffee | Colorado | 8015 | 2852 | 38 |
2060613 | 2060613 | 2021-12-29 | Chaffee | Colorado | 8015 | 2832 | 38 |
2057364 | 2057364 | 2021-12-28 | Chaffee | Colorado | 8015 | 2814 | 38 |
2054115 | 2054115 | 2021-12-27 | Chaffee | Colorado | 8015 | 2810 | 38 |
2050865 | 2050865 | 2021-12-26 | Chaffee | Colorado | 8015 | 2805 | 38 |
2047615 | 2047615 | 2021-12-25 | Chaffee | Colorado | 8015 | 2805 | 38 |
2044365 | 2044365 | 2021-12-24 | Chaffee | Colorado | 8015 | 2805 | 38 |
2041116 | 2041116 | 2021-12-23 | Chaffee | Colorado | 8015 | 2800 | 38 |
2037866 | 2037866 | 2021-12-22 | Chaffee | Colorado | 8015 | 2795 | 38 |
2034616 | 2034616 | 2021-12-21 | Chaffee | Colorado | 8015 | 2787 | 38 |
2031366 | 2031366 | 2021-12-20 | Chaffee | Colorado | 8015 | 2783 | 38 |
2028115 | 2028115 | 2021-12-19 | Chaffee | Colorado | 8015 | 2775 | 38 |
2024864 | 2024864 | 2021-12-18 | Chaffee | Colorado | 8015 | 2775 | 38 |
2021613 | 2021613 | 2021-12-17 | Chaffee | Colorado | 8015 | 2775 | 38 |
2018362 | 2018362 | 2021-12-16 | Chaffee | Colorado | 8015 | 2769 | 38 |
2015112 | 2015112 | 2021-12-15 | Chaffee | Colorado | 8015 | 2766 | 38 |
2011861 | 2011861 | 2021-12-14 | Chaffee | Colorado | 8015 | 2767 | 38 |
2008610 | 2008610 | 2021-12-13 | Chaffee | Colorado | 8015 | 2764 | 38 |
2005359 | 2005359 | 2021-12-12 | Chaffee | Colorado | 8015 | 2755 | 38 |
2002108 | 2002108 | 2021-12-11 | Chaffee | Colorado | 8015 | 2755 | 38 |
1998858 | 1998858 | 2021-12-10 | Chaffee | Colorado | 8015 | 2755 | 38 |
1995607 | 1995607 | 2021-12-09 | Chaffee | Colorado | 8015 | 2753 | 37 |
1992356 | 1992356 | 2021-12-08 | Chaffee | Colorado | 8015 | 2747 | 37 |
1989105 | 1989105 | 2021-12-07 | Chaffee | Colorado | 8015 | 2738 | 37 |
1985855 | 1985855 | 2021-12-06 | Chaffee | Colorado | 8015 | 2734 | 37 |
1982605 | 1982605 | 2021-12-05 | Chaffee | Colorado | 8015 | 2724 | 36 |
1979355 | 1979355 | 2021-12-04 | Chaffee | Colorado | 8015 | 2724 | 36 |
1976105 | 1976105 | 2021-12-03 | Chaffee | Colorado | 8015 | 2724 | 36 |
1972856 | 1972856 | 2021-12-02 | Chaffee | Colorado | 8015 | 2713 | 36 |
1969606 | 1969606 | 2021-12-01 | Chaffee | Colorado | 8015 | 2704 | 36 |
1966356 | 1966356 | 2021-11-30 | Chaffee | Colorado | 8015 | 2697 | 36 |
1963104 | 1963104 | 2021-11-29 | Chaffee | Colorado | 8015 | 2687 | 36 |
1959853 | 1959853 | 2021-11-28 | Chaffee | Colorado | 8015 | 2672 | 36 |
1956602 | 1956602 | 2021-11-27 | Chaffee | Colorado | 8015 | 2667 | 36 |
1953351 | 1953351 | 2021-11-26 | Chaffee | Colorado | 8015 | 2667 | 36 |
1950100 | 1950100 | 2021-11-25 | Chaffee | Colorado | 8015 | 2667 | 36 |
1946849 | 1946849 | 2021-11-24 | Chaffee | Colorado | 8015 | 2655 | 35 |
1943598 | 1943598 | 2021-11-23 | Chaffee | Colorado | 8015 | 2647 | 34 |
1940348 | 1940348 | 2021-11-22 | Chaffee | Colorado | 8015 | 2637 | 34 |
1937098 | 1937098 | 2021-11-21 | Chaffee | Colorado | 8015 | 2614 | 34 |
1933848 | 1933848 | 2021-11-20 | Chaffee | Colorado | 8015 | 2614 | 34 |
1930596 | 1930596 | 2021-11-19 | Chaffee | Colorado | 8015 | 2614 | 34 |
1927346 | 1927346 | 2021-11-18 | Chaffee | Colorado | 8015 | 2596 | 34 |
1924096 | 1924096 | 2021-11-17 | Chaffee | Colorado | 8015 | 2580 | 33 |
1920847 | 1920847 | 2021-11-16 | Chaffee | Colorado | 8015 | 2565 | 33 |
1917597 | 1917597 | 2021-11-15 | Chaffee | Colorado | 8015 | 2549 | 33 |
1914347 | 1914347 | 2021-11-14 | Chaffee | Colorado | 8015 | 2506 | 33 |
1911097 | 1911097 | 2021-11-13 | Chaffee | Colorado | 8015 | 2506 | 33 |
1907848 | 1907848 | 2021-11-12 | Chaffee | Colorado | 8015 | 2506 | 33 |
1904599 | 1904599 | 2021-11-11 | Chaffee | Colorado | 8015 | 2494 | 33 |
1901349 | 1901349 | 2021-11-10 | Chaffee | Colorado | 8015 | 2481 | 33 |
1898099 | 1898099 | 2021-11-09 | Chaffee | Colorado | 8015 | 2457 | 32 |
1894849 | 1894849 | 2021-11-08 | Chaffee | Colorado | 8015 | 2427 | 32 |
1891599 | 1891599 | 2021-11-07 | Chaffee | Colorado | 8015 | 2393 | 31 |
1888349 | 1888349 | 2021-11-06 | Chaffee | Colorado | 8015 | 2393 | 31 |
1885099 | 1885099 | 2021-11-05 | Chaffee | Colorado | 8015 | 2393 | 31 |
1881850 | 1881850 | 2021-11-04 | Chaffee | Colorado | 8015 | 2380 | 31 |
1878601 | 1878601 | 2021-11-03 | Chaffee | Colorado | 8015 | 2369 | 31 |
1875352 | 1875352 | 2021-11-02 | Chaffee | Colorado | 8015 | 2349 | 31 |
1872103 | 1872103 | 2021-11-01 | Chaffee | Colorado | 8015 | 2340 | 31 |
1868854 | 1868854 | 2021-10-31 | Chaffee | Colorado | 8015 | 2311 | 30 |
1865605 | 1865605 | 2021-10-30 | Chaffee | Colorado | 8015 | 2311 | 30 |
1862356 | 1862356 | 2021-10-29 | Chaffee | Colorado | 8015 | 2311 | 30 |
1859107 | 1859107 | 2021-10-28 | Chaffee | Colorado | 8015 | 2307 | 30 |
1855858 | 1855858 | 2021-10-27 | Chaffee | Colorado | 8015 | 2290 | 30 |
1852609 | 1852609 | 2021-10-26 | Chaffee | Colorado | 8015 | 2275 | 30 |
1849360 | 1849360 | 2021-10-25 | Chaffee | Colorado | 8015 | 2260 | 30 |
1846110 | 1846110 | 2021-10-24 | Chaffee | Colorado | 8015 | 2241 | 30 |
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);