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-11-10 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
717228 | 717228 | 2020-11-10 | Alcona | Michigan | 26001 | 68 | 3 |
717229 | 717229 | 2020-11-10 | Alger | Michigan | 26003 | 172 | 1 |
717230 | 717230 | 2020-11-10 | Allegan | Michigan | 26005 | 2185 | 9 |
717231 | 717231 | 2020-11-10 | Alpena | Michigan | 26007 | 245 | 15 |
717232 | 717232 | 2020-11-10 | Antrim | Michigan | 26009 | 214 | 1 |
717233 | 717233 | 2020-11-10 | Arenac | Michigan | 26011 | 165 | 5 |
717234 | 717234 | 2020-11-10 | Baraga | Michigan | 26013 | 225 | 4 |
717235 | 717235 | 2020-11-10 | Barry | Michigan | 26015 | 1157 | 9 |
717236 | 717236 | 2020-11-10 | Bay | Michigan | 26017 | 2352 | 72 |
717237 | 717237 | 2020-11-10 | Benzie | Michigan | 26019 | 193 | 3 |
717238 | 717238 | 2020-11-10 | Berrien | Michigan | 26021 | 3965 | 94 |
717239 | 717239 | 2020-11-10 | Branch | Michigan | 26023 | 2119 | 38 |
717240 | 717240 | 2020-11-10 | Calhoun | Michigan | 26025 | 4258 | 90 |
717241 | 717241 | 2020-11-10 | Cass | Michigan | 26027 | 1436 | 25 |
717242 | 717242 | 2020-11-10 | Charlevoix | Michigan | 26029 | 317 | 5 |
717243 | 717243 | 2020-11-10 | Cheboygan | Michigan | 26031 | 272 | 8 |
717244 | 717244 | 2020-11-10 | Chippewa | Michigan | 26033 | 396 | 0 |
717245 | 717245 | 2020-11-10 | Clare | Michigan | 26035 | 432 | 19 |
717246 | 717246 | 2020-11-10 | Clinton | Michigan | 26037 | 1692 | 18 |
717247 | 717247 | 2020-11-10 | Crawford | Michigan | 26039 | 192 | 5 |
717248 | 717248 | 2020-11-10 | Delta | Michigan | 26041 | 1773 | 50 |
717249 | 717249 | 2020-11-10 | Dickinson | Michigan | 26043 | 1060 | 27 |
717250 | 717250 | 2020-11-10 | Eaton | Michigan | 26045 | 1748 | 19 |
717251 | 717251 | 2020-11-10 | Emmet | Michigan | 26047 | 592 | 16 |
717252 | 717252 | 2020-11-10 | Genesee | Michigan | 26049 | 8998 | 359 |
717253 | 717253 | 2020-11-10 | Gladwin | Michigan | 26051 | 340 | 4 |
717254 | 717254 | 2020-11-10 | Gogebic | Michigan | 26053 | 582 | 17 |
717255 | 717255 | 2020-11-10 | Grand Traverse | Michigan | 26055 | 1098 | 14 |
717256 | 717256 | 2020-11-10 | Gratiot | Michigan | 26057 | 875 | 20 |
717257 | 717257 | 2020-11-10 | Hillsdale | Michigan | 26059 | 810 | 29 |
717258 | 717258 | 2020-11-10 | Houghton | Michigan | 26061 | 1146 | 9 |
717259 | 717259 | 2020-11-10 | Huron | Michigan | 26063 | 400 | 8 |
717260 | 717260 | 2020-11-10 | Ingham | Michigan | 26065 | 5789 | 79 |
717261 | 717261 | 2020-11-10 | Ionia | Michigan | 26067 | 1933 | 9 |
717262 | 717262 | 2020-11-10 | Iosco | Michigan | 26069 | 413 | 18 |
717263 | 717263 | 2020-11-10 | Iron | Michigan | 26071 | 574 | 28 |
717264 | 717264 | 2020-11-10 | Isabella | Michigan | 26073 | 1465 | 16 |
717265 | 717265 | 2020-11-10 | Jackson | Michigan | 26075 | 4433 | 103 |
717266 | 717266 | 2020-11-10 | Kalamazoo | Michigan | 26077 | 6580 | 134 |
717267 | 717267 | 2020-11-10 | Kalkaska | Michigan | 26079 | 203 | 4 |
717268 | 717268 | 2020-11-10 | Kent | Michigan | 26081 | 20890 | 227 |
717269 | 717269 | 2020-11-10 | Keweenaw | Michigan | 26083 | 29 | 1 |
717270 | 717270 | 2020-11-10 | Lake | Michigan | 26085 | 102 | 1 |
717271 | 717271 | 2020-11-10 | Lapeer | Michigan | 26087 | 1593 | 47 |
717272 | 717272 | 2020-11-10 | Leelanau | Michigan | 26089 | 211 | 2 |
717273 | 717273 | 2020-11-10 | Lenawee | Michigan | 26091 | 2225 | 25 |
717274 | 717274 | 2020-11-10 | Livingston | Michigan | 26093 | 3141 | 36 |
717275 | 717275 | 2020-11-10 | Luce | Michigan | 26095 | 537 | 0 |
717276 | 717276 | 2020-11-10 | Mackinac | Michigan | 26097 | 193 | 0 |
717277 | 717277 | 2020-11-10 | Macomb | Michigan | 26099 | 24532 | 1135 |
717278 | 717278 | 2020-11-10 | Manistee | Michigan | 26101 | 215 | 5 |
717279 | 717279 | 2020-11-10 | Marquette | Michigan | 26103 | 2654 | 19 |
717280 | 717280 | 2020-11-10 | Mason | Michigan | 26105 | 378 | 6 |
717281 | 717281 | 2020-11-10 | Mecosta | Michigan | 26107 | 797 | 6 |
717282 | 717282 | 2020-11-10 | Menominee | Michigan | 26109 | 962 | 8 |
717283 | 717283 | 2020-11-10 | Midland | Michigan | 26111 | 1682 | 14 |
717284 | 717284 | 2020-11-10 | Missaukee | Michigan | 26113 | 164 | 1 |
717285 | 717285 | 2020-11-10 | Monroe | Michigan | 26115 | 2951 | 47 |
717286 | 717286 | 2020-11-10 | Montcalm | Michigan | 26117 | 1080 | 16 |
717287 | 717287 | 2020-11-10 | Montmorency | Michigan | 26119 | 60 | 0 |
717288 | 717288 | 2020-11-10 | Muskegon | Michigan | 26121 | 4952 | 106 |
717289 | 717289 | 2020-11-10 | Newaygo | Michigan | 26123 | 961 | 7 |
717290 | 717290 | 2020-11-10 | Oakland | Michigan | 26125 | 31563 | 1259 |
717291 | 717291 | 2020-11-10 | Oceana | Michigan | 26127 | 826 | 8 |
717292 | 717292 | 2020-11-10 | Ogemaw | Michigan | 26129 | 219 | 6 |
717293 | 717293 | 2020-11-10 | Ontonagon | Michigan | 26131 | 217 | 2 |
717294 | 717294 | 2020-11-10 | Osceola | Michigan | 26133 | 289 | 1 |
717295 | 717295 | 2020-11-10 | Oscoda | Michigan | 26135 | 83 | 2 |
717296 | 717296 | 2020-11-10 | Otsego | Michigan | 26137 | 443 | 14 |
717297 | 717297 | 2020-11-10 | Ottawa | Michigan | 26139 | 8032 | 91 |
717298 | 717298 | 2020-11-10 | Presque Isle | Michigan | 26141 | 124 | 1 |
717299 | 717299 | 2020-11-10 | Roscommon | Michigan | 26143 | 302 | 6 |
717300 | 717300 | 2020-11-10 | Saginaw | Michigan | 26145 | 5487 | 165 |
717301 | 717301 | 2020-11-10 | Sanilac | Michigan | 26151 | 354 | 9 |
717302 | 717302 | 2020-11-10 | Schoolcraft | Michigan | 26153 | 132 | 1 |
717303 | 717303 | 2020-11-10 | Shiawassee | Michigan | 26155 | 1112 | 35 |
717304 | 717304 | 2020-11-10 | St. Clair | Michigan | 26147 | 2331 | 68 |
717305 | 717305 | 2020-11-10 | St. Joseph | Michigan | 26149 | 1774 | 25 |
717306 | 717306 | 2020-11-10 | Tuscola | Michigan | 26157 | 1003 | 39 |
717307 | 717307 | 2020-11-10 | Unknown | Michigan | 852 | 3 | |
717308 | 717308 | 2020-11-10 | Van Buren | Michigan | 26159 | 1692 | 22 |
717309 | 717309 | 2020-11-10 | Washtenaw | Michigan | 26161 | 7298 | 131 |
717310 | 717310 | 2020-11-10 | Wayne | Michigan | 26163 | 47389 | 3105 |
717311 | 717311 | 2020-11-10 | Wexford | Michigan | 26165 | 307 | 6 |
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);