ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where cases = 52 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Swift 7
- Chippewa 5
- Yellow Medicine 5
- Le Sueur 4
- Wilkin 4
- Hubbard 3
- Norman 3
- Pennington 3
- Roseau 3
- Clearwater 2
- Dodge 2
- Grant 2
- Kanabec 2
- McLeod 2
- Otter Tail 2
- Aitkin 1
- Carlton 1
- Cottonwood 1
- Dakota 1
- Freeborn 1
- Goodhue 1
- Hennepin 1
- Houston 1
- Isanti 1
- Itasca 1
- Jackson 1
- Lincoln 1
- Marshall 1
- Martin 1
- Mille Lacs 1
- …
state 1
- Minnesota · 76 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636273 | 636273 | 2020-10-16 | Red Lake | Minnesota | 27125 | 52 | 2 |
626490 | 626490 | 2020-10-13 | Clearwater | Minnesota | 27029 | 52 | 0 |
623248 | 623248 | 2020-10-12 | Clearwater | Minnesota | 27029 | 52 | 0 |
571410 | 571410 | 2020-09-26 | Marshall | Minnesota | 27089 | 52 | 1 |
561698 | 561698 | 2020-09-23 | Norman | Minnesota | 27107 | 52 | 0 |
558461 | 558461 | 2020-09-22 | Norman | Minnesota | 27107 | 52 | 0 |
555224 | 555224 | 2020-09-21 | Norman | Minnesota | 27107 | 52 | 0 |
526067 | 526067 | 2020-09-12 | Hubbard | Minnesota | 27057 | 52 | 0 |
522831 | 522831 | 2020-09-11 | Hubbard | Minnesota | 27057 | 52 | 0 |
519594 | 519594 | 2020-09-10 | Hubbard | Minnesota | 27057 | 52 | 0 |
516415 | 516415 | 2020-09-09 | Wilkin | Minnesota | 27167 | 52 | 3 |
509949 | 509949 | 2020-09-07 | Wilkin | Minnesota | 27167 | 52 | 3 |
506712 | 506712 | 2020-09-06 | Wadena | Minnesota | 27159 | 52 | 0 |
506716 | 506716 | 2020-09-06 | Wilkin | Minnesota | 27167 | 52 | 3 |
503483 | 503483 | 2020-09-05 | Wilkin | Minnesota | 27167 | 52 | 3 |
496931 | 496931 | 2020-09-03 | Aitkin | Minnesota | 27001 | 52 | 1 |
490538 | 490538 | 2020-09-01 | Stevens | Minnesota | 27149 | 52 | 1 |
461407 | 461407 | 2020-08-23 | Kanabec | Minnesota | 27065 | 52 | 4 |
458180 | 458180 | 2020-08-22 | Kanabec | Minnesota | 27065 | 52 | 4 |
448524 | 448524 | 2020-08-19 | Pope | Minnesota | 27121 | 52 | 0 |
435587 | 435587 | 2020-08-15 | Houston | Minnesota | 27055 | 52 | 0 |
425970 | 425970 | 2020-08-12 | Yellow Medicine | Minnesota | 27173 | 52 | 0 |
422728 | 422728 | 2020-08-11 | Roseau | Minnesota | 27135 | 52 | 0 |
422748 | 422748 | 2020-08-11 | Yellow Medicine | Minnesota | 27173 | 52 | 0 |
419506 | 419506 | 2020-08-10 | Roseau | Minnesota | 27135 | 52 | 0 |
419526 | 419526 | 2020-08-10 | Yellow Medicine | Minnesota | 27173 | 52 | 0 |
416285 | 416285 | 2020-08-09 | Roseau | Minnesota | 27135 | 52 | 0 |
416305 | 416305 | 2020-08-09 | Yellow Medicine | Minnesota | 27173 | 52 | 0 |
413073 | 413073 | 2020-08-08 | Swift | Minnesota | 27151 | 52 | 1 |
413085 | 413085 | 2020-08-08 | Yellow Medicine | Minnesota | 27173 | 52 | 0 |
409853 | 409853 | 2020-08-07 | Swift | Minnesota | 27151 | 52 | 1 |
406583 | 406583 | 2020-08-06 | Grant | Minnesota | 27051 | 52 | 3 |
406633 | 406633 | 2020-08-06 | Swift | Minnesota | 27151 | 52 | 1 |
403365 | 403365 | 2020-08-05 | Grant | Minnesota | 27051 | 52 | 1 |
403415 | 403415 | 2020-08-05 | Swift | Minnesota | 27151 | 52 | 1 |
400198 | 400198 | 2020-08-04 | Swift | Minnesota | 27151 | 52 | 1 |
396984 | 396984 | 2020-08-03 | Swift | Minnesota | 27151 | 52 | 1 |
393768 | 393768 | 2020-08-02 | Swift | Minnesota | 27151 | 52 | 1 |
380871 | 380871 | 2020-07-29 | Mille Lacs | Minnesota | 27095 | 52 | 3 |
371220 | 371220 | 2020-07-26 | Lincoln | Minnesota | 27081 | 52 | 0 |
313731 | 313731 | 2020-07-08 | Pennington | Minnesota | 27113 | 52 | 0 |
310561 | 310561 | 2020-07-07 | Pennington | Minnesota | 27113 | 52 | 0 |
307395 | 307395 | 2020-07-06 | Pipestone | Minnesota | 27117 | 52 | 2 |
279018 | 279018 | 2020-06-27 | Waseca | Minnesota | 27161 | 52 | 0 |
260153 | 260153 | 2020-06-21 | Jackson | Minnesota | 27063 | 52 | 0 |
253905 | 253905 | 2020-06-19 | Isanti | Minnesota | 27059 | 52 | 0 |
250816 | 250816 | 2020-06-18 | Pennington | Minnesota | 27113 | 52 | 0 |
244574 | 244574 | 2020-06-16 | Le Sueur | Minnesota | 27079 | 52 | 1 |
241463 | 241463 | 2020-06-15 | Le Sueur | Minnesota | 27079 | 52 | 1 |
238354 | 238354 | 2020-06-14 | Le Sueur | Minnesota | 27079 | 52 | 1 |
235247 | 235247 | 2020-06-13 | Le Sueur | Minnesota | 27079 | 52 | 1 |
232147 | 232147 | 2020-06-12 | McLeod | Minnesota | 27085 | 52 | 0 |
229043 | 229043 | 2020-06-11 | McLeod | Minnesota | 27085 | 52 | 0 |
225944 | 225944 | 2020-06-10 | Morrison | Minnesota | 27097 | 52 | 0 |
219716 | 219716 | 2020-06-08 | Chippewa | Minnesota | 27023 | 52 | 1 |
216624 | 216624 | 2020-06-07 | Chippewa | Minnesota | 27023 | 52 | 1 |
213536 | 213536 | 2020-06-06 | Chippewa | Minnesota | 27023 | 52 | 1 |
210452 | 210452 | 2020-06-05 | Chippewa | Minnesota | 27023 | 52 | 1 |
207371 | 207371 | 2020-06-04 | Chippewa | Minnesota | 27023 | 52 | 1 |
195076 | 195076 | 2020-05-31 | Dodge | Minnesota | 27039 | 52 | 0 |
192008 | 192008 | 2020-05-30 | Dodge | Minnesota | 27039 | 52 | 0 |
173703 | 173703 | 2020-05-24 | Goodhue | Minnesota | 27049 | 52 | 2 |
173709 | 173709 | 2020-05-24 | Itasca | Minnesota | 27061 | 52 | 7 |
167653 | 167653 | 2020-05-22 | Otter Tail | Minnesota | 27111 | 52 | 0 |
164617 | 164617 | 2020-05-21 | Otter Tail | Minnesota | 27111 | 52 | 0 |
149539 | 149539 | 2020-05-16 | Todd | Minnesota | 27153 | 52 | 0 |
146477 | 146477 | 2020-05-15 | Cottonwood | Minnesota | 27033 | 52 | 0 |
143484 | 143484 | 2020-05-14 | Freeborn | Minnesota | 27047 | 52 | 0 |
131548 | 131548 | 2020-05-10 | Polk | Minnesota | 27119 | 52 | 1 |
108032 | 108032 | 2020-05-02 | Scott | Minnesota | 27139 | 52 | 1 |
96585 | 96585 | 2020-04-28 | Martin | Minnesota | 27091 | 52 | 4 |
93720 | 93720 | 2020-04-27 | Carlton | Minnesota | 27017 | 52 | 0 |
90942 | 90942 | 2020-04-26 | Pine | Minnesota | 27115 | 52 | 0 |
74163 | 74163 | 2020-04-20 | St. Louis | Minnesota | 27137 | 52 | 10 |
27134 | 27134 | 2020-04-02 | Dakota | Minnesota | 27037 | 52 | 0 |
6558 | 6558 | 2020-03-21 | Hennepin | Minnesota | 27053 | 52 | 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);