ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
997 rows where deaths = 19 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Rock 203
- Koochiching 123
- Faribault 107
- Swift 62
- Pennington 57
- Lake 52
- Steele 51
- Stearns 45
- Roseau 39
- Marshall 28
- Wilkin 27
- Kanabec 23
- Wadena 22
- Waseca 16
- Kittson 12
- Yellow Medicine 12
- Winona 11
- St. Louis 10
- Cottonwood 9
- Martin 8
- Sibley 8
- Cass 7
- Chippewa 7
- Itasca 6
- Beltrami 4
- Fillmore 4
- Redwood 4
- Dodge 3
- Freeborn 3
- Kandiyohi 3
- …
state 1
- Minnesota · 997 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500932 | 2500932 | 2022-05-13 | Houston | Minnesota | 27055 | 4660 | 19 |
2497674 | 2497674 | 2022-05-12 | Houston | Minnesota | 27055 | 4653 | 19 |
2224330 | 2224330 | 2022-02-17 | Dodge | Minnesota | 27039 | 5509 | 19 |
2221079 | 2221079 | 2022-02-16 | Dodge | Minnesota | 27039 | 5502 | 19 |
2217828 | 2217828 | 2022-02-15 | Dodge | Minnesota | 27039 | 5501 | 19 |
2169101 | 2169101 | 2022-01-31 | Wilkin | Minnesota | 27167 | 1484 | 19 |
2165846 | 2165846 | 2022-01-30 | Wilkin | Minnesota | 27167 | 1470 | 19 |
2162591 | 2162591 | 2022-01-29 | Wilkin | Minnesota | 27167 | 1470 | 19 |
2159336 | 2159336 | 2022-01-28 | Wilkin | Minnesota | 27167 | 1470 | 19 |
2156082 | 2156082 | 2022-01-27 | Wilkin | Minnesota | 27167 | 1463 | 19 |
2152829 | 2152829 | 2022-01-26 | Wilkin | Minnesota | 27167 | 1438 | 19 |
2149577 | 2149577 | 2022-01-25 | Wilkin | Minnesota | 27167 | 1429 | 19 |
2146325 | 2146325 | 2022-01-24 | Wilkin | Minnesota | 27167 | 1405 | 19 |
2143008 | 2143008 | 2022-01-23 | Fillmore | Minnesota | 27045 | 3919 | 19 |
2143070 | 2143070 | 2022-01-23 | Wilkin | Minnesota | 27167 | 1399 | 19 |
2139753 | 2139753 | 2022-01-22 | Fillmore | Minnesota | 27045 | 3919 | 19 |
2139815 | 2139815 | 2022-01-22 | Wilkin | Minnesota | 27167 | 1399 | 19 |
2136497 | 2136497 | 2022-01-21 | Fillmore | Minnesota | 27045 | 3919 | 19 |
2136559 | 2136559 | 2022-01-21 | Wilkin | Minnesota | 27167 | 1399 | 19 |
2133245 | 2133245 | 2022-01-20 | Fillmore | Minnesota | 27045 | 3882 | 19 |
2133307 | 2133307 | 2022-01-20 | Wilkin | Minnesota | 27167 | 1391 | 19 |
2130054 | 2130054 | 2022-01-19 | Wilkin | Minnesota | 27167 | 1375 | 19 |
2126800 | 2126800 | 2022-01-18 | Wilkin | Minnesota | 27167 | 1347 | 19 |
2123548 | 2123548 | 2022-01-17 | Wilkin | Minnesota | 27167 | 1342 | 19 |
2120296 | 2120296 | 2022-01-16 | Wilkin | Minnesota | 27167 | 1342 | 19 |
2117044 | 2117044 | 2022-01-15 | Wilkin | Minnesota | 27167 | 1342 | 19 |
2113793 | 2113793 | 2022-01-14 | Wilkin | Minnesota | 27167 | 1342 | 19 |
2110541 | 2110541 | 2022-01-13 | Wilkin | Minnesota | 27167 | 1337 | 19 |
2107290 | 2107290 | 2022-01-12 | Wilkin | Minnesota | 27167 | 1327 | 19 |
2104039 | 2104039 | 2022-01-11 | Wilkin | Minnesota | 27167 | 1320 | 19 |
2100788 | 2100788 | 2022-01-10 | Wilkin | Minnesota | 27167 | 1314 | 19 |
2097537 | 2097537 | 2022-01-09 | Wilkin | Minnesota | 27167 | 1310 | 19 |
2094285 | 2094285 | 2022-01-08 | Wilkin | Minnesota | 27167 | 1310 | 19 |
2091033 | 2091033 | 2022-01-07 | Wilkin | Minnesota | 27167 | 1310 | 19 |
2087782 | 2087782 | 2022-01-06 | Wilkin | Minnesota | 27167 | 1307 | 19 |
2084530 | 2084530 | 2022-01-05 | Wilkin | Minnesota | 27167 | 1304 | 19 |
2013006 | 2013006 | 2021-12-14 | Sibley | Minnesota | 27143 | 2702 | 19 |
2009755 | 2009755 | 2021-12-13 | Sibley | Minnesota | 27143 | 2682 | 19 |
2006504 | 2006504 | 2021-12-12 | Sibley | Minnesota | 27143 | 2673 | 19 |
2003253 | 2003253 | 2021-12-11 | Sibley | Minnesota | 27143 | 2673 | 19 |
2000003 | 2000003 | 2021-12-10 | Sibley | Minnesota | 27143 | 2673 | 19 |
1996752 | 1996752 | 2021-12-09 | Sibley | Minnesota | 27143 | 2655 | 19 |
1993501 | 1993501 | 2021-12-08 | Sibley | Minnesota | 27143 | 2645 | 19 |
1990250 | 1990250 | 2021-12-07 | Sibley | Minnesota | 27143 | 2630 | 19 |
1928504 | 1928504 | 2021-11-18 | Watonwan | Minnesota | 27165 | 1904 | 19 |
1899188 | 1899188 | 2021-11-09 | Clearwater | Minnesota | 27029 | 1451 | 19 |
1895938 | 1895938 | 2021-11-08 | Clearwater | Minnesota | 27029 | 1439 | 19 |
1892749 | 1892749 | 2021-11-07 | Swift | Minnesota | 27151 | 1488 | 19 |
1889499 | 1889499 | 2021-11-06 | Swift | Minnesota | 27151 | 1488 | 19 |
1886249 | 1886249 | 2021-11-05 | Swift | Minnesota | 27151 | 1488 | 19 |
1883000 | 1883000 | 2021-11-04 | Swift | Minnesota | 27151 | 1476 | 19 |
1879742 | 1879742 | 2021-11-03 | Rock | Minnesota | 27133 | 1631 | 19 |
1879751 | 1879751 | 2021-11-03 | Swift | Minnesota | 27151 | 1467 | 19 |
1876462 | 1876462 | 2021-11-02 | Koochiching | Minnesota | 27071 | 1437 | 19 |
1876493 | 1876493 | 2021-11-02 | Rock | Minnesota | 27133 | 1630 | 19 |
1876502 | 1876502 | 2021-11-02 | Swift | Minnesota | 27151 | 1460 | 19 |
1873213 | 1873213 | 2021-11-01 | Koochiching | Minnesota | 27071 | 1426 | 19 |
1873244 | 1873244 | 2021-11-01 | Rock | Minnesota | 27133 | 1621 | 19 |
1873253 | 1873253 | 2021-11-01 | Swift | Minnesota | 27151 | 1419 | 19 |
1869964 | 1869964 | 2021-10-31 | Koochiching | Minnesota | 27071 | 1414 | 19 |
1869995 | 1869995 | 2021-10-31 | Rock | Minnesota | 27133 | 1597 | 19 |
1870004 | 1870004 | 2021-10-31 | Swift | Minnesota | 27151 | 1399 | 19 |
1866715 | 1866715 | 2021-10-30 | Koochiching | Minnesota | 27071 | 1414 | 19 |
1866746 | 1866746 | 2021-10-30 | Rock | Minnesota | 27133 | 1597 | 19 |
1866755 | 1866755 | 2021-10-30 | Swift | Minnesota | 27151 | 1399 | 19 |
1863466 | 1863466 | 2021-10-29 | Koochiching | Minnesota | 27071 | 1414 | 19 |
1863497 | 1863497 | 2021-10-29 | Rock | Minnesota | 27133 | 1597 | 19 |
1863506 | 1863506 | 2021-10-29 | Swift | Minnesota | 27151 | 1399 | 19 |
1860217 | 1860217 | 2021-10-28 | Koochiching | Minnesota | 27071 | 1411 | 19 |
1860248 | 1860248 | 2021-10-28 | Rock | Minnesota | 27133 | 1594 | 19 |
1860257 | 1860257 | 2021-10-28 | Swift | Minnesota | 27151 | 1390 | 19 |
1856968 | 1856968 | 2021-10-27 | Koochiching | Minnesota | 27071 | 1402 | 19 |
1856999 | 1856999 | 2021-10-27 | Rock | Minnesota | 27133 | 1587 | 19 |
1857008 | 1857008 | 2021-10-27 | Swift | Minnesota | 27151 | 1375 | 19 |
1853719 | 1853719 | 2021-10-26 | Koochiching | Minnesota | 27071 | 1396 | 19 |
1853750 | 1853750 | 2021-10-26 | Rock | Minnesota | 27133 | 1581 | 19 |
1853759 | 1853759 | 2021-10-26 | Swift | Minnesota | 27151 | 1375 | 19 |
1850470 | 1850470 | 2021-10-25 | Koochiching | Minnesota | 27071 | 1391 | 19 |
1850501 | 1850501 | 2021-10-25 | Rock | Minnesota | 27133 | 1558 | 19 |
1850510 | 1850510 | 2021-10-25 | Swift | Minnesota | 27151 | 1354 | 19 |
1847220 | 1847220 | 2021-10-24 | Koochiching | Minnesota | 27071 | 1386 | 19 |
1847251 | 1847251 | 2021-10-24 | Rock | Minnesota | 27133 | 1553 | 19 |
1847260 | 1847260 | 2021-10-24 | Swift | Minnesota | 27151 | 1346 | 19 |
1843970 | 1843970 | 2021-10-23 | Koochiching | Minnesota | 27071 | 1386 | 19 |
1844001 | 1844001 | 2021-10-23 | Rock | Minnesota | 27133 | 1553 | 19 |
1844010 | 1844010 | 2021-10-23 | Swift | Minnesota | 27151 | 1346 | 19 |
1840720 | 1840720 | 2021-10-22 | Koochiching | Minnesota | 27071 | 1386 | 19 |
1840751 | 1840751 | 2021-10-22 | Rock | Minnesota | 27133 | 1553 | 19 |
1840760 | 1840760 | 2021-10-22 | Swift | Minnesota | 27151 | 1346 | 19 |
1837471 | 1837471 | 2021-10-21 | Koochiching | Minnesota | 27071 | 1383 | 19 |
1837502 | 1837502 | 2021-10-21 | Rock | Minnesota | 27133 | 1550 | 19 |
1837511 | 1837511 | 2021-10-21 | Swift | Minnesota | 27151 | 1345 | 19 |
1834222 | 1834222 | 2021-10-20 | Koochiching | Minnesota | 27071 | 1383 | 19 |
1834230 | 1834230 | 2021-10-20 | Marshall | Minnesota | 27089 | 1337 | 19 |
1834253 | 1834253 | 2021-10-20 | Rock | Minnesota | 27133 | 1546 | 19 |
1834262 | 1834262 | 2021-10-20 | Swift | Minnesota | 27151 | 1343 | 19 |
1830973 | 1830973 | 2021-10-19 | Koochiching | Minnesota | 27071 | 1379 | 19 |
1830981 | 1830981 | 2021-10-19 | Marshall | Minnesota | 27089 | 1334 | 19 |
1831004 | 1831004 | 2021-10-19 | Rock | Minnesota | 27133 | 1545 | 19 |
1831013 | 1831013 | 2021-10-19 | Swift | Minnesota | 27151 | 1342 | 19 |
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);