ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
806 rows where fips = 41067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176460 | 2176460 | 2022-02-02 | Washington | Oregon | 41067 | 77862 | 481 |
2173206 | 2173206 | 2022-02-01 | Washington | Oregon | 41067 | 77335 | 475 |
2169954 | 2169954 | 2022-01-31 | Washington | Oregon | 41067 | 76872 | 474 |
2166700 | 2166700 | 2022-01-30 | Washington | Oregon | 41067 | 75131 | 472 |
2163445 | 2163445 | 2022-01-29 | Washington | Oregon | 41067 | 75131 | 472 |
2160190 | 2160190 | 2022-01-28 | Washington | Oregon | 41067 | 75131 | 472 |
2156934 | 2156934 | 2022-01-27 | Washington | Oregon | 41067 | 74169 | 472 |
2153681 | 2153681 | 2022-01-26 | Washington | Oregon | 41067 | 73233 | 471 |
2150429 | 2150429 | 2022-01-25 | Washington | Oregon | 41067 | 72322 | 469 |
2147177 | 2147177 | 2022-01-24 | Washington | Oregon | 41067 | 71639 | 465 |
2143923 | 2143923 | 2022-01-23 | Washington | Oregon | 41067 | 68918 | 461 |
2140668 | 2140668 | 2022-01-22 | Washington | Oregon | 41067 | 68918 | 461 |
2137412 | 2137412 | 2022-01-21 | Washington | Oregon | 41067 | 68918 | 461 |
2134158 | 2134158 | 2022-01-20 | Washington | Oregon | 41067 | 67637 | 461 |
2130906 | 2130906 | 2022-01-19 | Washington | Oregon | 41067 | 66239 | 461 |
2127652 | 2127652 | 2022-01-18 | Washington | Oregon | 41067 | 65280 | 460 |
2124400 | 2124400 | 2022-01-17 | Washington | Oregon | 41067 | 61187 | 460 |
2121148 | 2121148 | 2022-01-16 | Washington | Oregon | 41067 | 61187 | 460 |
2117896 | 2117896 | 2022-01-15 | Washington | Oregon | 41067 | 61187 | 460 |
2114645 | 2114645 | 2022-01-14 | Washington | Oregon | 41067 | 61187 | 460 |
2111393 | 2111393 | 2022-01-13 | Washington | Oregon | 41067 | 60003 | 460 |
2108141 | 2108141 | 2022-01-12 | Washington | Oregon | 41067 | 58490 | 459 |
2104890 | 2104890 | 2022-01-11 | Washington | Oregon | 41067 | 57331 | 459 |
2101639 | 2101639 | 2022-01-10 | Washington | Oregon | 41067 | 56228 | 453 |
2098388 | 2098388 | 2022-01-09 | Washington | Oregon | 41067 | 52451 | 453 |
2095136 | 2095136 | 2022-01-08 | Washington | Oregon | 41067 | 52451 | 453 |
2091884 | 2091884 | 2022-01-07 | Washington | Oregon | 41067 | 52451 | 453 |
2088632 | 2088632 | 2022-01-06 | Washington | Oregon | 41067 | 50563 | 451 |
2085381 | 2085381 | 2022-01-05 | Washington | Oregon | 41067 | 49230 | 451 |
2082129 | 2082129 | 2022-01-04 | Washington | Oregon | 41067 | 48356 | 450 |
2078877 | 2078877 | 2022-01-03 | Washington | Oregon | 41067 | 47745 | 443 |
2075626 | 2075626 | 2022-01-02 | Washington | Oregon | 41067 | 45682 | 442 |
2072375 | 2072375 | 2022-01-01 | Washington | Oregon | 41067 | 45682 | 442 |
2069124 | 2069124 | 2021-12-31 | Washington | Oregon | 41067 | 45682 | 442 |
2065873 | 2065873 | 2021-12-30 | Washington | Oregon | 41067 | 45682 | 442 |
2062623 | 2062623 | 2021-12-29 | Washington | Oregon | 41067 | 45266 | 440 |
2059373 | 2059373 | 2021-12-28 | Washington | Oregon | 41067 | 44987 | 440 |
2056124 | 2056124 | 2021-12-27 | Washington | Oregon | 41067 | 44774 | 440 |
2052875 | 2052875 | 2021-12-26 | Washington | Oregon | 41067 | 44235 | 439 |
2049625 | 2049625 | 2021-12-25 | Washington | Oregon | 41067 | 44235 | 439 |
2046375 | 2046375 | 2021-12-24 | Washington | Oregon | 41067 | 44235 | 439 |
2043125 | 2043125 | 2021-12-23 | Washington | Oregon | 41067 | 44235 | 439 |
2039876 | 2039876 | 2021-12-22 | Washington | Oregon | 41067 | 44077 | 437 |
2036626 | 2036626 | 2021-12-21 | Washington | Oregon | 41067 | 43964 | 434 |
2033376 | 2033376 | 2021-12-20 | Washington | Oregon | 41067 | 43875 | 429 |
2030126 | 2030126 | 2021-12-19 | Washington | Oregon | 41067 | 43614 | 429 |
2026875 | 2026875 | 2021-12-18 | Washington | Oregon | 41067 | 43614 | 429 |
2023624 | 2023624 | 2021-12-17 | Washington | Oregon | 41067 | 43614 | 429 |
2020373 | 2020373 | 2021-12-16 | Washington | Oregon | 41067 | 43471 | 428 |
2017122 | 2017122 | 2021-12-15 | Washington | Oregon | 41067 | 43352 | 427 |
2013872 | 2013872 | 2021-12-14 | Washington | Oregon | 41067 | 43267 | 426 |
2010621 | 2010621 | 2021-12-13 | Washington | Oregon | 41067 | 43185 | 418 |
2007370 | 2007370 | 2021-12-12 | Washington | Oregon | 41067 | 42997 | 415 |
2004119 | 2004119 | 2021-12-11 | Washington | Oregon | 41067 | 42997 | 415 |
2000868 | 2000868 | 2021-12-10 | Washington | Oregon | 41067 | 42997 | 415 |
1997618 | 1997618 | 2021-12-09 | Washington | Oregon | 41067 | 42911 | 413 |
1994367 | 1994367 | 2021-12-08 | Washington | Oregon | 41067 | 42807 | 409 |
1991116 | 1991116 | 2021-12-07 | Washington | Oregon | 41067 | 42725 | 408 |
1987865 | 1987865 | 2021-12-06 | Washington | Oregon | 41067 | 42631 | 406 |
1984615 | 1984615 | 2021-12-05 | Washington | Oregon | 41067 | 42359 | 405 |
1981365 | 1981365 | 2021-12-04 | Washington | Oregon | 41067 | 42359 | 405 |
1978115 | 1978115 | 2021-12-03 | Washington | Oregon | 41067 | 42359 | 405 |
1974865 | 1974865 | 2021-12-02 | Washington | Oregon | 41067 | 42197 | 402 |
1971616 | 1971616 | 2021-12-01 | Washington | Oregon | 41067 | 42082 | 398 |
1968366 | 1968366 | 2021-11-30 | Washington | Oregon | 41067 | 41981 | 395 |
1965115 | 1965115 | 2021-11-29 | Washington | Oregon | 41067 | 41910 | 395 |
1961863 | 1961863 | 2021-11-28 | Washington | Oregon | 41067 | 41571 | 393 |
1958612 | 1958612 | 2021-11-27 | Washington | Oregon | 41067 | 41571 | 393 |
1955361 | 1955361 | 2021-11-26 | Washington | Oregon | 41067 | 41571 | 393 |
1952110 | 1952110 | 2021-11-25 | Washington | Oregon | 41067 | 41571 | 393 |
1948859 | 1948859 | 2021-11-24 | Washington | Oregon | 41067 | 41571 | 393 |
1945608 | 1945608 | 2021-11-23 | Washington | Oregon | 41067 | 41476 | 389 |
1942357 | 1942357 | 2021-11-22 | Washington | Oregon | 41067 | 41404 | 382 |
1939107 | 1939107 | 2021-11-21 | Washington | Oregon | 41067 | 41249 | 380 |
1935857 | 1935857 | 2021-11-20 | Washington | Oregon | 41067 | 41249 | 380 |
1932607 | 1932607 | 2021-11-19 | Washington | Oregon | 41067 | 41249 | 380 |
1929356 | 1929356 | 2021-11-18 | Washington | Oregon | 41067 | 41144 | 379 |
1926106 | 1926106 | 2021-11-17 | Washington | Oregon | 41067 | 41036 | 376 |
1922856 | 1922856 | 2021-11-16 | Washington | Oregon | 41067 | 40961 | 374 |
1919607 | 1919607 | 2021-11-15 | Washington | Oregon | 41067 | 40877 | 372 |
1916357 | 1916357 | 2021-11-14 | Washington | Oregon | 41067 | 40695 | 364 |
1913107 | 1913107 | 2021-11-13 | Washington | Oregon | 41067 | 40695 | 364 |
1909857 | 1909857 | 2021-11-12 | Washington | Oregon | 41067 | 40695 | 364 |
1906608 | 1906608 | 2021-11-11 | Washington | Oregon | 41067 | 40529 | 360 |
1903359 | 1903359 | 2021-11-10 | Washington | Oregon | 41067 | 40529 | 360 |
1900109 | 1900109 | 2021-11-09 | Washington | Oregon | 41067 | 40431 | 353 |
1896859 | 1896859 | 2021-11-08 | Washington | Oregon | 41067 | 40371 | 351 |
1893609 | 1893609 | 2021-11-07 | Washington | Oregon | 41067 | 40121 | 342 |
1890359 | 1890359 | 2021-11-06 | Washington | Oregon | 41067 | 40121 | 342 |
1887109 | 1887109 | 2021-11-05 | Washington | Oregon | 41067 | 40121 | 342 |
1883859 | 1883859 | 2021-11-04 | Washington | Oregon | 41067 | 40008 | 341 |
1880610 | 1880610 | 2021-11-03 | Washington | Oregon | 41067 | 39905 | 336 |
1877361 | 1877361 | 2021-11-02 | Washington | Oregon | 41067 | 39774 | 329 |
1874112 | 1874112 | 2021-11-01 | Washington | Oregon | 41067 | 39692 | 327 |
1870863 | 1870863 | 2021-10-31 | Washington | Oregon | 41067 | 39422 | 327 |
1867614 | 1867614 | 2021-10-30 | Washington | Oregon | 41067 | 39422 | 327 |
1864365 | 1864365 | 2021-10-29 | Washington | Oregon | 41067 | 39422 | 327 |
1861116 | 1861116 | 2021-10-28 | Washington | Oregon | 41067 | 39280 | 327 |
1857867 | 1857867 | 2021-10-27 | Washington | Oregon | 41067 | 39207 | 326 |
1854618 | 1854618 | 2021-10-26 | Washington | Oregon | 41067 | 39109 | 325 |
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);