ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42011 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948867 | 1948867 | 2021-11-24 | Berks | Pennsylvania | 42011 | 63456 | 1195 |
1945616 | 1945616 | 2021-11-23 | Berks | Pennsylvania | 42011 | 63248 | 1190 |
1942365 | 1942365 | 2021-11-22 | Berks | Pennsylvania | 42011 | 63062 | 1189 |
1939115 | 1939115 | 2021-11-21 | Berks | Pennsylvania | 42011 | 62848 | 1189 |
1935865 | 1935865 | 2021-11-20 | Berks | Pennsylvania | 42011 | 62652 | 1189 |
1932615 | 1932615 | 2021-11-19 | Berks | Pennsylvania | 42011 | 62496 | 1186 |
1929364 | 1929364 | 2021-11-18 | Berks | Pennsylvania | 42011 | 62287 | 1183 |
1926114 | 1926114 | 2021-11-17 | Berks | Pennsylvania | 42011 | 62041 | 1183 |
1922864 | 1922864 | 2021-11-16 | Berks | Pennsylvania | 42011 | 61878 | 1182 |
1919615 | 1919615 | 2021-11-15 | Berks | Pennsylvania | 42011 | 61705 | 1181 |
1916365 | 1916365 | 2021-11-14 | Berks | Pennsylvania | 42011 | 61592 | 1180 |
1913115 | 1913115 | 2021-11-13 | Berks | Pennsylvania | 42011 | 61433 | 1179 |
1909865 | 1909865 | 2021-11-12 | Berks | Pennsylvania | 42011 | 60530 | 1177 |
1906616 | 1906616 | 2021-11-11 | Berks | Pennsylvania | 42011 | 60401 | 1177 |
1903367 | 1903367 | 2021-11-10 | Berks | Pennsylvania | 42011 | 60236 | 1172 |
1900117 | 1900117 | 2021-11-09 | Berks | Pennsylvania | 42011 | 60097 | 1164 |
1896867 | 1896867 | 2021-11-08 | Berks | Pennsylvania | 42011 | 59899 | 1164 |
1893617 | 1893617 | 2021-11-07 | Berks | Pennsylvania | 42011 | 59788 | 1164 |
1890367 | 1890367 | 2021-11-06 | Berks | Pennsylvania | 42011 | 59673 | 1164 |
1887117 | 1887117 | 2021-11-05 | Berks | Pennsylvania | 42011 | 59526 | 1164 |
1883867 | 1883867 | 2021-11-04 | Berks | Pennsylvania | 42011 | 59367 | 1161 |
1880618 | 1880618 | 2021-11-03 | Berks | Pennsylvania | 42011 | 59197 | 1158 |
1877369 | 1877369 | 2021-11-02 | Berks | Pennsylvania | 42011 | 59078 | 1156 |
1874120 | 1874120 | 2021-11-01 | Berks | Pennsylvania | 42011 | 58840 | 1154 |
1870871 | 1870871 | 2021-10-31 | Berks | Pennsylvania | 42011 | 58840 | 1154 |
1867622 | 1867622 | 2021-10-30 | Berks | Pennsylvania | 42011 | 58742 | 1152 |
1864373 | 1864373 | 2021-10-29 | Berks | Pennsylvania | 42011 | 58630 | 1150 |
1861124 | 1861124 | 2021-10-28 | Berks | Pennsylvania | 42011 | 58478 | 1148 |
1857875 | 1857875 | 2021-10-27 | Berks | Pennsylvania | 42011 | 58309 | 1147 |
1854626 | 1854626 | 2021-10-26 | Berks | Pennsylvania | 42011 | 58181 | 1141 |
1851377 | 1851377 | 2021-10-25 | Berks | Pennsylvania | 42011 | 58070 | 1136 |
1848127 | 1848127 | 2021-10-24 | Berks | Pennsylvania | 42011 | 57978 | 1136 |
1844877 | 1844877 | 2021-10-23 | Berks | Pennsylvania | 42011 | 57860 | 1136 |
1841627 | 1841627 | 2021-10-22 | Berks | Pennsylvania | 42011 | 57717 | 1136 |
1838378 | 1838378 | 2021-10-21 | Berks | Pennsylvania | 42011 | 57541 | 1135 |
1835129 | 1835129 | 2021-10-20 | Berks | Pennsylvania | 42011 | 57391 | 1133 |
1831880 | 1831880 | 2021-10-19 | Berks | Pennsylvania | 42011 | 57240 | 1125 |
1828631 | 1828631 | 2021-10-18 | Berks | Pennsylvania | 42011 | 57123 | 1124 |
1825382 | 1825382 | 2021-10-17 | Berks | Pennsylvania | 42011 | 57027 | 1122 |
1822133 | 1822133 | 2021-10-16 | Berks | Pennsylvania | 42011 | 56904 | 1122 |
1818884 | 1818884 | 2021-10-15 | Berks | Pennsylvania | 42011 | 56795 | 1122 |
1815635 | 1815635 | 2021-10-14 | Berks | Pennsylvania | 42011 | 56622 | 1119 |
1812387 | 1812387 | 2021-10-13 | Berks | Pennsylvania | 42011 | 56487 | 1113 |
1809138 | 1809138 | 2021-10-12 | Berks | Pennsylvania | 42011 | 56366 | 1108 |
1805888 | 1805888 | 2021-10-11 | Berks | Pennsylvania | 42011 | 56235 | 1103 |
1802638 | 1802638 | 2021-10-10 | Berks | Pennsylvania | 42011 | 56121 | 1103 |
1799389 | 1799389 | 2021-10-09 | Berks | Pennsylvania | 42011 | 55997 | 1103 |
1796140 | 1796140 | 2021-10-08 | Berks | Pennsylvania | 42011 | 55855 | 1103 |
1792891 | 1792891 | 2021-10-07 | Berks | Pennsylvania | 42011 | 55682 | 1101 |
1789642 | 1789642 | 2021-10-06 | Berks | Pennsylvania | 42011 | 55550 | 1099 |
1786394 | 1786394 | 2021-10-05 | Berks | Pennsylvania | 42011 | 55421 | 1094 |
1783145 | 1783145 | 2021-10-04 | Berks | Pennsylvania | 42011 | 55288 | 1093 |
1779896 | 1779896 | 2021-10-03 | Berks | Pennsylvania | 42011 | 55072 | 1092 |
1776646 | 1776646 | 2021-10-02 | Berks | Pennsylvania | 42011 | 54921 | 1090 |
1773396 | 1773396 | 2021-10-01 | Berks | Pennsylvania | 42011 | 54839 | 1090 |
1770146 | 1770146 | 2021-09-30 | Berks | Pennsylvania | 42011 | 54648 | 1089 |
1766897 | 1766897 | 2021-09-29 | Berks | Pennsylvania | 42011 | 54514 | 1089 |
1763648 | 1763648 | 2021-09-28 | Berks | Pennsylvania | 42011 | 54382 | 1086 |
1760399 | 1760399 | 2021-09-27 | Berks | Pennsylvania | 42011 | 54219 | 1085 |
1757151 | 1757151 | 2021-09-26 | Berks | Pennsylvania | 42011 | 54124 | 1085 |
1753903 | 1753903 | 2021-09-25 | Berks | Pennsylvania | 42011 | 53989 | 1085 |
1750655 | 1750655 | 2021-09-24 | Berks | Pennsylvania | 42011 | 53847 | 1083 |
1747406 | 1747406 | 2021-09-23 | Berks | Pennsylvania | 42011 | 53705 | 1081 |
1744156 | 1744156 | 2021-09-22 | Berks | Pennsylvania | 42011 | 53567 | 1081 |
1740907 | 1740907 | 2021-09-21 | Berks | Pennsylvania | 42011 | 53455 | 1077 |
1737658 | 1737658 | 2021-09-20 | Berks | Pennsylvania | 42011 | 53313 | 1074 |
1734408 | 1734408 | 2021-09-19 | Berks | Pennsylvania | 42011 | 53228 | 1074 |
1731158 | 1731158 | 2021-09-18 | Berks | Pennsylvania | 42011 | 53073 | 1073 |
1727908 | 1727908 | 2021-09-17 | Berks | Pennsylvania | 42011 | 52944 | 1073 |
1724659 | 1724659 | 2021-09-16 | Berks | Pennsylvania | 42011 | 52829 | 1072 |
1721410 | 1721410 | 2021-09-15 | Berks | Pennsylvania | 42011 | 52687 | 1066 |
1718162 | 1718162 | 2021-09-14 | Berks | Pennsylvania | 42011 | 52578 | 1064 |
1714914 | 1714914 | 2021-09-13 | Berks | Pennsylvania | 42011 | 52464 | 1062 |
1711668 | 1711668 | 2021-09-12 | Berks | Pennsylvania | 42011 | 52359 | 1062 |
1708421 | 1708421 | 2021-09-11 | Berks | Pennsylvania | 42011 | 52237 | 1062 |
1705174 | 1705174 | 2021-09-10 | Berks | Pennsylvania | 42011 | 52092 | 1058 |
1701924 | 1701924 | 2021-09-09 | Berks | Pennsylvania | 42011 | 51980 | 1058 |
1698675 | 1698675 | 2021-09-08 | Berks | Pennsylvania | 42011 | 51855 | 1057 |
1695427 | 1695427 | 2021-09-07 | Berks | Pennsylvania | 42011 | 51737 | 1056 |
1692179 | 1692179 | 2021-09-06 | Berks | Pennsylvania | 42011 | 51639 | 1056 |
1688930 | 1688930 | 2021-09-05 | Berks | Pennsylvania | 42011 | 51541 | 1056 |
1685680 | 1685680 | 2021-09-04 | Berks | Pennsylvania | 42011 | 51453 | 1053 |
1682429 | 1682429 | 2021-09-03 | Berks | Pennsylvania | 42011 | 51303 | 1052 |
1679179 | 1679179 | 2021-09-02 | Berks | Pennsylvania | 42011 | 51205 | 1051 |
1675931 | 1675931 | 2021-09-01 | Berks | Pennsylvania | 42011 | 51081 | 1048 |
1672684 | 1672684 | 2021-08-31 | Berks | Pennsylvania | 42011 | 50958 | 1048 |
1669436 | 1669436 | 2021-08-30 | Berks | Pennsylvania | 42011 | 50809 | 1048 |
1666189 | 1666189 | 2021-08-29 | Berks | Pennsylvania | 42011 | 50757 | 1048 |
1662941 | 1662941 | 2021-08-28 | Berks | Pennsylvania | 42011 | 50654 | 1048 |
1659693 | 1659693 | 2021-08-27 | Berks | Pennsylvania | 42011 | 50554 | 1048 |
1656444 | 1656444 | 2021-08-26 | Berks | Pennsylvania | 42011 | 50443 | 1047 |
1653197 | 1653197 | 2021-08-25 | Berks | Pennsylvania | 42011 | 50365 | 1045 |
1649950 | 1649950 | 2021-08-24 | Berks | Pennsylvania | 42011 | 50244 | 1045 |
1646701 | 1646701 | 2021-08-23 | Berks | Pennsylvania | 42011 | 50155 | 1045 |
1643452 | 1643452 | 2021-08-22 | Berks | Pennsylvania | 42011 | 50100 | 1045 |
1640202 | 1640202 | 2021-08-21 | Berks | Pennsylvania | 42011 | 50044 | 1045 |
1636952 | 1636952 | 2021-08-20 | Berks | Pennsylvania | 42011 | 49981 | 1045 |
1633702 | 1633702 | 2021-08-19 | Berks | Pennsylvania | 42011 | 49883 | 1045 |
1630455 | 1630455 | 2021-08-18 | Berks | Pennsylvania | 42011 | 49801 | 1045 |
1627208 | 1627208 | 2021-08-17 | Berks | Pennsylvania | 42011 | 49709 | 1045 |
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);