ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Lake" and fips = 8065 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174474 | 2174474 | 2022-02-02 | Lake | Colorado | 8065 | 1724 | 2 |
2171221 | 2171221 | 2022-02-01 | Lake | Colorado | 8065 | 1721 | 2 |
2167968 | 2167968 | 2022-01-31 | Lake | Colorado | 8065 | 1718 | 2 |
2164713 | 2164713 | 2022-01-30 | Lake | Colorado | 8065 | 1710 | 2 |
2161458 | 2161458 | 2022-01-29 | Lake | Colorado | 8065 | 1701 | 2 |
2158202 | 2158202 | 2022-01-28 | Lake | Colorado | 8065 | 1710 | 2 |
2154949 | 2154949 | 2022-01-27 | Lake | Colorado | 8065 | 1701 | 2 |
2151696 | 2151696 | 2022-01-26 | Lake | Colorado | 8065 | 1698 | 2 |
2148444 | 2148444 | 2022-01-25 | Lake | Colorado | 8065 | 1690 | 2 |
2145192 | 2145192 | 2022-01-24 | Lake | Colorado | 8065 | 1680 | 2 |
2141937 | 2141937 | 2022-01-23 | Lake | Colorado | 8065 | 1654 | 2 |
2138682 | 2138682 | 2022-01-22 | Lake | Colorado | 8065 | 1654 | 2 |
2135426 | 2135426 | 2022-01-21 | Lake | Colorado | 8065 | 1654 | 2 |
2132174 | 2132174 | 2022-01-20 | Lake | Colorado | 8065 | 1649 | 3 |
2128921 | 2128921 | 2022-01-19 | Lake | Colorado | 8065 | 1631 | 3 |
2125667 | 2125667 | 2022-01-18 | Lake | Colorado | 8065 | 1617 | 2 |
2122415 | 2122415 | 2022-01-17 | Lake | Colorado | 8065 | 1604 | 2 |
2119163 | 2119163 | 2022-01-16 | Lake | Colorado | 8065 | 1592 | 2 |
2115911 | 2115911 | 2022-01-15 | Lake | Colorado | 8065 | 1592 | 2 |
2112660 | 2112660 | 2022-01-14 | Lake | Colorado | 8065 | 1592 | 2 |
2109408 | 2109408 | 2022-01-13 | Lake | Colorado | 8065 | 1564 | 2 |
2106157 | 2106157 | 2022-01-12 | Lake | Colorado | 8065 | 1552 | 2 |
2102906 | 2102906 | 2022-01-11 | Lake | Colorado | 8065 | 1517 | 2 |
2099655 | 2099655 | 2022-01-10 | Lake | Colorado | 8065 | 1460 | 2 |
2096404 | 2096404 | 2022-01-09 | Lake | Colorado | 8065 | 1375 | 2 |
2093152 | 2093152 | 2022-01-08 | Lake | Colorado | 8065 | 1375 | 2 |
2089900 | 2089900 | 2022-01-07 | Lake | Colorado | 8065 | 1375 | 2 |
2086649 | 2086649 | 2022-01-06 | Lake | Colorado | 8065 | 1341 | 2 |
2083397 | 2083397 | 2022-01-05 | Lake | Colorado | 8065 | 1338 | 2 |
2080145 | 2080145 | 2022-01-04 | Lake | Colorado | 8065 | 1314 | 2 |
2076893 | 2076893 | 2022-01-03 | Lake | Colorado | 8065 | 1286 | 2 |
2073642 | 2073642 | 2022-01-02 | Lake | Colorado | 8065 | 1275 | 2 |
2070391 | 2070391 | 2022-01-01 | Lake | Colorado | 8065 | 1275 | 2 |
2067140 | 2067140 | 2021-12-31 | Lake | Colorado | 8065 | 1275 | 2 |
2063889 | 2063889 | 2021-12-30 | Lake | Colorado | 8065 | 1271 | 2 |
2060639 | 2060639 | 2021-12-29 | Lake | Colorado | 8065 | 1260 | 2 |
2057390 | 2057390 | 2021-12-28 | Lake | Colorado | 8065 | 1255 | 2 |
2054141 | 2054141 | 2021-12-27 | Lake | Colorado | 8065 | 1250 | 2 |
2050891 | 2050891 | 2021-12-26 | Lake | Colorado | 8065 | 1245 | 2 |
2047641 | 2047641 | 2021-12-25 | Lake | Colorado | 8065 | 1245 | 2 |
2044391 | 2044391 | 2021-12-24 | Lake | Colorado | 8065 | 1245 | 2 |
2041142 | 2041142 | 2021-12-23 | Lake | Colorado | 8065 | 1242 | 2 |
2037892 | 2037892 | 2021-12-22 | Lake | Colorado | 8065 | 1240 | 2 |
2034642 | 2034642 | 2021-12-21 | Lake | Colorado | 8065 | 1236 | 2 |
2031392 | 2031392 | 2021-12-20 | Lake | Colorado | 8065 | 1231 | 1 |
2028141 | 2028141 | 2021-12-19 | Lake | Colorado | 8065 | 1229 | 1 |
2024890 | 2024890 | 2021-12-18 | Lake | Colorado | 8065 | 1229 | 1 |
2021639 | 2021639 | 2021-12-17 | Lake | Colorado | 8065 | 1229 | 1 |
2018388 | 2018388 | 2021-12-16 | Lake | Colorado | 8065 | 1226 | 1 |
2015138 | 2015138 | 2021-12-15 | Lake | Colorado | 8065 | 1218 | 1 |
2011887 | 2011887 | 2021-12-14 | Lake | Colorado | 8065 | 1213 | 1 |
2008636 | 2008636 | 2021-12-13 | Lake | Colorado | 8065 | 1210 | 1 |
2005385 | 2005385 | 2021-12-12 | Lake | Colorado | 8065 | 1208 | 1 |
2002134 | 2002134 | 2021-12-11 | Lake | Colorado | 8065 | 1208 | 1 |
1998884 | 1998884 | 2021-12-10 | Lake | Colorado | 8065 | 1208 | 1 |
1995633 | 1995633 | 2021-12-09 | Lake | Colorado | 8065 | 1202 | 1 |
1992382 | 1992382 | 2021-12-08 | Lake | Colorado | 8065 | 1194 | 1 |
1989131 | 1989131 | 2021-12-07 | Lake | Colorado | 8065 | 1191 | 1 |
1985881 | 1985881 | 2021-12-06 | Lake | Colorado | 8065 | 1179 | 1 |
1982631 | 1982631 | 2021-12-05 | Lake | Colorado | 8065 | 1161 | 1 |
1979381 | 1979381 | 2021-12-04 | Lake | Colorado | 8065 | 1161 | 1 |
1976131 | 1976131 | 2021-12-03 | Lake | Colorado | 8065 | 1161 | 23 |
1972882 | 1972882 | 2021-12-02 | Lake | Colorado | 8065 | 1150 | 1 |
1969632 | 1969632 | 2021-12-01 | Lake | Colorado | 8065 | 1136 | 1 |
1966382 | 1966382 | 2021-11-30 | Lake | Colorado | 8065 | 1134 | 1 |
1963130 | 1963130 | 2021-11-29 | Lake | Colorado | 8065 | 1130 | 1 |
1959879 | 1959879 | 2021-11-28 | Lake | Colorado | 8065 | 1128 | 1 |
1956628 | 1956628 | 2021-11-27 | Lake | Colorado | 8065 | 1128 | 1 |
1953377 | 1953377 | 2021-11-26 | Lake | Colorado | 8065 | 1128 | 1 |
1950126 | 1950126 | 2021-11-25 | Lake | Colorado | 8065 | 1128 | 1 |
1946875 | 1946875 | 2021-11-24 | Lake | Colorado | 8065 | 1127 | 1 |
1943624 | 1943624 | 2021-11-23 | Lake | Colorado | 8065 | 1119 | 1 |
1940374 | 1940374 | 2021-11-22 | Lake | Colorado | 8065 | 1104 | 1 |
1937124 | 1937124 | 2021-11-21 | Lake | Colorado | 8065 | 1100 | 1 |
1933874 | 1933874 | 2021-11-20 | Lake | Colorado | 8065 | 1100 | 1 |
1930622 | 1930622 | 2021-11-19 | Lake | Colorado | 8065 | 1100 | 1 |
1927372 | 1927372 | 2021-11-18 | Lake | Colorado | 8065 | 1097 | 1 |
1924122 | 1924122 | 2021-11-17 | Lake | Colorado | 8065 | 1086 | 1 |
1920873 | 1920873 | 2021-11-16 | Lake | Colorado | 8065 | 1078 | 1 |
1917623 | 1917623 | 2021-11-15 | Lake | Colorado | 8065 | 1078 | 1 |
1914373 | 1914373 | 2021-11-14 | Lake | Colorado | 8065 | 1076 | 1 |
1911123 | 1911123 | 2021-11-13 | Lake | Colorado | 8065 | 1076 | 1 |
1907874 | 1907874 | 2021-11-12 | Lake | Colorado | 8065 | 1076 | 1 |
1904625 | 1904625 | 2021-11-11 | Lake | Colorado | 8065 | 1076 | 1 |
1901375 | 1901375 | 2021-11-10 | Lake | Colorado | 8065 | 1075 | 1 |
1898125 | 1898125 | 2021-11-09 | Lake | Colorado | 8065 | 1073 | 1 |
1894875 | 1894875 | 2021-11-08 | Lake | Colorado | 8065 | 1068 | 1 |
1891625 | 1891625 | 2021-11-07 | Lake | Colorado | 8065 | 1063 | 1 |
1888375 | 1888375 | 2021-11-06 | Lake | Colorado | 8065 | 1063 | 1 |
1885125 | 1885125 | 2021-11-05 | Lake | Colorado | 8065 | 1063 | 1 |
1881876 | 1881876 | 2021-11-04 | Lake | Colorado | 8065 | 1060 | 1 |
1878627 | 1878627 | 2021-11-03 | Lake | Colorado | 8065 | 1058 | 1 |
1875378 | 1875378 | 2021-11-02 | Lake | Colorado | 8065 | 1056 | 1 |
1872129 | 1872129 | 2021-11-01 | Lake | Colorado | 8065 | 1056 | 1 |
1868880 | 1868880 | 2021-10-31 | Lake | Colorado | 8065 | 1044 | 1 |
1865631 | 1865631 | 2021-10-30 | Lake | Colorado | 8065 | 1044 | 1 |
1862382 | 1862382 | 2021-10-29 | Lake | Colorado | 8065 | 1044 | 1 |
1859133 | 1859133 | 2021-10-28 | Lake | Colorado | 8065 | 1041 | 1 |
1855884 | 1855884 | 2021-10-27 | Lake | Colorado | 8065 | 1035 | 1 |
1852635 | 1852635 | 2021-10-26 | Lake | Colorado | 8065 | 1029 | 1 |
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);