ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
552 rows where cases = 2 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Clearwater 48
- Traverse 38
- Houston 29
- Itasca 27
- Kittson 27
- Big Stone 23
- Lincoln 23
- Kandiyohi 20
- Grant 18
- Cook 17
- Becker 14
- Lac qui Parle 14
- Pipestone 14
- Douglas 13
- Mahnomen 10
- Sibley 10
- Swift 10
- McLeod 9
- Renville 9
- Aitkin 8
- Chippewa 8
- Todd 8
- Waseca 8
- Chisago 7
- Red Lake 7
- Meeker 6
- Mille Lacs 6
- Wilkin 6
- Isanti 5
- Rice 5
- …
state 1
- Minnesota · 552 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
416256 | 416256 | 2020-08-09 | Lake of the Woods | Minnesota | 27077 | 2 | 0 |
413036 | 413036 | 2020-08-08 | Lake of the Woods | Minnesota | 27077 | 2 | 0 |
409816 | 409816 | 2020-08-07 | Lake of the Woods | Minnesota | 27077 | 2 | 0 |
406573 | 406573 | 2020-08-06 | Cook | Minnesota | 27031 | 2 | 0 |
403355 | 403355 | 2020-08-05 | Cook | Minnesota | 27031 | 2 | 0 |
400138 | 400138 | 2020-08-04 | Cook | Minnesota | 27031 | 2 | 0 |
396924 | 396924 | 2020-08-03 | Cook | Minnesota | 27031 | 2 | 0 |
393708 | 393708 | 2020-08-02 | Cook | Minnesota | 27031 | 2 | 0 |
390491 | 390491 | 2020-08-01 | Cook | Minnesota | 27031 | 2 | 0 |
387274 | 387274 | 2020-07-31 | Cook | Minnesota | 27031 | 2 | 0 |
384056 | 384056 | 2020-07-30 | Cook | Minnesota | 27031 | 2 | 0 |
380839 | 380839 | 2020-07-29 | Cook | Minnesota | 27031 | 2 | 0 |
377622 | 377622 | 2020-07-28 | Cook | Minnesota | 27031 | 2 | 0 |
374407 | 374407 | 2020-07-27 | Cook | Minnesota | 27031 | 2 | 0 |
371195 | 371195 | 2020-07-26 | Cook | Minnesota | 27031 | 2 | 0 |
367985 | 367985 | 2020-07-25 | Cook | Minnesota | 27031 | 2 | 0 |
364778 | 364778 | 2020-07-24 | Cook | Minnesota | 27031 | 2 | 0 |
361571 | 361571 | 2020-07-23 | Cook | Minnesota | 27031 | 2 | 0 |
358366 | 358366 | 2020-07-22 | Cook | Minnesota | 27031 | 2 | 0 |
358385 | 358385 | 2020-07-22 | Kittson | Minnesota | 27069 | 2 | 0 |
355163 | 355163 | 2020-07-21 | Cook | Minnesota | 27031 | 2 | 0 |
355182 | 355182 | 2020-07-21 | Kittson | Minnesota | 27069 | 2 | 0 |
351980 | 351980 | 2020-07-20 | Kittson | Minnesota | 27069 | 2 | 0 |
348780 | 348780 | 2020-07-19 | Kittson | Minnesota | 27069 | 2 | 0 |
345579 | 345579 | 2020-07-18 | Kittson | Minnesota | 27069 | 2 | 0 |
342379 | 342379 | 2020-07-17 | Kittson | Minnesota | 27069 | 2 | 0 |
339183 | 339183 | 2020-07-16 | Kittson | Minnesota | 27069 | 2 | 0 |
335987 | 335987 | 2020-07-15 | Kittson | Minnesota | 27069 | 2 | 0 |
332794 | 332794 | 2020-07-14 | Kittson | Minnesota | 27069 | 2 | 0 |
329607 | 329607 | 2020-07-13 | Kittson | Minnesota | 27069 | 2 | 0 |
326421 | 326421 | 2020-07-12 | Kittson | Minnesota | 27069 | 2 | 0 |
323238 | 323238 | 2020-07-11 | Kittson | Minnesota | 27069 | 2 | 0 |
320059 | 320059 | 2020-07-10 | Kittson | Minnesota | 27069 | 2 | 0 |
316884 | 316884 | 2020-07-09 | Kittson | Minnesota | 27069 | 2 | 0 |
313710 | 313710 | 2020-07-08 | Kittson | Minnesota | 27069 | 2 | 0 |
310540 | 310540 | 2020-07-07 | Kittson | Minnesota | 27069 | 2 | 0 |
307372 | 307372 | 2020-07-06 | Kittson | Minnesota | 27069 | 2 | 0 |
304205 | 304205 | 2020-07-05 | Kittson | Minnesota | 27069 | 2 | 0 |
301041 | 301041 | 2020-07-04 | Kittson | Minnesota | 27069 | 2 | 0 |
297878 | 297878 | 2020-07-03 | Kittson | Minnesota | 27069 | 2 | 0 |
294720 | 294720 | 2020-07-02 | Kittson | Minnesota | 27069 | 2 | 0 |
291566 | 291566 | 2020-07-01 | Kittson | Minnesota | 27069 | 2 | 0 |
288415 | 288415 | 2020-06-30 | Kittson | Minnesota | 27069 | 2 | 0 |
285265 | 285265 | 2020-06-29 | Kittson | Minnesota | 27069 | 2 | 0 |
282120 | 282120 | 2020-06-28 | Kittson | Minnesota | 27069 | 2 | 0 |
278972 | 278972 | 2020-06-27 | Kittson | Minnesota | 27069 | 2 | 0 |
275824 | 275824 | 2020-06-26 | Kittson | Minnesota | 27069 | 2 | 0 |
263324 | 263324 | 2020-06-22 | Stevens | Minnesota | 27149 | 2 | 0 |
260195 | 260195 | 2020-06-21 | Stevens | Minnesota | 27149 | 2 | 0 |
257069 | 257069 | 2020-06-20 | Stevens | Minnesota | 27149 | 2 | 0 |
253949 | 253949 | 2020-06-19 | Stevens | Minnesota | 27149 | 2 | 0 |
244573 | 244573 | 2020-06-16 | Lake | Minnesota | 27075 | 2 | 0 |
207386 | 207386 | 2020-06-04 | Houston | Minnesota | 27055 | 2 | 0 |
204305 | 204305 | 2020-06-03 | Houston | Minnesota | 27055 | 2 | 0 |
201228 | 201228 | 2020-06-02 | Houston | Minnesota | 27055 | 2 | 0 |
201267 | 201267 | 2020-06-02 | Roseau | Minnesota | 27135 | 2 | 0 |
198155 | 198155 | 2020-06-01 | Houston | Minnesota | 27055 | 2 | 0 |
198156 | 198156 | 2020-06-01 | Hubbard | Minnesota | 27057 | 2 | 0 |
198194 | 198194 | 2020-06-01 | Roseau | Minnesota | 27135 | 2 | 0 |
195084 | 195084 | 2020-05-31 | Houston | Minnesota | 27055 | 2 | 0 |
195085 | 195085 | 2020-05-31 | Hubbard | Minnesota | 27057 | 2 | 0 |
195123 | 195123 | 2020-05-31 | Roseau | Minnesota | 27135 | 2 | 0 |
192016 | 192016 | 2020-05-30 | Houston | Minnesota | 27055 | 2 | 0 |
188952 | 188952 | 2020-05-29 | Houston | Minnesota | 27055 | 2 | 0 |
188953 | 188953 | 2020-05-29 | Hubbard | Minnesota | 27057 | 2 | 0 |
188991 | 188991 | 2020-05-29 | Roseau | Minnesota | 27135 | 2 | 0 |
188998 | 188998 | 2020-05-29 | Stevens | Minnesota | 27149 | 2 | 0 |
185894 | 185894 | 2020-05-28 | Houston | Minnesota | 27055 | 2 | 0 |
185933 | 185933 | 2020-05-28 | Roseau | Minnesota | 27135 | 2 | 0 |
182839 | 182839 | 2020-05-27 | Houston | Minnesota | 27055 | 2 | 0 |
179793 | 179793 | 2020-05-26 | Houston | Minnesota | 27055 | 2 | 0 |
176747 | 176747 | 2020-05-25 | Grant | Minnesota | 27051 | 2 | 0 |
176749 | 176749 | 2020-05-25 | Houston | Minnesota | 27055 | 2 | 0 |
173694 | 173694 | 2020-05-24 | Clearwater | Minnesota | 27029 | 2 | 0 |
173704 | 173704 | 2020-05-24 | Grant | Minnesota | 27051 | 2 | 0 |
173706 | 173706 | 2020-05-24 | Houston | Minnesota | 27055 | 2 | 0 |
170652 | 170652 | 2020-05-23 | Clearwater | Minnesota | 27029 | 2 | 0 |
170662 | 170662 | 2020-05-23 | Grant | Minnesota | 27051 | 2 | 0 |
170664 | 170664 | 2020-05-23 | Houston | Minnesota | 27055 | 2 | 0 |
167615 | 167615 | 2020-05-22 | Clearwater | Minnesota | 27029 | 2 | 0 |
167625 | 167625 | 2020-05-22 | Grant | Minnesota | 27051 | 2 | 0 |
167627 | 167627 | 2020-05-22 | Houston | Minnesota | 27055 | 2 | 0 |
164579 | 164579 | 2020-05-21 | Clearwater | Minnesota | 27029 | 2 | 0 |
164589 | 164589 | 2020-05-21 | Grant | Minnesota | 27051 | 2 | 0 |
164591 | 164591 | 2020-05-21 | Houston | Minnesota | 27055 | 2 | 0 |
161550 | 161550 | 2020-05-20 | Clearwater | Minnesota | 27029 | 2 | 0 |
161560 | 161560 | 2020-05-20 | Grant | Minnesota | 27051 | 2 | 0 |
161562 | 161562 | 2020-05-20 | Houston | Minnesota | 27055 | 2 | 0 |
158524 | 158524 | 2020-05-19 | Clearwater | Minnesota | 27029 | 2 | 0 |
158534 | 158534 | 2020-05-19 | Grant | Minnesota | 27051 | 2 | 0 |
158536 | 158536 | 2020-05-19 | Houston | Minnesota | 27055 | 2 | 0 |
155506 | 155506 | 2020-05-18 | Clearwater | Minnesota | 27029 | 2 | 0 |
155516 | 155516 | 2020-05-18 | Grant | Minnesota | 27051 | 2 | 0 |
155518 | 155518 | 2020-05-18 | Houston | Minnesota | 27055 | 2 | 0 |
155545 | 155545 | 2020-05-18 | Pennington | Minnesota | 27113 | 2 | 0 |
152483 | 152483 | 2020-05-17 | Big Stone | Minnesota | 27011 | 2 | 0 |
152492 | 152492 | 2020-05-17 | Clearwater | Minnesota | 27029 | 2 | 0 |
152502 | 152502 | 2020-05-17 | Grant | Minnesota | 27051 | 2 | 0 |
152504 | 152504 | 2020-05-17 | Houston | Minnesota | 27055 | 2 | 0 |
152512 | 152512 | 2020-05-17 | Lac qui Parle | Minnesota | 27073 | 2 | 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);