ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8107 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174494 | 2174494 | 2022-02-02 | Routt | Colorado | 8107 | 5963 | 24 |
2171241 | 2171241 | 2022-02-01 | Routt | Colorado | 8107 | 5944 | 24 |
2167988 | 2167988 | 2022-01-31 | Routt | Colorado | 8107 | 5947 | 25 |
2164733 | 2164733 | 2022-01-30 | Routt | Colorado | 8107 | 5903 | 25 |
2161478 | 2161478 | 2022-01-29 | Routt | Colorado | 8107 | 5885 | 25 |
2158222 | 2158222 | 2022-01-28 | Routt | Colorado | 8107 | 5903 | 25 |
2154969 | 2154969 | 2022-01-27 | Routt | Colorado | 8107 | 5885 | 25 |
2151716 | 2151716 | 2022-01-26 | Routt | Colorado | 8107 | 5871 | 25 |
2148464 | 2148464 | 2022-01-25 | Routt | Colorado | 8107 | 5836 | 24 |
2145212 | 2145212 | 2022-01-24 | Routt | Colorado | 8107 | 5813 | 24 |
2141957 | 2141957 | 2022-01-23 | Routt | Colorado | 8107 | 5721 | 24 |
2138702 | 2138702 | 2022-01-22 | Routt | Colorado | 8107 | 5721 | 24 |
2135446 | 2135446 | 2022-01-21 | Routt | Colorado | 8107 | 5721 | 24 |
2132194 | 2132194 | 2022-01-20 | Routt | Colorado | 8107 | 5684 | 24 |
2128941 | 2128941 | 2022-01-19 | Routt | Colorado | 8107 | 5641 | 24 |
2125687 | 2125687 | 2022-01-18 | Routt | Colorado | 8107 | 5575 | 24 |
2122435 | 2122435 | 2022-01-17 | Routt | Colorado | 8107 | 5540 | 24 |
2119183 | 2119183 | 2022-01-16 | Routt | Colorado | 8107 | 5439 | 24 |
2115931 | 2115931 | 2022-01-15 | Routt | Colorado | 8107 | 5439 | 24 |
2112680 | 2112680 | 2022-01-14 | Routt | Colorado | 8107 | 5439 | 24 |
2109428 | 2109428 | 2022-01-13 | Routt | Colorado | 8107 | 5355 | 24 |
2106177 | 2106177 | 2022-01-12 | Routt | Colorado | 8107 | 5268 | 24 |
2102926 | 2102926 | 2022-01-11 | Routt | Colorado | 8107 | 5161 | 24 |
2099675 | 2099675 | 2022-01-10 | Routt | Colorado | 8107 | 5064 | 24 |
2096424 | 2096424 | 2022-01-09 | Routt | Colorado | 8107 | 4788 | 24 |
2093172 | 2093172 | 2022-01-08 | Routt | Colorado | 8107 | 4788 | 24 |
2089920 | 2089920 | 2022-01-07 | Routt | Colorado | 8107 | 4788 | 24 |
2086669 | 2086669 | 2022-01-06 | Routt | Colorado | 8107 | 4755 | 24 |
2083417 | 2083417 | 2022-01-05 | Routt | Colorado | 8107 | 4662 | 24 |
2080165 | 2080165 | 2022-01-04 | Routt | Colorado | 8107 | 4589 | 24 |
2076913 | 2076913 | 2022-01-03 | Routt | Colorado | 8107 | 4525 | 24 |
2073662 | 2073662 | 2022-01-02 | Routt | Colorado | 8107 | 4358 | 24 |
2070411 | 2070411 | 2022-01-01 | Routt | Colorado | 8107 | 4358 | 24 |
2067160 | 2067160 | 2021-12-31 | Routt | Colorado | 8107 | 4358 | 24 |
2063909 | 2063909 | 2021-12-30 | Routt | Colorado | 8107 | 4304 | 24 |
2060659 | 2060659 | 2021-12-29 | Routt | Colorado | 8107 | 4219 | 24 |
2057410 | 2057410 | 2021-12-28 | Routt | Colorado | 8107 | 4148 | 24 |
2054161 | 2054161 | 2021-12-27 | Routt | Colorado | 8107 | 4043 | 24 |
2050911 | 2050911 | 2021-12-26 | Routt | Colorado | 8107 | 4009 | 24 |
2047661 | 2047661 | 2021-12-25 | Routt | Colorado | 8107 | 4009 | 24 |
2044411 | 2044411 | 2021-12-24 | Routt | Colorado | 8107 | 4009 | 24 |
2041162 | 2041162 | 2021-12-23 | Routt | Colorado | 8107 | 3979 | 24 |
2037912 | 2037912 | 2021-12-22 | Routt | Colorado | 8107 | 3958 | 24 |
2034662 | 2034662 | 2021-12-21 | Routt | Colorado | 8107 | 3948 | 24 |
2031412 | 2031412 | 2021-12-20 | Routt | Colorado | 8107 | 3938 | 24 |
2028161 | 2028161 | 2021-12-19 | Routt | Colorado | 8107 | 3920 | 24 |
2024910 | 2024910 | 2021-12-18 | Routt | Colorado | 8107 | 3920 | 24 |
2021659 | 2021659 | 2021-12-17 | Routt | Colorado | 8107 | 3920 | 24 |
2018408 | 2018408 | 2021-12-16 | Routt | Colorado | 8107 | 3915 | 24 |
2015158 | 2015158 | 2021-12-15 | Routt | Colorado | 8107 | 3913 | 24 |
2011907 | 2011907 | 2021-12-14 | Routt | Colorado | 8107 | 3907 | 24 |
2008656 | 2008656 | 2021-12-13 | Routt | Colorado | 8107 | 3897 | 24 |
2005405 | 2005405 | 2021-12-12 | Routt | Colorado | 8107 | 3890 | 24 |
2002154 | 2002154 | 2021-12-11 | Routt | Colorado | 8107 | 3890 | 24 |
1998904 | 1998904 | 2021-12-10 | Routt | Colorado | 8107 | 3890 | 24 |
1995653 | 1995653 | 2021-12-09 | Routt | Colorado | 8107 | 3887 | 24 |
1992402 | 1992402 | 2021-12-08 | Routt | Colorado | 8107 | 3883 | 24 |
1989151 | 1989151 | 2021-12-07 | Routt | Colorado | 8107 | 3877 | 24 |
1985901 | 1985901 | 2021-12-06 | Routt | Colorado | 8107 | 3877 | 24 |
1982651 | 1982651 | 2021-12-05 | Routt | Colorado | 8107 | 3864 | 24 |
1979401 | 1979401 | 2021-12-04 | Routt | Colorado | 8107 | 3864 | 24 |
1976151 | 1976151 | 2021-12-03 | Routt | Colorado | 8107 | 3864 | 24 |
1972902 | 1972902 | 2021-12-02 | Routt | Colorado | 8107 | 3850 | 24 |
1969652 | 1969652 | 2021-12-01 | Routt | Colorado | 8107 | 3838 | 24 |
1966402 | 1966402 | 2021-11-30 | Routt | Colorado | 8107 | 3832 | 24 |
1963150 | 1963150 | 2021-11-29 | Routt | Colorado | 8107 | 3823 | 23 |
1959899 | 1959899 | 2021-11-28 | Routt | Colorado | 8107 | 3814 | 23 |
1956648 | 1956648 | 2021-11-27 | Routt | Colorado | 8107 | 3812 | 23 |
1953397 | 1953397 | 2021-11-26 | Routt | Colorado | 8107 | 3812 | 23 |
1950146 | 1950146 | 2021-11-25 | Routt | Colorado | 8107 | 3812 | 23 |
1946895 | 1946895 | 2021-11-24 | Routt | Colorado | 8107 | 3808 | 23 |
1943644 | 1943644 | 2021-11-23 | Routt | Colorado | 8107 | 3796 | 23 |
1940394 | 1940394 | 2021-11-22 | Routt | Colorado | 8107 | 3784 | 23 |
1937144 | 1937144 | 2021-11-21 | Routt | Colorado | 8107 | 3762 | 23 |
1933894 | 1933894 | 2021-11-20 | Routt | Colorado | 8107 | 3762 | 23 |
1930642 | 1930642 | 2021-11-19 | Routt | Colorado | 8107 | 3762 | 23 |
1927392 | 1927392 | 2021-11-18 | Routt | Colorado | 8107 | 3751 | 23 |
1924142 | 1924142 | 2021-11-17 | Routt | Colorado | 8107 | 3742 | 23 |
1920893 | 1920893 | 2021-11-16 | Routt | Colorado | 8107 | 3727 | 23 |
1917643 | 1917643 | 2021-11-15 | Routt | Colorado | 8107 | 3706 | 23 |
1914393 | 1914393 | 2021-11-14 | Routt | Colorado | 8107 | 3670 | 23 |
1911143 | 1911143 | 2021-11-13 | Routt | Colorado | 8107 | 3670 | 23 |
1907894 | 1907894 | 2021-11-12 | Routt | Colorado | 8107 | 3670 | 23 |
1904645 | 1904645 | 2021-11-11 | Routt | Colorado | 8107 | 3648 | 23 |
1901395 | 1901395 | 2021-11-10 | Routt | Colorado | 8107 | 3633 | 23 |
1898145 | 1898145 | 2021-11-09 | Routt | Colorado | 8107 | 3604 | 23 |
1894895 | 1894895 | 2021-11-08 | Routt | Colorado | 8107 | 3576 | 23 |
1891645 | 1891645 | 2021-11-07 | Routt | Colorado | 8107 | 3530 | 23 |
1888395 | 1888395 | 2021-11-06 | Routt | Colorado | 8107 | 3530 | 23 |
1885145 | 1885145 | 2021-11-05 | Routt | Colorado | 8107 | 3530 | 23 |
1881896 | 1881896 | 2021-11-04 | Routt | Colorado | 8107 | 3515 | 23 |
1878647 | 1878647 | 2021-11-03 | Routt | Colorado | 8107 | 3492 | 23 |
1875398 | 1875398 | 2021-11-02 | Routt | Colorado | 8107 | 3469 | 23 |
1872149 | 1872149 | 2021-11-01 | Routt | Colorado | 8107 | 3454 | 23 |
1868900 | 1868900 | 2021-10-31 | Routt | Colorado | 8107 | 3418 | 23 |
1865651 | 1865651 | 2021-10-30 | Routt | Colorado | 8107 | 3418 | 23 |
1862402 | 1862402 | 2021-10-29 | Routt | Colorado | 8107 | 3418 | 23 |
1859153 | 1859153 | 2021-10-28 | Routt | Colorado | 8107 | 3403 | 23 |
1855904 | 1855904 | 2021-10-27 | Routt | Colorado | 8107 | 3383 | 23 |
1852655 | 1852655 | 2021-10-26 | Routt | Colorado | 8107 | 3356 | 23 |
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);