ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-08-24" 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 |
---|---|---|---|---|---|---|---|
1648923 | 1648923 | 2021-08-24 | Alcona | Michigan | 26001 | 800 | 36 |
1648924 | 1648924 | 2021-08-24 | Alger | Michigan | 26003 | 690 | 7 |
1648925 | 1648925 | 2021-08-24 | Allegan | Michigan | 26005 | 11816 | 164 |
1648926 | 1648926 | 2021-08-24 | Alpena | Michigan | 26007 | 2468 | 66 |
1648927 | 1648927 | 2021-08-24 | Antrim | Michigan | 26009 | 1725 | 33 |
1648928 | 1648928 | 2021-08-24 | Arenac | Michigan | 26011 | 1273 | 29 |
1648929 | 1648929 | 2021-08-24 | Baraga | Michigan | 26013 | 1019 | 41 |
1648930 | 1648930 | 2021-08-24 | Barry | Michigan | 26015 | 6233 | 73 |
1648931 | 1648931 | 2021-08-24 | Bay | Michigan | 26017 | 11662 | 360 |
1648932 | 1648932 | 2021-08-24 | Benzie | Michigan | 26019 | 1334 | 38 |
1648933 | 1648933 | 2021-08-24 | Berrien | Michigan | 26021 | 16332 | 304 |
1648934 | 1648934 | 2021-08-24 | Branch | Michigan | 26023 | 6283 | 123 |
1648935 | 1648935 | 2021-08-24 | Calhoun | Michigan | 26025 | 15265 | 325 |
1648936 | 1648936 | 2021-08-24 | Cass | Michigan | 26027 | 5782 | 78 |
1648937 | 1648937 | 2021-08-24 | Charlevoix | Michigan | 26029 | 1893 | 26 |
1648938 | 1648938 | 2021-08-24 | Cheboygan | Michigan | 26031 | 2003 | 50 |
1648939 | 1648939 | 2021-08-24 | Chippewa | Michigan | 26033 | 5757 | 50 |
1648940 | 1648940 | 2021-08-24 | Clare | Michigan | 26035 | 2612 | 87 |
1648941 | 1648941 | 2021-08-24 | Clinton | Michigan | 26037 | 7995 | 97 |
1648942 | 1648942 | 2021-08-24 | Crawford | Michigan | 26039 | 1037 | 14 |
1648943 | 1648943 | 2021-08-24 | Delta | Michigan | 26041 | 4365 | 95 |
1648944 | 1648944 | 2021-08-24 | Dickinson | Michigan | 26043 | 2876 | 74 |
1648945 | 1648945 | 2021-08-24 | Eaton | Michigan | 26045 | 10655 | 213 |
1648946 | 1648946 | 2021-08-24 | Emmet | Michigan | 26047 | 2538 | 43 |
1648947 | 1648947 | 2021-08-24 | Genesee | Michigan | 26049 | 43400 | 992 |
1648948 | 1648948 | 2021-08-24 | Gladwin | Michigan | 26051 | 2370 | 61 |
1648949 | 1648949 | 2021-08-24 | Gogebic | Michigan | 26053 | 1508 | 53 |
1648950 | 1648950 | 2021-08-24 | Grand Traverse | Michigan | 26055 | 6843 | 101 |
1648951 | 1648951 | 2021-08-24 | Gratiot | Michigan | 26057 | 7113 | 125 |
1648952 | 1648952 | 2021-08-24 | Hillsdale | Michigan | 26059 | 4649 | 97 |
1648953 | 1648953 | 2021-08-24 | Houghton | Michigan | 26061 | 3259 | 43 |
1648954 | 1648954 | 2021-08-24 | Huron | Michigan | 26063 | 4225 | 84 |
1648955 | 1648955 | 2021-08-24 | Ingham | Michigan | 26065 | 26070 | 401 |
1648956 | 1648956 | 2021-08-24 | Ionia | Michigan | 26067 | 9627 | 86 |
1648957 | 1648957 | 2021-08-24 | Iosco | Michigan | 26069 | 2133 | 78 |
1648958 | 1648958 | 2021-08-24 | Iron | Michigan | 26071 | 1101 | 53 |
1648959 | 1648959 | 2021-08-24 | Isabella | Michigan | 26073 | 6536 | 102 |
1648960 | 1648960 | 2021-08-24 | Jackson | Michigan | 26075 | 21992 | 332 |
1648961 | 1648961 | 2021-08-24 | Kalamazoo | Michigan | 26077 | 24607 | 410 |
1648962 | 1648962 | 2021-08-24 | Kalkaska | Michigan | 26079 | 1226 | 29 |
1648963 | 1648963 | 2021-08-24 | Kent | Michigan | 26081 | 76630 | 878 |
1648964 | 1648964 | 2021-08-24 | Keweenaw | Michigan | 26083 | 179 | 2 |
1648965 | 1648965 | 2021-08-24 | Lake | Michigan | 26085 | 678 | 17 |
1648966 | 1648966 | 2021-08-24 | Lapeer | Michigan | 26087 | 10136 | 217 |
1648967 | 1648967 | 2021-08-24 | Leelanau | Michigan | 26089 | 1332 | 21 |
1648968 | 1648968 | 2021-08-24 | Lenawee | Michigan | 26091 | 11317 | 181 |
1648969 | 1648969 | 2021-08-24 | Livingston | Michigan | 26093 | 17893 | 201 |
1648970 | 1648970 | 2021-08-24 | Luce | Michigan | 26095 | 1353 | 6 |
1648971 | 1648971 | 2021-08-24 | Mackinac | Michigan | 26097 | 763 | 3 |
1648972 | 1648972 | 2021-08-24 | Macomb | Michigan | 26099 | 104460 | 2527 |
1648973 | 1648973 | 2021-08-24 | Manistee | Michigan | 26101 | 2083 | 28 |
1648974 | 1648974 | 2021-08-24 | Marquette | Michigan | 26103 | 6052 | 66 |
1648975 | 1648975 | 2021-08-24 | Mason | Michigan | 26105 | 2308 | 39 |
1648976 | 1648976 | 2021-08-24 | Mecosta | Michigan | 26107 | 3348 | 38 |
1648977 | 1648977 | 2021-08-24 | Menominee | Michigan | 26109 | 2299 | 44 |
1648978 | 1648978 | 2021-08-24 | Midland | Michigan | 26111 | 7880 | 100 |
1648979 | 1648979 | 2021-08-24 | Missaukee | Michigan | 26113 | 1545 | 29 |
1648980 | 1648980 | 2021-08-24 | Monroe | Michigan | 26115 | 16122 | 269 |
1648981 | 1648981 | 2021-08-24 | Montcalm | Michigan | 26117 | 8417 | 122 |
1648982 | 1648982 | 2021-08-24 | Montmorency | Michigan | 26119 | 676 | 20 |
1648983 | 1648983 | 2021-08-24 | Muskegon | Michigan | 26121 | 19170 | 387 |
1648984 | 1648984 | 2021-08-24 | Newaygo | Michigan | 26123 | 5055 | 70 |
1648985 | 1648985 | 2021-08-24 | Oakland | Michigan | 26125 | 124739 | 2498 |
1648986 | 1648986 | 2021-08-24 | Oceana | Michigan | 26127 | 2863 | 61 |
1648987 | 1648987 | 2021-08-24 | Ogemaw | Michigan | 26129 | 1868 | 44 |
1648988 | 1648988 | 2021-08-24 | Ontonagon | Michigan | 26131 | 515 | 22 |
1648989 | 1648989 | 2021-08-24 | Osceola | Michigan | 26133 | 2037 | 31 |
1648990 | 1648990 | 2021-08-24 | Oscoda | Michigan | 26135 | 707 | 31 |
1648991 | 1648991 | 2021-08-24 | Otsego | Michigan | 26137 | 2482 | 41 |
1648992 | 1648992 | 2021-08-24 | Ottawa | Michigan | 26139 | 34258 | 448 |
1648993 | 1648993 | 2021-08-24 | Presque Isle | Michigan | 26141 | 1092 | 34 |
1648994 | 1648994 | 2021-08-24 | Roscommon | Michigan | 26143 | 1948 | 55 |
1648995 | 1648995 | 2021-08-24 | Saginaw | Michigan | 26145 | 23554 | 645 |
1648996 | 1648996 | 2021-08-24 | Sanilac | Michigan | 26151 | 4343 | 126 |
1648997 | 1648997 | 2021-08-24 | Schoolcraft | Michigan | 26153 | 467 | 5 |
1648998 | 1648998 | 2021-08-24 | Shiawassee | Michigan | 26155 | 6778 | 110 |
1648999 | 1648999 | 2021-08-24 | St. Clair | Michigan | 26147 | 19036 | 457 |
1649000 | 1649000 | 2021-08-24 | St. Joseph | Michigan | 26149 | 6558 | 104 |
1649001 | 1649001 | 2021-08-24 | Tuscola | Michigan | 26157 | 5896 | 176 |
1649002 | 1649002 | 2021-08-24 | Unknown | Michigan | 797 | 18 | |
1649003 | 1649003 | 2021-08-24 | Van Buren | Michigan | 26159 | 7568 | 138 |
1649004 | 1649004 | 2021-08-24 | Washtenaw | Michigan | 26161 | 28520 | 315 |
1649005 | 1649005 | 2021-08-24 | Wayne | Michigan | 26163 | 173635 | 5252 |
1649006 | 1649006 | 2021-08-24 | 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);