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 393
- 26163 393
- 26065 391
- 26081 391
- 26117 391
- 26147 391
- 26161 391
- 26017 390
- 26029 390
- 26089 390
- 26099 390
- 26115 389
- 26139 388
- 26075 386
- 26137 386
- 26037 384
- 26045 384
- 26049 384
- 26093 384
- 26111 384
- 26005 382
- 26015 382
- 26021 382
- 26025 382
- 26035 382
- 26145 382
- 26157 382
- 26165 382
- 26047 381
- 26051 381
- …
county >30
- Oakland 393
- Wayne 393
- Ingham 391
- Kent 391
- Montcalm 391
- St. Clair 391
- Washtenaw 391
- Bay 390
- Charlevoix 390
- Leelanau 390
- Macomb 390
- Monroe 389
- Ottawa 388
- Jackson 386
- Otsego 386
- Clinton 384
- Eaton 384
- Genesee 384
- Livingston 384
- Midland 384
- Allegan 382
- Barry 382
- Berrien 382
- Calhoun 382
- Clare 382
- Saginaw 382
- Tuscola 382
- Wexford 382
- Emmet 381
- Gladwin 381
- …
state 1
- Michigan · 31,434 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194351 | 1194351 | 2021-04-06 | Alcona | Michigan | 26001 | 524 | 25 |
1194352 | 1194352 | 2021-04-06 | Alger | Michigan | 26003 | 610 | 5 |
1194353 | 1194353 | 2021-04-06 | Allegan | Michigan | 26005 | 8633 | 118 |
1194354 | 1194354 | 2021-04-06 | Alpena | Michigan | 26007 | 1672 | 50 |
1194355 | 1194355 | 2021-04-06 | Antrim | Michigan | 26009 | 1270 | 20 |
1194356 | 1194356 | 2021-04-06 | Arenac | Michigan | 26011 | 835 | 27 |
1194357 | 1194357 | 2021-04-06 | Baraga | Michigan | 26013 | 798 | 34 |
1194358 | 1194358 | 2021-04-06 | Barry | Michigan | 26015 | 4430 | 53 |
1194359 | 1194359 | 2021-04-06 | Bay | Michigan | 26017 | 8665 | 309 |
1194360 | 1194360 | 2021-04-06 | Benzie | Michigan | 26019 | 1028 | 32 |
1194361 | 1194361 | 2021-04-06 | Berrien | Michigan | 26021 | 13198 | 253 |
1194362 | 1194362 | 2021-04-06 | Branch | Michigan | 26023 | 4937 | 112 |
1194363 | 1194363 | 2021-04-06 | Calhoun | Michigan | 26025 | 11633 | 249 |
1194364 | 1194364 | 2021-04-06 | Cass | Michigan | 26027 | 4701 | 69 |
1194365 | 1194365 | 2021-04-06 | Charlevoix | Michigan | 26029 | 1250 | 13 |
1194366 | 1194366 | 2021-04-06 | Cheboygan | Michigan | 26031 | 1372 | 38 |
1194367 | 1194367 | 2021-04-06 | Chippewa | Michigan | 26033 | 5227 | 46 |
1194368 | 1194368 | 2021-04-06 | Clare | Michigan | 26035 | 1819 | 69 |
1194369 | 1194369 | 2021-04-06 | Clinton | Michigan | 26037 | 6259 | 75 |
1194370 | 1194370 | 2021-04-06 | Crawford | Michigan | 26039 | 791 | 6 |
1194371 | 1194371 | 2021-04-06 | Delta | Michigan | 26041 | 3375 | 87 |
1194372 | 1194372 | 2021-04-06 | Dickinson | Michigan | 26043 | 2476 | 71 |
1194373 | 1194373 | 2021-04-06 | Eaton | Michigan | 26045 | 8148 | 163 |
1194374 | 1194374 | 2021-04-06 | Emmet | Michigan | 26047 | 1826 | 40 |
1194375 | 1194375 | 2021-04-06 | Genesee | Michigan | 26049 | 32130 | 789 |
1194376 | 1194376 | 2021-04-06 | Gladwin | Michigan | 26051 | 1724 | 43 |
1194377 | 1194377 | 2021-04-06 | Gogebic | Michigan | 26053 | 1331 | 50 |
1194378 | 1194378 | 2021-04-06 | Grand Traverse | Michigan | 26055 | 5253 | 78 |
1194379 | 1194379 | 2021-04-06 | Gratiot | Michigan | 26057 | 6002 | 110 |
1194380 | 1194380 | 2021-04-06 | Hillsdale | Michigan | 26059 | 3743 | 80 |
1194381 | 1194381 | 2021-04-06 | Houghton | Michigan | 26061 | 2875 | 40 |
1194382 | 1194382 | 2021-04-06 | Huron | Michigan | 26063 | 3173 | 63 |
1194383 | 1194383 | 2021-04-06 | Ingham | Michigan | 26065 | 20471 | 310 |
1194384 | 1194384 | 2021-04-06 | Ionia | Michigan | 26067 | 7775 | 79 |
1194385 | 1194385 | 2021-04-06 | Iosco | Michigan | 26069 | 1500 | 67 |
1194386 | 1194386 | 2021-04-06 | Iron | Michigan | 26071 | 947 | 51 |
1194387 | 1194387 | 2021-04-06 | Isabella | Michigan | 26073 | 4750 | 78 |
1194388 | 1194388 | 2021-04-06 | Jackson | Michigan | 26075 | 17512 | 266 |
1194389 | 1194389 | 2021-04-06 | Kalamazoo | Michigan | 26077 | 18196 | 330 |
1194390 | 1194390 | 2021-04-06 | Kalkaska | Michigan | 26079 | 827 | 16 |
1194391 | 1194391 | 2021-04-06 | Kent | Michigan | 26081 | 58607 | 750 |
1194392 | 1194392 | 2021-04-06 | Keweenaw | Michigan | 26083 | 156 | 2 |
1194393 | 1194393 | 2021-04-06 | Lake | Michigan | 26085 | 461 | 12 |
1194394 | 1194394 | 2021-04-06 | Lapeer | Michigan | 26087 | 7508 | 149 |
1194395 | 1194395 | 2021-04-06 | Leelanau | Michigan | 26089 | 1020 | 16 |
1194396 | 1194396 | 2021-04-06 | Lenawee | Michigan | 26091 | 8787 | 141 |
1194397 | 1194397 | 2021-04-06 | Livingston | Michigan | 26093 | 13000 | 159 |
1194398 | 1194398 | 2021-04-06 | Luce | Michigan | 26095 | 1138 | 2 |
1194399 | 1194399 | 2021-04-06 | Mackinac | Michigan | 26097 | 502 | 3 |
1194400 | 1194400 | 2021-04-06 | Macomb | Michigan | 26099 | 78430 | 2059 |
1194401 | 1194401 | 2021-04-06 | Manistee | Michigan | 26101 | 1678 | 23 |
1194402 | 1194402 | 2021-04-06 | Marquette | Michigan | 26103 | 5192 | 57 |
1194403 | 1194403 | 2021-04-06 | Mason | Michigan | 26105 | 1490 | 27 |
1194404 | 1194404 | 2021-04-06 | Mecosta | Michigan | 26107 | 2404 | 24 |
1194405 | 1194405 | 2021-04-06 | Menominee | Michigan | 26109 | 1948 | 41 |
1194406 | 1194406 | 2021-04-06 | Midland | Michigan | 26111 | 5864 | 71 |
1194407 | 1194407 | 2021-04-06 | Missaukee | Michigan | 26113 | 1162 | 20 |
1194408 | 1194408 | 2021-04-06 | Monroe | Michigan | 26115 | 12272 | 214 |
1194409 | 1194409 | 2021-04-06 | Montcalm | Michigan | 26117 | 6344 | 97 |
1194410 | 1194410 | 2021-04-06 | Montmorency | Michigan | 26119 | 415 | 18 |
1194411 | 1194411 | 2021-04-06 | Muskegon | Michigan | 26121 | 13779 | 318 |
1194412 | 1194412 | 2021-04-06 | Newaygo | Michigan | 26123 | 3517 | 54 |
1194413 | 1194413 | 2021-04-06 | Oakland | Michigan | 26125 | 93013 | 2075 |
1194414 | 1194414 | 2021-04-06 | Oceana | Michigan | 26127 | 2098 | 51 |
1194415 | 1194415 | 2021-04-06 | Ogemaw | Michigan | 26129 | 1233 | 34 |
1194416 | 1194416 | 2021-04-06 | Ontonagon | Michigan | 26131 | 433 | 21 |
1194417 | 1194417 | 2021-04-06 | Osceola | Michigan | 26133 | 1410 | 24 |
1194418 | 1194418 | 2021-04-06 | Oscoda | Michigan | 26135 | 484 | 21 |
1194419 | 1194419 | 2021-04-06 | Otsego | Michigan | 26137 | 1793 | 28 |
1194420 | 1194420 | 2021-04-06 | Ottawa | Michigan | 26139 | 25982 | 373 |
1194421 | 1194421 | 2021-04-06 | Presque Isle | Michigan | 26141 | 799 | 29 |
1194422 | 1194422 | 2021-04-06 | Roscommon | Michigan | 26143 | 1560 | 42 |
1194423 | 1194423 | 2021-04-06 | Saginaw | Michigan | 26145 | 17895 | 546 |
1194424 | 1194424 | 2021-04-06 | Sanilac | Michigan | 26151 | 3243 | 87 |
1194425 | 1194425 | 2021-04-06 | Schoolcraft | Michigan | 26153 | 318 | 5 |
1194426 | 1194426 | 2021-04-06 | Shiawassee | Michigan | 26155 | 4776 | 86 |
1194427 | 1194427 | 2021-04-06 | St. Clair | Michigan | 26147 | 13566 | 295 |
1194428 | 1194428 | 2021-04-06 | St. Joseph | Michigan | 26149 | 5274 | 91 |
1194429 | 1194429 | 2021-04-06 | Tuscola | Michigan | 26157 | 4355 | 144 |
1194430 | 1194430 | 2021-04-06 | Unknown | Michigan | 0 | 15 | |
1194431 | 1194431 | 2021-04-06 | Van Buren | Michigan | 26159 | 5775 | 100 |
1194432 | 1194432 | 2021-04-06 | Washtenaw | Michigan | 26161 | 22415 | 262 |
1194433 | 1194433 | 2021-04-06 | Wayne | Michigan | 26163 | 126587 | 4304 |
1194434 | 1194434 | 2021-04-06 | Wexford | Michigan | 26165 | 2173 | 28 |
1191102 | 1191102 | 2021-04-05 | Alcona | Michigan | 26001 | 513 | 25 |
1191103 | 1191103 | 2021-04-05 | Alger | Michigan | 26003 | 609 | 5 |
1191104 | 1191104 | 2021-04-05 | Allegan | Michigan | 26005 | 8578 | 118 |
1191105 | 1191105 | 2021-04-05 | Alpena | Michigan | 26007 | 1663 | 50 |
1191106 | 1191106 | 2021-04-05 | Antrim | Michigan | 26009 | 1249 | 20 |
1191107 | 1191107 | 2021-04-05 | Arenac | Michigan | 26011 | 834 | 27 |
1191108 | 1191108 | 2021-04-05 | Baraga | Michigan | 26013 | 798 | 34 |
1191109 | 1191109 | 2021-04-05 | Barry | Michigan | 26015 | 4395 | 52 |
1191110 | 1191110 | 2021-04-05 | Bay | Michigan | 26017 | 8623 | 309 |
1191111 | 1191111 | 2021-04-05 | Benzie | Michigan | 26019 | 1022 | 32 |
1191112 | 1191112 | 2021-04-05 | Berrien | Michigan | 26021 | 13149 | 252 |
1191113 | 1191113 | 2021-04-05 | Branch | Michigan | 26023 | 4927 | 112 |
1191114 | 1191114 | 2021-04-05 | Calhoun | Michigan | 26025 | 11554 | 247 |
1191115 | 1191115 | 2021-04-05 | Cass | Michigan | 26027 | 4693 | 69 |
1191116 | 1191116 | 2021-04-05 | Charlevoix | Michigan | 26029 | 1234 | 13 |
1191117 | 1191117 | 2021-04-05 | Cheboygan | Michigan | 26031 | 1352 | 38 |
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);