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 220
- 26163 220
- 26065 218
- 26081 218
- 26117 218
- 26147 218
- 26161 218
- 26089 217
- 26099 217
- 26017 216
- 26029 216
- 26115 216
- 26139 215
- 26075 213
- 26137 213
- 26037 211
- 26045 211
- 26049 211
- 26093 211
- 26111 211
- 26035 209
- 26145 209
- 26157 209
- 26165 209
- 26005 208
- 26015 208
- 26021 208
- 26025 208
- 26047 208
- 26051 208
- …
county >30
- Oakland 220
- Wayne 220
- Ingham 218
- Kent 218
- Montcalm 218
- St. Clair 218
- Washtenaw 218
- Leelanau 217
- Macomb 217
- Bay 216
- Charlevoix 216
- Monroe 216
- Ottawa 215
- Jackson 213
- Otsego 213
- Clinton 211
- Eaton 211
- Genesee 211
- Livingston 211
- Midland 211
- Clare 209
- Saginaw 209
- Tuscola 209
- Wexford 209
- Allegan 208
- Barry 208
- Berrien 208
- Calhoun 208
- Emmet 208
- Gladwin 208
- …
state 1
- Michigan · 16,886 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
632897 | 632897 | 2020-10-15 | Chippewa | Michigan | 26033 | 98 | 0 |
632898 | 632898 | 2020-10-15 | Clare | Michigan | 26035 | 189 | 6 |
632899 | 632899 | 2020-10-15 | Clinton | Michigan | 26037 | 844 | 14 |
632900 | 632900 | 2020-10-15 | Crawford | Michigan | 26039 | 132 | 5 |
632901 | 632901 | 2020-10-15 | Delta | Michigan | 26041 | 912 | 16 |
632902 | 632902 | 2020-10-15 | Dickinson | Michigan | 26043 | 382 | 5 |
632903 | 632903 | 2020-10-15 | Eaton | Michigan | 26045 | 878 | 10 |
632904 | 632904 | 2020-10-15 | Emmet | Michigan | 26047 | 182 | 4 |
632905 | 632905 | 2020-10-15 | Genesee | Michigan | 26049 | 5694 | 320 |
632906 | 632906 | 2020-10-15 | Gladwin | Michigan | 26051 | 147 | 2 |
632907 | 632907 | 2020-10-15 | Gogebic | Michigan | 26053 | 224 | 2 |
632908 | 632908 | 2020-10-15 | Grand Traverse | Michigan | 26055 | 619 | 12 |
632909 | 632909 | 2020-10-15 | Gratiot | Michigan | 26057 | 395 | 16 |
632910 | 632910 | 2020-10-15 | Hillsdale | Michigan | 26059 | 429 | 27 |
632911 | 632911 | 2020-10-15 | Houghton | Michigan | 26061 | 832 | 6 |
632912 | 632912 | 2020-10-15 | Huron | Michigan | 26063 | 251 | 5 |
632913 | 632913 | 2020-10-15 | Ingham | Michigan | 26065 | 4176 | 57 |
632914 | 632914 | 2020-10-15 | Ionia | Michigan | 26067 | 697 | 8 |
632915 | 632915 | 2020-10-15 | Iosco | Michigan | 26069 | 253 | 14 |
632916 | 632916 | 2020-10-15 | Iron | Michigan | 26071 | 315 | 17 |
632917 | 632917 | 2020-10-15 | Isabella | Michigan | 26073 | 878 | 15 |
632918 | 632918 | 2020-10-15 | Jackson | Michigan | 26075 | 3122 | 82 |
632919 | 632919 | 2020-10-15 | Kalamazoo | Michigan | 26077 | 3932 | 99 |
632920 | 632920 | 2020-10-15 | Kalkaska | Michigan | 26079 | 106 | 4 |
632921 | 632921 | 2020-10-15 | Kent | Michigan | 26081 | 12030 | 173 |
632922 | 632922 | 2020-10-15 | Keweenaw | Michigan | 26083 | 16 | 0 |
632923 | 632923 | 2020-10-15 | Lake | Michigan | 26085 | 40 | 0 |
632924 | 632924 | 2020-10-15 | Lapeer | Michigan | 26087 | 1064 | 45 |
632925 | 632925 | 2020-10-15 | Leelanau | Michigan | 26089 | 125 | 1 |
632926 | 632926 | 2020-10-15 | Lenawee | Michigan | 26091 | 1713 | 22 |
632927 | 632927 | 2020-10-15 | Livingston | Michigan | 26093 | 1743 | 33 |
632928 | 632928 | 2020-10-15 | Luce | Michigan | 26095 | 284 | 0 |
632929 | 632929 | 2020-10-15 | Mackinac | Michigan | 26097 | 123 | 0 |
632930 | 632930 | 2020-10-15 | Macomb | Michigan | 26099 | 16793 | 1060 |
632931 | 632931 | 2020-10-15 | Manistee | Michigan | 26101 | 115 | 3 |
632932 | 632932 | 2020-10-15 | Marquette | Michigan | 26103 | 655 | 12 |
632933 | 632933 | 2020-10-15 | Mason | Michigan | 26105 | 164 | 1 |
632934 | 632934 | 2020-10-15 | Mecosta | Michigan | 26107 | 326 | 4 |
632935 | 632935 | 2020-10-15 | Menominee | Michigan | 26109 | 577 | 3 |
632936 | 632936 | 2020-10-15 | Midland | Michigan | 26111 | 767 | 13 |
632937 | 632937 | 2020-10-15 | Missaukee | Michigan | 26113 | 70 | 1 |
632938 | 632938 | 2020-10-15 | Monroe | Michigan | 26115 | 1753 | 29 |
632939 | 632939 | 2020-10-15 | Montcalm | Michigan | 26117 | 456 | 7 |
632940 | 632940 | 2020-10-15 | Montmorency | Michigan | 26119 | 19 | 0 |
632941 | 632941 | 2020-10-15 | Muskegon | Michigan | 26121 | 2772 | 78 |
632942 | 632942 | 2020-10-15 | Newaygo | Michigan | 26123 | 495 | 2 |
632943 | 632943 | 2020-10-15 | Oakland | Michigan | 26125 | 22571 | 1224 |
632944 | 632944 | 2020-10-15 | Oceana | Michigan | 26127 | 562 | 6 |
632945 | 632945 | 2020-10-15 | Ogemaw | Michigan | 26129 | 81 | 5 |
632946 | 632946 | 2020-10-15 | Ontonagon | Michigan | 26131 | 60 | 0 |
632947 | 632947 | 2020-10-15 | Osceola | Michigan | 26133 | 117 | 0 |
632948 | 632948 | 2020-10-15 | Oscoda | Michigan | 26135 | 50 | 1 |
632949 | 632949 | 2020-10-15 | Otsego | Michigan | 26137 | 214 | 12 |
632950 | 632950 | 2020-10-15 | Ottawa | Michigan | 26139 | 4187 | 70 |
632951 | 632951 | 2020-10-15 | Presque Isle | Michigan | 26141 | 33 | 1 |
632952 | 632952 | 2020-10-15 | Roscommon | Michigan | 26143 | 125 | 4 |
632953 | 632953 | 2020-10-15 | Saginaw | Michigan | 26145 | 3316 | 148 |
632954 | 632954 | 2020-10-15 | Sanilac | Michigan | 26151 | 163 | 7 |
632955 | 632955 | 2020-10-15 | Schoolcraft | Michigan | 26153 | 53 | 0 |
632956 | 632956 | 2020-10-15 | Shiawassee | Michigan | 26155 | 598 | 33 |
632957 | 632957 | 2020-10-15 | St. Clair | Michigan | 26147 | 1223 | 62 |
632958 | 632958 | 2020-10-15 | St. Joseph | Michigan | 26149 | 998 | 12 |
632959 | 632959 | 2020-10-15 | Tuscola | Michigan | 26157 | 557 | 34 |
632960 | 632960 | 2020-10-15 | Unknown | Michigan | 280 | 4 | |
632961 | 632961 | 2020-10-15 | Van Buren | Michigan | 26159 | 904 | 18 |
632962 | 632962 | 2020-10-15 | Washtenaw | Michigan | 26161 | 5004 | 126 |
632963 | 632963 | 2020-10-15 | Wayne | Michigan | 26163 | 37728 | 3019 |
632964 | 632964 | 2020-10-15 | Wexford | Michigan | 26165 | 149 | 4 |
629636 | 629636 | 2020-10-14 | Alcona | Michigan | 26001 | 50 | 2 |
629637 | 629637 | 2020-10-14 | Alger | Michigan | 26003 | 68 | 0 |
629638 | 629638 | 2020-10-14 | Allegan | Michigan | 26005 | 961 | 7 |
629639 | 629639 | 2020-10-14 | Alpena | Michigan | 26007 | 148 | 14 |
629640 | 629640 | 2020-10-14 | Antrim | Michigan | 26009 | 87 | 0 |
629641 | 629641 | 2020-10-14 | Arenac | Michigan | 26011 | 84 | 3 |
629642 | 629642 | 2020-10-14 | Baraga | Michigan | 26013 | 62 | 4 |
629643 | 629643 | 2020-10-14 | Barry | Michigan | 26015 | 476 | 4 |
629644 | 629644 | 2020-10-14 | Bay | Michigan | 26017 | 1158 | 55 |
629645 | 629645 | 2020-10-14 | Benzie | Michigan | 26019 | 97 | 2 |
629646 | 629646 | 2020-10-14 | Berrien | Michigan | 26021 | 2219 | 77 |
629647 | 629647 | 2020-10-14 | Branch | Michigan | 26023 | 1546 | 33 |
629648 | 629648 | 2020-10-14 | Calhoun | Michigan | 26025 | 1978 | 51 |
629649 | 629649 | 2020-10-14 | Cass | Michigan | 26027 | 732 | 22 |
629650 | 629650 | 2020-10-14 | Charlevoix | Michigan | 26029 | 129 | 4 |
629651 | 629651 | 2020-10-14 | Cheboygan | Michigan | 26031 | 104 | 2 |
629652 | 629652 | 2020-10-14 | Chippewa | Michigan | 26033 | 96 | 0 |
629653 | 629653 | 2020-10-14 | Clare | Michigan | 26035 | 168 | 6 |
629654 | 629654 | 2020-10-14 | Clinton | Michigan | 26037 | 821 | 14 |
629655 | 629655 | 2020-10-14 | Crawford | Michigan | 26039 | 132 | 5 |
629656 | 629656 | 2020-10-14 | Delta | Michigan | 26041 | 888 | 15 |
629657 | 629657 | 2020-10-14 | Dickinson | Michigan | 26043 | 355 | 4 |
629658 | 629658 | 2020-10-14 | Eaton | Michigan | 26045 | 852 | 10 |
629659 | 629659 | 2020-10-14 | Emmet | Michigan | 26047 | 180 | 4 |
629660 | 629660 | 2020-10-14 | Genesee | Michigan | 26049 | 5525 | 315 |
629661 | 629661 | 2020-10-14 | Gladwin | Michigan | 26051 | 139 | 2 |
629662 | 629662 | 2020-10-14 | Gogebic | Michigan | 26053 | 206 | 2 |
629663 | 629663 | 2020-10-14 | Grand Traverse | Michigan | 26055 | 605 | 12 |
629664 | 629664 | 2020-10-14 | Gratiot | Michigan | 26057 | 383 | 16 |
629665 | 629665 | 2020-10-14 | Hillsdale | Michigan | 26059 | 411 | 27 |
629666 | 629666 | 2020-10-14 | Houghton | Michigan | 26061 | 821 | 5 |
629667 | 629667 | 2020-10-14 | Huron | Michigan | 26063 | 251 | 5 |
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);