ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 46135 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 |
---|---|---|---|---|---|---|---|
2176725 | 2176725 | 2022-02-02 | Yankton | South Dakota | 46135 | 5659 | 50 |
2173471 | 2173471 | 2022-02-01 | Yankton | South Dakota | 46135 | 5651 | 50 |
2170219 | 2170219 | 2022-01-31 | Yankton | South Dakota | 46135 | 5605 | 50 |
2166965 | 2166965 | 2022-01-30 | Yankton | South Dakota | 46135 | 5587 | 50 |
2163710 | 2163710 | 2022-01-29 | Yankton | South Dakota | 46135 | 5587 | 50 |
2160455 | 2160455 | 2022-01-28 | Yankton | South Dakota | 46135 | 5587 | 50 |
2157199 | 2157199 | 2022-01-27 | Yankton | South Dakota | 46135 | 5543 | 50 |
2153946 | 2153946 | 2022-01-26 | Yankton | South Dakota | 46135 | 5502 | 49 |
2150694 | 2150694 | 2022-01-25 | Yankton | South Dakota | 46135 | 5481 | 48 |
2147442 | 2147442 | 2022-01-24 | Yankton | South Dakota | 46135 | 5389 | 48 |
2144188 | 2144188 | 2022-01-23 | Yankton | South Dakota | 46135 | 5339 | 48 |
2140933 | 2140933 | 2022-01-22 | Yankton | South Dakota | 46135 | 5339 | 48 |
2137677 | 2137677 | 2022-01-21 | Yankton | South Dakota | 46135 | 5339 | 48 |
2134423 | 2134423 | 2022-01-20 | Yankton | South Dakota | 46135 | 5276 | 47 |
2131171 | 2131171 | 2022-01-19 | Yankton | South Dakota | 46135 | 5206 | 47 |
2127917 | 2127917 | 2022-01-18 | Yankton | South Dakota | 46135 | 5042 | 47 |
2124665 | 2124665 | 2022-01-17 | Yankton | South Dakota | 46135 | 4988 | 47 |
2121413 | 2121413 | 2022-01-16 | Yankton | South Dakota | 46135 | 4988 | 47 |
2118161 | 2118161 | 2022-01-15 | Yankton | South Dakota | 46135 | 4988 | 47 |
2114910 | 2114910 | 2022-01-14 | Yankton | South Dakota | 46135 | 4988 | 47 |
2111658 | 2111658 | 2022-01-13 | Yankton | South Dakota | 46135 | 4920 | 46 |
2108406 | 2108406 | 2022-01-12 | Yankton | South Dakota | 46135 | 4879 | 46 |
2105155 | 2105155 | 2022-01-11 | Yankton | South Dakota | 46135 | 4808 | 46 |
2101904 | 2101904 | 2022-01-10 | Yankton | South Dakota | 46135 | 4742 | 46 |
2098653 | 2098653 | 2022-01-09 | Yankton | South Dakota | 46135 | 4700 | 46 |
2095401 | 2095401 | 2022-01-08 | Yankton | South Dakota | 46135 | 4700 | 46 |
2092149 | 2092149 | 2022-01-07 | Yankton | South Dakota | 46135 | 4700 | 46 |
2088897 | 2088897 | 2022-01-06 | Yankton | South Dakota | 46135 | 4656 | 46 |
2085646 | 2085646 | 2022-01-05 | Yankton | South Dakota | 46135 | 4590 | 46 |
2082394 | 2082394 | 2022-01-04 | Yankton | South Dakota | 46135 | 4533 | 45 |
2079142 | 2079142 | 2022-01-03 | Yankton | South Dakota | 46135 | 4452 | 45 |
2075891 | 2075891 | 2022-01-02 | Yankton | South Dakota | 46135 | 4438 | 44 |
2072640 | 2072640 | 2022-01-01 | Yankton | South Dakota | 46135 | 4438 | 44 |
2069389 | 2069389 | 2021-12-31 | Yankton | South Dakota | 46135 | 4438 | 44 |
2066138 | 2066138 | 2021-12-30 | Yankton | South Dakota | 46135 | 4438 | 44 |
2062888 | 2062888 | 2021-12-29 | Yankton | South Dakota | 46135 | 4425 | 44 |
2059638 | 2059638 | 2021-12-28 | Yankton | South Dakota | 46135 | 4383 | 44 |
2056389 | 2056389 | 2021-12-27 | Yankton | South Dakota | 46135 | 4351 | 44 |
2053140 | 2053140 | 2021-12-26 | Yankton | South Dakota | 46135 | 4338 | 44 |
2049890 | 2049890 | 2021-12-25 | Yankton | South Dakota | 46135 | 4338 | 44 |
2046640 | 2046640 | 2021-12-24 | Yankton | South Dakota | 46135 | 4338 | 44 |
2043390 | 2043390 | 2021-12-23 | Yankton | South Dakota | 46135 | 4338 | 44 |
2040141 | 2040141 | 2021-12-22 | Yankton | South Dakota | 46135 | 4323 | 44 |
2036891 | 2036891 | 2021-12-21 | Yankton | South Dakota | 46135 | 4303 | 44 |
2033641 | 2033641 | 2021-12-20 | Yankton | South Dakota | 46135 | 4261 | 44 |
2030391 | 2030391 | 2021-12-19 | Yankton | South Dakota | 46135 | 4241 | 44 |
2027140 | 2027140 | 2021-12-18 | Yankton | South Dakota | 46135 | 4241 | 44 |
2023889 | 2023889 | 2021-12-17 | Yankton | South Dakota | 46135 | 4241 | 44 |
2020638 | 2020638 | 2021-12-16 | Yankton | South Dakota | 46135 | 4231 | 44 |
2017387 | 2017387 | 2021-12-15 | Yankton | South Dakota | 46135 | 4196 | 44 |
2014137 | 2014137 | 2021-12-14 | Yankton | South Dakota | 46135 | 4176 | 44 |
2010886 | 2010886 | 2021-12-13 | Yankton | South Dakota | 46135 | 4138 | 44 |
2007635 | 2007635 | 2021-12-12 | Yankton | South Dakota | 46135 | 4129 | 44 |
2004384 | 2004384 | 2021-12-11 | Yankton | South Dakota | 46135 | 4129 | 44 |
2001133 | 2001133 | 2021-12-10 | Yankton | South Dakota | 46135 | 4129 | 44 |
1997883 | 1997883 | 2021-12-09 | Yankton | South Dakota | 46135 | 4120 | 43 |
1994632 | 1994632 | 2021-12-08 | Yankton | South Dakota | 46135 | 4098 | 43 |
1991381 | 1991381 | 2021-12-07 | Yankton | South Dakota | 46135 | 4078 | 42 |
1988130 | 1988130 | 2021-12-06 | Yankton | South Dakota | 46135 | 4051 | 42 |
1984880 | 1984880 | 2021-12-05 | Yankton | South Dakota | 46135 | 4039 | 42 |
1981630 | 1981630 | 2021-12-04 | Yankton | South Dakota | 46135 | 4039 | 42 |
1978380 | 1978380 | 2021-12-03 | Yankton | South Dakota | 46135 | 4039 | 42 |
1975130 | 1975130 | 2021-12-02 | Yankton | South Dakota | 46135 | 4029 | 42 |
1971881 | 1971881 | 2021-12-01 | Yankton | South Dakota | 46135 | 4014 | 42 |
1968631 | 1968631 | 2021-11-30 | Yankton | South Dakota | 46135 | 3978 | 41 |
1965380 | 1965380 | 2021-11-29 | Yankton | South Dakota | 46135 | 3969 | 41 |
1962128 | 1962128 | 2021-11-28 | Yankton | South Dakota | 46135 | 3960 | 41 |
1958877 | 1958877 | 2021-11-27 | Yankton | South Dakota | 46135 | 3960 | 41 |
1955626 | 1955626 | 2021-11-26 | Yankton | South Dakota | 46135 | 3960 | 41 |
1952375 | 1952375 | 2021-11-25 | Yankton | South Dakota | 46135 | 3960 | 41 |
1949124 | 1949124 | 2021-11-24 | Yankton | South Dakota | 46135 | 3960 | 41 |
1945873 | 1945873 | 2021-11-23 | Yankton | South Dakota | 46135 | 3941 | 41 |
1942622 | 1942622 | 2021-11-22 | Yankton | South Dakota | 46135 | 3915 | 41 |
1939372 | 1939372 | 2021-11-21 | Yankton | South Dakota | 46135 | 3897 | 41 |
1936122 | 1936122 | 2021-11-20 | Yankton | South Dakota | 46135 | 3897 | 41 |
1932872 | 1932872 | 2021-11-19 | Yankton | South Dakota | 46135 | 3897 | 41 |
1929621 | 1929621 | 2021-11-18 | Yankton | South Dakota | 46135 | 3894 | 41 |
1926371 | 1926371 | 2021-11-17 | Yankton | South Dakota | 46135 | 3881 | 41 |
1923121 | 1923121 | 2021-11-16 | Yankton | South Dakota | 46135 | 3864 | 40 |
1919872 | 1919872 | 2021-11-15 | Yankton | South Dakota | 46135 | 3842 | 40 |
1916622 | 1916622 | 2021-11-14 | Yankton | South Dakota | 46135 | 3820 | 40 |
1913372 | 1913372 | 2021-11-13 | Yankton | South Dakota | 46135 | 3820 | 40 |
1910122 | 1910122 | 2021-11-12 | Yankton | South Dakota | 46135 | 3820 | 40 |
1906873 | 1906873 | 2021-11-11 | Yankton | South Dakota | 46135 | 3806 | 40 |
1903624 | 1903624 | 2021-11-10 | Yankton | South Dakota | 46135 | 3806 | 40 |
1900374 | 1900374 | 2021-11-09 | Yankton | South Dakota | 46135 | 3784 | 40 |
1897124 | 1897124 | 2021-11-08 | Yankton | South Dakota | 46135 | 3762 | 40 |
1893874 | 1893874 | 2021-11-07 | Yankton | South Dakota | 46135 | 3751 | 40 |
1890624 | 1890624 | 2021-11-06 | Yankton | South Dakota | 46135 | 3751 | 40 |
1887374 | 1887374 | 2021-11-05 | Yankton | South Dakota | 46135 | 3751 | 40 |
1884124 | 1884124 | 2021-11-04 | Yankton | South Dakota | 46135 | 3741 | 40 |
1880875 | 1880875 | 2021-11-03 | Yankton | South Dakota | 46135 | 3726 | 40 |
1877626 | 1877626 | 2021-11-02 | Yankton | South Dakota | 46135 | 3717 | 40 |
1874377 | 1874377 | 2021-11-01 | Yankton | South Dakota | 46135 | 3696 | 40 |
1871128 | 1871128 | 2021-10-31 | Yankton | South Dakota | 46135 | 3678 | 38 |
1867879 | 1867879 | 2021-10-30 | Yankton | South Dakota | 46135 | 3678 | 38 |
1864630 | 1864630 | 2021-10-29 | Yankton | South Dakota | 46135 | 3678 | 38 |
1861381 | 1861381 | 2021-10-28 | Yankton | South Dakota | 46135 | 3665 | 38 |
1858132 | 1858132 | 2021-10-27 | Yankton | South Dakota | 46135 | 3662 | 38 |
1854883 | 1854883 | 2021-10-26 | Yankton | South Dakota | 46135 | 3647 | 38 |
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);