ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
215 rows where deaths = 34 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
2063421 | 2063421 | 2021-12-29 | Adams | Washington | 53001 | 3420 | 34 |
2063440 | 2063440 | 2021-12-29 | Klickitat | Washington | 53039 | 2348 | 34 |
2060171 | 2060171 | 2021-12-28 | Adams | Washington | 53001 | 3415 | 34 |
2060190 | 2060190 | 2021-12-28 | Klickitat | Washington | 53039 | 2347 | 34 |
2056922 | 2056922 | 2021-12-27 | Adams | Washington | 53001 | 3412 | 34 |
2056941 | 2056941 | 2021-12-27 | Klickitat | Washington | 53039 | 2343 | 34 |
2053673 | 2053673 | 2021-12-26 | Adams | Washington | 53001 | 3409 | 34 |
2053692 | 2053692 | 2021-12-26 | Klickitat | Washington | 53039 | 2327 | 34 |
2050423 | 2050423 | 2021-12-25 | Adams | Washington | 53001 | 3409 | 34 |
2050442 | 2050442 | 2021-12-25 | Klickitat | Washington | 53039 | 2327 | 34 |
2047173 | 2047173 | 2021-12-24 | Adams | Washington | 53001 | 3409 | 34 |
2047192 | 2047192 | 2021-12-24 | Klickitat | Washington | 53039 | 2327 | 34 |
2043923 | 2043923 | 2021-12-23 | Adams | Washington | 53001 | 3409 | 34 |
2043942 | 2043942 | 2021-12-23 | Klickitat | Washington | 53039 | 2327 | 34 |
2040674 | 2040674 | 2021-12-22 | Adams | Washington | 53001 | 3405 | 34 |
2037424 | 2037424 | 2021-12-21 | Adams | Washington | 53001 | 3405 | 34 |
2034174 | 2034174 | 2021-12-20 | Adams | Washington | 53001 | 3404 | 34 |
2030924 | 2030924 | 2021-12-19 | Adams | Washington | 53001 | 3402 | 34 |
2027673 | 2027673 | 2021-12-18 | Adams | Washington | 53001 | 3402 | 34 |
2024422 | 2024422 | 2021-12-17 | Adams | Washington | 53001 | 3402 | 34 |
2021171 | 2021171 | 2021-12-16 | Adams | Washington | 53001 | 3394 | 34 |
2017920 | 2017920 | 2021-12-15 | Adams | Washington | 53001 | 3391 | 34 |
2014670 | 2014670 | 2021-12-14 | Adams | Washington | 53001 | 3390 | 34 |
2011419 | 2011419 | 2021-12-13 | Adams | Washington | 53001 | 3390 | 34 |
2008168 | 2008168 | 2021-12-12 | Adams | Washington | 53001 | 3383 | 34 |
2004917 | 2004917 | 2021-12-11 | Adams | Washington | 53001 | 3383 | 34 |
2001666 | 2001666 | 2021-12-10 | Adams | Washington | 53001 | 3383 | 34 |
1998416 | 1998416 | 2021-12-09 | Adams | Washington | 53001 | 3377 | 34 |
1995165 | 1995165 | 2021-12-08 | Adams | Washington | 53001 | 3376 | 34 |
1991914 | 1991914 | 2021-12-07 | Adams | Washington | 53001 | 3374 | 34 |
1988663 | 1988663 | 2021-12-06 | Adams | Washington | 53001 | 3374 | 34 |
1985413 | 1985413 | 2021-12-05 | Adams | Washington | 53001 | 3365 | 34 |
1982163 | 1982163 | 2021-12-04 | Adams | Washington | 53001 | 3365 | 34 |
1978913 | 1978913 | 2021-12-03 | Adams | Washington | 53001 | 3365 | 34 |
1975663 | 1975663 | 2021-12-02 | Adams | Washington | 53001 | 3363 | 34 |
1972414 | 1972414 | 2021-12-01 | Adams | Washington | 53001 | 3353 | 34 |
1969164 | 1969164 | 2021-11-30 | Adams | Washington | 53001 | 3353 | 34 |
1965914 | 1965914 | 2021-11-29 | Adams | Washington | 53001 | 3351 | 34 |
1965938 | 1965938 | 2021-11-29 | Pacific | Washington | 53049 | 1895 | 34 |
1962662 | 1962662 | 2021-11-28 | Adams | Washington | 53001 | 3341 | 34 |
1962686 | 1962686 | 2021-11-28 | Pacific | Washington | 53049 | 1884 | 34 |
1959411 | 1959411 | 2021-11-27 | Adams | Washington | 53001 | 3341 | 34 |
1959435 | 1959435 | 2021-11-27 | Pacific | Washington | 53049 | 1884 | 34 |
1956160 | 1956160 | 2021-11-26 | Adams | Washington | 53001 | 3341 | 34 |
1956184 | 1956184 | 2021-11-26 | Pacific | Washington | 53049 | 1884 | 34 |
1952909 | 1952909 | 2021-11-25 | Adams | Washington | 53001 | 3341 | 34 |
1952933 | 1952933 | 2021-11-25 | Pacific | Washington | 53049 | 1884 | 34 |
1949658 | 1949658 | 2021-11-24 | Adams | Washington | 53001 | 3341 | 34 |
1949682 | 1949682 | 2021-11-24 | Pacific | Washington | 53049 | 1884 | 34 |
1946407 | 1946407 | 2021-11-23 | Adams | Washington | 53001 | 3335 | 34 |
1946431 | 1946431 | 2021-11-23 | Pacific | Washington | 53049 | 1884 | 34 |
1943156 | 1943156 | 2021-11-22 | Adams | Washington | 53001 | 3333 | 34 |
1943180 | 1943180 | 2021-11-22 | Pacific | Washington | 53049 | 1881 | 34 |
1939906 | 1939906 | 2021-11-21 | Adams | Washington | 53001 | 3328 | 34 |
1939930 | 1939930 | 2021-11-21 | Pacific | Washington | 53049 | 1875 | 34 |
1936656 | 1936656 | 2021-11-20 | Adams | Washington | 53001 | 3328 | 34 |
1936680 | 1936680 | 2021-11-20 | Pacific | Washington | 53049 | 1875 | 34 |
1933406 | 1933406 | 2021-11-19 | Adams | Washington | 53001 | 3328 | 34 |
1933430 | 1933430 | 2021-11-19 | Pacific | Washington | 53049 | 1875 | 34 |
1930154 | 1930154 | 2021-11-18 | Adams | Washington | 53001 | 3322 | 34 |
1930178 | 1930178 | 2021-11-18 | Pacific | Washington | 53049 | 1872 | 34 |
1926904 | 1926904 | 2021-11-17 | Adams | Washington | 53001 | 3315 | 34 |
1926928 | 1926928 | 2021-11-17 | Pacific | Washington | 53049 | 1871 | 34 |
1923654 | 1923654 | 2021-11-16 | Adams | Washington | 53001 | 3315 | 34 |
1923678 | 1923678 | 2021-11-16 | Pacific | Washington | 53049 | 1866 | 34 |
1920405 | 1920405 | 2021-11-15 | Adams | Washington | 53001 | 3314 | 34 |
1920429 | 1920429 | 2021-11-15 | Pacific | Washington | 53049 | 1864 | 34 |
1917179 | 1917179 | 2021-11-14 | Pacific | Washington | 53049 | 1854 | 34 |
1913929 | 1913929 | 2021-11-13 | Pacific | Washington | 53049 | 1854 | 34 |
1910679 | 1910679 | 2021-11-12 | Pacific | Washington | 53049 | 1854 | 34 |
1809936 | 1809936 | 2021-10-12 | Douglas | Washington | 53017 | 5879 | 34 |
1806687 | 1806687 | 2021-10-11 | Douglas | Washington | 53017 | 5826 | 34 |
1803436 | 1803436 | 2021-10-10 | Douglas | Washington | 53017 | 5806 | 34 |
1800187 | 1800187 | 2021-10-09 | Douglas | Washington | 53017 | 5806 | 34 |
1796938 | 1796938 | 2021-10-08 | Douglas | Washington | 53017 | 5806 | 34 |
1793689 | 1793689 | 2021-10-07 | Douglas | Washington | 53017 | 5778 | 34 |
1692970 | 1692970 | 2021-09-06 | Asotin | Washington | 53003 | 2088 | 34 |
1689721 | 1689721 | 2021-09-05 | Asotin | Washington | 53003 | 2088 | 34 |
1686471 | 1686471 | 2021-09-04 | Asotin | Washington | 53003 | 2088 | 34 |
1683220 | 1683220 | 2021-09-03 | Asotin | Washington | 53003 | 2088 | 34 |
1679970 | 1679970 | 2021-09-02 | Asotin | Washington | 53003 | 2068 | 34 |
1676735 | 1676735 | 2021-09-01 | Island | Washington | 53029 | 2795 | 34 |
1673488 | 1673488 | 2021-08-31 | Island | Washington | 53029 | 2773 | 34 |
1670240 | 1670240 | 2021-08-30 | Island | Washington | 53029 | 2765 | 34 |
1670258 | 1670258 | 2021-08-30 | Stevens | Washington | 53065 | 3067 | 34 |
1666993 | 1666993 | 2021-08-29 | Island | Washington | 53029 | 2717 | 34 |
1667011 | 1667011 | 2021-08-29 | Stevens | Washington | 53065 | 3000 | 34 |
1663745 | 1663745 | 2021-08-28 | Island | Washington | 53029 | 2717 | 34 |
1663763 | 1663763 | 2021-08-28 | Stevens | Washington | 53065 | 3000 | 34 |
1660497 | 1660497 | 2021-08-27 | Island | Washington | 53029 | 2717 | 34 |
1660515 | 1660515 | 2021-08-27 | Stevens | Washington | 53065 | 3000 | 34 |
1657249 | 1657249 | 2021-08-26 | Island | Washington | 53029 | 2691 | 34 |
1657267 | 1657267 | 2021-08-26 | Stevens | Washington | 53065 | 2957 | 34 |
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);