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 309
- 26163 309
- 26065 307
- 26081 307
- 26117 307
- 26147 307
- 26161 307
- 26017 306
- 26029 306
- 26089 306
- 26099 306
- 26115 305
- 26139 304
- 26075 302
- 26137 302
- 26037 300
- 26045 300
- 26049 300
- 26093 300
- 26111 300
- 26005 298
- 26015 298
- 26021 298
- 26025 298
- 26035 298
- 26145 298
- 26157 298
- 26165 298
- 26047 297
- 26051 297
- …
county >30
- Oakland 309
- Wayne 309
- Ingham 307
- Kent 307
- Montcalm 307
- St. Clair 307
- Washtenaw 307
- Bay 306
- Charlevoix 306
- Leelanau 306
- Macomb 306
- Monroe 305
- Ottawa 304
- Jackson 302
- Otsego 302
- Clinton 300
- Eaton 300
- Genesee 300
- Livingston 300
- Midland 300
- Allegan 298
- Barry 298
- Berrien 298
- Calhoun 298
- Clare 298
- Saginaw 298
- Tuscola 298
- Wexford 298
- Emmet 297
- Gladwin 297
- …
state 1
- Michigan · 24,378 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921680 | 921680 | 2021-01-12 | Alcona | Michigan | 26001 | 380 | 18 |
921681 | 921681 | 2021-01-12 | Alger | Michigan | 26003 | 477 | 3 |
921682 | 921682 | 2021-01-12 | Allegan | Michigan | 26005 | 6284 | 88 |
921683 | 921683 | 2021-01-12 | Alpena | Michigan | 26007 | 1313 | 38 |
921684 | 921684 | 2021-01-12 | Antrim | Michigan | 26009 | 756 | 14 |
921685 | 921685 | 2021-01-12 | Arenac | Michigan | 26011 | 651 | 25 |
921686 | 921686 | 2021-01-12 | Baraga | Michigan | 26013 | 631 | 29 |
921687 | 921687 | 2021-01-12 | Barry | Michigan | 26015 | 3240 | 38 |
921688 | 921688 | 2021-01-12 | Bay | Michigan | 26017 | 6726 | 223 |
921689 | 921689 | 2021-01-12 | Benzie | Michigan | 26019 | 761 | 28 |
921690 | 921690 | 2021-01-12 | Berrien | Michigan | 26021 | 10056 | 209 |
921691 | 921691 | 2021-01-12 | Branch | Michigan | 26023 | 4164 | 95 |
921692 | 921692 | 2021-01-12 | Calhoun | Michigan | 26025 | 8273 | 203 |
921693 | 921693 | 2021-01-12 | Cass | Michigan | 26027 | 3460 | 52 |
921694 | 921694 | 2021-01-12 | Charlevoix | Michigan | 26029 | 911 | 10 |
921695 | 921695 | 2021-01-12 | Cheboygan | Michigan | 26031 | 807 | 33 |
921696 | 921696 | 2021-01-12 | Chippewa | Michigan | 26033 | 3008 | 21 |
921697 | 921697 | 2021-01-12 | Clare | Michigan | 26035 | 1340 | 57 |
921698 | 921698 | 2021-01-12 | Clinton | Michigan | 26037 | 4376 | 50 |
921699 | 921699 | 2021-01-12 | Crawford | Michigan | 26039 | 506 | 5 |
921700 | 921700 | 2021-01-12 | Delta | Michigan | 26041 | 2981 | 78 |
921701 | 921701 | 2021-01-12 | Dickinson | Michigan | 26043 | 2258 | 70 |
921702 | 921702 | 2021-01-12 | Eaton | Michigan | 26045 | 5239 | 111 |
921703 | 921703 | 2021-01-12 | Emmet | Michigan | 26047 | 1295 | 34 |
921704 | 921704 | 2021-01-12 | Genesee | Michigan | 26049 | 23009 | 658 |
921705 | 921705 | 2021-01-12 | Gladwin | Michigan | 26051 | 1306 | 35 |
921706 | 921706 | 2021-01-12 | Gogebic | Michigan | 26053 | 1049 | 40 |
921707 | 921707 | 2021-01-12 | Grand Traverse | Michigan | 26055 | 3535 | 51 |
921708 | 921708 | 2021-01-12 | Gratiot | Michigan | 26057 | 4263 | 88 |
921709 | 921709 | 2021-01-12 | Hillsdale | Michigan | 26059 | 2889 | 63 |
921710 | 921710 | 2021-01-12 | Houghton | Michigan | 26061 | 2219 | 34 |
921711 | 921711 | 2021-01-12 | Huron | Michigan | 26063 | 1757 | 52 |
921712 | 921712 | 2021-01-12 | Ingham | Michigan | 26065 | 13686 | 222 |
921713 | 921713 | 2021-01-12 | Ionia | Michigan | 26067 | 5167 | 58 |
921714 | 921714 | 2021-01-12 | Iosco | Michigan | 26069 | 1185 | 56 |
921715 | 921715 | 2021-01-12 | Iron | Michigan | 26071 | 867 | 37 |
921716 | 921716 | 2021-01-12 | Isabella | Michigan | 26073 | 3687 | 58 |
921717 | 921717 | 2021-01-12 | Jackson | Michigan | 26075 | 11026 | 209 |
921718 | 921718 | 2021-01-12 | Kalamazoo | Michigan | 26077 | 13315 | 274 |
921719 | 921719 | 2021-01-12 | Kalkaska | Michigan | 26079 | 518 | 14 |
921720 | 921720 | 2021-01-12 | Kent | Michigan | 26081 | 46391 | 594 |
921721 | 921721 | 2021-01-12 | Keweenaw | Michigan | 26083 | 100 | 2 |
921722 | 921722 | 2021-01-12 | Lake | Michigan | 26085 | 325 | 10 |
921723 | 921723 | 2021-01-12 | Lapeer | Michigan | 26087 | 4646 | 110 |
921724 | 921724 | 2021-01-12 | Leelanau | Michigan | 26089 | 711 | 9 |
921725 | 921725 | 2021-01-12 | Lenawee | Michigan | 26091 | 6078 | 81 |
921726 | 921726 | 2021-01-12 | Livingston | Michigan | 26093 | 8782 | 92 |
921727 | 921727 | 2021-01-12 | Luce | Michigan | 26095 | 980 | 0 |
921728 | 921728 | 2021-01-12 | Mackinac | Michigan | 26097 | 397 | 3 |
921729 | 921729 | 2021-01-12 | Macomb | Michigan | 26099 | 52793 | 1734 |
921730 | 921730 | 2021-01-12 | Manistee | Michigan | 26101 | 695 | 19 |
921731 | 921731 | 2021-01-12 | Marquette | Michigan | 26103 | 4579 | 52 |
921732 | 921732 | 2021-01-12 | Mason | Michigan | 26105 | 1079 | 22 |
921733 | 921733 | 2021-01-12 | Mecosta | Michigan | 26107 | 1767 | 14 |
921734 | 921734 | 2021-01-12 | Menominee | Michigan | 26109 | 1777 | 33 |
921735 | 921735 | 2021-01-12 | Midland | Michigan | 26111 | 4383 | 51 |
921736 | 921736 | 2021-01-12 | Missaukee | Michigan | 26113 | 583 | 12 |
921737 | 921737 | 2021-01-12 | Monroe | Michigan | 26115 | 8384 | 172 |
921738 | 921738 | 2021-01-12 | Montcalm | Michigan | 26117 | 3447 | 78 |
921739 | 921739 | 2021-01-12 | Montmorency | Michigan | 26119 | 333 | 13 |
921740 | 921740 | 2021-01-12 | Muskegon | Michigan | 26121 | 11596 | 285 |
921741 | 921741 | 2021-01-12 | Newaygo | Michigan | 26123 | 2438 | 39 |
921742 | 921742 | 2021-01-12 | Oakland | Michigan | 26125 | 65837 | 1763 |
921743 | 921743 | 2021-01-12 | Oceana | Michigan | 26127 | 1711 | 43 |
921744 | 921744 | 2021-01-12 | Ogemaw | Michigan | 26129 | 995 | 30 |
921745 | 921745 | 2021-01-12 | Ontonagon | Michigan | 26131 | 313 | 16 |
921746 | 921746 | 2021-01-12 | Osceola | Michigan | 26133 | 924 | 19 |
921747 | 921747 | 2021-01-12 | Oscoda | Michigan | 26135 | 331 | 19 |
921748 | 921748 | 2021-01-12 | Otsego | Michigan | 26137 | 1067 | 25 |
921749 | 921749 | 2021-01-12 | Ottawa | Michigan | 26139 | 19781 | 302 |
921750 | 921750 | 2021-01-12 | Presque Isle | Michigan | 26141 | 578 | 18 |
921751 | 921751 | 2021-01-12 | Roscommon | Michigan | 26143 | 1032 | 28 |
921752 | 921752 | 2021-01-12 | Saginaw | Michigan | 26145 | 13270 | 435 |
921753 | 921753 | 2021-01-12 | Sanilac | Michigan | 26151 | 1667 | 67 |
921754 | 921754 | 2021-01-12 | Schoolcraft | Michigan | 26153 | 245 | 4 |
921755 | 921755 | 2021-01-12 | Shiawassee | Michigan | 26155 | 3252 | 61 |
921756 | 921756 | 2021-01-12 | St. Clair | Michigan | 26147 | 7724 | 198 |
921757 | 921757 | 2021-01-12 | St. Joseph | Michigan | 26149 | 3990 | 64 |
921758 | 921758 | 2021-01-12 | Tuscola | Michigan | 26157 | 2891 | 107 |
921759 | 921759 | 2021-01-12 | Unknown | Michigan | 8830 | 46 | |
921760 | 921760 | 2021-01-12 | Van Buren | Michigan | 26159 | 4434 | 86 |
921761 | 921761 | 2021-01-12 | Washtenaw | Michigan | 26161 | 15564 | 222 |
921762 | 921762 | 2021-01-12 | Wayne | Michigan | 26163 | 90704 | 3807 |
921763 | 921763 | 2021-01-12 | Wexford | Michigan | 26165 | 1126 | 20 |
918435 | 918435 | 2021-01-11 | Alcona | Michigan | 26001 | 378 | 18 |
918436 | 918436 | 2021-01-11 | Alger | Michigan | 26003 | 475 | 3 |
918437 | 918437 | 2021-01-11 | Allegan | Michigan | 26005 | 6256 | 87 |
918438 | 918438 | 2021-01-11 | Alpena | Michigan | 26007 | 1309 | 36 |
918439 | 918439 | 2021-01-11 | Antrim | Michigan | 26009 | 748 | 13 |
918440 | 918440 | 2021-01-11 | Arenac | Michigan | 26011 | 648 | 25 |
918441 | 918441 | 2021-01-11 | Baraga | Michigan | 26013 | 629 | 29 |
918442 | 918442 | 2021-01-11 | Barry | Michigan | 26015 | 3216 | 38 |
918443 | 918443 | 2021-01-11 | Bay | Michigan | 26017 | 6711 | 218 |
918444 | 918444 | 2021-01-11 | Benzie | Michigan | 26019 | 757 | 28 |
918445 | 918445 | 2021-01-11 | Berrien | Michigan | 26021 | 9994 | 205 |
918446 | 918446 | 2021-01-11 | Branch | Michigan | 26023 | 4157 | 96 |
918447 | 918447 | 2021-01-11 | Calhoun | Michigan | 26025 | 8230 | 206 |
918448 | 918448 | 2021-01-11 | Cass | Michigan | 26027 | 3441 | 52 |
918449 | 918449 | 2021-01-11 | Charlevoix | Michigan | 26029 | 903 | 10 |
918450 | 918450 | 2021-01-11 | Cheboygan | Michigan | 26031 | 803 | 33 |
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);