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 695
- 26163 695
- 26065 693
- 26081 693
- 26117 693
- 26147 693
- 26161 693
- 26017 692
- 26029 692
- 26089 692
- 26099 692
- 26115 691
- 26139 690
- 26075 688
- 26137 688
- 26037 686
- 26045 686
- 26049 686
- 26093 686
- 26111 686
- 26005 684
- 26015 684
- 26021 684
- 26025 684
- 26035 684
- 26145 684
- 26157 684
- 26165 684
- 26047 683
- 26051 683
- …
county >30
- Oakland 695
- Wayne 695
- Ingham 693
- Kent 693
- Montcalm 693
- St. Clair 693
- Washtenaw 693
- Bay 692
- Charlevoix 692
- Leelanau 692
- Macomb 692
- Monroe 691
- Ottawa 690
- Jackson 688
- Otsego 688
- Clinton 686
- Eaton 686
- Genesee 686
- Livingston 686
- Midland 686
- Allegan 684
- Barry 684
- Berrien 684
- Calhoun 684
- Clare 684
- Saginaw 684
- Tuscola 684
- Wexford 684
- Emmet 683
- Gladwin 683
- …
state 1
- Michigan · 56,802 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175439 | 2175439 | 2022-02-02 | Alcona | Michigan | 26001 | 1632 | 67 |
2175440 | 2175440 | 2022-02-02 | Alger | Michigan | 26003 | 1789 | 12 |
2175441 | 2175441 | 2022-02-02 | Allegan | Michigan | 26005 | 25878 | 313 |
2175442 | 2175442 | 2022-02-02 | Alpena | Michigan | 26007 | 5248 | 123 |
2175443 | 2175443 | 2022-02-02 | Antrim | Michigan | 26009 | 4078 | 54 |
2175444 | 2175444 | 2022-02-02 | Arenac | Michigan | 26011 | 3029 | 60 |
2175445 | 2175445 | 2022-02-02 | Baraga | Michigan | 26013 | 2110 | 53 |
2175446 | 2175446 | 2022-02-02 | Barry | Michigan | 26015 | 13696 | 148 |
2175447 | 2175447 | 2022-02-02 | Bay | Michigan | 26017 | 25855 | 538 |
2175448 | 2175448 | 2022-02-02 | Benzie | Michigan | 26019 | 3253 | 60 |
2175449 | 2175449 | 2022-02-02 | Berrien | Michigan | 26021 | 33538 | 478 |
2175450 | 2175450 | 2022-02-02 | Branch | Michigan | 26023 | 11760 | 183 |
2175451 | 2175451 | 2022-02-02 | Calhoun | Michigan | 26025 | 32504 | 526 |
2175452 | 2175452 | 2022-02-02 | Cass | Michigan | 26027 | 10776 | 124 |
2175453 | 2175453 | 2022-02-02 | Charlevoix | Michigan | 26029 | 4712 | 55 |
2175454 | 2175454 | 2022-02-02 | Cheboygan | Michigan | 26031 | 4403 | 89 |
2175455 | 2175455 | 2022-02-02 | Chippewa | Michigan | 26033 | 10978 | 100 |
2175456 | 2175456 | 2022-02-02 | Clare | Michigan | 26035 | 6391 | 147 |
2175457 | 2175457 | 2022-02-02 | Clinton | Michigan | 26037 | 19753 | 186 |
2175458 | 2175458 | 2022-02-02 | Crawford | Michigan | 26039 | 2401 | 24 |
2175459 | 2175459 | 2022-02-02 | Delta | Michigan | 26041 | 9506 | 145 |
2175460 | 2175460 | 2022-02-02 | Dickinson | Michigan | 26043 | 7059 | 99 |
2175461 | 2175461 | 2022-02-02 | Eaton | Michigan | 26045 | 25370 | 353 |
2175462 | 2175462 | 2022-02-02 | Emmet | Michigan | 26047 | 6117 | 70 |
2175463 | 2175463 | 2022-02-02 | Genesee | Michigan | 26049 | 96835 | 1537 |
2175464 | 2175464 | 2022-02-02 | Gladwin | Michigan | 26051 | 5329 | 105 |
2175465 | 2175465 | 2022-02-02 | Gogebic | Michigan | 26053 | 3129 | 64 |
2175466 | 2175466 | 2022-02-02 | Grand Traverse | Michigan | 26055 | 16156 | 199 |
2175467 | 2175467 | 2022-02-02 | Gratiot | Michigan | 26057 | 12913 | 175 |
2175468 | 2175468 | 2022-02-02 | Hillsdale | Michigan | 26059 | 9875 | 182 |
2175469 | 2175469 | 2022-02-02 | Houghton | Michigan | 26061 | 7469 | 83 |
2175470 | 2175470 | 2022-02-02 | Huron | Michigan | 26063 | 7770 | 137 |
2175471 | 2175471 | 2022-02-02 | Ingham | Michigan | 26065 | 60807 | 678 |
2175472 | 2175472 | 2022-02-02 | Ionia | Michigan | 26067 | 18662 | 170 |
2175473 | 2175473 | 2022-02-02 | Iosco | Michigan | 26069 | 4528 | 128 |
2175474 | 2175474 | 2022-02-02 | Iron | Michigan | 26071 | 2514 | 79 |
2175475 | 2175475 | 2022-02-02 | Isabella | Michigan | 26073 | 14840 | 184 |
2175476 | 2175476 | 2022-02-02 | Jackson | Michigan | 26075 | 43268 | 516 |
2175477 | 2175477 | 2022-02-02 | Kalamazoo | Michigan | 26077 | 55750 | 613 |
2175478 | 2175478 | 2022-02-02 | Kalkaska | Michigan | 26079 | 3343 | 49 |
2175479 | 2175479 | 2022-02-02 | Kent | Michigan | 26081 | 159708 | 1396 |
2175480 | 2175480 | 2022-02-02 | Keweenaw | Michigan | 26083 | 487 | 12 |
2175481 | 2175481 | 2022-02-02 | Lake | Michigan | 26085 | 1718 | 33 |
2175482 | 2175482 | 2022-02-02 | Lapeer | Michigan | 26087 | 20128 | 391 |
2175483 | 2175483 | 2022-02-02 | Leelanau | Michigan | 26089 | 3378 | 46 |
2175484 | 2175484 | 2022-02-02 | Lenawee | Michigan | 26091 | 24928 | 297 |
2175485 | 2175485 | 2022-02-02 | Livingston | Michigan | 26093 | 44114 | 410 |
2175486 | 2175486 | 2022-02-02 | Luce | Michigan | 26095 | 2202 | 9 |
2175487 | 2175487 | 2022-02-02 | Mackinac | Michigan | 26097 | 2269 | 26 |
2175488 | 2175488 | 2022-02-02 | Macomb | Michigan | 26099 | 219141 | 3611 |
2175489 | 2175489 | 2022-02-02 | Manistee | Michigan | 26101 | 4140 | 77 |
2175490 | 2175490 | 2022-02-02 | Marquette | Michigan | 26103 | 15037 | 111 |
2175491 | 2175491 | 2022-02-02 | Mason | Michigan | 26105 | 6220 | 79 |
2175492 | 2175492 | 2022-02-02 | Mecosta | Michigan | 26107 | 8157 | 91 |
2175493 | 2175493 | 2022-02-02 | Menominee | Michigan | 26109 | 5304 | 68 |
2175494 | 2175494 | 2022-02-02 | Midland | Michigan | 26111 | 18082 | 205 |
2175495 | 2175495 | 2022-02-02 | Missaukee | Michigan | 26113 | 2742 | 57 |
2175496 | 2175496 | 2022-02-02 | Monroe | Michigan | 26115 | 36556 | 427 |
2175497 | 2175497 | 2022-02-02 | Montcalm | Michigan | 26117 | 16402 | 194 |
2175498 | 2175498 | 2022-02-02 | Montmorency | Michigan | 26119 | 1635 | 45 |
2175499 | 2175499 | 2022-02-02 | Muskegon | Michigan | 26121 | 40000 | 584 |
2175500 | 2175500 | 2022-02-02 | Newaygo | Michigan | 26123 | 10924 | 145 |
2175501 | 2175501 | 2022-02-02 | Oakland | Michigan | 26125 | 272769 | 3508 |
2175502 | 2175502 | 2022-02-02 | Oceana | Michigan | 26127 | 5989 | 87 |
2175503 | 2175503 | 2022-02-02 | Ogemaw | Michigan | 26129 | 4088 | 89 |
2175504 | 2175504 | 2022-02-02 | Ontonagon | Michigan | 26131 | 931 | 34 |
2175505 | 2175505 | 2022-02-02 | Osceola | Michigan | 26133 | 4727 | 70 |
2175506 | 2175506 | 2022-02-02 | Oscoda | Michigan | 26135 | 1388 | 53 |
2175507 | 2175507 | 2022-02-02 | Otsego | Michigan | 26137 | 5296 | 90 |
2175508 | 2175508 | 2022-02-02 | Ottawa | Michigan | 26139 | 71571 | 733 |
2175509 | 2175509 | 2022-02-02 | Presque Isle | Michigan | 26141 | 2007 | 55 |
2175510 | 2175510 | 2022-02-02 | Roscommon | Michigan | 26143 | 4375 | 109 |
2175511 | 2175511 | 2022-02-02 | Saginaw | Michigan | 26145 | 48174 | 871 |
2175512 | 2175512 | 2022-02-02 | Sanilac | Michigan | 26151 | 8307 | 174 |
2175513 | 2175513 | 2022-02-02 | Schoolcraft | Michigan | 26153 | 1638 | 13 |
2175514 | 2175514 | 2022-02-02 | Shiawassee | Michigan | 26155 | 17001 | 211 |
2175515 | 2175515 | 2022-02-02 | St. Clair | Michigan | 26147 | 38914 | 759 |
2175516 | 2175516 | 2022-02-02 | St. Joseph | Michigan | 26149 | 13238 | 183 |
2175517 | 2175517 | 2022-02-02 | Tuscola | Michigan | 26157 | 12695 | 258 |
2175518 | 2175518 | 2022-02-02 | Unknown | Michigan | 10304 | 32 | |
2175519 | 2175519 | 2022-02-02 | Van Buren | Michigan | 26159 | 16297 | 244 |
2175520 | 2175520 | 2022-02-02 | Washtenaw | Michigan | 26161 | 69968 | 486 |
2175521 | 2175521 | 2022-02-02 | Wayne | Michigan | 26163 | 382633 | 7224 |
2175522 | 2175522 | 2022-02-02 | Wexford | Michigan | 26165 | 6586 | 96 |
2172186 | 2172186 | 2022-02-01 | Alcona | Michigan | 26001 | 1619 | 66 |
2172187 | 2172187 | 2022-02-01 | Alger | Michigan | 26003 | 1759 | 12 |
2172188 | 2172188 | 2022-02-01 | Allegan | Michigan | 26005 | 25605 | 307 |
2172189 | 2172189 | 2022-02-01 | Alpena | Michigan | 26007 | 5183 | 123 |
2172190 | 2172190 | 2022-02-01 | Antrim | Michigan | 26009 | 4055 | 53 |
2172191 | 2172191 | 2022-02-01 | Arenac | Michigan | 26011 | 2985 | 60 |
2172192 | 2172192 | 2022-02-01 | Baraga | Michigan | 26013 | 2080 | 52 |
2172193 | 2172193 | 2022-02-01 | Barry | Michigan | 26015 | 13526 | 148 |
2172194 | 2172194 | 2022-02-01 | Bay | Michigan | 26017 | 25569 | 531 |
2172195 | 2172195 | 2022-02-01 | Benzie | Michigan | 26019 | 3215 | 60 |
2172196 | 2172196 | 2022-02-01 | Berrien | Michigan | 26021 | 33042 | 468 |
2172197 | 2172197 | 2022-02-01 | Branch | Michigan | 26023 | 11525 | 181 |
2172198 | 2172198 | 2022-02-01 | Calhoun | Michigan | 26025 | 32116 | 524 |
2172199 | 2172199 | 2022-02-01 | Cass | Michigan | 26027 | 10678 | 124 |
2172200 | 2172200 | 2022-02-01 | Charlevoix | Michigan | 26029 | 4708 | 55 |
2172201 | 2172201 | 2022-02-01 | Cheboygan | Michigan | 26031 | 4368 | 88 |
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);