ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-08-27" 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 |
---|---|---|---|---|---|---|---|
474213 | 474213 | 2020-08-27 | Alcona | Michigan | 26001 | 31 | 2 |
474214 | 474214 | 2020-08-27 | Alger | Michigan | 26003 | 17 | 0 |
474215 | 474215 | 2020-08-27 | Allegan | Michigan | 26005 | 616 | 6 |
474216 | 474216 | 2020-08-27 | Alpena | Michigan | 26007 | 132 | 14 |
474217 | 474217 | 2020-08-27 | Antrim | Michigan | 26009 | 55 | 0 |
474218 | 474218 | 2020-08-27 | Arenac | Michigan | 26011 | 52 | 3 |
474219 | 474219 | 2020-08-27 | Baraga | Michigan | 26013 | 8 | 0 |
474220 | 474220 | 2020-08-27 | Barry | Michigan | 26015 | 210 | 2 |
474221 | 474221 | 2020-08-27 | Bay | Michigan | 26017 | 792 | 41 |
474222 | 474222 | 2020-08-27 | Benzie | Michigan | 26019 | 42 | 2 |
474223 | 474223 | 2020-08-27 | Berrien | Michigan | 26021 | 1644 | 70 |
474224 | 474224 | 2020-08-27 | Branch | Michigan | 26023 | 1249 | 26 |
474225 | 474225 | 2020-08-27 | Calhoun | Michigan | 26025 | 947 | 44 |
474226 | 474226 | 2020-08-27 | Cass | Michigan | 26027 | 398 | 16 |
474227 | 474227 | 2020-08-27 | Charlevoix | Michigan | 26029 | 74 | 2 |
474228 | 474228 | 2020-08-27 | Cheboygan | Michigan | 26031 | 69 | 2 |
474229 | 474229 | 2020-08-27 | Chippewa | Michigan | 26033 | 52 | 0 |
474230 | 474230 | 2020-08-27 | Clare | Michigan | 26035 | 99 | 3 |
474231 | 474231 | 2020-08-27 | Clinton | Michigan | 26037 | 469 | 13 |
474232 | 474232 | 2020-08-27 | Crawford | Michigan | 26039 | 114 | 5 |
474233 | 474233 | 2020-08-27 | Delta | Michigan | 26041 | 140 | 3 |
474234 | 474234 | 2020-08-27 | Dickinson | Michigan | 26043 | 63 | 2 |
474235 | 474235 | 2020-08-27 | Eaton | Michigan | 26045 | 503 | 8 |
474236 | 474236 | 2020-08-27 | Emmet | Michigan | 26047 | 114 | 2 |
474237 | 474237 | 2020-08-27 | Genesee | Michigan | 26049 | 3927 | 303 |
474238 | 474238 | 2020-08-27 | Gladwin | Michigan | 26051 | 75 | 2 |
474239 | 474239 | 2020-08-27 | Gogebic | Michigan | 26053 | 142 | 1 |
474240 | 474240 | 2020-08-27 | Grand Traverse | Michigan | 26055 | 338 | 6 |
474241 | 474241 | 2020-08-27 | Gratiot | Michigan | 26057 | 188 | 15 |
474242 | 474242 | 2020-08-27 | Hillsdale | Michigan | 26059 | 299 | 26 |
474243 | 474243 | 2020-08-27 | Houghton | Michigan | 26061 | 62 | 0 |
474244 | 474244 | 2020-08-27 | Huron | Michigan | 26063 | 197 | 4 |
474245 | 474245 | 2020-08-27 | Ingham | Michigan | 26065 | 1735 | 37 |
474246 | 474246 | 2020-08-27 | Ionia | Michigan | 26067 | 295 | 7 |
474247 | 474247 | 2020-08-27 | Iosco | Michigan | 26069 | 141 | 12 |
474248 | 474248 | 2020-08-27 | Iron | Michigan | 26071 | 27 | 1 |
474249 | 474249 | 2020-08-27 | Isabella | Michigan | 26073 | 406 | 9 |
474250 | 474250 | 2020-08-27 | Jackson | Michigan | 26075 | 2524 | 62 |
474251 | 474251 | 2020-08-27 | Kalamazoo | Michigan | 26077 | 1890 | 87 |
474252 | 474252 | 2020-08-27 | Kalkaska | Michigan | 26079 | 64 | 4 |
474253 | 474253 | 2020-08-27 | Kent | Michigan | 26081 | 8290 | 162 |
474254 | 474254 | 2020-08-27 | Keweenaw | Michigan | 26083 | 2 | 0 |
474255 | 474255 | 2020-08-27 | Lake | Michigan | 26085 | 29 | 0 |
474256 | 474256 | 2020-08-27 | Lapeer | Michigan | 26087 | 828 | 42 |
474257 | 474257 | 2020-08-27 | Leelanau | Michigan | 26089 | 86 | 1 |
474258 | 474258 | 2020-08-27 | Lenawee | Michigan | 26091 | 1259 | 17 |
474259 | 474259 | 2020-08-27 | Livingston | Michigan | 26093 | 1112 | 30 |
474260 | 474260 | 2020-08-27 | Luce | Michigan | 26095 | 120 | 0 |
474261 | 474261 | 2020-08-27 | Mackinac | Michigan | 26097 | 33 | 0 |
474262 | 474262 | 2020-08-27 | Macomb | Michigan | 26099 | 12697 | 969 |
474263 | 474263 | 2020-08-27 | Manistee | Michigan | 26101 | 63 | 1 |
474264 | 474264 | 2020-08-27 | Marquette | Michigan | 26103 | 239 | 11 |
474265 | 474265 | 2020-08-27 | Mason | Michigan | 26105 | 117 | 0 |
474266 | 474266 | 2020-08-27 | Mecosta | Michigan | 26107 | 83 | 2 |
474267 | 474267 | 2020-08-27 | Menominee | Michigan | 26109 | 234 | 0 |
474268 | 474268 | 2020-08-27 | Midland | Michigan | 26111 | 403 | 11 |
474269 | 474269 | 2020-08-27 | Missaukee | Michigan | 26113 | 43 | 1 |
474270 | 474270 | 2020-08-27 | Monroe | Michigan | 26115 | 1258 | 26 |
474271 | 474271 | 2020-08-27 | Montcalm | Michigan | 26117 | 219 | 3 |
474272 | 474272 | 2020-08-27 | Montmorency | Michigan | 26119 | 12 | 0 |
474273 | 474273 | 2020-08-27 | Muskegon | Michigan | 26121 | 1925 | 65 |
474274 | 474274 | 2020-08-27 | Newaygo | Michigan | 26123 | 292 | 0 |
474275 | 474275 | 2020-08-27 | Oakland | Michigan | 26125 | 17694 | 1157 |
474276 | 474276 | 2020-08-27 | Oceana | Michigan | 26127 | 499 | 6 |
474277 | 474277 | 2020-08-27 | Ogemaw | Michigan | 26129 | 57 | 3 |
474278 | 474278 | 2020-08-27 | Ontonagon | Michigan | 26131 | 33 | 0 |
474279 | 474279 | 2020-08-27 | Osceola | Michigan | 26133 | 76 | 0 |
474280 | 474280 | 2020-08-27 | Oscoda | Michigan | 26135 | 29 | 1 |
474281 | 474281 | 2020-08-27 | Otsego | Michigan | 26137 | 154 | 11 |
474282 | 474282 | 2020-08-27 | Ottawa | Michigan | 26139 | 2058 | 63 |
474283 | 474283 | 2020-08-27 | Presque Isle | Michigan | 26141 | 21 | 1 |
474284 | 474284 | 2020-08-27 | Roscommon | Michigan | 26143 | 75 | 3 |
474285 | 474285 | 2020-08-27 | Saginaw | Michigan | 26145 | 2453 | 131 |
474286 | 474286 | 2020-08-27 | Sanilac | Michigan | 26151 | 123 | 7 |
474287 | 474287 | 2020-08-27 | Schoolcraft | Michigan | 26153 | 15 | 0 |
474288 | 474288 | 2020-08-27 | Shiawassee | Michigan | 26155 | 410 | 29 |
474289 | 474289 | 2020-08-27 | St. Clair | Michigan | 26147 | 905 | 53 |
474290 | 474290 | 2020-08-27 | St. Joseph | Michigan | 26149 | 671 | 11 |
474291 | 474291 | 2020-08-27 | Tuscola | Michigan | 26157 | 432 | 29 |
474292 | 474292 | 2020-08-27 | Unknown | Michigan | 344 | 4 | |
474293 | 474293 | 2020-08-27 | Van Buren | Michigan | 26159 | 589 | 14 |
474294 | 474294 | 2020-08-27 | Washtenaw | Michigan | 26161 | 3367 | 124 |
474295 | 474295 | 2020-08-27 | Wayne | Michigan | 26163 | 30845 | 2874 |
474296 | 474296 | 2020-08-27 | Wexford | Michigan | 26165 | 97 | 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);