ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Benton" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177260 | 2177260 | 2022-02-02 | Benton | Washington | 53005 | 49289 | 424 |
2174007 | 2174007 | 2022-02-01 | Benton | Washington | 53005 | 48484 | 422 |
2170755 | 2170755 | 2022-01-31 | Benton | Washington | 53005 | 48484 | 422 |
2167502 | 2167502 | 2022-01-30 | Benton | Washington | 53005 | 46468 | 418 |
2164247 | 2164247 | 2022-01-29 | Benton | Washington | 53005 | 46468 | 418 |
2160992 | 2160992 | 2022-01-28 | Benton | Washington | 53005 | 46468 | 418 |
2157736 | 2157736 | 2022-01-27 | Benton | Washington | 53005 | 44995 | 416 |
2154483 | 2154483 | 2022-01-26 | Benton | Washington | 53005 | 44995 | 416 |
2151230 | 2151230 | 2022-01-25 | Benton | Washington | 53005 | 42667 | 415 |
2147978 | 2147978 | 2022-01-24 | Benton | Washington | 53005 | 42667 | 415 |
2144726 | 2144726 | 2022-01-23 | Benton | Washington | 53005 | 40893 | 413 |
2141471 | 2141471 | 2022-01-22 | Benton | Washington | 53005 | 40893 | 413 |
2138215 | 2138215 | 2022-01-21 | Benton | Washington | 53005 | 40893 | 413 |
2134960 | 2134960 | 2022-01-20 | Benton | Washington | 53005 | 40219 | 413 |
2131708 | 2131708 | 2022-01-19 | Benton | Washington | 53005 | 39652 | 410 |
2128454 | 2128454 | 2022-01-18 | Benton | Washington | 53005 | 39270 | 410 |
2125201 | 2125201 | 2022-01-17 | Benton | Washington | 53005 | 37604 | 409 |
2121949 | 2121949 | 2022-01-16 | Benton | Washington | 53005 | 37604 | 409 |
2118697 | 2118697 | 2022-01-15 | Benton | Washington | 53005 | 37604 | 409 |
2115445 | 2115445 | 2022-01-14 | Benton | Washington | 53005 | 37604 | 409 |
2112193 | 2112193 | 2022-01-13 | Benton | Washington | 53005 | 36956 | 410 |
2108941 | 2108941 | 2022-01-12 | Benton | Washington | 53005 | 36143 | 409 |
2105690 | 2105690 | 2022-01-11 | Benton | Washington | 53005 | 35791 | 405 |
2102439 | 2102439 | 2022-01-10 | Benton | Washington | 53005 | 35671 | 406 |
2099188 | 2099188 | 2022-01-09 | Benton | Washington | 53005 | 34835 | 405 |
2095937 | 2095937 | 2022-01-08 | Benton | Washington | 53005 | 34835 | 405 |
2092685 | 2092685 | 2022-01-07 | Benton | Washington | 53005 | 34835 | 405 |
2089433 | 2089433 | 2022-01-06 | Benton | Washington | 53005 | 34576 | 404 |
2086182 | 2086182 | 2022-01-05 | Benton | Washington | 53005 | 34273 | 400 |
2082930 | 2082930 | 2022-01-04 | Benton | Washington | 53005 | 34072 | 400 |
2079678 | 2079678 | 2022-01-03 | Benton | Washington | 53005 | 33847 | 398 |
2076426 | 2076426 | 2022-01-02 | Benton | Washington | 53005 | 33325 | 398 |
2073175 | 2073175 | 2022-01-01 | Benton | Washington | 53005 | 33325 | 398 |
2069924 | 2069924 | 2021-12-31 | Benton | Washington | 53005 | 33325 | 398 |
2066673 | 2066673 | 2021-12-30 | Benton | Washington | 53005 | 33325 | 398 |
2063423 | 2063423 | 2021-12-29 | Benton | Washington | 53005 | 33213 | 398 |
2060173 | 2060173 | 2021-12-28 | Benton | Washington | 53005 | 33135 | 398 |
2056924 | 2056924 | 2021-12-27 | Benton | Washington | 53005 | 33040 | 396 |
2053675 | 2053675 | 2021-12-26 | Benton | Washington | 53005 | 32916 | 396 |
2050425 | 2050425 | 2021-12-25 | Benton | Washington | 53005 | 32916 | 396 |
2047175 | 2047175 | 2021-12-24 | Benton | Washington | 53005 | 32916 | 396 |
2043925 | 2043925 | 2021-12-23 | Benton | Washington | 53005 | 32916 | 396 |
2040676 | 2040676 | 2021-12-22 | Benton | Washington | 53005 | 32885 | 396 |
2037426 | 2037426 | 2021-12-21 | Benton | Washington | 53005 | 32859 | 396 |
2034176 | 2034176 | 2021-12-20 | Benton | Washington | 53005 | 32824 | 396 |
2030926 | 2030926 | 2021-12-19 | Benton | Washington | 53005 | 32779 | 396 |
2027675 | 2027675 | 2021-12-18 | Benton | Washington | 53005 | 32779 | 396 |
2024424 | 2024424 | 2021-12-17 | Benton | Washington | 53005 | 32779 | 396 |
2021173 | 2021173 | 2021-12-16 | Benton | Washington | 53005 | 32760 | 396 |
2017922 | 2017922 | 2021-12-15 | Benton | Washington | 53005 | 32735 | 394 |
2014672 | 2014672 | 2021-12-14 | Benton | Washington | 53005 | 32713 | 394 |
2011421 | 2011421 | 2021-12-13 | Benton | Washington | 53005 | 32694 | 393 |
2008170 | 2008170 | 2021-12-12 | Benton | Washington | 53005 | 32644 | 393 |
2004919 | 2004919 | 2021-12-11 | Benton | Washington | 53005 | 32644 | 393 |
2001668 | 2001668 | 2021-12-10 | Benton | Washington | 53005 | 32644 | 393 |
1998418 | 1998418 | 2021-12-09 | Benton | Washington | 53005 | 32613 | 393 |
1995167 | 1995167 | 2021-12-08 | Benton | Washington | 53005 | 32577 | 392 |
1991916 | 1991916 | 2021-12-07 | Benton | Washington | 53005 | 32537 | 392 |
1988665 | 1988665 | 2021-12-06 | Benton | Washington | 53005 | 32501 | 392 |
1985415 | 1985415 | 2021-12-05 | Benton | Washington | 53005 | 32412 | 391 |
1982165 | 1982165 | 2021-12-04 | Benton | Washington | 53005 | 32412 | 391 |
1978915 | 1978915 | 2021-12-03 | Benton | Washington | 53005 | 32412 | 391 |
1975665 | 1975665 | 2021-12-02 | Benton | Washington | 53005 | 32367 | 388 |
1972416 | 1972416 | 2021-12-01 | Benton | Washington | 53005 | 32293 | 388 |
1969166 | 1969166 | 2021-11-30 | Benton | Washington | 53005 | 32293 | 388 |
1965916 | 1965916 | 2021-11-29 | Benton | Washington | 53005 | 32238 | 384 |
1962664 | 1962664 | 2021-11-28 | Benton | Washington | 53005 | 32149 | 383 |
1959413 | 1959413 | 2021-11-27 | Benton | Washington | 53005 | 32149 | 383 |
1956162 | 1956162 | 2021-11-26 | Benton | Washington | 53005 | 32149 | 383 |
1952911 | 1952911 | 2021-11-25 | Benton | Washington | 53005 | 32149 | 383 |
1949660 | 1949660 | 2021-11-24 | Benton | Washington | 53005 | 32149 | 383 |
1946409 | 1946409 | 2021-11-23 | Benton | Washington | 53005 | 32124 | 382 |
1943158 | 1943158 | 2021-11-22 | Benton | Washington | 53005 | 32097 | 377 |
1939908 | 1939908 | 2021-11-21 | Benton | Washington | 53005 | 32020 | 376 |
1936658 | 1936658 | 2021-11-20 | Benton | Washington | 53005 | 32020 | 376 |
1933408 | 1933408 | 2021-11-19 | Benton | Washington | 53005 | 32020 | 376 |
1930156 | 1930156 | 2021-11-18 | Benton | Washington | 53005 | 31987 | 376 |
1926906 | 1926906 | 2021-11-17 | Benton | Washington | 53005 | 31952 | 375 |
1923656 | 1923656 | 2021-11-16 | Benton | Washington | 53005 | 31900 | 375 |
1920407 | 1920407 | 2021-11-15 | Benton | Washington | 53005 | 31881 | 375 |
1917157 | 1917157 | 2021-11-14 | Benton | Washington | 53005 | 31792 | 373 |
1913907 | 1913907 | 2021-11-13 | Benton | Washington | 53005 | 31792 | 373 |
1910657 | 1910657 | 2021-11-12 | Benton | Washington | 53005 | 31792 | 373 |
1907408 | 1907408 | 2021-11-11 | Benton | Washington | 53005 | 31729 | 372 |
1904159 | 1904159 | 2021-11-10 | Benton | Washington | 53005 | 31729 | 372 |
1900909 | 1900909 | 2021-11-09 | Benton | Washington | 53005 | 31689 | 372 |
1897659 | 1897659 | 2021-11-08 | Benton | Washington | 53005 | 31654 | 372 |
1894409 | 1894409 | 2021-11-07 | Benton | Washington | 53005 | 31574 | 371 |
1891159 | 1891159 | 2021-11-06 | Benton | Washington | 53005 | 31574 | 371 |
1887909 | 1887909 | 2021-11-05 | Benton | Washington | 53005 | 31574 | 371 |
1884659 | 1884659 | 2021-11-04 | Benton | Washington | 53005 | 31530 | 371 |
1881410 | 1881410 | 2021-11-03 | Benton | Washington | 53005 | 31467 | 370 |
1878161 | 1878161 | 2021-11-02 | Benton | Washington | 53005 | 31420 | 369 |
1874912 | 1874912 | 2021-11-01 | Benton | Washington | 53005 | 31369 | 369 |
1871663 | 1871663 | 2021-10-31 | Benton | Washington | 53005 | 31276 | 367 |
1868414 | 1868414 | 2021-10-30 | Benton | Washington | 53005 | 31276 | 367 |
1865165 | 1865165 | 2021-10-29 | Benton | Washington | 53005 | 31276 | 367 |
1861916 | 1861916 | 2021-10-28 | Benton | Washington | 53005 | 31226 | 366 |
1858667 | 1858667 | 2021-10-27 | Benton | Washington | 53005 | 31140 | 367 |
1855418 | 1855418 | 2021-10-26 | Benton | Washington | 53005 | 31099 | 366 |
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);