ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
435 rows where deaths = 8 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Isabella 49
- Eaton 29
- Midland 29
- Alger 19
- Ionia 17
- Missaukee 16
- Antrim 15
- Iosco 14
- Huron 12
- Luce 12
- Otsego 12
- Schoolcraft 12
- Marquette 10
- Van Buren 10
- Alpena 9
- Charlevoix 9
- Keweenaw 9
- Leelanau 9
- Allegan 7
- Cass 7
- Delta 7
- Lake 7
- St. Joseph 7
- Unknown 7
- Benzie 6
- Montcalm 6
- Oceana 6
- Gladwin 5
- Washtenaw 5
- Alcona 4
- …
state 1
- Michigan · 435 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2172233 | 2172233 | 2022-02-01 | Luce | Michigan | 26095 | 2186 | 8 |
2168980 | 2168980 | 2022-01-31 | Luce | Michigan | 26095 | 2186 | 8 |
2165725 | 2165725 | 2022-01-30 | Luce | Michigan | 26095 | 2179 | 8 |
2162470 | 2162470 | 2022-01-29 | Luce | Michigan | 26095 | 2179 | 8 |
2159215 | 2159215 | 2022-01-28 | Luce | Michigan | 26095 | 2179 | 8 |
2155961 | 2155961 | 2022-01-27 | Luce | Michigan | 26095 | 2168 | 8 |
2152708 | 2152708 | 2022-01-26 | Luce | Michigan | 26095 | 2168 | 8 |
2149456 | 2149456 | 2022-01-25 | Luce | Michigan | 26095 | 2142 | 8 |
2146204 | 2146204 | 2022-01-24 | Luce | Michigan | 26095 | 2142 | 8 |
2142949 | 2142949 | 2022-01-23 | Luce | Michigan | 26095 | 2112 | 8 |
2139694 | 2139694 | 2022-01-22 | Luce | Michigan | 26095 | 2112 | 8 |
2136438 | 2136438 | 2022-01-21 | Luce | Michigan | 26095 | 2112 | 8 |
2074681 | 2074681 | 2022-01-02 | Schoolcraft | Michigan | 26153 | 1203 | 8 |
2071430 | 2071430 | 2022-01-01 | Schoolcraft | Michigan | 26153 | 1203 | 8 |
2068179 | 2068179 | 2021-12-31 | Schoolcraft | Michigan | 26153 | 1203 | 8 |
2064928 | 2064928 | 2021-12-30 | Schoolcraft | Michigan | 26153 | 1203 | 8 |
2061678 | 2061678 | 2021-12-29 | Schoolcraft | Michigan | 26153 | 1203 | 8 |
2058429 | 2058429 | 2021-12-28 | Schoolcraft | Michigan | 26153 | 1198 | 8 |
2055180 | 2055180 | 2021-12-27 | Schoolcraft | Michigan | 26153 | 1198 | 8 |
2051930 | 2051930 | 2021-12-26 | Schoolcraft | Michigan | 26153 | 1184 | 8 |
2048680 | 2048680 | 2021-12-25 | Schoolcraft | Michigan | 26153 | 1184 | 8 |
2045430 | 2045430 | 2021-12-24 | Schoolcraft | Michigan | 26153 | 1184 | 8 |
2042180 | 2042180 | 2021-12-23 | Schoolcraft | Michigan | 26153 | 1184 | 8 |
2038931 | 2038931 | 2021-12-22 | Schoolcraft | Michigan | 26153 | 1184 | 8 |
1967388 | 1967388 | 2021-11-30 | Keweenaw | Michigan | 26083 | 359 | 8 |
1964136 | 1964136 | 2021-11-29 | Keweenaw | Michigan | 26083 | 359 | 8 |
1960885 | 1960885 | 2021-11-28 | Keweenaw | Michigan | 26083 | 351 | 8 |
1957634 | 1957634 | 2021-11-27 | Keweenaw | Michigan | 26083 | 351 | 8 |
1954383 | 1954383 | 2021-11-26 | Keweenaw | Michigan | 26083 | 351 | 8 |
1951132 | 1951132 | 2021-11-25 | Keweenaw | Michigan | 26083 | 351 | 8 |
1947881 | 1947881 | 2021-11-24 | Keweenaw | Michigan | 26083 | 351 | 8 |
1944630 | 1944630 | 2021-11-23 | Keweenaw | Michigan | 26083 | 344 | 8 |
1941379 | 1941379 | 2021-11-22 | Keweenaw | Michigan | 26083 | 344 | 8 |
1847102 | 1847102 | 2021-10-24 | Alger | Michigan | 26003 | 995 | 8 |
1843852 | 1843852 | 2021-10-23 | Alger | Michigan | 26003 | 995 | 8 |
1840602 | 1840602 | 2021-10-22 | Alger | Michigan | 26003 | 995 | 8 |
1837353 | 1837353 | 2021-10-21 | Alger | Michigan | 26003 | 989 | 8 |
1837400 | 1837400 | 2021-10-21 | Mackinac | Michigan | 26097 | 1247 | 8 |
1834104 | 1834104 | 2021-10-20 | Alger | Michigan | 26003 | 989 | 8 |
1834151 | 1834151 | 2021-10-20 | Mackinac | Michigan | 26097 | 1247 | 8 |
1830855 | 1830855 | 2021-10-19 | Alger | Michigan | 26003 | 984 | 8 |
1827606 | 1827606 | 2021-10-18 | Alger | Michigan | 26003 | 984 | 8 |
1824357 | 1824357 | 2021-10-17 | Alger | Michigan | 26003 | 978 | 8 |
1821108 | 1821108 | 2021-10-16 | Alger | Michigan | 26003 | 978 | 8 |
1817859 | 1817859 | 2021-10-15 | Alger | Michigan | 26003 | 978 | 8 |
1814610 | 1814610 | 2021-10-14 | Alger | Michigan | 26003 | 972 | 8 |
1811362 | 1811362 | 2021-10-13 | Alger | Michigan | 26003 | 972 | 8 |
1808113 | 1808113 | 2021-10-12 | Alger | Michigan | 26003 | 953 | 8 |
1804862 | 1804862 | 2021-10-11 | Alger | Michigan | 26003 | 953 | 8 |
1801613 | 1801613 | 2021-10-10 | Alger | Michigan | 26003 | 944 | 8 |
1798364 | 1798364 | 2021-10-09 | Alger | Michigan | 26003 | 944 | 8 |
1795115 | 1795115 | 2021-10-08 | Alger | Michigan | 26003 | 944 | 8 |
1791866 | 1791866 | 2021-10-07 | Alger | Michigan | 26003 | 921 | 8 |
1788617 | 1788617 | 2021-10-06 | Alger | Michigan | 26003 | 921 | 8 |
915234 | 915234 | 2021-01-10 | Leelanau | Michigan | 26089 | 694 | 8 |
911989 | 911989 | 2021-01-09 | Leelanau | Michigan | 26089 | 694 | 8 |
908744 | 908744 | 2021-01-08 | Leelanau | Michigan | 26089 | 682 | 8 |
905498 | 905498 | 2021-01-07 | Leelanau | Michigan | 26089 | 674 | 8 |
902253 | 902253 | 2021-01-06 | Leelanau | Michigan | 26089 | 664 | 8 |
899008 | 899008 | 2021-01-05 | Leelanau | Michigan | 26089 | 657 | 8 |
895763 | 895763 | 2021-01-04 | Leelanau | Michigan | 26089 | 649 | 8 |
892516 | 892516 | 2021-01-03 | Leelanau | Michigan | 26089 | 640 | 8 |
889270 | 889270 | 2021-01-02 | Leelanau | Michigan | 26089 | 640 | 8 |
886036 | 886036 | 2021-01-01 | Missaukee | Michigan | 26113 | 481 | 8 |
882791 | 882791 | 2020-12-31 | Missaukee | Michigan | 26113 | 481 | 8 |
879546 | 879546 | 2020-12-30 | Missaukee | Michigan | 26113 | 481 | 8 |
876301 | 876301 | 2020-12-29 | Missaukee | Michigan | 26113 | 448 | 8 |
873056 | 873056 | 2020-12-28 | Missaukee | Michigan | 26113 | 440 | 8 |
869811 | 869811 | 2020-12-27 | Missaukee | Michigan | 26113 | 438 | 8 |
866566 | 866566 | 2020-12-26 | Missaukee | Michigan | 26113 | 438 | 8 |
863269 | 863269 | 2020-12-25 | Antrim | Michigan | 26009 | 586 | 8 |
863307 | 863307 | 2020-12-25 | Lake | Michigan | 26085 | 291 | 8 |
863321 | 863321 | 2020-12-25 | Missaukee | Michigan | 26113 | 424 | 8 |
860024 | 860024 | 2020-12-24 | Antrim | Michigan | 26009 | 586 | 8 |
860062 | 860062 | 2020-12-24 | Lake | Michigan | 26085 | 291 | 8 |
860076 | 860076 | 2020-12-24 | Missaukee | Michigan | 26113 | 424 | 8 |
856779 | 856779 | 2020-12-23 | Antrim | Michigan | 26009 | 586 | 8 |
856817 | 856817 | 2020-12-23 | Lake | Michigan | 26085 | 291 | 8 |
856831 | 856831 | 2020-12-23 | Missaukee | Michigan | 26113 | 424 | 8 |
853534 | 853534 | 2020-12-22 | Antrim | Michigan | 26009 | 581 | 8 |
853572 | 853572 | 2020-12-22 | Lake | Michigan | 26085 | 288 | 8 |
853586 | 853586 | 2020-12-22 | Missaukee | Michigan | 26113 | 419 | 8 |
850289 | 850289 | 2020-12-21 | Antrim | Michigan | 26009 | 578 | 8 |
850327 | 850327 | 2020-12-21 | Lake | Michigan | 26085 | 284 | 8 |
850341 | 850341 | 2020-12-21 | Missaukee | Michigan | 26113 | 415 | 8 |
847044 | 847044 | 2020-12-20 | Antrim | Michigan | 26009 | 577 | 8 |
847082 | 847082 | 2020-12-20 | Lake | Michigan | 26085 | 283 | 8 |
847096 | 847096 | 2020-12-20 | Missaukee | Michigan | 26113 | 405 | 8 |
847099 | 847099 | 2020-12-20 | Montmorency | Michigan | 26119 | 255 | 8 |
843798 | 843798 | 2020-12-19 | Antrim | Michigan | 26009 | 577 | 8 |
843836 | 843836 | 2020-12-19 | Lake | Michigan | 26085 | 283 | 8 |
843850 | 843850 | 2020-12-19 | Missaukee | Michigan | 26113 | 405 | 8 |
843853 | 843853 | 2020-12-19 | Montmorency | Michigan | 26119 | 255 | 8 |
840563 | 840563 | 2020-12-18 | Charlevoix | Michigan | 26029 | 810 | 8 |
840605 | 840605 | 2020-12-18 | Missaukee | Michigan | 26113 | 403 | 8 |
840608 | 840608 | 2020-12-18 | Montmorency | Michigan | 26119 | 272 | 8 |
837318 | 837318 | 2020-12-17 | Charlevoix | Michigan | 26029 | 804 | 8 |
837360 | 837360 | 2020-12-17 | Missaukee | Michigan | 26113 | 400 | 8 |
834062 | 834062 | 2020-12-16 | Antrim | Michigan | 26009 | 561 | 8 |
834072 | 834072 | 2020-12-16 | Charlevoix | Michigan | 26029 | 794 | 8 |
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);