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 2022-01-08 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2094117 | 2094117 | 2022-01-08 | Alcona | Michigan | 26001 | 1462 | 59 |
2094118 | 2094118 | 2022-01-08 | Alger | Michigan | 26003 | 1346 | 11 |
2094119 | 2094119 | 2022-01-08 | Allegan | Michigan | 26005 | 21376 | 287 |
2094120 | 2094120 | 2022-01-08 | Alpena | Michigan | 26007 | 4669 | 117 |
2094121 | 2094121 | 2022-01-08 | Antrim | Michigan | 26009 | 3368 | 52 |
2094122 | 2094122 | 2022-01-08 | Arenac | Michigan | 26011 | 2449 | 55 |
2094123 | 2094123 | 2022-01-08 | Baraga | Michigan | 26013 | 1740 | 49 |
2094124 | 2094124 | 2022-01-08 | Barry | Michigan | 26015 | 11276 | 134 |
2094125 | 2094125 | 2022-01-08 | Bay | Michigan | 26017 | 20295 | 492 |
2094126 | 2094126 | 2022-01-08 | Benzie | Michigan | 26019 | 2551 | 56 |
2094127 | 2094127 | 2022-01-08 | Berrien | Michigan | 26021 | 27323 | 418 |
2094128 | 2094128 | 2022-01-08 | Branch | Michigan | 26023 | 9701 | 170 |
2094129 | 2094129 | 2022-01-08 | Calhoun | Michigan | 26025 | 26203 | 486 |
2094130 | 2094130 | 2022-01-08 | Cass | Michigan | 26027 | 9398 | 115 |
2094131 | 2094131 | 2022-01-08 | Charlevoix | Michigan | 26029 | 3779 | 53 |
2094132 | 2094132 | 2022-01-08 | Cheboygan | Michigan | 26031 | 3824 | 84 |
2094133 | 2094133 | 2022-01-08 | Chippewa | Michigan | 26033 | 8771 | 88 |
2094134 | 2094134 | 2022-01-08 | Clare | Michigan | 26035 | 5351 | 139 |
2094135 | 2094135 | 2022-01-08 | Clinton | Michigan | 26037 | 15339 | 168 |
2094136 | 2094136 | 2022-01-08 | Crawford | Michigan | 26039 | 2006 | 23 |
2094137 | 2094137 | 2022-01-08 | Delta | Michigan | 26041 | 7491 | 138 |
2094138 | 2094138 | 2022-01-08 | Dickinson | Michigan | 26043 | 5392 | 94 |
2094139 | 2094139 | 2022-01-08 | Eaton | Michigan | 26045 | 19818 | 331 |
2094140 | 2094140 | 2022-01-08 | Emmet | Michigan | 26047 | 4861 | 63 |
2094141 | 2094141 | 2022-01-08 | Genesee | Michigan | 26049 | 78529 | 1393 |
2094142 | 2094142 | 2022-01-08 | Gladwin | Michigan | 26051 | 4384 | 101 |
2094143 | 2094143 | 2022-01-08 | Gogebic | Michigan | 26053 | 2434 | 63 |
2094144 | 2094144 | 2022-01-08 | Grand Traverse | Michigan | 26055 | 12991 | 186 |
2094145 | 2094145 | 2022-01-08 | Gratiot | Michigan | 26057 | 11202 | 167 |
2094146 | 2094146 | 2022-01-08 | Hillsdale | Michigan | 26059 | 8435 | 175 |
2094147 | 2094147 | 2022-01-08 | Houghton | Michigan | 26061 | 5894 | 76 |
2094148 | 2094148 | 2022-01-08 | Huron | Michigan | 26063 | 6536 | 127 |
2094149 | 2094149 | 2022-01-08 | Ingham | Michigan | 26065 | 46240 | 603 |
2094150 | 2094150 | 2022-01-08 | Ionia | Michigan | 26067 | 15741 | 150 |
2094151 | 2094151 | 2022-01-08 | Iosco | Michigan | 26069 | 3999 | 117 |
2094152 | 2094152 | 2022-01-08 | Iron | Michigan | 26071 | 1961 | 73 |
2094153 | 2094153 | 2022-01-08 | Isabella | Michigan | 26073 | 12069 | 167 |
2094154 | 2094154 | 2022-01-08 | Jackson | Michigan | 26075 | 35905 | 482 |
2094155 | 2094155 | 2022-01-08 | Kalamazoo | Michigan | 26077 | 44209 | 557 |
2094156 | 2094156 | 2022-01-08 | Kalkaska | Michigan | 26079 | 2659 | 48 |
2094157 | 2094157 | 2022-01-08 | Kent | Michigan | 26081 | 132568 | 1294 |
2094158 | 2094158 | 2022-01-08 | Keweenaw | Michigan | 26083 | 405 | 11 |
2094159 | 2094159 | 2022-01-08 | Lake | Michigan | 26085 | 1451 | 31 |
2094160 | 2094160 | 2022-01-08 | Lapeer | Michigan | 26087 | 16984 | 354 |
2094161 | 2094161 | 2022-01-08 | Leelanau | Michigan | 26089 | 2685 | 42 |
2094162 | 2094162 | 2022-01-08 | Lenawee | Michigan | 26091 | 20349 | 268 |
2094163 | 2094163 | 2022-01-08 | Livingston | Michigan | 26093 | 35913 | 366 |
2094164 | 2094164 | 2022-01-08 | Luce | Michigan | 26095 | 1950 | 6 |
2094165 | 2094165 | 2022-01-08 | Mackinac | Michigan | 26097 | 1796 | 23 |
2094166 | 2094166 | 2022-01-08 | Macomb | Michigan | 26099 | 181983 | 3309 |
2094167 | 2094167 | 2022-01-08 | Manistee | Michigan | 26101 | 3430 | 64 |
2094168 | 2094168 | 2022-01-08 | Marquette | Michigan | 26103 | 11013 | 98 |
2094169 | 2094169 | 2022-01-08 | Mason | Michigan | 26105 | 4963 | 74 |
2094170 | 2094170 | 2022-01-08 | Mecosta | Michigan | 26107 | 6680 | 88 |
2094171 | 2094171 | 2022-01-08 | Menominee | Michigan | 26109 | 4384 | 63 |
2094172 | 2094172 | 2022-01-08 | Midland | Michigan | 26111 | 14376 | 190 |
2094173 | 2094173 | 2022-01-08 | Missaukee | Michigan | 26113 | 2299 | 52 |
2094174 | 2094174 | 2022-01-08 | Monroe | Michigan | 26115 | 29675 | 386 |
2094175 | 2094175 | 2022-01-08 | Montcalm | Michigan | 26117 | 14160 | 177 |
2094176 | 2094176 | 2022-01-08 | Montmorency | Michigan | 26119 | 1389 | 42 |
2094177 | 2094177 | 2022-01-08 | Muskegon | Michigan | 26121 | 33551 | 541 |
2094178 | 2094178 | 2022-01-08 | Newaygo | Michigan | 26123 | 9184 | 131 |
2094179 | 2094179 | 2022-01-08 | Oakland | Michigan | 26125 | 220919 | 3199 |
2094180 | 2094180 | 2022-01-08 | Oceana | Michigan | 26127 | 5081 | 84 |
2094181 | 2094181 | 2022-01-08 | Ogemaw | Michigan | 26129 | 3469 | 84 |
2094182 | 2094182 | 2022-01-08 | Ontonagon | Michigan | 26131 | 796 | 28 |
2094183 | 2094183 | 2022-01-08 | Osceola | Michigan | 26133 | 4011 | 66 |
2094184 | 2094184 | 2022-01-08 | Oscoda | Michigan | 26135 | 1204 | 51 |
2094185 | 2094185 | 2022-01-08 | Otsego | Michigan | 26137 | 4458 | 84 |
2094186 | 2094186 | 2022-01-08 | Ottawa | Michigan | 26139 | 58717 | 672 |
2094187 | 2094187 | 2022-01-08 | Presque Isle | Michigan | 26141 | 1796 | 52 |
2094188 | 2094188 | 2022-01-08 | Roscommon | Michigan | 26143 | 3766 | 106 |
2094189 | 2094189 | 2022-01-08 | Saginaw | Michigan | 26145 | 39313 | 823 |
2094190 | 2094190 | 2022-01-08 | Sanilac | Michigan | 26151 | 7141 | 168 |
2094191 | 2094191 | 2022-01-08 | Schoolcraft | Michigan | 26153 | 1277 | 9 |
2094192 | 2094192 | 2022-01-08 | Shiawassee | Michigan | 26155 | 13592 | 192 |
2094193 | 2094193 | 2022-01-08 | St. Clair | Michigan | 26147 | 32792 | 694 |
2094194 | 2094194 | 2022-01-08 | St. Joseph | Michigan | 26149 | 11216 | 168 |
2094195 | 2094195 | 2022-01-08 | Tuscola | Michigan | 26157 | 10445 | 245 |
2094196 | 2094196 | 2022-01-08 | Unknown | Michigan | 3439 | 25 | |
2094197 | 2094197 | 2022-01-08 | Van Buren | Michigan | 26159 | 13509 | 219 |
2094198 | 2094198 | 2022-01-08 | Washtenaw | Michigan | 26161 | 53485 | 426 |
2094199 | 2094199 | 2022-01-08 | Wayne | Michigan | 26163 | 310944 | 6661 |
2094200 | 2094200 | 2022-01-08 | Wexford | Michigan | 26165 | 5256 | 87 |
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);