ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where cases = 17 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
- Fillmore 22
- Brown 6
- Norman 6
- Big Stone 5
- Crow Wing 5
- Goodhue 5
- Kittson 4
- Mahnomen 4
- Pennington 4
- Wabasha 4
- Clearwater 3
- Douglas 3
- Koochiching 3
- Mille Lacs 3
- Mower 3
- Aitkin 2
- Carver 2
- Cook 2
- Dodge 2
- Grant 2
- Kanabec 2
- Lake 2
- Lyon 2
- Marshall 2
- Meeker 2
- Murray 2
- Otter Tail 2
- Redwood 2
- Roseau 2
- Sibley 2
- …
state 1
- Minnesota · 135 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
671920 | 671920 | 2020-10-27 | Cook | Minnesota | 27031 | 17 | 0 |
668678 | 668678 | 2020-10-26 | Cook | Minnesota | 27031 | 17 | 0 |
626510 | 626510 | 2020-10-13 | Kittson | Minnesota | 27069 | 17 | 0 |
623268 | 623268 | 2020-10-12 | Kittson | Minnesota | 27069 | 17 | 0 |
620025 | 620025 | 2020-10-11 | Kittson | Minnesota | 27069 | 17 | 0 |
616783 | 616783 | 2020-10-10 | Kittson | Minnesota | 27069 | 17 | 0 |
490500 | 490500 | 2020-09-01 | Lac qui Parle | Minnesota | 27073 | 17 | 0 |
464620 | 464620 | 2020-08-24 | Clearwater | Minnesota | 27029 | 17 | 0 |
461389 | 461389 | 2020-08-23 | Clearwater | Minnesota | 27029 | 17 | 0 |
458162 | 458162 | 2020-08-22 | Clearwater | Minnesota | 27029 | 17 | 0 |
448541 | 448541 | 2020-08-19 | Traverse | Minnesota | 27155 | 17 | 0 |
445315 | 445315 | 2020-08-18 | Traverse | Minnesota | 27155 | 17 | 0 |
409852 | 409852 | 2020-08-07 | Stevens | Minnesota | 27149 | 17 | 0 |
406632 | 406632 | 2020-08-06 | Stevens | Minnesota | 27149 | 17 | 0 |
393730 | 393730 | 2020-08-02 | Lake | Minnesota | 27075 | 17 | 0 |
390513 | 390513 | 2020-08-01 | Lake | Minnesota | 27075 | 17 | 0 |
390538 | 390538 | 2020-08-01 | Red Lake | Minnesota | 27125 | 17 | 0 |
368012 | 368012 | 2020-07-25 | Mahnomen | Minnesota | 27087 | 17 | 1 |
364804 | 364804 | 2020-07-24 | Mahnomen | Minnesota | 27087 | 17 | 1 |
361597 | 361597 | 2020-07-23 | Mahnomen | Minnesota | 27087 | 17 | 1 |
348787 | 348787 | 2020-07-19 | Mahnomen | Minnesota | 27087 | 17 | 1 |
339191 | 339191 | 2020-07-16 | Marshall | Minnesota | 27089 | 17 | 0 |
335953 | 335953 | 2020-07-15 | Aitkin | Minnesota | 27001 | 17 | 0 |
335995 | 335995 | 2020-07-15 | Marshall | Minnesota | 27089 | 17 | 0 |
332760 | 332760 | 2020-07-14 | Aitkin | Minnesota | 27001 | 17 | 0 |
326392 | 326392 | 2020-07-12 | Big Stone | Minnesota | 27011 | 17 | 0 |
326419 | 326419 | 2020-07-12 | Kanabec | Minnesota | 27065 | 17 | 1 |
326466 | 326466 | 2020-07-12 | Wadena | Minnesota | 27159 | 17 | 0 |
323209 | 323209 | 2020-07-11 | Big Stone | Minnesota | 27011 | 17 | 0 |
323236 | 323236 | 2020-07-11 | Kanabec | Minnesota | 27065 | 17 | 1 |
323243 | 323243 | 2020-07-11 | Lincoln | Minnesota | 27081 | 17 | 0 |
323283 | 323283 | 2020-07-11 | Wadena | Minnesota | 27159 | 17 | 0 |
320030 | 320030 | 2020-07-10 | Big Stone | Minnesota | 27011 | 17 | 0 |
320060 | 320060 | 2020-07-10 | Koochiching | Minnesota | 27071 | 17 | 1 |
316855 | 316855 | 2020-07-09 | Big Stone | Minnesota | 27011 | 17 | 0 |
316885 | 316885 | 2020-07-09 | Koochiching | Minnesota | 27071 | 17 | 1 |
313681 | 313681 | 2020-07-08 | Big Stone | Minnesota | 27011 | 17 | 0 |
313701 | 313701 | 2020-07-08 | Grant | Minnesota | 27051 | 17 | 0 |
313711 | 313711 | 2020-07-08 | Koochiching | Minnesota | 27071 | 17 | 1 |
313742 | 313742 | 2020-07-08 | Roseau | Minnesota | 27135 | 17 | 0 |
310531 | 310531 | 2020-07-07 | Grant | Minnesota | 27051 | 17 | 0 |
310572 | 310572 | 2020-07-07 | Roseau | Minnesota | 27135 | 17 | 0 |
294748 | 294748 | 2020-07-02 | Redwood | Minnesota | 27127 | 17 | 0 |
291594 | 291594 | 2020-07-01 | Redwood | Minnesota | 27127 | 17 | 0 |
275817 | 275817 | 2020-06-26 | Houston | Minnesota | 27055 | 17 | 0 |
244588 | 244588 | 2020-06-16 | Norman | Minnesota | 27107 | 17 | 0 |
241477 | 241477 | 2020-06-15 | Norman | Minnesota | 27107 | 17 | 0 |
238368 | 238368 | 2020-06-14 | Norman | Minnesota | 27107 | 17 | 0 |
235261 | 235261 | 2020-06-13 | Norman | Minnesota | 27107 | 17 | 0 |
232155 | 232155 | 2020-06-12 | Norman | Minnesota | 27107 | 17 | 0 |
229051 | 229051 | 2020-06-11 | Norman | Minnesota | 27107 | 17 | 0 |
225905 | 225905 | 2020-06-10 | Brown | Minnesota | 27015 | 17 | 2 |
222807 | 222807 | 2020-06-09 | Brown | Minnesota | 27015 | 17 | 2 |
219712 | 219712 | 2020-06-08 | Brown | Minnesota | 27015 | 17 | 2 |
213532 | 213532 | 2020-06-06 | Brown | Minnesota | 27015 | 17 | 2 |
213593 | 213593 | 2020-06-06 | Sibley | Minnesota | 27143 | 17 | 0 |
210448 | 210448 | 2020-06-05 | Brown | Minnesota | 27015 | 17 | 2 |
210462 | 210462 | 2020-06-05 | Fillmore | Minnesota | 27045 | 17 | 1 |
210509 | 210509 | 2020-06-05 | Sibley | Minnesota | 27143 | 17 | 0 |
207381 | 207381 | 2020-06-04 | Fillmore | Minnesota | 27045 | 17 | 1 |
204286 | 204286 | 2020-06-03 | Brown | Minnesota | 27015 | 17 | 2 |
204300 | 204300 | 2020-06-03 | Fillmore | Minnesota | 27045 | 17 | 1 |
201223 | 201223 | 2020-06-02 | Fillmore | Minnesota | 27045 | 17 | 1 |
198150 | 198150 | 2020-06-01 | Fillmore | Minnesota | 27045 | 17 | 1 |
195079 | 195079 | 2020-05-31 | Fillmore | Minnesota | 27045 | 17 | 1 |
192011 | 192011 | 2020-05-30 | Fillmore | Minnesota | 27045 | 17 | 1 |
192044 | 192044 | 2020-05-30 | Pennington | Minnesota | 27113 | 17 | 0 |
188947 | 188947 | 2020-05-29 | Fillmore | Minnesota | 27045 | 17 | 1 |
188980 | 188980 | 2020-05-29 | Pennington | Minnesota | 27113 | 17 | 0 |
189003 | 189003 | 2020-05-29 | Wabasha | Minnesota | 27157 | 17 | 0 |
185889 | 185889 | 2020-05-28 | Fillmore | Minnesota | 27045 | 17 | 1 |
185922 | 185922 | 2020-05-28 | Pennington | Minnesota | 27113 | 17 | 0 |
185941 | 185941 | 2020-05-28 | Swift | Minnesota | 27151 | 17 | 0 |
185945 | 185945 | 2020-05-28 | Wabasha | Minnesota | 27157 | 17 | 0 |
182834 | 182834 | 2020-05-27 | Fillmore | Minnesota | 27045 | 17 | 1 |
182858 | 182858 | 2020-05-27 | Mille Lacs | Minnesota | 27095 | 17 | 1 |
182867 | 182867 | 2020-05-27 | Pennington | Minnesota | 27113 | 17 | 0 |
182885 | 182885 | 2020-05-27 | Swift | Minnesota | 27151 | 17 | 0 |
182889 | 182889 | 2020-05-27 | Wabasha | Minnesota | 27157 | 17 | 0 |
179788 | 179788 | 2020-05-26 | Fillmore | Minnesota | 27045 | 17 | 1 |
179812 | 179812 | 2020-05-26 | Mille Lacs | Minnesota | 27095 | 17 | 1 |
179843 | 179843 | 2020-05-26 | Wabasha | Minnesota | 27157 | 17 | 0 |
176744 | 176744 | 2020-05-25 | Fillmore | Minnesota | 27045 | 17 | 1 |
176768 | 176768 | 2020-05-25 | Mille Lacs | Minnesota | 27095 | 17 | 1 |
173701 | 173701 | 2020-05-24 | Fillmore | Minnesota | 27045 | 17 | 1 |
170659 | 170659 | 2020-05-23 | Fillmore | Minnesota | 27045 | 17 | 1 |
167622 | 167622 | 2020-05-22 | Fillmore | Minnesota | 27045 | 17 | 1 |
164586 | 164586 | 2020-05-21 | Fillmore | Minnesota | 27045 | 17 | 1 |
161557 | 161557 | 2020-05-20 | Fillmore | Minnesota | 27045 | 17 | 1 |
158531 | 158531 | 2020-05-19 | Fillmore | Minnesota | 27045 | 17 | 1 |
155513 | 155513 | 2020-05-18 | Fillmore | Minnesota | 27045 | 17 | 1 |
152499 | 152499 | 2020-05-17 | Fillmore | Minnesota | 27045 | 17 | 1 |
149488 | 149488 | 2020-05-16 | Fillmore | Minnesota | 27045 | 17 | 1 |
149494 | 149494 | 2020-05-16 | Isanti | Minnesota | 27059 | 17 | 0 |
146483 | 146483 | 2020-05-15 | Fillmore | Minnesota | 27045 | 17 | 1 |
143481 | 143481 | 2020-05-14 | Douglas | Minnesota | 27041 | 17 | 0 |
140486 | 140486 | 2020-05-13 | Douglas | Minnesota | 27041 | 17 | 0 |
137492 | 137492 | 2020-05-12 | Douglas | Minnesota | 27041 | 17 | 0 |
131530 | 131530 | 2020-05-10 | Lyon | Minnesota | 27083 | 17 | 0 |
131566 | 131566 | 2020-05-10 | Unknown | Minnesota | 17 | 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);