ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
357 rows where deaths = 48 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Wexford 68
- Kalkaska 35
- Alpena 32
- Montmorency 31
- Menominee 21
- Chippewa 19
- Iron 16
- Baraga 12
- Gogebic 10
- Roscommon 8
- Oceana 7
- Otsego 7
- St. Clair 7
- Antrim 5
- Bay 5
- Cheboygan 5
- Presque Isle 5
- Emmet 4
- Barry 3
- Benzie 3
- Grand Traverse 3
- Houghton 3
- Iosco 3
- Livingston 3
- Newaygo 3
- Oscoda 3
- Ottawa 3
- St. Joseph 3
- Calhoun 2
- Cass 2
- …
state 1
- Michigan · 357 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500880 | 2500880 | 2022-05-13 | Montmorency | Michigan | 26119 | 1750 | 48 |
2497622 | 2497622 | 2022-05-12 | Montmorency | Michigan | 26119 | 1750 | 48 |
2494364 | 2494364 | 2022-05-11 | Montmorency | Michigan | 26119 | 1750 | 48 |
2491106 | 2491106 | 2022-05-10 | Montmorency | Michigan | 26119 | 1745 | 48 |
2487849 | 2487849 | 2022-05-09 | Montmorency | Michigan | 26119 | 1745 | 48 |
2484591 | 2484591 | 2022-05-08 | Montmorency | Michigan | 26119 | 1745 | 48 |
2481333 | 2481333 | 2022-05-07 | Montmorency | Michigan | 26119 | 1745 | 48 |
2478075 | 2478075 | 2022-05-06 | Montmorency | Michigan | 26119 | 1745 | 48 |
2474817 | 2474817 | 2022-05-05 | Montmorency | Michigan | 26119 | 1745 | 48 |
2471560 | 2471560 | 2022-05-04 | Montmorency | Michigan | 26119 | 1745 | 48 |
2468304 | 2468304 | 2022-05-03 | Montmorency | Michigan | 26119 | 1732 | 48 |
2465049 | 2465049 | 2022-05-02 | Montmorency | Michigan | 26119 | 1732 | 48 |
2461793 | 2461793 | 2022-05-01 | Montmorency | Michigan | 26119 | 1732 | 48 |
2458537 | 2458537 | 2022-04-30 | Montmorency | Michigan | 26119 | 1732 | 48 |
2455281 | 2455281 | 2022-04-29 | Montmorency | Michigan | 26119 | 1732 | 48 |
2452025 | 2452025 | 2022-04-28 | Montmorency | Michigan | 26119 | 1732 | 48 |
2448769 | 2448769 | 2022-04-27 | Montmorency | Michigan | 26119 | 1732 | 48 |
2445513 | 2445513 | 2022-04-26 | Montmorency | Michigan | 26119 | 1717 | 48 |
2442257 | 2442257 | 2022-04-25 | Montmorency | Michigan | 26119 | 1717 | 48 |
2439001 | 2439001 | 2022-04-24 | Montmorency | Michigan | 26119 | 1717 | 48 |
2435745 | 2435745 | 2022-04-23 | Montmorency | Michigan | 26119 | 1717 | 48 |
2432489 | 2432489 | 2022-04-22 | Montmorency | Michigan | 26119 | 1717 | 48 |
2429233 | 2429233 | 2022-04-21 | Montmorency | Michigan | 26119 | 1717 | 48 |
2425977 | 2425977 | 2022-04-20 | Montmorency | Michigan | 26119 | 1717 | 48 |
2422721 | 2422721 | 2022-04-19 | Montmorency | Michigan | 26119 | 1716 | 48 |
2419465 | 2419465 | 2022-04-18 | Montmorency | Michigan | 26119 | 1716 | 48 |
2416209 | 2416209 | 2022-04-17 | Montmorency | Michigan | 26119 | 1716 | 48 |
2412953 | 2412953 | 2022-04-16 | Montmorency | Michigan | 26119 | 1716 | 48 |
2409697 | 2409697 | 2022-04-15 | Montmorency | Michigan | 26119 | 1716 | 48 |
2406441 | 2406441 | 2022-04-14 | Montmorency | Michigan | 26119 | 1716 | 48 |
2403185 | 2403185 | 2022-04-13 | Montmorency | Michigan | 26119 | 1716 | 48 |
2172225 | 2172225 | 2022-02-01 | Kalkaska | Michigan | 26079 | 3282 | 48 |
2168972 | 2168972 | 2022-01-31 | Kalkaska | Michigan | 26079 | 3282 | 48 |
2165717 | 2165717 | 2022-01-30 | Kalkaska | Michigan | 26079 | 3207 | 48 |
2162462 | 2162462 | 2022-01-29 | Kalkaska | Michigan | 26079 | 3207 | 48 |
2159207 | 2159207 | 2022-01-28 | Kalkaska | Michigan | 26079 | 3207 | 48 |
2155953 | 2155953 | 2022-01-27 | Kalkaska | Michigan | 26079 | 3151 | 48 |
2152700 | 2152700 | 2022-01-26 | Kalkaska | Michigan | 26079 | 3151 | 48 |
2149448 | 2149448 | 2022-01-25 | Kalkaska | Michigan | 26079 | 3065 | 48 |
2146196 | 2146196 | 2022-01-24 | Kalkaska | Michigan | 26079 | 3065 | 48 |
2142941 | 2142941 | 2022-01-23 | Kalkaska | Michigan | 26079 | 2986 | 48 |
2139686 | 2139686 | 2022-01-22 | Kalkaska | Michigan | 26079 | 2986 | 48 |
2136430 | 2136430 | 2022-01-21 | Kalkaska | Michigan | 26079 | 2986 | 48 |
2133178 | 2133178 | 2022-01-20 | Kalkaska | Michigan | 26079 | 2923 | 48 |
2129925 | 2129925 | 2022-01-19 | Kalkaska | Michigan | 26079 | 2923 | 48 |
2126671 | 2126671 | 2022-01-18 | Kalkaska | Michigan | 26079 | 2793 | 48 |
2123419 | 2123419 | 2022-01-17 | Kalkaska | Michigan | 26079 | 2793 | 48 |
2120167 | 2120167 | 2022-01-16 | Kalkaska | Michigan | 26079 | 2793 | 48 |
2116915 | 2116915 | 2022-01-15 | Kalkaska | Michigan | 26079 | 2793 | 48 |
2113664 | 2113664 | 2022-01-14 | Kalkaska | Michigan | 26079 | 2793 | 48 |
2110412 | 2110412 | 2022-01-13 | Kalkaska | Michigan | 26079 | 2750 | 48 |
2107161 | 2107161 | 2022-01-12 | Kalkaska | Michigan | 26079 | 2750 | 48 |
2103910 | 2103910 | 2022-01-11 | Kalkaska | Michigan | 26079 | 2712 | 48 |
2100659 | 2100659 | 2022-01-10 | Kalkaska | Michigan | 26079 | 2712 | 48 |
2097408 | 2097408 | 2022-01-09 | Kalkaska | Michigan | 26079 | 2659 | 48 |
2094156 | 2094156 | 2022-01-08 | Kalkaska | Michigan | 26079 | 2659 | 48 |
2090904 | 2090904 | 2022-01-07 | Kalkaska | Michigan | 26079 | 2659 | 48 |
2087653 | 2087653 | 2022-01-06 | Kalkaska | Michigan | 26079 | 2616 | 48 |
2084401 | 2084401 | 2022-01-05 | Kalkaska | Michigan | 26079 | 2616 | 48 |
2081149 | 2081149 | 2022-01-04 | Kalkaska | Michigan | 26079 | 2585 | 48 |
2077897 | 2077897 | 2022-01-03 | Kalkaska | Michigan | 26079 | 2585 | 48 |
2074646 | 2074646 | 2022-01-02 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2071395 | 2071395 | 2022-01-01 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2068144 | 2068144 | 2021-12-31 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2064893 | 2064893 | 2021-12-30 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2061643 | 2061643 | 2021-12-29 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2051862 | 2051862 | 2021-12-26 | Baraga | Michigan | 26013 | 1643 | 48 |
2048612 | 2048612 | 2021-12-25 | Baraga | Michigan | 26013 | 1643 | 48 |
2045362 | 2045362 | 2021-12-24 | Baraga | Michigan | 26013 | 1643 | 48 |
2042112 | 2042112 | 2021-12-23 | Baraga | Michigan | 26013 | 1643 | 48 |
2038863 | 2038863 | 2021-12-22 | Baraga | Michigan | 26013 | 1643 | 48 |
2035613 | 2035613 | 2021-12-21 | Baraga | Michigan | 26013 | 1636 | 48 |
2032363 | 2032363 | 2021-12-20 | Baraga | Michigan | 26013 | 1636 | 48 |
2029110 | 2029110 | 2021-12-19 | Antrim | Michigan | 26009 | 3070 | 48 |
2029112 | 2029112 | 2021-12-19 | Baraga | Michigan | 26013 | 1629 | 48 |
2029115 | 2029115 | 2021-12-19 | Benzie | Michigan | 26019 | 2323 | 48 |
2025859 | 2025859 | 2021-12-18 | Antrim | Michigan | 26009 | 3070 | 48 |
2025861 | 2025861 | 2021-12-18 | Baraga | Michigan | 26013 | 1629 | 48 |
2025864 | 2025864 | 2021-12-18 | Benzie | Michigan | 26019 | 2323 | 48 |
2022608 | 2022608 | 2021-12-17 | Antrim | Michigan | 26009 | 3070 | 48 |
2022610 | 2022610 | 2021-12-17 | Baraga | Michigan | 26013 | 1629 | 48 |
2022613 | 2022613 | 2021-12-17 | Benzie | Michigan | 26019 | 2323 | 48 |
2019357 | 2019357 | 2021-12-16 | Antrim | Michigan | 26009 | 3063 | 48 |
2019359 | 2019359 | 2021-12-16 | Baraga | Michigan | 26013 | 1620 | 48 |
2016107 | 2016107 | 2021-12-15 | Antrim | Michigan | 26009 | 3050 | 48 |
2016109 | 2016109 | 2021-12-15 | Baraga | Michigan | 26013 | 1620 | 48 |
2006417 | 2006417 | 2021-12-12 | Oscoda | Michigan | 26135 | 1136 | 48 |
2003166 | 2003166 | 2021-12-11 | Oscoda | Michigan | 26135 | 1136 | 48 |
1999916 | 1999916 | 2021-12-10 | Oscoda | Michigan | 26135 | 1136 | 48 |
1990166 | 1990166 | 2021-12-07 | Presque Isle | Michigan | 26141 | 1651 | 48 |
1986916 | 1986916 | 2021-12-06 | Presque Isle | Michigan | 26141 | 1651 | 48 |
1983666 | 1983666 | 2021-12-05 | Presque Isle | Michigan | 26141 | 1634 | 48 |
1980416 | 1980416 | 2021-12-04 | Presque Isle | Michigan | 26141 | 1634 | 48 |
1977166 | 1977166 | 2021-12-03 | Presque Isle | Michigan | 26141 | 1634 | 48 |
1967397 | 1967397 | 2021-11-30 | Manistee | Michigan | 26101 | 2933 | 48 |
1964145 | 1964145 | 2021-11-29 | Manistee | Michigan | 26101 | 2933 | 48 |
1944655 | 1944655 | 2021-11-23 | Osceola | Michigan | 26133 | 3466 | 48 |
1941404 | 1941404 | 2021-11-22 | Osceola | Michigan | 26133 | 3466 | 48 |
1899142 | 1899142 | 2021-11-09 | Mason | Michigan | 26105 | 3396 | 48 |
1895892 | 1895892 | 2021-11-08 | Mason | Michigan | 26105 | 3396 | 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);