ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-01-31" 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 |
---|---|---|---|---|---|---|---|
983341 | 983341 | 2021-01-31 | Alcona | Michigan | 26001 | 409 | 23 |
983342 | 983342 | 2021-01-31 | Alger | Michigan | 26003 | 563 | 3 |
983343 | 983343 | 2021-01-31 | Allegan | Michigan | 26005 | 6918 | 106 |
983344 | 983344 | 2021-01-31 | Alpena | Michigan | 26007 | 1416 | 45 |
983345 | 983345 | 2021-01-31 | Antrim | Michigan | 26009 | 850 | 17 |
983346 | 983346 | 2021-01-31 | Arenac | Michigan | 26011 | 701 | 23 |
983347 | 983347 | 2021-01-31 | Baraga | Michigan | 26013 | 749 | 32 |
983348 | 983348 | 2021-01-31 | Barry | Michigan | 26015 | 3538 | 40 |
983349 | 983349 | 2021-01-31 | Bay | Michigan | 26017 | 7097 | 263 |
983350 | 983350 | 2021-01-31 | Benzie | Michigan | 26019 | 862 | 30 |
983351 | 983351 | 2021-01-31 | Berrien | Michigan | 26021 | 10898 | 224 |
983352 | 983352 | 2021-01-31 | Branch | Michigan | 26023 | 4459 | 105 |
983353 | 983353 | 2021-01-31 | Calhoun | Michigan | 26025 | 8913 | 217 |
983354 | 983354 | 2021-01-31 | Cass | Michigan | 26027 | 3737 | 57 |
983355 | 983355 | 2021-01-31 | Charlevoix | Michigan | 26029 | 986 | 12 |
983356 | 983356 | 2021-01-31 | Cheboygan | Michigan | 26031 | 854 | 34 |
983357 | 983357 | 2021-01-31 | Chippewa | Michigan | 26033 | 4575 | 35 |
983358 | 983358 | 2021-01-31 | Clare | Michigan | 26035 | 1493 | 68 |
983359 | 983359 | 2021-01-31 | Clinton | Michigan | 26037 | 4727 | 66 |
983360 | 983360 | 2021-01-31 | Crawford | Michigan | 26039 | 556 | 5 |
983361 | 983361 | 2021-01-31 | Delta | Michigan | 26041 | 3074 | 82 |
983362 | 983362 | 2021-01-31 | Dickinson | Michigan | 26043 | 2331 | 69 |
983363 | 983363 | 2021-01-31 | Eaton | Michigan | 26045 | 5845 | 135 |
983364 | 983364 | 2021-01-31 | Emmet | Michigan | 26047 | 1397 | 35 |
983365 | 983365 | 2021-01-31 | Genesee | Michigan | 26049 | 24327 | 728 |
983366 | 983366 | 2021-01-31 | Gladwin | Michigan | 26051 | 1416 | 42 |
983367 | 983367 | 2021-01-31 | Gogebic | Michigan | 26053 | 1170 | 44 |
983368 | 983368 | 2021-01-31 | Grand Traverse | Michigan | 26055 | 3939 | 57 |
983369 | 983369 | 2021-01-31 | Gratiot | Michigan | 26057 | 5574 | 98 |
983370 | 983370 | 2021-01-31 | Hillsdale | Michigan | 26059 | 3132 | 68 |
983371 | 983371 | 2021-01-31 | Houghton | Michigan | 26061 | 2474 | 38 |
983372 | 983372 | 2021-01-31 | Huron | Michigan | 26063 | 1989 | 53 |
983373 | 983373 | 2021-01-31 | Ingham | Michigan | 26065 | 15006 | 260 |
983374 | 983374 | 2021-01-31 | Ionia | Michigan | 26067 | 6087 | 67 |
983375 | 983375 | 2021-01-31 | Iosco | Michigan | 26069 | 1250 | 62 |
983376 | 983376 | 2021-01-31 | Iron | Michigan | 26071 | 912 | 46 |
983377 | 983377 | 2021-01-31 | Isabella | Michigan | 26073 | 3842 | 69 |
983378 | 983378 | 2021-01-31 | Jackson | Michigan | 26075 | 13332 | 230 |
983379 | 983379 | 2021-01-31 | Kalamazoo | Michigan | 26077 | 14219 | 309 |
983380 | 983380 | 2021-01-31 | Kalkaska | Michigan | 26079 | 554 | 14 |
983381 | 983381 | 2021-01-31 | Kent | Michigan | 26081 | 49248 | 656 |
983382 | 983382 | 2021-01-31 | Keweenaw | Michigan | 26083 | 130 | 2 |
983383 | 983383 | 2021-01-31 | Lake | Michigan | 26085 | 345 | 11 |
983384 | 983384 | 2021-01-31 | Lapeer | Michigan | 26087 | 5062 | 122 |
983385 | 983385 | 2021-01-31 | Leelanau | Michigan | 26089 | 821 | 11 |
983386 | 983386 | 2021-01-31 | Lenawee | Michigan | 26091 | 7139 | 99 |
983387 | 983387 | 2021-01-31 | Livingston | Michigan | 26093 | 9645 | 113 |
983388 | 983388 | 2021-01-31 | Luce | Michigan | 26095 | 1061 | 2 |
983389 | 983389 | 2021-01-31 | Mackinac | Michigan | 26097 | 421 | 3 |
983390 | 983390 | 2021-01-31 | Macomb | Michigan | 26099 | 56229 | 1865 |
983391 | 983391 | 2021-01-31 | Manistee | Michigan | 26101 | 971 | 20 |
983392 | 983392 | 2021-01-31 | Marquette | Michigan | 26103 | 4735 | 54 |
983393 | 983393 | 2021-01-31 | Mason | Michigan | 26105 | 1178 | 26 |
983394 | 983394 | 2021-01-31 | Mecosta | Michigan | 26107 | 1869 | 18 |
983395 | 983395 | 2021-01-31 | Menominee | Michigan | 26109 | 1847 | 35 |
983396 | 983396 | 2021-01-31 | Midland | Michigan | 26111 | 4721 | 56 |
983397 | 983397 | 2021-01-31 | Missaukee | Michigan | 26113 | 680 | 16 |
983398 | 983398 | 2021-01-31 | Monroe | Michigan | 26115 | 9168 | 181 |
983399 | 983399 | 2021-01-31 | Montcalm | Michigan | 26117 | 5451 | 90 |
983400 | 983400 | 2021-01-31 | Montmorency | Michigan | 26119 | 348 | 17 |
983401 | 983401 | 2021-01-31 | Muskegon | Michigan | 26121 | 12374 | 309 |
983402 | 983402 | 2021-01-31 | Newaygo | Michigan | 26123 | 2633 | 44 |
983403 | 983403 | 2021-01-31 | Oakland | Michigan | 26125 | 70447 | 1898 |
983404 | 983404 | 2021-01-31 | Oceana | Michigan | 26127 | 1813 | 48 |
983405 | 983405 | 2021-01-31 | Ogemaw | Michigan | 26129 | 1080 | 30 |
983406 | 983406 | 2021-01-31 | Ontonagon | Michigan | 26131 | 371 | 18 |
983407 | 983407 | 2021-01-31 | Osceola | Michigan | 26133 | 987 | 22 |
983408 | 983408 | 2021-01-31 | Oscoda | Michigan | 26135 | 375 | 18 |
983409 | 983409 | 2021-01-31 | Otsego | Michigan | 26137 | 1100 | 25 |
983410 | 983410 | 2021-01-31 | Ottawa | Michigan | 26139 | 21288 | 334 |
983411 | 983411 | 2021-01-31 | Presque Isle | Michigan | 26141 | 621 | 23 |
983412 | 983412 | 2021-01-31 | Roscommon | Michigan | 26143 | 1087 | 31 |
983413 | 983413 | 2021-01-31 | Saginaw | Michigan | 26145 | 15176 | 470 |
983414 | 983414 | 2021-01-31 | Sanilac | Michigan | 26151 | 1874 | 73 |
983415 | 983415 | 2021-01-31 | Schoolcraft | Michigan | 26153 | 251 | 5 |
983416 | 983416 | 2021-01-31 | Shiawassee | Michigan | 26155 | 3557 | 72 |
983417 | 983417 | 2021-01-31 | St. Clair | Michigan | 26147 | 8251 | 231 |
983418 | 983418 | 2021-01-31 | St. Joseph | Michigan | 26149 | 4408 | 75 |
983419 | 983419 | 2021-01-31 | Tuscola | Michigan | 26157 | 3060 | 127 |
983420 | 983420 | 2021-01-31 | Unknown | Michigan | 0 | 23 | |
983421 | 983421 | 2021-01-31 | Van Buren | Michigan | 26159 | 4728 | 94 |
983422 | 983422 | 2021-01-31 | Washtenaw | Michigan | 26161 | 17165 | 234 |
983423 | 983423 | 2021-01-31 | Wayne | Michigan | 26163 | 96712 | 3984 |
983424 | 983424 | 2021-01-31 | Wexford | Michigan | 26165 | 1303 | 20 |
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);