ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 743 ✖
- 24996 7
- 8 4
- 5 3
- 6 3
- 148 3
- 442 3
- 548 3
- 9633 3
- 9671 3
- 24670 3
- 25114 3
- 167 2
- 194 2
- 275 2
- 352 2
- 399 2
- 734 2
- 864 2
- 9490 2
- 9702 2
- 9705 2
- 9833 2
- 9956 2
- 13377 2
- 24414 2
- 24614 2
- 24659 2
- 24695 2
- 1 1
- 2 1
- 7 1
- 9 1
- 12 1
- 18 1
- 19 1
- 21 1
- 22 1
- 25 1
- 28 1
- 33 1
- 38 1
- 43 1
- 44 1
- 48 1
- 56 1
- 63 1
- 64 1
- 67 1
- 70 1
- 74 1
- 80 1
- 85 1
- 91 1
- 92 1
- 95 1
- 110 1
- 113 1
- 117 1
- 122 1
- 124 1
- 130 1
- 137 1
- 140 1
- 141 1
- 145 1
- 151 1
- 154 1
- 156 1
- 159 1
- 169 1
- 174 1
- 183 1
- 185 1
- 189 1
- 197 1
- 204 1
- 214 1
- 222 1
- 226 1
- 227 1
- 233 1
- 236 1
- 240 1
- 241 1
- 245 1
- 250 1
- 251 1
- 255 1
- 260 1
- 263 1
- 264 1
- 269 1
- 273 1
- 278 1
- 279 1
- 284 1
- 289 1
- 290 1
- 296 1
- 298 1
- 300 1
- 304 1
- 309 1
- 311 1
- 314 1
- 317 1
- 321 1
- 322 1
- 323 1
- 324 1
- 327 1
- 328 1
- 332 1
- 339 1
- 341 1
- 342 1
- 344 1
- 349 1
- 358 1
- 361 1
- 366 1
- 377 1
- 385 1
- 396 1
- 398 1
- 409 1
- 410 1
- 412 1
- 413 1
- 414 1
- 421 1
- 424 1
- 437 1
- 441 1
- 448 1
- 454 1
- 461 1
- 462 1
- 469 1
- 474 1
- 480 1
- 481 1
- 483 1
- 490 1
- 497 1
- 498 1
- 518 1
- 524 1
- 531 1
- 535 1
- 539 1
- 544 1
- 547 1
- 552 1
- 557 1
- 561 1
- 566 1
- 568 1
- 570 1
- 574 1
- 580 1
- 585 1
- 599 1
- 632 1
- 637 1
- 642 1
- 648 1
- 680 1
- 686 1
- 697 1
- 706 1
- 708 1
- 711 1
- 715 1
- 717 1
- 721 1
- 723 1
- 742 1
- 749 1
- 758 1
- 765 1
- 766 1
- 782 1
- 788 1
- 796 1
- 799 1
- 810 1
- 815 1
- 822 1
- 824 1
- 833 1
- 835 1
- 837 1
- 852 1
- 854 1
- 880 1
- 885 1
- 891 1
- 897 1
- 910 1
- 916 1
- 929 1
- 935 1
- 939 1
- 945 1
- 957 1
- 962 1
- 971 1
- 985 1
- 996 1
- 1017 1
- 1030 1
- 1035 1
- 1044 1
- 1062 1
- 1070 1
- 1084 1
- 1100 1
- 1118 1
- 1133 1
- 1144 1
- 1158 1
- 1179 1
- 1184 1
- 1195 1
- 1229 1
- 1235 1
- 1252 1
- 1288 1
- 1318 1
- 1341 1
- 1358 1
- 1382 1
- 1408 1
- 1431 1
- 1468 1
- 1481 1
- 1493 1
- 1517 1
- 1552 1
- 1587 1
- 1611 1
- 1636 1
- 1666 1
- 1763 1
- 1774 1
- 1808 1
- 1834 1
- 1877 1
- 1908 1
- 1973 1
- 2003 1
- 2028 1
- 2047 1
- 2096 1
- 2227 1
- 2292 1
- 2424 1
- 2488 1
- 2512 1
- 2570 1
- 2633 1
- 2726 1
- 2792 1
- 2868 1
- 3017 1
- 3095 1
- 3132 1
- 3196 1
- 3280 1
- 3406 1
- 3569 1
- 3630 1
- 3697 1
- 3744 1
- 3889 1
- 3988 1
- 4040 1
- 4154 1
- 4221 1
- 4262 1
- 4325 1
- 4477 1
- 4557 1
- 4649 1
- 4701 1
- 4768 1
- 4786 1
- 4865 1
- 4973 1
- 5059 1
- 5145 1
- 5230 1
- 5341 1
- 5401 1
- 5434 1
- 5508 1
- 5642 1
- 5690 1
- 5749 1
- 5830 1
- 5892 1
- 5952 1
- 6032 1
- 6085 1
- 6130 1
- 6183 1
- 6228 1
- 6281 1
- 6323 1
- 6400 1
- 6446 1
- 6471 1
- 6507 1
- 6564 1
- 6578 1
- 6603 1
- 6631 1
- 6672 1
- 6704 1
- 6754 1
- 6779 1
- 6796 1
- 6821 1
- 6843 1
- 6876 1
- 6895 1
- 6919 1
- 6959 1
- 6977 1
- 7002 1
- 7018 1
- 7041 1
- 7074 1
- 7102 1
- 7120 1
- 7136 1
- 7162 1
- 7186 1
- 7203 1
- 7229 1
- 7250 1
- 7273 1
- 7284 1
- 7298 1
- 7332 1
- 7357 1
- 7378 1
- 7406 1
- 7429 1
- 7436 1
- 7476 1
- 7502 1
- 7527 1
- 7564 1
- 7586 1
- 7607 1
- 7614 1
- 7629 1
- 7662 1
- 7680 1
- 7699 1
- 7724 1
- 7745 1
- 7758 1
- 7774 1
- 7822 1
- 7862 1
- 7922 1
- 7955 1
- 7988 1
- 8008 1
- 8062 1
- 8112 1
- 8144 1
- 8194 1
- 8240 1
- 8263 1
- 8275 1
- 8302 1
- 8340 1
- 8373 1
- 8415 1
- 8465 1
- 8493 1
- 8504 1
- 8539 1
- 8579 1
- 8642 1
- 8690 1
- 8733 1
- 8752 1
- 8770 1
- 8810 1
- 8856 1
- 8879 1
- 8902 1
- 8938 1
- 8966 1
- 8976 1
- 9005 1
- 9050 1
- 9074 1
- 9113 1
- 9138 1
- 9168 1
- 9185 1
- 9210 1
- 9229 1
- 9253 1
- 9277 1
- 9293 1
- 9309 1
- 9314 1
- 9334 1
- 9349 1
- 9373 1
- 9391 1
- 9414 1
- 9422 1
- 9433 1
- 9448 1
- 9465 1
- 9475 1
- 9517 1
- 9522 1
- 9524 1
- 9537 1
- 9546 1
- 9554 1
- 9558 1
- 9564 1
- 9567 1
- 9571 1
- 9581 1
- 9587 1
- 9591 1
- 9593 1
- 9597 1
- 9599 1
- 9610 1
- 9618 1
- 9624 1
- 9626 1
- 9637 1
- 9641 1
- 9645 1
- 9648 1
- 9650 1
- 9651 1
- 9652 1
- 9657 1
- 9660 1
- 9662 1
- 9666 1
- 9677 1
- 9682 1
- 9683 1
- 9685 1
- 9688 1
- 9689 1
- 9690 1
- 9694 1
- 9696 1
- 9697 1
- 9709 1
- 9713 1
- 9715 1
- 9720 1
- 9722 1
- 9727 1
- 9732 1
- 9740 1
- 9754 1
- 9764 1
- 9769 1
- 9777 1
- 9779 1
- 9784 1
- 9794 1
- 9807 1
- 9821 1
- 9854 1
- 9867 1
- 9880 1
- 9893 1
- 9911 1
- 9932 1
- 9981 1
- 9994 1
- 10021 1
- 10035 1
- 10062 1
- 10082 1
- 10106 1
- 10118 1
- 10149 1
- 10165 1
- 10195 1
- 10223 1
- 10240 1
- 10273 1
- 10301 1
- 10328 1
- 10358 1
- 10391 1
- 10423 1
- 10473 1
- 10504 1
- 10529 1
- 10556 1
- 10591 1
- 10645 1
- 10682 1
- 10725 1
- 10762 1
- 10799 1
- 10834 1
- 10875 1
- 10953 1
- 11009 1
- 11050 1
- 11123 1
- 11166 1
- 11203 1
- 11288 1
- 11348 1
- 11387 1
- 11446 1
- 11500 1
- 11528 1
- 11571 1
- 11629 1
- 11666 1
- 11713 1
- 11752 1
- 11803 1
- 11850 1
- 11894 1
- 11953 1
- 12012 1
- 12056 1
- 12082 1
- 12162 1
- 12225 1
- 12252 1
- 12302 1
- 12356 1
- 12398 1
- 12449 1
- 12469 1
- 12505 1
- 12544 1
- 12601 1
- 12652 1
- 12709 1
- 12772 1
- 12818 1
- 12842 1
- 12883 1
- 12934 1
- 12976 1
- 13026 1
- 13067 1
- 13108 1
- 13136 1
- 13165 1
- 13213 1
- 13252 1
- 13301 1
- 13346 1
- 13442 1
- 13482 1
- 13526 1
- 13580 1
- 13624 1
- 13648 1
- 13679 1
- 13706 1
- 13746 1
- 13802 1
- 13846 1
- 14012 1
- 14052 1
- 14080 1
- 14127 1
- 14186 1
- 14218 1
- 14258 1
- 14288 1
- 14337 1
- 14365 1
- 14405 1
- 14461 1
- 14503 1
- 14535 1
- 14565 1
- 14617 1
- 14640 1
- 14695 1
- 14762 1
- 14842 1
- 14887 1
- 14978 1
- 15031 1
- 15074 1
- 15144 1
- 15210 1
- 15276 1
- 15359 1
- 15443 1
- 15520 1
- 15587 1
- 15642 1
- 15727 1
- 15816 1
- 15905 1
- 16003 1
- 16087 1
- 16156 1
- 16284 1
- 16826 1
- 17099 1
- 17335 1
- 17482 1
- 17559 1
- 17673 1
- 17786 1
- 17935 1
- 18097 1
- 18341 1
- 18458 1
- 18658 1
- 18795 1
- 18993 1
- 19223 1
- 19385 1
- 19555 1
- 19762 1
- 19943 1
- 20366 1
- 20464 1
- 20686 1
- 20856 1
- 21047 1
- 21276 1
- 21615 1
- 21842 1
- 22010 1
- 22126 1
- 22277 1
- 22448 1
- 22583 1
- 22775 1
- 22865 1
- 22985 1
- 23111 1
- 23260 1
- 23387 1
- 23471 1
- 23605 1
- 23678 1
- 23750 1
- 23816 1
- 23880 1
- 23923 1
- 24005 1
- 24052 1
- 24090 1
- 24093 1
- 24122 1
- 24167 1
- 24200 1
- 24236 1
- 24261 1
- 24277 1
- 24294 1
- 24308 1
- 24343 1
- 24365 1
- 24397 1
- 24430 1
- 24434 1
- 24452 1
- 24462 1
- 24562 1
- 24570 1
- 24572 1
- 24574 1
- 24578 1
- 24592 1
- 24597 1
- 24604 1
- 24606 1
- 24609 1
- 24612 1
- 24615 1
- 24621 1
- 24622 1
- 24625 1
- 24629 1
- 24638 1
- 24645 1
- 24649 1
- 24652 1
- 24654 1
- 24655 1
- 24661 1
- 24664 1
- 24672 1
- 24677 1
- 24688 1
- 24693 1
- 24709 1
- 24712 1
- 24730 1
- 24735 1
- 24743 1
- 24757 1
- 24762 1
- 24764 1
- 24774 1
- 24780 1
- 24794 1
- 24804 1
- 24806 1
- 24807 1
- 24809 1
- 24814 1
- 24821 1
- 24828 1
- 24837 1
- 24846 1
- 24849 1
- 24855 1
- 24870 1
- 24888 1
- 24910 1
- 24926 1
- 24945 1
- 24952 1
- 24964 1
- 24983 1
state 1
- Pennsylvania 787
fips 1
- 42001 · 787 ✖
county 1
- Adams 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501847 | 2501847 | 2022-05-13 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2498589 | 2498589 | 2022-05-12 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2495331 | 2495331 | 2022-05-11 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2492073 | 2492073 | 2022-05-10 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2488815 | 2488815 | 2022-05-09 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2485558 | 2485558 | 2022-05-08 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2482300 | 2482300 | 2022-05-07 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2479042 | 2479042 | 2022-05-06 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2475784 | 2475784 | 2022-05-05 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2472527 | 2472527 | 2022-05-04 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2469271 | 2469271 | 2022-05-03 | Adams | Pennsylvania | 42001 | 24983 | 362 |
2466015 | 2466015 | 2022-05-02 | Adams | Pennsylvania | 42001 | 24964 | 362 |
2462760 | 2462760 | 2022-05-01 | Adams | Pennsylvania | 42001 | 24952 | 362 |
2459504 | 2459504 | 2022-04-30 | Adams | Pennsylvania | 42001 | 24945 | 362 |
2456248 | 2456248 | 2022-04-29 | Adams | Pennsylvania | 42001 | 24926 | 361 |
2452992 | 2452992 | 2022-04-28 | Adams | Pennsylvania | 42001 | 24910 | 361 |
2449736 | 2449736 | 2022-04-27 | Adams | Pennsylvania | 42001 | 24888 | 361 |
2446479 | 2446479 | 2022-04-26 | Adams | Pennsylvania | 42001 | 24870 | 361 |
2443224 | 2443224 | 2022-04-25 | Adams | Pennsylvania | 42001 | 24855 | 361 |
2439968 | 2439968 | 2022-04-24 | Adams | Pennsylvania | 42001 | 24849 | 361 |
2436712 | 2436712 | 2022-04-23 | Adams | Pennsylvania | 42001 | 24846 | 361 |
2433456 | 2433456 | 2022-04-22 | Adams | Pennsylvania | 42001 | 24837 | 361 |
2430200 | 2430200 | 2022-04-21 | Adams | Pennsylvania | 42001 | 24828 | 361 |
2426944 | 2426944 | 2022-04-20 | Adams | Pennsylvania | 42001 | 24821 | 361 |
2423688 | 2423688 | 2022-04-19 | Adams | Pennsylvania | 42001 | 24814 | 361 |
2420432 | 2420432 | 2022-04-18 | Adams | Pennsylvania | 42001 | 24809 | 360 |
2417176 | 2417176 | 2022-04-17 | Adams | Pennsylvania | 42001 | 24807 | 360 |
2413920 | 2413920 | 2022-04-16 | Adams | Pennsylvania | 42001 | 24806 | 360 |
2410664 | 2410664 | 2022-04-15 | Adams | Pennsylvania | 42001 | 24804 | 360 |
2407408 | 2407408 | 2022-04-14 | Adams | Pennsylvania | 42001 | 24794 | 360 |
2404152 | 2404152 | 2022-04-13 | Adams | Pennsylvania | 42001 | 24780 | 360 |
2400897 | 2400897 | 2022-04-12 | Adams | Pennsylvania | 42001 | 24774 | 360 |
2397642 | 2397642 | 2022-04-11 | Adams | Pennsylvania | 42001 | 24764 | 360 |
2394387 | 2394387 | 2022-04-10 | Adams | Pennsylvania | 42001 | 24762 | 360 |
2391131 | 2391131 | 2022-04-09 | Adams | Pennsylvania | 42001 | 24757 | 360 |
2387875 | 2387875 | 2022-04-08 | Adams | Pennsylvania | 42001 | 24743 | 360 |
2384620 | 2384620 | 2022-04-07 | Adams | Pennsylvania | 42001 | 24735 | 360 |
2381365 | 2381365 | 2022-04-06 | Adams | Pennsylvania | 42001 | 24730 | 360 |
2378110 | 2378110 | 2022-04-05 | Adams | Pennsylvania | 42001 | 24712 | 360 |
2374856 | 2374856 | 2022-04-04 | Adams | Pennsylvania | 42001 | 24709 | 359 |
2371604 | 2371604 | 2022-04-03 | Adams | Pennsylvania | 42001 | 24695 | 358 |
2368351 | 2368351 | 2022-04-02 | Adams | Pennsylvania | 42001 | 24695 | 358 |
2365098 | 2365098 | 2022-04-01 | Adams | Pennsylvania | 42001 | 24693 | 358 |
2361845 | 2361845 | 2022-03-31 | Adams | Pennsylvania | 42001 | 24688 | 358 |
2358591 | 2358591 | 2022-03-30 | Adams | Pennsylvania | 42001 | 24677 | 358 |
2355337 | 2355337 | 2022-03-29 | Adams | Pennsylvania | 42001 | 24672 | 358 |
2352084 | 2352084 | 2022-03-28 | Adams | Pennsylvania | 42001 | 24670 | 358 |
2348832 | 2348832 | 2022-03-27 | Adams | Pennsylvania | 42001 | 24670 | 358 |
2345579 | 2345579 | 2022-03-26 | Adams | Pennsylvania | 42001 | 24670 | 358 |
2342326 | 2342326 | 2022-03-25 | Adams | Pennsylvania | 42001 | 24664 | 358 |
2339073 | 2339073 | 2022-03-24 | Adams | Pennsylvania | 42001 | 24661 | 358 |
2335819 | 2335819 | 2022-03-23 | Adams | Pennsylvania | 42001 | 24659 | 358 |
2332565 | 2332565 | 2022-03-22 | Adams | Pennsylvania | 42001 | 24659 | 358 |
2329312 | 2329312 | 2022-03-21 | Adams | Pennsylvania | 42001 | 24655 | 358 |
2326060 | 2326060 | 2022-03-20 | Adams | Pennsylvania | 42001 | 24654 | 358 |
2322807 | 2322807 | 2022-03-19 | Adams | Pennsylvania | 42001 | 24652 | 357 |
2319553 | 2319553 | 2022-03-18 | Adams | Pennsylvania | 42001 | 24649 | 357 |
2316299 | 2316299 | 2022-03-17 | Adams | Pennsylvania | 42001 | 24645 | 357 |
2313046 | 2313046 | 2022-03-16 | Adams | Pennsylvania | 42001 | 24638 | 357 |
2309793 | 2309793 | 2022-03-15 | Adams | Pennsylvania | 42001 | 24629 | 357 |
2306540 | 2306540 | 2022-03-14 | Adams | Pennsylvania | 42001 | 24625 | 356 |
2303289 | 2303289 | 2022-03-13 | Adams | Pennsylvania | 42001 | 24622 | 356 |
2300037 | 2300037 | 2022-03-12 | Adams | Pennsylvania | 42001 | 24621 | 356 |
2296785 | 2296785 | 2022-03-11 | Adams | Pennsylvania | 42001 | 24615 | 355 |
2293533 | 2293533 | 2022-03-10 | Adams | Pennsylvania | 42001 | 24614 | 354 |
2290281 | 2290281 | 2022-03-09 | Adams | Pennsylvania | 42001 | 24614 | 354 |
2287029 | 2287029 | 2022-03-08 | Adams | Pennsylvania | 42001 | 24612 | 354 |
2283777 | 2283777 | 2022-03-07 | Adams | Pennsylvania | 42001 | 24609 | 354 |
2280525 | 2280525 | 2022-03-06 | Adams | Pennsylvania | 42001 | 24606 | 354 |
2277272 | 2277272 | 2022-03-05 | Adams | Pennsylvania | 42001 | 24604 | 354 |
2274019 | 2274019 | 2022-03-04 | Adams | Pennsylvania | 42001 | 24597 | 354 |
2270766 | 2270766 | 2022-03-03 | Adams | Pennsylvania | 42001 | 24592 | 353 |
2267514 | 2267514 | 2022-03-02 | Adams | Pennsylvania | 42001 | 24578 | 353 |
2264261 | 2264261 | 2022-03-01 | Adams | Pennsylvania | 42001 | 24572 | 351 |
2261011 | 2261011 | 2022-02-28 | Adams | Pennsylvania | 42001 | 24574 | 349 |
2257760 | 2257760 | 2022-02-27 | Adams | Pennsylvania | 42001 | 24570 | 349 |
2254509 | 2254509 | 2022-02-26 | Adams | Pennsylvania | 42001 | 24562 | 349 |
2251258 | 2251258 | 2022-02-25 | Adams | Pennsylvania | 42001 | 24462 | 349 |
2248007 | 2248007 | 2022-02-24 | Adams | Pennsylvania | 42001 | 24452 | 349 |
2244756 | 2244756 | 2022-02-23 | Adams | Pennsylvania | 42001 | 24434 | 347 |
2241505 | 2241505 | 2022-02-22 | Adams | Pennsylvania | 42001 | 24430 | 347 |
2238254 | 2238254 | 2022-02-21 | Adams | Pennsylvania | 42001 | 24414 | 347 |
2235003 | 2235003 | 2022-02-20 | Adams | Pennsylvania | 42001 | 24414 | 347 |
2231752 | 2231752 | 2022-02-19 | Adams | Pennsylvania | 42001 | 24397 | 347 |
2228501 | 2228501 | 2022-02-18 | Adams | Pennsylvania | 42001 | 24365 | 347 |
2225250 | 2225250 | 2022-02-17 | Adams | Pennsylvania | 42001 | 24343 | 345 |
2221999 | 2221999 | 2022-02-16 | Adams | Pennsylvania | 42001 | 24308 | 345 |
2218748 | 2218748 | 2022-02-15 | Adams | Pennsylvania | 42001 | 24294 | 344 |
2215497 | 2215497 | 2022-02-14 | Adams | Pennsylvania | 42001 | 24277 | 344 |
2212246 | 2212246 | 2022-02-13 | Adams | Pennsylvania | 42001 | 24261 | 344 |
2208993 | 2208993 | 2022-02-12 | Adams | Pennsylvania | 42001 | 24236 | 344 |
2205740 | 2205740 | 2022-02-11 | Adams | Pennsylvania | 42001 | 24200 | 343 |
2202487 | 2202487 | 2022-02-10 | Adams | Pennsylvania | 42001 | 24167 | 343 |
2199233 | 2199233 | 2022-02-09 | Adams | Pennsylvania | 42001 | 24122 | 343 |
2195979 | 2195979 | 2022-02-08 | Adams | Pennsylvania | 42001 | 24090 | 342 |
2192725 | 2192725 | 2022-02-07 | Adams | Pennsylvania | 42001 | 24093 | 339 |
2189471 | 2189471 | 2022-02-06 | Adams | Pennsylvania | 42001 | 24052 | 338 |
2186218 | 2186218 | 2022-02-05 | Adams | Pennsylvania | 42001 | 24005 | 337 |
2182966 | 2182966 | 2022-02-04 | Adams | Pennsylvania | 42001 | 23923 | 335 |
2179714 | 2179714 | 2022-02-03 | Adams | Pennsylvania | 42001 | 23880 | 333 |
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);