ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26145 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947912 | 1947912 | 2021-11-24 | Saginaw | Michigan | 26145 | 32330 | 713 |
1944661 | 1944661 | 2021-11-23 | Saginaw | Michigan | 26145 | 31880 | 705 |
1941410 | 1941410 | 2021-11-22 | Saginaw | Michigan | 26145 | 31880 | 705 |
1938160 | 1938160 | 2021-11-21 | Saginaw | Michigan | 26145 | 31523 | 702 |
1934910 | 1934910 | 2021-11-20 | Saginaw | Michigan | 26145 | 31523 | 702 |
1931660 | 1931660 | 2021-11-19 | Saginaw | Michigan | 26145 | 31523 | 702 |
1928409 | 1928409 | 2021-11-18 | Saginaw | Michigan | 26145 | 31060 | 701 |
1925159 | 1925159 | 2021-11-17 | Saginaw | Michigan | 26145 | 31060 | 701 |
1921910 | 1921910 | 2021-11-16 | Saginaw | Michigan | 26145 | 30737 | 694 |
1918660 | 1918660 | 2021-11-15 | Saginaw | Michigan | 26145 | 30737 | 694 |
1915410 | 1915410 | 2021-11-14 | Saginaw | Michigan | 26145 | 30328 | 692 |
1912160 | 1912160 | 2021-11-13 | Saginaw | Michigan | 26145 | 30328 | 692 |
1908910 | 1908910 | 2021-11-12 | Saginaw | Michigan | 26145 | 30328 | 692 |
1905661 | 1905661 | 2021-11-11 | Saginaw | Michigan | 26145 | 30006 | 692 |
1902412 | 1902412 | 2021-11-10 | Saginaw | Michigan | 26145 | 30006 | 692 |
1899162 | 1899162 | 2021-11-09 | Saginaw | Michigan | 26145 | 29739 | 690 |
1895912 | 1895912 | 2021-11-08 | Saginaw | Michigan | 26145 | 29739 | 690 |
1892662 | 1892662 | 2021-11-07 | Saginaw | Michigan | 26145 | 29495 | 689 |
1889412 | 1889412 | 2021-11-06 | Saginaw | Michigan | 26145 | 29495 | 689 |
1886162 | 1886162 | 2021-11-05 | Saginaw | Michigan | 26145 | 29495 | 689 |
1882913 | 1882913 | 2021-11-04 | Saginaw | Michigan | 26145 | 29231 | 682 |
1879664 | 1879664 | 2021-11-03 | Saginaw | Michigan | 26145 | 29231 | 682 |
1876415 | 1876415 | 2021-11-02 | Saginaw | Michigan | 26145 | 28946 | 680 |
1873166 | 1873166 | 2021-11-01 | Saginaw | Michigan | 26145 | 28946 | 680 |
1869917 | 1869917 | 2021-10-31 | Saginaw | Michigan | 26145 | 28720 | 678 |
1866668 | 1866668 | 2021-10-30 | Saginaw | Michigan | 26145 | 28720 | 678 |
1863419 | 1863419 | 2021-10-29 | Saginaw | Michigan | 26145 | 28720 | 678 |
1860170 | 1860170 | 2021-10-28 | Saginaw | Michigan | 26145 | 28509 | 676 |
1856921 | 1856921 | 2021-10-27 | Saginaw | Michigan | 26145 | 28509 | 676 |
1853672 | 1853672 | 2021-10-26 | Saginaw | Michigan | 26145 | 28242 | 673 |
1850423 | 1850423 | 2021-10-25 | Saginaw | Michigan | 26145 | 28242 | 673 |
1847173 | 1847173 | 2021-10-24 | Saginaw | Michigan | 26145 | 28048 | 673 |
1843923 | 1843923 | 2021-10-23 | Saginaw | Michigan | 26145 | 28048 | 673 |
1840673 | 1840673 | 2021-10-22 | Saginaw | Michigan | 26145 | 28048 | 673 |
1837424 | 1837424 | 2021-10-21 | Saginaw | Michigan | 26145 | 27840 | 671 |
1834175 | 1834175 | 2021-10-20 | Saginaw | Michigan | 26145 | 27840 | 671 |
1830926 | 1830926 | 2021-10-19 | Saginaw | Michigan | 26145 | 27627 | 668 |
1827677 | 1827677 | 2021-10-18 | Saginaw | Michigan | 26145 | 27627 | 668 |
1824428 | 1824428 | 2021-10-17 | Saginaw | Michigan | 26145 | 27460 | 667 |
1821179 | 1821179 | 2021-10-16 | Saginaw | Michigan | 26145 | 27460 | 667 |
1817930 | 1817930 | 2021-10-15 | Saginaw | Michigan | 26145 | 27460 | 667 |
1814681 | 1814681 | 2021-10-14 | Saginaw | Michigan | 26145 | 27186 | 667 |
1811433 | 1811433 | 2021-10-13 | Saginaw | Michigan | 26145 | 27186 | 667 |
1808184 | 1808184 | 2021-10-12 | Saginaw | Michigan | 26145 | 26926 | 666 |
1804933 | 1804933 | 2021-10-11 | Saginaw | Michigan | 26145 | 26926 | 666 |
1801684 | 1801684 | 2021-10-10 | Saginaw | Michigan | 26145 | 26717 | 666 |
1798435 | 1798435 | 2021-10-09 | Saginaw | Michigan | 26145 | 26717 | 666 |
1795186 | 1795186 | 2021-10-08 | Saginaw | Michigan | 26145 | 26717 | 666 |
1791937 | 1791937 | 2021-10-07 | Saginaw | Michigan | 26145 | 26470 | 664 |
1788688 | 1788688 | 2021-10-06 | Saginaw | Michigan | 26145 | 26470 | 664 |
1785440 | 1785440 | 2021-10-05 | Saginaw | Michigan | 26145 | 26251 | 662 |
1782191 | 1782191 | 2021-10-04 | Saginaw | Michigan | 26145 | 26251 | 662 |
1778941 | 1778941 | 2021-10-03 | Saginaw | Michigan | 26145 | 26061 | 660 |
1775691 | 1775691 | 2021-10-02 | Saginaw | Michigan | 26145 | 26061 | 660 |
1772441 | 1772441 | 2021-10-01 | Saginaw | Michigan | 26145 | 26061 | 660 |
1769192 | 1769192 | 2021-09-30 | Saginaw | Michigan | 26145 | 25841 | 659 |
1765943 | 1765943 | 2021-09-29 | Saginaw | Michigan | 26145 | 25841 | 659 |
1762694 | 1762694 | 2021-09-28 | Saginaw | Michigan | 26145 | 25667 | 660 |
1759445 | 1759445 | 2021-09-27 | Saginaw | Michigan | 26145 | 25667 | 660 |
1756197 | 1756197 | 2021-09-26 | Saginaw | Michigan | 26145 | 25519 | 659 |
1752949 | 1752949 | 2021-09-25 | Saginaw | Michigan | 26145 | 25519 | 659 |
1749701 | 1749701 | 2021-09-24 | Saginaw | Michigan | 26145 | 25519 | 659 |
1746451 | 1746451 | 2021-09-23 | Saginaw | Michigan | 26145 | 25358 | 659 |
1743202 | 1743202 | 2021-09-22 | Saginaw | Michigan | 26145 | 25358 | 659 |
1739953 | 1739953 | 2021-09-21 | Saginaw | Michigan | 26145 | 25191 | 656 |
1736704 | 1736704 | 2021-09-20 | Saginaw | Michigan | 26145 | 25191 | 656 |
1733454 | 1733454 | 2021-09-19 | Saginaw | Michigan | 26145 | 25011 | 656 |
1730204 | 1730204 | 2021-09-18 | Saginaw | Michigan | 26145 | 25011 | 656 |
1726954 | 1726954 | 2021-09-17 | Saginaw | Michigan | 26145 | 25011 | 656 |
1723705 | 1723705 | 2021-09-16 | Saginaw | Michigan | 26145 | 24836 | 656 |
1720456 | 1720456 | 2021-09-15 | Saginaw | Michigan | 26145 | 24836 | 656 |
1717208 | 1717208 | 2021-09-14 | Saginaw | Michigan | 26145 | 24611 | 652 |
1713960 | 1713960 | 2021-09-13 | Saginaw | Michigan | 26145 | 24611 | 652 |
1710714 | 1710714 | 2021-09-12 | Saginaw | Michigan | 26145 | 24436 | 652 |
1707467 | 1707467 | 2021-09-11 | Saginaw | Michigan | 26145 | 24436 | 652 |
1704220 | 1704220 | 2021-09-10 | Saginaw | Michigan | 26145 | 24436 | 652 |
1700970 | 1700970 | 2021-09-09 | Saginaw | Michigan | 26145 | 24272 | 649 |
1697721 | 1697721 | 2021-09-08 | Saginaw | Michigan | 26145 | 24272 | 649 |
1694473 | 1694473 | 2021-09-07 | Saginaw | Michigan | 26145 | 24191 | 647 |
1691224 | 1691224 | 2021-09-06 | Saginaw | Michigan | 26145 | 24070 | 647 |
1687974 | 1687974 | 2021-09-05 | Saginaw | Michigan | 26145 | 24070 | 647 |
1684724 | 1684724 | 2021-09-04 | Saginaw | Michigan | 26145 | 24070 | 647 |
1681473 | 1681473 | 2021-09-03 | Saginaw | Michigan | 26145 | 24070 | 647 |
1678225 | 1678225 | 2021-09-02 | Saginaw | Michigan | 26145 | 23960 | 646 |
1674977 | 1674977 | 2021-09-01 | Saginaw | Michigan | 26145 | 23960 | 646 |
1671729 | 1671729 | 2021-08-31 | Saginaw | Michigan | 26145 | 23857 | 646 |
1668482 | 1668482 | 2021-08-30 | Saginaw | Michigan | 26145 | 23857 | 646 |
1665235 | 1665235 | 2021-08-29 | Saginaw | Michigan | 26145 | 23763 | 646 |
1661987 | 1661987 | 2021-08-28 | Saginaw | Michigan | 26145 | 23763 | 646 |
1658739 | 1658739 | 2021-08-27 | Saginaw | Michigan | 26145 | 23763 | 646 |
1655490 | 1655490 | 2021-08-26 | Saginaw | Michigan | 26145 | 23656 | 646 |
1652243 | 1652243 | 2021-08-25 | Saginaw | Michigan | 26145 | 23656 | 646 |
1648995 | 1648995 | 2021-08-24 | Saginaw | Michigan | 26145 | 23554 | 645 |
1645746 | 1645746 | 2021-08-23 | Saginaw | Michigan | 26145 | 23554 | 645 |
1642497 | 1642497 | 2021-08-22 | Saginaw | Michigan | 26145 | 23459 | 645 |
1639247 | 1639247 | 2021-08-21 | Saginaw | Michigan | 26145 | 23459 | 645 |
1635997 | 1635997 | 2021-08-20 | Saginaw | Michigan | 26145 | 23459 | 645 |
1632747 | 1632747 | 2021-08-19 | Saginaw | Michigan | 26145 | 23358 | 645 |
1629500 | 1629500 | 2021-08-18 | Saginaw | Michigan | 26145 | 23358 | 645 |
1626253 | 1626253 | 2021-08-17 | Saginaw | Michigan | 26145 | 23282 | 645 |
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);