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 2020-09-16 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
538899 | 538899 | 2020-09-16 | Alcona | Michigan | 26001 | 41 | 2 |
538900 | 538900 | 2020-09-16 | Alger | Michigan | 26003 | 17 | 0 |
538901 | 538901 | 2020-09-16 | Allegan | Michigan | 26005 | 713 | 7 |
538902 | 538902 | 2020-09-16 | Alpena | Michigan | 26007 | 135 | 14 |
538903 | 538903 | 2020-09-16 | Antrim | Michigan | 26009 | 66 | 0 |
538904 | 538904 | 2020-09-16 | Arenac | Michigan | 26011 | 67 | 3 |
538905 | 538905 | 2020-09-16 | Baraga | Michigan | 26013 | 14 | 0 |
538906 | 538906 | 2020-09-16 | Barry | Michigan | 26015 | 270 | 2 |
538907 | 538907 | 2020-09-16 | Bay | Michigan | 26017 | 932 | 46 |
538908 | 538908 | 2020-09-16 | Benzie | Michigan | 26019 | 64 | 2 |
538909 | 538909 | 2020-09-16 | Berrien | Michigan | 26021 | 1825 | 72 |
538910 | 538910 | 2020-09-16 | Branch | Michigan | 26023 | 1370 | 27 |
538911 | 538911 | 2020-09-16 | Calhoun | Michigan | 26025 | 1174 | 44 |
538912 | 538912 | 2020-09-16 | Cass | Michigan | 26027 | 488 | 16 |
538913 | 538913 | 2020-09-16 | Charlevoix | Michigan | 26029 | 98 | 3 |
538914 | 538914 | 2020-09-16 | Cheboygan | Michigan | 26031 | 87 | 2 |
538915 | 538915 | 2020-09-16 | Chippewa | Michigan | 26033 | 69 | 0 |
538916 | 538916 | 2020-09-16 | Clare | Michigan | 26035 | 107 | 4 |
538917 | 538917 | 2020-09-16 | Clinton | Michigan | 26037 | 601 | 13 |
538918 | 538918 | 2020-09-16 | Crawford | Michigan | 26039 | 118 | 5 |
538919 | 538919 | 2020-09-16 | Delta | Michigan | 26041 | 239 | 5 |
538920 | 538920 | 2020-09-16 | Dickinson | Michigan | 26043 | 83 | 2 |
538921 | 538921 | 2020-09-16 | Eaton | Michigan | 26045 | 594 | 10 |
538922 | 538922 | 2020-09-16 | Emmet | Michigan | 26047 | 147 | 4 |
538923 | 538923 | 2020-09-16 | Genesee | Michigan | 26049 | 4184 | 307 |
538924 | 538924 | 2020-09-16 | Gladwin | Michigan | 26051 | 87 | 2 |
538925 | 538925 | 2020-09-16 | Gogebic | Michigan | 26053 | 152 | 1 |
538926 | 538926 | 2020-09-16 | Grand Traverse | Michigan | 26055 | 446 | 7 |
538927 | 538927 | 2020-09-16 | Gratiot | Michigan | 26057 | 233 | 15 |
538928 | 538928 | 2020-09-16 | Hillsdale | Michigan | 26059 | 318 | 27 |
538929 | 538929 | 2020-09-16 | Houghton | Michigan | 26061 | 237 | 1 |
538930 | 538930 | 2020-09-16 | Huron | Michigan | 26063 | 207 | 5 |
538931 | 538931 | 2020-09-16 | Ingham | Michigan | 26065 | 2887 | 43 |
538932 | 538932 | 2020-09-16 | Ionia | Michigan | 26067 | 372 | 7 |
538933 | 538933 | 2020-09-16 | Iosco | Michigan | 26069 | 176 | 12 |
538934 | 538934 | 2020-09-16 | Iron | Michigan | 26071 | 53 | 1 |
538935 | 538935 | 2020-09-16 | Isabella | Michigan | 26073 | 632 | 11 |
538936 | 538936 | 2020-09-16 | Jackson | Michigan | 26075 | 2683 | 64 |
538937 | 538937 | 2020-09-16 | Kalamazoo | Michigan | 26077 | 2411 | 91 |
538938 | 538938 | 2020-09-16 | Kalkaska | Michigan | 26079 | 80 | 4 |
538939 | 538939 | 2020-09-16 | Kent | Michigan | 26081 | 9177 | 173 |
538940 | 538940 | 2020-09-16 | Keweenaw | Michigan | 26083 | 8 | 0 |
538941 | 538941 | 2020-09-16 | Lake | Michigan | 26085 | 32 | 0 |
538942 | 538942 | 2020-09-16 | Lapeer | Michigan | 26087 | 879 | 44 |
538943 | 538943 | 2020-09-16 | Leelanau | Michigan | 26089 | 102 | 1 |
538944 | 538944 | 2020-09-16 | Lenawee | Michigan | 26091 | 1489 | 19 |
538945 | 538945 | 2020-09-16 | Livingston | Michigan | 26093 | 1338 | 30 |
538946 | 538946 | 2020-09-16 | Luce | Michigan | 26095 | 219 | 0 |
538947 | 538947 | 2020-09-16 | Mackinac | Michigan | 26097 | 52 | 0 |
538948 | 538948 | 2020-09-16 | Macomb | Michigan | 26099 | 14071 | 1011 |
538949 | 538949 | 2020-09-16 | Manistee | Michigan | 26101 | 82 | 2 |
538950 | 538950 | 2020-09-16 | Marquette | Michigan | 26103 | 297 | 11 |
538951 | 538951 | 2020-09-16 | Mason | Michigan | 26105 | 133 | 0 |
538952 | 538952 | 2020-09-16 | Mecosta | Michigan | 26107 | 171 | 2 |
538953 | 538953 | 2020-09-16 | Menominee | Michigan | 26109 | 278 | 1 |
538954 | 538954 | 2020-09-16 | Midland | Michigan | 26111 | 531 | 11 |
538955 | 538955 | 2020-09-16 | Missaukee | Michigan | 26113 | 57 | 1 |
538956 | 538956 | 2020-09-16 | Monroe | Michigan | 26115 | 1454 | 28 |
538957 | 538957 | 2020-09-16 | Montcalm | Michigan | 26117 | 277 | 4 |
538958 | 538958 | 2020-09-16 | Montmorency | Michigan | 26119 | 13 | 0 |
538959 | 538959 | 2020-09-16 | Muskegon | Michigan | 26121 | 2316 | 70 |
538960 | 538960 | 2020-09-16 | Newaygo | Michigan | 26123 | 321 | 1 |
538961 | 538961 | 2020-09-16 | Oakland | Michigan | 26125 | 19624 | 1189 |
538962 | 538962 | 2020-09-16 | Oceana | Michigan | 26127 | 506 | 6 |
538963 | 538963 | 2020-09-16 | Ogemaw | Michigan | 26129 | 61 | 5 |
538964 | 538964 | 2020-09-16 | Ontonagon | Michigan | 26131 | 41 | 0 |
538965 | 538965 | 2020-09-16 | Osceola | Michigan | 26133 | 88 | 0 |
538966 | 538966 | 2020-09-16 | Oscoda | Michigan | 26135 | 30 | 1 |
538967 | 538967 | 2020-09-16 | Otsego | Michigan | 26137 | 173 | 11 |
538968 | 538968 | 2020-09-16 | Ottawa | Michigan | 26139 | 3058 | 67 |
538969 | 538969 | 2020-09-16 | Presque Isle | Michigan | 26141 | 24 | 1 |
538970 | 538970 | 2020-09-16 | Roscommon | Michigan | 26143 | 89 | 4 |
538971 | 538971 | 2020-09-16 | Saginaw | Michigan | 26145 | 2825 | 138 |
538972 | 538972 | 2020-09-16 | Sanilac | Michigan | 26151 | 139 | 7 |
538973 | 538973 | 2020-09-16 | Schoolcraft | Michigan | 26153 | 20 | 0 |
538974 | 538974 | 2020-09-16 | Shiawassee | Michigan | 26155 | 484 | 30 |
538975 | 538975 | 2020-09-16 | St. Clair | Michigan | 26147 | 970 | 53 |
538976 | 538976 | 2020-09-16 | St. Joseph | Michigan | 26149 | 713 | 11 |
538977 | 538977 | 2020-09-16 | Tuscola | Michigan | 26157 | 476 | 30 |
538978 | 538978 | 2020-09-16 | Unknown | Michigan | 289 | 4 | |
538979 | 538979 | 2020-09-16 | Van Buren | Michigan | 26159 | 717 | 17 |
538980 | 538980 | 2020-09-16 | Washtenaw | Michigan | 26161 | 3744 | 125 |
538981 | 538981 | 2020-09-16 | Wayne | Michigan | 26163 | 33815 | 2951 |
538982 | 538982 | 2020-09-16 | Wexford | Michigan | 26165 | 122 | 4 |
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);