ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 42029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1623970 | 1623970 | 2021-08-16 | Chester | Pennsylvania | 42029 | 42388 | 827 |
1620723 | 1620723 | 2021-08-15 | Chester | Pennsylvania | 42029 | 42309 | 827 |
1617475 | 1617475 | 2021-08-14 | Chester | Pennsylvania | 42029 | 42213 | 827 |
1614227 | 1614227 | 2021-08-13 | Chester | Pennsylvania | 42029 | 42128 | 827 |
1610978 | 1610978 | 2021-08-12 | Chester | Pennsylvania | 42029 | 42026 | 827 |
1607730 | 1607730 | 2021-08-11 | Chester | Pennsylvania | 42029 | 41937 | 827 |
1604481 | 1604481 | 2021-08-10 | Chester | Pennsylvania | 42029 | 41871 | 827 |
1601232 | 1601232 | 2021-08-09 | Chester | Pennsylvania | 42029 | 41791 | 827 |
1597984 | 1597984 | 2021-08-08 | Chester | Pennsylvania | 42029 | 41686 | 827 |
1594735 | 1594735 | 2021-08-07 | Chester | Pennsylvania | 42029 | 41686 | 827 |
1591486 | 1591486 | 2021-08-06 | Chester | Pennsylvania | 42029 | 41610 | 827 |
1588237 | 1588237 | 2021-08-05 | Chester | Pennsylvania | 42029 | 41541 | 827 |
1584987 | 1584987 | 2021-08-04 | Chester | Pennsylvania | 42029 | 41470 | 827 |
1581737 | 1581737 | 2021-08-03 | Chester | Pennsylvania | 42029 | 41423 | 826 |
1578488 | 1578488 | 2021-08-02 | Chester | Pennsylvania | 42029 | 41380 | 826 |
1575240 | 1575240 | 2021-08-01 | Chester | Pennsylvania | 42029 | 41336 | 826 |
1571992 | 1571992 | 2021-07-31 | Chester | Pennsylvania | 42029 | 41252 | 826 |
1568744 | 1568744 | 2021-07-30 | Chester | Pennsylvania | 42029 | 41252 | 826 |
1565496 | 1565496 | 2021-07-29 | Chester | Pennsylvania | 42029 | 41210 | 826 |
1562248 | 1562248 | 2021-07-28 | Chester | Pennsylvania | 42029 | 41184 | 826 |
1559000 | 1559000 | 2021-07-27 | Chester | Pennsylvania | 42029 | 41161 | 826 |
1555753 | 1555753 | 2021-07-26 | Chester | Pennsylvania | 42029 | 41123 | 826 |
1552506 | 1552506 | 2021-07-25 | Chester | Pennsylvania | 42029 | 41106 | 826 |
1549259 | 1549259 | 2021-07-24 | Chester | Pennsylvania | 42029 | 41087 | 826 |
1546012 | 1546012 | 2021-07-23 | Chester | Pennsylvania | 42029 | 41054 | 826 |
1542765 | 1542765 | 2021-07-22 | Chester | Pennsylvania | 42029 | 41025 | 826 |
1539517 | 1539517 | 2021-07-21 | Chester | Pennsylvania | 42029 | 41005 | 825 |
1536270 | 1536270 | 2021-07-20 | Chester | Pennsylvania | 42029 | 40982 | 825 |
1533022 | 1533022 | 2021-07-19 | Chester | Pennsylvania | 42029 | 40971 | 825 |
1529775 | 1529775 | 2021-07-18 | Chester | Pennsylvania | 42029 | 40963 | 825 |
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);