ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46023 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176671 | 2176671 | 2022-02-02 | Charles Mix | South Dakota | 46023 | 2823 | 33 |
2173417 | 2173417 | 2022-02-01 | Charles Mix | South Dakota | 46023 | 2806 | 33 |
2170165 | 2170165 | 2022-01-31 | Charles Mix | South Dakota | 46023 | 2779 | 33 |
2166911 | 2166911 | 2022-01-30 | Charles Mix | South Dakota | 46023 | 2763 | 33 |
2163656 | 2163656 | 2022-01-29 | Charles Mix | South Dakota | 46023 | 2763 | 33 |
2160401 | 2160401 | 2022-01-28 | Charles Mix | South Dakota | 46023 | 2763 | 33 |
2157145 | 2157145 | 2022-01-27 | Charles Mix | South Dakota | 46023 | 2742 | 33 |
2153892 | 2153892 | 2022-01-26 | Charles Mix | South Dakota | 46023 | 2724 | 33 |
2150640 | 2150640 | 2022-01-25 | Charles Mix | South Dakota | 46023 | 2701 | 33 |
2147388 | 2147388 | 2022-01-24 | Charles Mix | South Dakota | 46023 | 2659 | 33 |
2144134 | 2144134 | 2022-01-23 | Charles Mix | South Dakota | 46023 | 2624 | 33 |
2140879 | 2140879 | 2022-01-22 | Charles Mix | South Dakota | 46023 | 2624 | 33 |
2137623 | 2137623 | 2022-01-21 | Charles Mix | South Dakota | 46023 | 2624 | 33 |
2134369 | 2134369 | 2022-01-20 | Charles Mix | South Dakota | 46023 | 2592 | 32 |
2131117 | 2131117 | 2022-01-19 | Charles Mix | South Dakota | 46023 | 2543 | 32 |
2127863 | 2127863 | 2022-01-18 | Charles Mix | South Dakota | 46023 | 2465 | 32 |
2124611 | 2124611 | 2022-01-17 | Charles Mix | South Dakota | 46023 | 2415 | 32 |
2121359 | 2121359 | 2022-01-16 | Charles Mix | South Dakota | 46023 | 2415 | 32 |
2118107 | 2118107 | 2022-01-15 | Charles Mix | South Dakota | 46023 | 2415 | 32 |
2114856 | 2114856 | 2022-01-14 | Charles Mix | South Dakota | 46023 | 2415 | 32 |
2111604 | 2111604 | 2022-01-13 | Charles Mix | South Dakota | 46023 | 2381 | 32 |
2108352 | 2108352 | 2022-01-12 | Charles Mix | South Dakota | 46023 | 2343 | 32 |
2105101 | 2105101 | 2022-01-11 | Charles Mix | South Dakota | 46023 | 2317 | 32 |
2101850 | 2101850 | 2022-01-10 | Charles Mix | South Dakota | 46023 | 2261 | 32 |
2098599 | 2098599 | 2022-01-09 | Charles Mix | South Dakota | 46023 | 2236 | 32 |
2095347 | 2095347 | 2022-01-08 | Charles Mix | South Dakota | 46023 | 2236 | 32 |
2092095 | 2092095 | 2022-01-07 | Charles Mix | South Dakota | 46023 | 2236 | 32 |
2088843 | 2088843 | 2022-01-06 | Charles Mix | South Dakota | 46023 | 2218 | 32 |
2085592 | 2085592 | 2022-01-05 | Charles Mix | South Dakota | 46023 | 2192 | 32 |
2082340 | 2082340 | 2022-01-04 | Charles Mix | South Dakota | 46023 | 2148 | 32 |
2079088 | 2079088 | 2022-01-03 | Charles Mix | South Dakota | 46023 | 2141 | 32 |
2075837 | 2075837 | 2022-01-02 | Charles Mix | South Dakota | 46023 | 2137 | 32 |
2072586 | 2072586 | 2022-01-01 | Charles Mix | South Dakota | 46023 | 2137 | 32 |
2069335 | 2069335 | 2021-12-31 | Charles Mix | South Dakota | 46023 | 2137 | 32 |
2066084 | 2066084 | 2021-12-30 | Charles Mix | South Dakota | 46023 | 2137 | 32 |
2062834 | 2062834 | 2021-12-29 | Charles Mix | South Dakota | 46023 | 2131 | 32 |
2059584 | 2059584 | 2021-12-28 | Charles Mix | South Dakota | 46023 | 2127 | 30 |
2056335 | 2056335 | 2021-12-27 | Charles Mix | South Dakota | 46023 | 2110 | 30 |
2053086 | 2053086 | 2021-12-26 | Charles Mix | South Dakota | 46023 | 2109 | 30 |
2049836 | 2049836 | 2021-12-25 | Charles Mix | South Dakota | 46023 | 2109 | 30 |
2046586 | 2046586 | 2021-12-24 | Charles Mix | South Dakota | 46023 | 2109 | 30 |
2043336 | 2043336 | 2021-12-23 | Charles Mix | South Dakota | 46023 | 2109 | 30 |
2040087 | 2040087 | 2021-12-22 | Charles Mix | South Dakota | 46023 | 2109 | 30 |
2036837 | 2036837 | 2021-12-21 | Charles Mix | South Dakota | 46023 | 2104 | 30 |
2033587 | 2033587 | 2021-12-20 | Charles Mix | South Dakota | 46023 | 2100 | 30 |
2030337 | 2030337 | 2021-12-19 | Charles Mix | South Dakota | 46023 | 2097 | 30 |
2027086 | 2027086 | 2021-12-18 | Charles Mix | South Dakota | 46023 | 2097 | 30 |
2023835 | 2023835 | 2021-12-17 | Charles Mix | South Dakota | 46023 | 2097 | 30 |
2020584 | 2020584 | 2021-12-16 | Charles Mix | South Dakota | 46023 | 2093 | 30 |
2017333 | 2017333 | 2021-12-15 | Charles Mix | South Dakota | 46023 | 2080 | 30 |
2014083 | 2014083 | 2021-12-14 | Charles Mix | South Dakota | 46023 | 2065 | 28 |
2010832 | 2010832 | 2021-12-13 | Charles Mix | South Dakota | 46023 | 2061 | 28 |
2007581 | 2007581 | 2021-12-12 | Charles Mix | South Dakota | 46023 | 2056 | 28 |
2004330 | 2004330 | 2021-12-11 | Charles Mix | South Dakota | 46023 | 2056 | 28 |
2001079 | 2001079 | 2021-12-10 | Charles Mix | South Dakota | 46023 | 2056 | 28 |
1997829 | 1997829 | 2021-12-09 | Charles Mix | South Dakota | 46023 | 2044 | 28 |
1994578 | 1994578 | 2021-12-08 | Charles Mix | South Dakota | 46023 | 2036 | 28 |
1991327 | 1991327 | 2021-12-07 | Charles Mix | South Dakota | 46023 | 2017 | 27 |
1988076 | 1988076 | 2021-12-06 | Charles Mix | South Dakota | 46023 | 1984 | 27 |
1984826 | 1984826 | 2021-12-05 | Charles Mix | South Dakota | 46023 | 1971 | 27 |
1981576 | 1981576 | 2021-12-04 | Charles Mix | South Dakota | 46023 | 1971 | 27 |
1978326 | 1978326 | 2021-12-03 | Charles Mix | South Dakota | 46023 | 1971 | 27 |
1975076 | 1975076 | 2021-12-02 | Charles Mix | South Dakota | 46023 | 1957 | 27 |
1971827 | 1971827 | 2021-12-01 | Charles Mix | South Dakota | 46023 | 1943 | 27 |
1968577 | 1968577 | 2021-11-30 | Charles Mix | South Dakota | 46023 | 1910 | 27 |
1965326 | 1965326 | 2021-11-29 | Charles Mix | South Dakota | 46023 | 1888 | 27 |
1962074 | 1962074 | 2021-11-28 | Charles Mix | South Dakota | 46023 | 1872 | 27 |
1958823 | 1958823 | 2021-11-27 | Charles Mix | South Dakota | 46023 | 1872 | 27 |
1955572 | 1955572 | 2021-11-26 | Charles Mix | South Dakota | 46023 | 1872 | 27 |
1952321 | 1952321 | 2021-11-25 | Charles Mix | South Dakota | 46023 | 1872 | 27 |
1949070 | 1949070 | 2021-11-24 | Charles Mix | South Dakota | 46023 | 1872 | 27 |
1945819 | 1945819 | 2021-11-23 | Charles Mix | South Dakota | 46023 | 1863 | 27 |
1942568 | 1942568 | 2021-11-22 | Charles Mix | South Dakota | 46023 | 1849 | 27 |
1939318 | 1939318 | 2021-11-21 | Charles Mix | South Dakota | 46023 | 1846 | 27 |
1936068 | 1936068 | 2021-11-20 | Charles Mix | South Dakota | 46023 | 1846 | 27 |
1932818 | 1932818 | 2021-11-19 | Charles Mix | South Dakota | 46023 | 1846 | 27 |
1929567 | 1929567 | 2021-11-18 | Charles Mix | South Dakota | 46023 | 1834 | 27 |
1926317 | 1926317 | 2021-11-17 | Charles Mix | South Dakota | 46023 | 1817 | 27 |
1923067 | 1923067 | 2021-11-16 | Charles Mix | South Dakota | 46023 | 1810 | 27 |
1919818 | 1919818 | 2021-11-15 | Charles Mix | South Dakota | 46023 | 1790 | 27 |
1916568 | 1916568 | 2021-11-14 | Charles Mix | South Dakota | 46023 | 1772 | 27 |
1913318 | 1913318 | 2021-11-13 | Charles Mix | South Dakota | 46023 | 1772 | 27 |
1910068 | 1910068 | 2021-11-12 | Charles Mix | South Dakota | 46023 | 1772 | 27 |
1906819 | 1906819 | 2021-11-11 | Charles Mix | South Dakota | 46023 | 1767 | 27 |
1903570 | 1903570 | 2021-11-10 | Charles Mix | South Dakota | 46023 | 1767 | 27 |
1900320 | 1900320 | 2021-11-09 | Charles Mix | South Dakota | 46023 | 1761 | 27 |
1897070 | 1897070 | 2021-11-08 | Charles Mix | South Dakota | 46023 | 1753 | 27 |
1893820 | 1893820 | 2021-11-07 | Charles Mix | South Dakota | 46023 | 1749 | 27 |
1890570 | 1890570 | 2021-11-06 | Charles Mix | South Dakota | 46023 | 1749 | 27 |
1887320 | 1887320 | 2021-11-05 | Charles Mix | South Dakota | 46023 | 1749 | 27 |
1884070 | 1884070 | 2021-11-04 | Charles Mix | South Dakota | 46023 | 1743 | 26 |
1880821 | 1880821 | 2021-11-03 | Charles Mix | South Dakota | 46023 | 1735 | 26 |
1877572 | 1877572 | 2021-11-02 | Charles Mix | South Dakota | 46023 | 1732 | 26 |
1874323 | 1874323 | 2021-11-01 | Charles Mix | South Dakota | 46023 | 1727 | 26 |
1871074 | 1871074 | 2021-10-31 | Charles Mix | South Dakota | 46023 | 1724 | 26 |
1867825 | 1867825 | 2021-10-30 | Charles Mix | South Dakota | 46023 | 1724 | 26 |
1864576 | 1864576 | 2021-10-29 | Charles Mix | South Dakota | 46023 | 1724 | 26 |
1861327 | 1861327 | 2021-10-28 | Charles Mix | South Dakota | 46023 | 1721 | 26 |
1858078 | 1858078 | 2021-10-27 | Charles Mix | South Dakota | 46023 | 1720 | 26 |
1854829 | 1854829 | 2021-10-26 | Charles Mix | South Dakota | 46023 | 1717 | 26 |
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);