ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 37 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Renville 8
- Hubbard 6
- Kanabec 5
- Mahnomen 5
- Houston 4
- McLeod 4
- Red Lake 4
- Becker 3
- Norman 3
- Pennington 3
- Redwood 3
- Carlton 2
- Clearwater 2
- Lake 2
- Pipestone 2
- Yellow Medicine 2
- Brown 1
- Chippewa 1
- Chisago 1
- Cottonwood 1
- Freeborn 1
- Isanti 1
- Jackson 1
- Kittson 1
- Koochiching 1
- Lake of the Woods 1
- Lincoln 1
- Marshall 1
- Martin 1
- Mower 1
- …
state 1
- Minnesota · 80 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
655719 | 655719 | 2020-10-22 | Kittson | Minnesota | 27069 | 37 | 0 |
623272 | 623272 | 2020-10-12 | Lake of the Woods | Minnesota | 27077 | 37 | 1 |
600553 | 600553 | 2020-10-05 | Clearwater | Minnesota | 27029 | 37 | 0 |
597310 | 597310 | 2020-10-04 | Clearwater | Minnesota | 27029 | 37 | 0 |
548756 | 548756 | 2020-09-19 | Red Lake | Minnesota | 27125 | 37 | 0 |
545518 | 545518 | 2020-09-18 | Red Lake | Minnesota | 27125 | 37 | 0 |
542281 | 542281 | 2020-09-17 | Red Lake | Minnesota | 27125 | 37 | 0 |
539045 | 539045 | 2020-09-16 | Red Lake | Minnesota | 27125 | 37 | 0 |
516373 | 516373 | 2020-09-09 | Mahnomen | Minnesota | 27087 | 37 | 1 |
506674 | 506674 | 2020-09-06 | Mahnomen | Minnesota | 27087 | 37 | 1 |
503436 | 503436 | 2020-09-05 | Lake | Minnesota | 27075 | 37 | 0 |
503441 | 503441 | 2020-09-05 | Mahnomen | Minnesota | 27087 | 37 | 1 |
500202 | 500202 | 2020-09-04 | Lake | Minnesota | 27075 | 37 | 0 |
493740 | 493740 | 2020-09-02 | Mahnomen | Minnesota | 27087 | 37 | 1 |
490506 | 490506 | 2020-09-01 | Mahnomen | Minnesota | 27087 | 37 | 1 |
490507 | 490507 | 2020-09-01 | Marshall | Minnesota | 27089 | 37 | 0 |
448492 | 448492 | 2020-08-19 | Hubbard | Minnesota | 27057 | 37 | 0 |
445266 | 445266 | 2020-08-18 | Hubbard | Minnesota | 27057 | 37 | 0 |
442040 | 442040 | 2020-08-17 | Hubbard | Minnesota | 27057 | 37 | 0 |
438813 | 438813 | 2020-08-16 | Hubbard | Minnesota | 27057 | 37 | 0 |
435588 | 435588 | 2020-08-15 | Hubbard | Minnesota | 27057 | 37 | 0 |
435623 | 435623 | 2020-08-15 | Redwood | Minnesota | 27127 | 37 | 0 |
432362 | 432362 | 2020-08-14 | Hubbard | Minnesota | 27057 | 37 | 0 |
432366 | 432366 | 2020-08-14 | Kanabec | Minnesota | 27065 | 37 | 2 |
432397 | 432397 | 2020-08-14 | Redwood | Minnesota | 27127 | 37 | 0 |
429139 | 429139 | 2020-08-13 | Kanabec | Minnesota | 27065 | 37 | 2 |
429170 | 429170 | 2020-08-13 | Redwood | Minnesota | 27127 | 37 | 0 |
425915 | 425915 | 2020-08-12 | Kanabec | Minnesota | 27065 | 37 | 2 |
422693 | 422693 | 2020-08-11 | Kanabec | Minnesota | 27065 | 37 | 1 |
419471 | 419471 | 2020-08-10 | Kanabec | Minnesota | 27065 | 37 | 1 |
406611 | 406611 | 2020-08-06 | Norman | Minnesota | 27107 | 37 | 0 |
403393 | 403393 | 2020-08-05 | Norman | Minnesota | 27107 | 37 | 0 |
400176 | 400176 | 2020-08-04 | Norman | Minnesota | 27107 | 37 | 0 |
387286 | 387286 | 2020-07-31 | Houston | Minnesota | 27055 | 37 | 0 |
384068 | 384068 | 2020-07-30 | Houston | Minnesota | 27055 | 37 | 0 |
380851 | 380851 | 2020-07-29 | Houston | Minnesota | 27055 | 37 | 0 |
377634 | 377634 | 2020-07-28 | Houston | Minnesota | 27055 | 37 | 0 |
358437 | 358437 | 2020-07-22 | Yellow Medicine | Minnesota | 27173 | 37 | 0 |
355234 | 355234 | 2020-07-21 | Yellow Medicine | Minnesota | 27173 | 37 | 0 |
351981 | 351981 | 2020-07-20 | Koochiching | Minnesota | 27071 | 37 | 2 |
342410 | 342410 | 2020-07-17 | Rock | Minnesota | 27133 | 37 | 0 |
339188 | 339188 | 2020-07-16 | Lincoln | Minnesota | 27081 | 37 | 0 |
339212 | 339212 | 2020-07-16 | Renville | Minnesota | 27129 | 37 | 3 |
336016 | 336016 | 2020-07-15 | Renville | Minnesota | 27129 | 37 | 3 |
332823 | 332823 | 2020-07-14 | Renville | Minnesota | 27129 | 37 | 3 |
329636 | 329636 | 2020-07-13 | Renville | Minnesota | 27129 | 37 | 3 |
326450 | 326450 | 2020-07-12 | Renville | Minnesota | 27129 | 37 | 2 |
323267 | 323267 | 2020-07-11 | Renville | Minnesota | 27129 | 37 | 2 |
320088 | 320088 | 2020-07-10 | Renville | Minnesota | 27129 | 37 | 2 |
316913 | 316913 | 2020-07-09 | Renville | Minnesota | 27129 | 37 | 2 |
313683 | 313683 | 2020-07-08 | Brown | Minnesota | 27015 | 37 | 2 |
301064 | 301064 | 2020-07-04 | Pipestone | Minnesota | 27117 | 37 | 1 |
297901 | 297901 | 2020-07-03 | Pipestone | Minnesota | 27117 | 37 | 1 |
275859 | 275859 | 2020-06-26 | Sibley | Minnesota | 27143 | 37 | 2 |
257076 | 257076 | 2020-06-20 | Waseca | Minnesota | 27161 | 37 | 0 |
229054 | 229054 | 2020-06-11 | Pennington | Minnesota | 27113 | 37 | 0 |
225952 | 225952 | 2020-06-10 | Pennington | Minnesota | 27113 | 37 | 0 |
222854 | 222854 | 2020-06-09 | Pennington | Minnesota | 27113 | 37 | 0 |
213553 | 213553 | 2020-06-06 | Isanti | Minnesota | 27059 | 37 | 0 |
204322 | 204322 | 2020-06-03 | McLeod | Minnesota | 27085 | 37 | 0 |
201245 | 201245 | 2020-06-02 | McLeod | Minnesota | 27085 | 37 | 0 |
198172 | 198172 | 2020-06-01 | McLeod | Minnesota | 27085 | 37 | 0 |
195101 | 195101 | 2020-05-31 | McLeod | Minnesota | 27085 | 37 | 0 |
188974 | 188974 | 2020-05-29 | Murray | Minnesota | 27101 | 37 | 0 |
182815 | 182815 | 2020-05-27 | Becker | Minnesota | 27005 | 37 | 0 |
179769 | 179769 | 2020-05-26 | Becker | Minnesota | 27005 | 37 | 0 |
176725 | 176725 | 2020-05-25 | Becker | Minnesota | 27005 | 37 | 0 |
167630 | 167630 | 2020-05-22 | Jackson | Minnesota | 27063 | 37 | 0 |
164576 | 164576 | 2020-05-21 | Chippewa | Minnesota | 27023 | 37 | 0 |
155504 | 155504 | 2020-05-18 | Chisago | Minnesota | 27025 | 37 | 1 |
152526 | 152526 | 2020-05-17 | Nicollet | Minnesota | 27103 | 37 | 3 |
125561 | 125561 | 2020-05-08 | Mower | Minnesota | 27099 | 37 | 0 |
122603 | 122603 | 2020-05-07 | Steele | Minnesota | 27147 | 37 | 0 |
116622 | 116622 | 2020-05-05 | Freeborn | Minnesota | 27047 | 37 | 0 |
113734 | 113734 | 2020-05-04 | Cottonwood | Minnesota | 27033 | 37 | 0 |
76888 | 76888 | 2020-04-21 | Carlton | Minnesota | 27017 | 37 | 0 |
74108 | 74108 | 2020-04-20 | Carlton | Minnesota | 27017 | 37 | 0 |
49627 | 49627 | 2020-04-11 | Martin | Minnesota | 27091 | 37 | 4 |
49647 | 49647 | 2020-04-11 | St. Louis | Minnesota | 27137 | 37 | 4 |
16664 | 16664 | 2020-03-28 | Olmsted | Minnesota | 27109 | 37 | 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);