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 584
- 26163 584
- 26065 582
- 26081 582
- 26117 582
- 26147 582
- 26161 582
- 26089 581
- 26099 581
- 26017 580
- 26029 580
- 26115 580
- 26139 579
- 26075 577
- 26137 577
- 26037 575
- 26045 575
- 26049 575
- 26093 575
- 26111 575
- 26035 573
- 26145 573
- 26157 573
- 26165 573
- 26005 572
- 26015 572
- 26021 572
- 26025 572
- 26047 572
- 26051 572
- …
county >30
- Oakland 584
- Wayne 584
- Ingham 582
- Kent 582
- Montcalm 582
- St. Clair 582
- Washtenaw 582
- Leelanau 581
- Macomb 581
- Bay 580
- Charlevoix 580
- Monroe 580
- Ottawa 579
- Jackson 577
- Otsego 577
- Clinton 575
- Eaton 575
- Genesee 575
- Livingston 575
- Midland 575
- Clare 573
- Saginaw 573
- Tuscola 573
- Wexford 573
- Allegan 572
- Barry 572
- Berrien 572
- Calhoun 572
- Emmet 572
- Gladwin 572
- …
state 1
- Michigan · 47,462 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814625 | 1814625 | 2021-10-14 | Chippewa | Michigan | 26033 | 6676 | 58 |
1814626 | 1814626 | 2021-10-14 | Clare | Michigan | 26035 | 3478 | 96 |
1814627 | 1814627 | 2021-10-14 | Clinton | Michigan | 26037 | 9561 | 103 |
1814628 | 1814628 | 2021-10-14 | Crawford | Michigan | 26039 | 1230 | 16 |
1814629 | 1814629 | 2021-10-14 | Delta | Michigan | 26041 | 5492 | 103 |
1814630 | 1814630 | 2021-10-14 | Dickinson | Michigan | 26043 | 3807 | 80 |
1814631 | 1814631 | 2021-10-14 | Eaton | Michigan | 26045 | 12605 | 234 |
1814632 | 1814632 | 2021-10-14 | Emmet | Michigan | 26047 | 3242 | 49 |
1814633 | 1814633 | 2021-10-14 | Genesee | Michigan | 26049 | 49645 | 1055 |
1814634 | 1814634 | 2021-10-14 | Gladwin | Michigan | 26051 | 3085 | 68 |
1814635 | 1814635 | 2021-10-14 | Gogebic | Michigan | 26053 | 1754 | 53 |
1814636 | 1814636 | 2021-10-14 | Grand Traverse | Michigan | 26055 | 8455 | 117 |
1814637 | 1814637 | 2021-10-14 | Gratiot | Michigan | 26057 | 8257 | 129 |
1814638 | 1814638 | 2021-10-14 | Hillsdale | Michigan | 26059 | 5871 | 116 |
1814639 | 1814639 | 2021-10-14 | Houghton | Michigan | 26061 | 3776 | 54 |
1814640 | 1814640 | 2021-10-14 | Huron | Michigan | 26063 | 4620 | 89 |
1814641 | 1814641 | 2021-10-14 | Ingham | Michigan | 26065 | 29858 | 441 |
1814642 | 1814642 | 2021-10-14 | Ionia | Michigan | 26067 | 11306 | 95 |
1814643 | 1814643 | 2021-10-14 | Iosco | Michigan | 26069 | 2768 | 90 |
1814644 | 1814644 | 2021-10-14 | Iron | Michigan | 26071 | 1362 | 54 |
1814645 | 1814645 | 2021-10-14 | Isabella | Michigan | 26073 | 8449 | 109 |
1814646 | 1814646 | 2021-10-14 | Jackson | Michigan | 26075 | 24791 | 351 |
1814647 | 1814647 | 2021-10-14 | Kalamazoo | Michigan | 26077 | 28528 | 441 |
1814648 | 1814648 | 2021-10-14 | Kalkaska | Michigan | 26079 | 1664 | 35 |
1814649 | 1814649 | 2021-10-14 | Kent | Michigan | 26081 | 89258 | 959 |
1814650 | 1814650 | 2021-10-14 | Keweenaw | Michigan | 26083 | 233 | 4 |
1814651 | 1814651 | 2021-10-14 | Lake | Michigan | 26085 | 901 | 20 |
1814652 | 1814652 | 2021-10-14 | Lapeer | Michigan | 26087 | 11626 | 244 |
1814653 | 1814653 | 2021-10-14 | Leelanau | Michigan | 26089 | 1567 | 24 |
1814654 | 1814654 | 2021-10-14 | Lenawee | Michigan | 26091 | 13763 | 197 |
1814655 | 1814655 | 2021-10-14 | Livingston | Michigan | 26093 | 21878 | 229 |
1814656 | 1814656 | 2021-10-14 | Luce | Michigan | 26095 | 1535 | 6 |
1814657 | 1814657 | 2021-10-14 | Mackinac | Michigan | 26097 | 1187 | 7 |
1814658 | 1814658 | 2021-10-14 | Macomb | Michigan | 26099 | 117513 | 2639 |
1814659 | 1814659 | 2021-10-14 | Manistee | Michigan | 26101 | 2393 | 34 |
1814660 | 1814660 | 2021-10-14 | Marquette | Michigan | 26103 | 7601 | 74 |
1814661 | 1814661 | 2021-10-14 | Mason | Michigan | 26105 | 2942 | 45 |
1814662 | 1814662 | 2021-10-14 | Mecosta | Michigan | 26107 | 4371 | 41 |
1814663 | 1814663 | 2021-10-14 | Menominee | Michigan | 26109 | 3168 | 48 |
1814664 | 1814664 | 2021-10-14 | Midland | Michigan | 26111 | 9756 | 126 |
1814665 | 1814665 | 2021-10-14 | Missaukee | Michigan | 26113 | 1780 | 32 |
1814666 | 1814666 | 2021-10-14 | Monroe | Michigan | 26115 | 19394 | 294 |
1814667 | 1814667 | 2021-10-14 | Montcalm | Michigan | 26117 | 10149 | 128 |
1814668 | 1814668 | 2021-10-14 | Montmorency | Michigan | 26119 | 848 | 24 |
1814669 | 1814669 | 2021-10-14 | Muskegon | Michigan | 26121 | 22441 | 417 |
1814670 | 1814670 | 2021-10-14 | Newaygo | Michigan | 26123 | 6243 | 79 |
1814671 | 1814671 | 2021-10-14 | Oakland | Michigan | 26125 | 140924 | 2628 |
1814672 | 1814672 | 2021-10-14 | Oceana | Michigan | 26127 | 3537 | 67 |
1814673 | 1814673 | 2021-10-14 | Ogemaw | Michigan | 26129 | 2548 | 52 |
1814674 | 1814674 | 2021-10-14 | Ontonagon | Michigan | 26131 | 590 | 22 |
1814675 | 1814675 | 2021-10-14 | Osceola | Michigan | 26133 | 2764 | 34 |
1814676 | 1814676 | 2021-10-14 | Oscoda | Michigan | 26135 | 889 | 33 |
1814677 | 1814677 | 2021-10-14 | Otsego | Michigan | 26137 | 3103 | 51 |
1814678 | 1814678 | 2021-10-14 | Ottawa | Michigan | 26139 | 39679 | 488 |
1814679 | 1814679 | 2021-10-14 | Presque Isle | Michigan | 26141 | 1302 | 36 |
1814680 | 1814680 | 2021-10-14 | Roscommon | Michigan | 26143 | 2305 | 61 |
1814681 | 1814681 | 2021-10-14 | Saginaw | Michigan | 26145 | 27186 | 667 |
1814682 | 1814682 | 2021-10-14 | Sanilac | Michigan | 26151 | 4791 | 131 |
1814683 | 1814683 | 2021-10-14 | Schoolcraft | Michigan | 26153 | 735 | 5 |
1814684 | 1814684 | 2021-10-14 | Shiawassee | Michigan | 26155 | 8238 | 124 |
1814685 | 1814685 | 2021-10-14 | St. Clair | Michigan | 26147 | 21579 | 503 |
1814686 | 1814686 | 2021-10-14 | St. Joseph | Michigan | 26149 | 7993 | 115 |
1814687 | 1814687 | 2021-10-14 | Tuscola | Michigan | 26157 | 7053 | 188 |
1814688 | 1814688 | 2021-10-14 | Unknown | Michigan | 802 | 12 | |
1814689 | 1814689 | 2021-10-14 | Van Buren | Michigan | 26159 | 8867 | 156 |
1814690 | 1814690 | 2021-10-14 | Washtenaw | Michigan | 26161 | 32829 | 330 |
1814691 | 1814691 | 2021-10-14 | Wayne | Michigan | 26163 | 192783 | 5494 |
1814692 | 1814692 | 2021-10-14 | Wexford | Michigan | 26165 | 3433 | 51 |
1811361 | 1811361 | 2021-10-13 | Alcona | Michigan | 26001 | 1026 | 40 |
1811362 | 1811362 | 2021-10-13 | Alger | Michigan | 26003 | 972 | 8 |
1811363 | 1811363 | 2021-10-13 | Allegan | Michigan | 26005 | 14011 | 181 |
1811364 | 1811364 | 2021-10-13 | Alpena | Michigan | 26007 | 2927 | 69 |
1811365 | 1811365 | 2021-10-13 | Antrim | Michigan | 26009 | 2229 | 35 |
1811366 | 1811366 | 2021-10-13 | Arenac | Michigan | 26011 | 1633 | 32 |
1811367 | 1811367 | 2021-10-13 | Baraga | Michigan | 26013 | 1226 | 46 |
1811368 | 1811368 | 2021-10-13 | Barry | Michigan | 26015 | 7417 | 79 |
1811369 | 1811369 | 2021-10-13 | Bay | Michigan | 26017 | 14015 | 377 |
1811370 | 1811370 | 2021-10-13 | Benzie | Michigan | 26019 | 1583 | 38 |
1811371 | 1811371 | 2021-10-13 | Berrien | Michigan | 26021 | 18692 | 324 |
1811372 | 1811372 | 2021-10-13 | Branch | Michigan | 26023 | 7078 | 134 |
1811373 | 1811373 | 2021-10-13 | Calhoun | Michigan | 26025 | 18000 | 342 |
1811374 | 1811374 | 2021-10-13 | Cass | Michigan | 26027 | 6848 | 88 |
1811375 | 1811375 | 2021-10-13 | Charlevoix | Michigan | 26029 | 2354 | 31 |
1811376 | 1811376 | 2021-10-13 | Cheboygan | Michigan | 26031 | 2653 | 63 |
1811377 | 1811377 | 2021-10-13 | Chippewa | Michigan | 26033 | 6676 | 58 |
1811378 | 1811378 | 2021-10-13 | Clare | Michigan | 26035 | 3478 | 96 |
1811379 | 1811379 | 2021-10-13 | Clinton | Michigan | 26037 | 9561 | 103 |
1811380 | 1811380 | 2021-10-13 | Crawford | Michigan | 26039 | 1230 | 16 |
1811381 | 1811381 | 2021-10-13 | Delta | Michigan | 26041 | 5492 | 103 |
1811382 | 1811382 | 2021-10-13 | Dickinson | Michigan | 26043 | 3807 | 80 |
1811383 | 1811383 | 2021-10-13 | Eaton | Michigan | 26045 | 12605 | 234 |
1811384 | 1811384 | 2021-10-13 | Emmet | Michigan | 26047 | 3224 | 49 |
1811385 | 1811385 | 2021-10-13 | Genesee | Michigan | 26049 | 49645 | 1055 |
1811386 | 1811386 | 2021-10-13 | Gladwin | Michigan | 26051 | 3085 | 68 |
1811387 | 1811387 | 2021-10-13 | Gogebic | Michigan | 26053 | 1754 | 53 |
1811388 | 1811388 | 2021-10-13 | Grand Traverse | Michigan | 26055 | 8455 | 117 |
1811389 | 1811389 | 2021-10-13 | Gratiot | Michigan | 26057 | 8257 | 129 |
1811390 | 1811390 | 2021-10-13 | Hillsdale | Michigan | 26059 | 5871 | 116 |
1811391 | 1811391 | 2021-10-13 | Houghton | Michigan | 26061 | 3776 | 54 |
1811392 | 1811392 | 2021-10-13 | Huron | Michigan | 26063 | 4620 | 89 |
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);