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 |
---|---|---|---|---|---|---|---|
2175515 | 2175515 | 2022-02-02 | St. Clair | Michigan | 26147 | 38914 | 759 |
2172262 | 2172262 | 2022-02-01 | St. Clair | Michigan | 26147 | 38638 | 754 |
2169009 | 2169009 | 2022-01-31 | St. Clair | Michigan | 26147 | 38638 | 754 |
2165754 | 2165754 | 2022-01-30 | St. Clair | Michigan | 26147 | 38608 | 754 |
2162499 | 2162499 | 2022-01-29 | St. Clair | Michigan | 26147 | 38379 | 754 |
2159244 | 2159244 | 2022-01-28 | St. Clair | Michigan | 26147 | 38379 | 754 |
2155990 | 2155990 | 2022-01-27 | St. Clair | Michigan | 26147 | 38141 | 749 |
2152737 | 2152737 | 2022-01-26 | St. Clair | Michigan | 26147 | 37936 | 747 |
2149485 | 2149485 | 2022-01-25 | St. Clair | Michigan | 26147 | 37700 | 745 |
2146233 | 2146233 | 2022-01-24 | St. Clair | Michigan | 26147 | 37490 | 744 |
2142978 | 2142978 | 2022-01-23 | St. Clair | Michigan | 26147 | 37330 | 744 |
2139723 | 2139723 | 2022-01-22 | St. Clair | Michigan | 26147 | 36821 | 741 |
2136467 | 2136467 | 2022-01-21 | St. Clair | Michigan | 26147 | 36821 | 741 |
2133215 | 2133215 | 2022-01-20 | St. Clair | Michigan | 26147 | 36500 | 740 |
2129962 | 2129962 | 2022-01-19 | St. Clair | Michigan | 26147 | 36208 | 733 |
2126708 | 2126708 | 2022-01-18 | St. Clair | Michigan | 26147 | 35924 | 716 |
2123456 | 2123456 | 2022-01-17 | St. Clair | Michigan | 26147 | 35797 | 716 |
2120204 | 2120204 | 2022-01-16 | St. Clair | Michigan | 26147 | 35385 | 716 |
2116952 | 2116952 | 2022-01-15 | St. Clair | Michigan | 26147 | 34694 | 716 |
2113701 | 2113701 | 2022-01-14 | St. Clair | Michigan | 26147 | 34694 | 716 |
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 |
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);