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 2020-08-28 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
477446 | 477446 | 2020-08-28 | Alcona | Michigan | 26001 | 31 | 2 |
477447 | 477447 | 2020-08-28 | Alger | Michigan | 26003 | 17 | 0 |
477448 | 477448 | 2020-08-28 | Allegan | Michigan | 26005 | 620 | 6 |
477449 | 477449 | 2020-08-28 | Alpena | Michigan | 26007 | 132 | 14 |
477450 | 477450 | 2020-08-28 | Antrim | Michigan | 26009 | 55 | 0 |
477451 | 477451 | 2020-08-28 | Arenac | Michigan | 26011 | 53 | 3 |
477452 | 477452 | 2020-08-28 | Baraga | Michigan | 26013 | 8 | 0 |
477453 | 477453 | 2020-08-28 | Barry | Michigan | 26015 | 212 | 2 |
477454 | 477454 | 2020-08-28 | Bay | Michigan | 26017 | 803 | 41 |
477455 | 477455 | 2020-08-28 | Benzie | Michigan | 26019 | 46 | 2 |
477456 | 477456 | 2020-08-28 | Berrien | Michigan | 26021 | 1661 | 70 |
477457 | 477457 | 2020-08-28 | Branch | Michigan | 26023 | 1277 | 26 |
477458 | 477458 | 2020-08-28 | Calhoun | Michigan | 26025 | 958 | 44 |
477459 | 477459 | 2020-08-28 | Cass | Michigan | 26027 | 402 | 16 |
477460 | 477460 | 2020-08-28 | Charlevoix | Michigan | 26029 | 74 | 2 |
477461 | 477461 | 2020-08-28 | Cheboygan | Michigan | 26031 | 72 | 2 |
477462 | 477462 | 2020-08-28 | Chippewa | Michigan | 26033 | 57 | 0 |
477463 | 477463 | 2020-08-28 | Clare | Michigan | 26035 | 99 | 3 |
477464 | 477464 | 2020-08-28 | Clinton | Michigan | 26037 | 476 | 13 |
477465 | 477465 | 2020-08-28 | Crawford | Michigan | 26039 | 113 | 5 |
477466 | 477466 | 2020-08-28 | Delta | Michigan | 26041 | 142 | 3 |
477467 | 477467 | 2020-08-28 | Dickinson | Michigan | 26043 | 64 | 2 |
477468 | 477468 | 2020-08-28 | Eaton | Michigan | 26045 | 509 | 8 |
477469 | 477469 | 2020-08-28 | Emmet | Michigan | 26047 | 115 | 2 |
477470 | 477470 | 2020-08-28 | Genesee | Michigan | 26049 | 3942 | 303 |
477471 | 477471 | 2020-08-28 | Gladwin | Michigan | 26051 | 75 | 2 |
477472 | 477472 | 2020-08-28 | Gogebic | Michigan | 26053 | 142 | 1 |
477473 | 477473 | 2020-08-28 | Grand Traverse | Michigan | 26055 | 340 | 6 |
477474 | 477474 | 2020-08-28 | Gratiot | Michigan | 26057 | 189 | 15 |
477475 | 477475 | 2020-08-28 | Hillsdale | Michigan | 26059 | 300 | 26 |
477476 | 477476 | 2020-08-28 | Houghton | Michigan | 26061 | 64 | 0 |
477477 | 477477 | 2020-08-28 | Huron | Michigan | 26063 | 197 | 4 |
477478 | 477478 | 2020-08-28 | Ingham | Michigan | 26065 | 1749 | 38 |
477479 | 477479 | 2020-08-28 | Ionia | Michigan | 26067 | 296 | 7 |
477480 | 477480 | 2020-08-28 | Iosco | Michigan | 26069 | 141 | 12 |
477481 | 477481 | 2020-08-28 | Iron | Michigan | 26071 | 27 | 1 |
477482 | 477482 | 2020-08-28 | Isabella | Michigan | 26073 | 439 | 9 |
477483 | 477483 | 2020-08-28 | Jackson | Michigan | 26075 | 2536 | 62 |
477484 | 477484 | 2020-08-28 | Kalamazoo | Michigan | 26077 | 1912 | 87 |
477485 | 477485 | 2020-08-28 | Kalkaska | Michigan | 26079 | 64 | 4 |
477486 | 477486 | 2020-08-28 | Kent | Michigan | 26081 | 8353 | 162 |
477487 | 477487 | 2020-08-28 | Keweenaw | Michigan | 26083 | 2 | 0 |
477488 | 477488 | 2020-08-28 | Lake | Michigan | 26085 | 29 | 0 |
477489 | 477489 | 2020-08-28 | Lapeer | Michigan | 26087 | 832 | 42 |
477490 | 477490 | 2020-08-28 | Leelanau | Michigan | 26089 | 86 | 1 |
477491 | 477491 | 2020-08-28 | Lenawee | Michigan | 26091 | 1273 | 17 |
477492 | 477492 | 2020-08-28 | Livingston | Michigan | 26093 | 1121 | 30 |
477493 | 477493 | 2020-08-28 | Luce | Michigan | 26095 | 136 | 0 |
477494 | 477494 | 2020-08-28 | Mackinac | Michigan | 26097 | 34 | 0 |
477495 | 477495 | 2020-08-28 | Macomb | Michigan | 26099 | 12805 | 970 |
477496 | 477496 | 2020-08-28 | Manistee | Michigan | 26101 | 66 | 1 |
477497 | 477497 | 2020-08-28 | Marquette | Michigan | 26103 | 238 | 11 |
477498 | 477498 | 2020-08-28 | Mason | Michigan | 26105 | 119 | 0 |
477499 | 477499 | 2020-08-28 | Mecosta | Michigan | 26107 | 83 | 2 |
477500 | 477500 | 2020-08-28 | Menominee | Michigan | 26109 | 243 | 0 |
477501 | 477501 | 2020-08-28 | Midland | Michigan | 26111 | 407 | 11 |
477502 | 477502 | 2020-08-28 | Missaukee | Michigan | 26113 | 45 | 1 |
477503 | 477503 | 2020-08-28 | Monroe | Michigan | 26115 | 1269 | 27 |
477504 | 477504 | 2020-08-28 | Montcalm | Michigan | 26117 | 222 | 3 |
477505 | 477505 | 2020-08-28 | Montmorency | Michigan | 26119 | 12 | 0 |
477506 | 477506 | 2020-08-28 | Muskegon | Michigan | 26121 | 1928 | 65 |
477507 | 477507 | 2020-08-28 | Newaygo | Michigan | 26123 | 293 | 0 |
477508 | 477508 | 2020-08-28 | Oakland | Michigan | 26125 | 17794 | 1157 |
477509 | 477509 | 2020-08-28 | Oceana | Michigan | 26127 | 499 | 6 |
477510 | 477510 | 2020-08-28 | Ogemaw | Michigan | 26129 | 57 | 4 |
477511 | 477511 | 2020-08-28 | Ontonagon | Michigan | 26131 | 34 | 0 |
477512 | 477512 | 2020-08-28 | Osceola | Michigan | 26133 | 76 | 0 |
477513 | 477513 | 2020-08-28 | Oscoda | Michigan | 26135 | 29 | 1 |
477514 | 477514 | 2020-08-28 | Otsego | Michigan | 26137 | 154 | 11 |
477515 | 477515 | 2020-08-28 | Ottawa | Michigan | 26139 | 2087 | 63 |
477516 | 477516 | 2020-08-28 | Presque Isle | Michigan | 26141 | 21 | 1 |
477517 | 477517 | 2020-08-28 | Roscommon | Michigan | 26143 | 75 | 3 |
477518 | 477518 | 2020-08-28 | Saginaw | Michigan | 26145 | 2483 | 131 |
477519 | 477519 | 2020-08-28 | Sanilac | Michigan | 26151 | 123 | 7 |
477520 | 477520 | 2020-08-28 | Schoolcraft | Michigan | 26153 | 15 | 0 |
477521 | 477521 | 2020-08-28 | Shiawassee | Michigan | 26155 | 418 | 29 |
477522 | 477522 | 2020-08-28 | St. Clair | Michigan | 26147 | 912 | 53 |
477523 | 477523 | 2020-08-28 | St. Joseph | Michigan | 26149 | 676 | 11 |
477524 | 477524 | 2020-08-28 | Tuscola | Michigan | 26157 | 442 | 29 |
477525 | 477525 | 2020-08-28 | Unknown | Michigan | 345 | 4 | |
477526 | 477526 | 2020-08-28 | Van Buren | Michigan | 26159 | 597 | 14 |
477527 | 477527 | 2020-08-28 | Washtenaw | Michigan | 26161 | 3381 | 124 |
477528 | 477528 | 2020-08-28 | Wayne | Michigan | 26163 | 30980 | 2876 |
477529 | 477529 | 2020-08-28 | Wexford | Michigan | 26165 | 100 | 4 |
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);