ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-08-24" 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 |
---|---|---|---|---|---|---|---|
464522 | 464522 | 2020-08-24 | Alcona | Michigan | 26001 | 30 | 2 |
464523 | 464523 | 2020-08-24 | Alger | Michigan | 26003 | 17 | 0 |
464524 | 464524 | 2020-08-24 | Allegan | Michigan | 26005 | 600 | 6 |
464525 | 464525 | 2020-08-24 | Alpena | Michigan | 26007 | 131 | 14 |
464526 | 464526 | 2020-08-24 | Antrim | Michigan | 26009 | 52 | 0 |
464527 | 464527 | 2020-08-24 | Arenac | Michigan | 26011 | 51 | 3 |
464528 | 464528 | 2020-08-24 | Baraga | Michigan | 26013 | 8 | 0 |
464529 | 464529 | 2020-08-24 | Barry | Michigan | 26015 | 204 | 2 |
464530 | 464530 | 2020-08-24 | Bay | Michigan | 26017 | 780 | 39 |
464531 | 464531 | 2020-08-24 | Benzie | Michigan | 26019 | 42 | 1 |
464532 | 464532 | 2020-08-24 | Berrien | Michigan | 26021 | 1614 | 69 |
464533 | 464533 | 2020-08-24 | Branch | Michigan | 26023 | 1221 | 26 |
464534 | 464534 | 2020-08-24 | Calhoun | Michigan | 26025 | 886 | 43 |
464535 | 464535 | 2020-08-24 | Cass | Michigan | 26027 | 387 | 15 |
464536 | 464536 | 2020-08-24 | Charlevoix | Michigan | 26029 | 70 | 2 |
464537 | 464537 | 2020-08-24 | Cheboygan | Michigan | 26031 | 65 | 2 |
464538 | 464538 | 2020-08-24 | Chippewa | Michigan | 26033 | 49 | 0 |
464539 | 464539 | 2020-08-24 | Clare | Michigan | 26035 | 94 | 3 |
464540 | 464540 | 2020-08-24 | Clinton | Michigan | 26037 | 456 | 13 |
464541 | 464541 | 2020-08-24 | Crawford | Michigan | 26039 | 113 | 5 |
464542 | 464542 | 2020-08-24 | Delta | Michigan | 26041 | 133 | 3 |
464543 | 464543 | 2020-08-24 | Dickinson | Michigan | 26043 | 61 | 2 |
464544 | 464544 | 2020-08-24 | Eaton | Michigan | 26045 | 492 | 8 |
464545 | 464545 | 2020-08-24 | Emmet | Michigan | 26047 | 108 | 2 |
464546 | 464546 | 2020-08-24 | Genesee | Michigan | 26049 | 3869 | 303 |
464547 | 464547 | 2020-08-24 | Gladwin | Michigan | 26051 | 74 | 2 |
464548 | 464548 | 2020-08-24 | Gogebic | Michigan | 26053 | 143 | 1 |
464549 | 464549 | 2020-08-24 | Grand Traverse | Michigan | 26055 | 289 | 5 |
464550 | 464550 | 2020-08-24 | Gratiot | Michigan | 26057 | 183 | 15 |
464551 | 464551 | 2020-08-24 | Hillsdale | Michigan | 26059 | 294 | 25 |
464552 | 464552 | 2020-08-24 | Houghton | Michigan | 26061 | 59 | 0 |
464553 | 464553 | 2020-08-24 | Huron | Michigan | 26063 | 194 | 4 |
464554 | 464554 | 2020-08-24 | Ingham | Michigan | 26065 | 1705 | 36 |
464555 | 464555 | 2020-08-24 | Ionia | Michigan | 26067 | 291 | 7 |
464556 | 464556 | 2020-08-24 | Iosco | Michigan | 26069 | 140 | 12 |
464557 | 464557 | 2020-08-24 | Iron | Michigan | 26071 | 25 | 1 |
464558 | 464558 | 2020-08-24 | Isabella | Michigan | 26073 | 337 | 9 |
464559 | 464559 | 2020-08-24 | Jackson | Michigan | 26075 | 2498 | 59 |
464560 | 464560 | 2020-08-24 | Kalamazoo | Michigan | 26077 | 1844 | 86 |
464561 | 464561 | 2020-08-24 | Kalkaska | Michigan | 26079 | 62 | 4 |
464562 | 464562 | 2020-08-24 | Kent | Michigan | 26081 | 8119 | 160 |
464563 | 464563 | 2020-08-24 | Keweenaw | Michigan | 26083 | 3 | 0 |
464564 | 464564 | 2020-08-24 | Lake | Michigan | 26085 | 29 | 0 |
464565 | 464565 | 2020-08-24 | Lapeer | Michigan | 26087 | 828 | 42 |
464566 | 464566 | 2020-08-24 | Leelanau | Michigan | 26089 | 84 | 0 |
464567 | 464567 | 2020-08-24 | Lenawee | Michigan | 26091 | 1236 | 17 |
464568 | 464568 | 2020-08-24 | Livingston | Michigan | 26093 | 1069 | 30 |
464569 | 464569 | 2020-08-24 | Luce | Michigan | 26095 | 33 | 0 |
464570 | 464570 | 2020-08-24 | Mackinac | Michigan | 26097 | 33 | 0 |
464571 | 464571 | 2020-08-24 | Macomb | Michigan | 26099 | 12396 | 963 |
464572 | 464572 | 2020-08-24 | Manistee | Michigan | 26101 | 58 | 1 |
464573 | 464573 | 2020-08-24 | Marquette | Michigan | 26103 | 233 | 11 |
464574 | 464574 | 2020-08-24 | Mason | Michigan | 26105 | 114 | 0 |
464575 | 464575 | 2020-08-24 | Mecosta | Michigan | 26107 | 80 | 2 |
464576 | 464576 | 2020-08-24 | Menominee | Michigan | 26109 | 229 | 0 |
464577 | 464577 | 2020-08-24 | Midland | Michigan | 26111 | 385 | 10 |
464578 | 464578 | 2020-08-24 | Missaukee | Michigan | 26113 | 43 | 1 |
464579 | 464579 | 2020-08-24 | Monroe | Michigan | 26115 | 1198 | 26 |
464580 | 464580 | 2020-08-24 | Montcalm | Michigan | 26117 | 213 | 3 |
464581 | 464581 | 2020-08-24 | Montmorency | Michigan | 26119 | 12 | 0 |
464582 | 464582 | 2020-08-24 | Muskegon | Michigan | 26121 | 1506 | 63 |
464583 | 464583 | 2020-08-24 | Newaygo | Michigan | 26123 | 285 | 0 |
464584 | 464584 | 2020-08-24 | Oakland | Michigan | 26125 | 17358 | 1152 |
464585 | 464585 | 2020-08-24 | Oceana | Michigan | 26127 | 497 | 6 |
464586 | 464586 | 2020-08-24 | Ogemaw | Michigan | 26129 | 55 | 3 |
464587 | 464587 | 2020-08-24 | Ontonagon | Michigan | 26131 | 33 | 0 |
464588 | 464588 | 2020-08-24 | Osceola | Michigan | 26133 | 74 | 0 |
464589 | 464589 | 2020-08-24 | Oscoda | Michigan | 26135 | 29 | 1 |
464590 | 464590 | 2020-08-24 | Otsego | Michigan | 26137 | 150 | 11 |
464591 | 464591 | 2020-08-24 | Ottawa | Michigan | 26139 | 2014 | 63 |
464592 | 464592 | 2020-08-24 | Presque Isle | Michigan | 26141 | 21 | 1 |
464593 | 464593 | 2020-08-24 | Roscommon | Michigan | 26143 | 71 | 4 |
464594 | 464594 | 2020-08-24 | Saginaw | Michigan | 26145 | 2391 | 130 |
464595 | 464595 | 2020-08-24 | Sanilac | Michigan | 26151 | 117 | 6 |
464596 | 464596 | 2020-08-24 | Schoolcraft | Michigan | 26153 | 15 | 0 |
464597 | 464597 | 2020-08-24 | Shiawassee | Michigan | 26155 | 387 | 29 |
464598 | 464598 | 2020-08-24 | St. Clair | Michigan | 26147 | 884 | 53 |
464599 | 464599 | 2020-08-24 | St. Joseph | Michigan | 26149 | 667 | 11 |
464600 | 464600 | 2020-08-24 | Tuscola | Michigan | 26157 | 422 | 29 |
464601 | 464601 | 2020-08-24 | Unknown | Michigan | 604 | 4 | |
464602 | 464602 | 2020-08-24 | Van Buren | Michigan | 26159 | 579 | 14 |
464603 | 464603 | 2020-08-24 | Washtenaw | Michigan | 26161 | 3306 | 124 |
464604 | 464604 | 2020-08-24 | Wayne | Michigan | 26163 | 30191 | 2862 |
464605 | 464605 | 2020-08-24 | Wexford | Michigan | 26165 | 94 | 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);