ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46099 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 |
---|---|---|---|---|---|---|---|
2111642 | 2111642 | 2022-01-13 | Minnehaha | South Dakota | 46099 | 50197 | 446 |
2108390 | 2108390 | 2022-01-12 | Minnehaha | South Dakota | 46099 | 49460 | 444 |
2105139 | 2105139 | 2022-01-11 | Minnehaha | South Dakota | 46099 | 48711 | 443 |
2101888 | 2101888 | 2022-01-10 | Minnehaha | South Dakota | 46099 | 47351 | 443 |
2098637 | 2098637 | 2022-01-09 | Minnehaha | South Dakota | 46099 | 46911 | 443 |
2095385 | 2095385 | 2022-01-08 | Minnehaha | South Dakota | 46099 | 46911 | 443 |
2092133 | 2092133 | 2022-01-07 | Minnehaha | South Dakota | 46099 | 46911 | 443 |
2088881 | 2088881 | 2022-01-06 | Minnehaha | South Dakota | 46099 | 46266 | 443 |
2085630 | 2085630 | 2022-01-05 | Minnehaha | South Dakota | 46099 | 45550 | 439 |
2082378 | 2082378 | 2022-01-04 | Minnehaha | South Dakota | 46099 | 44888 | 435 |
2079126 | 2079126 | 2022-01-03 | Minnehaha | South Dakota | 46099 | 43872 | 435 |
2075875 | 2075875 | 2022-01-02 | Minnehaha | South Dakota | 46099 | 43580 | 433 |
2072624 | 2072624 | 2022-01-01 | Minnehaha | South Dakota | 46099 | 43580 | 433 |
2069373 | 2069373 | 2021-12-31 | Minnehaha | South Dakota | 46099 | 43580 | 433 |
2066122 | 2066122 | 2021-12-30 | Minnehaha | South Dakota | 46099 | 43580 | 433 |
2062872 | 2062872 | 2021-12-29 | Minnehaha | South Dakota | 46099 | 43260 | 429 |
2059622 | 2059622 | 2021-12-28 | Minnehaha | South Dakota | 46099 | 42949 | 428 |
2056373 | 2056373 | 2021-12-27 | Minnehaha | South Dakota | 46099 | 42556 | 428 |
2053124 | 2053124 | 2021-12-26 | Minnehaha | South Dakota | 46099 | 42384 | 423 |
2049874 | 2049874 | 2021-12-25 | Minnehaha | South Dakota | 46099 | 42384 | 423 |
2046624 | 2046624 | 2021-12-24 | Minnehaha | South Dakota | 46099 | 42384 | 423 |
2043374 | 2043374 | 2021-12-23 | Minnehaha | South Dakota | 46099 | 42384 | 423 |
2040125 | 2040125 | 2021-12-22 | Minnehaha | South Dakota | 46099 | 42271 | 423 |
2036875 | 2036875 | 2021-12-21 | Minnehaha | South Dakota | 46099 | 42152 | 423 |
2033625 | 2033625 | 2021-12-20 | Minnehaha | South Dakota | 46099 | 41968 | 422 |
2030375 | 2030375 | 2021-12-19 | Minnehaha | South Dakota | 46099 | 41869 | 422 |
2027124 | 2027124 | 2021-12-18 | Minnehaha | South Dakota | 46099 | 41869 | 422 |
2023873 | 2023873 | 2021-12-17 | Minnehaha | South Dakota | 46099 | 41869 | 422 |
2020622 | 2020622 | 2021-12-16 | Minnehaha | South Dakota | 46099 | 41773 | 422 |
2017371 | 2017371 | 2021-12-15 | Minnehaha | South Dakota | 46099 | 41671 | 421 |
2014121 | 2014121 | 2021-12-14 | Minnehaha | South Dakota | 46099 | 41562 | 419 |
2010870 | 2010870 | 2021-12-13 | Minnehaha | South Dakota | 46099 | 41412 | 419 |
2007619 | 2007619 | 2021-12-12 | Minnehaha | South Dakota | 46099 | 41327 | 417 |
2004368 | 2004368 | 2021-12-11 | Minnehaha | South Dakota | 46099 | 41327 | 417 |
2001117 | 2001117 | 2021-12-10 | Minnehaha | South Dakota | 46099 | 41327 | 417 |
1997867 | 1997867 | 2021-12-09 | Minnehaha | South Dakota | 46099 | 41208 | 416 |
1994616 | 1994616 | 2021-12-08 | Minnehaha | South Dakota | 46099 | 41122 | 415 |
1991365 | 1991365 | 2021-12-07 | Minnehaha | South Dakota | 46099 | 40988 | 415 |
1988114 | 1988114 | 2021-12-06 | Minnehaha | South Dakota | 46099 | 40701 | 415 |
1984864 | 1984864 | 2021-12-05 | Minnehaha | South Dakota | 46099 | 40574 | 409 |
1981614 | 1981614 | 2021-12-04 | Minnehaha | South Dakota | 46099 | 40574 | 409 |
1978364 | 1978364 | 2021-12-03 | Minnehaha | South Dakota | 46099 | 40574 | 409 |
1975114 | 1975114 | 2021-12-02 | Minnehaha | South Dakota | 46099 | 40461 | 409 |
1971865 | 1971865 | 2021-12-01 | Minnehaha | South Dakota | 46099 | 40302 | 409 |
1968615 | 1968615 | 2021-11-30 | Minnehaha | South Dakota | 46099 | 40140 | 405 |
1965364 | 1965364 | 2021-11-29 | Minnehaha | South Dakota | 46099 | 39703 | 405 |
1962112 | 1962112 | 2021-11-28 | Minnehaha | South Dakota | 46099 | 39537 | 404 |
1958861 | 1958861 | 2021-11-27 | Minnehaha | South Dakota | 46099 | 39537 | 404 |
1955610 | 1955610 | 2021-11-26 | Minnehaha | South Dakota | 46099 | 39537 | 404 |
1952359 | 1952359 | 2021-11-25 | Minnehaha | South Dakota | 46099 | 39537 | 404 |
1949108 | 1949108 | 2021-11-24 | Minnehaha | South Dakota | 46099 | 39537 | 404 |
1945857 | 1945857 | 2021-11-23 | Minnehaha | South Dakota | 46099 | 39429 | 403 |
1942606 | 1942606 | 2021-11-22 | Minnehaha | South Dakota | 46099 | 39233 | 400 |
1939356 | 1939356 | 2021-11-21 | Minnehaha | South Dakota | 46099 | 39147 | 399 |
1936106 | 1936106 | 2021-11-20 | Minnehaha | South Dakota | 46099 | 39147 | 399 |
1932856 | 1932856 | 2021-11-19 | Minnehaha | South Dakota | 46099 | 39147 | 399 |
1929605 | 1929605 | 2021-11-18 | Minnehaha | South Dakota | 46099 | 39076 | 398 |
1926355 | 1926355 | 2021-11-17 | Minnehaha | South Dakota | 46099 | 38986 | 398 |
1923105 | 1923105 | 2021-11-16 | Minnehaha | South Dakota | 46099 | 38871 | 398 |
1919856 | 1919856 | 2021-11-15 | Minnehaha | South Dakota | 46099 | 38647 | 397 |
1916606 | 1916606 | 2021-11-14 | Minnehaha | South Dakota | 46099 | 38485 | 397 |
1913356 | 1913356 | 2021-11-13 | Minnehaha | South Dakota | 46099 | 38485 | 397 |
1910106 | 1910106 | 2021-11-12 | Minnehaha | South Dakota | 46099 | 38485 | 397 |
1906857 | 1906857 | 2021-11-11 | Minnehaha | South Dakota | 46099 | 38370 | 396 |
1903608 | 1903608 | 2021-11-10 | Minnehaha | South Dakota | 46099 | 38370 | 396 |
1900358 | 1900358 | 2021-11-09 | Minnehaha | South Dakota | 46099 | 38257 | 396 |
1897108 | 1897108 | 2021-11-08 | Minnehaha | South Dakota | 46099 | 38060 | 395 |
1893858 | 1893858 | 2021-11-07 | Minnehaha | South Dakota | 46099 | 37984 | 395 |
1890608 | 1890608 | 2021-11-06 | Minnehaha | South Dakota | 46099 | 37984 | 395 |
1887358 | 1887358 | 2021-11-05 | Minnehaha | South Dakota | 46099 | 37984 | 395 |
1884108 | 1884108 | 2021-11-04 | Minnehaha | South Dakota | 46099 | 37887 | 394 |
1880859 | 1880859 | 2021-11-03 | Minnehaha | South Dakota | 46099 | 37818 | 394 |
1877610 | 1877610 | 2021-11-02 | Minnehaha | South Dakota | 46099 | 37722 | 394 |
1874361 | 1874361 | 2021-11-01 | Minnehaha | South Dakota | 46099 | 37591 | 393 |
1871112 | 1871112 | 2021-10-31 | Minnehaha | South Dakota | 46099 | 37519 | 393 |
1867863 | 1867863 | 2021-10-30 | Minnehaha | South Dakota | 46099 | 37519 | 393 |
1864614 | 1864614 | 2021-10-29 | Minnehaha | South Dakota | 46099 | 37519 | 393 |
1861365 | 1861365 | 2021-10-28 | Minnehaha | South Dakota | 46099 | 37444 | 393 |
1858116 | 1858116 | 2021-10-27 | Minnehaha | South Dakota | 46099 | 37396 | 393 |
1854867 | 1854867 | 2021-10-26 | Minnehaha | South Dakota | 46099 | 37321 | 393 |
1851618 | 1851618 | 2021-10-25 | Minnehaha | South Dakota | 46099 | 37184 | 391 |
1848368 | 1848368 | 2021-10-24 | Minnehaha | South Dakota | 46099 | 37133 | 391 |
1845118 | 1845118 | 2021-10-23 | Minnehaha | South Dakota | 46099 | 37133 | 391 |
1841868 | 1841868 | 2021-10-22 | Minnehaha | South Dakota | 46099 | 37133 | 391 |
1838619 | 1838619 | 2021-10-21 | Minnehaha | South Dakota | 46099 | 37078 | 390 |
1835370 | 1835370 | 2021-10-20 | Minnehaha | South Dakota | 46099 | 37008 | 389 |
1832121 | 1832121 | 2021-10-19 | Minnehaha | South Dakota | 46099 | 36932 | 389 |
1828872 | 1828872 | 2021-10-18 | Minnehaha | South Dakota | 46099 | 36808 | 389 |
1825623 | 1825623 | 2021-10-17 | Minnehaha | South Dakota | 46099 | 36752 | 385 |
1822374 | 1822374 | 2021-10-16 | Minnehaha | South Dakota | 46099 | 36752 | 385 |
1819125 | 1819125 | 2021-10-15 | Minnehaha | South Dakota | 46099 | 36752 | 385 |
1815876 | 1815876 | 2021-10-14 | Minnehaha | South Dakota | 46099 | 36679 | 383 |
1812628 | 1812628 | 2021-10-13 | Minnehaha | South Dakota | 46099 | 36617 | 383 |
1809379 | 1809379 | 2021-10-12 | Minnehaha | South Dakota | 46099 | 36393 | 383 |
1806129 | 1806129 | 2021-10-11 | Minnehaha | South Dakota | 46099 | 36313 | 383 |
1802879 | 1802879 | 2021-10-10 | Minnehaha | South Dakota | 46099 | 36313 | 383 |
1799630 | 1799630 | 2021-10-09 | Minnehaha | South Dakota | 46099 | 36313 | 383 |
1796381 | 1796381 | 2021-10-08 | Minnehaha | South Dakota | 46099 | 36313 | 383 |
1793132 | 1793132 | 2021-10-07 | Minnehaha | South Dakota | 46099 | 36215 | 383 |
1789883 | 1789883 | 2021-10-06 | Minnehaha | South Dakota | 46099 | 36128 | 382 |
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);