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-06-29 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1467055 | 1467055 | 2021-06-29 | Alcona | Michigan | 26001 | 739 | 33 |
1467056 | 1467056 | 2021-06-29 | Alger | Michigan | 26003 | 670 | 7 |
1467057 | 1467057 | 2021-06-29 | Allegan | Michigan | 26005 | 11186 | 161 |
1467058 | 1467058 | 2021-06-29 | Alpena | Michigan | 26007 | 2270 | 63 |
1467059 | 1467059 | 2021-06-29 | Antrim | Michigan | 26009 | 1636 | 30 |
1467060 | 1467060 | 2021-06-29 | Arenac | Michigan | 26011 | 1209 | 29 |
1467061 | 1467061 | 2021-06-29 | Baraga | Michigan | 26013 | 994 | 39 |
1467062 | 1467062 | 2021-06-29 | Barry | Michigan | 26015 | 5962 | 69 |
1467063 | 1467063 | 2021-06-29 | Bay | Michigan | 26017 | 11263 | 355 |
1467064 | 1467064 | 2021-06-29 | Benzie | Michigan | 26019 | 1281 | 36 |
1467065 | 1467065 | 2021-06-29 | Berrien | Michigan | 26021 | 15596 | 291 |
1467066 | 1467066 | 2021-06-29 | Branch | Michigan | 26023 | 5764 | 121 |
1467067 | 1467067 | 2021-06-29 | Calhoun | Michigan | 26025 | 14559 | 318 |
1467068 | 1467068 | 2021-06-29 | Cass | Michigan | 26027 | 5499 | 77 |
1467069 | 1467069 | 2021-06-29 | Charlevoix | Michigan | 26029 | 1681 | 22 |
1467070 | 1467070 | 2021-06-29 | Cheboygan | Michigan | 26031 | 1931 | 46 |
1467071 | 1467071 | 2021-06-29 | Chippewa | Michigan | 26033 | 5629 | 50 |
1467072 | 1467072 | 2021-06-29 | Clare | Michigan | 26035 | 2480 | 85 |
1467073 | 1467073 | 2021-06-29 | Clinton | Michigan | 26037 | 7660 | 92 |
1467074 | 1467074 | 2021-06-29 | Crawford | Michigan | 26039 | 995 | 14 |
1467075 | 1467075 | 2021-06-29 | Delta | Michigan | 26041 | 4057 | 95 |
1467076 | 1467076 | 2021-06-29 | Dickinson | Michigan | 26043 | 2755 | 74 |
1467077 | 1467077 | 2021-06-29 | Eaton | Michigan | 26045 | 10153 | 212 |
1467078 | 1467078 | 2021-06-29 | Emmet | Michigan | 26047 | 2384 | 43 |
1467079 | 1467079 | 2021-06-29 | Genesee | Michigan | 26049 | 41749 | 971 |
1467080 | 1467080 | 2021-06-29 | Gladwin | Michigan | 26051 | 2305 | 61 |
1467081 | 1467081 | 2021-06-29 | Gogebic | Michigan | 26053 | 1405 | 52 |
1467082 | 1467082 | 2021-06-29 | Grand Traverse | Michigan | 26055 | 6479 | 99 |
1467083 | 1467083 | 2021-06-29 | Gratiot | Michigan | 26057 | 6987 | 125 |
1467084 | 1467084 | 2021-06-29 | Hillsdale | Michigan | 26059 | 4406 | 93 |
1467085 | 1467085 | 2021-06-29 | Houghton | Michigan | 26061 | 3141 | 43 |
1467086 | 1467086 | 2021-06-29 | Huron | Michigan | 26063 | 4092 | 82 |
1467087 | 1467087 | 2021-06-29 | Ingham | Michigan | 26065 | 24904 | 391 |
1467088 | 1467088 | 2021-06-29 | Ionia | Michigan | 26067 | 9348 | 85 |
1467089 | 1467089 | 2021-06-29 | Iosco | Michigan | 26069 | 2008 | 74 |
1467090 | 1467090 | 2021-06-29 | Iron | Michigan | 26071 | 1054 | 53 |
1467091 | 1467091 | 2021-06-29 | Isabella | Michigan | 26073 | 6339 | 100 |
1467092 | 1467092 | 2021-06-29 | Jackson | Michigan | 26075 | 21047 | 324 |
1467093 | 1467093 | 2021-06-29 | Kalamazoo | Michigan | 26077 | 23187 | 403 |
1467094 | 1467094 | 2021-06-29 | Kalkaska | Michigan | 26079 | 1140 | 26 |
1467095 | 1467095 | 2021-06-29 | Kent | Michigan | 26081 | 73605 | 862 |
1467096 | 1467096 | 2021-06-29 | Keweenaw | Michigan | 26083 | 174 | 2 |
1467097 | 1467097 | 2021-06-29 | Lake | Michigan | 26085 | 637 | 16 |
1467098 | 1467098 | 2021-06-29 | Lapeer | Michigan | 26087 | 9767 | 215 |
1467099 | 1467099 | 2021-06-29 | Leelanau | Michigan | 26089 | 1243 | 19 |
1467100 | 1467100 | 2021-06-29 | Lenawee | Michigan | 26091 | 10854 | 177 |
1467101 | 1467101 | 2021-06-29 | Livingston | Michigan | 26093 | 16801 | 196 |
1467102 | 1467102 | 2021-06-29 | Luce | Michigan | 26095 | 1338 | 6 |
1467103 | 1467103 | 2021-06-29 | Mackinac | Michigan | 26097 | 716 | 3 |
1467104 | 1467104 | 2021-06-29 | Macomb | Michigan | 26099 | 100642 | 2496 |
1467105 | 1467105 | 2021-06-29 | Manistee | Michigan | 26101 | 1981 | 24 |
1467106 | 1467106 | 2021-06-29 | Marquette | Michigan | 26103 | 5939 | 64 |
1467107 | 1467107 | 2021-06-29 | Mason | Michigan | 26105 | 2140 | 37 |
1467108 | 1467108 | 2021-06-29 | Mecosta | Michigan | 26107 | 3214 | 36 |
1467109 | 1467109 | 2021-06-29 | Menominee | Michigan | 26109 | 2129 | 43 |
1467110 | 1467110 | 2021-06-29 | Midland | Michigan | 26111 | 7577 | 94 |
1467111 | 1467111 | 2021-06-29 | Missaukee | Michigan | 26113 | 1513 | 27 |
1467112 | 1467112 | 2021-06-29 | Monroe | Michigan | 26115 | 15414 | 264 |
1467113 | 1467113 | 2021-06-29 | Montcalm | Michigan | 26117 | 8212 | 119 |
1467114 | 1467114 | 2021-06-29 | Montmorency | Michigan | 26119 | 618 | 20 |
1467115 | 1467115 | 2021-06-29 | Muskegon | Michigan | 26121 | 18420 | 384 |
1467116 | 1467116 | 2021-06-29 | Newaygo | Michigan | 26123 | 4897 | 68 |
1467117 | 1467117 | 2021-06-29 | Oakland | Michigan | 26125 | 118725 | 2445 |
1467118 | 1467118 | 2021-06-29 | Oceana | Michigan | 26127 | 2769 | 60 |
1467119 | 1467119 | 2021-06-29 | Ogemaw | Michigan | 26129 | 1743 | 43 |
1467120 | 1467120 | 2021-06-29 | Ontonagon | Michigan | 26131 | 482 | 21 |
1467121 | 1467121 | 2021-06-29 | Osceola | Michigan | 26133 | 1962 | 31 |
1467122 | 1467122 | 2021-06-29 | Oscoda | Michigan | 26135 | 691 | 31 |
1467123 | 1467123 | 2021-06-29 | Otsego | Michigan | 26137 | 2362 | 41 |
1467124 | 1467124 | 2021-06-29 | Ottawa | Michigan | 26139 | 32932 | 440 |
1467125 | 1467125 | 2021-06-29 | Presque Isle | Michigan | 26141 | 1057 | 34 |
1467126 | 1467126 | 2021-06-29 | Roscommon | Michigan | 26143 | 1900 | 55 |
1467127 | 1467127 | 2021-06-29 | Saginaw | Michigan | 26145 | 22525 | 634 |
1467128 | 1467128 | 2021-06-29 | Sanilac | Michigan | 26151 | 4259 | 125 |
1467129 | 1467129 | 2021-06-29 | Schoolcraft | Michigan | 26153 | 438 | 5 |
1467130 | 1467130 | 2021-06-29 | Shiawassee | Michigan | 26155 | 6436 | 107 |
1467131 | 1467131 | 2021-06-29 | St. Clair | Michigan | 26147 | 18499 | 448 |
1467132 | 1467132 | 2021-06-29 | St. Joseph | Michigan | 26149 | 6260 | 101 |
1467133 | 1467133 | 2021-06-29 | Tuscola | Michigan | 26157 | 5668 | 174 |
1467134 | 1467134 | 2021-06-29 | Unknown | Michigan | 741 | 16 | |
1467135 | 1467135 | 2021-06-29 | Van Buren | Michigan | 26159 | 7145 | 130 |
1467136 | 1467136 | 2021-06-29 | Washtenaw | Michigan | 26161 | 27140 | 310 |
1467137 | 1467137 | 2021-06-29 | Wayne | Michigan | 26163 | 165895 | 5167 |
1467138 | 1467138 | 2021-06-29 | Wexford | Michigan | 26165 | 2901 | 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);