ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
680 rows where county = "Campbell" 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 |
---|---|---|---|---|---|---|---|
2176670 | 2176670 | 2022-02-02 | Campbell | South Dakota | 46021 | 255 | 7 |
2173416 | 2173416 | 2022-02-01 | Campbell | South Dakota | 46021 | 255 | 7 |
2170164 | 2170164 | 2022-01-31 | Campbell | South Dakota | 46021 | 252 | 7 |
2166910 | 2166910 | 2022-01-30 | Campbell | South Dakota | 46021 | 250 | 7 |
2163655 | 2163655 | 2022-01-29 | Campbell | South Dakota | 46021 | 250 | 7 |
2160400 | 2160400 | 2022-01-28 | Campbell | South Dakota | 46021 | 250 | 7 |
2157144 | 2157144 | 2022-01-27 | Campbell | South Dakota | 46021 | 250 | 7 |
2153891 | 2153891 | 2022-01-26 | Campbell | South Dakota | 46021 | 250 | 7 |
2150639 | 2150639 | 2022-01-25 | Campbell | South Dakota | 46021 | 249 | 7 |
2147387 | 2147387 | 2022-01-24 | Campbell | South Dakota | 46021 | 248 | 7 |
2144133 | 2144133 | 2022-01-23 | Campbell | South Dakota | 46021 | 240 | 7 |
2140878 | 2140878 | 2022-01-22 | Campbell | South Dakota | 46021 | 240 | 7 |
2137622 | 2137622 | 2022-01-21 | Campbell | South Dakota | 46021 | 240 | 7 |
2134368 | 2134368 | 2022-01-20 | Campbell | South Dakota | 46021 | 238 | 7 |
2131116 | 2131116 | 2022-01-19 | Campbell | South Dakota | 46021 | 237 | 6 |
2127862 | 2127862 | 2022-01-18 | Campbell | South Dakota | 46021 | 233 | 6 |
2124610 | 2124610 | 2022-01-17 | Campbell | South Dakota | 46021 | 230 | 6 |
2121358 | 2121358 | 2022-01-16 | Campbell | South Dakota | 46021 | 230 | 6 |
2118106 | 2118106 | 2022-01-15 | Campbell | South Dakota | 46021 | 230 | 6 |
2114855 | 2114855 | 2022-01-14 | Campbell | South Dakota | 46021 | 230 | 6 |
2111603 | 2111603 | 2022-01-13 | Campbell | South Dakota | 46021 | 224 | 6 |
2108351 | 2108351 | 2022-01-12 | Campbell | South Dakota | 46021 | 223 | 6 |
2105100 | 2105100 | 2022-01-11 | Campbell | South Dakota | 46021 | 221 | 6 |
2101849 | 2101849 | 2022-01-10 | Campbell | South Dakota | 46021 | 218 | 6 |
2098598 | 2098598 | 2022-01-09 | Campbell | South Dakota | 46021 | 217 | 6 |
2095346 | 2095346 | 2022-01-08 | Campbell | South Dakota | 46021 | 217 | 6 |
2092094 | 2092094 | 2022-01-07 | Campbell | South Dakota | 46021 | 217 | 6 |
2088842 | 2088842 | 2022-01-06 | Campbell | South Dakota | 46021 | 217 | 6 |
2085591 | 2085591 | 2022-01-05 | Campbell | South Dakota | 46021 | 216 | 6 |
2082339 | 2082339 | 2022-01-04 | Campbell | South Dakota | 46021 | 214 | 6 |
2079087 | 2079087 | 2022-01-03 | Campbell | South Dakota | 46021 | 212 | 6 |
2075836 | 2075836 | 2022-01-02 | Campbell | South Dakota | 46021 | 210 | 6 |
2072585 | 2072585 | 2022-01-01 | Campbell | South Dakota | 46021 | 210 | 6 |
2069334 | 2069334 | 2021-12-31 | Campbell | South Dakota | 46021 | 210 | 6 |
2066083 | 2066083 | 2021-12-30 | Campbell | South Dakota | 46021 | 210 | 6 |
2062833 | 2062833 | 2021-12-29 | Campbell | South Dakota | 46021 | 210 | 6 |
2059583 | 2059583 | 2021-12-28 | Campbell | South Dakota | 46021 | 208 | 6 |
2056334 | 2056334 | 2021-12-27 | Campbell | South Dakota | 46021 | 208 | 6 |
2053085 | 2053085 | 2021-12-26 | Campbell | South Dakota | 46021 | 208 | 6 |
2049835 | 2049835 | 2021-12-25 | Campbell | South Dakota | 46021 | 208 | 6 |
2046585 | 2046585 | 2021-12-24 | Campbell | South Dakota | 46021 | 208 | 6 |
2043335 | 2043335 | 2021-12-23 | Campbell | South Dakota | 46021 | 208 | 6 |
2040086 | 2040086 | 2021-12-22 | Campbell | South Dakota | 46021 | 208 | 6 |
2036836 | 2036836 | 2021-12-21 | Campbell | South Dakota | 46021 | 208 | 6 |
2033586 | 2033586 | 2021-12-20 | Campbell | South Dakota | 46021 | 207 | 6 |
2030336 | 2030336 | 2021-12-19 | Campbell | South Dakota | 46021 | 207 | 6 |
2027085 | 2027085 | 2021-12-18 | Campbell | South Dakota | 46021 | 207 | 6 |
2023834 | 2023834 | 2021-12-17 | Campbell | South Dakota | 46021 | 207 | 6 |
2020583 | 2020583 | 2021-12-16 | Campbell | South Dakota | 46021 | 207 | 6 |
2017332 | 2017332 | 2021-12-15 | Campbell | South Dakota | 46021 | 206 | 5 |
2014082 | 2014082 | 2021-12-14 | Campbell | South Dakota | 46021 | 205 | 5 |
2010831 | 2010831 | 2021-12-13 | Campbell | South Dakota | 46021 | 205 | 5 |
2007580 | 2007580 | 2021-12-12 | Campbell | South Dakota | 46021 | 204 | 5 |
2004329 | 2004329 | 2021-12-11 | Campbell | South Dakota | 46021 | 204 | 5 |
2001078 | 2001078 | 2021-12-10 | Campbell | South Dakota | 46021 | 204 | 5 |
1997828 | 1997828 | 2021-12-09 | Campbell | South Dakota | 46021 | 204 | 5 |
1994577 | 1994577 | 2021-12-08 | Campbell | South Dakota | 46021 | 202 | 5 |
1991326 | 1991326 | 2021-12-07 | Campbell | South Dakota | 46021 | 199 | 5 |
1988075 | 1988075 | 2021-12-06 | Campbell | South Dakota | 46021 | 196 | 5 |
1984825 | 1984825 | 2021-12-05 | Campbell | South Dakota | 46021 | 196 | 5 |
1981575 | 1981575 | 2021-12-04 | Campbell | South Dakota | 46021 | 196 | 5 |
1978325 | 1978325 | 2021-12-03 | Campbell | South Dakota | 46021 | 196 | 5 |
1975075 | 1975075 | 2021-12-02 | Campbell | South Dakota | 46021 | 192 | 5 |
1971826 | 1971826 | 2021-12-01 | Campbell | South Dakota | 46021 | 186 | 5 |
1968576 | 1968576 | 2021-11-30 | Campbell | South Dakota | 46021 | 182 | 4 |
1965325 | 1965325 | 2021-11-29 | Campbell | South Dakota | 46021 | 180 | 4 |
1962073 | 1962073 | 2021-11-28 | Campbell | South Dakota | 46021 | 176 | 4 |
1958822 | 1958822 | 2021-11-27 | Campbell | South Dakota | 46021 | 176 | 4 |
1955571 | 1955571 | 2021-11-26 | Campbell | South Dakota | 46021 | 176 | 4 |
1952320 | 1952320 | 2021-11-25 | Campbell | South Dakota | 46021 | 176 | 4 |
1949069 | 1949069 | 2021-11-24 | Campbell | South Dakota | 46021 | 176 | 4 |
1945818 | 1945818 | 2021-11-23 | Campbell | South Dakota | 46021 | 176 | 4 |
1942567 | 1942567 | 2021-11-22 | Campbell | South Dakota | 46021 | 175 | 4 |
1939317 | 1939317 | 2021-11-21 | Campbell | South Dakota | 46021 | 175 | 4 |
1936067 | 1936067 | 2021-11-20 | Campbell | South Dakota | 46021 | 175 | 4 |
1932817 | 1932817 | 2021-11-19 | Campbell | South Dakota | 46021 | 175 | 4 |
1929566 | 1929566 | 2021-11-18 | Campbell | South Dakota | 46021 | 174 | 4 |
1926316 | 1926316 | 2021-11-17 | Campbell | South Dakota | 46021 | 173 | 4 |
1923066 | 1923066 | 2021-11-16 | Campbell | South Dakota | 46021 | 173 | 4 |
1919817 | 1919817 | 2021-11-15 | Campbell | South Dakota | 46021 | 172 | 4 |
1916567 | 1916567 | 2021-11-14 | Campbell | South Dakota | 46021 | 172 | 4 |
1913317 | 1913317 | 2021-11-13 | Campbell | South Dakota | 46021 | 172 | 4 |
1910067 | 1910067 | 2021-11-12 | Campbell | South Dakota | 46021 | 172 | 4 |
1906818 | 1906818 | 2021-11-11 | Campbell | South Dakota | 46021 | 172 | 4 |
1903569 | 1903569 | 2021-11-10 | Campbell | South Dakota | 46021 | 172 | 4 |
1900319 | 1900319 | 2021-11-09 | Campbell | South Dakota | 46021 | 172 | 4 |
1897069 | 1897069 | 2021-11-08 | Campbell | South Dakota | 46021 | 169 | 4 |
1893819 | 1893819 | 2021-11-07 | Campbell | South Dakota | 46021 | 169 | 4 |
1890569 | 1890569 | 2021-11-06 | Campbell | South Dakota | 46021 | 169 | 4 |
1887319 | 1887319 | 2021-11-05 | Campbell | South Dakota | 46021 | 169 | 4 |
1884069 | 1884069 | 2021-11-04 | Campbell | South Dakota | 46021 | 168 | 4 |
1880820 | 1880820 | 2021-11-03 | Campbell | South Dakota | 46021 | 168 | 4 |
1877571 | 1877571 | 2021-11-02 | Campbell | South Dakota | 46021 | 166 | 4 |
1874322 | 1874322 | 2021-11-01 | Campbell | South Dakota | 46021 | 166 | 4 |
1871073 | 1871073 | 2021-10-31 | Campbell | South Dakota | 46021 | 166 | 4 |
1867824 | 1867824 | 2021-10-30 | Campbell | South Dakota | 46021 | 166 | 4 |
1864575 | 1864575 | 2021-10-29 | Campbell | South Dakota | 46021 | 166 | 4 |
1861326 | 1861326 | 2021-10-28 | Campbell | South Dakota | 46021 | 165 | 4 |
1858077 | 1858077 | 2021-10-27 | Campbell | South Dakota | 46021 | 165 | 4 |
1854828 | 1854828 | 2021-10-26 | Campbell | South Dakota | 46021 | 165 | 4 |
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);