ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where "date" is on date 2020-04-22 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
79586 | 79586 | 2020-04-22 | Alcona | Michigan | 26001 | 4 | 0 |
79587 | 79587 | 2020-04-22 | Allegan | Michigan | 26005 | 50 | 0 |
79588 | 79588 | 2020-04-22 | Alpena | Michigan | 26007 | 38 | 1 |
79589 | 79589 | 2020-04-22 | Antrim | Michigan | 26009 | 9 | 0 |
79590 | 79590 | 2020-04-22 | Arenac | Michigan | 26011 | 13 | 1 |
79591 | 79591 | 2020-04-22 | Baraga | Michigan | 26013 | 1 | 0 |
79592 | 79592 | 2020-04-22 | Barry | Michigan | 26015 | 28 | 1 |
79593 | 79593 | 2020-04-22 | Bay | Michigan | 26017 | 93 | 2 |
79594 | 79594 | 2020-04-22 | Benzie | Michigan | 26019 | 4 | 0 |
79595 | 79595 | 2020-04-22 | Berrien | Michigan | 26021 | 177 | 11 |
79596 | 79596 | 2020-04-22 | Branch | Michigan | 26023 | 250 | 10 |
79597 | 79597 | 2020-04-22 | Calhoun | Michigan | 26025 | 168 | 5 |
79598 | 79598 | 2020-04-22 | Cass | Michigan | 26027 | 23 | 1 |
79599 | 79599 | 2020-04-22 | Charlevoix | Michigan | 26029 | 12 | 1 |
79600 | 79600 | 2020-04-22 | Cheboygan | Michigan | 26031 | 14 | 1 |
79601 | 79601 | 2020-04-22 | Chippewa | Michigan | 26033 | 2 | 0 |
79602 | 79602 | 2020-04-22 | Clare | Michigan | 26035 | 10 | 1 |
79603 | 79603 | 2020-04-22 | Clinton | Michigan | 26037 | 106 | 7 |
79604 | 79604 | 2020-04-22 | Crawford | Michigan | 26039 | 32 | 2 |
79605 | 79605 | 2020-04-22 | Delta | Michigan | 26041 | 12 | 2 |
79606 | 79606 | 2020-04-22 | Dickinson | Michigan | 26043 | 3 | 2 |
79607 | 79607 | 2020-04-22 | Eaton | Michigan | 26045 | 104 | 5 |
79608 | 79608 | 2020-04-22 | Emmet | Michigan | 26047 | 22 | 2 |
79609 | 79609 | 2020-04-22 | Genesee | Michigan | 26049 | 1362 | 138 |
79610 | 79610 | 2020-04-22 | Gladwin | Michigan | 26051 | 10 | 1 |
79611 | 79611 | 2020-04-22 | Gogebic | Michigan | 26053 | 4 | 1 |
79612 | 79612 | 2020-04-22 | Grand Traverse | Michigan | 26055 | 19 | 5 |
79613 | 79613 | 2020-04-22 | Gratiot | Michigan | 26057 | 8 | 1 |
79614 | 79614 | 2020-04-22 | Hillsdale | Michigan | 26059 | 97 | 12 |
79615 | 79615 | 2020-04-22 | Houghton | Michigan | 26061 | 2 | 0 |
79616 | 79616 | 2020-04-22 | Huron | Michigan | 26063 | 9 | 0 |
79617 | 79617 | 2020-04-22 | Ingham | Michigan | 26065 | 350 | 7 |
79618 | 79618 | 2020-04-22 | Ionia | Michigan | 26067 | 29 | 2 |
79619 | 79619 | 2020-04-22 | Iosco | Michigan | 26069 | 15 | 2 |
79620 | 79620 | 2020-04-22 | Isabella | Michigan | 26073 | 54 | 7 |
79621 | 79621 | 2020-04-22 | Jackson | Michigan | 26075 | 588 | 20 |
79622 | 79622 | 2020-04-22 | Kalamazoo | Michigan | 26077 | 212 | 11 |
79623 | 79623 | 2020-04-22 | Kalkaska | Michigan | 26079 | 17 | 2 |
79624 | 79624 | 2020-04-22 | Kent | Michigan | 26081 | 759 | 25 |
79625 | 79625 | 2020-04-22 | Lake | Michigan | 26085 | 2 | 0 |
79626 | 79626 | 2020-04-22 | Lapeer | Michigan | 26087 | 172 | 23 |
79627 | 79627 | 2020-04-22 | Leelanau | Michigan | 26089 | 8 | 0 |
79628 | 79628 | 2020-04-22 | Lenawee | Michigan | 26091 | 87 | 0 |
79629 | 79629 | 2020-04-22 | Livingston | Michigan | 26093 | 314 | 11 |
79630 | 79630 | 2020-04-22 | Luce | Michigan | 26095 | 2 | 0 |
79631 | 79631 | 2020-04-22 | Mackinac | Michigan | 26097 | 5 | 0 |
79632 | 79632 | 2020-04-22 | Macomb | Michigan | 26099 | 4712 | 477 |
79633 | 79633 | 2020-04-22 | Manistee | Michigan | 26101 | 11 | 0 |
79634 | 79634 | 2020-04-22 | Marquette | Michigan | 26103 | 35 | 6 |
79635 | 79635 | 2020-04-22 | Mason | Michigan | 26105 | 5 | 0 |
79636 | 79636 | 2020-04-22 | Mecosta | Michigan | 26107 | 13 | 1 |
79637 | 79637 | 2020-04-22 | Menominee | Michigan | 26109 | 1 | 0 |
79638 | 79638 | 2020-04-22 | Midland | Michigan | 26111 | 47 | 3 |
79639 | 79639 | 2020-04-22 | Missaukee | Michigan | 26113 | 12 | 1 |
79640 | 79640 | 2020-04-22 | Monroe | Michigan | 26115 | 247 | 10 |
79641 | 79641 | 2020-04-22 | Montcalm | Michigan | 26117 | 26 | 1 |
79642 | 79642 | 2020-04-22 | Montmorency | Michigan | 26119 | 6 | 0 |
79643 | 79643 | 2020-04-22 | Muskegon | Michigan | 26121 | 173 | 11 |
79644 | 79644 | 2020-04-22 | Newaygo | Michigan | 26123 | 12 | 0 |
79645 | 79645 | 2020-04-22 | Oakland | Michigan | 26125 | 6463 | 529 |
79646 | 79646 | 2020-04-22 | Oceana | Michigan | 26127 | 4 | 1 |
79647 | 79647 | 2020-04-22 | Ogemaw | Michigan | 26129 | 6 | 0 |
79648 | 79648 | 2020-04-22 | Osceola | Michigan | 26133 | 8 | 0 |
79649 | 79649 | 2020-04-22 | Oscoda | Michigan | 26135 | 4 | 0 |
79650 | 79650 | 2020-04-22 | Otsego | Michigan | 26137 | 78 | 6 |
79651 | 79651 | 2020-04-22 | Ottawa | Michigan | 26139 | 149 | 7 |
79652 | 79652 | 2020-04-22 | Presque Isle | Michigan | 26141 | 6 | 0 |
79653 | 79653 | 2020-04-22 | Roscommon | Michigan | 26143 | 11 | 0 |
79654 | 79654 | 2020-04-22 | Saginaw | Michigan | 26145 | 475 | 35 |
79655 | 79655 | 2020-04-22 | Sanilac | Michigan | 26151 | 32 | 3 |
79656 | 79656 | 2020-04-22 | Schoolcraft | Michigan | 26153 | 3 | 0 |
79657 | 79657 | 2020-04-22 | Shiawassee | Michigan | 26155 | 123 | 3 |
79658 | 79658 | 2020-04-22 | St. Clair | Michigan | 26147 | 271 | 16 |
79659 | 79659 | 2020-04-22 | St. Joseph | Michigan | 26149 | 27 | 1 |
79660 | 79660 | 2020-04-22 | Tuscola | Michigan | 26157 | 71 | 11 |
79661 | 79661 | 2020-04-22 | Van Buren | Michigan | 26159 | 36 | 2 |
79662 | 79662 | 2020-04-22 | Washtenaw | Michigan | 26161 | 1021 | 43 |
79663 | 79663 | 2020-04-22 | Wayne | Michigan | 26163 | 14578 | 1322 |
79664 | 79664 | 2020-04-22 | 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);