ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 42119 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 666 ✖
- 11797 7
- 4 5
- 6170 5
- 31 4
- 38 4
- 40 4
- 56 4
- 89 4
- 359 4
- 6153 4
- 6162 4
- 6168 4
- 83 3
- 90 3
- 95 3
- 472 3
- 6138 3
- 6151 3
- 6156 3
- 11682 3
- 11842 3
- 6 2
- 23 2
- 27 2
- 30 2
- 33 2
- 41 2
- 59 2
- 61 2
- 73 2
- 81 2
- 84 2
- 88 2
- 92 2
- 97 2
- 98 2
- 108 2
- 113 2
- 276 2
- 397 2
- 425 2
- 451 2
- 475 2
- 490 2
- 646 2
- 4913 2
- 5261 2
- 5273 2
- 5284 2
- 5311 2
- 5369 2
- 6094 2
- 6128 2
- 6140 2
- 6150 2
- 6152 2
- 6154 2
- 6157 2
- 6167 2
- 6177 2
- 6179 2
- 6190 2
- 6199 2
- 6207 2
- 7518 2
- 11473 2
- 11650 2
- 11670 2
- 11679 2
- 11683 2
- 11697 2
- 5 1
- 7 1
- 8 1
- 11 1
- 12 1
- 14 1
- 19 1
- 21 1
- 25 1
- 26 1
- 28 1
- 29 1
- 36 1
- 37 1
- 39 1
- 42 1
- 43 1
- 44 1
- 46 1
- 47 1
- 50 1
- 51 1
- 52 1
- 53 1
- 54 1
- 57 1
- 60 1
- 62 1
- 63 1
- 65 1
- 70 1
- 71 1
- 74 1
- 75 1
- 79 1
- 85 1
- 91 1
- 93 1
- 94 1
- 96 1
- 99 1
- 100 1
- 105 1
- 109 1
- 110 1
- 111 1
- 114 1
- 115 1
- 116 1
- 119 1
- 123 1
- 124 1
- 128 1
- 129 1
- 132 1
- 135 1
- 165 1
- 172 1
- 173 1
- 191 1
- 201 1
- 206 1
- 216 1
- 218 1
- 225 1
- 238 1
- 262 1
- 279 1
- 292 1
- 305 1
- 306 1
- 310 1
- 322 1
- 344 1
- 347 1
- 354 1
- 361 1
- 367 1
- 371 1
- 372 1
- 377 1
- 386 1
- 390 1
- 406 1
- 407 1
- 411 1
- 414 1
- 416 1
- 417 1
- 420 1
- 435 1
- 438 1
- 439 1
- 448 1
- 452 1
- 453 1
- 454 1
- 459 1
- 462 1
- 464 1
- 477 1
- 558 1
- 568 1
- 571 1
- 576 1
- 577 1
- 586 1
- 597 1
- 600 1
- 611 1
- 613 1
- 619 1
- 634 1
- 636 1
- 637 1
- 641 1
- 647 1
- 659 1
- 672 1
- 678 1
- 690 1
- 699 1
- 700 1
- 702 1
- 705 1
- 714 1
- 726 1
- 745 1
- 746 1
- 749 1
- 756 1
- 759 1
- 770 1
- 785 1
- 823 1
- 845 1
- 858 1
- 868 1
- 901 1
- 922 1
- 966 1
- 1003 1
- 1016 1
- 1031 1
- 1041 1
- 1084 1
- 1187 1
- 1234 1
- 1308 1
- 1335 1
- 1378 1
- 1456 1
- 1553 1
- 1620 1
- 1643 1
- 1663 1
- 1679 1
- 1709 1
- 1739 1
- 1781 1
- 1829 1
- 1870 1
- 1887 1
- 1919 1
- 1954 1
- 1984 1
- 2039 1
- 2100 1
- 2132 1
- 2180 1
- 2219 1
- 2235 1
- 2279 1
- 2323 1
- 2354 1
- 2423 1
- 2453 1
- 2505 1
- 2567 1
- 2622 1
- 2648 1
- 2719 1
- 2755 1
- 2773 1
- 2789 1
- 2816 1
- 2850 1
- 2891 1
- 2940 1
- 2953 1
- 2983 1
- 3001 1
- 3049 1
- 3102 1
- 3157 1
- 3235 1
- 3340 1
- 3381 1
- 3416 1
- 3452 1
- 3560 1
- 3589 1
- 3613 1
- 3647 1
- 3667 1
- 3673 1
- 3688 1
- 3747 1
- 3777 1
- 3812 1
- 3849 1
- 3866 1
- 3892 1
- 3915 1
- 3946 1
- 3972 1
- 4011 1
- 4039 1
- 4056 1
- 4071 1
- 4080 1
- 4089 1
- 4116 1
- 4854 1
- 4856 1
- 4876 1
- 4893 1
- 4950 1
- 4976 1
- 4991 1
- 5021 1
- 5054 1
- 5059 1
- 5066 1
- 5068 1
- 5070 1
- 5082 1
- 5091 1
- 5093 1
- 5097 1
- 5116 1
- 5140 1
- 5264 1
- 5268 1
- 5271 1
- 5279 1
- 5281 1
- 5292 1
- 5303 1
- 5306 1
- 5308 1
- 5317 1
- 5320 1
- 5325 1
- 5341 1
- 5351 1
- 5359 1
- 5372 1
- 5383 1
- 5399 1
- 5401 1
- 5403 1
- 5406 1
- 5409 1
- 5411 1
- 5412 1
- 5418 1
- 5433 1
- 5448 1
- 5456 1
- 5462 1
- 5484 1
- 5503 1
- 5521 1
- 5528 1
- 5553 1
- 5567 1
- 5583 1
- 5604 1
- 5629 1
- 5649 1
- 5665 1
- 5709 1
- 5733 1
- 5740 1
- 5758 1
- 5770 1
- 5788 1
- 5801 1
- 5825 1
- 5835 1
- 5843 1
- 5853 1
- 5882 1
- 5899 1
- 5920 1
- 5928 1
- 5943 1
- 5948 1
- 5952 1
- 5965 1
- 5973 1
- 5993 1
- 6004 1
- 6006 1
- 6010 1
- 6022 1
- 6034 1
- 6047 1
- 6051 1
- 6054 1
- 6057 1
- 6061 1
- 6071 1
- 6076 1
- 6084 1
- 6098 1
- 6103 1
- 6110 1
- 6115 1
- 6120 1
- 6124 1
- 6125 1
- 6127 1
- 6129 1
- 6130 1
- 6136 1
- 6142 1
- 6143 1
- 6158 1
- 6159 1
- 6160 1
- 6164 1
- 6165 1
- 6166 1
- 6169 1
- 6172 1
- 6174 1
- 6178 1
- 6185 1
- 6195 1
- 6201 1
- 6202 1
- 6204 1
- 6211 1
- 6216 1
- 6222 1
- 6223 1
- 6225 1
- 6229 1
- 6232 1
- 6237 1
- 6246 1
- 6250 1
- 6262 1
- 6267 1
- 6271 1
- 6273 1
- 6277 1
- 6286 1
- 6300 1
- 6307 1
- 6312 1
- 6318 1
- 6323 1
- 6328 1
- 6341 1
- 6357 1
- 6367 1
- 6377 1
- 6398 1
- 6410 1
- 6414 1
- 6417 1
- 6452 1
- 6480 1
- 6510 1
- 6525 1
- 6539 1
- 6548 1
- 6568 1
- 6590 1
- 6612 1
- 6628 1
- 6648 1
- 6655 1
- 6663 1
- 6677 1
- 6694 1
- 6708 1
- 6723 1
- 6747 1
- 6760 1
- 6778 1
- 6801 1
- 6814 1
- 6831 1
- 6853 1
- 6869 1
- 6900 1
- 6915 1
- 6926 1
- 6944 1
- 6969 1
- 7002 1
- 7024 1
- 7048 1
- 7071 1
- 7091 1
- 7110 1
- 7140 1
- 7165 1
- 7177 1
- 7184 1
- 7197 1
- 7203 1
- 7227 1
- 7260 1
- 7297 1
- 7339 1
- 7357 1
- 7373 1
- 7400 1
- 7429 1
- 7457 1
- 7469 1
- 7514 1
- 7552 1
- 7569 1
- 7584 1
- 7612 1
- 7625 1
- 7636 1
- 7651 1
- 7674 1
- 7686 1
- 7700 1
- 7710 1
- 7814 1
- 7837 1
- 7850 1
- 7861 1
- 7882 1
- 7894 1
- 7913 1
- 7933 1
- 7949 1
- 7969 1
- 7989 1
- 8020 1
- 8036 1
- 8080 1
- 8105 1
- 8110 1
- 8121 1
- 8139 1
- 8155 1
- 8194 1
- 8228 1
- 8264 1
- 8287 1
- 8295 1
- 8320 1
- 8358 1
- 8395 1
- 8439 1
- 8467 1
- 8501 1
- 8519 1
- 8560 1
- 8575 1
- 8606 1
- 8623 1
- 8645 1
- 8666 1
- 8677 1
- 8711 1
- 8736 1
- 8782 1
- 8816 1
- 8827 1
- 8851 1
- 8855 1
- 8885 1
- 8922 1
- 8948 1
- 8991 1
- 9011 1
- 9048 1
- 9085 1
- 9113 1
- 9166 1
- 9211 1
- 9293 1
- 9363 1
- 9412 1
- 9499 1
- 9545 1
- 9599 1
- 9658 1
- 9752 1
- 9844 1
- 9975 1
- 10022 1
- 10230 1
- 10310 1
- 10402 1
- 10481 1
- 10553 1
- 10589 1
- 10642 1
- 10688 1
- 10736 1
- 10829 1
- 10914 1
- 10982 1
- 11015 1
- 11036 1
- 11062 1
- 11090 1
- 11128 1
- 11157 1
- 11228 1
- 11239 1
- 11276 1
- 11301 1
- 11310 1
- 11333 1
- 11362 1
- 11381 1
- 11389 1
- 11391 1
- 11397 1
- 11415 1
- 11432 1
- 11449 1
- 11471 1
- 11484 1
- 11498 1
- 11512 1
- 11530 1
- 11541 1
- 11544 1
- 11548 1
- 11555 1
- 11567 1
- 11581 1
- 11600 1
- 11608 1
- 11612 1
- 11616 1
- 11626 1
- 11633 1
- 11641 1
- 11647 1
- 11649 1
- 11651 1
- 11652 1
- 11657 1
- 11658 1
- 11662 1
- 11663 1
- 11664 1
- 11665 1
- 11667 1
- 11668 1
- 11669 1
- 11671 1
- 11674 1
- 11675 1
- 11677 1
- 11678 1
- 11680 1
- 11685 1
- 11687 1
- 11691 1
- 11701 1
- 11702 1
- 11705 1
- 11707 1
- 11708 1
- 11716 1
- 11720 1
- 11724 1
- 11729 1
- 11730 1
- 11732 1
- 11737 1
- 11767 1
- 11770 1
- 11779 1
- 11783 1
- 11788 1
- 11791 1
- 11795 1
state 1
- Pennsylvania · 775 ✖
fips 1
- 42119 · 775 ✖
county 1
- Union 775
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501906 | 2501906 | 2022-05-13 | Union | Pennsylvania | 42119 | 11842 | 154 |
2498648 | 2498648 | 2022-05-12 | Union | Pennsylvania | 42119 | 11842 | 154 |
2495390 | 2495390 | 2022-05-11 | Union | Pennsylvania | 42119 | 11842 | 154 |
2492132 | 2492132 | 2022-05-10 | Union | Pennsylvania | 42119 | 11797 | 154 |
2488874 | 2488874 | 2022-05-09 | Union | Pennsylvania | 42119 | 11797 | 154 |
2485617 | 2485617 | 2022-05-08 | Union | Pennsylvania | 42119 | 11797 | 154 |
2482359 | 2482359 | 2022-05-07 | Union | Pennsylvania | 42119 | 11797 | 154 |
2479101 | 2479101 | 2022-05-06 | Union | Pennsylvania | 42119 | 11797 | 154 |
2475843 | 2475843 | 2022-05-05 | Union | Pennsylvania | 42119 | 11797 | 154 |
2472586 | 2472586 | 2022-05-04 | Union | Pennsylvania | 42119 | 11797 | 154 |
2469330 | 2469330 | 2022-05-03 | Union | Pennsylvania | 42119 | 11795 | 154 |
2466074 | 2466074 | 2022-05-02 | Union | Pennsylvania | 42119 | 11791 | 154 |
2462819 | 2462819 | 2022-05-01 | Union | Pennsylvania | 42119 | 11788 | 154 |
2459563 | 2459563 | 2022-04-30 | Union | Pennsylvania | 42119 | 11783 | 154 |
2456307 | 2456307 | 2022-04-29 | Union | Pennsylvania | 42119 | 11779 | 154 |
2453051 | 2453051 | 2022-04-28 | Union | Pennsylvania | 42119 | 11770 | 154 |
2449795 | 2449795 | 2022-04-27 | Union | Pennsylvania | 42119 | 11767 | 154 |
2446538 | 2446538 | 2022-04-26 | Union | Pennsylvania | 42119 | 11737 | 154 |
2443283 | 2443283 | 2022-04-25 | Union | Pennsylvania | 42119 | 11732 | 154 |
2440027 | 2440027 | 2022-04-24 | Union | Pennsylvania | 42119 | 11730 | 154 |
2436771 | 2436771 | 2022-04-23 | Union | Pennsylvania | 42119 | 11729 | 154 |
2433515 | 2433515 | 2022-04-22 | Union | Pennsylvania | 42119 | 11724 | 154 |
2430259 | 2430259 | 2022-04-21 | Union | Pennsylvania | 42119 | 11720 | 154 |
2427003 | 2427003 | 2022-04-20 | Union | Pennsylvania | 42119 | 11716 | 154 |
2423747 | 2423747 | 2022-04-19 | Union | Pennsylvania | 42119 | 11708 | 154 |
2420491 | 2420491 | 2022-04-18 | Union | Pennsylvania | 42119 | 11707 | 153 |
2417235 | 2417235 | 2022-04-17 | Union | Pennsylvania | 42119 | 11705 | 153 |
2413979 | 2413979 | 2022-04-16 | Union | Pennsylvania | 42119 | 11702 | 153 |
2410723 | 2410723 | 2022-04-15 | Union | Pennsylvania | 42119 | 11701 | 153 |
2407467 | 2407467 | 2022-04-14 | Union | Pennsylvania | 42119 | 11697 | 153 |
2404211 | 2404211 | 2022-04-13 | Union | Pennsylvania | 42119 | 11697 | 153 |
2400956 | 2400956 | 2022-04-12 | Union | Pennsylvania | 42119 | 11691 | 153 |
2397701 | 2397701 | 2022-04-11 | Union | Pennsylvania | 42119 | 11687 | 153 |
2394446 | 2394446 | 2022-04-10 | Union | Pennsylvania | 42119 | 11685 | 153 |
2391190 | 2391190 | 2022-04-09 | Union | Pennsylvania | 42119 | 11683 | 153 |
2387934 | 2387934 | 2022-04-08 | Union | Pennsylvania | 42119 | 11683 | 153 |
2384679 | 2384679 | 2022-04-07 | Union | Pennsylvania | 42119 | 11682 | 153 |
2381424 | 2381424 | 2022-04-06 | Union | Pennsylvania | 42119 | 11682 | 153 |
2378169 | 2378169 | 2022-04-05 | Union | Pennsylvania | 42119 | 11682 | 153 |
2374915 | 2374915 | 2022-04-04 | Union | Pennsylvania | 42119 | 11680 | 153 |
2371663 | 2371663 | 2022-04-03 | Union | Pennsylvania | 42119 | 11679 | 153 |
2368410 | 2368410 | 2022-04-02 | Union | Pennsylvania | 42119 | 11679 | 153 |
2365157 | 2365157 | 2022-04-01 | Union | Pennsylvania | 42119 | 11678 | 153 |
2361904 | 2361904 | 2022-03-31 | Union | Pennsylvania | 42119 | 11677 | 153 |
2358650 | 2358650 | 2022-03-30 | Union | Pennsylvania | 42119 | 11675 | 153 |
2355396 | 2355396 | 2022-03-29 | Union | Pennsylvania | 42119 | 11674 | 153 |
2352143 | 2352143 | 2022-03-28 | Union | Pennsylvania | 42119 | 11671 | 152 |
2348891 | 2348891 | 2022-03-27 | Union | Pennsylvania | 42119 | 11670 | 152 |
2345638 | 2345638 | 2022-03-26 | Union | Pennsylvania | 42119 | 11670 | 152 |
2342385 | 2342385 | 2022-03-25 | Union | Pennsylvania | 42119 | 11669 | 152 |
2339132 | 2339132 | 2022-03-24 | Union | Pennsylvania | 42119 | 11668 | 151 |
2335878 | 2335878 | 2022-03-23 | Union | Pennsylvania | 42119 | 11667 | 151 |
2332624 | 2332624 | 2022-03-22 | Union | Pennsylvania | 42119 | 11665 | 151 |
2329371 | 2329371 | 2022-03-21 | Union | Pennsylvania | 42119 | 11664 | 151 |
2326119 | 2326119 | 2022-03-20 | Union | Pennsylvania | 42119 | 11663 | 151 |
2322866 | 2322866 | 2022-03-19 | Union | Pennsylvania | 42119 | 11662 | 151 |
2319612 | 2319612 | 2022-03-18 | Union | Pennsylvania | 42119 | 11658 | 151 |
2316358 | 2316358 | 2022-03-17 | Union | Pennsylvania | 42119 | 11657 | 151 |
2313105 | 2313105 | 2022-03-16 | Union | Pennsylvania | 42119 | 11652 | 151 |
2309852 | 2309852 | 2022-03-15 | Union | Pennsylvania | 42119 | 11651 | 151 |
2306599 | 2306599 | 2022-03-14 | Union | Pennsylvania | 42119 | 11650 | 151 |
2303348 | 2303348 | 2022-03-13 | Union | Pennsylvania | 42119 | 11650 | 151 |
2300096 | 2300096 | 2022-03-12 | Union | Pennsylvania | 42119 | 11649 | 151 |
2296844 | 2296844 | 2022-03-11 | Union | Pennsylvania | 42119 | 11647 | 151 |
2293592 | 2293592 | 2022-03-10 | Union | Pennsylvania | 42119 | 11641 | 151 |
2290340 | 2290340 | 2022-03-09 | Union | Pennsylvania | 42119 | 11633 | 151 |
2287088 | 2287088 | 2022-03-08 | Union | Pennsylvania | 42119 | 11626 | 151 |
2283836 | 2283836 | 2022-03-07 | Union | Pennsylvania | 42119 | 11616 | 151 |
2280584 | 2280584 | 2022-03-06 | Union | Pennsylvania | 42119 | 11612 | 151 |
2277331 | 2277331 | 2022-03-05 | Union | Pennsylvania | 42119 | 11608 | 151 |
2274078 | 2274078 | 2022-03-04 | Union | Pennsylvania | 42119 | 11600 | 151 |
2270825 | 2270825 | 2022-03-03 | Union | Pennsylvania | 42119 | 11581 | 151 |
2267573 | 2267573 | 2022-03-02 | Union | Pennsylvania | 42119 | 11567 | 150 |
2264320 | 2264320 | 2022-03-01 | Union | Pennsylvania | 42119 | 11555 | 150 |
2261070 | 2261070 | 2022-02-28 | Union | Pennsylvania | 42119 | 11548 | 150 |
2257819 | 2257819 | 2022-02-27 | Union | Pennsylvania | 42119 | 11544 | 150 |
2254568 | 2254568 | 2022-02-26 | Union | Pennsylvania | 42119 | 11541 | 150 |
2251317 | 2251317 | 2022-02-25 | Union | Pennsylvania | 42119 | 11530 | 150 |
2248066 | 2248066 | 2022-02-24 | Union | Pennsylvania | 42119 | 11512 | 148 |
2244815 | 2244815 | 2022-02-23 | Union | Pennsylvania | 42119 | 11498 | 148 |
2241564 | 2241564 | 2022-02-22 | Union | Pennsylvania | 42119 | 11484 | 147 |
2238313 | 2238313 | 2022-02-21 | Union | Pennsylvania | 42119 | 11473 | 147 |
2235062 | 2235062 | 2022-02-20 | Union | Pennsylvania | 42119 | 11473 | 147 |
2231811 | 2231811 | 2022-02-19 | Union | Pennsylvania | 42119 | 11471 | 146 |
2228560 | 2228560 | 2022-02-18 | Union | Pennsylvania | 42119 | 11449 | 146 |
2225309 | 2225309 | 2022-02-17 | Union | Pennsylvania | 42119 | 11432 | 146 |
2222058 | 2222058 | 2022-02-16 | Union | Pennsylvania | 42119 | 11415 | 145 |
2218807 | 2218807 | 2022-02-15 | Union | Pennsylvania | 42119 | 11397 | 145 |
2215556 | 2215556 | 2022-02-14 | Union | Pennsylvania | 42119 | 11391 | 144 |
2212305 | 2212305 | 2022-02-13 | Union | Pennsylvania | 42119 | 11389 | 144 |
2209052 | 2209052 | 2022-02-12 | Union | Pennsylvania | 42119 | 11381 | 144 |
2205799 | 2205799 | 2022-02-11 | Union | Pennsylvania | 42119 | 11362 | 144 |
2202546 | 2202546 | 2022-02-10 | Union | Pennsylvania | 42119 | 11333 | 143 |
2199292 | 2199292 | 2022-02-09 | Union | Pennsylvania | 42119 | 11310 | 142 |
2196038 | 2196038 | 2022-02-08 | Union | Pennsylvania | 42119 | 11276 | 142 |
2192784 | 2192784 | 2022-02-07 | Union | Pennsylvania | 42119 | 11301 | 141 |
2189530 | 2189530 | 2022-02-06 | Union | Pennsylvania | 42119 | 11239 | 141 |
2186277 | 2186277 | 2022-02-05 | Union | Pennsylvania | 42119 | 11228 | 141 |
2183025 | 2183025 | 2022-02-04 | Union | Pennsylvania | 42119 | 11157 | 140 |
2179773 | 2179773 | 2022-02-03 | Union | Pennsylvania | 42119 | 11128 | 139 |
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);