ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where date = "2020-04-29" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
99313 | 99313 | 2020-04-29 | Alcona | Michigan | 26001 | 4 | 0 |
99314 | 99314 | 2020-04-29 | Allegan | Michigan | 26005 | 94 | 2 |
99315 | 99315 | 2020-04-29 | Alpena | Michigan | 26007 | 76 | 4 |
99316 | 99316 | 2020-04-29 | Antrim | Michigan | 26009 | 10 | 0 |
99317 | 99317 | 2020-04-29 | Arenac | Michigan | 26011 | 18 | 1 |
99318 | 99318 | 2020-04-29 | Baraga | Michigan | 26013 | 1 | 0 |
99319 | 99319 | 2020-04-29 | Barry | Michigan | 26015 | 34 | 1 |
99320 | 99320 | 2020-04-29 | Bay | Michigan | 26017 | 142 | 4 |
99321 | 99321 | 2020-04-29 | Benzie | Michigan | 26019 | 6 | 0 |
99322 | 99322 | 2020-04-29 | Berrien | Michigan | 26021 | 242 | 15 |
99323 | 99323 | 2020-04-29 | Branch | Michigan | 26023 | 841 | 15 |
99324 | 99324 | 2020-04-29 | Calhoun | Michigan | 26025 | 219 | 11 |
99325 | 99325 | 2020-04-29 | Cass | Michigan | 26027 | 29 | 2 |
99326 | 99326 | 2020-04-29 | Charlevoix | Michigan | 26029 | 13 | 1 |
99327 | 99327 | 2020-04-29 | Cheboygan | Michigan | 26031 | 17 | 1 |
99328 | 99328 | 2020-04-29 | Chippewa | Michigan | 26033 | 3 | 0 |
99329 | 99329 | 2020-04-29 | Clare | Michigan | 26035 | 11 | 1 |
99330 | 99330 | 2020-04-29 | Clinton | Michigan | 26037 | 117 | 9 |
99331 | 99331 | 2020-04-29 | Crawford | Michigan | 26039 | 54 | 4 |
99332 | 99332 | 2020-04-29 | Delta | Michigan | 26041 | 13 | 2 |
99333 | 99333 | 2020-04-29 | Dickinson | Michigan | 26043 | 3 | 2 |
99334 | 99334 | 2020-04-29 | Eaton | Michigan | 26045 | 124 | 6 |
99335 | 99335 | 2020-04-29 | Emmet | Michigan | 26047 | 21 | 2 |
99336 | 99336 | 2020-04-29 | Genesee | Michigan | 26049 | 1564 | 180 |
99337 | 99337 | 2020-04-29 | Gladwin | Michigan | 26051 | 16 | 1 |
99338 | 99338 | 2020-04-29 | Gogebic | Michigan | 26053 | 4 | 1 |
99339 | 99339 | 2020-04-29 | Grand Traverse | Michigan | 26055 | 19 | 5 |
99340 | 99340 | 2020-04-29 | Gratiot | Michigan | 26057 | 13 | 1 |
99341 | 99341 | 2020-04-29 | Hillsdale | Michigan | 26059 | 121 | 17 |
99342 | 99342 | 2020-04-29 | Houghton | Michigan | 26061 | 2 | 0 |
99343 | 99343 | 2020-04-29 | Huron | Michigan | 26063 | 16 | 0 |
99344 | 99344 | 2020-04-29 | Ingham | Michigan | 26065 | 446 | 10 |
99345 | 99345 | 2020-04-29 | Ionia | Michigan | 26067 | 62 | 2 |
99346 | 99346 | 2020-04-29 | Iosco | Michigan | 26069 | 47 | 4 |
99347 | 99347 | 2020-04-29 | Isabella | Michigan | 26073 | 60 | 7 |
99348 | 99348 | 2020-04-29 | Jackson | Michigan | 26075 | 717 | 33 |
99349 | 99349 | 2020-04-29 | Kalamazoo | Michigan | 26077 | 348 | 12 |
99350 | 99350 | 2020-04-29 | Kalkaska | Michigan | 26079 | 17 | 2 |
99351 | 99351 | 2020-04-29 | Kent | Michigan | 26081 | 1397 | 33 |
99352 | 99352 | 2020-04-29 | Lake | Michigan | 26085 | 2 | 0 |
99353 | 99353 | 2020-04-29 | Lapeer | Michigan | 26087 | 196 | 26 |
99354 | 99354 | 2020-04-29 | Leelanau | Michigan | 26089 | 10 | 0 |
99355 | 99355 | 2020-04-29 | Lenawee | Michigan | 26091 | 108 | 1 |
99356 | 99356 | 2020-04-29 | Livingston | Michigan | 26093 | 343 | 19 |
99357 | 99357 | 2020-04-29 | Luce | Michigan | 26095 | 2 | 0 |
99358 | 99358 | 2020-04-29 | Mackinac | Michigan | 26097 | 6 | 0 |
99359 | 99359 | 2020-04-29 | Macomb | Michigan | 26099 | 5521 | 602 |
99360 | 99360 | 2020-04-29 | Manistee | Michigan | 26101 | 11 | 0 |
99361 | 99361 | 2020-04-29 | Marquette | Michigan | 26103 | 45 | 8 |
99362 | 99362 | 2020-04-29 | Mason | Michigan | 26105 | 8 | 0 |
99363 | 99363 | 2020-04-29 | Mecosta | Michigan | 26107 | 14 | 1 |
99364 | 99364 | 2020-04-29 | Menominee | Michigan | 26109 | 5 | 0 |
99365 | 99365 | 2020-04-29 | Midland | Michigan | 26111 | 59 | 5 |
99366 | 99366 | 2020-04-29 | Missaukee | Michigan | 26113 | 15 | 1 |
99367 | 99367 | 2020-04-29 | Monroe | Michigan | 26115 | 284 | 12 |
99368 | 99368 | 2020-04-29 | Montcalm | Michigan | 26117 | 38 | 1 |
99369 | 99369 | 2020-04-29 | Montmorency | Michigan | 26119 | 5 | 0 |
99370 | 99370 | 2020-04-29 | Muskegon | Michigan | 26121 | 262 | 16 |
99371 | 99371 | 2020-04-29 | Newaygo | Michigan | 26123 | 22 | 0 |
99372 | 99372 | 2020-04-29 | Oakland | Michigan | 26125 | 7159 | 668 |
99373 | 99373 | 2020-04-29 | Oceana | Michigan | 26127 | 9 | 1 |
99374 | 99374 | 2020-04-29 | Ogemaw | Michigan | 26129 | 12 | 0 |
99375 | 99375 | 2020-04-29 | Osceola | Michigan | 26133 | 8 | 0 |
99376 | 99376 | 2020-04-29 | Oscoda | Michigan | 26135 | 4 | 0 |
99377 | 99377 | 2020-04-29 | Otsego | Michigan | 26137 | 90 | 8 |
99378 | 99378 | 2020-04-29 | Ottawa | Michigan | 26139 | 224 | 9 |
99379 | 99379 | 2020-04-29 | Presque Isle | Michigan | 26141 | 12 | 0 |
99380 | 99380 | 2020-04-29 | Roscommon | Michigan | 26143 | 15 | 0 |
99381 | 99381 | 2020-04-29 | Saginaw | Michigan | 26145 | 633 | 56 |
99382 | 99382 | 2020-04-29 | Sanilac | Michigan | 26151 | 34 | 4 |
99383 | 99383 | 2020-04-29 | Schoolcraft | Michigan | 26153 | 3 | 0 |
99384 | 99384 | 2020-04-29 | Shiawassee | Michigan | 26155 | 173 | 8 |
99385 | 99385 | 2020-04-29 | St. Clair | Michigan | 26147 | 313 | 21 |
99386 | 99386 | 2020-04-29 | St. Joseph | Michigan | 26149 | 30 | 1 |
99387 | 99387 | 2020-04-29 | Tuscola | Michigan | 26157 | 98 | 13 |
99388 | 99388 | 2020-04-29 | Unknown | Michigan | 0 | 2 | |
99389 | 99389 | 2020-04-29 | Van Buren | Michigan | 26159 | 46 | 2 |
99390 | 99390 | 2020-04-29 | Washtenaw | Michigan | 26161 | 1159 | 63 |
99391 | 99391 | 2020-04-29 | Wayne | Michigan | 26163 | 16514 | 1729 |
99392 | 99392 | 2020-04-29 | Wexford | Michigan | 26165 | 10 | 2 |
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);