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-08-22 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
458064 | 458064 | 2020-08-22 | Alcona | Michigan | 26001 | 30 | 2 |
458065 | 458065 | 2020-08-22 | Alger | Michigan | 26003 | 18 | 0 |
458066 | 458066 | 2020-08-22 | Allegan | Michigan | 26005 | 583 | 6 |
458067 | 458067 | 2020-08-22 | Alpena | Michigan | 26007 | 131 | 14 |
458068 | 458068 | 2020-08-22 | Antrim | Michigan | 26009 | 52 | 0 |
458069 | 458069 | 2020-08-22 | Arenac | Michigan | 26011 | 49 | 3 |
458070 | 458070 | 2020-08-22 | Baraga | Michigan | 26013 | 8 | 0 |
458071 | 458071 | 2020-08-22 | Barry | Michigan | 26015 | 200 | 2 |
458072 | 458072 | 2020-08-22 | Bay | Michigan | 26017 | 764 | 39 |
458073 | 458073 | 2020-08-22 | Benzie | Michigan | 26019 | 39 | 1 |
458074 | 458074 | 2020-08-22 | Berrien | Michigan | 26021 | 1583 | 69 |
458075 | 458075 | 2020-08-22 | Branch | Michigan | 26023 | 1214 | 26 |
458076 | 458076 | 2020-08-22 | Calhoun | Michigan | 26025 | 873 | 43 |
458077 | 458077 | 2020-08-22 | Cass | Michigan | 26027 | 381 | 15 |
458078 | 458078 | 2020-08-22 | Charlevoix | Michigan | 26029 | 63 | 2 |
458079 | 458079 | 2020-08-22 | Cheboygan | Michigan | 26031 | 63 | 2 |
458080 | 458080 | 2020-08-22 | Chippewa | Michigan | 26033 | 49 | 0 |
458081 | 458081 | 2020-08-22 | Clare | Michigan | 26035 | 93 | 3 |
458082 | 458082 | 2020-08-22 | Clinton | Michigan | 26037 | 447 | 13 |
458083 | 458083 | 2020-08-22 | Crawford | Michigan | 26039 | 112 | 5 |
458084 | 458084 | 2020-08-22 | Delta | Michigan | 26041 | 131 | 3 |
458085 | 458085 | 2020-08-22 | Dickinson | Michigan | 26043 | 61 | 2 |
458086 | 458086 | 2020-08-22 | Eaton | Michigan | 26045 | 488 | 8 |
458087 | 458087 | 2020-08-22 | Emmet | Michigan | 26047 | 100 | 2 |
458088 | 458088 | 2020-08-22 | Genesee | Michigan | 26049 | 3842 | 302 |
458089 | 458089 | 2020-08-22 | Gladwin | Michigan | 26051 | 73 | 2 |
458090 | 458090 | 2020-08-22 | Gogebic | Michigan | 26053 | 141 | 1 |
458091 | 458091 | 2020-08-22 | Grand Traverse | Michigan | 26055 | 279 | 5 |
458092 | 458092 | 2020-08-22 | Gratiot | Michigan | 26057 | 177 | 15 |
458093 | 458093 | 2020-08-22 | Hillsdale | Michigan | 26059 | 288 | 25 |
458094 | 458094 | 2020-08-22 | Houghton | Michigan | 26061 | 57 | 0 |
458095 | 458095 | 2020-08-22 | Huron | Michigan | 26063 | 189 | 4 |
458096 | 458096 | 2020-08-22 | Ingham | Michigan | 26065 | 1679 | 36 |
458097 | 458097 | 2020-08-22 | Ionia | Michigan | 26067 | 285 | 7 |
458098 | 458098 | 2020-08-22 | Iosco | Michigan | 26069 | 140 | 12 |
458099 | 458099 | 2020-08-22 | Iron | Michigan | 26071 | 25 | 1 |
458100 | 458100 | 2020-08-22 | Isabella | Michigan | 26073 | 298 | 9 |
458101 | 458101 | 2020-08-22 | Jackson | Michigan | 26075 | 2494 | 58 |
458102 | 458102 | 2020-08-22 | Kalamazoo | Michigan | 26077 | 1809 | 86 |
458103 | 458103 | 2020-08-22 | Kalkaska | Michigan | 26079 | 60 | 4 |
458104 | 458104 | 2020-08-22 | Kent | Michigan | 26081 | 7999 | 160 |
458105 | 458105 | 2020-08-22 | Keweenaw | Michigan | 26083 | 2 | 0 |
458106 | 458106 | 2020-08-22 | Lake | Michigan | 26085 | 29 | 0 |
458107 | 458107 | 2020-08-22 | Lapeer | Michigan | 26087 | 819 | 42 |
458108 | 458108 | 2020-08-22 | Leelanau | Michigan | 26089 | 83 | 0 |
458109 | 458109 | 2020-08-22 | Lenawee | Michigan | 26091 | 1218 | 17 |
458110 | 458110 | 2020-08-22 | Livingston | Michigan | 26093 | 1025 | 30 |
458111 | 458111 | 2020-08-22 | Luce | Michigan | 26095 | 33 | 0 |
458112 | 458112 | 2020-08-22 | Mackinac | Michigan | 26097 | 31 | 0 |
458113 | 458113 | 2020-08-22 | Macomb | Michigan | 26099 | 12121 | 963 |
458114 | 458114 | 2020-08-22 | Manistee | Michigan | 26101 | 56 | 1 |
458115 | 458115 | 2020-08-22 | Marquette | Michigan | 26103 | 230 | 11 |
458116 | 458116 | 2020-08-22 | Mason | Michigan | 26105 | 110 | 0 |
458117 | 458117 | 2020-08-22 | Mecosta | Michigan | 26107 | 76 | 2 |
458118 | 458118 | 2020-08-22 | Menominee | Michigan | 26109 | 222 | 0 |
458119 | 458119 | 2020-08-22 | Midland | Michigan | 26111 | 380 | 10 |
458120 | 458120 | 2020-08-22 | Missaukee | Michigan | 26113 | 42 | 1 |
458121 | 458121 | 2020-08-22 | Monroe | Michigan | 26115 | 1170 | 26 |
458122 | 458122 | 2020-08-22 | Montcalm | Michigan | 26117 | 212 | 3 |
458123 | 458123 | 2020-08-22 | Montmorency | Michigan | 26119 | 12 | 0 |
458124 | 458124 | 2020-08-22 | Muskegon | Michigan | 26121 | 1486 | 63 |
458125 | 458125 | 2020-08-22 | Newaygo | Michigan | 26123 | 279 | 0 |
458126 | 458126 | 2020-08-22 | Oakland | Michigan | 26125 | 17106 | 1151 |
458127 | 458127 | 2020-08-22 | Oceana | Michigan | 26127 | 495 | 6 |
458128 | 458128 | 2020-08-22 | Ogemaw | Michigan | 26129 | 54 | 3 |
458129 | 458129 | 2020-08-22 | Ontonagon | Michigan | 26131 | 32 | 0 |
458130 | 458130 | 2020-08-22 | Osceola | Michigan | 26133 | 73 | 0 |
458131 | 458131 | 2020-08-22 | Oscoda | Michigan | 26135 | 29 | 1 |
458132 | 458132 | 2020-08-22 | Otsego | Michigan | 26137 | 148 | 11 |
458133 | 458133 | 2020-08-22 | Ottawa | Michigan | 26139 | 1988 | 63 |
458134 | 458134 | 2020-08-22 | Presque Isle | Michigan | 26141 | 21 | 1 |
458135 | 458135 | 2020-08-22 | Roscommon | Michigan | 26143 | 64 | 3 |
458136 | 458136 | 2020-08-22 | Saginaw | Michigan | 26145 | 2345 | 130 |
458137 | 458137 | 2020-08-22 | Sanilac | Michigan | 26151 | 116 | 6 |
458138 | 458138 | 2020-08-22 | Schoolcraft | Michigan | 26153 | 15 | 0 |
458139 | 458139 | 2020-08-22 | Shiawassee | Michigan | 26155 | 378 | 29 |
458140 | 458140 | 2020-08-22 | St. Clair | Michigan | 26147 | 876 | 53 |
458141 | 458141 | 2020-08-22 | St. Joseph | Michigan | 26149 | 657 | 11 |
458142 | 458142 | 2020-08-22 | Tuscola | Michigan | 26157 | 415 | 29 |
458143 | 458143 | 2020-08-22 | Unknown | Michigan | 548 | 3 | |
458144 | 458144 | 2020-08-22 | Van Buren | Michigan | 26159 | 563 | 14 |
458145 | 458145 | 2020-08-22 | Washtenaw | Michigan | 26161 | 3249 | 124 |
458146 | 458146 | 2020-08-22 | Wayne | Michigan | 26163 | 29879 | 2859 |
458147 | 458147 | 2020-08-22 | Wexford | Michigan | 26165 | 87 | 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);