ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2021-08-30 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1668410 | 1668410 | 2021-08-30 | Alcona | Michigan | 26001 | 825 | 36 |
1668411 | 1668411 | 2021-08-30 | Alger | Michigan | 26003 | 708 | 7 |
1668412 | 1668412 | 2021-08-30 | Allegan | Michigan | 26005 | 12019 | 165 |
1668413 | 1668413 | 2021-08-30 | Alpena | Michigan | 26007 | 2496 | 66 |
1668414 | 1668414 | 2021-08-30 | Antrim | Michigan | 26009 | 1757 | 33 |
1668415 | 1668415 | 2021-08-30 | Arenac | Michigan | 26011 | 1291 | 30 |
1668416 | 1668416 | 2021-08-30 | Baraga | Michigan | 26013 | 1045 | 41 |
1668417 | 1668417 | 2021-08-30 | Barry | Michigan | 26015 | 6342 | 74 |
1668418 | 1668418 | 2021-08-30 | Bay | Michigan | 26017 | 11794 | 363 |
1668419 | 1668419 | 2021-08-30 | Benzie | Michigan | 26019 | 1353 | 38 |
1668420 | 1668420 | 2021-08-30 | Berrien | Michigan | 26021 | 16548 | 305 |
1668421 | 1668421 | 2021-08-30 | Branch | Michigan | 26023 | 6378 | 125 |
1668422 | 1668422 | 2021-08-30 | Calhoun | Michigan | 26025 | 15513 | 327 |
1668423 | 1668423 | 2021-08-30 | Cass | Michigan | 26027 | 5863 | 79 |
1668424 | 1668424 | 2021-08-30 | Charlevoix | Michigan | 26029 | 1916 | 26 |
1668425 | 1668425 | 2021-08-30 | Cheboygan | Michigan | 26031 | 2059 | 52 |
1668426 | 1668426 | 2021-08-30 | Chippewa | Michigan | 26033 | 5805 | 50 |
1668427 | 1668427 | 2021-08-30 | Clare | Michigan | 26035 | 2667 | 88 |
1668428 | 1668428 | 2021-08-30 | Clinton | Michigan | 26037 | 8121 | 97 |
1668429 | 1668429 | 2021-08-30 | Crawford | Michigan | 26039 | 1051 | 14 |
1668430 | 1668430 | 2021-08-30 | Delta | Michigan | 26041 | 4456 | 95 |
1668431 | 1668431 | 2021-08-30 | Dickinson | Michigan | 26043 | 2925 | 74 |
1668432 | 1668432 | 2021-08-30 | Eaton | Michigan | 26045 | 10863 | 213 |
1668433 | 1668433 | 2021-08-30 | Emmet | Michigan | 26047 | 2581 | 45 |
1668434 | 1668434 | 2021-08-30 | Genesee | Michigan | 26049 | 44044 | 999 |
1668435 | 1668435 | 2021-08-30 | Gladwin | Michigan | 26051 | 2431 | 62 |
1668436 | 1668436 | 2021-08-30 | Gogebic | Michigan | 26053 | 1526 | 53 |
1668437 | 1668437 | 2021-08-30 | Grand Traverse | Michigan | 26055 | 6995 | 102 |
1668438 | 1668438 | 2021-08-30 | Gratiot | Michigan | 26057 | 7172 | 126 |
1668439 | 1668439 | 2021-08-30 | Hillsdale | Michigan | 26059 | 4743 | 98 |
1668440 | 1668440 | 2021-08-30 | Houghton | Michigan | 26061 | 3303 | 44 |
1668441 | 1668441 | 2021-08-30 | Huron | Michigan | 26063 | 4282 | 86 |
1668442 | 1668442 | 2021-08-30 | Ingham | Michigan | 26065 | 26420 | 408 |
1668443 | 1668443 | 2021-08-30 | Ionia | Michigan | 26067 | 9725 | 86 |
1668444 | 1668444 | 2021-08-30 | Iosco | Michigan | 26069 | 2173 | 78 |
1668445 | 1668445 | 2021-08-30 | Iron | Michigan | 26071 | 1132 | 53 |
1668446 | 1668446 | 2021-08-30 | Isabella | Michigan | 26073 | 6626 | 102 |
1668447 | 1668447 | 2021-08-30 | Jackson | Michigan | 26075 | 22244 | 335 |
1668448 | 1668448 | 2021-08-30 | Kalamazoo | Michigan | 26077 | 25056 | 414 |
1668449 | 1668449 | 2021-08-30 | Kalkaska | Michigan | 26079 | 1245 | 29 |
1668450 | 1668450 | 2021-08-30 | Kent | Michigan | 26081 | 77834 | 889 |
1668451 | 1668451 | 2021-08-30 | Keweenaw | Michigan | 26083 | 183 | 2 |
1668452 | 1668452 | 2021-08-30 | Lake | Michigan | 26085 | 697 | 17 |
1668453 | 1668453 | 2021-08-30 | Lapeer | Michigan | 26087 | 10271 | 218 |
1668454 | 1668454 | 2021-08-30 | Leelanau | Michigan | 26089 | 1355 | 21 |
1668455 | 1668455 | 2021-08-30 | Lenawee | Michigan | 26091 | 11554 | 183 |
1668456 | 1668456 | 2021-08-30 | Livingston | Michigan | 26093 | 18304 | 204 |
1668457 | 1668457 | 2021-08-30 | Luce | Michigan | 26095 | 1358 | 6 |
1668458 | 1668458 | 2021-08-30 | Mackinac | Michigan | 26097 | 796 | 3 |
1668459 | 1668459 | 2021-08-30 | Macomb | Michigan | 26099 | 105803 | 2540 |
1668460 | 1668460 | 2021-08-30 | Manistee | Michigan | 26101 | 2118 | 28 |
1668461 | 1668461 | 2021-08-30 | Marquette | Michigan | 26103 | 6126 | 66 |
1668462 | 1668462 | 2021-08-30 | Mason | Michigan | 26105 | 2380 | 39 |
1668463 | 1668463 | 2021-08-30 | Mecosta | Michigan | 26107 | 3400 | 38 |
1668464 | 1668464 | 2021-08-30 | Menominee | Michigan | 26109 | 2376 | 44 |
1668465 | 1668465 | 2021-08-30 | Midland | Michigan | 26111 | 8019 | 101 |
1668466 | 1668466 | 2021-08-30 | Missaukee | Michigan | 26113 | 1557 | 29 |
1668467 | 1668467 | 2021-08-30 | Monroe | Michigan | 26115 | 16368 | 273 |
1668468 | 1668468 | 2021-08-30 | Montcalm | Michigan | 26117 | 8533 | 123 |
1668469 | 1668469 | 2021-08-30 | Montmorency | Michigan | 26119 | 693 | 20 |
1668470 | 1668470 | 2021-08-30 | Muskegon | Michigan | 26121 | 19428 | 389 |
1668471 | 1668471 | 2021-08-30 | Newaygo | Michigan | 26123 | 5110 | 70 |
1668472 | 1668472 | 2021-08-30 | Oakland | Michigan | 26125 | 126572 | 2509 |
1668473 | 1668473 | 2021-08-30 | Oceana | Michigan | 26127 | 2891 | 61 |
1668474 | 1668474 | 2021-08-30 | Ogemaw | Michigan | 26129 | 1901 | 44 |
1668475 | 1668475 | 2021-08-30 | Ontonagon | Michigan | 26131 | 522 | 22 |
1668476 | 1668476 | 2021-08-30 | Osceola | Michigan | 26133 | 2070 | 31 |
1668477 | 1668477 | 2021-08-30 | Oscoda | Michigan | 26135 | 722 | 31 |
1668478 | 1668478 | 2021-08-30 | Otsego | Michigan | 26137 | 2514 | 41 |
1668479 | 1668479 | 2021-08-30 | Ottawa | Michigan | 26139 | 34862 | 451 |
1668480 | 1668480 | 2021-08-30 | Presque Isle | Michigan | 26141 | 1105 | 34 |
1668481 | 1668481 | 2021-08-30 | Roscommon | Michigan | 26143 | 1976 | 55 |
1668482 | 1668482 | 2021-08-30 | Saginaw | Michigan | 26145 | 23857 | 646 |
1668483 | 1668483 | 2021-08-30 | Sanilac | Michigan | 26151 | 4378 | 127 |
1668484 | 1668484 | 2021-08-30 | Schoolcraft | Michigan | 26153 | 485 | 5 |
1668485 | 1668485 | 2021-08-30 | Shiawassee | Michigan | 26155 | 6912 | 112 |
1668486 | 1668486 | 2021-08-30 | St. Clair | Michigan | 26147 | 19216 | 460 |
1668487 | 1668487 | 2021-08-30 | St. Joseph | Michigan | 26149 | 6688 | 104 |
1668488 | 1668488 | 2021-08-30 | Tuscola | Michigan | 26157 | 5971 | 176 |
1668489 | 1668489 | 2021-08-30 | Unknown | Michigan | 806 | 18 | |
1668490 | 1668490 | 2021-08-30 | Van Buren | Michigan | 26159 | 7657 | 139 |
1668491 | 1668491 | 2021-08-30 | Washtenaw | Michigan | 26161 | 28881 | 315 |
1668492 | 1668492 | 2021-08-30 | Wayne | Michigan | 26163 | 175854 | 5284 |
1668493 | 1668493 | 2021-08-30 | Wexford | Michigan | 26165 | 2989 | 48 |
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);