ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-07-21" 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 |
---|---|---|---|---|---|---|---|
1538481 | 1538481 | 2021-07-21 | Alcona | Michigan | 26001 | 742 | 33 |
1538482 | 1538482 | 2021-07-21 | Alger | Michigan | 26003 | 670 | 7 |
1538483 | 1538483 | 2021-07-21 | Allegan | Michigan | 26005 | 11247 | 162 |
1538484 | 1538484 | 2021-07-21 | Alpena | Michigan | 26007 | 2278 | 64 |
1538485 | 1538485 | 2021-07-21 | Antrim | Michigan | 26009 | 1643 | 30 |
1538486 | 1538486 | 2021-07-21 | Arenac | Michigan | 26011 | 1219 | 29 |
1538487 | 1538487 | 2021-07-21 | Baraga | Michigan | 26013 | 994 | 40 |
1538488 | 1538488 | 2021-07-21 | Barry | Michigan | 26015 | 5986 | 70 |
1538489 | 1538489 | 2021-07-21 | Bay | Michigan | 26017 | 11298 | 354 |
1538490 | 1538490 | 2021-07-21 | Benzie | Michigan | 26019 | 1285 | 36 |
1538491 | 1538491 | 2021-07-21 | Berrien | Michigan | 26021 | 15667 | 299 |
1538492 | 1538492 | 2021-07-21 | Branch | Michigan | 26023 | 5814 | 121 |
1538493 | 1538493 | 2021-07-21 | Calhoun | Michigan | 26025 | 14666 | 320 |
1538494 | 1538494 | 2021-07-21 | Cass | Michigan | 26027 | 5522 | 78 |
1538495 | 1538495 | 2021-07-21 | Charlevoix | Michigan | 26029 | 1692 | 22 |
1538496 | 1538496 | 2021-07-21 | Cheboygan | Michigan | 26031 | 1938 | 47 |
1538497 | 1538497 | 2021-07-21 | Chippewa | Michigan | 26033 | 5662 | 50 |
1538498 | 1538498 | 2021-07-21 | Clare | Michigan | 26035 | 2492 | 85 |
1538499 | 1538499 | 2021-07-21 | Clinton | Michigan | 26037 | 7680 | 95 |
1538500 | 1538500 | 2021-07-21 | Crawford | Michigan | 26039 | 996 | 14 |
1538501 | 1538501 | 2021-07-21 | Delta | Michigan | 26041 | 4063 | 95 |
1538502 | 1538502 | 2021-07-21 | Dickinson | Michigan | 26043 | 2766 | 74 |
1538503 | 1538503 | 2021-07-21 | Eaton | Michigan | 26045 | 10198 | 212 |
1538504 | 1538504 | 2021-07-21 | Emmet | Michigan | 26047 | 2394 | 43 |
1538505 | 1538505 | 2021-07-21 | Genesee | Michigan | 26049 | 41901 | 976 |
1538506 | 1538506 | 2021-07-21 | Gladwin | Michigan | 26051 | 2311 | 61 |
1538507 | 1538507 | 2021-07-21 | Gogebic | Michigan | 26053 | 1444 | 53 |
1538508 | 1538508 | 2021-07-21 | Grand Traverse | Michigan | 26055 | 6524 | 100 |
1538509 | 1538509 | 2021-07-21 | Gratiot | Michigan | 26057 | 6977 | 125 |
1538510 | 1538510 | 2021-07-21 | Hillsdale | Michigan | 26059 | 4415 | 94 |
1538511 | 1538511 | 2021-07-21 | Houghton | Michigan | 26061 | 3145 | 43 |
1538512 | 1538512 | 2021-07-21 | Huron | Michigan | 26063 | 4098 | 82 |
1538513 | 1538513 | 2021-07-21 | Ingham | Michigan | 26065 | 25019 | 394 |
1538514 | 1538514 | 2021-07-21 | Ionia | Michigan | 26067 | 9378 | 85 |
1538515 | 1538515 | 2021-07-21 | Iosco | Michigan | 26069 | 2010 | 75 |
1538516 | 1538516 | 2021-07-21 | Iron | Michigan | 26071 | 1067 | 53 |
1538517 | 1538517 | 2021-07-21 | Isabella | Michigan | 26073 | 6352 | 100 |
1538518 | 1538518 | 2021-07-21 | Jackson | Michigan | 26075 | 21145 | 324 |
1538519 | 1538519 | 2021-07-21 | Kalamazoo | Michigan | 26077 | 23302 | 403 |
1538520 | 1538520 | 2021-07-21 | Kalkaska | Michigan | 26079 | 1151 | 27 |
1538521 | 1538521 | 2021-07-21 | Kent | Michigan | 26081 | 74098 | 867 |
1538522 | 1538522 | 2021-07-21 | Keweenaw | Michigan | 26083 | 174 | 2 |
1538523 | 1538523 | 2021-07-21 | Lake | Michigan | 26085 | 640 | 16 |
1538524 | 1538524 | 2021-07-21 | Lapeer | Michigan | 26087 | 9792 | 215 |
1538525 | 1538525 | 2021-07-21 | Leelanau | Michigan | 26089 | 1249 | 20 |
1538526 | 1538526 | 2021-07-21 | Lenawee | Michigan | 26091 | 10889 | 178 |
1538527 | 1538527 | 2021-07-21 | Livingston | Michigan | 26093 | 16887 | 198 |
1538528 | 1538528 | 2021-07-21 | Luce | Michigan | 26095 | 1338 | 6 |
1538529 | 1538529 | 2021-07-21 | Mackinac | Michigan | 26097 | 718 | 3 |
1538530 | 1538530 | 2021-07-21 | Macomb | Michigan | 26099 | 101015 | 2507 |
1538531 | 1538531 | 2021-07-21 | Manistee | Michigan | 26101 | 1983 | 25 |
1538532 | 1538532 | 2021-07-21 | Marquette | Michigan | 26103 | 5947 | 65 |
1538533 | 1538533 | 2021-07-21 | Mason | Michigan | 26105 | 2149 | 37 |
1538534 | 1538534 | 2021-07-21 | Mecosta | Michigan | 26107 | 3226 | 37 |
1538535 | 1538535 | 2021-07-21 | Menominee | Michigan | 26109 | 2133 | 44 |
1538536 | 1538536 | 2021-07-21 | Midland | Michigan | 26111 | 7620 | 95 |
1538537 | 1538537 | 2021-07-21 | Missaukee | Michigan | 26113 | 1520 | 27 |
1538538 | 1538538 | 2021-07-21 | Monroe | Michigan | 26115 | 15505 | 266 |
1538539 | 1538539 | 2021-07-21 | Montcalm | Michigan | 26117 | 8212 | 120 |
1538540 | 1538540 | 2021-07-21 | Montmorency | Michigan | 26119 | 619 | 20 |
1538541 | 1538541 | 2021-07-21 | Muskegon | Michigan | 26121 | 18513 | 382 |
1538542 | 1538542 | 2021-07-21 | Newaygo | Michigan | 26123 | 4918 | 69 |
1538543 | 1538543 | 2021-07-21 | Oakland | Michigan | 26125 | 119379 | 2467 |
1538544 | 1538544 | 2021-07-21 | Oceana | Michigan | 26127 | 2783 | 60 |
1538545 | 1538545 | 2021-07-21 | Ogemaw | Michigan | 26129 | 1751 | 43 |
1538546 | 1538546 | 2021-07-21 | Ontonagon | Michigan | 26131 | 484 | 22 |
1538547 | 1538547 | 2021-07-21 | Osceola | Michigan | 26133 | 1970 | 31 |
1538548 | 1538548 | 2021-07-21 | Oscoda | Michigan | 26135 | 694 | 31 |
1538549 | 1538549 | 2021-07-21 | Otsego | Michigan | 26137 | 2370 | 41 |
1538550 | 1538550 | 2021-07-21 | Ottawa | Michigan | 26139 | 33049 | 442 |
1538551 | 1538551 | 2021-07-21 | Presque Isle | Michigan | 26141 | 1058 | 34 |
1538552 | 1538552 | 2021-07-21 | Roscommon | Michigan | 26143 | 1905 | 55 |
1538553 | 1538553 | 2021-07-21 | Saginaw | Michigan | 26145 | 22625 | 639 |
1538554 | 1538554 | 2021-07-21 | Sanilac | Michigan | 26151 | 4265 | 125 |
1538555 | 1538555 | 2021-07-21 | Schoolcraft | Michigan | 26153 | 439 | 5 |
1538556 | 1538556 | 2021-07-21 | Shiawassee | Michigan | 26155 | 6459 | 110 |
1538557 | 1538557 | 2021-07-21 | St. Clair | Michigan | 26147 | 18569 | 451 |
1538558 | 1538558 | 2021-07-21 | St. Joseph | Michigan | 26149 | 6282 | 101 |
1538559 | 1538559 | 2021-07-21 | Tuscola | Michigan | 26157 | 5689 | 174 |
1538560 | 1538560 | 2021-07-21 | Unknown | Michigan | 756 | 16 | |
1538561 | 1538561 | 2021-07-21 | Van Buren | Michigan | 26159 | 7185 | 133 |
1538562 | 1538562 | 2021-07-21 | Washtenaw | Michigan | 26161 | 27259 | 312 |
1538563 | 1538563 | 2021-07-21 | Wayne | Michigan | 26163 | 167006 | 5196 |
1538564 | 1538564 | 2021-07-21 | Wexford | Michigan | 26165 | 2906 | 48 |
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);