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 2021-12-28 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2058355 | 2058355 | 2021-12-28 | Alcona | Michigan | 26001 | 1409 | 55 |
2058356 | 2058356 | 2021-12-28 | Alger | Michigan | 26003 | 1231 | 11 |
2058357 | 2058357 | 2021-12-28 | Allegan | Michigan | 26005 | 20135 | 272 |
2058358 | 2058358 | 2021-12-28 | Alpena | Michigan | 26007 | 4526 | 113 |
2058359 | 2058359 | 2021-12-28 | Antrim | Michigan | 26009 | 3129 | 50 |
2058360 | 2058360 | 2021-12-28 | Arenac | Michigan | 26011 | 2353 | 51 |
2058361 | 2058361 | 2021-12-28 | Baraga | Michigan | 26013 | 1660 | 49 |
2058362 | 2058362 | 2021-12-28 | Barry | Michigan | 26015 | 10662 | 131 |
2058363 | 2058363 | 2021-12-28 | Bay | Michigan | 26017 | 19046 | 467 |
2058364 | 2058364 | 2021-12-28 | Benzie | Michigan | 26019 | 2389 | 53 |
2058365 | 2058365 | 2021-12-28 | Berrien | Michigan | 26021 | 25082 | 389 |
2058366 | 2058366 | 2021-12-28 | Branch | Michigan | 26023 | 9325 | 163 |
2058367 | 2058367 | 2021-12-28 | Calhoun | Michigan | 26025 | 24614 | 459 |
2058368 | 2058368 | 2021-12-28 | Cass | Michigan | 26027 | 8963 | 110 |
2058369 | 2058369 | 2021-12-28 | Charlevoix | Michigan | 26029 | 3393 | 52 |
2058370 | 2058370 | 2021-12-28 | Cheboygan | Michigan | 26031 | 3646 | 80 |
2058371 | 2058371 | 2021-12-28 | Chippewa | Michigan | 26033 | 8191 | 80 |
2058372 | 2058372 | 2021-12-28 | Clare | Michigan | 26035 | 5102 | 131 |
2058373 | 2058373 | 2021-12-28 | Clinton | Michigan | 26037 | 14055 | 162 |
2058374 | 2058374 | 2021-12-28 | Crawford | Michigan | 26039 | 1924 | 20 |
2058375 | 2058375 | 2021-12-28 | Delta | Michigan | 26041 | 7104 | 132 |
2058376 | 2058376 | 2021-12-28 | Dickinson | Michigan | 26043 | 5076 | 92 |
2058377 | 2058377 | 2021-12-28 | Eaton | Michigan | 26045 | 18115 | 318 |
2058378 | 2058378 | 2021-12-28 | Emmet | Michigan | 26047 | 4519 | 59 |
2058379 | 2058379 | 2021-12-28 | Genesee | Michigan | 26049 | 71178 | 1324 |
2058380 | 2058380 | 2021-12-28 | Gladwin | Michigan | 26051 | 4110 | 94 |
2058381 | 2058381 | 2021-12-28 | Gogebic | Michigan | 26053 | 2318 | 62 |
2058382 | 2058382 | 2021-12-28 | Grand Traverse | Michigan | 26055 | 12167 | 173 |
2058383 | 2058383 | 2021-12-28 | Gratiot | Michigan | 26057 | 10799 | 162 |
2058384 | 2058384 | 2021-12-28 | Hillsdale | Michigan | 26059 | 8191 | 170 |
2058385 | 2058385 | 2021-12-28 | Houghton | Michigan | 26061 | 5645 | 72 |
2058386 | 2058386 | 2021-12-28 | Huron | Michigan | 26063 | 6264 | 121 |
2058387 | 2058387 | 2021-12-28 | Ingham | Michigan | 26065 | 41392 | 577 |
2058388 | 2058388 | 2021-12-28 | Ionia | Michigan | 26067 | 15078 | 144 |
2058389 | 2058389 | 2021-12-28 | Iosco | Michigan | 26069 | 3779 | 112 |
2058390 | 2058390 | 2021-12-28 | Iron | Michigan | 26071 | 1863 | 70 |
2058391 | 2058391 | 2021-12-28 | Isabella | Michigan | 26073 | 11315 | 160 |
2058392 | 2058392 | 2021-12-28 | Jackson | Michigan | 26075 | 33766 | 457 |
2058393 | 2058393 | 2021-12-28 | Kalamazoo | Michigan | 26077 | 39376 | 540 |
2058394 | 2058394 | 2021-12-28 | Kalkaska | Michigan | 26079 | 2498 | 47 |
2058395 | 2058395 | 2021-12-28 | Kent | Michigan | 26081 | 121287 | 1231 |
2058396 | 2058396 | 2021-12-28 | Keweenaw | Michigan | 26083 | 389 | 11 |
2058397 | 2058397 | 2021-12-28 | Lake | Michigan | 26085 | 1391 | 31 |
2058398 | 2058398 | 2021-12-28 | Lapeer | Michigan | 26087 | 15960 | 328 |
2058399 | 2058399 | 2021-12-28 | Leelanau | Michigan | 26089 | 2461 | 41 |
2058400 | 2058400 | 2021-12-28 | Lenawee | Michigan | 26091 | 19021 | 254 |
2058401 | 2058401 | 2021-12-28 | Livingston | Michigan | 26093 | 32736 | 354 |
2058402 | 2058402 | 2021-12-28 | Luce | Michigan | 26095 | 1881 | 6 |
2058403 | 2058403 | 2021-12-28 | Mackinac | Michigan | 26097 | 1682 | 19 |
2058404 | 2058404 | 2021-12-28 | Macomb | Michigan | 26099 | 162666 | 3181 |
2058405 | 2058405 | 2021-12-28 | Manistee | Michigan | 26101 | 3286 | 63 |
2058406 | 2058406 | 2021-12-28 | Marquette | Michigan | 26103 | 9950 | 96 |
2058407 | 2058407 | 2021-12-28 | Mason | Michigan | 26105 | 4739 | 66 |
2058408 | 2058408 | 2021-12-28 | Mecosta | Michigan | 26107 | 6349 | 85 |
2058409 | 2058409 | 2021-12-28 | Menominee | Michigan | 26109 | 4189 | 60 |
2058410 | 2058410 | 2021-12-28 | Midland | Michigan | 26111 | 13425 | 181 |
2058411 | 2058411 | 2021-12-28 | Missaukee | Michigan | 26113 | 2233 | 46 |
2058412 | 2058412 | 2021-12-28 | Monroe | Michigan | 26115 | 26834 | 369 |
2058413 | 2058413 | 2021-12-28 | Montcalm | Michigan | 26117 | 13673 | 168 |
2058414 | 2058414 | 2021-12-28 | Montmorency | Michigan | 26119 | 1339 | 41 |
2058415 | 2058415 | 2021-12-28 | Muskegon | Michigan | 26121 | 31219 | 519 |
2058416 | 2058416 | 2021-12-28 | Newaygo | Michigan | 26123 | 8778 | 129 |
2058417 | 2058417 | 2021-12-28 | Oakland | Michigan | 26125 | 194971 | 3071 |
2058418 | 2058418 | 2021-12-28 | Oceana | Michigan | 26127 | 4896 | 84 |
2058419 | 2058419 | 2021-12-28 | Ogemaw | Michigan | 26129 | 3314 | 80 |
2058420 | 2058420 | 2021-12-28 | Ontonagon | Michigan | 26131 | 747 | 27 |
2058421 | 2058421 | 2021-12-28 | Osceola | Michigan | 26133 | 3872 | 61 |
2058422 | 2058422 | 2021-12-28 | Oscoda | Michigan | 26135 | 1168 | 50 |
2058423 | 2058423 | 2021-12-28 | Otsego | Michigan | 26137 | 4293 | 78 |
2058424 | 2058424 | 2021-12-28 | Ottawa | Michigan | 26139 | 54992 | 641 |
2058425 | 2058425 | 2021-12-28 | Presque Isle | Michigan | 26141 | 1732 | 50 |
2058426 | 2058426 | 2021-12-28 | Roscommon | Michigan | 26143 | 3632 | 99 |
2058427 | 2058427 | 2021-12-28 | Saginaw | Michigan | 26145 | 36748 | 788 |
2058428 | 2058428 | 2021-12-28 | Sanilac | Michigan | 26151 | 6759 | 164 |
2058429 | 2058429 | 2021-12-28 | Schoolcraft | Michigan | 26153 | 1198 | 8 |
2058430 | 2058430 | 2021-12-28 | Shiawassee | Michigan | 26155 | 12590 | 182 |
2058431 | 2058431 | 2021-12-28 | St. Clair | Michigan | 26147 | 30414 | 642 |
2058432 | 2058432 | 2021-12-28 | St. Joseph | Michigan | 26149 | 10794 | 157 |
2058433 | 2058433 | 2021-12-28 | Tuscola | Michigan | 26157 | 9919 | 235 |
2058434 | 2058434 | 2021-12-28 | Unknown | Michigan | 2456 | 26 | |
2058435 | 2058435 | 2021-12-28 | Van Buren | Michigan | 26159 | 12600 | 207 |
2058436 | 2058436 | 2021-12-28 | Washtenaw | Michigan | 26161 | 45441 | 401 |
2058437 | 2058437 | 2021-12-28 | Wayne | Michigan | 26163 | 268864 | 6411 |
2058438 | 2058438 | 2021-12-28 | Wexford | Michigan | 26165 | 5037 | 84 |
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);