ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where "date" is on date 2020-04-18 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
68484 | 68484 | 2020-04-18 | Alcona | Michigan | 26001 | 1 | 0 |
68485 | 68485 | 2020-04-18 | Allegan | Michigan | 26005 | 33 | 0 |
68486 | 68486 | 2020-04-18 | Alpena | Michigan | 26007 | 2 | 1 |
68487 | 68487 | 2020-04-18 | Antrim | Michigan | 26009 | 8 | 0 |
68488 | 68488 | 2020-04-18 | Arenac | Michigan | 26011 | 9 | 0 |
68489 | 68489 | 2020-04-18 | Baraga | Michigan | 26013 | 1 | 0 |
68490 | 68490 | 2020-04-18 | Barry | Michigan | 26015 | 21 | 1 |
68491 | 68491 | 2020-04-18 | Bay | Michigan | 26017 | 79 | 2 |
68492 | 68492 | 2020-04-18 | Benzie | Michigan | 26019 | 2 | 0 |
68493 | 68493 | 2020-04-18 | Berrien | Michigan | 26021 | 153 | 8 |
68494 | 68494 | 2020-04-18 | Branch | Michigan | 26023 | 120 | 4 |
68495 | 68495 | 2020-04-18 | Calhoun | Michigan | 26025 | 136 | 5 |
68496 | 68496 | 2020-04-18 | Cass | Michigan | 26027 | 22 | 1 |
68497 | 68497 | 2020-04-18 | Charlevoix | Michigan | 26029 | 12 | 1 |
68498 | 68498 | 2020-04-18 | Cheboygan | Michigan | 26031 | 14 | 1 |
68499 | 68499 | 2020-04-18 | Chippewa | Michigan | 26033 | 1 | 0 |
68500 | 68500 | 2020-04-18 | Clare | Michigan | 26035 | 8 | 1 |
68501 | 68501 | 2020-04-18 | Clinton | Michigan | 26037 | 103 | 6 |
68502 | 68502 | 2020-04-18 | Crawford | Michigan | 26039 | 26 | 2 |
68503 | 68503 | 2020-04-18 | Delta | Michigan | 26041 | 12 | 1 |
68504 | 68504 | 2020-04-18 | Dickinson | Michigan | 26043 | 3 | 2 |
68505 | 68505 | 2020-04-18 | Eaton | Michigan | 26045 | 88 | 5 |
68506 | 68506 | 2020-04-18 | Emmet | Michigan | 26047 | 21 | 2 |
68507 | 68507 | 2020-04-18 | Genesee | Michigan | 26049 | 1228 | 112 |
68508 | 68508 | 2020-04-18 | Gladwin | Michigan | 26051 | 9 | 0 |
68509 | 68509 | 2020-04-18 | Gogebic | Michigan | 26053 | 4 | 1 |
68510 | 68510 | 2020-04-18 | Grand Traverse | Michigan | 26055 | 18 | 4 |
68511 | 68511 | 2020-04-18 | Gratiot | Michigan | 26057 | 7 | 0 |
68512 | 68512 | 2020-04-18 | Hillsdale | Michigan | 26059 | 89 | 11 |
68513 | 68513 | 2020-04-18 | Houghton | Michigan | 26061 | 2 | 0 |
68514 | 68514 | 2020-04-18 | Huron | Michigan | 26063 | 10 | 0 |
68515 | 68515 | 2020-04-18 | Ingham | Michigan | 26065 | 304 | 6 |
68516 | 68516 | 2020-04-18 | Ionia | Michigan | 26067 | 22 | 2 |
68517 | 68517 | 2020-04-18 | Iosco | Michigan | 26069 | 11 | 1 |
68518 | 68518 | 2020-04-18 | Isabella | Michigan | 26073 | 51 | 7 |
68519 | 68519 | 2020-04-18 | Jackson | Michigan | 26075 | 453 | 15 |
68520 | 68520 | 2020-04-18 | Kalamazoo | Michigan | 26077 | 154 | 9 |
68521 | 68521 | 2020-04-18 | Kalkaska | Michigan | 26079 | 17 | 2 |
68522 | 68522 | 2020-04-18 | Kent | Michigan | 26081 | 461 | 23 |
68523 | 68523 | 2020-04-18 | Lake | Michigan | 26085 | 2 | 0 |
68524 | 68524 | 2020-04-18 | Lapeer | Michigan | 26087 | 147 | 18 |
68525 | 68525 | 2020-04-18 | Leelanau | Michigan | 26089 | 7 | 0 |
68526 | 68526 | 2020-04-18 | Lenawee | Michigan | 26091 | 70 | 0 |
68527 | 68527 | 2020-04-18 | Livingston | Michigan | 26093 | 282 | 10 |
68528 | 68528 | 2020-04-18 | Luce | Michigan | 26095 | 1 | 0 |
68529 | 68529 | 2020-04-18 | Mackinac | Michigan | 26097 | 4 | 0 |
68530 | 68530 | 2020-04-18 | Macomb | Michigan | 26099 | 4328 | 384 |
68531 | 68531 | 2020-04-18 | Manistee | Michigan | 26101 | 11 | 0 |
68532 | 68532 | 2020-04-18 | Marquette | Michigan | 26103 | 29 | 6 |
68533 | 68533 | 2020-04-18 | Mason | Michigan | 26105 | 4 | 0 |
68534 | 68534 | 2020-04-18 | Mecosta | Michigan | 26107 | 12 | 1 |
68535 | 68535 | 2020-04-18 | Menominee | Michigan | 26109 | 1 | 0 |
68536 | 68536 | 2020-04-18 | Midland | Michigan | 26111 | 43 | 2 |
68537 | 68537 | 2020-04-18 | Missaukee | Michigan | 26113 | 3 | 1 |
68538 | 68538 | 2020-04-18 | Monroe | Michigan | 26115 | 224 | 10 |
68539 | 68539 | 2020-04-18 | Montcalm | Michigan | 26117 | 24 | 1 |
68540 | 68540 | 2020-04-18 | Montmorency | Michigan | 26119 | 4 | 0 |
68541 | 68541 | 2020-04-18 | Muskegon | Michigan | 26121 | 136 | 5 |
68542 | 68542 | 2020-04-18 | Newaygo | Michigan | 26123 | 7 | 0 |
68543 | 68543 | 2020-04-18 | Oakland | Michigan | 26125 | 6021 | 458 |
68544 | 68544 | 2020-04-18 | Oceana | Michigan | 26127 | 3 | 1 |
68545 | 68545 | 2020-04-18 | Ogemaw | Michigan | 26129 | 5 | 0 |
68546 | 68546 | 2020-04-18 | Osceola | Michigan | 26133 | 6 | 0 |
68547 | 68547 | 2020-04-18 | Oscoda | Michigan | 26135 | 4 | 0 |
68548 | 68548 | 2020-04-18 | Otsego | Michigan | 26137 | 54 | 5 |
68549 | 68549 | 2020-04-18 | Ottawa | Michigan | 26139 | 98 | 5 |
68550 | 68550 | 2020-04-18 | Presque Isle | Michigan | 26141 | 2 | 0 |
68551 | 68551 | 2020-04-18 | Roscommon | Michigan | 26143 | 9 | 0 |
68552 | 68552 | 2020-04-18 | Saginaw | Michigan | 26145 | 395 | 24 |
68553 | 68553 | 2020-04-18 | Sanilac | Michigan | 26151 | 32 | 3 |
68554 | 68554 | 2020-04-18 | Schoolcraft | Michigan | 26153 | 3 | 0 |
68555 | 68555 | 2020-04-18 | Shiawassee | Michigan | 26155 | 91 | 2 |
68556 | 68556 | 2020-04-18 | St. Clair | Michigan | 26147 | 241 | 7 |
68557 | 68557 | 2020-04-18 | St. Joseph | Michigan | 26149 | 24 | 1 |
68558 | 68558 | 2020-04-18 | Tuscola | Michigan | 26157 | 59 | 11 |
68559 | 68559 | 2020-04-18 | Unknown | Michigan | 142 | 13 | |
68560 | 68560 | 2020-04-18 | Van Buren | Michigan | 26159 | 31 | 2 |
68561 | 68561 | 2020-04-18 | Washtenaw | Michigan | 26161 | 950 | 29 |
68562 | 68562 | 2020-04-18 | Wayne | Michigan | 26163 | 13487 | 1071 |
68563 | 68563 | 2020-04-18 | Wexford | Michigan | 26165 | 7 | 1 |
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);