ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
330 rows where deaths = 31 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Mower 42
- Waseca 30
- Faribault 25
- Roseau 24
- Swift 21
- Martin 16
- Pipestone 14
- Pennington 13
- Freeborn 12
- Aitkin 11
- Todd 9
- Meeker 7
- Unknown 7
- Chippewa 6
- Mille Lacs 6
- Rock 6
- Steele 6
- Cass 5
- Crow Wing 5
- Isanti 5
- Koochiching 5
- Le Sueur 5
- Scott 5
- Wadena 5
- Hubbard 4
- Becker 3
- Sherburne 3
- Anoka 2
- Clay 2
- Douglas 2
- …
state 1
- Minnesota · 330 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2201622 | 2201622 | 2022-02-10 | Swift | Minnesota | 27151 | 2203 | 31 |
2198368 | 2198368 | 2022-02-09 | Swift | Minnesota | 27151 | 2186 | 31 |
2195114 | 2195114 | 2022-02-08 | Swift | Minnesota | 27151 | 2166 | 31 |
2191860 | 2191860 | 2022-02-07 | Swift | Minnesota | 27151 | 2143 | 31 |
2188607 | 2188607 | 2022-02-06 | Swift | Minnesota | 27151 | 2132 | 31 |
2185354 | 2185354 | 2022-02-05 | Swift | Minnesota | 27151 | 2132 | 31 |
2182102 | 2182102 | 2022-02-04 | Swift | Minnesota | 27151 | 2132 | 31 |
2178850 | 2178850 | 2022-02-03 | Swift | Minnesota | 27151 | 2122 | 31 |
2175598 | 2175598 | 2022-02-02 | Swift | Minnesota | 27151 | 2114 | 31 |
2172345 | 2172345 | 2022-02-01 | Swift | Minnesota | 27151 | 2100 | 31 |
2169092 | 2169092 | 2022-01-31 | Swift | Minnesota | 27151 | 2071 | 31 |
2165837 | 2165837 | 2022-01-30 | Swift | Minnesota | 27151 | 2038 | 31 |
2162582 | 2162582 | 2022-01-29 | Swift | Minnesota | 27151 | 2038 | 31 |
2159327 | 2159327 | 2022-01-28 | Swift | Minnesota | 27151 | 2038 | 31 |
2156073 | 2156073 | 2022-01-27 | Swift | Minnesota | 27151 | 2026 | 31 |
2152820 | 2152820 | 2022-01-26 | Swift | Minnesota | 27151 | 1991 | 31 |
2149551 | 2149551 | 2022-01-25 | Pipestone | Minnesota | 27117 | 1824 | 31 |
2149568 | 2149568 | 2022-01-25 | Swift | Minnesota | 27151 | 1968 | 31 |
2146299 | 2146299 | 2022-01-24 | Pipestone | Minnesota | 27117 | 1800 | 31 |
2146316 | 2146316 | 2022-01-24 | Swift | Minnesota | 27151 | 1940 | 31 |
2143044 | 2143044 | 2022-01-23 | Pipestone | Minnesota | 27117 | 1787 | 31 |
2143061 | 2143061 | 2022-01-23 | Swift | Minnesota | 27151 | 1932 | 31 |
2139789 | 2139789 | 2022-01-22 | Pipestone | Minnesota | 27117 | 1787 | 31 |
2139806 | 2139806 | 2022-01-22 | Swift | Minnesota | 27151 | 1932 | 31 |
2136533 | 2136533 | 2022-01-21 | Pipestone | Minnesota | 27117 | 1787 | 31 |
2136550 | 2136550 | 2022-01-21 | Swift | Minnesota | 27151 | 1932 | 31 |
2133281 | 2133281 | 2022-01-20 | Pipestone | Minnesota | 27117 | 1765 | 31 |
2130028 | 2130028 | 2022-01-19 | Pipestone | Minnesota | 27117 | 1755 | 31 |
2126774 | 2126774 | 2022-01-18 | Pipestone | Minnesota | 27117 | 1720 | 31 |
2123522 | 2123522 | 2022-01-17 | Pipestone | Minnesota | 27117 | 1715 | 31 |
2120270 | 2120270 | 2022-01-16 | Pipestone | Minnesota | 27117 | 1715 | 31 |
2117018 | 2117018 | 2022-01-15 | Pipestone | Minnesota | 27117 | 1715 | 31 |
2113767 | 2113767 | 2022-01-14 | Pipestone | Minnesota | 27117 | 1715 | 31 |
2110515 | 2110515 | 2022-01-13 | Pipestone | Minnesota | 27117 | 1705 | 31 |
2107264 | 2107264 | 2022-01-12 | Pipestone | Minnesota | 27117 | 1700 | 31 |
2100739 | 2100739 | 2022-01-10 | Koochiching | Minnesota | 27071 | 2032 | 31 |
2097488 | 2097488 | 2022-01-09 | Koochiching | Minnesota | 27071 | 2030 | 31 |
2094236 | 2094236 | 2022-01-08 | Koochiching | Minnesota | 27071 | 2030 | 31 |
2090984 | 2090984 | 2022-01-07 | Koochiching | Minnesota | 27071 | 2030 | 31 |
2087733 | 2087733 | 2022-01-06 | Koochiching | Minnesota | 27071 | 2027 | 31 |
2061744 | 2061744 | 2021-12-29 | Pennington | Minnesota | 27113 | 2664 | 31 |
2058495 | 2058495 | 2021-12-28 | Pennington | Minnesota | 27113 | 2661 | 31 |
2055246 | 2055246 | 2021-12-27 | Pennington | Minnesota | 27113 | 2653 | 31 |
2051996 | 2051996 | 2021-12-26 | Pennington | Minnesota | 27113 | 2646 | 31 |
2048746 | 2048746 | 2021-12-25 | Pennington | Minnesota | 27113 | 2646 | 31 |
2045496 | 2045496 | 2021-12-24 | Pennington | Minnesota | 27113 | 2646 | 31 |
2042246 | 2042246 | 2021-12-23 | Pennington | Minnesota | 27113 | 2646 | 31 |
2038997 | 2038997 | 2021-12-22 | Pennington | Minnesota | 27113 | 2644 | 31 |
2035747 | 2035747 | 2021-12-21 | Pennington | Minnesota | 27113 | 2641 | 31 |
2032497 | 2032497 | 2021-12-20 | Pennington | Minnesota | 27113 | 2638 | 31 |
2029246 | 2029246 | 2021-12-19 | Pennington | Minnesota | 27113 | 2631 | 31 |
2025995 | 2025995 | 2021-12-18 | Pennington | Minnesota | 27113 | 2631 | 31 |
2022744 | 2022744 | 2021-12-17 | Pennington | Minnesota | 27113 | 2631 | 31 |
2009751 | 2009751 | 2021-12-13 | Rock | Minnesota | 27133 | 1805 | 31 |
2006500 | 2006500 | 2021-12-12 | Rock | Minnesota | 27133 | 1801 | 31 |
2003249 | 2003249 | 2021-12-11 | Rock | Minnesota | 27133 | 1801 | 31 |
1999999 | 1999999 | 2021-12-10 | Rock | Minnesota | 27133 | 1801 | 31 |
1996748 | 1996748 | 2021-12-09 | Rock | Minnesota | 27133 | 1798 | 31 |
1993497 | 1993497 | 2021-12-08 | Rock | Minnesota | 27133 | 1795 | 31 |
1973997 | 1973997 | 2021-12-02 | Roseau | Minnesota | 27135 | 3186 | 31 |
1970748 | 1970748 | 2021-12-01 | Roseau | Minnesota | 27135 | 3162 | 31 |
1970754 | 1970754 | 2021-12-01 | Steele | Minnesota | 27147 | 6857 | 31 |
1967498 | 1967498 | 2021-11-30 | Roseau | Minnesota | 27135 | 3155 | 31 |
1967504 | 1967504 | 2021-11-30 | Steele | Minnesota | 27147 | 6827 | 31 |
1964246 | 1964246 | 2021-11-29 | Roseau | Minnesota | 27135 | 3120 | 31 |
1964252 | 1964252 | 2021-11-29 | Steele | Minnesota | 27147 | 6728 | 31 |
1960995 | 1960995 | 2021-11-28 | Roseau | Minnesota | 27135 | 3079 | 31 |
1961001 | 1961001 | 2021-11-28 | Steele | Minnesota | 27147 | 6694 | 31 |
1957744 | 1957744 | 2021-11-27 | Roseau | Minnesota | 27135 | 3079 | 31 |
1957750 | 1957750 | 2021-11-27 | Steele | Minnesota | 27147 | 6694 | 31 |
1954493 | 1954493 | 2021-11-26 | Roseau | Minnesota | 27135 | 3079 | 31 |
1954499 | 1954499 | 2021-11-26 | Steele | Minnesota | 27147 | 6694 | 31 |
1951196 | 1951196 | 2021-11-25 | Faribault | Minnesota | 27043 | 2524 | 31 |
1951242 | 1951242 | 2021-11-25 | Roseau | Minnesota | 27135 | 3076 | 31 |
1947945 | 1947945 | 2021-11-24 | Faribault | Minnesota | 27043 | 2524 | 31 |
1947991 | 1947991 | 2021-11-24 | Roseau | Minnesota | 27135 | 3076 | 31 |
1944694 | 1944694 | 2021-11-23 | Faribault | Minnesota | 27043 | 2514 | 31 |
1944740 | 1944740 | 2021-11-23 | Roseau | Minnesota | 27135 | 3073 | 31 |
1941443 | 1941443 | 2021-11-22 | Faribault | Minnesota | 27043 | 2483 | 31 |
1941489 | 1941489 | 2021-11-22 | Roseau | Minnesota | 27135 | 3047 | 31 |
1938193 | 1938193 | 2021-11-21 | Faribault | Minnesota | 27043 | 2467 | 31 |
1938239 | 1938239 | 2021-11-21 | Roseau | Minnesota | 27135 | 3035 | 31 |
1934943 | 1934943 | 2021-11-20 | Faribault | Minnesota | 27043 | 2467 | 31 |
1934989 | 1934989 | 2021-11-20 | Roseau | Minnesota | 27135 | 3035 | 31 |
1931693 | 1931693 | 2021-11-19 | Faribault | Minnesota | 27043 | 2467 | 31 |
1931739 | 1931739 | 2021-11-19 | Roseau | Minnesota | 27135 | 3035 | 31 |
1928442 | 1928442 | 2021-11-18 | Faribault | Minnesota | 27043 | 2452 | 31 |
1928488 | 1928488 | 2021-11-18 | Roseau | Minnesota | 27135 | 3008 | 31 |
1928502 | 1928502 | 2021-11-18 | Waseca | Minnesota | 27161 | 3551 | 31 |
1925192 | 1925192 | 2021-11-17 | Faribault | Minnesota | 27043 | 2436 | 31 |
1925238 | 1925238 | 2021-11-17 | Roseau | Minnesota | 27135 | 2981 | 31 |
1925252 | 1925252 | 2021-11-17 | Waseca | Minnesota | 27161 | 3541 | 31 |
1921938 | 1921938 | 2021-11-16 | Cottonwood | Minnesota | 27033 | 2155 | 31 |
1921943 | 1921943 | 2021-11-16 | Faribault | Minnesota | 27043 | 2435 | 31 |
1921989 | 1921989 | 2021-11-16 | Roseau | Minnesota | 27135 | 2956 | 31 |
1922003 | 1922003 | 2021-11-16 | Waseca | Minnesota | 27161 | 3530 | 31 |
1918693 | 1918693 | 2021-11-15 | Faribault | Minnesota | 27043 | 2404 | 31 |
1918739 | 1918739 | 2021-11-15 | Roseau | Minnesota | 27135 | 2908 | 31 |
1918753 | 1918753 | 2021-11-15 | Waseca | Minnesota | 27161 | 3510 | 31 |
1915443 | 1915443 | 2021-11-14 | Faribault | Minnesota | 27043 | 2387 | 31 |
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);