ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
730 rows where county = "Tripp" 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 |
---|---|---|---|---|---|---|---|
2176721 | 2176721 | 2022-02-02 | Tripp | South Dakota | 46123 | 1326 | 22 |
2173467 | 2173467 | 2022-02-01 | Tripp | South Dakota | 46123 | 1320 | 22 |
2170215 | 2170215 | 2022-01-31 | Tripp | South Dakota | 46123 | 1309 | 21 |
2166961 | 2166961 | 2022-01-30 | Tripp | South Dakota | 46123 | 1299 | 21 |
2163706 | 2163706 | 2022-01-29 | Tripp | South Dakota | 46123 | 1299 | 21 |
2160451 | 2160451 | 2022-01-28 | Tripp | South Dakota | 46123 | 1299 | 21 |
2157195 | 2157195 | 2022-01-27 | Tripp | South Dakota | 46123 | 1288 | 21 |
2153942 | 2153942 | 2022-01-26 | Tripp | South Dakota | 46123 | 1275 | 21 |
2150690 | 2150690 | 2022-01-25 | Tripp | South Dakota | 46123 | 1269 | 21 |
2147438 | 2147438 | 2022-01-24 | Tripp | South Dakota | 46123 | 1259 | 21 |
2144184 | 2144184 | 2022-01-23 | Tripp | South Dakota | 46123 | 1229 | 21 |
2140929 | 2140929 | 2022-01-22 | Tripp | South Dakota | 46123 | 1229 | 21 |
2137673 | 2137673 | 2022-01-21 | Tripp | South Dakota | 46123 | 1229 | 21 |
2134419 | 2134419 | 2022-01-20 | Tripp | South Dakota | 46123 | 1209 | 21 |
2131167 | 2131167 | 2022-01-19 | Tripp | South Dakota | 46123 | 1203 | 21 |
2127913 | 2127913 | 2022-01-18 | Tripp | South Dakota | 46123 | 1185 | 21 |
2124661 | 2124661 | 2022-01-17 | Tripp | South Dakota | 46123 | 1170 | 21 |
2121409 | 2121409 | 2022-01-16 | Tripp | South Dakota | 46123 | 1170 | 21 |
2118157 | 2118157 | 2022-01-15 | Tripp | South Dakota | 46123 | 1170 | 21 |
2114906 | 2114906 | 2022-01-14 | Tripp | South Dakota | 46123 | 1170 | 21 |
2111654 | 2111654 | 2022-01-13 | Tripp | South Dakota | 46123 | 1150 | 21 |
2108402 | 2108402 | 2022-01-12 | Tripp | South Dakota | 46123 | 1130 | 21 |
2105151 | 2105151 | 2022-01-11 | Tripp | South Dakota | 46123 | 1108 | 21 |
2101900 | 2101900 | 2022-01-10 | Tripp | South Dakota | 46123 | 1078 | 21 |
2098649 | 2098649 | 2022-01-09 | Tripp | South Dakota | 46123 | 1063 | 21 |
2095397 | 2095397 | 2022-01-08 | Tripp | South Dakota | 46123 | 1063 | 21 |
2092145 | 2092145 | 2022-01-07 | Tripp | South Dakota | 46123 | 1063 | 21 |
2088893 | 2088893 | 2022-01-06 | Tripp | South Dakota | 46123 | 1054 | 21 |
2085642 | 2085642 | 2022-01-05 | Tripp | South Dakota | 46123 | 1039 | 21 |
2082390 | 2082390 | 2022-01-04 | Tripp | South Dakota | 46123 | 1015 | 21 |
2079138 | 2079138 | 2022-01-03 | Tripp | South Dakota | 46123 | 991 | 21 |
2075887 | 2075887 | 2022-01-02 | Tripp | South Dakota | 46123 | 986 | 21 |
2072636 | 2072636 | 2022-01-01 | Tripp | South Dakota | 46123 | 986 | 21 |
2069385 | 2069385 | 2021-12-31 | Tripp | South Dakota | 46123 | 986 | 21 |
2066134 | 2066134 | 2021-12-30 | Tripp | South Dakota | 46123 | 986 | 21 |
2062884 | 2062884 | 2021-12-29 | Tripp | South Dakota | 46123 | 983 | 21 |
2059634 | 2059634 | 2021-12-28 | Tripp | South Dakota | 46123 | 982 | 21 |
2056385 | 2056385 | 2021-12-27 | Tripp | South Dakota | 46123 | 974 | 21 |
2053136 | 2053136 | 2021-12-26 | Tripp | South Dakota | 46123 | 967 | 21 |
2049886 | 2049886 | 2021-12-25 | Tripp | South Dakota | 46123 | 967 | 21 |
2046636 | 2046636 | 2021-12-24 | Tripp | South Dakota | 46123 | 967 | 21 |
2043386 | 2043386 | 2021-12-23 | Tripp | South Dakota | 46123 | 967 | 21 |
2040137 | 2040137 | 2021-12-22 | Tripp | South Dakota | 46123 | 963 | 21 |
2036887 | 2036887 | 2021-12-21 | Tripp | South Dakota | 46123 | 963 | 21 |
2033637 | 2033637 | 2021-12-20 | Tripp | South Dakota | 46123 | 961 | 21 |
2030387 | 2030387 | 2021-12-19 | Tripp | South Dakota | 46123 | 957 | 21 |
2027136 | 2027136 | 2021-12-18 | Tripp | South Dakota | 46123 | 957 | 21 |
2023885 | 2023885 | 2021-12-17 | Tripp | South Dakota | 46123 | 957 | 21 |
2020634 | 2020634 | 2021-12-16 | Tripp | South Dakota | 46123 | 955 | 21 |
2017383 | 2017383 | 2021-12-15 | Tripp | South Dakota | 46123 | 953 | 21 |
2014133 | 2014133 | 2021-12-14 | Tripp | South Dakota | 46123 | 954 | 21 |
2010882 | 2010882 | 2021-12-13 | Tripp | South Dakota | 46123 | 952 | 21 |
2007631 | 2007631 | 2021-12-12 | Tripp | South Dakota | 46123 | 950 | 21 |
2004380 | 2004380 | 2021-12-11 | Tripp | South Dakota | 46123 | 950 | 21 |
2001129 | 2001129 | 2021-12-10 | Tripp | South Dakota | 46123 | 950 | 21 |
1997879 | 1997879 | 2021-12-09 | Tripp | South Dakota | 46123 | 948 | 21 |
1994628 | 1994628 | 2021-12-08 | Tripp | South Dakota | 46123 | 943 | 21 |
1991377 | 1991377 | 2021-12-07 | Tripp | South Dakota | 46123 | 938 | 21 |
1988126 | 1988126 | 2021-12-06 | Tripp | South Dakota | 46123 | 932 | 21 |
1984876 | 1984876 | 2021-12-05 | Tripp | South Dakota | 46123 | 932 | 21 |
1981626 | 1981626 | 2021-12-04 | Tripp | South Dakota | 46123 | 932 | 21 |
1978376 | 1978376 | 2021-12-03 | Tripp | South Dakota | 46123 | 932 | 21 |
1975126 | 1975126 | 2021-12-02 | Tripp | South Dakota | 46123 | 931 | 21 |
1971877 | 1971877 | 2021-12-01 | Tripp | South Dakota | 46123 | 922 | 21 |
1968627 | 1968627 | 2021-11-30 | Tripp | South Dakota | 46123 | 917 | 20 |
1965376 | 1965376 | 2021-11-29 | Tripp | South Dakota | 46123 | 910 | 20 |
1962124 | 1962124 | 2021-11-28 | Tripp | South Dakota | 46123 | 907 | 20 |
1958873 | 1958873 | 2021-11-27 | Tripp | South Dakota | 46123 | 907 | 20 |
1955622 | 1955622 | 2021-11-26 | Tripp | South Dakota | 46123 | 907 | 20 |
1952371 | 1952371 | 2021-11-25 | Tripp | South Dakota | 46123 | 907 | 20 |
1949120 | 1949120 | 2021-11-24 | Tripp | South Dakota | 46123 | 907 | 20 |
1945869 | 1945869 | 2021-11-23 | Tripp | South Dakota | 46123 | 906 | 20 |
1942618 | 1942618 | 2021-11-22 | Tripp | South Dakota | 46123 | 897 | 20 |
1939368 | 1939368 | 2021-11-21 | Tripp | South Dakota | 46123 | 893 | 20 |
1936118 | 1936118 | 2021-11-20 | Tripp | South Dakota | 46123 | 893 | 20 |
1932868 | 1932868 | 2021-11-19 | Tripp | South Dakota | 46123 | 893 | 20 |
1929617 | 1929617 | 2021-11-18 | Tripp | South Dakota | 46123 | 891 | 20 |
1926367 | 1926367 | 2021-11-17 | Tripp | South Dakota | 46123 | 891 | 20 |
1923117 | 1923117 | 2021-11-16 | Tripp | South Dakota | 46123 | 887 | 20 |
1919868 | 1919868 | 2021-11-15 | Tripp | South Dakota | 46123 | 882 | 19 |
1916618 | 1916618 | 2021-11-14 | Tripp | South Dakota | 46123 | 878 | 19 |
1913368 | 1913368 | 2021-11-13 | Tripp | South Dakota | 46123 | 878 | 19 |
1910118 | 1910118 | 2021-11-12 | Tripp | South Dakota | 46123 | 878 | 19 |
1906869 | 1906869 | 2021-11-11 | Tripp | South Dakota | 46123 | 877 | 19 |
1903620 | 1903620 | 2021-11-10 | Tripp | South Dakota | 46123 | 877 | 19 |
1900370 | 1900370 | 2021-11-09 | Tripp | South Dakota | 46123 | 877 | 19 |
1897120 | 1897120 | 2021-11-08 | Tripp | South Dakota | 46123 | 873 | 19 |
1893870 | 1893870 | 2021-11-07 | Tripp | South Dakota | 46123 | 873 | 19 |
1890620 | 1890620 | 2021-11-06 | Tripp | South Dakota | 46123 | 873 | 19 |
1887370 | 1887370 | 2021-11-05 | Tripp | South Dakota | 46123 | 873 | 19 |
1884120 | 1884120 | 2021-11-04 | Tripp | South Dakota | 46123 | 873 | 19 |
1880871 | 1880871 | 2021-11-03 | Tripp | South Dakota | 46123 | 863 | 19 |
1877622 | 1877622 | 2021-11-02 | Tripp | South Dakota | 46123 | 860 | 18 |
1874373 | 1874373 | 2021-11-01 | Tripp | South Dakota | 46123 | 856 | 18 |
1871124 | 1871124 | 2021-10-31 | Tripp | South Dakota | 46123 | 853 | 18 |
1867875 | 1867875 | 2021-10-30 | Tripp | South Dakota | 46123 | 853 | 18 |
1864626 | 1864626 | 2021-10-29 | Tripp | South Dakota | 46123 | 853 | 18 |
1861377 | 1861377 | 2021-10-28 | Tripp | South Dakota | 46123 | 852 | 18 |
1858128 | 1858128 | 2021-10-27 | Tripp | South Dakota | 46123 | 851 | 18 |
1854879 | 1854879 | 2021-10-26 | Tripp | South Dakota | 46123 | 849 | 18 |
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);