ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Thurston" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177291 | 2177291 | 2022-02-02 | Thurston | Washington | 53067 | 43178 | 317 |
2174038 | 2174038 | 2022-02-01 | Thurston | Washington | 53067 | 42684 | 312 |
2170786 | 2170786 | 2022-01-31 | Thurston | Washington | 53067 | 42684 | 312 |
2167533 | 2167533 | 2022-01-30 | Thurston | Washington | 53067 | 41529 | 308 |
2164278 | 2164278 | 2022-01-29 | Thurston | Washington | 53067 | 41529 | 308 |
2161023 | 2161023 | 2022-01-28 | Thurston | Washington | 53067 | 41529 | 308 |
2157767 | 2157767 | 2022-01-27 | Thurston | Washington | 53067 | 40487 | 304 |
2154514 | 2154514 | 2022-01-26 | Thurston | Washington | 53067 | 40487 | 304 |
2151261 | 2151261 | 2022-01-25 | Thurston | Washington | 53067 | 39351 | 294 |
2148009 | 2148009 | 2022-01-24 | Thurston | Washington | 53067 | 39351 | 294 |
2144757 | 2144757 | 2022-01-23 | Thurston | Washington | 53067 | 37260 | 292 |
2141502 | 2141502 | 2022-01-22 | Thurston | Washington | 53067 | 37260 | 292 |
2138246 | 2138246 | 2022-01-21 | Thurston | Washington | 53067 | 37260 | 292 |
2134991 | 2134991 | 2022-01-20 | Thurston | Washington | 53067 | 36758 | 289 |
2131739 | 2131739 | 2022-01-19 | Thurston | Washington | 53067 | 36353 | 286 |
2128485 | 2128485 | 2022-01-18 | Thurston | Washington | 53067 | 35795 | 286 |
2125232 | 2125232 | 2022-01-17 | Thurston | Washington | 53067 | 33312 | 286 |
2121980 | 2121980 | 2022-01-16 | Thurston | Washington | 53067 | 33312 | 286 |
2118728 | 2118728 | 2022-01-15 | Thurston | Washington | 53067 | 33312 | 286 |
2115476 | 2115476 | 2022-01-14 | Thurston | Washington | 53067 | 33312 | 286 |
2112224 | 2112224 | 2022-01-13 | Thurston | Washington | 53067 | 32816 | 284 |
2108972 | 2108972 | 2022-01-12 | Thurston | Washington | 53067 | 32303 | 279 |
2105721 | 2105721 | 2022-01-11 | Thurston | Washington | 53067 | 31799 | 276 |
2102470 | 2102470 | 2022-01-10 | Thurston | Washington | 53067 | 31397 | 276 |
2099219 | 2099219 | 2022-01-09 | Thurston | Washington | 53067 | 29601 | 275 |
2095968 | 2095968 | 2022-01-08 | Thurston | Washington | 53067 | 29601 | 275 |
2092716 | 2092716 | 2022-01-07 | Thurston | Washington | 53067 | 29601 | 275 |
2089464 | 2089464 | 2022-01-06 | Thurston | Washington | 53067 | 28995 | 272 |
2086213 | 2086213 | 2022-01-05 | Thurston | Washington | 53067 | 28278 | 270 |
2082961 | 2082961 | 2022-01-04 | Thurston | Washington | 53067 | 27900 | 270 |
2079709 | 2079709 | 2022-01-03 | Thurston | Washington | 53067 | 27904 | 269 |
2076457 | 2076457 | 2022-01-02 | Thurston | Washington | 53067 | 26379 | 269 |
2073206 | 2073206 | 2022-01-01 | Thurston | Washington | 53067 | 26379 | 269 |
2069955 | 2069955 | 2021-12-31 | Thurston | Washington | 53067 | 26379 | 269 |
2066704 | 2066704 | 2021-12-30 | Thurston | Washington | 53067 | 26379 | 269 |
2063454 | 2063454 | 2021-12-29 | Thurston | Washington | 53067 | 26051 | 269 |
2060204 | 2060204 | 2021-12-28 | Thurston | Washington | 53067 | 25864 | 269 |
2056955 | 2056955 | 2021-12-27 | Thurston | Washington | 53067 | 25761 | 270 |
2053706 | 2053706 | 2021-12-26 | Thurston | Washington | 53067 | 24713 | 270 |
2050456 | 2050456 | 2021-12-25 | Thurston | Washington | 53067 | 24713 | 270 |
2047206 | 2047206 | 2021-12-24 | Thurston | Washington | 53067 | 24713 | 270 |
2043956 | 2043956 | 2021-12-23 | Thurston | Washington | 53067 | 24713 | 270 |
2040707 | 2040707 | 2021-12-22 | Thurston | Washington | 53067 | 24445 | 269 |
2037457 | 2037457 | 2021-12-21 | Thurston | Washington | 53067 | 24337 | 268 |
2034207 | 2034207 | 2021-12-20 | Thurston | Washington | 53067 | 24256 | 267 |
2030957 | 2030957 | 2021-12-19 | Thurston | Washington | 53067 | 23991 | 267 |
2027706 | 2027706 | 2021-12-18 | Thurston | Washington | 53067 | 23991 | 267 |
2024455 | 2024455 | 2021-12-17 | Thurston | Washington | 53067 | 23991 | 267 |
2021204 | 2021204 | 2021-12-16 | Thurston | Washington | 53067 | 23900 | 266 |
2017953 | 2017953 | 2021-12-15 | Thurston | Washington | 53067 | 23807 | 264 |
2014703 | 2014703 | 2021-12-14 | Thurston | Washington | 53067 | 23738 | 263 |
2011452 | 2011452 | 2021-12-13 | Thurston | Washington | 53067 | 23690 | 263 |
2008201 | 2008201 | 2021-12-12 | Thurston | Washington | 53067 | 23556 | 262 |
2004950 | 2004950 | 2021-12-11 | Thurston | Washington | 53067 | 23556 | 262 |
2001699 | 2001699 | 2021-12-10 | Thurston | Washington | 53067 | 23556 | 262 |
1998449 | 1998449 | 2021-12-09 | Thurston | Washington | 53067 | 23494 | 262 |
1995198 | 1995198 | 2021-12-08 | Thurston | Washington | 53067 | 23418 | 260 |
1991947 | 1991947 | 2021-12-07 | Thurston | Washington | 53067 | 23376 | 257 |
1988696 | 1988696 | 2021-12-06 | Thurston | Washington | 53067 | 23288 | 257 |
1985446 | 1985446 | 2021-12-05 | Thurston | Washington | 53067 | 23137 | 256 |
1982196 | 1982196 | 2021-12-04 | Thurston | Washington | 53067 | 23137 | 256 |
1978946 | 1978946 | 2021-12-03 | Thurston | Washington | 53067 | 23137 | 256 |
1975696 | 1975696 | 2021-12-02 | Thurston | Washington | 53067 | 23043 | 256 |
1972447 | 1972447 | 2021-12-01 | Thurston | Washington | 53067 | 22828 | 255 |
1969197 | 1969197 | 2021-11-30 | Thurston | Washington | 53067 | 22828 | 255 |
1965947 | 1965947 | 2021-11-29 | Thurston | Washington | 53067 | 22769 | 255 |
1962695 | 1962695 | 2021-11-28 | Thurston | Washington | 53067 | 22568 | 255 |
1959444 | 1959444 | 2021-11-27 | Thurston | Washington | 53067 | 22568 | 255 |
1956193 | 1956193 | 2021-11-26 | Thurston | Washington | 53067 | 22568 | 255 |
1952942 | 1952942 | 2021-11-25 | Thurston | Washington | 53067 | 22568 | 255 |
1949691 | 1949691 | 2021-11-24 | Thurston | Washington | 53067 | 22568 | 255 |
1946440 | 1946440 | 2021-11-23 | Thurston | Washington | 53067 | 22542 | 252 |
1943189 | 1943189 | 2021-11-22 | Thurston | Washington | 53067 | 22496 | 250 |
1939939 | 1939939 | 2021-11-21 | Thurston | Washington | 53067 | 22304 | 250 |
1936689 | 1936689 | 2021-11-20 | Thurston | Washington | 53067 | 22304 | 250 |
1933439 | 1933439 | 2021-11-19 | Thurston | Washington | 53067 | 22304 | 250 |
1930187 | 1930187 | 2021-11-18 | Thurston | Washington | 53067 | 22214 | 254 |
1926937 | 1926937 | 2021-11-17 | Thurston | Washington | 53067 | 22130 | 253 |
1923687 | 1923687 | 2021-11-16 | Thurston | Washington | 53067 | 22044 | 253 |
1920438 | 1920438 | 2021-11-15 | Thurston | Washington | 53067 | 21974 | 252 |
1917188 | 1917188 | 2021-11-14 | Thurston | Washington | 53067 | 21761 | 251 |
1913938 | 1913938 | 2021-11-13 | Thurston | Washington | 53067 | 21761 | 251 |
1910688 | 1910688 | 2021-11-12 | Thurston | Washington | 53067 | 21761 | 251 |
1907439 | 1907439 | 2021-11-11 | Thurston | Washington | 53067 | 21575 | 248 |
1904190 | 1904190 | 2021-11-10 | Thurston | Washington | 53067 | 21575 | 248 |
1900940 | 1900940 | 2021-11-09 | Thurston | Washington | 53067 | 21487 | 248 |
1897690 | 1897690 | 2021-11-08 | Thurston | Washington | 53067 | 21441 | 247 |
1894440 | 1894440 | 2021-11-07 | Thurston | Washington | 53067 | 21226 | 245 |
1891190 | 1891190 | 2021-11-06 | Thurston | Washington | 53067 | 21226 | 245 |
1887940 | 1887940 | 2021-11-05 | Thurston | Washington | 53067 | 21226 | 245 |
1884690 | 1884690 | 2021-11-04 | Thurston | Washington | 53067 | 21159 | 243 |
1881441 | 1881441 | 2021-11-03 | Thurston | Washington | 53067 | 21061 | 238 |
1878192 | 1878192 | 2021-11-02 | Thurston | Washington | 53067 | 21014 | 236 |
1874943 | 1874943 | 2021-11-01 | Thurston | Washington | 53067 | 20954 | 235 |
1871694 | 1871694 | 2021-10-31 | Thurston | Washington | 53067 | 20742 | 235 |
1868445 | 1868445 | 2021-10-30 | Thurston | Washington | 53067 | 20742 | 235 |
1865196 | 1865196 | 2021-10-29 | Thurston | Washington | 53067 | 20742 | 235 |
1861947 | 1861947 | 2021-10-28 | Thurston | Washington | 53067 | 20660 | 233 |
1858698 | 1858698 | 2021-10-27 | Thurston | Washington | 53067 | 20531 | 231 |
1855449 | 1855449 | 2021-10-26 | Thurston | Washington | 53067 | 20436 | 228 |
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);