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 2021-07-26 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1554717 | 1554717 | 2021-07-26 | Alcona | Michigan | 26001 | 743 | 33 |
1554718 | 1554718 | 2021-07-26 | Alger | Michigan | 26003 | 670 | 7 |
1554719 | 1554719 | 2021-07-26 | Allegan | Michigan | 26005 | 11266 | 162 |
1554720 | 1554720 | 2021-07-26 | Alpena | Michigan | 26007 | 2290 | 64 |
1554721 | 1554721 | 2021-07-26 | Antrim | Michigan | 26009 | 1645 | 30 |
1554722 | 1554722 | 2021-07-26 | Arenac | Michigan | 26011 | 1223 | 29 |
1554723 | 1554723 | 2021-07-26 | Baraga | Michigan | 26013 | 994 | 40 |
1554724 | 1554724 | 2021-07-26 | Barry | Michigan | 26015 | 5993 | 70 |
1554725 | 1554725 | 2021-07-26 | Bay | Michigan | 26017 | 11308 | 354 |
1554726 | 1554726 | 2021-07-26 | Benzie | Michigan | 26019 | 1290 | 36 |
1554727 | 1554727 | 2021-07-26 | Berrien | Michigan | 26021 | 15717 | 300 |
1554728 | 1554728 | 2021-07-26 | Branch | Michigan | 26023 | 5848 | 121 |
1554729 | 1554729 | 2021-07-26 | Calhoun | Michigan | 26025 | 14690 | 320 |
1554730 | 1554730 | 2021-07-26 | Cass | Michigan | 26027 | 5544 | 78 |
1554731 | 1554731 | 2021-07-26 | Charlevoix | Michigan | 26029 | 1701 | 22 |
1554732 | 1554732 | 2021-07-26 | Cheboygan | Michigan | 26031 | 1942 | 47 |
1554733 | 1554733 | 2021-07-26 | Chippewa | Michigan | 26033 | 5666 | 51 |
1554734 | 1554734 | 2021-07-26 | Clare | Michigan | 26035 | 2493 | 85 |
1554735 | 1554735 | 2021-07-26 | Clinton | Michigan | 26037 | 7697 | 95 |
1554736 | 1554736 | 2021-07-26 | Crawford | Michigan | 26039 | 996 | 14 |
1554737 | 1554737 | 2021-07-26 | Delta | Michigan | 26041 | 4073 | 95 |
1554738 | 1554738 | 2021-07-26 | Dickinson | Michigan | 26043 | 2772 | 74 |
1554739 | 1554739 | 2021-07-26 | Eaton | Michigan | 26045 | 10210 | 212 |
1554740 | 1554740 | 2021-07-26 | Emmet | Michigan | 26047 | 2401 | 43 |
1554741 | 1554741 | 2021-07-26 | Genesee | Michigan | 26049 | 41947 | 976 |
1554742 | 1554742 | 2021-07-26 | Gladwin | Michigan | 26051 | 2313 | 61 |
1554743 | 1554743 | 2021-07-26 | Gogebic | Michigan | 26053 | 1444 | 53 |
1554744 | 1554744 | 2021-07-26 | Grand Traverse | Michigan | 26055 | 6542 | 100 |
1554745 | 1554745 | 2021-07-26 | Gratiot | Michigan | 26057 | 6976 | 125 |
1554746 | 1554746 | 2021-07-26 | Hillsdale | Michigan | 26059 | 4427 | 94 |
1554747 | 1554747 | 2021-07-26 | Houghton | Michigan | 26061 | 3151 | 43 |
1554748 | 1554748 | 2021-07-26 | Huron | Michigan | 26063 | 4099 | 82 |
1554749 | 1554749 | 2021-07-26 | Ingham | Michigan | 26065 | 25057 | 394 |
1554750 | 1554750 | 2021-07-26 | Ionia | Michigan | 26067 | 9393 | 85 |
1554751 | 1554751 | 2021-07-26 | Iosco | Michigan | 26069 | 2014 | 75 |
1554752 | 1554752 | 2021-07-26 | Iron | Michigan | 26071 | 1071 | 53 |
1554753 | 1554753 | 2021-07-26 | Isabella | Michigan | 26073 | 6363 | 100 |
1554754 | 1554754 | 2021-07-26 | Jackson | Michigan | 26075 | 21174 | 326 |
1554755 | 1554755 | 2021-07-26 | Kalamazoo | Michigan | 26077 | 23345 | 403 |
1554756 | 1554756 | 2021-07-26 | Kalkaska | Michigan | 26079 | 1157 | 28 |
1554757 | 1554757 | 2021-07-26 | Kent | Michigan | 26081 | 74208 | 868 |
1554758 | 1554758 | 2021-07-26 | Keweenaw | Michigan | 26083 | 174 | 2 |
1554759 | 1554759 | 2021-07-26 | Lake | Michigan | 26085 | 641 | 17 |
1554760 | 1554760 | 2021-07-26 | Lapeer | Michigan | 26087 | 9802 | 215 |
1554761 | 1554761 | 2021-07-26 | Leelanau | Michigan | 26089 | 1254 | 20 |
1554762 | 1554762 | 2021-07-26 | Lenawee | Michigan | 26091 | 10900 | 178 |
1554763 | 1554763 | 2021-07-26 | Livingston | Michigan | 26093 | 16922 | 198 |
1554764 | 1554764 | 2021-07-26 | Luce | Michigan | 26095 | 1338 | 6 |
1554765 | 1554765 | 2021-07-26 | Mackinac | Michigan | 26097 | 721 | 3 |
1554766 | 1554766 | 2021-07-26 | Macomb | Michigan | 26099 | 101189 | 2507 |
1554767 | 1554767 | 2021-07-26 | Manistee | Michigan | 26101 | 1985 | 25 |
1554768 | 1554768 | 2021-07-26 | Marquette | Michigan | 26103 | 5951 | 65 |
1554769 | 1554769 | 2021-07-26 | Mason | Michigan | 26105 | 2159 | 37 |
1554770 | 1554770 | 2021-07-26 | Mecosta | Michigan | 26107 | 3226 | 37 |
1554771 | 1554771 | 2021-07-26 | Menominee | Michigan | 26109 | 2135 | 43 |
1554772 | 1554772 | 2021-07-26 | Midland | Michigan | 26111 | 7627 | 95 |
1554773 | 1554773 | 2021-07-26 | Missaukee | Michigan | 26113 | 1522 | 27 |
1554774 | 1554774 | 2021-07-26 | Monroe | Michigan | 26115 | 15530 | 267 |
1554775 | 1554775 | 2021-07-26 | Montcalm | Michigan | 26117 | 8213 | 121 |
1554776 | 1554776 | 2021-07-26 | Montmorency | Michigan | 26119 | 618 | 20 |
1554777 | 1554777 | 2021-07-26 | Muskegon | Michigan | 26121 | 18551 | 383 |
1554778 | 1554778 | 2021-07-26 | Newaygo | Michigan | 26123 | 4922 | 69 |
1554779 | 1554779 | 2021-07-26 | Oakland | Michigan | 26125 | 119667 | 2470 |
1554780 | 1554780 | 2021-07-26 | Oceana | Michigan | 26127 | 2791 | 60 |
1554781 | 1554781 | 2021-07-26 | Ogemaw | Michigan | 26129 | 1754 | 43 |
1554782 | 1554782 | 2021-07-26 | Ontonagon | Michigan | 26131 | 485 | 22 |
1554783 | 1554783 | 2021-07-26 | Osceola | Michigan | 26133 | 1971 | 31 |
1554784 | 1554784 | 2021-07-26 | Oscoda | Michigan | 26135 | 694 | 31 |
1554785 | 1554785 | 2021-07-26 | Otsego | Michigan | 26137 | 2371 | 41 |
1554786 | 1554786 | 2021-07-26 | Ottawa | Michigan | 26139 | 33086 | 442 |
1554787 | 1554787 | 2021-07-26 | Presque Isle | Michigan | 26141 | 1059 | 34 |
1554788 | 1554788 | 2021-07-26 | Roscommon | Michigan | 26143 | 1907 | 55 |
1554789 | 1554789 | 2021-07-26 | Saginaw | Michigan | 26145 | 22671 | 640 |
1554790 | 1554790 | 2021-07-26 | Sanilac | Michigan | 26151 | 4270 | 125 |
1554791 | 1554791 | 2021-07-26 | Schoolcraft | Michigan | 26153 | 439 | 5 |
1554792 | 1554792 | 2021-07-26 | Shiawassee | Michigan | 26155 | 6478 | 110 |
1554793 | 1554793 | 2021-07-26 | St. Clair | Michigan | 26147 | 18588 | 453 |
1554794 | 1554794 | 2021-07-26 | St. Joseph | Michigan | 26149 | 6288 | 101 |
1554795 | 1554795 | 2021-07-26 | Tuscola | Michigan | 26157 | 5695 | 174 |
1554796 | 1554796 | 2021-07-26 | Unknown | Michigan | 758 | 16 | |
1554797 | 1554797 | 2021-07-26 | Van Buren | Michigan | 26159 | 7205 | 134 |
1554798 | 1554798 | 2021-07-26 | Washtenaw | Michigan | 26161 | 27369 | 313 |
1554799 | 1554799 | 2021-07-26 | Wayne | Michigan | 26163 | 167307 | 5201 |
1554800 | 1554800 | 2021-07-26 | Wexford | Michigan | 26165 | 2909 | 48 |
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);