ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Fayette", fips = 42051 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176488 | 2176488 | 2022-02-02 | Fayette | Pennsylvania | 42051 | 28982 | 590 |
2173234 | 2173234 | 2022-02-01 | Fayette | Pennsylvania | 42051 | 28897 | 588 |
2169982 | 2169982 | 2022-01-31 | Fayette | Pennsylvania | 42051 | 28805 | 586 |
2166728 | 2166728 | 2022-01-30 | Fayette | Pennsylvania | 42051 | 28710 | 586 |
2163473 | 2163473 | 2022-01-29 | Fayette | Pennsylvania | 42051 | 28597 | 585 |
2160218 | 2160218 | 2022-01-28 | Fayette | Pennsylvania | 42051 | 28422 | 582 |
2156962 | 2156962 | 2022-01-27 | Fayette | Pennsylvania | 42051 | 28114 | 581 |
2153709 | 2153709 | 2022-01-26 | Fayette | Pennsylvania | 42051 | 27924 | 575 |
2150457 | 2150457 | 2022-01-25 | Fayette | Pennsylvania | 42051 | 27792 | 574 |
2147205 | 2147205 | 2022-01-24 | Fayette | Pennsylvania | 42051 | 27649 | 573 |
2143951 | 2143951 | 2022-01-23 | Fayette | Pennsylvania | 42051 | 27372 | 573 |
2140696 | 2140696 | 2022-01-22 | Fayette | Pennsylvania | 42051 | 27227 | 573 |
2137440 | 2137440 | 2022-01-21 | Fayette | Pennsylvania | 42051 | 26961 | 572 |
2134186 | 2134186 | 2022-01-20 | Fayette | Pennsylvania | 42051 | 26615 | 566 |
2130934 | 2130934 | 2022-01-19 | Fayette | Pennsylvania | 42051 | 26415 | 564 |
2127680 | 2127680 | 2022-01-18 | Fayette | Pennsylvania | 42051 | 26265 | 563 |
2124428 | 2124428 | 2022-01-17 | Fayette | Pennsylvania | 42051 | 26096 | 563 |
2121176 | 2121176 | 2022-01-16 | Fayette | Pennsylvania | 42051 | 25955 | 563 |
2117924 | 2117924 | 2022-01-15 | Fayette | Pennsylvania | 42051 | 25629 | 563 |
2114673 | 2114673 | 2022-01-14 | Fayette | Pennsylvania | 42051 | 25379 | 562 |
2111421 | 2111421 | 2022-01-13 | Fayette | Pennsylvania | 42051 | 25133 | 561 |
2108169 | 2108169 | 2022-01-12 | Fayette | Pennsylvania | 42051 | 24935 | 556 |
2104918 | 2104918 | 2022-01-11 | Fayette | Pennsylvania | 42051 | 24662 | 553 |
2101667 | 2101667 | 2022-01-10 | Fayette | Pennsylvania | 42051 | 24567 | 550 |
2098416 | 2098416 | 2022-01-09 | Fayette | Pennsylvania | 42051 | 24430 | 550 |
2095164 | 2095164 | 2022-01-08 | Fayette | Pennsylvania | 42051 | 24309 | 548 |
2091912 | 2091912 | 2022-01-07 | Fayette | Pennsylvania | 42051 | 24055 | 546 |
2088660 | 2088660 | 2022-01-06 | Fayette | Pennsylvania | 42051 | 23853 | 544 |
2085409 | 2085409 | 2022-01-05 | Fayette | Pennsylvania | 42051 | 23710 | 542 |
2082157 | 2082157 | 2022-01-04 | Fayette | Pennsylvania | 42051 | 23430 | 541 |
2078905 | 2078905 | 2022-01-03 | Fayette | Pennsylvania | 42051 | 23315 | 539 |
2075654 | 2075654 | 2022-01-02 | Fayette | Pennsylvania | 42051 | 23259 | 539 |
2072403 | 2072403 | 2022-01-01 | Fayette | Pennsylvania | 42051 | 23163 | 539 |
2069152 | 2069152 | 2021-12-31 | Fayette | Pennsylvania | 42051 | 23005 | 539 |
2065901 | 2065901 | 2021-12-30 | Fayette | Pennsylvania | 42051 | 22880 | 538 |
2062651 | 2062651 | 2021-12-29 | Fayette | Pennsylvania | 42051 | 22754 | 533 |
2059401 | 2059401 | 2021-12-28 | Fayette | Pennsylvania | 42051 | 22690 | 527 |
2056152 | 2056152 | 2021-12-27 | Fayette | Pennsylvania | 42051 | 22641 | 525 |
2052903 | 2052903 | 2021-12-26 | Fayette | Pennsylvania | 42051 | 22622 | 525 |
2049653 | 2049653 | 2021-12-25 | Fayette | Pennsylvania | 42051 | 22591 | 525 |
2046403 | 2046403 | 2021-12-24 | Fayette | Pennsylvania | 42051 | 22520 | 525 |
2043153 | 2043153 | 2021-12-23 | Fayette | Pennsylvania | 42051 | 22377 | 524 |
2039904 | 2039904 | 2021-12-22 | Fayette | Pennsylvania | 42051 | 22327 | 518 |
2036654 | 2036654 | 2021-12-21 | Fayette | Pennsylvania | 42051 | 22284 | 514 |
2033404 | 2033404 | 2021-12-20 | Fayette | Pennsylvania | 42051 | 22185 | 510 |
2030154 | 2030154 | 2021-12-19 | Fayette | Pennsylvania | 42051 | 22159 | 510 |
2026903 | 2026903 | 2021-12-18 | Fayette | Pennsylvania | 42051 | 22084 | 510 |
2023652 | 2023652 | 2021-12-17 | Fayette | Pennsylvania | 42051 | 22020 | 508 |
2020401 | 2020401 | 2021-12-16 | Fayette | Pennsylvania | 42051 | 21912 | 507 |
2017150 | 2017150 | 2021-12-15 | Fayette | Pennsylvania | 42051 | 21862 | 507 |
2013900 | 2013900 | 2021-12-14 | Fayette | Pennsylvania | 42051 | 21796 | 500 |
2010649 | 2010649 | 2021-12-13 | Fayette | Pennsylvania | 42051 | 21677 | 493 |
2007398 | 2007398 | 2021-12-12 | Fayette | Pennsylvania | 42051 | 21636 | 492 |
2004147 | 2004147 | 2021-12-11 | Fayette | Pennsylvania | 42051 | 21559 | 491 |
2000896 | 2000896 | 2021-12-10 | Fayette | Pennsylvania | 42051 | 21461 | 483 |
1997646 | 1997646 | 2021-12-09 | Fayette | Pennsylvania | 42051 | 21392 | 480 |
1994395 | 1994395 | 2021-12-08 | Fayette | Pennsylvania | 42051 | 21275 | 478 |
1991144 | 1991144 | 2021-12-07 | Fayette | Pennsylvania | 42051 | 21171 | 475 |
1987893 | 1987893 | 2021-12-06 | Fayette | Pennsylvania | 42051 | 21066 | 473 |
1984643 | 1984643 | 2021-12-05 | Fayette | Pennsylvania | 42051 | 20989 | 470 |
1981393 | 1981393 | 2021-12-04 | Fayette | Pennsylvania | 42051 | 20951 | 470 |
1978143 | 1978143 | 2021-12-03 | Fayette | Pennsylvania | 42051 | 20911 | 468 |
1974893 | 1974893 | 2021-12-02 | Fayette | Pennsylvania | 42051 | 20723 | 467 |
1971644 | 1971644 | 2021-12-01 | Fayette | Pennsylvania | 42051 | 20623 | 462 |
1968394 | 1968394 | 2021-11-30 | Fayette | Pennsylvania | 42051 | 20546 | 460 |
1965143 | 1965143 | 2021-11-29 | Fayette | Pennsylvania | 42051 | 20475 | 458 |
1961891 | 1961891 | 2021-11-28 | Fayette | Pennsylvania | 42051 | 20349 | 457 |
1958640 | 1958640 | 2021-11-27 | Fayette | Pennsylvania | 42051 | 20317 | 456 |
1955389 | 1955389 | 2021-11-26 | Fayette | Pennsylvania | 42051 | 20271 | 456 |
1952138 | 1952138 | 2021-11-25 | Fayette | Pennsylvania | 42051 | 20192 | 456 |
1948887 | 1948887 | 2021-11-24 | Fayette | Pennsylvania | 42051 | 20118 | 452 |
1945636 | 1945636 | 2021-11-23 | Fayette | Pennsylvania | 42051 | 20011 | 451 |
1942385 | 1942385 | 2021-11-22 | Fayette | Pennsylvania | 42051 | 19976 | 449 |
1939135 | 1939135 | 2021-11-21 | Fayette | Pennsylvania | 42051 | 19861 | 449 |
1935885 | 1935885 | 2021-11-20 | Fayette | Pennsylvania | 42051 | 19806 | 449 |
1932635 | 1932635 | 2021-11-19 | Fayette | Pennsylvania | 42051 | 19674 | 446 |
1929384 | 1929384 | 2021-11-18 | Fayette | Pennsylvania | 42051 | 19543 | 444 |
1926134 | 1926134 | 2021-11-17 | Fayette | Pennsylvania | 42051 | 19448 | 441 |
1922884 | 1922884 | 2021-11-16 | Fayette | Pennsylvania | 42051 | 19380 | 437 |
1919635 | 1919635 | 2021-11-15 | Fayette | Pennsylvania | 42051 | 19270 | 436 |
1916385 | 1916385 | 2021-11-14 | Fayette | Pennsylvania | 42051 | 19226 | 435 |
1913135 | 1913135 | 2021-11-13 | Fayette | Pennsylvania | 42051 | 19153 | 434 |
1909885 | 1909885 | 2021-11-12 | Fayette | Pennsylvania | 42051 | 18849 | 427 |
1906636 | 1906636 | 2021-11-11 | Fayette | Pennsylvania | 42051 | 18751 | 427 |
1903387 | 1903387 | 2021-11-10 | Fayette | Pennsylvania | 42051 | 18685 | 427 |
1900137 | 1900137 | 2021-11-09 | Fayette | Pennsylvania | 42051 | 18571 | 426 |
1896887 | 1896887 | 2021-11-08 | Fayette | Pennsylvania | 42051 | 18528 | 424 |
1893637 | 1893637 | 2021-11-07 | Fayette | Pennsylvania | 42051 | 18458 | 421 |
1890387 | 1890387 | 2021-11-06 | Fayette | Pennsylvania | 42051 | 18397 | 421 |
1887137 | 1887137 | 2021-11-05 | Fayette | Pennsylvania | 42051 | 18324 | 420 |
1883887 | 1883887 | 2021-11-04 | Fayette | Pennsylvania | 42051 | 18226 | 419 |
1880638 | 1880638 | 2021-11-03 | Fayette | Pennsylvania | 42051 | 18158 | 417 |
1877389 | 1877389 | 2021-11-02 | Fayette | Pennsylvania | 42051 | 18083 | 412 |
1874140 | 1874140 | 2021-11-01 | Fayette | Pennsylvania | 42051 | 17994 | 410 |
1870891 | 1870891 | 2021-10-31 | Fayette | Pennsylvania | 42051 | 17994 | 410 |
1867642 | 1867642 | 2021-10-30 | Fayette | Pennsylvania | 42051 | 17932 | 408 |
1864393 | 1864393 | 2021-10-29 | Fayette | Pennsylvania | 42051 | 17882 | 407 |
1861144 | 1861144 | 2021-10-28 | Fayette | Pennsylvania | 42051 | 17781 | 405 |
1857895 | 1857895 | 2021-10-27 | Fayette | Pennsylvania | 42051 | 17720 | 401 |
1854646 | 1854646 | 2021-10-26 | Fayette | Pennsylvania | 42051 | 17654 | 398 |
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);