ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-09-26" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
571283 | 571283 | 2020-09-26 | Alcona | Michigan | 26001 | 43 | 2 |
571284 | 571284 | 2020-09-26 | Alger | Michigan | 26003 | 18 | 0 |
571285 | 571285 | 2020-09-26 | Allegan | Michigan | 26005 | 765 | 7 |
571286 | 571286 | 2020-09-26 | Alpena | Michigan | 26007 | 148 | 14 |
571287 | 571287 | 2020-09-26 | Antrim | Michigan | 26009 | 70 | 0 |
571288 | 571288 | 2020-09-26 | Arenac | Michigan | 26011 | 70 | 3 |
571289 | 571289 | 2020-09-26 | Baraga | Michigan | 26013 | 31 | 0 |
571290 | 571290 | 2020-09-26 | Barry | Michigan | 26015 | 306 | 4 |
571291 | 571291 | 2020-09-26 | Bay | Michigan | 26017 | 1006 | 50 |
571292 | 571292 | 2020-09-26 | Benzie | Michigan | 26019 | 79 | 2 |
571293 | 571293 | 2020-09-26 | Berrien | Michigan | 26021 | 1946 | 74 |
571294 | 571294 | 2020-09-26 | Branch | Michigan | 26023 | 1434 | 28 |
571295 | 571295 | 2020-09-26 | Calhoun | Michigan | 26025 | 1357 | 45 |
571296 | 571296 | 2020-09-26 | Cass | Michigan | 26027 | 579 | 16 |
571297 | 571297 | 2020-09-26 | Charlevoix | Michigan | 26029 | 111 | 3 |
571298 | 571298 | 2020-09-26 | Cheboygan | Michigan | 26031 | 91 | 2 |
571299 | 571299 | 2020-09-26 | Chippewa | Michigan | 26033 | 79 | 0 |
571300 | 571300 | 2020-09-26 | Clare | Michigan | 26035 | 112 | 4 |
571301 | 571301 | 2020-09-26 | Clinton | Michigan | 26037 | 677 | 14 |
571302 | 571302 | 2020-09-26 | Crawford | Michigan | 26039 | 124 | 5 |
571303 | 571303 | 2020-09-26 | Delta | Michigan | 26041 | 414 | 7 |
571304 | 571304 | 2020-09-26 | Dickinson | Michigan | 26043 | 131 | 2 |
571305 | 571305 | 2020-09-26 | Eaton | Michigan | 26045 | 664 | 10 |
571306 | 571306 | 2020-09-26 | Emmet | Michigan | 26047 | 157 | 4 |
571307 | 571307 | 2020-09-26 | Genesee | Michigan | 26049 | 4554 | 308 |
571308 | 571308 | 2020-09-26 | Gladwin | Michigan | 26051 | 96 | 2 |
571309 | 571309 | 2020-09-26 | Gogebic | Michigan | 26053 | 160 | 2 |
571310 | 571310 | 2020-09-26 | Grand Traverse | Michigan | 26055 | 482 | 8 |
571311 | 571311 | 2020-09-26 | Gratiot | Michigan | 26057 | 276 | 15 |
571312 | 571312 | 2020-09-26 | Hillsdale | Michigan | 26059 | 348 | 27 |
571313 | 571313 | 2020-09-26 | Houghton | Michigan | 26061 | 475 | 1 |
571314 | 571314 | 2020-09-26 | Huron | Michigan | 26063 | 225 | 5 |
571315 | 571315 | 2020-09-26 | Ingham | Michigan | 26065 | 3506 | 47 |
571316 | 571316 | 2020-09-26 | Ionia | Michigan | 26067 | 525 | 7 |
571317 | 571317 | 2020-09-26 | Iosco | Michigan | 26069 | 219 | 12 |
571318 | 571318 | 2020-09-26 | Iron | Michigan | 26071 | 164 | 2 |
571319 | 571319 | 2020-09-26 | Isabella | Michigan | 26073 | 700 | 13 |
571320 | 571320 | 2020-09-26 | Jackson | Michigan | 26075 | 2814 | 67 |
571321 | 571321 | 2020-09-26 | Kalamazoo | Michigan | 26077 | 2888 | 93 |
571322 | 571322 | 2020-09-26 | Kalkaska | Michigan | 26079 | 85 | 4 |
571323 | 571323 | 2020-09-26 | Kent | Michigan | 26081 | 9849 | 175 |
571324 | 571324 | 2020-09-26 | Keweenaw | Michigan | 26083 | 10 | 0 |
571325 | 571325 | 2020-09-26 | Lake | Michigan | 26085 | 32 | 0 |
571326 | 571326 | 2020-09-26 | Lapeer | Michigan | 26087 | 920 | 43 |
571327 | 571327 | 2020-09-26 | Leelanau | Michigan | 26089 | 112 | 1 |
571328 | 571328 | 2020-09-26 | Lenawee | Michigan | 26091 | 1527 | 22 |
571329 | 571329 | 2020-09-26 | Livingston | Michigan | 26093 | 1419 | 31 |
571330 | 571330 | 2020-09-26 | Luce | Michigan | 26095 | 238 | 0 |
571331 | 571331 | 2020-09-26 | Mackinac | Michigan | 26097 | 59 | 0 |
571332 | 571332 | 2020-09-26 | Macomb | Michigan | 26099 | 14722 | 1026 |
571333 | 571333 | 2020-09-26 | Manistee | Michigan | 26101 | 88 | 2 |
571334 | 571334 | 2020-09-26 | Marquette | Michigan | 26103 | 363 | 12 |
571335 | 571335 | 2020-09-26 | Mason | Michigan | 26105 | 135 | 0 |
571336 | 571336 | 2020-09-26 | Mecosta | Michigan | 26107 | 206 | 3 |
571337 | 571337 | 2020-09-26 | Menominee | Michigan | 26109 | 375 | 1 |
571338 | 571338 | 2020-09-26 | Midland | Michigan | 26111 | 605 | 11 |
571339 | 571339 | 2020-09-26 | Missaukee | Michigan | 26113 | 63 | 1 |
571340 | 571340 | 2020-09-26 | Monroe | Michigan | 26115 | 1513 | 28 |
571341 | 571341 | 2020-09-26 | Montcalm | Michigan | 26117 | 317 | 6 |
571342 | 571342 | 2020-09-26 | Montmorency | Michigan | 26119 | 14 | 0 |
571343 | 571343 | 2020-09-26 | Muskegon | Michigan | 26121 | 2452 | 71 |
571344 | 571344 | 2020-09-26 | Newaygo | Michigan | 26123 | 362 | 2 |
571345 | 571345 | 2020-09-26 | Oakland | Michigan | 26125 | 20543 | 1200 |
571346 | 571346 | 2020-09-26 | Oceana | Michigan | 26127 | 518 | 6 |
571347 | 571347 | 2020-09-26 | Ogemaw | Michigan | 26129 | 67 | 5 |
571348 | 571348 | 2020-09-26 | Ontonagon | Michigan | 26131 | 42 | 0 |
571349 | 571349 | 2020-09-26 | Osceola | Michigan | 26133 | 93 | 0 |
571350 | 571350 | 2020-09-26 | Oscoda | Michigan | 26135 | 30 | 1 |
571351 | 571351 | 2020-09-26 | Otsego | Michigan | 26137 | 186 | 11 |
571352 | 571352 | 2020-09-26 | Ottawa | Michigan | 26139 | 3409 | 66 |
571353 | 571353 | 2020-09-26 | Presque Isle | Michigan | 26141 | 27 | 1 |
571354 | 571354 | 2020-09-26 | Roscommon | Michigan | 26143 | 100 | 4 |
571355 | 571355 | 2020-09-26 | Saginaw | Michigan | 26145 | 2936 | 139 |
571356 | 571356 | 2020-09-26 | Sanilac | Michigan | 26151 | 147 | 7 |
571357 | 571357 | 2020-09-26 | Schoolcraft | Michigan | 26153 | 27 | 0 |
571358 | 571358 | 2020-09-26 | Shiawassee | Michigan | 26155 | 513 | 32 |
571359 | 571359 | 2020-09-26 | St. Clair | Michigan | 26147 | 1012 | 56 |
571360 | 571360 | 2020-09-26 | St. Joseph | Michigan | 26149 | 769 | 11 |
571361 | 571361 | 2020-09-26 | Tuscola | Michigan | 26157 | 509 | 31 |
571362 | 571362 | 2020-09-26 | Unknown | Michigan | 147 | 5 | |
571363 | 571363 | 2020-09-26 | Van Buren | Michigan | 26159 | 763 | 17 |
571364 | 571364 | 2020-09-26 | Washtenaw | Michigan | 26161 | 4050 | 125 |
571365 | 571365 | 2020-09-26 | Wayne | Michigan | 26163 | 35046 | 2979 |
571366 | 571366 | 2020-09-26 | Wexford | Michigan | 26165 | 128 | 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);