ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where deaths = 205 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445465 | 2445465 | 2022-04-26 | Branch | Michigan | 26023 | 12185 | 205 |
2442209 | 2442209 | 2022-04-25 | Branch | Michigan | 26023 | 12185 | 205 |
2438953 | 2438953 | 2022-04-24 | Branch | Michigan | 26023 | 12185 | 205 |
2435697 | 2435697 | 2022-04-23 | Branch | Michigan | 26023 | 12185 | 205 |
2432441 | 2432441 | 2022-04-22 | Branch | Michigan | 26023 | 12185 | 205 |
2429185 | 2429185 | 2022-04-21 | Branch | Michigan | 26023 | 12185 | 205 |
2425929 | 2425929 | 2022-04-20 | Branch | Michigan | 26023 | 12185 | 205 |
2422673 | 2422673 | 2022-04-19 | Branch | Michigan | 26023 | 12171 | 205 |
2419417 | 2419417 | 2022-04-18 | Branch | Michigan | 26023 | 12171 | 205 |
2416161 | 2416161 | 2022-04-17 | Branch | Michigan | 26023 | 12171 | 205 |
2412905 | 2412905 | 2022-04-16 | Branch | Michigan | 26023 | 12171 | 205 |
2409649 | 2409649 | 2022-04-15 | Branch | Michigan | 26023 | 12171 | 205 |
2406393 | 2406393 | 2022-04-14 | Branch | Michigan | 26023 | 12171 | 205 |
2403137 | 2403137 | 2022-04-13 | Branch | Michigan | 26023 | 12171 | 205 |
2399883 | 2399883 | 2022-04-12 | Branch | Michigan | 26023 | 12157 | 205 |
2396627 | 2396627 | 2022-04-11 | Branch | Michigan | 26023 | 12157 | 205 |
2393372 | 2393372 | 2022-04-10 | Branch | Michigan | 26023 | 12157 | 205 |
2390116 | 2390116 | 2022-04-09 | Branch | Michigan | 26023 | 12157 | 205 |
2386860 | 2386860 | 2022-04-08 | Branch | Michigan | 26023 | 12157 | 205 |
2383605 | 2383605 | 2022-04-07 | Branch | Michigan | 26023 | 12157 | 205 |
2380350 | 2380350 | 2022-04-06 | Branch | Michigan | 26023 | 12157 | 205 |
2377095 | 2377095 | 2022-04-05 | Branch | Michigan | 26023 | 12153 | 205 |
2373843 | 2373843 | 2022-04-04 | Branch | Michigan | 26023 | 12153 | 205 |
2370590 | 2370590 | 2022-04-03 | Branch | Michigan | 26023 | 12153 | 205 |
2367337 | 2367337 | 2022-04-02 | Branch | Michigan | 26023 | 12153 | 205 |
2364084 | 2364084 | 2022-04-01 | Branch | Michigan | 26023 | 12153 | 205 |
2360830 | 2360830 | 2022-03-31 | Branch | Michigan | 26023 | 12149 | 205 |
2357576 | 2357576 | 2022-03-30 | Branch | Michigan | 26023 | 12149 | 205 |
2354323 | 2354323 | 2022-03-29 | Branch | Michigan | 26023 | 12138 | 205 |
2354389 | 2354389 | 2022-03-29 | St. Joseph | Michigan | 26149 | 13643 | 205 |
2351071 | 2351071 | 2022-03-28 | Branch | Michigan | 26023 | 12138 | 205 |
2351137 | 2351137 | 2022-03-28 | St. Joseph | Michigan | 26149 | 13643 | 205 |
2347818 | 2347818 | 2022-03-27 | Branch | Michigan | 26023 | 12136 | 205 |
2347884 | 2347884 | 2022-03-27 | St. Joseph | Michigan | 26149 | 13641 | 205 |
2344565 | 2344565 | 2022-03-26 | Branch | Michigan | 26023 | 12136 | 205 |
2344631 | 2344631 | 2022-03-26 | St. Joseph | Michigan | 26149 | 13641 | 205 |
2341312 | 2341312 | 2022-03-25 | Branch | Michigan | 26023 | 12136 | 205 |
2341378 | 2341378 | 2022-03-25 | St. Joseph | Michigan | 26149 | 13641 | 205 |
2338059 | 2338059 | 2022-03-24 | Branch | Michigan | 26023 | 12133 | 205 |
2338084 | 2338084 | 2022-03-24 | Isabella | Michigan | 26073 | 15503 | 205 |
2338125 | 2338125 | 2022-03-24 | St. Joseph | Michigan | 26149 | 13640 | 205 |
2334805 | 2334805 | 2022-03-23 | Branch | Michigan | 26023 | 12133 | 205 |
2334830 | 2334830 | 2022-03-23 | Isabella | Michigan | 26073 | 15503 | 205 |
2334871 | 2334871 | 2022-03-23 | St. Joseph | Michigan | 26149 | 13640 | 205 |
2331617 | 2331617 | 2022-03-22 | St. Joseph | Michigan | 26149 | 13636 | 205 |
2328365 | 2328365 | 2022-03-21 | St. Joseph | Michigan | 26149 | 13636 | 205 |
2325112 | 2325112 | 2022-03-20 | St. Joseph | Michigan | 26149 | 13635 | 205 |
2321858 | 2321858 | 2022-03-19 | St. Joseph | Michigan | 26149 | 13635 | 205 |
2318604 | 2318604 | 2022-03-18 | St. Joseph | Michigan | 26149 | 13635 | 205 |
2315351 | 2315351 | 2022-03-17 | St. Joseph | Michigan | 26149 | 13629 | 205 |
2312098 | 2312098 | 2022-03-16 | St. Joseph | Michigan | 26149 | 13629 | 205 |
2286064 | 2286064 | 2022-03-08 | Montcalm | Michigan | 26117 | 17051 | 205 |
2282812 | 2282812 | 2022-03-07 | Montcalm | Michigan | 26117 | 17051 | 205 |
2279559 | 2279559 | 2022-03-06 | Montcalm | Michigan | 26117 | 17042 | 205 |
2276306 | 2276306 | 2022-03-05 | Montcalm | Michigan | 26117 | 17042 | 205 |
2273053 | 2273053 | 2022-03-04 | Montcalm | Michigan | 26117 | 17042 | 205 |
2269801 | 2269801 | 2022-03-03 | Montcalm | Michigan | 26117 | 17032 | 205 |
2266548 | 2266548 | 2022-03-02 | Montcalm | Michigan | 26117 | 17032 | 205 |
2217752 | 2217752 | 2022-02-15 | Grand Traverse | Michigan | 26055 | 16609 | 205 |
2214501 | 2214501 | 2022-02-14 | Grand Traverse | Michigan | 26055 | 16609 | 205 |
2178746 | 2178746 | 2022-02-03 | Midland | Michigan | 26111 | 18082 | 205 |
2175494 | 2175494 | 2022-02-02 | Midland | Michigan | 26111 | 18082 | 205 |
1921916 | 1921916 | 2021-11-16 | Tuscola | Michigan | 26157 | 8151 | 205 |
1918666 | 1918666 | 2021-11-15 | Tuscola | Michigan | 26157 | 8151 | 205 |
1356748 | 1356748 | 2021-05-26 | Lapeer | Michigan | 26087 | 9686 | 205 |
1353502 | 1353502 | 2021-05-25 | Lapeer | Michigan | 26087 | 9678 | 205 |
1350256 | 1350256 | 2021-05-24 | Lapeer | Michigan | 26087 | 9674 | 205 |
1340492 | 1340492 | 2021-05-21 | Eaton | Michigan | 26045 | 10035 | 205 |
1337245 | 1337245 | 2021-05-20 | Eaton | Michigan | 26045 | 10026 | 205 |
1113230 | 1113230 | 2021-03-12 | Monroe | Michigan | 26115 | 10289 | 205 |
1109984 | 1109984 | 2021-03-11 | Monroe | Michigan | 26115 | 10234 | 205 |
1106738 | 1106738 | 2021-03-10 | Monroe | Michigan | 26115 | 10182 | 205 |
1103492 | 1103492 | 2021-03-09 | Monroe | Michigan | 26115 | 10125 | 205 |
941163 | 941163 | 2021-01-18 | Calhoun | Michigan | 26025 | 8501 | 205 |
941227 | 941227 | 2021-01-18 | St. Clair | Michigan | 26147 | 7909 | 205 |
931492 | 931492 | 2021-01-15 | St. Clair | Michigan | 26147 | 7855 | 205 |
918445 | 918445 | 2021-01-11 | Berrien | Michigan | 26021 | 9994 | 205 |
915200 | 915200 | 2021-01-10 | Berrien | Michigan | 26021 | 9929 | 205 |
911955 | 911955 | 2021-01-09 | Berrien | Michigan | 26021 | 9903 | 205 |
908710 | 908710 | 2021-01-08 | Berrien | Michigan | 26021 | 9850 | 205 |
905464 | 905464 | 2021-01-07 | Berrien | Michigan | 26021 | 9790 | 205 |
892553 | 892553 | 2021-01-03 | Washtenaw | Michigan | 26161 | 14372 | 205 |
889307 | 889307 | 2021-01-02 | Washtenaw | Michigan | 26161 | 14372 | 205 |
814649 | 814649 | 2020-12-10 | Ottawa | Michigan | 26139 | 16235 | 205 |
39191 | 39191 | 2020-04-07 | Oakland | Michigan | 26125 | 3736 | 205 |
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);