ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 42 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Jackson 6
- Aitkin 3
- Crow Wing 3
- Hubbard 3
- Meeker 3
- Roseau 3
- Big Stone 2
- Chippewa 2
- Houston 2
- Lake of the Woods 2
- Murray 2
- Polk 2
- Rock 2
- Todd 2
- Watonwan 2
- Anoka 1
- Clay 1
- Cottonwood 1
- Douglas 1
- Itasca 1
- Kittson 1
- Lake 1
- Mahnomen 1
- Martin 1
- Mille Lacs 1
- Mower 1
- Ramsey 1
- Red Lake 1
- Renville 1
- St. Louis 1
- …
state 1
- Minnesota · 56 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
668697 | 668697 | 2020-10-26 | Kittson | Minnesota | 27069 | 42 | 0 |
649233 | 649233 | 2020-10-20 | Lake of the Woods | Minnesota | 27077 | 42 | 1 |
645989 | 645989 | 2020-10-19 | Lake of the Woods | Minnesota | 27077 | 42 | 1 |
564947 | 564947 | 2020-09-24 | Red Lake | Minnesota | 27125 | 42 | 1 |
539025 | 539025 | 2020-09-16 | Mahnomen | Minnesota | 27087 | 42 | 1 |
513102 | 513102 | 2020-09-08 | Big Stone | Minnesota | 27011 | 42 | 0 |
509870 | 509870 | 2020-09-07 | Big Stone | Minnesota | 27011 | 42 | 0 |
506669 | 506669 | 2020-09-06 | Lake | Minnesota | 27075 | 42 | 0 |
477558 | 477558 | 2020-08-28 | Hubbard | Minnesota | 27057 | 42 | 0 |
474325 | 474325 | 2020-08-27 | Hubbard | Minnesota | 27057 | 42 | 0 |
464634 | 464634 | 2020-08-24 | Hubbard | Minnesota | 27057 | 42 | 0 |
438785 | 438785 | 2020-08-16 | Aitkin | Minnesota | 27001 | 42 | 1 |
435560 | 435560 | 2020-08-15 | Aitkin | Minnesota | 27001 | 42 | 1 |
432334 | 432334 | 2020-08-14 | Aitkin | Minnesota | 27001 | 42 | 1 |
422688 | 422688 | 2020-08-11 | Houston | Minnesota | 27055 | 42 | 0 |
416245 | 416245 | 2020-08-09 | Houston | Minnesota | 27055 | 42 | 0 |
390543 | 390543 | 2020-08-01 | Roseau | Minnesota | 27135 | 42 | 0 |
387326 | 387326 | 2020-07-31 | Roseau | Minnesota | 27135 | 42 | 0 |
384108 | 384108 | 2020-07-30 | Roseau | Minnesota | 27135 | 42 | 0 |
374479 | 374479 | 2020-07-27 | Yellow Medicine | Minnesota | 27173 | 42 | 0 |
352011 | 352011 | 2020-07-20 | Rock | Minnesota | 27133 | 42 | 0 |
348811 | 348811 | 2020-07-19 | Rock | Minnesota | 27133 | 42 | 0 |
342391 | 342391 | 2020-07-17 | Mille Lacs | Minnesota | 27095 | 42 | 2 |
342408 | 342408 | 2020-07-17 | Renville | Minnesota | 27129 | 42 | 3 |
232152 | 232152 | 2020-06-12 | Murray | Minnesota | 27101 | 42 | 0 |
229048 | 229048 | 2020-06-11 | Murray | Minnesota | 27101 | 42 | 0 |
222830 | 222830 | 2020-06-09 | Jackson | Minnesota | 27063 | 42 | 0 |
219735 | 219735 | 2020-06-08 | Jackson | Minnesota | 27063 | 42 | 0 |
216643 | 216643 | 2020-06-07 | Jackson | Minnesota | 27063 | 42 | 0 |
213555 | 213555 | 2020-06-06 | Jackson | Minnesota | 27063 | 42 | 0 |
210471 | 210471 | 2020-06-05 | Jackson | Minnesota | 27063 | 42 | 0 |
207390 | 207390 | 2020-06-04 | Jackson | Minnesota | 27063 | 42 | 0 |
195077 | 195077 | 2020-05-31 | Douglas | Minnesota | 27041 | 42 | 0 |
179778 | 179778 | 2020-05-26 | Chippewa | Minnesota | 27023 | 42 | 1 |
179811 | 179811 | 2020-05-26 | Meeker | Minnesota | 27093 | 42 | 0 |
176734 | 176734 | 2020-05-25 | Chippewa | Minnesota | 27023 | 42 | 0 |
176767 | 176767 | 2020-05-25 | Meeker | Minnesota | 27093 | 42 | 0 |
173696 | 173696 | 2020-05-24 | Crow Wing | Minnesota | 27035 | 42 | 1 |
173724 | 173724 | 2020-05-24 | Meeker | Minnesota | 27093 | 42 | 0 |
170654 | 170654 | 2020-05-23 | Crow Wing | Minnesota | 27035 | 42 | 1 |
167617 | 167617 | 2020-05-22 | Crow Wing | Minnesota | 27035 | 42 | 1 |
164644 | 164644 | 2020-05-21 | Watonwan | Minnesota | 27165 | 42 | 0 |
161615 | 161615 | 2020-05-20 | Watonwan | Minnesota | 27165 | 42 | 0 |
146490 | 146490 | 2020-05-15 | Itasca | Minnesota | 27061 | 42 | 4 |
140539 | 140539 | 2020-05-13 | Todd | Minnesota | 27153 | 42 | 0 |
137545 | 137545 | 2020-05-12 | Todd | Minnesota | 27153 | 42 | 0 |
128548 | 128548 | 2020-05-09 | Mower | Minnesota | 27099 | 42 | 0 |
119575 | 119575 | 2020-05-06 | Cottonwood | Minnesota | 27033 | 42 | 0 |
116655 | 116655 | 2020-05-05 | Polk | Minnesota | 27119 | 42 | 0 |
113774 | 113774 | 2020-05-04 | Polk | Minnesota | 27119 | 42 | 0 |
102323 | 102323 | 2020-04-30 | Wright | Minnesota | 27171 | 42 | 1 |
88113 | 88113 | 2020-04-25 | Martin | Minnesota | 27091 | 42 | 4 |
57654 | 57654 | 2020-04-14 | Clay | Minnesota | 27027 | 42 | 0 |
57699 | 57699 | 2020-04-14 | St. Louis | Minnesota | 27137 | 42 | 5 |
39211 | 39211 | 2020-04-07 | Anoka | Minnesota | 27003 | 42 | 0 |
16665 | 16665 | 2020-03-28 | Ramsey | Minnesota | 27123 | 42 | 2 |
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);