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 317
- 26163 317
- 26065 315
- 26081 315
- 26117 315
- 26147 315
- 26161 315
- 26017 314
- 26029 314
- 26089 314
- 26099 314
- 26115 313
- 26139 312
- 26075 310
- 26137 310
- 26037 308
- 26045 308
- 26049 308
- 26093 308
- 26111 308
- 26005 306
- 26015 306
- 26021 306
- 26025 306
- 26035 306
- 26145 306
- 26157 306
- 26165 306
- 26047 305
- 26051 305
- …
county >30
- Oakland 317
- Wayne 317
- Ingham 315
- Kent 315
- Montcalm 315
- St. Clair 315
- Washtenaw 315
- Bay 314
- Charlevoix 314
- Leelanau 314
- Macomb 314
- Monroe 313
- Ottawa 312
- Jackson 310
- Otsego 310
- Clinton 308
- Eaton 308
- Genesee 308
- Livingston 308
- Midland 308
- Allegan 306
- Barry 306
- Berrien 306
- Calhoun 306
- Clare 306
- Saginaw 306
- Tuscola 306
- Wexford 306
- Emmet 305
- Gladwin 305
- …
state 1
- Michigan · 25,050 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947643 | 947643 | 2021-01-20 | Alcona | Michigan | 26001 | 389 | 22 |
947644 | 947644 | 2021-01-20 | Alger | Michigan | 26003 | 534 | 3 |
947645 | 947645 | 2021-01-20 | Allegan | Michigan | 26005 | 6641 | 93 |
947646 | 947646 | 2021-01-20 | Alpena | Michigan | 26007 | 1374 | 42 |
947647 | 947647 | 2021-01-20 | Antrim | Michigan | 26009 | 806 | 18 |
947648 | 947648 | 2021-01-20 | Arenac | Michigan | 26011 | 682 | 23 |
947649 | 947649 | 2021-01-20 | Baraga | Michigan | 26013 | 740 | 30 |
947650 | 947650 | 2021-01-20 | Barry | Michigan | 26015 | 3374 | 39 |
947651 | 947651 | 2021-01-20 | Bay | Michigan | 26017 | 6917 | 240 |
947652 | 947652 | 2021-01-20 | Benzie | Michigan | 26019 | 811 | 28 |
947653 | 947653 | 2021-01-20 | Berrien | Michigan | 26021 | 10447 | 213 |
947654 | 947654 | 2021-01-20 | Branch | Michigan | 26023 | 4315 | 100 |
947655 | 947655 | 2021-01-20 | Calhoun | Michigan | 26025 | 8579 | 207 |
947656 | 947656 | 2021-01-20 | Cass | Michigan | 26027 | 3593 | 56 |
947657 | 947657 | 2021-01-20 | Charlevoix | Michigan | 26029 | 949 | 11 |
947658 | 947658 | 2021-01-20 | Cheboygan | Michigan | 26031 | 841 | 34 |
947659 | 947659 | 2021-01-20 | Chippewa | Michigan | 26033 | 4532 | 31 |
947660 | 947660 | 2021-01-20 | Clare | Michigan | 26035 | 1414 | 61 |
947661 | 947661 | 2021-01-20 | Clinton | Michigan | 26037 | 4542 | 53 |
947662 | 947662 | 2021-01-20 | Crawford | Michigan | 26039 | 526 | 5 |
947663 | 947663 | 2021-01-20 | Delta | Michigan | 26041 | 3036 | 79 |
947664 | 947664 | 2021-01-20 | Dickinson | Michigan | 26043 | 2295 | 70 |
947665 | 947665 | 2021-01-20 | Eaton | Michigan | 26045 | 5503 | 117 |
947666 | 947666 | 2021-01-20 | Emmet | Michigan | 26047 | 1345 | 34 |
947667 | 947667 | 2021-01-20 | Genesee | Michigan | 26049 | 23760 | 686 |
947668 | 947668 | 2021-01-20 | Gladwin | Michigan | 26051 | 1362 | 37 |
947669 | 947669 | 2021-01-20 | Gogebic | Michigan | 26053 | 1100 | 39 |
947670 | 947670 | 2021-01-20 | Grand Traverse | Michigan | 26055 | 3775 | 54 |
947671 | 947671 | 2021-01-20 | Gratiot | Michigan | 26057 | 5495 | 95 |
947672 | 947672 | 2021-01-20 | Hillsdale | Michigan | 26059 | 3013 | 67 |
947673 | 947673 | 2021-01-20 | Houghton | Michigan | 26061 | 2357 | 34 |
947674 | 947674 | 2021-01-20 | Huron | Michigan | 26063 | 1876 | 53 |
947675 | 947675 | 2021-01-20 | Ingham | Michigan | 26065 | 14310 | 236 |
947676 | 947676 | 2021-01-20 | Ionia | Michigan | 26067 | 5983 | 61 |
947677 | 947677 | 2021-01-20 | Iosco | Michigan | 26069 | 1215 | 60 |
947678 | 947678 | 2021-01-20 | Iron | Michigan | 26071 | 898 | 38 |
947679 | 947679 | 2021-01-20 | Isabella | Michigan | 26073 | 3759 | 64 |
947680 | 947680 | 2021-01-20 | Jackson | Michigan | 26075 | 12985 | 222 |
947681 | 947681 | 2021-01-20 | Kalamazoo | Michigan | 26077 | 13743 | 287 |
947682 | 947682 | 2021-01-20 | Kalkaska | Michigan | 26079 | 530 | 14 |
947683 | 947683 | 2021-01-20 | Kent | Michigan | 26081 | 47832 | 616 |
947684 | 947684 | 2021-01-20 | Keweenaw | Michigan | 26083 | 120 | 2 |
947685 | 947685 | 2021-01-20 | Lake | Michigan | 26085 | 338 | 10 |
947686 | 947686 | 2021-01-20 | Lapeer | Michigan | 26087 | 4955 | 116 |
947687 | 947687 | 2021-01-20 | Leelanau | Michigan | 26089 | 782 | 10 |
947688 | 947688 | 2021-01-20 | Lenawee | Michigan | 26091 | 6773 | 88 |
947689 | 947689 | 2021-01-20 | Livingston | Michigan | 26093 | 9174 | 101 |
947690 | 947690 | 2021-01-20 | Luce | Michigan | 26095 | 1057 | 1 |
947691 | 947691 | 2021-01-20 | Mackinac | Michigan | 26097 | 411 | 3 |
947692 | 947692 | 2021-01-20 | Macomb | Michigan | 26099 | 54488 | 1778 |
947693 | 947693 | 2021-01-20 | Manistee | Michigan | 26101 | 947 | 20 |
947694 | 947694 | 2021-01-20 | Marquette | Michigan | 26103 | 4673 | 54 |
947695 | 947695 | 2021-01-20 | Mason | Michigan | 26105 | 1135 | 23 |
947696 | 947696 | 2021-01-20 | Mecosta | Michigan | 26107 | 1812 | 15 |
947697 | 947697 | 2021-01-20 | Menominee | Michigan | 26109 | 1809 | 36 |
947698 | 947698 | 2021-01-20 | Midland | Michigan | 26111 | 4562 | 53 |
947699 | 947699 | 2021-01-20 | Missaukee | Michigan | 26113 | 632 | 15 |
947700 | 947700 | 2021-01-20 | Monroe | Michigan | 26115 | 8774 | 172 |
947701 | 947701 | 2021-01-20 | Montcalm | Michigan | 26117 | 5384 | 84 |
947702 | 947702 | 2021-01-20 | Montmorency | Michigan | 26119 | 343 | 13 |
947703 | 947703 | 2021-01-20 | Muskegon | Michigan | 26121 | 12170 | 297 |
947704 | 947704 | 2021-01-20 | Newaygo | Michigan | 26123 | 2533 | 40 |
947705 | 947705 | 2021-01-20 | Oakland | Michigan | 26125 | 68244 | 1816 |
947706 | 947706 | 2021-01-20 | Oceana | Michigan | 26127 | 1769 | 45 |
947707 | 947707 | 2021-01-20 | Ogemaw | Michigan | 26129 | 1014 | 31 |
947708 | 947708 | 2021-01-20 | Ontonagon | Michigan | 26131 | 327 | 17 |
947709 | 947709 | 2021-01-20 | Osceola | Michigan | 26133 | 958 | 20 |
947710 | 947710 | 2021-01-20 | Oscoda | Michigan | 26135 | 344 | 19 |
947711 | 947711 | 2021-01-20 | Otsego | Michigan | 26137 | 1086 | 25 |
947712 | 947712 | 2021-01-20 | Ottawa | Michigan | 26139 | 20512 | 312 |
947713 | 947713 | 2021-01-20 | Presque Isle | Michigan | 26141 | 593 | 22 |
947714 | 947714 | 2021-01-20 | Roscommon | Michigan | 26143 | 1056 | 29 |
947715 | 947715 | 2021-01-20 | Saginaw | Michigan | 26145 | 14706 | 457 |
947716 | 947716 | 2021-01-20 | Sanilac | Michigan | 26151 | 1753 | 69 |
947717 | 947717 | 2021-01-20 | Schoolcraft | Michigan | 26153 | 248 | 5 |
947718 | 947718 | 2021-01-20 | Shiawassee | Michigan | 26155 | 3405 | 65 |
947719 | 947719 | 2021-01-20 | St. Clair | Michigan | 26147 | 7980 | 208 |
947720 | 947720 | 2021-01-20 | St. Joseph | Michigan | 26149 | 4204 | 68 |
947721 | 947721 | 2021-01-20 | Tuscola | Michigan | 26157 | 2958 | 116 |
947722 | 947722 | 2021-01-20 | Unknown | Michigan | 0 | 17 | |
947723 | 947723 | 2021-01-20 | Van Buren | Michigan | 26159 | 4573 | 91 |
947724 | 947724 | 2021-01-20 | Washtenaw | Michigan | 26161 | 16208 | 226 |
947725 | 947725 | 2021-01-20 | Wayne | Michigan | 26163 | 93764 | 3878 |
947726 | 947726 | 2021-01-20 | Wexford | Michigan | 26165 | 1211 | 20 |
944396 | 944396 | 2021-01-19 | Alcona | Michigan | 26001 | 387 | 20 |
944397 | 944397 | 2021-01-19 | Alger | Michigan | 26003 | 519 | 3 |
944398 | 944398 | 2021-01-19 | Allegan | Michigan | 26005 | 6579 | 93 |
944399 | 944399 | 2021-01-19 | Alpena | Michigan | 26007 | 1368 | 43 |
944400 | 944400 | 2021-01-19 | Antrim | Michigan | 26009 | 804 | 18 |
944401 | 944401 | 2021-01-19 | Arenac | Michigan | 26011 | 680 | 23 |
944402 | 944402 | 2021-01-19 | Baraga | Michigan | 26013 | 739 | 30 |
944403 | 944403 | 2021-01-19 | Barry | Michigan | 26015 | 3358 | 39 |
944404 | 944404 | 2021-01-19 | Bay | Michigan | 26017 | 6895 | 236 |
944405 | 944405 | 2021-01-19 | Benzie | Michigan | 26019 | 798 | 28 |
944406 | 944406 | 2021-01-19 | Berrien | Michigan | 26021 | 10397 | 212 |
944407 | 944407 | 2021-01-19 | Branch | Michigan | 26023 | 4304 | 99 |
944408 | 944408 | 2021-01-19 | Calhoun | Michigan | 26025 | 8532 | 206 |
944409 | 944409 | 2021-01-19 | Cass | Michigan | 26027 | 3581 | 56 |
944410 | 944410 | 2021-01-19 | Charlevoix | Michigan | 26029 | 944 | 11 |
944411 | 944411 | 2021-01-19 | Cheboygan | Michigan | 26031 | 839 | 33 |
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);