ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,267 rows where deaths = 8 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Grant 254
- Rice 103
- Norman 94
- Big Stone 86
- Pope 78
- Watonwan 70
- Stevens 62
- Murray 61
- Goodhue 46
- Traverse 42
- Fillmore 41
- Mahnomen 30
- Wabasha 21
- Kanabec 20
- Waseca 18
- Red Lake 17
- Koochiching 15
- Cass 13
- Renville 12
- Jackson 11
- Pine 11
- Yellow Medicine 11
- Otter Tail 10
- Steele 8
- Olmsted 7
- Carlton 6
- Chisago 6
- Kittson 6
- Lake 6
- Isanti 5
- …
state 1
- Minnesota · 1,267 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448799 | 2448799 | 2022-04-27 | Big Stone | Minnesota | 27011 | 1401 | 8 |
2445543 | 2445543 | 2022-04-26 | Big Stone | Minnesota | 27011 | 1400 | 8 |
2442287 | 2442287 | 2022-04-25 | Big Stone | Minnesota | 27011 | 1397 | 8 |
2439031 | 2439031 | 2022-04-24 | Big Stone | Minnesota | 27011 | 1393 | 8 |
2435775 | 2435775 | 2022-04-23 | Big Stone | Minnesota | 27011 | 1393 | 8 |
2432519 | 2432519 | 2022-04-22 | Big Stone | Minnesota | 27011 | 1393 | 8 |
2429263 | 2429263 | 2022-04-21 | Big Stone | Minnesota | 27011 | 1393 | 8 |
2426007 | 2426007 | 2022-04-20 | Big Stone | Minnesota | 27011 | 1391 | 8 |
2422751 | 2422751 | 2022-04-19 | Big Stone | Minnesota | 27011 | 1388 | 8 |
2419495 | 2419495 | 2022-04-18 | Big Stone | Minnesota | 27011 | 1387 | 8 |
2416239 | 2416239 | 2022-04-17 | Big Stone | Minnesota | 27011 | 1386 | 8 |
2412983 | 2412983 | 2022-04-16 | Big Stone | Minnesota | 27011 | 1386 | 8 |
2409727 | 2409727 | 2022-04-15 | Big Stone | Minnesota | 27011 | 1386 | 8 |
2406471 | 2406471 | 2022-04-14 | Big Stone | Minnesota | 27011 | 1385 | 8 |
2403215 | 2403215 | 2022-04-13 | Big Stone | Minnesota | 27011 | 1385 | 8 |
2399961 | 2399961 | 2022-04-12 | Big Stone | Minnesota | 27011 | 1383 | 8 |
2396705 | 2396705 | 2022-04-11 | Big Stone | Minnesota | 27011 | 1382 | 8 |
2393450 | 2393450 | 2022-04-10 | Big Stone | Minnesota | 27011 | 1382 | 8 |
2390194 | 2390194 | 2022-04-09 | Big Stone | Minnesota | 27011 | 1382 | 8 |
2386938 | 2386938 | 2022-04-08 | Big Stone | Minnesota | 27011 | 1382 | 8 |
2383683 | 2383683 | 2022-04-07 | Big Stone | Minnesota | 27011 | 1382 | 8 |
2380428 | 2380428 | 2022-04-06 | Big Stone | Minnesota | 27011 | 1382 | 8 |
2377173 | 2377173 | 2022-04-05 | Big Stone | Minnesota | 27011 | 1380 | 8 |
2373921 | 2373921 | 2022-04-04 | Big Stone | Minnesota | 27011 | 1380 | 8 |
2370668 | 2370668 | 2022-04-03 | Big Stone | Minnesota | 27011 | 1380 | 8 |
2367415 | 2367415 | 2022-04-02 | Big Stone | Minnesota | 27011 | 1380 | 8 |
2364162 | 2364162 | 2022-04-01 | Big Stone | Minnesota | 27011 | 1380 | 8 |
2360908 | 2360908 | 2022-03-31 | Big Stone | Minnesota | 27011 | 1379 | 8 |
2357654 | 2357654 | 2022-03-30 | Big Stone | Minnesota | 27011 | 1379 | 8 |
2354401 | 2354401 | 2022-03-29 | Big Stone | Minnesota | 27011 | 1379 | 8 |
2351149 | 2351149 | 2022-03-28 | Big Stone | Minnesota | 27011 | 1379 | 8 |
2347896 | 2347896 | 2022-03-27 | Big Stone | Minnesota | 27011 | 1379 | 8 |
2344643 | 2344643 | 2022-03-26 | Big Stone | Minnesota | 27011 | 1379 | 8 |
2341390 | 2341390 | 2022-03-25 | Big Stone | Minnesota | 27011 | 1379 | 8 |
2338137 | 2338137 | 2022-03-24 | Big Stone | Minnesota | 27011 | 1379 | 8 |
2334883 | 2334883 | 2022-03-23 | Big Stone | Minnesota | 27011 | 1379 | 8 |
2331629 | 2331629 | 2022-03-22 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2328377 | 2328377 | 2022-03-21 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2325124 | 2325124 | 2022-03-20 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2321870 | 2321870 | 2022-03-19 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2318616 | 2318616 | 2022-03-18 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2315363 | 2315363 | 2022-03-17 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2312110 | 2312110 | 2022-03-16 | Big Stone | Minnesota | 27011 | 1376 | 8 |
2308857 | 2308857 | 2022-03-15 | Big Stone | Minnesota | 27011 | 1375 | 8 |
2305606 | 2305606 | 2022-03-14 | Big Stone | Minnesota | 27011 | 1375 | 8 |
2302354 | 2302354 | 2022-03-13 | Big Stone | Minnesota | 27011 | 1375 | 8 |
2299102 | 2299102 | 2022-03-12 | Big Stone | Minnesota | 27011 | 1375 | 8 |
2295850 | 2295850 | 2022-03-11 | Big Stone | Minnesota | 27011 | 1375 | 8 |
2292598 | 2292598 | 2022-03-10 | Big Stone | Minnesota | 27011 | 1369 | 8 |
2289346 | 2289346 | 2022-03-09 | Big Stone | Minnesota | 27011 | 1368 | 8 |
2286095 | 2286095 | 2022-03-08 | Big Stone | Minnesota | 27011 | 1368 | 8 |
2282843 | 2282843 | 2022-03-07 | Big Stone | Minnesota | 27011 | 1368 | 8 |
2279590 | 2279590 | 2022-03-06 | Big Stone | Minnesota | 27011 | 1368 | 8 |
2276337 | 2276337 | 2022-03-05 | Big Stone | Minnesota | 27011 | 1368 | 8 |
2273084 | 2273084 | 2022-03-04 | Big Stone | Minnesota | 27011 | 1368 | 8 |
2269832 | 2269832 | 2022-03-03 | Big Stone | Minnesota | 27011 | 1366 | 8 |
2266579 | 2266579 | 2022-03-02 | Big Stone | Minnesota | 27011 | 1365 | 8 |
2263328 | 2263328 | 2022-03-01 | Big Stone | Minnesota | 27011 | 1363 | 8 |
2260077 | 2260077 | 2022-02-28 | Big Stone | Minnesota | 27011 | 1363 | 8 |
2256826 | 2256826 | 2022-02-27 | Big Stone | Minnesota | 27011 | 1362 | 8 |
2253575 | 2253575 | 2022-02-26 | Big Stone | Minnesota | 27011 | 1362 | 8 |
2250324 | 2250324 | 2022-02-25 | Big Stone | Minnesota | 27011 | 1362 | 8 |
2247073 | 2247073 | 2022-02-24 | Big Stone | Minnesota | 27011 | 1361 | 8 |
2243822 | 2243822 | 2022-02-23 | Big Stone | Minnesota | 27011 | 1357 | 8 |
2240571 | 2240571 | 2022-02-22 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2237320 | 2237320 | 2022-02-21 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2234069 | 2234069 | 2022-02-20 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2230818 | 2230818 | 2022-02-19 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2227567 | 2227567 | 2022-02-18 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2224316 | 2224316 | 2022-02-17 | Big Stone | Minnesota | 27011 | 1347 | 8 |
2221065 | 2221065 | 2022-02-16 | Big Stone | Minnesota | 27011 | 1343 | 8 |
2217814 | 2217814 | 2022-02-15 | Big Stone | Minnesota | 27011 | 1343 | 8 |
2214563 | 2214563 | 2022-02-14 | Big Stone | Minnesota | 27011 | 1335 | 8 |
2211311 | 2211311 | 2022-02-13 | Big Stone | Minnesota | 27011 | 1331 | 8 |
2208058 | 2208058 | 2022-02-12 | Big Stone | Minnesota | 27011 | 1331 | 8 |
2204805 | 2204805 | 2022-02-11 | Big Stone | Minnesota | 27011 | 1331 | 8 |
2201552 | 2201552 | 2022-02-10 | Big Stone | Minnesota | 27011 | 1324 | 8 |
2198298 | 2198298 | 2022-02-09 | Big Stone | Minnesota | 27011 | 1321 | 8 |
2195044 | 2195044 | 2022-02-08 | Big Stone | Minnesota | 27011 | 1314 | 8 |
2191790 | 2191790 | 2022-02-07 | Big Stone | Minnesota | 27011 | 1308 | 8 |
2188537 | 2188537 | 2022-02-06 | Big Stone | Minnesota | 27011 | 1296 | 8 |
2185284 | 2185284 | 2022-02-05 | Big Stone | Minnesota | 27011 | 1296 | 8 |
2182032 | 2182032 | 2022-02-04 | Big Stone | Minnesota | 27011 | 1296 | 8 |
2178780 | 2178780 | 2022-02-03 | Big Stone | Minnesota | 27011 | 1291 | 8 |
2175528 | 2175528 | 2022-02-02 | Big Stone | Minnesota | 27011 | 1285 | 8 |
2172275 | 2172275 | 2022-02-01 | Big Stone | Minnesota | 27011 | 1274 | 8 |
2165839 | 2165839 | 2022-01-30 | Traverse | Minnesota | 27155 | 717 | 8 |
2162584 | 2162584 | 2022-01-29 | Traverse | Minnesota | 27155 | 717 | 8 |
2159329 | 2159329 | 2022-01-28 | Traverse | Minnesota | 27155 | 717 | 8 |
2156075 | 2156075 | 2022-01-27 | Traverse | Minnesota | 27155 | 710 | 8 |
2152822 | 2152822 | 2022-01-26 | Traverse | Minnesota | 27155 | 705 | 8 |
2149570 | 2149570 | 2022-01-25 | Traverse | Minnesota | 27155 | 697 | 8 |
2146318 | 2146318 | 2022-01-24 | Traverse | Minnesota | 27155 | 686 | 8 |
2143063 | 2143063 | 2022-01-23 | Traverse | Minnesota | 27155 | 682 | 8 |
2139808 | 2139808 | 2022-01-22 | Traverse | Minnesota | 27155 | 682 | 8 |
2136552 | 2136552 | 2022-01-21 | Traverse | Minnesota | 27155 | 682 | 8 |
2133300 | 2133300 | 2022-01-20 | Traverse | Minnesota | 27155 | 677 | 8 |
2130047 | 2130047 | 2022-01-19 | Traverse | Minnesota | 27155 | 671 | 8 |
2126793 | 2126793 | 2022-01-18 | Traverse | Minnesota | 27155 | 662 | 8 |
2123541 | 2123541 | 2022-01-17 | Traverse | Minnesota | 27155 | 659 | 8 |
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);