ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 46085 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 |
---|---|---|---|---|---|---|---|
2176702 | 2176702 | 2022-02-02 | Lyman | South Dakota | 46085 | 1173 | 12 |
2173448 | 2173448 | 2022-02-01 | Lyman | South Dakota | 46085 | 1171 | 12 |
2170196 | 2170196 | 2022-01-31 | Lyman | South Dakota | 46085 | 1166 | 12 |
2166942 | 2166942 | 2022-01-30 | Lyman | South Dakota | 46085 | 1161 | 12 |
2163687 | 2163687 | 2022-01-29 | Lyman | South Dakota | 46085 | 1161 | 12 |
2160432 | 2160432 | 2022-01-28 | Lyman | South Dakota | 46085 | 1161 | 12 |
2157176 | 2157176 | 2022-01-27 | Lyman | South Dakota | 46085 | 1149 | 12 |
2153923 | 2153923 | 2022-01-26 | Lyman | South Dakota | 46085 | 1144 | 12 |
2150671 | 2150671 | 2022-01-25 | Lyman | South Dakota | 46085 | 1137 | 12 |
2147419 | 2147419 | 2022-01-24 | Lyman | South Dakota | 46085 | 1129 | 12 |
2144165 | 2144165 | 2022-01-23 | Lyman | South Dakota | 46085 | 1126 | 12 |
2140910 | 2140910 | 2022-01-22 | Lyman | South Dakota | 46085 | 1126 | 12 |
2137654 | 2137654 | 2022-01-21 | Lyman | South Dakota | 46085 | 1126 | 12 |
2134400 | 2134400 | 2022-01-20 | Lyman | South Dakota | 46085 | 1118 | 12 |
2131148 | 2131148 | 2022-01-19 | Lyman | South Dakota | 46085 | 1105 | 12 |
2127894 | 2127894 | 2022-01-18 | Lyman | South Dakota | 46085 | 1082 | 12 |
2124642 | 2124642 | 2022-01-17 | Lyman | South Dakota | 46085 | 1070 | 12 |
2121390 | 2121390 | 2022-01-16 | Lyman | South Dakota | 46085 | 1070 | 12 |
2118138 | 2118138 | 2022-01-15 | Lyman | South Dakota | 46085 | 1070 | 12 |
2114887 | 2114887 | 2022-01-14 | Lyman | South Dakota | 46085 | 1070 | 12 |
2111635 | 2111635 | 2022-01-13 | Lyman | South Dakota | 46085 | 1055 | 12 |
2108383 | 2108383 | 2022-01-12 | Lyman | South Dakota | 46085 | 1043 | 12 |
2105132 | 2105132 | 2022-01-11 | Lyman | South Dakota | 46085 | 1026 | 12 |
2101881 | 2101881 | 2022-01-10 | Lyman | South Dakota | 46085 | 1007 | 12 |
2098630 | 2098630 | 2022-01-09 | Lyman | South Dakota | 46085 | 998 | 12 |
2095378 | 2095378 | 2022-01-08 | Lyman | South Dakota | 46085 | 998 | 12 |
2092126 | 2092126 | 2022-01-07 | Lyman | South Dakota | 46085 | 998 | 12 |
2088874 | 2088874 | 2022-01-06 | Lyman | South Dakota | 46085 | 993 | 12 |
2085623 | 2085623 | 2022-01-05 | Lyman | South Dakota | 46085 | 986 | 12 |
2082371 | 2082371 | 2022-01-04 | Lyman | South Dakota | 46085 | 924 | 12 |
2079119 | 2079119 | 2022-01-03 | Lyman | South Dakota | 46085 | 905 | 12 |
2075868 | 2075868 | 2022-01-02 | Lyman | South Dakota | 46085 | 900 | 12 |
2072617 | 2072617 | 2022-01-01 | Lyman | South Dakota | 46085 | 900 | 12 |
2069366 | 2069366 | 2021-12-31 | Lyman | South Dakota | 46085 | 900 | 12 |
2066115 | 2066115 | 2021-12-30 | Lyman | South Dakota | 46085 | 900 | 12 |
2062865 | 2062865 | 2021-12-29 | Lyman | South Dakota | 46085 | 897 | 12 |
2059615 | 2059615 | 2021-12-28 | Lyman | South Dakota | 46085 | 888 | 12 |
2056366 | 2056366 | 2021-12-27 | Lyman | South Dakota | 46085 | 883 | 12 |
2053117 | 2053117 | 2021-12-26 | Lyman | South Dakota | 46085 | 873 | 12 |
2049867 | 2049867 | 2021-12-25 | Lyman | South Dakota | 46085 | 873 | 12 |
2046617 | 2046617 | 2021-12-24 | Lyman | South Dakota | 46085 | 873 | 12 |
2043367 | 2043367 | 2021-12-23 | Lyman | South Dakota | 46085 | 873 | 12 |
2040118 | 2040118 | 2021-12-22 | Lyman | South Dakota | 46085 | 872 | 12 |
2036868 | 2036868 | 2021-12-21 | Lyman | South Dakota | 46085 | 865 | 12 |
2033618 | 2033618 | 2021-12-20 | Lyman | South Dakota | 46085 | 862 | 11 |
2030368 | 2030368 | 2021-12-19 | Lyman | South Dakota | 46085 | 862 | 11 |
2027117 | 2027117 | 2021-12-18 | Lyman | South Dakota | 46085 | 862 | 11 |
2023866 | 2023866 | 2021-12-17 | Lyman | South Dakota | 46085 | 862 | 11 |
2020615 | 2020615 | 2021-12-16 | Lyman | South Dakota | 46085 | 857 | 11 |
2017364 | 2017364 | 2021-12-15 | Lyman | South Dakota | 46085 | 856 | 11 |
2014114 | 2014114 | 2021-12-14 | Lyman | South Dakota | 46085 | 856 | 11 |
2010863 | 2010863 | 2021-12-13 | Lyman | South Dakota | 46085 | 854 | 11 |
2007612 | 2007612 | 2021-12-12 | Lyman | South Dakota | 46085 | 850 | 11 |
2004361 | 2004361 | 2021-12-11 | Lyman | South Dakota | 46085 | 850 | 11 |
2001110 | 2001110 | 2021-12-10 | Lyman | South Dakota | 46085 | 850 | 11 |
1997860 | 1997860 | 2021-12-09 | Lyman | South Dakota | 46085 | 848 | 11 |
1994609 | 1994609 | 2021-12-08 | Lyman | South Dakota | 46085 | 844 | 11 |
1991358 | 1991358 | 2021-12-07 | Lyman | South Dakota | 46085 | 838 | 11 |
1988107 | 1988107 | 2021-12-06 | Lyman | South Dakota | 46085 | 832 | 11 |
1984857 | 1984857 | 2021-12-05 | Lyman | South Dakota | 46085 | 829 | 11 |
1981607 | 1981607 | 2021-12-04 | Lyman | South Dakota | 46085 | 829 | 11 |
1978357 | 1978357 | 2021-12-03 | Lyman | South Dakota | 46085 | 829 | 11 |
1975107 | 1975107 | 2021-12-02 | Lyman | South Dakota | 46085 | 824 | 11 |
1971858 | 1971858 | 2021-12-01 | Lyman | South Dakota | 46085 | 814 | 11 |
1968608 | 1968608 | 2021-11-30 | Lyman | South Dakota | 46085 | 810 | 11 |
1965357 | 1965357 | 2021-11-29 | Lyman | South Dakota | 46085 | 806 | 11 |
1962105 | 1962105 | 2021-11-28 | Lyman | South Dakota | 46085 | 803 | 11 |
1958854 | 1958854 | 2021-11-27 | Lyman | South Dakota | 46085 | 803 | 11 |
1955603 | 1955603 | 2021-11-26 | Lyman | South Dakota | 46085 | 803 | 11 |
1952352 | 1952352 | 2021-11-25 | Lyman | South Dakota | 46085 | 803 | 11 |
1949101 | 1949101 | 2021-11-24 | Lyman | South Dakota | 46085 | 803 | 11 |
1945850 | 1945850 | 2021-11-23 | Lyman | South Dakota | 46085 | 800 | 11 |
1942599 | 1942599 | 2021-11-22 | Lyman | South Dakota | 46085 | 790 | 11 |
1939349 | 1939349 | 2021-11-21 | Lyman | South Dakota | 46085 | 789 | 11 |
1936099 | 1936099 | 2021-11-20 | Lyman | South Dakota | 46085 | 789 | 11 |
1932849 | 1932849 | 2021-11-19 | Lyman | South Dakota | 46085 | 789 | 11 |
1929598 | 1929598 | 2021-11-18 | Lyman | South Dakota | 46085 | 784 | 11 |
1926348 | 1926348 | 2021-11-17 | Lyman | South Dakota | 46085 | 776 | 11 |
1923098 | 1923098 | 2021-11-16 | Lyman | South Dakota | 46085 | 772 | 11 |
1919849 | 1919849 | 2021-11-15 | Lyman | South Dakota | 46085 | 771 | 11 |
1916599 | 1916599 | 2021-11-14 | Lyman | South Dakota | 46085 | 762 | 11 |
1913349 | 1913349 | 2021-11-13 | Lyman | South Dakota | 46085 | 762 | 11 |
1910099 | 1910099 | 2021-11-12 | Lyman | South Dakota | 46085 | 762 | 11 |
1906850 | 1906850 | 2021-11-11 | Lyman | South Dakota | 46085 | 758 | 11 |
1903601 | 1903601 | 2021-11-10 | Lyman | South Dakota | 46085 | 758 | 11 |
1900351 | 1900351 | 2021-11-09 | Lyman | South Dakota | 46085 | 757 | 11 |
1897101 | 1897101 | 2021-11-08 | Lyman | South Dakota | 46085 | 748 | 11 |
1893851 | 1893851 | 2021-11-07 | Lyman | South Dakota | 46085 | 744 | 11 |
1890601 | 1890601 | 2021-11-06 | Lyman | South Dakota | 46085 | 744 | 11 |
1887351 | 1887351 | 2021-11-05 | Lyman | South Dakota | 46085 | 744 | 11 |
1884101 | 1884101 | 2021-11-04 | Lyman | South Dakota | 46085 | 743 | 11 |
1880852 | 1880852 | 2021-11-03 | Lyman | South Dakota | 46085 | 742 | 11 |
1877603 | 1877603 | 2021-11-02 | Lyman | South Dakota | 46085 | 738 | 11 |
1874354 | 1874354 | 2021-11-01 | Lyman | South Dakota | 46085 | 737 | 11 |
1871105 | 1871105 | 2021-10-31 | Lyman | South Dakota | 46085 | 734 | 11 |
1867856 | 1867856 | 2021-10-30 | Lyman | South Dakota | 46085 | 734 | 11 |
1864607 | 1864607 | 2021-10-29 | Lyman | South Dakota | 46085 | 734 | 11 |
1861358 | 1861358 | 2021-10-28 | Lyman | South Dakota | 46085 | 734 | 11 |
1858109 | 1858109 | 2021-10-27 | Lyman | South Dakota | 46085 | 727 | 11 |
1854860 | 1854860 | 2021-10-26 | Lyman | South Dakota | 46085 | 725 | 11 |
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);