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 |
---|---|---|---|---|---|---|---|
2176525 | 2176525 | 2022-02-02 | Washington | Pennsylvania | 42125 | 48595 | 587 |
2173271 | 2173271 | 2022-02-01 | Washington | Pennsylvania | 42125 | 48461 | 586 |
2170019 | 2170019 | 2022-01-31 | Washington | Pennsylvania | 42125 | 48271 | 582 |
2166765 | 2166765 | 2022-01-30 | Washington | Pennsylvania | 42125 | 48151 | 582 |
2163510 | 2163510 | 2022-01-29 | Washington | Pennsylvania | 42125 | 48011 | 582 |
2160255 | 2160255 | 2022-01-28 | Washington | Pennsylvania | 42125 | 47662 | 582 |
2156999 | 2156999 | 2022-01-27 | Washington | Pennsylvania | 42125 | 47337 | 579 |
2153746 | 2153746 | 2022-01-26 | Washington | Pennsylvania | 42125 | 47006 | 572 |
2150494 | 2150494 | 2022-01-25 | Washington | Pennsylvania | 42125 | 46752 | 569 |
2147242 | 2147242 | 2022-01-24 | Washington | Pennsylvania | 42125 | 46452 | 565 |
2143988 | 2143988 | 2022-01-23 | Washington | Pennsylvania | 42125 | 46146 | 565 |
2140733 | 2140733 | 2022-01-22 | Washington | Pennsylvania | 42125 | 45986 | 564 |
2137477 | 2137477 | 2022-01-21 | Washington | Pennsylvania | 42125 | 45558 | 562 |
2134223 | 2134223 | 2022-01-20 | Washington | Pennsylvania | 42125 | 45065 | 557 |
2130971 | 2130971 | 2022-01-19 | Washington | Pennsylvania | 42125 | 44612 | 553 |
2127717 | 2127717 | 2022-01-18 | Washington | Pennsylvania | 42125 | 44278 | 549 |
2124465 | 2124465 | 2022-01-17 | Washington | Pennsylvania | 42125 | 43889 | 548 |
2121213 | 2121213 | 2022-01-16 | Washington | Pennsylvania | 42125 | 43624 | 548 |
2117961 | 2117961 | 2022-01-15 | Washington | Pennsylvania | 42125 | 42894 | 548 |
2114710 | 2114710 | 2022-01-14 | Washington | Pennsylvania | 42125 | 42251 | 542 |
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 |
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);