ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where cases = 27 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Emmet 28
- Cheboygan 14
- Gladwin 12
- Presque Isle 10
- Clare 9
- Alcona 7
- Arenac 7
- Delta 6
- Mackinac 6
- Houghton 5
- Antrim 4
- St. Joseph 4
- Iron 3
- Lake 3
- Manistee 3
- Osceola 3
- Schoolcraft 3
- Cass 2
- Chippewa 2
- Dickinson 2
- Grand Traverse 2
- Gratiot 2
- Leelanau 2
- Marquette 2
- Mason 2
- Mecosta 2
- Montmorency 2
- Alger 1
- Baraga 1
- Benzie 1
- …
state 1
- Michigan · 158 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
671880 | 671880 | 2020-10-27 | Montmorency | Michigan | 26119 | 27 | 0 |
668638 | 668638 | 2020-10-26 | Montmorency | Michigan | 26119 | 27 | 0 |
600456 | 600456 | 2020-10-05 | Alger | Michigan | 26003 | 27 | 0 |
600525 | 600525 | 2020-10-05 | Presque Isle | Michigan | 26141 | 27 | 1 |
597282 | 597282 | 2020-10-04 | Presque Isle | Michigan | 26141 | 27 | 1 |
594041 | 594041 | 2020-10-03 | Presque Isle | Michigan | 26141 | 27 | 1 |
590800 | 590800 | 2020-10-02 | Presque Isle | Michigan | 26141 | 27 | 1 |
587559 | 587559 | 2020-10-01 | Presque Isle | Michigan | 26141 | 27 | 1 |
584319 | 584319 | 2020-09-30 | Presque Isle | Michigan | 26141 | 27 | 1 |
581078 | 581078 | 2020-09-29 | Presque Isle | Michigan | 26141 | 27 | 1 |
577837 | 577837 | 2020-09-28 | Presque Isle | Michigan | 26141 | 27 | 1 |
577841 | 577841 | 2020-09-28 | Schoolcraft | Michigan | 26153 | 27 | 0 |
574596 | 574596 | 2020-09-27 | Presque Isle | Michigan | 26141 | 27 | 1 |
574600 | 574600 | 2020-09-27 | Schoolcraft | Michigan | 26153 | 27 | 0 |
571353 | 571353 | 2020-09-26 | Presque Isle | Michigan | 26141 | 27 | 1 |
571357 | 571357 | 2020-09-26 | Schoolcraft | Michigan | 26153 | 27 | 0 |
568047 | 568047 | 2020-09-25 | Baraga | Michigan | 26013 | 27 | 0 |
477481 | 477481 | 2020-08-28 | Iron | Michigan | 26071 | 27 | 1 |
474248 | 474248 | 2020-08-27 | Iron | Michigan | 26071 | 27 | 1 |
471016 | 471016 | 2020-08-26 | Iron | Michigan | 26071 | 27 | 1 |
441976 | 441976 | 2020-08-17 | Mackinac | Michigan | 26097 | 27 | 0 |
441995 | 441995 | 2020-08-17 | Oscoda | Michigan | 26135 | 27 | 1 |
438743 | 438743 | 2020-08-16 | Lake | Michigan | 26085 | 27 | 0 |
438749 | 438749 | 2020-08-16 | Mackinac | Michigan | 26097 | 27 | 0 |
435524 | 435524 | 2020-08-15 | Mackinac | Michigan | 26097 | 27 | 0 |
432298 | 432298 | 2020-08-14 | Mackinac | Michigan | 26097 | 27 | 0 |
429065 | 429065 | 2020-08-13 | Lake | Michigan | 26085 | 27 | 0 |
425841 | 425841 | 2020-08-12 | Lake | Michigan | 26085 | 27 | 0 |
416182 | 416182 | 2020-08-09 | Mackinac | Michigan | 26097 | 27 | 0 |
412962 | 412962 | 2020-08-08 | Mackinac | Michigan | 26097 | 27 | 0 |
387184 | 387184 | 2020-07-31 | Benzie | Michigan | 26019 | 27 | 1 |
377523 | 377523 | 2020-07-28 | Alcona | Michigan | 26001 | 27 | 1 |
374308 | 374308 | 2020-07-27 | Alcona | Michigan | 26001 | 27 | 1 |
371112 | 371112 | 2020-07-26 | Chippewa | Michigan | 26033 | 27 | 0 |
367886 | 367886 | 2020-07-25 | Alcona | Michigan | 26001 | 27 | 1 |
367902 | 367902 | 2020-07-25 | Chippewa | Michigan | 26033 | 27 | 0 |
364679 | 364679 | 2020-07-24 | Alcona | Michigan | 26001 | 27 | 1 |
361472 | 361472 | 2020-07-23 | Alcona | Michigan | 26001 | 27 | 1 |
358267 | 358267 | 2020-07-22 | Alcona | Michigan | 26001 | 27 | 1 |
355064 | 355064 | 2020-07-21 | Alcona | Michigan | 26001 | 27 | 1 |
342282 | 342282 | 2020-07-17 | Dickinson | Michigan | 26043 | 27 | 2 |
339069 | 339069 | 2020-07-16 | Antrim | Michigan | 26009 | 27 | 0 |
339086 | 339086 | 2020-07-16 | Dickinson | Michigan | 26043 | 27 | 2 |
335873 | 335873 | 2020-07-15 | Antrim | Michigan | 26009 | 27 | 0 |
332680 | 332680 | 2020-07-14 | Antrim | Michigan | 26009 | 27 | 0 |
329493 | 329493 | 2020-07-13 | Antrim | Michigan | 26009 | 27 | 0 |
329504 | 329504 | 2020-07-13 | Cheboygan | Michigan | 26031 | 27 | 2 |
329519 | 329519 | 2020-07-13 | Houghton | Michigan | 26061 | 27 | 0 |
326328 | 326328 | 2020-07-12 | Gladwin | Michigan | 26051 | 27 | 1 |
326333 | 326333 | 2020-07-12 | Houghton | Michigan | 26061 | 27 | 0 |
323145 | 323145 | 2020-07-11 | Gladwin | Michigan | 26051 | 27 | 1 |
323150 | 323150 | 2020-07-11 | Houghton | Michigan | 26061 | 27 | 0 |
319956 | 319956 | 2020-07-10 | Cheboygan | Michigan | 26031 | 27 | 2 |
319966 | 319966 | 2020-07-10 | Gladwin | Michigan | 26051 | 27 | 1 |
319971 | 319971 | 2020-07-10 | Houghton | Michigan | 26061 | 27 | 0 |
316781 | 316781 | 2020-07-09 | Cheboygan | Michigan | 26031 | 27 | 2 |
316791 | 316791 | 2020-07-09 | Gladwin | Michigan | 26051 | 27 | 1 |
316796 | 316796 | 2020-07-09 | Houghton | Michigan | 26061 | 27 | 0 |
313607 | 313607 | 2020-07-08 | Cheboygan | Michigan | 26031 | 27 | 2 |
313612 | 313612 | 2020-07-08 | Delta | Michigan | 26041 | 27 | 3 |
310442 | 310442 | 2020-07-07 | Delta | Michigan | 26041 | 27 | 3 |
310447 | 310447 | 2020-07-07 | Gladwin | Michigan | 26051 | 27 | 1 |
310466 | 310466 | 2020-07-07 | Leelanau | Michigan | 26089 | 27 | 0 |
307274 | 307274 | 2020-07-06 | Delta | Michigan | 26041 | 27 | 3 |
307279 | 307279 | 2020-07-06 | Gladwin | Michigan | 26051 | 27 | 1 |
307298 | 307298 | 2020-07-06 | Leelanau | Michigan | 26089 | 27 | 0 |
304102 | 304102 | 2020-07-05 | Cheboygan | Michigan | 26031 | 27 | 2 |
304107 | 304107 | 2020-07-05 | Delta | Michigan | 26041 | 27 | 3 |
304112 | 304112 | 2020-07-05 | Gladwin | Michigan | 26051 | 27 | 1 |
300938 | 300938 | 2020-07-04 | Cheboygan | Michigan | 26031 | 27 | 2 |
300943 | 300943 | 2020-07-04 | Delta | Michigan | 26041 | 27 | 3 |
300948 | 300948 | 2020-07-04 | Gladwin | Michigan | 26051 | 27 | 1 |
297776 | 297776 | 2020-07-03 | Cheboygan | Michigan | 26031 | 27 | 2 |
297781 | 297781 | 2020-07-03 | Delta | Michigan | 26041 | 27 | 3 |
297786 | 297786 | 2020-07-03 | Gladwin | Michigan | 26051 | 27 | 1 |
294618 | 294618 | 2020-07-02 | Cheboygan | Michigan | 26031 | 27 | 2 |
294628 | 294628 | 2020-07-02 | Gladwin | Michigan | 26051 | 27 | 1 |
291464 | 291464 | 2020-07-01 | Cheboygan | Michigan | 26031 | 27 | 2 |
291474 | 291474 | 2020-07-01 | Gladwin | Michigan | 26051 | 27 | 1 |
288313 | 288313 | 2020-06-30 | Cheboygan | Michigan | 26031 | 27 | 2 |
288321 | 288321 | 2020-06-30 | Emmet | Michigan | 26047 | 27 | 2 |
288323 | 288323 | 2020-06-30 | Gladwin | Michigan | 26051 | 27 | 1 |
285163 | 285163 | 2020-06-29 | Cheboygan | Michigan | 26031 | 27 | 2 |
285165 | 285165 | 2020-06-29 | Clare | Michigan | 26035 | 27 | 3 |
285171 | 285171 | 2020-06-29 | Emmet | Michigan | 26047 | 27 | 2 |
282018 | 282018 | 2020-06-28 | Cheboygan | Michigan | 26031 | 27 | 2 |
282020 | 282020 | 2020-06-28 | Clare | Michigan | 26035 | 27 | 3 |
282026 | 282026 | 2020-06-28 | Emmet | Michigan | 26047 | 27 | 2 |
282068 | 282068 | 2020-06-28 | Osceola | Michigan | 26133 | 27 | 0 |
278872 | 278872 | 2020-06-27 | Clare | Michigan | 26035 | 27 | 3 |
278878 | 278878 | 2020-06-27 | Emmet | Michigan | 26047 | 27 | 2 |
275722 | 275722 | 2020-06-26 | Cheboygan | Michigan | 26031 | 27 | 2 |
275724 | 275724 | 2020-06-26 | Clare | Michigan | 26035 | 27 | 3 |
275730 | 275730 | 2020-06-26 | Emmet | Michigan | 26047 | 27 | 2 |
272579 | 272579 | 2020-06-25 | Cheboygan | Michigan | 26031 | 27 | 2 |
272581 | 272581 | 2020-06-25 | Clare | Michigan | 26035 | 27 | 3 |
272587 | 272587 | 2020-06-25 | Emmet | Michigan | 26047 | 27 | 2 |
269444 | 269444 | 2020-06-24 | Clare | Michigan | 26035 | 27 | 2 |
266311 | 266311 | 2020-06-23 | Clare | Michigan | 26035 | 27 | 2 |
266317 | 266317 | 2020-06-23 | Emmet | Michigan | 26047 | 27 | 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);