ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 53045 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- …
state 1
- Washington · 688 ✖
fips 1
- 53045 · 688 ✖
county 1
- Mason 688
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177280 | 2177280 | 2022-02-02 | Mason | Washington | 53045 | 11035 | 117 |
2174027 | 2174027 | 2022-02-01 | Mason | Washington | 53045 | 10799 | 113 |
2170775 | 2170775 | 2022-01-31 | Mason | Washington | 53045 | 10799 | 113 |
2167522 | 2167522 | 2022-01-30 | Mason | Washington | 53045 | 10307 | 113 |
2164267 | 2164267 | 2022-01-29 | Mason | Washington | 53045 | 10307 | 113 |
2161012 | 2161012 | 2022-01-28 | Mason | Washington | 53045 | 10307 | 113 |
2157756 | 2157756 | 2022-01-27 | Mason | Washington | 53045 | 10053 | 111 |
2154503 | 2154503 | 2022-01-26 | Mason | Washington | 53045 | 10053 | 111 |
2151250 | 2151250 | 2022-01-25 | Mason | Washington | 53045 | 9789 | 108 |
2147998 | 2147998 | 2022-01-24 | Mason | Washington | 53045 | 9789 | 108 |
2144746 | 2144746 | 2022-01-23 | Mason | Washington | 53045 | 9322 | 106 |
2141491 | 2141491 | 2022-01-22 | Mason | Washington | 53045 | 9322 | 106 |
2138235 | 2138235 | 2022-01-21 | Mason | Washington | 53045 | 9322 | 106 |
2134980 | 2134980 | 2022-01-20 | Mason | Washington | 53045 | 9139 | 104 |
2131728 | 2131728 | 2022-01-19 | Mason | Washington | 53045 | 9040 | 104 |
2128474 | 2128474 | 2022-01-18 | Mason | Washington | 53045 | 8933 | 104 |
2125221 | 2125221 | 2022-01-17 | Mason | Washington | 53045 | 8420 | 104 |
2121969 | 2121969 | 2022-01-16 | Mason | Washington | 53045 | 8420 | 104 |
2118717 | 2118717 | 2022-01-15 | Mason | Washington | 53045 | 8420 | 104 |
2115465 | 2115465 | 2022-01-14 | Mason | Washington | 53045 | 8420 | 104 |
2112213 | 2112213 | 2022-01-13 | Mason | Washington | 53045 | 8333 | 104 |
2108961 | 2108961 | 2022-01-12 | Mason | Washington | 53045 | 8093 | 103 |
2105710 | 2105710 | 2022-01-11 | Mason | Washington | 53045 | 7993 | 102 |
2102459 | 2102459 | 2022-01-10 | Mason | Washington | 53045 | 7841 | 102 |
2099208 | 2099208 | 2022-01-09 | Mason | Washington | 53045 | 7479 | 101 |
2095957 | 2095957 | 2022-01-08 | Mason | Washington | 53045 | 7479 | 101 |
2092705 | 2092705 | 2022-01-07 | Mason | Washington | 53045 | 7479 | 101 |
2089453 | 2089453 | 2022-01-06 | Mason | Washington | 53045 | 7343 | 100 |
2086202 | 2086202 | 2022-01-05 | Mason | Washington | 53045 | 7283 | 95 |
2082950 | 2082950 | 2022-01-04 | Mason | Washington | 53045 | 7206 | 95 |
2079698 | 2079698 | 2022-01-03 | Mason | Washington | 53045 | 7184 | 93 |
2076446 | 2076446 | 2022-01-02 | Mason | Washington | 53045 | 6968 | 93 |
2073195 | 2073195 | 2022-01-01 | Mason | Washington | 53045 | 6968 | 93 |
2069944 | 2069944 | 2021-12-31 | Mason | Washington | 53045 | 6968 | 93 |
2066693 | 2066693 | 2021-12-30 | Mason | Washington | 53045 | 6968 | 93 |
2063443 | 2063443 | 2021-12-29 | Mason | Washington | 53045 | 6936 | 93 |
2060193 | 2060193 | 2021-12-28 | Mason | Washington | 53045 | 6922 | 93 |
2056944 | 2056944 | 2021-12-27 | Mason | Washington | 53045 | 6920 | 93 |
2053695 | 2053695 | 2021-12-26 | Mason | Washington | 53045 | 6827 | 93 |
2050445 | 2050445 | 2021-12-25 | Mason | Washington | 53045 | 6827 | 93 |
2047195 | 2047195 | 2021-12-24 | Mason | Washington | 53045 | 6827 | 93 |
2043945 | 2043945 | 2021-12-23 | Mason | Washington | 53045 | 6827 | 93 |
2040696 | 2040696 | 2021-12-22 | Mason | Washington | 53045 | 6800 | 91 |
2037446 | 2037446 | 2021-12-21 | Mason | Washington | 53045 | 6787 | 91 |
2034196 | 2034196 | 2021-12-20 | Mason | Washington | 53045 | 6779 | 89 |
2030946 | 2030946 | 2021-12-19 | Mason | Washington | 53045 | 6752 | 88 |
2027695 | 2027695 | 2021-12-18 | Mason | Washington | 53045 | 6752 | 88 |
2024444 | 2024444 | 2021-12-17 | Mason | Washington | 53045 | 6752 | 88 |
2021193 | 2021193 | 2021-12-16 | Mason | Washington | 53045 | 6748 | 88 |
2017942 | 2017942 | 2021-12-15 | Mason | Washington | 53045 | 6670 | 85 |
2014692 | 2014692 | 2021-12-14 | Mason | Washington | 53045 | 6663 | 85 |
2011441 | 2011441 | 2021-12-13 | Mason | Washington | 53045 | 6656 | 85 |
2008190 | 2008190 | 2021-12-12 | Mason | Washington | 53045 | 6619 | 85 |
2004939 | 2004939 | 2021-12-11 | Mason | Washington | 53045 | 6619 | 85 |
2001688 | 2001688 | 2021-12-10 | Mason | Washington | 53045 | 6619 | 85 |
1998438 | 1998438 | 2021-12-09 | Mason | Washington | 53045 | 6608 | 85 |
1995187 | 1995187 | 2021-12-08 | Mason | Washington | 53045 | 6580 | 84 |
1991936 | 1991936 | 2021-12-07 | Mason | Washington | 53045 | 6571 | 84 |
1988685 | 1988685 | 2021-12-06 | Mason | Washington | 53045 | 6546 | 84 |
1985435 | 1985435 | 2021-12-05 | Mason | Washington | 53045 | 6510 | 83 |
1982185 | 1982185 | 2021-12-04 | Mason | Washington | 53045 | 6510 | 83 |
1978935 | 1978935 | 2021-12-03 | Mason | Washington | 53045 | 6510 | 83 |
1975685 | 1975685 | 2021-12-02 | Mason | Washington | 53045 | 6483 | 82 |
1972436 | 1972436 | 2021-12-01 | Mason | Washington | 53045 | 6441 | 81 |
1969186 | 1969186 | 2021-11-30 | Mason | Washington | 53045 | 6441 | 81 |
1965936 | 1965936 | 2021-11-29 | Mason | Washington | 53045 | 6433 | 81 |
1962684 | 1962684 | 2021-11-28 | Mason | Washington | 53045 | 6365 | 80 |
1959433 | 1959433 | 2021-11-27 | Mason | Washington | 53045 | 6365 | 80 |
1956182 | 1956182 | 2021-11-26 | Mason | Washington | 53045 | 6365 | 80 |
1952931 | 1952931 | 2021-11-25 | Mason | Washington | 53045 | 6365 | 80 |
1949680 | 1949680 | 2021-11-24 | Mason | Washington | 53045 | 6365 | 80 |
1946429 | 1946429 | 2021-11-23 | Mason | Washington | 53045 | 6364 | 80 |
1943178 | 1943178 | 2021-11-22 | Mason | Washington | 53045 | 6358 | 80 |
1939928 | 1939928 | 2021-11-21 | Mason | Washington | 53045 | 6291 | 80 |
1936678 | 1936678 | 2021-11-20 | Mason | Washington | 53045 | 6291 | 80 |
1933428 | 1933428 | 2021-11-19 | Mason | Washington | 53045 | 6291 | 80 |
1930176 | 1930176 | 2021-11-18 | Mason | Washington | 53045 | 6252 | 80 |
1926926 | 1926926 | 2021-11-17 | Mason | Washington | 53045 | 6240 | 80 |
1923676 | 1923676 | 2021-11-16 | Mason | Washington | 53045 | 6233 | 79 |
1920427 | 1920427 | 2021-11-15 | Mason | Washington | 53045 | 6229 | 77 |
1917177 | 1917177 | 2021-11-14 | Mason | Washington | 53045 | 6161 | 74 |
1913927 | 1913927 | 2021-11-13 | Mason | Washington | 53045 | 6161 | 74 |
1910677 | 1910677 | 2021-11-12 | Mason | Washington | 53045 | 6161 | 74 |
1907428 | 1907428 | 2021-11-11 | Mason | Washington | 53045 | 6110 | 74 |
1904179 | 1904179 | 2021-11-10 | Mason | Washington | 53045 | 6110 | 74 |
1900929 | 1900929 | 2021-11-09 | Mason | Washington | 53045 | 6098 | 74 |
1897679 | 1897679 | 2021-11-08 | Mason | Washington | 53045 | 6090 | 73 |
1894429 | 1894429 | 2021-11-07 | Mason | Washington | 53045 | 6027 | 73 |
1891179 | 1891179 | 2021-11-06 | Mason | Washington | 53045 | 6027 | 73 |
1887929 | 1887929 | 2021-11-05 | Mason | Washington | 53045 | 6027 | 73 |
1884679 | 1884679 | 2021-11-04 | Mason | Washington | 53045 | 6007 | 72 |
1881430 | 1881430 | 2021-11-03 | Mason | Washington | 53045 | 5981 | 72 |
1878181 | 1878181 | 2021-11-02 | Mason | Washington | 53045 | 5967 | 72 |
1874932 | 1874932 | 2021-11-01 | Mason | Washington | 53045 | 5955 | 72 |
1871683 | 1871683 | 2021-10-31 | Mason | Washington | 53045 | 5891 | 71 |
1868434 | 1868434 | 2021-10-30 | Mason | Washington | 53045 | 5891 | 71 |
1865185 | 1865185 | 2021-10-29 | Mason | Washington | 53045 | 5891 | 71 |
1861936 | 1861936 | 2021-10-28 | Mason | Washington | 53045 | 5871 | 71 |
1858687 | 1858687 | 2021-10-27 | Mason | Washington | 53045 | 5820 | 69 |
1855438 | 1855438 | 2021-10-26 | Mason | Washington | 53045 | 5811 | 68 |
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);