ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where deaths = 72 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Berrien 13
- Clinton 11
- Barry 10
- Cass 10
- Dickinson 10
- Ottawa 10
- Hillsdale 9
- Marquette 7
- Oceana 7
- Iosco 6
- Livingston 6
- Huron 5
- Newaygo 5
- Iron 4
- Midland 4
- Roscommon 4
- Shiawassee 4
- Ionia 3
- Kalamazoo 3
- Muskegon 3
- Sanilac 3
- Allegan 2
- Cheboygan 2
- Chippewa 2
- Houghton 2
- Otsego 2
- Tuscola 2
- Bay 1
- Calhoun 1
- Clare 1
- …
state 1
- Michigan · 156 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2087649 | 2087649 | 2022-01-06 | Iron | Michigan | 26071 | 1944 | 72 |
2084397 | 2084397 | 2022-01-05 | Iron | Michigan | 26071 | 1944 | 72 |
2081145 | 2081145 | 2022-01-04 | Iron | Michigan | 26071 | 1907 | 72 |
2077893 | 2077893 | 2022-01-03 | Iron | Michigan | 26071 | 1907 | 72 |
2058385 | 2058385 | 2021-12-28 | Houghton | Michigan | 26061 | 5645 | 72 |
2055136 | 2055136 | 2021-12-27 | Houghton | Michigan | 26061 | 5645 | 72 |
1993415 | 1993415 | 2021-12-08 | Otsego | Michigan | 26137 | 4069 | 72 |
1990164 | 1990164 | 2021-12-07 | Otsego | Michigan | 26137 | 4071 | 72 |
1967363 | 1967363 | 2021-11-30 | Chippewa | Michigan | 26033 | 7570 | 72 |
1964111 | 1964111 | 2021-11-29 | Chippewa | Michigan | 26033 | 7570 | 72 |
1944604 | 1944604 | 2021-11-23 | Cheboygan | Michigan | 26031 | 3220 | 72 |
1944652 | 1944652 | 2021-11-23 | Oceana | Michigan | 26127 | 4264 | 72 |
1941353 | 1941353 | 2021-11-22 | Cheboygan | Michigan | 26031 | 3220 | 72 |
1941401 | 1941401 | 2021-11-22 | Oceana | Michigan | 26127 | 4264 | 72 |
1938151 | 1938151 | 2021-11-21 | Oceana | Michigan | 26127 | 4187 | 72 |
1934901 | 1934901 | 2021-11-20 | Oceana | Michigan | 26127 | 4187 | 72 |
1931651 | 1931651 | 2021-11-19 | Oceana | Michigan | 26127 | 4187 | 72 |
1928400 | 1928400 | 2021-11-18 | Oceana | Michigan | 26127 | 4124 | 72 |
1928408 | 1928408 | 2021-11-18 | Roscommon | Michigan | 26143 | 2997 | 72 |
1925150 | 1925150 | 2021-11-17 | Oceana | Michigan | 26127 | 4124 | 72 |
1925158 | 1925158 | 2021-11-17 | Roscommon | Michigan | 26143 | 2997 | 72 |
1921909 | 1921909 | 2021-11-16 | Roscommon | Michigan | 26143 | 2951 | 72 |
1918659 | 1918659 | 2021-11-15 | Roscommon | Michigan | 26143 | 2951 | 72 |
1801663 | 1801663 | 2021-10-10 | Marquette | Michigan | 26103 | 7462 | 72 |
1798414 | 1798414 | 2021-10-09 | Marquette | Michigan | 26103 | 7462 | 72 |
1795165 | 1795165 | 2021-10-08 | Marquette | Michigan | 26103 | 7462 | 72 |
1791916 | 1791916 | 2021-10-07 | Marquette | Michigan | 26103 | 7359 | 72 |
1788667 | 1788667 | 2021-10-06 | Marquette | Michigan | 26103 | 7359 | 72 |
1785419 | 1785419 | 2021-10-05 | Marquette | Michigan | 26103 | 7257 | 72 |
1782170 | 1782170 | 2021-10-04 | Marquette | Michigan | 26103 | 7257 | 72 |
1717197 | 1717197 | 2021-09-14 | Newaygo | Michigan | 26123 | 5280 | 72 |
1713949 | 1713949 | 2021-09-13 | Newaygo | Michigan | 26123 | 5280 | 72 |
1710703 | 1710703 | 2021-09-12 | Newaygo | Michigan | 26123 | 5248 | 72 |
1707456 | 1707456 | 2021-09-11 | Newaygo | Michigan | 26123 | 5248 | 72 |
1704209 | 1704209 | 2021-09-10 | Newaygo | Michigan | 26123 | 5248 | 72 |
1642432 | 1642432 | 2021-08-22 | Barry | Michigan | 26015 | 6213 | 72 |
1639182 | 1639182 | 2021-08-21 | Barry | Michigan | 26015 | 6213 | 72 |
1635932 | 1635932 | 2021-08-20 | Barry | Michigan | 26015 | 6213 | 72 |
1632682 | 1632682 | 2021-08-19 | Barry | Michigan | 26015 | 6175 | 72 |
1629435 | 1629435 | 2021-08-18 | Barry | Michigan | 26015 | 6175 | 72 |
1626188 | 1626188 | 2021-08-17 | Barry | Michigan | 26015 | 6150 | 72 |
1622941 | 1622941 | 2021-08-16 | Barry | Michigan | 26015 | 6150 | 72 |
1619694 | 1619694 | 2021-08-15 | Barry | Michigan | 26015 | 6133 | 72 |
1616446 | 1616446 | 2021-08-14 | Barry | Michigan | 26015 | 6133 | 72 |
1613198 | 1613198 | 2021-08-13 | Barry | Michigan | 26015 | 6133 | 72 |
1353493 | 1353493 | 2021-05-25 | Iosco | Michigan | 26069 | 1986 | 72 |
1350247 | 1350247 | 2021-05-24 | Iosco | Michigan | 26069 | 1980 | 72 |
1347001 | 1347001 | 2021-05-23 | Iosco | Michigan | 26069 | 1977 | 72 |
1343753 | 1343753 | 2021-05-22 | Iosco | Michigan | 26069 | 1977 | 72 |
1340504 | 1340504 | 2021-05-21 | Iosco | Michigan | 26069 | 1976 | 72 |
1337257 | 1337257 | 2021-05-20 | Iosco | Michigan | 26069 | 1967 | 72 |
1272323 | 1272323 | 2021-04-30 | Huron | Michigan | 26063 | 3958 | 72 |
1269076 | 1269076 | 2021-04-29 | Huron | Michigan | 26063 | 3950 | 72 |
1265829 | 1265829 | 2021-04-28 | Huron | Michigan | 26063 | 3931 | 72 |
1262582 | 1262582 | 2021-04-27 | Huron | Michigan | 26063 | 3856 | 72 |
1259317 | 1259317 | 2021-04-26 | Cass | Michigan | 26027 | 5135 | 72 |
1259321 | 1259321 | 2021-04-26 | Clare | Michigan | 26035 | 2209 | 72 |
1259335 | 1259335 | 2021-04-26 | Huron | Michigan | 26063 | 3843 | 72 |
1256070 | 1256070 | 2021-04-25 | Cass | Michigan | 26027 | 5111 | 72 |
1252823 | 1252823 | 2021-04-24 | Cass | Michigan | 26027 | 5111 | 72 |
1249576 | 1249576 | 2021-04-23 | Cass | Michigan | 26027 | 5097 | 72 |
1249584 | 1249584 | 2021-04-23 | Dickinson | Michigan | 26043 | 2636 | 72 |
1246329 | 1246329 | 2021-04-22 | Cass | Michigan | 26027 | 5078 | 72 |
1246337 | 1246337 | 2021-04-22 | Dickinson | Michigan | 26043 | 2626 | 72 |
1243082 | 1243082 | 2021-04-21 | Cass | Michigan | 26027 | 5061 | 72 |
1243090 | 1243090 | 2021-04-21 | Dickinson | Michigan | 26043 | 2620 | 72 |
1239835 | 1239835 | 2021-04-20 | Cass | Michigan | 26027 | 5037 | 72 |
1239843 | 1239843 | 2021-04-20 | Dickinson | Michigan | 26043 | 2609 | 72 |
1236588 | 1236588 | 2021-04-19 | Cass | Michigan | 26027 | 5016 | 72 |
1236596 | 1236596 | 2021-04-19 | Dickinson | Michigan | 26043 | 2602 | 72 |
1233341 | 1233341 | 2021-04-18 | Cass | Michigan | 26027 | 4967 | 72 |
1233349 | 1233349 | 2021-04-18 | Dickinson | Michigan | 26043 | 2596 | 72 |
1230093 | 1230093 | 2021-04-17 | Cass | Michigan | 26027 | 4967 | 72 |
1230101 | 1230101 | 2021-04-17 | Dickinson | Michigan | 26043 | 2596 | 72 |
1226853 | 1226853 | 2021-04-16 | Dickinson | Michigan | 26043 | 2592 | 72 |
1223605 | 1223605 | 2021-04-15 | Dickinson | Michigan | 26043 | 2582 | 72 |
1220358 | 1220358 | 2021-04-14 | Dickinson | Michigan | 26043 | 2561 | 72 |
1213897 | 1213897 | 2021-04-12 | Midland | Michigan | 26111 | 6239 | 72 |
1210649 | 1210649 | 2021-04-11 | Midland | Michigan | 26111 | 6150 | 72 |
1207400 | 1207400 | 2021-04-10 | Midland | Michigan | 26111 | 6150 | 72 |
1204152 | 1204152 | 2021-04-09 | Midland | Michigan | 26111 | 6075 | 72 |
1132672 | 1132672 | 2021-03-18 | Clinton | Michigan | 26037 | 5399 | 72 |
1129424 | 1129424 | 2021-03-17 | Clinton | Michigan | 26037 | 5358 | 72 |
1126177 | 1126177 | 2021-03-16 | Clinton | Michigan | 26037 | 5335 | 72 |
1122931 | 1122931 | 2021-03-15 | Clinton | Michigan | 26037 | 5301 | 72 |
1119684 | 1119684 | 2021-03-14 | Clinton | Michigan | 26037 | 5233 | 72 |
1116437 | 1116437 | 2021-03-13 | Clinton | Michigan | 26037 | 5233 | 72 |
1113191 | 1113191 | 2021-03-12 | Clinton | Michigan | 26037 | 5228 | 72 |
1109945 | 1109945 | 2021-03-11 | Clinton | Michigan | 26037 | 5194 | 72 |
1106699 | 1106699 | 2021-03-10 | Clinton | Michigan | 26037 | 5156 | 72 |
1103453 | 1103453 | 2021-03-09 | Clinton | Michigan | 26037 | 5126 | 72 |
1100207 | 1100207 | 2021-03-08 | Clinton | Michigan | 26037 | 5114 | 72 |
1067759 | 1067759 | 2021-02-26 | Hillsdale | Michigan | 26059 | 3346 | 72 |
1064514 | 1064514 | 2021-02-25 | Hillsdale | Michigan | 26059 | 3339 | 72 |
1061270 | 1061270 | 2021-02-24 | Hillsdale | Michigan | 26059 | 3327 | 72 |
1058024 | 1058024 | 2021-02-23 | Hillsdale | Michigan | 26059 | 3316 | 72 |
1054778 | 1054778 | 2021-02-22 | Hillsdale | Michigan | 26059 | 3311 | 72 |
1051531 | 1051531 | 2021-02-21 | Hillsdale | Michigan | 26059 | 3296 | 72 |
1048284 | 1048284 | 2021-02-20 | Hillsdale | Michigan | 26059 | 3296 | 72 |
1045038 | 1045038 | 2021-02-19 | Hillsdale | Michigan | 26059 | 3297 | 72 |
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);