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 462
- 26163 462
- 26065 460
- 26081 460
- 26117 460
- 26147 460
- 26161 460
- 26017 459
- 26029 459
- 26089 459
- 26099 459
- 26115 458
- 26139 457
- 26075 455
- 26137 455
- 26037 453
- 26045 453
- 26049 453
- 26093 453
- 26111 453
- 26005 451
- 26015 451
- 26021 451
- 26025 451
- 26035 451
- 26145 451
- 26157 451
- 26165 451
- 26047 450
- 26051 450
- 26055 450
- 26143 450
- 26033 449
- 26077 449
- 26121 449
- 26123 449
- 26059 448
- 26073 448
- 26079 448
- 26087 448
- 26101 448
- 26069 447
- 26091 447
- 26103 447
- 26151 447
- 26159 447
- 26053 446
- 26067 446
- 26107 446
- 26113 446
- 26127 446
- 26129 446
- 26155 446
- 26027 445
- 26039 445
- 26057 445
- 26063 445
- - 445
- 26133 444
- 26031 443
- 26009 442
- 26041 442
- 26061 442
- 26149 442
- 26011 441
- 26023 441
- 26135 441
- 26097 440
- 26043 439
- 26095 438
- 26141 435
- 26105 434
- 26153 433
- 26109 431
- 26007 430
- 26085 430
- 26119 428
- 26001 426
- 26013 425
- 26019 423
- 26071 378
- 26003 370
- 26083 370
- 26131 346
county 84
- Oakland 462
- Wayne 462
- Ingham 460
- Kent 460
- Montcalm 460
- St. Clair 460
- Washtenaw 460
- Bay 459
- Charlevoix 459
- Leelanau 459
- Macomb 459
- Monroe 458
- Ottawa 457
- Jackson 455
- Otsego 455
- Clinton 453
- Eaton 453
- Genesee 453
- Livingston 453
- Midland 453
- Allegan 451
- Barry 451
- Berrien 451
- Calhoun 451
- Clare 451
- Saginaw 451
- Tuscola 451
- Wexford 451
- Emmet 450
- Gladwin 450
- Grand Traverse 450
- Roscommon 450
- Chippewa 449
- Kalamazoo 449
- Muskegon 449
- Newaygo 449
- Hillsdale 448
- Isabella 448
- Kalkaska 448
- Lapeer 448
- Manistee 448
- Iosco 447
- Lenawee 447
- Marquette 447
- Sanilac 447
- Van Buren 447
- Gogebic 446
- Ionia 446
- Mecosta 446
- Missaukee 446
- Oceana 446
- Ogemaw 446
- Shiawassee 446
- Cass 445
- Crawford 445
- Gratiot 445
- Huron 445
- Unknown 445
- Osceola 444
- Cheboygan 443
- Antrim 442
- Delta 442
- Houghton 442
- St. Joseph 442
- Arenac 441
- Branch 441
- Oscoda 441
- Mackinac 440
- Dickinson 439
- Luce 438
- Presque Isle 435
- Mason 434
- Schoolcraft 433
- Menominee 431
- Alpena 430
- Lake 430
- Montmorency 428
- Alcona 426
- Baraga 425
- Benzie 423
- Iron 378
- Alger 370
- Keweenaw 370
- Ontonagon 346
state 1
- Michigan · 37,230 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418371 | 1418371 | 2021-06-14 | Alcona | Michigan | 26001 | 739 | 32 |
1418372 | 1418372 | 2021-06-14 | Alger | Michigan | 26003 | 667 | 7 |
1418373 | 1418373 | 2021-06-14 | Allegan | Michigan | 26005 | 11154 | 156 |
1418374 | 1418374 | 2021-06-14 | Alpena | Michigan | 26007 | 2268 | 62 |
1418375 | 1418375 | 2021-06-14 | Antrim | Michigan | 26009 | 1632 | 29 |
1418376 | 1418376 | 2021-06-14 | Arenac | Michigan | 26011 | 1208 | 29 |
1418377 | 1418377 | 2021-06-14 | Baraga | Michigan | 26013 | 987 | 38 |
1418378 | 1418378 | 2021-06-14 | Barry | Michigan | 26015 | 5949 | 68 |
1418379 | 1418379 | 2021-06-14 | Bay | Michigan | 26017 | 11243 | 353 |
1418380 | 1418380 | 2021-06-14 | Benzie | Michigan | 26019 | 1280 | 36 |
1418381 | 1418381 | 2021-06-14 | Berrien | Michigan | 26021 | 15551 | 289 |
1418382 | 1418382 | 2021-06-14 | Branch | Michigan | 26023 | 5712 | 120 |
1418383 | 1418383 | 2021-06-14 | Calhoun | Michigan | 26025 | 14514 | 313 |
1418384 | 1418384 | 2021-06-14 | Cass | Michigan | 26027 | 5484 | 77 |
1418385 | 1418385 | 2021-06-14 | Charlevoix | Michigan | 26029 | 1679 | 22 |
1418386 | 1418386 | 2021-06-14 | Cheboygan | Michigan | 26031 | 1930 | 45 |
1418387 | 1418387 | 2021-06-14 | Chippewa | Michigan | 26033 | 5614 | 49 |
1418388 | 1418388 | 2021-06-14 | Clare | Michigan | 26035 | 2465 | 83 |
1418389 | 1418389 | 2021-06-14 | Clinton | Michigan | 26037 | 7621 | 90 |
1418390 | 1418390 | 2021-06-14 | Crawford | Michigan | 26039 | 992 | 14 |
1418391 | 1418391 | 2021-06-14 | Delta | Michigan | 26041 | 4056 | 95 |
1418392 | 1418392 | 2021-06-14 | Dickinson | Michigan | 26043 | 2747 | 74 |
1418393 | 1418393 | 2021-06-14 | Eaton | Michigan | 26045 | 10140 | 209 |
1418394 | 1418394 | 2021-06-14 | Emmet | Michigan | 26047 | 2381 | 43 |
1418395 | 1418395 | 2021-06-14 | Genesee | Michigan | 26049 | 41690 | 962 |
1418396 | 1418396 | 2021-06-14 | Gladwin | Michigan | 26051 | 2304 | 58 |
1418397 | 1418397 | 2021-06-14 | Gogebic | Michigan | 26053 | 1405 | 51 |
1418398 | 1418398 | 2021-06-14 | Grand Traverse | Michigan | 26055 | 6472 | 99 |
1418399 | 1418399 | 2021-06-14 | Gratiot | Michigan | 26057 | 6967 | 125 |
1418400 | 1418400 | 2021-06-14 | Hillsdale | Michigan | 26059 | 4410 | 93 |
1418401 | 1418401 | 2021-06-14 | Houghton | Michigan | 26061 | 3135 | 43 |
1418402 | 1418402 | 2021-06-14 | Huron | Michigan | 26063 | 4089 | 82 |
1418403 | 1418403 | 2021-06-14 | Ingham | Michigan | 26065 | 24860 | 386 |
1418404 | 1418404 | 2021-06-14 | Ionia | Michigan | 26067 | 9313 | 85 |
1418405 | 1418405 | 2021-06-14 | Iosco | Michigan | 26069 | 2004 | 74 |
1418406 | 1418406 | 2021-06-14 | Iron | Michigan | 26071 | 1052 | 52 |
1418407 | 1418407 | 2021-06-14 | Isabella | Michigan | 26073 | 6328 | 99 |
1418408 | 1418408 | 2021-06-14 | Jackson | Michigan | 26075 | 21010 | 321 |
1418409 | 1418409 | 2021-06-14 | Kalamazoo | Michigan | 26077 | 23107 | 402 |
1418410 | 1418410 | 2021-06-14 | Kalkaska | Michigan | 26079 | 1132 | 25 |
1418411 | 1418411 | 2021-06-14 | Kent | Michigan | 26081 | 73214 | 852 |
1418412 | 1418412 | 2021-06-14 | Keweenaw | Michigan | 26083 | 174 | 2 |
1418413 | 1418413 | 2021-06-14 | Lake | Michigan | 26085 | 635 | 16 |
1418414 | 1418414 | 2021-06-14 | Lapeer | Michigan | 26087 | 9747 | 213 |
1418415 | 1418415 | 2021-06-14 | Leelanau | Michigan | 26089 | 1242 | 19 |
1418416 | 1418416 | 2021-06-14 | Lenawee | Michigan | 26091 | 10828 | 173 |
1418417 | 1418417 | 2021-06-14 | Livingston | Michigan | 26093 | 16762 | 193 |
1418418 | 1418418 | 2021-06-14 | Luce | Michigan | 26095 | 1337 | 6 |
1418419 | 1418419 | 2021-06-14 | Mackinac | Michigan | 26097 | 713 | 3 |
1418420 | 1418420 | 2021-06-14 | Macomb | Michigan | 26099 | 100468 | 2478 |
1418421 | 1418421 | 2021-06-14 | Manistee | Michigan | 26101 | 1972 | 24 |
1418422 | 1418422 | 2021-06-14 | Marquette | Michigan | 26103 | 5924 | 63 |
1418423 | 1418423 | 2021-06-14 | Mason | Michigan | 26105 | 2136 | 37 |
1418424 | 1418424 | 2021-06-14 | Mecosta | Michigan | 26107 | 3203 | 36 |
1418425 | 1418425 | 2021-06-14 | Menominee | Michigan | 26109 | 2122 | 43 |
1418426 | 1418426 | 2021-06-14 | Midland | Michigan | 26111 | 7558 | 93 |
1418427 | 1418427 | 2021-06-14 | Missaukee | Michigan | 26113 | 1511 | 27 |
1418428 | 1418428 | 2021-06-14 | Monroe | Michigan | 26115 | 15395 | 261 |
1418429 | 1418429 | 2021-06-14 | Montcalm | Michigan | 26117 | 8194 | 119 |
1418430 | 1418430 | 2021-06-14 | Montmorency | Michigan | 26119 | 614 | 20 |
1418431 | 1418431 | 2021-06-14 | Muskegon | Michigan | 26121 | 18351 | 376 |
1418432 | 1418432 | 2021-06-14 | Newaygo | Michigan | 26123 | 4884 | 69 |
1418433 | 1418433 | 2021-06-14 | Oakland | Michigan | 26125 | 118439 | 2419 |
1418434 | 1418434 | 2021-06-14 | Oceana | Michigan | 26127 | 2765 | 60 |
1418435 | 1418435 | 2021-06-14 | Ogemaw | Michigan | 26129 | 1741 | 44 |
1418436 | 1418436 | 2021-06-14 | Ontonagon | Michigan | 26131 | 482 | 21 |
1418437 | 1418437 | 2021-06-14 | Osceola | Michigan | 26133 | 1957 | 31 |
1418438 | 1418438 | 2021-06-14 | Oscoda | Michigan | 26135 | 690 | 31 |
1418439 | 1418439 | 2021-06-14 | Otsego | Michigan | 26137 | 2353 | 41 |
1418440 | 1418440 | 2021-06-14 | Ottawa | Michigan | 26139 | 32845 | 431 |
1418441 | 1418441 | 2021-06-14 | Presque Isle | Michigan | 26141 | 1056 | 34 |
1418442 | 1418442 | 2021-06-14 | Roscommon | Michigan | 26143 | 1898 | 53 |
1418443 | 1418443 | 2021-06-14 | Saginaw | Michigan | 26145 | 22482 | 627 |
1418444 | 1418444 | 2021-06-14 | Sanilac | Michigan | 26151 | 4257 | 125 |
1418445 | 1418445 | 2021-06-14 | Schoolcraft | Michigan | 26153 | 439 | 5 |
1418446 | 1418446 | 2021-06-14 | Shiawassee | Michigan | 26155 | 6417 | 106 |
1418447 | 1418447 | 2021-06-14 | St. Clair | Michigan | 26147 | 18476 | 446 |
1418448 | 1418448 | 2021-06-14 | St. Joseph | Michigan | 26149 | 6250 | 100 |
1418449 | 1418449 | 2021-06-14 | Tuscola | Michigan | 26157 | 5664 | 173 |
1418450 | 1418450 | 2021-06-14 | Unknown | Michigan | 897 | 15 | |
1418451 | 1418451 | 2021-06-14 | Van Buren | Michigan | 26159 | 7128 | 130 |
1418452 | 1418452 | 2021-06-14 | Washtenaw | Michigan | 26161 | 27083 | 307 |
1418453 | 1418453 | 2021-06-14 | Wayne | Michigan | 26163 | 165350 | 5114 |
1418454 | 1418454 | 2021-06-14 | Wexford | Michigan | 26165 | 2893 | 47 |
1415126 | 1415126 | 2021-06-13 | Alcona | Michigan | 26001 | 739 | 32 |
1415127 | 1415127 | 2021-06-13 | Alger | Michigan | 26003 | 667 | 7 |
1415128 | 1415128 | 2021-06-13 | Allegan | Michigan | 26005 | 11151 | 156 |
1415129 | 1415129 | 2021-06-13 | Alpena | Michigan | 26007 | 2266 | 62 |
1415130 | 1415130 | 2021-06-13 | Antrim | Michigan | 26009 | 1631 | 29 |
1415131 | 1415131 | 2021-06-13 | Arenac | Michigan | 26011 | 1207 | 29 |
1415132 | 1415132 | 2021-06-13 | Baraga | Michigan | 26013 | 987 | 38 |
1415133 | 1415133 | 2021-06-13 | Barry | Michigan | 26015 | 5948 | 68 |
1415134 | 1415134 | 2021-06-13 | Bay | Michigan | 26017 | 11238 | 352 |
1415135 | 1415135 | 2021-06-13 | Benzie | Michigan | 26019 | 1280 | 36 |
1415136 | 1415136 | 2021-06-13 | Berrien | Michigan | 26021 | 15551 | 289 |
1415137 | 1415137 | 2021-06-13 | Branch | Michigan | 26023 | 5704 | 120 |
1415138 | 1415138 | 2021-06-13 | Calhoun | Michigan | 26025 | 14506 | 313 |
1415139 | 1415139 | 2021-06-13 | Cass | Michigan | 26027 | 5482 | 76 |
1415140 | 1415140 | 2021-06-13 | Charlevoix | Michigan | 26029 | 1677 | 22 |
1415141 | 1415141 | 2021-06-13 | Cheboygan | Michigan | 26031 | 1930 | 45 |
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);