ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 46039 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 |
---|---|---|---|---|---|---|---|
2176679 | 2176679 | 2022-02-02 | Deuel | South Dakota | 46039 | 1007 | 12 |
2173425 | 2173425 | 2022-02-01 | Deuel | South Dakota | 46039 | 1002 | 12 |
2170173 | 2170173 | 2022-01-31 | Deuel | South Dakota | 46039 | 992 | 12 |
2166919 | 2166919 | 2022-01-30 | Deuel | South Dakota | 46039 | 990 | 12 |
2163664 | 2163664 | 2022-01-29 | Deuel | South Dakota | 46039 | 990 | 12 |
2160409 | 2160409 | 2022-01-28 | Deuel | South Dakota | 46039 | 990 | 12 |
2157153 | 2157153 | 2022-01-27 | Deuel | South Dakota | 46039 | 986 | 12 |
2153900 | 2153900 | 2022-01-26 | Deuel | South Dakota | 46039 | 981 | 12 |
2150648 | 2150648 | 2022-01-25 | Deuel | South Dakota | 46039 | 971 | 12 |
2147396 | 2147396 | 2022-01-24 | Deuel | South Dakota | 46039 | 961 | 12 |
2144142 | 2144142 | 2022-01-23 | Deuel | South Dakota | 46039 | 946 | 12 |
2140887 | 2140887 | 2022-01-22 | Deuel | South Dakota | 46039 | 946 | 12 |
2137631 | 2137631 | 2022-01-21 | Deuel | South Dakota | 46039 | 946 | 12 |
2134377 | 2134377 | 2022-01-20 | Deuel | South Dakota | 46039 | 938 | 12 |
2131125 | 2131125 | 2022-01-19 | Deuel | South Dakota | 46039 | 931 | 12 |
2127871 | 2127871 | 2022-01-18 | Deuel | South Dakota | 46039 | 901 | 12 |
2124619 | 2124619 | 2022-01-17 | Deuel | South Dakota | 46039 | 886 | 12 |
2121367 | 2121367 | 2022-01-16 | Deuel | South Dakota | 46039 | 886 | 12 |
2118115 | 2118115 | 2022-01-15 | Deuel | South Dakota | 46039 | 886 | 12 |
2114864 | 2114864 | 2022-01-14 | Deuel | South Dakota | 46039 | 886 | 12 |
2111612 | 2111612 | 2022-01-13 | Deuel | South Dakota | 46039 | 874 | 12 |
2108360 | 2108360 | 2022-01-12 | Deuel | South Dakota | 46039 | 870 | 12 |
2105109 | 2105109 | 2022-01-11 | Deuel | South Dakota | 46039 | 859 | 12 |
2101858 | 2101858 | 2022-01-10 | Deuel | South Dakota | 46039 | 848 | 12 |
2098607 | 2098607 | 2022-01-09 | Deuel | South Dakota | 46039 | 843 | 12 |
2095355 | 2095355 | 2022-01-08 | Deuel | South Dakota | 46039 | 843 | 12 |
2092103 | 2092103 | 2022-01-07 | Deuel | South Dakota | 46039 | 843 | 12 |
2088851 | 2088851 | 2022-01-06 | Deuel | South Dakota | 46039 | 842 | 12 |
2085600 | 2085600 | 2022-01-05 | Deuel | South Dakota | 46039 | 836 | 12 |
2082348 | 2082348 | 2022-01-04 | Deuel | South Dakota | 46039 | 826 | 12 |
2079096 | 2079096 | 2022-01-03 | Deuel | South Dakota | 46039 | 820 | 12 |
2075845 | 2075845 | 2022-01-02 | Deuel | South Dakota | 46039 | 819 | 12 |
2072594 | 2072594 | 2022-01-01 | Deuel | South Dakota | 46039 | 819 | 12 |
2069343 | 2069343 | 2021-12-31 | Deuel | South Dakota | 46039 | 819 | 12 |
2066092 | 2066092 | 2021-12-30 | Deuel | South Dakota | 46039 | 819 | 12 |
2062842 | 2062842 | 2021-12-29 | Deuel | South Dakota | 46039 | 815 | 12 |
2059592 | 2059592 | 2021-12-28 | Deuel | South Dakota | 46039 | 813 | 12 |
2056343 | 2056343 | 2021-12-27 | Deuel | South Dakota | 46039 | 809 | 12 |
2053094 | 2053094 | 2021-12-26 | Deuel | South Dakota | 46039 | 809 | 12 |
2049844 | 2049844 | 2021-12-25 | Deuel | South Dakota | 46039 | 809 | 12 |
2046594 | 2046594 | 2021-12-24 | Deuel | South Dakota | 46039 | 809 | 12 |
2043344 | 2043344 | 2021-12-23 | Deuel | South Dakota | 46039 | 809 | 12 |
2040095 | 2040095 | 2021-12-22 | Deuel | South Dakota | 46039 | 807 | 12 |
2036845 | 2036845 | 2021-12-21 | Deuel | South Dakota | 46039 | 805 | 12 |
2033595 | 2033595 | 2021-12-20 | Deuel | South Dakota | 46039 | 798 | 12 |
2030345 | 2030345 | 2021-12-19 | Deuel | South Dakota | 46039 | 797 | 12 |
2027094 | 2027094 | 2021-12-18 | Deuel | South Dakota | 46039 | 797 | 12 |
2023843 | 2023843 | 2021-12-17 | Deuel | South Dakota | 46039 | 797 | 12 |
2020592 | 2020592 | 2021-12-16 | Deuel | South Dakota | 46039 | 795 | 12 |
2017341 | 2017341 | 2021-12-15 | Deuel | South Dakota | 46039 | 792 | 12 |
2014091 | 2014091 | 2021-12-14 | Deuel | South Dakota | 46039 | 789 | 12 |
2010840 | 2010840 | 2021-12-13 | Deuel | South Dakota | 46039 | 783 | 12 |
2007589 | 2007589 | 2021-12-12 | Deuel | South Dakota | 46039 | 780 | 12 |
2004338 | 2004338 | 2021-12-11 | Deuel | South Dakota | 46039 | 780 | 12 |
2001087 | 2001087 | 2021-12-10 | Deuel | South Dakota | 46039 | 780 | 12 |
1997837 | 1997837 | 2021-12-09 | Deuel | South Dakota | 46039 | 779 | 12 |
1994586 | 1994586 | 2021-12-08 | Deuel | South Dakota | 46039 | 774 | 11 |
1991335 | 1991335 | 2021-12-07 | Deuel | South Dakota | 46039 | 767 | 11 |
1988084 | 1988084 | 2021-12-06 | Deuel | South Dakota | 46039 | 760 | 11 |
1984834 | 1984834 | 2021-12-05 | Deuel | South Dakota | 46039 | 756 | 11 |
1981584 | 1981584 | 2021-12-04 | Deuel | South Dakota | 46039 | 756 | 11 |
1978334 | 1978334 | 2021-12-03 | Deuel | South Dakota | 46039 | 756 | 11 |
1975084 | 1975084 | 2021-12-02 | Deuel | South Dakota | 46039 | 755 | 11 |
1971835 | 1971835 | 2021-12-01 | Deuel | South Dakota | 46039 | 749 | 11 |
1968585 | 1968585 | 2021-11-30 | Deuel | South Dakota | 46039 | 745 | 11 |
1965334 | 1965334 | 2021-11-29 | Deuel | South Dakota | 46039 | 738 | 11 |
1962082 | 1962082 | 2021-11-28 | Deuel | South Dakota | 46039 | 733 | 11 |
1958831 | 1958831 | 2021-11-27 | Deuel | South Dakota | 46039 | 733 | 11 |
1955580 | 1955580 | 2021-11-26 | Deuel | South Dakota | 46039 | 733 | 11 |
1952329 | 1952329 | 2021-11-25 | Deuel | South Dakota | 46039 | 733 | 11 |
1949078 | 1949078 | 2021-11-24 | Deuel | South Dakota | 46039 | 733 | 11 |
1945827 | 1945827 | 2021-11-23 | Deuel | South Dakota | 46039 | 724 | 11 |
1942576 | 1942576 | 2021-11-22 | Deuel | South Dakota | 46039 | 718 | 11 |
1939326 | 1939326 | 2021-11-21 | Deuel | South Dakota | 46039 | 716 | 11 |
1936076 | 1936076 | 2021-11-20 | Deuel | South Dakota | 46039 | 716 | 11 |
1932826 | 1932826 | 2021-11-19 | Deuel | South Dakota | 46039 | 716 | 11 |
1929575 | 1929575 | 2021-11-18 | Deuel | South Dakota | 46039 | 716 | 11 |
1926325 | 1926325 | 2021-11-17 | Deuel | South Dakota | 46039 | 716 | 11 |
1923075 | 1923075 | 2021-11-16 | Deuel | South Dakota | 46039 | 711 | 11 |
1919826 | 1919826 | 2021-11-15 | Deuel | South Dakota | 46039 | 704 | 11 |
1916576 | 1916576 | 2021-11-14 | Deuel | South Dakota | 46039 | 702 | 11 |
1913326 | 1913326 | 2021-11-13 | Deuel | South Dakota | 46039 | 702 | 11 |
1910076 | 1910076 | 2021-11-12 | Deuel | South Dakota | 46039 | 702 | 11 |
1906827 | 1906827 | 2021-11-11 | Deuel | South Dakota | 46039 | 697 | 11 |
1903578 | 1903578 | 2021-11-10 | Deuel | South Dakota | 46039 | 697 | 11 |
1900328 | 1900328 | 2021-11-09 | Deuel | South Dakota | 46039 | 692 | 11 |
1897078 | 1897078 | 2021-11-08 | Deuel | South Dakota | 46039 | 682 | 11 |
1893828 | 1893828 | 2021-11-07 | Deuel | South Dakota | 46039 | 680 | 11 |
1890578 | 1890578 | 2021-11-06 | Deuel | South Dakota | 46039 | 680 | 11 |
1887328 | 1887328 | 2021-11-05 | Deuel | South Dakota | 46039 | 680 | 11 |
1884078 | 1884078 | 2021-11-04 | Deuel | South Dakota | 46039 | 679 | 11 |
1880829 | 1880829 | 2021-11-03 | Deuel | South Dakota | 46039 | 675 | 11 |
1877580 | 1877580 | 2021-11-02 | Deuel | South Dakota | 46039 | 672 | 11 |
1874331 | 1874331 | 2021-11-01 | Deuel | South Dakota | 46039 | 667 | 11 |
1871082 | 1871082 | 2021-10-31 | Deuel | South Dakota | 46039 | 666 | 11 |
1867833 | 1867833 | 2021-10-30 | Deuel | South Dakota | 46039 | 666 | 11 |
1864584 | 1864584 | 2021-10-29 | Deuel | South Dakota | 46039 | 666 | 11 |
1861335 | 1861335 | 2021-10-28 | Deuel | South Dakota | 46039 | 663 | 11 |
1858086 | 1858086 | 2021-10-27 | Deuel | South Dakota | 46039 | 662 | 11 |
1854837 | 1854837 | 2021-10-26 | Deuel | South Dakota | 46039 | 659 | 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);