ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-05-26" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1356705 | 1356705 | 2021-05-26 | Alcona | Michigan | 26001 | 737 | 32 |
1356706 | 1356706 | 2021-05-26 | Alger | Michigan | 26003 | 666 | 6 |
1356707 | 1356707 | 2021-05-26 | Allegan | Michigan | 26005 | 11051 | 143 |
1356708 | 1356708 | 2021-05-26 | Alpena | Michigan | 26007 | 2250 | 60 |
1356709 | 1356709 | 2021-05-26 | Antrim | Michigan | 26009 | 1623 | 28 |
1356710 | 1356710 | 2021-05-26 | Arenac | Michigan | 26011 | 1199 | 29 |
1356711 | 1356711 | 2021-05-26 | Baraga | Michigan | 26013 | 966 | 38 |
1356712 | 1356712 | 2021-05-26 | Barry | Michigan | 26015 | 5901 | 67 |
1356713 | 1356713 | 2021-05-26 | Bay | Michigan | 26017 | 11199 | 346 |
1356714 | 1356714 | 2021-05-26 | Benzie | Michigan | 26019 | 1271 | 34 |
1356715 | 1356715 | 2021-05-26 | Berrien | Michigan | 26021 | 15443 | 283 |
1356716 | 1356716 | 2021-05-26 | Branch | Michigan | 26023 | 5640 | 120 |
1356717 | 1356717 | 2021-05-26 | Calhoun | Michigan | 26025 | 14357 | 296 |
1356718 | 1356718 | 2021-05-26 | Cass | Michigan | 26027 | 5434 | 76 |
1356719 | 1356719 | 2021-05-26 | Charlevoix | Michigan | 26029 | 1663 | 21 |
1356720 | 1356720 | 2021-05-26 | Cheboygan | Michigan | 26031 | 1922 | 45 |
1356721 | 1356721 | 2021-05-26 | Chippewa | Michigan | 26033 | 5585 | 49 |
1356722 | 1356722 | 2021-05-26 | Clare | Michigan | 26035 | 2447 | 80 |
1356723 | 1356723 | 2021-05-26 | Clinton | Michigan | 26037 | 7559 | 88 |
1356724 | 1356724 | 2021-05-26 | Crawford | Michigan | 26039 | 987 | 14 |
1356725 | 1356725 | 2021-05-26 | Delta | Michigan | 26041 | 4020 | 93 |
1356726 | 1356726 | 2021-05-26 | Dickinson | Michigan | 26043 | 2729 | 74 |
1356727 | 1356727 | 2021-05-26 | Eaton | Michigan | 26045 | 10075 | 208 |
1356728 | 1356728 | 2021-05-26 | Emmet | Michigan | 26047 | 2368 | 42 |
1356729 | 1356729 | 2021-05-26 | Genesee | Michigan | 26049 | 41508 | 943 |
1356730 | 1356730 | 2021-05-26 | Gladwin | Michigan | 26051 | 2292 | 58 |
1356731 | 1356731 | 2021-05-26 | Gogebic | Michigan | 26053 | 1400 | 50 |
1356732 | 1356732 | 2021-05-26 | Grand Traverse | Michigan | 26055 | 6427 | 96 |
1356733 | 1356733 | 2021-05-26 | Gratiot | Michigan | 26057 | 6941 | 123 |
1356734 | 1356734 | 2021-05-26 | Hillsdale | Michigan | 26059 | 4376 | 92 |
1356735 | 1356735 | 2021-05-26 | Houghton | Michigan | 26061 | 3124 | 42 |
1356736 | 1356736 | 2021-05-26 | Huron | Michigan | 26063 | 4070 | 77 |
1356737 | 1356737 | 2021-05-26 | Ingham | Michigan | 26065 | 24687 | 379 |
1356738 | 1356738 | 2021-05-26 | Ionia | Michigan | 26067 | 9235 | 85 |
1356739 | 1356739 | 2021-05-26 | Iosco | Michigan | 26069 | 1989 | 73 |
1356740 | 1356740 | 2021-05-26 | Iron | Michigan | 26071 | 1050 | 51 |
1356741 | 1356741 | 2021-05-26 | Isabella | Michigan | 26073 | 6291 | 95 |
1356742 | 1356742 | 2021-05-26 | Jackson | Michigan | 26075 | 20922 | 307 |
1356743 | 1356743 | 2021-05-26 | Kalamazoo | Michigan | 26077 | 22934 | 393 |
1356744 | 1356744 | 2021-05-26 | Kalkaska | Michigan | 26079 | 1115 | 23 |
1356745 | 1356745 | 2021-05-26 | Kent | Michigan | 26081 | 72561 | 835 |
1356746 | 1356746 | 2021-05-26 | Keweenaw | Michigan | 26083 | 175 | 2 |
1356747 | 1356747 | 2021-05-26 | Lake | Michigan | 26085 | 626 | 15 |
1356748 | 1356748 | 2021-05-26 | Lapeer | Michigan | 26087 | 9686 | 205 |
1356749 | 1356749 | 2021-05-26 | Leelanau | Michigan | 26089 | 1236 | 18 |
1356750 | 1356750 | 2021-05-26 | Lenawee | Michigan | 26091 | 10765 | 168 |
1356751 | 1356751 | 2021-05-26 | Livingston | Michigan | 26093 | 16647 | 187 |
1356752 | 1356752 | 2021-05-26 | Luce | Michigan | 26095 | 1324 | 5 |
1356753 | 1356753 | 2021-05-26 | Mackinac | Michigan | 26097 | 704 | 3 |
1356754 | 1356754 | 2021-05-26 | Macomb | Michigan | 26099 | 99820 | 2416 |
1356755 | 1356755 | 2021-05-26 | Manistee | Michigan | 26101 | 1966 | 24 |
1356756 | 1356756 | 2021-05-26 | Marquette | Michigan | 26103 | 5912 | 62 |
1356757 | 1356757 | 2021-05-26 | Mason | Michigan | 26105 | 2119 | 36 |
1356758 | 1356758 | 2021-05-26 | Mecosta | Michigan | 26107 | 3174 | 32 |
1356759 | 1356759 | 2021-05-26 | Menominee | Michigan | 26109 | 2111 | 42 |
1356760 | 1356760 | 2021-05-26 | Midland | Michigan | 26111 | 7494 | 90 |
1356761 | 1356761 | 2021-05-26 | Missaukee | Michigan | 26113 | 1498 | 25 |
1356762 | 1356762 | 2021-05-26 | Monroe | Michigan | 26115 | 15290 | 259 |
1356763 | 1356763 | 2021-05-26 | Montcalm | Michigan | 26117 | 8088 | 116 |
1356764 | 1356764 | 2021-05-26 | Montmorency | Michigan | 26119 | 608 | 20 |
1356765 | 1356765 | 2021-05-26 | Muskegon | Michigan | 26121 | 18153 | 365 |
1356766 | 1356766 | 2021-05-26 | Newaygo | Michigan | 26123 | 4823 | 66 |
1356767 | 1356767 | 2021-05-26 | Oakland | Michigan | 26125 | 117495 | 2346 |
1356768 | 1356768 | 2021-05-26 | Oceana | Michigan | 26127 | 2744 | 60 |
1356769 | 1356769 | 2021-05-26 | Ogemaw | Michigan | 26129 | 1721 | 43 |
1356770 | 1356770 | 2021-05-26 | Ontonagon | Michigan | 26131 | 474 | 21 |
1356771 | 1356771 | 2021-05-26 | Osceola | Michigan | 26133 | 1940 | 29 |
1356772 | 1356772 | 2021-05-26 | Oscoda | Michigan | 26135 | 667 | 29 |
1356773 | 1356773 | 2021-05-26 | Otsego | Michigan | 26137 | 2339 | 40 |
1356774 | 1356774 | 2021-05-26 | Ottawa | Michigan | 26139 | 32599 | 418 |
1356775 | 1356775 | 2021-05-26 | Presque Isle | Michigan | 26141 | 1048 | 34 |
1356776 | 1356776 | 2021-05-26 | Roscommon | Michigan | 26143 | 1881 | 50 |
1356777 | 1356777 | 2021-05-26 | Saginaw | Michigan | 26145 | 22293 | 606 |
1356778 | 1356778 | 2021-05-26 | Sanilac | Michigan | 26151 | 4237 | 118 |
1356779 | 1356779 | 2021-05-26 | Schoolcraft | Michigan | 26153 | 431 | 5 |
1356780 | 1356780 | 2021-05-26 | Shiawassee | Michigan | 26155 | 6377 | 103 |
1356781 | 1356781 | 2021-05-26 | St. Clair | Michigan | 26147 | 18326 | 433 |
1356782 | 1356782 | 2021-05-26 | St. Joseph | Michigan | 26149 | 6180 | 98 |
1356783 | 1356783 | 2021-05-26 | Tuscola | Michigan | 26157 | 5642 | 174 |
1356784 | 1356784 | 2021-05-26 | Unknown | Michigan | 615 | 13 | |
1356785 | 1356785 | 2021-05-26 | Van Buren | Michigan | 26159 | 7066 | 128 |
1356786 | 1356786 | 2021-05-26 | Washtenaw | Michigan | 26161 | 26980 | 299 |
1356787 | 1356787 | 2021-05-26 | Wayne | Michigan | 26163 | 163841 | 4980 |
1356788 | 1356788 | 2021-05-26 | Wexford | Michigan | 26165 | 2879 | 47 |
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);