ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-09-19" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
548610 | 548610 | 2020-09-19 | Alcona | Michigan | 26001 | 41 | 2 |
548611 | 548611 | 2020-09-19 | Alger | Michigan | 26003 | 17 | 0 |
548612 | 548612 | 2020-09-19 | Allegan | Michigan | 26005 | 729 | 7 |
548613 | 548613 | 2020-09-19 | Alpena | Michigan | 26007 | 139 | 14 |
548614 | 548614 | 2020-09-19 | Antrim | Michigan | 26009 | 66 | 0 |
548615 | 548615 | 2020-09-19 | Arenac | Michigan | 26011 | 69 | 3 |
548616 | 548616 | 2020-09-19 | Baraga | Michigan | 26013 | 14 | 0 |
548617 | 548617 | 2020-09-19 | Barry | Michigan | 26015 | 272 | 2 |
548618 | 548618 | 2020-09-19 | Bay | Michigan | 26017 | 956 | 48 |
548619 | 548619 | 2020-09-19 | Benzie | Michigan | 26019 | 69 | 2 |
548620 | 548620 | 2020-09-19 | Berrien | Michigan | 26021 | 1854 | 72 |
548621 | 548621 | 2020-09-19 | Branch | Michigan | 26023 | 1383 | 27 |
548622 | 548622 | 2020-09-19 | Calhoun | Michigan | 26025 | 1222 | 44 |
548623 | 548623 | 2020-09-19 | Cass | Michigan | 26027 | 514 | 16 |
548624 | 548624 | 2020-09-19 | Charlevoix | Michigan | 26029 | 98 | 3 |
548625 | 548625 | 2020-09-19 | Cheboygan | Michigan | 26031 | 88 | 2 |
548626 | 548626 | 2020-09-19 | Chippewa | Michigan | 26033 | 76 | 0 |
548627 | 548627 | 2020-09-19 | Clare | Michigan | 26035 | 108 | 4 |
548628 | 548628 | 2020-09-19 | Clinton | Michigan | 26037 | 620 | 13 |
548629 | 548629 | 2020-09-19 | Crawford | Michigan | 26039 | 118 | 5 |
548630 | 548630 | 2020-09-19 | Delta | Michigan | 26041 | 261 | 5 |
548631 | 548631 | 2020-09-19 | Dickinson | Michigan | 26043 | 97 | 2 |
548632 | 548632 | 2020-09-19 | Eaton | Michigan | 26045 | 610 | 10 |
548633 | 548633 | 2020-09-19 | Emmet | Michigan | 26047 | 152 | 4 |
548634 | 548634 | 2020-09-19 | Genesee | Michigan | 26049 | 4267 | 306 |
548635 | 548635 | 2020-09-19 | Gladwin | Michigan | 26051 | 91 | 2 |
548636 | 548636 | 2020-09-19 | Gogebic | Michigan | 26053 | 153 | 1 |
548637 | 548637 | 2020-09-19 | Grand Traverse | Michigan | 26055 | 455 | 7 |
548638 | 548638 | 2020-09-19 | Gratiot | Michigan | 26057 | 250 | 15 |
548639 | 548639 | 2020-09-19 | Hillsdale | Michigan | 26059 | 325 | 27 |
548640 | 548640 | 2020-09-19 | Houghton | Michigan | 26061 | 300 | 1 |
548641 | 548641 | 2020-09-19 | Huron | Michigan | 26063 | 214 | 5 |
548642 | 548642 | 2020-09-19 | Ingham | Michigan | 26065 | 3158 | 45 |
548643 | 548643 | 2020-09-19 | Ionia | Michigan | 26067 | 506 | 7 |
548644 | 548644 | 2020-09-19 | Iosco | Michigan | 26069 | 190 | 12 |
548645 | 548645 | 2020-09-19 | Iron | Michigan | 26071 | 66 | 1 |
548646 | 548646 | 2020-09-19 | Isabella | Michigan | 26073 | 652 | 12 |
548647 | 548647 | 2020-09-19 | Jackson | Michigan | 26075 | 2715 | 66 |
548648 | 548648 | 2020-09-19 | Kalamazoo | Michigan | 26077 | 2580 | 91 |
548649 | 548649 | 2020-09-19 | Kalkaska | Michigan | 26079 | 80 | 4 |
548650 | 548650 | 2020-09-19 | Kent | Michigan | 26081 | 9348 | 174 |
548651 | 548651 | 2020-09-19 | Keweenaw | Michigan | 26083 | 7 | 0 |
548652 | 548652 | 2020-09-19 | Lake | Michigan | 26085 | 33 | 0 |
548653 | 548653 | 2020-09-19 | Lapeer | Michigan | 26087 | 887 | 43 |
548654 | 548654 | 2020-09-19 | Leelanau | Michigan | 26089 | 108 | 1 |
548655 | 548655 | 2020-09-19 | Lenawee | Michigan | 26091 | 1509 | 20 |
548656 | 548656 | 2020-09-19 | Livingston | Michigan | 26093 | 1355 | 31 |
548657 | 548657 | 2020-09-19 | Luce | Michigan | 26095 | 237 | 0 |
548658 | 548658 | 2020-09-19 | Mackinac | Michigan | 26097 | 54 | 0 |
548659 | 548659 | 2020-09-19 | Macomb | Michigan | 26099 | 14215 | 1014 |
548660 | 548660 | 2020-09-19 | Manistee | Michigan | 26101 | 82 | 2 |
548661 | 548661 | 2020-09-19 | Marquette | Michigan | 26103 | 316 | 12 |
548662 | 548662 | 2020-09-19 | Mason | Michigan | 26105 | 134 | 0 |
548663 | 548663 | 2020-09-19 | Mecosta | Michigan | 26107 | 186 | 3 |
548664 | 548664 | 2020-09-19 | Menominee | Michigan | 26109 | 302 | 1 |
548665 | 548665 | 2020-09-19 | Midland | Michigan | 26111 | 553 | 11 |
548666 | 548666 | 2020-09-19 | Missaukee | Michigan | 26113 | 58 | 1 |
548667 | 548667 | 2020-09-19 | Monroe | Michigan | 26115 | 1458 | 28 |
548668 | 548668 | 2020-09-19 | Montcalm | Michigan | 26117 | 291 | 5 |
548669 | 548669 | 2020-09-19 | Montmorency | Michigan | 26119 | 14 | 0 |
548670 | 548670 | 2020-09-19 | Muskegon | Michigan | 26121 | 2379 | 71 |
548671 | 548671 | 2020-09-19 | Newaygo | Michigan | 26123 | 318 | 1 |
548672 | 548672 | 2020-09-19 | Oakland | Michigan | 26125 | 19884 | 1193 |
548673 | 548673 | 2020-09-19 | Oceana | Michigan | 26127 | 513 | 6 |
548674 | 548674 | 2020-09-19 | Ogemaw | Michigan | 26129 | 61 | 5 |
548675 | 548675 | 2020-09-19 | Ontonagon | Michigan | 26131 | 42 | 0 |
548676 | 548676 | 2020-09-19 | Osceola | Michigan | 26133 | 89 | 0 |
548677 | 548677 | 2020-09-19 | Oscoda | Michigan | 26135 | 30 | 1 |
548678 | 548678 | 2020-09-19 | Otsego | Michigan | 26137 | 176 | 11 |
548679 | 548679 | 2020-09-19 | Ottawa | Michigan | 26139 | 3162 | 65 |
548680 | 548680 | 2020-09-19 | Presque Isle | Michigan | 26141 | 26 | 1 |
548681 | 548681 | 2020-09-19 | Roscommon | Michigan | 26143 | 88 | 4 |
548682 | 548682 | 2020-09-19 | Saginaw | Michigan | 26145 | 2867 | 138 |
548683 | 548683 | 2020-09-19 | Sanilac | Michigan | 26151 | 144 | 7 |
548684 | 548684 | 2020-09-19 | Schoolcraft | Michigan | 26153 | 21 | 0 |
548685 | 548685 | 2020-09-19 | Shiawassee | Michigan | 26155 | 491 | 31 |
548686 | 548686 | 2020-09-19 | St. Clair | Michigan | 26147 | 982 | 53 |
548687 | 548687 | 2020-09-19 | St. Joseph | Michigan | 26149 | 726 | 11 |
548688 | 548688 | 2020-09-19 | Tuscola | Michigan | 26157 | 488 | 31 |
548689 | 548689 | 2020-09-19 | Unknown | Michigan | 116 | 5 | |
548690 | 548690 | 2020-09-19 | Van Buren | Michigan | 26159 | 738 | 17 |
548691 | 548691 | 2020-09-19 | Washtenaw | Michigan | 26161 | 3819 | 125 |
548692 | 548692 | 2020-09-19 | Wayne | Michigan | 26163 | 34107 | 2957 |
548693 | 548693 | 2020-09-19 | Wexford | Michigan | 26165 | 123 | 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);