ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-08-10" 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 |
---|---|---|---|---|---|---|---|
419355 | 419355 | 2020-08-10 | Alcona | Michigan | 26001 | 29 | 1 |
419356 | 419356 | 2020-08-10 | Alger | Michigan | 26003 | 11 | 0 |
419357 | 419357 | 2020-08-10 | Allegan | Michigan | 26005 | 529 | 6 |
419358 | 419358 | 2020-08-10 | Alpena | Michigan | 26007 | 130 | 13 |
419359 | 419359 | 2020-08-10 | Antrim | Michigan | 26009 | 41 | 0 |
419360 | 419360 | 2020-08-10 | Arenac | Michigan | 26011 | 42 | 3 |
419361 | 419361 | 2020-08-10 | Baraga | Michigan | 26013 | 5 | 0 |
419362 | 419362 | 2020-08-10 | Barry | Michigan | 26015 | 191 | 2 |
419363 | 419363 | 2020-08-10 | Bay | Michigan | 26017 | 638 | 31 |
419364 | 419364 | 2020-08-10 | Benzie | Michigan | 26019 | 29 | 1 |
419365 | 419365 | 2020-08-10 | Berrien | Michigan | 26021 | 1438 | 66 |
419366 | 419366 | 2020-08-10 | Branch | Michigan | 26023 | 1179 | 25 |
419367 | 419367 | 2020-08-10 | Calhoun | Michigan | 26025 | 795 | 42 |
419368 | 419368 | 2020-08-10 | Cass | Michigan | 26027 | 326 | 14 |
419369 | 419369 | 2020-08-10 | Charlevoix | Michigan | 26029 | 53 | 2 |
419370 | 419370 | 2020-08-10 | Cheboygan | Michigan | 26031 | 49 | 2 |
419371 | 419371 | 2020-08-10 | Chippewa | Michigan | 26033 | 41 | 0 |
419372 | 419372 | 2020-08-10 | Clare | Michigan | 26035 | 72 | 3 |
419373 | 419373 | 2020-08-10 | Clinton | Michigan | 26037 | 423 | 13 |
419374 | 419374 | 2020-08-10 | Crawford | Michigan | 26039 | 107 | 5 |
419375 | 419375 | 2020-08-10 | Delta | Michigan | 26041 | 97 | 3 |
419376 | 419376 | 2020-08-10 | Dickinson | Michigan | 26043 | 55 | 2 |
419377 | 419377 | 2020-08-10 | Eaton | Michigan | 26045 | 462 | 8 |
419378 | 419378 | 2020-08-10 | Emmet | Michigan | 26047 | 64 | 2 |
419379 | 419379 | 2020-08-10 | Genesee | Michigan | 26049 | 3664 | 296 |
419380 | 419380 | 2020-08-10 | Gladwin | Michigan | 26051 | 59 | 2 |
419381 | 419381 | 2020-08-10 | Gogebic | Michigan | 26053 | 120 | 1 |
419382 | 419382 | 2020-08-10 | Grand Traverse | Michigan | 26055 | 218 | 5 |
419383 | 419383 | 2020-08-10 | Gratiot | Michigan | 26057 | 162 | 15 |
419384 | 419384 | 2020-08-10 | Hillsdale | Michigan | 26059 | 271 | 25 |
419385 | 419385 | 2020-08-10 | Houghton | Michigan | 26061 | 50 | 0 |
419386 | 419386 | 2020-08-10 | Huron | Michigan | 26063 | 158 | 4 |
419387 | 419387 | 2020-08-10 | Ingham | Michigan | 26065 | 1554 | 31 |
419388 | 419388 | 2020-08-10 | Ionia | Michigan | 26067 | 278 | 7 |
419389 | 419389 | 2020-08-10 | Iosco | Michigan | 26069 | 134 | 12 |
419390 | 419390 | 2020-08-10 | Iron | Michigan | 26071 | 20 | 1 |
419391 | 419391 | 2020-08-10 | Isabella | Michigan | 26073 | 207 | 9 |
419392 | 419392 | 2020-08-10 | Jackson | Michigan | 26075 | 2432 | 56 |
419393 | 419393 | 2020-08-10 | Kalamazoo | Michigan | 26077 | 1648 | 83 |
419394 | 419394 | 2020-08-10 | Kalkaska | Michigan | 26079 | 55 | 4 |
419395 | 419395 | 2020-08-10 | Kent | Michigan | 26081 | 7555 | 157 |
419396 | 419396 | 2020-08-10 | Keweenaw | Michigan | 26083 | 3 | 0 |
419397 | 419397 | 2020-08-10 | Lake | Michigan | 26085 | 23 | 0 |
419398 | 419398 | 2020-08-10 | Lapeer | Michigan | 26087 | 777 | 40 |
419399 | 419399 | 2020-08-10 | Leelanau | Michigan | 26089 | 72 | 0 |
419400 | 419400 | 2020-08-10 | Lenawee | Michigan | 26091 | 1163 | 16 |
419401 | 419401 | 2020-08-10 | Livingston | Michigan | 26093 | 886 | 29 |
419402 | 419402 | 2020-08-10 | Luce | Michigan | 26095 | 7 | 0 |
419403 | 419403 | 2020-08-10 | Mackinac | Michigan | 26097 | 26 | 0 |
419404 | 419404 | 2020-08-10 | Macomb | Michigan | 26099 | 10786 | 952 |
419405 | 419405 | 2020-08-10 | Manistee | Michigan | 26101 | 52 | 0 |
419406 | 419406 | 2020-08-10 | Marquette | Michigan | 26103 | 160 | 11 |
419407 | 419407 | 2020-08-10 | Mason | Michigan | 26105 | 104 | 0 |
419408 | 419408 | 2020-08-10 | Mecosta | Michigan | 26107 | 68 | 2 |
419409 | 419409 | 2020-08-10 | Menominee | Michigan | 26109 | 141 | 0 |
419410 | 419410 | 2020-08-10 | Midland | Michigan | 26111 | 338 | 10 |
419411 | 419411 | 2020-08-10 | Missaukee | Michigan | 26113 | 41 | 1 |
419412 | 419412 | 2020-08-10 | Monroe | Michigan | 26115 | 987 | 25 |
419413 | 419413 | 2020-08-10 | Montcalm | Michigan | 26117 | 194 | 1 |
419414 | 419414 | 2020-08-10 | Montmorency | Michigan | 26119 | 9 | 1 |
419415 | 419415 | 2020-08-10 | Muskegon | Michigan | 26121 | 1179 | 59 |
419416 | 419416 | 2020-08-10 | Newaygo | Michigan | 26123 | 252 | 0 |
419417 | 419417 | 2020-08-10 | Oakland | Michigan | 26125 | 15615 | 1129 |
419418 | 419418 | 2020-08-10 | Oceana | Michigan | 26127 | 479 | 6 |
419419 | 419419 | 2020-08-10 | Ogemaw | Michigan | 26129 | 54 | 2 |
419420 | 419420 | 2020-08-10 | Ontonagon | Michigan | 26131 | 14 | 0 |
419421 | 419421 | 2020-08-10 | Osceola | Michigan | 26133 | 71 | 0 |
419422 | 419422 | 2020-08-10 | Oscoda | Michigan | 26135 | 24 | 1 |
419423 | 419423 | 2020-08-10 | Otsego | Michigan | 26137 | 146 | 11 |
419424 | 419424 | 2020-08-10 | Ottawa | Michigan | 26139 | 1853 | 56 |
419425 | 419425 | 2020-08-10 | Presque Isle | Michigan | 26141 | 20 | 1 |
419426 | 419426 | 2020-08-10 | Roscommon | Michigan | 26143 | 53 | 0 |
419427 | 419427 | 2020-08-10 | Saginaw | Michigan | 26145 | 2036 | 130 |
419428 | 419428 | 2020-08-10 | Sanilac | Michigan | 26151 | 110 | 6 |
419429 | 419429 | 2020-08-10 | Schoolcraft | Michigan | 26153 | 13 | 0 |
419430 | 419430 | 2020-08-10 | Shiawassee | Michigan | 26155 | 343 | 28 |
419431 | 419431 | 2020-08-10 | St. Clair | Michigan | 26147 | 824 | 53 |
419432 | 419432 | 2020-08-10 | St. Joseph | Michigan | 26149 | 591 | 8 |
419433 | 419433 | 2020-08-10 | Tuscola | Michigan | 26157 | 356 | 29 |
419434 | 419434 | 2020-08-10 | Unknown | Michigan | 305 | 4 | |
419435 | 419435 | 2020-08-10 | Van Buren | Michigan | 26159 | 454 | 10 |
419436 | 419436 | 2020-08-10 | Washtenaw | Michigan | 26161 | 3081 | 122 |
419437 | 419437 | 2020-08-10 | Wayne | Michigan | 26163 | 28298 | 2828 |
419438 | 419438 | 2020-08-10 | Wexford | Michigan | 26165 | 73 | 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);