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-07-06 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
307254 | 307254 | 2020-07-06 | Alcona | Michigan | 26001 | 22 | 1 |
307255 | 307255 | 2020-07-06 | Alger | Michigan | 26003 | 4 | 0 |
307256 | 307256 | 2020-07-06 | Allegan | Michigan | 26005 | 338 | 7 |
307257 | 307257 | 2020-07-06 | Alpena | Michigan | 26007 | 123 | 12 |
307258 | 307258 | 2020-07-06 | Antrim | Michigan | 26009 | 23 | 0 |
307259 | 307259 | 2020-07-06 | Arenac | Michigan | 26011 | 38 | 2 |
307260 | 307260 | 2020-07-06 | Baraga | Michigan | 26013 | 5 | 0 |
307261 | 307261 | 2020-07-06 | Barry | Michigan | 26015 | 119 | 2 |
307262 | 307262 | 2020-07-06 | Bay | Michigan | 26017 | 405 | 30 |
307263 | 307263 | 2020-07-06 | Benzie | Michigan | 26019 | 11 | 0 |
307264 | 307264 | 2020-07-06 | Berrien | Michigan | 26021 | 991 | 60 |
307265 | 307265 | 2020-07-06 | Branch | Michigan | 26023 | 1053 | 25 |
307266 | 307266 | 2020-07-06 | Calhoun | Michigan | 26025 | 562 | 37 |
307267 | 307267 | 2020-07-06 | Cass | Michigan | 26027 | 164 | 6 |
307268 | 307268 | 2020-07-06 | Charlevoix | Michigan | 26029 | 33 | 2 |
307269 | 307269 | 2020-07-06 | Cheboygan | Michigan | 26031 | 28 | 2 |
307270 | 307270 | 2020-07-06 | Chippewa | Michigan | 26033 | 14 | 0 |
307271 | 307271 | 2020-07-06 | Clare | Michigan | 26035 | 31 | 3 |
307272 | 307272 | 2020-07-06 | Clinton | Michigan | 26037 | 253 | 12 |
307273 | 307273 | 2020-07-06 | Crawford | Michigan | 26039 | 70 | 5 |
307274 | 307274 | 2020-07-06 | Delta | Michigan | 26041 | 27 | 3 |
307275 | 307275 | 2020-07-06 | Dickinson | Michigan | 26043 | 14 | 2 |
307276 | 307276 | 2020-07-06 | Eaton | Michigan | 26045 | 338 | 7 |
307277 | 307277 | 2020-07-06 | Emmet | Michigan | 26047 | 31 | 2 |
307278 | 307278 | 2020-07-06 | Genesee | Michigan | 26049 | 2829 | 288 |
307279 | 307279 | 2020-07-06 | Gladwin | Michigan | 26051 | 27 | 1 |
307280 | 307280 | 2020-07-06 | Gogebic | Michigan | 26053 | 10 | 1 |
307281 | 307281 | 2020-07-06 | Grand Traverse | Michigan | 26055 | 71 | 5 |
307282 | 307282 | 2020-07-06 | Gratiot | Michigan | 26057 | 101 | 13 |
307283 | 307283 | 2020-07-06 | Hillsdale | Michigan | 26059 | 201 | 25 |
307284 | 307284 | 2020-07-06 | Houghton | Michigan | 26061 | 20 | 0 |
307285 | 307285 | 2020-07-06 | Huron | Michigan | 26063 | 66 | 3 |
307286 | 307286 | 2020-07-06 | Ingham | Michigan | 26065 | 1095 | 29 |
307287 | 307287 | 2020-07-06 | Ionia | Michigan | 26067 | 210 | 4 |
307288 | 307288 | 2020-07-06 | Iosco | Michigan | 26069 | 118 | 11 |
307289 | 307289 | 2020-07-06 | Iron | Michigan | 26071 | 6 | 1 |
307290 | 307290 | 2020-07-06 | Isabella | Michigan | 26073 | 136 | 8 |
307291 | 307291 | 2020-07-06 | Jackson | Michigan | 26075 | 2136 | 53 |
307292 | 307292 | 2020-07-06 | Kalamazoo | Michigan | 26077 | 1112 | 68 |
307293 | 307293 | 2020-07-06 | Kalkaska | Michigan | 26079 | 41 | 2 |
307294 | 307294 | 2020-07-06 | Kent | Michigan | 26081 | 5308 | 136 |
307295 | 307295 | 2020-07-06 | Keweenaw | Michigan | 26083 | 1 | 0 |
307296 | 307296 | 2020-07-06 | Lake | Michigan | 26085 | 12 | 0 |
307297 | 307297 | 2020-07-06 | Lapeer | Michigan | 26087 | 615 | 38 |
307298 | 307298 | 2020-07-06 | Leelanau | Michigan | 26089 | 27 | 0 |
307299 | 307299 | 2020-07-06 | Lenawee | Michigan | 26091 | 968 | 11 |
307300 | 307300 | 2020-07-06 | Livingston | Michigan | 26093 | 644 | 29 |
307301 | 307301 | 2020-07-06 | Luce | Michigan | 26095 | 4 | 0 |
307302 | 307302 | 2020-07-06 | Mackinac | Michigan | 26097 | 9 | 0 |
307303 | 307303 | 2020-07-06 | Macomb | Michigan | 26099 | 7820 | 924 |
307304 | 307304 | 2020-07-06 | Manistee | Michigan | 26101 | 37 | 0 |
307305 | 307305 | 2020-07-06 | Marquette | Michigan | 26103 | 76 | 11 |
307306 | 307306 | 2020-07-06 | Mason | Michigan | 26105 | 65 | 0 |
307307 | 307307 | 2020-07-06 | Mecosta | Michigan | 26107 | 32 | 2 |
307308 | 307308 | 2020-07-06 | Menominee | Michigan | 26109 | 24 | 0 |
307309 | 307309 | 2020-07-06 | Midland | Michigan | 26111 | 172 | 9 |
307310 | 307310 | 2020-07-06 | Missaukee | Michigan | 26113 | 34 | 1 |
307311 | 307311 | 2020-07-06 | Monroe | Michigan | 26115 | 641 | 21 |
307312 | 307312 | 2020-07-06 | Montcalm | Michigan | 26117 | 111 | 1 |
307313 | 307313 | 2020-07-06 | Montmorency | Michigan | 26119 | 5 | 0 |
307314 | 307314 | 2020-07-06 | Muskegon | Michigan | 26121 | 861 | 51 |
307315 | 307315 | 2020-07-06 | Newaygo | Michigan | 26123 | 182 | 0 |
307316 | 307316 | 2020-07-06 | Oakland | Michigan | 26125 | 12254 | 1091 |
307317 | 307317 | 2020-07-06 | Oceana | Michigan | 26127 | 347 | 4 |
307318 | 307318 | 2020-07-06 | Ogemaw | Michigan | 26129 | 39 | 2 |
307319 | 307319 | 2020-07-06 | Ontonagon | Michigan | 26131 | 1 | 0 |
307320 | 307320 | 2020-07-06 | Osceola | Michigan | 26133 | 39 | 0 |
307321 | 307321 | 2020-07-06 | Oscoda | Michigan | 26135 | 21 | 1 |
307322 | 307322 | 2020-07-06 | Otsego | Michigan | 26137 | 135 | 10 |
307323 | 307323 | 2020-07-06 | Ottawa | Michigan | 26139 | 1148 | 51 |
307324 | 307324 | 2020-07-06 | Presque Isle | Michigan | 26141 | 13 | 0 |
307325 | 307325 | 2020-07-06 | Roscommon | Michigan | 26143 | 28 | 0 |
307326 | 307326 | 2020-07-06 | Saginaw | Michigan | 26145 | 1342 | 123 |
307327 | 307327 | 2020-07-06 | Sanilac | Michigan | 26151 | 51 | 6 |
307328 | 307328 | 2020-07-06 | Schoolcraft | Michigan | 26153 | 6 | 0 |
307329 | 307329 | 2020-07-06 | Shiawassee | Michigan | 26155 | 278 | 28 |
307330 | 307330 | 2020-07-06 | St. Clair | Michigan | 26147 | 590 | 50 |
307331 | 307331 | 2020-07-06 | St. Joseph | Michigan | 26149 | 352 | 5 |
307332 | 307332 | 2020-07-06 | Tuscola | Michigan | 26157 | 235 | 26 |
307333 | 307333 | 2020-07-06 | Unknown | Michigan | 155 | 2 | |
307334 | 307334 | 2020-07-06 | Van Buren | Michigan | 26159 | 235 | 8 |
307335 | 307335 | 2020-07-06 | Washtenaw | Michigan | 26161 | 2276 | 116 |
307336 | 307336 | 2020-07-06 | Wayne | Michigan | 26163 | 23283 | 2732 |
307337 | 307337 | 2020-07-06 | Wexford | Michigan | 26165 | 51 | 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);