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
county >30
- Oakland 25
- Wayne 25
- Ingham 23
- Kent 23
- Montcalm 23
- St. Clair 23
- Washtenaw 23
- Bay 22
- Charlevoix 22
- Leelanau 22
- Macomb 22
- Monroe 21
- Ottawa 20
- Jackson 18
- Otsego 18
- Clinton 16
- Eaton 16
- Genesee 16
- Livingston 16
- Midland 16
- Allegan 14
- Barry 14
- Berrien 14
- Calhoun 14
- Clare 14
- Saginaw 14
- Tuscola 14
- Wexford 14
- Emmet 13
- Gladwin 13
- …
state 1
- Michigan · 884 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
29369 | 29369 | 2020-04-03 | Allegan | Michigan | 26005 | 6 | 0 |
29370 | 29370 | 2020-04-03 | Antrim | Michigan | 26009 | 4 | 0 |
29371 | 29371 | 2020-04-03 | Arenac | Michigan | 26011 | 2 | 0 |
29372 | 29372 | 2020-04-03 | Barry | Michigan | 26015 | 5 | 0 |
29373 | 29373 | 2020-04-03 | Bay | Michigan | 26017 | 18 | 0 |
29374 | 29374 | 2020-04-03 | Berrien | Michigan | 26021 | 52 | 1 |
29375 | 29375 | 2020-04-03 | Branch | Michigan | 26023 | 6 | 0 |
29376 | 29376 | 2020-04-03 | Calhoun | Michigan | 26025 | 31 | 1 |
29377 | 29377 | 2020-04-03 | Cass | Michigan | 26027 | 6 | 1 |
29378 | 29378 | 2020-04-03 | Charlevoix | Michigan | 26029 | 5 | 0 |
29379 | 29379 | 2020-04-03 | Cheboygan | Michigan | 26031 | 6 | 0 |
29380 | 29380 | 2020-04-03 | Chippewa | Michigan | 26033 | 1 | 0 |
29381 | 29381 | 2020-04-03 | Clare | Michigan | 26035 | 2 | 0 |
29382 | 29382 | 2020-04-03 | Clinton | Michigan | 26037 | 49 | 1 |
29383 | 29383 | 2020-04-03 | Crawford | Michigan | 26039 | 1 | 0 |
29384 | 29384 | 2020-04-03 | Delta | Michigan | 26041 | 5 | 0 |
29385 | 29385 | 2020-04-03 | Dickinson | Michigan | 26043 | 1 | 1 |
29386 | 29386 | 2020-04-03 | Eaton | Michigan | 26045 | 47 | 2 |
29387 | 29387 | 2020-04-03 | Emmet | Michigan | 26047 | 6 | 2 |
29388 | 29388 | 2020-04-03 | Genesee | Michigan | 26049 | 422 | 11 |
29389 | 29389 | 2020-04-03 | Gladwin | Michigan | 26051 | 2 | 0 |
29390 | 29390 | 2020-04-03 | Gogebic | Michigan | 26053 | 3 | 1 |
29391 | 29391 | 2020-04-03 | Grand Traverse | Michigan | 26055 | 11 | 2 |
29392 | 29392 | 2020-04-03 | Gratiot | Michigan | 26057 | 5 | 0 |
29393 | 29393 | 2020-04-03 | Hillsdale | Michigan | 26059 | 26 | 2 |
29394 | 29394 | 2020-04-03 | Houghton | Michigan | 26061 | 1 | 0 |
29395 | 29395 | 2020-04-03 | Huron | Michigan | 26063 | 4 | 0 |
29396 | 29396 | 2020-04-03 | Ingham | Michigan | 26065 | 152 | 1 |
29397 | 29397 | 2020-04-03 | Ionia | Michigan | 26067 | 6 | 0 |
29398 | 29398 | 2020-04-03 | Iosco | Michigan | 26069 | 1 | 0 |
29399 | 29399 | 2020-04-03 | Isabella | Michigan | 26073 | 9 | 2 |
29400 | 29400 | 2020-04-03 | Jackson | Michigan | 26075 | 69 | 3 |
29401 | 29401 | 2020-04-03 | Kalamazoo | Michigan | 26077 | 40 | 1 |
29402 | 29402 | 2020-04-03 | Kalkaska | Michigan | 26079 | 8 | 1 |
29403 | 29403 | 2020-04-03 | Kent | Michigan | 26081 | 136 | 2 |
29404 | 29404 | 2020-04-03 | Lapeer | Michigan | 26087 | 22 | 0 |
29405 | 29405 | 2020-04-03 | Leelanau | Michigan | 26089 | 1 | 0 |
29406 | 29406 | 2020-04-03 | Lenawee | Michigan | 26091 | 24 | 0 |
29407 | 29407 | 2020-04-03 | Livingston | Michigan | 26093 | 121 | 2 |
29408 | 29408 | 2020-04-03 | Luce | Michigan | 26095 | 1 | 0 |
29409 | 29409 | 2020-04-03 | Mackinac | Michigan | 26097 | 2 | 0 |
29410 | 29410 | 2020-04-03 | Macomb | Michigan | 26099 | 1560 | 65 |
29411 | 29411 | 2020-04-03 | Manistee | Michigan | 26101 | 1 | 0 |
29412 | 29412 | 2020-04-03 | Marquette | Michigan | 26103 | 7 | 0 |
29413 | 29413 | 2020-04-03 | Mecosta | Michigan | 26107 | 4 | 1 |
29414 | 29414 | 2020-04-03 | Midland | Michigan | 26111 | 16 | 0 |
29415 | 29415 | 2020-04-03 | Missaukee | Michigan | 26113 | 1 | 1 |
29416 | 29416 | 2020-04-03 | Monroe | Michigan | 26115 | 95 | 0 |
29417 | 29417 | 2020-04-03 | Montcalm | Michigan | 26117 | 12 | 0 |
29418 | 29418 | 2020-04-03 | Muskegon | Michigan | 26121 | 30 | 2 |
29419 | 29419 | 2020-04-03 | Newaygo | Michigan | 26123 | 2 | 0 |
29420 | 29420 | 2020-04-03 | Oakland | Michigan | 26125 | 2540 | 136 |
29421 | 29421 | 2020-04-03 | Oceana | Michigan | 26127 | 3 | 0 |
29422 | 29422 | 2020-04-03 | Ogemaw | Michigan | 26129 | 2 | 0 |
29423 | 29423 | 2020-04-03 | Osceola | Michigan | 26133 | 3 | 0 |
29424 | 29424 | 2020-04-03 | Oscoda | Michigan | 26135 | 2 | 0 |
29425 | 29425 | 2020-04-03 | Otsego | Michigan | 26137 | 20 | 0 |
29426 | 29426 | 2020-04-03 | Ottawa | Michigan | 26139 | 37 | 0 |
29427 | 29427 | 2020-04-03 | Roscommon | Michigan | 26143 | 2 | 0 |
29428 | 29428 | 2020-04-03 | Saginaw | Michigan | 26145 | 90 | 0 |
29429 | 29429 | 2020-04-03 | Sanilac | Michigan | 26151 | 10 | 1 |
29430 | 29430 | 2020-04-03 | Shiawassee | Michigan | 26155 | 18 | 0 |
29431 | 29431 | 2020-04-03 | St. Clair | Michigan | 26147 | 66 | 0 |
29432 | 29432 | 2020-04-03 | St. Joseph | Michigan | 26149 | 10 | 0 |
29433 | 29433 | 2020-04-03 | Tuscola | Michigan | 26157 | 15 | 2 |
29434 | 29434 | 2020-04-03 | Unknown | Michigan | 215 | 1 | |
29435 | 29435 | 2020-04-03 | Van Buren | Michigan | 26159 | 12 | 1 |
29436 | 29436 | 2020-04-03 | Washtenaw | Michigan | 26161 | 477 | 8 |
29437 | 29437 | 2020-04-03 | Wayne | Michigan | 26163 | 6096 | 223 |
29438 | 29438 | 2020-04-03 | Wexford | Michigan | 26165 | 4 | 0 |
27051 | 27051 | 2020-04-02 | Allegan | Michigan | 26005 | 5 | 0 |
27052 | 27052 | 2020-04-02 | Antrim | Michigan | 26009 | 4 | 0 |
27053 | 27053 | 2020-04-02 | Arenac | Michigan | 26011 | 1 | 0 |
27054 | 27054 | 2020-04-02 | Barry | Michigan | 26015 | 4 | 0 |
27055 | 27055 | 2020-04-02 | Bay | Michigan | 26017 | 16 | 0 |
27056 | 27056 | 2020-04-02 | Berrien | Michigan | 26021 | 40 | 1 |
27057 | 27057 | 2020-04-02 | Branch | Michigan | 26023 | 5 | 0 |
27058 | 27058 | 2020-04-02 | Calhoun | Michigan | 26025 | 25 | 0 |
27059 | 27059 | 2020-04-02 | Cass | Michigan | 26027 | 6 | 1 |
27060 | 27060 | 2020-04-02 | Charlevoix | Michigan | 26029 | 5 | 0 |
27061 | 27061 | 2020-04-02 | Cheboygan | Michigan | 26031 | 3 | 0 |
27062 | 27062 | 2020-04-02 | Chippewa | Michigan | 26033 | 1 | 0 |
27063 | 27063 | 2020-04-02 | Clare | Michigan | 26035 | 1 | 0 |
27064 | 27064 | 2020-04-02 | Clinton | Michigan | 26037 | 43 | 1 |
27065 | 27065 | 2020-04-02 | Crawford | Michigan | 26039 | 1 | 0 |
27066 | 27066 | 2020-04-02 | Delta | Michigan | 26041 | 4 | 0 |
27067 | 27067 | 2020-04-02 | Dickinson | Michigan | 26043 | 1 | 0 |
27068 | 27068 | 2020-04-02 | Eaton | Michigan | 26045 | 37 | 1 |
27069 | 27069 | 2020-04-02 | Emmet | Michigan | 26047 | 6 | 1 |
27070 | 27070 | 2020-04-02 | Genesee | Michigan | 26049 | 349 | 10 |
27071 | 27071 | 2020-04-02 | Gladwin | Michigan | 26051 | 2 | 0 |
27072 | 27072 | 2020-04-02 | Gogebic | Michigan | 26053 | 3 | 1 |
27073 | 27073 | 2020-04-02 | Grand Traverse | Michigan | 26055 | 9 | 2 |
27074 | 27074 | 2020-04-02 | Gratiot | Michigan | 26057 | 5 | 0 |
27075 | 27075 | 2020-04-02 | Hillsdale | Michigan | 26059 | 24 | 1 |
27076 | 27076 | 2020-04-02 | Houghton | Michigan | 26061 | 1 | 0 |
27077 | 27077 | 2020-04-02 | Huron | Michigan | 26063 | 4 | 0 |
27078 | 27078 | 2020-04-02 | Ingham | Michigan | 26065 | 128 | 1 |
27079 | 27079 | 2020-04-02 | Ionia | Michigan | 26067 | 5 | 0 |
27080 | 27080 | 2020-04-02 | Iosco | Michigan | 26069 | 1 | 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);