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-09-01 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
490380 | 490380 | 2020-09-01 | Alcona | Michigan | 26001 | 36 | 2 |
490381 | 490381 | 2020-09-01 | Alger | Michigan | 26003 | 17 | 0 |
490382 | 490382 | 2020-09-01 | Allegan | Michigan | 26005 | 644 | 6 |
490383 | 490383 | 2020-09-01 | Alpena | Michigan | 26007 | 133 | 14 |
490384 | 490384 | 2020-09-01 | Antrim | Michigan | 26009 | 60 | 0 |
490385 | 490385 | 2020-09-01 | Arenac | Michigan | 26011 | 59 | 3 |
490386 | 490386 | 2020-09-01 | Baraga | Michigan | 26013 | 8 | 0 |
490387 | 490387 | 2020-09-01 | Barry | Michigan | 26015 | 216 | 2 |
490388 | 490388 | 2020-09-01 | Bay | Michigan | 26017 | 831 | 41 |
490389 | 490389 | 2020-09-01 | Benzie | Michigan | 26019 | 47 | 2 |
490390 | 490390 | 2020-09-01 | Berrien | Michigan | 26021 | 1691 | 70 |
490391 | 490391 | 2020-09-01 | Branch | Michigan | 26023 | 1306 | 26 |
490392 | 490392 | 2020-09-01 | Calhoun | Michigan | 26025 | 1004 | 44 |
490393 | 490393 | 2020-09-01 | Cass | Michigan | 26027 | 417 | 16 |
490394 | 490394 | 2020-09-01 | Charlevoix | Michigan | 26029 | 79 | 3 |
490395 | 490395 | 2020-09-01 | Cheboygan | Michigan | 26031 | 80 | 2 |
490396 | 490396 | 2020-09-01 | Chippewa | Michigan | 26033 | 59 | 0 |
490397 | 490397 | 2020-09-01 | Clare | Michigan | 26035 | 101 | 4 |
490398 | 490398 | 2020-09-01 | Clinton | Michigan | 26037 | 499 | 13 |
490399 | 490399 | 2020-09-01 | Crawford | Michigan | 26039 | 113 | 5 |
490400 | 490400 | 2020-09-01 | Delta | Michigan | 26041 | 160 | 3 |
490401 | 490401 | 2020-09-01 | Dickinson | Michigan | 26043 | 65 | 2 |
490402 | 490402 | 2020-09-01 | Eaton | Michigan | 26045 | 518 | 9 |
490403 | 490403 | 2020-09-01 | Emmet | Michigan | 26047 | 127 | 3 |
490404 | 490404 | 2020-09-01 | Genesee | Michigan | 26049 | 3980 | 305 |
490405 | 490405 | 2020-09-01 | Gladwin | Michigan | 26051 | 79 | 2 |
490406 | 490406 | 2020-09-01 | Gogebic | Michigan | 26053 | 144 | 1 |
490407 | 490407 | 2020-09-01 | Grand Traverse | Michigan | 26055 | 360 | 7 |
490408 | 490408 | 2020-09-01 | Gratiot | Michigan | 26057 | 195 | 15 |
490409 | 490409 | 2020-09-01 | Hillsdale | Michigan | 26059 | 304 | 26 |
490410 | 490410 | 2020-09-01 | Houghton | Michigan | 26061 | 80 | 1 |
490411 | 490411 | 2020-09-01 | Huron | Michigan | 26063 | 203 | 4 |
490412 | 490412 | 2020-09-01 | Ingham | Michigan | 26065 | 1796 | 40 |
490413 | 490413 | 2020-09-01 | Ionia | Michigan | 26067 | 304 | 7 |
490414 | 490414 | 2020-09-01 | Iosco | Michigan | 26069 | 143 | 12 |
490415 | 490415 | 2020-09-01 | Iron | Michigan | 26071 | 35 | 1 |
490416 | 490416 | 2020-09-01 | Isabella | Michigan | 26073 | 507 | 9 |
490417 | 490417 | 2020-09-01 | Jackson | Michigan | 26075 | 2570 | 62 |
490418 | 490418 | 2020-09-01 | Kalamazoo | Michigan | 26077 | 1965 | 88 |
490419 | 490419 | 2020-09-01 | Kalkaska | Michigan | 26079 | 66 | 4 |
490420 | 490420 | 2020-09-01 | Kent | Michigan | 26081 | 8537 | 168 |
490421 | 490421 | 2020-09-01 | Keweenaw | Michigan | 26083 | 2 | 0 |
490422 | 490422 | 2020-09-01 | Lake | Michigan | 26085 | 29 | 0 |
490423 | 490423 | 2020-09-01 | Lapeer | Michigan | 26087 | 843 | 42 |
490424 | 490424 | 2020-09-01 | Leelanau | Michigan | 26089 | 92 | 1 |
490425 | 490425 | 2020-09-01 | Lenawee | Michigan | 26091 | 1330 | 17 |
490426 | 490426 | 2020-09-01 | Livingston | Michigan | 26093 | 1174 | 30 |
490427 | 490427 | 2020-09-01 | Luce | Michigan | 26095 | 121 | 0 |
490428 | 490428 | 2020-09-01 | Mackinac | Michigan | 26097 | 37 | 0 |
490429 | 490429 | 2020-09-01 | Macomb | Michigan | 26099 | 13126 | 974 |
490430 | 490430 | 2020-09-01 | Manistee | Michigan | 26101 | 67 | 1 |
490431 | 490431 | 2020-09-01 | Marquette | Michigan | 26103 | 248 | 11 |
490432 | 490432 | 2020-09-01 | Mason | Michigan | 26105 | 121 | 0 |
490433 | 490433 | 2020-09-01 | Mecosta | Michigan | 26107 | 92 | 2 |
490434 | 490434 | 2020-09-01 | Menominee | Michigan | 26109 | 253 | 0 |
490435 | 490435 | 2020-09-01 | Midland | Michigan | 26111 | 425 | 11 |
490436 | 490436 | 2020-09-01 | Missaukee | Michigan | 26113 | 47 | 1 |
490437 | 490437 | 2020-09-01 | Monroe | Michigan | 26115 | 1325 | 27 |
490438 | 490438 | 2020-09-01 | Montcalm | Michigan | 26117 | 232 | 4 |
490439 | 490439 | 2020-09-01 | Montmorency | Michigan | 26119 | 12 | 0 |
490440 | 490440 | 2020-09-01 | Muskegon | Michigan | 26121 | 1958 | 68 |
490441 | 490441 | 2020-09-01 | Newaygo | Michigan | 26123 | 300 | 1 |
490442 | 490442 | 2020-09-01 | Oakland | Michigan | 26125 | 18168 | 1165 |
490443 | 490443 | 2020-09-01 | Oceana | Michigan | 26127 | 501 | 6 |
490444 | 490444 | 2020-09-01 | Ogemaw | Michigan | 26129 | 58 | 5 |
490445 | 490445 | 2020-09-01 | Ontonagon | Michigan | 26131 | 35 | 0 |
490446 | 490446 | 2020-09-01 | Osceola | Michigan | 26133 | 79 | 0 |
490447 | 490447 | 2020-09-01 | Oscoda | Michigan | 26135 | 29 | 1 |
490448 | 490448 | 2020-09-01 | Otsego | Michigan | 26137 | 157 | 11 |
490449 | 490449 | 2020-09-01 | Ottawa | Michigan | 26139 | 2245 | 63 |
490450 | 490450 | 2020-09-01 | Presque Isle | Michigan | 26141 | 21 | 1 |
490451 | 490451 | 2020-09-01 | Roscommon | Michigan | 26143 | 76 | 4 |
490452 | 490452 | 2020-09-01 | Saginaw | Michigan | 26145 | 2543 | 132 |
490453 | 490453 | 2020-09-01 | Sanilac | Michigan | 26151 | 126 | 7 |
490454 | 490454 | 2020-09-01 | Schoolcraft | Michigan | 26153 | 15 | 0 |
490455 | 490455 | 2020-09-01 | Shiawassee | Michigan | 26155 | 435 | 30 |
490456 | 490456 | 2020-09-01 | St. Clair | Michigan | 26147 | 934 | 53 |
490457 | 490457 | 2020-09-01 | St. Joseph | Michigan | 26149 | 685 | 11 |
490458 | 490458 | 2020-09-01 | Tuscola | Michigan | 26157 | 455 | 29 |
490459 | 490459 | 2020-09-01 | Unknown | Michigan | 459 | 5 | |
490460 | 490460 | 2020-09-01 | Van Buren | Michigan | 26159 | 637 | 16 |
490461 | 490461 | 2020-09-01 | Washtenaw | Michigan | 26161 | 3448 | 124 |
490462 | 490462 | 2020-09-01 | Wayne | Michigan | 26163 | 31382 | 2891 |
490463 | 490463 | 2020-09-01 | Wexford | Michigan | 26165 | 109 | 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);