ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 8113 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174497 | 2174497 | 2022-02-02 | San Miguel | Colorado | 8113 | 2111 | 7 |
2171244 | 2171244 | 2022-02-01 | San Miguel | Colorado | 8113 | 2108 | 7 |
2167991 | 2167991 | 2022-01-31 | San Miguel | Colorado | 8113 | 2108 | 7 |
2164736 | 2164736 | 2022-01-30 | San Miguel | Colorado | 8113 | 2093 | 7 |
2161481 | 2161481 | 2022-01-29 | San Miguel | Colorado | 8113 | 2068 | 7 |
2158225 | 2158225 | 2022-01-28 | San Miguel | Colorado | 8113 | 2093 | 7 |
2154972 | 2154972 | 2022-01-27 | San Miguel | Colorado | 8113 | 2068 | 7 |
2151719 | 2151719 | 2022-01-26 | San Miguel | Colorado | 8113 | 2062 | 7 |
2148467 | 2148467 | 2022-01-25 | San Miguel | Colorado | 8113 | 2057 | 7 |
2145215 | 2145215 | 2022-01-24 | San Miguel | Colorado | 8113 | 2049 | 7 |
2141960 | 2141960 | 2022-01-23 | San Miguel | Colorado | 8113 | 2024 | 7 |
2138705 | 2138705 | 2022-01-22 | San Miguel | Colorado | 8113 | 2024 | 7 |
2135449 | 2135449 | 2022-01-21 | San Miguel | Colorado | 8113 | 2024 | 7 |
2132197 | 2132197 | 2022-01-20 | San Miguel | Colorado | 8113 | 2022 | 7 |
2128944 | 2128944 | 2022-01-19 | San Miguel | Colorado | 8113 | 2000 | 7 |
2125690 | 2125690 | 2022-01-18 | San Miguel | Colorado | 8113 | 1994 | 7 |
2122438 | 2122438 | 2022-01-17 | San Miguel | Colorado | 8113 | 1990 | 7 |
2119186 | 2119186 | 2022-01-16 | San Miguel | Colorado | 8113 | 1966 | 7 |
2115934 | 2115934 | 2022-01-15 | San Miguel | Colorado | 8113 | 1966 | 7 |
2112683 | 2112683 | 2022-01-14 | San Miguel | Colorado | 8113 | 1966 | 7 |
2109431 | 2109431 | 2022-01-13 | San Miguel | Colorado | 8113 | 1947 | 7 |
2106180 | 2106180 | 2022-01-12 | San Miguel | Colorado | 8113 | 1883 | 7 |
2102929 | 2102929 | 2022-01-11 | San Miguel | Colorado | 8113 | 1877 | 7 |
2099678 | 2099678 | 2022-01-10 | San Miguel | Colorado | 8113 | 1851 | 7 |
2096427 | 2096427 | 2022-01-09 | San Miguel | Colorado | 8113 | 1721 | 7 |
2093175 | 2093175 | 2022-01-08 | San Miguel | Colorado | 8113 | 1721 | 7 |
2089923 | 2089923 | 2022-01-07 | San Miguel | Colorado | 8113 | 1721 | 7 |
2086672 | 2086672 | 2022-01-06 | San Miguel | Colorado | 8113 | 1714 | 7 |
2083420 | 2083420 | 2022-01-05 | San Miguel | Colorado | 8113 | 1705 | 7 |
2080168 | 2080168 | 2022-01-04 | San Miguel | Colorado | 8113 | 1693 | 7 |
2076916 | 2076916 | 2022-01-03 | San Miguel | Colorado | 8113 | 1675 | 7 |
2073665 | 2073665 | 2022-01-02 | San Miguel | Colorado | 8113 | 1642 | 7 |
2070414 | 2070414 | 2022-01-01 | San Miguel | Colorado | 8113 | 1642 | 7 |
2067163 | 2067163 | 2021-12-31 | San Miguel | Colorado | 8113 | 1642 | 7 |
2063912 | 2063912 | 2021-12-30 | San Miguel | Colorado | 8113 | 1590 | 7 |
2060662 | 2060662 | 2021-12-29 | San Miguel | Colorado | 8113 | 1505 | 7 |
2057413 | 2057413 | 2021-12-28 | San Miguel | Colorado | 8113 | 1477 | 7 |
2054164 | 2054164 | 2021-12-27 | San Miguel | Colorado | 8113 | 1471 | 7 |
2050914 | 2050914 | 2021-12-26 | San Miguel | Colorado | 8113 | 1459 | 7 |
2047664 | 2047664 | 2021-12-25 | San Miguel | Colorado | 8113 | 1459 | 7 |
2044414 | 2044414 | 2021-12-24 | San Miguel | Colorado | 8113 | 1459 | 7 |
2041165 | 2041165 | 2021-12-23 | San Miguel | Colorado | 8113 | 1373 | 7 |
2037915 | 2037915 | 2021-12-22 | San Miguel | Colorado | 8113 | 1327 | 7 |
2034665 | 2034665 | 2021-12-21 | San Miguel | Colorado | 8113 | 1324 | 7 |
2031415 | 2031415 | 2021-12-20 | San Miguel | Colorado | 8113 | 1322 | 6 |
2028164 | 2028164 | 2021-12-19 | San Miguel | Colorado | 8113 | 1322 | 5 |
2024913 | 2024913 | 2021-12-18 | San Miguel | Colorado | 8113 | 1322 | 5 |
2021662 | 2021662 | 2021-12-17 | San Miguel | Colorado | 8113 | 1322 | 5 |
2018411 | 2018411 | 2021-12-16 | San Miguel | Colorado | 8113 | 1311 | 5 |
2015161 | 2015161 | 2021-12-15 | San Miguel | Colorado | 8113 | 1308 | 5 |
2011910 | 2011910 | 2021-12-14 | San Miguel | Colorado | 8113 | 1307 | 5 |
2008659 | 2008659 | 2021-12-13 | San Miguel | Colorado | 8113 | 1302 | 5 |
2005408 | 2005408 | 2021-12-12 | San Miguel | Colorado | 8113 | 1298 | 5 |
2002157 | 2002157 | 2021-12-11 | San Miguel | Colorado | 8113 | 1298 | 5 |
1998907 | 1998907 | 2021-12-10 | San Miguel | Colorado | 8113 | 1298 | 5 |
1995656 | 1995656 | 2021-12-09 | San Miguel | Colorado | 8113 | 1294 | 5 |
1992405 | 1992405 | 2021-12-08 | San Miguel | Colorado | 8113 | 1288 | 5 |
1989154 | 1989154 | 2021-12-07 | San Miguel | Colorado | 8113 | 1286 | 5 |
1985904 | 1985904 | 2021-12-06 | San Miguel | Colorado | 8113 | 1281 | 5 |
1982654 | 1982654 | 2021-12-05 | San Miguel | Colorado | 8113 | 1279 | 5 |
1979404 | 1979404 | 2021-12-04 | San Miguel | Colorado | 8113 | 1279 | 5 |
1976154 | 1976154 | 2021-12-03 | San Miguel | Colorado | 8113 | 1279 | 5 |
1972905 | 1972905 | 2021-12-02 | San Miguel | Colorado | 8113 | 1278 | 5 |
1969655 | 1969655 | 2021-12-01 | San Miguel | Colorado | 8113 | 1271 | 5 |
1966405 | 1966405 | 2021-11-30 | San Miguel | Colorado | 8113 | 1270 | 5 |
1963153 | 1963153 | 2021-11-29 | San Miguel | Colorado | 8113 | 1268 | 5 |
1959902 | 1959902 | 2021-11-28 | San Miguel | Colorado | 8113 | 1263 | 5 |
1956651 | 1956651 | 2021-11-27 | San Miguel | Colorado | 8113 | 1263 | 5 |
1953400 | 1953400 | 2021-11-26 | San Miguel | Colorado | 8113 | 1263 | 5 |
1950149 | 1950149 | 2021-11-25 | San Miguel | Colorado | 8113 | 1263 | 5 |
1946898 | 1946898 | 2021-11-24 | San Miguel | Colorado | 8113 | 1260 | 5 |
1943647 | 1943647 | 2021-11-23 | San Miguel | Colorado | 8113 | 1259 | 5 |
1940397 | 1940397 | 2021-11-22 | San Miguel | Colorado | 8113 | 1259 | 5 |
1937147 | 1937147 | 2021-11-21 | San Miguel | Colorado | 8113 | 1253 | 5 |
1933897 | 1933897 | 2021-11-20 | San Miguel | Colorado | 8113 | 1253 | 5 |
1930645 | 1930645 | 2021-11-19 | San Miguel | Colorado | 8113 | 1253 | 5 |
1927395 | 1927395 | 2021-11-18 | San Miguel | Colorado | 8113 | 1243 | 5 |
1924145 | 1924145 | 2021-11-17 | San Miguel | Colorado | 8113 | 1235 | 5 |
1920896 | 1920896 | 2021-11-16 | San Miguel | Colorado | 8113 | 1231 | 5 |
1917646 | 1917646 | 2021-11-15 | San Miguel | Colorado | 8113 | 1232 | 5 |
1914396 | 1914396 | 2021-11-14 | San Miguel | Colorado | 8113 | 1216 | 5 |
1911146 | 1911146 | 2021-11-13 | San Miguel | Colorado | 8113 | 1216 | 5 |
1907897 | 1907897 | 2021-11-12 | San Miguel | Colorado | 8113 | 1216 | 5 |
1904648 | 1904648 | 2021-11-11 | San Miguel | Colorado | 8113 | 1215 | 5 |
1901398 | 1901398 | 2021-11-10 | San Miguel | Colorado | 8113 | 1212 | 5 |
1898148 | 1898148 | 2021-11-09 | San Miguel | Colorado | 8113 | 1207 | 5 |
1894898 | 1894898 | 2021-11-08 | San Miguel | Colorado | 8113 | 1205 | 5 |
1891648 | 1891648 | 2021-11-07 | San Miguel | Colorado | 8113 | 1201 | 5 |
1888398 | 1888398 | 2021-11-06 | San Miguel | Colorado | 8113 | 1201 | 5 |
1885148 | 1885148 | 2021-11-05 | San Miguel | Colorado | 8113 | 1201 | 5 |
1881899 | 1881899 | 2021-11-04 | San Miguel | Colorado | 8113 | 1197 | 5 |
1878650 | 1878650 | 2021-11-03 | San Miguel | Colorado | 8113 | 1191 | 5 |
1875401 | 1875401 | 2021-11-02 | San Miguel | Colorado | 8113 | 1192 | 5 |
1872152 | 1872152 | 2021-11-01 | San Miguel | Colorado | 8113 | 1191 | 5 |
1868903 | 1868903 | 2021-10-31 | San Miguel | Colorado | 8113 | 1180 | 4 |
1865654 | 1865654 | 2021-10-30 | San Miguel | Colorado | 8113 | 1180 | 4 |
1862405 | 1862405 | 2021-10-29 | San Miguel | Colorado | 8113 | 1180 | 4 |
1859156 | 1859156 | 2021-10-28 | San Miguel | Colorado | 8113 | 1172 | 4 |
1855907 | 1855907 | 2021-10-27 | San Miguel | Colorado | 8113 | 1173 | 4 |
1852658 | 1852658 | 2021-10-26 | San Miguel | Colorado | 8113 | 1171 | 4 |
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);