ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where date = "2020-05-05" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
116520 | 116520 | 2020-05-05 | Alcona | Michigan | 26001 | 4 | 1 |
116521 | 116521 | 2020-05-05 | Allegan | Michigan | 26005 | 120 | 2 |
116522 | 116522 | 2020-05-05 | Alpena | Michigan | 26007 | 85 | 7 |
116523 | 116523 | 2020-05-05 | Antrim | Michigan | 26009 | 10 | 0 |
116524 | 116524 | 2020-05-05 | Arenac | Michigan | 26011 | 27 | 1 |
116525 | 116525 | 2020-05-05 | Baraga | Michigan | 26013 | 1 | 0 |
116526 | 116526 | 2020-05-05 | Barry | Michigan | 26015 | 39 | 1 |
116527 | 116527 | 2020-05-05 | Bay | Michigan | 26017 | 162 | 8 |
116528 | 116528 | 2020-05-05 | Benzie | Michigan | 26019 | 4 | 0 |
116529 | 116529 | 2020-05-05 | Berrien | Michigan | 26021 | 315 | 20 |
116530 | 116530 | 2020-05-05 | Branch | Michigan | 26023 | 861 | 17 |
116531 | 116531 | 2020-05-05 | Calhoun | Michigan | 26025 | 246 | 16 |
116532 | 116532 | 2020-05-05 | Cass | Michigan | 26027 | 34 | 2 |
116533 | 116533 | 2020-05-05 | Charlevoix | Michigan | 26029 | 13 | 1 |
116534 | 116534 | 2020-05-05 | Cheboygan | Michigan | 26031 | 19 | 1 |
116535 | 116535 | 2020-05-05 | Chippewa | Michigan | 26033 | 3 | 0 |
116536 | 116536 | 2020-05-05 | Clare | Michigan | 26035 | 11 | 2 |
116537 | 116537 | 2020-05-05 | Clinton | Michigan | 26037 | 120 | 10 |
116538 | 116538 | 2020-05-05 | Crawford | Michigan | 26039 | 56 | 4 |
116539 | 116539 | 2020-05-05 | Delta | Michigan | 26041 | 14 | 2 |
116540 | 116540 | 2020-05-05 | Dickinson | Michigan | 26043 | 3 | 2 |
116541 | 116541 | 2020-05-05 | Eaton | Michigan | 26045 | 138 | 6 |
116542 | 116542 | 2020-05-05 | Emmet | Michigan | 26047 | 21 | 2 |
116543 | 116543 | 2020-05-05 | Genesee | Michigan | 26049 | 1668 | 200 |
116544 | 116544 | 2020-05-05 | Gladwin | Michigan | 26051 | 14 | 1 |
116545 | 116545 | 2020-05-05 | Gogebic | Michigan | 26053 | 4 | 1 |
116546 | 116546 | 2020-05-05 | Grand Traverse | Michigan | 26055 | 20 | 5 |
116547 | 116547 | 2020-05-05 | Gratiot | Michigan | 26057 | 26 | 2 |
116548 | 116548 | 2020-05-05 | Hillsdale | Michigan | 26059 | 137 | 21 |
116549 | 116549 | 2020-05-05 | Houghton | Michigan | 26061 | 2 | 0 |
116550 | 116550 | 2020-05-05 | Huron | Michigan | 26063 | 25 | 1 |
116551 | 116551 | 2020-05-05 | Ingham | Michigan | 26065 | 518 | 14 |
116552 | 116552 | 2020-05-05 | Ionia | Michigan | 26067 | 96 | 2 |
116553 | 116553 | 2020-05-05 | Iosco | Michigan | 26069 | 52 | 7 |
116554 | 116554 | 2020-05-05 | Isabella | Michigan | 26073 | 61 | 7 |
116555 | 116555 | 2020-05-05 | Jackson | Michigan | 26075 | 1301 | 42 |
116556 | 116556 | 2020-05-05 | Kalamazoo | Michigan | 26077 | 489 | 22 |
116557 | 116557 | 2020-05-05 | Kalkaska | Michigan | 26079 | 17 | 2 |
116558 | 116558 | 2020-05-05 | Kent | Michigan | 26081 | 1917 | 40 |
116559 | 116559 | 2020-05-05 | Lake | Michigan | 26085 | 2 | 0 |
116560 | 116560 | 2020-05-05 | Lapeer | Michigan | 26087 | 225 | 28 |
116561 | 116561 | 2020-05-05 | Leelanau | Michigan | 26089 | 9 | 0 |
116562 | 116562 | 2020-05-05 | Lenawee | Michigan | 26091 | 162 | 2 |
116563 | 116563 | 2020-05-05 | Livingston | Michigan | 26093 | 370 | 21 |
116564 | 116564 | 2020-05-05 | Luce | Michigan | 26095 | 2 | 0 |
116565 | 116565 | 2020-05-05 | Mackinac | Michigan | 26097 | 6 | 0 |
116566 | 116566 | 2020-05-05 | Macomb | Michigan | 26099 | 5888 | 652 |
116567 | 116567 | 2020-05-05 | Manistee | Michigan | 26101 | 11 | 0 |
116568 | 116568 | 2020-05-05 | Marquette | Michigan | 26103 | 49 | 8 |
116569 | 116569 | 2020-05-05 | Mason | Michigan | 26105 | 13 | 0 |
116570 | 116570 | 2020-05-05 | Mecosta | Michigan | 26107 | 14 | 2 |
116571 | 116571 | 2020-05-05 | Menominee | Michigan | 26109 | 6 | 0 |
116572 | 116572 | 2020-05-05 | Midland | Michigan | 26111 | 62 | 7 |
116573 | 116573 | 2020-05-05 | Missaukee | Michigan | 26113 | 16 | 1 |
116574 | 116574 | 2020-05-05 | Monroe | Michigan | 26115 | 327 | 13 |
116575 | 116575 | 2020-05-05 | Montcalm | Michigan | 26117 | 46 | 1 |
116576 | 116576 | 2020-05-05 | Montmorency | Michigan | 26119 | 5 | 0 |
116577 | 116577 | 2020-05-05 | Muskegon | Michigan | 26121 | 318 | 18 |
116578 | 116578 | 2020-05-05 | Newaygo | Michigan | 26123 | 31 | 0 |
116579 | 116579 | 2020-05-05 | Oakland | Michigan | 26125 | 7522 | 772 |
116580 | 116580 | 2020-05-05 | Oceana | Michigan | 26127 | 21 | 1 |
116581 | 116581 | 2020-05-05 | Ogemaw | Michigan | 26129 | 15 | 0 |
116582 | 116582 | 2020-05-05 | Osceola | Michigan | 26133 | 8 | 0 |
116583 | 116583 | 2020-05-05 | Oscoda | Michigan | 26135 | 5 | 0 |
116584 | 116584 | 2020-05-05 | Otsego | Michigan | 26137 | 94 | 8 |
116585 | 116585 | 2020-05-05 | Ottawa | Michigan | 26139 | 295 | 12 |
116586 | 116586 | 2020-05-05 | Presque Isle | Michigan | 26141 | 11 | 0 |
116587 | 116587 | 2020-05-05 | Roscommon | Michigan | 26143 | 18 | 0 |
116588 | 116588 | 2020-05-05 | Saginaw | Michigan | 26145 | 743 | 70 |
116589 | 116589 | 2020-05-05 | Sanilac | Michigan | 26151 | 36 | 5 |
116590 | 116590 | 2020-05-05 | Schoolcraft | Michigan | 26153 | 3 | 0 |
116591 | 116591 | 2020-05-05 | Shiawassee | Michigan | 26155 | 189 | 12 |
116592 | 116592 | 2020-05-05 | St. Clair | Michigan | 26147 | 342 | 21 |
116593 | 116593 | 2020-05-05 | St. Joseph | Michigan | 26149 | 43 | 1 |
116594 | 116594 | 2020-05-05 | Tuscola | Michigan | 26157 | 117 | 14 |
116595 | 116595 | 2020-05-05 | Unknown | Michigan | 0 | 5 | |
116596 | 116596 | 2020-05-05 | Van Buren | Michigan | 26159 | 69 | 2 |
116597 | 116597 | 2020-05-05 | Washtenaw | Michigan | 26161 | 1225 | 82 |
116598 | 116598 | 2020-05-05 | Wayne | Michigan | 26163 | 17411 | 1947 |
116599 | 116599 | 2020-05-05 | Wexford | Michigan | 26165 | 9 | 2 |
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);