ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
479 rows where deaths = 54 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Lyon 105
- Todd 49
- Mille Lacs 37
- McLeod 35
- Kanabec 29
- Nobles 29
- Beltrami 23
- Wadena 17
- Meeker 14
- Renville 14
- Unknown 12
- Martin 11
- Carver 10
- Chisago 10
- Becker 9
- Washington 9
- Winona 8
- Aitkin 7
- Scott 7
- Carlton 6
- Nicollet 6
- Morrison 5
- Redwood 5
- Isanti 4
- Itasca 2
- Olmsted 2
- Polk 2
- Blue Earth 1
- Clay 1
- Dakota 1
- …
state 1
- Minnesota · 479 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500968 | 2500968 | 2022-05-13 | Redwood | Minnesota | 27127 | 3985 | 54 |
2497710 | 2497710 | 2022-05-12 | Redwood | Minnesota | 27127 | 3981 | 54 |
2494452 | 2494452 | 2022-05-11 | Redwood | Minnesota | 27127 | 3976 | 54 |
2491194 | 2491194 | 2022-05-10 | Redwood | Minnesota | 27127 | 3970 | 54 |
2487937 | 2487937 | 2022-05-09 | Redwood | Minnesota | 27127 | 3965 | 54 |
2383758 | 2383758 | 2022-04-07 | Wadena | Minnesota | 27159 | 4208 | 54 |
2380503 | 2380503 | 2022-04-06 | Wadena | Minnesota | 27159 | 4207 | 54 |
2377248 | 2377248 | 2022-04-05 | Wadena | Minnesota | 27159 | 4206 | 54 |
2373996 | 2373996 | 2022-04-04 | Wadena | Minnesota | 27159 | 4206 | 54 |
2370743 | 2370743 | 2022-04-03 | Wadena | Minnesota | 27159 | 4206 | 54 |
2367490 | 2367490 | 2022-04-02 | Wadena | Minnesota | 27159 | 4206 | 54 |
2364237 | 2364237 | 2022-04-01 | Wadena | Minnesota | 27159 | 4206 | 54 |
2360983 | 2360983 | 2022-03-31 | Wadena | Minnesota | 27159 | 4204 | 54 |
2357729 | 2357729 | 2022-03-30 | Wadena | Minnesota | 27159 | 4204 | 54 |
2354476 | 2354476 | 2022-03-29 | Wadena | Minnesota | 27159 | 4204 | 54 |
2351224 | 2351224 | 2022-03-28 | Wadena | Minnesota | 27159 | 4203 | 54 |
2347971 | 2347971 | 2022-03-27 | Wadena | Minnesota | 27159 | 4203 | 54 |
2344718 | 2344718 | 2022-03-26 | Wadena | Minnesota | 27159 | 4203 | 54 |
2341465 | 2341465 | 2022-03-25 | Wadena | Minnesota | 27159 | 4203 | 54 |
2338212 | 2338212 | 2022-03-24 | Wadena | Minnesota | 27159 | 4200 | 54 |
2334958 | 2334958 | 2022-03-23 | Wadena | Minnesota | 27159 | 4199 | 54 |
2331704 | 2331704 | 2022-03-22 | Wadena | Minnesota | 27159 | 4199 | 54 |
2292625 | 2292625 | 2022-03-10 | Kanabec | Minnesota | 27065 | 3466 | 54 |
2289373 | 2289373 | 2022-03-09 | Kanabec | Minnesota | 27065 | 3461 | 54 |
2286122 | 2286122 | 2022-03-08 | Kanabec | Minnesota | 27065 | 3460 | 54 |
2282870 | 2282870 | 2022-03-07 | Kanabec | Minnesota | 27065 | 3460 | 54 |
2279617 | 2279617 | 2022-03-06 | Kanabec | Minnesota | 27065 | 3458 | 54 |
2276364 | 2276364 | 2022-03-05 | Kanabec | Minnesota | 27065 | 3458 | 54 |
2273111 | 2273111 | 2022-03-04 | Kanabec | Minnesota | 27065 | 3458 | 54 |
2269859 | 2269859 | 2022-03-03 | Kanabec | Minnesota | 27065 | 3457 | 54 |
2266606 | 2266606 | 2022-03-02 | Kanabec | Minnesota | 27065 | 3457 | 54 |
2263355 | 2263355 | 2022-03-01 | Kanabec | Minnesota | 27065 | 3455 | 54 |
2260104 | 2260104 | 2022-02-28 | Kanabec | Minnesota | 27065 | 3455 | 54 |
2260148 | 2260148 | 2022-02-28 | Todd | Minnesota | 27153 | 6633 | 54 |
2256853 | 2256853 | 2022-02-27 | Kanabec | Minnesota | 27065 | 3454 | 54 |
2256897 | 2256897 | 2022-02-27 | Todd | Minnesota | 27153 | 6627 | 54 |
2253602 | 2253602 | 2022-02-26 | Kanabec | Minnesota | 27065 | 3454 | 54 |
2253646 | 2253646 | 2022-02-26 | Todd | Minnesota | 27153 | 6627 | 54 |
2250351 | 2250351 | 2022-02-25 | Kanabec | Minnesota | 27065 | 3454 | 54 |
2250395 | 2250395 | 2022-02-25 | Todd | Minnesota | 27153 | 6627 | 54 |
2247100 | 2247100 | 2022-02-24 | Kanabec | Minnesota | 27065 | 3452 | 54 |
2247144 | 2247144 | 2022-02-24 | Todd | Minnesota | 27153 | 6625 | 54 |
2243849 | 2243849 | 2022-02-23 | Kanabec | Minnesota | 27065 | 3452 | 54 |
2243893 | 2243893 | 2022-02-23 | Todd | Minnesota | 27153 | 6620 | 54 |
2240598 | 2240598 | 2022-02-22 | Kanabec | Minnesota | 27065 | 3445 | 54 |
2240642 | 2240642 | 2022-02-22 | Todd | Minnesota | 27153 | 6591 | 54 |
2237347 | 2237347 | 2022-02-21 | Kanabec | Minnesota | 27065 | 3442 | 54 |
2237391 | 2237391 | 2022-02-21 | Todd | Minnesota | 27153 | 6581 | 54 |
2234096 | 2234096 | 2022-02-20 | Kanabec | Minnesota | 27065 | 3442 | 54 |
2234140 | 2234140 | 2022-02-20 | Todd | Minnesota | 27153 | 6581 | 54 |
2230845 | 2230845 | 2022-02-19 | Kanabec | Minnesota | 27065 | 3442 | 54 |
2230889 | 2230889 | 2022-02-19 | Todd | Minnesota | 27153 | 6581 | 54 |
2227594 | 2227594 | 2022-02-18 | Kanabec | Minnesota | 27065 | 3442 | 54 |
2227638 | 2227638 | 2022-02-18 | Todd | Minnesota | 27153 | 6581 | 54 |
2224343 | 2224343 | 2022-02-17 | Kanabec | Minnesota | 27065 | 3432 | 54 |
2224375 | 2224375 | 2022-02-17 | Renville | Minnesota | 27129 | 3546 | 54 |
2224384 | 2224384 | 2022-02-17 | Steele | Minnesota | 27147 | 10097 | 54 |
2224387 | 2224387 | 2022-02-17 | Todd | Minnesota | 27153 | 6557 | 54 |
2221092 | 2221092 | 2022-02-16 | Kanabec | Minnesota | 27065 | 3426 | 54 |
2221124 | 2221124 | 2022-02-16 | Renville | Minnesota | 27129 | 3538 | 54 |
2221136 | 2221136 | 2022-02-16 | Todd | Minnesota | 27153 | 6541 | 54 |
2217841 | 2217841 | 2022-02-15 | Kanabec | Minnesota | 27065 | 3425 | 54 |
2217873 | 2217873 | 2022-02-15 | Renville | Minnesota | 27129 | 3533 | 54 |
2217885 | 2217885 | 2022-02-15 | Todd | Minnesota | 27153 | 6525 | 54 |
2214590 | 2214590 | 2022-02-14 | Kanabec | Minnesota | 27065 | 3411 | 54 |
2214622 | 2214622 | 2022-02-14 | Renville | Minnesota | 27129 | 3511 | 54 |
2214634 | 2214634 | 2022-02-14 | Todd | Minnesota | 27153 | 6499 | 54 |
2211338 | 2211338 | 2022-02-13 | Kanabec | Minnesota | 27065 | 3402 | 54 |
2211370 | 2211370 | 2022-02-13 | Renville | Minnesota | 27129 | 3488 | 54 |
2211382 | 2211382 | 2022-02-13 | Todd | Minnesota | 27153 | 6462 | 54 |
2208085 | 2208085 | 2022-02-12 | Kanabec | Minnesota | 27065 | 3402 | 54 |
2208117 | 2208117 | 2022-02-12 | Renville | Minnesota | 27129 | 3488 | 54 |
2208129 | 2208129 | 2022-02-12 | Todd | Minnesota | 27153 | 6462 | 54 |
2204832 | 2204832 | 2022-02-11 | Kanabec | Minnesota | 27065 | 3402 | 54 |
2204864 | 2204864 | 2022-02-11 | Renville | Minnesota | 27129 | 3488 | 54 |
2204876 | 2204876 | 2022-02-11 | Todd | Minnesota | 27153 | 6462 | 54 |
2201579 | 2201579 | 2022-02-10 | Kanabec | Minnesota | 27065 | 3387 | 54 |
2201611 | 2201611 | 2022-02-10 | Renville | Minnesota | 27129 | 3480 | 54 |
2201623 | 2201623 | 2022-02-10 | Todd | Minnesota | 27153 | 6432 | 54 |
2198357 | 2198357 | 2022-02-09 | Renville | Minnesota | 27129 | 3480 | 54 |
2198369 | 2198369 | 2022-02-09 | Todd | Minnesota | 27153 | 6414 | 54 |
2195103 | 2195103 | 2022-02-08 | Renville | Minnesota | 27129 | 3461 | 54 |
2195115 | 2195115 | 2022-02-08 | Todd | Minnesota | 27153 | 6378 | 54 |
2191829 | 2191829 | 2022-02-07 | Martin | Minnesota | 27091 | 5249 | 54 |
2191849 | 2191849 | 2022-02-07 | Renville | Minnesota | 27129 | 3438 | 54 |
2191861 | 2191861 | 2022-02-07 | Todd | Minnesota | 27153 | 6338 | 54 |
2188576 | 2188576 | 2022-02-06 | Martin | Minnesota | 27091 | 5220 | 54 |
2188596 | 2188596 | 2022-02-06 | Renville | Minnesota | 27129 | 3421 | 54 |
2188608 | 2188608 | 2022-02-06 | Todd | Minnesota | 27153 | 6295 | 54 |
2185323 | 2185323 | 2022-02-05 | Martin | Minnesota | 27091 | 5220 | 54 |
2185343 | 2185343 | 2022-02-05 | Renville | Minnesota | 27129 | 3421 | 54 |
2185355 | 2185355 | 2022-02-05 | Todd | Minnesota | 27153 | 6295 | 54 |
2182071 | 2182071 | 2022-02-04 | Martin | Minnesota | 27091 | 5220 | 54 |
2182091 | 2182091 | 2022-02-04 | Renville | Minnesota | 27129 | 3421 | 54 |
2182103 | 2182103 | 2022-02-04 | Todd | Minnesota | 27153 | 6295 | 54 |
2178819 | 2178819 | 2022-02-03 | Martin | Minnesota | 27091 | 5193 | 54 |
2178851 | 2178851 | 2022-02-03 | Todd | Minnesota | 27153 | 6263 | 54 |
2175567 | 2175567 | 2022-02-02 | Martin | Minnesota | 27091 | 5178 | 54 |
2175599 | 2175599 | 2022-02-02 | Todd | Minnesota | 27153 | 6237 | 54 |
2172314 | 2172314 | 2022-02-01 | Martin | Minnesota | 27091 | 5157 | 54 |
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);