ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
813 rows where deaths = 20 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Yellow Medicine 187
- Pennington 100
- Lake 76
- Cottonwood 64
- Wadena 50
- Pine 29
- Le Sueur 25
- Waseca 23
- Clearwater 22
- Sibley 22
- Faribault 21
- Stearns 19
- Martin 13
- Roseau 13
- Watonwan 13
- Dodge 11
- Marshall 11
- Olmsted 9
- Cass 8
- Kittson 8
- Swift 8
- Nicollet 7
- Winona 6
- Koochiching 5
- Crow Wing 4
- Fillmore 4
- Goodhue 4
- Redwood 4
- St. Louis 4
- Steele 4
- …
state 1
- Minnesota · 813 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2260091 | 2260091 | 2022-02-28 | Dodge | Minnesota | 27039 | 5565 | 20 |
2256840 | 2256840 | 2022-02-27 | Dodge | Minnesota | 27039 | 5561 | 20 |
2253589 | 2253589 | 2022-02-26 | Dodge | Minnesota | 27039 | 5561 | 20 |
2250338 | 2250338 | 2022-02-25 | Dodge | Minnesota | 27039 | 5561 | 20 |
2247087 | 2247087 | 2022-02-24 | Dodge | Minnesota | 27039 | 5561 | 20 |
2243836 | 2243836 | 2022-02-23 | Dodge | Minnesota | 27039 | 5552 | 20 |
2240585 | 2240585 | 2022-02-22 | Dodge | Minnesota | 27039 | 5527 | 20 |
2237334 | 2237334 | 2022-02-21 | Dodge | Minnesota | 27039 | 5521 | 20 |
2234083 | 2234083 | 2022-02-20 | Dodge | Minnesota | 27039 | 5521 | 20 |
2230832 | 2230832 | 2022-02-19 | Dodge | Minnesota | 27039 | 5521 | 20 |
2227581 | 2227581 | 2022-02-18 | Dodge | Minnesota | 27039 | 5521 | 20 |
2178859 | 2178859 | 2022-02-03 | Wilkin | Minnesota | 27167 | 1507 | 20 |
2175607 | 2175607 | 2022-02-02 | Wilkin | Minnesota | 27167 | 1504 | 20 |
2172354 | 2172354 | 2022-02-01 | Wilkin | Minnesota | 27167 | 1492 | 20 |
2156020 | 2156020 | 2022-01-27 | Fillmore | Minnesota | 27045 | 4153 | 20 |
2152767 | 2152767 | 2022-01-26 | Fillmore | Minnesota | 27045 | 4088 | 20 |
2149515 | 2149515 | 2022-01-25 | Fillmore | Minnesota | 27045 | 4048 | 20 |
2146263 | 2146263 | 2022-01-24 | Fillmore | Minnesota | 27045 | 3956 | 20 |
2084516 | 2084516 | 2022-01-05 | Sibley | Minnesota | 27143 | 2815 | 20 |
2081264 | 2081264 | 2022-01-04 | Sibley | Minnesota | 27143 | 2812 | 20 |
2078012 | 2078012 | 2022-01-03 | Sibley | Minnesota | 27143 | 2803 | 20 |
2074761 | 2074761 | 2022-01-02 | Sibley | Minnesota | 27143 | 2801 | 20 |
2071510 | 2071510 | 2022-01-01 | Sibley | Minnesota | 27143 | 2801 | 20 |
2068259 | 2068259 | 2021-12-31 | Sibley | Minnesota | 27143 | 2801 | 20 |
2065008 | 2065008 | 2021-12-30 | Sibley | Minnesota | 27143 | 2801 | 20 |
2061758 | 2061758 | 2021-12-29 | Sibley | Minnesota | 27143 | 2794 | 20 |
2058509 | 2058509 | 2021-12-28 | Sibley | Minnesota | 27143 | 2789 | 20 |
2055260 | 2055260 | 2021-12-27 | Sibley | Minnesota | 27143 | 2770 | 20 |
2052010 | 2052010 | 2021-12-26 | Sibley | Minnesota | 27143 | 2760 | 20 |
2048760 | 2048760 | 2021-12-25 | Sibley | Minnesota | 27143 | 2760 | 20 |
2045510 | 2045510 | 2021-12-24 | Sibley | Minnesota | 27143 | 2760 | 20 |
2042260 | 2042260 | 2021-12-23 | Sibley | Minnesota | 27143 | 2760 | 20 |
2039011 | 2039011 | 2021-12-22 | Sibley | Minnesota | 27143 | 2753 | 20 |
2035761 | 2035761 | 2021-12-21 | Sibley | Minnesota | 27143 | 2746 | 20 |
2032511 | 2032511 | 2021-12-20 | Sibley | Minnesota | 27143 | 2734 | 20 |
2029260 | 2029260 | 2021-12-19 | Sibley | Minnesota | 27143 | 2725 | 20 |
2026009 | 2026009 | 2021-12-18 | Sibley | Minnesota | 27143 | 2725 | 20 |
2022758 | 2022758 | 2021-12-17 | Sibley | Minnesota | 27143 | 2725 | 20 |
2019507 | 2019507 | 2021-12-16 | Sibley | Minnesota | 27143 | 2716 | 20 |
2016257 | 2016257 | 2021-12-15 | Sibley | Minnesota | 27143 | 2708 | 20 |
1970695 | 1970695 | 2021-12-01 | Clearwater | Minnesota | 27029 | 1580 | 20 |
1970764 | 1970764 | 2021-12-01 | Watonwan | Minnesota | 27165 | 1980 | 20 |
1967445 | 1967445 | 2021-11-30 | Clearwater | Minnesota | 27029 | 1575 | 20 |
1967514 | 1967514 | 2021-11-30 | Watonwan | Minnesota | 27165 | 1974 | 20 |
1964193 | 1964193 | 2021-11-29 | Clearwater | Minnesota | 27029 | 1564 | 20 |
1964262 | 1964262 | 2021-11-29 | Watonwan | Minnesota | 27165 | 1954 | 20 |
1960942 | 1960942 | 2021-11-28 | Clearwater | Minnesota | 27029 | 1557 | 20 |
1961011 | 1961011 | 2021-11-28 | Watonwan | Minnesota | 27165 | 1949 | 20 |
1957691 | 1957691 | 2021-11-27 | Clearwater | Minnesota | 27029 | 1557 | 20 |
1957760 | 1957760 | 2021-11-27 | Watonwan | Minnesota | 27165 | 1949 | 20 |
1954440 | 1954440 | 2021-11-26 | Clearwater | Minnesota | 27029 | 1557 | 20 |
1954509 | 1954509 | 2021-11-26 | Watonwan | Minnesota | 27165 | 1949 | 20 |
1951189 | 1951189 | 2021-11-25 | Clearwater | Minnesota | 27029 | 1551 | 20 |
1951258 | 1951258 | 2021-11-25 | Watonwan | Minnesota | 27165 | 1937 | 20 |
1947938 | 1947938 | 2021-11-24 | Clearwater | Minnesota | 27029 | 1551 | 20 |
1948007 | 1948007 | 2021-11-24 | Watonwan | Minnesota | 27165 | 1937 | 20 |
1944687 | 1944687 | 2021-11-23 | Clearwater | Minnesota | 27029 | 1544 | 20 |
1944756 | 1944756 | 2021-11-23 | Watonwan | Minnesota | 27165 | 1932 | 20 |
1941436 | 1941436 | 2021-11-22 | Clearwater | Minnesota | 27029 | 1522 | 20 |
1941505 | 1941505 | 2021-11-22 | Watonwan | Minnesota | 27165 | 1923 | 20 |
1938186 | 1938186 | 2021-11-21 | Clearwater | Minnesota | 27029 | 1512 | 20 |
1938255 | 1938255 | 2021-11-21 | Watonwan | Minnesota | 27165 | 1916 | 20 |
1934936 | 1934936 | 2021-11-20 | Clearwater | Minnesota | 27029 | 1512 | 20 |
1935005 | 1935005 | 2021-11-20 | Watonwan | Minnesota | 27165 | 1916 | 20 |
1931686 | 1931686 | 2021-11-19 | Clearwater | Minnesota | 27029 | 1512 | 20 |
1931755 | 1931755 | 2021-11-19 | Watonwan | Minnesota | 27165 | 1916 | 20 |
1928435 | 1928435 | 2021-11-18 | Clearwater | Minnesota | 27029 | 1501 | 20 |
1925185 | 1925185 | 2021-11-17 | Clearwater | Minnesota | 27029 | 1491 | 20 |
1921936 | 1921936 | 2021-11-16 | Clearwater | Minnesota | 27029 | 1488 | 20 |
1918686 | 1918686 | 2021-11-15 | Clearwater | Minnesota | 27029 | 1474 | 20 |
1918747 | 1918747 | 2021-11-15 | Swift | Minnesota | 27151 | 1581 | 20 |
1915436 | 1915436 | 2021-11-14 | Clearwater | Minnesota | 27029 | 1467 | 20 |
1915497 | 1915497 | 2021-11-14 | Swift | Minnesota | 27151 | 1560 | 20 |
1912186 | 1912186 | 2021-11-13 | Clearwater | Minnesota | 27029 | 1467 | 20 |
1912247 | 1912247 | 2021-11-13 | Swift | Minnesota | 27151 | 1560 | 20 |
1908936 | 1908936 | 2021-11-12 | Clearwater | Minnesota | 27029 | 1467 | 20 |
1908997 | 1908997 | 2021-11-12 | Swift | Minnesota | 27151 | 1560 | 20 |
1905687 | 1905687 | 2021-11-11 | Clearwater | Minnesota | 27029 | 1459 | 20 |
1905748 | 1905748 | 2021-11-11 | Swift | Minnesota | 27151 | 1548 | 20 |
1902438 | 1902438 | 2021-11-10 | Clearwater | Minnesota | 27029 | 1454 | 20 |
1902499 | 1902499 | 2021-11-10 | Swift | Minnesota | 27151 | 1536 | 20 |
1899249 | 1899249 | 2021-11-09 | Swift | Minnesota | 27151 | 1521 | 20 |
1895999 | 1895999 | 2021-11-08 | Swift | Minnesota | 27151 | 1500 | 20 |
1892709 | 1892709 | 2021-11-07 | Koochiching | Minnesota | 27071 | 1461 | 20 |
1889459 | 1889459 | 2021-11-06 | Koochiching | Minnesota | 27071 | 1461 | 20 |
1886209 | 1886209 | 2021-11-05 | Koochiching | Minnesota | 27071 | 1461 | 20 |
1882960 | 1882960 | 2021-11-04 | Koochiching | Minnesota | 27071 | 1458 | 20 |
1879711 | 1879711 | 2021-11-03 | Koochiching | Minnesota | 27071 | 1452 | 20 |
1869972 | 1869972 | 2021-10-31 | Marshall | Minnesota | 27089 | 1366 | 20 |
1866723 | 1866723 | 2021-10-30 | Marshall | Minnesota | 27089 | 1366 | 20 |
1863474 | 1863474 | 2021-10-29 | Marshall | Minnesota | 27089 | 1366 | 20 |
1860225 | 1860225 | 2021-10-28 | Marshall | Minnesota | 27089 | 1365 | 20 |
1856976 | 1856976 | 2021-10-27 | Marshall | Minnesota | 27089 | 1357 | 20 |
1853727 | 1853727 | 2021-10-26 | Marshall | Minnesota | 27089 | 1351 | 20 |
1853771 | 1853771 | 2021-10-26 | Yellow Medicine | Minnesota | 27173 | 1606 | 20 |
1850478 | 1850478 | 2021-10-25 | Marshall | Minnesota | 27089 | 1346 | 20 |
1850522 | 1850522 | 2021-10-25 | Yellow Medicine | Minnesota | 27173 | 1584 | 20 |
1847228 | 1847228 | 2021-10-24 | Marshall | Minnesota | 27089 | 1345 | 20 |
1847272 | 1847272 | 2021-10-24 | Yellow Medicine | Minnesota | 27173 | 1572 | 20 |
1843978 | 1843978 | 2021-10-23 | Marshall | Minnesota | 27089 | 1345 | 20 |
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);