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-21 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
555087 | 555087 | 2020-09-21 | Alcona | Michigan | 26001 | 41 | 2 |
555088 | 555088 | 2020-09-21 | Alger | Michigan | 26003 | 17 | 0 |
555089 | 555089 | 2020-09-21 | Allegan | Michigan | 26005 | 737 | 7 |
555090 | 555090 | 2020-09-21 | Alpena | Michigan | 26007 | 145 | 14 |
555091 | 555091 | 2020-09-21 | Antrim | Michigan | 26009 | 67 | 0 |
555092 | 555092 | 2020-09-21 | Arenac | Michigan | 26011 | 69 | 3 |
555093 | 555093 | 2020-09-21 | Baraga | Michigan | 26013 | 15 | 0 |
555094 | 555094 | 2020-09-21 | Barry | Michigan | 26015 | 282 | 2 |
555095 | 555095 | 2020-09-21 | Bay | Michigan | 26017 | 971 | 48 |
555096 | 555096 | 2020-09-21 | Benzie | Michigan | 26019 | 79 | 2 |
555097 | 555097 | 2020-09-21 | Berrien | Michigan | 26021 | 1865 | 72 |
555098 | 555098 | 2020-09-21 | Branch | Michigan | 26023 | 1391 | 27 |
555099 | 555099 | 2020-09-21 | Calhoun | Michigan | 26025 | 1239 | 45 |
555100 | 555100 | 2020-09-21 | Cass | Michigan | 26027 | 533 | 16 |
555101 | 555101 | 2020-09-21 | Charlevoix | Michigan | 26029 | 98 | 3 |
555102 | 555102 | 2020-09-21 | Cheboygan | Michigan | 26031 | 89 | 2 |
555103 | 555103 | 2020-09-21 | Chippewa | Michigan | 26033 | 75 | 0 |
555104 | 555104 | 2020-09-21 | Clare | Michigan | 26035 | 111 | 4 |
555105 | 555105 | 2020-09-21 | Clinton | Michigan | 26037 | 633 | 13 |
555106 | 555106 | 2020-09-21 | Crawford | Michigan | 26039 | 119 | 5 |
555107 | 555107 | 2020-09-21 | Delta | Michigan | 26041 | 286 | 5 |
555108 | 555108 | 2020-09-21 | Dickinson | Michigan | 26043 | 108 | 2 |
555109 | 555109 | 2020-09-21 | Eaton | Michigan | 26045 | 618 | 10 |
555110 | 555110 | 2020-09-21 | Emmet | Michigan | 26047 | 154 | 4 |
555111 | 555111 | 2020-09-21 | Genesee | Michigan | 26049 | 4334 | 306 |
555112 | 555112 | 2020-09-21 | Gladwin | Michigan | 26051 | 91 | 2 |
555113 | 555113 | 2020-09-21 | Gogebic | Michigan | 26053 | 154 | 1 |
555114 | 555114 | 2020-09-21 | Grand Traverse | Michigan | 26055 | 457 | 7 |
555115 | 555115 | 2020-09-21 | Gratiot | Michigan | 26057 | 256 | 15 |
555116 | 555116 | 2020-09-21 | Hillsdale | Michigan | 26059 | 330 | 27 |
555117 | 555117 | 2020-09-21 | Houghton | Michigan | 26061 | 337 | 1 |
555118 | 555118 | 2020-09-21 | Huron | Michigan | 26063 | 218 | 5 |
555119 | 555119 | 2020-09-21 | Ingham | Michigan | 26065 | 3242 | 47 |
555120 | 555120 | 2020-09-21 | Ionia | Michigan | 26067 | 506 | 7 |
555121 | 555121 | 2020-09-21 | Iosco | Michigan | 26069 | 204 | 12 |
555122 | 555122 | 2020-09-21 | Iron | Michigan | 26071 | 91 | 1 |
555123 | 555123 | 2020-09-21 | Isabella | Michigan | 26073 | 672 | 12 |
555124 | 555124 | 2020-09-21 | Jackson | Michigan | 26075 | 2733 | 66 |
555125 | 555125 | 2020-09-21 | Kalamazoo | Michigan | 26077 | 2616 | 91 |
555126 | 555126 | 2020-09-21 | Kalkaska | Michigan | 26079 | 81 | 4 |
555127 | 555127 | 2020-09-21 | Kent | Michigan | 26081 | 9463 | 174 |
555128 | 555128 | 2020-09-21 | Keweenaw | Michigan | 26083 | 7 | 0 |
555129 | 555129 | 2020-09-21 | Lake | Michigan | 26085 | 33 | 0 |
555130 | 555130 | 2020-09-21 | Lapeer | Michigan | 26087 | 894 | 43 |
555131 | 555131 | 2020-09-21 | Leelanau | Michigan | 26089 | 110 | 1 |
555132 | 555132 | 2020-09-21 | Lenawee | Michigan | 26091 | 1517 | 20 |
555133 | 555133 | 2020-09-21 | Livingston | Michigan | 26093 | 1387 | 31 |
555134 | 555134 | 2020-09-21 | Luce | Michigan | 26095 | 237 | 0 |
555135 | 555135 | 2020-09-21 | Mackinac | Michigan | 26097 | 54 | 0 |
555136 | 555136 | 2020-09-21 | Macomb | Michigan | 26099 | 14365 | 1015 |
555137 | 555137 | 2020-09-21 | Manistee | Michigan | 26101 | 82 | 2 |
555138 | 555138 | 2020-09-21 | Marquette | Michigan | 26103 | 329 | 12 |
555139 | 555139 | 2020-09-21 | Mason | Michigan | 26105 | 134 | 0 |
555140 | 555140 | 2020-09-21 | Mecosta | Michigan | 26107 | 193 | 3 |
555141 | 555141 | 2020-09-21 | Menominee | Michigan | 26109 | 324 | 1 |
555142 | 555142 | 2020-09-21 | Midland | Michigan | 26111 | 570 | 11 |
555143 | 555143 | 2020-09-21 | Missaukee | Michigan | 26113 | 59 | 1 |
555144 | 555144 | 2020-09-21 | Monroe | Michigan | 26115 | 1471 | 28 |
555145 | 555145 | 2020-09-21 | Montcalm | Michigan | 26117 | 296 | 5 |
555146 | 555146 | 2020-09-21 | Montmorency | Michigan | 26119 | 14 | 0 |
555147 | 555147 | 2020-09-21 | Muskegon | Michigan | 26121 | 2391 | 71 |
555148 | 555148 | 2020-09-21 | Newaygo | Michigan | 26123 | 328 | 1 |
555149 | 555149 | 2020-09-21 | Oakland | Michigan | 26125 | 20089 | 1194 |
555150 | 555150 | 2020-09-21 | Oceana | Michigan | 26127 | 514 | 6 |
555151 | 555151 | 2020-09-21 | Ogemaw | Michigan | 26129 | 62 | 5 |
555152 | 555152 | 2020-09-21 | Ontonagon | Michigan | 26131 | 42 | 0 |
555153 | 555153 | 2020-09-21 | Osceola | Michigan | 26133 | 91 | 0 |
555154 | 555154 | 2020-09-21 | Oscoda | Michigan | 26135 | 30 | 1 |
555155 | 555155 | 2020-09-21 | Otsego | Michigan | 26137 | 176 | 11 |
555156 | 555156 | 2020-09-21 | Ottawa | Michigan | 26139 | 3233 | 66 |
555157 | 555157 | 2020-09-21 | Presque Isle | Michigan | 26141 | 26 | 1 |
555158 | 555158 | 2020-09-21 | Roscommon | Michigan | 26143 | 91 | 4 |
555159 | 555159 | 2020-09-21 | Saginaw | Michigan | 26145 | 2880 | 140 |
555160 | 555160 | 2020-09-21 | Sanilac | Michigan | 26151 | 146 | 7 |
555161 | 555161 | 2020-09-21 | Schoolcraft | Michigan | 26153 | 21 | 0 |
555162 | 555162 | 2020-09-21 | Shiawassee | Michigan | 26155 | 496 | 31 |
555163 | 555163 | 2020-09-21 | St. Clair | Michigan | 26147 | 985 | 53 |
555164 | 555164 | 2020-09-21 | St. Joseph | Michigan | 26149 | 732 | 11 |
555165 | 555165 | 2020-09-21 | Tuscola | Michigan | 26157 | 493 | 31 |
555166 | 555166 | 2020-09-21 | Unknown | Michigan | 151 | 5 | |
555167 | 555167 | 2020-09-21 | Van Buren | Michigan | 26159 | 744 | 17 |
555168 | 555168 | 2020-09-21 | Washtenaw | Michigan | 26161 | 3881 | 125 |
555169 | 555169 | 2020-09-21 | Wayne | Michigan | 26163 | 34327 | 2961 |
555170 | 555170 | 2020-09-21 | Wexford | Michigan | 26165 | 123 | 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);