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 554
- 26163 554
- 26065 552
- 26081 552
- 26117 552
- 26147 552
- 26161 552
- 26017 551
- 26029 551
- 26089 551
- 26099 551
- 26115 550
- 26139 549
- 26075 547
- 26137 547
- 26037 545
- 26045 545
- 26049 545
- 26093 545
- 26111 545
- 26005 543
- 26015 543
- 26021 543
- 26025 543
- 26035 543
- 26145 543
- 26157 543
- 26165 543
- 26047 542
- 26051 542
- …
county >30
- Oakland 554
- Wayne 554
- Ingham 552
- Kent 552
- Montcalm 552
- St. Clair 552
- Washtenaw 552
- Bay 551
- Charlevoix 551
- Leelanau 551
- Macomb 551
- Monroe 550
- Ottawa 549
- Jackson 547
- Otsego 547
- Clinton 545
- Eaton 545
- Genesee 545
- Livingston 545
- Midland 545
- Allegan 543
- Barry 543
- Berrien 543
- Calhoun 543
- Clare 543
- Saginaw 543
- Tuscola 543
- Wexford 543
- Emmet 542
- Gladwin 542
- …
state 1
- Michigan · 44,958 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717136 | 1717136 | 2021-09-14 | Alcona | Michigan | 26001 | 851 | 37 |
1717137 | 1717137 | 2021-09-14 | Alger | Michigan | 26003 | 768 | 7 |
1717138 | 1717138 | 2021-09-14 | Allegan | Michigan | 26005 | 12462 | 169 |
1717139 | 1717139 | 2021-09-14 | Alpena | Michigan | 26007 | 2573 | 67 |
1717140 | 1717140 | 2021-09-14 | Antrim | Michigan | 26009 | 1849 | 33 |
1717141 | 1717141 | 2021-09-14 | Arenac | Michigan | 26011 | 1341 | 31 |
1717142 | 1717142 | 2021-09-14 | Baraga | Michigan | 26013 | 1102 | 44 |
1717143 | 1717143 | 2021-09-14 | Barry | Michigan | 26015 | 6637 | 74 |
1717144 | 1717144 | 2021-09-14 | Bay | Michigan | 26017 | 12146 | 366 |
1717145 | 1717145 | 2021-09-14 | Benzie | Michigan | 26019 | 1396 | 38 |
1717146 | 1717146 | 2021-09-14 | Berrien | Michigan | 26021 | 17066 | 307 |
1717147 | 1717147 | 2021-09-14 | Branch | Michigan | 26023 | 6617 | 128 |
1717148 | 1717148 | 2021-09-14 | Calhoun | Michigan | 26025 | 16113 | 332 |
1717149 | 1717149 | 2021-09-14 | Cass | Michigan | 26027 | 6080 | 81 |
1717150 | 1717150 | 2021-09-14 | Charlevoix | Michigan | 26029 | 2011 | 28 |
1717151 | 1717151 | 2021-09-14 | Cheboygan | Michigan | 26031 | 2169 | 53 |
1717152 | 1717152 | 2021-09-14 | Chippewa | Michigan | 26033 | 5936 | 51 |
1717153 | 1717153 | 2021-09-14 | Clare | Michigan | 26035 | 2789 | 89 |
1717154 | 1717154 | 2021-09-14 | Clinton | Michigan | 26037 | 8368 | 98 |
1717155 | 1717155 | 2021-09-14 | Crawford | Michigan | 26039 | 1090 | 15 |
1717156 | 1717156 | 2021-09-14 | Delta | Michigan | 26041 | 4713 | 96 |
1717157 | 1717157 | 2021-09-14 | Dickinson | Michigan | 26043 | 3151 | 75 |
1717158 | 1717158 | 2021-09-14 | Eaton | Michigan | 26045 | 11272 | 218 |
1717159 | 1717159 | 2021-09-14 | Emmet | Michigan | 26047 | 2714 | 45 |
1717160 | 1717160 | 2021-09-14 | Genesee | Michigan | 26049 | 45509 | 1014 |
1717161 | 1717161 | 2021-09-14 | Gladwin | Michigan | 26051 | 2570 | 62 |
1717162 | 1717162 | 2021-09-14 | Gogebic | Michigan | 26053 | 1567 | 53 |
1717163 | 1717163 | 2021-09-14 | Grand Traverse | Michigan | 26055 | 7329 | 104 |
1717164 | 1717164 | 2021-09-14 | Gratiot | Michigan | 26057 | 7333 | 127 |
1717165 | 1717165 | 2021-09-14 | Hillsdale | Michigan | 26059 | 5058 | 102 |
1717166 | 1717166 | 2021-09-14 | Houghton | Michigan | 26061 | 3373 | 46 |
1717167 | 1717167 | 2021-09-14 | Huron | Michigan | 26063 | 4352 | 87 |
1717168 | 1717168 | 2021-09-14 | Ingham | Michigan | 26065 | 27259 | 421 |
1717169 | 1717169 | 2021-09-14 | Ionia | Michigan | 26067 | 10036 | 88 |
1717170 | 1717170 | 2021-09-14 | Iosco | Michigan | 26069 | 2287 | 81 |
1717171 | 1717171 | 2021-09-14 | Iron | Michigan | 26071 | 1211 | 53 |
1717172 | 1717172 | 2021-09-14 | Isabella | Michigan | 26073 | 7036 | 103 |
1717173 | 1717173 | 2021-09-14 | Jackson | Michigan | 26075 | 22930 | 337 |
1717174 | 1717174 | 2021-09-14 | Kalamazoo | Michigan | 26077 | 25941 | 426 |
1717175 | 1717175 | 2021-09-14 | Kalkaska | Michigan | 26079 | 1321 | 31 |
1717176 | 1717176 | 2021-09-14 | Kent | Michigan | 26081 | 80743 | 905 |
1717177 | 1717177 | 2021-09-14 | Keweenaw | Michigan | 26083 | 192 | 2 |
1717178 | 1717178 | 2021-09-14 | Lake | Michigan | 26085 | 758 | 17 |
1717179 | 1717179 | 2021-09-14 | Lapeer | Michigan | 26087 | 10552 | 226 |
1717180 | 1717180 | 2021-09-14 | Leelanau | Michigan | 26089 | 1401 | 22 |
1717181 | 1717181 | 2021-09-14 | Lenawee | Michigan | 26091 | 12026 | 185 |
1717182 | 1717182 | 2021-09-14 | Livingston | Michigan | 26093 | 19109 | 210 |
1717183 | 1717183 | 2021-09-14 | Luce | Michigan | 26095 | 1389 | 6 |
1717184 | 1717184 | 2021-09-14 | Mackinac | Michigan | 26097 | 876 | 4 |
1717185 | 1717185 | 2021-09-14 | Macomb | Michigan | 26099 | 108579 | 2562 |
1717186 | 1717186 | 2021-09-14 | Manistee | Michigan | 26101 | 2206 | 30 |
1717187 | 1717187 | 2021-09-14 | Marquette | Michigan | 26103 | 6437 | 68 |
1717188 | 1717188 | 2021-09-14 | Mason | Michigan | 26105 | 2505 | 41 |
1717189 | 1717189 | 2021-09-14 | Mecosta | Michigan | 26107 | 3584 | 39 |
1717190 | 1717190 | 2021-09-14 | Menominee | Michigan | 26109 | 2548 | 46 |
1717191 | 1717191 | 2021-09-14 | Midland | Michigan | 26111 | 8405 | 106 |
1717192 | 1717192 | 2021-09-14 | Missaukee | Michigan | 26113 | 1604 | 29 |
1717193 | 1717193 | 2021-09-14 | Monroe | Michigan | 26115 | 16960 | 278 |
1717194 | 1717194 | 2021-09-14 | Montcalm | Michigan | 26117 | 8800 | 126 |
1717195 | 1717195 | 2021-09-14 | Montmorency | Michigan | 26119 | 705 | 21 |
1717196 | 1717196 | 2021-09-14 | Muskegon | Michigan | 26121 | 20011 | 394 |
1717197 | 1717197 | 2021-09-14 | Newaygo | Michigan | 26123 | 5280 | 72 |
1717198 | 1717198 | 2021-09-14 | Oakland | Michigan | 26125 | 130259 | 2539 |
1717199 | 1717199 | 2021-09-14 | Oceana | Michigan | 26127 | 2969 | 62 |
1717200 | 1717200 | 2021-09-14 | Ogemaw | Michigan | 26129 | 1979 | 45 |
1717201 | 1717201 | 2021-09-14 | Ontonagon | Michigan | 26131 | 546 | 22 |
1717202 | 1717202 | 2021-09-14 | Osceola | Michigan | 26133 | 2190 | 31 |
1717203 | 1717203 | 2021-09-14 | Oscoda | Michigan | 26135 | 742 | 31 |
1717204 | 1717204 | 2021-09-14 | Otsego | Michigan | 26137 | 2622 | 43 |
1717205 | 1717205 | 2021-09-14 | Ottawa | Michigan | 26139 | 36153 | 459 |
1717206 | 1717206 | 2021-09-14 | Presque Isle | Michigan | 26141 | 1147 | 35 |
1717207 | 1717207 | 2021-09-14 | Roscommon | Michigan | 26143 | 2048 | 57 |
1717208 | 1717208 | 2021-09-14 | Saginaw | Michigan | 26145 | 24611 | 652 |
1717209 | 1717209 | 2021-09-14 | Sanilac | Michigan | 26151 | 4449 | 127 |
1717210 | 1717210 | 2021-09-14 | Schoolcraft | Michigan | 26153 | 525 | 5 |
1717211 | 1717211 | 2021-09-14 | Shiawassee | Michigan | 26155 | 7284 | 114 |
1717212 | 1717212 | 2021-09-14 | St. Clair | Michigan | 26147 | 19764 | 468 |
1717213 | 1717213 | 2021-09-14 | St. Joseph | Michigan | 26149 | 7003 | 104 |
1717214 | 1717214 | 2021-09-14 | Tuscola | Michigan | 26157 | 6134 | 181 |
1717215 | 1717215 | 2021-09-14 | Unknown | Michigan | 830 | 18 | |
1717216 | 1717216 | 2021-09-14 | Van Buren | Michigan | 26159 | 7859 | 148 |
1717217 | 1717217 | 2021-09-14 | Washtenaw | Michigan | 26161 | 29992 | 317 |
1717218 | 1717218 | 2021-09-14 | Wayne | Michigan | 26163 | 180274 | 5327 |
1717219 | 1717219 | 2021-09-14 | Wexford | Michigan | 26165 | 3043 | 50 |
1713888 | 1713888 | 2021-09-13 | Alcona | Michigan | 26001 | 851 | 37 |
1713889 | 1713889 | 2021-09-13 | Alger | Michigan | 26003 | 768 | 7 |
1713890 | 1713890 | 2021-09-13 | Allegan | Michigan | 26005 | 12462 | 169 |
1713891 | 1713891 | 2021-09-13 | Alpena | Michigan | 26007 | 2573 | 67 |
1713892 | 1713892 | 2021-09-13 | Antrim | Michigan | 26009 | 1839 | 33 |
1713893 | 1713893 | 2021-09-13 | Arenac | Michigan | 26011 | 1341 | 31 |
1713894 | 1713894 | 2021-09-13 | Baraga | Michigan | 26013 | 1102 | 44 |
1713895 | 1713895 | 2021-09-13 | Barry | Michigan | 26015 | 6637 | 74 |
1713896 | 1713896 | 2021-09-13 | Bay | Michigan | 26017 | 12146 | 366 |
1713897 | 1713897 | 2021-09-13 | Benzie | Michigan | 26019 | 1396 | 38 |
1713898 | 1713898 | 2021-09-13 | Berrien | Michigan | 26021 | 17004 | 306 |
1713899 | 1713899 | 2021-09-13 | Branch | Michigan | 26023 | 6617 | 128 |
1713900 | 1713900 | 2021-09-13 | Calhoun | Michigan | 26025 | 16113 | 332 |
1713901 | 1713901 | 2021-09-13 | Cass | Michigan | 26027 | 6080 | 81 |
1713902 | 1713902 | 2021-09-13 | Charlevoix | Michigan | 26029 | 2003 | 28 |
1713903 | 1713903 | 2021-09-13 | Cheboygan | Michigan | 26031 | 2169 | 53 |
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);