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 674
- 26163 674
- 26065 672
- 26081 672
- 26117 672
- 26147 672
- 26161 672
- 26089 671
- 26099 671
- 26017 670
- 26029 670
- 26115 670
- 26139 669
- 26075 667
- 26137 667
- 26037 665
- 26045 665
- 26049 665
- 26093 665
- 26111 665
- 26035 663
- 26145 663
- 26157 663
- 26165 663
- 26005 662
- 26015 662
- 26021 662
- 26025 662
- 26047 662
- 26051 662
- …
county >30
- Oakland 674
- Wayne 674
- Ingham 672
- Kent 672
- Montcalm 672
- St. Clair 672
- Washtenaw 672
- Leelanau 671
- Macomb 671
- Bay 670
- Charlevoix 670
- Monroe 670
- Ottawa 669
- Jackson 667
- Otsego 667
- Clinton 665
- Eaton 665
- Genesee 665
- Livingston 665
- Midland 665
- Clare 663
- Saginaw 663
- Tuscola 663
- Wexford 663
- Allegan 662
- Barry 662
- Berrien 662
- Calhoun 662
- Emmet 662
- Gladwin 662
- …
state 1
- Michigan · 55,022 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2107138 | 2107138 | 2022-01-12 | Chippewa | Michigan | 26033 | 9119 | 88 |
2107139 | 2107139 | 2022-01-12 | Clare | Michigan | 26035 | 5478 | 142 |
2107140 | 2107140 | 2022-01-12 | Clinton | Michigan | 26037 | 15953 | 170 |
2107141 | 2107141 | 2022-01-12 | Crawford | Michigan | 26039 | 2073 | 23 |
2107142 | 2107142 | 2022-01-12 | Delta | Michigan | 26041 | 7862 | 139 |
2107143 | 2107143 | 2022-01-12 | Dickinson | Michigan | 26043 | 5712 | 95 |
2107144 | 2107144 | 2022-01-12 | Eaton | Michigan | 26045 | 20884 | 333 |
2107145 | 2107145 | 2022-01-12 | Emmet | Michigan | 26047 | 5124 | 65 |
2107146 | 2107146 | 2022-01-12 | Genesee | Michigan | 26049 | 82639 | 1425 |
2107147 | 2107147 | 2022-01-12 | Gladwin | Michigan | 26051 | 4538 | 101 |
2107148 | 2107148 | 2022-01-12 | Gogebic | Michigan | 26053 | 2572 | 63 |
2107149 | 2107149 | 2022-01-12 | Grand Traverse | Michigan | 26055 | 13554 | 188 |
2107150 | 2107150 | 2022-01-12 | Gratiot | Michigan | 26057 | 11382 | 169 |
2107151 | 2107151 | 2022-01-12 | Hillsdale | Michigan | 26059 | 8619 | 176 |
2107152 | 2107152 | 2022-01-12 | Houghton | Michigan | 26061 | 6132 | 77 |
2107153 | 2107153 | 2022-01-12 | Huron | Michigan | 26063 | 6679 | 129 |
2107154 | 2107154 | 2022-01-12 | Ingham | Michigan | 26065 | 49440 | 612 |
2107155 | 2107155 | 2022-01-12 | Ionia | Michigan | 26067 | 16146 | 152 |
2107156 | 2107156 | 2022-01-12 | Iosco | Michigan | 26069 | 4090 | 119 |
2107157 | 2107157 | 2022-01-12 | Iron | Michigan | 26071 | 2041 | 74 |
2107158 | 2107158 | 2022-01-12 | Isabella | Michigan | 26073 | 12554 | 171 |
2107159 | 2107159 | 2022-01-12 | Jackson | Michigan | 26075 | 37305 | 489 |
2107160 | 2107160 | 2022-01-12 | Kalamazoo | Michigan | 26077 | 46870 | 569 |
2107161 | 2107161 | 2022-01-12 | Kalkaska | Michigan | 26079 | 2750 | 48 |
2107162 | 2107162 | 2022-01-12 | Kent | Michigan | 26081 | 138186 | 1326 |
2107163 | 2107163 | 2022-01-12 | Keweenaw | Michigan | 26083 | 409 | 11 |
2107164 | 2107164 | 2022-01-12 | Lake | Michigan | 26085 | 1477 | 32 |
2107165 | 2107165 | 2022-01-12 | Lapeer | Michigan | 26087 | 17555 | 363 |
2107166 | 2107166 | 2022-01-12 | Leelanau | Michigan | 26089 | 2834 | 42 |
2107167 | 2107167 | 2022-01-12 | Lenawee | Michigan | 26091 | 21216 | 272 |
2107168 | 2107168 | 2022-01-12 | Livingston | Michigan | 26093 | 37370 | 377 |
2107169 | 2107169 | 2022-01-12 | Luce | Michigan | 26095 | 1990 | 6 |
2107170 | 2107170 | 2022-01-12 | Mackinac | Michigan | 26097 | 1900 | 24 |
2107171 | 2107171 | 2022-01-12 | Macomb | Michigan | 26099 | 190201 | 3367 |
2107172 | 2107172 | 2022-01-12 | Manistee | Michigan | 26101 | 3516 | 65 |
2107173 | 2107173 | 2022-01-12 | Marquette | Michigan | 26103 | 11875 | 100 |
2107174 | 2107174 | 2022-01-12 | Mason | Michigan | 26105 | 5120 | 74 |
2107175 | 2107175 | 2022-01-12 | Mecosta | Michigan | 26107 | 6885 | 89 |
2107176 | 2107176 | 2022-01-12 | Menominee | Michigan | 26109 | 4550 | 64 |
2107177 | 2107177 | 2022-01-12 | Midland | Michigan | 26111 | 15049 | 193 |
2107178 | 2107178 | 2022-01-12 | Missaukee | Michigan | 26113 | 2348 | 54 |
2107179 | 2107179 | 2022-01-12 | Monroe | Michigan | 26115 | 31462 | 391 |
2107180 | 2107180 | 2022-01-12 | Montcalm | Michigan | 26117 | 14428 | 182 |
2107181 | 2107181 | 2022-01-12 | Montmorency | Michigan | 26119 | 1428 | 43 |
2107182 | 2107182 | 2022-01-12 | Muskegon | Michigan | 26121 | 34864 | 545 |
2107183 | 2107183 | 2022-01-12 | Newaygo | Michigan | 26123 | 9387 | 133 |
2107184 | 2107184 | 2022-01-12 | Oakland | Michigan | 26125 | 232417 | 3244 |
2107185 | 2107185 | 2022-01-12 | Oceana | Michigan | 26127 | 5191 | 84 |
2107186 | 2107186 | 2022-01-12 | Ogemaw | Michigan | 26129 | 3557 | 84 |
2107187 | 2107187 | 2022-01-12 | Ontonagon | Michigan | 26131 | 832 | 28 |
2107188 | 2107188 | 2022-01-12 | Osceola | Michigan | 26133 | 4113 | 66 |
2107189 | 2107189 | 2022-01-12 | Oscoda | Michigan | 26135 | 1227 | 51 |
2107190 | 2107190 | 2022-01-12 | Otsego | Michigan | 26137 | 4593 | 86 |
2107191 | 2107191 | 2022-01-12 | Ottawa | Michigan | 26139 | 61146 | 684 |
2107192 | 2107192 | 2022-01-12 | Presque Isle | Michigan | 26141 | 1826 | 52 |
2107193 | 2107193 | 2022-01-12 | Roscommon | Michigan | 26143 | 3861 | 107 |
2107194 | 2107194 | 2022-01-12 | Saginaw | Michigan | 26145 | 40757 | 833 |
2107195 | 2107195 | 2022-01-12 | Sanilac | Michigan | 26151 | 7309 | 168 |
2107196 | 2107196 | 2022-01-12 | Schoolcraft | Michigan | 26153 | 1365 | 9 |
2107197 | 2107197 | 2022-01-12 | Shiawassee | Michigan | 26155 | 14120 | 196 |
2107198 | 2107198 | 2022-01-12 | St. Clair | Michigan | 26147 | 34077 | 707 |
2107199 | 2107199 | 2022-01-12 | St. Joseph | Michigan | 26149 | 11489 | 171 |
2107200 | 2107200 | 2022-01-12 | Tuscola | Michigan | 26157 | 10762 | 247 |
2107201 | 2107201 | 2022-01-12 | Unknown | Michigan | 4158 | 27 | |
2107202 | 2107202 | 2022-01-12 | Van Buren | Michigan | 26159 | 14067 | 225 |
2107203 | 2107203 | 2022-01-12 | Washtenaw | Michigan | 26161 | 57534 | 440 |
2107204 | 2107204 | 2022-01-12 | Wayne | Michigan | 26163 | 325483 | 6734 |
2107205 | 2107205 | 2022-01-12 | Wexford | Michigan | 26165 | 5362 | 90 |
2103871 | 2103871 | 2022-01-11 | Alcona | Michigan | 26001 | 1486 | 59 |
2103872 | 2103872 | 2022-01-11 | Alger | Michigan | 26003 | 1367 | 11 |
2103873 | 2103873 | 2022-01-11 | Allegan | Michigan | 26005 | 21803 | 287 |
2103874 | 2103874 | 2022-01-11 | Alpena | Michigan | 26007 | 4717 | 117 |
2103875 | 2103875 | 2022-01-11 | Antrim | Michigan | 26009 | 3450 | 52 |
2103876 | 2103876 | 2022-01-11 | Arenac | Michigan | 26011 | 2521 | 55 |
2103877 | 2103877 | 2022-01-11 | Baraga | Michigan | 26013 | 1766 | 49 |
2103878 | 2103878 | 2022-01-11 | Barry | Michigan | 26015 | 11487 | 135 |
2103879 | 2103879 | 2022-01-11 | Bay | Michigan | 26017 | 20808 | 493 |
2103880 | 2103880 | 2022-01-11 | Benzie | Michigan | 26019 | 2606 | 56 |
2103881 | 2103881 | 2022-01-11 | Berrien | Michigan | 26021 | 27975 | 418 |
2103882 | 2103882 | 2022-01-11 | Branch | Michigan | 26023 | 9843 | 170 |
2103883 | 2103883 | 2022-01-11 | Calhoun | Michigan | 26025 | 26717 | 487 |
2103884 | 2103884 | 2022-01-11 | Cass | Michigan | 26027 | 9514 | 115 |
2103885 | 2103885 | 2022-01-11 | Charlevoix | Michigan | 26029 | 3853 | 53 |
2103886 | 2103886 | 2022-01-11 | Cheboygan | Michigan | 26031 | 3892 | 84 |
2103887 | 2103887 | 2022-01-11 | Chippewa | Michigan | 26033 | 8938 | 88 |
2103888 | 2103888 | 2022-01-11 | Clare | Michigan | 26035 | 5408 | 140 |
2103889 | 2103889 | 2022-01-11 | Clinton | Michigan | 26037 | 15617 | 170 |
2103890 | 2103890 | 2022-01-11 | Crawford | Michigan | 26039 | 2042 | 23 |
2103891 | 2103891 | 2022-01-11 | Delta | Michigan | 26041 | 7678 | 138 |
2103892 | 2103892 | 2022-01-11 | Dickinson | Michigan | 26043 | 5534 | 94 |
2103893 | 2103893 | 2022-01-11 | Eaton | Michigan | 26045 | 20369 | 331 |
2103894 | 2103894 | 2022-01-11 | Emmet | Michigan | 26047 | 4985 | 63 |
2103895 | 2103895 | 2022-01-11 | Genesee | Michigan | 26049 | 81052 | 1397 |
2103896 | 2103896 | 2022-01-11 | Gladwin | Michigan | 26051 | 4461 | 101 |
2103897 | 2103897 | 2022-01-11 | Gogebic | Michigan | 26053 | 2501 | 63 |
2103898 | 2103898 | 2022-01-11 | Grand Traverse | Michigan | 26055 | 13249 | 186 |
2103899 | 2103899 | 2022-01-11 | Gratiot | Michigan | 26057 | 11292 | 168 |
2103900 | 2103900 | 2022-01-11 | Hillsdale | Michigan | 26059 | 8545 | 175 |
2103901 | 2103901 | 2022-01-11 | Houghton | Michigan | 26061 | 6030 | 76 |
2103902 | 2103902 | 2022-01-11 | Huron | Michigan | 26063 | 6610 | 128 |
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);