ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
882 rows where deaths = 6 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Pope 145
- Lincoln 93
- Lake of the Woods 80
- Nobles 64
- Traverse 42
- Renville 29
- Lyon 28
- Wright 26
- Grant 25
- Blue Earth 22
- Otter Tail 22
- Wadena 20
- Martin 18
- Stevens 18
- Le Sueur 16
- Mahnomen 16
- Koochiching 14
- Red Lake 10
- Steele 10
- Mower 9
- Big Stone 8
- Kanabec 8
- Dakota 7
- Lake 7
- Norman 7
- Olmsted 7
- Clearwater 6
- Pennington 6
- Winona 6
- Yellow Medicine 6
- …
state 1
- Minnesota · 882 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500943 | 2500943 | 2022-05-13 | Lake of the Woods | Minnesota | 27077 | 779 | 6 |
2500945 | 2500945 | 2022-05-13 | Lincoln | Minnesota | 27081 | 1220 | 6 |
2497685 | 2497685 | 2022-05-12 | Lake of the Woods | Minnesota | 27077 | 777 | 6 |
2497687 | 2497687 | 2022-05-12 | Lincoln | Minnesota | 27081 | 1219 | 6 |
2494427 | 2494427 | 2022-05-11 | Lake of the Woods | Minnesota | 27077 | 777 | 6 |
2494429 | 2494429 | 2022-05-11 | Lincoln | Minnesota | 27081 | 1219 | 6 |
2491169 | 2491169 | 2022-05-10 | Lake of the Woods | Minnesota | 27077 | 779 | 6 |
2491171 | 2491171 | 2022-05-10 | Lincoln | Minnesota | 27081 | 1219 | 6 |
2487912 | 2487912 | 2022-05-09 | Lake of the Woods | Minnesota | 27077 | 778 | 6 |
2487914 | 2487914 | 2022-05-09 | Lincoln | Minnesota | 27081 | 1218 | 6 |
2484654 | 2484654 | 2022-05-08 | Lake of the Woods | Minnesota | 27077 | 778 | 6 |
2484656 | 2484656 | 2022-05-08 | Lincoln | Minnesota | 27081 | 1217 | 6 |
2481396 | 2481396 | 2022-05-07 | Lake of the Woods | Minnesota | 27077 | 778 | 6 |
2481398 | 2481398 | 2022-05-07 | Lincoln | Minnesota | 27081 | 1217 | 6 |
2478138 | 2478138 | 2022-05-06 | Lake of the Woods | Minnesota | 27077 | 778 | 6 |
2478140 | 2478140 | 2022-05-06 | Lincoln | Minnesota | 27081 | 1217 | 6 |
2474880 | 2474880 | 2022-05-05 | Lake of the Woods | Minnesota | 27077 | 774 | 6 |
2474882 | 2474882 | 2022-05-05 | Lincoln | Minnesota | 27081 | 1217 | 6 |
2471623 | 2471623 | 2022-05-04 | Lake of the Woods | Minnesota | 27077 | 774 | 6 |
2471625 | 2471625 | 2022-05-04 | Lincoln | Minnesota | 27081 | 1217 | 6 |
2468367 | 2468367 | 2022-05-03 | Lake of the Woods | Minnesota | 27077 | 773 | 6 |
2468369 | 2468369 | 2022-05-03 | Lincoln | Minnesota | 27081 | 1217 | 6 |
2465112 | 2465112 | 2022-05-02 | Lake of the Woods | Minnesota | 27077 | 773 | 6 |
2465114 | 2465114 | 2022-05-02 | Lincoln | Minnesota | 27081 | 1216 | 6 |
2461856 | 2461856 | 2022-05-01 | Lake of the Woods | Minnesota | 27077 | 770 | 6 |
2461858 | 2461858 | 2022-05-01 | Lincoln | Minnesota | 27081 | 1216 | 6 |
2458600 | 2458600 | 2022-04-30 | Lake of the Woods | Minnesota | 27077 | 770 | 6 |
2458602 | 2458602 | 2022-04-30 | Lincoln | Minnesota | 27081 | 1216 | 6 |
2455344 | 2455344 | 2022-04-29 | Lake of the Woods | Minnesota | 27077 | 770 | 6 |
2455346 | 2455346 | 2022-04-29 | Lincoln | Minnesota | 27081 | 1216 | 6 |
2452088 | 2452088 | 2022-04-28 | Lake of the Woods | Minnesota | 27077 | 768 | 6 |
2452090 | 2452090 | 2022-04-28 | Lincoln | Minnesota | 27081 | 1216 | 6 |
2448832 | 2448832 | 2022-04-27 | Lake of the Woods | Minnesota | 27077 | 768 | 6 |
2448834 | 2448834 | 2022-04-27 | Lincoln | Minnesota | 27081 | 1216 | 6 |
2445576 | 2445576 | 2022-04-26 | Lake of the Woods | Minnesota | 27077 | 766 | 6 |
2445578 | 2445578 | 2022-04-26 | Lincoln | Minnesota | 27081 | 1216 | 6 |
2442320 | 2442320 | 2022-04-25 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2442322 | 2442322 | 2022-04-25 | Lincoln | Minnesota | 27081 | 1215 | 6 |
2439064 | 2439064 | 2022-04-24 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2439066 | 2439066 | 2022-04-24 | Lincoln | Minnesota | 27081 | 1215 | 6 |
2435808 | 2435808 | 2022-04-23 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2435810 | 2435810 | 2022-04-23 | Lincoln | Minnesota | 27081 | 1215 | 6 |
2432552 | 2432552 | 2022-04-22 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2432554 | 2432554 | 2022-04-22 | Lincoln | Minnesota | 27081 | 1215 | 6 |
2429296 | 2429296 | 2022-04-21 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2429298 | 2429298 | 2022-04-21 | Lincoln | Minnesota | 27081 | 1215 | 6 |
2426040 | 2426040 | 2022-04-20 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2426042 | 2426042 | 2022-04-20 | Lincoln | Minnesota | 27081 | 1215 | 6 |
2422784 | 2422784 | 2022-04-19 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2422786 | 2422786 | 2022-04-19 | Lincoln | Minnesota | 27081 | 1215 | 6 |
2419528 | 2419528 | 2022-04-18 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2419530 | 2419530 | 2022-04-18 | Lincoln | Minnesota | 27081 | 1215 | 6 |
2416272 | 2416272 | 2022-04-17 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2416274 | 2416274 | 2022-04-17 | Lincoln | Minnesota | 27081 | 1214 | 6 |
2413016 | 2413016 | 2022-04-16 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2413018 | 2413018 | 2022-04-16 | Lincoln | Minnesota | 27081 | 1214 | 6 |
2409760 | 2409760 | 2022-04-15 | Lake of the Woods | Minnesota | 27077 | 765 | 6 |
2409762 | 2409762 | 2022-04-15 | Lincoln | Minnesota | 27081 | 1214 | 6 |
2406504 | 2406504 | 2022-04-14 | Lake of the Woods | Minnesota | 27077 | 764 | 6 |
2406506 | 2406506 | 2022-04-14 | Lincoln | Minnesota | 27081 | 1213 | 6 |
2403248 | 2403248 | 2022-04-13 | Lake of the Woods | Minnesota | 27077 | 764 | 6 |
2403250 | 2403250 | 2022-04-13 | Lincoln | Minnesota | 27081 | 1213 | 6 |
2399994 | 2399994 | 2022-04-12 | Lake of the Woods | Minnesota | 27077 | 764 | 6 |
2399996 | 2399996 | 2022-04-12 | Lincoln | Minnesota | 27081 | 1213 | 6 |
2396738 | 2396738 | 2022-04-11 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2396740 | 2396740 | 2022-04-11 | Lincoln | Minnesota | 27081 | 1213 | 6 |
2393483 | 2393483 | 2022-04-10 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2393485 | 2393485 | 2022-04-10 | Lincoln | Minnesota | 27081 | 1213 | 6 |
2390227 | 2390227 | 2022-04-09 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2390229 | 2390229 | 2022-04-09 | Lincoln | Minnesota | 27081 | 1213 | 6 |
2386971 | 2386971 | 2022-04-08 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2386973 | 2386973 | 2022-04-08 | Lincoln | Minnesota | 27081 | 1213 | 6 |
2383716 | 2383716 | 2022-04-07 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2383718 | 2383718 | 2022-04-07 | Lincoln | Minnesota | 27081 | 1213 | 6 |
2380461 | 2380461 | 2022-04-06 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2380463 | 2380463 | 2022-04-06 | Lincoln | Minnesota | 27081 | 1213 | 6 |
2377206 | 2377206 | 2022-04-05 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2377208 | 2377208 | 2022-04-05 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2373954 | 2373954 | 2022-04-04 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2373956 | 2373956 | 2022-04-04 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2370701 | 2370701 | 2022-04-03 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2370703 | 2370703 | 2022-04-03 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2367448 | 2367448 | 2022-04-02 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2367450 | 2367450 | 2022-04-02 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2364195 | 2364195 | 2022-04-01 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2364197 | 2364197 | 2022-04-01 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2360941 | 2360941 | 2022-03-31 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2360943 | 2360943 | 2022-03-31 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2357687 | 2357687 | 2022-03-30 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2357689 | 2357689 | 2022-03-30 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2354434 | 2354434 | 2022-03-29 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2354436 | 2354436 | 2022-03-29 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2351182 | 2351182 | 2022-03-28 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2351184 | 2351184 | 2022-03-28 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2347929 | 2347929 | 2022-03-27 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2347931 | 2347931 | 2022-03-27 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2344676 | 2344676 | 2022-03-26 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2344678 | 2344678 | 2022-03-26 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2341423 | 2341423 | 2022-03-25 | Lake of the Woods | Minnesota | 27077 | 763 | 6 |
2341425 | 2341425 | 2022-03-25 | Lincoln | Minnesota | 27081 | 1212 | 6 |
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);