ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 53077 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177296 | 2177296 | 2022-02-02 | Yakima | Washington | 53077 | 68459 | 687 |
2174043 | 2174043 | 2022-02-01 | Yakima | Washington | 53077 | 68107 | 686 |
2170791 | 2170791 | 2022-01-31 | Yakima | Washington | 53077 | 67874 | 686 |
2167538 | 2167538 | 2022-01-30 | Yakima | Washington | 53077 | 66443 | 683 |
2164283 | 2164283 | 2022-01-29 | Yakima | Washington | 53077 | 66443 | 683 |
2161028 | 2161028 | 2022-01-28 | Yakima | Washington | 53077 | 66443 | 683 |
2157772 | 2157772 | 2022-01-27 | Yakima | Washington | 53077 | 65062 | 677 |
2154519 | 2154519 | 2022-01-26 | Yakima | Washington | 53077 | 63784 | 677 |
2151266 | 2151266 | 2022-01-25 | Yakima | Washington | 53077 | 63015 | 674 |
2148014 | 2148014 | 2022-01-24 | Yakima | Washington | 53077 | 62594 | 674 |
2144762 | 2144762 | 2022-01-23 | Yakima | Washington | 53077 | 59962 | 672 |
2141507 | 2141507 | 2022-01-22 | Yakima | Washington | 53077 | 59962 | 672 |
2138251 | 2138251 | 2022-01-21 | Yakima | Washington | 53077 | 59962 | 672 |
2134996 | 2134996 | 2022-01-20 | Yakima | Washington | 53077 | 58962 | 671 |
2131744 | 2131744 | 2022-01-19 | Yakima | Washington | 53077 | 57893 | 668 |
2128490 | 2128490 | 2022-01-18 | Yakima | Washington | 53077 | 57300 | 668 |
2125237 | 2125237 | 2022-01-17 | Yakima | Washington | 53077 | 54191 | 668 |
2121985 | 2121985 | 2022-01-16 | Yakima | Washington | 53077 | 54191 | 668 |
2118733 | 2118733 | 2022-01-15 | Yakima | Washington | 53077 | 54191 | 668 |
2115481 | 2115481 | 2022-01-14 | Yakima | Washington | 53077 | 54191 | 668 |
2112229 | 2112229 | 2022-01-13 | Yakima | Washington | 53077 | 53743 | 669 |
2108977 | 2108977 | 2022-01-12 | Yakima | Washington | 53077 | 53004 | 665 |
2105726 | 2105726 | 2022-01-11 | Yakima | Washington | 53077 | 52302 | 661 |
2102475 | 2102475 | 2022-01-10 | Yakima | Washington | 53077 | 51722 | 661 |
2099224 | 2099224 | 2022-01-09 | Yakima | Washington | 53077 | 50642 | 660 |
2095973 | 2095973 | 2022-01-08 | Yakima | Washington | 53077 | 50642 | 660 |
2092721 | 2092721 | 2022-01-07 | Yakima | Washington | 53077 | 50642 | 660 |
2089469 | 2089469 | 2022-01-06 | Yakima | Washington | 53077 | 50120 | 660 |
2086218 | 2086218 | 2022-01-05 | Yakima | Washington | 53077 | 49651 | 658 |
2082966 | 2082966 | 2022-01-04 | Yakima | Washington | 53077 | 49361 | 658 |
2079714 | 2079714 | 2022-01-03 | Yakima | Washington | 53077 | 49052 | 656 |
2076462 | 2076462 | 2022-01-02 | Yakima | Washington | 53077 | 48370 | 656 |
2073211 | 2073211 | 2022-01-01 | Yakima | Washington | 53077 | 48370 | 656 |
2069960 | 2069960 | 2021-12-31 | Yakima | Washington | 53077 | 48370 | 656 |
2066709 | 2066709 | 2021-12-30 | Yakima | Washington | 53077 | 48370 | 656 |
2063459 | 2063459 | 2021-12-29 | Yakima | Washington | 53077 | 48164 | 655 |
2060209 | 2060209 | 2021-12-28 | Yakima | Washington | 53077 | 48020 | 655 |
2056960 | 2056960 | 2021-12-27 | Yakima | Washington | 53077 | 47936 | 654 |
2053711 | 2053711 | 2021-12-26 | Yakima | Washington | 53077 | 47727 | 654 |
2050461 | 2050461 | 2021-12-25 | Yakima | Washington | 53077 | 47727 | 654 |
2047211 | 2047211 | 2021-12-24 | Yakima | Washington | 53077 | 47727 | 654 |
2043961 | 2043961 | 2021-12-23 | Yakima | Washington | 53077 | 47727 | 654 |
2040712 | 2040712 | 2021-12-22 | Yakima | Washington | 53077 | 47667 | 651 |
2037462 | 2037462 | 2021-12-21 | Yakima | Washington | 53077 | 47639 | 651 |
2034212 | 2034212 | 2021-12-20 | Yakima | Washington | 53077 | 47607 | 650 |
2030962 | 2030962 | 2021-12-19 | Yakima | Washington | 53077 | 47559 | 650 |
2027711 | 2027711 | 2021-12-18 | Yakima | Washington | 53077 | 47559 | 650 |
2024460 | 2024460 | 2021-12-17 | Yakima | Washington | 53077 | 47559 | 650 |
2021209 | 2021209 | 2021-12-16 | Yakima | Washington | 53077 | 47526 | 649 |
2017958 | 2017958 | 2021-12-15 | Yakima | Washington | 53077 | 47477 | 649 |
2014708 | 2014708 | 2021-12-14 | Yakima | Washington | 53077 | 47436 | 648 |
2011457 | 2011457 | 2021-12-13 | Yakima | Washington | 53077 | 47410 | 647 |
2008206 | 2008206 | 2021-12-12 | Yakima | Washington | 53077 | 47328 | 642 |
2004955 | 2004955 | 2021-12-11 | Yakima | Washington | 53077 | 47328 | 642 |
2001704 | 2001704 | 2021-12-10 | Yakima | Washington | 53077 | 47328 | 642 |
1998454 | 1998454 | 2021-12-09 | Yakima | Washington | 53077 | 47288 | 642 |
1995203 | 1995203 | 2021-12-08 | Yakima | Washington | 53077 | 47222 | 640 |
1991952 | 1991952 | 2021-12-07 | Yakima | Washington | 53077 | 47203 | 636 |
1988701 | 1988701 | 2021-12-06 | Yakima | Washington | 53077 | 47155 | 635 |
1985451 | 1985451 | 2021-12-05 | Yakima | Washington | 53077 | 47053 | 635 |
1982201 | 1982201 | 2021-12-04 | Yakima | Washington | 53077 | 47053 | 635 |
1978951 | 1978951 | 2021-12-03 | Yakima | Washington | 53077 | 47053 | 635 |
1975701 | 1975701 | 2021-12-02 | Yakima | Washington | 53077 | 46989 | 635 |
1972452 | 1972452 | 2021-12-01 | Yakima | Washington | 53077 | 46888 | 634 |
1969202 | 1969202 | 2021-11-30 | Yakima | Washington | 53077 | 46835 | 634 |
1965952 | 1965952 | 2021-11-29 | Yakima | Washington | 53077 | 46783 | 631 |
1962700 | 1962700 | 2021-11-28 | Yakima | Washington | 53077 | 46605 | 628 |
1959449 | 1959449 | 2021-11-27 | Yakima | Washington | 53077 | 46605 | 628 |
1956198 | 1956198 | 2021-11-26 | Yakima | Washington | 53077 | 46605 | 628 |
1952947 | 1952947 | 2021-11-25 | Yakima | Washington | 53077 | 46605 | 628 |
1949696 | 1949696 | 2021-11-24 | Yakima | Washington | 53077 | 46605 | 628 |
1946445 | 1946445 | 2021-11-23 | Yakima | Washington | 53077 | 46569 | 627 |
1943194 | 1943194 | 2021-11-22 | Yakima | Washington | 53077 | 46505 | 622 |
1939944 | 1939944 | 2021-11-21 | Yakima | Washington | 53077 | 46368 | 621 |
1936694 | 1936694 | 2021-11-20 | Yakima | Washington | 53077 | 46368 | 621 |
1933444 | 1933444 | 2021-11-19 | Yakima | Washington | 53077 | 46368 | 621 |
1930192 | 1930192 | 2021-11-18 | Yakima | Washington | 53077 | 46326 | 619 |
1926942 | 1926942 | 2021-11-17 | Yakima | Washington | 53077 | 46252 | 617 |
1923692 | 1923692 | 2021-11-16 | Yakima | Washington | 53077 | 46187 | 614 |
1920443 | 1920443 | 2021-11-15 | Yakima | Washington | 53077 | 46146 | 611 |
1917193 | 1917193 | 2021-11-14 | Yakima | Washington | 53077 | 46028 | 607 |
1913943 | 1913943 | 2021-11-13 | Yakima | Washington | 53077 | 46028 | 607 |
1910693 | 1910693 | 2021-11-12 | Yakima | Washington | 53077 | 46028 | 607 |
1907444 | 1907444 | 2021-11-11 | Yakima | Washington | 53077 | 45911 | 600 |
1904195 | 1904195 | 2021-11-10 | Yakima | Washington | 53077 | 45911 | 600 |
1900945 | 1900945 | 2021-11-09 | Yakima | Washington | 53077 | 45819 | 600 |
1897695 | 1897695 | 2021-11-08 | Yakima | Washington | 53077 | 45743 | 599 |
1894445 | 1894445 | 2021-11-07 | Yakima | Washington | 53077 | 45591 | 595 |
1891195 | 1891195 | 2021-11-06 | Yakima | Washington | 53077 | 45591 | 595 |
1887945 | 1887945 | 2021-11-05 | Yakima | Washington | 53077 | 45591 | 595 |
1884695 | 1884695 | 2021-11-04 | Yakima | Washington | 53077 | 45528 | 595 |
1881446 | 1881446 | 2021-11-03 | Yakima | Washington | 53077 | 45430 | 592 |
1878197 | 1878197 | 2021-11-02 | Yakima | Washington | 53077 | 45330 | 592 |
1874948 | 1874948 | 2021-11-01 | Yakima | Washington | 53077 | 45249 | 592 |
1871699 | 1871699 | 2021-10-31 | Yakima | Washington | 53077 | 45068 | 590 |
1868450 | 1868450 | 2021-10-30 | Yakima | Washington | 53077 | 45068 | 590 |
1865201 | 1865201 | 2021-10-29 | Yakima | Washington | 53077 | 45068 | 590 |
1861952 | 1861952 | 2021-10-28 | Yakima | Washington | 53077 | 45014 | 591 |
1858703 | 1858703 | 2021-10-27 | Yakima | Washington | 53077 | 44847 | 591 |
1855454 | 1855454 | 2021-10-26 | Yakima | Washington | 53077 | 44764 | 590 |
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);