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 553
- 26163 553
- 26065 551
- 26081 551
- 26117 551
- 26147 551
- 26161 551
- 26089 550
- 26099 550
- 26017 549
- 26029 549
- 26115 549
- 26139 548
- 26075 546
- 26137 546
- 26037 544
- 26045 544
- 26049 544
- 26093 544
- 26111 544
- 26035 542
- 26145 542
- 26157 542
- 26165 542
- 26005 541
- 26015 541
- 26021 541
- 26025 541
- 26047 541
- 26051 541
- …
county >30
- Oakland 553
- Wayne 553
- Ingham 551
- Kent 551
- Montcalm 551
- St. Clair 551
- Washtenaw 551
- Leelanau 550
- Macomb 550
- Bay 549
- Charlevoix 549
- Monroe 549
- Ottawa 548
- Jackson 546
- Otsego 546
- Clinton 544
- Eaton 544
- Genesee 544
- Livingston 544
- Midland 544
- Clare 542
- Saginaw 542
- Tuscola 542
- Wexford 542
- Allegan 541
- Barry 541
- Berrien 541
- Calhoun 541
- Emmet 541
- Gladwin 541
- …
state 1
- Michigan · 44,858 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1713904 | 1713904 | 2021-09-13 | Chippewa | Michigan | 26033 | 5936 | 51 |
1713905 | 1713905 | 2021-09-13 | Clare | Michigan | 26035 | 2789 | 89 |
1713906 | 1713906 | 2021-09-13 | Clinton | Michigan | 26037 | 8368 | 98 |
1713907 | 1713907 | 2021-09-13 | Crawford | Michigan | 26039 | 1090 | 15 |
1713908 | 1713908 | 2021-09-13 | Delta | Michigan | 26041 | 4713 | 96 |
1713909 | 1713909 | 2021-09-13 | Dickinson | Michigan | 26043 | 3151 | 75 |
1713910 | 1713910 | 2021-09-13 | Eaton | Michigan | 26045 | 11272 | 218 |
1713911 | 1713911 | 2021-09-13 | Emmet | Michigan | 26047 | 2696 | 45 |
1713912 | 1713912 | 2021-09-13 | Genesee | Michigan | 26049 | 45509 | 1014 |
1713913 | 1713913 | 2021-09-13 | Gladwin | Michigan | 26051 | 2570 | 62 |
1713914 | 1713914 | 2021-09-13 | Gogebic | Michigan | 26053 | 1567 | 53 |
1713915 | 1713915 | 2021-09-13 | Grand Traverse | Michigan | 26055 | 7329 | 104 |
1713916 | 1713916 | 2021-09-13 | Gratiot | Michigan | 26057 | 7333 | 127 |
1713917 | 1713917 | 2021-09-13 | Hillsdale | Michigan | 26059 | 5058 | 102 |
1713918 | 1713918 | 2021-09-13 | Houghton | Michigan | 26061 | 3373 | 46 |
1713919 | 1713919 | 2021-09-13 | Huron | Michigan | 26063 | 4352 | 87 |
1713920 | 1713920 | 2021-09-13 | Ingham | Michigan | 26065 | 27259 | 421 |
1713921 | 1713921 | 2021-09-13 | Ionia | Michigan | 26067 | 10036 | 88 |
1713922 | 1713922 | 2021-09-13 | Iosco | Michigan | 26069 | 2287 | 81 |
1713923 | 1713923 | 2021-09-13 | Iron | Michigan | 26071 | 1211 | 53 |
1713924 | 1713924 | 2021-09-13 | Isabella | Michigan | 26073 | 7036 | 103 |
1713925 | 1713925 | 2021-09-13 | Jackson | Michigan | 26075 | 22930 | 337 |
1713926 | 1713926 | 2021-09-13 | Kalamazoo | Michigan | 26077 | 25941 | 426 |
1713927 | 1713927 | 2021-09-13 | Kalkaska | Michigan | 26079 | 1321 | 31 |
1713928 | 1713928 | 2021-09-13 | Kent | Michigan | 26081 | 80743 | 905 |
1713929 | 1713929 | 2021-09-13 | Keweenaw | Michigan | 26083 | 192 | 2 |
1713930 | 1713930 | 2021-09-13 | Lake | Michigan | 26085 | 758 | 17 |
1713931 | 1713931 | 2021-09-13 | Lapeer | Michigan | 26087 | 10552 | 226 |
1713932 | 1713932 | 2021-09-13 | Leelanau | Michigan | 26089 | 1401 | 22 |
1713933 | 1713933 | 2021-09-13 | Lenawee | Michigan | 26091 | 12026 | 185 |
1713934 | 1713934 | 2021-09-13 | Livingston | Michigan | 26093 | 19109 | 210 |
1713935 | 1713935 | 2021-09-13 | Luce | Michigan | 26095 | 1389 | 6 |
1713936 | 1713936 | 2021-09-13 | Mackinac | Michigan | 26097 | 876 | 4 |
1713937 | 1713937 | 2021-09-13 | Macomb | Michigan | 26099 | 108579 | 2562 |
1713938 | 1713938 | 2021-09-13 | Manistee | Michigan | 26101 | 2206 | 30 |
1713939 | 1713939 | 2021-09-13 | Marquette | Michigan | 26103 | 6437 | 68 |
1713940 | 1713940 | 2021-09-13 | Mason | Michigan | 26105 | 2505 | 41 |
1713941 | 1713941 | 2021-09-13 | Mecosta | Michigan | 26107 | 3584 | 39 |
1713942 | 1713942 | 2021-09-13 | Menominee | Michigan | 26109 | 2548 | 46 |
1713943 | 1713943 | 2021-09-13 | Midland | Michigan | 26111 | 8405 | 106 |
1713944 | 1713944 | 2021-09-13 | Missaukee | Michigan | 26113 | 1604 | 29 |
1713945 | 1713945 | 2021-09-13 | Monroe | Michigan | 26115 | 16960 | 278 |
1713946 | 1713946 | 2021-09-13 | Montcalm | Michigan | 26117 | 8800 | 126 |
1713947 | 1713947 | 2021-09-13 | Montmorency | Michigan | 26119 | 705 | 21 |
1713948 | 1713948 | 2021-09-13 | Muskegon | Michigan | 26121 | 20011 | 394 |
1713949 | 1713949 | 2021-09-13 | Newaygo | Michigan | 26123 | 5280 | 72 |
1713950 | 1713950 | 2021-09-13 | Oakland | Michigan | 26125 | 130259 | 2539 |
1713951 | 1713951 | 2021-09-13 | Oceana | Michigan | 26127 | 2969 | 62 |
1713952 | 1713952 | 2021-09-13 | Ogemaw | Michigan | 26129 | 1979 | 45 |
1713953 | 1713953 | 2021-09-13 | Ontonagon | Michigan | 26131 | 546 | 22 |
1713954 | 1713954 | 2021-09-13 | Osceola | Michigan | 26133 | 2190 | 31 |
1713955 | 1713955 | 2021-09-13 | Oscoda | Michigan | 26135 | 742 | 31 |
1713956 | 1713956 | 2021-09-13 | Otsego | Michigan | 26137 | 2618 | 43 |
1713957 | 1713957 | 2021-09-13 | Ottawa | Michigan | 26139 | 36153 | 459 |
1713958 | 1713958 | 2021-09-13 | Presque Isle | Michigan | 26141 | 1147 | 35 |
1713959 | 1713959 | 2021-09-13 | Roscommon | Michigan | 26143 | 2048 | 57 |
1713960 | 1713960 | 2021-09-13 | Saginaw | Michigan | 26145 | 24611 | 652 |
1713961 | 1713961 | 2021-09-13 | Sanilac | Michigan | 26151 | 4449 | 127 |
1713962 | 1713962 | 2021-09-13 | Schoolcraft | Michigan | 26153 | 525 | 5 |
1713963 | 1713963 | 2021-09-13 | Shiawassee | Michigan | 26155 | 7284 | 114 |
1713964 | 1713964 | 2021-09-13 | St. Clair | Michigan | 26147 | 19702 | 468 |
1713965 | 1713965 | 2021-09-13 | St. Joseph | Michigan | 26149 | 7003 | 104 |
1713966 | 1713966 | 2021-09-13 | Tuscola | Michigan | 26157 | 6134 | 181 |
1713967 | 1713967 | 2021-09-13 | Unknown | Michigan | 830 | 18 | |
1713968 | 1713968 | 2021-09-13 | Van Buren | Michigan | 26159 | 7859 | 148 |
1713969 | 1713969 | 2021-09-13 | Washtenaw | Michigan | 26161 | 29940 | 317 |
1713970 | 1713970 | 2021-09-13 | Wayne | Michigan | 26163 | 180274 | 5327 |
1713971 | 1713971 | 2021-09-13 | Wexford | Michigan | 26165 | 3043 | 50 |
1710642 | 1710642 | 2021-09-12 | Alcona | Michigan | 26001 | 844 | 37 |
1710643 | 1710643 | 2021-09-12 | Alger | Michigan | 26003 | 751 | 7 |
1710644 | 1710644 | 2021-09-12 | Allegan | Michigan | 26005 | 12371 | 168 |
1710645 | 1710645 | 2021-09-12 | Alpena | Michigan | 26007 | 2545 | 67 |
1710646 | 1710646 | 2021-09-12 | Antrim | Michigan | 26009 | 1827 | 33 |
1710647 | 1710647 | 2021-09-12 | Arenac | Michigan | 26011 | 1321 | 31 |
1710648 | 1710648 | 2021-09-12 | Baraga | Michigan | 26013 | 1091 | 43 |
1710649 | 1710649 | 2021-09-12 | Barry | Michigan | 26015 | 6580 | 74 |
1710650 | 1710650 | 2021-09-12 | Bay | Michigan | 26017 | 12036 | 366 |
1710651 | 1710651 | 2021-09-12 | Benzie | Michigan | 26019 | 1391 | 38 |
1710652 | 1710652 | 2021-09-12 | Berrien | Michigan | 26021 | 16960 | 306 |
1710653 | 1710653 | 2021-09-12 | Branch | Michigan | 26023 | 6565 | 128 |
1710654 | 1710654 | 2021-09-12 | Calhoun | Michigan | 26025 | 15987 | 331 |
1710655 | 1710655 | 2021-09-12 | Cass | Michigan | 26027 | 6041 | 81 |
1710656 | 1710656 | 2021-09-12 | Charlevoix | Michigan | 26029 | 1979 | 27 |
1710657 | 1710657 | 2021-09-12 | Cheboygan | Michigan | 26031 | 2152 | 53 |
1710658 | 1710658 | 2021-09-12 | Chippewa | Michigan | 26033 | 5913 | 51 |
1710659 | 1710659 | 2021-09-12 | Clare | Michigan | 26035 | 2757 | 89 |
1710660 | 1710660 | 2021-09-12 | Clinton | Michigan | 26037 | 8329 | 98 |
1710661 | 1710661 | 2021-09-12 | Crawford | Michigan | 26039 | 1081 | 14 |
1710662 | 1710662 | 2021-09-12 | Delta | Michigan | 26041 | 4648 | 95 |
1710663 | 1710663 | 2021-09-12 | Dickinson | Michigan | 26043 | 3096 | 75 |
1710664 | 1710664 | 2021-09-12 | Eaton | Michigan | 26045 | 11181 | 218 |
1710665 | 1710665 | 2021-09-12 | Emmet | Michigan | 26047 | 2681 | 45 |
1710666 | 1710666 | 2021-09-12 | Genesee | Michigan | 26049 | 45277 | 1014 |
1710667 | 1710667 | 2021-09-12 | Gladwin | Michigan | 26051 | 2545 | 62 |
1710668 | 1710668 | 2021-09-12 | Gogebic | Michigan | 26053 | 1561 | 53 |
1710669 | 1710669 | 2021-09-12 | Grand Traverse | Michigan | 26055 | 7261 | 104 |
1710670 | 1710670 | 2021-09-12 | Gratiot | Michigan | 26057 | 7296 | 127 |
1710671 | 1710671 | 2021-09-12 | Hillsdale | Michigan | 26059 | 4978 | 101 |
1710672 | 1710672 | 2021-09-12 | Houghton | Michigan | 26061 | 3351 | 45 |
1710673 | 1710673 | 2021-09-12 | Huron | Michigan | 26063 | 4344 | 87 |
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);