ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Saginaw" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110445 | 2110445 | 2022-01-13 | Saginaw | Michigan | 26145 | 40757 | 833 |
2107194 | 2107194 | 2022-01-12 | Saginaw | Michigan | 26145 | 40757 | 833 |
2103943 | 2103943 | 2022-01-11 | Saginaw | Michigan | 26145 | 40133 | 823 |
2100692 | 2100692 | 2022-01-10 | Saginaw | Michigan | 26145 | 40133 | 823 |
2097441 | 2097441 | 2022-01-09 | Saginaw | Michigan | 26145 | 39313 | 823 |
2094189 | 2094189 | 2022-01-08 | Saginaw | Michigan | 26145 | 39313 | 823 |
2090937 | 2090937 | 2022-01-07 | Saginaw | Michigan | 26145 | 39313 | 823 |
2087686 | 2087686 | 2022-01-06 | Saginaw | Michigan | 26145 | 38409 | 818 |
2084434 | 2084434 | 2022-01-05 | Saginaw | Michigan | 26145 | 38409 | 818 |
2081182 | 2081182 | 2022-01-04 | Saginaw | Michigan | 26145 | 37955 | 800 |
2077930 | 2077930 | 2022-01-03 | Saginaw | Michigan | 26145 | 37955 | 800 |
2074679 | 2074679 | 2022-01-02 | Saginaw | Michigan | 26145 | 37159 | 792 |
2071428 | 2071428 | 2022-01-01 | Saginaw | Michigan | 26145 | 37159 | 792 |
2068177 | 2068177 | 2021-12-31 | Saginaw | Michigan | 26145 | 37159 | 792 |
2064926 | 2064926 | 2021-12-30 | Saginaw | Michigan | 26145 | 37159 | 792 |
2061676 | 2061676 | 2021-12-29 | Saginaw | Michigan | 26145 | 37159 | 792 |
2058427 | 2058427 | 2021-12-28 | Saginaw | Michigan | 26145 | 36748 | 788 |
2055178 | 2055178 | 2021-12-27 | Saginaw | Michigan | 26145 | 36748 | 788 |
2051928 | 2051928 | 2021-12-26 | Saginaw | Michigan | 26145 | 36249 | 784 |
2048678 | 2048678 | 2021-12-25 | Saginaw | Michigan | 26145 | 36249 | 784 |
2045428 | 2045428 | 2021-12-24 | Saginaw | Michigan | 26145 | 36249 | 784 |
2042178 | 2042178 | 2021-12-23 | Saginaw | Michigan | 26145 | 36249 | 784 |
2038929 | 2038929 | 2021-12-22 | Saginaw | Michigan | 26145 | 36249 | 784 |
2035679 | 2035679 | 2021-12-21 | Saginaw | Michigan | 26145 | 35998 | 766 |
2032429 | 2032429 | 2021-12-20 | Saginaw | Michigan | 26145 | 35998 | 766 |
2029178 | 2029178 | 2021-12-19 | Saginaw | Michigan | 26145 | 35726 | 762 |
2025927 | 2025927 | 2021-12-18 | Saginaw | Michigan | 26145 | 35726 | 762 |
2022676 | 2022676 | 2021-12-17 | Saginaw | Michigan | 26145 | 35726 | 762 |
2019425 | 2019425 | 2021-12-16 | Saginaw | Michigan | 26145 | 35451 | 757 |
2016175 | 2016175 | 2021-12-15 | Saginaw | Michigan | 26145 | 35451 | 757 |
2012924 | 2012924 | 2021-12-14 | Saginaw | Michigan | 26145 | 35162 | 748 |
2009673 | 2009673 | 2021-12-13 | Saginaw | Michigan | 26145 | 35162 | 748 |
2006422 | 2006422 | 2021-12-12 | Saginaw | Michigan | 26145 | 34755 | 744 |
2003171 | 2003171 | 2021-12-11 | Saginaw | Michigan | 26145 | 34755 | 744 |
1999921 | 1999921 | 2021-12-10 | Saginaw | Michigan | 26145 | 34755 | 744 |
1996670 | 1996670 | 2021-12-09 | Saginaw | Michigan | 26145 | 34451 | 741 |
1993419 | 1993419 | 2021-12-08 | Saginaw | Michigan | 26145 | 34451 | 741 |
1990168 | 1990168 | 2021-12-07 | Saginaw | Michigan | 26145 | 34105 | 733 |
1986918 | 1986918 | 2021-12-06 | Saginaw | Michigan | 26145 | 34105 | 733 |
1983668 | 1983668 | 2021-12-05 | Saginaw | Michigan | 26145 | 33727 | 729 |
1980418 | 1980418 | 2021-12-04 | Saginaw | Michigan | 26145 | 33727 | 729 |
1977168 | 1977168 | 2021-12-03 | Saginaw | Michigan | 26145 | 33727 | 729 |
1973918 | 1973918 | 2021-12-02 | Saginaw | Michigan | 26145 | 33225 | 723 |
1970669 | 1970669 | 2021-12-01 | Saginaw | Michigan | 26145 | 33225 | 723 |
1967419 | 1967419 | 2021-11-30 | Saginaw | Michigan | 26145 | 32814 | 714 |
1964167 | 1964167 | 2021-11-29 | Saginaw | Michigan | 26145 | 32814 | 714 |
1960916 | 1960916 | 2021-11-28 | Saginaw | Michigan | 26145 | 32330 | 713 |
1957665 | 1957665 | 2021-11-27 | Saginaw | Michigan | 26145 | 32330 | 713 |
1954414 | 1954414 | 2021-11-26 | Saginaw | Michigan | 26145 | 32330 | 713 |
1951163 | 1951163 | 2021-11-25 | Saginaw | Michigan | 26145 | 32330 | 713 |
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 |
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);