ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Bon Homme" 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 |
---|---|---|---|---|---|---|---|
2176664 | 2176664 | 2022-02-02 | Bon Homme | South Dakota | 46009 | 2258 | 36 |
2173410 | 2173410 | 2022-02-01 | Bon Homme | South Dakota | 46009 | 2255 | 36 |
2170158 | 2170158 | 2022-01-31 | Bon Homme | South Dakota | 46009 | 2247 | 36 |
2166904 | 2166904 | 2022-01-30 | Bon Homme | South Dakota | 46009 | 2240 | 36 |
2163649 | 2163649 | 2022-01-29 | Bon Homme | South Dakota | 46009 | 2240 | 36 |
2160394 | 2160394 | 2022-01-28 | Bon Homme | South Dakota | 46009 | 2240 | 36 |
2157138 | 2157138 | 2022-01-27 | Bon Homme | South Dakota | 46009 | 2235 | 36 |
2153885 | 2153885 | 2022-01-26 | Bon Homme | South Dakota | 46009 | 2228 | 36 |
2150633 | 2150633 | 2022-01-25 | Bon Homme | South Dakota | 46009 | 2217 | 36 |
2147381 | 2147381 | 2022-01-24 | Bon Homme | South Dakota | 46009 | 2196 | 36 |
2144127 | 2144127 | 2022-01-23 | Bon Homme | South Dakota | 46009 | 2191 | 35 |
2140872 | 2140872 | 2022-01-22 | Bon Homme | South Dakota | 46009 | 2191 | 35 |
2137616 | 2137616 | 2022-01-21 | Bon Homme | South Dakota | 46009 | 2191 | 35 |
2134362 | 2134362 | 2022-01-20 | Bon Homme | South Dakota | 46009 | 2171 | 34 |
2131110 | 2131110 | 2022-01-19 | Bon Homme | South Dakota | 46009 | 2158 | 34 |
2127856 | 2127856 | 2022-01-18 | Bon Homme | South Dakota | 46009 | 2117 | 33 |
2124604 | 2124604 | 2022-01-17 | Bon Homme | South Dakota | 46009 | 2095 | 33 |
2121352 | 2121352 | 2022-01-16 | Bon Homme | South Dakota | 46009 | 2095 | 33 |
2118100 | 2118100 | 2022-01-15 | Bon Homme | South Dakota | 46009 | 2095 | 33 |
2114849 | 2114849 | 2022-01-14 | Bon Homme | South Dakota | 46009 | 2095 | 33 |
2111597 | 2111597 | 2022-01-13 | Bon Homme | South Dakota | 46009 | 2062 | 33 |
2108345 | 2108345 | 2022-01-12 | Bon Homme | South Dakota | 46009 | 1998 | 31 |
2105094 | 2105094 | 2022-01-11 | Bon Homme | South Dakota | 46009 | 1983 | 31 |
2101843 | 2101843 | 2022-01-10 | Bon Homme | South Dakota | 46009 | 1961 | 31 |
2098592 | 2098592 | 2022-01-09 | Bon Homme | South Dakota | 46009 | 1945 | 31 |
2095340 | 2095340 | 2022-01-08 | Bon Homme | South Dakota | 46009 | 1945 | 31 |
2092088 | 2092088 | 2022-01-07 | Bon Homme | South Dakota | 46009 | 1945 | 31 |
2088836 | 2088836 | 2022-01-06 | Bon Homme | South Dakota | 46009 | 1929 | 31 |
2085585 | 2085585 | 2022-01-05 | Bon Homme | South Dakota | 46009 | 1907 | 31 |
2082333 | 2082333 | 2022-01-04 | Bon Homme | South Dakota | 46009 | 1889 | 31 |
2079081 | 2079081 | 2022-01-03 | Bon Homme | South Dakota | 46009 | 1862 | 31 |
2075830 | 2075830 | 2022-01-02 | Bon Homme | South Dakota | 46009 | 1854 | 31 |
2072579 | 2072579 | 2022-01-01 | Bon Homme | South Dakota | 46009 | 1854 | 31 |
2069328 | 2069328 | 2021-12-31 | Bon Homme | South Dakota | 46009 | 1854 | 31 |
2066077 | 2066077 | 2021-12-30 | Bon Homme | South Dakota | 46009 | 1854 | 31 |
2062827 | 2062827 | 2021-12-29 | Bon Homme | South Dakota | 46009 | 1851 | 31 |
2059577 | 2059577 | 2021-12-28 | Bon Homme | South Dakota | 46009 | 1838 | 31 |
2056328 | 2056328 | 2021-12-27 | Bon Homme | South Dakota | 46009 | 1823 | 31 |
2053079 | 2053079 | 2021-12-26 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2049829 | 2049829 | 2021-12-25 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2046579 | 2046579 | 2021-12-24 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2043329 | 2043329 | 2021-12-23 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2040080 | 2040080 | 2021-12-22 | Bon Homme | South Dakota | 46009 | 1815 | 31 |
2036830 | 2036830 | 2021-12-21 | Bon Homme | South Dakota | 46009 | 1812 | 31 |
2033580 | 2033580 | 2021-12-20 | Bon Homme | South Dakota | 46009 | 1806 | 31 |
2030330 | 2030330 | 2021-12-19 | Bon Homme | South Dakota | 46009 | 1798 | 31 |
2027079 | 2027079 | 2021-12-18 | Bon Homme | South Dakota | 46009 | 1798 | 31 |
2023828 | 2023828 | 2021-12-17 | Bon Homme | South Dakota | 46009 | 1798 | 31 |
2020577 | 2020577 | 2021-12-16 | Bon Homme | South Dakota | 46009 | 1794 | 31 |
2017326 | 2017326 | 2021-12-15 | Bon Homme | South Dakota | 46009 | 1791 | 31 |
2014076 | 2014076 | 2021-12-14 | Bon Homme | South Dakota | 46009 | 1788 | 31 |
2010825 | 2010825 | 2021-12-13 | Bon Homme | South Dakota | 46009 | 1783 | 31 |
2007574 | 2007574 | 2021-12-12 | Bon Homme | South Dakota | 46009 | 1780 | 30 |
2004323 | 2004323 | 2021-12-11 | Bon Homme | South Dakota | 46009 | 1780 | 30 |
2001072 | 2001072 | 2021-12-10 | Bon Homme | South Dakota | 46009 | 1780 | 30 |
1997822 | 1997822 | 2021-12-09 | Bon Homme | South Dakota | 46009 | 1781 | 30 |
1994571 | 1994571 | 2021-12-08 | Bon Homme | South Dakota | 46009 | 1778 | 30 |
1991320 | 1991320 | 2021-12-07 | Bon Homme | South Dakota | 46009 | 1772 | 30 |
1988069 | 1988069 | 2021-12-06 | Bon Homme | South Dakota | 46009 | 1753 | 30 |
1984819 | 1984819 | 2021-12-05 | Bon Homme | South Dakota | 46009 | 1749 | 30 |
1981569 | 1981569 | 2021-12-04 | Bon Homme | South Dakota | 46009 | 1749 | 30 |
1978319 | 1978319 | 2021-12-03 | Bon Homme | South Dakota | 46009 | 1749 | 30 |
1975069 | 1975069 | 2021-12-02 | Bon Homme | South Dakota | 46009 | 1743 | 30 |
1971820 | 1971820 | 2021-12-01 | Bon Homme | South Dakota | 46009 | 1738 | 30 |
1968570 | 1968570 | 2021-11-30 | Bon Homme | South Dakota | 46009 | 1733 | 30 |
1965319 | 1965319 | 2021-11-29 | Bon Homme | South Dakota | 46009 | 1716 | 30 |
1962067 | 1962067 | 2021-11-28 | Bon Homme | South Dakota | 46009 | 1714 | 30 |
1958816 | 1958816 | 2021-11-27 | Bon Homme | South Dakota | 46009 | 1714 | 30 |
1955565 | 1955565 | 2021-11-26 | Bon Homme | South Dakota | 46009 | 1714 | 30 |
1952314 | 1952314 | 2021-11-25 | Bon Homme | South Dakota | 46009 | 1714 | 30 |
1949063 | 1949063 | 2021-11-24 | Bon Homme | South Dakota | 46009 | 1714 | 30 |
1945812 | 1945812 | 2021-11-23 | Bon Homme | South Dakota | 46009 | 1712 | 30 |
1942561 | 1942561 | 2021-11-22 | Bon Homme | South Dakota | 46009 | 1702 | 30 |
1939311 | 1939311 | 2021-11-21 | Bon Homme | South Dakota | 46009 | 1698 | 30 |
1936061 | 1936061 | 2021-11-20 | Bon Homme | South Dakota | 46009 | 1698 | 30 |
1932811 | 1932811 | 2021-11-19 | Bon Homme | South Dakota | 46009 | 1698 | 30 |
1929560 | 1929560 | 2021-11-18 | Bon Homme | South Dakota | 46009 | 1694 | 30 |
1926310 | 1926310 | 2021-11-17 | Bon Homme | South Dakota | 46009 | 1694 | 30 |
1923060 | 1923060 | 2021-11-16 | Bon Homme | South Dakota | 46009 | 1688 | 30 |
1919811 | 1919811 | 2021-11-15 | Bon Homme | South Dakota | 46009 | 1679 | 30 |
1916561 | 1916561 | 2021-11-14 | Bon Homme | South Dakota | 46009 | 1672 | 29 |
1913311 | 1913311 | 2021-11-13 | Bon Homme | South Dakota | 46009 | 1672 | 29 |
1910061 | 1910061 | 2021-11-12 | Bon Homme | South Dakota | 46009 | 1672 | 29 |
1906812 | 1906812 | 2021-11-11 | Bon Homme | South Dakota | 46009 | 1666 | 29 |
1903563 | 1903563 | 2021-11-10 | Bon Homme | South Dakota | 46009 | 1666 | 29 |
1900313 | 1900313 | 2021-11-09 | Bon Homme | South Dakota | 46009 | 1659 | 29 |
1897063 | 1897063 | 2021-11-08 | Bon Homme | South Dakota | 46009 | 1652 | 29 |
1893813 | 1893813 | 2021-11-07 | Bon Homme | South Dakota | 46009 | 1649 | 29 |
1890563 | 1890563 | 2021-11-06 | Bon Homme | South Dakota | 46009 | 1649 | 29 |
1887313 | 1887313 | 2021-11-05 | Bon Homme | South Dakota | 46009 | 1649 | 29 |
1884063 | 1884063 | 2021-11-04 | Bon Homme | South Dakota | 46009 | 1648 | 29 |
1880814 | 1880814 | 2021-11-03 | Bon Homme | South Dakota | 46009 | 1646 | 29 |
1877565 | 1877565 | 2021-11-02 | Bon Homme | South Dakota | 46009 | 1644 | 29 |
1874316 | 1874316 | 2021-11-01 | Bon Homme | South Dakota | 46009 | 1640 | 29 |
1871067 | 1871067 | 2021-10-31 | Bon Homme | South Dakota | 46009 | 1637 | 29 |
1867818 | 1867818 | 2021-10-30 | Bon Homme | South Dakota | 46009 | 1637 | 29 |
1864569 | 1864569 | 2021-10-29 | Bon Homme | South Dakota | 46009 | 1637 | 29 |
1861320 | 1861320 | 2021-10-28 | Bon Homme | South Dakota | 46009 | 1636 | 29 |
1858071 | 1858071 | 2021-10-27 | Bon Homme | South Dakota | 46009 | 1634 | 29 |
1854822 | 1854822 | 2021-10-26 | Bon Homme | South Dakota | 46009 | 1634 | 29 |
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);