ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26111 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947895 | 1947895 | 2021-11-24 | Midland | Michigan | 26111 | 11815 | 156 |
1944644 | 1944644 | 2021-11-23 | Midland | Michigan | 26111 | 11666 | 156 |
1941393 | 1941393 | 2021-11-22 | Midland | Michigan | 26111 | 11666 | 156 |
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 |
1928392 | 1928392 | 2021-11-18 | Midland | Michigan | 26111 | 11412 | 150 |
1925142 | 1925142 | 2021-11-17 | Midland | Michigan | 26111 | 11412 | 150 |
1921893 | 1921893 | 2021-11-16 | Midland | Michigan | 26111 | 11295 | 150 |
1918643 | 1918643 | 2021-11-15 | Midland | Michigan | 26111 | 11295 | 150 |
1915393 | 1915393 | 2021-11-14 | Midland | Michigan | 26111 | 11092 | 149 |
1912143 | 1912143 | 2021-11-13 | Midland | Michigan | 26111 | 11092 | 149 |
1908893 | 1908893 | 2021-11-12 | Midland | Michigan | 26111 | 11092 | 149 |
1905644 | 1905644 | 2021-11-11 | Midland | Michigan | 26111 | 10977 | 146 |
1902395 | 1902395 | 2021-11-10 | Midland | Michigan | 26111 | 10977 | 146 |
1899145 | 1899145 | 2021-11-09 | Midland | Michigan | 26111 | 10896 | 145 |
1895895 | 1895895 | 2021-11-08 | Midland | Michigan | 26111 | 10896 | 145 |
1892645 | 1892645 | 2021-11-07 | Midland | Michigan | 26111 | 10766 | 143 |
1889395 | 1889395 | 2021-11-06 | Midland | Michigan | 26111 | 10766 | 143 |
1886145 | 1886145 | 2021-11-05 | Midland | Michigan | 26111 | 10766 | 143 |
1882896 | 1882896 | 2021-11-04 | Midland | Michigan | 26111 | 10674 | 143 |
1879647 | 1879647 | 2021-11-03 | Midland | Michigan | 26111 | 10674 | 143 |
1876398 | 1876398 | 2021-11-02 | Midland | Michigan | 26111 | 10542 | 138 |
1873149 | 1873149 | 2021-11-01 | Midland | Michigan | 26111 | 10542 | 138 |
1869900 | 1869900 | 2021-10-31 | Midland | Michigan | 26111 | 10458 | 136 |
1866651 | 1866651 | 2021-10-30 | Midland | Michigan | 26111 | 10458 | 136 |
1863402 | 1863402 | 2021-10-29 | Midland | Michigan | 26111 | 10458 | 136 |
1860153 | 1860153 | 2021-10-28 | Midland | Michigan | 26111 | 10379 | 134 |
1856904 | 1856904 | 2021-10-27 | Midland | Michigan | 26111 | 10379 | 134 |
1853655 | 1853655 | 2021-10-26 | Midland | Michigan | 26111 | 10258 | 130 |
1850406 | 1850406 | 2021-10-25 | Midland | Michigan | 26111 | 10258 | 130 |
1847156 | 1847156 | 2021-10-24 | Midland | Michigan | 26111 | 10164 | 129 |
1843906 | 1843906 | 2021-10-23 | Midland | Michigan | 26111 | 10164 | 129 |
1840656 | 1840656 | 2021-10-22 | Midland | Michigan | 26111 | 10164 | 129 |
1837407 | 1837407 | 2021-10-21 | Midland | Michigan | 26111 | 10072 | 128 |
1834158 | 1834158 | 2021-10-20 | Midland | Michigan | 26111 | 10072 | 128 |
1830909 | 1830909 | 2021-10-19 | Midland | Michigan | 26111 | 9972 | 125 |
1827660 | 1827660 | 2021-10-18 | Midland | Michigan | 26111 | 9972 | 125 |
1824411 | 1824411 | 2021-10-17 | Midland | Michigan | 26111 | 9874 | 125 |
1821162 | 1821162 | 2021-10-16 | Midland | Michigan | 26111 | 9874 | 125 |
1817913 | 1817913 | 2021-10-15 | Midland | Michigan | 26111 | 9874 | 125 |
1814664 | 1814664 | 2021-10-14 | Midland | Michigan | 26111 | 9756 | 126 |
1811416 | 1811416 | 2021-10-13 | Midland | Michigan | 26111 | 9756 | 126 |
1808167 | 1808167 | 2021-10-12 | Midland | Michigan | 26111 | 9624 | 125 |
1804916 | 1804916 | 2021-10-11 | Midland | Michigan | 26111 | 9624 | 125 |
1801667 | 1801667 | 2021-10-10 | Midland | Michigan | 26111 | 9475 | 124 |
1798418 | 1798418 | 2021-10-09 | Midland | Michigan | 26111 | 9475 | 124 |
1795169 | 1795169 | 2021-10-08 | Midland | Michigan | 26111 | 9475 | 124 |
1791920 | 1791920 | 2021-10-07 | Midland | Michigan | 26111 | 9369 | 120 |
1788671 | 1788671 | 2021-10-06 | Midland | Michigan | 26111 | 9369 | 120 |
1785423 | 1785423 | 2021-10-05 | Midland | Michigan | 26111 | 9236 | 120 |
1782174 | 1782174 | 2021-10-04 | Midland | Michigan | 26111 | 9236 | 120 |
1778924 | 1778924 | 2021-10-03 | Midland | Michigan | 26111 | 9126 | 119 |
1775674 | 1775674 | 2021-10-02 | Midland | Michigan | 26111 | 9126 | 119 |
1772424 | 1772424 | 2021-10-01 | Midland | Michigan | 26111 | 9126 | 119 |
1769175 | 1769175 | 2021-09-30 | Midland | Michigan | 26111 | 9052 | 115 |
1765926 | 1765926 | 2021-09-29 | Midland | Michigan | 26111 | 9052 | 115 |
1762677 | 1762677 | 2021-09-28 | Midland | Michigan | 26111 | 8948 | 114 |
1759428 | 1759428 | 2021-09-27 | Midland | Michigan | 26111 | 8948 | 114 |
1756180 | 1756180 | 2021-09-26 | Midland | Michigan | 26111 | 8851 | 114 |
1752932 | 1752932 | 2021-09-25 | Midland | Michigan | 26111 | 8851 | 114 |
1749684 | 1749684 | 2021-09-24 | Midland | Michigan | 26111 | 8851 | 114 |
1746434 | 1746434 | 2021-09-23 | Midland | Michigan | 26111 | 8758 | 110 |
1743185 | 1743185 | 2021-09-22 | Midland | Michigan | 26111 | 8758 | 110 |
1739936 | 1739936 | 2021-09-21 | Midland | Michigan | 26111 | 8654 | 108 |
1736687 | 1736687 | 2021-09-20 | Midland | Michigan | 26111 | 8654 | 108 |
1733437 | 1733437 | 2021-09-19 | Midland | Michigan | 26111 | 8549 | 106 |
1730187 | 1730187 | 2021-09-18 | Midland | Michigan | 26111 | 8549 | 106 |
1726937 | 1726937 | 2021-09-17 | Midland | Michigan | 26111 | 8549 | 106 |
1723688 | 1723688 | 2021-09-16 | Midland | Michigan | 26111 | 8483 | 106 |
1720439 | 1720439 | 2021-09-15 | Midland | Michigan | 26111 | 8483 | 106 |
1717191 | 1717191 | 2021-09-14 | Midland | Michigan | 26111 | 8405 | 106 |
1713943 | 1713943 | 2021-09-13 | Midland | Michigan | 26111 | 8405 | 106 |
1710697 | 1710697 | 2021-09-12 | Midland | Michigan | 26111 | 8324 | 105 |
1707450 | 1707450 | 2021-09-11 | Midland | Michigan | 26111 | 8324 | 105 |
1704203 | 1704203 | 2021-09-10 | Midland | Michigan | 26111 | 8324 | 105 |
1700953 | 1700953 | 2021-09-09 | Midland | Michigan | 26111 | 8251 | 105 |
1697704 | 1697704 | 2021-09-08 | Midland | Michigan | 26111 | 8251 | 105 |
1694456 | 1694456 | 2021-09-07 | Midland | Michigan | 26111 | 8226 | 103 |
1691207 | 1691207 | 2021-09-06 | Midland | Michigan | 26111 | 8147 | 103 |
1687957 | 1687957 | 2021-09-05 | Midland | Michigan | 26111 | 8147 | 103 |
1684707 | 1684707 | 2021-09-04 | Midland | Michigan | 26111 | 8147 | 103 |
1681456 | 1681456 | 2021-09-03 | Midland | Michigan | 26111 | 8147 | 103 |
1678208 | 1678208 | 2021-09-02 | Midland | Michigan | 26111 | 8089 | 102 |
1674960 | 1674960 | 2021-09-01 | Midland | Michigan | 26111 | 8089 | 102 |
1671712 | 1671712 | 2021-08-31 | Midland | Michigan | 26111 | 8019 | 101 |
1668465 | 1668465 | 2021-08-30 | Midland | Michigan | 26111 | 8019 | 101 |
1665218 | 1665218 | 2021-08-29 | Midland | Michigan | 26111 | 7960 | 100 |
1661970 | 1661970 | 2021-08-28 | Midland | Michigan | 26111 | 7960 | 100 |
1658722 | 1658722 | 2021-08-27 | Midland | Michigan | 26111 | 7960 | 100 |
1655473 | 1655473 | 2021-08-26 | Midland | Michigan | 26111 | 7920 | 100 |
1652226 | 1652226 | 2021-08-25 | Midland | Michigan | 26111 | 7920 | 100 |
1648978 | 1648978 | 2021-08-24 | Midland | Michigan | 26111 | 7880 | 100 |
1645729 | 1645729 | 2021-08-23 | Midland | Michigan | 26111 | 7880 | 100 |
1642480 | 1642480 | 2021-08-22 | Midland | Michigan | 26111 | 7853 | 99 |
1639230 | 1639230 | 2021-08-21 | Midland | Michigan | 26111 | 7853 | 99 |
1635980 | 1635980 | 2021-08-20 | Midland | Michigan | 26111 | 7853 | 99 |
1632730 | 1632730 | 2021-08-19 | Midland | Michigan | 26111 | 7822 | 97 |
1629483 | 1629483 | 2021-08-18 | Midland | Michigan | 26111 | 7822 | 97 |
1626236 | 1626236 | 2021-08-17 | Midland | Michigan | 26111 | 7806 | 97 |
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);