ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
246 rows where deaths = 59 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Missaukee 35
- Gladwin 22
- Huron 18
- Marquette 15
- Roscommon 14
- Alpena 10
- Kalkaska 9
- Alcona 7
- Arenac 7
- Charlevoix 7
- Emmet 7
- Oceana 7
- Ogemaw 7
- Presque Isle 7
- Muskegon 6
- Ottawa 6
- Houghton 5
- Mecosta 5
- Montcalm 4
- Shiawassee 4
- Cass 3
- Menominee 3
- Benzie 2
- Cheboygan 2
- Clinton 2
- Dickinson 2
- Gogebic 2
- Iron 2
- Isabella 2
- Jackson 2
- …
state 1
- Michigan · 246 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422732 | 2422732 | 2022-04-19 | Presque Isle | Michigan | 26141 | 2065 | 59 |
2419476 | 2419476 | 2022-04-18 | Presque Isle | Michigan | 26141 | 2065 | 59 |
2416220 | 2416220 | 2022-04-17 | Presque Isle | Michigan | 26141 | 2065 | 59 |
2412964 | 2412964 | 2022-04-16 | Presque Isle | Michigan | 26141 | 2065 | 59 |
2409708 | 2409708 | 2022-04-15 | Presque Isle | Michigan | 26141 | 2065 | 59 |
2406452 | 2406452 | 2022-04-14 | Presque Isle | Michigan | 26141 | 2065 | 59 |
2403196 | 2403196 | 2022-04-13 | Presque Isle | Michigan | 26141 | 2065 | 59 |
2377140 | 2377140 | 2022-04-05 | Missaukee | Michigan | 26113 | 2903 | 59 |
2373888 | 2373888 | 2022-04-04 | Missaukee | Michigan | 26113 | 2903 | 59 |
2370635 | 2370635 | 2022-04-03 | Missaukee | Michigan | 26113 | 2903 | 59 |
2367382 | 2367382 | 2022-04-02 | Missaukee | Michigan | 26113 | 2903 | 59 |
2364129 | 2364129 | 2022-04-01 | Missaukee | Michigan | 26113 | 2903 | 59 |
2360875 | 2360875 | 2022-03-31 | Missaukee | Michigan | 26113 | 2903 | 59 |
2357621 | 2357621 | 2022-03-30 | Missaukee | Michigan | 26113 | 2903 | 59 |
2354368 | 2354368 | 2022-03-29 | Missaukee | Michigan | 26113 | 2901 | 59 |
2351116 | 2351116 | 2022-03-28 | Missaukee | Michigan | 26113 | 2901 | 59 |
2347863 | 2347863 | 2022-03-27 | Missaukee | Michigan | 26113 | 2902 | 59 |
2344610 | 2344610 | 2022-03-26 | Missaukee | Michigan | 26113 | 2902 | 59 |
2341357 | 2341357 | 2022-03-25 | Missaukee | Michigan | 26113 | 2902 | 59 |
2338104 | 2338104 | 2022-03-24 | Missaukee | Michigan | 26113 | 2901 | 59 |
2334850 | 2334850 | 2022-03-23 | Missaukee | Michigan | 26113 | 2901 | 59 |
2331596 | 2331596 | 2022-03-22 | Missaukee | Michigan | 26113 | 2899 | 59 |
2328344 | 2328344 | 2022-03-21 | Missaukee | Michigan | 26113 | 2899 | 59 |
2325091 | 2325091 | 2022-03-20 | Missaukee | Michigan | 26113 | 2892 | 59 |
2321837 | 2321837 | 2022-03-19 | Missaukee | Michigan | 26113 | 2892 | 59 |
2318583 | 2318583 | 2022-03-18 | Missaukee | Michigan | 26113 | 2892 | 59 |
2315313 | 2315313 | 2022-03-17 | Kalkaska | Michigan | 26079 | 3511 | 59 |
2315330 | 2315330 | 2022-03-17 | Missaukee | Michigan | 26113 | 2891 | 59 |
2312060 | 2312060 | 2022-03-16 | Kalkaska | Michigan | 26079 | 3511 | 59 |
2312077 | 2312077 | 2022-03-16 | Missaukee | Michigan | 26113 | 2891 | 59 |
2308807 | 2308807 | 2022-03-15 | Kalkaska | Michigan | 26079 | 3509 | 59 |
2308824 | 2308824 | 2022-03-15 | Missaukee | Michigan | 26113 | 2887 | 59 |
2305531 | 2305531 | 2022-03-14 | Charlevoix | Michigan | 26029 | 4892 | 59 |
2305556 | 2305556 | 2022-03-14 | Kalkaska | Michigan | 26079 | 3509 | 59 |
2305573 | 2305573 | 2022-03-14 | Missaukee | Michigan | 26113 | 2887 | 59 |
2302279 | 2302279 | 2022-03-13 | Charlevoix | Michigan | 26029 | 4892 | 59 |
2302304 | 2302304 | 2022-03-13 | Kalkaska | Michigan | 26079 | 3502 | 59 |
2302321 | 2302321 | 2022-03-13 | Missaukee | Michigan | 26113 | 2886 | 59 |
2299027 | 2299027 | 2022-03-12 | Charlevoix | Michigan | 26029 | 4892 | 59 |
2299052 | 2299052 | 2022-03-12 | Kalkaska | Michigan | 26079 | 3502 | 59 |
2299069 | 2299069 | 2022-03-12 | Missaukee | Michigan | 26113 | 2886 | 59 |
2295775 | 2295775 | 2022-03-11 | Charlevoix | Michigan | 26029 | 4892 | 59 |
2295800 | 2295800 | 2022-03-11 | Kalkaska | Michigan | 26079 | 3502 | 59 |
2295817 | 2295817 | 2022-03-11 | Missaukee | Michigan | 26113 | 2886 | 59 |
2292523 | 2292523 | 2022-03-10 | Charlevoix | Michigan | 26029 | 4892 | 59 |
2292548 | 2292548 | 2022-03-10 | Kalkaska | Michigan | 26079 | 3497 | 59 |
2292565 | 2292565 | 2022-03-10 | Missaukee | Michigan | 26113 | 2886 | 59 |
2289271 | 2289271 | 2022-03-09 | Charlevoix | Michigan | 26029 | 4887 | 59 |
2289296 | 2289296 | 2022-03-09 | Kalkaska | Michigan | 26079 | 3497 | 59 |
2289313 | 2289313 | 2022-03-09 | Missaukee | Michigan | 26113 | 2886 | 59 |
2286020 | 2286020 | 2022-03-08 | Charlevoix | Michigan | 26029 | 4887 | 59 |
2286062 | 2286062 | 2022-03-08 | Missaukee | Michigan | 26113 | 2886 | 59 |
2282810 | 2282810 | 2022-03-07 | Missaukee | Michigan | 26113 | 2886 | 59 |
2263243 | 2263243 | 2022-03-01 | Antrim | Michigan | 26009 | 4264 | 59 |
2263295 | 2263295 | 2022-03-01 | Missaukee | Michigan | 26113 | 2878 | 59 |
2260044 | 2260044 | 2022-02-28 | Missaukee | Michigan | 26113 | 2878 | 59 |
2256793 | 2256793 | 2022-02-27 | Missaukee | Michigan | 26113 | 2870 | 59 |
2253542 | 2253542 | 2022-02-26 | Missaukee | Michigan | 26113 | 2870 | 59 |
2250291 | 2250291 | 2022-02-25 | Missaukee | Michigan | 26113 | 2870 | 59 |
2155919 | 2155919 | 2022-01-27 | Arenac | Michigan | 26011 | 2921 | 59 |
2155923 | 2155923 | 2022-01-27 | Benzie | Michigan | 26019 | 3152 | 59 |
2152666 | 2152666 | 2022-01-26 | Arenac | Michigan | 26011 | 2921 | 59 |
2152670 | 2152670 | 2022-01-26 | Benzie | Michigan | 26019 | 3152 | 59 |
2149414 | 2149414 | 2022-01-25 | Arenac | Michigan | 26011 | 2876 | 59 |
2146162 | 2146162 | 2022-01-24 | Arenac | Michigan | 26011 | 2876 | 59 |
2142907 | 2142907 | 2022-01-23 | Arenac | Michigan | 26011 | 2814 | 59 |
2139652 | 2139652 | 2022-01-22 | Arenac | Michigan | 26011 | 2814 | 59 |
2136396 | 2136396 | 2022-01-21 | Arenac | Michigan | 26011 | 2814 | 59 |
2103871 | 2103871 | 2022-01-11 | Alcona | Michigan | 26001 | 1486 | 59 |
2100620 | 2100620 | 2022-01-10 | Alcona | Michigan | 26001 | 1486 | 59 |
2097369 | 2097369 | 2022-01-09 | Alcona | Michigan | 26001 | 1462 | 59 |
2094117 | 2094117 | 2022-01-08 | Alcona | Michigan | 26001 | 1462 | 59 |
2090865 | 2090865 | 2022-01-07 | Alcona | Michigan | 26001 | 1462 | 59 |
2087614 | 2087614 | 2022-01-06 | Alcona | Michigan | 26001 | 1444 | 59 |
2084362 | 2084362 | 2022-01-05 | Alcona | Michigan | 26001 | 1444 | 59 |
2058378 | 2058378 | 2021-12-28 | Emmet | Michigan | 26047 | 4519 | 59 |
2055129 | 2055129 | 2021-12-27 | Emmet | Michigan | 26047 | 4519 | 59 |
2051879 | 2051879 | 2021-12-26 | Emmet | Michigan | 26047 | 4454 | 59 |
2048629 | 2048629 | 2021-12-25 | Emmet | Michigan | 26047 | 4454 | 59 |
2045379 | 2045379 | 2021-12-24 | Emmet | Michigan | 26047 | 4454 | 59 |
2042129 | 2042129 | 2021-12-23 | Emmet | Michigan | 26047 | 4454 | 59 |
2038880 | 2038880 | 2021-12-22 | Emmet | Michigan | 26047 | 4454 | 59 |
2029160 | 2029160 | 2021-12-19 | Menominee | Michigan | 26109 | 4111 | 59 |
2025909 | 2025909 | 2021-12-18 | Menominee | Michigan | 26109 | 4111 | 59 |
2022658 | 2022658 | 2021-12-17 | Menominee | Michigan | 26109 | 4111 | 59 |
2012878 | 2012878 | 2021-12-14 | Gogebic | Michigan | 26053 | 2238 | 59 |
2009627 | 2009627 | 2021-12-13 | Gogebic | Michigan | 26053 | 2238 | 59 |
1960897 | 1960897 | 2021-11-28 | Mecosta | Michigan | 26107 | 5593 | 59 |
1957646 | 1957646 | 2021-11-27 | Mecosta | Michigan | 26107 | 5593 | 59 |
1954395 | 1954395 | 2021-11-26 | Mecosta | Michigan | 26107 | 5593 | 59 |
1951144 | 1951144 | 2021-11-25 | Mecosta | Michigan | 26107 | 5593 | 59 |
1947893 | 1947893 | 2021-11-24 | Mecosta | Michigan | 26107 | 5593 | 59 |
1944619 | 1944619 | 2021-11-23 | Houghton | Michigan | 26061 | 5027 | 59 |
1941368 | 1941368 | 2021-11-22 | Houghton | Michigan | 26061 | 5027 | 59 |
1938118 | 1938118 | 2021-11-21 | Houghton | Michigan | 26061 | 4940 | 59 |
1934868 | 1934868 | 2021-11-20 | Houghton | Michigan | 26061 | 4940 | 59 |
1931618 | 1931618 | 2021-11-19 | Houghton | Michigan | 26061 | 4940 | 59 |
1921921 | 1921921 | 2021-11-16 | Wexford | Michigan | 26165 | 4123 | 59 |
1918671 | 1918671 | 2021-11-15 | Wexford | Michigan | 26165 | 4123 | 59 |
1899125 | 1899125 | 2021-11-09 | Iron | Michigan | 26071 | 1509 | 59 |
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);