ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 42071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 502 ✖
- 1888 12
- 0 9
- 1165 9
- 1176 8
- 459 7
- 1171 7
- 1885 7
- 458 6
- 462 6
- 1077 6
- 1155 6
- 1163 6
- 1877 6
- 1873 5
- 392 4
- 428 4
- 432 4
- 479 4
- 496 4
- 1073 4
- 1080 4
- 1112 4
- 1123 4
- 1158 4
- 1160 4
- 1167 4
- 1170 4
- 1177 4
- 1197 4
- 1258 4
- 1521 4
- 1874 4
- 1875 4
- 383 3
- 401 3
- 407 3
- 411 3
- 421 3
- 429 3
- 445 3
- 468 3
- 474 3
- 489 3
- 506 3
- 837 3
- 1062 3
- 1086 3
- 1094 3
- 1105 3
- 1145 3
- 1154 3
- 1157 3
- 1166 3
- 1173 3
- 1174 3
- 1182 3
- 1190 3
- 1207 3
- 1226 3
- 1244 3
- 1281 3
- 1302 3
- 1370 3
- 1821 3
- 1841 3
- 1868 3
- 1878 3
- 1882 3
- 1890 3
- 2 2
- 3 2
- 5 2
- 24 2
- 281 2
- 297 2
- 317 2
- 318 2
- 322 2
- 329 2
- 346 2
- 354 2
- 356 2
- 357 2
- 365 2
- 367 2
- 372 2
- 388 2
- 406 2
- 408 2
- 410 2
- 425 2
- 439 2
- 441 2
- 447 2
- 449 2
- 455 2
- 461 2
- 467 2
- 472 2
- 481 2
- 513 2
- 698 2
- 741 2
- 949 2
- 979 2
- 980 2
- 998 2
- 1004 2
- 1030 2
- 1033 2
- 1053 2
- 1128 2
- 1130 2
- 1133 2
- 1148 2
- 1159 2
- 1172 2
- 1191 2
- 1217 2
- 1223 2
- 1330 2
- 1348 2
- 1363 2
- 1390 2
- 1399 2
- 1461 2
- 1555 2
- 1596 2
- 1640 2
- 1769 2
- 1797 2
- 1818 2
- 1849 2
- 1854 2
- 1876 2
- 1879 2
- 1880 2
- 1881 2
- 1 1
- 4 1
- 8 1
- 11 1
- 14 1
- 16 1
- 17 1
- 21 1
- 23 1
- 56 1
- 69 1
- 77 1
- 85 1
- 93 1
- 98 1
- 101 1
- 107 1
- 122 1
- 131 1
- 139 1
- 140 1
- 145 1
- 152 1
- 164 1
- 170 1
- 173 1
- 183 1
- 188 1
- 191 1
- 198 1
- 206 1
- 209 1
- 216 1
- 222 1
- 228 1
- 233 1
- 239 1
- 241 1
- 245 1
- 249 1
- 253 1
- 255 1
- 258 1
- 263 1
- 267 1
- 271 1
- 277 1
- 278 1
- 280 1
- 283 1
- 285 1
- 291 1
- 292 1
- 295 1
- 306 1
- 310 1
- 315 1
- 320 1
- 325 1
- 331 1
- 333 1
- 336 1
- 341 1
- 344 1
- 347 1
- 350 1
- 352 1
- 355 1
- 366 1
- 377 1
- 382 1
- 386 1
- 390 1
- 393 1
- 395 1
- 400 1
- 403 1
- 405 1
- 414 1
- 417 1
- 418 1
- 420 1
- 422 1
- 427 1
- 434 1
- 435 1
- 438 1
- 442 1
- 443 1
- 451 1
- 453 1
- 457 1
- 466 1
- 469 1
- 470 1
- 475 1
- 476 1
- 477 1
- 486 1
- 488 1
- 490 1
- 492 1
- 494 1
- 495 1
- 499 1
- 502 1
- 504 1
- 509 1
- 512 1
- 517 1
- 519 1
- 522 1
- 527 1
- 535 1
- 540 1
- 545 1
- 550 1
- 551 1
- 553 1
- 556 1
- 566 1
- 577 1
- 582 1
- 597 1
- 607 1
- 608 1
- 621 1
- 628 1
- 639 1
- 648 1
- 654 1
- 658 1
- 659 1
- 671 1
- 680 1
- 691 1
- 700 1
- 701 1
- 712 1
- 722 1
- 731 1
- 742 1
- 743 1
- 747 1
- 759 1
- 773 1
- 779 1
- 785 1
- 786 1
- 791 1
- 800 1
- 806 1
- 820 1
- 828 1
- 831 1
- 854 1
- 860 1
- 866 1
- 872 1
- 876 1
- 878 1
- 885 1
- 897 1
- 903 1
- 911 1
- 918 1
- 921 1
- 923 1
- 926 1
- 935 1
- 939 1
- 944 1
- 948 1
- 961 1
- 965 1
- 970 1
- 974 1
- 989 1
- 1003 1
- 1012 1
- 1017 1
- 1025 1
- 1034 1
- 1038 1
- 1041 1
- 1045 1
- 1049 1
- 1056 1
- 1057 1
- 1058 1
- 1063 1
- 1065 1
- 1066 1
- 1070 1
- 1072 1
- 1074 1
- 1075 1
- 1079 1
- 1082 1
- 1083 1
- 1084 1
- 1085 1
- 1087 1
- 1088 1
- 1091 1
- 1093 1
- 1096 1
- 1098 1
- 1100 1
- 1104 1
- 1107 1
- 1108 1
- 1111 1
- 1114 1
- 1117 1
- 1119 1
- 1124 1
- 1136 1
- 1138 1
- 1141 1
- 1143 1
- 1150 1
- 1151 1
- 1153 1
- 1156 1
- 1162 1
- 1168 1
- 1175 1
- 1178 1
- 1179 1
- 1180 1
- 1181 1
- 1183 1
- 1185 1
- 1187 1
- 1188 1
- 1195 1
- 1196 1
- 1201 1
- 1202 1
- 1205 1
- 1208 1
- 1212 1
- 1213 1
- 1215 1
- 1216 1
- 1218 1
- 1219 1
- 1231 1
- 1236 1
- 1241 1
- 1242 1
- 1245 1
- 1255 1
- 1257 1
- 1270 1
- 1275 1
- 1278 1
- 1287 1
- 1290 1
- 1294 1
- 1296 1
- 1301 1
- 1304 1
- 1315 1
- 1321 1
- 1327 1
- 1328 1
- 1331 1
- 1340 1
- 1343 1
- 1345 1
- 1349 1
- 1350 1
- 1359 1
- 1373 1
- 1376 1
- 1381 1
- 1386 1
- 1389 1
- 1393 1
- 1397 1
- 1400 1
- 1401 1
- 1402 1
- 1404 1
- 1407 1
- 1416 1
- 1417 1
- 1422 1
- 1424 1
- 1428 1
- 1435 1
- 1440 1
- 1443 1
- 1449 1
- 1456 1
- 1471 1
- 1478 1
- 1482 1
- 1486 1
- 1494 1
- 1496 1
- 1498 1
- 1506 1
- 1513 1
- 1518 1
- 1531 1
- 1545 1
- 1552 1
- 1554 1
- 1561 1
- 1564 1
- 1567 1
- 1579 1
- 1587 1
- 1592 1
- 1605 1
- 1612 1
- 1618 1
- 1627 1
- 1639 1
- 1643 1
- 1645 1
- 1654 1
- 1666 1
- 1672 1
- 1677 1
- 1679 1
- 1687 1
- 1694 1
- 1705 1
- 1715 1
- 1720 1
- 1722 1
- 1725 1
- 1728 1
- 1746 1
- 1755 1
- 1763 1
- 1774 1
- 1782 1
- 1784 1
- 1790 1
- 1794 1
- 1799 1
- 1803 1
- 1808 1
- 1814 1
- 1831 1
- 1836 1
- 1838 1
- 1843 1
- 1845 1
- 1847 1
- 1857 1
- 1862 1
- 1865 1
- 1867 1
- 1870 1
- 1872 1
- 1883 1
- 1884 1
- 1886 1
state 1
- Pennsylvania 786
fips 1
- 42071 · 786 ✖
county 1
- Lancaster 786
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501882 | 2501882 | 2022-05-13 | Lancaster | Pennsylvania | 42071 | 122794 | 1890 |
2498624 | 2498624 | 2022-05-12 | Lancaster | Pennsylvania | 42071 | 122794 | 1890 |
2495366 | 2495366 | 2022-05-11 | Lancaster | Pennsylvania | 42071 | 122794 | 1890 |
2492108 | 2492108 | 2022-05-10 | Lancaster | Pennsylvania | 42071 | 122133 | 1888 |
2488850 | 2488850 | 2022-05-09 | Lancaster | Pennsylvania | 42071 | 122133 | 1888 |
2485593 | 2485593 | 2022-05-08 | Lancaster | Pennsylvania | 42071 | 122133 | 1888 |
2482335 | 2482335 | 2022-05-07 | Lancaster | Pennsylvania | 42071 | 122133 | 1888 |
2479077 | 2479077 | 2022-05-06 | Lancaster | Pennsylvania | 42071 | 122133 | 1888 |
2475819 | 2475819 | 2022-05-05 | Lancaster | Pennsylvania | 42071 | 122133 | 1888 |
2472562 | 2472562 | 2022-05-04 | Lancaster | Pennsylvania | 42071 | 122133 | 1888 |
2469306 | 2469306 | 2022-05-03 | Lancaster | Pennsylvania | 42071 | 122045 | 1888 |
2466050 | 2466050 | 2022-05-02 | Lancaster | Pennsylvania | 42071 | 121955 | 1888 |
2462795 | 2462795 | 2022-05-01 | Lancaster | Pennsylvania | 42071 | 121928 | 1888 |
2459539 | 2459539 | 2022-04-30 | Lancaster | Pennsylvania | 42071 | 121889 | 1888 |
2456283 | 2456283 | 2022-04-29 | Lancaster | Pennsylvania | 42071 | 121794 | 1888 |
2453027 | 2453027 | 2022-04-28 | Lancaster | Pennsylvania | 42071 | 121716 | 1886 |
2449771 | 2449771 | 2022-04-27 | Lancaster | Pennsylvania | 42071 | 121638 | 1885 |
2446514 | 2446514 | 2022-04-26 | Lancaster | Pennsylvania | 42071 | 121577 | 1885 |
2443259 | 2443259 | 2022-04-25 | Lancaster | Pennsylvania | 42071 | 121521 | 1885 |
2440003 | 2440003 | 2022-04-24 | Lancaster | Pennsylvania | 42071 | 121483 | 1885 |
2436747 | 2436747 | 2022-04-23 | Lancaster | Pennsylvania | 42071 | 121449 | 1885 |
2433491 | 2433491 | 2022-04-22 | Lancaster | Pennsylvania | 42071 | 121407 | 1885 |
2430235 | 2430235 | 2022-04-21 | Lancaster | Pennsylvania | 42071 | 121355 | 1885 |
2426979 | 2426979 | 2022-04-20 | Lancaster | Pennsylvania | 42071 | 121302 | 1884 |
2423723 | 2423723 | 2022-04-19 | Lancaster | Pennsylvania | 42071 | 121270 | 1883 |
2420467 | 2420467 | 2022-04-18 | Lancaster | Pennsylvania | 42071 | 121233 | 1882 |
2417211 | 2417211 | 2022-04-17 | Lancaster | Pennsylvania | 42071 | 121212 | 1882 |
2413955 | 2413955 | 2022-04-16 | Lancaster | Pennsylvania | 42071 | 121190 | 1882 |
2410699 | 2410699 | 2022-04-15 | Lancaster | Pennsylvania | 42071 | 121145 | 1881 |
2407443 | 2407443 | 2022-04-14 | Lancaster | Pennsylvania | 42071 | 121102 | 1881 |
2404187 | 2404187 | 2022-04-13 | Lancaster | Pennsylvania | 42071 | 121065 | 1880 |
2400932 | 2400932 | 2022-04-12 | Lancaster | Pennsylvania | 42071 | 121018 | 1880 |
2397677 | 2397677 | 2022-04-11 | Lancaster | Pennsylvania | 42071 | 120987 | 1879 |
2394422 | 2394422 | 2022-04-10 | Lancaster | Pennsylvania | 42071 | 120978 | 1879 |
2391166 | 2391166 | 2022-04-09 | Lancaster | Pennsylvania | 42071 | 120966 | 1878 |
2387910 | 2387910 | 2022-04-08 | Lancaster | Pennsylvania | 42071 | 120934 | 1878 |
2384655 | 2384655 | 2022-04-07 | Lancaster | Pennsylvania | 42071 | 120890 | 1878 |
2381400 | 2381400 | 2022-04-06 | Lancaster | Pennsylvania | 42071 | 120864 | 1877 |
2378145 | 2378145 | 2022-04-05 | Lancaster | Pennsylvania | 42071 | 120835 | 1877 |
2374891 | 2374891 | 2022-04-04 | Lancaster | Pennsylvania | 42071 | 120813 | 1877 |
2371639 | 2371639 | 2022-04-03 | Lancaster | Pennsylvania | 42071 | 120789 | 1877 |
2368386 | 2368386 | 2022-04-02 | Lancaster | Pennsylvania | 42071 | 120789 | 1877 |
2365133 | 2365133 | 2022-04-01 | Lancaster | Pennsylvania | 42071 | 120770 | 1877 |
2361880 | 2361880 | 2022-03-31 | Lancaster | Pennsylvania | 42071 | 120748 | 1876 |
2358626 | 2358626 | 2022-03-30 | Lancaster | Pennsylvania | 42071 | 120723 | 1876 |
2355372 | 2355372 | 2022-03-29 | Lancaster | Pennsylvania | 42071 | 120712 | 1875 |
2352119 | 2352119 | 2022-03-28 | Lancaster | Pennsylvania | 42071 | 120684 | 1875 |
2348867 | 2348867 | 2022-03-27 | Lancaster | Pennsylvania | 42071 | 120676 | 1875 |
2345614 | 2345614 | 2022-03-26 | Lancaster | Pennsylvania | 42071 | 120664 | 1875 |
2342361 | 2342361 | 2022-03-25 | Lancaster | Pennsylvania | 42071 | 120648 | 1874 |
2339108 | 2339108 | 2022-03-24 | Lancaster | Pennsylvania | 42071 | 120628 | 1874 |
2335854 | 2335854 | 2022-03-23 | Lancaster | Pennsylvania | 42071 | 120605 | 1874 |
2332600 | 2332600 | 2022-03-22 | Lancaster | Pennsylvania | 42071 | 120588 | 1874 |
2329347 | 2329347 | 2022-03-21 | Lancaster | Pennsylvania | 42071 | 120575 | 1873 |
2326095 | 2326095 | 2022-03-20 | Lancaster | Pennsylvania | 42071 | 120566 | 1873 |
2322842 | 2322842 | 2022-03-19 | Lancaster | Pennsylvania | 42071 | 120558 | 1873 |
2319588 | 2319588 | 2022-03-18 | Lancaster | Pennsylvania | 42071 | 120546 | 1873 |
2316334 | 2316334 | 2022-03-17 | Lancaster | Pennsylvania | 42071 | 120523 | 1873 |
2313081 | 2313081 | 2022-03-16 | Lancaster | Pennsylvania | 42071 | 120499 | 1872 |
2309828 | 2309828 | 2022-03-15 | Lancaster | Pennsylvania | 42071 | 120483 | 1870 |
2306575 | 2306575 | 2022-03-14 | Lancaster | Pennsylvania | 42071 | 120466 | 1868 |
2303324 | 2303324 | 2022-03-13 | Lancaster | Pennsylvania | 42071 | 120453 | 1868 |
2300072 | 2300072 | 2022-03-12 | Lancaster | Pennsylvania | 42071 | 120442 | 1868 |
2296820 | 2296820 | 2022-03-11 | Lancaster | Pennsylvania | 42071 | 120413 | 1867 |
2293568 | 2293568 | 2022-03-10 | Lancaster | Pennsylvania | 42071 | 120391 | 1865 |
2290316 | 2290316 | 2022-03-09 | Lancaster | Pennsylvania | 42071 | 120366 | 1862 |
2287064 | 2287064 | 2022-03-08 | Lancaster | Pennsylvania | 42071 | 120336 | 1857 |
2283812 | 2283812 | 2022-03-07 | Lancaster | Pennsylvania | 42071 | 120295 | 1854 |
2280560 | 2280560 | 2022-03-06 | Lancaster | Pennsylvania | 42071 | 120277 | 1854 |
2277307 | 2277307 | 2022-03-05 | Lancaster | Pennsylvania | 42071 | 120253 | 1849 |
2274054 | 2274054 | 2022-03-04 | Lancaster | Pennsylvania | 42071 | 120229 | 1849 |
2270801 | 2270801 | 2022-03-03 | Lancaster | Pennsylvania | 42071 | 120201 | 1847 |
2267549 | 2267549 | 2022-03-02 | Lancaster | Pennsylvania | 42071 | 120155 | 1845 |
2264296 | 2264296 | 2022-03-01 | Lancaster | Pennsylvania | 42071 | 120121 | 1843 |
2261046 | 2261046 | 2022-02-28 | Lancaster | Pennsylvania | 42071 | 120098 | 1841 |
2257795 | 2257795 | 2022-02-27 | Lancaster | Pennsylvania | 42071 | 120068 | 1841 |
2254544 | 2254544 | 2022-02-26 | Lancaster | Pennsylvania | 42071 | 120040 | 1841 |
2251293 | 2251293 | 2022-02-25 | Lancaster | Pennsylvania | 42071 | 119978 | 1838 |
2248042 | 2248042 | 2022-02-24 | Lancaster | Pennsylvania | 42071 | 119897 | 1836 |
2244791 | 2244791 | 2022-02-23 | Lancaster | Pennsylvania | 42071 | 119815 | 1831 |
2241540 | 2241540 | 2022-02-22 | Lancaster | Pennsylvania | 42071 | 119761 | 1821 |
2238289 | 2238289 | 2022-02-21 | Lancaster | Pennsylvania | 42071 | 119652 | 1821 |
2235038 | 2235038 | 2022-02-20 | Lancaster | Pennsylvania | 42071 | 119652 | 1821 |
2231787 | 2231787 | 2022-02-19 | Lancaster | Pennsylvania | 42071 | 119595 | 1818 |
2228536 | 2228536 | 2022-02-18 | Lancaster | Pennsylvania | 42071 | 119432 | 1818 |
2225285 | 2225285 | 2022-02-17 | Lancaster | Pennsylvania | 42071 | 119345 | 1814 |
2222034 | 2222034 | 2022-02-16 | Lancaster | Pennsylvania | 42071 | 119224 | 1808 |
2218783 | 2218783 | 2022-02-15 | Lancaster | Pennsylvania | 42071 | 119153 | 1803 |
2215532 | 2215532 | 2022-02-14 | Lancaster | Pennsylvania | 42071 | 119046 | 1799 |
2212281 | 2212281 | 2022-02-13 | Lancaster | Pennsylvania | 42071 | 118976 | 1797 |
2209028 | 2209028 | 2022-02-12 | Lancaster | Pennsylvania | 42071 | 118889 | 1797 |
2205775 | 2205775 | 2022-02-11 | Lancaster | Pennsylvania | 42071 | 118722 | 1794 |
2202522 | 2202522 | 2022-02-10 | Lancaster | Pennsylvania | 42071 | 118545 | 1790 |
2199268 | 2199268 | 2022-02-09 | Lancaster | Pennsylvania | 42071 | 118376 | 1784 |
2196014 | 2196014 | 2022-02-08 | Lancaster | Pennsylvania | 42071 | 118203 | 1782 |
2192760 | 2192760 | 2022-02-07 | Lancaster | Pennsylvania | 42071 | 118684 | 1774 |
2189506 | 2189506 | 2022-02-06 | Lancaster | Pennsylvania | 42071 | 118144 | 1769 |
2186253 | 2186253 | 2022-02-05 | Lancaster | Pennsylvania | 42071 | 118004 | 1769 |
2183001 | 2183001 | 2022-02-04 | Lancaster | Pennsylvania | 42071 | 117574 | 1763 |
2179749 | 2179749 | 2022-02-03 | Lancaster | Pennsylvania | 42071 | 117315 | 1755 |
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);