ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where date = "2020-05-10" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
131412 | 131412 | 2020-05-10 | Alcona | Michigan | 26001 | 4 | 1 |
131413 | 131413 | 2020-05-10 | Allegan | Michigan | 26005 | 150 | 2 |
131414 | 131414 | 2020-05-10 | Alpena | Michigan | 26007 | 87 | 8 |
131415 | 131415 | 2020-05-10 | Antrim | Michigan | 26009 | 10 | 0 |
131416 | 131416 | 2020-05-10 | Arenac | Michigan | 26011 | 27 | 1 |
131417 | 131417 | 2020-05-10 | Baraga | Michigan | 26013 | 1 | 0 |
131418 | 131418 | 2020-05-10 | Barry | Michigan | 26015 | 48 | 1 |
131419 | 131419 | 2020-05-10 | Bay | Michigan | 26017 | 192 | 9 |
131420 | 131420 | 2020-05-10 | Benzie | Michigan | 26019 | 4 | 0 |
131421 | 131421 | 2020-05-10 | Berrien | Michigan | 26021 | 391 | 22 |
131422 | 131422 | 2020-05-10 | Branch | Michigan | 26023 | 870 | 20 |
131423 | 131423 | 2020-05-10 | Calhoun | Michigan | 26025 | 260 | 17 |
131424 | 131424 | 2020-05-10 | Cass | Michigan | 26027 | 41 | 2 |
131425 | 131425 | 2020-05-10 | Charlevoix | Michigan | 26029 | 13 | 1 |
131426 | 131426 | 2020-05-10 | Cheboygan | Michigan | 26031 | 19 | 1 |
131427 | 131427 | 2020-05-10 | Chippewa | Michigan | 26033 | 3 | 0 |
131428 | 131428 | 2020-05-10 | Clare | Michigan | 26035 | 12 | 2 |
131429 | 131429 | 2020-05-10 | Clinton | Michigan | 26037 | 126 | 10 |
131430 | 131430 | 2020-05-10 | Crawford | Michigan | 26039 | 57 | 4 |
131431 | 131431 | 2020-05-10 | Delta | Michigan | 26041 | 14 | 2 |
131432 | 131432 | 2020-05-10 | Dickinson | Michigan | 26043 | 5 | 2 |
131433 | 131433 | 2020-05-10 | Eaton | Michigan | 26045 | 150 | 6 |
131434 | 131434 | 2020-05-10 | Emmet | Michigan | 26047 | 21 | 2 |
131435 | 131435 | 2020-05-10 | Genesee | Michigan | 26049 | 1758 | 224 |
131436 | 131436 | 2020-05-10 | Gladwin | Michigan | 26051 | 17 | 1 |
131437 | 131437 | 2020-05-10 | Gogebic | Michigan | 26053 | 4 | 1 |
131438 | 131438 | 2020-05-10 | Grand Traverse | Michigan | 26055 | 20 | 5 |
131439 | 131439 | 2020-05-10 | Gratiot | Michigan | 26057 | 36 | 3 |
131440 | 131440 | 2020-05-10 | Hillsdale | Michigan | 26059 | 152 | 21 |
131441 | 131441 | 2020-05-10 | Houghton | Michigan | 26061 | 2 | 0 |
131442 | 131442 | 2020-05-10 | Huron | Michigan | 26063 | 35 | 1 |
131443 | 131443 | 2020-05-10 | Ingham | Michigan | 26065 | 579 | 16 |
131444 | 131444 | 2020-05-10 | Ionia | Michigan | 26067 | 111 | 2 |
131445 | 131445 | 2020-05-10 | Iosco | Michigan | 26069 | 55 | 8 |
131446 | 131446 | 2020-05-10 | Isabella | Michigan | 26073 | 62 | 7 |
131447 | 131447 | 2020-05-10 | Jackson | Michigan | 26075 | 1364 | 43 |
131448 | 131448 | 2020-05-10 | Kalamazoo | Michigan | 26077 | 601 | 29 |
131449 | 131449 | 2020-05-10 | Kalkaska | Michigan | 26079 | 18 | 2 |
131450 | 131450 | 2020-05-10 | Kent | Michigan | 26081 | 2284 | 41 |
131451 | 131451 | 2020-05-10 | Lake | Michigan | 26085 | 2 | 0 |
131452 | 131452 | 2020-05-10 | Lapeer | Michigan | 26087 | 231 | 30 |
131453 | 131453 | 2020-05-10 | Leelanau | Michigan | 26089 | 9 | 0 |
131454 | 131454 | 2020-05-10 | Lenawee | Michigan | 26091 | 212 | 4 |
131455 | 131455 | 2020-05-10 | Livingston | Michigan | 26093 | 384 | 23 |
131456 | 131456 | 2020-05-10 | Luce | Michigan | 26095 | 2 | 0 |
131457 | 131457 | 2020-05-10 | Mackinac | Michigan | 26097 | 6 | 0 |
131458 | 131458 | 2020-05-10 | Macomb | Michigan | 26099 | 6150 | 703 |
131459 | 131459 | 2020-05-10 | Manistee | Michigan | 26101 | 11 | 0 |
131460 | 131460 | 2020-05-10 | Marquette | Michigan | 26103 | 51 | 10 |
131461 | 131461 | 2020-05-10 | Mason | Michigan | 26105 | 21 | 0 |
131462 | 131462 | 2020-05-10 | Mecosta | Michigan | 26107 | 16 | 2 |
131463 | 131463 | 2020-05-10 | Menominee | Michigan | 26109 | 6 | 0 |
131464 | 131464 | 2020-05-10 | Midland | Michigan | 26111 | 66 | 8 |
131465 | 131465 | 2020-05-10 | Missaukee | Michigan | 26113 | 16 | 1 |
131466 | 131466 | 2020-05-10 | Monroe | Michigan | 26115 | 389 | 16 |
131467 | 131467 | 2020-05-10 | Montcalm | Michigan | 26117 | 46 | 1 |
131468 | 131468 | 2020-05-10 | Montmorency | Michigan | 26119 | 5 | 0 |
131469 | 131469 | 2020-05-10 | Muskegon | Michigan | 26121 | 367 | 20 |
131470 | 131470 | 2020-05-10 | Newaygo | Michigan | 26123 | 34 | 0 |
131471 | 131471 | 2020-05-10 | Oakland | Michigan | 26125 | 7736 | 843 |
131472 | 131472 | 2020-05-10 | Oceana | Michigan | 26127 | 28 | 1 |
131473 | 131473 | 2020-05-10 | Ogemaw | Michigan | 26129 | 15 | 0 |
131474 | 131474 | 2020-05-10 | Osceola | Michigan | 26133 | 9 | 0 |
131475 | 131475 | 2020-05-10 | Oscoda | Michigan | 26135 | 5 | 1 |
131476 | 131476 | 2020-05-10 | Otsego | Michigan | 26137 | 97 | 9 |
131477 | 131477 | 2020-05-10 | Ottawa | Michigan | 26139 | 388 | 19 |
131478 | 131478 | 2020-05-10 | Presque Isle | Michigan | 26141 | 11 | 0 |
131479 | 131479 | 2020-05-10 | Roscommon | Michigan | 26143 | 20 | 0 |
131480 | 131480 | 2020-05-10 | Saginaw | Michigan | 26145 | 790 | 83 |
131481 | 131481 | 2020-05-10 | Sanilac | Michigan | 26151 | 37 | 5 |
131482 | 131482 | 2020-05-10 | Schoolcraft | Michigan | 26153 | 4 | 0 |
131483 | 131483 | 2020-05-10 | Shiawassee | Michigan | 26155 | 204 | 17 |
131484 | 131484 | 2020-05-10 | St. Clair | Michigan | 26147 | 357 | 25 |
131485 | 131485 | 2020-05-10 | St. Joseph | Michigan | 26149 | 65 | 1 |
131486 | 131486 | 2020-05-10 | Tuscola | Michigan | 26157 | 134 | 17 |
131487 | 131487 | 2020-05-10 | Unknown | Michigan | 49 | 3 | |
131488 | 131488 | 2020-05-10 | Van Buren | Michigan | 26159 | 88 | 4 |
131489 | 131489 | 2020-05-10 | Washtenaw | Michigan | 26161 | 1346 | 87 |
131490 | 131490 | 2020-05-10 | Wayne | Michigan | 26163 | 18095 | 2099 |
131491 | 131491 | 2020-05-10 | Wexford | Michigan | 26165 | 11 | 2 |
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);