ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
393 rows where deaths = 38 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Chippewa 104
- Aitkin 22
- Redwood 22
- Hubbard 20
- Mower 19
- Clay 17
- Waseca 17
- Cottonwood 13
- Roseau 13
- Blue Earth 12
- Freeborn 12
- Chisago 10
- Meeker 10
- Becker 8
- Faribault 7
- Renville 7
- Unknown 7
- Carlton 6
- Pennington 6
- Todd 6
- Mille Lacs 5
- Steele 5
- Lyon 4
- Nicollet 4
- Washington 4
- Morrison 3
- Olmsted 3
- Sherburne 3
- Carver 2
- Cass 2
- …
state 1
- Minnesota · 393 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2224392 | 2224392 | 2022-02-17 | Waseca | Minnesota | 27161 | 5371 | 38 |
2221141 | 2221141 | 2022-02-16 | Waseca | Minnesota | 27161 | 5360 | 38 |
2217865 | 2217865 | 2022-02-15 | Pennington | Minnesota | 27113 | 3400 | 38 |
2217890 | 2217890 | 2022-02-15 | Waseca | Minnesota | 27161 | 5354 | 38 |
2214614 | 2214614 | 2022-02-14 | Pennington | Minnesota | 27113 | 3388 | 38 |
2214639 | 2214639 | 2022-02-14 | Waseca | Minnesota | 27161 | 5343 | 38 |
2211362 | 2211362 | 2022-02-13 | Pennington | Minnesota | 27113 | 3375 | 38 |
2211387 | 2211387 | 2022-02-13 | Waseca | Minnesota | 27161 | 5332 | 38 |
2208109 | 2208109 | 2022-02-12 | Pennington | Minnesota | 27113 | 3375 | 38 |
2208134 | 2208134 | 2022-02-12 | Waseca | Minnesota | 27161 | 5332 | 38 |
2204856 | 2204856 | 2022-02-11 | Pennington | Minnesota | 27113 | 3375 | 38 |
2204881 | 2204881 | 2022-02-11 | Waseca | Minnesota | 27161 | 5332 | 38 |
2201603 | 2201603 | 2022-02-10 | Pennington | Minnesota | 27113 | 3358 | 38 |
2201628 | 2201628 | 2022-02-10 | Waseca | Minnesota | 27161 | 5319 | 38 |
2198309 | 2198309 | 2022-02-09 | Cottonwood | Minnesota | 27033 | 3093 | 38 |
2198374 | 2198374 | 2022-02-09 | Waseca | Minnesota | 27161 | 5306 | 38 |
2195055 | 2195055 | 2022-02-08 | Cottonwood | Minnesota | 27033 | 3079 | 38 |
2195120 | 2195120 | 2022-02-08 | Waseca | Minnesota | 27161 | 5292 | 38 |
2191801 | 2191801 | 2022-02-07 | Cottonwood | Minnesota | 27033 | 3062 | 38 |
2191866 | 2191866 | 2022-02-07 | Waseca | Minnesota | 27161 | 5266 | 38 |
2188548 | 2188548 | 2022-02-06 | Cottonwood | Minnesota | 27033 | 3050 | 38 |
2188613 | 2188613 | 2022-02-06 | Waseca | Minnesota | 27161 | 5241 | 38 |
2185295 | 2185295 | 2022-02-05 | Cottonwood | Minnesota | 27033 | 3050 | 38 |
2185360 | 2185360 | 2022-02-05 | Waseca | Minnesota | 27161 | 5241 | 38 |
2182043 | 2182043 | 2022-02-04 | Cottonwood | Minnesota | 27033 | 3050 | 38 |
2182108 | 2182108 | 2022-02-04 | Waseca | Minnesota | 27161 | 5241 | 38 |
2178791 | 2178791 | 2022-02-03 | Cottonwood | Minnesota | 27033 | 3042 | 38 |
2178856 | 2178856 | 2022-02-03 | Waseca | Minnesota | 27161 | 5209 | 38 |
2175539 | 2175539 | 2022-02-02 | Cottonwood | Minnesota | 27033 | 3036 | 38 |
2175604 | 2175604 | 2022-02-02 | Waseca | Minnesota | 27161 | 5174 | 38 |
2172286 | 2172286 | 2022-02-01 | Cottonwood | Minnesota | 27033 | 3029 | 38 |
2172351 | 2172351 | 2022-02-01 | Waseca | Minnesota | 27161 | 5153 | 38 |
2169033 | 2169033 | 2022-01-31 | Cottonwood | Minnesota | 27033 | 2991 | 38 |
2165778 | 2165778 | 2022-01-30 | Cottonwood | Minnesota | 27033 | 2960 | 38 |
2162523 | 2162523 | 2022-01-29 | Cottonwood | Minnesota | 27033 | 2960 | 38 |
2159268 | 2159268 | 2022-01-28 | Cottonwood | Minnesota | 27033 | 2960 | 38 |
2152812 | 2152812 | 2022-01-26 | Roseau | Minnesota | 27135 | 3952 | 38 |
2149560 | 2149560 | 2022-01-25 | Roseau | Minnesota | 27135 | 3917 | 38 |
2146308 | 2146308 | 2022-01-24 | Roseau | Minnesota | 27135 | 3857 | 38 |
2143053 | 2143053 | 2022-01-23 | Roseau | Minnesota | 27135 | 3813 | 38 |
2139798 | 2139798 | 2022-01-22 | Roseau | Minnesota | 27135 | 3813 | 38 |
2136542 | 2136542 | 2022-01-21 | Roseau | Minnesota | 27135 | 3813 | 38 |
2133290 | 2133290 | 2022-01-20 | Roseau | Minnesota | 27135 | 3740 | 38 |
2130037 | 2130037 | 2022-01-19 | Roseau | Minnesota | 27135 | 3707 | 38 |
2126783 | 2126783 | 2022-01-18 | Roseau | Minnesota | 27135 | 3627 | 38 |
2123531 | 2123531 | 2022-01-17 | Roseau | Minnesota | 27135 | 3595 | 38 |
2120279 | 2120279 | 2022-01-16 | Roseau | Minnesota | 27135 | 3595 | 38 |
2117027 | 2117027 | 2022-01-15 | Roseau | Minnesota | 27135 | 3595 | 38 |
2113776 | 2113776 | 2022-01-14 | Roseau | Minnesota | 27135 | 3595 | 38 |
2055211 | 2055211 | 2021-12-27 | Faribault | Minnesota | 27043 | 2812 | 38 |
2051961 | 2051961 | 2021-12-26 | Faribault | Minnesota | 27043 | 2802 | 38 |
2048711 | 2048711 | 2021-12-25 | Faribault | Minnesota | 27043 | 2802 | 38 |
2045461 | 2045461 | 2021-12-24 | Faribault | Minnesota | 27043 | 2802 | 38 |
2042211 | 2042211 | 2021-12-23 | Faribault | Minnesota | 27043 | 2802 | 38 |
2038962 | 2038962 | 2021-12-22 | Faribault | Minnesota | 27043 | 2787 | 38 |
2035712 | 2035712 | 2021-12-21 | Faribault | Minnesota | 27043 | 2783 | 38 |
2029263 | 2029263 | 2021-12-19 | Steele | Minnesota | 27147 | 7312 | 38 |
2026012 | 2026012 | 2021-12-18 | Steele | Minnesota | 27147 | 7312 | 38 |
2022761 | 2022761 | 2021-12-17 | Steele | Minnesota | 27147 | 7312 | 38 |
2019476 | 2019476 | 2021-12-16 | Le Sueur | Minnesota | 27079 | 4897 | 38 |
2019510 | 2019510 | 2021-12-16 | Steele | Minnesota | 27147 | 7284 | 38 |
2016260 | 2016260 | 2021-12-15 | Steele | Minnesota | 27147 | 7258 | 38 |
1986962 | 1986962 | 2021-12-06 | Kanabec | Minnesota | 27065 | 2567 | 38 |
1944753 | 1944753 | 2021-11-23 | Wadena | Minnesota | 27159 | 2949 | 38 |
1899250 | 1899250 | 2021-11-09 | Todd | Minnesota | 27153 | 4433 | 38 |
1896000 | 1896000 | 2021-11-08 | Todd | Minnesota | 27153 | 4402 | 38 |
1892750 | 1892750 | 2021-11-07 | Todd | Minnesota | 27153 | 4384 | 38 |
1889500 | 1889500 | 2021-11-06 | Todd | Minnesota | 27153 | 4384 | 38 |
1886250 | 1886250 | 2021-11-05 | Todd | Minnesota | 27153 | 4384 | 38 |
1883001 | 1883001 | 2021-11-04 | Todd | Minnesota | 27153 | 4360 | 38 |
1779002 | 1779002 | 2021-10-03 | Mower | Minnesota | 27099 | 5938 | 38 |
1775752 | 1775752 | 2021-10-02 | Mower | Minnesota | 27099 | 5938 | 38 |
1772502 | 1772502 | 2021-10-01 | Mower | Minnesota | 27099 | 5938 | 38 |
1769253 | 1769253 | 2021-09-30 | Mower | Minnesota | 27099 | 5906 | 38 |
1766004 | 1766004 | 2021-09-29 | Mower | Minnesota | 27099 | 5884 | 38 |
1762716 | 1762716 | 2021-09-28 | Cass | Minnesota | 27021 | 3639 | 38 |
1762755 | 1762755 | 2021-09-28 | Mower | Minnesota | 27099 | 5868 | 38 |
1759467 | 1759467 | 2021-09-27 | Cass | Minnesota | 27021 | 3573 | 38 |
1759506 | 1759506 | 2021-09-27 | Mower | Minnesota | 27099 | 5799 | 38 |
1756258 | 1756258 | 2021-09-26 | Mower | Minnesota | 27099 | 5762 | 38 |
1753010 | 1753010 | 2021-09-25 | Mower | Minnesota | 27099 | 5762 | 38 |
1749762 | 1749762 | 2021-09-24 | Mower | Minnesota | 27099 | 5762 | 38 |
1746463 | 1746463 | 2021-09-23 | Aitkin | Minnesota | 27001 | 1580 | 38 |
1746512 | 1746512 | 2021-09-23 | Mower | Minnesota | 27099 | 5739 | 38 |
1743214 | 1743214 | 2021-09-22 | Aitkin | Minnesota | 27001 | 1573 | 38 |
1743263 | 1743263 | 2021-09-22 | Mower | Minnesota | 27099 | 5705 | 38 |
1739965 | 1739965 | 2021-09-21 | Aitkin | Minnesota | 27001 | 1568 | 38 |
1739988 | 1739988 | 2021-09-21 | Freeborn | Minnesota | 27047 | 4338 | 38 |
1740014 | 1740014 | 2021-09-21 | Mower | Minnesota | 27099 | 5691 | 38 |
1736716 | 1736716 | 2021-09-20 | Aitkin | Minnesota | 27001 | 1552 | 38 |
1736739 | 1736739 | 2021-09-20 | Freeborn | Minnesota | 27047 | 4304 | 38 |
1736765 | 1736765 | 2021-09-20 | Mower | Minnesota | 27099 | 5607 | 38 |
1733466 | 1733466 | 2021-09-19 | Aitkin | Minnesota | 27001 | 1550 | 38 |
1733489 | 1733489 | 2021-09-19 | Freeborn | Minnesota | 27047 | 4295 | 38 |
1733515 | 1733515 | 2021-09-19 | Mower | Minnesota | 27099 | 5580 | 38 |
1730216 | 1730216 | 2021-09-18 | Aitkin | Minnesota | 27001 | 1550 | 38 |
1730239 | 1730239 | 2021-09-18 | Freeborn | Minnesota | 27047 | 4295 | 38 |
1730265 | 1730265 | 2021-09-18 | Mower | Minnesota | 27099 | 5580 | 38 |
1726966 | 1726966 | 2021-09-17 | Aitkin | Minnesota | 27001 | 1550 | 38 |
1726989 | 1726989 | 2021-09-17 | Freeborn | Minnesota | 27047 | 4295 | 38 |
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);