ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 8037 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174459 | 2174459 | 2022-02-02 | Eagle | Colorado | 8037 | 15136 | 34 |
2171206 | 2171206 | 2022-02-01 | Eagle | Colorado | 8037 | 15097 | 34 |
2167953 | 2167953 | 2022-01-31 | Eagle | Colorado | 8037 | 15077 | 34 |
2164698 | 2164698 | 2022-01-30 | Eagle | Colorado | 8037 | 14986 | 34 |
2161443 | 2161443 | 2022-01-29 | Eagle | Colorado | 8037 | 14935 | 34 |
2158187 | 2158187 | 2022-01-28 | Eagle | Colorado | 8037 | 14986 | 34 |
2154934 | 2154934 | 2022-01-27 | Eagle | Colorado | 8037 | 14935 | 34 |
2151681 | 2151681 | 2022-01-26 | Eagle | Colorado | 8037 | 14852 | 33 |
2148429 | 2148429 | 2022-01-25 | Eagle | Colorado | 8037 | 14739 | 33 |
2145177 | 2145177 | 2022-01-24 | Eagle | Colorado | 8037 | 14689 | 33 |
2141922 | 2141922 | 2022-01-23 | Eagle | Colorado | 8037 | 14491 | 33 |
2138667 | 2138667 | 2022-01-22 | Eagle | Colorado | 8037 | 14491 | 33 |
2135411 | 2135411 | 2022-01-21 | Eagle | Colorado | 8037 | 14491 | 33 |
2132159 | 2132159 | 2022-01-20 | Eagle | Colorado | 8037 | 14413 | 33 |
2128906 | 2128906 | 2022-01-19 | Eagle | Colorado | 8037 | 14308 | 33 |
2125652 | 2125652 | 2022-01-18 | Eagle | Colorado | 8037 | 14235 | 33 |
2122400 | 2122400 | 2022-01-17 | Eagle | Colorado | 8037 | 14156 | 33 |
2119148 | 2119148 | 2022-01-16 | Eagle | Colorado | 8037 | 13931 | 33 |
2115896 | 2115896 | 2022-01-15 | Eagle | Colorado | 8037 | 13931 | 33 |
2112645 | 2112645 | 2022-01-14 | Eagle | Colorado | 8037 | 13931 | 33 |
2109393 | 2109393 | 2022-01-13 | Eagle | Colorado | 8037 | 13794 | 32 |
2106142 | 2106142 | 2022-01-12 | Eagle | Colorado | 8037 | 13651 | 32 |
2102891 | 2102891 | 2022-01-11 | Eagle | Colorado | 8037 | 13558 | 32 |
2099640 | 2099640 | 2022-01-10 | Eagle | Colorado | 8037 | 13416 | 32 |
2096389 | 2096389 | 2022-01-09 | Eagle | Colorado | 8037 | 12713 | 32 |
2093137 | 2093137 | 2022-01-08 | Eagle | Colorado | 8037 | 12713 | 32 |
2089885 | 2089885 | 2022-01-07 | Eagle | Colorado | 8037 | 12713 | 32 |
2086634 | 2086634 | 2022-01-06 | Eagle | Colorado | 8037 | 12523 | 32 |
2083382 | 2083382 | 2022-01-05 | Eagle | Colorado | 8037 | 12462 | 32 |
2080130 | 2080130 | 2022-01-04 | Eagle | Colorado | 8037 | 12377 | 32 |
2076878 | 2076878 | 2022-01-03 | Eagle | Colorado | 8037 | 12250 | 32 |
2073627 | 2073627 | 2022-01-02 | Eagle | Colorado | 8037 | 11646 | 32 |
2070376 | 2070376 | 2022-01-01 | Eagle | Colorado | 8037 | 11646 | 32 |
2067125 | 2067125 | 2021-12-31 | Eagle | Colorado | 8037 | 11646 | 32 |
2063874 | 2063874 | 2021-12-30 | Eagle | Colorado | 8037 | 11515 | 32 |
2060624 | 2060624 | 2021-12-29 | Eagle | Colorado | 8037 | 11238 | 32 |
2057375 | 2057375 | 2021-12-28 | Eagle | Colorado | 8037 | 10899 | 32 |
2054126 | 2054126 | 2021-12-27 | Eagle | Colorado | 8037 | 10791 | 32 |
2050876 | 2050876 | 2021-12-26 | Eagle | Colorado | 8037 | 10385 | 32 |
2047626 | 2047626 | 2021-12-25 | Eagle | Colorado | 8037 | 10385 | 32 |
2044376 | 2044376 | 2021-12-24 | Eagle | Colorado | 8037 | 10385 | 32 |
2041127 | 2041127 | 2021-12-23 | Eagle | Colorado | 8037 | 10213 | 32 |
2037877 | 2037877 | 2021-12-22 | Eagle | Colorado | 8037 | 10034 | 32 |
2034627 | 2034627 | 2021-12-21 | Eagle | Colorado | 8037 | 9824 | 32 |
2031377 | 2031377 | 2021-12-20 | Eagle | Colorado | 8037 | 9714 | 32 |
2028126 | 2028126 | 2021-12-19 | Eagle | Colorado | 8037 | 9575 | 32 |
2024875 | 2024875 | 2021-12-18 | Eagle | Colorado | 8037 | 9575 | 32 |
2021624 | 2021624 | 2021-12-17 | Eagle | Colorado | 8037 | 9575 | 32 |
2018373 | 2018373 | 2021-12-16 | Eagle | Colorado | 8037 | 9530 | 32 |
2015123 | 2015123 | 2021-12-15 | Eagle | Colorado | 8037 | 9486 | 32 |
2011872 | 2011872 | 2021-12-14 | Eagle | Colorado | 8037 | 9457 | 32 |
2008621 | 2008621 | 2021-12-13 | Eagle | Colorado | 8037 | 9429 | 32 |
2005370 | 2005370 | 2021-12-12 | Eagle | Colorado | 8037 | 9402 | 32 |
2002119 | 2002119 | 2021-12-11 | Eagle | Colorado | 8037 | 9402 | 32 |
1998869 | 1998869 | 2021-12-10 | Eagle | Colorado | 8037 | 9402 | 32 |
1995618 | 1995618 | 2021-12-09 | Eagle | Colorado | 8037 | 9387 | 32 |
1992367 | 1992367 | 2021-12-08 | Eagle | Colorado | 8037 | 9367 | 32 |
1989116 | 1989116 | 2021-12-07 | Eagle | Colorado | 8037 | 9351 | 32 |
1985866 | 1985866 | 2021-12-06 | Eagle | Colorado | 8037 | 9354 | 32 |
1982616 | 1982616 | 2021-12-05 | Eagle | Colorado | 8037 | 9322 | 32 |
1979366 | 1979366 | 2021-12-04 | Eagle | Colorado | 8037 | 9322 | 32 |
1976116 | 1976116 | 2021-12-03 | Eagle | Colorado | 8037 | 9322 | 32 |
1972867 | 1972867 | 2021-12-02 | Eagle | Colorado | 8037 | 9304 | 32 |
1969617 | 1969617 | 2021-12-01 | Eagle | Colorado | 8037 | 9292 | 32 |
1966367 | 1966367 | 2021-11-30 | Eagle | Colorado | 8037 | 9262 | 32 |
1963115 | 1963115 | 2021-11-29 | Eagle | Colorado | 8037 | 9238 | 32 |
1959864 | 1959864 | 2021-11-28 | Eagle | Colorado | 8037 | 9197 | 32 |
1956613 | 1956613 | 2021-11-27 | Eagle | Colorado | 8037 | 9189 | 32 |
1953362 | 1953362 | 2021-11-26 | Eagle | Colorado | 8037 | 9189 | 32 |
1950111 | 1950111 | 2021-11-25 | Eagle | Colorado | 8037 | 9189 | 32 |
1946860 | 1946860 | 2021-11-24 | Eagle | Colorado | 8037 | 9174 | 32 |
1943609 | 1943609 | 2021-11-23 | Eagle | Colorado | 8037 | 9143 | 32 |
1940359 | 1940359 | 2021-11-22 | Eagle | Colorado | 8037 | 9114 | 32 |
1937109 | 1937109 | 2021-11-21 | Eagle | Colorado | 8037 | 9045 | 32 |
1933859 | 1933859 | 2021-11-20 | Eagle | Colorado | 8037 | 9045 | 32 |
1930607 | 1930607 | 2021-11-19 | Eagle | Colorado | 8037 | 9045 | 32 |
1927357 | 1927357 | 2021-11-18 | Eagle | Colorado | 8037 | 9019 | 32 |
1924107 | 1924107 | 2021-11-17 | Eagle | Colorado | 8037 | 8993 | 32 |
1920858 | 1920858 | 2021-11-16 | Eagle | Colorado | 8037 | 8955 | 32 |
1917608 | 1917608 | 2021-11-15 | Eagle | Colorado | 8037 | 8903 | 32 |
1914358 | 1914358 | 2021-11-14 | Eagle | Colorado | 8037 | 8863 | 32 |
1911108 | 1911108 | 2021-11-13 | Eagle | Colorado | 8037 | 8863 | 32 |
1907859 | 1907859 | 2021-11-12 | Eagle | Colorado | 8037 | 8863 | 32 |
1904610 | 1904610 | 2021-11-11 | Eagle | Colorado | 8037 | 8840 | 32 |
1901360 | 1901360 | 2021-11-10 | Eagle | Colorado | 8037 | 8808 | 32 |
1898110 | 1898110 | 2021-11-09 | Eagle | Colorado | 8037 | 8765 | 32 |
1894860 | 1894860 | 2021-11-08 | Eagle | Colorado | 8037 | 8692 | 32 |
1891610 | 1891610 | 2021-11-07 | Eagle | Colorado | 8037 | 8614 | 31 |
1888360 | 1888360 | 2021-11-06 | Eagle | Colorado | 8037 | 8614 | 31 |
1885110 | 1885110 | 2021-11-05 | Eagle | Colorado | 8037 | 8614 | 31 |
1881861 | 1881861 | 2021-11-04 | Eagle | Colorado | 8037 | 8590 | 31 |
1878612 | 1878612 | 2021-11-03 | Eagle | Colorado | 8037 | 8535 | 31 |
1875363 | 1875363 | 2021-11-02 | Eagle | Colorado | 8037 | 8500 | 31 |
1872114 | 1872114 | 2021-11-01 | Eagle | Colorado | 8037 | 8467 | 31 |
1868865 | 1868865 | 2021-10-31 | Eagle | Colorado | 8037 | 8433 | 31 |
1865616 | 1865616 | 2021-10-30 | Eagle | Colorado | 8037 | 8433 | 31 |
1862367 | 1862367 | 2021-10-29 | Eagle | Colorado | 8037 | 8433 | 31 |
1859118 | 1859118 | 2021-10-28 | Eagle | Colorado | 8037 | 8409 | 31 |
1855869 | 1855869 | 2021-10-27 | Eagle | Colorado | 8037 | 8375 | 32 |
1852620 | 1852620 | 2021-10-26 | Eagle | Colorado | 8037 | 8356 | 31 |
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);