ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 46047 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 |
---|---|---|---|---|---|---|---|
2176683 | 2176683 | 2022-02-02 | Fall River | South Dakota | 46047 | 1716 | 37 |
2173429 | 2173429 | 2022-02-01 | Fall River | South Dakota | 46047 | 1703 | 36 |
2170177 | 2170177 | 2022-01-31 | Fall River | South Dakota | 46047 | 1678 | 36 |
2166923 | 2166923 | 2022-01-30 | Fall River | South Dakota | 46047 | 1660 | 36 |
2163668 | 2163668 | 2022-01-29 | Fall River | South Dakota | 46047 | 1660 | 36 |
2160413 | 2160413 | 2022-01-28 | Fall River | South Dakota | 46047 | 1660 | 36 |
2157157 | 2157157 | 2022-01-27 | Fall River | South Dakota | 46047 | 1644 | 36 |
2153904 | 2153904 | 2022-01-26 | Fall River | South Dakota | 46047 | 1614 | 36 |
2150652 | 2150652 | 2022-01-25 | Fall River | South Dakota | 46047 | 1582 | 34 |
2147400 | 2147400 | 2022-01-24 | Fall River | South Dakota | 46047 | 1557 | 34 |
2144146 | 2144146 | 2022-01-23 | Fall River | South Dakota | 46047 | 1537 | 34 |
2140891 | 2140891 | 2022-01-22 | Fall River | South Dakota | 46047 | 1537 | 34 |
2137635 | 2137635 | 2022-01-21 | Fall River | South Dakota | 46047 | 1537 | 34 |
2134381 | 2134381 | 2022-01-20 | Fall River | South Dakota | 46047 | 1516 | 34 |
2131129 | 2131129 | 2022-01-19 | Fall River | South Dakota | 46047 | 1484 | 34 |
2127875 | 2127875 | 2022-01-18 | Fall River | South Dakota | 46047 | 1439 | 33 |
2124623 | 2124623 | 2022-01-17 | Fall River | South Dakota | 46047 | 1420 | 33 |
2121371 | 2121371 | 2022-01-16 | Fall River | South Dakota | 46047 | 1420 | 33 |
2118119 | 2118119 | 2022-01-15 | Fall River | South Dakota | 46047 | 1420 | 33 |
2114868 | 2114868 | 2022-01-14 | Fall River | South Dakota | 46047 | 1420 | 33 |
2111616 | 2111616 | 2022-01-13 | Fall River | South Dakota | 46047 | 1405 | 31 |
2108364 | 2108364 | 2022-01-12 | Fall River | South Dakota | 46047 | 1396 | 31 |
2105113 | 2105113 | 2022-01-11 | Fall River | South Dakota | 46047 | 1373 | 31 |
2101862 | 2101862 | 2022-01-10 | Fall River | South Dakota | 46047 | 1349 | 31 |
2098611 | 2098611 | 2022-01-09 | Fall River | South Dakota | 46047 | 1338 | 31 |
2095359 | 2095359 | 2022-01-08 | Fall River | South Dakota | 46047 | 1338 | 31 |
2092107 | 2092107 | 2022-01-07 | Fall River | South Dakota | 46047 | 1338 | 31 |
2088855 | 2088855 | 2022-01-06 | Fall River | South Dakota | 46047 | 1328 | 31 |
2085604 | 2085604 | 2022-01-05 | Fall River | South Dakota | 46047 | 1317 | 31 |
2082352 | 2082352 | 2022-01-04 | Fall River | South Dakota | 46047 | 1308 | 31 |
2079100 | 2079100 | 2022-01-03 | Fall River | South Dakota | 46047 | 1293 | 30 |
2075849 | 2075849 | 2022-01-02 | Fall River | South Dakota | 46047 | 1289 | 30 |
2072598 | 2072598 | 2022-01-01 | Fall River | South Dakota | 46047 | 1289 | 30 |
2069347 | 2069347 | 2021-12-31 | Fall River | South Dakota | 46047 | 1289 | 30 |
2066096 | 2066096 | 2021-12-30 | Fall River | South Dakota | 46047 | 1289 | 30 |
2062846 | 2062846 | 2021-12-29 | Fall River | South Dakota | 46047 | 1282 | 29 |
2059596 | 2059596 | 2021-12-28 | Fall River | South Dakota | 46047 | 1273 | 29 |
2056347 | 2056347 | 2021-12-27 | Fall River | South Dakota | 46047 | 1260 | 29 |
2053098 | 2053098 | 2021-12-26 | Fall River | South Dakota | 46047 | 1257 | 29 |
2049848 | 2049848 | 2021-12-25 | Fall River | South Dakota | 46047 | 1257 | 29 |
2046598 | 2046598 | 2021-12-24 | Fall River | South Dakota | 46047 | 1257 | 29 |
2043348 | 2043348 | 2021-12-23 | Fall River | South Dakota | 46047 | 1257 | 29 |
2040099 | 2040099 | 2021-12-22 | Fall River | South Dakota | 46047 | 1254 | 29 |
2036849 | 2036849 | 2021-12-21 | Fall River | South Dakota | 46047 | 1250 | 29 |
2033599 | 2033599 | 2021-12-20 | Fall River | South Dakota | 46047 | 1243 | 28 |
2030349 | 2030349 | 2021-12-19 | Fall River | South Dakota | 46047 | 1239 | 28 |
2027098 | 2027098 | 2021-12-18 | Fall River | South Dakota | 46047 | 1239 | 28 |
2023847 | 2023847 | 2021-12-17 | Fall River | South Dakota | 46047 | 1239 | 28 |
2020596 | 2020596 | 2021-12-16 | Fall River | South Dakota | 46047 | 1234 | 27 |
2017345 | 2017345 | 2021-12-15 | Fall River | South Dakota | 46047 | 1231 | 25 |
2014095 | 2014095 | 2021-12-14 | Fall River | South Dakota | 46047 | 1229 | 24 |
2010844 | 2010844 | 2021-12-13 | Fall River | South Dakota | 46047 | 1221 | 24 |
2007593 | 2007593 | 2021-12-12 | Fall River | South Dakota | 46047 | 1217 | 24 |
2004342 | 2004342 | 2021-12-11 | Fall River | South Dakota | 46047 | 1217 | 24 |
2001091 | 2001091 | 2021-12-10 | Fall River | South Dakota | 46047 | 1217 | 24 |
1997841 | 1997841 | 2021-12-09 | Fall River | South Dakota | 46047 | 1209 | 24 |
1994590 | 1994590 | 2021-12-08 | Fall River | South Dakota | 46047 | 1202 | 24 |
1991339 | 1991339 | 2021-12-07 | Fall River | South Dakota | 46047 | 1196 | 24 |
1988088 | 1988088 | 2021-12-06 | Fall River | South Dakota | 46047 | 1184 | 24 |
1984838 | 1984838 | 2021-12-05 | Fall River | South Dakota | 46047 | 1178 | 24 |
1981588 | 1981588 | 2021-12-04 | Fall River | South Dakota | 46047 | 1178 | 24 |
1978338 | 1978338 | 2021-12-03 | Fall River | South Dakota | 46047 | 1178 | 24 |
1975088 | 1975088 | 2021-12-02 | Fall River | South Dakota | 46047 | 1171 | 24 |
1971839 | 1971839 | 2021-12-01 | Fall River | South Dakota | 46047 | 1167 | 24 |
1968589 | 1968589 | 2021-11-30 | Fall River | South Dakota | 46047 | 1166 | 24 |
1965338 | 1965338 | 2021-11-29 | Fall River | South Dakota | 46047 | 1152 | 24 |
1962086 | 1962086 | 2021-11-28 | Fall River | South Dakota | 46047 | 1142 | 24 |
1958835 | 1958835 | 2021-11-27 | Fall River | South Dakota | 46047 | 1142 | 24 |
1955584 | 1955584 | 2021-11-26 | Fall River | South Dakota | 46047 | 1142 | 24 |
1952333 | 1952333 | 2021-11-25 | Fall River | South Dakota | 46047 | 1142 | 24 |
1949082 | 1949082 | 2021-11-24 | Fall River | South Dakota | 46047 | 1142 | 24 |
1945831 | 1945831 | 2021-11-23 | Fall River | South Dakota | 46047 | 1135 | 24 |
1942580 | 1942580 | 2021-11-22 | Fall River | South Dakota | 46047 | 1119 | 24 |
1939330 | 1939330 | 2021-11-21 | Fall River | South Dakota | 46047 | 1113 | 24 |
1936080 | 1936080 | 2021-11-20 | Fall River | South Dakota | 46047 | 1113 | 24 |
1932830 | 1932830 | 2021-11-19 | Fall River | South Dakota | 46047 | 1113 | 24 |
1929579 | 1929579 | 2021-11-18 | Fall River | South Dakota | 46047 | 1107 | 24 |
1926329 | 1926329 | 2021-11-17 | Fall River | South Dakota | 46047 | 1104 | 24 |
1923079 | 1923079 | 2021-11-16 | Fall River | South Dakota | 46047 | 1099 | 23 |
1919830 | 1919830 | 2021-11-15 | Fall River | South Dakota | 46047 | 1081 | 23 |
1916580 | 1916580 | 2021-11-14 | Fall River | South Dakota | 46047 | 1067 | 23 |
1913330 | 1913330 | 2021-11-13 | Fall River | South Dakota | 46047 | 1067 | 23 |
1910080 | 1910080 | 2021-11-12 | Fall River | South Dakota | 46047 | 1067 | 23 |
1906831 | 1906831 | 2021-11-11 | Fall River | South Dakota | 46047 | 1059 | 23 |
1903582 | 1903582 | 2021-11-10 | Fall River | South Dakota | 46047 | 1059 | 23 |
1900332 | 1900332 | 2021-11-09 | Fall River | South Dakota | 46047 | 1047 | 23 |
1897082 | 1897082 | 2021-11-08 | Fall River | South Dakota | 46047 | 1033 | 23 |
1893832 | 1893832 | 2021-11-07 | Fall River | South Dakota | 46047 | 1025 | 23 |
1890582 | 1890582 | 2021-11-06 | Fall River | South Dakota | 46047 | 1025 | 23 |
1887332 | 1887332 | 2021-11-05 | Fall River | South Dakota | 46047 | 1025 | 23 |
1884082 | 1884082 | 2021-11-04 | Fall River | South Dakota | 46047 | 1014 | 23 |
1880833 | 1880833 | 2021-11-03 | Fall River | South Dakota | 46047 | 1006 | 23 |
1877584 | 1877584 | 2021-11-02 | Fall River | South Dakota | 46047 | 999 | 23 |
1874335 | 1874335 | 2021-11-01 | Fall River | South Dakota | 46047 | 995 | 23 |
1871086 | 1871086 | 2021-10-31 | Fall River | South Dakota | 46047 | 990 | 23 |
1867837 | 1867837 | 2021-10-30 | Fall River | South Dakota | 46047 | 990 | 23 |
1864588 | 1864588 | 2021-10-29 | Fall River | South Dakota | 46047 | 990 | 23 |
1861339 | 1861339 | 2021-10-28 | Fall River | South Dakota | 46047 | 985 | 23 |
1858090 | 1858090 | 2021-10-27 | Fall River | South Dakota | 46047 | 979 | 23 |
1854841 | 1854841 | 2021-10-26 | Fall River | South Dakota | 46047 | 972 | 23 |
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);