ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46005 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 |
---|---|---|---|---|---|---|---|
2176662 | 2176662 | 2022-02-02 | Beadle | South Dakota | 46005 | 4466 | 52 |
2173408 | 2173408 | 2022-02-01 | Beadle | South Dakota | 46005 | 4455 | 51 |
2170156 | 2170156 | 2022-01-31 | Beadle | South Dakota | 46005 | 4415 | 51 |
2166902 | 2166902 | 2022-01-30 | Beadle | South Dakota | 46005 | 4384 | 51 |
2163647 | 2163647 | 2022-01-29 | Beadle | South Dakota | 46005 | 4384 | 51 |
2160392 | 2160392 | 2022-01-28 | Beadle | South Dakota | 46005 | 4384 | 51 |
2157136 | 2157136 | 2022-01-27 | Beadle | South Dakota | 46005 | 4358 | 51 |
2153883 | 2153883 | 2022-01-26 | Beadle | South Dakota | 46005 | 4334 | 51 |
2150631 | 2150631 | 2022-01-25 | Beadle | South Dakota | 46005 | 4303 | 51 |
2147379 | 2147379 | 2022-01-24 | Beadle | South Dakota | 46005 | 4244 | 51 |
2144125 | 2144125 | 2022-01-23 | Beadle | South Dakota | 46005 | 4221 | 51 |
2140870 | 2140870 | 2022-01-22 | Beadle | South Dakota | 46005 | 4221 | 51 |
2137614 | 2137614 | 2022-01-21 | Beadle | South Dakota | 46005 | 4221 | 51 |
2134360 | 2134360 | 2022-01-20 | Beadle | South Dakota | 46005 | 4199 | 50 |
2131108 | 2131108 | 2022-01-19 | Beadle | South Dakota | 46005 | 4174 | 50 |
2127854 | 2127854 | 2022-01-18 | Beadle | South Dakota | 46005 | 4100 | 50 |
2124602 | 2124602 | 2022-01-17 | Beadle | South Dakota | 46005 | 4069 | 50 |
2121350 | 2121350 | 2022-01-16 | Beadle | South Dakota | 46005 | 4069 | 50 |
2118098 | 2118098 | 2022-01-15 | Beadle | South Dakota | 46005 | 4069 | 50 |
2114847 | 2114847 | 2022-01-14 | Beadle | South Dakota | 46005 | 4069 | 50 |
2111595 | 2111595 | 2022-01-13 | Beadle | South Dakota | 46005 | 4012 | 50 |
2108343 | 2108343 | 2022-01-12 | Beadle | South Dakota | 46005 | 3978 | 50 |
2105092 | 2105092 | 2022-01-11 | Beadle | South Dakota | 46005 | 3944 | 50 |
2101841 | 2101841 | 2022-01-10 | Beadle | South Dakota | 46005 | 3917 | 50 |
2098590 | 2098590 | 2022-01-09 | Beadle | South Dakota | 46005 | 3890 | 50 |
2095338 | 2095338 | 2022-01-08 | Beadle | South Dakota | 46005 | 3890 | 50 |
2092086 | 2092086 | 2022-01-07 | Beadle | South Dakota | 46005 | 3890 | 50 |
2088834 | 2088834 | 2022-01-06 | Beadle | South Dakota | 46005 | 3844 | 50 |
2085583 | 2085583 | 2022-01-05 | Beadle | South Dakota | 46005 | 3810 | 50 |
2082331 | 2082331 | 2022-01-04 | Beadle | South Dakota | 46005 | 3790 | 50 |
2079079 | 2079079 | 2022-01-03 | Beadle | South Dakota | 46005 | 3725 | 50 |
2075828 | 2075828 | 2022-01-02 | Beadle | South Dakota | 46005 | 3721 | 49 |
2072577 | 2072577 | 2022-01-01 | Beadle | South Dakota | 46005 | 3721 | 49 |
2069326 | 2069326 | 2021-12-31 | Beadle | South Dakota | 46005 | 3721 | 49 |
2066075 | 2066075 | 2021-12-30 | Beadle | South Dakota | 46005 | 3721 | 49 |
2062825 | 2062825 | 2021-12-29 | Beadle | South Dakota | 46005 | 3719 | 49 |
2059575 | 2059575 | 2021-12-28 | Beadle | South Dakota | 46005 | 3714 | 49 |
2056326 | 2056326 | 2021-12-27 | Beadle | South Dakota | 46005 | 3702 | 49 |
2053077 | 2053077 | 2021-12-26 | Beadle | South Dakota | 46005 | 3688 | 49 |
2049827 | 2049827 | 2021-12-25 | Beadle | South Dakota | 46005 | 3688 | 49 |
2046577 | 2046577 | 2021-12-24 | Beadle | South Dakota | 46005 | 3688 | 49 |
2043327 | 2043327 | 2021-12-23 | Beadle | South Dakota | 46005 | 3688 | 49 |
2040078 | 2040078 | 2021-12-22 | Beadle | South Dakota | 46005 | 3682 | 49 |
2036828 | 2036828 | 2021-12-21 | Beadle | South Dakota | 46005 | 3663 | 49 |
2033578 | 2033578 | 2021-12-20 | Beadle | South Dakota | 46005 | 3650 | 48 |
2030328 | 2030328 | 2021-12-19 | Beadle | South Dakota | 46005 | 3640 | 48 |
2027077 | 2027077 | 2021-12-18 | Beadle | South Dakota | 46005 | 3640 | 48 |
2023826 | 2023826 | 2021-12-17 | Beadle | South Dakota | 46005 | 3640 | 48 |
2020575 | 2020575 | 2021-12-16 | Beadle | South Dakota | 46005 | 3633 | 48 |
2017324 | 2017324 | 2021-12-15 | Beadle | South Dakota | 46005 | 3610 | 48 |
2014074 | 2014074 | 2021-12-14 | Beadle | South Dakota | 46005 | 3603 | 48 |
2010823 | 2010823 | 2021-12-13 | Beadle | South Dakota | 46005 | 3581 | 48 |
2007572 | 2007572 | 2021-12-12 | Beadle | South Dakota | 46005 | 3573 | 48 |
2004321 | 2004321 | 2021-12-11 | Beadle | South Dakota | 46005 | 3573 | 48 |
2001070 | 2001070 | 2021-12-10 | Beadle | South Dakota | 46005 | 3573 | 48 |
1997820 | 1997820 | 2021-12-09 | Beadle | South Dakota | 46005 | 3577 | 48 |
1994569 | 1994569 | 2021-12-08 | Beadle | South Dakota | 46005 | 3569 | 47 |
1991318 | 1991318 | 2021-12-07 | Beadle | South Dakota | 46005 | 3557 | 47 |
1988067 | 1988067 | 2021-12-06 | Beadle | South Dakota | 46005 | 3533 | 47 |
1984817 | 1984817 | 2021-12-05 | Beadle | South Dakota | 46005 | 3522 | 47 |
1981567 | 1981567 | 2021-12-04 | Beadle | South Dakota | 46005 | 3522 | 47 |
1978317 | 1978317 | 2021-12-03 | Beadle | South Dakota | 46005 | 3522 | 47 |
1975067 | 1975067 | 2021-12-02 | Beadle | South Dakota | 46005 | 3517 | 47 |
1971818 | 1971818 | 2021-12-01 | Beadle | South Dakota | 46005 | 3501 | 47 |
1968568 | 1968568 | 2021-11-30 | Beadle | South Dakota | 46005 | 3463 | 47 |
1965317 | 1965317 | 2021-11-29 | Beadle | South Dakota | 46005 | 3458 | 47 |
1962065 | 1962065 | 2021-11-28 | Beadle | South Dakota | 46005 | 3448 | 47 |
1958814 | 1958814 | 2021-11-27 | Beadle | South Dakota | 46005 | 3448 | 47 |
1955563 | 1955563 | 2021-11-26 | Beadle | South Dakota | 46005 | 3448 | 47 |
1952312 | 1952312 | 2021-11-25 | Beadle | South Dakota | 46005 | 3448 | 47 |
1949061 | 1949061 | 2021-11-24 | Beadle | South Dakota | 46005 | 3448 | 47 |
1945810 | 1945810 | 2021-11-23 | Beadle | South Dakota | 46005 | 3441 | 47 |
1942559 | 1942559 | 2021-11-22 | Beadle | South Dakota | 46005 | 3430 | 47 |
1939309 | 1939309 | 2021-11-21 | Beadle | South Dakota | 46005 | 3422 | 47 |
1936059 | 1936059 | 2021-11-20 | Beadle | South Dakota | 46005 | 3422 | 47 |
1932809 | 1932809 | 2021-11-19 | Beadle | South Dakota | 46005 | 3422 | 47 |
1929558 | 1929558 | 2021-11-18 | Beadle | South Dakota | 46005 | 3407 | 47 |
1926308 | 1926308 | 2021-11-17 | Beadle | South Dakota | 46005 | 3397 | 47 |
1923058 | 1923058 | 2021-11-16 | Beadle | South Dakota | 46005 | 3389 | 47 |
1919809 | 1919809 | 2021-11-15 | Beadle | South Dakota | 46005 | 3375 | 47 |
1916559 | 1916559 | 2021-11-14 | Beadle | South Dakota | 46005 | 3370 | 47 |
1913309 | 1913309 | 2021-11-13 | Beadle | South Dakota | 46005 | 3370 | 47 |
1910059 | 1910059 | 2021-11-12 | Beadle | South Dakota | 46005 | 3370 | 47 |
1906810 | 1906810 | 2021-11-11 | Beadle | South Dakota | 46005 | 3369 | 47 |
1903561 | 1903561 | 2021-11-10 | Beadle | South Dakota | 46005 | 3369 | 47 |
1900311 | 1900311 | 2021-11-09 | Beadle | South Dakota | 46005 | 3356 | 47 |
1897061 | 1897061 | 2021-11-08 | Beadle | South Dakota | 46005 | 3348 | 47 |
1893811 | 1893811 | 2021-11-07 | Beadle | South Dakota | 46005 | 3344 | 47 |
1890561 | 1890561 | 2021-11-06 | Beadle | South Dakota | 46005 | 3344 | 47 |
1887311 | 1887311 | 2021-11-05 | Beadle | South Dakota | 46005 | 3344 | 47 |
1884061 | 1884061 | 2021-11-04 | Beadle | South Dakota | 46005 | 3337 | 47 |
1880812 | 1880812 | 2021-11-03 | Beadle | South Dakota | 46005 | 3327 | 47 |
1877563 | 1877563 | 2021-11-02 | Beadle | South Dakota | 46005 | 3317 | 47 |
1874314 | 1874314 | 2021-11-01 | Beadle | South Dakota | 46005 | 3309 | 47 |
1871065 | 1871065 | 2021-10-31 | Beadle | South Dakota | 46005 | 3298 | 47 |
1867816 | 1867816 | 2021-10-30 | Beadle | South Dakota | 46005 | 3298 | 47 |
1864567 | 1864567 | 2021-10-29 | Beadle | South Dakota | 46005 | 3298 | 47 |
1861318 | 1861318 | 2021-10-28 | Beadle | South Dakota | 46005 | 3291 | 47 |
1858069 | 1858069 | 2021-10-27 | Beadle | South Dakota | 46005 | 3287 | 45 |
1854820 | 1854820 | 2021-10-26 | Beadle | South Dakota | 46005 | 3280 | 45 |
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);