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-03-05 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090449 | 1090449 | 2021-03-05 | Alcona | Michigan | 26001 | 431 | 24 |
1090450 | 1090450 | 2021-03-05 | Alger | Michigan | 26003 | 584 | 5 |
1090451 | 1090451 | 2021-03-05 | Allegan | Michigan | 26005 | 7394 | 118 |
1090452 | 1090452 | 2021-03-05 | Alpena | Michigan | 26007 | 1500 | 48 |
1090453 | 1090453 | 2021-03-05 | Antrim | Michigan | 26009 | 979 | 20 |
1090454 | 1090454 | 2021-03-05 | Arenac | Michigan | 26011 | 766 | 25 |
1090455 | 1090455 | 2021-03-05 | Baraga | Michigan | 26013 | 777 | 33 |
1090456 | 1090456 | 2021-03-05 | Barry | Michigan | 26015 | 3809 | 46 |
1090457 | 1090457 | 2021-03-05 | Bay | Michigan | 26017 | 7531 | 293 |
1090458 | 1090458 | 2021-03-05 | Benzie | Michigan | 26019 | 928 | 31 |
1090459 | 1090459 | 2021-03-05 | Berrien | Michigan | 26021 | 11690 | 245 |
1090460 | 1090460 | 2021-03-05 | Branch | Michigan | 26023 | 4620 | 110 |
1090461 | 1090461 | 2021-03-05 | Calhoun | Michigan | 26025 | 9784 | 235 |
1090462 | 1090462 | 2021-03-05 | Cass | Michigan | 26027 | 4079 | 64 |
1090463 | 1090463 | 2021-03-05 | Charlevoix | Michigan | 26029 | 1065 | 13 |
1090464 | 1090464 | 2021-03-05 | Cheboygan | Michigan | 26031 | 1032 | 37 |
1090465 | 1090465 | 2021-03-05 | Chippewa | Michigan | 26033 | 4889 | 43 |
1090466 | 1090466 | 2021-03-05 | Clare | Michigan | 26035 | 1625 | 69 |
1090467 | 1090467 | 2021-03-05 | Clinton | Michigan | 26037 | 5090 | 71 |
1090468 | 1090468 | 2021-03-05 | Crawford | Michigan | 26039 | 607 | 5 |
1090469 | 1090469 | 2021-03-05 | Delta | Michigan | 26041 | 3156 | 84 |
1090470 | 1090470 | 2021-03-05 | Dickinson | Michigan | 26043 | 2373 | 70 |
1090471 | 1090471 | 2021-03-05 | Eaton | Michigan | 26045 | 6388 | 156 |
1090472 | 1090472 | 2021-03-05 | Emmet | Michigan | 26047 | 1557 | 39 |
1090473 | 1090473 | 2021-03-05 | Genesee | Michigan | 26049 | 26041 | 756 |
1090474 | 1090474 | 2021-03-05 | Gladwin | Michigan | 26051 | 1499 | 43 |
1090475 | 1090475 | 2021-03-05 | Gogebic | Michigan | 26053 | 1288 | 48 |
1090476 | 1090476 | 2021-03-05 | Grand Traverse | Michigan | 26055 | 4368 | 70 |
1090477 | 1090477 | 2021-03-05 | Gratiot | Michigan | 26057 | 5679 | 107 |
1090478 | 1090478 | 2021-03-05 | Hillsdale | Michigan | 26059 | 3388 | 76 |
1090479 | 1090479 | 2021-03-05 | Houghton | Michigan | 26061 | 2685 | 40 |
1090480 | 1090480 | 2021-03-05 | Huron | Michigan | 26063 | 2189 | 59 |
1090481 | 1090481 | 2021-03-05 | Ingham | Michigan | 26065 | 16617 | 281 |
1090482 | 1090482 | 2021-03-05 | Ionia | Michigan | 26067 | 7101 | 76 |
1090483 | 1090483 | 2021-03-05 | Iosco | Michigan | 26069 | 1282 | 67 |
1090484 | 1090484 | 2021-03-05 | Iron | Michigan | 26071 | 928 | 49 |
1090485 | 1090485 | 2021-03-05 | Isabella | Michigan | 26073 | 4054 | 73 |
1090486 | 1090486 | 2021-03-05 | Jackson | Michigan | 26075 | 14341 | 253 |
1090487 | 1090487 | 2021-03-05 | Kalamazoo | Michigan | 26077 | 15222 | 324 |
1090488 | 1090488 | 2021-03-05 | Kalkaska | Michigan | 26079 | 630 | 15 |
1090489 | 1090489 | 2021-03-05 | Kent | Michigan | 26081 | 52237 | 714 |
1090490 | 1090490 | 2021-03-05 | Keweenaw | Michigan | 26083 | 145 | 2 |
1090491 | 1090491 | 2021-03-05 | Lake | Michigan | 26085 | 367 | 11 |
1090492 | 1090492 | 2021-03-05 | Lapeer | Michigan | 26087 | 5672 | 131 |
1090493 | 1090493 | 2021-03-05 | Leelanau | Michigan | 26089 | 888 | 15 |
1090494 | 1090494 | 2021-03-05 | Lenawee | Michigan | 26091 | 7865 | 129 |
1090495 | 1090495 | 2021-03-05 | Livingston | Michigan | 26093 | 10566 | 147 |
1090496 | 1090496 | 2021-03-05 | Luce | Michigan | 26095 | 1087 | 2 |
1090497 | 1090497 | 2021-03-05 | Mackinac | Michigan | 26097 | 447 | 3 |
1090498 | 1090498 | 2021-03-05 | Macomb | Michigan | 26099 | 60378 | 1978 |
1090499 | 1090499 | 2021-03-05 | Manistee | Michigan | 26101 | 1535 | 23 |
1090500 | 1090500 | 2021-03-05 | Marquette | Michigan | 26103 | 4826 | 57 |
1090501 | 1090501 | 2021-03-05 | Mason | Michigan | 26105 | 1249 | 26 |
1090502 | 1090502 | 2021-03-05 | Mecosta | Michigan | 26107 | 2041 | 20 |
1090503 | 1090503 | 2021-03-05 | Menominee | Michigan | 26109 | 1882 | 38 |
1090504 | 1090504 | 2021-03-05 | Midland | Michigan | 26111 | 5064 | 65 |
1090505 | 1090505 | 2021-03-05 | Missaukee | Michigan | 26113 | 808 | 17 |
1090506 | 1090506 | 2021-03-05 | Monroe | Michigan | 26115 | 9969 | 204 |
1090507 | 1090507 | 2021-03-05 | Montcalm | Michigan | 26117 | 5667 | 94 |
1090508 | 1090508 | 2021-03-05 | Montmorency | Michigan | 26119 | 369 | 17 |
1090509 | 1090509 | 2021-03-05 | Muskegon | Michigan | 26121 | 12729 | 317 |
1090510 | 1090510 | 2021-03-05 | Newaygo | Michigan | 26123 | 2918 | 52 |
1090511 | 1090511 | 2021-03-05 | Oakland | Michigan | 26125 | 75649 | 2008 |
1090512 | 1090512 | 2021-03-05 | Oceana | Michigan | 26127 | 1889 | 50 |
1090513 | 1090513 | 2021-03-05 | Ogemaw | Michigan | 26129 | 1116 | 34 |
1090514 | 1090514 | 2021-03-05 | Ontonagon | Michigan | 26131 | 413 | 20 |
1090515 | 1090515 | 2021-03-05 | Osceola | Michigan | 26133 | 1068 | 23 |
1090516 | 1090516 | 2021-03-05 | Oscoda | Michigan | 26135 | 401 | 19 |
1090517 | 1090517 | 2021-03-05 | Otsego | Michigan | 26137 | 1196 | 27 |
1090518 | 1090518 | 2021-03-05 | Ottawa | Michigan | 26139 | 22556 | 357 |
1090519 | 1090519 | 2021-03-05 | Presque Isle | Michigan | 26141 | 668 | 28 |
1090520 | 1090520 | 2021-03-05 | Roscommon | Michigan | 26143 | 1186 | 33 |
1090521 | 1090521 | 2021-03-05 | Saginaw | Michigan | 26145 | 16130 | 526 |
1090522 | 1090522 | 2021-03-05 | Sanilac | Michigan | 26151 | 2137 | 77 |
1090523 | 1090523 | 2021-03-05 | Schoolcraft | Michigan | 26153 | 258 | 5 |
1090524 | 1090524 | 2021-03-05 | Shiawassee | Michigan | 26155 | 3879 | 80 |
1090525 | 1090525 | 2021-03-05 | St. Clair | Michigan | 26147 | 8842 | 260 |
1090526 | 1090526 | 2021-03-05 | St. Joseph | Michigan | 26149 | 4767 | 85 |
1090527 | 1090527 | 2021-03-05 | Tuscola | Michigan | 26157 | 3264 | 138 |
1090528 | 1090528 | 2021-03-05 | Unknown | Michigan | 0 | 12 | |
1090529 | 1090529 | 2021-03-05 | Van Buren | Michigan | 26159 | 5020 | 96 |
1090530 | 1090530 | 2021-03-05 | Washtenaw | Michigan | 26161 | 19548 | 252 |
1090531 | 1090531 | 2021-03-05 | Wayne | Michigan | 26163 | 103309 | 4158 |
1090532 | 1090532 | 2021-03-05 | Wexford | Michigan | 26165 | 1476 | 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);