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 582
- 26163 582
- 26065 580
- 26081 580
- 26117 580
- 26147 580
- 26161 580
- 26017 579
- 26029 579
- 26089 579
- 26099 579
- 26115 578
- 26139 577
- 26075 575
- 26137 575
- 26037 573
- 26045 573
- 26049 573
- 26093 573
- 26111 573
- 26005 571
- 26015 571
- 26021 571
- 26025 571
- 26035 571
- 26145 571
- 26157 571
- 26165 571
- 26047 570
- 26051 570
- …
county >30
- Oakland 582
- Wayne 582
- Ingham 580
- Kent 580
- Montcalm 580
- St. Clair 580
- Washtenaw 580
- Bay 579
- Charlevoix 579
- Leelanau 579
- Macomb 579
- Monroe 578
- Ottawa 577
- Jackson 575
- Otsego 575
- Clinton 573
- Eaton 573
- Genesee 573
- Livingston 573
- Midland 573
- Allegan 571
- Barry 571
- Berrien 571
- Calhoun 571
- Clare 571
- Saginaw 571
- Tuscola 571
- Wexford 571
- Emmet 570
- Gladwin 570
- …
state 1
- Michigan · 47,310 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1808112 | 1808112 | 2021-10-12 | Alcona | Michigan | 26001 | 998 | 39 |
1808113 | 1808113 | 2021-10-12 | Alger | Michigan | 26003 | 953 | 8 |
1808114 | 1808114 | 2021-10-12 | Allegan | Michigan | 26005 | 13859 | 180 |
1808115 | 1808115 | 2021-10-12 | Alpena | Michigan | 26007 | 2885 | 69 |
1808116 | 1808116 | 2021-10-12 | Antrim | Michigan | 26009 | 2202 | 35 |
1808117 | 1808117 | 2021-10-12 | Arenac | Michigan | 26011 | 1591 | 32 |
1808118 | 1808118 | 2021-10-12 | Baraga | Michigan | 26013 | 1199 | 46 |
1808119 | 1808119 | 2021-10-12 | Barry | Michigan | 26015 | 7322 | 78 |
1808120 | 1808120 | 2021-10-12 | Bay | Michigan | 26017 | 13837 | 376 |
1808121 | 1808121 | 2021-10-12 | Benzie | Michigan | 26019 | 1568 | 38 |
1808122 | 1808122 | 2021-10-12 | Berrien | Michigan | 26021 | 18585 | 322 |
1808123 | 1808123 | 2021-10-12 | Branch | Michigan | 26023 | 7030 | 135 |
1808124 | 1808124 | 2021-10-12 | Calhoun | Michigan | 26025 | 17799 | 341 |
1808125 | 1808125 | 2021-10-12 | Cass | Michigan | 26027 | 6805 | 87 |
1808126 | 1808126 | 2021-10-12 | Charlevoix | Michigan | 26029 | 2342 | 31 |
1808127 | 1808127 | 2021-10-12 | Cheboygan | Michigan | 26031 | 2628 | 62 |
1808128 | 1808128 | 2021-10-12 | Chippewa | Michigan | 26033 | 6592 | 56 |
1808129 | 1808129 | 2021-10-12 | Clare | Michigan | 26035 | 3390 | 95 |
1808130 | 1808130 | 2021-10-12 | Clinton | Michigan | 26037 | 9410 | 103 |
1808131 | 1808131 | 2021-10-12 | Crawford | Michigan | 26039 | 1202 | 16 |
1808132 | 1808132 | 2021-10-12 | Delta | Michigan | 26041 | 5436 | 102 |
1808133 | 1808133 | 2021-10-12 | Dickinson | Michigan | 26043 | 3752 | 78 |
1808134 | 1808134 | 2021-10-12 | Eaton | Michigan | 26045 | 12494 | 233 |
1808135 | 1808135 | 2021-10-12 | Emmet | Michigan | 26047 | 3193 | 49 |
1808136 | 1808136 | 2021-10-12 | Genesee | Michigan | 26049 | 49156 | 1048 |
1808137 | 1808137 | 2021-10-12 | Gladwin | Michigan | 26051 | 3043 | 67 |
1808138 | 1808138 | 2021-10-12 | Gogebic | Michigan | 26053 | 1741 | 53 |
1808139 | 1808139 | 2021-10-12 | Grand Traverse | Michigan | 26055 | 8357 | 113 |
1808140 | 1808140 | 2021-10-12 | Gratiot | Michigan | 26057 | 8154 | 128 |
1808141 | 1808141 | 2021-10-12 | Hillsdale | Michigan | 26059 | 5804 | 114 |
1808142 | 1808142 | 2021-10-12 | Houghton | Michigan | 26061 | 3722 | 54 |
1808143 | 1808143 | 2021-10-12 | Huron | Michigan | 26063 | 4584 | 89 |
1808144 | 1808144 | 2021-10-12 | Ingham | Michigan | 26065 | 29623 | 437 |
1808145 | 1808145 | 2021-10-12 | Ionia | Michigan | 26067 | 11202 | 95 |
1808146 | 1808146 | 2021-10-12 | Iosco | Michigan | 26069 | 2725 | 88 |
1808147 | 1808147 | 2021-10-12 | Iron | Michigan | 26071 | 1337 | 54 |
1808148 | 1808148 | 2021-10-12 | Isabella | Michigan | 26073 | 8319 | 109 |
1808149 | 1808149 | 2021-10-12 | Jackson | Michigan | 26075 | 24595 | 351 |
1808150 | 1808150 | 2021-10-12 | Kalamazoo | Michigan | 26077 | 28289 | 439 |
1808151 | 1808151 | 2021-10-12 | Kalkaska | Michigan | 26079 | 1631 | 33 |
1808152 | 1808152 | 2021-10-12 | Kent | Michigan | 26081 | 88468 | 955 |
1808153 | 1808153 | 2021-10-12 | Keweenaw | Michigan | 26083 | 229 | 4 |
1808154 | 1808154 | 2021-10-12 | Lake | Michigan | 26085 | 888 | 19 |
1808155 | 1808155 | 2021-10-12 | Lapeer | Michigan | 26087 | 11504 | 243 |
1808156 | 1808156 | 2021-10-12 | Leelanau | Michigan | 26089 | 1558 | 24 |
1808157 | 1808157 | 2021-10-12 | Lenawee | Michigan | 26091 | 13614 | 195 |
1808158 | 1808158 | 2021-10-12 | Livingston | Michigan | 26093 | 21583 | 229 |
1808159 | 1808159 | 2021-10-12 | Luce | Michigan | 26095 | 1521 | 6 |
1808160 | 1808160 | 2021-10-12 | Mackinac | Michigan | 26097 | 1158 | 7 |
1808161 | 1808161 | 2021-10-12 | Macomb | Michigan | 26099 | 116751 | 2625 |
1808162 | 1808162 | 2021-10-12 | Manistee | Michigan | 26101 | 2372 | 34 |
1808163 | 1808163 | 2021-10-12 | Marquette | Michigan | 26103 | 7518 | 73 |
1808164 | 1808164 | 2021-10-12 | Mason | Michigan | 26105 | 2892 | 44 |
1808165 | 1808165 | 2021-10-12 | Mecosta | Michigan | 26107 | 4306 | 41 |
1808166 | 1808166 | 2021-10-12 | Menominee | Michigan | 26109 | 3117 | 48 |
1808167 | 1808167 | 2021-10-12 | Midland | Michigan | 26111 | 9624 | 125 |
1808168 | 1808168 | 2021-10-12 | Missaukee | Michigan | 26113 | 1765 | 31 |
1808169 | 1808169 | 2021-10-12 | Monroe | Michigan | 26115 | 19117 | 294 |
1808170 | 1808170 | 2021-10-12 | Montcalm | Michigan | 26117 | 10009 | 128 |
1808171 | 1808171 | 2021-10-12 | Montmorency | Michigan | 26119 | 835 | 24 |
1808172 | 1808172 | 2021-10-12 | Muskegon | Michigan | 26121 | 22235 | 414 |
1808173 | 1808173 | 2021-10-12 | Newaygo | Michigan | 26123 | 6188 | 78 |
1808174 | 1808174 | 2021-10-12 | Oakland | Michigan | 26125 | 139998 | 2617 |
1808175 | 1808175 | 2021-10-12 | Oceana | Michigan | 26127 | 3493 | 67 |
1808176 | 1808176 | 2021-10-12 | Ogemaw | Michigan | 26129 | 2513 | 49 |
1808177 | 1808177 | 2021-10-12 | Ontonagon | Michigan | 26131 | 585 | 22 |
1808178 | 1808178 | 2021-10-12 | Osceola | Michigan | 26133 | 2722 | 34 |
1808179 | 1808179 | 2021-10-12 | Oscoda | Michigan | 26135 | 878 | 32 |
1808180 | 1808180 | 2021-10-12 | Otsego | Michigan | 26137 | 3046 | 50 |
1808181 | 1808181 | 2021-10-12 | Ottawa | Michigan | 26139 | 39284 | 483 |
1808182 | 1808182 | 2021-10-12 | Presque Isle | Michigan | 26141 | 1281 | 36 |
1808183 | 1808183 | 2021-10-12 | Roscommon | Michigan | 26143 | 2275 | 61 |
1808184 | 1808184 | 2021-10-12 | Saginaw | Michigan | 26145 | 26926 | 666 |
1808185 | 1808185 | 2021-10-12 | Sanilac | Michigan | 26151 | 4752 | 131 |
1808186 | 1808186 | 2021-10-12 | Schoolcraft | Michigan | 26153 | 723 | 5 |
1808187 | 1808187 | 2021-10-12 | Shiawassee | Michigan | 26155 | 8104 | 122 |
1808188 | 1808188 | 2021-10-12 | St. Clair | Michigan | 26147 | 21433 | 498 |
1808189 | 1808189 | 2021-10-12 | St. Joseph | Michigan | 26149 | 7925 | 115 |
1808190 | 1808190 | 2021-10-12 | Tuscola | Michigan | 26157 | 6990 | 186 |
1808191 | 1808191 | 2021-10-12 | Unknown | Michigan | 695 | 13 | |
1808192 | 1808192 | 2021-10-12 | Van Buren | Michigan | 26159 | 8780 | 155 |
1808193 | 1808193 | 2021-10-12 | Washtenaw | Michigan | 26161 | 32529 | 328 |
1808194 | 1808194 | 2021-10-12 | Wayne | Michigan | 26163 | 191660 | 5473 |
1808195 | 1808195 | 2021-10-12 | Wexford | Michigan | 26165 | 3395 | 51 |
1804861 | 1804861 | 2021-10-11 | Alcona | Michigan | 26001 | 998 | 39 |
1804862 | 1804862 | 2021-10-11 | Alger | Michigan | 26003 | 953 | 8 |
1804863 | 1804863 | 2021-10-11 | Allegan | Michigan | 26005 | 13859 | 180 |
1804864 | 1804864 | 2021-10-11 | Alpena | Michigan | 26007 | 2885 | 69 |
1804865 | 1804865 | 2021-10-11 | Antrim | Michigan | 26009 | 2191 | 35 |
1804866 | 1804866 | 2021-10-11 | Arenac | Michigan | 26011 | 1591 | 32 |
1804867 | 1804867 | 2021-10-11 | Baraga | Michigan | 26013 | 1199 | 46 |
1804868 | 1804868 | 2021-10-11 | Barry | Michigan | 26015 | 7322 | 78 |
1804869 | 1804869 | 2021-10-11 | Bay | Michigan | 26017 | 13837 | 376 |
1804870 | 1804870 | 2021-10-11 | Benzie | Michigan | 26019 | 1568 | 38 |
1804871 | 1804871 | 2021-10-11 | Berrien | Michigan | 26021 | 18585 | 322 |
1804872 | 1804872 | 2021-10-11 | Branch | Michigan | 26023 | 7030 | 135 |
1804873 | 1804873 | 2021-10-11 | Calhoun | Michigan | 26025 | 17799 | 341 |
1804874 | 1804874 | 2021-10-11 | Cass | Michigan | 26027 | 6805 | 87 |
1804875 | 1804875 | 2021-10-11 | Charlevoix | Michigan | 26029 | 2330 | 31 |
1804876 | 1804876 | 2021-10-11 | Cheboygan | Michigan | 26031 | 2628 | 62 |
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);