ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Olmsted" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110511 | 2110511 | 2022-01-13 | Olmsted | Minnesota | 27109 | 28820 | 146 |
2107260 | 2107260 | 2022-01-12 | Olmsted | Minnesota | 27109 | 28251 | 146 |
2104009 | 2104009 | 2022-01-11 | Olmsted | Minnesota | 27109 | 27729 | 144 |
2100758 | 2100758 | 2022-01-10 | Olmsted | Minnesota | 27109 | 26503 | 144 |
2097507 | 2097507 | 2022-01-09 | Olmsted | Minnesota | 27109 | 26053 | 144 |
2094255 | 2094255 | 2022-01-08 | Olmsted | Minnesota | 27109 | 26053 | 144 |
2091003 | 2091003 | 2022-01-07 | Olmsted | Minnesota | 27109 | 26053 | 144 |
2087752 | 2087752 | 2022-01-06 | Olmsted | Minnesota | 27109 | 25593 | 143 |
2084500 | 2084500 | 2022-01-05 | Olmsted | Minnesota | 27109 | 25375 | 143 |
2081248 | 2081248 | 2022-01-04 | Olmsted | Minnesota | 27109 | 25308 | 143 |
2077996 | 2077996 | 2022-01-03 | Olmsted | Minnesota | 27109 | 25152 | 142 |
2074745 | 2074745 | 2022-01-02 | Olmsted | Minnesota | 27109 | 25067 | 139 |
2071494 | 2071494 | 2022-01-01 | Olmsted | Minnesota | 27109 | 25067 | 139 |
2068243 | 2068243 | 2021-12-31 | Olmsted | Minnesota | 27109 | 25067 | 139 |
2064992 | 2064992 | 2021-12-30 | Olmsted | Minnesota | 27109 | 25067 | 139 |
2061742 | 2061742 | 2021-12-29 | Olmsted | Minnesota | 27109 | 24873 | 139 |
2058493 | 2058493 | 2021-12-28 | Olmsted | Minnesota | 27109 | 24788 | 139 |
2055244 | 2055244 | 2021-12-27 | Olmsted | Minnesota | 27109 | 24517 | 139 |
2051994 | 2051994 | 2021-12-26 | Olmsted | Minnesota | 27109 | 24426 | 139 |
2048744 | 2048744 | 2021-12-25 | Olmsted | Minnesota | 27109 | 24426 | 139 |
2045494 | 2045494 | 2021-12-24 | Olmsted | Minnesota | 27109 | 24426 | 139 |
2042244 | 2042244 | 2021-12-23 | Olmsted | Minnesota | 27109 | 24426 | 139 |
2038995 | 2038995 | 2021-12-22 | Olmsted | Minnesota | 27109 | 24317 | 138 |
2035745 | 2035745 | 2021-12-21 | Olmsted | Minnesota | 27109 | 24259 | 137 |
2032495 | 2032495 | 2021-12-20 | Olmsted | Minnesota | 27109 | 24057 | 135 |
2029244 | 2029244 | 2021-12-19 | Olmsted | Minnesota | 27109 | 23986 | 135 |
2025993 | 2025993 | 2021-12-18 | Olmsted | Minnesota | 27109 | 23986 | 135 |
2022742 | 2022742 | 2021-12-17 | Olmsted | Minnesota | 27109 | 23986 | 135 |
2019491 | 2019491 | 2021-12-16 | Olmsted | Minnesota | 27109 | 23896 | 135 |
2016241 | 2016241 | 2021-12-15 | Olmsted | Minnesota | 27109 | 23793 | 135 |
2012990 | 2012990 | 2021-12-14 | Olmsted | Minnesota | 27109 | 23748 | 134 |
2009739 | 2009739 | 2021-12-13 | Olmsted | Minnesota | 27109 | 23539 | 133 |
2006488 | 2006488 | 2021-12-12 | Olmsted | Minnesota | 27109 | 23454 | 132 |
2003237 | 2003237 | 2021-12-11 | Olmsted | Minnesota | 27109 | 23454 | 132 |
1999987 | 1999987 | 2021-12-10 | Olmsted | Minnesota | 27109 | 23454 | 132 |
1996736 | 1996736 | 2021-12-09 | Olmsted | Minnesota | 27109 | 23374 | 132 |
1993485 | 1993485 | 2021-12-08 | Olmsted | Minnesota | 27109 | 23233 | 132 |
1990234 | 1990234 | 2021-12-07 | Olmsted | Minnesota | 27109 | 23165 | 132 |
1986984 | 1986984 | 2021-12-06 | Olmsted | Minnesota | 27109 | 22837 | 131 |
1983734 | 1983734 | 2021-12-05 | Olmsted | Minnesota | 27109 | 22677 | 131 |
1980484 | 1980484 | 2021-12-04 | Olmsted | Minnesota | 27109 | 22677 | 131 |
1977234 | 1977234 | 2021-12-03 | Olmsted | Minnesota | 27109 | 22677 | 131 |
1973984 | 1973984 | 2021-12-02 | Olmsted | Minnesota | 27109 | 22502 | 130 |
1970735 | 1970735 | 2021-12-01 | Olmsted | Minnesota | 27109 | 22339 | 130 |
1967485 | 1967485 | 2021-11-30 | Olmsted | Minnesota | 27109 | 22258 | 128 |
1964233 | 1964233 | 2021-11-29 | Olmsted | Minnesota | 27109 | 21874 | 128 |
1960982 | 1960982 | 2021-11-28 | Olmsted | Minnesota | 27109 | 21750 | 127 |
1957731 | 1957731 | 2021-11-27 | Olmsted | Minnesota | 27109 | 21750 | 127 |
1954480 | 1954480 | 2021-11-26 | Olmsted | Minnesota | 27109 | 21750 | 127 |
1951229 | 1951229 | 2021-11-25 | Olmsted | Minnesota | 27109 | 21580 | 127 |
1947978 | 1947978 | 2021-11-24 | Olmsted | Minnesota | 27109 | 21580 | 127 |
1944727 | 1944727 | 2021-11-23 | Olmsted | Minnesota | 27109 | 21510 | 127 |
1941476 | 1941476 | 2021-11-22 | Olmsted | Minnesota | 27109 | 21150 | 126 |
1938226 | 1938226 | 2021-11-21 | Olmsted | Minnesota | 27109 | 21013 | 126 |
1934976 | 1934976 | 2021-11-20 | Olmsted | Minnesota | 27109 | 21013 | 126 |
1931726 | 1931726 | 2021-11-19 | Olmsted | Minnesota | 27109 | 21013 | 126 |
1928475 | 1928475 | 2021-11-18 | Olmsted | Minnesota | 27109 | 20834 | 126 |
1925225 | 1925225 | 2021-11-17 | Olmsted | Minnesota | 27109 | 20657 | 125 |
1921976 | 1921976 | 2021-11-16 | Olmsted | Minnesota | 27109 | 20591 | 123 |
1918726 | 1918726 | 2021-11-15 | Olmsted | Minnesota | 27109 | 20266 | 123 |
1915476 | 1915476 | 2021-11-14 | Olmsted | Minnesota | 27109 | 20113 | 123 |
1912226 | 1912226 | 2021-11-13 | Olmsted | Minnesota | 27109 | 20113 | 123 |
1908976 | 1908976 | 2021-11-12 | Olmsted | Minnesota | 27109 | 20113 | 123 |
1905727 | 1905727 | 2021-11-11 | Olmsted | Minnesota | 27109 | 19981 | 123 |
1902478 | 1902478 | 2021-11-10 | Olmsted | Minnesota | 27109 | 19815 | 123 |
1899228 | 1899228 | 2021-11-09 | Olmsted | Minnesota | 27109 | 19682 | 123 |
1895978 | 1895978 | 2021-11-08 | Olmsted | Minnesota | 27109 | 19492 | 123 |
1892728 | 1892728 | 2021-11-07 | Olmsted | Minnesota | 27109 | 19396 | 123 |
1889478 | 1889478 | 2021-11-06 | Olmsted | Minnesota | 27109 | 19396 | 123 |
1886228 | 1886228 | 2021-11-05 | Olmsted | Minnesota | 27109 | 19396 | 123 |
1882979 | 1882979 | 2021-11-04 | Olmsted | Minnesota | 27109 | 19309 | 121 |
1879730 | 1879730 | 2021-11-03 | Olmsted | Minnesota | 27109 | 19151 | 120 |
1876481 | 1876481 | 2021-11-02 | Olmsted | Minnesota | 27109 | 19070 | 120 |
1873232 | 1873232 | 2021-11-01 | Olmsted | Minnesota | 27109 | 18841 | 120 |
1869983 | 1869983 | 2021-10-31 | Olmsted | Minnesota | 27109 | 18669 | 120 |
1866734 | 1866734 | 2021-10-30 | Olmsted | Minnesota | 27109 | 18669 | 120 |
1863485 | 1863485 | 2021-10-29 | Olmsted | Minnesota | 27109 | 18669 | 120 |
1860236 | 1860236 | 2021-10-28 | Olmsted | Minnesota | 27109 | 18534 | 120 |
1856987 | 1856987 | 2021-10-27 | Olmsted | Minnesota | 27109 | 18469 | 120 |
1853738 | 1853738 | 2021-10-26 | Olmsted | Minnesota | 27109 | 18423 | 120 |
1850489 | 1850489 | 2021-10-25 | Olmsted | Minnesota | 27109 | 18209 | 120 |
1847239 | 1847239 | 2021-10-24 | Olmsted | Minnesota | 27109 | 18144 | 120 |
1843989 | 1843989 | 2021-10-23 | Olmsted | Minnesota | 27109 | 18144 | 120 |
1840739 | 1840739 | 2021-10-22 | Olmsted | Minnesota | 27109 | 18144 | 120 |
1837490 | 1837490 | 2021-10-21 | Olmsted | Minnesota | 27109 | 18125 | 120 |
1834241 | 1834241 | 2021-10-20 | Olmsted | Minnesota | 27109 | 18060 | 120 |
1830992 | 1830992 | 2021-10-19 | Olmsted | Minnesota | 27109 | 18023 | 118 |
1827743 | 1827743 | 2021-10-18 | Olmsted | Minnesota | 27109 | 17894 | 118 |
1824494 | 1824494 | 2021-10-17 | Olmsted | Minnesota | 27109 | 17821 | 118 |
1821245 | 1821245 | 2021-10-16 | Olmsted | Minnesota | 27109 | 17821 | 118 |
1817996 | 1817996 | 2021-10-15 | Olmsted | Minnesota | 27109 | 17821 | 118 |
1814747 | 1814747 | 2021-10-14 | Olmsted | Minnesota | 27109 | 17737 | 118 |
1811499 | 1811499 | 2021-10-13 | Olmsted | Minnesota | 27109 | 17646 | 118 |
1808250 | 1808250 | 2021-10-12 | Olmsted | Minnesota | 27109 | 17590 | 118 |
1804999 | 1804999 | 2021-10-11 | Olmsted | Minnesota | 27109 | 17346 | 117 |
1801750 | 1801750 | 2021-10-10 | Olmsted | Minnesota | 27109 | 17275 | 117 |
1798501 | 1798501 | 2021-10-09 | Olmsted | Minnesota | 27109 | 17275 | 117 |
1795252 | 1795252 | 2021-10-08 | Olmsted | Minnesota | 27109 | 17275 | 117 |
1792003 | 1792003 | 2021-10-07 | Olmsted | Minnesota | 27109 | 17195 | 117 |
1788754 | 1788754 | 2021-10-06 | Olmsted | Minnesota | 27109 | 17093 | 115 |
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);