ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Minnehaha" 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 |
---|---|---|---|---|---|---|---|
2176709 | 2176709 | 2022-02-02 | Minnehaha | South Dakota | 46099 | 55875 | 469 |
2173455 | 2173455 | 2022-02-01 | Minnehaha | South Dakota | 46099 | 55765 | 469 |
2170203 | 2170203 | 2022-01-31 | Minnehaha | South Dakota | 46099 | 55553 | 466 |
2166949 | 2166949 | 2022-01-30 | Minnehaha | South Dakota | 46099 | 55414 | 466 |
2163694 | 2163694 | 2022-01-29 | Minnehaha | South Dakota | 46099 | 55414 | 466 |
2160439 | 2160439 | 2022-01-28 | Minnehaha | South Dakota | 46099 | 55414 | 466 |
2157183 | 2157183 | 2022-01-27 | Minnehaha | South Dakota | 46099 | 55222 | 463 |
2153930 | 2153930 | 2022-01-26 | Minnehaha | South Dakota | 46099 | 55008 | 463 |
2150678 | 2150678 | 2022-01-25 | Minnehaha | South Dakota | 46099 | 54787 | 458 |
2147426 | 2147426 | 2022-01-24 | Minnehaha | South Dakota | 46099 | 54280 | 456 |
2144172 | 2144172 | 2022-01-23 | Minnehaha | South Dakota | 46099 | 53957 | 455 |
2140917 | 2140917 | 2022-01-22 | Minnehaha | South Dakota | 46099 | 53957 | 455 |
2137661 | 2137661 | 2022-01-21 | Minnehaha | South Dakota | 46099 | 53957 | 455 |
2134407 | 2134407 | 2022-01-20 | Minnehaha | South Dakota | 46099 | 53583 | 452 |
2131155 | 2131155 | 2022-01-19 | Minnehaha | South Dakota | 46099 | 53138 | 452 |
2127901 | 2127901 | 2022-01-18 | Minnehaha | South Dakota | 46099 | 51418 | 449 |
2124649 | 2124649 | 2022-01-17 | Minnehaha | South Dakota | 46099 | 50884 | 448 |
2121397 | 2121397 | 2022-01-16 | Minnehaha | South Dakota | 46099 | 50884 | 448 |
2118145 | 2118145 | 2022-01-15 | Minnehaha | South Dakota | 46099 | 50884 | 448 |
2114894 | 2114894 | 2022-01-14 | Minnehaha | South Dakota | 46099 | 50884 | 448 |
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 |
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);