ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Chester" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948876 | 1948876 | 2021-11-24 | Chester | Pennsylvania | 42029 | 54518 | 902 |
1945625 | 1945625 | 2021-11-23 | Chester | Pennsylvania | 42029 | 54377 | 902 |
1942374 | 1942374 | 2021-11-22 | Chester | Pennsylvania | 42029 | 54218 | 901 |
1939124 | 1939124 | 2021-11-21 | Chester | Pennsylvania | 42029 | 54083 | 901 |
1935874 | 1935874 | 2021-11-20 | Chester | Pennsylvania | 42029 | 53944 | 901 |
1932624 | 1932624 | 2021-11-19 | Chester | Pennsylvania | 42029 | 53807 | 900 |
1929373 | 1929373 | 2021-11-18 | Chester | Pennsylvania | 42029 | 53655 | 899 |
1926123 | 1926123 | 2021-11-17 | Chester | Pennsylvania | 42029 | 53475 | 897 |
1922873 | 1922873 | 2021-11-16 | Chester | Pennsylvania | 42029 | 53278 | 895 |
1919624 | 1919624 | 2021-11-15 | Chester | Pennsylvania | 42029 | 53141 | 895 |
1916374 | 1916374 | 2021-11-14 | Chester | Pennsylvania | 42029 | 53031 | 895 |
1913124 | 1913124 | 2021-11-13 | Chester | Pennsylvania | 42029 | 52886 | 895 |
1909874 | 1909874 | 2021-11-12 | Chester | Pennsylvania | 42029 | 52331 | 893 |
1906625 | 1906625 | 2021-11-11 | Chester | Pennsylvania | 42029 | 52226 | 892 |
1903376 | 1903376 | 2021-11-10 | Chester | Pennsylvania | 42029 | 52084 | 892 |
1900126 | 1900126 | 2021-11-09 | Chester | Pennsylvania | 42029 | 51957 | 891 |
1896876 | 1896876 | 2021-11-08 | Chester | Pennsylvania | 42029 | 51826 | 888 |
1893626 | 1893626 | 2021-11-07 | Chester | Pennsylvania | 42029 | 51755 | 888 |
1890376 | 1890376 | 2021-11-06 | Chester | Pennsylvania | 42029 | 51647 | 888 |
1887126 | 1887126 | 2021-11-05 | Chester | Pennsylvania | 42029 | 51542 | 888 |
1883876 | 1883876 | 2021-11-04 | Chester | Pennsylvania | 42029 | 51421 | 885 |
1880627 | 1880627 | 2021-11-03 | Chester | Pennsylvania | 42029 | 51260 | 883 |
1877378 | 1877378 | 2021-11-02 | Chester | Pennsylvania | 42029 | 51199 | 881 |
1874129 | 1874129 | 2021-11-01 | Chester | Pennsylvania | 42029 | 51038 | 880 |
1870880 | 1870880 | 2021-10-31 | Chester | Pennsylvania | 42029 | 51038 | 880 |
1867631 | 1867631 | 2021-10-30 | Chester | Pennsylvania | 42029 | 50979 | 879 |
1864382 | 1864382 | 2021-10-29 | Chester | Pennsylvania | 42029 | 50851 | 879 |
1861133 | 1861133 | 2021-10-28 | Chester | Pennsylvania | 42029 | 50754 | 877 |
1857884 | 1857884 | 2021-10-27 | Chester | Pennsylvania | 42029 | 50649 | 875 |
1854635 | 1854635 | 2021-10-26 | Chester | Pennsylvania | 42029 | 50555 | 874 |
1851386 | 1851386 | 2021-10-25 | Chester | Pennsylvania | 42029 | 50463 | 872 |
1848136 | 1848136 | 2021-10-24 | Chester | Pennsylvania | 42029 | 50406 | 871 |
1844886 | 1844886 | 2021-10-23 | Chester | Pennsylvania | 42029 | 50330 | 871 |
1841636 | 1841636 | 2021-10-22 | Chester | Pennsylvania | 42029 | 50251 | 871 |
1838387 | 1838387 | 2021-10-21 | Chester | Pennsylvania | 42029 | 50095 | 871 |
1835138 | 1835138 | 2021-10-20 | Chester | Pennsylvania | 42029 | 49939 | 869 |
1831889 | 1831889 | 2021-10-19 | Chester | Pennsylvania | 42029 | 49843 | 867 |
1828640 | 1828640 | 2021-10-18 | Chester | Pennsylvania | 42029 | 49705 | 867 |
1825391 | 1825391 | 2021-10-17 | Chester | Pennsylvania | 42029 | 49643 | 866 |
1822142 | 1822142 | 2021-10-16 | Chester | Pennsylvania | 42029 | 49531 | 866 |
1818893 | 1818893 | 2021-10-15 | Chester | Pennsylvania | 42029 | 49427 | 866 |
1815644 | 1815644 | 2021-10-14 | Chester | Pennsylvania | 42029 | 49250 | 866 |
1812396 | 1812396 | 2021-10-13 | Chester | Pennsylvania | 42029 | 49165 | 865 |
1809147 | 1809147 | 2021-10-12 | Chester | Pennsylvania | 42029 | 49010 | 862 |
1805897 | 1805897 | 2021-10-11 | Chester | Pennsylvania | 42029 | 48897 | 860 |
1802647 | 1802647 | 2021-10-10 | Chester | Pennsylvania | 42029 | 48817 | 860 |
1799398 | 1799398 | 2021-10-09 | Chester | Pennsylvania | 42029 | 48725 | 860 |
1796149 | 1796149 | 2021-10-08 | Chester | Pennsylvania | 42029 | 48574 | 860 |
1792900 | 1792900 | 2021-10-07 | Chester | Pennsylvania | 42029 | 48461 | 858 |
1789651 | 1789651 | 2021-10-06 | Chester | Pennsylvania | 42029 | 48321 | 853 |
1786403 | 1786403 | 2021-10-05 | Chester | Pennsylvania | 42029 | 48201 | 852 |
1783154 | 1783154 | 2021-10-04 | Chester | Pennsylvania | 42029 | 48073 | 851 |
1779905 | 1779905 | 2021-10-03 | Chester | Pennsylvania | 42029 | 47935 | 851 |
1776655 | 1776655 | 2021-10-02 | Chester | Pennsylvania | 42029 | 47789 | 851 |
1773405 | 1773405 | 2021-10-01 | Chester | Pennsylvania | 42029 | 47641 | 850 |
1770155 | 1770155 | 2021-09-30 | Chester | Pennsylvania | 42029 | 47513 | 850 |
1766906 | 1766906 | 2021-09-29 | Chester | Pennsylvania | 42029 | 47387 | 850 |
1763657 | 1763657 | 2021-09-28 | Chester | Pennsylvania | 42029 | 47264 | 849 |
1760408 | 1760408 | 2021-09-27 | Chester | Pennsylvania | 42029 | 47148 | 846 |
1757160 | 1757160 | 2021-09-26 | Chester | Pennsylvania | 42029 | 47053 | 846 |
1753912 | 1753912 | 2021-09-25 | Chester | Pennsylvania | 42029 | 46946 | 846 |
1750664 | 1750664 | 2021-09-24 | Chester | Pennsylvania | 42029 | 46804 | 844 |
1747415 | 1747415 | 2021-09-23 | Chester | Pennsylvania | 42029 | 46667 | 843 |
1744165 | 1744165 | 2021-09-22 | Chester | Pennsylvania | 42029 | 46545 | 843 |
1740916 | 1740916 | 2021-09-21 | Chester | Pennsylvania | 42029 | 46439 | 843 |
1737667 | 1737667 | 2021-09-20 | Chester | Pennsylvania | 42029 | 46308 | 843 |
1734417 | 1734417 | 2021-09-19 | Chester | Pennsylvania | 42029 | 46229 | 843 |
1731167 | 1731167 | 2021-09-18 | Chester | Pennsylvania | 42029 | 46103 | 843 |
1727917 | 1727917 | 2021-09-17 | Chester | Pennsylvania | 42029 | 45996 | 843 |
1724668 | 1724668 | 2021-09-16 | Chester | Pennsylvania | 42029 | 45804 | 842 |
1721419 | 1721419 | 2021-09-15 | Chester | Pennsylvania | 42029 | 45659 | 842 |
1718171 | 1718171 | 2021-09-14 | Chester | Pennsylvania | 42029 | 45499 | 842 |
1714923 | 1714923 | 2021-09-13 | Chester | Pennsylvania | 42029 | 45384 | 841 |
1711677 | 1711677 | 2021-09-12 | Chester | Pennsylvania | 42029 | 45286 | 841 |
1708430 | 1708430 | 2021-09-11 | Chester | Pennsylvania | 42029 | 45136 | 841 |
1705183 | 1705183 | 2021-09-10 | Chester | Pennsylvania | 42029 | 44998 | 841 |
1701933 | 1701933 | 2021-09-09 | Chester | Pennsylvania | 42029 | 44842 | 839 |
1698684 | 1698684 | 2021-09-08 | Chester | Pennsylvania | 42029 | 44720 | 839 |
1695436 | 1695436 | 2021-09-07 | Chester | Pennsylvania | 42029 | 44583 | 839 |
1692188 | 1692188 | 2021-09-06 | Chester | Pennsylvania | 42029 | 44495 | 839 |
1688939 | 1688939 | 2021-09-05 | Chester | Pennsylvania | 42029 | 44398 | 839 |
1685689 | 1685689 | 2021-09-04 | Chester | Pennsylvania | 42029 | 44327 | 839 |
1682438 | 1682438 | 2021-09-03 | Chester | Pennsylvania | 42029 | 44205 | 838 |
1679188 | 1679188 | 2021-09-02 | Chester | Pennsylvania | 42029 | 44100 | 838 |
1675940 | 1675940 | 2021-09-01 | Chester | Pennsylvania | 42029 | 43986 | 837 |
1672693 | 1672693 | 2021-08-31 | Chester | Pennsylvania | 42029 | 43860 | 837 |
1669445 | 1669445 | 2021-08-30 | Chester | Pennsylvania | 42029 | 43708 | 837 |
1666198 | 1666198 | 2021-08-29 | Chester | Pennsylvania | 42029 | 43608 | 837 |
1662950 | 1662950 | 2021-08-28 | Chester | Pennsylvania | 42029 | 43498 | 837 |
1659702 | 1659702 | 2021-08-27 | Chester | Pennsylvania | 42029 | 43389 | 837 |
1656453 | 1656453 | 2021-08-26 | Chester | Pennsylvania | 42029 | 43250 | 834 |
1653206 | 1653206 | 2021-08-25 | Chester | Pennsylvania | 42029 | 43111 | 834 |
1649959 | 1649959 | 2021-08-24 | Chester | Pennsylvania | 42029 | 43010 | 833 |
1646710 | 1646710 | 2021-08-23 | Chester | Pennsylvania | 42029 | 42941 | 830 |
1643461 | 1643461 | 2021-08-22 | Chester | Pennsylvania | 42029 | 42868 | 830 |
1640211 | 1640211 | 2021-08-21 | Chester | Pennsylvania | 42029 | 42803 | 830 |
1636961 | 1636961 | 2021-08-20 | Chester | Pennsylvania | 42029 | 42721 | 830 |
1633711 | 1633711 | 2021-08-19 | Chester | Pennsylvania | 42029 | 42652 | 830 |
1630464 | 1630464 | 2021-08-18 | Chester | Pennsylvania | 42029 | 42565 | 830 |
1627217 | 1627217 | 2021-08-17 | Chester | Pennsylvania | 42029 | 42476 | 829 |
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);