ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 46083 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 |
---|---|---|---|---|---|---|---|
2176701 | 2176701 | 2022-02-02 | Lincoln | South Dakota | 46083 | 15219 | 90 |
2173447 | 2173447 | 2022-02-01 | Lincoln | South Dakota | 46083 | 15190 | 89 |
2170195 | 2170195 | 2022-01-31 | Lincoln | South Dakota | 46083 | 15124 | 89 |
2166941 | 2166941 | 2022-01-30 | Lincoln | South Dakota | 46083 | 15086 | 89 |
2163686 | 2163686 | 2022-01-29 | Lincoln | South Dakota | 46083 | 15086 | 89 |
2160431 | 2160431 | 2022-01-28 | Lincoln | South Dakota | 46083 | 15086 | 89 |
2157175 | 2157175 | 2022-01-27 | Lincoln | South Dakota | 46083 | 15052 | 87 |
2153922 | 2153922 | 2022-01-26 | Lincoln | South Dakota | 46083 | 15001 | 87 |
2150670 | 2150670 | 2022-01-25 | Lincoln | South Dakota | 46083 | 14943 | 87 |
2147418 | 2147418 | 2022-01-24 | Lincoln | South Dakota | 46083 | 14808 | 87 |
2144164 | 2144164 | 2022-01-23 | Lincoln | South Dakota | 46083 | 14734 | 87 |
2140909 | 2140909 | 2022-01-22 | Lincoln | South Dakota | 46083 | 14734 | 87 |
2137653 | 2137653 | 2022-01-21 | Lincoln | South Dakota | 46083 | 14734 | 87 |
2134399 | 2134399 | 2022-01-20 | Lincoln | South Dakota | 46083 | 14636 | 87 |
2131147 | 2131147 | 2022-01-19 | Lincoln | South Dakota | 46083 | 14533 | 87 |
2127893 | 2127893 | 2022-01-18 | Lincoln | South Dakota | 46083 | 14073 | 86 |
2124641 | 2124641 | 2022-01-17 | Lincoln | South Dakota | 46083 | 13926 | 86 |
2121389 | 2121389 | 2022-01-16 | Lincoln | South Dakota | 46083 | 13926 | 86 |
2118137 | 2118137 | 2022-01-15 | Lincoln | South Dakota | 46083 | 13926 | 86 |
2114886 | 2114886 | 2022-01-14 | Lincoln | South Dakota | 46083 | 13926 | 86 |
2111634 | 2111634 | 2022-01-13 | Lincoln | South Dakota | 46083 | 13755 | 86 |
2108382 | 2108382 | 2022-01-12 | Lincoln | South Dakota | 46083 | 13533 | 86 |
2105131 | 2105131 | 2022-01-11 | Lincoln | South Dakota | 46083 | 13334 | 86 |
2101880 | 2101880 | 2022-01-10 | Lincoln | South Dakota | 46083 | 12938 | 86 |
2098629 | 2098629 | 2022-01-09 | Lincoln | South Dakota | 46083 | 12832 | 84 |
2095377 | 2095377 | 2022-01-08 | Lincoln | South Dakota | 46083 | 12832 | 84 |
2092125 | 2092125 | 2022-01-07 | Lincoln | South Dakota | 46083 | 12832 | 84 |
2088873 | 2088873 | 2022-01-06 | Lincoln | South Dakota | 46083 | 12658 | 83 |
2085622 | 2085622 | 2022-01-05 | Lincoln | South Dakota | 46083 | 12472 | 81 |
2082370 | 2082370 | 2022-01-04 | Lincoln | South Dakota | 46083 | 12309 | 81 |
2079118 | 2079118 | 2022-01-03 | Lincoln | South Dakota | 46083 | 12036 | 80 |
2075867 | 2075867 | 2022-01-02 | Lincoln | South Dakota | 46083 | 11951 | 80 |
2072616 | 2072616 | 2022-01-01 | Lincoln | South Dakota | 46083 | 11951 | 80 |
2069365 | 2069365 | 2021-12-31 | Lincoln | South Dakota | 46083 | 11951 | 80 |
2066114 | 2066114 | 2021-12-30 | Lincoln | South Dakota | 46083 | 11951 | 80 |
2062864 | 2062864 | 2021-12-29 | Lincoln | South Dakota | 46083 | 11841 | 79 |
2059614 | 2059614 | 2021-12-28 | Lincoln | South Dakota | 46083 | 11745 | 79 |
2056365 | 2056365 | 2021-12-27 | Lincoln | South Dakota | 46083 | 11633 | 79 |
2053116 | 2053116 | 2021-12-26 | Lincoln | South Dakota | 46083 | 11591 | 79 |
2049866 | 2049866 | 2021-12-25 | Lincoln | South Dakota | 46083 | 11591 | 79 |
2046616 | 2046616 | 2021-12-24 | Lincoln | South Dakota | 46083 | 11591 | 79 |
2043366 | 2043366 | 2021-12-23 | Lincoln | South Dakota | 46083 | 11591 | 79 |
2040117 | 2040117 | 2021-12-22 | Lincoln | South Dakota | 46083 | 11562 | 79 |
2036867 | 2036867 | 2021-12-21 | Lincoln | South Dakota | 46083 | 11545 | 79 |
2033617 | 2033617 | 2021-12-20 | Lincoln | South Dakota | 46083 | 11487 | 79 |
2030367 | 2030367 | 2021-12-19 | Lincoln | South Dakota | 46083 | 11457 | 79 |
2027116 | 2027116 | 2021-12-18 | Lincoln | South Dakota | 46083 | 11457 | 79 |
2023865 | 2023865 | 2021-12-17 | Lincoln | South Dakota | 46083 | 11457 | 79 |
2020614 | 2020614 | 2021-12-16 | Lincoln | South Dakota | 46083 | 11439 | 79 |
2017363 | 2017363 | 2021-12-15 | Lincoln | South Dakota | 46083 | 11409 | 79 |
2014113 | 2014113 | 2021-12-14 | Lincoln | South Dakota | 46083 | 11374 | 79 |
2010862 | 2010862 | 2021-12-13 | Lincoln | South Dakota | 46083 | 11332 | 79 |
2007611 | 2007611 | 2021-12-12 | Lincoln | South Dakota | 46083 | 11312 | 79 |
2004360 | 2004360 | 2021-12-11 | Lincoln | South Dakota | 46083 | 11312 | 79 |
2001109 | 2001109 | 2021-12-10 | Lincoln | South Dakota | 46083 | 11312 | 79 |
1997859 | 1997859 | 2021-12-09 | Lincoln | South Dakota | 46083 | 11277 | 79 |
1994608 | 1994608 | 2021-12-08 | Lincoln | South Dakota | 46083 | 11260 | 79 |
1991357 | 1991357 | 2021-12-07 | Lincoln | South Dakota | 46083 | 11234 | 79 |
1988106 | 1988106 | 2021-12-06 | Lincoln | South Dakota | 46083 | 11167 | 79 |
1984856 | 1984856 | 2021-12-05 | Lincoln | South Dakota | 46083 | 11135 | 79 |
1981606 | 1981606 | 2021-12-04 | Lincoln | South Dakota | 46083 | 11135 | 79 |
1978356 | 1978356 | 2021-12-03 | Lincoln | South Dakota | 46083 | 11135 | 79 |
1975106 | 1975106 | 2021-12-02 | Lincoln | South Dakota | 46083 | 11106 | 79 |
1971857 | 1971857 | 2021-12-01 | Lincoln | South Dakota | 46083 | 11064 | 79 |
1968607 | 1968607 | 2021-11-30 | Lincoln | South Dakota | 46083 | 11019 | 79 |
1965356 | 1965356 | 2021-11-29 | Lincoln | South Dakota | 46083 | 10884 | 78 |
1962104 | 1962104 | 2021-11-28 | Lincoln | South Dakota | 46083 | 10840 | 78 |
1958853 | 1958853 | 2021-11-27 | Lincoln | South Dakota | 46083 | 10840 | 78 |
1955602 | 1955602 | 2021-11-26 | Lincoln | South Dakota | 46083 | 10840 | 78 |
1952351 | 1952351 | 2021-11-25 | Lincoln | South Dakota | 46083 | 10840 | 78 |
1949100 | 1949100 | 2021-11-24 | Lincoln | South Dakota | 46083 | 10840 | 78 |
1945849 | 1945849 | 2021-11-23 | Lincoln | South Dakota | 46083 | 10812 | 78 |
1942598 | 1942598 | 2021-11-22 | Lincoln | South Dakota | 46083 | 10753 | 78 |
1939348 | 1939348 | 2021-11-21 | Lincoln | South Dakota | 46083 | 10722 | 78 |
1936098 | 1936098 | 2021-11-20 | Lincoln | South Dakota | 46083 | 10722 | 78 |
1932848 | 1932848 | 2021-11-19 | Lincoln | South Dakota | 46083 | 10722 | 78 |
1929597 | 1929597 | 2021-11-18 | Lincoln | South Dakota | 46083 | 10696 | 78 |
1926347 | 1926347 | 2021-11-17 | Lincoln | South Dakota | 46083 | 10674 | 78 |
1923097 | 1923097 | 2021-11-16 | Lincoln | South Dakota | 46083 | 10643 | 78 |
1919848 | 1919848 | 2021-11-15 | Lincoln | South Dakota | 46083 | 10593 | 78 |
1916598 | 1916598 | 2021-11-14 | Lincoln | South Dakota | 46083 | 10542 | 78 |
1913348 | 1913348 | 2021-11-13 | Lincoln | South Dakota | 46083 | 10542 | 78 |
1910098 | 1910098 | 2021-11-12 | Lincoln | South Dakota | 46083 | 10542 | 78 |
1906849 | 1906849 | 2021-11-11 | Lincoln | South Dakota | 46083 | 10516 | 78 |
1903600 | 1903600 | 2021-11-10 | Lincoln | South Dakota | 46083 | 10516 | 78 |
1900350 | 1900350 | 2021-11-09 | Lincoln | South Dakota | 46083 | 10494 | 78 |
1897100 | 1897100 | 2021-11-08 | Lincoln | South Dakota | 46083 | 10438 | 78 |
1893850 | 1893850 | 2021-11-07 | Lincoln | South Dakota | 46083 | 10417 | 78 |
1890600 | 1890600 | 2021-11-06 | Lincoln | South Dakota | 46083 | 10417 | 78 |
1887350 | 1887350 | 2021-11-05 | Lincoln | South Dakota | 46083 | 10417 | 78 |
1884100 | 1884100 | 2021-11-04 | Lincoln | South Dakota | 46083 | 10395 | 78 |
1880851 | 1880851 | 2021-11-03 | Lincoln | South Dakota | 46083 | 10362 | 78 |
1877602 | 1877602 | 2021-11-02 | Lincoln | South Dakota | 46083 | 10345 | 78 |
1874353 | 1874353 | 2021-11-01 | Lincoln | South Dakota | 46083 | 10294 | 78 |
1871104 | 1871104 | 2021-10-31 | Lincoln | South Dakota | 46083 | 10267 | 78 |
1867855 | 1867855 | 2021-10-30 | Lincoln | South Dakota | 46083 | 10267 | 78 |
1864606 | 1864606 | 2021-10-29 | Lincoln | South Dakota | 46083 | 10267 | 78 |
1861357 | 1861357 | 2021-10-28 | Lincoln | South Dakota | 46083 | 10249 | 78 |
1858108 | 1858108 | 2021-10-27 | Lincoln | South Dakota | 46083 | 10228 | 78 |
1854859 | 1854859 | 2021-10-26 | Lincoln | South Dakota | 46083 | 10209 | 78 |
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);