ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
178 rows where deaths = 92 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500851 | 2500851 | 2022-05-13 | Houghton | Michigan | 26061 | 7982 | 92 |
2497593 | 2497593 | 2022-05-12 | Houghton | Michigan | 26061 | 7982 | 92 |
2494335 | 2494335 | 2022-05-11 | Houghton | Michigan | 26061 | 7982 | 92 |
2491077 | 2491077 | 2022-05-10 | Houghton | Michigan | 26061 | 7922 | 92 |
2487820 | 2487820 | 2022-05-09 | Houghton | Michigan | 26061 | 7922 | 92 |
2484562 | 2484562 | 2022-05-08 | Houghton | Michigan | 26061 | 7922 | 92 |
2481304 | 2481304 | 2022-05-07 | Houghton | Michigan | 26061 | 7922 | 92 |
2478046 | 2478046 | 2022-05-06 | Houghton | Michigan | 26061 | 7922 | 92 |
2474788 | 2474788 | 2022-05-05 | Houghton | Michigan | 26061 | 7922 | 92 |
2471531 | 2471531 | 2022-05-04 | Houghton | Michigan | 26061 | 7922 | 92 |
2468275 | 2468275 | 2022-05-03 | Houghton | Michigan | 26061 | 7867 | 92 |
2465020 | 2465020 | 2022-05-02 | Houghton | Michigan | 26061 | 7867 | 92 |
2461764 | 2461764 | 2022-05-01 | Houghton | Michigan | 26061 | 7867 | 92 |
2458508 | 2458508 | 2022-04-30 | Houghton | Michigan | 26061 | 7867 | 92 |
2455252 | 2455252 | 2022-04-29 | Houghton | Michigan | 26061 | 7867 | 92 |
2451996 | 2451996 | 2022-04-28 | Houghton | Michigan | 26061 | 7867 | 92 |
2448740 | 2448740 | 2022-04-27 | Houghton | Michigan | 26061 | 7867 | 92 |
2445484 | 2445484 | 2022-04-26 | Houghton | Michigan | 26061 | 7836 | 92 |
2445506 | 2445506 | 2022-04-26 | Mason | Michigan | 26105 | 6766 | 92 |
2442228 | 2442228 | 2022-04-25 | Houghton | Michigan | 26061 | 7836 | 92 |
2442250 | 2442250 | 2022-04-25 | Mason | Michigan | 26105 | 6766 | 92 |
2438972 | 2438972 | 2022-04-24 | Houghton | Michigan | 26061 | 7836 | 92 |
2438994 | 2438994 | 2022-04-24 | Mason | Michigan | 26105 | 6766 | 92 |
2435716 | 2435716 | 2022-04-23 | Houghton | Michigan | 26061 | 7836 | 92 |
2435738 | 2435738 | 2022-04-23 | Mason | Michigan | 26105 | 6766 | 92 |
2432460 | 2432460 | 2022-04-22 | Houghton | Michigan | 26061 | 7836 | 92 |
2432482 | 2432482 | 2022-04-22 | Mason | Michigan | 26105 | 6766 | 92 |
2429204 | 2429204 | 2022-04-21 | Houghton | Michigan | 26061 | 7836 | 92 |
2429226 | 2429226 | 2022-04-21 | Mason | Michigan | 26105 | 6766 | 92 |
2425948 | 2425948 | 2022-04-20 | Houghton | Michigan | 26061 | 7836 | 92 |
2425970 | 2425970 | 2022-04-20 | Mason | Michigan | 26105 | 6766 | 92 |
2422692 | 2422692 | 2022-04-19 | Houghton | Michigan | 26061 | 7812 | 92 |
2422714 | 2422714 | 2022-04-19 | Mason | Michigan | 26105 | 6749 | 92 |
2419436 | 2419436 | 2022-04-18 | Houghton | Michigan | 26061 | 7812 | 92 |
2419458 | 2419458 | 2022-04-18 | Mason | Michigan | 26105 | 6749 | 92 |
2416180 | 2416180 | 2022-04-17 | Houghton | Michigan | 26061 | 7812 | 92 |
2416202 | 2416202 | 2022-04-17 | Mason | Michigan | 26105 | 6749 | 92 |
2412924 | 2412924 | 2022-04-16 | Houghton | Michigan | 26061 | 7812 | 92 |
2412946 | 2412946 | 2022-04-16 | Mason | Michigan | 26105 | 6749 | 92 |
2409668 | 2409668 | 2022-04-15 | Houghton | Michigan | 26061 | 7812 | 92 |
2409690 | 2409690 | 2022-04-15 | Mason | Michigan | 26105 | 6749 | 92 |
2406412 | 2406412 | 2022-04-14 | Houghton | Michigan | 26061 | 7812 | 92 |
2406434 | 2406434 | 2022-04-14 | Mason | Michigan | 26105 | 6749 | 92 |
2403156 | 2403156 | 2022-04-13 | Houghton | Michigan | 26061 | 7812 | 92 |
2403178 | 2403178 | 2022-04-13 | Mason | Michigan | 26105 | 6749 | 92 |
2198277 | 2198277 | 2022-02-09 | Otsego | Michigan | 26137 | 5404 | 92 |
2195008 | 2195008 | 2022-02-08 | Mecosta | Michigan | 26107 | 8297 | 92 |
2195023 | 2195023 | 2022-02-08 | Otsego | Michigan | 26137 | 5404 | 92 |
2191754 | 2191754 | 2022-02-07 | Mecosta | Michigan | 26107 | 8297 | 92 |
2188501 | 2188501 | 2022-02-06 | Mecosta | Michigan | 26107 | 8243 | 92 |
2185248 | 2185248 | 2022-02-05 | Mecosta | Michigan | 26107 | 8243 | 92 |
2181996 | 2181996 | 2022-02-04 | Mecosta | Michigan | 26107 | 8243 | 92 |
2133222 | 2133222 | 2022-01-20 | Wexford | Michigan | 26165 | 5669 | 92 |
2129969 | 2129969 | 2022-01-19 | Wexford | Michigan | 26165 | 5669 | 92 |
2058376 | 2058376 | 2021-12-28 | Dickinson | Michigan | 26043 | 5076 | 92 |
2055127 | 2055127 | 2021-12-27 | Dickinson | Michigan | 26043 | 5076 | 92 |
2051877 | 2051877 | 2021-12-26 | Dickinson | Michigan | 26043 | 5022 | 92 |
2048627 | 2048627 | 2021-12-25 | Dickinson | Michigan | 26043 | 5022 | 92 |
2045377 | 2045377 | 2021-12-24 | Dickinson | Michigan | 26043 | 5022 | 92 |
2042127 | 2042127 | 2021-12-23 | Dickinson | Michigan | 26043 | 5022 | 92 |
2038878 | 2038878 | 2021-12-22 | Dickinson | Michigan | 26043 | 5022 | 92 |
2035628 | 2035628 | 2021-12-21 | Dickinson | Michigan | 26043 | 4983 | 92 |
2032378 | 2032378 | 2021-12-20 | Dickinson | Michigan | 26043 | 4983 | 92 |
2029127 | 2029127 | 2021-12-19 | Dickinson | Michigan | 26043 | 4960 | 92 |
2025876 | 2025876 | 2021-12-18 | Dickinson | Michigan | 26043 | 4960 | 92 |
2022625 | 2022625 | 2021-12-17 | Dickinson | Michigan | 26043 | 4960 | 92 |
2019374 | 2019374 | 2021-12-16 | Dickinson | Michigan | 26043 | 4931 | 92 |
2016124 | 2016124 | 2021-12-15 | Dickinson | Michigan | 26043 | 4931 | 92 |
2006421 | 2006421 | 2021-12-12 | Roscommon | Michigan | 26143 | 3466 | 92 |
2003170 | 2003170 | 2021-12-11 | Roscommon | Michigan | 26143 | 3466 | 92 |
1999920 | 1999920 | 2021-12-10 | Roscommon | Michigan | 26143 | 3466 | 92 |
1944650 | 1944650 | 2021-11-23 | Newaygo | Michigan | 26123 | 7571 | 92 |
1941399 | 1941399 | 2021-11-22 | Newaygo | Michigan | 26123 | 7571 | 92 |
1915345 | 1915345 | 2021-11-14 | Barry | Michigan | 26015 | 8591 | 92 |
1912095 | 1912095 | 2021-11-13 | Barry | Michigan | 26015 | 8591 | 92 |
1908845 | 1908845 | 2021-11-12 | Barry | Michigan | 26015 | 8591 | 92 |
1905596 | 1905596 | 2021-11-11 | Barry | Michigan | 26015 | 8436 | 92 |
1902347 | 1902347 | 2021-11-10 | Barry | Michigan | 26015 | 8436 | 92 |
1899097 | 1899097 | 2021-11-09 | Barry | Michigan | 26015 | 8325 | 92 |
1895847 | 1895847 | 2021-11-08 | Barry | Michigan | 26015 | 8325 | 92 |
1876356 | 1876356 | 2021-11-02 | Cass | Michigan | 26027 | 7216 | 92 |
1873107 | 1873107 | 2021-11-01 | Cass | Michigan | 26027 | 7216 | 92 |
1869858 | 1869858 | 2021-10-31 | Cass | Michigan | 26027 | 7174 | 92 |
1866609 | 1866609 | 2021-10-30 | Cass | Michigan | 26027 | 7174 | 92 |
1863360 | 1863360 | 2021-10-29 | Cass | Michigan | 26027 | 7174 | 92 |
1837386 | 1837386 | 2021-10-21 | Iosco | Michigan | 26069 | 2907 | 92 |
1834137 | 1834137 | 2021-10-20 | Iosco | Michigan | 26069 | 2907 | 92 |
1830888 | 1830888 | 2021-10-19 | Iosco | Michigan | 26069 | 2884 | 92 |
1827639 | 1827639 | 2021-10-18 | Iosco | Michigan | 26069 | 2884 | 92 |
1824390 | 1824390 | 2021-10-17 | Iosco | Michigan | 26069 | 2817 | 92 |
1821141 | 1821141 | 2021-10-16 | Iosco | Michigan | 26069 | 2817 | 92 |
1817892 | 1817892 | 2021-10-15 | Iosco | Michigan | 26069 | 2817 | 92 |
1785385 | 1785385 | 2021-10-05 | Clare | Michigan | 26035 | 3188 | 92 |
1782136 | 1782136 | 2021-10-04 | Clare | Michigan | 26035 | 3188 | 92 |
1778886 | 1778886 | 2021-10-03 | Clare | Michigan | 26035 | 3115 | 92 |
1778902 | 1778902 | 2021-10-03 | Ionia | Michigan | 26067 | 10727 | 92 |
1775636 | 1775636 | 2021-10-02 | Clare | Michigan | 26035 | 3115 | 92 |
1775652 | 1775652 | 2021-10-02 | Ionia | Michigan | 26067 | 10727 | 92 |
1772386 | 1772386 | 2021-10-01 | Clare | Michigan | 26035 | 3115 | 92 |
1772402 | 1772402 | 2021-10-01 | Ionia | Michigan | 26067 | 10727 | 92 |
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);