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-11-22 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
756167 | 756167 | 2020-11-22 | Alcona | Michigan | 26001 | 127 | 3 |
756168 | 756168 | 2020-11-22 | Alger | Michigan | 26003 | 223 | 2 |
756169 | 756169 | 2020-11-22 | Allegan | Michigan | 26005 | 3348 | 20 |
756170 | 756170 | 2020-11-22 | Alpena | Michigan | 26007 | 452 | 16 |
756171 | 756171 | 2020-11-22 | Antrim | Michigan | 26009 | 324 | 5 |
756172 | 756172 | 2020-11-22 | Arenac | Michigan | 26011 | 309 | 11 |
756173 | 756173 | 2020-11-22 | Baraga | Michigan | 26013 | 392 | 6 |
756174 | 756174 | 2020-11-22 | Barry | Michigan | 26015 | 1707 | 12 |
756175 | 756175 | 2020-11-22 | Bay | Michigan | 26017 | 3634 | 81 |
756176 | 756176 | 2020-11-22 | Benzie | Michigan | 26019 | 295 | 4 |
756177 | 756177 | 2020-11-22 | Berrien | Michigan | 26021 | 5862 | 106 |
756178 | 756178 | 2020-11-22 | Branch | Michigan | 26023 | 2766 | 50 |
756179 | 756179 | 2020-11-22 | Calhoun | Michigan | 26025 | 5309 | 111 |
756180 | 756180 | 2020-11-22 | Cass | Michigan | 26027 | 1926 | 28 |
756181 | 756181 | 2020-11-22 | Charlevoix | Michigan | 26029 | 459 | 6 |
756182 | 756182 | 2020-11-22 | Cheboygan | Michigan | 26031 | 389 | 16 |
756183 | 756183 | 2020-11-22 | Chippewa | Michigan | 26033 | 676 | 2 |
756184 | 756184 | 2020-11-22 | Clare | Michigan | 26035 | 624 | 22 |
756185 | 756185 | 2020-11-22 | Clinton | Michigan | 26037 | 2396 | 19 |
756186 | 756186 | 2020-11-22 | Crawford | Michigan | 26039 | 284 | 5 |
756187 | 756187 | 2020-11-22 | Delta | Michigan | 26041 | 2286 | 56 |
756188 | 756188 | 2020-11-22 | Dickinson | Michigan | 26043 | 1527 | 30 |
756189 | 756189 | 2020-11-22 | Eaton | Michigan | 26045 | 2564 | 29 |
756190 | 756190 | 2020-11-22 | Emmet | Michigan | 26047 | 835 | 27 |
756191 | 756191 | 2020-11-22 | Genesee | Michigan | 26049 | 12517 | 399 |
756192 | 756192 | 2020-11-22 | Gladwin | Michigan | 26051 | 643 | 8 |
756193 | 756193 | 2020-11-22 | Gogebic | Michigan | 26053 | 702 | 20 |
756194 | 756194 | 2020-11-22 | Grand Traverse | Michigan | 26055 | 1586 | 18 |
756195 | 756195 | 2020-11-22 | Gratiot | Michigan | 26057 | 1351 | 27 |
756196 | 756196 | 2020-11-22 | Hillsdale | Michigan | 26059 | 1348 | 34 |
756197 | 756197 | 2020-11-22 | Houghton | Michigan | 26061 | 1416 | 11 |
756198 | 756198 | 2020-11-22 | Huron | Michigan | 26063 | 592 | 13 |
756199 | 756199 | 2020-11-22 | Ingham | Michigan | 26065 | 7733 | 97 |
756200 | 756200 | 2020-11-22 | Ionia | Michigan | 26067 | 2638 | 13 |
756201 | 756201 | 2020-11-22 | Iosco | Michigan | 26069 | 591 | 20 |
756202 | 756202 | 2020-11-22 | Iron | Michigan | 26071 | 674 | 32 |
756203 | 756203 | 2020-11-22 | Isabella | Michigan | 26073 | 2114 | 18 |
756204 | 756204 | 2020-11-22 | Jackson | Michigan | 26075 | 5825 | 110 |
756205 | 756205 | 2020-11-22 | Kalamazoo | Michigan | 26077 | 8256 | 157 |
756206 | 756206 | 2020-11-22 | Kalkaska | Michigan | 26079 | 293 | 4 |
756207 | 756207 | 2020-11-22 | Kent | Michigan | 26081 | 28340 | 292 |
756208 | 756208 | 2020-11-22 | Keweenaw | Michigan | 26083 | 62 | 1 |
756209 | 756209 | 2020-11-22 | Lake | Michigan | 26085 | 165 | 3 |
756210 | 756210 | 2020-11-22 | Lapeer | Michigan | 26087 | 2263 | 55 |
756211 | 756211 | 2020-11-22 | Leelanau | Michigan | 26089 | 319 | 2 |
756212 | 756212 | 2020-11-22 | Lenawee | Michigan | 26091 | 2833 | 26 |
756213 | 756213 | 2020-11-22 | Livingston | Michigan | 26093 | 4560 | 43 |
756214 | 756214 | 2020-11-22 | Luce | Michigan | 26095 | 571 | 0 |
756215 | 756215 | 2020-11-22 | Mackinac | Michigan | 26097 | 246 | 0 |
756216 | 756216 | 2020-11-22 | Macomb | Michigan | 26099 | 32074 | 1218 |
756217 | 756217 | 2020-11-22 | Manistee | Michigan | 26101 | 310 | 5 |
756218 | 756218 | 2020-11-22 | Marquette | Michigan | 26103 | 3391 | 25 |
756219 | 756219 | 2020-11-22 | Mason | Michigan | 26105 | 504 | 9 |
756220 | 756220 | 2020-11-22 | Mecosta | Michigan | 26107 | 1030 | 7 |
756221 | 756221 | 2020-11-22 | Menominee | Michigan | 26109 | 1186 | 12 |
756222 | 756222 | 2020-11-22 | Midland | Michigan | 26111 | 2564 | 23 |
756223 | 756223 | 2020-11-22 | Missaukee | Michigan | 26113 | 238 | 2 |
756224 | 756224 | 2020-11-22 | Monroe | Michigan | 26115 | 4351 | 60 |
756225 | 756225 | 2020-11-22 | Montcalm | Michigan | 26117 | 1540 | 21 |
756226 | 756226 | 2020-11-22 | Montmorency | Michigan | 26119 | 115 | 2 |
756227 | 756227 | 2020-11-22 | Muskegon | Michigan | 26121 | 7289 | 150 |
756228 | 756228 | 2020-11-22 | Newaygo | Michigan | 26123 | 1308 | 15 |
756229 | 756229 | 2020-11-22 | Oakland | Michigan | 26125 | 40381 | 1310 |
756230 | 756230 | 2020-11-22 | Oceana | Michigan | 26127 | 1039 | 13 |
756231 | 756231 | 2020-11-22 | Ogemaw | Michigan | 26129 | 387 | 10 |
756232 | 756232 | 2020-11-22 | Ontonagon | Michigan | 26131 | 257 | 11 |
756233 | 756233 | 2020-11-22 | Osceola | Michigan | 26133 | 417 | 3 |
756234 | 756234 | 2020-11-22 | Oscoda | Michigan | 26135 | 118 | 2 |
756235 | 756235 | 2020-11-22 | Otsego | Michigan | 26137 | 631 | 16 |
756236 | 756236 | 2020-11-22 | Ottawa | Michigan | 26139 | 12031 | 124 |
756237 | 756237 | 2020-11-22 | Presque Isle | Michigan | 26141 | 196 | 3 |
756238 | 756238 | 2020-11-22 | Roscommon | Michigan | 26143 | 478 | 7 |
756239 | 756239 | 2020-11-22 | Saginaw | Michigan | 26145 | 7367 | 204 |
756240 | 756240 | 2020-11-22 | Sanilac | Michigan | 26151 | 548 | 12 |
756241 | 756241 | 2020-11-22 | Schoolcraft | Michigan | 26153 | 163 | 2 |
756242 | 756242 | 2020-11-22 | Shiawassee | Michigan | 26155 | 1626 | 38 |
756243 | 756243 | 2020-11-22 | St. Clair | Michigan | 26147 | 3707 | 78 |
756244 | 756244 | 2020-11-22 | St. Joseph | Michigan | 26149 | 2266 | 31 |
756245 | 756245 | 2020-11-22 | Tuscola | Michigan | 26157 | 1426 | 46 |
756246 | 756246 | 2020-11-22 | Unknown | Michigan | 4518 | 8 | |
756247 | 756247 | 2020-11-22 | Van Buren | Michigan | 26159 | 2352 | 32 |
756248 | 756248 | 2020-11-22 | Washtenaw | Michigan | 26161 | 9086 | 137 |
756249 | 756249 | 2020-11-22 | Wayne | Michigan | 26163 | 57116 | 3156 |
756250 | 756250 | 2020-11-22 | Wexford | Michigan | 26165 | 471 | 12 |
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);