ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Cumberland" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176483 | 2176483 | 2022-02-02 | Cumberland | Pennsylvania | 42041 | 48618 | 817 |
2173229 | 2173229 | 2022-02-01 | Cumberland | Pennsylvania | 42041 | 48467 | 813 |
2169977 | 2169977 | 2022-01-31 | Cumberland | Pennsylvania | 42041 | 48339 | 804 |
2166723 | 2166723 | 2022-01-30 | Cumberland | Pennsylvania | 42041 | 48198 | 804 |
2163468 | 2163468 | 2022-01-29 | Cumberland | Pennsylvania | 42041 | 47983 | 804 |
2160213 | 2160213 | 2022-01-28 | Cumberland | Pennsylvania | 42041 | 47749 | 799 |
2156957 | 2156957 | 2022-01-27 | Cumberland | Pennsylvania | 42041 | 47455 | 795 |
2153704 | 2153704 | 2022-01-26 | Cumberland | Pennsylvania | 42041 | 47028 | 790 |
2150452 | 2150452 | 2022-01-25 | Cumberland | Pennsylvania | 42041 | 46699 | 783 |
2147200 | 2147200 | 2022-01-24 | Cumberland | Pennsylvania | 42041 | 46417 | 779 |
2143946 | 2143946 | 2022-01-23 | Cumberland | Pennsylvania | 42041 | 46182 | 779 |
2140691 | 2140691 | 2022-01-22 | Cumberland | Pennsylvania | 42041 | 45878 | 779 |
2137435 | 2137435 | 2022-01-21 | Cumberland | Pennsylvania | 42041 | 45447 | 777 |
2134181 | 2134181 | 2022-01-20 | Cumberland | Pennsylvania | 42041 | 45074 | 769 |
2130929 | 2130929 | 2022-01-19 | Cumberland | Pennsylvania | 42041 | 44594 | 760 |
2127675 | 2127675 | 2022-01-18 | Cumberland | Pennsylvania | 42041 | 44304 | 756 |
2124423 | 2124423 | 2022-01-17 | Cumberland | Pennsylvania | 42041 | 43950 | 756 |
2121171 | 2121171 | 2022-01-16 | Cumberland | Pennsylvania | 42041 | 43561 | 756 |
2117919 | 2117919 | 2022-01-15 | Cumberland | Pennsylvania | 42041 | 42842 | 755 |
2114668 | 2114668 | 2022-01-14 | Cumberland | Pennsylvania | 42041 | 42355 | 755 |
2111416 | 2111416 | 2022-01-13 | Cumberland | Pennsylvania | 42041 | 41885 | 751 |
2108164 | 2108164 | 2022-01-12 | Cumberland | Pennsylvania | 42041 | 41415 | 750 |
2104913 | 2104913 | 2022-01-11 | Cumberland | Pennsylvania | 42041 | 41013 | 745 |
2101662 | 2101662 | 2022-01-10 | Cumberland | Pennsylvania | 42041 | 40593 | 743 |
2098411 | 2098411 | 2022-01-09 | Cumberland | Pennsylvania | 42041 | 40114 | 743 |
2095159 | 2095159 | 2022-01-08 | Cumberland | Pennsylvania | 42041 | 39720 | 743 |
2091907 | 2091907 | 2022-01-07 | Cumberland | Pennsylvania | 42041 | 39281 | 740 |
2088655 | 2088655 | 2022-01-06 | Cumberland | Pennsylvania | 42041 | 38917 | 738 |
2085404 | 2085404 | 2022-01-05 | Cumberland | Pennsylvania | 42041 | 38526 | 731 |
2082152 | 2082152 | 2022-01-04 | Cumberland | Pennsylvania | 42041 | 38136 | 729 |
2078900 | 2078900 | 2022-01-03 | Cumberland | Pennsylvania | 42041 | 37805 | 724 |
2075649 | 2075649 | 2022-01-02 | Cumberland | Pennsylvania | 42041 | 37529 | 721 |
2072398 | 2072398 | 2022-01-01 | Cumberland | Pennsylvania | 42041 | 37155 | 721 |
2069147 | 2069147 | 2021-12-31 | Cumberland | Pennsylvania | 42041 | 36898 | 721 |
2065896 | 2065896 | 2021-12-30 | Cumberland | Pennsylvania | 42041 | 36561 | 721 |
2062646 | 2062646 | 2021-12-29 | Cumberland | Pennsylvania | 42041 | 36273 | 719 |
2059396 | 2059396 | 2021-12-28 | Cumberland | Pennsylvania | 42041 | 36077 | 712 |
2056147 | 2056147 | 2021-12-27 | Cumberland | Pennsylvania | 42041 | 35785 | 710 |
2052898 | 2052898 | 2021-12-26 | Cumberland | Pennsylvania | 42041 | 35695 | 708 |
2049648 | 2049648 | 2021-12-25 | Cumberland | Pennsylvania | 42041 | 35585 | 708 |
2046398 | 2046398 | 2021-12-24 | Cumberland | Pennsylvania | 42041 | 35395 | 708 |
2043148 | 2043148 | 2021-12-23 | Cumberland | Pennsylvania | 42041 | 35172 | 707 |
2039899 | 2039899 | 2021-12-22 | Cumberland | Pennsylvania | 42041 | 34977 | 703 |
2036649 | 2036649 | 2021-12-21 | Cumberland | Pennsylvania | 42041 | 34694 | 698 |
2033399 | 2033399 | 2021-12-20 | Cumberland | Pennsylvania | 42041 | 34534 | 691 |
2030149 | 2030149 | 2021-12-19 | Cumberland | Pennsylvania | 42041 | 34436 | 691 |
2026898 | 2026898 | 2021-12-18 | Cumberland | Pennsylvania | 42041 | 34279 | 691 |
2023647 | 2023647 | 2021-12-17 | Cumberland | Pennsylvania | 42041 | 34106 | 685 |
2020396 | 2020396 | 2021-12-16 | Cumberland | Pennsylvania | 42041 | 33963 | 685 |
2017145 | 2017145 | 2021-12-15 | Cumberland | Pennsylvania | 42041 | 33809 | 684 |
2013895 | 2013895 | 2021-12-14 | Cumberland | Pennsylvania | 42041 | 33647 | 681 |
2010644 | 2010644 | 2021-12-13 | Cumberland | Pennsylvania | 42041 | 33491 | 679 |
2007393 | 2007393 | 2021-12-12 | Cumberland | Pennsylvania | 42041 | 33355 | 679 |
2004142 | 2004142 | 2021-12-11 | Cumberland | Pennsylvania | 42041 | 33192 | 678 |
2000891 | 2000891 | 2021-12-10 | Cumberland | Pennsylvania | 42041 | 32924 | 676 |
1997641 | 1997641 | 2021-12-09 | Cumberland | Pennsylvania | 42041 | 32746 | 672 |
1994390 | 1994390 | 2021-12-08 | Cumberland | Pennsylvania | 42041 | 32646 | 671 |
1991139 | 1991139 | 2021-12-07 | Cumberland | Pennsylvania | 42041 | 32506 | 671 |
1987888 | 1987888 | 2021-12-06 | Cumberland | Pennsylvania | 42041 | 32367 | 668 |
1984638 | 1984638 | 2021-12-05 | Cumberland | Pennsylvania | 42041 | 32305 | 666 |
1981388 | 1981388 | 2021-12-04 | Cumberland | Pennsylvania | 42041 | 32203 | 666 |
1978138 | 1978138 | 2021-12-03 | Cumberland | Pennsylvania | 42041 | 32023 | 663 |
1974888 | 1974888 | 2021-12-02 | Cumberland | Pennsylvania | 42041 | 31912 | 661 |
1971639 | 1971639 | 2021-12-01 | Cumberland | Pennsylvania | 42041 | 31775 | 656 |
1968389 | 1968389 | 2021-11-30 | Cumberland | Pennsylvania | 42041 | 31605 | 651 |
1965138 | 1965138 | 2021-11-29 | Cumberland | Pennsylvania | 42041 | 31458 | 650 |
1961886 | 1961886 | 2021-11-28 | Cumberland | Pennsylvania | 42041 | 31357 | 650 |
1958635 | 1958635 | 2021-11-27 | Cumberland | Pennsylvania | 42041 | 31260 | 650 |
1955384 | 1955384 | 2021-11-26 | Cumberland | Pennsylvania | 42041 | 31109 | 650 |
1952133 | 1952133 | 2021-11-25 | Cumberland | Pennsylvania | 42041 | 31017 | 650 |
1948882 | 1948882 | 2021-11-24 | Cumberland | Pennsylvania | 42041 | 30896 | 649 |
1945631 | 1945631 | 2021-11-23 | Cumberland | Pennsylvania | 42041 | 30775 | 648 |
1942380 | 1942380 | 2021-11-22 | Cumberland | Pennsylvania | 42041 | 30639 | 646 |
1939130 | 1939130 | 2021-11-21 | Cumberland | Pennsylvania | 42041 | 30557 | 646 |
1935880 | 1935880 | 2021-11-20 | Cumberland | Pennsylvania | 42041 | 30413 | 646 |
1932630 | 1932630 | 2021-11-19 | Cumberland | Pennsylvania | 42041 | 30321 | 646 |
1929379 | 1929379 | 2021-11-18 | Cumberland | Pennsylvania | 42041 | 30216 | 645 |
1926129 | 1926129 | 2021-11-17 | Cumberland | Pennsylvania | 42041 | 30130 | 643 |
1922879 | 1922879 | 2021-11-16 | Cumberland | Pennsylvania | 42041 | 29993 | 640 |
1919630 | 1919630 | 2021-11-15 | Cumberland | Pennsylvania | 42041 | 29887 | 640 |
1916380 | 1916380 | 2021-11-14 | Cumberland | Pennsylvania | 42041 | 29789 | 640 |
1913130 | 1913130 | 2021-11-13 | Cumberland | Pennsylvania | 42041 | 29712 | 639 |
1909880 | 1909880 | 2021-11-12 | Cumberland | Pennsylvania | 42041 | 29198 | 638 |
1906631 | 1906631 | 2021-11-11 | Cumberland | Pennsylvania | 42041 | 29129 | 637 |
1903382 | 1903382 | 2021-11-10 | Cumberland | Pennsylvania | 42041 | 29021 | 636 |
1900132 | 1900132 | 2021-11-09 | Cumberland | Pennsylvania | 42041 | 28940 | 634 |
1896882 | 1896882 | 2021-11-08 | Cumberland | Pennsylvania | 42041 | 28835 | 634 |
1893632 | 1893632 | 2021-11-07 | Cumberland | Pennsylvania | 42041 | 28778 | 634 |
1890382 | 1890382 | 2021-11-06 | Cumberland | Pennsylvania | 42041 | 28711 | 634 |
1887132 | 1887132 | 2021-11-05 | Cumberland | Pennsylvania | 42041 | 28636 | 634 |
1883882 | 1883882 | 2021-11-04 | Cumberland | Pennsylvania | 42041 | 28548 | 634 |
1880633 | 1880633 | 2021-11-03 | Cumberland | Pennsylvania | 42041 | 28448 | 633 |
1877384 | 1877384 | 2021-11-02 | Cumberland | Pennsylvania | 42041 | 28388 | 629 |
1874135 | 1874135 | 2021-11-01 | Cumberland | Pennsylvania | 42041 | 28275 | 626 |
1870886 | 1870886 | 2021-10-31 | Cumberland | Pennsylvania | 42041 | 28275 | 626 |
1867637 | 1867637 | 2021-10-30 | Cumberland | Pennsylvania | 42041 | 28228 | 624 |
1864388 | 1864388 | 2021-10-29 | Cumberland | Pennsylvania | 42041 | 28161 | 624 |
1861139 | 1861139 | 2021-10-28 | Cumberland | Pennsylvania | 42041 | 28089 | 622 |
1857890 | 1857890 | 2021-10-27 | Cumberland | Pennsylvania | 42041 | 28014 | 617 |
1854641 | 1854641 | 2021-10-26 | Cumberland | Pennsylvania | 42041 | 27961 | 612 |
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);