ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where "date" is on date 2020-05-12 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
137393 | 137393 | 2020-05-12 | Alcona | Michigan | 26001 | 4 | 1 |
137394 | 137394 | 2020-05-12 | Allegan | Michigan | 26005 | 161 | 2 |
137395 | 137395 | 2020-05-12 | Alpena | Michigan | 26007 | 87 | 8 |
137396 | 137396 | 2020-05-12 | Antrim | Michigan | 26009 | 10 | 0 |
137397 | 137397 | 2020-05-12 | Arenac | Michigan | 26011 | 28 | 1 |
137398 | 137398 | 2020-05-12 | Baraga | Michigan | 26013 | 1 | 0 |
137399 | 137399 | 2020-05-12 | Barry | Michigan | 26015 | 52 | 1 |
137400 | 137400 | 2020-05-12 | Bay | Michigan | 26017 | 214 | 10 |
137401 | 137401 | 2020-05-12 | Benzie | Michigan | 26019 | 4 | 0 |
137402 | 137402 | 2020-05-12 | Berrien | Michigan | 26021 | 411 | 25 |
137403 | 137403 | 2020-05-12 | Branch | Michigan | 26023 | 873 | 21 |
137404 | 137404 | 2020-05-12 | Calhoun | Michigan | 26025 | 275 | 17 |
137405 | 137405 | 2020-05-12 | Cass | Michigan | 26027 | 43 | 2 |
137406 | 137406 | 2020-05-12 | Charlevoix | Michigan | 26029 | 13 | 1 |
137407 | 137407 | 2020-05-12 | Cheboygan | Michigan | 26031 | 19 | 1 |
137408 | 137408 | 2020-05-12 | Chippewa | Michigan | 26033 | 3 | 0 |
137409 | 137409 | 2020-05-12 | Clare | Michigan | 26035 | 12 | 2 |
137410 | 137410 | 2020-05-12 | Clinton | Michigan | 26037 | 126 | 10 |
137411 | 137411 | 2020-05-12 | Crawford | Michigan | 26039 | 57 | 4 |
137412 | 137412 | 2020-05-12 | Delta | Michigan | 26041 | 14 | 2 |
137413 | 137413 | 2020-05-12 | Dickinson | Michigan | 26043 | 5 | 2 |
137414 | 137414 | 2020-05-12 | Eaton | Michigan | 26045 | 152 | 6 |
137415 | 137415 | 2020-05-12 | Emmet | Michigan | 26047 | 21 | 2 |
137416 | 137416 | 2020-05-12 | Genesee | Michigan | 26049 | 1782 | 225 |
137417 | 137417 | 2020-05-12 | Gladwin | Michigan | 26051 | 18 | 1 |
137418 | 137418 | 2020-05-12 | Gogebic | Michigan | 26053 | 4 | 1 |
137419 | 137419 | 2020-05-12 | Grand Traverse | Michigan | 26055 | 21 | 5 |
137420 | 137420 | 2020-05-12 | Gratiot | Michigan | 26057 | 38 | 4 |
137421 | 137421 | 2020-05-12 | Hillsdale | Michigan | 26059 | 152 | 22 |
137422 | 137422 | 2020-05-12 | Houghton | Michigan | 26061 | 2 | 0 |
137423 | 137423 | 2020-05-12 | Huron | Michigan | 26063 | 36 | 1 |
137424 | 137424 | 2020-05-12 | Ingham | Michigan | 26065 | 594 | 17 |
137425 | 137425 | 2020-05-12 | Ionia | Michigan | 26067 | 113 | 3 |
137426 | 137426 | 2020-05-12 | Iosco | Michigan | 26069 | 55 | 8 |
137427 | 137427 | 2020-05-12 | Isabella | Michigan | 26073 | 61 | 7 |
137428 | 137428 | 2020-05-12 | Jackson | Michigan | 26075 | 1382 | 43 |
137429 | 137429 | 2020-05-12 | Kalamazoo | Michigan | 26077 | 636 | 36 |
137430 | 137430 | 2020-05-12 | Kalkaska | Michigan | 26079 | 17 | 2 |
137431 | 137431 | 2020-05-12 | Kent | Michigan | 26081 | 2420 | 45 |
137432 | 137432 | 2020-05-12 | Lake | Michigan | 26085 | 2 | 0 |
137433 | 137433 | 2020-05-12 | Lapeer | Michigan | 26087 | 230 | 31 |
137434 | 137434 | 2020-05-12 | Leelanau | Michigan | 26089 | 9 | 0 |
137435 | 137435 | 2020-05-12 | Lenawee | Michigan | 26091 | 214 | 4 |
137436 | 137436 | 2020-05-12 | Livingston | Michigan | 26093 | 385 | 23 |
137437 | 137437 | 2020-05-12 | Luce | Michigan | 26095 | 2 | 0 |
137438 | 137438 | 2020-05-12 | Mackinac | Michigan | 26097 | 6 | 0 |
137439 | 137439 | 2020-05-12 | Macomb | Michigan | 26099 | 6205 | 715 |
137440 | 137440 | 2020-05-12 | Manistee | Michigan | 26101 | 11 | 0 |
137441 | 137441 | 2020-05-12 | Marquette | Michigan | 26103 | 51 | 10 |
137442 | 137442 | 2020-05-12 | Mason | Michigan | 26105 | 23 | 0 |
137443 | 137443 | 2020-05-12 | Mecosta | Michigan | 26107 | 16 | 2 |
137444 | 137444 | 2020-05-12 | Menominee | Michigan | 26109 | 6 | 0 |
137445 | 137445 | 2020-05-12 | Midland | Michigan | 26111 | 67 | 8 |
137446 | 137446 | 2020-05-12 | Missaukee | Michigan | 26113 | 16 | 1 |
137447 | 137447 | 2020-05-12 | Monroe | Michigan | 26115 | 399 | 18 |
137448 | 137448 | 2020-05-12 | Montcalm | Michigan | 26117 | 47 | 1 |
137449 | 137449 | 2020-05-12 | Montmorency | Michigan | 26119 | 5 | 0 |
137450 | 137450 | 2020-05-12 | Muskegon | Michigan | 26121 | 401 | 20 |
137451 | 137451 | 2020-05-12 | Newaygo | Michigan | 26123 | 36 | 0 |
137452 | 137452 | 2020-05-12 | Oakland | Michigan | 26125 | 7784 | 872 |
137453 | 137453 | 2020-05-12 | Oceana | Michigan | 26127 | 34 | 1 |
137454 | 137454 | 2020-05-12 | Ogemaw | Michigan | 26129 | 15 | 0 |
137455 | 137455 | 2020-05-12 | Osceola | Michigan | 26133 | 9 | 0 |
137456 | 137456 | 2020-05-12 | Oscoda | Michigan | 26135 | 5 | 1 |
137457 | 137457 | 2020-05-12 | Otsego | Michigan | 26137 | 98 | 10 |
137458 | 137458 | 2020-05-12 | Ottawa | Michigan | 26139 | 430 | 20 |
137459 | 137459 | 2020-05-12 | Presque Isle | Michigan | 26141 | 11 | 0 |
137460 | 137460 | 2020-05-12 | Roscommon | Michigan | 26143 | 20 | 0 |
137461 | 137461 | 2020-05-12 | Saginaw | Michigan | 26145 | 830 | 87 |
137462 | 137462 | 2020-05-12 | Sanilac | Michigan | 26151 | 38 | 5 |
137463 | 137463 | 2020-05-12 | Schoolcraft | Michigan | 26153 | 4 | 0 |
137464 | 137464 | 2020-05-12 | Shiawassee | Michigan | 26155 | 214 | 18 |
137465 | 137465 | 2020-05-12 | St. Clair | Michigan | 26147 | 366 | 28 |
137466 | 137466 | 2020-05-12 | St. Joseph | Michigan | 26149 | 71 | 1 |
137467 | 137467 | 2020-05-12 | Tuscola | Michigan | 26157 | 162 | 17 |
137468 | 137468 | 2020-05-12 | Unknown | Michigan | 38 | 7 | |
137469 | 137469 | 2020-05-12 | Van Buren | Michigan | 26159 | 94 | 4 |
137470 | 137470 | 2020-05-12 | Washtenaw | Michigan | 26161 | 1371 | 88 |
137471 | 137471 | 2020-05-12 | Wayne | Michigan | 26163 | 18294 | 2142 |
137472 | 137472 | 2020-05-12 | 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);