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 2021-01-11 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
918435 | 918435 | 2021-01-11 | Alcona | Michigan | 26001 | 378 | 18 |
918436 | 918436 | 2021-01-11 | Alger | Michigan | 26003 | 475 | 3 |
918437 | 918437 | 2021-01-11 | Allegan | Michigan | 26005 | 6256 | 87 |
918438 | 918438 | 2021-01-11 | Alpena | Michigan | 26007 | 1309 | 36 |
918439 | 918439 | 2021-01-11 | Antrim | Michigan | 26009 | 748 | 13 |
918440 | 918440 | 2021-01-11 | Arenac | Michigan | 26011 | 648 | 25 |
918441 | 918441 | 2021-01-11 | Baraga | Michigan | 26013 | 629 | 29 |
918442 | 918442 | 2021-01-11 | Barry | Michigan | 26015 | 3216 | 38 |
918443 | 918443 | 2021-01-11 | Bay | Michigan | 26017 | 6711 | 218 |
918444 | 918444 | 2021-01-11 | Benzie | Michigan | 26019 | 757 | 28 |
918445 | 918445 | 2021-01-11 | Berrien | Michigan | 26021 | 9994 | 205 |
918446 | 918446 | 2021-01-11 | Branch | Michigan | 26023 | 4157 | 96 |
918447 | 918447 | 2021-01-11 | Calhoun | Michigan | 26025 | 8230 | 206 |
918448 | 918448 | 2021-01-11 | Cass | Michigan | 26027 | 3441 | 52 |
918449 | 918449 | 2021-01-11 | Charlevoix | Michigan | 26029 | 903 | 10 |
918450 | 918450 | 2021-01-11 | Cheboygan | Michigan | 26031 | 803 | 33 |
918451 | 918451 | 2021-01-11 | Chippewa | Michigan | 26033 | 2992 | 21 |
918452 | 918452 | 2021-01-11 | Clare | Michigan | 26035 | 1325 | 57 |
918453 | 918453 | 2021-01-11 | Clinton | Michigan | 26037 | 4344 | 50 |
918454 | 918454 | 2021-01-11 | Crawford | Michigan | 26039 | 504 | 5 |
918455 | 918455 | 2021-01-11 | Delta | Michigan | 26041 | 2977 | 78 |
918456 | 918456 | 2021-01-11 | Dickinson | Michigan | 26043 | 2251 | 70 |
918457 | 918457 | 2021-01-11 | Eaton | Michigan | 26045 | 5186 | 110 |
918458 | 918458 | 2021-01-11 | Emmet | Michigan | 26047 | 1294 | 34 |
918459 | 918459 | 2021-01-11 | Genesee | Michigan | 26049 | 22896 | 650 |
918460 | 918460 | 2021-01-11 | Gladwin | Michigan | 26051 | 1296 | 35 |
918461 | 918461 | 2021-01-11 | Gogebic | Michigan | 26053 | 1047 | 39 |
918462 | 918462 | 2021-01-11 | Grand Traverse | Michigan | 26055 | 3504 | 51 |
918463 | 918463 | 2021-01-11 | Gratiot | Michigan | 26057 | 4251 | 87 |
918464 | 918464 | 2021-01-11 | Hillsdale | Michigan | 26059 | 2864 | 62 |
918465 | 918465 | 2021-01-11 | Houghton | Michigan | 26061 | 2194 | 34 |
918466 | 918466 | 2021-01-11 | Huron | Michigan | 26063 | 1691 | 52 |
918467 | 918467 | 2021-01-11 | Ingham | Michigan | 26065 | 13577 | 217 |
918468 | 918468 | 2021-01-11 | Ionia | Michigan | 26067 | 5152 | 54 |
918469 | 918469 | 2021-01-11 | Iosco | Michigan | 26069 | 1183 | 56 |
918470 | 918470 | 2021-01-11 | Iron | Michigan | 26071 | 867 | 37 |
918471 | 918471 | 2021-01-11 | Isabella | Michigan | 26073 | 3667 | 56 |
918472 | 918472 | 2021-01-11 | Jackson | Michigan | 26075 | 10977 | 208 |
918473 | 918473 | 2021-01-11 | Kalamazoo | Michigan | 26077 | 13267 | 274 |
918474 | 918474 | 2021-01-11 | Kalkaska | Michigan | 26079 | 516 | 14 |
918475 | 918475 | 2021-01-11 | Kent | Michigan | 26081 | 46228 | 594 |
918476 | 918476 | 2021-01-11 | Keweenaw | Michigan | 26083 | 99 | 2 |
918477 | 918477 | 2021-01-11 | Lake | Michigan | 26085 | 319 | 10 |
918478 | 918478 | 2021-01-11 | Lapeer | Michigan | 26087 | 4614 | 110 |
918479 | 918479 | 2021-01-11 | Leelanau | Michigan | 26089 | 707 | 9 |
918480 | 918480 | 2021-01-11 | Lenawee | Michigan | 26091 | 6013 | 77 |
918481 | 918481 | 2021-01-11 | Livingston | Michigan | 26093 | 8718 | 90 |
918482 | 918482 | 2021-01-11 | Luce | Michigan | 26095 | 980 | 0 |
918483 | 918483 | 2021-01-11 | Mackinac | Michigan | 26097 | 397 | 3 |
918484 | 918484 | 2021-01-11 | Macomb | Michigan | 26099 | 52638 | 1721 |
918485 | 918485 | 2021-01-11 | Manistee | Michigan | 26101 | 685 | 18 |
918486 | 918486 | 2021-01-11 | Marquette | Michigan | 26103 | 4571 | 52 |
918487 | 918487 | 2021-01-11 | Mason | Michigan | 26105 | 1072 | 22 |
918488 | 918488 | 2021-01-11 | Mecosta | Michigan | 26107 | 1754 | 14 |
918489 | 918489 | 2021-01-11 | Menominee | Michigan | 26109 | 1769 | 32 |
918490 | 918490 | 2021-01-11 | Midland | Michigan | 26111 | 4351 | 49 |
918491 | 918491 | 2021-01-11 | Missaukee | Michigan | 26113 | 582 | 12 |
918492 | 918492 | 2021-01-11 | Monroe | Michigan | 26115 | 8325 | 170 |
918493 | 918493 | 2021-01-11 | Montcalm | Michigan | 26117 | 3436 | 74 |
918494 | 918494 | 2021-01-11 | Montmorency | Michigan | 26119 | 333 | 12 |
918495 | 918495 | 2021-01-11 | Muskegon | Michigan | 26121 | 11576 | 285 |
918496 | 918496 | 2021-01-11 | Newaygo | Michigan | 26123 | 2420 | 39 |
918497 | 918497 | 2021-01-11 | Oakland | Michigan | 26125 | 65546 | 1751 |
918498 | 918498 | 2021-01-11 | Oceana | Michigan | 26127 | 1700 | 43 |
918499 | 918499 | 2021-01-11 | Ogemaw | Michigan | 26129 | 993 | 29 |
918500 | 918500 | 2021-01-11 | Ontonagon | Michigan | 26131 | 312 | 16 |
918501 | 918501 | 2021-01-11 | Osceola | Michigan | 26133 | 923 | 19 |
918502 | 918502 | 2021-01-11 | Oscoda | Michigan | 26135 | 330 | 18 |
918503 | 918503 | 2021-01-11 | Otsego | Michigan | 26137 | 1062 | 25 |
918504 | 918504 | 2021-01-11 | Ottawa | Michigan | 26139 | 19712 | 297 |
918505 | 918505 | 2021-01-11 | Presque Isle | Michigan | 26141 | 579 | 18 |
918506 | 918506 | 2021-01-11 | Roscommon | Michigan | 26143 | 1031 | 28 |
918507 | 918507 | 2021-01-11 | Saginaw | Michigan | 26145 | 13209 | 435 |
918508 | 918508 | 2021-01-11 | Sanilac | Michigan | 26151 | 1650 | 67 |
918509 | 918509 | 2021-01-11 | Schoolcraft | Michigan | 26153 | 244 | 4 |
918510 | 918510 | 2021-01-11 | Shiawassee | Michigan | 26155 | 3224 | 62 |
918511 | 918511 | 2021-01-11 | St. Clair | Michigan | 26147 | 7672 | 193 |
918512 | 918512 | 2021-01-11 | St. Joseph | Michigan | 26149 | 3951 | 63 |
918513 | 918513 | 2021-01-11 | Tuscola | Michigan | 26157 | 2884 | 106 |
918514 | 918514 | 2021-01-11 | Unknown | Michigan | 8770 | 46 | |
918515 | 918515 | 2021-01-11 | Van Buren | Michigan | 26159 | 4409 | 86 |
918516 | 918516 | 2021-01-11 | Washtenaw | Michigan | 26161 | 15466 | 220 |
918517 | 918517 | 2021-01-11 | Wayne | Michigan | 26163 | 90377 | 3794 |
918518 | 918518 | 2021-01-11 | Wexford | Michigan | 26165 | 1123 | 20 |
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);