ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where deaths = 154 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2331560 | 2331560 | 2022-03-22 | Delta | Michigan | 26041 | 9916 | 154 |
2328308 | 2328308 | 2022-03-21 | Delta | Michigan | 26041 | 9916 | 154 |
2325055 | 2325055 | 2022-03-20 | Delta | Michigan | 26041 | 9912 | 154 |
2321801 | 2321801 | 2022-03-19 | Delta | Michigan | 26041 | 9912 | 154 |
2318547 | 2318547 | 2022-03-18 | Delta | Michigan | 26041 | 9912 | 154 |
2315294 | 2315294 | 2022-03-17 | Delta | Michigan | 26041 | 9909 | 154 |
2315335 | 2315335 | 2022-03-17 | Newaygo | Michigan | 26123 | 11432 | 154 |
2312041 | 2312041 | 2022-03-16 | Delta | Michigan | 26041 | 9909 | 154 |
2312082 | 2312082 | 2022-03-16 | Newaygo | Michigan | 26123 | 11432 | 154 |
2308788 | 2308788 | 2022-03-15 | Delta | Michigan | 26041 | 9909 | 154 |
2308829 | 2308829 | 2022-03-15 | Newaygo | Michigan | 26123 | 11432 | 154 |
2305537 | 2305537 | 2022-03-14 | Delta | Michigan | 26041 | 9909 | 154 |
2305578 | 2305578 | 2022-03-14 | Newaygo | Michigan | 26123 | 11432 | 154 |
2302285 | 2302285 | 2022-03-13 | Delta | Michigan | 26041 | 9904 | 154 |
2302326 | 2302326 | 2022-03-13 | Newaygo | Michigan | 26123 | 11422 | 154 |
2299033 | 2299033 | 2022-03-12 | Delta | Michigan | 26041 | 9904 | 154 |
2299074 | 2299074 | 2022-03-12 | Newaygo | Michigan | 26123 | 11422 | 154 |
2295781 | 2295781 | 2022-03-11 | Delta | Michigan | 26041 | 9904 | 154 |
2295822 | 2295822 | 2022-03-11 | Newaygo | Michigan | 26123 | 11422 | 154 |
2292526 | 2292526 | 2022-03-10 | Clare | Michigan | 26035 | 6709 | 154 |
2289274 | 2289274 | 2022-03-09 | Clare | Michigan | 26035 | 6709 | 154 |
2029124 | 2029124 | 2021-12-19 | Clinton | Michigan | 26037 | 13574 | 154 |
2025873 | 2025873 | 2021-12-18 | Clinton | Michigan | 26037 | 13574 | 154 |
2022622 | 2022622 | 2021-12-17 | Clinton | Michigan | 26037 | 13574 | 154 |
2012880 | 2012880 | 2021-12-14 | Gratiot | Michigan | 26057 | 10341 | 154 |
2009629 | 2009629 | 2021-12-13 | Gratiot | Michigan | 26057 | 10341 | 154 |
2006361 | 2006361 | 2021-12-12 | Branch | Michigan | 26023 | 8964 | 154 |
2003110 | 2003110 | 2021-12-11 | Branch | Michigan | 26023 | 8964 | 154 |
1999860 | 1999860 | 2021-12-10 | Branch | Michigan | 26023 | 8964 | 154 |
1996625 | 1996625 | 2021-12-09 | Grand Traverse | Michigan | 26055 | 11434 | 154 |
1996671 | 1996671 | 2021-12-09 | Sanilac | Michigan | 26151 | 6343 | 154 |
1993374 | 1993374 | 2021-12-08 | Grand Traverse | Michigan | 26055 | 11434 | 154 |
1993420 | 1993420 | 2021-12-08 | Sanilac | Michigan | 26151 | 6343 | 154 |
1983654 | 1983654 | 2021-12-05 | Montcalm | Michigan | 26117 | 12769 | 154 |
1983671 | 1983671 | 2021-12-05 | Shiawassee | Michigan | 26155 | 11435 | 154 |
1980404 | 1980404 | 2021-12-04 | Montcalm | Michigan | 26117 | 12769 | 154 |
1980421 | 1980421 | 2021-12-04 | Shiawassee | Michigan | 26155 | 11435 | 154 |
1977154 | 1977154 | 2021-12-03 | Montcalm | Michigan | 26117 | 12769 | 154 |
1977171 | 1977171 | 2021-12-03 | Shiawassee | Michigan | 26155 | 11435 | 154 |
1938143 | 1938143 | 2021-11-21 | Midland | Michigan | 26111 | 11539 | 154 |
1934893 | 1934893 | 2021-11-20 | Midland | Michigan | 26111 | 11539 | 154 |
1931643 | 1931643 | 2021-11-19 | Midland | Michigan | 26111 | 11539 | 154 |
1801692 | 1801692 | 2021-10-10 | Van Buren | Michigan | 26159 | 8706 | 154 |
1798443 | 1798443 | 2021-10-09 | Van Buren | Michigan | 26159 | 8706 | 154 |
1795194 | 1795194 | 2021-10-08 | Van Buren | Michigan | 26159 | 8706 | 154 |
1791945 | 1791945 | 2021-10-07 | Van Buren | Michigan | 26159 | 8633 | 154 |
1788696 | 1788696 | 2021-10-06 | Van Buren | Michigan | 26159 | 8633 | 154 |
1408637 | 1408637 | 2021-06-11 | Allegan | Michigan | 26005 | 11149 | 154 |
1239900 | 1239900 | 2021-04-20 | Tuscola | Michigan | 26157 | 5111 | 154 |
1236653 | 1236653 | 2021-04-19 | Tuscola | Michigan | 26157 | 5067 | 154 |
1174913 | 1174913 | 2021-03-31 | Livingston | Michigan | 26093 | 12354 | 154 |
1171666 | 1171666 | 2021-03-30 | Livingston | Michigan | 26093 | 12240 | 154 |
1168418 | 1168418 | 2021-03-29 | Livingston | Michigan | 26093 | 12144 | 154 |
1165170 | 1165170 | 2021-03-28 | Livingston | Michigan | 26093 | 11911 | 154 |
1161922 | 1161922 | 2021-03-27 | Livingston | Michigan | 26093 | 11911 | 154 |
1158674 | 1158674 | 2021-03-26 | Livingston | Michigan | 26093 | 11798 | 154 |
1155427 | 1155427 | 2021-03-25 | Livingston | Michigan | 26093 | 11712 | 154 |
1152180 | 1152180 | 2021-03-24 | Livingston | Michigan | 26093 | 11600 | 154 |
1148933 | 1148933 | 2021-03-23 | Livingston | Michigan | 26093 | 11529 | 154 |
892529 | 892529 | 2021-01-03 | Monroe | Michigan | 26115 | 7808 | 154 |
889283 | 889283 | 2021-01-02 | Monroe | Michigan | 26115 | 7808 | 154 |
834066 | 834066 | 2020-12-16 | Bay | Michigan | 26017 | 5613 | 154 |
830821 | 830821 | 2020-12-15 | Berrien | Michigan | 26021 | 8530 | 154 |
749713 | 749713 | 2020-11-20 | Kalamazoo | Michigan | 26077 | 8175 | 154 |
671893 | 671893 | 2020-10-27 | Saginaw | Michigan | 26145 | 3877 | 154 |
668651 | 668651 | 2020-10-26 | Saginaw | Michigan | 26145 | 3792 | 154 |
403296 | 403296 | 2020-08-05 | Kent | Michigan | 26081 | 7342 | 154 |
400079 | 400079 | 2020-08-04 | Kent | Michigan | 26081 | 7300 | 154 |
396865 | 396865 | 2020-08-03 | Kent | Michigan | 26081 | 7239 | 154 |
393649 | 393649 | 2020-08-02 | Kent | Michigan | 26081 | 7204 | 154 |
390432 | 390432 | 2020-08-01 | Kent | Michigan | 26081 | 7111 | 154 |
387215 | 387215 | 2020-07-31 | Kent | Michigan | 26081 | 7059 | 154 |
383997 | 383997 | 2020-07-30 | Kent | Michigan | 26081 | 6997 | 154 |
380780 | 380780 | 2020-07-29 | Kent | Michigan | 26081 | 6951 | 154 |
377563 | 377563 | 2020-07-28 | Kent | Michigan | 26081 | 6908 | 154 |
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);