ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 53035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177275 | 2177275 | 2022-02-02 | Kitsap | Washington | 53035 | 36042 | 282 |
2174022 | 2174022 | 2022-02-01 | Kitsap | Washington | 53035 | 35583 | 281 |
2170770 | 2170770 | 2022-01-31 | Kitsap | Washington | 53035 | 35583 | 281 |
2167517 | 2167517 | 2022-01-30 | Kitsap | Washington | 53035 | 34602 | 280 |
2164262 | 2164262 | 2022-01-29 | Kitsap | Washington | 53035 | 34602 | 280 |
2161007 | 2161007 | 2022-01-28 | Kitsap | Washington | 53035 | 34602 | 280 |
2157751 | 2157751 | 2022-01-27 | Kitsap | Washington | 53035 | 33464 | 275 |
2154498 | 2154498 | 2022-01-26 | Kitsap | Washington | 53035 | 33464 | 275 |
2151245 | 2151245 | 2022-01-25 | Kitsap | Washington | 53035 | 31186 | 269 |
2147993 | 2147993 | 2022-01-24 | Kitsap | Washington | 53035 | 31186 | 269 |
2144741 | 2144741 | 2022-01-23 | Kitsap | Washington | 53035 | 29502 | 269 |
2141486 | 2141486 | 2022-01-22 | Kitsap | Washington | 53035 | 29502 | 269 |
2138230 | 2138230 | 2022-01-21 | Kitsap | Washington | 53035 | 29502 | 269 |
2134975 | 2134975 | 2022-01-20 | Kitsap | Washington | 53035 | 29088 | 267 |
2131723 | 2131723 | 2022-01-19 | Kitsap | Washington | 53035 | 28466 | 264 |
2128469 | 2128469 | 2022-01-18 | Kitsap | Washington | 53035 | 27908 | 264 |
2125216 | 2125216 | 2022-01-17 | Kitsap | Washington | 53035 | 25853 | 265 |
2121964 | 2121964 | 2022-01-16 | Kitsap | Washington | 53035 | 25853 | 265 |
2118712 | 2118712 | 2022-01-15 | Kitsap | Washington | 53035 | 25853 | 265 |
2115460 | 2115460 | 2022-01-14 | Kitsap | Washington | 53035 | 25853 | 265 |
2112208 | 2112208 | 2022-01-13 | Kitsap | Washington | 53035 | 25428 | 265 |
2108956 | 2108956 | 2022-01-12 | Kitsap | Washington | 53035 | 25081 | 266 |
2105705 | 2105705 | 2022-01-11 | Kitsap | Washington | 53035 | 24443 | 265 |
2102454 | 2102454 | 2022-01-10 | Kitsap | Washington | 53035 | 23943 | 265 |
2099203 | 2099203 | 2022-01-09 | Kitsap | Washington | 53035 | 22445 | 265 |
2095952 | 2095952 | 2022-01-08 | Kitsap | Washington | 53035 | 22445 | 265 |
2092700 | 2092700 | 2022-01-07 | Kitsap | Washington | 53035 | 22445 | 265 |
2089448 | 2089448 | 2022-01-06 | Kitsap | Washington | 53035 | 21868 | 264 |
2086197 | 2086197 | 2022-01-05 | Kitsap | Washington | 53035 | 21583 | 263 |
2082945 | 2082945 | 2022-01-04 | Kitsap | Washington | 53035 | 21198 | 263 |
2079693 | 2079693 | 2022-01-03 | Kitsap | Washington | 53035 | 20956 | 264 |
2076441 | 2076441 | 2022-01-02 | Kitsap | Washington | 53035 | 20051 | 264 |
2073190 | 2073190 | 2022-01-01 | Kitsap | Washington | 53035 | 20051 | 264 |
2069939 | 2069939 | 2021-12-31 | Kitsap | Washington | 53035 | 20051 | 264 |
2066688 | 2066688 | 2021-12-30 | Kitsap | Washington | 53035 | 20051 | 264 |
2063438 | 2063438 | 2021-12-29 | Kitsap | Washington | 53035 | 19864 | 264 |
2060188 | 2060188 | 2021-12-28 | Kitsap | Washington | 53035 | 19740 | 264 |
2056939 | 2056939 | 2021-12-27 | Kitsap | Washington | 53035 | 19678 | 263 |
2053690 | 2053690 | 2021-12-26 | Kitsap | Washington | 53035 | 19210 | 263 |
2050440 | 2050440 | 2021-12-25 | Kitsap | Washington | 53035 | 19210 | 263 |
2047190 | 2047190 | 2021-12-24 | Kitsap | Washington | 53035 | 19210 | 263 |
2043940 | 2043940 | 2021-12-23 | Kitsap | Washington | 53035 | 19210 | 263 |
2040691 | 2040691 | 2021-12-22 | Kitsap | Washington | 53035 | 19126 | 262 |
2037441 | 2037441 | 2021-12-21 | Kitsap | Washington | 53035 | 19068 | 262 |
2034191 | 2034191 | 2021-12-20 | Kitsap | Washington | 53035 | 19042 | 262 |
2030941 | 2030941 | 2021-12-19 | Kitsap | Washington | 53035 | 18910 | 262 |
2027690 | 2027690 | 2021-12-18 | Kitsap | Washington | 53035 | 18910 | 262 |
2024439 | 2024439 | 2021-12-17 | Kitsap | Washington | 53035 | 18910 | 262 |
2021188 | 2021188 | 2021-12-16 | Kitsap | Washington | 53035 | 18844 | 263 |
2017937 | 2017937 | 2021-12-15 | Kitsap | Washington | 53035 | 18801 | 263 |
2014687 | 2014687 | 2021-12-14 | Kitsap | Washington | 53035 | 18755 | 258 |
2011436 | 2011436 | 2021-12-13 | Kitsap | Washington | 53035 | 18728 | 257 |
2008185 | 2008185 | 2021-12-12 | Kitsap | Washington | 53035 | 18640 | 255 |
2004934 | 2004934 | 2021-12-11 | Kitsap | Washington | 53035 | 18640 | 255 |
2001683 | 2001683 | 2021-12-10 | Kitsap | Washington | 53035 | 18640 | 255 |
1998433 | 1998433 | 2021-12-09 | Kitsap | Washington | 53035 | 18597 | 254 |
1995182 | 1995182 | 2021-12-08 | Kitsap | Washington | 53035 | 18543 | 253 |
1991931 | 1991931 | 2021-12-07 | Kitsap | Washington | 53035 | 18512 | 253 |
1988680 | 1988680 | 2021-12-06 | Kitsap | Washington | 53035 | 18454 | 252 |
1985430 | 1985430 | 2021-12-05 | Kitsap | Washington | 53035 | 18359 | 253 |
1982180 | 1982180 | 2021-12-04 | Kitsap | Washington | 53035 | 18359 | 253 |
1978930 | 1978930 | 2021-12-03 | Kitsap | Washington | 53035 | 18359 | 253 |
1975680 | 1975680 | 2021-12-02 | Kitsap | Washington | 53035 | 18301 | 251 |
1972431 | 1972431 | 2021-12-01 | Kitsap | Washington | 53035 | 18173 | 250 |
1969181 | 1969181 | 2021-11-30 | Kitsap | Washington | 53035 | 18173 | 250 |
1965931 | 1965931 | 2021-11-29 | Kitsap | Washington | 53035 | 18127 | 248 |
1962679 | 1962679 | 2021-11-28 | Kitsap | Washington | 53035 | 18010 | 247 |
1959428 | 1959428 | 2021-11-27 | Kitsap | Washington | 53035 | 18010 | 247 |
1956177 | 1956177 | 2021-11-26 | Kitsap | Washington | 53035 | 18010 | 247 |
1952926 | 1952926 | 2021-11-25 | Kitsap | Washington | 53035 | 18010 | 247 |
1949675 | 1949675 | 2021-11-24 | Kitsap | Washington | 53035 | 18010 | 247 |
1946424 | 1946424 | 2021-11-23 | Kitsap | Washington | 53035 | 17983 | 246 |
1943173 | 1943173 | 2021-11-22 | Kitsap | Washington | 53035 | 17951 | 246 |
1939923 | 1939923 | 2021-11-21 | Kitsap | Washington | 53035 | 17832 | 244 |
1936673 | 1936673 | 2021-11-20 | Kitsap | Washington | 53035 | 17832 | 244 |
1933423 | 1933423 | 2021-11-19 | Kitsap | Washington | 53035 | 17832 | 244 |
1930171 | 1930171 | 2021-11-18 | Kitsap | Washington | 53035 | 17775 | 244 |
1926921 | 1926921 | 2021-11-17 | Kitsap | Washington | 53035 | 17735 | 244 |
1923671 | 1923671 | 2021-11-16 | Kitsap | Washington | 53035 | 17676 | 244 |
1920422 | 1920422 | 2021-11-15 | Kitsap | Washington | 53035 | 17656 | 244 |
1917172 | 1917172 | 2021-11-14 | Kitsap | Washington | 53035 | 17522 | 240 |
1913922 | 1913922 | 2021-11-13 | Kitsap | Washington | 53035 | 17522 | 240 |
1910672 | 1910672 | 2021-11-12 | Kitsap | Washington | 53035 | 17522 | 240 |
1907423 | 1907423 | 2021-11-11 | Kitsap | Washington | 53035 | 17408 | 237 |
1904174 | 1904174 | 2021-11-10 | Kitsap | Washington | 53035 | 17408 | 237 |
1900924 | 1900924 | 2021-11-09 | Kitsap | Washington | 53035 | 17366 | 237 |
1897674 | 1897674 | 2021-11-08 | Kitsap | Washington | 53035 | 17322 | 237 |
1894424 | 1894424 | 2021-11-07 | Kitsap | Washington | 53035 | 17208 | 237 |
1891174 | 1891174 | 2021-11-06 | Kitsap | Washington | 53035 | 17208 | 237 |
1887924 | 1887924 | 2021-11-05 | Kitsap | Washington | 53035 | 17208 | 237 |
1884674 | 1884674 | 2021-11-04 | Kitsap | Washington | 53035 | 17162 | 237 |
1881425 | 1881425 | 2021-11-03 | Kitsap | Washington | 53035 | 17102 | 237 |
1878176 | 1878176 | 2021-11-02 | Kitsap | Washington | 53035 | 17075 | 237 |
1874927 | 1874927 | 2021-11-01 | Kitsap | Washington | 53035 | 17047 | 237 |
1871678 | 1871678 | 2021-10-31 | Kitsap | Washington | 53035 | 16920 | 238 |
1868429 | 1868429 | 2021-10-30 | Kitsap | Washington | 53035 | 16920 | 238 |
1865180 | 1865180 | 2021-10-29 | Kitsap | Washington | 53035 | 16920 | 238 |
1861931 | 1861931 | 2021-10-28 | Kitsap | Washington | 53035 | 16855 | 236 |
1858682 | 1858682 | 2021-10-27 | Kitsap | Washington | 53035 | 16802 | 234 |
1855433 | 1855433 | 2021-10-26 | Kitsap | Washington | 53035 | 16748 | 233 |
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);