ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
806 rows where fips = 53033 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177274 | 2177274 | 2022-02-02 | King | Washington | 53033 | 349214 | 2361 |
2174021 | 2174021 | 2022-02-01 | King | Washington | 53033 | 346077 | 2330 |
2170769 | 2170769 | 2022-01-31 | King | Washington | 53033 | 346077 | 2330 |
2167516 | 2167516 | 2022-01-30 | King | Washington | 53033 | 335376 | 2313 |
2164261 | 2164261 | 2022-01-29 | King | Washington | 53033 | 335376 | 2313 |
2161006 | 2161006 | 2022-01-28 | King | Washington | 53033 | 335376 | 2313 |
2157750 | 2157750 | 2022-01-27 | King | Washington | 53033 | 330897 | 2313 |
2154497 | 2154497 | 2022-01-26 | King | Washington | 53033 | 327961 | 2316 |
2151244 | 2151244 | 2022-01-25 | King | Washington | 53033 | 319375 | 2301 |
2147992 | 2147992 | 2022-01-24 | King | Washington | 53033 | 314592 | 2287 |
2144740 | 2144740 | 2022-01-23 | King | Washington | 53033 | 302926 | 2276 |
2141485 | 2141485 | 2022-01-22 | King | Washington | 53033 | 302926 | 2276 |
2138229 | 2138229 | 2022-01-21 | King | Washington | 53033 | 302926 | 2276 |
2134974 | 2134974 | 2022-01-20 | King | Washington | 53033 | 298790 | 2275 |
2131722 | 2131722 | 2022-01-19 | King | Washington | 53033 | 293253 | 2270 |
2128468 | 2128468 | 2022-01-18 | King | Washington | 53033 | 288810 | 2248 |
2125215 | 2125215 | 2022-01-17 | King | Washington | 53033 | 269433 | 2241 |
2121963 | 2121963 | 2022-01-16 | King | Washington | 53033 | 269433 | 2241 |
2118711 | 2118711 | 2022-01-15 | King | Washington | 53033 | 269433 | 2241 |
2115459 | 2115459 | 2022-01-14 | King | Washington | 53033 | 269433 | 2241 |
2112207 | 2112207 | 2022-01-13 | King | Washington | 53033 | 264209 | 2222 |
2108955 | 2108955 | 2022-01-12 | King | Washington | 53033 | 259422 | 2220 |
2105704 | 2105704 | 2022-01-11 | King | Washington | 53033 | 254174 | 2213 |
2102453 | 2102453 | 2022-01-10 | King | Washington | 53033 | 248777 | 2198 |
2099202 | 2099202 | 2022-01-09 | King | Washington | 53033 | 229984 | 2199 |
2095951 | 2095951 | 2022-01-08 | King | Washington | 53033 | 229984 | 2199 |
2092699 | 2092699 | 2022-01-07 | King | Washington | 53033 | 229984 | 2199 |
2089447 | 2089447 | 2022-01-06 | King | Washington | 53033 | 224612 | 2186 |
2086196 | 2086196 | 2022-01-05 | King | Washington | 53033 | 218918 | 2178 |
2082944 | 2082944 | 2022-01-04 | King | Washington | 53033 | 214904 | 2172 |
2079692 | 2079692 | 2022-01-03 | King | Washington | 53033 | 212295 | 2167 |
2076440 | 2076440 | 2022-01-02 | King | Washington | 53033 | 200875 | 2164 |
2073189 | 2073189 | 2022-01-01 | King | Washington | 53033 | 200875 | 2164 |
2069938 | 2069938 | 2021-12-31 | King | Washington | 53033 | 200875 | 2164 |
2066687 | 2066687 | 2021-12-30 | King | Washington | 53033 | 200875 | 2164 |
2063437 | 2063437 | 2021-12-29 | King | Washington | 53033 | 198517 | 2159 |
2060187 | 2060187 | 2021-12-28 | King | Washington | 53033 | 196625 | 2158 |
2056938 | 2056938 | 2021-12-27 | King | Washington | 53033 | 194215 | 2155 |
2053689 | 2053689 | 2021-12-26 | King | Washington | 53033 | 185916 | 2152 |
2050439 | 2050439 | 2021-12-25 | King | Washington | 53033 | 185916 | 2152 |
2047189 | 2047189 | 2021-12-24 | King | Washington | 53033 | 185916 | 2152 |
2043939 | 2043939 | 2021-12-23 | King | Washington | 53033 | 185916 | 2152 |
2040690 | 2040690 | 2021-12-22 | King | Washington | 53033 | 183037 | 2144 |
2037440 | 2037440 | 2021-12-21 | King | Washington | 53033 | 182420 | 2140 |
2034190 | 2034190 | 2021-12-20 | King | Washington | 53033 | 181570 | 2139 |
2030940 | 2030940 | 2021-12-19 | King | Washington | 53033 | 179396 | 2138 |
2027689 | 2027689 | 2021-12-18 | King | Washington | 53033 | 179396 | 2138 |
2024438 | 2024438 | 2021-12-17 | King | Washington | 53033 | 179396 | 2138 |
2021187 | 2021187 | 2021-12-16 | King | Washington | 53033 | 178703 | 2135 |
2017936 | 2017936 | 2021-12-15 | King | Washington | 53033 | 178066 | 2131 |
2014686 | 2014686 | 2021-12-14 | King | Washington | 53033 | 177616 | 2129 |
2011435 | 2011435 | 2021-12-13 | King | Washington | 53033 | 177441 | 2127 |
2008184 | 2008184 | 2021-12-12 | King | Washington | 53033 | 176450 | 2127 |
2004933 | 2004933 | 2021-12-11 | King | Washington | 53033 | 176450 | 2127 |
2001682 | 2001682 | 2021-12-10 | King | Washington | 53033 | 176450 | 2127 |
1998432 | 1998432 | 2021-12-09 | King | Washington | 53033 | 176320 | 2122 |
1995181 | 1995181 | 2021-12-08 | King | Washington | 53033 | 175671 | 2118 |
1991930 | 1991930 | 2021-12-07 | King | Washington | 53033 | 175548 | 2117 |
1988679 | 1988679 | 2021-12-06 | King | Washington | 53033 | 175160 | 2115 |
1985429 | 1985429 | 2021-12-05 | King | Washington | 53033 | 174550 | 2102 |
1982179 | 1982179 | 2021-12-04 | King | Washington | 53033 | 174550 | 2102 |
1978929 | 1978929 | 2021-12-03 | King | Washington | 53033 | 174550 | 2102 |
1975679 | 1975679 | 2021-12-02 | King | Washington | 53033 | 174158 | 2098 |
1972430 | 1972430 | 2021-12-01 | King | Washington | 53033 | 173948 | 2096 |
1969180 | 1969180 | 2021-11-30 | King | Washington | 53033 | 173130 | 2086 |
1965930 | 1965930 | 2021-11-29 | King | Washington | 53033 | 173060 | 2086 |
1962678 | 1962678 | 2021-11-28 | King | Washington | 53033 | 172009 | 2081 |
1959427 | 1959427 | 2021-11-27 | King | Washington | 53033 | 172009 | 2081 |
1956176 | 1956176 | 2021-11-26 | King | Washington | 53033 | 172009 | 2081 |
1952925 | 1952925 | 2021-11-25 | King | Washington | 53033 | 172009 | 2081 |
1949674 | 1949674 | 2021-11-24 | King | Washington | 53033 | 172009 | 2081 |
1946423 | 1946423 | 2021-11-23 | King | Washington | 53033 | 171837 | 2078 |
1943172 | 1943172 | 2021-11-22 | King | Washington | 53033 | 171717 | 2072 |
1939922 | 1939922 | 2021-11-21 | King | Washington | 53033 | 171009 | 2068 |
1936672 | 1936672 | 2021-11-20 | King | Washington | 53033 | 171009 | 2068 |
1933422 | 1933422 | 2021-11-19 | King | Washington | 53033 | 171009 | 2068 |
1930170 | 1930170 | 2021-11-18 | King | Washington | 53033 | 170722 | 2067 |
1926920 | 1926920 | 2021-11-17 | King | Washington | 53033 | 170363 | 2066 |
1923670 | 1923670 | 2021-11-16 | King | Washington | 53033 | 169923 | 2059 |
1920421 | 1920421 | 2021-11-15 | King | Washington | 53033 | 169719 | 2056 |
1917171 | 1917171 | 2021-11-14 | King | Washington | 53033 | 168884 | 2052 |
1913921 | 1913921 | 2021-11-13 | King | Washington | 53033 | 168884 | 2052 |
1910671 | 1910671 | 2021-11-12 | King | Washington | 53033 | 168884 | 2052 |
1907422 | 1907422 | 2021-11-11 | King | Washington | 53033 | 168323 | 2049 |
1904173 | 1904173 | 2021-11-10 | King | Washington | 53033 | 168323 | 2049 |
1900923 | 1900923 | 2021-11-09 | King | Washington | 53033 | 167817 | 2047 |
1897673 | 1897673 | 2021-11-08 | King | Washington | 53033 | 167661 | 2045 |
1894423 | 1894423 | 2021-11-07 | King | Washington | 53033 | 166674 | 2036 |
1891173 | 1891173 | 2021-11-06 | King | Washington | 53033 | 166674 | 2036 |
1887923 | 1887923 | 2021-11-05 | King | Washington | 53033 | 166674 | 2036 |
1884673 | 1884673 | 2021-11-04 | King | Washington | 53033 | 166421 | 2035 |
1881424 | 1881424 | 2021-11-03 | King | Washington | 53033 | 165899 | 2030 |
1878175 | 1878175 | 2021-11-02 | King | Washington | 53033 | 165512 | 2024 |
1874926 | 1874926 | 2021-11-01 | King | Washington | 53033 | 165186 | 2014 |
1871677 | 1871677 | 2021-10-31 | King | Washington | 53033 | 164221 | 2009 |
1868428 | 1868428 | 2021-10-30 | King | Washington | 53033 | 164221 | 2009 |
1865179 | 1865179 | 2021-10-29 | King | Washington | 53033 | 164221 | 2009 |
1861930 | 1861930 | 2021-10-28 | King | Washington | 53033 | 163797 | 2004 |
1858681 | 1858681 | 2021-10-27 | King | Washington | 53033 | 163093 | 2000 |
1855432 | 1855432 | 2021-10-26 | King | Washington | 53033 | 162711 | 1990 |
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);