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 84
- 26125 392
- 26163 392
- 26065 390
- 26081 390
- 26117 390
- 26147 390
- 26161 390
- 26089 389
- 26099 389
- 26017 388
- 26029 388
- 26115 388
- 26139 387
- 26075 385
- 26137 385
- 26037 383
- 26045 383
- 26049 383
- 26093 383
- 26111 383
- 26035 381
- 26145 381
- 26157 381
- 26165 381
- 26005 380
- 26015 380
- 26021 380
- 26025 380
- 26047 380
- 26051 380
- 26055 380
- 26143 380
- 26033 379
- 26077 379
- 26121 379
- 26123 379
- 26059 378
- 26073 378
- 26079 378
- 26087 378
- 26101 378
- 26069 377
- 26091 377
- 26103 377
- 26151 377
- 26159 377
- 26053 376
- 26067 376
- 26107 376
- 26113 376
- 26127 376
- 26129 376
- 26155 376
- 26039 375
- 26057 375
- 26063 375
- - 375
- 26027 374
- 26133 374
- 26031 372
- 26041 372
- 26061 372
- 26149 372
- 26009 371
- 26135 371
- 26011 370
- 26023 370
- 26097 370
- 26043 369
- 26095 368
- 26141 365
- 26105 364
- 26153 363
- 26109 361
- 26085 360
- 26007 359
- 26119 358
- 26001 355
- 26013 354
- 26019 352
- 26071 308
- 26083 300
- 26003 299
- 26131 276
county 84
- Oakland 392
- Wayne 392
- Ingham 390
- Kent 390
- Montcalm 390
- St. Clair 390
- Washtenaw 390
- Leelanau 389
- Macomb 389
- Bay 388
- Charlevoix 388
- Monroe 388
- Ottawa 387
- Jackson 385
- Otsego 385
- Clinton 383
- Eaton 383
- Genesee 383
- Livingston 383
- Midland 383
- Clare 381
- Saginaw 381
- Tuscola 381
- Wexford 381
- Allegan 380
- Barry 380
- Berrien 380
- Calhoun 380
- Emmet 380
- Gladwin 380
- Grand Traverse 380
- Roscommon 380
- Chippewa 379
- Kalamazoo 379
- Muskegon 379
- Newaygo 379
- Hillsdale 378
- Isabella 378
- Kalkaska 378
- Lapeer 378
- Manistee 378
- Iosco 377
- Lenawee 377
- Marquette 377
- Sanilac 377
- Van Buren 377
- Gogebic 376
- Ionia 376
- Mecosta 376
- Missaukee 376
- Oceana 376
- Ogemaw 376
- Shiawassee 376
- Crawford 375
- Gratiot 375
- Huron 375
- Unknown 375
- Cass 374
- Osceola 374
- Cheboygan 372
- Delta 372
- Houghton 372
- St. Joseph 372
- Antrim 371
- Oscoda 371
- Arenac 370
- Branch 370
- Mackinac 370
- Dickinson 369
- Luce 368
- Presque Isle 365
- Mason 364
- Schoolcraft 363
- Menominee 361
- Lake 360
- Alpena 359
- Montmorency 358
- Alcona 355
- Baraga 354
- Benzie 352
- Iron 308
- Keweenaw 300
- Alger 299
- Ontonagon 276
state 1
- Michigan · 31,334 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1191118 | 1191118 | 2021-04-05 | Chippewa | Michigan | 26033 | 5209 | 46 |
1191119 | 1191119 | 2021-04-05 | Clare | Michigan | 26035 | 1803 | 69 |
1191120 | 1191120 | 2021-04-05 | Clinton | Michigan | 26037 | 6221 | 75 |
1191121 | 1191121 | 2021-04-05 | Crawford | Michigan | 26039 | 779 | 6 |
1191122 | 1191122 | 2021-04-05 | Delta | Michigan | 26041 | 3360 | 87 |
1191123 | 1191123 | 2021-04-05 | Dickinson | Michigan | 26043 | 2471 | 71 |
1191124 | 1191124 | 2021-04-05 | Eaton | Michigan | 26045 | 8031 | 162 |
1191125 | 1191125 | 2021-04-05 | Emmet | Michigan | 26047 | 1800 | 40 |
1191126 | 1191126 | 2021-04-05 | Genesee | Michigan | 26049 | 31888 | 787 |
1191127 | 1191127 | 2021-04-05 | Gladwin | Michigan | 26051 | 1700 | 43 |
1191128 | 1191128 | 2021-04-05 | Gogebic | Michigan | 26053 | 1330 | 50 |
1191129 | 1191129 | 2021-04-05 | Grand Traverse | Michigan | 26055 | 5218 | 78 |
1191130 | 1191130 | 2021-04-05 | Gratiot | Michigan | 26057 | 5989 | 110 |
1191131 | 1191131 | 2021-04-05 | Hillsdale | Michigan | 26059 | 3731 | 80 |
1191132 | 1191132 | 2021-04-05 | Houghton | Michigan | 26061 | 2869 | 40 |
1191133 | 1191133 | 2021-04-05 | Huron | Michigan | 26063 | 3134 | 62 |
1191134 | 1191134 | 2021-04-05 | Ingham | Michigan | 26065 | 20352 | 308 |
1191135 | 1191135 | 2021-04-05 | Ionia | Michigan | 26067 | 7757 | 79 |
1191136 | 1191136 | 2021-04-05 | Iosco | Michigan | 26069 | 1495 | 67 |
1191137 | 1191137 | 2021-04-05 | Iron | Michigan | 26071 | 947 | 51 |
1191138 | 1191138 | 2021-04-05 | Isabella | Michigan | 26073 | 4684 | 78 |
1191139 | 1191139 | 2021-04-05 | Jackson | Michigan | 26075 | 17350 | 266 |
1191140 | 1191140 | 2021-04-05 | Kalamazoo | Michigan | 26077 | 18041 | 329 |
1191141 | 1191141 | 2021-04-05 | Kalkaska | Michigan | 26079 | 820 | 16 |
1191142 | 1191142 | 2021-04-05 | Kent | Michigan | 26081 | 58303 | 749 |
1191143 | 1191143 | 2021-04-05 | Keweenaw | Michigan | 26083 | 155 | 2 |
1191144 | 1191144 | 2021-04-05 | Lake | Michigan | 26085 | 458 | 12 |
1191145 | 1191145 | 2021-04-05 | Lapeer | Michigan | 26087 | 7434 | 148 |
1191146 | 1191146 | 2021-04-05 | Leelanau | Michigan | 26089 | 1018 | 16 |
1191147 | 1191147 | 2021-04-05 | Lenawee | Michigan | 26091 | 8716 | 140 |
1191148 | 1191148 | 2021-04-05 | Livingston | Michigan | 26093 | 12940 | 158 |
1191149 | 1191149 | 2021-04-05 | Luce | Michigan | 26095 | 1135 | 2 |
1191150 | 1191150 | 2021-04-05 | Mackinac | Michigan | 26097 | 497 | 3 |
1191151 | 1191151 | 2021-04-05 | Macomb | Michigan | 26099 | 77720 | 2053 |
1191152 | 1191152 | 2021-04-05 | Manistee | Michigan | 26101 | 1674 | 23 |
1191153 | 1191153 | 2021-04-05 | Marquette | Michigan | 26103 | 5178 | 57 |
1191154 | 1191154 | 2021-04-05 | Mason | Michigan | 26105 | 1481 | 27 |
1191155 | 1191155 | 2021-04-05 | Mecosta | Michigan | 26107 | 2385 | 23 |
1191156 | 1191156 | 2021-04-05 | Menominee | Michigan | 26109 | 1943 | 41 |
1191157 | 1191157 | 2021-04-05 | Midland | Michigan | 26111 | 5811 | 70 |
1191158 | 1191158 | 2021-04-05 | Missaukee | Michigan | 26113 | 1158 | 20 |
1191159 | 1191159 | 2021-04-05 | Monroe | Michigan | 26115 | 12180 | 214 |
1191160 | 1191160 | 2021-04-05 | Montcalm | Michigan | 26117 | 6310 | 97 |
1191161 | 1191161 | 2021-04-05 | Montmorency | Michigan | 26119 | 411 | 18 |
1191162 | 1191162 | 2021-04-05 | Muskegon | Michigan | 26121 | 13724 | 318 |
1191163 | 1191163 | 2021-04-05 | Newaygo | Michigan | 26123 | 3497 | 54 |
1191164 | 1191164 | 2021-04-05 | Oakland | Michigan | 26125 | 92253 | 2070 |
1191165 | 1191165 | 2021-04-05 | Oceana | Michigan | 26127 | 2087 | 51 |
1191166 | 1191166 | 2021-04-05 | Ogemaw | Michigan | 26129 | 1220 | 34 |
1191167 | 1191167 | 2021-04-05 | Ontonagon | Michigan | 26131 | 433 | 21 |
1191168 | 1191168 | 2021-04-05 | Osceola | Michigan | 26133 | 1401 | 24 |
1191169 | 1191169 | 2021-04-05 | Oscoda | Michigan | 26135 | 480 | 20 |
1191170 | 1191170 | 2021-04-05 | Otsego | Michigan | 26137 | 1775 | 28 |
1191171 | 1191171 | 2021-04-05 | Ottawa | Michigan | 26139 | 25765 | 372 |
1191172 | 1191172 | 2021-04-05 | Presque Isle | Michigan | 26141 | 784 | 29 |
1191173 | 1191173 | 2021-04-05 | Roscommon | Michigan | 26143 | 1547 | 42 |
1191174 | 1191174 | 2021-04-05 | Saginaw | Michigan | 26145 | 17792 | 544 |
1191175 | 1191175 | 2021-04-05 | Sanilac | Michigan | 26151 | 3183 | 86 |
1191176 | 1191176 | 2021-04-05 | Schoolcraft | Michigan | 26153 | 316 | 5 |
1191177 | 1191177 | 2021-04-05 | Shiawassee | Michigan | 26155 | 4736 | 85 |
1191178 | 1191178 | 2021-04-05 | St. Clair | Michigan | 26147 | 13282 | 285 |
1191179 | 1191179 | 2021-04-05 | St. Joseph | Michigan | 26149 | 5261 | 91 |
1191180 | 1191180 | 2021-04-05 | Tuscola | Michigan | 26157 | 4298 | 142 |
1191181 | 1191181 | 2021-04-05 | Unknown | Michigan | 0 | 13 | |
1191182 | 1191182 | 2021-04-05 | Van Buren | Michigan | 26159 | 5763 | 100 |
1191183 | 1191183 | 2021-04-05 | Washtenaw | Michigan | 26161 | 22264 | 262 |
1191184 | 1191184 | 2021-04-05 | Wayne | Michigan | 26163 | 125421 | 4297 |
1191185 | 1191185 | 2021-04-05 | Wexford | Michigan | 26165 | 2156 | 25 |
1187854 | 1187854 | 2021-04-04 | Alcona | Michigan | 26001 | 499 | 25 |
1187855 | 1187855 | 2021-04-04 | Alger | Michigan | 26003 | 606 | 5 |
1187856 | 1187856 | 2021-04-04 | Allegan | Michigan | 26005 | 8478 | 118 |
1187857 | 1187857 | 2021-04-04 | Alpena | Michigan | 26007 | 1651 | 50 |
1187858 | 1187858 | 2021-04-04 | Antrim | Michigan | 26009 | 1234 | 20 |
1187859 | 1187859 | 2021-04-04 | Arenac | Michigan | 26011 | 820 | 27 |
1187860 | 1187860 | 2021-04-04 | Baraga | Michigan | 26013 | 798 | 34 |
1187861 | 1187861 | 2021-04-04 | Barry | Michigan | 26015 | 4344 | 52 |
1187862 | 1187862 | 2021-04-04 | Bay | Michigan | 26017 | 8527 | 308 |
1187863 | 1187863 | 2021-04-04 | Benzie | Michigan | 26019 | 1018 | 32 |
1187864 | 1187864 | 2021-04-04 | Berrien | Michigan | 26021 | 13081 | 252 |
1187865 | 1187865 | 2021-04-04 | Branch | Michigan | 26023 | 4898 | 112 |
1187866 | 1187866 | 2021-04-04 | Calhoun | Michigan | 26025 | 11443 | 247 |
1187867 | 1187867 | 2021-04-04 | Cass | Michigan | 26027 | 4669 | 68 |
1187868 | 1187868 | 2021-04-04 | Charlevoix | Michigan | 26029 | 1220 | 13 |
1187869 | 1187869 | 2021-04-04 | Cheboygan | Michigan | 26031 | 1334 | 38 |
1187870 | 1187870 | 2021-04-04 | Chippewa | Michigan | 26033 | 5204 | 46 |
1187871 | 1187871 | 2021-04-04 | Clare | Michigan | 26035 | 1782 | 69 |
1187872 | 1187872 | 2021-04-04 | Clinton | Michigan | 26037 | 6090 | 75 |
1187873 | 1187873 | 2021-04-04 | Crawford | Michigan | 26039 | 761 | 6 |
1187874 | 1187874 | 2021-04-04 | Delta | Michigan | 26041 | 3341 | 86 |
1187875 | 1187875 | 2021-04-04 | Dickinson | Michigan | 26043 | 2466 | 71 |
1187876 | 1187876 | 2021-04-04 | Eaton | Michigan | 26045 | 7895 | 162 |
1187877 | 1187877 | 2021-04-04 | Emmet | Michigan | 26047 | 1767 | 40 |
1187878 | 1187878 | 2021-04-04 | Genesee | Michigan | 26049 | 31410 | 787 |
1187879 | 1187879 | 2021-04-04 | Gladwin | Michigan | 26051 | 1675 | 43 |
1187880 | 1187880 | 2021-04-04 | Gogebic | Michigan | 26053 | 1331 | 50 |
1187881 | 1187881 | 2021-04-04 | Grand Traverse | Michigan | 26055 | 5085 | 77 |
1187882 | 1187882 | 2021-04-04 | Gratiot | Michigan | 26057 | 5932 | 110 |
1187883 | 1187883 | 2021-04-04 | Hillsdale | Michigan | 26059 | 3710 | 79 |
1187884 | 1187884 | 2021-04-04 | Houghton | Michigan | 26061 | 2854 | 40 |
1187885 | 1187885 | 2021-04-04 | Huron | Michigan | 26063 | 3093 | 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);