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 144
- 26163 144
- 26065 142
- 26081 142
- 26117 142
- 26147 142
- 26161 142
- 26017 141
- 26029 141
- 26089 141
- 26099 141
- 26115 140
- 26139 139
- 26075 137
- 26137 137
- 26037 135
- 26045 135
- 26049 135
- 26093 135
- 26111 135
- 26005 133
- 26015 133
- 26021 133
- 26025 133
- 26035 133
- 26145 133
- 26157 133
- 26165 133
- 26047 132
- 26051 132
- …
county >30
- Oakland 144
- Wayne 144
- Ingham 142
- Kent 142
- Montcalm 142
- St. Clair 142
- Washtenaw 142
- Bay 141
- Charlevoix 141
- Leelanau 141
- Macomb 141
- Monroe 140
- Ottawa 139
- Jackson 137
- Otsego 137
- Clinton 135
- Eaton 135
- Genesee 135
- Livingston 135
- Midland 135
- Allegan 133
- Barry 133
- Berrien 133
- Calhoun 133
- Clare 133
- Saginaw 133
- Tuscola 133
- Wexford 133
- Emmet 132
- Gladwin 132
- …
state 1
- Michigan · 10,518 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387175 | 387175 | 2020-07-31 | Alcona | Michigan | 26001 | 28 | 1 |
387176 | 387176 | 2020-07-31 | Alger | Michigan | 26003 | 8 | 0 |
387177 | 387177 | 2020-07-31 | Allegan | Michigan | 26005 | 495 | 7 |
387178 | 387178 | 2020-07-31 | Alpena | Michigan | 26007 | 125 | 13 |
387179 | 387179 | 2020-07-31 | Antrim | Michigan | 26009 | 36 | 0 |
387180 | 387180 | 2020-07-31 | Arenac | Michigan | 26011 | 40 | 3 |
387181 | 387181 | 2020-07-31 | Baraga | Michigan | 26013 | 5 | 0 |
387182 | 387182 | 2020-07-31 | Barry | Michigan | 26015 | 170 | 2 |
387183 | 387183 | 2020-07-31 | Bay | Michigan | 26017 | 539 | 31 |
387184 | 387184 | 2020-07-31 | Benzie | Michigan | 26019 | 27 | 1 |
387185 | 387185 | 2020-07-31 | Berrien | Michigan | 26021 | 1333 | 64 |
387186 | 387186 | 2020-07-31 | Branch | Michigan | 26023 | 1133 | 25 |
387187 | 387187 | 2020-07-31 | Calhoun | Michigan | 26025 | 728 | 41 |
387188 | 387188 | 2020-07-31 | Cass | Michigan | 26027 | 284 | 9 |
387189 | 387189 | 2020-07-31 | Charlevoix | Michigan | 26029 | 45 | 2 |
387190 | 387190 | 2020-07-31 | Cheboygan | Michigan | 26031 | 37 | 2 |
387191 | 387191 | 2020-07-31 | Chippewa | Michigan | 26033 | 30 | 0 |
387192 | 387192 | 2020-07-31 | Clare | Michigan | 26035 | 58 | 3 |
387193 | 387193 | 2020-07-31 | Clinton | Michigan | 26037 | 404 | 13 |
387194 | 387194 | 2020-07-31 | Crawford | Michigan | 26039 | 94 | 5 |
387195 | 387195 | 2020-07-31 | Delta | Michigan | 26041 | 72 | 3 |
387196 | 387196 | 2020-07-31 | Dickinson | Michigan | 26043 | 44 | 2 |
387197 | 387197 | 2020-07-31 | Eaton | Michigan | 26045 | 447 | 7 |
387198 | 387198 | 2020-07-31 | Emmet | Michigan | 26047 | 58 | 2 |
387199 | 387199 | 2020-07-31 | Genesee | Michigan | 26049 | 3463 | 294 |
387200 | 387200 | 2020-07-31 | Gladwin | Michigan | 26051 | 51 | 2 |
387201 | 387201 | 2020-07-31 | Gogebic | Michigan | 26053 | 83 | 1 |
387202 | 387202 | 2020-07-31 | Grand Traverse | Michigan | 26055 | 195 | 5 |
387203 | 387203 | 2020-07-31 | Gratiot | Michigan | 26057 | 149 | 15 |
387204 | 387204 | 2020-07-31 | Hillsdale | Michigan | 26059 | 246 | 25 |
387205 | 387205 | 2020-07-31 | Houghton | Michigan | 26061 | 47 | 0 |
387206 | 387206 | 2020-07-31 | Huron | Michigan | 26063 | 146 | 4 |
387207 | 387207 | 2020-07-31 | Ingham | Michigan | 26065 | 1459 | 30 |
387208 | 387208 | 2020-07-31 | Ionia | Michigan | 26067 | 269 | 5 |
387209 | 387209 | 2020-07-31 | Iosco | Michigan | 26069 | 129 | 12 |
387210 | 387210 | 2020-07-31 | Iron | Michigan | 26071 | 17 | 1 |
387211 | 387211 | 2020-07-31 | Isabella | Michigan | 26073 | 199 | 8 |
387212 | 387212 | 2020-07-31 | Jackson | Michigan | 26075 | 2392 | 55 |
387213 | 387213 | 2020-07-31 | Kalamazoo | Michigan | 26077 | 1522 | 80 |
387214 | 387214 | 2020-07-31 | Kalkaska | Michigan | 26079 | 49 | 4 |
387215 | 387215 | 2020-07-31 | Kent | Michigan | 26081 | 7059 | 154 |
387216 | 387216 | 2020-07-31 | Keweenaw | Michigan | 26083 | 3 | 0 |
387217 | 387217 | 2020-07-31 | Lake | Michigan | 26085 | 16 | 0 |
387218 | 387218 | 2020-07-31 | Lapeer | Michigan | 26087 | 711 | 39 |
387219 | 387219 | 2020-07-31 | Leelanau | Michigan | 26089 | 64 | 0 |
387220 | 387220 | 2020-07-31 | Lenawee | Michigan | 26091 | 1118 | 16 |
387221 | 387221 | 2020-07-31 | Livingston | Michigan | 26093 | 812 | 29 |
387222 | 387222 | 2020-07-31 | Luce | Michigan | 26095 | 4 | 0 |
387223 | 387223 | 2020-07-31 | Mackinac | Michigan | 26097 | 20 | 0 |
387224 | 387224 | 2020-07-31 | Macomb | Michigan | 26099 | 9689 | 941 |
387225 | 387225 | 2020-07-31 | Manistee | Michigan | 26101 | 43 | 0 |
387226 | 387226 | 2020-07-31 | Marquette | Michigan | 26103 | 127 | 11 |
387227 | 387227 | 2020-07-31 | Mason | Michigan | 26105 | 96 | 0 |
387228 | 387228 | 2020-07-31 | Mecosta | Michigan | 26107 | 55 | 2 |
387229 | 387229 | 2020-07-31 | Menominee | Michigan | 26109 | 86 | 0 |
387230 | 387230 | 2020-07-31 | Midland | Michigan | 26111 | 292 | 9 |
387231 | 387231 | 2020-07-31 | Missaukee | Michigan | 26113 | 40 | 1 |
387232 | 387232 | 2020-07-31 | Monroe | Michigan | 26115 | 867 | 22 |
387233 | 387233 | 2020-07-31 | Montcalm | Michigan | 26117 | 176 | 1 |
387234 | 387234 | 2020-07-31 | Montmorency | Michigan | 26119 | 8 | 0 |
387235 | 387235 | 2020-07-31 | Muskegon | Michigan | 26121 | 1125 | 57 |
387236 | 387236 | 2020-07-31 | Newaygo | Michigan | 26123 | 247 | 0 |
387237 | 387237 | 2020-07-31 | Oakland | Michigan | 26125 | 14614 | 1126 |
387238 | 387238 | 2020-07-31 | Oceana | Michigan | 26127 | 461 | 6 |
387239 | 387239 | 2020-07-31 | Ogemaw | Michigan | 26129 | 50 | 2 |
387240 | 387240 | 2020-07-31 | Ontonagon | Michigan | 26131 | 4 | 0 |
387241 | 387241 | 2020-07-31 | Osceola | Michigan | 26133 | 66 | 0 |
387242 | 387242 | 2020-07-31 | Oscoda | Michigan | 26135 | 24 | 1 |
387243 | 387243 | 2020-07-31 | Otsego | Michigan | 26137 | 142 | 10 |
387244 | 387244 | 2020-07-31 | Ottawa | Michigan | 26139 | 1686 | 54 |
387245 | 387245 | 2020-07-31 | Presque Isle | Michigan | 26141 | 15 | 1 |
387246 | 387246 | 2020-07-31 | Roscommon | Michigan | 26143 | 47 | 0 |
387247 | 387247 | 2020-07-31 | Saginaw | Michigan | 26145 | 1826 | 129 |
387248 | 387248 | 2020-07-31 | Sanilac | Michigan | 26151 | 92 | 6 |
387249 | 387249 | 2020-07-31 | Schoolcraft | Michigan | 26153 | 8 | 0 |
387250 | 387250 | 2020-07-31 | Shiawassee | Michigan | 26155 | 321 | 28 |
387251 | 387251 | 2020-07-31 | St. Clair | Michigan | 26147 | 756 | 53 |
387252 | 387252 | 2020-07-31 | St. Joseph | Michigan | 26149 | 549 | 7 |
387253 | 387253 | 2020-07-31 | Tuscola | Michigan | 26157 | 300 | 27 |
387254 | 387254 | 2020-07-31 | Unknown | Michigan | 30 | 3 | |
387255 | 387255 | 2020-07-31 | Van Buren | Michigan | 26159 | 394 | 11 |
387256 | 387256 | 2020-07-31 | Washtenaw | Michigan | 26161 | 2894 | 122 |
387257 | 387257 | 2020-07-31 | Wayne | Michigan | 26163 | 27092 | 2804 |
387258 | 387258 | 2020-07-31 | Wexford | Michigan | 26165 | 67 | 4 |
383957 | 383957 | 2020-07-30 | Alcona | Michigan | 26001 | 28 | 1 |
383958 | 383958 | 2020-07-30 | Alger | Michigan | 26003 | 6 | 0 |
383959 | 383959 | 2020-07-30 | Allegan | Michigan | 26005 | 485 | 7 |
383960 | 383960 | 2020-07-30 | Alpena | Michigan | 26007 | 125 | 13 |
383961 | 383961 | 2020-07-30 | Antrim | Michigan | 26009 | 35 | 0 |
383962 | 383962 | 2020-07-30 | Arenac | Michigan | 26011 | 40 | 3 |
383963 | 383963 | 2020-07-30 | Baraga | Michigan | 26013 | 5 | 0 |
383964 | 383964 | 2020-07-30 | Barry | Michigan | 26015 | 169 | 2 |
383965 | 383965 | 2020-07-30 | Bay | Michigan | 26017 | 536 | 31 |
383966 | 383966 | 2020-07-30 | Benzie | Michigan | 26019 | 28 | 1 |
383967 | 383967 | 2020-07-30 | Berrien | Michigan | 26021 | 1326 | 64 |
383968 | 383968 | 2020-07-30 | Branch | Michigan | 26023 | 1127 | 25 |
383969 | 383969 | 2020-07-30 | Calhoun | Michigan | 26025 | 717 | 41 |
383970 | 383970 | 2020-07-30 | Cass | Michigan | 26027 | 272 | 9 |
383971 | 383971 | 2020-07-30 | Charlevoix | Michigan | 26029 | 45 | 2 |
383972 | 383972 | 2020-07-30 | Cheboygan | Michigan | 26031 | 37 | 2 |
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);