ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Klickitat" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177277 | 2177277 | 2022-02-02 | Klickitat | Washington | 53039 | 3225 | 38 |
2174024 | 2174024 | 2022-02-01 | Klickitat | Washington | 53039 | 3154 | 38 |
2170772 | 2170772 | 2022-01-31 | Klickitat | Washington | 53039 | 3154 | 38 |
2167519 | 2167519 | 2022-01-30 | Klickitat | Washington | 53039 | 3017 | 37 |
2164264 | 2164264 | 2022-01-29 | Klickitat | Washington | 53039 | 3017 | 37 |
2161009 | 2161009 | 2022-01-28 | Klickitat | Washington | 53039 | 3017 | 37 |
2157753 | 2157753 | 2022-01-27 | Klickitat | Washington | 53039 | 2937 | 37 |
2154500 | 2154500 | 2022-01-26 | Klickitat | Washington | 53039 | 2937 | 37 |
2151247 | 2151247 | 2022-01-25 | Klickitat | Washington | 53039 | 2813 | 37 |
2147995 | 2147995 | 2022-01-24 | Klickitat | Washington | 53039 | 2813 | 37 |
2144743 | 2144743 | 2022-01-23 | Klickitat | Washington | 53039 | 2675 | 37 |
2141488 | 2141488 | 2022-01-22 | Klickitat | Washington | 53039 | 2675 | 37 |
2138232 | 2138232 | 2022-01-21 | Klickitat | Washington | 53039 | 2675 | 37 |
2134977 | 2134977 | 2022-01-20 | Klickitat | Washington | 53039 | 2631 | 37 |
2131725 | 2131725 | 2022-01-19 | Klickitat | Washington | 53039 | 2617 | 37 |
2128471 | 2128471 | 2022-01-18 | Klickitat | Washington | 53039 | 2591 | 37 |
2125218 | 2125218 | 2022-01-17 | Klickitat | Washington | 53039 | 2534 | 36 |
2121966 | 2121966 | 2022-01-16 | Klickitat | Washington | 53039 | 2534 | 36 |
2118714 | 2118714 | 2022-01-15 | Klickitat | Washington | 53039 | 2534 | 36 |
2115462 | 2115462 | 2022-01-14 | Klickitat | Washington | 53039 | 2534 | 36 |
2112210 | 2112210 | 2022-01-13 | Klickitat | Washington | 53039 | 2520 | 36 |
2108958 | 2108958 | 2022-01-12 | Klickitat | Washington | 53039 | 2506 | 36 |
2105707 | 2105707 | 2022-01-11 | Klickitat | Washington | 53039 | 2481 | 35 |
2102456 | 2102456 | 2022-01-10 | Klickitat | Washington | 53039 | 2462 | 35 |
2099205 | 2099205 | 2022-01-09 | Klickitat | Washington | 53039 | 2432 | 35 |
2095954 | 2095954 | 2022-01-08 | Klickitat | Washington | 53039 | 2432 | 35 |
2092702 | 2092702 | 2022-01-07 | Klickitat | Washington | 53039 | 2432 | 35 |
2089450 | 2089450 | 2022-01-06 | Klickitat | Washington | 53039 | 2417 | 35 |
2086199 | 2086199 | 2022-01-05 | Klickitat | Washington | 53039 | 2406 | 34 |
2082947 | 2082947 | 2022-01-04 | Klickitat | Washington | 53039 | 2407 | 34 |
2079695 | 2079695 | 2022-01-03 | Klickitat | Washington | 53039 | 2393 | 34 |
2076443 | 2076443 | 2022-01-02 | Klickitat | Washington | 53039 | 2358 | 34 |
2073192 | 2073192 | 2022-01-01 | Klickitat | Washington | 53039 | 2358 | 34 |
2069941 | 2069941 | 2021-12-31 | Klickitat | Washington | 53039 | 2358 | 34 |
2066690 | 2066690 | 2021-12-30 | Klickitat | Washington | 53039 | 2358 | 34 |
2063440 | 2063440 | 2021-12-29 | Klickitat | Washington | 53039 | 2348 | 34 |
2060190 | 2060190 | 2021-12-28 | Klickitat | Washington | 53039 | 2347 | 34 |
2056941 | 2056941 | 2021-12-27 | Klickitat | Washington | 53039 | 2343 | 34 |
2053692 | 2053692 | 2021-12-26 | Klickitat | Washington | 53039 | 2327 | 34 |
2050442 | 2050442 | 2021-12-25 | Klickitat | Washington | 53039 | 2327 | 34 |
2047192 | 2047192 | 2021-12-24 | Klickitat | Washington | 53039 | 2327 | 34 |
2043942 | 2043942 | 2021-12-23 | Klickitat | Washington | 53039 | 2327 | 34 |
2040693 | 2040693 | 2021-12-22 | Klickitat | Washington | 53039 | 2325 | 33 |
2037443 | 2037443 | 2021-12-21 | Klickitat | Washington | 53039 | 2324 | 31 |
2034193 | 2034193 | 2021-12-20 | Klickitat | Washington | 53039 | 2323 | 31 |
2030943 | 2030943 | 2021-12-19 | Klickitat | Washington | 53039 | 2321 | 31 |
2027692 | 2027692 | 2021-12-18 | Klickitat | Washington | 53039 | 2321 | 31 |
2024441 | 2024441 | 2021-12-17 | Klickitat | Washington | 53039 | 2321 | 31 |
2021190 | 2021190 | 2021-12-16 | Klickitat | Washington | 53039 | 2318 | 31 |
2017939 | 2017939 | 2021-12-15 | Klickitat | Washington | 53039 | 2315 | 31 |
2014689 | 2014689 | 2021-12-14 | Klickitat | Washington | 53039 | 2312 | 30 |
2011438 | 2011438 | 2021-12-13 | Klickitat | Washington | 53039 | 2308 | 30 |
2008187 | 2008187 | 2021-12-12 | Klickitat | Washington | 53039 | 2305 | 30 |
2004936 | 2004936 | 2021-12-11 | Klickitat | Washington | 53039 | 2305 | 30 |
2001685 | 2001685 | 2021-12-10 | Klickitat | Washington | 53039 | 2305 | 30 |
1998435 | 1998435 | 2021-12-09 | Klickitat | Washington | 53039 | 2301 | 30 |
1995184 | 1995184 | 2021-12-08 | Klickitat | Washington | 53039 | 2296 | 30 |
1991933 | 1991933 | 2021-12-07 | Klickitat | Washington | 53039 | 2294 | 30 |
1988682 | 1988682 | 2021-12-06 | Klickitat | Washington | 53039 | 2288 | 30 |
1985432 | 1985432 | 2021-12-05 | Klickitat | Washington | 53039 | 2275 | 30 |
1982182 | 1982182 | 2021-12-04 | Klickitat | Washington | 53039 | 2275 | 30 |
1978932 | 1978932 | 2021-12-03 | Klickitat | Washington | 53039 | 2275 | 30 |
1975682 | 1975682 | 2021-12-02 | Klickitat | Washington | 53039 | 2273 | 30 |
1972433 | 1972433 | 2021-12-01 | Klickitat | Washington | 53039 | 2260 | 30 |
1969183 | 1969183 | 2021-11-30 | Klickitat | Washington | 53039 | 2260 | 30 |
1965933 | 1965933 | 2021-11-29 | Klickitat | Washington | 53039 | 2258 | 30 |
1962681 | 1962681 | 2021-11-28 | Klickitat | Washington | 53039 | 2250 | 30 |
1959430 | 1959430 | 2021-11-27 | Klickitat | Washington | 53039 | 2250 | 30 |
1956179 | 1956179 | 2021-11-26 | Klickitat | Washington | 53039 | 2250 | 30 |
1952928 | 1952928 | 2021-11-25 | Klickitat | Washington | 53039 | 2250 | 30 |
1949677 | 1949677 | 2021-11-24 | Klickitat | Washington | 53039 | 2250 | 30 |
1946426 | 1946426 | 2021-11-23 | Klickitat | Washington | 53039 | 2245 | 27 |
1943175 | 1943175 | 2021-11-22 | Klickitat | Washington | 53039 | 2238 | 27 |
1939925 | 1939925 | 2021-11-21 | Klickitat | Washington | 53039 | 2226 | 26 |
1936675 | 1936675 | 2021-11-20 | Klickitat | Washington | 53039 | 2226 | 26 |
1933425 | 1933425 | 2021-11-19 | Klickitat | Washington | 53039 | 2226 | 26 |
1930173 | 1930173 | 2021-11-18 | Klickitat | Washington | 53039 | 2224 | 26 |
1926923 | 1926923 | 2021-11-17 | Klickitat | Washington | 53039 | 2221 | 26 |
1923673 | 1923673 | 2021-11-16 | Klickitat | Washington | 53039 | 2213 | 26 |
1920424 | 1920424 | 2021-11-15 | Klickitat | Washington | 53039 | 2200 | 25 |
1917174 | 1917174 | 2021-11-14 | Klickitat | Washington | 53039 | 2172 | 25 |
1913924 | 1913924 | 2021-11-13 | Klickitat | Washington | 53039 | 2172 | 25 |
1910674 | 1910674 | 2021-11-12 | Klickitat | Washington | 53039 | 2172 | 25 |
1907425 | 1907425 | 2021-11-11 | Klickitat | Washington | 53039 | 2143 | 24 |
1904176 | 1904176 | 2021-11-10 | Klickitat | Washington | 53039 | 2143 | 24 |
1900926 | 1900926 | 2021-11-09 | Klickitat | Washington | 53039 | 2140 | 24 |
1897676 | 1897676 | 2021-11-08 | Klickitat | Washington | 53039 | 2122 | 23 |
1894426 | 1894426 | 2021-11-07 | Klickitat | Washington | 53039 | 2099 | 23 |
1891176 | 1891176 | 2021-11-06 | Klickitat | Washington | 53039 | 2099 | 23 |
1887926 | 1887926 | 2021-11-05 | Klickitat | Washington | 53039 | 2099 | 23 |
1884676 | 1884676 | 2021-11-04 | Klickitat | Washington | 53039 | 2092 | 22 |
1881427 | 1881427 | 2021-11-03 | Klickitat | Washington | 53039 | 2079 | 22 |
1878178 | 1878178 | 2021-11-02 | Klickitat | Washington | 53039 | 2074 | 21 |
1874929 | 1874929 | 2021-11-01 | Klickitat | Washington | 53039 | 2064 | 18 |
1871680 | 1871680 | 2021-10-31 | Klickitat | Washington | 53039 | 2035 | 18 |
1868431 | 1868431 | 2021-10-30 | Klickitat | Washington | 53039 | 2035 | 18 |
1865182 | 1865182 | 2021-10-29 | Klickitat | Washington | 53039 | 2035 | 18 |
1861933 | 1861933 | 2021-10-28 | Klickitat | Washington | 53039 | 2018 | 18 |
1858684 | 1858684 | 2021-10-27 | Klickitat | Washington | 53039 | 2000 | 18 |
1855435 | 1855435 | 2021-10-26 | Klickitat | Washington | 53039 | 1987 | 18 |
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);