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 190
- 26163 190
- 26065 188
- 26081 188
- 26117 188
- 26147 188
- 26161 188
- 26017 187
- 26029 187
- 26089 187
- 26099 187
- 26115 186
- 26139 185
- 26075 183
- 26137 183
- 26037 181
- 26045 181
- 26049 181
- 26093 181
- 26111 181
- 26005 179
- 26015 179
- 26021 179
- 26025 179
- 26035 179
- 26145 179
- 26157 179
- 26165 179
- 26047 178
- 26051 178
- …
county >30
- Oakland 190
- Wayne 190
- Ingham 188
- Kent 188
- Montcalm 188
- St. Clair 188
- Washtenaw 188
- Bay 187
- Charlevoix 187
- Leelanau 187
- Macomb 187
- Monroe 186
- Ottawa 185
- Jackson 183
- Otsego 183
- Clinton 181
- Eaton 181
- Genesee 181
- Livingston 181
- Midland 181
- Allegan 179
- Barry 179
- Berrien 179
- Calhoun 179
- Clare 179
- Saginaw 179
- Tuscola 179
- Wexford 179
- Emmet 178
- Gladwin 178
- …
state 1
- Michigan · 14,382 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535662 | 535662 | 2020-09-15 | Alcona | Michigan | 26001 | 41 | 2 |
535663 | 535663 | 2020-09-15 | Alger | Michigan | 26003 | 17 | 0 |
535664 | 535664 | 2020-09-15 | Allegan | Michigan | 26005 | 711 | 7 |
535665 | 535665 | 2020-09-15 | Alpena | Michigan | 26007 | 134 | 14 |
535666 | 535666 | 2020-09-15 | Antrim | Michigan | 26009 | 64 | 0 |
535667 | 535667 | 2020-09-15 | Arenac | Michigan | 26011 | 68 | 3 |
535668 | 535668 | 2020-09-15 | Baraga | Michigan | 26013 | 13 | 0 |
535669 | 535669 | 2020-09-15 | Barry | Michigan | 26015 | 263 | 2 |
535670 | 535670 | 2020-09-15 | Bay | Michigan | 26017 | 918 | 46 |
535671 | 535671 | 2020-09-15 | Benzie | Michigan | 26019 | 61 | 2 |
535672 | 535672 | 2020-09-15 | Berrien | Michigan | 26021 | 1811 | 72 |
535673 | 535673 | 2020-09-15 | Branch | Michigan | 26023 | 1369 | 27 |
535674 | 535674 | 2020-09-15 | Calhoun | Michigan | 26025 | 1160 | 44 |
535675 | 535675 | 2020-09-15 | Cass | Michigan | 26027 | 480 | 16 |
535676 | 535676 | 2020-09-15 | Charlevoix | Michigan | 26029 | 95 | 3 |
535677 | 535677 | 2020-09-15 | Cheboygan | Michigan | 26031 | 86 | 2 |
535678 | 535678 | 2020-09-15 | Chippewa | Michigan | 26033 | 68 | 0 |
535679 | 535679 | 2020-09-15 | Clare | Michigan | 26035 | 107 | 4 |
535680 | 535680 | 2020-09-15 | Clinton | Michigan | 26037 | 594 | 13 |
535681 | 535681 | 2020-09-15 | Crawford | Michigan | 26039 | 118 | 5 |
535682 | 535682 | 2020-09-15 | Delta | Michigan | 26041 | 230 | 4 |
535683 | 535683 | 2020-09-15 | Dickinson | Michigan | 26043 | 78 | 2 |
535684 | 535684 | 2020-09-15 | Eaton | Michigan | 26045 | 586 | 10 |
535685 | 535685 | 2020-09-15 | Emmet | Michigan | 26047 | 140 | 4 |
535686 | 535686 | 2020-09-15 | Genesee | Michigan | 26049 | 4169 | 307 |
535687 | 535687 | 2020-09-15 | Gladwin | Michigan | 26051 | 85 | 2 |
535688 | 535688 | 2020-09-15 | Gogebic | Michigan | 26053 | 152 | 1 |
535689 | 535689 | 2020-09-15 | Grand Traverse | Michigan | 26055 | 439 | 7 |
535690 | 535690 | 2020-09-15 | Gratiot | Michigan | 26057 | 230 | 15 |
535691 | 535691 | 2020-09-15 | Hillsdale | Michigan | 26059 | 316 | 27 |
535692 | 535692 | 2020-09-15 | Houghton | Michigan | 26061 | 223 | 1 |
535693 | 535693 | 2020-09-15 | Huron | Michigan | 26063 | 207 | 5 |
535694 | 535694 | 2020-09-15 | Ingham | Michigan | 26065 | 2758 | 43 |
535695 | 535695 | 2020-09-15 | Ionia | Michigan | 26067 | 369 | 7 |
535696 | 535696 | 2020-09-15 | Iosco | Michigan | 26069 | 176 | 12 |
535697 | 535697 | 2020-09-15 | Iron | Michigan | 26071 | 52 | 1 |
535698 | 535698 | 2020-09-15 | Isabella | Michigan | 26073 | 622 | 11 |
535699 | 535699 | 2020-09-15 | Jackson | Michigan | 26075 | 2675 | 64 |
535700 | 535700 | 2020-09-15 | Kalamazoo | Michigan | 26077 | 2352 | 91 |
535701 | 535701 | 2020-09-15 | Kalkaska | Michigan | 26079 | 79 | 4 |
535702 | 535702 | 2020-09-15 | Kent | Michigan | 26081 | 9131 | 173 |
535703 | 535703 | 2020-09-15 | Keweenaw | Michigan | 26083 | 7 | 0 |
535704 | 535704 | 2020-09-15 | Lake | Michigan | 26085 | 32 | 0 |
535705 | 535705 | 2020-09-15 | Lapeer | Michigan | 26087 | 879 | 44 |
535706 | 535706 | 2020-09-15 | Leelanau | Michigan | 26089 | 102 | 1 |
535707 | 535707 | 2020-09-15 | Lenawee | Michigan | 26091 | 1482 | 19 |
535708 | 535708 | 2020-09-15 | Livingston | Michigan | 26093 | 1329 | 30 |
535709 | 535709 | 2020-09-15 | Luce | Michigan | 26095 | 217 | 0 |
535710 | 535710 | 2020-09-15 | Mackinac | Michigan | 26097 | 51 | 0 |
535711 | 535711 | 2020-09-15 | Macomb | Michigan | 26099 | 14041 | 1010 |
535712 | 535712 | 2020-09-15 | Manistee | Michigan | 26101 | 83 | 2 |
535713 | 535713 | 2020-09-15 | Marquette | Michigan | 26103 | 293 | 11 |
535714 | 535714 | 2020-09-15 | Mason | Michigan | 26105 | 133 | 0 |
535715 | 535715 | 2020-09-15 | Mecosta | Michigan | 26107 | 169 | 2 |
535716 | 535716 | 2020-09-15 | Menominee | Michigan | 26109 | 272 | 0 |
535717 | 535717 | 2020-09-15 | Midland | Michigan | 26111 | 526 | 11 |
535718 | 535718 | 2020-09-15 | Missaukee | Michigan | 26113 | 55 | 1 |
535719 | 535719 | 2020-09-15 | Monroe | Michigan | 26115 | 1443 | 28 |
535720 | 535720 | 2020-09-15 | Montcalm | Michigan | 26117 | 275 | 4 |
535721 | 535721 | 2020-09-15 | Montmorency | Michigan | 26119 | 13 | 0 |
535722 | 535722 | 2020-09-15 | Muskegon | Michigan | 26121 | 2306 | 70 |
535723 | 535723 | 2020-09-15 | Newaygo | Michigan | 26123 | 318 | 1 |
535724 | 535724 | 2020-09-15 | Oakland | Michigan | 26125 | 19549 | 1188 |
535725 | 535725 | 2020-09-15 | Oceana | Michigan | 26127 | 506 | 6 |
535726 | 535726 | 2020-09-15 | Ogemaw | Michigan | 26129 | 60 | 5 |
535727 | 535727 | 2020-09-15 | Ontonagon | Michigan | 26131 | 39 | 0 |
535728 | 535728 | 2020-09-15 | Osceola | Michigan | 26133 | 88 | 0 |
535729 | 535729 | 2020-09-15 | Oscoda | Michigan | 26135 | 29 | 1 |
535730 | 535730 | 2020-09-15 | Otsego | Michigan | 26137 | 171 | 11 |
535731 | 535731 | 2020-09-15 | Ottawa | Michigan | 26139 | 3019 | 65 |
535732 | 535732 | 2020-09-15 | Presque Isle | Michigan | 26141 | 24 | 1 |
535733 | 535733 | 2020-09-15 | Roscommon | Michigan | 26143 | 87 | 4 |
535734 | 535734 | 2020-09-15 | Saginaw | Michigan | 26145 | 2809 | 137 |
535735 | 535735 | 2020-09-15 | Sanilac | Michigan | 26151 | 134 | 7 |
535736 | 535736 | 2020-09-15 | Schoolcraft | Michigan | 26153 | 19 | 0 |
535737 | 535737 | 2020-09-15 | Shiawassee | Michigan | 26155 | 482 | 30 |
535738 | 535738 | 2020-09-15 | St. Clair | Michigan | 26147 | 969 | 53 |
535739 | 535739 | 2020-09-15 | St. Joseph | Michigan | 26149 | 711 | 11 |
535740 | 535740 | 2020-09-15 | Tuscola | Michigan | 26157 | 474 | 29 |
535741 | 535741 | 2020-09-15 | Unknown | Michigan | 288 | 4 | |
535742 | 535742 | 2020-09-15 | Van Buren | Michigan | 26159 | 714 | 17 |
535743 | 535743 | 2020-09-15 | Washtenaw | Michigan | 26161 | 3733 | 125 |
535744 | 535744 | 2020-09-15 | Wayne | Michigan | 26163 | 33678 | 2948 |
535745 | 535745 | 2020-09-15 | Wexford | Michigan | 26165 | 122 | 4 |
532427 | 532427 | 2020-09-14 | Alcona | Michigan | 26001 | 41 | 2 |
532428 | 532428 | 2020-09-14 | Alger | Michigan | 26003 | 17 | 0 |
532429 | 532429 | 2020-09-14 | Allegan | Michigan | 26005 | 702 | 7 |
532430 | 532430 | 2020-09-14 | Alpena | Michigan | 26007 | 133 | 14 |
532431 | 532431 | 2020-09-14 | Antrim | Michigan | 26009 | 64 | 0 |
532432 | 532432 | 2020-09-14 | Arenac | Michigan | 26011 | 66 | 3 |
532433 | 532433 | 2020-09-14 | Baraga | Michigan | 26013 | 13 | 0 |
532434 | 532434 | 2020-09-14 | Barry | Michigan | 26015 | 259 | 2 |
532435 | 532435 | 2020-09-14 | Bay | Michigan | 26017 | 911 | 46 |
532436 | 532436 | 2020-09-14 | Benzie | Michigan | 26019 | 62 | 2 |
532437 | 532437 | 2020-09-14 | Berrien | Michigan | 26021 | 1807 | 72 |
532438 | 532438 | 2020-09-14 | Branch | Michigan | 26023 | 1363 | 27 |
532439 | 532439 | 2020-09-14 | Calhoun | Michigan | 26025 | 1153 | 44 |
532440 | 532440 | 2020-09-14 | Cass | Michigan | 26027 | 475 | 16 |
532441 | 532441 | 2020-09-14 | Charlevoix | Michigan | 26029 | 95 | 3 |
532442 | 532442 | 2020-09-14 | Cheboygan | Michigan | 26031 | 85 | 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);