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-01-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 |
---|---|---|---|---|---|---|---|
2084362 | 2084362 | 2022-01-05 | Alcona | Michigan | 26001 | 1444 | 59 |
2084363 | 2084363 | 2022-01-05 | Alger | Michigan | 26003 | 1308 | 11 |
2084364 | 2084364 | 2022-01-05 | Allegan | Michigan | 26005 | 21069 | 287 |
2084365 | 2084365 | 2022-01-05 | Alpena | Michigan | 26007 | 4617 | 117 |
2084366 | 2084366 | 2022-01-05 | Antrim | Michigan | 26009 | 3298 | 51 |
2084367 | 2084367 | 2022-01-05 | Arenac | Michigan | 26011 | 2414 | 53 |
2084368 | 2084368 | 2022-01-05 | Baraga | Michigan | 26013 | 1709 | 49 |
2084369 | 2084369 | 2022-01-05 | Barry | Michigan | 26015 | 11099 | 133 |
2084370 | 2084370 | 2022-01-05 | Bay | Michigan | 26017 | 19818 | 485 |
2084371 | 2084371 | 2022-01-05 | Benzie | Michigan | 26019 | 2509 | 56 |
2084372 | 2084372 | 2022-01-05 | Berrien | Michigan | 26021 | 26747 | 415 |
2084373 | 2084373 | 2022-01-05 | Branch | Michigan | 26023 | 9590 | 168 |
2084374 | 2084374 | 2022-01-05 | Calhoun | Michigan | 26025 | 25703 | 478 |
2084375 | 2084375 | 2022-01-05 | Cass | Michigan | 26027 | 9261 | 114 |
2084376 | 2084376 | 2022-01-05 | Charlevoix | Michigan | 26029 | 3646 | 53 |
2084377 | 2084377 | 2022-01-05 | Cheboygan | Michigan | 26031 | 3783 | 84 |
2084378 | 2084378 | 2022-01-05 | Chippewa | Michigan | 26033 | 8585 | 87 |
2084379 | 2084379 | 2022-01-05 | Clare | Michigan | 26035 | 5267 | 137 |
2084380 | 2084380 | 2022-01-05 | Clinton | Michigan | 26037 | 14986 | 166 |
2084381 | 2084381 | 2022-01-05 | Crawford | Michigan | 26039 | 1978 | 22 |
2084382 | 2084382 | 2022-01-05 | Delta | Michigan | 26041 | 7369 | 137 |
2084383 | 2084383 | 2022-01-05 | Dickinson | Michigan | 26043 | 5318 | 93 |
2084384 | 2084384 | 2022-01-05 | Eaton | Michigan | 26045 | 19283 | 331 |
2084385 | 2084385 | 2022-01-05 | Emmet | Michigan | 26047 | 4755 | 61 |
2084386 | 2084386 | 2022-01-05 | Genesee | Michigan | 26049 | 75960 | 1385 |
2084387 | 2084387 | 2022-01-05 | Gladwin | Michigan | 26051 | 4292 | 97 |
2084388 | 2084388 | 2022-01-05 | Gogebic | Michigan | 26053 | 2392 | 63 |
2084389 | 2084389 | 2022-01-05 | Grand Traverse | Michigan | 26055 | 12702 | 185 |
2084390 | 2084390 | 2022-01-05 | Gratiot | Michigan | 26057 | 11107 | 166 |
2084391 | 2084391 | 2022-01-05 | Hillsdale | Michigan | 26059 | 8351 | 174 |
2084392 | 2084392 | 2022-01-05 | Houghton | Michigan | 26061 | 5811 | 74 |
2084393 | 2084393 | 2022-01-05 | Huron | Michigan | 26063 | 6473 | 126 |
2084394 | 2084394 | 2022-01-05 | Ingham | Michigan | 26065 | 44946 | 599 |
2084395 | 2084395 | 2022-01-05 | Ionia | Michigan | 26067 | 15540 | 150 |
2084396 | 2084396 | 2022-01-05 | Iosco | Michigan | 26069 | 3933 | 114 |
2084397 | 2084397 | 2022-01-05 | Iron | Michigan | 26071 | 1944 | 72 |
2084398 | 2084398 | 2022-01-05 | Isabella | Michigan | 26073 | 11816 | 167 |
2084399 | 2084399 | 2022-01-05 | Jackson | Michigan | 26075 | 35239 | 478 |
2084400 | 2084400 | 2022-01-05 | Kalamazoo | Michigan | 26077 | 43136 | 555 |
2084401 | 2084401 | 2022-01-05 | Kalkaska | Michigan | 26079 | 2616 | 48 |
2084402 | 2084402 | 2022-01-05 | Kent | Michigan | 26081 | 129607 | 1281 |
2084403 | 2084403 | 2022-01-05 | Keweenaw | Michigan | 26083 | 405 | 11 |
2084404 | 2084404 | 2022-01-05 | Lake | Michigan | 26085 | 1436 | 31 |
2084405 | 2084405 | 2022-01-05 | Lapeer | Michigan | 26087 | 16657 | 350 |
2084406 | 2084406 | 2022-01-05 | Leelanau | Michigan | 26089 | 2622 | 42 |
2084407 | 2084407 | 2022-01-05 | Lenawee | Michigan | 26091 | 20023 | 268 |
2084408 | 2084408 | 2022-01-05 | Livingston | Michigan | 26093 | 35024 | 365 |
2084409 | 2084409 | 2022-01-05 | Luce | Michigan | 26095 | 1938 | 6 |
2084410 | 2084410 | 2022-01-05 | Mackinac | Michigan | 26097 | 1766 | 22 |
2084411 | 2084411 | 2022-01-05 | Macomb | Michigan | 26099 | 176857 | 3282 |
2084412 | 2084412 | 2022-01-05 | Manistee | Michigan | 26101 | 3387 | 64 |
2084413 | 2084413 | 2022-01-05 | Marquette | Michigan | 26103 | 10692 | 98 |
2084414 | 2084414 | 2022-01-05 | Mason | Michigan | 26105 | 4899 | 69 |
2084415 | 2084415 | 2022-01-05 | Mecosta | Michigan | 26107 | 6588 | 88 |
2084416 | 2084416 | 2022-01-05 | Menominee | Michigan | 26109 | 4327 | 62 |
2084417 | 2084417 | 2022-01-05 | Midland | Michigan | 26111 | 14091 | 187 |
2084418 | 2084418 | 2022-01-05 | Missaukee | Michigan | 26113 | 2277 | 52 |
2084419 | 2084419 | 2022-01-05 | Monroe | Michigan | 26115 | 28685 | 377 |
2084420 | 2084420 | 2022-01-05 | Montcalm | Michigan | 26117 | 14022 | 175 |
2084421 | 2084421 | 2022-01-05 | Montmorency | Michigan | 26119 | 1374 | 41 |
2084422 | 2084422 | 2022-01-05 | Muskegon | Michigan | 26121 | 33011 | 536 |
2084423 | 2084423 | 2022-01-05 | Newaygo | Michigan | 26123 | 9080 | 130 |
2084424 | 2084424 | 2022-01-05 | Oakland | Michigan | 26125 | 213730 | 3165 |
2084425 | 2084425 | 2022-01-05 | Oceana | Michigan | 26127 | 5025 | 84 |
2084426 | 2084426 | 2022-01-05 | Ogemaw | Michigan | 26129 | 3432 | 83 |
2084427 | 2084427 | 2022-01-05 | Ontonagon | Michigan | 26131 | 768 | 28 |
2084428 | 2084428 | 2022-01-05 | Osceola | Michigan | 26133 | 3973 | 65 |
2084429 | 2084429 | 2022-01-05 | Oscoda | Michigan | 26135 | 1193 | 51 |
2084430 | 2084430 | 2022-01-05 | Otsego | Michigan | 26137 | 4408 | 82 |
2084431 | 2084431 | 2022-01-05 | Ottawa | Michigan | 26139 | 57600 | 665 |
2084432 | 2084432 | 2022-01-05 | Presque Isle | Michigan | 26141 | 1780 | 52 |
2084433 | 2084433 | 2022-01-05 | Roscommon | Michigan | 26143 | 3709 | 106 |
2084434 | 2084434 | 2022-01-05 | Saginaw | Michigan | 26145 | 38409 | 818 |
2084435 | 2084435 | 2022-01-05 | Sanilac | Michigan | 26151 | 7021 | 168 |
2084436 | 2084436 | 2022-01-05 | Schoolcraft | Michigan | 26153 | 1257 | 9 |
2084437 | 2084437 | 2022-01-05 | Shiawassee | Michigan | 26155 | 13237 | 192 |
2084438 | 2084438 | 2022-01-05 | St. Clair | Michigan | 26147 | 32046 | 686 |
2084439 | 2084439 | 2022-01-05 | St. Joseph | Michigan | 26149 | 11098 | 164 |
2084440 | 2084440 | 2022-01-05 | Tuscola | Michigan | 26157 | 10279 | 243 |
2084441 | 2084441 | 2022-01-05 | Unknown | Michigan | 3216 | 23 | |
2084442 | 2084442 | 2022-01-05 | Van Buren | Michigan | 26159 | 13244 | 217 |
2084443 | 2084443 | 2022-01-05 | Washtenaw | Michigan | 26161 | 51119 | 418 |
2084444 | 2084444 | 2022-01-05 | Wayne | Michigan | 26163 | 301761 | 6581 |
2084445 | 2084445 | 2022-01-05 | Wexford | Michigan | 26165 | 5198 | 87 |
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);