ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Washington" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111458 | 2111458 | 2022-01-13 | Washington | Pennsylvania | 42125 | 41803 | 542 |
2108206 | 2108206 | 2022-01-12 | Washington | Pennsylvania | 42125 | 41145 | 542 |
2104955 | 2104955 | 2022-01-11 | Washington | Pennsylvania | 42125 | 40451 | 540 |
2101704 | 2101704 | 2022-01-10 | Washington | Pennsylvania | 42125 | 40125 | 535 |
2098453 | 2098453 | 2022-01-09 | Washington | Pennsylvania | 42125 | 39739 | 535 |
2095201 | 2095201 | 2022-01-08 | Washington | Pennsylvania | 42125 | 39174 | 535 |
2091949 | 2091949 | 2022-01-07 | Washington | Pennsylvania | 42125 | 38599 | 535 |
2088697 | 2088697 | 2022-01-06 | Washington | Pennsylvania | 42125 | 38034 | 530 |
2085446 | 2085446 | 2022-01-05 | Washington | Pennsylvania | 42125 | 37281 | 521 |
2082194 | 2082194 | 2022-01-04 | Washington | Pennsylvania | 42125 | 36720 | 519 |
2078942 | 2078942 | 2022-01-03 | Washington | Pennsylvania | 42125 | 36461 | 514 |
2075691 | 2075691 | 2022-01-02 | Washington | Pennsylvania | 42125 | 36014 | 513 |
2072440 | 2072440 | 2022-01-01 | Washington | Pennsylvania | 42125 | 35875 | 513 |
2069189 | 2069189 | 2021-12-31 | Washington | Pennsylvania | 42125 | 35399 | 513 |
2065938 | 2065938 | 2021-12-30 | Washington | Pennsylvania | 42125 | 35004 | 513 |
2062688 | 2062688 | 2021-12-29 | Washington | Pennsylvania | 42125 | 34682 | 512 |
2059438 | 2059438 | 2021-12-28 | Washington | Pennsylvania | 42125 | 34419 | 503 |
2056189 | 2056189 | 2021-12-27 | Washington | Pennsylvania | 42125 | 34198 | 500 |
2052940 | 2052940 | 2021-12-26 | Washington | Pennsylvania | 42125 | 34169 | 500 |
2049690 | 2049690 | 2021-12-25 | Washington | Pennsylvania | 42125 | 34057 | 500 |
2046440 | 2046440 | 2021-12-24 | Washington | Pennsylvania | 42125 | 33820 | 500 |
2043190 | 2043190 | 2021-12-23 | Washington | Pennsylvania | 42125 | 33536 | 500 |
2039941 | 2039941 | 2021-12-22 | Washington | Pennsylvania | 42125 | 33375 | 497 |
2036691 | 2036691 | 2021-12-21 | Washington | Pennsylvania | 42125 | 33300 | 493 |
2033441 | 2033441 | 2021-12-20 | Washington | Pennsylvania | 42125 | 33071 | 484 |
2030191 | 2030191 | 2021-12-19 | Washington | Pennsylvania | 42125 | 33026 | 484 |
2026940 | 2026940 | 2021-12-18 | Washington | Pennsylvania | 42125 | 32925 | 484 |
2023689 | 2023689 | 2021-12-17 | Washington | Pennsylvania | 42125 | 32803 | 477 |
2020438 | 2020438 | 2021-12-16 | Washington | Pennsylvania | 42125 | 32624 | 476 |
2017187 | 2017187 | 2021-12-15 | Washington | Pennsylvania | 42125 | 32504 | 474 |
2013937 | 2013937 | 2021-12-14 | Washington | Pennsylvania | 42125 | 32322 | 469 |
2010686 | 2010686 | 2021-12-13 | Washington | Pennsylvania | 42125 | 32155 | 466 |
2007435 | 2007435 | 2021-12-12 | Washington | Pennsylvania | 42125 | 32039 | 466 |
2004184 | 2004184 | 2021-12-11 | Washington | Pennsylvania | 42125 | 31916 | 465 |
2000933 | 2000933 | 2021-12-10 | Washington | Pennsylvania | 42125 | 31681 | 463 |
1997683 | 1997683 | 2021-12-09 | Washington | Pennsylvania | 42125 | 31551 | 461 |
1994432 | 1994432 | 2021-12-08 | Washington | Pennsylvania | 42125 | 31381 | 460 |
1991181 | 1991181 | 2021-12-07 | Washington | Pennsylvania | 42125 | 31198 | 454 |
1987930 | 1987930 | 2021-12-06 | Washington | Pennsylvania | 42125 | 30961 | 448 |
1984680 | 1984680 | 2021-12-05 | Washington | Pennsylvania | 42125 | 30886 | 445 |
1981430 | 1981430 | 2021-12-04 | Washington | Pennsylvania | 42125 | 30790 | 444 |
1978180 | 1978180 | 2021-12-03 | Washington | Pennsylvania | 42125 | 30637 | 441 |
1974930 | 1974930 | 2021-12-02 | Washington | Pennsylvania | 42125 | 30300 | 437 |
1971681 | 1971681 | 2021-12-01 | Washington | Pennsylvania | 42125 | 30121 | 435 |
1968431 | 1968431 | 2021-11-30 | Washington | Pennsylvania | 42125 | 29974 | 432 |
1965180 | 1965180 | 2021-11-29 | Washington | Pennsylvania | 42125 | 29837 | 428 |
1961928 | 1961928 | 2021-11-28 | Washington | Pennsylvania | 42125 | 29645 | 426 |
1958677 | 1958677 | 2021-11-27 | Washington | Pennsylvania | 42125 | 29536 | 425 |
1955426 | 1955426 | 2021-11-26 | Washington | Pennsylvania | 42125 | 29454 | 425 |
1952175 | 1952175 | 2021-11-25 | Washington | Pennsylvania | 42125 | 29307 | 425 |
1948924 | 1948924 | 2021-11-24 | Washington | Pennsylvania | 42125 | 29182 | 421 |
1945673 | 1945673 | 2021-11-23 | Washington | Pennsylvania | 42125 | 28981 | 420 |
1942422 | 1942422 | 2021-11-22 | Washington | Pennsylvania | 42125 | 28837 | 420 |
1939172 | 1939172 | 2021-11-21 | Washington | Pennsylvania | 42125 | 28693 | 420 |
1935922 | 1935922 | 2021-11-20 | Washington | Pennsylvania | 42125 | 28592 | 420 |
1932672 | 1932672 | 2021-11-19 | Washington | Pennsylvania | 42125 | 28409 | 419 |
1929421 | 1929421 | 2021-11-18 | Washington | Pennsylvania | 42125 | 28239 | 415 |
1926171 | 1926171 | 2021-11-17 | Washington | Pennsylvania | 42125 | 28058 | 414 |
1922921 | 1922921 | 2021-11-16 | Washington | Pennsylvania | 42125 | 27923 | 408 |
1919672 | 1919672 | 2021-11-15 | Washington | Pennsylvania | 42125 | 27743 | 407 |
1916422 | 1916422 | 2021-11-14 | Washington | Pennsylvania | 42125 | 27673 | 407 |
1913172 | 1913172 | 2021-11-13 | Washington | Pennsylvania | 42125 | 27578 | 406 |
1909922 | 1909922 | 2021-11-12 | Washington | Pennsylvania | 42125 | 27163 | 406 |
1906673 | 1906673 | 2021-11-11 | Washington | Pennsylvania | 42125 | 26988 | 406 |
1903424 | 1903424 | 2021-11-10 | Washington | Pennsylvania | 42125 | 26877 | 406 |
1900174 | 1900174 | 2021-11-09 | Washington | Pennsylvania | 42125 | 26718 | 403 |
1896924 | 1896924 | 2021-11-08 | Washington | Pennsylvania | 42125 | 26636 | 403 |
1893674 | 1893674 | 2021-11-07 | Washington | Pennsylvania | 42125 | 26549 | 403 |
1890424 | 1890424 | 2021-11-06 | Washington | Pennsylvania | 42125 | 26443 | 403 |
1887174 | 1887174 | 2021-11-05 | Washington | Pennsylvania | 42125 | 26334 | 402 |
1883924 | 1883924 | 2021-11-04 | Washington | Pennsylvania | 42125 | 26220 | 401 |
1880675 | 1880675 | 2021-11-03 | Washington | Pennsylvania | 42125 | 26080 | 400 |
1877426 | 1877426 | 2021-11-02 | Washington | Pennsylvania | 42125 | 25954 | 398 |
1874177 | 1874177 | 2021-11-01 | Washington | Pennsylvania | 42125 | 25820 | 398 |
1870928 | 1870928 | 2021-10-31 | Washington | Pennsylvania | 42125 | 25820 | 398 |
1867679 | 1867679 | 2021-10-30 | Washington | Pennsylvania | 42125 | 25749 | 396 |
1864430 | 1864430 | 2021-10-29 | Washington | Pennsylvania | 42125 | 25639 | 394 |
1861181 | 1861181 | 2021-10-28 | Washington | Pennsylvania | 42125 | 25529 | 390 |
1857932 | 1857932 | 2021-10-27 | Washington | Pennsylvania | 42125 | 25458 | 389 |
1854683 | 1854683 | 2021-10-26 | Washington | Pennsylvania | 42125 | 25361 | 387 |
1851434 | 1851434 | 2021-10-25 | Washington | Pennsylvania | 42125 | 25259 | 386 |
1848184 | 1848184 | 2021-10-24 | Washington | Pennsylvania | 42125 | 25218 | 386 |
1844934 | 1844934 | 2021-10-23 | Washington | Pennsylvania | 42125 | 25165 | 386 |
1841684 | 1841684 | 2021-10-22 | Washington | Pennsylvania | 42125 | 25057 | 384 |
1838435 | 1838435 | 2021-10-21 | Washington | Pennsylvania | 42125 | 24995 | 382 |
1835186 | 1835186 | 2021-10-20 | Washington | Pennsylvania | 42125 | 24825 | 382 |
1831937 | 1831937 | 2021-10-19 | Washington | Pennsylvania | 42125 | 24763 | 380 |
1828688 | 1828688 | 2021-10-18 | Washington | Pennsylvania | 42125 | 24706 | 379 |
1825439 | 1825439 | 2021-10-17 | Washington | Pennsylvania | 42125 | 24627 | 378 |
1822190 | 1822190 | 2021-10-16 | Washington | Pennsylvania | 42125 | 24583 | 378 |
1818941 | 1818941 | 2021-10-15 | Washington | Pennsylvania | 42125 | 24466 | 378 |
1815692 | 1815692 | 2021-10-14 | Washington | Pennsylvania | 42125 | 24317 | 377 |
1812444 | 1812444 | 2021-10-13 | Washington | Pennsylvania | 42125 | 24195 | 375 |
1809195 | 1809195 | 2021-10-12 | Washington | Pennsylvania | 42125 | 24039 | 372 |
1805945 | 1805945 | 2021-10-11 | Washington | Pennsylvania | 42125 | 23960 | 368 |
1802695 | 1802695 | 2021-10-10 | Washington | Pennsylvania | 42125 | 23886 | 368 |
1799446 | 1799446 | 2021-10-09 | Washington | Pennsylvania | 42125 | 23803 | 368 |
1796197 | 1796197 | 2021-10-08 | Washington | Pennsylvania | 42125 | 23681 | 368 |
1792948 | 1792948 | 2021-10-07 | Washington | Pennsylvania | 42125 | 23504 | 362 |
1789699 | 1789699 | 2021-10-06 | Washington | Pennsylvania | 42125 | 23319 | 358 |
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);