ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Logan" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174478 | 2174478 | 2022-02-02 | Logan | Colorado | 8075 | 6556 | 104 |
2171225 | 2171225 | 2022-02-01 | Logan | Colorado | 8075 | 6402 | 104 |
2167972 | 2167972 | 2022-01-31 | Logan | Colorado | 8075 | 6377 | 104 |
2164717 | 2164717 | 2022-01-30 | Logan | Colorado | 8075 | 6312 | 102 |
2161462 | 2161462 | 2022-01-29 | Logan | Colorado | 8075 | 6293 | 102 |
2158206 | 2158206 | 2022-01-28 | Logan | Colorado | 8075 | 6312 | 102 |
2154953 | 2154953 | 2022-01-27 | Logan | Colorado | 8075 | 6293 | 102 |
2151700 | 2151700 | 2022-01-26 | Logan | Colorado | 8075 | 6174 | 102 |
2148448 | 2148448 | 2022-01-25 | Logan | Colorado | 8075 | 6072 | 102 |
2145196 | 2145196 | 2022-01-24 | Logan | Colorado | 8075 | 6057 | 102 |
2141941 | 2141941 | 2022-01-23 | Logan | Colorado | 8075 | 6021 | 101 |
2138686 | 2138686 | 2022-01-22 | Logan | Colorado | 8075 | 6021 | 101 |
2135430 | 2135430 | 2022-01-21 | Logan | Colorado | 8075 | 6021 | 101 |
2132178 | 2132178 | 2022-01-20 | Logan | Colorado | 8075 | 5992 | 101 |
2128925 | 2128925 | 2022-01-19 | Logan | Colorado | 8075 | 5963 | 100 |
2125671 | 2125671 | 2022-01-18 | Logan | Colorado | 8075 | 5930 | 100 |
2122419 | 2122419 | 2022-01-17 | Logan | Colorado | 8075 | 5819 | 100 |
2119167 | 2119167 | 2022-01-16 | Logan | Colorado | 8075 | 5690 | 99 |
2115915 | 2115915 | 2022-01-15 | Logan | Colorado | 8075 | 5690 | 99 |
2112664 | 2112664 | 2022-01-14 | Logan | Colorado | 8075 | 5690 | 99 |
2109412 | 2109412 | 2022-01-13 | Logan | Colorado | 8075 | 5642 | 98 |
2106161 | 2106161 | 2022-01-12 | Logan | Colorado | 8075 | 5619 | 98 |
2102910 | 2102910 | 2022-01-11 | Logan | Colorado | 8075 | 5598 | 98 |
2099659 | 2099659 | 2022-01-10 | Logan | Colorado | 8075 | 5571 | 97 |
2096408 | 2096408 | 2022-01-09 | Logan | Colorado | 8075 | 5479 | 97 |
2093156 | 2093156 | 2022-01-08 | Logan | Colorado | 8075 | 5479 | 97 |
2089904 | 2089904 | 2022-01-07 | Logan | Colorado | 8075 | 5479 | 97 |
2086653 | 2086653 | 2022-01-06 | Logan | Colorado | 8075 | 5467 | 97 |
2083401 | 2083401 | 2022-01-05 | Logan | Colorado | 8075 | 5456 | 97 |
2080149 | 2080149 | 2022-01-04 | Logan | Colorado | 8075 | 5422 | 97 |
2076897 | 2076897 | 2022-01-03 | Logan | Colorado | 8075 | 5397 | 97 |
2073646 | 2073646 | 2022-01-02 | Logan | Colorado | 8075 | 5345 | 97 |
2070395 | 2070395 | 2022-01-01 | Logan | Colorado | 8075 | 5345 | 97 |
2067144 | 2067144 | 2021-12-31 | Logan | Colorado | 8075 | 5345 | 97 |
2063893 | 2063893 | 2021-12-30 | Logan | Colorado | 8075 | 5331 | 97 |
2060643 | 2060643 | 2021-12-29 | Logan | Colorado | 8075 | 5316 | 96 |
2057394 | 2057394 | 2021-12-28 | Logan | Colorado | 8075 | 5294 | 96 |
2054145 | 2054145 | 2021-12-27 | Logan | Colorado | 8075 | 5281 | 95 |
2050895 | 2050895 | 2021-12-26 | Logan | Colorado | 8075 | 5259 | 95 |
2047645 | 2047645 | 2021-12-25 | Logan | Colorado | 8075 | 5259 | 95 |
2044395 | 2044395 | 2021-12-24 | Logan | Colorado | 8075 | 5259 | 95 |
2041146 | 2041146 | 2021-12-23 | Logan | Colorado | 8075 | 5254 | 95 |
2037896 | 2037896 | 2021-12-22 | Logan | Colorado | 8075 | 5247 | 95 |
2034646 | 2034646 | 2021-12-21 | Logan | Colorado | 8075 | 5236 | 95 |
2031396 | 2031396 | 2021-12-20 | Logan | Colorado | 8075 | 5233 | 95 |
2028145 | 2028145 | 2021-12-19 | Logan | Colorado | 8075 | 5228 | 95 |
2024894 | 2024894 | 2021-12-18 | Logan | Colorado | 8075 | 5228 | 95 |
2021643 | 2021643 | 2021-12-17 | Logan | Colorado | 8075 | 5228 | 95 |
2018392 | 2018392 | 2021-12-16 | Logan | Colorado | 8075 | 5223 | 95 |
2015142 | 2015142 | 2021-12-15 | Logan | Colorado | 8075 | 5218 | 95 |
2011891 | 2011891 | 2021-12-14 | Logan | Colorado | 8075 | 5198 | 95 |
2008640 | 2008640 | 2021-12-13 | Logan | Colorado | 8075 | 5196 | 95 |
2005389 | 2005389 | 2021-12-12 | Logan | Colorado | 8075 | 5173 | 94 |
2002138 | 2002138 | 2021-12-11 | Logan | Colorado | 8075 | 5173 | 94 |
1998888 | 1998888 | 2021-12-10 | Logan | Colorado | 8075 | 5173 | 94 |
1995637 | 1995637 | 2021-12-09 | Logan | Colorado | 8075 | 5165 | 93 |
1992386 | 1992386 | 2021-12-08 | Logan | Colorado | 8075 | 5151 | 93 |
1989135 | 1989135 | 2021-12-07 | Logan | Colorado | 8075 | 5138 | 93 |
1985885 | 1985885 | 2021-12-06 | Logan | Colorado | 8075 | 5116 | 92 |
1982635 | 1982635 | 2021-12-05 | Logan | Colorado | 8075 | 5099 | 92 |
1979385 | 1979385 | 2021-12-04 | Logan | Colorado | 8075 | 5099 | 92 |
1976135 | 1976135 | 2021-12-03 | Logan | Colorado | 8075 | 5099 | 92 |
1972886 | 1972886 | 2021-12-02 | Logan | Colorado | 8075 | 5093 | 92 |
1969636 | 1969636 | 2021-12-01 | Logan | Colorado | 8075 | 5091 | 92 |
1966386 | 1966386 | 2021-11-30 | Logan | Colorado | 8075 | 5076 | 92 |
1963134 | 1963134 | 2021-11-29 | Logan | Colorado | 8075 | 5070 | 92 |
1959883 | 1959883 | 2021-11-28 | Logan | Colorado | 8075 | 5044 | 91 |
1956632 | 1956632 | 2021-11-27 | Logan | Colorado | 8075 | 5044 | 91 |
1953381 | 1953381 | 2021-11-26 | Logan | Colorado | 8075 | 5044 | 91 |
1950130 | 1950130 | 2021-11-25 | Logan | Colorado | 8075 | 5044 | 91 |
1946879 | 1946879 | 2021-11-24 | Logan | Colorado | 8075 | 5037 | 92 |
1943628 | 1943628 | 2021-11-23 | Logan | Colorado | 8075 | 5026 | 91 |
1940378 | 1940378 | 2021-11-22 | Logan | Colorado | 8075 | 5014 | 91 |
1937128 | 1937128 | 2021-11-21 | Logan | Colorado | 8075 | 4974 | 89 |
1933878 | 1933878 | 2021-11-20 | Logan | Colorado | 8075 | 4974 | 89 |
1930626 | 1930626 | 2021-11-19 | Logan | Colorado | 8075 | 4974 | 89 |
1927376 | 1927376 | 2021-11-18 | Logan | Colorado | 8075 | 4966 | 89 |
1924126 | 1924126 | 2021-11-17 | Logan | Colorado | 8075 | 4952 | 88 |
1920877 | 1920877 | 2021-11-16 | Logan | Colorado | 8075 | 4938 | 87 |
1917627 | 1917627 | 2021-11-15 | Logan | Colorado | 8075 | 4930 | 87 |
1914377 | 1914377 | 2021-11-14 | Logan | Colorado | 8075 | 4912 | 87 |
1911127 | 1911127 | 2021-11-13 | Logan | Colorado | 8075 | 4912 | 87 |
1907878 | 1907878 | 2021-11-12 | Logan | Colorado | 8075 | 4912 | 87 |
1904629 | 1904629 | 2021-11-11 | Logan | Colorado | 8075 | 4906 | 87 |
1901379 | 1901379 | 2021-11-10 | Logan | Colorado | 8075 | 4890 | 87 |
1898129 | 1898129 | 2021-11-09 | Logan | Colorado | 8075 | 4880 | 87 |
1894879 | 1894879 | 2021-11-08 | Logan | Colorado | 8075 | 4868 | 87 |
1891629 | 1891629 | 2021-11-07 | Logan | Colorado | 8075 | 4831 | 87 |
1888379 | 1888379 | 2021-11-06 | Logan | Colorado | 8075 | 4831 | 87 |
1885129 | 1885129 | 2021-11-05 | Logan | Colorado | 8075 | 4831 | 87 |
1881880 | 1881880 | 2021-11-04 | Logan | Colorado | 8075 | 4818 | 87 |
1878631 | 1878631 | 2021-11-03 | Logan | Colorado | 8075 | 4807 | 84 |
1875382 | 1875382 | 2021-11-02 | Logan | Colorado | 8075 | 4796 | 84 |
1872133 | 1872133 | 2021-11-01 | Logan | Colorado | 8075 | 4776 | 83 |
1868884 | 1868884 | 2021-10-31 | Logan | Colorado | 8075 | 4752 | 82 |
1865635 | 1865635 | 2021-10-30 | Logan | Colorado | 8075 | 4752 | 82 |
1862386 | 1862386 | 2021-10-29 | Logan | Colorado | 8075 | 4752 | 82 |
1859137 | 1859137 | 2021-10-28 | Logan | Colorado | 8075 | 4737 | 82 |
1855888 | 1855888 | 2021-10-27 | Logan | Colorado | 8075 | 4730 | 82 |
1852639 | 1852639 | 2021-10-26 | Logan | Colorado | 8075 | 4705 | 82 |
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);