ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Jerauld" 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 |
---|---|---|---|---|---|---|---|
2176696 | 2176696 | 2022-02-02 | Jerauld | South Dakota | 46073 | 394 | 19 |
2173442 | 2173442 | 2022-02-01 | Jerauld | South Dakota | 46073 | 394 | 19 |
2170190 | 2170190 | 2022-01-31 | Jerauld | South Dakota | 46073 | 390 | 19 |
2166936 | 2166936 | 2022-01-30 | Jerauld | South Dakota | 46073 | 387 | 19 |
2163681 | 2163681 | 2022-01-29 | Jerauld | South Dakota | 46073 | 387 | 19 |
2160426 | 2160426 | 2022-01-28 | Jerauld | South Dakota | 46073 | 387 | 19 |
2157170 | 2157170 | 2022-01-27 | Jerauld | South Dakota | 46073 | 385 | 19 |
2153917 | 2153917 | 2022-01-26 | Jerauld | South Dakota | 46073 | 379 | 19 |
2150665 | 2150665 | 2022-01-25 | Jerauld | South Dakota | 46073 | 379 | 19 |
2147413 | 2147413 | 2022-01-24 | Jerauld | South Dakota | 46073 | 378 | 19 |
2144159 | 2144159 | 2022-01-23 | Jerauld | South Dakota | 46073 | 376 | 19 |
2140904 | 2140904 | 2022-01-22 | Jerauld | South Dakota | 46073 | 376 | 19 |
2137648 | 2137648 | 2022-01-21 | Jerauld | South Dakota | 46073 | 376 | 19 |
2134394 | 2134394 | 2022-01-20 | Jerauld | South Dakota | 46073 | 374 | 19 |
2131142 | 2131142 | 2022-01-19 | Jerauld | South Dakota | 46073 | 372 | 19 |
2127888 | 2127888 | 2022-01-18 | Jerauld | South Dakota | 46073 | 362 | 19 |
2124636 | 2124636 | 2022-01-17 | Jerauld | South Dakota | 46073 | 357 | 19 |
2121384 | 2121384 | 2022-01-16 | Jerauld | South Dakota | 46073 | 357 | 19 |
2118132 | 2118132 | 2022-01-15 | Jerauld | South Dakota | 46073 | 357 | 19 |
2114881 | 2114881 | 2022-01-14 | Jerauld | South Dakota | 46073 | 357 | 19 |
2111629 | 2111629 | 2022-01-13 | Jerauld | South Dakota | 46073 | 350 | 19 |
2108377 | 2108377 | 2022-01-12 | Jerauld | South Dakota | 46073 | 346 | 19 |
2105126 | 2105126 | 2022-01-11 | Jerauld | South Dakota | 46073 | 344 | 19 |
2101875 | 2101875 | 2022-01-10 | Jerauld | South Dakota | 46073 | 342 | 19 |
2098624 | 2098624 | 2022-01-09 | Jerauld | South Dakota | 46073 | 342 | 19 |
2095372 | 2095372 | 2022-01-08 | Jerauld | South Dakota | 46073 | 342 | 19 |
2092120 | 2092120 | 2022-01-07 | Jerauld | South Dakota | 46073 | 342 | 19 |
2088868 | 2088868 | 2022-01-06 | Jerauld | South Dakota | 46073 | 340 | 19 |
2085617 | 2085617 | 2022-01-05 | Jerauld | South Dakota | 46073 | 339 | 19 |
2082365 | 2082365 | 2022-01-04 | Jerauld | South Dakota | 46073 | 338 | 19 |
2079113 | 2079113 | 2022-01-03 | Jerauld | South Dakota | 46073 | 337 | 19 |
2075862 | 2075862 | 2022-01-02 | Jerauld | South Dakota | 46073 | 337 | 19 |
2072611 | 2072611 | 2022-01-01 | Jerauld | South Dakota | 46073 | 337 | 19 |
2069360 | 2069360 | 2021-12-31 | Jerauld | South Dakota | 46073 | 337 | 19 |
2066109 | 2066109 | 2021-12-30 | Jerauld | South Dakota | 46073 | 337 | 19 |
2062859 | 2062859 | 2021-12-29 | Jerauld | South Dakota | 46073 | 335 | 19 |
2059609 | 2059609 | 2021-12-28 | Jerauld | South Dakota | 46073 | 332 | 19 |
2056360 | 2056360 | 2021-12-27 | Jerauld | South Dakota | 46073 | 332 | 19 |
2053111 | 2053111 | 2021-12-26 | Jerauld | South Dakota | 46073 | 332 | 19 |
2049861 | 2049861 | 2021-12-25 | Jerauld | South Dakota | 46073 | 332 | 19 |
2046611 | 2046611 | 2021-12-24 | Jerauld | South Dakota | 46073 | 332 | 19 |
2043361 | 2043361 | 2021-12-23 | Jerauld | South Dakota | 46073 | 332 | 19 |
2040112 | 2040112 | 2021-12-22 | Jerauld | South Dakota | 46073 | 332 | 19 |
2036862 | 2036862 | 2021-12-21 | Jerauld | South Dakota | 46073 | 332 | 19 |
2033612 | 2033612 | 2021-12-20 | Jerauld | South Dakota | 46073 | 330 | 19 |
2030362 | 2030362 | 2021-12-19 | Jerauld | South Dakota | 46073 | 329 | 19 |
2027111 | 2027111 | 2021-12-18 | Jerauld | South Dakota | 46073 | 329 | 19 |
2023860 | 2023860 | 2021-12-17 | Jerauld | South Dakota | 46073 | 329 | 19 |
2020609 | 2020609 | 2021-12-16 | Jerauld | South Dakota | 46073 | 327 | 19 |
2017358 | 2017358 | 2021-12-15 | Jerauld | South Dakota | 46073 | 325 | 19 |
2014108 | 2014108 | 2021-12-14 | Jerauld | South Dakota | 46073 | 325 | 18 |
2010857 | 2010857 | 2021-12-13 | Jerauld | South Dakota | 46073 | 319 | 18 |
2007606 | 2007606 | 2021-12-12 | Jerauld | South Dakota | 46073 | 318 | 18 |
2004355 | 2004355 | 2021-12-11 | Jerauld | South Dakota | 46073 | 318 | 18 |
2001104 | 2001104 | 2021-12-10 | Jerauld | South Dakota | 46073 | 318 | 18 |
1997854 | 1997854 | 2021-12-09 | Jerauld | South Dakota | 46073 | 316 | 18 |
1994603 | 1994603 | 2021-12-08 | Jerauld | South Dakota | 46073 | 315 | 18 |
1991352 | 1991352 | 2021-12-07 | Jerauld | South Dakota | 46073 | 313 | 18 |
1988101 | 1988101 | 2021-12-06 | Jerauld | South Dakota | 46073 | 312 | 18 |
1984851 | 1984851 | 2021-12-05 | Jerauld | South Dakota | 46073 | 312 | 18 |
1981601 | 1981601 | 2021-12-04 | Jerauld | South Dakota | 46073 | 312 | 18 |
1978351 | 1978351 | 2021-12-03 | Jerauld | South Dakota | 46073 | 312 | 18 |
1975101 | 1975101 | 2021-12-02 | Jerauld | South Dakota | 46073 | 312 | 18 |
1971852 | 1971852 | 2021-12-01 | Jerauld | South Dakota | 46073 | 312 | 17 |
1968602 | 1968602 | 2021-11-30 | Jerauld | South Dakota | 46073 | 311 | 17 |
1965351 | 1965351 | 2021-11-29 | Jerauld | South Dakota | 46073 | 310 | 17 |
1962099 | 1962099 | 2021-11-28 | Jerauld | South Dakota | 46073 | 307 | 17 |
1958848 | 1958848 | 2021-11-27 | Jerauld | South Dakota | 46073 | 307 | 17 |
1955597 | 1955597 | 2021-11-26 | Jerauld | South Dakota | 46073 | 307 | 17 |
1952346 | 1952346 | 2021-11-25 | Jerauld | South Dakota | 46073 | 307 | 17 |
1949095 | 1949095 | 2021-11-24 | Jerauld | South Dakota | 46073 | 307 | 17 |
1945844 | 1945844 | 2021-11-23 | Jerauld | South Dakota | 46073 | 307 | 17 |
1942593 | 1942593 | 2021-11-22 | Jerauld | South Dakota | 46073 | 307 | 17 |
1939343 | 1939343 | 2021-11-21 | Jerauld | South Dakota | 46073 | 306 | 17 |
1936093 | 1936093 | 2021-11-20 | Jerauld | South Dakota | 46073 | 306 | 17 |
1932843 | 1932843 | 2021-11-19 | Jerauld | South Dakota | 46073 | 306 | 17 |
1929592 | 1929592 | 2021-11-18 | Jerauld | South Dakota | 46073 | 303 | 17 |
1926342 | 1926342 | 2021-11-17 | Jerauld | South Dakota | 46073 | 303 | 17 |
1923092 | 1923092 | 2021-11-16 | Jerauld | South Dakota | 46073 | 302 | 17 |
1919843 | 1919843 | 2021-11-15 | Jerauld | South Dakota | 46073 | 302 | 17 |
1916593 | 1916593 | 2021-11-14 | Jerauld | South Dakota | 46073 | 301 | 17 |
1913343 | 1913343 | 2021-11-13 | Jerauld | South Dakota | 46073 | 301 | 17 |
1910093 | 1910093 | 2021-11-12 | Jerauld | South Dakota | 46073 | 301 | 17 |
1906844 | 1906844 | 2021-11-11 | Jerauld | South Dakota | 46073 | 301 | 17 |
1903595 | 1903595 | 2021-11-10 | Jerauld | South Dakota | 46073 | 301 | 17 |
1900345 | 1900345 | 2021-11-09 | Jerauld | South Dakota | 46073 | 301 | 17 |
1897095 | 1897095 | 2021-11-08 | Jerauld | South Dakota | 46073 | 301 | 17 |
1893845 | 1893845 | 2021-11-07 | Jerauld | South Dakota | 46073 | 301 | 17 |
1890595 | 1890595 | 2021-11-06 | Jerauld | South Dakota | 46073 | 301 | 17 |
1887345 | 1887345 | 2021-11-05 | Jerauld | South Dakota | 46073 | 301 | 17 |
1884095 | 1884095 | 2021-11-04 | Jerauld | South Dakota | 46073 | 301 | 17 |
1880846 | 1880846 | 2021-11-03 | Jerauld | South Dakota | 46073 | 301 | 17 |
1877597 | 1877597 | 2021-11-02 | Jerauld | South Dakota | 46073 | 301 | 17 |
1874348 | 1874348 | 2021-11-01 | Jerauld | South Dakota | 46073 | 300 | 17 |
1871099 | 1871099 | 2021-10-31 | Jerauld | South Dakota | 46073 | 300 | 17 |
1867850 | 1867850 | 2021-10-30 | Jerauld | South Dakota | 46073 | 300 | 17 |
1864601 | 1864601 | 2021-10-29 | Jerauld | South Dakota | 46073 | 300 | 17 |
1861352 | 1861352 | 2021-10-28 | Jerauld | South Dakota | 46073 | 300 | 17 |
1858103 | 1858103 | 2021-10-27 | Jerauld | South Dakota | 46073 | 300 | 17 |
1854854 | 1854854 | 2021-10-26 | Jerauld | South Dakota | 46073 | 300 | 17 |
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);