ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
217 rows where cases = 7 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Lake of the Woods 18
- Chisago 16
- Brown 14
- Clearwater 12
- Cook 10
- Nicollet 8
- Stearns 8
- Cass 7
- Mahnomen 7
- Wilkin 7
- Isanti 6
- Mille Lacs 6
- Dakota 5
- Lincoln 5
- Norman 5
- Pipestone 5
- Yellow Medicine 5
- Aitkin 4
- Faribault 4
- Koochiching 4
- Redwood 4
- Anoka 3
- Kittson 3
- Marshall 3
- Renville 3
- Rice 3
- Todd 3
- Unknown 3
- Wabasha 3
- Watonwan 3
- …
state 1
- Minnesota · 217 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
610281 | 610281 | 2020-10-08 | Cook | Minnesota | 27031 | 7 | 0 |
607039 | 607039 | 2020-10-07 | Cook | Minnesota | 27031 | 7 | 0 |
603796 | 603796 | 2020-10-06 | Cook | Minnesota | 27031 | 7 | 0 |
600554 | 600554 | 2020-10-05 | Cook | Minnesota | 27031 | 7 | 0 |
597311 | 597311 | 2020-10-04 | Cook | Minnesota | 27031 | 7 | 0 |
594070 | 594070 | 2020-10-03 | Cook | Minnesota | 27031 | 7 | 0 |
590829 | 590829 | 2020-10-02 | Cook | Minnesota | 27031 | 7 | 0 |
587588 | 587588 | 2020-10-01 | Cook | Minnesota | 27031 | 7 | 0 |
584348 | 584348 | 2020-09-30 | Cook | Minnesota | 27031 | 7 | 0 |
581107 | 581107 | 2020-09-29 | Cook | Minnesota | 27031 | 7 | 0 |
490498 | 490498 | 2020-09-01 | Kittson | Minnesota | 27069 | 7 | 0 |
487265 | 487265 | 2020-08-31 | Kittson | Minnesota | 27069 | 7 | 0 |
487269 | 487269 | 2020-08-31 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
484031 | 484031 | 2020-08-30 | Kittson | Minnesota | 27069 | 7 | 0 |
484035 | 484035 | 2020-08-30 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
480800 | 480800 | 2020-08-29 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
477568 | 477568 | 2020-08-28 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
474335 | 474335 | 2020-08-27 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
471103 | 471103 | 2020-08-26 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
467873 | 467873 | 2020-08-25 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
464644 | 464644 | 2020-08-24 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
461413 | 461413 | 2020-08-23 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
458186 | 458186 | 2020-08-22 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
454958 | 454958 | 2020-08-21 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
451730 | 451730 | 2020-08-20 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
448502 | 448502 | 2020-08-19 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
445276 | 445276 | 2020-08-18 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
442050 | 442050 | 2020-08-17 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
438823 | 438823 | 2020-08-16 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
435598 | 435598 | 2020-08-15 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
432372 | 432372 | 2020-08-14 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
416254 | 416254 | 2020-08-09 | Lac qui Parle | Minnesota | 27073 | 7 | 0 |
413034 | 413034 | 2020-08-08 | Lac qui Parle | Minnesota | 27073 | 7 | 0 |
329649 | 329649 | 2020-07-13 | Traverse | Minnesota | 27155 | 7 | 0 |
307366 | 307366 | 2020-07-06 | Hubbard | Minnesota | 27057 | 7 | 0 |
304185 | 304185 | 2020-07-05 | Clearwater | Minnesota | 27029 | 7 | 0 |
301021 | 301021 | 2020-07-04 | Clearwater | Minnesota | 27029 | 7 | 0 |
297858 | 297858 | 2020-07-03 | Clearwater | Minnesota | 27029 | 7 | 0 |
294700 | 294700 | 2020-07-02 | Clearwater | Minnesota | 27029 | 7 | 0 |
294727 | 294727 | 2020-07-02 | Mahnomen | Minnesota | 27087 | 7 | 1 |
291546 | 291546 | 2020-07-01 | Clearwater | Minnesota | 27029 | 7 | 0 |
291573 | 291573 | 2020-07-01 | Mahnomen | Minnesota | 27087 | 7 | 1 |
288395 | 288395 | 2020-06-30 | Clearwater | Minnesota | 27029 | 7 | 0 |
288418 | 288418 | 2020-06-30 | Lake | Minnesota | 27075 | 7 | 0 |
288422 | 288422 | 2020-06-30 | Mahnomen | Minnesota | 27087 | 7 | 1 |
285245 | 285245 | 2020-06-29 | Clearwater | Minnesota | 27029 | 7 | 0 |
285272 | 285272 | 2020-06-29 | Mahnomen | Minnesota | 27087 | 7 | 1 |
282100 | 282100 | 2020-06-28 | Clearwater | Minnesota | 27029 | 7 | 0 |
282125 | 282125 | 2020-06-28 | Lincoln | Minnesota | 27081 | 7 | 0 |
282127 | 282127 | 2020-06-28 | Mahnomen | Minnesota | 27087 | 7 | 1 |
278952 | 278952 | 2020-06-27 | Clearwater | Minnesota | 27029 | 7 | 0 |
278977 | 278977 | 2020-06-27 | Lincoln | Minnesota | 27081 | 7 | 0 |
278979 | 278979 | 2020-06-27 | Mahnomen | Minnesota | 27087 | 7 | 1 |
275804 | 275804 | 2020-06-26 | Clearwater | Minnesota | 27029 | 7 | 0 |
275829 | 275829 | 2020-06-26 | Lincoln | Minnesota | 27081 | 7 | 0 |
275831 | 275831 | 2020-06-26 | Mahnomen | Minnesota | 27087 | 7 | 1 |
272661 | 272661 | 2020-06-25 | Clearwater | Minnesota | 27029 | 7 | 0 |
272686 | 272686 | 2020-06-25 | Lincoln | Minnesota | 27081 | 7 | 0 |
269524 | 269524 | 2020-06-24 | Clearwater | Minnesota | 27029 | 7 | 0 |
269549 | 269549 | 2020-06-24 | Lincoln | Minnesota | 27081 | 7 | 0 |
253903 | 253903 | 2020-06-19 | Houston | Minnesota | 27055 | 7 | 0 |
247676 | 247676 | 2020-06-17 | Houston | Minnesota | 27055 | 7 | 0 |
222885 | 222885 | 2020-06-09 | Yellow Medicine | Minnesota | 27173 | 7 | 0 |
219790 | 219790 | 2020-06-08 | Yellow Medicine | Minnesota | 27173 | 7 | 0 |
216674 | 216674 | 2020-06-07 | Redwood | Minnesota | 27127 | 7 | 0 |
216698 | 216698 | 2020-06-07 | Yellow Medicine | Minnesota | 27173 | 7 | 0 |
213586 | 213586 | 2020-06-06 | Redwood | Minnesota | 27127 | 7 | 0 |
213587 | 213587 | 2020-06-06 | Renville | Minnesota | 27129 | 7 | 0 |
213610 | 213610 | 2020-06-06 | Yellow Medicine | Minnesota | 27173 | 7 | 0 |
210502 | 210502 | 2020-06-05 | Redwood | Minnesota | 27127 | 7 | 0 |
210503 | 210503 | 2020-06-05 | Renville | Minnesota | 27129 | 7 | 0 |
210526 | 210526 | 2020-06-05 | Yellow Medicine | Minnesota | 27173 | 7 | 0 |
207421 | 207421 | 2020-06-04 | Redwood | Minnesota | 27127 | 7 | 0 |
207422 | 207422 | 2020-06-04 | Renville | Minnesota | 27129 | 7 | 0 |
192024 | 192024 | 2020-05-30 | Koochiching | Minnesota | 27071 | 7 | 0 |
188926 | 188926 | 2020-05-29 | Aitkin | Minnesota | 27001 | 7 | 0 |
188960 | 188960 | 2020-05-29 | Koochiching | Minnesota | 27071 | 7 | 0 |
185868 | 185868 | 2020-05-28 | Aitkin | Minnesota | 27001 | 7 | 0 |
185902 | 185902 | 2020-05-28 | Koochiching | Minnesota | 27071 | 7 | 0 |
182813 | 182813 | 2020-05-27 | Aitkin | Minnesota | 27001 | 7 | 0 |
182847 | 182847 | 2020-05-27 | Koochiching | Minnesota | 27071 | 7 | 0 |
179767 | 179767 | 2020-05-26 | Aitkin | Minnesota | 27001 | 7 | 0 |
173734 | 173734 | 2020-05-24 | Pennington | Minnesota | 27113 | 7 | 0 |
173738 | 173738 | 2020-05-24 | Pope | Minnesota | 27121 | 7 | 0 |
170692 | 170692 | 2020-05-23 | Pennington | Minnesota | 27113 | 7 | 0 |
149534 | 149534 | 2020-05-16 | Sibley | Minnesota | 27143 | 7 | 0 |
143506 | 143506 | 2020-05-14 | Mille Lacs | Minnesota | 27095 | 7 | 1 |
140511 | 140511 | 2020-05-13 | Mille Lacs | Minnesota | 27095 | 7 | 1 |
140522 | 140522 | 2020-05-13 | Pipestone | Minnesota | 27117 | 7 | 0 |
137517 | 137517 | 2020-05-12 | Mille Lacs | Minnesota | 27095 | 7 | 1 |
137528 | 137528 | 2020-05-12 | Pipestone | Minnesota | 27117 | 7 | 0 |
134527 | 134527 | 2020-05-11 | Mille Lacs | Minnesota | 27095 | 7 | 1 |
134538 | 134538 | 2020-05-11 | Pipestone | Minnesota | 27117 | 7 | 0 |
131519 | 131519 | 2020-05-10 | Isanti | Minnesota | 27059 | 7 | 0 |
131536 | 131536 | 2020-05-10 | Mille Lacs | Minnesota | 27095 | 7 | 1 |
131547 | 131547 | 2020-05-10 | Pipestone | Minnesota | 27117 | 7 | 0 |
128529 | 128529 | 2020-05-09 | Isanti | Minnesota | 27059 | 7 | 0 |
128546 | 128546 | 2020-05-09 | Mille Lacs | Minnesota | 27095 | 7 | 1 |
128557 | 128557 | 2020-05-09 | Pipestone | Minnesota | 27117 | 7 | 0 |
125525 | 125525 | 2020-05-08 | Cass | Minnesota | 27021 | 7 | 0 |
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);