ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-08-23" 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 |
---|---|---|---|---|---|---|---|
1645674 | 1645674 | 2021-08-23 | Alcona | Michigan | 26001 | 800 | 36 |
1645675 | 1645675 | 2021-08-23 | Alger | Michigan | 26003 | 690 | 7 |
1645676 | 1645676 | 2021-08-23 | Allegan | Michigan | 26005 | 11816 | 164 |
1645677 | 1645677 | 2021-08-23 | Alpena | Michigan | 26007 | 2468 | 66 |
1645678 | 1645678 | 2021-08-23 | Antrim | Michigan | 26009 | 1721 | 33 |
1645679 | 1645679 | 2021-08-23 | Arenac | Michigan | 26011 | 1273 | 29 |
1645680 | 1645680 | 2021-08-23 | Baraga | Michigan | 26013 | 1019 | 41 |
1645681 | 1645681 | 2021-08-23 | Barry | Michigan | 26015 | 6233 | 73 |
1645682 | 1645682 | 2021-08-23 | Bay | Michigan | 26017 | 11662 | 360 |
1645683 | 1645683 | 2021-08-23 | Benzie | Michigan | 26019 | 1334 | 38 |
1645684 | 1645684 | 2021-08-23 | Berrien | Michigan | 26021 | 16294 | 303 |
1645685 | 1645685 | 2021-08-23 | Branch | Michigan | 26023 | 6283 | 123 |
1645686 | 1645686 | 2021-08-23 | Calhoun | Michigan | 26025 | 15265 | 325 |
1645687 | 1645687 | 2021-08-23 | Cass | Michigan | 26027 | 5782 | 78 |
1645688 | 1645688 | 2021-08-23 | Charlevoix | Michigan | 26029 | 1886 | 26 |
1645689 | 1645689 | 2021-08-23 | Cheboygan | Michigan | 26031 | 2003 | 50 |
1645690 | 1645690 | 2021-08-23 | Chippewa | Michigan | 26033 | 5757 | 50 |
1645691 | 1645691 | 2021-08-23 | Clare | Michigan | 26035 | 2612 | 87 |
1645692 | 1645692 | 2021-08-23 | Clinton | Michigan | 26037 | 7995 | 97 |
1645693 | 1645693 | 2021-08-23 | Crawford | Michigan | 26039 | 1037 | 14 |
1645694 | 1645694 | 2021-08-23 | Delta | Michigan | 26041 | 4365 | 95 |
1645695 | 1645695 | 2021-08-23 | Dickinson | Michigan | 26043 | 2876 | 74 |
1645696 | 1645696 | 2021-08-23 | Eaton | Michigan | 26045 | 10655 | 213 |
1645697 | 1645697 | 2021-08-23 | Emmet | Michigan | 26047 | 2530 | 43 |
1645698 | 1645698 | 2021-08-23 | Genesee | Michigan | 26049 | 43400 | 992 |
1645699 | 1645699 | 2021-08-23 | Gladwin | Michigan | 26051 | 2370 | 61 |
1645700 | 1645700 | 2021-08-23 | Gogebic | Michigan | 26053 | 1508 | 53 |
1645701 | 1645701 | 2021-08-23 | Grand Traverse | Michigan | 26055 | 6843 | 101 |
1645702 | 1645702 | 2021-08-23 | Gratiot | Michigan | 26057 | 7113 | 125 |
1645703 | 1645703 | 2021-08-23 | Hillsdale | Michigan | 26059 | 4649 | 97 |
1645704 | 1645704 | 2021-08-23 | Houghton | Michigan | 26061 | 3259 | 43 |
1645705 | 1645705 | 2021-08-23 | Huron | Michigan | 26063 | 4225 | 84 |
1645706 | 1645706 | 2021-08-23 | Ingham | Michigan | 26065 | 26070 | 401 |
1645707 | 1645707 | 2021-08-23 | Ionia | Michigan | 26067 | 9627 | 86 |
1645708 | 1645708 | 2021-08-23 | Iosco | Michigan | 26069 | 2133 | 78 |
1645709 | 1645709 | 2021-08-23 | Iron | Michigan | 26071 | 1101 | 53 |
1645710 | 1645710 | 2021-08-23 | Isabella | Michigan | 26073 | 6536 | 102 |
1645711 | 1645711 | 2021-08-23 | Jackson | Michigan | 26075 | 21992 | 332 |
1645712 | 1645712 | 2021-08-23 | Kalamazoo | Michigan | 26077 | 24607 | 410 |
1645713 | 1645713 | 2021-08-23 | Kalkaska | Michigan | 26079 | 1226 | 29 |
1645714 | 1645714 | 2021-08-23 | Kent | Michigan | 26081 | 76630 | 878 |
1645715 | 1645715 | 2021-08-23 | Keweenaw | Michigan | 26083 | 179 | 2 |
1645716 | 1645716 | 2021-08-23 | Lake | Michigan | 26085 | 678 | 17 |
1645717 | 1645717 | 2021-08-23 | Lapeer | Michigan | 26087 | 10136 | 217 |
1645718 | 1645718 | 2021-08-23 | Leelanau | Michigan | 26089 | 1332 | 21 |
1645719 | 1645719 | 2021-08-23 | Lenawee | Michigan | 26091 | 11317 | 181 |
1645720 | 1645720 | 2021-08-23 | Livingston | Michigan | 26093 | 17893 | 201 |
1645721 | 1645721 | 2021-08-23 | Luce | Michigan | 26095 | 1353 | 6 |
1645722 | 1645722 | 2021-08-23 | Mackinac | Michigan | 26097 | 763 | 3 |
1645723 | 1645723 | 2021-08-23 | Macomb | Michigan | 26099 | 104460 | 2527 |
1645724 | 1645724 | 2021-08-23 | Manistee | Michigan | 26101 | 2083 | 28 |
1645725 | 1645725 | 2021-08-23 | Marquette | Michigan | 26103 | 6052 | 66 |
1645726 | 1645726 | 2021-08-23 | Mason | Michigan | 26105 | 2308 | 39 |
1645727 | 1645727 | 2021-08-23 | Mecosta | Michigan | 26107 | 3348 | 38 |
1645728 | 1645728 | 2021-08-23 | Menominee | Michigan | 26109 | 2299 | 44 |
1645729 | 1645729 | 2021-08-23 | Midland | Michigan | 26111 | 7880 | 100 |
1645730 | 1645730 | 2021-08-23 | Missaukee | Michigan | 26113 | 1545 | 29 |
1645731 | 1645731 | 2021-08-23 | Monroe | Michigan | 26115 | 16122 | 269 |
1645732 | 1645732 | 2021-08-23 | Montcalm | Michigan | 26117 | 8417 | 122 |
1645733 | 1645733 | 2021-08-23 | Montmorency | Michigan | 26119 | 676 | 20 |
1645734 | 1645734 | 2021-08-23 | Muskegon | Michigan | 26121 | 19170 | 387 |
1645735 | 1645735 | 2021-08-23 | Newaygo | Michigan | 26123 | 5055 | 70 |
1645736 | 1645736 | 2021-08-23 | Oakland | Michigan | 26125 | 124739 | 2498 |
1645737 | 1645737 | 2021-08-23 | Oceana | Michigan | 26127 | 2863 | 61 |
1645738 | 1645738 | 2021-08-23 | Ogemaw | Michigan | 26129 | 1868 | 44 |
1645739 | 1645739 | 2021-08-23 | Ontonagon | Michigan | 26131 | 515 | 22 |
1645740 | 1645740 | 2021-08-23 | Osceola | Michigan | 26133 | 2037 | 31 |
1645741 | 1645741 | 2021-08-23 | Oscoda | Michigan | 26135 | 707 | 31 |
1645742 | 1645742 | 2021-08-23 | Otsego | Michigan | 26137 | 2472 | 41 |
1645743 | 1645743 | 2021-08-23 | Ottawa | Michigan | 26139 | 34258 | 448 |
1645744 | 1645744 | 2021-08-23 | Presque Isle | Michigan | 26141 | 1092 | 34 |
1645745 | 1645745 | 2021-08-23 | Roscommon | Michigan | 26143 | 1948 | 55 |
1645746 | 1645746 | 2021-08-23 | Saginaw | Michigan | 26145 | 23554 | 645 |
1645747 | 1645747 | 2021-08-23 | Sanilac | Michigan | 26151 | 4343 | 126 |
1645748 | 1645748 | 2021-08-23 | Schoolcraft | Michigan | 26153 | 467 | 5 |
1645749 | 1645749 | 2021-08-23 | Shiawassee | Michigan | 26155 | 6778 | 110 |
1645750 | 1645750 | 2021-08-23 | St. Clair | Michigan | 26147 | 19002 | 457 |
1645751 | 1645751 | 2021-08-23 | St. Joseph | Michigan | 26149 | 6558 | 104 |
1645752 | 1645752 | 2021-08-23 | Tuscola | Michigan | 26157 | 5896 | 176 |
1645753 | 1645753 | 2021-08-23 | Unknown | Michigan | 797 | 18 | |
1645754 | 1645754 | 2021-08-23 | Van Buren | Michigan | 26159 | 7568 | 138 |
1645755 | 1645755 | 2021-08-23 | Washtenaw | Michigan | 26161 | 28520 | 315 |
1645756 | 1645756 | 2021-08-23 | Wayne | Michigan | 26163 | 173635 | 5252 |
1645757 | 1645757 | 2021-08-23 | Wexford | Michigan | 26165 | 2966 | 48 |
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);