ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "St. Clair" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110449 | 2110449 | 2022-01-13 | St. Clair | Michigan | 26147 | 34077 | 707 |
2107198 | 2107198 | 2022-01-12 | St. Clair | Michigan | 26147 | 34077 | 707 |
2103947 | 2103947 | 2022-01-11 | St. Clair | Michigan | 26147 | 33829 | 704 |
2100696 | 2100696 | 2022-01-10 | St. Clair | Michigan | 26147 | 33541 | 695 |
2097445 | 2097445 | 2022-01-09 | St. Clair | Michigan | 26147 | 33220 | 695 |
2094193 | 2094193 | 2022-01-08 | St. Clair | Michigan | 26147 | 32792 | 694 |
2090941 | 2090941 | 2022-01-07 | St. Clair | Michigan | 26147 | 32792 | 694 |
2087690 | 2087690 | 2022-01-06 | St. Clair | Michigan | 26147 | 32336 | 689 |
2084438 | 2084438 | 2022-01-05 | St. Clair | Michigan | 26147 | 32046 | 686 |
2081186 | 2081186 | 2022-01-04 | St. Clair | Michigan | 26147 | 31855 | 686 |
2077934 | 2077934 | 2022-01-03 | St. Clair | Michigan | 26147 | 31613 | 681 |
2074683 | 2074683 | 2022-01-02 | St. Clair | Michigan | 26147 | 31456 | 663 |
2071432 | 2071432 | 2022-01-01 | St. Clair | Michigan | 26147 | 31062 | 663 |
2068181 | 2068181 | 2021-12-31 | St. Clair | Michigan | 26147 | 31062 | 663 |
2064930 | 2064930 | 2021-12-30 | St. Clair | Michigan | 26147 | 30888 | 663 |
2061680 | 2061680 | 2021-12-29 | St. Clair | Michigan | 26147 | 30663 | 663 |
2058431 | 2058431 | 2021-12-28 | St. Clair | Michigan | 26147 | 30414 | 642 |
2055182 | 2055182 | 2021-12-27 | St. Clair | Michigan | 26147 | 30293 | 642 |
2051932 | 2051932 | 2021-12-26 | St. Clair | Michigan | 26147 | 30245 | 633 |
2048682 | 2048682 | 2021-12-25 | St. Clair | Michigan | 26147 | 30096 | 633 |
2045432 | 2045432 | 2021-12-24 | St. Clair | Michigan | 26147 | 30096 | 633 |
2042182 | 2042182 | 2021-12-23 | St. Clair | Michigan | 26147 | 29984 | 633 |
2038933 | 2038933 | 2021-12-22 | St. Clair | Michigan | 26147 | 29816 | 633 |
2035683 | 2035683 | 2021-12-21 | St. Clair | Michigan | 26147 | 29481 | 619 |
2032433 | 2032433 | 2021-12-20 | St. Clair | Michigan | 26147 | 29481 | 619 |
2029182 | 2029182 | 2021-12-19 | St. Clair | Michigan | 26147 | 29435 | 616 |
2025931 | 2025931 | 2021-12-18 | St. Clair | Michigan | 26147 | 29221 | 616 |
2022680 | 2022680 | 2021-12-17 | St. Clair | Michigan | 26147 | 29221 | 616 |
2019429 | 2019429 | 2021-12-16 | St. Clair | Michigan | 26147 | 29047 | 605 |
2016179 | 2016179 | 2021-12-15 | St. Clair | Michigan | 26147 | 28877 | 605 |
2012928 | 2012928 | 2021-12-14 | St. Clair | Michigan | 26147 | 28745 | 591 |
2009677 | 2009677 | 2021-12-13 | St. Clair | Michigan | 26147 | 28629 | 591 |
2006426 | 2006426 | 2021-12-12 | St. Clair | Michigan | 26147 | 28465 | 589 |
2003175 | 2003175 | 2021-12-11 | St. Clair | Michigan | 26147 | 28237 | 589 |
1999925 | 1999925 | 2021-12-10 | St. Clair | Michigan | 26147 | 28237 | 589 |
1996674 | 1996674 | 2021-12-09 | St. Clair | Michigan | 26147 | 28046 | 577 |
1993423 | 1993423 | 2021-12-08 | St. Clair | Michigan | 26147 | 27902 | 577 |
1990172 | 1990172 | 2021-12-07 | St. Clair | Michigan | 26147 | 27715 | 569 |
1986922 | 1986922 | 2021-12-06 | St. Clair | Michigan | 26147 | 27557 | 569 |
1983672 | 1983672 | 2021-12-05 | St. Clair | Michigan | 26147 | 27431 | 562 |
1980422 | 1980422 | 2021-12-04 | St. Clair | Michigan | 26147 | 27089 | 562 |
1977172 | 1977172 | 2021-12-03 | St. Clair | Michigan | 26147 | 27089 | 562 |
1973922 | 1973922 | 2021-12-02 | St. Clair | Michigan | 26147 | 26862 | 562 |
1970673 | 1970673 | 2021-12-01 | St. Clair | Michigan | 26147 | 26600 | 562 |
1967423 | 1967423 | 2021-11-30 | St. Clair | Michigan | 26147 | 26387 | 554 |
1964171 | 1964171 | 2021-11-29 | St. Clair | Michigan | 26147 | 26222 | 554 |
1960920 | 1960920 | 2021-11-28 | St. Clair | Michigan | 26147 | 26063 | 552 |
1957669 | 1957669 | 2021-11-27 | St. Clair | Michigan | 26147 | 25863 | 552 |
1954418 | 1954418 | 2021-11-26 | St. Clair | Michigan | 26147 | 25863 | 552 |
1951167 | 1951167 | 2021-11-25 | St. Clair | Michigan | 26147 | 25821 | 552 |
1947916 | 1947916 | 2021-11-24 | St. Clair | Michigan | 26147 | 25659 | 552 |
1944665 | 1944665 | 2021-11-23 | St. Clair | Michigan | 26147 | 25385 | 545 |
1941414 | 1941414 | 2021-11-22 | St. Clair | Michigan | 26147 | 25186 | 545 |
1938164 | 1938164 | 2021-11-21 | St. Clair | Michigan | 26147 | 25078 | 541 |
1934914 | 1934914 | 2021-11-20 | St. Clair | Michigan | 26147 | 25021 | 541 |
1931664 | 1931664 | 2021-11-19 | St. Clair | Michigan | 26147 | 24887 | 541 |
1928413 | 1928413 | 2021-11-18 | St. Clair | Michigan | 26147 | 24655 | 537 |
1925163 | 1925163 | 2021-11-17 | St. Clair | Michigan | 26147 | 24482 | 537 |
1921914 | 1921914 | 2021-11-16 | St. Clair | Michigan | 26147 | 24298 | 533 |
1918664 | 1918664 | 2021-11-15 | St. Clair | Michigan | 26147 | 24084 | 533 |
1915414 | 1915414 | 2021-11-14 | St. Clair | Michigan | 26147 | 24009 | 532 |
1912164 | 1912164 | 2021-11-13 | St. Clair | Michigan | 26147 | 23719 | 532 |
1908914 | 1908914 | 2021-11-12 | St. Clair | Michigan | 26147 | 23719 | 532 |
1905665 | 1905665 | 2021-11-11 | St. Clair | Michigan | 26147 | 23437 | 532 |
1902416 | 1902416 | 2021-11-10 | St. Clair | Michigan | 26147 | 23437 | 532 |
1899166 | 1899166 | 2021-11-09 | St. Clair | Michigan | 26147 | 23381 | 527 |
1895916 | 1895916 | 2021-11-08 | St. Clair | Michigan | 26147 | 23270 | 527 |
1892666 | 1892666 | 2021-11-07 | St. Clair | Michigan | 26147 | 23249 | 527 |
1889416 | 1889416 | 2021-11-06 | St. Clair | Michigan | 26147 | 23124 | 527 |
1886166 | 1886166 | 2021-11-05 | St. Clair | Michigan | 26147 | 23124 | 527 |
1882917 | 1882917 | 2021-11-04 | St. Clair | Michigan | 26147 | 22993 | 525 |
1879668 | 1879668 | 2021-11-03 | St. Clair | Michigan | 26147 | 22907 | 525 |
1876419 | 1876419 | 2021-11-02 | St. Clair | Michigan | 26147 | 22824 | 521 |
1873170 | 1873170 | 2021-11-01 | St. Clair | Michigan | 26147 | 22718 | 521 |
1869921 | 1869921 | 2021-10-31 | St. Clair | Michigan | 26147 | 22662 | 517 |
1866672 | 1866672 | 2021-10-30 | St. Clair | Michigan | 26147 | 22590 | 517 |
1863423 | 1863423 | 2021-10-29 | St. Clair | Michigan | 26147 | 22590 | 517 |
1860174 | 1860174 | 2021-10-28 | St. Clair | Michigan | 26147 | 22502 | 515 |
1856925 | 1856925 | 2021-10-27 | St. Clair | Michigan | 26147 | 22420 | 515 |
1853676 | 1853676 | 2021-10-26 | St. Clair | Michigan | 26147 | 22352 | 512 |
1850427 | 1850427 | 2021-10-25 | St. Clair | Michigan | 26147 | 22270 | 512 |
1847177 | 1847177 | 2021-10-24 | St. Clair | Michigan | 26147 | 22145 | 511 |
1843927 | 1843927 | 2021-10-23 | St. Clair | Michigan | 26147 | 22145 | 511 |
1840677 | 1840677 | 2021-10-22 | St. Clair | Michigan | 26147 | 22145 | 511 |
1837428 | 1837428 | 2021-10-21 | St. Clair | Michigan | 26147 | 22058 | 509 |
1834179 | 1834179 | 2021-10-20 | St. Clair | Michigan | 26147 | 21970 | 509 |
1830930 | 1830930 | 2021-10-19 | St. Clair | Michigan | 26147 | 21918 | 503 |
1827681 | 1827681 | 2021-10-18 | St. Clair | Michigan | 26147 | 21837 | 503 |
1824432 | 1824432 | 2021-10-17 | St. Clair | Michigan | 26147 | 21807 | 503 |
1821183 | 1821183 | 2021-10-16 | St. Clair | Michigan | 26147 | 21672 | 503 |
1817934 | 1817934 | 2021-10-15 | St. Clair | Michigan | 26147 | 21672 | 503 |
1814685 | 1814685 | 2021-10-14 | St. Clair | Michigan | 26147 | 21579 | 503 |
1811437 | 1811437 | 2021-10-13 | St. Clair | Michigan | 26147 | 21517 | 503 |
1808188 | 1808188 | 2021-10-12 | St. Clair | Michigan | 26147 | 21433 | 498 |
1804937 | 1804937 | 2021-10-11 | St. Clair | Michigan | 26147 | 21337 | 498 |
1801688 | 1801688 | 2021-10-10 | St. Clair | Michigan | 26147 | 21193 | 497 |
1798439 | 1798439 | 2021-10-09 | St. Clair | Michigan | 26147 | 21193 | 497 |
1795190 | 1795190 | 2021-10-08 | St. Clair | Michigan | 26147 | 21193 | 497 |
1791941 | 1791941 | 2021-10-07 | St. Clair | Michigan | 26147 | 21102 | 495 |
1788692 | 1788692 | 2021-10-06 | St. Clair | Michigan | 26147 | 21038 | 495 |
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);