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 |
---|---|---|---|---|---|---|---|
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 |
1785444 | 1785444 | 2021-10-05 | St. Clair | Michigan | 26147 | 20958 | 493 |
1782195 | 1782195 | 2021-10-04 | St. Clair | Michigan | 26147 | 20859 | 493 |
1778945 | 1778945 | 2021-10-03 | St. Clair | Michigan | 26147 | 20825 | 493 |
1775695 | 1775695 | 2021-10-02 | St. Clair | Michigan | 26147 | 20715 | 493 |
1772445 | 1772445 | 2021-10-01 | St. Clair | Michigan | 26147 | 20715 | 493 |
1769196 | 1769196 | 2021-09-30 | St. Clair | Michigan | 26147 | 20618 | 486 |
1765947 | 1765947 | 2021-09-29 | St. Clair | Michigan | 26147 | 20531 | 486 |
1762698 | 1762698 | 2021-09-28 | St. Clair | Michigan | 26147 | 20472 | 482 |
1759449 | 1759449 | 2021-09-27 | St. Clair | Michigan | 26147 | 20386 | 482 |
1756201 | 1756201 | 2021-09-26 | St. Clair | Michigan | 26147 | 20365 | 479 |
1752953 | 1752953 | 2021-09-25 | St. Clair | Michigan | 26147 | 20293 | 479 |
1749705 | 1749705 | 2021-09-24 | St. Clair | Michigan | 26147 | 20293 | 479 |
1746455 | 1746455 | 2021-09-23 | St. Clair | Michigan | 26147 | 20260 | 475 |
1743206 | 1743206 | 2021-09-22 | St. Clair | Michigan | 26147 | 20163 | 475 |
1739957 | 1739957 | 2021-09-21 | St. Clair | Michigan | 26147 | 20091 | 477 |
1736708 | 1736708 | 2021-09-20 | St. Clair | Michigan | 26147 | 20012 | 477 |
1733458 | 1733458 | 2021-09-19 | St. Clair | Michigan | 26147 | 19990 | 474 |
1730208 | 1730208 | 2021-09-18 | St. Clair | Michigan | 26147 | 19912 | 474 |
1726958 | 1726958 | 2021-09-17 | St. Clair | Michigan | 26147 | 19912 | 474 |
1723709 | 1723709 | 2021-09-16 | St. Clair | Michigan | 26147 | 19870 | 472 |
1720460 | 1720460 | 2021-09-15 | St. Clair | Michigan | 26147 | 19816 | 472 |
1717212 | 1717212 | 2021-09-14 | St. Clair | Michigan | 26147 | 19764 | 468 |
1713964 | 1713964 | 2021-09-13 | St. Clair | Michigan | 26147 | 19702 | 468 |
1710718 | 1710718 | 2021-09-12 | St. Clair | Michigan | 26147 | 19625 | 465 |
1707471 | 1707471 | 2021-09-11 | St. Clair | Michigan | 26147 | 19625 | 465 |
1704224 | 1704224 | 2021-09-10 | St. Clair | Michigan | 26147 | 19625 | 465 |
1700974 | 1700974 | 2021-09-09 | St. Clair | Michigan | 26147 | 19580 | 465 |
1697725 | 1697725 | 2021-09-08 | St. Clair | Michigan | 26147 | 19518 | 465 |
1694477 | 1694477 | 2021-09-07 | St. Clair | Michigan | 26147 | 19469 | 465 |
1691228 | 1691228 | 2021-09-06 | St. Clair | Michigan | 26147 | 19434 | 464 |
1687978 | 1687978 | 2021-09-05 | St. Clair | Michigan | 26147 | 19434 | 464 |
1684728 | 1684728 | 2021-09-04 | St. Clair | Michigan | 26147 | 19396 | 464 |
1681477 | 1681477 | 2021-09-03 | St. Clair | Michigan | 26147 | 19396 | 464 |
1678229 | 1678229 | 2021-09-02 | St. Clair | Michigan | 26147 | 19352 | 462 |
1674981 | 1674981 | 2021-09-01 | St. Clair | Michigan | 26147 | 19309 | 462 |
1671733 | 1671733 | 2021-08-31 | St. Clair | Michigan | 26147 | 19266 | 460 |
1668486 | 1668486 | 2021-08-30 | St. Clair | Michigan | 26147 | 19216 | 460 |
1665239 | 1665239 | 2021-08-29 | St. Clair | Michigan | 26147 | 19200 | 460 |
1661991 | 1661991 | 2021-08-28 | St. Clair | Michigan | 26147 | 19136 | 460 |
1658743 | 1658743 | 2021-08-27 | St. Clair | Michigan | 26147 | 19136 | 460 |
1655494 | 1655494 | 2021-08-26 | St. Clair | Michigan | 26147 | 19107 | 458 |
1652247 | 1652247 | 2021-08-25 | St. Clair | Michigan | 26147 | 19075 | 458 |
1648999 | 1648999 | 2021-08-24 | St. Clair | Michigan | 26147 | 19036 | 457 |
1645750 | 1645750 | 2021-08-23 | St. Clair | Michigan | 26147 | 19002 | 457 |
1642501 | 1642501 | 2021-08-22 | St. Clair | Michigan | 26147 | 19001 | 457 |
1639251 | 1639251 | 2021-08-21 | St. Clair | Michigan | 26147 | 18964 | 457 |
1636001 | 1636001 | 2021-08-20 | St. Clair | Michigan | 26147 | 18964 | 457 |
1632751 | 1632751 | 2021-08-19 | St. Clair | Michigan | 26147 | 18935 | 457 |
1629504 | 1629504 | 2021-08-18 | St. Clair | Michigan | 26147 | 18901 | 457 |
1626257 | 1626257 | 2021-08-17 | St. Clair | Michigan | 26147 | 18876 | 456 |
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);