ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2022-04-22" 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 |
---|---|---|---|---|---|---|---|
2432430 | 2432430 | 2022-04-22 | Alcona | Michigan | 26001 | 1731 | 71 |
2432431 | 2432431 | 2022-04-22 | Alger | Michigan | 26003 | 1867 | 13 |
2432432 | 2432432 | 2022-04-22 | Allegan | Michigan | 26005 | 27133 | 346 |
2432433 | 2432433 | 2022-04-22 | Alpena | Michigan | 26007 | 5699 | 138 |
2432434 | 2432434 | 2022-04-22 | Antrim | Michigan | 26009 | 4355 | 64 |
2432435 | 2432435 | 2022-04-22 | Arenac | Michigan | 26011 | 3200 | 67 |
2432436 | 2432436 | 2022-04-22 | Baraga | Michigan | 26013 | 2210 | 54 |
2432437 | 2432437 | 2022-04-22 | Barry | Michigan | 26015 | 14350 | 167 |
2432438 | 2432438 | 2022-04-22 | Bay | Michigan | 26017 | 27082 | 581 |
2432439 | 2432439 | 2022-04-22 | Benzie | Michigan | 26019 | 3440 | 66 |
2432440 | 2432440 | 2022-04-22 | Berrien | Michigan | 26021 | 34849 | 551 |
2432441 | 2432441 | 2022-04-22 | Branch | Michigan | 26023 | 12185 | 205 |
2432442 | 2432442 | 2022-04-22 | Calhoun | Michigan | 26025 | 34338 | 574 |
2432443 | 2432443 | 2022-04-22 | Cass | Michigan | 26027 | 11116 | 144 |
2432444 | 2432444 | 2022-04-22 | Charlevoix | Michigan | 26029 | 4922 | 60 |
2432445 | 2432445 | 2022-04-22 | Cheboygan | Michigan | 26031 | 4607 | 103 |
2432446 | 2432446 | 2022-04-22 | Chippewa | Michigan | 26033 | 11643 | 120 |
2432447 | 2432447 | 2022-04-22 | Clare | Michigan | 26035 | 6748 | 156 |
2432448 | 2432448 | 2022-04-22 | Clinton | Michigan | 26037 | 21354 | 208 |
2432449 | 2432449 | 2022-04-22 | Crawford | Michigan | 26039 | 2576 | 30 |
2432450 | 2432450 | 2022-04-22 | Delta | Michigan | 26041 | 9935 | 157 |
2432451 | 2432451 | 2022-04-22 | Dickinson | Michigan | 26043 | 7372 | 108 |
2432452 | 2432452 | 2022-04-22 | Eaton | Michigan | 26045 | 26926 | 400 |
2432453 | 2432453 | 2022-04-22 | Emmet | Michigan | 26047 | 6423 | 86 |
2432454 | 2432454 | 2022-04-22 | Genesee | Michigan | 26049 | 101611 | 1711 |
2432455 | 2432455 | 2022-04-22 | Gladwin | Michigan | 26051 | 5566 | 113 |
2432456 | 2432456 | 2022-04-22 | Gogebic | Michigan | 26053 | 3265 | 69 |
2432457 | 2432457 | 2022-04-22 | Grand Traverse | Michigan | 26055 | 17342 | 233 |
2432458 | 2432458 | 2022-04-22 | Gratiot | Michigan | 26057 | 13698 | 192 |
2432459 | 2432459 | 2022-04-22 | Hillsdale | Michigan | 26059 | 10342 | 204 |
2432460 | 2432460 | 2022-04-22 | Houghton | Michigan | 26061 | 7836 | 92 |
2432461 | 2432461 | 2022-04-22 | Huron | Michigan | 26063 | 8011 | 145 |
2432462 | 2432462 | 2022-04-22 | Ingham | Michigan | 26065 | 64433 | 764 |
2432463 | 2432463 | 2022-04-22 | Ionia | Michigan | 26067 | 19598 | 181 |
2432464 | 2432464 | 2022-04-22 | Iosco | Michigan | 26069 | 4810 | 142 |
2432465 | 2432465 | 2022-04-22 | Iron | Michigan | 26071 | 2649 | 87 |
2432466 | 2432466 | 2022-04-22 | Isabella | Michigan | 26073 | 15584 | 208 |
2432467 | 2432467 | 2022-04-22 | Jackson | Michigan | 26075 | 44757 | 585 |
2432468 | 2432468 | 2022-04-22 | Kalamazoo | Michigan | 26077 | 59524 | 674 |
2432469 | 2432469 | 2022-04-22 | Kalkaska | Michigan | 26079 | 3547 | 60 |
2432470 | 2432470 | 2022-04-22 | Kent | Michigan | 26081 | 167281 | 1526 |
2432471 | 2432471 | 2022-04-22 | Keweenaw | Michigan | 26083 | 511 | 13 |
2432472 | 2432472 | 2022-04-22 | Lake | Michigan | 26085 | 1842 | 37 |
2432473 | 2432473 | 2022-04-22 | Lapeer | Michigan | 26087 | 20857 | 427 |
2432474 | 2432474 | 2022-04-22 | Leelanau | Michigan | 26089 | 3603 | 54 |
2432475 | 2432475 | 2022-04-22 | Lenawee | Michigan | 26091 | 26056 | 329 |
2432476 | 2432476 | 2022-04-22 | Livingston | Michigan | 26093 | 46432 | 448 |
2432477 | 2432477 | 2022-04-22 | Luce | Michigan | 26095 | 2280 | 14 |
2432478 | 2432478 | 2022-04-22 | Mackinac | Michigan | 26097 | 2410 | 30 |
2432479 | 2432479 | 2022-04-22 | Macomb | Michigan | 26099 | 232167 | 3958 |
2432480 | 2432480 | 2022-04-22 | Manistee | Michigan | 26101 | 4475 | 90 |
2432481 | 2432481 | 2022-04-22 | Marquette | Michigan | 26103 | 15867 | 130 |
2432482 | 2432482 | 2022-04-22 | Mason | Michigan | 26105 | 6766 | 92 |
2432483 | 2432483 | 2022-04-22 | Mecosta | Michigan | 26107 | 8664 | 108 |
2432484 | 2432484 | 2022-04-22 | Menominee | Michigan | 26109 | 5625 | 70 |
2432485 | 2432485 | 2022-04-22 | Midland | Michigan | 26111 | 19090 | 223 |
2432486 | 2432486 | 2022-04-22 | Missaukee | Michigan | 26113 | 2914 | 60 |
2432487 | 2432487 | 2022-04-22 | Monroe | Michigan | 26115 | 38147 | 473 |
2432488 | 2432488 | 2022-04-22 | Montcalm | Michigan | 26117 | 17188 | 216 |
2432489 | 2432489 | 2022-04-22 | Montmorency | Michigan | 26119 | 1717 | 48 |
2432490 | 2432490 | 2022-04-22 | Muskegon | Michigan | 26121 | 41913 | 648 |
2432491 | 2432491 | 2022-04-22 | Newaygo | Michigan | 26123 | 11485 | 158 |
2432492 | 2432492 | 2022-04-22 | Oakland | Michigan | 26125 | 289946 | 3829 |
2432493 | 2432493 | 2022-04-22 | Oceana | Michigan | 26127 | 6345 | 90 |
2432494 | 2432494 | 2022-04-22 | Ogemaw | Michigan | 26129 | 4312 | 106 |
2432495 | 2432495 | 2022-04-22 | Ontonagon | Michigan | 26131 | 994 | 38 |
2432496 | 2432496 | 2022-04-22 | Osceola | Michigan | 26133 | 5016 | 80 |
2432497 | 2432497 | 2022-04-22 | Oscoda | Michigan | 26135 | 1434 | 55 |
2432498 | 2432498 | 2022-04-22 | Otsego | Michigan | 26137 | 5656 | 100 |
2432499 | 2432499 | 2022-04-22 | Ottawa | Michigan | 26139 | 75061 | 788 |
2432500 | 2432500 | 2022-04-22 | Presque Isle | Michigan | 26141 | 2066 | 58 |
2432501 | 2432501 | 2022-04-22 | Roscommon | Michigan | 26143 | 4627 | 114 |
2432502 | 2432502 | 2022-04-22 | Saginaw | Michigan | 26145 | 50475 | 950 |
2432503 | 2432503 | 2022-04-22 | Sanilac | Michigan | 26151 | 8702 | 191 |
2432504 | 2432504 | 2022-04-22 | Schoolcraft | Michigan | 26153 | 1747 | 16 |
2432505 | 2432505 | 2022-04-22 | Shiawassee | Michigan | 26155 | 17831 | 230 |
2432506 | 2432506 | 2022-04-22 | St. Clair | Michigan | 26147 | 40828 | 832 |
2432507 | 2432507 | 2022-04-22 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2432508 | 2432508 | 2022-04-22 | Tuscola | Michigan | 26157 | 13213 | 276 |
2432509 | 2432509 | 2022-04-22 | Unknown | Michigan | 17615 | 79 | |
2432510 | 2432510 | 2022-04-22 | Van Buren | Michigan | 26159 | 17084 | 270 |
2432511 | 2432511 | 2022-04-22 | Washtenaw | Michigan | 26161 | 78364 | 515 |
2432512 | 2432512 | 2022-04-22 | Wayne | Michigan | 26163 | 403423 | 7924 |
2432513 | 2432513 | 2022-04-22 | Wexford | Michigan | 26165 | 7086 | 106 |
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);