ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where cases = 24 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Red Lake 8
- Clearwater 6
- Mille Lacs 6
- Aitkin 4
- Crow Wing 4
- Pope 4
- Waseca 4
- Itasca 3
- Lake of the Woods 3
- Le Sueur 3
- Renville 3
- Traverse 3
- Wilkin 3
- Yellow Medicine 3
- Blue Earth 2
- Dodge 2
- Douglas 2
- Freeborn 2
- Houston 2
- Lac qui Parle 2
- Lake 2
- Meeker 2
- Wabasha 2
- Wadena 2
- Beltrami 1
- Cook 1
- Faribault 1
- Fillmore 1
- Grant 1
- Isanti 1
- …
state 1
- Minnesota · 95 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
688136 | 688136 | 2020-11-01 | Cook | Minnesota | 27031 | 24 | 0 |
587611 | 587611 | 2020-10-01 | Lake of the Woods | Minnesota | 27077 | 24 | 1 |
584371 | 584371 | 2020-09-30 | Lake of the Woods | Minnesota | 27077 | 24 | 1 |
581130 | 581130 | 2020-09-29 | Lake of the Woods | Minnesota | 27077 | 24 | 1 |
545470 | 545470 | 2020-09-18 | Clearwater | Minnesota | 27029 | 24 | 0 |
542233 | 542233 | 2020-09-17 | Clearwater | Minnesota | 27029 | 24 | 0 |
538997 | 538997 | 2020-09-16 | Clearwater | Minnesota | 27029 | 24 | 0 |
535760 | 535760 | 2020-09-15 | Clearwater | Minnesota | 27029 | 24 | 0 |
532525 | 532525 | 2020-09-14 | Clearwater | Minnesota | 27029 | 24 | 0 |
529289 | 529289 | 2020-09-13 | Clearwater | Minnesota | 27029 | 24 | 0 |
513133 | 513133 | 2020-09-08 | Lac qui Parle | Minnesota | 27073 | 24 | 0 |
513174 | 513174 | 2020-09-08 | Traverse | Minnesota | 27155 | 24 | 0 |
509901 | 509901 | 2020-09-07 | Lac qui Parle | Minnesota | 27073 | 24 | 0 |
509942 | 509942 | 2020-09-07 | Traverse | Minnesota | 27155 | 24 | 0 |
506709 | 506709 | 2020-09-06 | Traverse | Minnesota | 27155 | 24 | 0 |
435597 | 435597 | 2020-08-15 | Lake | Minnesota | 27075 | 24 | 0 |
435622 | 435622 | 2020-08-15 | Red Lake | Minnesota | 27125 | 24 | 0 |
432371 | 432371 | 2020-08-14 | Lake | Minnesota | 27075 | 24 | 0 |
432396 | 432396 | 2020-08-14 | Red Lake | Minnesota | 27125 | 24 | 0 |
429169 | 429169 | 2020-08-13 | Red Lake | Minnesota | 27125 | 24 | 0 |
425945 | 425945 | 2020-08-12 | Red Lake | Minnesota | 27125 | 24 | 0 |
422723 | 422723 | 2020-08-11 | Red Lake | Minnesota | 27125 | 24 | 0 |
419501 | 419501 | 2020-08-10 | Red Lake | Minnesota | 27125 | 24 | 0 |
416280 | 416280 | 2020-08-09 | Red Lake | Minnesota | 27125 | 24 | 0 |
413060 | 413060 | 2020-08-08 | Red Lake | Minnesota | 27125 | 24 | 0 |
406638 | 406638 | 2020-08-06 | Wadena | Minnesota | 27159 | 24 | 0 |
403420 | 403420 | 2020-08-05 | Wadena | Minnesota | 27159 | 24 | 0 |
400165 | 400165 | 2020-08-04 | Mahnomen | Minnesota | 27087 | 24 | 1 |
377691 | 377691 | 2020-07-28 | Wilkin | Minnesota | 27167 | 24 | 3 |
374476 | 374476 | 2020-07-27 | Wilkin | Minnesota | 27167 | 24 | 3 |
371180 | 371180 | 2020-07-26 | Aitkin | Minnesota | 27001 | 24 | 0 |
371264 | 371264 | 2020-07-26 | Wilkin | Minnesota | 27167 | 24 | 3 |
367970 | 367970 | 2020-07-25 | Aitkin | Minnesota | 27001 | 24 | 0 |
364763 | 364763 | 2020-07-24 | Aitkin | Minnesota | 27001 | 24 | 0 |
361556 | 361556 | 2020-07-23 | Aitkin | Minnesota | 27001 | 24 | 0 |
358403 | 358403 | 2020-07-22 | Norman | Minnesota | 27107 | 24 | 0 |
352005 | 352005 | 2020-07-20 | Pope | Minnesota | 27121 | 24 | 0 |
348805 | 348805 | 2020-07-19 | Pope | Minnesota | 27121 | 24 | 0 |
345604 | 345604 | 2020-07-18 | Pope | Minnesota | 27121 | 24 | 0 |
342404 | 342404 | 2020-07-17 | Pope | Minnesota | 27121 | 24 | 0 |
332795 | 332795 | 2020-07-14 | Koochiching | Minnesota | 27071 | 24 | 1 |
320050 | 320050 | 2020-07-10 | Grant | Minnesota | 27051 | 24 | 0 |
291559 | 291559 | 2020-07-01 | Houston | Minnesota | 27055 | 24 | 0 |
288408 | 288408 | 2020-06-30 | Houston | Minnesota | 27055 | 24 | 0 |
288444 | 288444 | 2020-06-30 | Renville | Minnesota | 27129 | 24 | 2 |
285294 | 285294 | 2020-06-29 | Renville | Minnesota | 27129 | 24 | 2 |
282149 | 282149 | 2020-06-28 | Renville | Minnesota | 27129 | 24 | 1 |
275812 | 275812 | 2020-06-26 | Fillmore | Minnesota | 27045 | 24 | 0 |
272733 | 272733 | 2020-06-25 | Yellow Medicine | Minnesota | 27173 | 24 | 0 |
269596 | 269596 | 2020-06-24 | Yellow Medicine | Minnesota | 27173 | 24 | 0 |
263337 | 263337 | 2020-06-22 | Yellow Medicine | Minnesota | 27173 | 24 | 0 |
256999 | 256999 | 2020-06-20 | Beltrami | Minnesota | 27007 | 24 | 0 |
250839 | 250839 | 2020-06-18 | Wabasha | Minnesota | 27157 | 24 | 0 |
247727 | 247727 | 2020-06-17 | Wabasha | Minnesota | 27157 | 24 | 0 |
225943 | 225943 | 2020-06-10 | Mille Lacs | Minnesota | 27095 | 24 | 1 |
222845 | 222845 | 2020-06-09 | Mille Lacs | Minnesota | 27095 | 24 | 1 |
219725 | 219725 | 2020-06-08 | Faribault | Minnesota | 27043 | 24 | 0 |
219750 | 219750 | 2020-06-08 | Mille Lacs | Minnesota | 27095 | 24 | 1 |
216658 | 216658 | 2020-06-07 | Mille Lacs | Minnesota | 27095 | 24 | 1 |
213570 | 213570 | 2020-06-06 | Mille Lacs | Minnesota | 27095 | 24 | 1 |
210486 | 210486 | 2020-06-05 | Mille Lacs | Minnesota | 27095 | 24 | 1 |
182891 | 182891 | 2020-05-27 | Waseca | Minnesota | 27161 | 24 | 0 |
179842 | 179842 | 2020-05-26 | Unknown | Minnesota | 24 | 9 | |
179845 | 179845 | 2020-05-26 | Waseca | Minnesota | 27161 | 24 | 0 |
173758 | 173758 | 2020-05-24 | Waseca | Minnesota | 27161 | 24 | 0 |
170666 | 170666 | 2020-05-23 | Isanti | Minnesota | 27059 | 24 | 0 |
170716 | 170716 | 2020-05-23 | Waseca | Minnesota | 27161 | 24 | 0 |
167643 | 167643 | 2020-05-22 | McLeod | Minnesota | 27085 | 24 | 0 |
164584 | 164584 | 2020-05-21 | Douglas | Minnesota | 27041 | 24 | 0 |
161555 | 161555 | 2020-05-20 | Douglas | Minnesota | 27041 | 24 | 0 |
149483 | 149483 | 2020-05-16 | Crow Wing | Minnesota | 27035 | 24 | 1 |
149512 | 149512 | 2020-05-16 | Morrison | Minnesota | 27097 | 24 | 0 |
146505 | 146505 | 2020-05-15 | Meeker | Minnesota | 27093 | 24 | 0 |
143478 | 143478 | 2020-05-14 | Crow Wing | Minnesota | 27035 | 24 | 1 |
143505 | 143505 | 2020-05-14 | Meeker | Minnesota | 27093 | 24 | 0 |
128518 | 128518 | 2020-05-09 | Crow Wing | Minnesota | 27035 | 24 | 1 |
128520 | 128520 | 2020-05-09 | Dodge | Minnesota | 27039 | 24 | 0 |
125531 | 125531 | 2020-05-08 | Crow Wing | Minnesota | 27035 | 24 | 1 |
125533 | 125533 | 2020-05-08 | Dodge | Minnesota | 27039 | 24 | 0 |
125543 | 125543 | 2020-05-08 | Itasca | Minnesota | 27061 | 24 | 0 |
122561 | 122561 | 2020-05-07 | Itasca | Minnesota | 27061 | 24 | 0 |
119588 | 119588 | 2020-05-06 | Itasca | Minnesota | 27061 | 24 | 0 |
113748 | 113748 | 2020-05-04 | Jackson | Minnesota | 27063 | 24 | 0 |
113779 | 113779 | 2020-05-04 | Rice | Minnesota | 27131 | 24 | 1 |
113787 | 113787 | 2020-05-04 | Steele | Minnesota | 27147 | 24 | 0 |
102278 | 102278 | 2020-04-30 | Le Sueur | Minnesota | 27079 | 24 | 0 |
99426 | 99426 | 2020-04-29 | Le Sueur | Minnesota | 27079 | 24 | 0 |
96580 | 96580 | 2020-04-28 | Le Sueur | Minnesota | 27079 | 24 | 0 |
93765 | 93765 | 2020-04-27 | Polk | Minnesota | 27119 | 24 | 0 |
76886 | 76886 | 2020-04-21 | Blue Earth | Minnesota | 27013 | 24 | 0 |
74106 | 74106 | 2020-04-20 | Blue Earth | Minnesota | 27013 | 24 | 0 |
57680 | 57680 | 2020-04-14 | Mower | Minnesota | 27099 | 24 | 0 |
54965 | 54965 | 2020-04-13 | Freeborn | Minnesota | 27047 | 24 | 0 |
52283 | 52283 | 2020-04-12 | Freeborn | Minnesota | 27047 | 24 | 0 |
8825 | 8825 | 2020-03-23 | Ramsey | Minnesota | 27123 | 24 | 1 |
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);