ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 46049 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 |
---|---|---|---|---|---|---|---|
2176684 | 2176684 | 2022-02-02 | Faulk | South Dakota | 46049 | 523 | 16 |
2173430 | 2173430 | 2022-02-01 | Faulk | South Dakota | 46049 | 520 | 16 |
2170178 | 2170178 | 2022-01-31 | Faulk | South Dakota | 46049 | 517 | 16 |
2166924 | 2166924 | 2022-01-30 | Faulk | South Dakota | 46049 | 515 | 16 |
2163669 | 2163669 | 2022-01-29 | Faulk | South Dakota | 46049 | 515 | 16 |
2160414 | 2160414 | 2022-01-28 | Faulk | South Dakota | 46049 | 515 | 16 |
2157158 | 2157158 | 2022-01-27 | Faulk | South Dakota | 46049 | 514 | 16 |
2153905 | 2153905 | 2022-01-26 | Faulk | South Dakota | 46049 | 512 | 16 |
2150653 | 2150653 | 2022-01-25 | Faulk | South Dakota | 46049 | 505 | 16 |
2147401 | 2147401 | 2022-01-24 | Faulk | South Dakota | 46049 | 502 | 16 |
2144147 | 2144147 | 2022-01-23 | Faulk | South Dakota | 46049 | 501 | 16 |
2140892 | 2140892 | 2022-01-22 | Faulk | South Dakota | 46049 | 501 | 16 |
2137636 | 2137636 | 2022-01-21 | Faulk | South Dakota | 46049 | 501 | 16 |
2134382 | 2134382 | 2022-01-20 | Faulk | South Dakota | 46049 | 497 | 16 |
2131130 | 2131130 | 2022-01-19 | Faulk | South Dakota | 46049 | 493 | 16 |
2127876 | 2127876 | 2022-01-18 | Faulk | South Dakota | 46049 | 491 | 16 |
2124624 | 2124624 | 2022-01-17 | Faulk | South Dakota | 46049 | 490 | 16 |
2121372 | 2121372 | 2022-01-16 | Faulk | South Dakota | 46049 | 490 | 16 |
2118120 | 2118120 | 2022-01-15 | Faulk | South Dakota | 46049 | 490 | 16 |
2114869 | 2114869 | 2022-01-14 | Faulk | South Dakota | 46049 | 490 | 16 |
2111617 | 2111617 | 2022-01-13 | Faulk | South Dakota | 46049 | 486 | 16 |
2108365 | 2108365 | 2022-01-12 | Faulk | South Dakota | 46049 | 485 | 16 |
2105114 | 2105114 | 2022-01-11 | Faulk | South Dakota | 46049 | 480 | 16 |
2101863 | 2101863 | 2022-01-10 | Faulk | South Dakota | 46049 | 476 | 16 |
2098612 | 2098612 | 2022-01-09 | Faulk | South Dakota | 46049 | 473 | 16 |
2095360 | 2095360 | 2022-01-08 | Faulk | South Dakota | 46049 | 473 | 16 |
2092108 | 2092108 | 2022-01-07 | Faulk | South Dakota | 46049 | 473 | 16 |
2088856 | 2088856 | 2022-01-06 | Faulk | South Dakota | 46049 | 472 | 16 |
2085605 | 2085605 | 2022-01-05 | Faulk | South Dakota | 46049 | 472 | 16 |
2082353 | 2082353 | 2022-01-04 | Faulk | South Dakota | 46049 | 472 | 16 |
2079101 | 2079101 | 2022-01-03 | Faulk | South Dakota | 46049 | 469 | 16 |
2075850 | 2075850 | 2022-01-02 | Faulk | South Dakota | 46049 | 468 | 16 |
2072599 | 2072599 | 2022-01-01 | Faulk | South Dakota | 46049 | 468 | 16 |
2069348 | 2069348 | 2021-12-31 | Faulk | South Dakota | 46049 | 468 | 16 |
2066097 | 2066097 | 2021-12-30 | Faulk | South Dakota | 46049 | 468 | 16 |
2062847 | 2062847 | 2021-12-29 | Faulk | South Dakota | 46049 | 467 | 16 |
2059597 | 2059597 | 2021-12-28 | Faulk | South Dakota | 46049 | 467 | 16 |
2056348 | 2056348 | 2021-12-27 | Faulk | South Dakota | 46049 | 464 | 16 |
2053099 | 2053099 | 2021-12-26 | Faulk | South Dakota | 46049 | 464 | 15 |
2049849 | 2049849 | 2021-12-25 | Faulk | South Dakota | 46049 | 464 | 15 |
2046599 | 2046599 | 2021-12-24 | Faulk | South Dakota | 46049 | 464 | 15 |
2043349 | 2043349 | 2021-12-23 | Faulk | South Dakota | 46049 | 464 | 15 |
2040100 | 2040100 | 2021-12-22 | Faulk | South Dakota | 46049 | 464 | 15 |
2036850 | 2036850 | 2021-12-21 | Faulk | South Dakota | 46049 | 462 | 15 |
2033600 | 2033600 | 2021-12-20 | Faulk | South Dakota | 46049 | 461 | 15 |
2030350 | 2030350 | 2021-12-19 | Faulk | South Dakota | 46049 | 459 | 15 |
2027099 | 2027099 | 2021-12-18 | Faulk | South Dakota | 46049 | 459 | 15 |
2023848 | 2023848 | 2021-12-17 | Faulk | South Dakota | 46049 | 459 | 15 |
2020597 | 2020597 | 2021-12-16 | Faulk | South Dakota | 46049 | 458 | 15 |
2017346 | 2017346 | 2021-12-15 | Faulk | South Dakota | 46049 | 457 | 15 |
2014096 | 2014096 | 2021-12-14 | Faulk | South Dakota | 46049 | 454 | 15 |
2010845 | 2010845 | 2021-12-13 | Faulk | South Dakota | 46049 | 453 | 15 |
2007594 | 2007594 | 2021-12-12 | Faulk | South Dakota | 46049 | 450 | 15 |
2004343 | 2004343 | 2021-12-11 | Faulk | South Dakota | 46049 | 450 | 15 |
2001092 | 2001092 | 2021-12-10 | Faulk | South Dakota | 46049 | 450 | 15 |
1997842 | 1997842 | 2021-12-09 | Faulk | South Dakota | 46049 | 449 | 15 |
1994591 | 1994591 | 2021-12-08 | Faulk | South Dakota | 46049 | 448 | 15 |
1991340 | 1991340 | 2021-12-07 | Faulk | South Dakota | 46049 | 446 | 15 |
1988089 | 1988089 | 2021-12-06 | Faulk | South Dakota | 46049 | 443 | 15 |
1984839 | 1984839 | 2021-12-05 | Faulk | South Dakota | 46049 | 443 | 15 |
1981589 | 1981589 | 2021-12-04 | Faulk | South Dakota | 46049 | 443 | 15 |
1978339 | 1978339 | 2021-12-03 | Faulk | South Dakota | 46049 | 443 | 15 |
1975089 | 1975089 | 2021-12-02 | Faulk | South Dakota | 46049 | 442 | 15 |
1971840 | 1971840 | 2021-12-01 | Faulk | South Dakota | 46049 | 439 | 15 |
1968590 | 1968590 | 2021-11-30 | Faulk | South Dakota | 46049 | 438 | 15 |
1965339 | 1965339 | 2021-11-29 | Faulk | South Dakota | 46049 | 436 | 15 |
1962087 | 1962087 | 2021-11-28 | Faulk | South Dakota | 46049 | 435 | 15 |
1958836 | 1958836 | 2021-11-27 | Faulk | South Dakota | 46049 | 435 | 15 |
1955585 | 1955585 | 2021-11-26 | Faulk | South Dakota | 46049 | 435 | 15 |
1952334 | 1952334 | 2021-11-25 | Faulk | South Dakota | 46049 | 435 | 15 |
1949083 | 1949083 | 2021-11-24 | Faulk | South Dakota | 46049 | 435 | 15 |
1945832 | 1945832 | 2021-11-23 | Faulk | South Dakota | 46049 | 431 | 15 |
1942581 | 1942581 | 2021-11-22 | Faulk | South Dakota | 46049 | 429 | 15 |
1939331 | 1939331 | 2021-11-21 | Faulk | South Dakota | 46049 | 427 | 15 |
1936081 | 1936081 | 2021-11-20 | Faulk | South Dakota | 46049 | 427 | 15 |
1932831 | 1932831 | 2021-11-19 | Faulk | South Dakota | 46049 | 427 | 15 |
1929580 | 1929580 | 2021-11-18 | Faulk | South Dakota | 46049 | 427 | 15 |
1926330 | 1926330 | 2021-11-17 | Faulk | South Dakota | 46049 | 425 | 15 |
1923080 | 1923080 | 2021-11-16 | Faulk | South Dakota | 46049 | 420 | 15 |
1919831 | 1919831 | 2021-11-15 | Faulk | South Dakota | 46049 | 413 | 15 |
1916581 | 1916581 | 2021-11-14 | Faulk | South Dakota | 46049 | 412 | 15 |
1913331 | 1913331 | 2021-11-13 | Faulk | South Dakota | 46049 | 412 | 15 |
1910081 | 1910081 | 2021-11-12 | Faulk | South Dakota | 46049 | 412 | 15 |
1906832 | 1906832 | 2021-11-11 | Faulk | South Dakota | 46049 | 410 | 15 |
1903583 | 1903583 | 2021-11-10 | Faulk | South Dakota | 46049 | 410 | 15 |
1900333 | 1900333 | 2021-11-09 | Faulk | South Dakota | 46049 | 409 | 15 |
1897083 | 1897083 | 2021-11-08 | Faulk | South Dakota | 46049 | 408 | 15 |
1893833 | 1893833 | 2021-11-07 | Faulk | South Dakota | 46049 | 407 | 15 |
1890583 | 1890583 | 2021-11-06 | Faulk | South Dakota | 46049 | 407 | 15 |
1887333 | 1887333 | 2021-11-05 | Faulk | South Dakota | 46049 | 407 | 15 |
1884083 | 1884083 | 2021-11-04 | Faulk | South Dakota | 46049 | 407 | 15 |
1880834 | 1880834 | 2021-11-03 | Faulk | South Dakota | 46049 | 407 | 15 |
1877585 | 1877585 | 2021-11-02 | Faulk | South Dakota | 46049 | 407 | 15 |
1874336 | 1874336 | 2021-11-01 | Faulk | South Dakota | 46049 | 405 | 15 |
1871087 | 1871087 | 2021-10-31 | Faulk | South Dakota | 46049 | 405 | 15 |
1867838 | 1867838 | 2021-10-30 | Faulk | South Dakota | 46049 | 405 | 15 |
1864589 | 1864589 | 2021-10-29 | Faulk | South Dakota | 46049 | 405 | 15 |
1861340 | 1861340 | 2021-10-28 | Faulk | South Dakota | 46049 | 403 | 15 |
1858091 | 1858091 | 2021-10-27 | Faulk | South Dakota | 46049 | 402 | 15 |
1854842 | 1854842 | 2021-10-26 | Faulk | South Dakota | 46049 | 402 | 15 |
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);