ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 46011 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 |
---|---|---|---|---|---|---|---|
2176665 | 2176665 | 2022-02-02 | Brookings | South Dakota | 46011 | 7891 | 43 |
2173411 | 2173411 | 2022-02-01 | Brookings | South Dakota | 46011 | 7868 | 43 |
2170159 | 2170159 | 2022-01-31 | Brookings | South Dakota | 46011 | 7828 | 43 |
2166905 | 2166905 | 2022-01-30 | Brookings | South Dakota | 46011 | 7805 | 43 |
2163650 | 2163650 | 2022-01-29 | Brookings | South Dakota | 46011 | 7805 | 43 |
2160395 | 2160395 | 2022-01-28 | Brookings | South Dakota | 46011 | 7805 | 43 |
2157139 | 2157139 | 2022-01-27 | Brookings | South Dakota | 46011 | 7752 | 41 |
2153886 | 2153886 | 2022-01-26 | Brookings | South Dakota | 46011 | 7690 | 41 |
2150634 | 2150634 | 2022-01-25 | Brookings | South Dakota | 46011 | 7637 | 41 |
2147382 | 2147382 | 2022-01-24 | Brookings | South Dakota | 46011 | 7531 | 41 |
2144128 | 2144128 | 2022-01-23 | Brookings | South Dakota | 46011 | 7425 | 41 |
2140873 | 2140873 | 2022-01-22 | Brookings | South Dakota | 46011 | 7425 | 41 |
2137617 | 2137617 | 2022-01-21 | Brookings | South Dakota | 46011 | 7425 | 41 |
2134363 | 2134363 | 2022-01-20 | Brookings | South Dakota | 46011 | 7353 | 41 |
2131111 | 2131111 | 2022-01-19 | Brookings | South Dakota | 46011 | 7226 | 41 |
2127857 | 2127857 | 2022-01-18 | Brookings | South Dakota | 46011 | 6975 | 41 |
2124605 | 2124605 | 2022-01-17 | Brookings | South Dakota | 46011 | 6856 | 41 |
2121353 | 2121353 | 2022-01-16 | Brookings | South Dakota | 46011 | 6856 | 41 |
2118101 | 2118101 | 2022-01-15 | Brookings | South Dakota | 46011 | 6856 | 41 |
2114850 | 2114850 | 2022-01-14 | Brookings | South Dakota | 46011 | 6856 | 41 |
2111598 | 2111598 | 2022-01-13 | Brookings | South Dakota | 46011 | 6741 | 41 |
2108346 | 2108346 | 2022-01-12 | Brookings | South Dakota | 46011 | 6604 | 41 |
2105095 | 2105095 | 2022-01-11 | Brookings | South Dakota | 46011 | 6479 | 41 |
2101844 | 2101844 | 2022-01-10 | Brookings | South Dakota | 46011 | 6280 | 41 |
2098593 | 2098593 | 2022-01-09 | Brookings | South Dakota | 46011 | 6176 | 41 |
2095341 | 2095341 | 2022-01-08 | Brookings | South Dakota | 46011 | 6176 | 41 |
2092089 | 2092089 | 2022-01-07 | Brookings | South Dakota | 46011 | 6176 | 41 |
2088837 | 2088837 | 2022-01-06 | Brookings | South Dakota | 46011 | 6066 | 41 |
2085586 | 2085586 | 2022-01-05 | Brookings | South Dakota | 46011 | 5968 | 41 |
2082334 | 2082334 | 2022-01-04 | Brookings | South Dakota | 46011 | 5889 | 41 |
2079082 | 2079082 | 2022-01-03 | Brookings | South Dakota | 46011 | 5803 | 41 |
2075831 | 2075831 | 2022-01-02 | Brookings | South Dakota | 46011 | 5778 | 41 |
2072580 | 2072580 | 2022-01-01 | Brookings | South Dakota | 46011 | 5778 | 41 |
2069329 | 2069329 | 2021-12-31 | Brookings | South Dakota | 46011 | 5778 | 41 |
2066078 | 2066078 | 2021-12-30 | Brookings | South Dakota | 46011 | 5778 | 41 |
2062828 | 2062828 | 2021-12-29 | Brookings | South Dakota | 46011 | 5745 | 41 |
2059578 | 2059578 | 2021-12-28 | Brookings | South Dakota | 46011 | 5718 | 41 |
2056329 | 2056329 | 2021-12-27 | Brookings | South Dakota | 46011 | 5682 | 41 |
2053080 | 2053080 | 2021-12-26 | Brookings | South Dakota | 46011 | 5669 | 41 |
2049830 | 2049830 | 2021-12-25 | Brookings | South Dakota | 46011 | 5669 | 41 |
2046580 | 2046580 | 2021-12-24 | Brookings | South Dakota | 46011 | 5669 | 41 |
2043330 | 2043330 | 2021-12-23 | Brookings | South Dakota | 46011 | 5669 | 41 |
2040081 | 2040081 | 2021-12-22 | Brookings | South Dakota | 46011 | 5658 | 41 |
2036831 | 2036831 | 2021-12-21 | Brookings | South Dakota | 46011 | 5640 | 41 |
2033581 | 2033581 | 2021-12-20 | Brookings | South Dakota | 46011 | 5614 | 41 |
2030331 | 2030331 | 2021-12-19 | Brookings | South Dakota | 46011 | 5603 | 41 |
2027080 | 2027080 | 2021-12-18 | Brookings | South Dakota | 46011 | 5603 | 41 |
2023829 | 2023829 | 2021-12-17 | Brookings | South Dakota | 46011 | 5603 | 41 |
2020578 | 2020578 | 2021-12-16 | Brookings | South Dakota | 46011 | 5582 | 41 |
2017327 | 2017327 | 2021-12-15 | Brookings | South Dakota | 46011 | 5563 | 41 |
2014077 | 2014077 | 2021-12-14 | Brookings | South Dakota | 46011 | 5542 | 41 |
2010826 | 2010826 | 2021-12-13 | Brookings | South Dakota | 46011 | 5519 | 41 |
2007575 | 2007575 | 2021-12-12 | Brookings | South Dakota | 46011 | 5510 | 41 |
2004324 | 2004324 | 2021-12-11 | Brookings | South Dakota | 46011 | 5510 | 41 |
2001073 | 2001073 | 2021-12-10 | Brookings | South Dakota | 46011 | 5510 | 41 |
1997823 | 1997823 | 2021-12-09 | Brookings | South Dakota | 46011 | 5515 | 41 |
1994572 | 1994572 | 2021-12-08 | Brookings | South Dakota | 46011 | 5514 | 42 |
1991321 | 1991321 | 2021-12-07 | Brookings | South Dakota | 46011 | 5495 | 42 |
1988070 | 1988070 | 2021-12-06 | Brookings | South Dakota | 46011 | 5460 | 42 |
1984820 | 1984820 | 2021-12-05 | Brookings | South Dakota | 46011 | 5444 | 41 |
1981570 | 1981570 | 2021-12-04 | Brookings | South Dakota | 46011 | 5444 | 41 |
1978320 | 1978320 | 2021-12-03 | Brookings | South Dakota | 46011 | 5444 | 41 |
1975070 | 1975070 | 2021-12-02 | Brookings | South Dakota | 46011 | 5417 | 41 |
1971821 | 1971821 | 2021-12-01 | Brookings | South Dakota | 46011 | 5389 | 41 |
1968571 | 1968571 | 2021-11-30 | Brookings | South Dakota | 46011 | 5366 | 41 |
1965320 | 1965320 | 2021-11-29 | Brookings | South Dakota | 46011 | 5333 | 41 |
1962068 | 1962068 | 2021-11-28 | Brookings | South Dakota | 46011 | 5319 | 40 |
1958817 | 1958817 | 2021-11-27 | Brookings | South Dakota | 46011 | 5319 | 40 |
1955566 | 1955566 | 2021-11-26 | Brookings | South Dakota | 46011 | 5319 | 40 |
1952315 | 1952315 | 2021-11-25 | Brookings | South Dakota | 46011 | 5319 | 40 |
1949064 | 1949064 | 2021-11-24 | Brookings | South Dakota | 46011 | 5319 | 40 |
1945813 | 1945813 | 2021-11-23 | Brookings | South Dakota | 46011 | 5308 | 39 |
1942562 | 1942562 | 2021-11-22 | Brookings | South Dakota | 46011 | 5282 | 39 |
1939312 | 1939312 | 2021-11-21 | Brookings | South Dakota | 46011 | 5272 | 39 |
1936062 | 1936062 | 2021-11-20 | Brookings | South Dakota | 46011 | 5272 | 39 |
1932812 | 1932812 | 2021-11-19 | Brookings | South Dakota | 46011 | 5272 | 39 |
1929561 | 1929561 | 2021-11-18 | Brookings | South Dakota | 46011 | 5265 | 39 |
1926311 | 1926311 | 2021-11-17 | Brookings | South Dakota | 46011 | 5249 | 39 |
1923061 | 1923061 | 2021-11-16 | Brookings | South Dakota | 46011 | 5233 | 39 |
1919812 | 1919812 | 2021-11-15 | Brookings | South Dakota | 46011 | 5221 | 39 |
1916562 | 1916562 | 2021-11-14 | Brookings | South Dakota | 46011 | 5211 | 39 |
1913312 | 1913312 | 2021-11-13 | Brookings | South Dakota | 46011 | 5211 | 39 |
1910062 | 1910062 | 2021-11-12 | Brookings | South Dakota | 46011 | 5211 | 39 |
1906813 | 1906813 | 2021-11-11 | Brookings | South Dakota | 46011 | 5206 | 39 |
1903564 | 1903564 | 2021-11-10 | Brookings | South Dakota | 46011 | 5206 | 39 |
1900314 | 1900314 | 2021-11-09 | Brookings | South Dakota | 46011 | 5199 | 39 |
1897064 | 1897064 | 2021-11-08 | Brookings | South Dakota | 46011 | 5183 | 39 |
1893814 | 1893814 | 2021-11-07 | Brookings | South Dakota | 46011 | 5177 | 39 |
1890564 | 1890564 | 2021-11-06 | Brookings | South Dakota | 46011 | 5177 | 39 |
1887314 | 1887314 | 2021-11-05 | Brookings | South Dakota | 46011 | 5177 | 39 |
1884064 | 1884064 | 2021-11-04 | Brookings | South Dakota | 46011 | 5170 | 39 |
1880815 | 1880815 | 2021-11-03 | Brookings | South Dakota | 46011 | 5162 | 39 |
1877566 | 1877566 | 2021-11-02 | Brookings | South Dakota | 46011 | 5157 | 39 |
1874317 | 1874317 | 2021-11-01 | Brookings | South Dakota | 46011 | 5141 | 39 |
1871068 | 1871068 | 2021-10-31 | Brookings | South Dakota | 46011 | 5132 | 39 |
1867819 | 1867819 | 2021-10-30 | Brookings | South Dakota | 46011 | 5132 | 39 |
1864570 | 1864570 | 2021-10-29 | Brookings | South Dakota | 46011 | 5132 | 39 |
1861321 | 1861321 | 2021-10-28 | Brookings | South Dakota | 46011 | 5127 | 38 |
1858072 | 1858072 | 2021-10-27 | Brookings | South Dakota | 46011 | 5123 | 38 |
1854823 | 1854823 | 2021-10-26 | Brookings | South Dakota | 46011 | 5113 | 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);