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 |
---|---|---|---|---|---|---|---|
2111401 | 2111401 | 2022-01-13 | Berks | Pennsylvania | 42011 | 89418 | 1397 |
2108149 | 2108149 | 2022-01-12 | Berks | Pennsylvania | 42011 | 88551 | 1387 |
2104898 | 2104898 | 2022-01-11 | Berks | Pennsylvania | 42011 | 87571 | 1374 |
2101647 | 2101647 | 2022-01-10 | Berks | Pennsylvania | 42011 | 86639 | 1368 |
2098396 | 2098396 | 2022-01-09 | Berks | Pennsylvania | 42011 | 85386 | 1366 |
2095144 | 2095144 | 2022-01-08 | Berks | Pennsylvania | 42011 | 84067 | 1366 |
2091892 | 2091892 | 2022-01-07 | Berks | Pennsylvania | 42011 | 82856 | 1360 |
2088640 | 2088640 | 2022-01-06 | Berks | Pennsylvania | 42011 | 81713 | 1356 |
2085389 | 2085389 | 2022-01-05 | Berks | Pennsylvania | 42011 | 80690 | 1346 |
2082137 | 2082137 | 2022-01-04 | Berks | Pennsylvania | 42011 | 79512 | 1342 |
2078885 | 2078885 | 2022-01-03 | Berks | Pennsylvania | 42011 | 78773 | 1328 |
2075634 | 2075634 | 2022-01-02 | Berks | Pennsylvania | 42011 | 78112 | 1320 |
2072383 | 2072383 | 2022-01-01 | Berks | Pennsylvania | 42011 | 77311 | 1320 |
2069132 | 2069132 | 2021-12-31 | Berks | Pennsylvania | 42011 | 76376 | 1319 |
2065881 | 2065881 | 2021-12-30 | Berks | Pennsylvania | 42011 | 75542 | 1318 |
2062631 | 2062631 | 2021-12-29 | Berks | Pennsylvania | 42011 | 74876 | 1311 |
2059381 | 2059381 | 2021-12-28 | Berks | Pennsylvania | 42011 | 74225 | 1294 |
2056132 | 2056132 | 2021-12-27 | Berks | Pennsylvania | 42011 | 73591 | 1290 |
2052883 | 2052883 | 2021-12-26 | Berks | Pennsylvania | 42011 | 73291 | 1289 |
2049633 | 2049633 | 2021-12-25 | Berks | Pennsylvania | 42011 | 73106 | 1289 |
2046383 | 2046383 | 2021-12-24 | Berks | Pennsylvania | 42011 | 72705 | 1289 |
2043133 | 2043133 | 2021-12-23 | Berks | Pennsylvania | 42011 | 72387 | 1282 |
2039884 | 2039884 | 2021-12-22 | Berks | Pennsylvania | 42011 | 72045 | 1278 |
2036634 | 2036634 | 2021-12-21 | Berks | Pennsylvania | 42011 | 71713 | 1271 |
2033384 | 2033384 | 2021-12-20 | Berks | Pennsylvania | 42011 | 71425 | 1266 |
2030134 | 2030134 | 2021-12-19 | Berks | Pennsylvania | 42011 | 71245 | 1266 |
2026883 | 2026883 | 2021-12-18 | Berks | Pennsylvania | 42011 | 70907 | 1265 |
2023632 | 2023632 | 2021-12-17 | Berks | Pennsylvania | 42011 | 70540 | 1256 |
2020381 | 2020381 | 2021-12-16 | Berks | Pennsylvania | 42011 | 70182 | 1255 |
2017130 | 2017130 | 2021-12-15 | Berks | Pennsylvania | 42011 | 69849 | 1252 |
2013880 | 2013880 | 2021-12-14 | Berks | Pennsylvania | 42011 | 69550 | 1244 |
2010629 | 2010629 | 2021-12-13 | Berks | Pennsylvania | 42011 | 69282 | 1236 |
2007378 | 2007378 | 2021-12-12 | Berks | Pennsylvania | 42011 | 69031 | 1236 |
2004127 | 2004127 | 2021-12-11 | Berks | Pennsylvania | 42011 | 68576 | 1233 |
2000876 | 2000876 | 2021-12-10 | Berks | Pennsylvania | 42011 | 68000 | 1231 |
1997626 | 1997626 | 2021-12-09 | Berks | Pennsylvania | 42011 | 67533 | 1227 |
1994375 | 1994375 | 2021-12-08 | Berks | Pennsylvania | 42011 | 67310 | 1225 |
1991124 | 1991124 | 2021-12-07 | Berks | Pennsylvania | 42011 | 66962 | 1223 |
1987873 | 1987873 | 2021-12-06 | Berks | Pennsylvania | 42011 | 66691 | 1220 |
1984623 | 1984623 | 2021-12-05 | Berks | Pennsylvania | 42011 | 66454 | 1220 |
1981373 | 1981373 | 2021-12-04 | Berks | Pennsylvania | 42011 | 66147 | 1219 |
1978123 | 1978123 | 2021-12-03 | Berks | Pennsylvania | 42011 | 65636 | 1215 |
1974873 | 1974873 | 2021-12-02 | Berks | Pennsylvania | 42011 | 65297 | 1214 |
1971624 | 1971624 | 2021-12-01 | Berks | Pennsylvania | 42011 | 64789 | 1210 |
1968374 | 1968374 | 2021-11-30 | Berks | Pennsylvania | 42011 | 64559 | 1209 |
1965123 | 1965123 | 2021-11-29 | Berks | Pennsylvania | 42011 | 64357 | 1202 |
1961871 | 1961871 | 2021-11-28 | Berks | Pennsylvania | 42011 | 64227 | 1201 |
1958620 | 1958620 | 2021-11-27 | Berks | Pennsylvania | 42011 | 64039 | 1199 |
1955369 | 1955369 | 2021-11-26 | Berks | Pennsylvania | 42011 | 63816 | 1199 |
1952118 | 1952118 | 2021-11-25 | Berks | Pennsylvania | 42011 | 63640 | 1199 |
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 |
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);