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-09-06 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
506548 | 506548 | 2020-09-06 | Alcona | Michigan | 26001 | 38 | 2 |
506549 | 506549 | 2020-09-06 | Alger | Michigan | 26003 | 17 | 0 |
506550 | 506550 | 2020-09-06 | Allegan | Michigan | 26005 | 663 | 6 |
506551 | 506551 | 2020-09-06 | Alpena | Michigan | 26007 | 132 | 14 |
506552 | 506552 | 2020-09-06 | Antrim | Michigan | 26009 | 61 | 0 |
506553 | 506553 | 2020-09-06 | Arenac | Michigan | 26011 | 64 | 3 |
506554 | 506554 | 2020-09-06 | Baraga | Michigan | 26013 | 12 | 0 |
506555 | 506555 | 2020-09-06 | Barry | Michigan | 26015 | 225 | 2 |
506556 | 506556 | 2020-09-06 | Bay | Michigan | 26017 | 870 | 43 |
506557 | 506557 | 2020-09-06 | Benzie | Michigan | 26019 | 57 | 2 |
506558 | 506558 | 2020-09-06 | Berrien | Michigan | 26021 | 1745 | 70 |
506559 | 506559 | 2020-09-06 | Branch | Michigan | 26023 | 1319 | 27 |
506560 | 506560 | 2020-09-06 | Calhoun | Michigan | 26025 | 1070 | 44 |
506561 | 506561 | 2020-09-06 | Cass | Michigan | 26027 | 430 | 16 |
506562 | 506562 | 2020-09-06 | Charlevoix | Michigan | 26029 | 79 | 3 |
506563 | 506563 | 2020-09-06 | Cheboygan | Michigan | 26031 | 83 | 2 |
506564 | 506564 | 2020-09-06 | Chippewa | Michigan | 26033 | 65 | 0 |
506565 | 506565 | 2020-09-06 | Clare | Michigan | 26035 | 106 | 4 |
506566 | 506566 | 2020-09-06 | Clinton | Michigan | 26037 | 546 | 13 |
506567 | 506567 | 2020-09-06 | Crawford | Michigan | 26039 | 113 | 5 |
506568 | 506568 | 2020-09-06 | Delta | Michigan | 26041 | 182 | 3 |
506569 | 506569 | 2020-09-06 | Dickinson | Michigan | 26043 | 67 | 2 |
506570 | 506570 | 2020-09-06 | Eaton | Michigan | 26045 | 540 | 9 |
506571 | 506571 | 2020-09-06 | Emmet | Michigan | 26047 | 131 | 3 |
506572 | 506572 | 2020-09-06 | Genesee | Michigan | 26049 | 4031 | 305 |
506573 | 506573 | 2020-09-06 | Gladwin | Michigan | 26051 | 81 | 2 |
506574 | 506574 | 2020-09-06 | Gogebic | Michigan | 26053 | 147 | 1 |
506575 | 506575 | 2020-09-06 | Grand Traverse | Michigan | 26055 | 384 | 7 |
506576 | 506576 | 2020-09-06 | Gratiot | Michigan | 26057 | 200 | 15 |
506577 | 506577 | 2020-09-06 | Hillsdale | Michigan | 26059 | 305 | 26 |
506578 | 506578 | 2020-09-06 | Houghton | Michigan | 26061 | 121 | 3 |
506579 | 506579 | 2020-09-06 | Huron | Michigan | 26063 | 208 | 4 |
506580 | 506580 | 2020-09-06 | Ingham | Michigan | 26065 | 1958 | 40 |
506581 | 506581 | 2020-09-06 | Ionia | Michigan | 26067 | 320 | 7 |
506582 | 506582 | 2020-09-06 | Iosco | Michigan | 26069 | 153 | 12 |
506583 | 506583 | 2020-09-06 | Iron | Michigan | 26071 | 37 | 1 |
506584 | 506584 | 2020-09-06 | Isabella | Michigan | 26073 | 563 | 10 |
506585 | 506585 | 2020-09-06 | Jackson | Michigan | 26075 | 2597 | 62 |
506586 | 506586 | 2020-09-06 | Kalamazoo | Michigan | 26077 | 2069 | 89 |
506587 | 506587 | 2020-09-06 | Kalkaska | Michigan | 26079 | 71 | 4 |
506588 | 506588 | 2020-09-06 | Kent | Michigan | 26081 | 8684 | 170 |
506589 | 506589 | 2020-09-06 | Keweenaw | Michigan | 26083 | 4 | 0 |
506590 | 506590 | 2020-09-06 | Lake | Michigan | 26085 | 29 | 0 |
506591 | 506591 | 2020-09-06 | Lapeer | Michigan | 26087 | 868 | 43 |
506592 | 506592 | 2020-09-06 | Leelanau | Michigan | 26089 | 96 | 1 |
506593 | 506593 | 2020-09-06 | Lenawee | Michigan | 26091 | 1404 | 17 |
506594 | 506594 | 2020-09-06 | Livingston | Michigan | 26093 | 1213 | 30 |
506595 | 506595 | 2020-09-06 | Luce | Michigan | 26095 | 122 | 0 |
506596 | 506596 | 2020-09-06 | Mackinac | Michigan | 26097 | 43 | 0 |
506597 | 506597 | 2020-09-06 | Macomb | Michigan | 26099 | 13433 | 987 |
506598 | 506598 | 2020-09-06 | Manistee | Michigan | 26101 | 74 | 1 |
506599 | 506599 | 2020-09-06 | Marquette | Michigan | 26103 | 265 | 11 |
506600 | 506600 | 2020-09-06 | Mason | Michigan | 26105 | 126 | 0 |
506601 | 506601 | 2020-09-06 | Mecosta | Michigan | 26107 | 103 | 2 |
506602 | 506602 | 2020-09-06 | Menominee | Michigan | 26109 | 261 | 0 |
506603 | 506603 | 2020-09-06 | Midland | Michigan | 26111 | 463 | 11 |
506604 | 506604 | 2020-09-06 | Missaukee | Michigan | 26113 | 51 | 1 |
506605 | 506605 | 2020-09-06 | Monroe | Michigan | 26115 | 1377 | 28 |
506606 | 506606 | 2020-09-06 | Montcalm | Michigan | 26117 | 243 | 4 |
506607 | 506607 | 2020-09-06 | Montmorency | Michigan | 26119 | 12 | 0 |
506608 | 506608 | 2020-09-06 | Muskegon | Michigan | 26121 | 2027 | 68 |
506609 | 506609 | 2020-09-06 | Newaygo | Michigan | 26123 | 303 | 1 |
506610 | 506610 | 2020-09-06 | Oakland | Michigan | 26125 | 18513 | 1171 |
506611 | 506611 | 2020-09-06 | Oceana | Michigan | 26127 | 501 | 6 |
506612 | 506612 | 2020-09-06 | Ogemaw | Michigan | 26129 | 58 | 5 |
506613 | 506613 | 2020-09-06 | Ontonagon | Michigan | 26131 | 36 | 0 |
506614 | 506614 | 2020-09-06 | Osceola | Michigan | 26133 | 81 | 0 |
506615 | 506615 | 2020-09-06 | Oscoda | Michigan | 26135 | 29 | 1 |
506616 | 506616 | 2020-09-06 | Otsego | Michigan | 26137 | 162 | 11 |
506617 | 506617 | 2020-09-06 | Ottawa | Michigan | 26139 | 2558 | 64 |
506618 | 506618 | 2020-09-06 | Presque Isle | Michigan | 26141 | 22 | 1 |
506619 | 506619 | 2020-09-06 | Roscommon | Michigan | 26143 | 78 | 4 |
506620 | 506620 | 2020-09-06 | Saginaw | Michigan | 26145 | 2642 | 133 |
506621 | 506621 | 2020-09-06 | Sanilac | Michigan | 26151 | 128 | 7 |
506622 | 506622 | 2020-09-06 | Schoolcraft | Michigan | 26153 | 16 | 0 |
506623 | 506623 | 2020-09-06 | Shiawassee | Michigan | 26155 | 461 | 30 |
506624 | 506624 | 2020-09-06 | St. Clair | Michigan | 26147 | 947 | 53 |
506625 | 506625 | 2020-09-06 | St. Joseph | Michigan | 26149 | 696 | 11 |
506626 | 506626 | 2020-09-06 | Tuscola | Michigan | 26157 | 467 | 29 |
506627 | 506627 | 2020-09-06 | Unknown | Michigan | 573 | 4 | |
506628 | 506628 | 2020-09-06 | Van Buren | Michigan | 26159 | 674 | 17 |
506629 | 506629 | 2020-09-06 | Washtenaw | Michigan | 26161 | 3508 | 124 |
506630 | 506630 | 2020-09-06 | Wayne | Michigan | 26163 | 31983 | 2898 |
506631 | 506631 | 2020-09-06 | Wexford | Michigan | 26165 | 116 | 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);