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 115
- 26163 115
- 26065 113
- 26081 113
- 26117 113
- 26147 113
- 26161 113
- 26017 112
- 26029 112
- 26089 112
- 26099 112
- 26115 111
- 26139 110
- 26075 108
- 26137 108
- 26037 106
- 26045 106
- 26049 106
- 26093 106
- 26111 106
- 26005 104
- 26015 104
- 26021 104
- 26025 104
- 26035 104
- 26145 104
- 26157 104
- 26165 104
- 26047 103
- 26051 103
- …
county >30
- Oakland 115
- Wayne 115
- Ingham 113
- Kent 113
- Montcalm 113
- St. Clair 113
- Washtenaw 113
- Bay 112
- Charlevoix 112
- Leelanau 112
- Macomb 112
- Monroe 111
- Ottawa 110
- Jackson 108
- Otsego 108
- Clinton 106
- Eaton 106
- Genesee 106
- Livingston 106
- Midland 106
- Allegan 104
- Barry 104
- Berrien 104
- Calhoun 104
- Clare 104
- Saginaw 104
- Tuscola 104
- Wexford 104
- Emmet 103
- Gladwin 103
- …
state 1
- Michigan · 8,083 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
294603 | 294603 | 2020-07-02 | Alcona | Michigan | 26001 | 22 | 1 |
294604 | 294604 | 2020-07-02 | Alger | Michigan | 26003 | 4 | 0 |
294605 | 294605 | 2020-07-02 | Allegan | Michigan | 26005 | 325 | 7 |
294606 | 294606 | 2020-07-02 | Alpena | Michigan | 26007 | 122 | 12 |
294607 | 294607 | 2020-07-02 | Antrim | Michigan | 26009 | 20 | 0 |
294608 | 294608 | 2020-07-02 | Arenac | Michigan | 26011 | 38 | 2 |
294609 | 294609 | 2020-07-02 | Baraga | Michigan | 26013 | 5 | 0 |
294610 | 294610 | 2020-07-02 | Barry | Michigan | 26015 | 106 | 2 |
294611 | 294611 | 2020-07-02 | Bay | Michigan | 26017 | 396 | 30 |
294612 | 294612 | 2020-07-02 | Benzie | Michigan | 26019 | 10 | 0 |
294613 | 294613 | 2020-07-02 | Berrien | Michigan | 26021 | 963 | 60 |
294614 | 294614 | 2020-07-02 | Branch | Michigan | 26023 | 1050 | 25 |
294615 | 294615 | 2020-07-02 | Calhoun | Michigan | 26025 | 550 | 36 |
294616 | 294616 | 2020-07-02 | Cass | Michigan | 26027 | 152 | 5 |
294617 | 294617 | 2020-07-02 | Charlevoix | Michigan | 26029 | 30 | 2 |
294618 | 294618 | 2020-07-02 | Cheboygan | Michigan | 26031 | 27 | 2 |
294619 | 294619 | 2020-07-02 | Chippewa | Michigan | 26033 | 12 | 0 |
294620 | 294620 | 2020-07-02 | Clare | Michigan | 26035 | 29 | 3 |
294621 | 294621 | 2020-07-02 | Clinton | Michigan | 26037 | 236 | 12 |
294622 | 294622 | 2020-07-02 | Crawford | Michigan | 26039 | 70 | 5 |
294623 | 294623 | 2020-07-02 | Delta | Michigan | 26041 | 26 | 3 |
294624 | 294624 | 2020-07-02 | Dickinson | Michigan | 26043 | 7 | 2 |
294625 | 294625 | 2020-07-02 | Eaton | Michigan | 26045 | 320 | 7 |
294626 | 294626 | 2020-07-02 | Emmet | Michigan | 26047 | 29 | 2 |
294627 | 294627 | 2020-07-02 | Genesee | Michigan | 26049 | 2766 | 288 |
294628 | 294628 | 2020-07-02 | Gladwin | Michigan | 26051 | 27 | 1 |
294629 | 294629 | 2020-07-02 | Gogebic | Michigan | 26053 | 7 | 1 |
294630 | 294630 | 2020-07-02 | Grand Traverse | Michigan | 26055 | 53 | 5 |
294631 | 294631 | 2020-07-02 | Gratiot | Michigan | 26057 | 98 | 13 |
294632 | 294632 | 2020-07-02 | Hillsdale | Michigan | 26059 | 197 | 25 |
294633 | 294633 | 2020-07-02 | Houghton | Michigan | 26061 | 14 | 0 |
294634 | 294634 | 2020-07-02 | Huron | Michigan | 26063 | 66 | 3 |
294635 | 294635 | 2020-07-02 | Ingham | Michigan | 26065 | 1054 | 29 |
294636 | 294636 | 2020-07-02 | Ionia | Michigan | 26067 | 200 | 4 |
294637 | 294637 | 2020-07-02 | Iosco | Michigan | 26069 | 116 | 11 |
294638 | 294638 | 2020-07-02 | Iron | Michigan | 26071 | 6 | 1 |
294639 | 294639 | 2020-07-02 | Isabella | Michigan | 26073 | 128 | 8 |
294640 | 294640 | 2020-07-02 | Jackson | Michigan | 26075 | 2105 | 53 |
294641 | 294641 | 2020-07-02 | Kalamazoo | Michigan | 26077 | 1093 | 68 |
294642 | 294642 | 2020-07-02 | Kalkaska | Michigan | 26079 | 34 | 2 |
294643 | 294643 | 2020-07-02 | Kent | Michigan | 26081 | 5070 | 135 |
294644 | 294644 | 2020-07-02 | Keweenaw | Michigan | 26083 | 1 | 0 |
294645 | 294645 | 2020-07-02 | Lake | Michigan | 26085 | 9 | 0 |
294646 | 294646 | 2020-07-02 | Lapeer | Michigan | 26087 | 607 | 38 |
294647 | 294647 | 2020-07-02 | Leelanau | Michigan | 26089 | 19 | 0 |
294648 | 294648 | 2020-07-02 | Lenawee | Michigan | 26091 | 956 | 10 |
294649 | 294649 | 2020-07-02 | Livingston | Michigan | 26093 | 633 | 29 |
294650 | 294650 | 2020-07-02 | Luce | Michigan | 26095 | 4 | 0 |
294651 | 294651 | 2020-07-02 | Mackinac | Michigan | 26097 | 9 | 0 |
294652 | 294652 | 2020-07-02 | Macomb | Michigan | 26099 | 7709 | 922 |
294653 | 294653 | 2020-07-02 | Manistee | Michigan | 26101 | 31 | 0 |
294654 | 294654 | 2020-07-02 | Marquette | Michigan | 26103 | 70 | 11 |
294655 | 294655 | 2020-07-02 | Mason | Michigan | 26105 | 57 | 0 |
294656 | 294656 | 2020-07-02 | Mecosta | Michigan | 26107 | 29 | 2 |
294657 | 294657 | 2020-07-02 | Menominee | Michigan | 26109 | 16 | 0 |
294658 | 294658 | 2020-07-02 | Midland | Michigan | 26111 | 169 | 9 |
294659 | 294659 | 2020-07-02 | Missaukee | Michigan | 26113 | 29 | 1 |
294660 | 294660 | 2020-07-02 | Monroe | Michigan | 26115 | 619 | 21 |
294661 | 294661 | 2020-07-02 | Montcalm | Michigan | 26117 | 98 | 1 |
294662 | 294662 | 2020-07-02 | Montmorency | Michigan | 26119 | 5 | 0 |
294663 | 294663 | 2020-07-02 | Muskegon | Michigan | 26121 | 827 | 52 |
294664 | 294664 | 2020-07-02 | Newaygo | Michigan | 26123 | 176 | 0 |
294665 | 294665 | 2020-07-02 | Oakland | Michigan | 26125 | 12108 | 1091 |
294666 | 294666 | 2020-07-02 | Oceana | Michigan | 26127 | 307 | 3 |
294667 | 294667 | 2020-07-02 | Ogemaw | Michigan | 26129 | 34 | 2 |
294668 | 294668 | 2020-07-02 | Osceola | Michigan | 26133 | 30 | 0 |
294669 | 294669 | 2020-07-02 | Oscoda | Michigan | 26135 | 21 | 1 |
294670 | 294670 | 2020-07-02 | Otsego | Michigan | 26137 | 134 | 10 |
294671 | 294671 | 2020-07-02 | Ottawa | Michigan | 26139 | 1081 | 51 |
294672 | 294672 | 2020-07-02 | Presque Isle | Michigan | 26141 | 13 | 0 |
294673 | 294673 | 2020-07-02 | Roscommon | Michigan | 26143 | 28 | 0 |
294674 | 294674 | 2020-07-02 | Saginaw | Michigan | 26145 | 1302 | 123 |
294675 | 294675 | 2020-07-02 | Sanilac | Michigan | 26151 | 51 | 6 |
294676 | 294676 | 2020-07-02 | Schoolcraft | Michigan | 26153 | 4 | 0 |
294677 | 294677 | 2020-07-02 | Shiawassee | Michigan | 26155 | 276 | 28 |
294678 | 294678 | 2020-07-02 | St. Clair | Michigan | 26147 | 572 | 50 |
294679 | 294679 | 2020-07-02 | St. Joseph | Michigan | 26149 | 336 | 4 |
294680 | 294680 | 2020-07-02 | Tuscola | Michigan | 26157 | 232 | 26 |
294681 | 294681 | 2020-07-02 | Unknown | Michigan | 172 | 2 | |
294682 | 294682 | 2020-07-02 | Van Buren | Michigan | 26159 | 231 | 8 |
294683 | 294683 | 2020-07-02 | Washtenaw | Michigan | 26161 | 2217 | 116 |
294684 | 294684 | 2020-07-02 | Wayne | Michigan | 26163 | 23015 | 2730 |
294685 | 294685 | 2020-07-02 | Wexford | Michigan | 26165 | 33 | 4 |
291449 | 291449 | 2020-07-01 | Alcona | Michigan | 26001 | 21 | 1 |
291450 | 291450 | 2020-07-01 | Alger | Michigan | 26003 | 4 | 0 |
291451 | 291451 | 2020-07-01 | Allegan | Michigan | 26005 | 317 | 7 |
291452 | 291452 | 2020-07-01 | Alpena | Michigan | 26007 | 122 | 12 |
291453 | 291453 | 2020-07-01 | Antrim | Michigan | 26009 | 19 | 0 |
291454 | 291454 | 2020-07-01 | Arenac | Michigan | 26011 | 39 | 2 |
291455 | 291455 | 2020-07-01 | Baraga | Michigan | 26013 | 5 | 0 |
291456 | 291456 | 2020-07-01 | Barry | Michigan | 26015 | 103 | 2 |
291457 | 291457 | 2020-07-01 | Bay | Michigan | 26017 | 392 | 30 |
291458 | 291458 | 2020-07-01 | Benzie | Michigan | 26019 | 10 | 0 |
291459 | 291459 | 2020-07-01 | Berrien | Michigan | 26021 | 962 | 60 |
291460 | 291460 | 2020-07-01 | Branch | Michigan | 26023 | 1050 | 25 |
291461 | 291461 | 2020-07-01 | Calhoun | Michigan | 26025 | 539 | 33 |
291462 | 291462 | 2020-07-01 | Cass | Michigan | 26027 | 149 | 5 |
291463 | 291463 | 2020-07-01 | Charlevoix | Michigan | 26029 | 30 | 2 |
291464 | 291464 | 2020-07-01 | Cheboygan | Michigan | 26031 | 27 | 2 |
291465 | 291465 | 2020-07-01 | Chippewa | Michigan | 26033 | 12 | 0 |
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);