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 794
- 26163 794
- 26065 792
- 26081 792
- 26117 792
- 26147 792
- 26161 792
- 26089 791
- 26099 791
- 26017 790
- 26029 790
- 26115 790
- 26139 789
- 26075 787
- 26137 787
- 26037 785
- 26045 785
- 26049 785
- 26093 785
- 26111 785
- 26035 783
- 26145 783
- 26157 783
- 26165 783
- 26005 782
- 26015 782
- 26021 782
- 26025 782
- 26047 782
- 26051 782
- …
county >30
- Oakland 794
- Wayne 794
- Ingham 792
- Kent 792
- Montcalm 792
- St. Clair 792
- Washtenaw 792
- Leelanau 791
- Macomb 791
- Bay 790
- Charlevoix 790
- Monroe 790
- Ottawa 789
- Jackson 787
- Otsego 787
- Clinton 785
- Eaton 785
- Genesee 785
- Livingston 785
- Midland 785
- Clare 783
- Saginaw 783
- Tuscola 783
- Wexford 783
- Allegan 782
- Barry 782
- Berrien 782
- Calhoun 782
- Emmet 782
- Gladwin 782
- …
state 1
- Michigan · 65,102 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497579 | 2497579 | 2022-05-12 | Chippewa | Michigan | 26033 | 11841 | 120 |
2497580 | 2497580 | 2022-05-12 | Clare | Michigan | 26035 | 6834 | 157 |
2497581 | 2497581 | 2022-05-12 | Clinton | Michigan | 26037 | 22007 | 208 |
2497582 | 2497582 | 2022-05-12 | Crawford | Michigan | 26039 | 2629 | 31 |
2497583 | 2497583 | 2022-05-12 | Delta | Michigan | 26041 | 10050 | 157 |
2497584 | 2497584 | 2022-05-12 | Dickinson | Michigan | 26043 | 7490 | 110 |
2497585 | 2497585 | 2022-05-12 | Eaton | Michigan | 26045 | 27518 | 402 |
2497586 | 2497586 | 2022-05-12 | Emmet | Michigan | 26047 | 6608 | 87 |
2497587 | 2497587 | 2022-05-12 | Genesee | Michigan | 26049 | 103601 | 1720 |
2497588 | 2497588 | 2022-05-12 | Gladwin | Michigan | 26051 | 5632 | 114 |
2497589 | 2497589 | 2022-05-12 | Gogebic | Michigan | 26053 | 3296 | 69 |
2497590 | 2497590 | 2022-05-12 | Grand Traverse | Michigan | 26055 | 17858 | 236 |
2497591 | 2497591 | 2022-05-12 | Gratiot | Michigan | 26057 | 13864 | 191 |
2497592 | 2497592 | 2022-05-12 | Hillsdale | Michigan | 26059 | 10453 | 203 |
2497593 | 2497593 | 2022-05-12 | Houghton | Michigan | 26061 | 7982 | 92 |
2497594 | 2497594 | 2022-05-12 | Huron | Michigan | 26063 | 8138 | 145 |
2497595 | 2497595 | 2022-05-12 | Ingham | Michigan | 26065 | 66384 | 769 |
2497596 | 2497596 | 2022-05-12 | Ionia | Michigan | 26067 | 19843 | 181 |
2497597 | 2497597 | 2022-05-12 | Iosco | Michigan | 26069 | 4860 | 145 |
2497598 | 2497598 | 2022-05-12 | Iron | Michigan | 26071 | 2673 | 86 |
2497599 | 2497599 | 2022-05-12 | Isabella | Michigan | 26073 | 15890 | 211 |
2497600 | 2497600 | 2022-05-12 | Jackson | Michigan | 26075 | 45532 | 590 |
2497601 | 2497601 | 2022-05-12 | Kalamazoo | Michigan | 26077 | 60792 | 675 |
2497602 | 2497602 | 2022-05-12 | Kalkaska | Michigan | 26079 | 3623 | 61 |
2497603 | 2497603 | 2022-05-12 | Kent | Michigan | 26081 | 170251 | 1533 |
2497604 | 2497604 | 2022-05-12 | Keweenaw | Michigan | 26083 | 523 | 14 |
2497605 | 2497605 | 2022-05-12 | Lake | Michigan | 26085 | 1893 | 37 |
2497606 | 2497606 | 2022-05-12 | Lapeer | Michigan | 26087 | 21122 | 427 |
2497607 | 2497607 | 2022-05-12 | Leelanau | Michigan | 26089 | 3697 | 55 |
2497608 | 2497608 | 2022-05-12 | Lenawee | Michigan | 26091 | 26611 | 331 |
2497609 | 2497609 | 2022-05-12 | Livingston | Michigan | 26093 | 47690 | 451 |
2497610 | 2497610 | 2022-05-12 | Luce | Michigan | 26095 | 2306 | 14 |
2497611 | 2497611 | 2022-05-12 | Mackinac | Michigan | 26097 | 2479 | 31 |
2497612 | 2497612 | 2022-05-12 | Macomb | Michigan | 26099 | 238947 | 3970 |
2497613 | 2497613 | 2022-05-12 | Manistee | Michigan | 26101 | 4550 | 91 |
2497614 | 2497614 | 2022-05-12 | Marquette | Michigan | 26103 | 16276 | 131 |
2497615 | 2497615 | 2022-05-12 | Mason | Michigan | 26105 | 6873 | 96 |
2497616 | 2497616 | 2022-05-12 | Mecosta | Michigan | 26107 | 8784 | 108 |
2497617 | 2497617 | 2022-05-12 | Menominee | Michigan | 26109 | 5693 | 70 |
2497618 | 2497618 | 2022-05-12 | Midland | Michigan | 26111 | 19428 | 226 |
2497619 | 2497619 | 2022-05-12 | Missaukee | Michigan | 26113 | 2946 | 60 |
2497620 | 2497620 | 2022-05-12 | Monroe | Michigan | 26115 | 39169 | 475 |
2497621 | 2497621 | 2022-05-12 | Montcalm | Michigan | 26117 | 17350 | 216 |
2497622 | 2497622 | 2022-05-12 | Montmorency | Michigan | 26119 | 1750 | 48 |
2497623 | 2497623 | 2022-05-12 | Muskegon | Michigan | 26121 | 42498 | 650 |
2497624 | 2497624 | 2022-05-12 | Newaygo | Michigan | 26123 | 11622 | 158 |
2497625 | 2497625 | 2022-05-12 | Oakland | Michigan | 26125 | 300744 | 3851 |
2497626 | 2497626 | 2022-05-12 | Oceana | Michigan | 26127 | 6422 | 90 |
2497627 | 2497627 | 2022-05-12 | Ogemaw | Michigan | 26129 | 4372 | 106 |
2497628 | 2497628 | 2022-05-12 | Ontonagon | Michigan | 26131 | 1008 | 38 |
2497629 | 2497629 | 2022-05-12 | Osceola | Michigan | 26133 | 5067 | 80 |
2497630 | 2497630 | 2022-05-12 | Oscoda | Michigan | 26135 | 1450 | 56 |
2497631 | 2497631 | 2022-05-12 | Otsego | Michigan | 26137 | 5779 | 101 |
2497632 | 2497632 | 2022-05-12 | Ottawa | Michigan | 26139 | 76277 | 785 |
2497633 | 2497633 | 2022-05-12 | Presque Isle | Michigan | 26141 | 2085 | 58 |
2497634 | 2497634 | 2022-05-12 | Roscommon | Michigan | 26143 | 4690 | 115 |
2497635 | 2497635 | 2022-05-12 | Saginaw | Michigan | 26145 | 51303 | 956 |
2497636 | 2497636 | 2022-05-12 | Sanilac | Michigan | 26151 | 8827 | 193 |
2497637 | 2497637 | 2022-05-12 | Schoolcraft | Michigan | 26153 | 1763 | 16 |
2497638 | 2497638 | 2022-05-12 | Shiawassee | Michigan | 26155 | 18142 | 232 |
2497639 | 2497639 | 2022-05-12 | St. Clair | Michigan | 26147 | 41609 | 835 |
2497640 | 2497640 | 2022-05-12 | St. Joseph | Michigan | 26149 | 13812 | 208 |
2497641 | 2497641 | 2022-05-12 | Tuscola | Michigan | 26157 | 13350 | 277 |
2497642 | 2497642 | 2022-05-12 | Unknown | Michigan | 17869 | 80 | |
2497643 | 2497643 | 2022-05-12 | Van Buren | Michigan | 26159 | 17347 | 273 |
2497644 | 2497644 | 2022-05-12 | Washtenaw | Michigan | 26161 | 83089 | 522 |
2497645 | 2497645 | 2022-05-12 | Wayne | Michigan | 26163 | 416604 | 7975 |
2497646 | 2497646 | 2022-05-12 | Wexford | Michigan | 26165 | 7169 | 107 |
2494305 | 2494305 | 2022-05-11 | Alcona | Michigan | 26001 | 1745 | 71 |
2494306 | 2494306 | 2022-05-11 | Alger | Michigan | 26003 | 1880 | 13 |
2494307 | 2494307 | 2022-05-11 | Allegan | Michigan | 26005 | 27448 | 348 |
2494308 | 2494308 | 2022-05-11 | Alpena | Michigan | 26007 | 5809 | 139 |
2494309 | 2494309 | 2022-05-11 | Antrim | Michigan | 26009 | 4449 | 66 |
2494310 | 2494310 | 2022-05-11 | Arenac | Michigan | 26011 | 3267 | 67 |
2494311 | 2494311 | 2022-05-11 | Baraga | Michigan | 26013 | 2222 | 54 |
2494312 | 2494312 | 2022-05-11 | Barry | Michigan | 26015 | 14514 | 169 |
2494313 | 2494313 | 2022-05-11 | Bay | Michigan | 26017 | 27496 | 588 |
2494314 | 2494314 | 2022-05-11 | Benzie | Michigan | 26019 | 3514 | 68 |
2494315 | 2494315 | 2022-05-11 | Berrien | Michigan | 26021 | 35344 | 561 |
2494316 | 2494316 | 2022-05-11 | Branch | Michigan | 26023 | 12253 | 206 |
2494317 | 2494317 | 2022-05-11 | Calhoun | Michigan | 26025 | 35011 | 575 |
2494318 | 2494318 | 2022-05-11 | Cass | Michigan | 26027 | 11215 | 145 |
2494319 | 2494319 | 2022-05-11 | Charlevoix | Michigan | 26029 | 4996 | 60 |
2494320 | 2494320 | 2022-05-11 | Cheboygan | Michigan | 26031 | 4760 | 104 |
2494321 | 2494321 | 2022-05-11 | Chippewa | Michigan | 26033 | 11841 | 120 |
2494322 | 2494322 | 2022-05-11 | Clare | Michigan | 26035 | 6834 | 157 |
2494323 | 2494323 | 2022-05-11 | Clinton | Michigan | 26037 | 22007 | 208 |
2494324 | 2494324 | 2022-05-11 | Crawford | Michigan | 26039 | 2629 | 31 |
2494325 | 2494325 | 2022-05-11 | Delta | Michigan | 26041 | 10050 | 157 |
2494326 | 2494326 | 2022-05-11 | Dickinson | Michigan | 26043 | 7490 | 110 |
2494327 | 2494327 | 2022-05-11 | Eaton | Michigan | 26045 | 27518 | 402 |
2494328 | 2494328 | 2022-05-11 | Emmet | Michigan | 26047 | 6574 | 87 |
2494329 | 2494329 | 2022-05-11 | Genesee | Michigan | 26049 | 103601 | 1720 |
2494330 | 2494330 | 2022-05-11 | Gladwin | Michigan | 26051 | 5632 | 114 |
2494331 | 2494331 | 2022-05-11 | Gogebic | Michigan | 26053 | 3296 | 69 |
2494332 | 2494332 | 2022-05-11 | Grand Traverse | Michigan | 26055 | 17858 | 236 |
2494333 | 2494333 | 2022-05-11 | Gratiot | Michigan | 26057 | 13864 | 191 |
2494334 | 2494334 | 2022-05-11 | Hillsdale | Michigan | 26059 | 10453 | 203 |
2494335 | 2494335 | 2022-05-11 | Houghton | Michigan | 26061 | 7982 | 92 |
2494336 | 2494336 | 2022-05-11 | Huron | Michigan | 26063 | 8138 | 145 |
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);