ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-10-05" 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 |
---|---|---|---|---|---|---|---|
600455 | 600455 | 2020-10-05 | Alcona | Michigan | 26001 | 49 | 2 |
600456 | 600456 | 2020-10-05 | Alger | Michigan | 26003 | 27 | 0 |
600457 | 600457 | 2020-10-05 | Allegan | Michigan | 26005 | 834 | 7 |
600458 | 600458 | 2020-10-05 | Alpena | Michigan | 26007 | 146 | 14 |
600459 | 600459 | 2020-10-05 | Antrim | Michigan | 26009 | 71 | 0 |
600460 | 600460 | 2020-10-05 | Arenac | Michigan | 26011 | 76 | 3 |
600461 | 600461 | 2020-10-05 | Baraga | Michigan | 26013 | 46 | 3 |
600462 | 600462 | 2020-10-05 | Barry | Michigan | 26015 | 354 | 4 |
600463 | 600463 | 2020-10-05 | Bay | Michigan | 26017 | 1062 | 52 |
600464 | 600464 | 2020-10-05 | Benzie | Michigan | 26019 | 85 | 2 |
600465 | 600465 | 2020-10-05 | Berrien | Michigan | 26021 | 2054 | 75 |
600466 | 600466 | 2020-10-05 | Branch | Michigan | 26023 | 1479 | 29 |
600467 | 600467 | 2020-10-05 | Calhoun | Michigan | 26025 | 1622 | 49 |
600468 | 600468 | 2020-10-05 | Cass | Michigan | 26027 | 647 | 17 |
600469 | 600469 | 2020-10-05 | Charlevoix | Michigan | 26029 | 118 | 4 |
600470 | 600470 | 2020-10-05 | Cheboygan | Michigan | 26031 | 97 | 3 |
600471 | 600471 | 2020-10-05 | Chippewa | Michigan | 26033 | 85 | 0 |
600472 | 600472 | 2020-10-05 | Clare | Michigan | 26035 | 123 | 4 |
600473 | 600473 | 2020-10-05 | Clinton | Michigan | 26037 | 746 | 14 |
600474 | 600474 | 2020-10-05 | Crawford | Michigan | 26039 | 127 | 5 |
600475 | 600475 | 2020-10-05 | Delta | Michigan | 26041 | 709 | 10 |
600476 | 600476 | 2020-10-05 | Dickinson | Michigan | 26043 | 215 | 2 |
600477 | 600477 | 2020-10-05 | Eaton | Michigan | 26045 | 740 | 10 |
600478 | 600478 | 2020-10-05 | Emmet | Michigan | 26047 | 173 | 4 |
600479 | 600479 | 2020-10-05 | Genesee | Michigan | 26049 | 4968 | 309 |
600480 | 600480 | 2020-10-05 | Gladwin | Michigan | 26051 | 112 | 2 |
600481 | 600481 | 2020-10-05 | Gogebic | Michigan | 26053 | 179 | 2 |
600482 | 600482 | 2020-10-05 | Grand Traverse | Michigan | 26055 | 532 | 9 |
600483 | 600483 | 2020-10-05 | Gratiot | Michigan | 26057 | 314 | 16 |
600484 | 600484 | 2020-10-05 | Hillsdale | Michigan | 26059 | 370 | 27 |
600485 | 600485 | 2020-10-05 | Houghton | Michigan | 26061 | 672 | 3 |
600486 | 600486 | 2020-10-05 | Huron | Michigan | 26063 | 231 | 5 |
600487 | 600487 | 2020-10-05 | Ingham | Michigan | 26065 | 3753 | 51 |
600488 | 600488 | 2020-10-05 | Ionia | Michigan | 26067 | 562 | 7 |
600489 | 600489 | 2020-10-05 | Iosco | Michigan | 26069 | 238 | 13 |
600490 | 600490 | 2020-10-05 | Iron | Michigan | 26071 | 255 | 8 |
600491 | 600491 | 2020-10-05 | Isabella | Michigan | 26073 | 753 | 15 |
600492 | 600492 | 2020-10-05 | Jackson | Michigan | 26075 | 2928 | 70 |
600493 | 600493 | 2020-10-05 | Kalamazoo | Michigan | 26077 | 3262 | 96 |
600494 | 600494 | 2020-10-05 | Kalkaska | Michigan | 26079 | 93 | 4 |
600495 | 600495 | 2020-10-05 | Kent | Michigan | 26081 | 10683 | 175 |
600496 | 600496 | 2020-10-05 | Keweenaw | Michigan | 26083 | 14 | 0 |
600497 | 600497 | 2020-10-05 | Lake | Michigan | 26085 | 38 | 0 |
600498 | 600498 | 2020-10-05 | Lapeer | Michigan | 26087 | 961 | 43 |
600499 | 600499 | 2020-10-05 | Leelanau | Michigan | 26089 | 115 | 1 |
600500 | 600500 | 2020-10-05 | Lenawee | Michigan | 26091 | 1604 | 22 |
600501 | 600501 | 2020-10-05 | Livingston | Michigan | 26093 | 1532 | 32 |
600502 | 600502 | 2020-10-05 | Luce | Michigan | 26095 | 239 | 0 |
600503 | 600503 | 2020-10-05 | Mackinac | Michigan | 26097 | 75 | 0 |
600504 | 600504 | 2020-10-05 | Macomb | Michigan | 26099 | 15511 | 1037 |
600505 | 600505 | 2020-10-05 | Manistee | Michigan | 26101 | 101 | 3 |
600506 | 600506 | 2020-10-05 | Marquette | Michigan | 26103 | 446 | 12 |
600507 | 600507 | 2020-10-05 | Mason | Michigan | 26105 | 141 | 0 |
600508 | 600508 | 2020-10-05 | Mecosta | Michigan | 26107 | 248 | 3 |
600509 | 600509 | 2020-10-05 | Menominee | Michigan | 26109 | 471 | 3 |
600510 | 600510 | 2020-10-05 | Midland | Michigan | 26111 | 660 | 11 |
600511 | 600511 | 2020-10-05 | Missaukee | Michigan | 26113 | 68 | 1 |
600512 | 600512 | 2020-10-05 | Monroe | Michigan | 26115 | 1595 | 29 |
600513 | 600513 | 2020-10-05 | Montcalm | Michigan | 26117 | 374 | 7 |
600514 | 600514 | 2020-10-05 | Montmorency | Michigan | 26119 | 17 | 0 |
600515 | 600515 | 2020-10-05 | Muskegon | Michigan | 26121 | 2532 | 74 |
600516 | 600516 | 2020-10-05 | Newaygo | Michigan | 26123 | 422 | 2 |
600517 | 600517 | 2020-10-05 | Oakland | Michigan | 26125 | 21241 | 1207 |
600518 | 600518 | 2020-10-05 | Oceana | Michigan | 26127 | 536 | 6 |
600519 | 600519 | 2020-10-05 | Ogemaw | Michigan | 26129 | 72 | 5 |
600520 | 600520 | 2020-10-05 | Ontonagon | Michigan | 26131 | 46 | 0 |
600521 | 600521 | 2020-10-05 | Osceola | Michigan | 26133 | 103 | 0 |
600522 | 600522 | 2020-10-05 | Oscoda | Michigan | 26135 | 32 | 1 |
600523 | 600523 | 2020-10-05 | Otsego | Michigan | 26137 | 200 | 12 |
600524 | 600524 | 2020-10-05 | Ottawa | Michigan | 26139 | 3710 | 67 |
600525 | 600525 | 2020-10-05 | Presque Isle | Michigan | 26141 | 27 | 1 |
600526 | 600526 | 2020-10-05 | Roscommon | Michigan | 26143 | 105 | 4 |
600527 | 600527 | 2020-10-05 | Saginaw | Michigan | 26145 | 3098 | 141 |
600528 | 600528 | 2020-10-05 | Sanilac | Michigan | 26151 | 153 | 7 |
600529 | 600529 | 2020-10-05 | Schoolcraft | Michigan | 26153 | 37 | 0 |
600530 | 600530 | 2020-10-05 | Shiawassee | Michigan | 26155 | 553 | 32 |
600531 | 600531 | 2020-10-05 | St. Clair | Michigan | 26147 | 1081 | 57 |
600532 | 600532 | 2020-10-05 | St. Joseph | Michigan | 26149 | 847 | 11 |
600533 | 600533 | 2020-10-05 | Tuscola | Michigan | 26157 | 530 | 31 |
600534 | 600534 | 2020-10-05 | Unknown | Michigan | 180 | 6 | |
600535 | 600535 | 2020-10-05 | Van Buren | Michigan | 26159 | 805 | 18 |
600536 | 600536 | 2020-10-05 | Washtenaw | Michigan | 26161 | 4429 | 126 |
600537 | 600537 | 2020-10-05 | Wayne | Michigan | 26163 | 36078 | 3000 |
600538 | 600538 | 2020-10-05 | Wexford | Michigan | 26165 | 140 | 4 |
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);