ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 46013 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 |
---|---|---|---|---|---|---|---|
2176666 | 2176666 | 2022-02-02 | Brown | South Dakota | 46013 | 9846 | 113 |
2173412 | 2173412 | 2022-02-01 | Brown | South Dakota | 46013 | 9785 | 113 |
2170160 | 2170160 | 2022-01-31 | Brown | South Dakota | 46013 | 9700 | 113 |
2166906 | 2166906 | 2022-01-30 | Brown | South Dakota | 46013 | 9641 | 113 |
2163651 | 2163651 | 2022-01-29 | Brown | South Dakota | 46013 | 9641 | 113 |
2160396 | 2160396 | 2022-01-28 | Brown | South Dakota | 46013 | 9641 | 113 |
2157140 | 2157140 | 2022-01-27 | Brown | South Dakota | 46013 | 9557 | 112 |
2153887 | 2153887 | 2022-01-26 | Brown | South Dakota | 46013 | 9469 | 112 |
2150635 | 2150635 | 2022-01-25 | Brown | South Dakota | 46013 | 9398 | 112 |
2147383 | 2147383 | 2022-01-24 | Brown | South Dakota | 46013 | 9247 | 111 |
2144129 | 2144129 | 2022-01-23 | Brown | South Dakota | 46013 | 9149 | 110 |
2140874 | 2140874 | 2022-01-22 | Brown | South Dakota | 46013 | 9149 | 110 |
2137618 | 2137618 | 2022-01-21 | Brown | South Dakota | 46013 | 9149 | 110 |
2134364 | 2134364 | 2022-01-20 | Brown | South Dakota | 46013 | 9049 | 110 |
2131112 | 2131112 | 2022-01-19 | Brown | South Dakota | 46013 | 8919 | 110 |
2127858 | 2127858 | 2022-01-18 | Brown | South Dakota | 46013 | 8622 | 110 |
2124606 | 2124606 | 2022-01-17 | Brown | South Dakota | 46013 | 8530 | 110 |
2121354 | 2121354 | 2022-01-16 | Brown | South Dakota | 46013 | 8530 | 110 |
2118102 | 2118102 | 2022-01-15 | Brown | South Dakota | 46013 | 8530 | 110 |
2114851 | 2114851 | 2022-01-14 | Brown | South Dakota | 46013 | 8530 | 110 |
2111599 | 2111599 | 2022-01-13 | Brown | South Dakota | 46013 | 8437 | 110 |
2108347 | 2108347 | 2022-01-12 | Brown | South Dakota | 46013 | 8319 | 109 |
2105096 | 2105096 | 2022-01-11 | Brown | South Dakota | 46013 | 8179 | 109 |
2101845 | 2101845 | 2022-01-10 | Brown | South Dakota | 46013 | 8044 | 109 |
2098594 | 2098594 | 2022-01-09 | Brown | South Dakota | 46013 | 7977 | 109 |
2095342 | 2095342 | 2022-01-08 | Brown | South Dakota | 46013 | 7977 | 109 |
2092090 | 2092090 | 2022-01-07 | Brown | South Dakota | 46013 | 7977 | 109 |
2088838 | 2088838 | 2022-01-06 | Brown | South Dakota | 46013 | 7919 | 109 |
2085587 | 2085587 | 2022-01-05 | Brown | South Dakota | 46013 | 7857 | 109 |
2082335 | 2082335 | 2022-01-04 | Brown | South Dakota | 46013 | 7785 | 108 |
2079083 | 2079083 | 2022-01-03 | Brown | South Dakota | 46013 | 7707 | 108 |
2075832 | 2075832 | 2022-01-02 | Brown | South Dakota | 46013 | 7679 | 107 |
2072581 | 2072581 | 2022-01-01 | Brown | South Dakota | 46013 | 7679 | 107 |
2069330 | 2069330 | 2021-12-31 | Brown | South Dakota | 46013 | 7679 | 107 |
2066079 | 2066079 | 2021-12-30 | Brown | South Dakota | 46013 | 7679 | 107 |
2062829 | 2062829 | 2021-12-29 | Brown | South Dakota | 46013 | 7660 | 107 |
2059579 | 2059579 | 2021-12-28 | Brown | South Dakota | 46013 | 7620 | 107 |
2056330 | 2056330 | 2021-12-27 | Brown | South Dakota | 46013 | 7584 | 107 |
2053081 | 2053081 | 2021-12-26 | Brown | South Dakota | 46013 | 7568 | 107 |
2049831 | 2049831 | 2021-12-25 | Brown | South Dakota | 46013 | 7568 | 107 |
2046581 | 2046581 | 2021-12-24 | Brown | South Dakota | 46013 | 7568 | 107 |
2043331 | 2043331 | 2021-12-23 | Brown | South Dakota | 46013 | 7568 | 107 |
2040082 | 2040082 | 2021-12-22 | Brown | South Dakota | 46013 | 7556 | 107 |
2036832 | 2036832 | 2021-12-21 | Brown | South Dakota | 46013 | 7540 | 107 |
2033582 | 2033582 | 2021-12-20 | Brown | South Dakota | 46013 | 7520 | 107 |
2030332 | 2030332 | 2021-12-19 | Brown | South Dakota | 46013 | 7507 | 107 |
2027081 | 2027081 | 2021-12-18 | Brown | South Dakota | 46013 | 7507 | 107 |
2023830 | 2023830 | 2021-12-17 | Brown | South Dakota | 46013 | 7507 | 107 |
2020579 | 2020579 | 2021-12-16 | Brown | South Dakota | 46013 | 7494 | 107 |
2017328 | 2017328 | 2021-12-15 | Brown | South Dakota | 46013 | 7484 | 107 |
2014078 | 2014078 | 2021-12-14 | Brown | South Dakota | 46013 | 7474 | 107 |
2010827 | 2010827 | 2021-12-13 | Brown | South Dakota | 46013 | 7450 | 107 |
2007576 | 2007576 | 2021-12-12 | Brown | South Dakota | 46013 | 7437 | 107 |
2004325 | 2004325 | 2021-12-11 | Brown | South Dakota | 46013 | 7437 | 107 |
2001074 | 2001074 | 2021-12-10 | Brown | South Dakota | 46013 | 7437 | 107 |
1997824 | 1997824 | 2021-12-09 | Brown | South Dakota | 46013 | 7427 | 107 |
1994573 | 1994573 | 2021-12-08 | Brown | South Dakota | 46013 | 7410 | 107 |
1991322 | 1991322 | 2021-12-07 | Brown | South Dakota | 46013 | 7394 | 107 |
1988071 | 1988071 | 2021-12-06 | Brown | South Dakota | 46013 | 7361 | 107 |
1984821 | 1984821 | 2021-12-05 | Brown | South Dakota | 46013 | 7338 | 105 |
1981571 | 1981571 | 2021-12-04 | Brown | South Dakota | 46013 | 7338 | 105 |
1978321 | 1978321 | 2021-12-03 | Brown | South Dakota | 46013 | 7338 | 105 |
1975071 | 1975071 | 2021-12-02 | Brown | South Dakota | 46013 | 7324 | 104 |
1971822 | 1971822 | 2021-12-01 | Brown | South Dakota | 46013 | 7299 | 104 |
1968572 | 1968572 | 2021-11-30 | Brown | South Dakota | 46013 | 7254 | 104 |
1965321 | 1965321 | 2021-11-29 | Brown | South Dakota | 46013 | 7202 | 103 |
1962069 | 1962069 | 2021-11-28 | Brown | South Dakota | 46013 | 7184 | 101 |
1958818 | 1958818 | 2021-11-27 | Brown | South Dakota | 46013 | 7184 | 101 |
1955567 | 1955567 | 2021-11-26 | Brown | South Dakota | 46013 | 7184 | 101 |
1952316 | 1952316 | 2021-11-25 | Brown | South Dakota | 46013 | 7184 | 101 |
1949065 | 1949065 | 2021-11-24 | Brown | South Dakota | 46013 | 7184 | 101 |
1945814 | 1945814 | 2021-11-23 | Brown | South Dakota | 46013 | 7152 | 101 |
1942563 | 1942563 | 2021-11-22 | Brown | South Dakota | 46013 | 7098 | 101 |
1939313 | 1939313 | 2021-11-21 | Brown | South Dakota | 46013 | 7081 | 101 |
1936063 | 1936063 | 2021-11-20 | Brown | South Dakota | 46013 | 7081 | 101 |
1932813 | 1932813 | 2021-11-19 | Brown | South Dakota | 46013 | 7081 | 101 |
1929562 | 1929562 | 2021-11-18 | Brown | South Dakota | 46013 | 7056 | 101 |
1926312 | 1926312 | 2021-11-17 | Brown | South Dakota | 46013 | 7032 | 101 |
1923062 | 1923062 | 2021-11-16 | Brown | South Dakota | 46013 | 7010 | 101 |
1919813 | 1919813 | 2021-11-15 | Brown | South Dakota | 46013 | 6958 | 101 |
1916563 | 1916563 | 2021-11-14 | Brown | South Dakota | 46013 | 6922 | 101 |
1913313 | 1913313 | 2021-11-13 | Brown | South Dakota | 46013 | 6922 | 101 |
1910063 | 1910063 | 2021-11-12 | Brown | South Dakota | 46013 | 6922 | 101 |
1906814 | 1906814 | 2021-11-11 | Brown | South Dakota | 46013 | 6900 | 101 |
1903565 | 1903565 | 2021-11-10 | Brown | South Dakota | 46013 | 6900 | 101 |
1900315 | 1900315 | 2021-11-09 | Brown | South Dakota | 46013 | 6877 | 100 |
1897065 | 1897065 | 2021-11-08 | Brown | South Dakota | 46013 | 6851 | 100 |
1893815 | 1893815 | 2021-11-07 | Brown | South Dakota | 46013 | 6833 | 100 |
1890565 | 1890565 | 2021-11-06 | Brown | South Dakota | 46013 | 6833 | 100 |
1887315 | 1887315 | 2021-11-05 | Brown | South Dakota | 46013 | 6833 | 100 |
1884065 | 1884065 | 2021-11-04 | Brown | South Dakota | 46013 | 6806 | 100 |
1880816 | 1880816 | 2021-11-03 | Brown | South Dakota | 46013 | 6784 | 100 |
1877567 | 1877567 | 2021-11-02 | Brown | South Dakota | 46013 | 6759 | 100 |
1874318 | 1874318 | 2021-11-01 | Brown | South Dakota | 46013 | 6704 | 100 |
1871069 | 1871069 | 2021-10-31 | Brown | South Dakota | 46013 | 6685 | 100 |
1867820 | 1867820 | 2021-10-30 | Brown | South Dakota | 46013 | 6685 | 100 |
1864571 | 1864571 | 2021-10-29 | Brown | South Dakota | 46013 | 6685 | 100 |
1861322 | 1861322 | 2021-10-28 | Brown | South Dakota | 46013 | 6669 | 100 |
1858073 | 1858073 | 2021-10-27 | Brown | South Dakota | 46013 | 6652 | 100 |
1854824 | 1854824 | 2021-10-26 | Brown | South Dakota | 46013 | 6631 | 100 |
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);