ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where deaths = 223 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
state 1
- Michigan · 53 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445509 | 2445509 | 2022-04-26 | Midland | Michigan | 26111 | 19090 | 223 |
2442253 | 2442253 | 2022-04-25 | Midland | Michigan | 26111 | 19090 | 223 |
2438997 | 2438997 | 2022-04-24 | Midland | Michigan | 26111 | 19090 | 223 |
2435741 | 2435741 | 2022-04-23 | Midland | Michigan | 26111 | 19090 | 223 |
2432485 | 2432485 | 2022-04-22 | Midland | Michigan | 26111 | 19090 | 223 |
2429229 | 2429229 | 2022-04-21 | Midland | Michigan | 26111 | 19090 | 223 |
2425973 | 2425973 | 2022-04-20 | Midland | Michigan | 26111 | 19090 | 223 |
2422717 | 2422717 | 2022-04-19 | Midland | Michigan | 26111 | 19051 | 223 |
2419461 | 2419461 | 2022-04-18 | Midland | Michigan | 26111 | 19051 | 223 |
2416205 | 2416205 | 2022-04-17 | Midland | Michigan | 26111 | 19051 | 223 |
2412949 | 2412949 | 2022-04-16 | Midland | Michigan | 26111 | 19051 | 223 |
2409693 | 2409693 | 2022-04-15 | Midland | Michigan | 26111 | 19051 | 223 |
2406437 | 2406437 | 2022-04-14 | Midland | Michigan | 26111 | 19051 | 223 |
2403181 | 2403181 | 2022-04-13 | Midland | Michigan | 26111 | 19051 | 223 |
2399927 | 2399927 | 2022-04-12 | Midland | Michigan | 26111 | 19021 | 223 |
2396671 | 2396671 | 2022-04-11 | Midland | Michigan | 26111 | 19021 | 223 |
2393416 | 2393416 | 2022-04-10 | Midland | Michigan | 26111 | 19021 | 223 |
2390160 | 2390160 | 2022-04-09 | Midland | Michigan | 26111 | 19021 | 223 |
2386904 | 2386904 | 2022-04-08 | Midland | Michigan | 26111 | 19021 | 223 |
2383649 | 2383649 | 2022-04-07 | Midland | Michigan | 26111 | 19021 | 223 |
2380394 | 2380394 | 2022-04-06 | Midland | Michigan | 26111 | 19021 | 223 |
2377139 | 2377139 | 2022-04-05 | Midland | Michigan | 26111 | 19016 | 223 |
2373887 | 2373887 | 2022-04-04 | Midland | Michigan | 26111 | 19016 | 223 |
2370634 | 2370634 | 2022-04-03 | Midland | Michigan | 26111 | 19016 | 223 |
2367381 | 2367381 | 2022-04-02 | Midland | Michigan | 26111 | 19016 | 223 |
2364128 | 2364128 | 2022-04-01 | Midland | Michigan | 26111 | 19016 | 223 |
2360874 | 2360874 | 2022-03-31 | Midland | Michigan | 26111 | 19010 | 223 |
2357620 | 2357620 | 2022-03-30 | Midland | Michigan | 26111 | 19010 | 223 |
2354367 | 2354367 | 2022-03-29 | Midland | Michigan | 26111 | 19007 | 223 |
2351115 | 2351115 | 2022-03-28 | Midland | Michigan | 26111 | 19007 | 223 |
2347862 | 2347862 | 2022-03-27 | Midland | Michigan | 26111 | 19003 | 223 |
2344609 | 2344609 | 2022-03-26 | Midland | Michigan | 26111 | 19003 | 223 |
2341356 | 2341356 | 2022-03-25 | Midland | Michigan | 26111 | 19003 | 223 |
2338103 | 2338103 | 2022-03-24 | Midland | Michigan | 26111 | 18998 | 223 |
2334849 | 2334849 | 2022-03-23 | Midland | Michigan | 26111 | 18998 | 223 |
2263314 | 2263314 | 2022-03-01 | Shiawassee | Michigan | 26155 | 17619 | 223 |
2260063 | 2260063 | 2022-02-28 | Shiawassee | Michigan | 26155 | 17619 | 223 |
2256812 | 2256812 | 2022-02-27 | Shiawassee | Michigan | 26155 | 17583 | 223 |
2253561 | 2253561 | 2022-02-26 | Shiawassee | Michigan | 26155 | 17583 | 223 |
2250310 | 2250310 | 2022-02-25 | Shiawassee | Michigan | 26155 | 17583 | 223 |
1990174 | 1990174 | 2021-12-07 | Tuscola | Michigan | 26157 | 9206 | 223 |
1986924 | 1986924 | 2021-12-06 | Tuscola | Michigan | 26157 | 9206 | 223 |
1983598 | 1983598 | 2021-12-05 | Allegan | Michigan | 26005 | 18568 | 223 |
1980348 | 1980348 | 2021-12-04 | Allegan | Michigan | 26005 | 18568 | 223 |
1977098 | 1977098 | 2021-12-03 | Allegan | Michigan | 26005 | 18568 | 223 |
954171 | 954171 | 2021-01-22 | Jackson | Michigan | 26075 | 13066 | 223 |
950926 | 950926 | 2021-01-21 | Jackson | Michigan | 26075 | 13036 | 223 |
924957 | 924957 | 2021-01-13 | Ingham | Michigan | 26065 | 13771 | 223 |
921688 | 921688 | 2021-01-12 | Bay | Michigan | 26017 | 6726 | 223 |
769222 | 769222 | 2020-11-26 | Saginaw | Michigan | 26145 | 7928 | 223 |
765976 | 765976 | 2020-11-25 | Saginaw | Michigan | 26145 | 7928 | 223 |
128445 | 128445 | 2020-05-09 | Genesee | Michigan | 26049 | 1750 | 223 |
29437 | 29437 | 2020-04-03 | Wayne | Michigan | 26163 | 6096 | 223 |
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);