ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-11-06" 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 |
---|---|---|---|---|---|---|---|
1889340 | 1889340 | 2021-11-06 | Alcona | Michigan | 26001 | 1187 | 44 |
1889341 | 1889341 | 2021-11-06 | Alger | Michigan | 26003 | 1025 | 9 |
1889342 | 1889342 | 2021-11-06 | Allegan | Michigan | 26005 | 15467 | 199 |
1889343 | 1889343 | 2021-11-06 | Alpena | Michigan | 26007 | 3380 | 73 |
1889344 | 1889344 | 2021-11-06 | Antrim | Michigan | 26009 | 2496 | 38 |
1889345 | 1889345 | 2021-11-06 | Arenac | Michigan | 26011 | 1886 | 36 |
1889346 | 1889346 | 2021-11-06 | Baraga | Michigan | 26013 | 1411 | 47 |
1889347 | 1889347 | 2021-11-06 | Barry | Michigan | 26015 | 8250 | 91 |
1889348 | 1889348 | 2021-11-06 | Bay | Michigan | 26017 | 15489 | 397 |
1889349 | 1889349 | 2021-11-06 | Benzie | Michigan | 26019 | 1739 | 40 |
1889350 | 1889350 | 2021-11-06 | Berrien | Michigan | 26021 | 19813 | 333 |
1889351 | 1889351 | 2021-11-06 | Branch | Michigan | 26023 | 7596 | 137 |
1889352 | 1889352 | 2021-11-06 | Calhoun | Michigan | 26025 | 19429 | 359 |
1889353 | 1889353 | 2021-11-06 | Cass | Michigan | 26027 | 7320 | 93 |
1889354 | 1889354 | 2021-11-06 | Charlevoix | Michigan | 26029 | 2663 | 38 |
1889355 | 1889355 | 2021-11-06 | Cheboygan | Michigan | 26031 | 2991 | 68 |
1889356 | 1889356 | 2021-11-06 | Chippewa | Michigan | 26033 | 7062 | 68 |
1889357 | 1889357 | 2021-11-06 | Clare | Michigan | 26035 | 4023 | 106 |
1889358 | 1889358 | 2021-11-06 | Clinton | Michigan | 26037 | 10606 | 114 |
1889359 | 1889359 | 2021-11-06 | Crawford | Michigan | 26039 | 1457 | 17 |
1889360 | 1889360 | 2021-11-06 | Delta | Michigan | 26041 | 6003 | 110 |
1889361 | 1889361 | 2021-11-06 | Dickinson | Michigan | 26043 | 4121 | 84 |
1889362 | 1889362 | 2021-11-06 | Eaton | Michigan | 26045 | 13793 | 249 |
1889363 | 1889363 | 2021-11-06 | Emmet | Michigan | 26047 | 3564 | 51 |
1889364 | 1889364 | 2021-11-06 | Genesee | Michigan | 26049 | 54081 | 1107 |
1889365 | 1889365 | 2021-11-06 | Gladwin | Michigan | 26051 | 3426 | 77 |
1889366 | 1889366 | 2021-11-06 | Gogebic | Michigan | 26053 | 1865 | 54 |
1889367 | 1889367 | 2021-11-06 | Grand Traverse | Michigan | 26055 | 9338 | 121 |
1889368 | 1889368 | 2021-11-06 | Gratiot | Michigan | 26057 | 9061 | 134 |
1889369 | 1889369 | 2021-11-06 | Hillsdale | Michigan | 26059 | 6439 | 130 |
1889370 | 1889370 | 2021-11-06 | Houghton | Michigan | 26061 | 4408 | 56 |
1889371 | 1889371 | 2021-11-06 | Huron | Michigan | 26063 | 5036 | 96 |
1889372 | 1889372 | 2021-11-06 | Ingham | Michigan | 26065 | 32163 | 461 |
1889373 | 1889373 | 2021-11-06 | Ionia | Michigan | 26067 | 12196 | 109 |
1889374 | 1889374 | 2021-11-06 | Iosco | Michigan | 26069 | 3179 | 98 |
1889375 | 1889375 | 2021-11-06 | Iron | Michigan | 26071 | 1486 | 58 |
1889376 | 1889376 | 2021-11-06 | Isabella | Michigan | 26073 | 9438 | 133 |
1889377 | 1889377 | 2021-11-06 | Jackson | Michigan | 26075 | 27134 | 376 |
1889378 | 1889378 | 2021-11-06 | Kalamazoo | Michigan | 26077 | 30816 | 467 |
1889379 | 1889379 | 2021-11-06 | Kalkaska | Michigan | 26079 | 1860 | 40 |
1889380 | 1889380 | 2021-11-06 | Kent | Michigan | 26081 | 96768 | 1010 |
1889381 | 1889381 | 2021-11-06 | Keweenaw | Michigan | 26083 | 277 | 5 |
1889382 | 1889382 | 2021-11-06 | Lake | Michigan | 26085 | 1015 | 22 |
1889383 | 1889383 | 2021-11-06 | Lapeer | Michigan | 26087 | 12475 | 261 |
1889384 | 1889384 | 2021-11-06 | Leelanau | Michigan | 26089 | 1730 | 26 |
1889385 | 1889385 | 2021-11-06 | Lenawee | Michigan | 26091 | 15303 | 208 |
1889386 | 1889386 | 2021-11-06 | Livingston | Michigan | 26093 | 24308 | 248 |
1889387 | 1889387 | 2021-11-06 | Luce | Michigan | 26095 | 1615 | 6 |
1889388 | 1889388 | 2021-11-06 | Mackinac | Michigan | 26097 | 1335 | 12 |
1889389 | 1889389 | 2021-11-06 | Macomb | Michigan | 26099 | 125652 | 2738 |
1889390 | 1889390 | 2021-11-06 | Manistee | Michigan | 26101 | 2601 | 39 |
1889391 | 1889391 | 2021-11-06 | Marquette | Michigan | 26103 | 8330 | 82 |
1889392 | 1889392 | 2021-11-06 | Mason | Michigan | 26105 | 3341 | 47 |
1889393 | 1889393 | 2021-11-06 | Mecosta | Michigan | 26107 | 4940 | 49 |
1889394 | 1889394 | 2021-11-06 | Menominee | Michigan | 26109 | 3479 | 51 |
1889395 | 1889395 | 2021-11-06 | Midland | Michigan | 26111 | 10766 | 143 |
1889396 | 1889396 | 2021-11-06 | Missaukee | Michigan | 26113 | 1907 | 40 |
1889397 | 1889397 | 2021-11-06 | Monroe | Michigan | 26115 | 21297 | 309 |
1889398 | 1889398 | 2021-11-06 | Montcalm | Michigan | 26117 | 11195 | 137 |
1889399 | 1889399 | 2021-11-06 | Montmorency | Michigan | 26119 | 1040 | 29 |
1889400 | 1889400 | 2021-11-06 | Muskegon | Michigan | 26121 | 24447 | 432 |
1889401 | 1889401 | 2021-11-06 | Newaygo | Michigan | 26123 | 6857 | 84 |
1889402 | 1889402 | 2021-11-06 | Oakland | Michigan | 26125 | 150362 | 2710 |
1889403 | 1889403 | 2021-11-06 | Oceana | Michigan | 26127 | 3848 | 71 |
1889404 | 1889404 | 2021-11-06 | Ogemaw | Michigan | 26129 | 2816 | 62 |
1889405 | 1889405 | 2021-11-06 | Ontonagon | Michigan | 26131 | 649 | 22 |
1889406 | 1889406 | 2021-11-06 | Osceola | Michigan | 26133 | 3201 | 41 |
1889407 | 1889407 | 2021-11-06 | Oscoda | Michigan | 26135 | 1005 | 39 |
1889408 | 1889408 | 2021-11-06 | Otsego | Michigan | 26137 | 3447 | 60 |
1889409 | 1889409 | 2021-11-06 | Ottawa | Michigan | 26139 | 43084 | 513 |
1889410 | 1889410 | 2021-11-06 | Presque Isle | Michigan | 26141 | 1431 | 39 |
1889411 | 1889411 | 2021-11-06 | Roscommon | Michigan | 26143 | 2736 | 67 |
1889412 | 1889412 | 2021-11-06 | Saginaw | Michigan | 26145 | 29495 | 689 |
1889413 | 1889413 | 2021-11-06 | Sanilac | Michigan | 26151 | 5167 | 139 |
1889414 | 1889414 | 2021-11-06 | Schoolcraft | Michigan | 26153 | 862 | 5 |
1889415 | 1889415 | 2021-11-06 | Shiawassee | Michigan | 26155 | 9145 | 132 |
1889416 | 1889416 | 2021-11-06 | St. Clair | Michigan | 26147 | 23124 | 527 |
1889417 | 1889417 | 2021-11-06 | St. Joseph | Michigan | 26149 | 8766 | 121 |
1889418 | 1889418 | 2021-11-06 | Tuscola | Michigan | 26157 | 7741 | 201 |
1889419 | 1889419 | 2021-11-06 | Unknown | Michigan | 1488 | 14 | |
1889420 | 1889420 | 2021-11-06 | Van Buren | Michigan | 26159 | 9635 | 166 |
1889421 | 1889421 | 2021-11-06 | Washtenaw | Michigan | 26161 | 35006 | 340 |
1889422 | 1889422 | 2021-11-06 | Wayne | Michigan | 26163 | 204921 | 5642 |
1889423 | 1889423 | 2021-11-06 | Wexford | Michigan | 26165 | 3883 | 55 |
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);