ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65,202 rows where state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 26125 362
- 26163 362
- 26065 360
- 26081 360
- 26117 360
- 26147 360
- 26161 360
- 26089 359
- 26099 359
- 26017 358
- 26029 358
- 26115 358
- 26139 357
- 26075 355
- 26137 355
- 26037 353
- 26045 353
- 26049 353
- 26093 353
- 26111 353
- 26035 351
- 26145 351
- 26157 351
- 26165 351
- 26005 350
- 26015 350
- 26021 350
- 26025 350
- 26047 350
- 26051 350
- …
county >30
- Oakland 362
- Wayne 362
- Ingham 360
- Kent 360
- Montcalm 360
- St. Clair 360
- Washtenaw 360
- Leelanau 359
- Macomb 359
- Bay 358
- Charlevoix 358
- Monroe 358
- Ottawa 357
- Jackson 355
- Otsego 355
- Clinton 353
- Eaton 353
- Genesee 353
- Livingston 353
- Midland 353
- Clare 351
- Saginaw 351
- Tuscola 351
- Wexford 351
- Allegan 350
- Barry 350
- Berrien 350
- Calhoun 350
- Emmet 350
- Gladwin 350
- …
state 1
- Michigan · 28,814 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093711 | 1093711 | 2021-03-06 | Chippewa | Michigan | 26033 | 4891 | 43 |
1093712 | 1093712 | 2021-03-06 | Clare | Michigan | 26035 | 1626 | 69 |
1093713 | 1093713 | 2021-03-06 | Clinton | Michigan | 26037 | 5098 | 71 |
1093714 | 1093714 | 2021-03-06 | Crawford | Michigan | 26039 | 607 | 5 |
1093715 | 1093715 | 2021-03-06 | Delta | Michigan | 26041 | 3157 | 85 |
1093716 | 1093716 | 2021-03-06 | Dickinson | Michigan | 26043 | 2373 | 70 |
1093717 | 1093717 | 2021-03-06 | Eaton | Michigan | 26045 | 6407 | 156 |
1093718 | 1093718 | 2021-03-06 | Emmet | Michigan | 26047 | 1557 | 39 |
1093719 | 1093719 | 2021-03-06 | Genesee | Michigan | 26049 | 26111 | 757 |
1093720 | 1093720 | 2021-03-06 | Gladwin | Michigan | 26051 | 1500 | 43 |
1093721 | 1093721 | 2021-03-06 | Gogebic | Michigan | 26053 | 1289 | 48 |
1093722 | 1093722 | 2021-03-06 | Grand Traverse | Michigan | 26055 | 4368 | 71 |
1093723 | 1093723 | 2021-03-06 | Gratiot | Michigan | 26057 | 5684 | 108 |
1093724 | 1093724 | 2021-03-06 | Hillsdale | Michigan | 26059 | 3392 | 76 |
1093725 | 1093725 | 2021-03-06 | Houghton | Michigan | 26061 | 2686 | 40 |
1093726 | 1093726 | 2021-03-06 | Huron | Michigan | 26063 | 2203 | 59 |
1093727 | 1093727 | 2021-03-06 | Ingham | Michigan | 26065 | 16689 | 282 |
1093728 | 1093728 | 2021-03-06 | Ionia | Michigan | 26067 | 7106 | 76 |
1093729 | 1093729 | 2021-03-06 | Iosco | Michigan | 26069 | 1281 | 67 |
1093730 | 1093730 | 2021-03-06 | Iron | Michigan | 26071 | 929 | 49 |
1093731 | 1093731 | 2021-03-06 | Isabella | Michigan | 26073 | 4062 | 73 |
1093732 | 1093732 | 2021-03-06 | Jackson | Michigan | 26075 | 14361 | 255 |
1093733 | 1093733 | 2021-03-06 | Kalamazoo | Michigan | 26077 | 15274 | 324 |
1093734 | 1093734 | 2021-03-06 | Kalkaska | Michigan | 26079 | 634 | 15 |
1093735 | 1093735 | 2021-03-06 | Kent | Michigan | 26081 | 52310 | 717 |
1093736 | 1093736 | 2021-03-06 | Keweenaw | Michigan | 26083 | 145 | 2 |
1093737 | 1093737 | 2021-03-06 | Lake | Michigan | 26085 | 368 | 11 |
1093738 | 1093738 | 2021-03-06 | Lapeer | Michigan | 26087 | 5704 | 131 |
1093739 | 1093739 | 2021-03-06 | Leelanau | Michigan | 26089 | 890 | 15 |
1093740 | 1093740 | 2021-03-06 | Lenawee | Michigan | 26091 | 7878 | 129 |
1093741 | 1093741 | 2021-03-06 | Livingston | Michigan | 26093 | 10586 | 149 |
1093742 | 1093742 | 2021-03-06 | Luce | Michigan | 26095 | 1087 | 2 |
1093743 | 1093743 | 2021-03-06 | Mackinac | Michigan | 26097 | 448 | 3 |
1093744 | 1093744 | 2021-03-06 | Macomb | Michigan | 26099 | 60588 | 1984 |
1093745 | 1093745 | 2021-03-06 | Manistee | Michigan | 26101 | 1535 | 23 |
1093746 | 1093746 | 2021-03-06 | Marquette | Michigan | 26103 | 4830 | 57 |
1093747 | 1093747 | 2021-03-06 | Mason | Michigan | 26105 | 1250 | 26 |
1093748 | 1093748 | 2021-03-06 | Mecosta | Michigan | 26107 | 2043 | 20 |
1093749 | 1093749 | 2021-03-06 | Menominee | Michigan | 26109 | 1882 | 38 |
1093750 | 1093750 | 2021-03-06 | Midland | Michigan | 26111 | 5088 | 66 |
1093751 | 1093751 | 2021-03-06 | Missaukee | Michigan | 26113 | 813 | 18 |
1093752 | 1093752 | 2021-03-06 | Monroe | Michigan | 26115 | 10008 | 204 |
1093753 | 1093753 | 2021-03-06 | Montcalm | Michigan | 26117 | 5671 | 94 |
1093754 | 1093754 | 2021-03-06 | Montmorency | Michigan | 26119 | 370 | 17 |
1093755 | 1093755 | 2021-03-06 | Muskegon | Michigan | 26121 | 12730 | 317 |
1093756 | 1093756 | 2021-03-06 | Newaygo | Michigan | 26123 | 2929 | 52 |
1093757 | 1093757 | 2021-03-06 | Oakland | Michigan | 26125 | 75863 | 2019 |
1093758 | 1093758 | 2021-03-06 | Oceana | Michigan | 26127 | 1889 | 50 |
1093759 | 1093759 | 2021-03-06 | Ogemaw | Michigan | 26129 | 1116 | 34 |
1093760 | 1093760 | 2021-03-06 | Ontonagon | Michigan | 26131 | 413 | 20 |
1093761 | 1093761 | 2021-03-06 | Osceola | Michigan | 26133 | 1070 | 23 |
1093762 | 1093762 | 2021-03-06 | Oscoda | Michigan | 26135 | 401 | 19 |
1093763 | 1093763 | 2021-03-06 | Otsego | Michigan | 26137 | 1196 | 27 |
1093764 | 1093764 | 2021-03-06 | Ottawa | Michigan | 26139 | 22595 | 357 |
1093765 | 1093765 | 2021-03-06 | Presque Isle | Michigan | 26141 | 667 | 28 |
1093766 | 1093766 | 2021-03-06 | Roscommon | Michigan | 26143 | 1188 | 33 |
1093767 | 1093767 | 2021-03-06 | Saginaw | Michigan | 26145 | 16159 | 527 |
1093768 | 1093768 | 2021-03-06 | Sanilac | Michigan | 26151 | 2155 | 77 |
1093769 | 1093769 | 2021-03-06 | Schoolcraft | Michigan | 26153 | 260 | 5 |
1093770 | 1093770 | 2021-03-06 | Shiawassee | Michigan | 26155 | 3894 | 81 |
1093771 | 1093771 | 2021-03-06 | St. Clair | Michigan | 26147 | 8879 | 261 |
1093772 | 1093772 | 2021-03-06 | St. Joseph | Michigan | 26149 | 4788 | 85 |
1093773 | 1093773 | 2021-03-06 | Tuscola | Michigan | 26157 | 3293 | 138 |
1093774 | 1093774 | 2021-03-06 | Unknown | Michigan | 0 | 12 | |
1093775 | 1093775 | 2021-03-06 | Van Buren | Michigan | 26159 | 5033 | 97 |
1093776 | 1093776 | 2021-03-06 | Washtenaw | Michigan | 26161 | 19548 | 252 |
1093777 | 1093777 | 2021-03-06 | Wayne | Michigan | 26163 | 103587 | 4174 |
1093778 | 1093778 | 2021-03-06 | Wexford | Michigan | 26165 | 1481 | 21 |
1090449 | 1090449 | 2021-03-05 | Alcona | Michigan | 26001 | 431 | 24 |
1090450 | 1090450 | 2021-03-05 | Alger | Michigan | 26003 | 584 | 5 |
1090451 | 1090451 | 2021-03-05 | Allegan | Michigan | 26005 | 7394 | 118 |
1090452 | 1090452 | 2021-03-05 | Alpena | Michigan | 26007 | 1500 | 48 |
1090453 | 1090453 | 2021-03-05 | Antrim | Michigan | 26009 | 979 | 20 |
1090454 | 1090454 | 2021-03-05 | Arenac | Michigan | 26011 | 766 | 25 |
1090455 | 1090455 | 2021-03-05 | Baraga | Michigan | 26013 | 777 | 33 |
1090456 | 1090456 | 2021-03-05 | Barry | Michigan | 26015 | 3809 | 46 |
1090457 | 1090457 | 2021-03-05 | Bay | Michigan | 26017 | 7531 | 293 |
1090458 | 1090458 | 2021-03-05 | Benzie | Michigan | 26019 | 928 | 31 |
1090459 | 1090459 | 2021-03-05 | Berrien | Michigan | 26021 | 11690 | 245 |
1090460 | 1090460 | 2021-03-05 | Branch | Michigan | 26023 | 4620 | 110 |
1090461 | 1090461 | 2021-03-05 | Calhoun | Michigan | 26025 | 9784 | 235 |
1090462 | 1090462 | 2021-03-05 | Cass | Michigan | 26027 | 4079 | 64 |
1090463 | 1090463 | 2021-03-05 | Charlevoix | Michigan | 26029 | 1065 | 13 |
1090464 | 1090464 | 2021-03-05 | Cheboygan | Michigan | 26031 | 1032 | 37 |
1090465 | 1090465 | 2021-03-05 | Chippewa | Michigan | 26033 | 4889 | 43 |
1090466 | 1090466 | 2021-03-05 | Clare | Michigan | 26035 | 1625 | 69 |
1090467 | 1090467 | 2021-03-05 | Clinton | Michigan | 26037 | 5090 | 71 |
1090468 | 1090468 | 2021-03-05 | Crawford | Michigan | 26039 | 607 | 5 |
1090469 | 1090469 | 2021-03-05 | Delta | Michigan | 26041 | 3156 | 84 |
1090470 | 1090470 | 2021-03-05 | Dickinson | Michigan | 26043 | 2373 | 70 |
1090471 | 1090471 | 2021-03-05 | Eaton | Michigan | 26045 | 6388 | 156 |
1090472 | 1090472 | 2021-03-05 | Emmet | Michigan | 26047 | 1557 | 39 |
1090473 | 1090473 | 2021-03-05 | Genesee | Michigan | 26049 | 26041 | 756 |
1090474 | 1090474 | 2021-03-05 | Gladwin | Michigan | 26051 | 1499 | 43 |
1090475 | 1090475 | 2021-03-05 | Gogebic | Michigan | 26053 | 1288 | 48 |
1090476 | 1090476 | 2021-03-05 | Grand Traverse | Michigan | 26055 | 4368 | 70 |
1090477 | 1090477 | 2021-03-05 | Gratiot | Michigan | 26057 | 5679 | 107 |
1090478 | 1090478 | 2021-03-05 | Hillsdale | Michigan | 26059 | 3388 | 76 |
1090479 | 1090479 | 2021-03-05 | Houghton | Michigan | 26061 | 2685 | 40 |
1090480 | 1090480 | 2021-03-05 | Huron | Michigan | 26063 | 2189 | 59 |
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);