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 2022-05-04 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 |
---|---|---|---|---|---|---|---|
2471501 | 2471501 | 2022-05-04 | Alcona | Michigan | 26001 | 1738 | 71 |
2471502 | 2471502 | 2022-05-04 | Alger | Michigan | 26003 | 1870 | 13 |
2471503 | 2471503 | 2022-05-04 | Allegan | Michigan | 26005 | 27287 | 349 |
2471504 | 2471504 | 2022-05-04 | Alpena | Michigan | 26007 | 5767 | 139 |
2471505 | 2471505 | 2022-05-04 | Antrim | Michigan | 26009 | 4401 | 65 |
2471506 | 2471506 | 2022-05-04 | Arenac | Michigan | 26011 | 3242 | 67 |
2471507 | 2471507 | 2022-05-04 | Baraga | Michigan | 26013 | 2219 | 54 |
2471508 | 2471508 | 2022-05-04 | Barry | Michigan | 26015 | 14443 | 169 |
2471509 | 2471509 | 2022-05-04 | Bay | Michigan | 26017 | 27284 | 584 |
2471510 | 2471510 | 2022-05-04 | Benzie | Michigan | 26019 | 3474 | 68 |
2471511 | 2471511 | 2022-05-04 | Berrien | Michigan | 26021 | 35114 | 557 |
2471512 | 2471512 | 2022-05-04 | Branch | Michigan | 26023 | 12211 | 206 |
2471513 | 2471513 | 2022-05-04 | Calhoun | Michigan | 26025 | 34687 | 575 |
2471514 | 2471514 | 2022-05-04 | Cass | Michigan | 26027 | 11165 | 145 |
2471515 | 2471515 | 2022-05-04 | Charlevoix | Michigan | 26029 | 4959 | 60 |
2471516 | 2471516 | 2022-05-04 | Cheboygan | Michigan | 26031 | 4667 | 103 |
2471517 | 2471517 | 2022-05-04 | Chippewa | Michigan | 26033 | 11738 | 120 |
2471518 | 2471518 | 2022-05-04 | Clare | Michigan | 26035 | 6790 | 157 |
2471519 | 2471519 | 2022-05-04 | Clinton | Michigan | 26037 | 21647 | 207 |
2471520 | 2471520 | 2022-05-04 | Crawford | Michigan | 26039 | 2596 | 31 |
2471521 | 2471521 | 2022-05-04 | Delta | Michigan | 26041 | 9984 | 157 |
2471522 | 2471522 | 2022-05-04 | Dickinson | Michigan | 26043 | 7447 | 109 |
2471523 | 2471523 | 2022-05-04 | Eaton | Michigan | 26045 | 27231 | 403 |
2471524 | 2471524 | 2022-05-04 | Emmet | Michigan | 26047 | 6484 | 86 |
2471525 | 2471525 | 2022-05-04 | Genesee | Michigan | 26049 | 102660 | 1715 |
2471526 | 2471526 | 2022-05-04 | Gladwin | Michigan | 26051 | 5608 | 114 |
2471527 | 2471527 | 2022-05-04 | Gogebic | Michigan | 26053 | 3278 | 69 |
2471528 | 2471528 | 2022-05-04 | Grand Traverse | Michigan | 26055 | 17636 | 234 |
2471529 | 2471529 | 2022-05-04 | Gratiot | Michigan | 26057 | 13780 | 192 |
2471530 | 2471530 | 2022-05-04 | Hillsdale | Michigan | 26059 | 10417 | 204 |
2471531 | 2471531 | 2022-05-04 | Houghton | Michigan | 26061 | 7922 | 92 |
2471532 | 2471532 | 2022-05-04 | Huron | Michigan | 26063 | 8078 | 145 |
2471533 | 2471533 | 2022-05-04 | Ingham | Michigan | 26065 | 65479 | 767 |
2471534 | 2471534 | 2022-05-04 | Ionia | Michigan | 26067 | 19720 | 181 |
2471535 | 2471535 | 2022-05-04 | Iosco | Michigan | 26069 | 4829 | 143 |
2471536 | 2471536 | 2022-05-04 | Iron | Michigan | 26071 | 2659 | 87 |
2471537 | 2471537 | 2022-05-04 | Isabella | Michigan | 26073 | 15730 | 210 |
2471538 | 2471538 | 2022-05-04 | Jackson | Michigan | 26075 | 45207 | 588 |
2471539 | 2471539 | 2022-05-04 | Kalamazoo | Michigan | 26077 | 60229 | 673 |
2471540 | 2471540 | 2022-05-04 | Kalkaska | Michigan | 26079 | 3582 | 61 |
2471541 | 2471541 | 2022-05-04 | Kent | Michigan | 26081 | 168797 | 1532 |
2471542 | 2471542 | 2022-05-04 | Keweenaw | Michigan | 26083 | 520 | 14 |
2471543 | 2471543 | 2022-05-04 | Lake | Michigan | 26085 | 1870 | 37 |
2471544 | 2471544 | 2022-05-04 | Lapeer | Michigan | 26087 | 20983 | 427 |
2471545 | 2471545 | 2022-05-04 | Leelanau | Michigan | 26089 | 3654 | 55 |
2471546 | 2471546 | 2022-05-04 | Lenawee | Michigan | 26091 | 26296 | 330 |
2471547 | 2471547 | 2022-05-04 | Livingston | Michigan | 26093 | 47139 | 450 |
2471548 | 2471548 | 2022-05-04 | Luce | Michigan | 26095 | 2298 | 14 |
2471549 | 2471549 | 2022-05-04 | Mackinac | Michigan | 26097 | 2439 | 31 |
2471550 | 2471550 | 2022-05-04 | Macomb | Michigan | 26099 | 235909 | 3963 |
2471551 | 2471551 | 2022-05-04 | Manistee | Michigan | 26101 | 4500 | 90 |
2471552 | 2471552 | 2022-05-04 | Marquette | Michigan | 26103 | 16088 | 131 |
2471553 | 2471553 | 2022-05-04 | Mason | Michigan | 26105 | 6823 | 96 |
2471554 | 2471554 | 2022-05-04 | Mecosta | Michigan | 26107 | 8730 | 107 |
2471555 | 2471555 | 2022-05-04 | Menominee | Michigan | 26109 | 5656 | 70 |
2471556 | 2471556 | 2022-05-04 | Midland | Michigan | 26111 | 19254 | 225 |
2471557 | 2471557 | 2022-05-04 | Missaukee | Michigan | 26113 | 2922 | 60 |
2471558 | 2471558 | 2022-05-04 | Monroe | Michigan | 26115 | 38646 | 475 |
2471559 | 2471559 | 2022-05-04 | Montcalm | Michigan | 26117 | 17268 | 216 |
2471560 | 2471560 | 2022-05-04 | Montmorency | Michigan | 26119 | 1745 | 48 |
2471561 | 2471561 | 2022-05-04 | Muskegon | Michigan | 26121 | 42236 | 649 |
2471562 | 2471562 | 2022-05-04 | Newaygo | Michigan | 26123 | 11553 | 158 |
2471563 | 2471563 | 2022-05-04 | Oakland | Michigan | 26125 | 296058 | 3845 |
2471564 | 2471564 | 2022-05-04 | Oceana | Michigan | 26127 | 6384 | 90 |
2471565 | 2471565 | 2022-05-04 | Ogemaw | Michigan | 26129 | 4343 | 106 |
2471566 | 2471566 | 2022-05-04 | Ontonagon | Michigan | 26131 | 1000 | 38 |
2471567 | 2471567 | 2022-05-04 | Osceola | Michigan | 26133 | 5035 | 80 |
2471568 | 2471568 | 2022-05-04 | Oscoda | Michigan | 26135 | 1444 | 55 |
2471569 | 2471569 | 2022-05-04 | Otsego | Michigan | 26137 | 5693 | 100 |
2471570 | 2471570 | 2022-05-04 | Ottawa | Michigan | 26139 | 75716 | 783 |
2471571 | 2471571 | 2022-05-04 | Presque Isle | Michigan | 26141 | 2072 | 58 |
2471572 | 2471572 | 2022-05-04 | Roscommon | Michigan | 26143 | 4656 | 114 |
2471573 | 2471573 | 2022-05-04 | Saginaw | Michigan | 26145 | 50871 | 954 |
2471574 | 2471574 | 2022-05-04 | Sanilac | Michigan | 26151 | 8776 | 193 |
2471575 | 2471575 | 2022-05-04 | Schoolcraft | Michigan | 26153 | 1754 | 16 |
2471576 | 2471576 | 2022-05-04 | Shiawassee | Michigan | 26155 | 17988 | 231 |
2471577 | 2471577 | 2022-05-04 | St. Clair | Michigan | 26147 | 41252 | 833 |
2471578 | 2471578 | 2022-05-04 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2471579 | 2471579 | 2022-05-04 | Tuscola | Michigan | 26157 | 13270 | 277 |
2471580 | 2471580 | 2022-05-04 | Unknown | Michigan | 12342 | 39 | |
2471581 | 2471581 | 2022-05-04 | Van Buren | Michigan | 26159 | 17239 | 273 |
2471582 | 2471582 | 2022-05-04 | Washtenaw | Michigan | 26161 | 80682 | 520 |
2471583 | 2471583 | 2022-05-04 | Wayne | Michigan | 26163 | 410946 | 7955 |
2471584 | 2471584 | 2022-05-04 | Wexford | Michigan | 26165 | 7125 | 107 |
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);