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 583
- 26163 583
- 26065 581
- 26081 581
- 26117 581
- 26147 581
- 26161 581
- 26089 580
- 26099 580
- 26017 579
- 26029 579
- 26115 579
- 26139 578
- 26075 576
- 26137 576
- 26093 574
- 26111 574
- 26037 573
- 26045 573
- 26049 573
- 26145 572
- 26157 572
- 26165 572
- 26005 571
- 26015 571
- 26021 571
- 26025 571
- 26035 571
- 26143 571
- 26047 570
- …
county >30
- Oakland 583
- Wayne 583
- Ingham 581
- Kent 581
- Montcalm 581
- St. Clair 581
- Washtenaw 581
- Leelanau 580
- Macomb 580
- Bay 579
- Charlevoix 579
- Monroe 579
- Ottawa 578
- Jackson 576
- Otsego 576
- Livingston 574
- Midland 574
- Clinton 573
- Eaton 573
- Genesee 573
- Saginaw 572
- Tuscola 572
- Wexford 572
- Allegan 571
- Barry 571
- Berrien 571
- Calhoun 571
- Clare 571
- Roscommon 571
- Emmet 570
- …
state 1
- Michigan · 47,362 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811393 | 1811393 | 2021-10-13 | Ingham | Michigan | 26065 | 29858 | 441 |
1811394 | 1811394 | 2021-10-13 | Ionia | Michigan | 26067 | 11306 | 95 |
1811395 | 1811395 | 2021-10-13 | Iosco | Michigan | 26069 | 2768 | 90 |
1811396 | 1811396 | 2021-10-13 | Iron | Michigan | 26071 | 1362 | 54 |
1811397 | 1811397 | 2021-10-13 | Isabella | Michigan | 26073 | 8449 | 109 |
1811398 | 1811398 | 2021-10-13 | Jackson | Michigan | 26075 | 24791 | 351 |
1811399 | 1811399 | 2021-10-13 | Kalamazoo | Michigan | 26077 | 28528 | 441 |
1811400 | 1811400 | 2021-10-13 | Kalkaska | Michigan | 26079 | 1664 | 35 |
1811401 | 1811401 | 2021-10-13 | Kent | Michigan | 26081 | 89258 | 959 |
1811402 | 1811402 | 2021-10-13 | Keweenaw | Michigan | 26083 | 233 | 4 |
1811403 | 1811403 | 2021-10-13 | Lake | Michigan | 26085 | 901 | 20 |
1811404 | 1811404 | 2021-10-13 | Lapeer | Michigan | 26087 | 11626 | 244 |
1811405 | 1811405 | 2021-10-13 | Leelanau | Michigan | 26089 | 1567 | 24 |
1811406 | 1811406 | 2021-10-13 | Lenawee | Michigan | 26091 | 13763 | 197 |
1811407 | 1811407 | 2021-10-13 | Livingston | Michigan | 26093 | 21878 | 229 |
1811408 | 1811408 | 2021-10-13 | Luce | Michigan | 26095 | 1535 | 6 |
1811409 | 1811409 | 2021-10-13 | Mackinac | Michigan | 26097 | 1187 | 7 |
1811410 | 1811410 | 2021-10-13 | Macomb | Michigan | 26099 | 117513 | 2639 |
1811411 | 1811411 | 2021-10-13 | Manistee | Michigan | 26101 | 2393 | 34 |
1811412 | 1811412 | 2021-10-13 | Marquette | Michigan | 26103 | 7601 | 74 |
1811413 | 1811413 | 2021-10-13 | Mason | Michigan | 26105 | 2942 | 45 |
1811414 | 1811414 | 2021-10-13 | Mecosta | Michigan | 26107 | 4371 | 41 |
1811415 | 1811415 | 2021-10-13 | Menominee | Michigan | 26109 | 3168 | 48 |
1811416 | 1811416 | 2021-10-13 | Midland | Michigan | 26111 | 9756 | 126 |
1811417 | 1811417 | 2021-10-13 | Missaukee | Michigan | 26113 | 1780 | 32 |
1811418 | 1811418 | 2021-10-13 | Monroe | Michigan | 26115 | 19394 | 294 |
1811419 | 1811419 | 2021-10-13 | Montcalm | Michigan | 26117 | 10149 | 128 |
1811420 | 1811420 | 2021-10-13 | Montmorency | Michigan | 26119 | 848 | 24 |
1811421 | 1811421 | 2021-10-13 | Muskegon | Michigan | 26121 | 22441 | 417 |
1811422 | 1811422 | 2021-10-13 | Newaygo | Michigan | 26123 | 6243 | 79 |
1811423 | 1811423 | 2021-10-13 | Oakland | Michigan | 26125 | 140924 | 2628 |
1811424 | 1811424 | 2021-10-13 | Oceana | Michigan | 26127 | 3537 | 67 |
1811425 | 1811425 | 2021-10-13 | Ogemaw | Michigan | 26129 | 2548 | 52 |
1811426 | 1811426 | 2021-10-13 | Ontonagon | Michigan | 26131 | 590 | 22 |
1811427 | 1811427 | 2021-10-13 | Osceola | Michigan | 26133 | 2764 | 34 |
1811428 | 1811428 | 2021-10-13 | Oscoda | Michigan | 26135 | 889 | 33 |
1811429 | 1811429 | 2021-10-13 | Otsego | Michigan | 26137 | 3085 | 51 |
1811430 | 1811430 | 2021-10-13 | Ottawa | Michigan | 26139 | 39679 | 488 |
1811431 | 1811431 | 2021-10-13 | Presque Isle | Michigan | 26141 | 1302 | 36 |
1811432 | 1811432 | 2021-10-13 | Roscommon | Michigan | 26143 | 2305 | 61 |
1811433 | 1811433 | 2021-10-13 | Saginaw | Michigan | 26145 | 27186 | 667 |
1811434 | 1811434 | 2021-10-13 | Sanilac | Michigan | 26151 | 4791 | 131 |
1811435 | 1811435 | 2021-10-13 | Schoolcraft | Michigan | 26153 | 735 | 5 |
1811436 | 1811436 | 2021-10-13 | Shiawassee | Michigan | 26155 | 8238 | 124 |
1811437 | 1811437 | 2021-10-13 | St. Clair | Michigan | 26147 | 21517 | 503 |
1811438 | 1811438 | 2021-10-13 | St. Joseph | Michigan | 26149 | 7993 | 115 |
1811439 | 1811439 | 2021-10-13 | Tuscola | Michigan | 26157 | 7053 | 188 |
1811440 | 1811440 | 2021-10-13 | Unknown | Michigan | 1094 | 15 | |
1811441 | 1811441 | 2021-10-13 | Van Buren | Michigan | 26159 | 8867 | 156 |
1811442 | 1811442 | 2021-10-13 | Washtenaw | Michigan | 26161 | 32656 | 328 |
1811443 | 1811443 | 2021-10-13 | Wayne | Michigan | 26163 | 192783 | 5494 |
1811444 | 1811444 | 2021-10-13 | Wexford | Michigan | 26165 | 3433 | 51 |
1808112 | 1808112 | 2021-10-12 | Alcona | Michigan | 26001 | 998 | 39 |
1808113 | 1808113 | 2021-10-12 | Alger | Michigan | 26003 | 953 | 8 |
1808114 | 1808114 | 2021-10-12 | Allegan | Michigan | 26005 | 13859 | 180 |
1808115 | 1808115 | 2021-10-12 | Alpena | Michigan | 26007 | 2885 | 69 |
1808116 | 1808116 | 2021-10-12 | Antrim | Michigan | 26009 | 2202 | 35 |
1808117 | 1808117 | 2021-10-12 | Arenac | Michigan | 26011 | 1591 | 32 |
1808118 | 1808118 | 2021-10-12 | Baraga | Michigan | 26013 | 1199 | 46 |
1808119 | 1808119 | 2021-10-12 | Barry | Michigan | 26015 | 7322 | 78 |
1808120 | 1808120 | 2021-10-12 | Bay | Michigan | 26017 | 13837 | 376 |
1808121 | 1808121 | 2021-10-12 | Benzie | Michigan | 26019 | 1568 | 38 |
1808122 | 1808122 | 2021-10-12 | Berrien | Michigan | 26021 | 18585 | 322 |
1808123 | 1808123 | 2021-10-12 | Branch | Michigan | 26023 | 7030 | 135 |
1808124 | 1808124 | 2021-10-12 | Calhoun | Michigan | 26025 | 17799 | 341 |
1808125 | 1808125 | 2021-10-12 | Cass | Michigan | 26027 | 6805 | 87 |
1808126 | 1808126 | 2021-10-12 | Charlevoix | Michigan | 26029 | 2342 | 31 |
1808127 | 1808127 | 2021-10-12 | Cheboygan | Michigan | 26031 | 2628 | 62 |
1808128 | 1808128 | 2021-10-12 | Chippewa | Michigan | 26033 | 6592 | 56 |
1808129 | 1808129 | 2021-10-12 | Clare | Michigan | 26035 | 3390 | 95 |
1808130 | 1808130 | 2021-10-12 | Clinton | Michigan | 26037 | 9410 | 103 |
1808131 | 1808131 | 2021-10-12 | Crawford | Michigan | 26039 | 1202 | 16 |
1808132 | 1808132 | 2021-10-12 | Delta | Michigan | 26041 | 5436 | 102 |
1808133 | 1808133 | 2021-10-12 | Dickinson | Michigan | 26043 | 3752 | 78 |
1808134 | 1808134 | 2021-10-12 | Eaton | Michigan | 26045 | 12494 | 233 |
1808135 | 1808135 | 2021-10-12 | Emmet | Michigan | 26047 | 3193 | 49 |
1808136 | 1808136 | 2021-10-12 | Genesee | Michigan | 26049 | 49156 | 1048 |
1808137 | 1808137 | 2021-10-12 | Gladwin | Michigan | 26051 | 3043 | 67 |
1808138 | 1808138 | 2021-10-12 | Gogebic | Michigan | 26053 | 1741 | 53 |
1808139 | 1808139 | 2021-10-12 | Grand Traverse | Michigan | 26055 | 8357 | 113 |
1808140 | 1808140 | 2021-10-12 | Gratiot | Michigan | 26057 | 8154 | 128 |
1808141 | 1808141 | 2021-10-12 | Hillsdale | Michigan | 26059 | 5804 | 114 |
1808142 | 1808142 | 2021-10-12 | Houghton | Michigan | 26061 | 3722 | 54 |
1808143 | 1808143 | 2021-10-12 | Huron | Michigan | 26063 | 4584 | 89 |
1808144 | 1808144 | 2021-10-12 | Ingham | Michigan | 26065 | 29623 | 437 |
1808145 | 1808145 | 2021-10-12 | Ionia | Michigan | 26067 | 11202 | 95 |
1808146 | 1808146 | 2021-10-12 | Iosco | Michigan | 26069 | 2725 | 88 |
1808147 | 1808147 | 2021-10-12 | Iron | Michigan | 26071 | 1337 | 54 |
1808148 | 1808148 | 2021-10-12 | Isabella | Michigan | 26073 | 8319 | 109 |
1808149 | 1808149 | 2021-10-12 | Jackson | Michigan | 26075 | 24595 | 351 |
1808150 | 1808150 | 2021-10-12 | Kalamazoo | Michigan | 26077 | 28289 | 439 |
1808151 | 1808151 | 2021-10-12 | Kalkaska | Michigan | 26079 | 1631 | 33 |
1808152 | 1808152 | 2021-10-12 | Kent | Michigan | 26081 | 88468 | 955 |
1808153 | 1808153 | 2021-10-12 | Keweenaw | Michigan | 26083 | 229 | 4 |
1808154 | 1808154 | 2021-10-12 | Lake | Michigan | 26085 | 888 | 19 |
1808155 | 1808155 | 2021-10-12 | Lapeer | Michigan | 26087 | 11504 | 243 |
1808156 | 1808156 | 2021-10-12 | Leelanau | Michigan | 26089 | 1558 | 24 |
1808157 | 1808157 | 2021-10-12 | Lenawee | Michigan | 26091 | 13614 | 195 |
1808158 | 1808158 | 2021-10-12 | Livingston | Michigan | 26093 | 21583 | 229 |
1808159 | 1808159 | 2021-10-12 | Luce | Michigan | 26095 | 1521 | 6 |
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);