ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 92 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Otter Tail 3
- Roseau 3
- Wabasha 3
- Brown 2
- Chippewa 2
- Crow Wing 2
- Fillmore 2
- Grant 2
- McLeod 2
- Pope 2
- Washington 2
- Becker 1
- Benton 1
- Big Stone 1
- Carver 1
- Cass 1
- Chisago 1
- Cottonwood 1
- Dodge 1
- Faribault 1
- Goodhue 1
- Houston 1
- Kanabec 1
- Koochiching 1
- Lake 1
- Mille Lacs 1
- Morrison 1
- Red Lake 1
- St. Louis 1
- Steele 1
- …
state 1
- Minnesota · 46 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
691428 | 691428 | 2020-11-02 | Red Lake | Minnesota | 27125 | 92 | 2 |
658955 | 658955 | 2020-10-23 | Grant | Minnesota | 27051 | 92 | 4 |
655710 | 655710 | 2020-10-22 | Grant | Minnesota | 27051 | 92 | 4 |
633002 | 633002 | 2020-10-15 | Lake | Minnesota | 27075 | 92 | 0 |
600544 | 600544 | 2020-10-05 | Big Stone | Minnesota | 27011 | 92 | 0 |
568185 | 568185 | 2020-09-25 | Pope | Minnesota | 27121 | 92 | 0 |
564945 | 564945 | 2020-09-24 | Pope | Minnesota | 27121 | 92 | 0 |
539015 | 539015 | 2020-09-16 | Kanabec | Minnesota | 27065 | 92 | 8 |
532533 | 532533 | 2020-09-14 | Fillmore | Minnesota | 27045 | 92 | 0 |
529297 | 529297 | 2020-09-13 | Fillmore | Minnesota | 27045 | 92 | 0 |
522830 | 522830 | 2020-09-11 | Houston | Minnesota | 27055 | 92 | 0 |
519633 | 519633 | 2020-09-10 | Roseau | Minnesota | 27135 | 92 | 0 |
516398 | 516398 | 2020-09-09 | Roseau | Minnesota | 27135 | 92 | 0 |
513164 | 513164 | 2020-09-08 | Roseau | Minnesota | 27135 | 92 | 0 |
506667 | 506667 | 2020-09-06 | Koochiching | Minnesota | 27071 | 92 | 3 |
474344 | 474344 | 2020-08-27 | Mille Lacs | Minnesota | 27095 | 92 | 3 |
464616 | 464616 | 2020-08-24 | Cass | Minnesota | 27021 | 92 | 3 |
432341 | 432341 | 2020-08-14 | Brown | Minnesota | 27015 | 92 | 2 |
429114 | 429114 | 2020-08-13 | Brown | Minnesota | 27015 | 92 | 2 |
429128 | 429128 | 2020-08-13 | Faribault | Minnesota | 27043 | 92 | 0 |
425962 | 425962 | 2020-08-12 | Wabasha | Minnesota | 27157 | 92 | 0 |
419518 | 419518 | 2020-08-10 | Wabasha | Minnesota | 27157 | 92 | 0 |
416266 | 416266 | 2020-08-09 | Morrison | Minnesota | 27097 | 92 | 1 |
416297 | 416297 | 2020-08-09 | Wabasha | Minnesota | 27157 | 92 | 0 |
384052 | 384052 | 2020-07-30 | Chippewa | Minnesota | 27023 | 92 | 1 |
380835 | 380835 | 2020-07-29 | Chippewa | Minnesota | 27023 | 92 | 1 |
361558 | 361558 | 2020-07-23 | Becker | Minnesota | 27005 | 92 | 0 |
352026 | 352026 | 2020-07-20 | Waseca | Minnesota | 27161 | 92 | 0 |
313695 | 313695 | 2020-07-08 | Dodge | Minnesota | 27039 | 92 | 0 |
310550 | 310550 | 2020-07-07 | McLeod | Minnesota | 27085 | 92 | 0 |
307382 | 307382 | 2020-07-06 | McLeod | Minnesota | 27085 | 92 | 0 |
294740 | 294740 | 2020-07-02 | Otter Tail | Minnesota | 27111 | 92 | 1 |
291586 | 291586 | 2020-07-01 | Otter Tail | Minnesota | 27111 | 92 | 1 |
288435 | 288435 | 2020-06-30 | Otter Tail | Minnesota | 27111 | 92 | 1 |
282098 | 282098 | 2020-06-28 | Chisago | Minnesota | 27025 | 92 | 1 |
253893 | 253893 | 2020-06-19 | Crow Wing | Minnesota | 27035 | 92 | 11 |
250778 | 250778 | 2020-06-18 | Crow Wing | Minnesota | 27035 | 92 | 10 |
232127 | 232127 | 2020-06-12 | Goodhue | Minnesota | 27049 | 92 | 7 |
219720 | 219720 | 2020-06-08 | Cottonwood | Minnesota | 27033 | 92 | 0 |
146532 | 146532 | 2020-05-15 | Steele | Minnesota | 27147 | 92 | 0 |
134492 | 134492 | 2020-05-11 | Carver | Minnesota | 27019 | 92 | 1 |
131496 | 131496 | 2020-05-10 | Benton | Minnesota | 27009 | 92 | 2 |
131560 | 131560 | 2020-05-10 | St. Louis | Minnesota | 27137 | 92 | 12 |
128584 | 128584 | 2020-05-09 | Wright | Minnesota | 27171 | 92 | 1 |
68633 | 68633 | 2020-04-18 | Washington | Minnesota | 27163 | 92 | 3 |
65881 | 65881 | 2020-04-17 | Washington | Minnesota | 27163 | 92 | 3 |
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);