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 2021-08-09 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1600196 | 1600196 | 2021-08-09 | Alcona | Michigan | 26001 | 758 | 33 |
1600197 | 1600197 | 2021-08-09 | Alger | Michigan | 26003 | 671 | 7 |
1600198 | 1600198 | 2021-08-09 | Allegan | Michigan | 26005 | 11508 | 163 |
1600199 | 1600199 | 2021-08-09 | Alpena | Michigan | 26007 | 2392 | 66 |
1600200 | 1600200 | 2021-08-09 | Antrim | Michigan | 26009 | 1672 | 31 |
1600201 | 1600201 | 2021-08-09 | Arenac | Michigan | 26011 | 1240 | 29 |
1600202 | 1600202 | 2021-08-09 | Baraga | Michigan | 26013 | 1004 | 40 |
1600203 | 1600203 | 2021-08-09 | Barry | Michigan | 26015 | 6098 | 70 |
1600204 | 1600204 | 2021-08-09 | Bay | Michigan | 26017 | 11427 | 355 |
1600205 | 1600205 | 2021-08-09 | Benzie | Michigan | 26019 | 1305 | 36 |
1600206 | 1600206 | 2021-08-09 | Berrien | Michigan | 26021 | 15905 | 302 |
1600207 | 1600207 | 2021-08-09 | Branch | Michigan | 26023 | 6059 | 121 |
1600208 | 1600208 | 2021-08-09 | Calhoun | Michigan | 26025 | 14940 | 321 |
1600209 | 1600209 | 2021-08-09 | Cass | Michigan | 26027 | 5641 | 78 |
1600210 | 1600210 | 2021-08-09 | Charlevoix | Michigan | 26029 | 1789 | 23 |
1600211 | 1600211 | 2021-08-09 | Cheboygan | Michigan | 26031 | 1963 | 47 |
1600212 | 1600212 | 2021-08-09 | Chippewa | Michigan | 26033 | 5698 | 51 |
1600213 | 1600213 | 2021-08-09 | Clare | Michigan | 26035 | 2527 | 86 |
1600214 | 1600214 | 2021-08-09 | Clinton | Michigan | 26037 | 7801 | 94 |
1600215 | 1600215 | 2021-08-09 | Crawford | Michigan | 26039 | 1010 | 14 |
1600216 | 1600216 | 2021-08-09 | Delta | Michigan | 26041 | 4162 | 95 |
1600217 | 1600217 | 2021-08-09 | Dickinson | Michigan | 26043 | 2799 | 74 |
1600218 | 1600218 | 2021-08-09 | Eaton | Michigan | 26045 | 10374 | 211 |
1600219 | 1600219 | 2021-08-09 | Emmet | Michigan | 26047 | 2446 | 43 |
1600220 | 1600220 | 2021-08-09 | Genesee | Michigan | 26049 | 42448 | 984 |
1600221 | 1600221 | 2021-08-09 | Gladwin | Michigan | 26051 | 2338 | 61 |
1600222 | 1600222 | 2021-08-09 | Gogebic | Michigan | 26053 | 1475 | 53 |
1600223 | 1600223 | 2021-08-09 | Grand Traverse | Michigan | 26055 | 6676 | 100 |
1600224 | 1600224 | 2021-08-09 | Gratiot | Michigan | 26057 | 7019 | 125 |
1600225 | 1600225 | 2021-08-09 | Hillsdale | Michigan | 26059 | 4506 | 95 |
1600226 | 1600226 | 2021-08-09 | Houghton | Michigan | 26061 | 3181 | 43 |
1600227 | 1600227 | 2021-08-09 | Huron | Michigan | 26063 | 4159 | 83 |
1600228 | 1600228 | 2021-08-09 | Ingham | Michigan | 26065 | 25547 | 396 |
1600229 | 1600229 | 2021-08-09 | Ionia | Michigan | 26067 | 9491 | 85 |
1600230 | 1600230 | 2021-08-09 | Iosco | Michigan | 26069 | 2061 | 75 |
1600231 | 1600231 | 2021-08-09 | Iron | Michigan | 26071 | 1082 | 53 |
1600232 | 1600232 | 2021-08-09 | Isabella | Michigan | 26073 | 6429 | 101 |
1600233 | 1600233 | 2021-08-09 | Jackson | Michigan | 26075 | 21511 | 326 |
1600234 | 1600234 | 2021-08-09 | Kalamazoo | Michigan | 26077 | 23823 | 406 |
1600235 | 1600235 | 2021-08-09 | Kalkaska | Michigan | 26079 | 1190 | 29 |
1600236 | 1600236 | 2021-08-09 | Kent | Michigan | 26081 | 74997 | 871 |
1600237 | 1600237 | 2021-08-09 | Keweenaw | Michigan | 26083 | 174 | 2 |
1600238 | 1600238 | 2021-08-09 | Lake | Michigan | 26085 | 652 | 17 |
1600239 | 1600239 | 2021-08-09 | Lapeer | Michigan | 26087 | 9906 | 215 |
1600240 | 1600240 | 2021-08-09 | Leelanau | Michigan | 26089 | 1283 | 20 |
1600241 | 1600241 | 2021-08-09 | Lenawee | Michigan | 26091 | 11050 | 179 |
1600242 | 1600242 | 2021-08-09 | Livingston | Michigan | 26093 | 17271 | 195 |
1600243 | 1600243 | 2021-08-09 | Luce | Michigan | 26095 | 1341 | 6 |
1600244 | 1600244 | 2021-08-09 | Mackinac | Michigan | 26097 | 722 | 3 |
1600245 | 1600245 | 2021-08-09 | Macomb | Michigan | 26099 | 102608 | 2517 |
1600246 | 1600246 | 2021-08-09 | Manistee | Michigan | 26101 | 2013 | 26 |
1600247 | 1600247 | 2021-08-09 | Marquette | Michigan | 26103 | 5977 | 66 |
1600248 | 1600248 | 2021-08-09 | Mason | Michigan | 26105 | 2214 | 37 |
1600249 | 1600249 | 2021-08-09 | Mecosta | Michigan | 26107 | 3261 | 38 |
1600250 | 1600250 | 2021-08-09 | Menominee | Michigan | 26109 | 2185 | 43 |
1600251 | 1600251 | 2021-08-09 | Midland | Michigan | 26111 | 7726 | 96 |
1600252 | 1600252 | 2021-08-09 | Missaukee | Michigan | 26113 | 1531 | 28 |
1600253 | 1600253 | 2021-08-09 | Monroe | Michigan | 26115 | 15768 | 267 |
1600254 | 1600254 | 2021-08-09 | Montcalm | Michigan | 26117 | 8267 | 121 |
1600255 | 1600255 | 2021-08-09 | Montmorency | Michigan | 26119 | 640 | 20 |
1600256 | 1600256 | 2021-08-09 | Muskegon | Michigan | 26121 | 18806 | 386 |
1600257 | 1600257 | 2021-08-09 | Newaygo | Michigan | 26123 | 4975 | 69 |
1600258 | 1600258 | 2021-08-09 | Oakland | Michigan | 26125 | 121812 | 2479 |
1600259 | 1600259 | 2021-08-09 | Oceana | Michigan | 26127 | 2809 | 60 |
1600260 | 1600260 | 2021-08-09 | Ogemaw | Michigan | 26129 | 1799 | 43 |
1600261 | 1600261 | 2021-08-09 | Ontonagon | Michigan | 26131 | 487 | 22 |
1600262 | 1600262 | 2021-08-09 | Osceola | Michigan | 26133 | 1982 | 31 |
1600263 | 1600263 | 2021-08-09 | Oscoda | Michigan | 26135 | 697 | 31 |
1600264 | 1600264 | 2021-08-09 | Otsego | Michigan | 26137 | 2387 | 41 |
1600265 | 1600265 | 2021-08-09 | Ottawa | Michigan | 26139 | 33499 | 444 |
1600266 | 1600266 | 2021-08-09 | Presque Isle | Michigan | 26141 | 1071 | 34 |
1600267 | 1600267 | 2021-08-09 | Roscommon | Michigan | 26143 | 1924 | 55 |
1600268 | 1600268 | 2021-08-09 | Saginaw | Michigan | 26145 | 23046 | 643 |
1600269 | 1600269 | 2021-08-09 | Sanilac | Michigan | 26151 | 4289 | 126 |
1600270 | 1600270 | 2021-08-09 | Schoolcraft | Michigan | 26153 | 443 | 5 |
1600271 | 1600271 | 2021-08-09 | Shiawassee | Michigan | 26155 | 6597 | 110 |
1600272 | 1600272 | 2021-08-09 | St. Clair | Michigan | 26147 | 18747 | 454 |
1600273 | 1600273 | 2021-08-09 | St. Joseph | Michigan | 26149 | 6400 | 104 |
1600274 | 1600274 | 2021-08-09 | Tuscola | Michigan | 26157 | 5780 | 176 |
1600275 | 1600275 | 2021-08-09 | Unknown | Michigan | 771 | 18 | |
1600276 | 1600276 | 2021-08-09 | Van Buren | Michigan | 26159 | 7358 | 137 |
1600277 | 1600277 | 2021-08-09 | Washtenaw | Michigan | 26161 | 27785 | 312 |
1600278 | 1600278 | 2021-08-09 | Wayne | Michigan | 26163 | 170033 | 5220 |
1600279 | 1600279 | 2021-08-09 | Wexford | Michigan | 26165 | 2932 | 48 |
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);