ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where cases = 15 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Wadena 14
- Stevens 11
- Clearwater 10
- Aitkin 7
- Pipestone 7
- Norman 4
- Wilkin 4
- Carver 3
- Cass 3
- Kittson 3
- Mille Lacs 3
- Sherburne 3
- Swift 3
- Watonwan 3
- Beltrami 2
- Big Stone 2
- Douglas 2
- Houston 2
- Kanabec 2
- Koochiching 2
- Lac qui Parle 2
- Le Sueur 2
- McLeod 2
- Mower 2
- Nicollet 2
- Todd 2
- Becker 1
- Benton 1
- Blue Earth 1
- Brown 1
- …
state 1
- Minnesota · 120 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
613542 | 613542 | 2020-10-09 | Kittson | Minnesota | 27069 | 15 | 0 |
610300 | 610300 | 2020-10-08 | Kittson | Minnesota | 27069 | 15 | 0 |
607058 | 607058 | 2020-10-07 | Kittson | Minnesota | 27069 | 15 | 0 |
487267 | 487267 | 2020-08-31 | Lac qui Parle | Minnesota | 27073 | 15 | 0 |
484033 | 484033 | 2020-08-30 | Lac qui Parle | Minnesota | 27073 | 15 | 0 |
454934 | 454934 | 2020-08-21 | Clearwater | Minnesota | 27029 | 15 | 0 |
451706 | 451706 | 2020-08-20 | Clearwater | Minnesota | 27029 | 15 | 0 |
448478 | 448478 | 2020-08-19 | Clearwater | Minnesota | 27029 | 15 | 0 |
432411 | 432411 | 2020-08-14 | Traverse | Minnesota | 27155 | 15 | 0 |
406572 | 406572 | 2020-08-06 | Clearwater | Minnesota | 27029 | 15 | 0 |
400137 | 400137 | 2020-08-04 | Clearwater | Minnesota | 27029 | 15 | 0 |
396923 | 396923 | 2020-08-03 | Clearwater | Minnesota | 27029 | 15 | 0 |
396983 | 396983 | 2020-08-03 | Stevens | Minnesota | 27149 | 15 | 0 |
393767 | 393767 | 2020-08-02 | Stevens | Minnesota | 27149 | 15 | 0 |
390550 | 390550 | 2020-08-01 | Stevens | Minnesota | 27149 | 15 | 0 |
387296 | 387296 | 2020-07-31 | Lake | Minnesota | 27075 | 15 | 0 |
387333 | 387333 | 2020-07-31 | Stevens | Minnesota | 27149 | 15 | 0 |
384115 | 384115 | 2020-07-30 | Stevens | Minnesota | 27149 | 15 | 0 |
380898 | 380898 | 2020-07-29 | Stevens | Minnesota | 27149 | 15 | 0 |
377621 | 377621 | 2020-07-28 | Clearwater | Minnesota | 27029 | 15 | 0 |
377681 | 377681 | 2020-07-28 | Stevens | Minnesota | 27149 | 15 | 0 |
374406 | 374406 | 2020-07-27 | Clearwater | Minnesota | 27029 | 15 | 0 |
374466 | 374466 | 2020-07-27 | Stevens | Minnesota | 27149 | 15 | 0 |
371254 | 371254 | 2020-07-26 | Stevens | Minnesota | 27149 | 15 | 0 |
368044 | 368044 | 2020-07-25 | Stevens | Minnesota | 27149 | 15 | 0 |
364836 | 364836 | 2020-07-24 | Stevens | Minnesota | 27149 | 15 | 0 |
342359 | 342359 | 2020-07-17 | Clearwater | Minnesota | 27029 | 15 | 0 |
339190 | 339190 | 2020-07-16 | Mahnomen | Minnesota | 27087 | 15 | 1 |
329587 | 329587 | 2020-07-13 | Clearwater | Minnesota | 27029 | 15 | 0 |
323204 | 323204 | 2020-07-11 | Aitkin | Minnesota | 27001 | 15 | 0 |
320025 | 320025 | 2020-07-10 | Aitkin | Minnesota | 27001 | 15 | 0 |
316850 | 316850 | 2020-07-09 | Aitkin | Minnesota | 27001 | 15 | 0 |
313676 | 313676 | 2020-07-08 | Aitkin | Minnesota | 27001 | 15 | 0 |
313708 | 313708 | 2020-07-08 | Kanabec | Minnesota | 27065 | 15 | 1 |
313755 | 313755 | 2020-07-08 | Wadena | Minnesota | 27159 | 15 | 0 |
310506 | 310506 | 2020-07-07 | Aitkin | Minnesota | 27001 | 15 | 0 |
310511 | 310511 | 2020-07-07 | Big Stone | Minnesota | 27011 | 15 | 0 |
310538 | 310538 | 2020-07-07 | Kanabec | Minnesota | 27065 | 15 | 1 |
310585 | 310585 | 2020-07-07 | Wadena | Minnesota | 27159 | 15 | 0 |
307338 | 307338 | 2020-07-06 | Aitkin | Minnesota | 27001 | 15 | 0 |
307343 | 307343 | 2020-07-06 | Big Stone | Minnesota | 27011 | 15 | 0 |
307373 | 307373 | 2020-07-06 | Koochiching | Minnesota | 27071 | 15 | 1 |
307417 | 307417 | 2020-07-06 | Wadena | Minnesota | 27159 | 15 | 0 |
304171 | 304171 | 2020-07-05 | Aitkin | Minnesota | 27001 | 15 | 0 |
304181 | 304181 | 2020-07-05 | Cass | Minnesota | 27021 | 15 | 2 |
304206 | 304206 | 2020-07-05 | Koochiching | Minnesota | 27071 | 15 | 1 |
304250 | 304250 | 2020-07-05 | Wadena | Minnesota | 27159 | 15 | 0 |
301017 | 301017 | 2020-07-04 | Cass | Minnesota | 27021 | 15 | 2 |
301086 | 301086 | 2020-07-04 | Wadena | Minnesota | 27159 | 15 | 0 |
297854 | 297854 | 2020-07-03 | Cass | Minnesota | 27021 | 15 | 2 |
297923 | 297923 | 2020-07-03 | Wadena | Minnesota | 27159 | 15 | 0 |
294765 | 294765 | 2020-07-02 | Wadena | Minnesota | 27159 | 15 | 0 |
291611 | 291611 | 2020-07-01 | Wadena | Minnesota | 27159 | 15 | 0 |
288460 | 288460 | 2020-06-30 | Wadena | Minnesota | 27159 | 15 | 0 |
285310 | 285310 | 2020-06-29 | Wadena | Minnesota | 27159 | 15 | 0 |
282165 | 282165 | 2020-06-28 | Wadena | Minnesota | 27159 | 15 | 0 |
279017 | 279017 | 2020-06-27 | Wadena | Minnesota | 27159 | 15 | 0 |
275869 | 275869 | 2020-06-26 | Wadena | Minnesota | 27159 | 15 | 0 |
272704 | 272704 | 2020-06-25 | Pipestone | Minnesota | 27117 | 15 | 0 |
272726 | 272726 | 2020-06-25 | Wadena | Minnesota | 27159 | 15 | 0 |
269537 | 269537 | 2020-06-24 | Houston | Minnesota | 27055 | 15 | 0 |
269567 | 269567 | 2020-06-24 | Pipestone | Minnesota | 27117 | 15 | 0 |
266404 | 266404 | 2020-06-23 | Houston | Minnesota | 27055 | 15 | 0 |
266434 | 266434 | 2020-06-23 | Pipestone | Minnesota | 27117 | 15 | 0 |
263308 | 263308 | 2020-06-22 | Pipestone | Minnesota | 27117 | 15 | 0 |
247732 | 247732 | 2020-06-17 | Wilkin | Minnesota | 27167 | 15 | 3 |
244619 | 244619 | 2020-06-16 | Wilkin | Minnesota | 27167 | 15 | 3 |
241508 | 241508 | 2020-06-15 | Wilkin | Minnesota | 27167 | 15 | 3 |
238399 | 238399 | 2020-06-14 | Wilkin | Minnesota | 27167 | 15 | 3 |
235266 | 235266 | 2020-06-13 | Pipestone | Minnesota | 27117 | 15 | 0 |
232160 | 232160 | 2020-06-12 | Pipestone | Minnesota | 27117 | 15 | 0 |
229056 | 229056 | 2020-06-11 | Pipestone | Minnesota | 27117 | 15 | 0 |
216664 | 216664 | 2020-06-07 | Norman | Minnesota | 27107 | 15 | 0 |
213576 | 213576 | 2020-06-06 | Norman | Minnesota | 27107 | 15 | 0 |
210492 | 210492 | 2020-06-05 | Norman | Minnesota | 27107 | 15 | 0 |
207411 | 207411 | 2020-06-04 | Norman | Minnesota | 27107 | 15 | 0 |
198132 | 198132 | 2020-06-01 | Beltrami | Minnesota | 27007 | 15 | 0 |
195061 | 195061 | 2020-05-31 | Beltrami | Minnesota | 27007 | 15 | 0 |
191997 | 191997 | 2020-05-30 | Brown | Minnesota | 27015 | 15 | 2 |
188946 | 188946 | 2020-05-29 | Faribault | Minnesota | 27043 | 15 | 0 |
185936 | 185936 | 2020-05-28 | Sibley | Minnesota | 27143 | 15 | 0 |
173752 | 173752 | 2020-05-24 | Swift | Minnesota | 27151 | 15 | 0 |
170683 | 170683 | 2020-05-23 | Mille Lacs | Minnesota | 27095 | 15 | 1 |
170710 | 170710 | 2020-05-23 | Swift | Minnesota | 27151 | 15 | 0 |
167645 | 167645 | 2020-05-22 | Mille Lacs | Minnesota | 27095 | 15 | 1 |
167672 | 167672 | 2020-05-22 | Swift | Minnesota | 27151 | 15 | 0 |
161580 | 161580 | 2020-05-20 | Mille Lacs | Minnesota | 27095 | 15 | 1 |
146504 | 146504 | 2020-05-15 | McLeod | Minnesota | 27085 | 15 | 0 |
143504 | 143504 | 2020-05-14 | McLeod | Minnesota | 27085 | 15 | 0 |
128521 | 128521 | 2020-05-09 | Douglas | Minnesota | 27041 | 15 | 0 |
125534 | 125534 | 2020-05-08 | Douglas | Minnesota | 27041 | 15 | 0 |
122571 | 122571 | 2020-05-07 | Lyon | Minnesota | 27083 | 15 | 0 |
119638 | 119638 | 2020-05-06 | Watonwan | Minnesota | 27165 | 15 | 0 |
116602 | 116602 | 2020-05-05 | Becker | Minnesota | 27005 | 15 | 0 |
116671 | 116671 | 2020-05-05 | Todd | Minnesota | 27153 | 15 | 0 |
116678 | 116678 | 2020-05-05 | Watonwan | Minnesota | 27165 | 15 | 0 |
113789 | 113789 | 2020-05-04 | Todd | Minnesota | 27153 | 15 | 0 |
113796 | 113796 | 2020-05-04 | Watonwan | Minnesota | 27165 | 15 | 0 |
110882 | 110882 | 2020-05-03 | Meeker | Minnesota | 27093 | 15 | 0 |
110887 | 110887 | 2020-05-03 | Nicollet | Minnesota | 27103 | 15 | 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);