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 2022-02-11 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2204716 | 2204716 | 2022-02-11 | Alcona | Michigan | 26001 | 1665 | 67 |
2204717 | 2204717 | 2022-02-11 | Alger | Michigan | 26003 | 1815 | 13 |
2204718 | 2204718 | 2022-02-11 | Allegan | Michigan | 26005 | 26478 | 324 |
2204719 | 2204719 | 2022-02-11 | Alpena | Michigan | 26007 | 5384 | 127 |
2204720 | 2204720 | 2022-02-11 | Antrim | Michigan | 26009 | 4174 | 56 |
2204721 | 2204721 | 2022-02-11 | Arenac | Michigan | 26011 | 3112 | 62 |
2204722 | 2204722 | 2022-02-11 | Baraga | Michigan | 26013 | 2153 | 54 |
2204723 | 2204723 | 2022-02-11 | Barry | Michigan | 26015 | 13986 | 155 |
2204724 | 2204724 | 2022-02-11 | Bay | Michigan | 26017 | 26425 | 548 |
2204725 | 2204725 | 2022-02-11 | Benzie | Michigan | 26019 | 3338 | 63 |
2204726 | 2204726 | 2022-02-11 | Berrien | Michigan | 26021 | 34072 | 498 |
2204727 | 2204727 | 2022-02-11 | Branch | Michigan | 26023 | 11948 | 186 |
2204728 | 2204728 | 2022-02-11 | Calhoun | Michigan | 26025 | 33131 | 538 |
2204729 | 2204729 | 2022-02-11 | Cass | Michigan | 26027 | 10929 | 127 |
2204730 | 2204730 | 2022-02-11 | Charlevoix | Michigan | 26029 | 4825 | 56 |
2204731 | 2204731 | 2022-02-11 | Cheboygan | Michigan | 26031 | 4491 | 93 |
2204732 | 2204732 | 2022-02-11 | Chippewa | Michigan | 26033 | 11257 | 104 |
2204733 | 2204733 | 2022-02-11 | Clare | Michigan | 26035 | 6555 | 150 |
2204734 | 2204734 | 2022-02-11 | Clinton | Michigan | 26037 | 20271 | 193 |
2204735 | 2204735 | 2022-02-11 | Crawford | Michigan | 26039 | 2455 | 26 |
2204736 | 2204736 | 2022-02-11 | Delta | Michigan | 26041 | 9745 | 149 |
2204737 | 2204737 | 2022-02-11 | Dickinson | Michigan | 26043 | 7246 | 102 |
2204738 | 2204738 | 2022-02-11 | Eaton | Michigan | 26045 | 25867 | 371 |
2204739 | 2204739 | 2022-02-11 | Emmet | Michigan | 26047 | 6233 | 74 |
2204740 | 2204740 | 2022-02-11 | Genesee | Michigan | 26049 | 98664 | 1601 |
2204741 | 2204741 | 2022-02-11 | Gladwin | Michigan | 26051 | 5454 | 106 |
2204742 | 2204742 | 2022-02-11 | Gogebic | Michigan | 26053 | 3180 | 65 |
2204743 | 2204743 | 2022-02-11 | Grand Traverse | Michigan | 26055 | 16547 | 204 |
2204744 | 2204744 | 2022-02-11 | Gratiot | Michigan | 26057 | 13255 | 177 |
2204745 | 2204745 | 2022-02-11 | Hillsdale | Michigan | 26059 | 10121 | 185 |
2204746 | 2204746 | 2022-02-11 | Houghton | Michigan | 26061 | 7592 | 87 |
2204747 | 2204747 | 2022-02-11 | Huron | Michigan | 26063 | 7913 | 141 |
2204748 | 2204748 | 2022-02-11 | Ingham | Michigan | 26065 | 61993 | 690 |
2204749 | 2204749 | 2022-02-11 | Ionia | Michigan | 26067 | 19068 | 171 |
2204750 | 2204750 | 2022-02-11 | Iosco | Michigan | 26069 | 4644 | 129 |
2204751 | 2204751 | 2022-02-11 | Iron | Michigan | 26071 | 2583 | 79 |
2204752 | 2204752 | 2022-02-11 | Isabella | Michigan | 26073 | 15185 | 187 |
2204753 | 2204753 | 2022-02-11 | Jackson | Michigan | 26075 | 43796 | 537 |
2204754 | 2204754 | 2022-02-11 | Kalamazoo | Michigan | 26077 | 56899 | 624 |
2204755 | 2204755 | 2022-02-11 | Kalkaska | Michigan | 26079 | 3431 | 52 |
2204756 | 2204756 | 2022-02-11 | Kent | Michigan | 26081 | 162438 | 1426 |
2204757 | 2204757 | 2022-02-11 | Keweenaw | Michigan | 26083 | 496 | 12 |
2204758 | 2204758 | 2022-02-11 | Lake | Michigan | 26085 | 1778 | 34 |
2204759 | 2204759 | 2022-02-11 | Lapeer | Michigan | 26087 | 20397 | 402 |
2204760 | 2204760 | 2022-02-11 | Leelanau | Michigan | 26089 | 3462 | 47 |
2204761 | 2204761 | 2022-02-11 | Lenawee | Michigan | 26091 | 25386 | 304 |
2204762 | 2204762 | 2022-02-11 | Livingston | Michigan | 26093 | 44666 | 420 |
2204763 | 2204763 | 2022-02-11 | Luce | Michigan | 26095 | 2234 | 9 |
2204764 | 2204764 | 2022-02-11 | Mackinac | Michigan | 26097 | 2312 | 27 |
2204765 | 2204765 | 2022-02-11 | Macomb | Michigan | 26099 | 222040 | 3698 |
2204766 | 2204766 | 2022-02-11 | Manistee | Michigan | 26101 | 4297 | 78 |
2204767 | 2204767 | 2022-02-11 | Marquette | Michigan | 26103 | 15370 | 113 |
2204768 | 2204768 | 2022-02-11 | Mason | Michigan | 26105 | 6404 | 82 |
2204769 | 2204769 | 2022-02-11 | Mecosta | Michigan | 26107 | 8418 | 96 |
2204770 | 2204770 | 2022-02-11 | Menominee | Michigan | 26109 | 5426 | 68 |
2204771 | 2204771 | 2022-02-11 | Midland | Michigan | 26111 | 18564 | 210 |
2204772 | 2204772 | 2022-02-11 | Missaukee | Michigan | 26113 | 2830 | 57 |
2204773 | 2204773 | 2022-02-11 | Monroe | Michigan | 26115 | 37117 | 442 |
2204774 | 2204774 | 2022-02-11 | Montcalm | Michigan | 26117 | 16791 | 199 |
2204775 | 2204775 | 2022-02-11 | Montmorency | Michigan | 26119 | 1673 | 45 |
2204776 | 2204776 | 2022-02-11 | Muskegon | Michigan | 26121 | 40683 | 601 |
2204777 | 2204777 | 2022-02-11 | Newaygo | Michigan | 26123 | 11202 | 150 |
2204778 | 2204778 | 2022-02-11 | Oakland | Michigan | 26125 | 277833 | 3588 |
2204779 | 2204779 | 2022-02-11 | Oceana | Michigan | 26127 | 6122 | 87 |
2204780 | 2204780 | 2022-02-11 | Ogemaw | Michigan | 26129 | 4215 | 91 |
2204781 | 2204781 | 2022-02-11 | Ontonagon | Michigan | 26131 | 953 | 35 |
2204782 | 2204782 | 2022-02-11 | Osceola | Michigan | 26133 | 4854 | 71 |
2204783 | 2204783 | 2022-02-11 | Oscoda | Michigan | 26135 | 1410 | 53 |
2204784 | 2204784 | 2022-02-11 | Otsego | Michigan | 26137 | 5429 | 93 |
2204785 | 2204785 | 2022-02-11 | Ottawa | Michigan | 26139 | 73028 | 752 |
2204786 | 2204786 | 2022-02-11 | Presque Isle | Michigan | 26141 | 2039 | 55 |
2204787 | 2204787 | 2022-02-11 | Roscommon | Michigan | 26143 | 4490 | 109 |
2204788 | 2204788 | 2022-02-11 | Saginaw | Michigan | 26145 | 49181 | 886 |
2204789 | 2204789 | 2022-02-11 | Sanilac | Michigan | 26151 | 8483 | 177 |
2204790 | 2204790 | 2022-02-11 | Schoolcraft | Michigan | 26153 | 1701 | 13 |
2204791 | 2204791 | 2022-02-11 | Shiawassee | Michigan | 26155 | 17312 | 216 |
2204792 | 2204792 | 2022-02-11 | St. Clair | Michigan | 26147 | 39527 | 778 |
2204793 | 2204793 | 2022-02-11 | St. Joseph | Michigan | 26149 | 13436 | 189 |
2204794 | 2204794 | 2022-02-11 | Tuscola | Michigan | 26157 | 12975 | 265 |
2204795 | 2204795 | 2022-02-11 | Unknown | Michigan | 11204 | 32 | |
2204796 | 2204796 | 2022-02-11 | Van Buren | Michigan | 26159 | 16606 | 248 |
2204797 | 2204797 | 2022-02-11 | Washtenaw | Michigan | 26161 | 71548 | 495 |
2204798 | 2204798 | 2022-02-11 | Wayne | Michigan | 26163 | 388109 | 7402 |
2204799 | 2204799 | 2022-02-11 | Wexford | Michigan | 26165 | 6825 | 100 |
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);