ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Bedford" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 641 ✖
- 11010 7
- 4 6
- 24 6
- 29 5
- 32 5
- 4708 5
- 3 4
- 5 4
- 21 4
- 37 4
- 89 4
- 92 4
- 4729 4
- 4738 4
- 39 3
- 45 3
- 46 3
- 123 3
- 161 3
- 170 3
- 4717 3
- 4741 3
- 4747 3
- 10883 3
- 10964 3
- 10966 3
- 10970 3
- 10974 3
- 10975 3
- 11044 3
- 15 2
- 16 2
- 27 2
- 30 2
- 36 2
- 38 2
- 40 2
- 43 2
- 66 2
- 81 2
- 90 2
- 105 2
- 109 2
- 128 2
- 130 2
- 143 2
- 145 2
- 176 2
- 202 2
- 235 2
- 238 2
- 242 2
- 253 2
- 262 2
- 3895 2
- 3914 2
- 3942 2
- 4557 2
- 4694 2
- 4697 2
- 4709 2
- 4713 2
- 4727 2
- 4737 2
- 4742 2
- 4744 2
- 4749 2
- 4755 2
- 4797 2
- 6856 2
- 10808 2
- 10905 2
- 10945 2
- 10946 2
- 10955 2
- 10967 2
- 10980 2
- 10982 2
- 11000 2
- 2 1
- 9 1
- 11 1
- 13 1
- 14 1
- 20 1
- 22 1
- 26 1
- 28 1
- 41 1
- 42 1
- 44 1
- 48 1
- 52 1
- 53 1
- 59 1
- 61 1
- 63 1
- 65 1
- 69 1
- 71 1
- 72 1
- 76 1
- 77 1
- 82 1
- 87 1
- 88 1
- 91 1
- 93 1
- 94 1
- 95 1
- 99 1
- 100 1
- 106 1
- 112 1
- 113 1
- 124 1
- 127 1
- 133 1
- 134 1
- 136 1
- 138 1
- 141 1
- 142 1
- 150 1
- 151 1
- 153 1
- 154 1
- 155 1
- 156 1
- 157 1
- 159 1
- 160 1
- 162 1
- 166 1
- 167 1
- 168 1
- 172 1
- 177 1
- 178 1
- 179 1
- 181 1
- 187 1
- 191 1
- 199 1
- 212 1
- 213 1
- 219 1
- 222 1
- 223 1
- 224 1
- 228 1
- 229 1
- 231 1
- 243 1
- 245 1
- 250 1
- 264 1
- 269 1
- 273 1
- 274 1
- 277 1
- 291 1
- 295 1
- 299 1
- 309 1
- 315 1
- 323 1
- 329 1
- 337 1
- 338 1
- 342 1
- 348 1
- 359 1
- 369 1
- 378 1
- 382 1
- 383 1
- 392 1
- 398 1
- 404 1
- 414 1
- 447 1
- 462 1
- 483 1
- 498 1
- 512 1
- 550 1
- 581 1
- 611 1
- 648 1
- 668 1
- 691 1
- 727 1
- 765 1
- 808 1
- 898 1
- 931 1
- 955 1
- 982 1
- 1026 1
- 1069 1
- 1113 1
- 1147 1
- 1194 1
- 1228 1
- 1267 1
- 1305 1
- 1368 1
- 1446 1
- 1489 1
- 1557 1
- 1567 1
- 1601 1
- 1635 1
- 1683 1
- 1737 1
- 1815 1
- 1865 1
- 1890 1
- 1959 1
- 2061 1
- 2147 1
- 2233 1
- 2295 1
- 2371 1
- 2403 1
- 2456 1
- 2509 1
- 2533 1
- 2573 1
- 2637 1
- 2677 1
- 2706 1
- 2729 1
- 2752 1
- 2786 1
- 2803 1
- 2842 1
- 2849 1
- 2864 1
- 2904 1
- 2926 1
- 2956 1
- 2969 1
- 3001 1
- 3028 1
- 3042 1
- 3065 1
- 3095 1
- 3129 1
- 3172 1
- 3196 1
- 3224 1
- 3233 1
- 3272 1
- 3289 1
- 3351 1
- 3367 1
- 3390 1
- 3408 1
- 3416 1
- 3427 1
- 3447 1
- 3457 1
- 3468 1
- 3487 1
- 3503 1
- 3519 1
- 3532 1
- 3574 1
- 3587 1
- 3605 1
- 3631 1
- 3635 1
- 3639 1
- 3651 1
- 3661 1
- 3667 1
- 3678 1
- 3685 1
- 3690 1
- 3698 1
- 3708 1
- 3718 1
- 3725 1
- 3729 1
- 3735 1
- 3736 1
- 3741 1
- 3751 1
- 3758 1
- 3760 1
- 3768 1
- 3771 1
- 3774 1
- 3780 1
- 3785 1
- 3788 1
- 3790 1
- 3793 1
- 3802 1
- 3804 1
- 3807 1
- 3814 1
- 3817 1
- 3820 1
- 3831 1
- 3839 1
- 3843 1
- 3844 1
- 3847 1
- 3854 1
- 3856 1
- 3868 1
- 3876 1
- 3878 1
- 3879 1
- 3890 1
- 3892 1
- 3910 1
- 3920 1
- 3922 1
- 3931 1
- 3935 1
- 3938 1
- 3943 1
- 3952 1
- 3958 1
- 3974 1
- 3987 1
- 3997 1
- 3999 1
- 4008 1
- 4020 1
- 4024 1
- 4033 1
- 4040 1
- 4053 1
- 4059 1
- 4085 1
- 4098 1
- 4116 1
- 4137 1
- 4151 1
- 4167 1
- 4175 1
- 4199 1
- 4216 1
- 4239 1
- 4260 1
- 4275 1
- 4285 1
- 4287 1
- 4306 1
- 4311 1
- 4321 1
- 4346 1
- 4356 1
- 4364 1
- 4373 1
- 4379 1
- 4396 1
- 4410 1
- 4429 1
- 4438 1
- 4446 1
- 4449 1
- 4461 1
- 4470 1
- 4490 1
- 4501 1
- 4510 1
- 4514 1
- 4515 1
- 4526 1
- 4529 1
- 4546 1
- 4570 1
- 4572 1
- 4590 1
- 4595 1
- 4603 1
- 4620 1
- 4626 1
- 4632 1
- 4635 1
- 4644 1
- 4651 1
- 4654 1
- 4658 1
- 4667 1
- 4669 1
- 4670 1
- 4671 1
- 4674 1
- 4689 1
- 4696 1
- 4704 1
- 4723 1
- 4725 1
- 4736 1
- 4740 1
- 4743 1
- 4745 1
- 4752 1
- 4764 1
- 4767 1
- 4772 1
- 4777 1
- 4787 1
- 4796 1
- 4807 1
- 4815 1
- 4818 1
- 4829 1
- 4831 1
- 4839 1
- 4848 1
- 4859 1
- 4870 1
- 4875 1
- 4889 1
- 4896 1
- 4932 1
- 4935 1
- 4937 1
- 4941 1
- 4944 1
- 4954 1
- 4961 1
- 4985 1
- 4991 1
- 4997 1
- 5008 1
- 5027 1
- 5045 1
- 5055 1
- 5078 1
- 5091 1
- 5106 1
- 5107 1
- 5134 1
- 5175 1
- 5212 1
- 5247 1
- 5270 1
- 5311 1
- 5332 1
- 5357 1
- 5423 1
- 5467 1
- 5520 1
- 5563 1
- 5593 1
- 5624 1
- 5648 1
- 5689 1
- 5753 1
- 5802 1
- 5841 1
- 5870 1
- 5897 1
- 5937 1
- 5988 1
- 6031 1
- 6066 1
- 6106 1
- 6130 1
- 6169 1
- 6203 1
- 6243 1
- 6287 1
- 6317 1
- 6334 1
- 6342 1
- 6374 1
- 6398 1
- 6444 1
- 6481 1
- 6514 1
- 6531 1
- 6543 1
- 6567 1
- 6595 1
- 6629 1
- 6662 1
- 6688 1
- 6704 1
- 6708 1
- 6725 1
- 6743 1
- 6765 1
- 6800 1
- 6828 1
- 6893 1
- 6910 1
- 6951 1
- 6989 1
- 7023 1
- 7035 1
- 7049 1
- 7060 1
- 7077 1
- 7135 1
- 7157 1
- 7268 1
- 7308 1
- 7315 1
- 7345 1
- 7369 1
- 7412 1
- 7465 1
- 7511 1
- 7539 1
- 7558 1
- 7576 1
- 7604 1
- 7626 1
- 7647 1
- 7677 1
- 7685 1
- 7698 1
- 7730 1
- 7786 1
- 7837 1
- 7886 1
- 7919 1
- 7948 1
- 7963 1
- 7996 1
- 8027 1
- 8066 1
- 8107 1
- 8154 1
- 8172 1
- 8199 1
- 8227 1
- 8252 1
- 8300 1
- 8335 1
- 8392 1
- 8425 1
- 8428 1
- 8459 1
- 8482 1
- 8517 1
- 8540 1
- 8569 1
- 8573 1
- 8575 1
- 8595 1
- 8626 1
- 8699 1
- 8761 1
- 8797 1
- 8813 1
- 8833 1
- 8865 1
- 8926 1
- 8980 1
- 9036 1
- 9111 1
- 9143 1
- 9182 1
- 9219 1
- 9279 1
- 9347 1
- 9421 1
- 9481 1
- 9605 1
- 9639 1
- 9671 1
- 9701 1
- 9782 1
- 9841 1
- 9941 1
- 9996 1
- 10037 1
- 10086 1
- 10161 1
- 10235 1
- 10308 1
- 10365 1
- 10385 1
- 10393 1
- 10434 1
- 10437 1
- 10466 1
- 10489 1
- 10559 1
- 10573 1
- 10579 1
- 10603 1
- 10626 1
- 10656 1
- 10675 1
- 10697 1
- 10702 1
- 10710 1
- 10725 1
- 10735 1
- 10759 1
- 10772 1
- 10792 1
- 10821 1
- 10836 1
- 10853 1
- 10858 1
- 10884 1
- 10887 1
- 10890 1
- 10896 1
- 10899 1
- 10903 1
- 10912 1
- 10917 1
- 10922 1
- 10926 1
- 10928 1
- 10931 1
- 10933 1
- 10937 1
- 10940 1
- 10942 1
- 10948 1
- 10950 1
- 10951 1
- 10952 1
- 10954 1
- 10960 1
- 10963 1
- 10969 1
- 10973 1
- 10977 1
- 10981 1
- 10983 1
- 10986 1
- 10995 1
- 10998 1
- 10999 1
- 11001 1
state 1
- Pennsylvania · 774 ✖
fips 1
- 42009 774
county 1
- Bedford · 774 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501851 | 2501851 | 2022-05-13 | Bedford | Pennsylvania | 42009 | 11044 | 275 |
2498593 | 2498593 | 2022-05-12 | Bedford | Pennsylvania | 42009 | 11044 | 275 |
2495335 | 2495335 | 2022-05-11 | Bedford | Pennsylvania | 42009 | 11044 | 275 |
2492077 | 2492077 | 2022-05-10 | Bedford | Pennsylvania | 42009 | 11010 | 275 |
2488819 | 2488819 | 2022-05-09 | Bedford | Pennsylvania | 42009 | 11010 | 275 |
2485562 | 2485562 | 2022-05-08 | Bedford | Pennsylvania | 42009 | 11010 | 275 |
2482304 | 2482304 | 2022-05-07 | Bedford | Pennsylvania | 42009 | 11010 | 275 |
2479046 | 2479046 | 2022-05-06 | Bedford | Pennsylvania | 42009 | 11010 | 275 |
2475788 | 2475788 | 2022-05-05 | Bedford | Pennsylvania | 42009 | 11010 | 275 |
2472531 | 2472531 | 2022-05-04 | Bedford | Pennsylvania | 42009 | 11010 | 275 |
2469275 | 2469275 | 2022-05-03 | Bedford | Pennsylvania | 42009 | 11001 | 275 |
2466019 | 2466019 | 2022-05-02 | Bedford | Pennsylvania | 42009 | 11000 | 275 |
2462764 | 2462764 | 2022-05-01 | Bedford | Pennsylvania | 42009 | 11000 | 275 |
2459508 | 2459508 | 2022-04-30 | Bedford | Pennsylvania | 42009 | 10999 | 275 |
2456252 | 2456252 | 2022-04-29 | Bedford | Pennsylvania | 42009 | 10998 | 275 |
2452996 | 2452996 | 2022-04-28 | Bedford | Pennsylvania | 42009 | 10995 | 275 |
2449740 | 2449740 | 2022-04-27 | Bedford | Pennsylvania | 42009 | 10986 | 275 |
2446483 | 2446483 | 2022-04-26 | Bedford | Pennsylvania | 42009 | 10983 | 275 |
2443228 | 2443228 | 2022-04-25 | Bedford | Pennsylvania | 42009 | 10982 | 275 |
2439972 | 2439972 | 2022-04-24 | Bedford | Pennsylvania | 42009 | 10982 | 275 |
2436716 | 2436716 | 2022-04-23 | Bedford | Pennsylvania | 42009 | 10981 | 275 |
2433460 | 2433460 | 2022-04-22 | Bedford | Pennsylvania | 42009 | 10980 | 275 |
2430204 | 2430204 | 2022-04-21 | Bedford | Pennsylvania | 42009 | 10980 | 275 |
2426948 | 2426948 | 2022-04-20 | Bedford | Pennsylvania | 42009 | 10977 | 275 |
2423692 | 2423692 | 2022-04-19 | Bedford | Pennsylvania | 42009 | 10975 | 275 |
2420436 | 2420436 | 2022-04-18 | Bedford | Pennsylvania | 42009 | 10975 | 275 |
2417180 | 2417180 | 2022-04-17 | Bedford | Pennsylvania | 42009 | 10975 | 275 |
2413924 | 2413924 | 2022-04-16 | Bedford | Pennsylvania | 42009 | 10974 | 275 |
2410668 | 2410668 | 2022-04-15 | Bedford | Pennsylvania | 42009 | 10974 | 275 |
2407412 | 2407412 | 2022-04-14 | Bedford | Pennsylvania | 42009 | 10974 | 275 |
2404156 | 2404156 | 2022-04-13 | Bedford | Pennsylvania | 42009 | 10973 | 275 |
2400901 | 2400901 | 2022-04-12 | Bedford | Pennsylvania | 42009 | 10970 | 275 |
2397646 | 2397646 | 2022-04-11 | Bedford | Pennsylvania | 42009 | 10970 | 275 |
2394391 | 2394391 | 2022-04-10 | Bedford | Pennsylvania | 42009 | 10970 | 275 |
2391135 | 2391135 | 2022-04-09 | Bedford | Pennsylvania | 42009 | 10969 | 275 |
2387879 | 2387879 | 2022-04-08 | Bedford | Pennsylvania | 42009 | 10967 | 275 |
2384624 | 2384624 | 2022-04-07 | Bedford | Pennsylvania | 42009 | 10967 | 275 |
2381369 | 2381369 | 2022-04-06 | Bedford | Pennsylvania | 42009 | 10966 | 275 |
2378114 | 2378114 | 2022-04-05 | Bedford | Pennsylvania | 42009 | 10966 | 275 |
2374860 | 2374860 | 2022-04-04 | Bedford | Pennsylvania | 42009 | 10966 | 275 |
2371608 | 2371608 | 2022-04-03 | Bedford | Pennsylvania | 42009 | 10964 | 275 |
2368355 | 2368355 | 2022-04-02 | Bedford | Pennsylvania | 42009 | 10964 | 275 |
2365102 | 2365102 | 2022-04-01 | Bedford | Pennsylvania | 42009 | 10964 | 275 |
2361849 | 2361849 | 2022-03-31 | Bedford | Pennsylvania | 42009 | 10963 | 275 |
2358595 | 2358595 | 2022-03-30 | Bedford | Pennsylvania | 42009 | 10960 | 275 |
2355341 | 2355341 | 2022-03-29 | Bedford | Pennsylvania | 42009 | 10955 | 275 |
2352088 | 2352088 | 2022-03-28 | Bedford | Pennsylvania | 42009 | 10955 | 275 |
2348836 | 2348836 | 2022-03-27 | Bedford | Pennsylvania | 42009 | 10954 | 275 |
2345583 | 2345583 | 2022-03-26 | Bedford | Pennsylvania | 42009 | 10952 | 275 |
2342330 | 2342330 | 2022-03-25 | Bedford | Pennsylvania | 42009 | 10951 | 275 |
2339077 | 2339077 | 2022-03-24 | Bedford | Pennsylvania | 42009 | 10950 | 275 |
2335823 | 2335823 | 2022-03-23 | Bedford | Pennsylvania | 42009 | 10948 | 274 |
2332569 | 2332569 | 2022-03-22 | Bedford | Pennsylvania | 42009 | 10946 | 273 |
2329316 | 2329316 | 2022-03-21 | Bedford | Pennsylvania | 42009 | 10945 | 273 |
2326064 | 2326064 | 2022-03-20 | Bedford | Pennsylvania | 42009 | 10946 | 273 |
2322811 | 2322811 | 2022-03-19 | Bedford | Pennsylvania | 42009 | 10945 | 273 |
2319557 | 2319557 | 2022-03-18 | Bedford | Pennsylvania | 42009 | 10942 | 273 |
2316303 | 2316303 | 2022-03-17 | Bedford | Pennsylvania | 42009 | 10940 | 273 |
2313050 | 2313050 | 2022-03-16 | Bedford | Pennsylvania | 42009 | 10937 | 273 |
2309797 | 2309797 | 2022-03-15 | Bedford | Pennsylvania | 42009 | 10933 | 272 |
2306544 | 2306544 | 2022-03-14 | Bedford | Pennsylvania | 42009 | 10931 | 271 |
2303293 | 2303293 | 2022-03-13 | Bedford | Pennsylvania | 42009 | 10928 | 271 |
2300041 | 2300041 | 2022-03-12 | Bedford | Pennsylvania | 42009 | 10926 | 271 |
2296789 | 2296789 | 2022-03-11 | Bedford | Pennsylvania | 42009 | 10922 | 271 |
2293537 | 2293537 | 2022-03-10 | Bedford | Pennsylvania | 42009 | 10917 | 271 |
2290285 | 2290285 | 2022-03-09 | Bedford | Pennsylvania | 42009 | 10912 | 271 |
2287033 | 2287033 | 2022-03-08 | Bedford | Pennsylvania | 42009 | 10905 | 271 |
2283781 | 2283781 | 2022-03-07 | Bedford | Pennsylvania | 42009 | 10905 | 271 |
2280529 | 2280529 | 2022-03-06 | Bedford | Pennsylvania | 42009 | 10903 | 271 |
2277276 | 2277276 | 2022-03-05 | Bedford | Pennsylvania | 42009 | 10899 | 271 |
2274023 | 2274023 | 2022-03-04 | Bedford | Pennsylvania | 42009 | 10896 | 271 |
2270770 | 2270770 | 2022-03-03 | Bedford | Pennsylvania | 42009 | 10890 | 271 |
2267518 | 2267518 | 2022-03-02 | Bedford | Pennsylvania | 42009 | 10887 | 270 |
2264265 | 2264265 | 2022-03-01 | Bedford | Pennsylvania | 42009 | 10883 | 269 |
2261015 | 2261015 | 2022-02-28 | Bedford | Pennsylvania | 42009 | 10884 | 268 |
2257764 | 2257764 | 2022-02-27 | Bedford | Pennsylvania | 42009 | 10883 | 268 |
2254513 | 2254513 | 2022-02-26 | Bedford | Pennsylvania | 42009 | 10883 | 267 |
2251262 | 2251262 | 2022-02-25 | Bedford | Pennsylvania | 42009 | 10858 | 266 |
2248011 | 2248011 | 2022-02-24 | Bedford | Pennsylvania | 42009 | 10853 | 266 |
2244760 | 2244760 | 2022-02-23 | Bedford | Pennsylvania | 42009 | 10836 | 266 |
2241509 | 2241509 | 2022-02-22 | Bedford | Pennsylvania | 42009 | 10821 | 265 |
2238258 | 2238258 | 2022-02-21 | Bedford | Pennsylvania | 42009 | 10808 | 265 |
2235007 | 2235007 | 2022-02-20 | Bedford | Pennsylvania | 42009 | 10808 | 265 |
2231756 | 2231756 | 2022-02-19 | Bedford | Pennsylvania | 42009 | 10792 | 265 |
2228505 | 2228505 | 2022-02-18 | Bedford | Pennsylvania | 42009 | 10772 | 265 |
2225254 | 2225254 | 2022-02-17 | Bedford | Pennsylvania | 42009 | 10759 | 266 |
2222003 | 2222003 | 2022-02-16 | Bedford | Pennsylvania | 42009 | 10735 | 264 |
2218752 | 2218752 | 2022-02-15 | Bedford | Pennsylvania | 42009 | 10725 | 262 |
2215501 | 2215501 | 2022-02-14 | Bedford | Pennsylvania | 42009 | 10710 | 258 |
2212250 | 2212250 | 2022-02-13 | Bedford | Pennsylvania | 42009 | 10702 | 258 |
2208997 | 2208997 | 2022-02-12 | Bedford | Pennsylvania | 42009 | 10697 | 258 |
2205744 | 2205744 | 2022-02-11 | Bedford | Pennsylvania | 42009 | 10675 | 258 |
2202491 | 2202491 | 2022-02-10 | Bedford | Pennsylvania | 42009 | 10656 | 257 |
2199237 | 2199237 | 2022-02-09 | Bedford | Pennsylvania | 42009 | 10626 | 257 |
2195983 | 2195983 | 2022-02-08 | Bedford | Pennsylvania | 42009 | 10603 | 257 |
2192729 | 2192729 | 2022-02-07 | Bedford | Pennsylvania | 42009 | 10579 | 256 |
2189475 | 2189475 | 2022-02-06 | Bedford | Pennsylvania | 42009 | 10573 | 256 |
2186222 | 2186222 | 2022-02-05 | Bedford | Pennsylvania | 42009 | 10559 | 256 |
2182970 | 2182970 | 2022-02-04 | Bedford | Pennsylvania | 42009 | 10489 | 256 |
2179718 | 2179718 | 2022-02-03 | Bedford | Pennsylvania | 42009 | 10466 | 253 |
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);