ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where deaths = 116 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2315290 | 2315290 | 2022-03-17 | Chippewa | Michigan | 26033 | 11546 | 116 |
2312037 | 2312037 | 2022-03-16 | Chippewa | Michigan | 26033 | 11546 | 116 |
2240533 | 2240533 | 2022-02-22 | Marquette | Michigan | 26103 | 15541 | 116 |
2237282 | 2237282 | 2022-02-21 | Marquette | Michigan | 26103 | 15541 | 116 |
2234031 | 2234031 | 2022-02-20 | Marquette | Michigan | 26103 | 15541 | 116 |
2110386 | 2110386 | 2022-01-13 | Cass | Michigan | 26027 | 9644 | 116 |
2107135 | 2107135 | 2022-01-12 | Cass | Michigan | 26027 | 9644 | 116 |
2019384 | 2019384 | 2021-12-16 | Huron | Michigan | 26063 | 6115 | 116 |
2016134 | 2016134 | 2021-12-15 | Huron | Michigan | 26063 | 6115 | 116 |
2006357 | 2006357 | 2021-12-12 | Barry | Michigan | 26015 | 10169 | 116 |
2003106 | 2003106 | 2021-12-11 | Barry | Michigan | 26015 | 10169 | 116 |
1999856 | 1999856 | 2021-12-10 | Barry | Michigan | 26015 | 10169 | 116 |
1996659 | 1996659 | 2021-12-09 | Newaygo | Michigan | 26123 | 8276 | 116 |
1993408 | 1993408 | 2021-12-08 | Newaygo | Michigan | 26123 | 8276 | 116 |
1960861 | 1960861 | 2021-11-28 | Clare | Michigan | 26035 | 4464 | 116 |
1960877 | 1960877 | 2021-11-28 | Ionia | Michigan | 26067 | 13505 | 116 |
1957610 | 1957610 | 2021-11-27 | Clare | Michigan | 26035 | 4464 | 116 |
1957626 | 1957626 | 2021-11-27 | Ionia | Michigan | 26067 | 13505 | 116 |
1954359 | 1954359 | 2021-11-26 | Clare | Michigan | 26035 | 4464 | 116 |
1954375 | 1954375 | 2021-11-26 | Ionia | Michigan | 26067 | 13505 | 116 |
1951108 | 1951108 | 2021-11-25 | Clare | Michigan | 26035 | 4464 | 116 |
1951124 | 1951124 | 2021-11-25 | Ionia | Michigan | 26067 | 13505 | 116 |
1947857 | 1947857 | 2021-11-24 | Clare | Michigan | 26035 | 4464 | 116 |
1947873 | 1947873 | 2021-11-24 | Ionia | Michigan | 26067 | 13505 | 116 |
1847137 | 1847137 | 2021-10-24 | Isabella | Michigan | 26073 | 8853 | 116 |
1843887 | 1843887 | 2021-10-23 | Isabella | Michigan | 26073 | 8853 | 116 |
1840637 | 1840637 | 2021-10-22 | Isabella | Michigan | 26073 | 8853 | 116 |
1814638 | 1814638 | 2021-10-14 | Hillsdale | Michigan | 26059 | 5871 | 116 |
1811390 | 1811390 | 2021-10-13 | Hillsdale | Michigan | 26059 | 5871 | 116 |
1723708 | 1723708 | 2021-09-16 | Shiawassee | Michigan | 26155 | 7352 | 116 |
1720459 | 1720459 | 2021-09-15 | Shiawassee | Michigan | 26155 | 7352 | 116 |
1356763 | 1356763 | 2021-05-26 | Montcalm | Michigan | 26117 | 8088 | 116 |
1353517 | 1353517 | 2021-05-25 | Montcalm | Michigan | 26117 | 8076 | 116 |
1350271 | 1350271 | 2021-05-24 | Montcalm | Michigan | 26117 | 8067 | 116 |
1347040 | 1347040 | 2021-05-23 | Sanilac | Michigan | 26151 | 4224 | 116 |
1343792 | 1343792 | 2021-05-22 | Sanilac | Michigan | 26151 | 4224 | 116 |
1285307 | 1285307 | 2021-05-04 | Gratiot | Michigan | 26057 | 6710 | 116 |
1282061 | 1282061 | 2021-05-03 | Gratiot | Michigan | 26057 | 6692 | 116 |
1282113 | 1282113 | 2021-05-03 | Van Buren | Michigan | 26159 | 6770 | 116 |
1278814 | 1278814 | 2021-05-02 | Gratiot | Michigan | 26057 | 6655 | 116 |
1278866 | 1278866 | 2021-05-02 | Van Buren | Michigan | 26159 | 6746 | 116 |
1275567 | 1275567 | 2021-05-01 | Gratiot | Michigan | 26057 | 6655 | 116 |
1275619 | 1275619 | 2021-05-01 | Van Buren | Michigan | 26159 | 6746 | 116 |
1272320 | 1272320 | 2021-04-30 | Gratiot | Michigan | 26057 | 6632 | 116 |
1249574 | 1249574 | 2021-04-23 | Branch | Michigan | 26023 | 5320 | 116 |
1246327 | 1246327 | 2021-04-22 | Branch | Michigan | 26023 | 5290 | 116 |
1243080 | 1243080 | 2021-04-21 | Branch | Michigan | 26023 | 5274 | 116 |
1038521 | 1038521 | 2021-02-17 | Allegan | Michigan | 26005 | 7193 | 116 |
1035276 | 1035276 | 2021-02-16 | Allegan | Michigan | 26005 | 7178 | 116 |
1032031 | 1032031 | 2021-02-15 | Allegan | Michigan | 26005 | 7163 | 116 |
1015846 | 1015846 | 2021-02-10 | Lenawee | Michigan | 26091 | 7407 | 116 |
989881 | 989881 | 2021-02-02 | Livingston | Michigan | 26093 | 9739 | 116 |
947686 | 947686 | 2021-01-20 | Lapeer | Michigan | 26087 | 4955 | 116 |
947721 | 947721 | 2021-01-20 | Tuscola | Michigan | 26157 | 2958 | 116 |
944439 | 944439 | 2021-01-19 | Lapeer | Michigan | 26087 | 4942 | 116 |
941229 | 941229 | 2021-01-18 | Tuscola | Michigan | 26157 | 2946 | 116 |
928193 | 928193 | 2021-01-14 | Eaton | Michigan | 26045 | 5315 | 116 |
824375 | 824375 | 2020-12-13 | Monroe | Michigan | 26115 | 6645 | 116 |
821129 | 821129 | 2020-12-12 | Monroe | Michigan | 26115 | 6645 | 116 |
817902 | 817902 | 2020-12-11 | St. Clair | Michigan | 26147 | 5910 | 116 |
785385 | 785385 | 2020-12-01 | Berrien | Michigan | 26021 | 6964 | 116 |
736751 | 736751 | 2020-11-16 | Muskegon | Michigan | 26121 | 6304 | 116 |
307335 | 307335 | 2020-07-06 | Washtenaw | Michigan | 26161 | 2276 | 116 |
304168 | 304168 | 2020-07-05 | Washtenaw | Michigan | 26161 | 2217 | 116 |
301004 | 301004 | 2020-07-04 | Washtenaw | Michigan | 26161 | 2217 | 116 |
297841 | 297841 | 2020-07-03 | Washtenaw | Michigan | 26161 | 2217 | 116 |
294683 | 294683 | 2020-07-02 | Washtenaw | Michigan | 26161 | 2217 | 116 |
247606 | 247606 | 2020-06-17 | Kent | Michigan | 26081 | 4497 | 116 |
244493 | 244493 | 2020-06-16 | Kent | Michigan | 26081 | 4477 | 116 |
241382 | 241382 | 2020-06-15 | Kent | Michigan | 26081 | 4469 | 116 |
238273 | 238273 | 2020-06-14 | Kent | Michigan | 26081 | 4467 | 116 |
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);