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 2020-12-14 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
827565 | 827565 | 2020-12-14 | Alcona | Michigan | 26001 | 302 | 9 |
827566 | 827566 | 2020-12-14 | Alger | Michigan | 26003 | 394 | 2 |
827567 | 827567 | 2020-12-14 | Allegan | Michigan | 26005 | 5065 | 45 |
827568 | 827568 | 2020-12-14 | Alpena | Michigan | 26007 | 1000 | 20 |
827569 | 827569 | 2020-12-14 | Antrim | Michigan | 26009 | 549 | 8 |
827570 | 827570 | 2020-12-14 | Arenac | Michigan | 26011 | 553 | 24 |
827571 | 827571 | 2020-12-14 | Baraga | Michigan | 26013 | 608 | 26 |
827572 | 827572 | 2020-12-14 | Barry | Michigan | 26015 | 2674 | 24 |
827573 | 827573 | 2020-12-14 | Bay | Michigan | 26017 | 5494 | 146 |
827574 | 827574 | 2020-12-14 | Benzie | Michigan | 26019 | 582 | 13 |
827575 | 827575 | 2020-12-14 | Berrien | Michigan | 26021 | 8471 | 150 |
827576 | 827576 | 2020-12-14 | Branch | Michigan | 26023 | 3565 | 70 |
827577 | 827577 | 2020-12-14 | Calhoun | Michigan | 26025 | 7104 | 152 |
827578 | 827578 | 2020-12-14 | Cass | Michigan | 26027 | 2793 | 36 |
827579 | 827579 | 2020-12-14 | Charlevoix | Michigan | 26029 | 783 | 8 |
827580 | 827580 | 2020-12-14 | Cheboygan | Michigan | 26031 | 651 | 27 |
827581 | 827581 | 2020-12-14 | Chippewa | Michigan | 26033 | 2492 | 16 |
827582 | 827582 | 2020-12-14 | Clare | Michigan | 26035 | 1023 | 28 |
827583 | 827583 | 2020-12-14 | Clinton | Michigan | 26037 | 3406 | 29 |
827584 | 827584 | 2020-12-14 | Crawford | Michigan | 26039 | 426 | 5 |
827585 | 827585 | 2020-12-14 | Delta | Michigan | 26041 | 2768 | 66 |
827586 | 827586 | 2020-12-14 | Dickinson | Michigan | 26043 | 2019 | 62 |
827587 | 827587 | 2020-12-14 | Eaton | Michigan | 26045 | 4030 | 69 |
827588 | 827588 | 2020-12-14 | Emmet | Michigan | 26047 | 1152 | 30 |
827589 | 827589 | 2020-12-14 | Genesee | Michigan | 26049 | 18933 | 508 |
827590 | 827590 | 2020-12-14 | Gladwin | Michigan | 26051 | 1055 | 16 |
827591 | 827591 | 2020-12-14 | Gogebic | Michigan | 26053 | 957 | 27 |
827592 | 827592 | 2020-12-14 | Grand Traverse | Michigan | 26055 | 2609 | 34 |
827593 | 827593 | 2020-12-14 | Gratiot | Michigan | 26057 | 3824 | 50 |
827594 | 827594 | 2020-12-14 | Hillsdale | Michigan | 26059 | 2197 | 49 |
827595 | 827595 | 2020-12-14 | Houghton | Michigan | 26061 | 1851 | 17 |
827596 | 827596 | 2020-12-14 | Huron | Michigan | 26063 | 1297 | 28 |
827597 | 827597 | 2020-12-14 | Ingham | Michigan | 26065 | 11097 | 150 |
827598 | 827598 | 2020-12-14 | Ionia | Michigan | 26067 | 4455 | 39 |
827599 | 827599 | 2020-12-14 | Iosco | Michigan | 26069 | 980 | 37 |
827600 | 827600 | 2020-12-14 | Iron | Michigan | 26071 | 777 | 37 |
827601 | 827601 | 2020-12-14 | Isabella | Michigan | 26073 | 3021 | 33 |
827602 | 827602 | 2020-12-14 | Jackson | Michigan | 26075 | 9363 | 147 |
827603 | 827603 | 2020-12-14 | Kalamazoo | Michigan | 26077 | 11014 | 202 |
827604 | 827604 | 2020-12-14 | Kalkaska | Michigan | 26079 | 449 | 9 |
827605 | 827605 | 2020-12-14 | Kent | Michigan | 26081 | 39597 | 455 |
827606 | 827606 | 2020-12-14 | Keweenaw | Michigan | 26083 | 82 | 2 |
827607 | 827607 | 2020-12-14 | Lake | Michigan | 26085 | 257 | 6 |
827608 | 827608 | 2020-12-14 | Lapeer | Michigan | 26087 | 3725 | 82 |
827609 | 827609 | 2020-12-14 | Leelanau | Michigan | 26089 | 515 | 4 |
827610 | 827610 | 2020-12-14 | Lenawee | Michigan | 26091 | 4616 | 50 |
827611 | 827611 | 2020-12-14 | Livingston | Michigan | 26093 | 7079 | 58 |
827612 | 827612 | 2020-12-14 | Luce | Michigan | 26095 | 966 | 0 |
827613 | 827613 | 2020-12-14 | Mackinac | Michigan | 26097 | 351 | 1 |
827614 | 827614 | 2020-12-14 | Macomb | Michigan | 26099 | 45516 | 1431 |
827615 | 827615 | 2020-12-14 | Manistee | Michigan | 26101 | 522 | 11 |
827616 | 827616 | 2020-12-14 | Marquette | Michigan | 26103 | 4173 | 45 |
827617 | 827617 | 2020-12-14 | Mason | Michigan | 26105 | 805 | 15 |
827618 | 827618 | 2020-12-14 | Mecosta | Michigan | 26107 | 1521 | 11 |
827619 | 827619 | 2020-12-14 | Menominee | Michigan | 26109 | 1505 | 22 |
827620 | 827620 | 2020-12-14 | Midland | Michigan | 26111 | 3536 | 32 |
827621 | 827621 | 2020-12-14 | Missaukee | Michigan | 26113 | 386 | 7 |
827622 | 827622 | 2020-12-14 | Monroe | Michigan | 26115 | 6787 | 117 |
827623 | 827623 | 2020-12-14 | Montcalm | Michigan | 26117 | 3059 | 44 |
827624 | 827624 | 2020-12-14 | Montmorency | Michigan | 26119 | 258 | 5 |
827625 | 827625 | 2020-12-14 | Muskegon | Michigan | 26121 | 10376 | 231 |
827626 | 827626 | 2020-12-14 | Newaygo | Michigan | 26123 | 2017 | 27 |
827627 | 827627 | 2020-12-14 | Oakland | Michigan | 26125 | 55183 | 1478 |
827628 | 827628 | 2020-12-14 | Oceana | Michigan | 26127 | 1489 | 32 |
827629 | 827629 | 2020-12-14 | Ogemaw | Michigan | 26129 | 772 | 23 |
827630 | 827630 | 2020-12-14 | Ontonagon | Michigan | 26131 | 299 | 15 |
827631 | 827631 | 2020-12-14 | Osceola | Michigan | 26133 | 719 | 14 |
827632 | 827632 | 2020-12-14 | Oscoda | Michigan | 26135 | 269 | 11 |
827633 | 827633 | 2020-12-14 | Otsego | Michigan | 26137 | 924 | 19 |
827634 | 827634 | 2020-12-14 | Ottawa | Michigan | 26139 | 16758 | 218 |
827635 | 827635 | 2020-12-14 | Presque Isle | Michigan | 26141 | 442 | 4 |
827636 | 827636 | 2020-12-14 | Roscommon | Michigan | 26143 | 831 | 25 |
827637 | 827637 | 2020-12-14 | Saginaw | Michigan | 26145 | 10896 | 314 |
827638 | 827638 | 2020-12-14 | Sanilac | Michigan | 26151 | 1256 | 44 |
827639 | 827639 | 2020-12-14 | Schoolcraft | Michigan | 26153 | 203 | 3 |
827640 | 827640 | 2020-12-14 | Shiawassee | Michigan | 26155 | 2555 | 51 |
827641 | 827641 | 2020-12-14 | St. Clair | Michigan | 26147 | 6085 | 119 |
827642 | 827642 | 2020-12-14 | St. Joseph | Michigan | 26149 | 3159 | 43 |
827643 | 827643 | 2020-12-14 | Tuscola | Michigan | 26157 | 2210 | 73 |
827644 | 827644 | 2020-12-14 | Unknown | Michigan | 4312 | 17 | |
827645 | 827645 | 2020-12-14 | Van Buren | Michigan | 26159 | 3649 | 65 |
827646 | 827646 | 2020-12-14 | Washtenaw | Michigan | 26161 | 12636 | 166 |
827647 | 827647 | 2020-12-14 | Wayne | Michigan | 26163 | 76791 | 3428 |
827648 | 827648 | 2020-12-14 | Wexford | Michigan | 26165 | 868 | 16 |
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);