ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Turner" 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 |
---|---|---|---|---|---|---|---|
2176722 | 2176722 | 2022-02-02 | Turner | South Dakota | 46125 | 1923 | 62 |
2173468 | 2173468 | 2022-02-01 | Turner | South Dakota | 46125 | 1917 | 62 |
2170216 | 2170216 | 2022-01-31 | Turner | South Dakota | 46125 | 1906 | 62 |
2166962 | 2166962 | 2022-01-30 | Turner | South Dakota | 46125 | 1901 | 62 |
2163707 | 2163707 | 2022-01-29 | Turner | South Dakota | 46125 | 1901 | 62 |
2160452 | 2160452 | 2022-01-28 | Turner | South Dakota | 46125 | 1901 | 62 |
2157196 | 2157196 | 2022-01-27 | Turner | South Dakota | 46125 | 1894 | 62 |
2153943 | 2153943 | 2022-01-26 | Turner | South Dakota | 46125 | 1887 | 62 |
2150691 | 2150691 | 2022-01-25 | Turner | South Dakota | 46125 | 1878 | 62 |
2147439 | 2147439 | 2022-01-24 | Turner | South Dakota | 46125 | 1860 | 62 |
2144185 | 2144185 | 2022-01-23 | Turner | South Dakota | 46125 | 1849 | 62 |
2140930 | 2140930 | 2022-01-22 | Turner | South Dakota | 46125 | 1849 | 62 |
2137674 | 2137674 | 2022-01-21 | Turner | South Dakota | 46125 | 1849 | 62 |
2134420 | 2134420 | 2022-01-20 | Turner | South Dakota | 46125 | 1839 | 62 |
2131168 | 2131168 | 2022-01-19 | Turner | South Dakota | 46125 | 1825 | 62 |
2127914 | 2127914 | 2022-01-18 | Turner | South Dakota | 46125 | 1759 | 62 |
2124662 | 2124662 | 2022-01-17 | Turner | South Dakota | 46125 | 1737 | 62 |
2121410 | 2121410 | 2022-01-16 | Turner | South Dakota | 46125 | 1737 | 62 |
2118158 | 2118158 | 2022-01-15 | Turner | South Dakota | 46125 | 1737 | 62 |
2114907 | 2114907 | 2022-01-14 | Turner | South Dakota | 46125 | 1737 | 62 |
2111655 | 2111655 | 2022-01-13 | Turner | South Dakota | 46125 | 1715 | 62 |
2108403 | 2108403 | 2022-01-12 | Turner | South Dakota | 46125 | 1696 | 62 |
2105152 | 2105152 | 2022-01-11 | Turner | South Dakota | 46125 | 1674 | 62 |
2101901 | 2101901 | 2022-01-10 | Turner | South Dakota | 46125 | 1647 | 62 |
2098650 | 2098650 | 2022-01-09 | Turner | South Dakota | 46125 | 1633 | 62 |
2095398 | 2095398 | 2022-01-08 | Turner | South Dakota | 46125 | 1633 | 62 |
2092146 | 2092146 | 2022-01-07 | Turner | South Dakota | 46125 | 1633 | 62 |
2088894 | 2088894 | 2022-01-06 | Turner | South Dakota | 46125 | 1621 | 62 |
2085643 | 2085643 | 2022-01-05 | Turner | South Dakota | 46125 | 1612 | 62 |
2082391 | 2082391 | 2022-01-04 | Turner | South Dakota | 46125 | 1589 | 62 |
2079139 | 2079139 | 2022-01-03 | Turner | South Dakota | 46125 | 1548 | 62 |
2075888 | 2075888 | 2022-01-02 | Turner | South Dakota | 46125 | 1542 | 62 |
2072637 | 2072637 | 2022-01-01 | Turner | South Dakota | 46125 | 1542 | 62 |
2069386 | 2069386 | 2021-12-31 | Turner | South Dakota | 46125 | 1542 | 62 |
2066135 | 2066135 | 2021-12-30 | Turner | South Dakota | 46125 | 1542 | 62 |
2062885 | 2062885 | 2021-12-29 | Turner | South Dakota | 46125 | 1536 | 62 |
2059635 | 2059635 | 2021-12-28 | Turner | South Dakota | 46125 | 1529 | 62 |
2056386 | 2056386 | 2021-12-27 | Turner | South Dakota | 46125 | 1519 | 62 |
2053137 | 2053137 | 2021-12-26 | Turner | South Dakota | 46125 | 1514 | 62 |
2049887 | 2049887 | 2021-12-25 | Turner | South Dakota | 46125 | 1514 | 62 |
2046637 | 2046637 | 2021-12-24 | Turner | South Dakota | 46125 | 1514 | 62 |
2043387 | 2043387 | 2021-12-23 | Turner | South Dakota | 46125 | 1514 | 62 |
2040138 | 2040138 | 2021-12-22 | Turner | South Dakota | 46125 | 1509 | 62 |
2036888 | 2036888 | 2021-12-21 | Turner | South Dakota | 46125 | 1505 | 62 |
2033638 | 2033638 | 2021-12-20 | Turner | South Dakota | 46125 | 1501 | 62 |
2030388 | 2030388 | 2021-12-19 | Turner | South Dakota | 46125 | 1496 | 62 |
2027137 | 2027137 | 2021-12-18 | Turner | South Dakota | 46125 | 1496 | 62 |
2023886 | 2023886 | 2021-12-17 | Turner | South Dakota | 46125 | 1496 | 62 |
2020635 | 2020635 | 2021-12-16 | Turner | South Dakota | 46125 | 1496 | 62 |
2017384 | 2017384 | 2021-12-15 | Turner | South Dakota | 46125 | 1488 | 62 |
2014134 | 2014134 | 2021-12-14 | Turner | South Dakota | 46125 | 1481 | 62 |
2010883 | 2010883 | 2021-12-13 | Turner | South Dakota | 46125 | 1472 | 62 |
2007632 | 2007632 | 2021-12-12 | Turner | South Dakota | 46125 | 1471 | 62 |
2004381 | 2004381 | 2021-12-11 | Turner | South Dakota | 46125 | 1471 | 62 |
2001130 | 2001130 | 2021-12-10 | Turner | South Dakota | 46125 | 1471 | 62 |
1997880 | 1997880 | 2021-12-09 | Turner | South Dakota | 46125 | 1469 | 61 |
1994629 | 1994629 | 2021-12-08 | Turner | South Dakota | 46125 | 1468 | 61 |
1991378 | 1991378 | 2021-12-07 | Turner | South Dakota | 46125 | 1464 | 61 |
1988127 | 1988127 | 2021-12-06 | Turner | South Dakota | 46125 | 1449 | 61 |
1984877 | 1984877 | 2021-12-05 | Turner | South Dakota | 46125 | 1444 | 61 |
1981627 | 1981627 | 2021-12-04 | Turner | South Dakota | 46125 | 1444 | 61 |
1978377 | 1978377 | 2021-12-03 | Turner | South Dakota | 46125 | 1444 | 61 |
1975127 | 1975127 | 2021-12-02 | Turner | South Dakota | 46125 | 1437 | 61 |
1971878 | 1971878 | 2021-12-01 | Turner | South Dakota | 46125 | 1431 | 61 |
1968628 | 1968628 | 2021-11-30 | Turner | South Dakota | 46125 | 1422 | 61 |
1965377 | 1965377 | 2021-11-29 | Turner | South Dakota | 46125 | 1417 | 61 |
1962125 | 1962125 | 2021-11-28 | Turner | South Dakota | 46125 | 1411 | 61 |
1958874 | 1958874 | 2021-11-27 | Turner | South Dakota | 46125 | 1411 | 61 |
1955623 | 1955623 | 2021-11-26 | Turner | South Dakota | 46125 | 1411 | 61 |
1952372 | 1952372 | 2021-11-25 | Turner | South Dakota | 46125 | 1411 | 61 |
1949121 | 1949121 | 2021-11-24 | Turner | South Dakota | 46125 | 1411 | 61 |
1945870 | 1945870 | 2021-11-23 | Turner | South Dakota | 46125 | 1406 | 61 |
1942619 | 1942619 | 2021-11-22 | Turner | South Dakota | 46125 | 1398 | 61 |
1939369 | 1939369 | 2021-11-21 | Turner | South Dakota | 46125 | 1391 | 61 |
1936119 | 1936119 | 2021-11-20 | Turner | South Dakota | 46125 | 1391 | 61 |
1932869 | 1932869 | 2021-11-19 | Turner | South Dakota | 46125 | 1391 | 61 |
1929618 | 1929618 | 2021-11-18 | Turner | South Dakota | 46125 | 1391 | 61 |
1926368 | 1926368 | 2021-11-17 | Turner | South Dakota | 46125 | 1390 | 61 |
1923118 | 1923118 | 2021-11-16 | Turner | South Dakota | 46125 | 1385 | 61 |
1919869 | 1919869 | 2021-11-15 | Turner | South Dakota | 46125 | 1377 | 61 |
1916619 | 1916619 | 2021-11-14 | Turner | South Dakota | 46125 | 1369 | 61 |
1913369 | 1913369 | 2021-11-13 | Turner | South Dakota | 46125 | 1369 | 61 |
1910119 | 1910119 | 2021-11-12 | Turner | South Dakota | 46125 | 1369 | 61 |
1906870 | 1906870 | 2021-11-11 | Turner | South Dakota | 46125 | 1368 | 61 |
1903621 | 1903621 | 2021-11-10 | Turner | South Dakota | 46125 | 1368 | 61 |
1900371 | 1900371 | 2021-11-09 | Turner | South Dakota | 46125 | 1366 | 61 |
1897121 | 1897121 | 2021-11-08 | Turner | South Dakota | 46125 | 1360 | 61 |
1893871 | 1893871 | 2021-11-07 | Turner | South Dakota | 46125 | 1354 | 61 |
1890621 | 1890621 | 2021-11-06 | Turner | South Dakota | 46125 | 1354 | 61 |
1887371 | 1887371 | 2021-11-05 | Turner | South Dakota | 46125 | 1354 | 61 |
1884121 | 1884121 | 2021-11-04 | Turner | South Dakota | 46125 | 1350 | 61 |
1880872 | 1880872 | 2021-11-03 | Turner | South Dakota | 46125 | 1347 | 61 |
1877623 | 1877623 | 2021-11-02 | Turner | South Dakota | 46125 | 1339 | 61 |
1874374 | 1874374 | 2021-11-01 | Turner | South Dakota | 46125 | 1338 | 61 |
1871125 | 1871125 | 2021-10-31 | Turner | South Dakota | 46125 | 1335 | 61 |
1867876 | 1867876 | 2021-10-30 | Turner | South Dakota | 46125 | 1335 | 61 |
1864627 | 1864627 | 2021-10-29 | Turner | South Dakota | 46125 | 1335 | 61 |
1861378 | 1861378 | 2021-10-28 | Turner | South Dakota | 46125 | 1332 | 61 |
1858129 | 1858129 | 2021-10-27 | Turner | South Dakota | 46125 | 1331 | 61 |
1854880 | 1854880 | 2021-10-26 | Turner | South Dakota | 46125 | 1327 | 61 |
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);