ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 51199 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 618 ✖
- 44 5
- 1 4
- 9 4
- 25 4
- 43 4
- 77 4
- 86 4
- 3802 4
- 5211 4
- 9651 4
- 46 3
- 62 3
- 63 3
- 72 3
- 94 3
- 106 3
- 115 3
- 3732 3
- 3775 3
- 3776 3
- 3803 3
- 3808 3
- 3843 3
- 3873 3
- 3926 3
- 4024 3
- 4108 3
- 4218 3
- 4395 3
- 4542 3
- 4696 3
- 4828 3
- 4967 3
- 5088 3
- 5325 3
- 5417 3
- 5485 3
- 5544 3
- 5586 3
- 5631 3
- 5685 3
- 5754 3
- 5852 3
- 5941 3
- 6099 3
- 6483 3
- 6955 3
- 7917 3
- 8597 3
- 9037 3
- 9290 3
- 9439 3
- 9549 3
- 9618 3
- 9685 3
- 9728 3
- 9745 3
- 9770 3
- 9801 3
- 9845 3
- 9894 3
- 9956 3
- 10048 3
- 3 2
- 5 2
- 17 2
- 35 2
- 38 2
- 45 2
- 47 2
- 48 2
- 55 2
- 67 2
- 71 2
- 93 2
- 131 2
- 444 2
- 492 2
- 497 2
- 541 2
- 564 2
- 616 2
- 626 2
- 637 2
- 658 2
- 3724 2
- 3733 2
- 3740 2
- 3774 2
- 3780 2
- 3783 2
- 3789 2
- 3796 2
- 3797 2
- 3807 2
- 3815 2
- 9734 2
- 6 1
- 8 1
- 11 1
- 14 1
- 16 1
- 19 1
- 20 1
- 21 1
- 27 1
- 29 1
- 33 1
- 37 1
- 51 1
- 56 1
- 57 1
- 59 1
- 60 1
- 61 1
- 65 1
- 68 1
- 69 1
- 74 1
- 79 1
- 82 1
- 89 1
- 90 1
- 91 1
- 97 1
- 98 1
- 99 1
- 101 1
- 108 1
- 110 1
- 114 1
- 116 1
- 120 1
- 124 1
- 129 1
- 135 1
- 140 1
- 144 1
- 149 1
- 160 1
- 168 1
- 176 1
- 180 1
- 181 1
- 191 1
- 200 1
- 216 1
- 226 1
- 234 1
- 237 1
- 243 1
- 259 1
- 270 1
- 279 1
- 282 1
- 287 1
- 290 1
- 293 1
- 301 1
- 308 1
- 310 1
- 318 1
- 330 1
- 335 1
- 338 1
- 355 1
- 361 1
- 366 1
- 373 1
- 374 1
- 375 1
- 383 1
- 394 1
- 400 1
- 406 1
- 409 1
- 410 1
- 412 1
- 413 1
- 419 1
- 423 1
- 427 1
- 432 1
- 433 1
- 437 1
- 451 1
- 454 1
- 461 1
- 467 1
- 468 1
- 474 1
- 480 1
- 482 1
- 486 1
- 488 1
- 503 1
- 506 1
- 507 1
- 509 1
- 513 1
- 514 1
- 520 1
- 523 1
- 528 1
- 532 1
- 534 1
- 537 1
- 544 1
- 545 1
- 546 1
- 549 1
- 553 1
- 554 1
- 557 1
- 561 1
- 562 1
- 566 1
- 570 1
- 580 1
- 584 1
- 587 1
- 588 1
- 592 1
- 595 1
- 603 1
- 612 1
- 617 1
- 620 1
- 625 1
- 629 1
- 640 1
- 644 1
- 646 1
- 650 1
- 661 1
- 665 1
- 668 1
- 670 1
- 686 1
- 697 1
- 707 1
- 710 1
- 713 1
- 718 1
- 719 1
- 724 1
- 735 1
- 745 1
- 759 1
- 767 1
- 775 1
- 783 1
- 806 1
- 817 1
- 825 1
- 848 1
- 859 1
- 867 1
- 875 1
- 877 1
- 889 1
- 908 1
- 921 1
- 929 1
- 950 1
- 957 1
- 968 1
- 975 1
- 992 1
- 1007 1
- 1012 1
- 1023 1
- 1038 1
- 1046 1
- 1069 1
- 1089 1
- 1105 1
- 1129 1
- 1159 1
- 1181 1
- 1213 1
- 1241 1
- 1262 1
- 1276 1
- 1306 1
- 1334 1
- 1362 1
- 1367 1
- 1368 1
- 1372 1
- 1397 1
- 1441 1
- 1452 1
- 1472 1
- 1491 1
- 1493 1
- 1566 1
- 1601 1
- 1634 1
- 1661 1
- 1701 1
- 1729 1
- 1757 1
- 1801 1
- 1843 1
- 1886 1
- 1899 1
- 1919 1
- 1956 1
- 1999 1
- 2040 1
- 2077 1
- 2099 1
- 2137 1
- 2175 1
- 2198 1
- 2253 1
- 2287 1
- 2347 1
- 2397 1
- 2448 1
- 2485 1
- 2514 1
- 2534 1
- 2548 1
- 2559 1
- 2574 1
- 2592 1
- 2602 1
- 2643 1
- 2672 1
- 2701 1
- 2728 1
- 2743 1
- 2755 1
- 2774 1
- 2790 1
- 2809 1
- 2832 1
- 2840 1
- 2849 1
- 2872 1
- 2878 1
- 2895 1
- 2897 1
- 2924 1
- 2932 1
- 2952 1
- 2967 1
- 2984 1
- 2990 1
- 3000 1
- 3008 1
- 3011 1
- 3037 1
- 3054 1
- 3059 1
- 3082 1
- 3104 1
- 3114 1
- 3122 1
- 3130 1
- 3152 1
- 3163 1
- 3180 1
- 3200 1
- 3205 1
- 3220 1
- 3238 1
- 3271 1
- 3286 1
- 3305 1
- 3323 1
- 3326 1
- 3331 1
- 3345 1
- 3354 1
- 3367 1
- 3376 1
- 3393 1
- 3403 1
- 3411 1
- 3430 1
- 3439 1
- 3458 1
- 3469 1
- 3483 1
- 3489 1
- 3500 1
- 3513 1
- 3525 1
- 3533 1
- 3540 1
- 3547 1
- 3552 1
- 3554 1
- 3565 1
- 3575 1
- 3581 1
- 3588 1
- 3597 1
- 3604 1
- 3608 1
- 3619 1
- 3622 1
- 3632 1
- 3639 1
- 3643 1
- 3647 1
- 3654 1
- 3665 1
- 3674 1
- 3685 1
- 3689 1
- 3696 1
- 3697 1
- 3701 1
- 3706 1
- 3707 1
- 3712 1
- 3720 1
- 3723 1
- 3727 1
- 3729 1
- 3734 1
- 3735 1
- 3738 1
- 3739 1
- 3741 1
- 3768 1
- 3771 1
- 3777 1
- 3778 1
- 3786 1
- 3788 1
- 3792 1
- 3794 1
- 3798 1
- 3799 1
- 3800 1
- 3804 1
- 3805 1
- 3810 1
- 3814 1
- 3819 1
- 3826 1
- 3830 1
- 3832 1
- 3837 1
- 3851 1
- 3852 1
- 3856 1
- 3862 1
- 3896 1
- 3902 1
- 3911 1
- 3922 1
- 3959 1
- 3971 1
- 3988 1
- 4007 1
- 4046 1
- 4065 1
- 4079 1
- 4091 1
- 4151 1
- 4168 1
- 4191 1
- 4203 1
- 4274 1
- 4290 1
- 4326 1
- 4358 1
- 4446 1
- 4477 1
- 4492 1
- 4511 1
- 4611 1
- 4628 1
- 4654 1
- 4677 1
- 4736 1
- 4752 1
- 4772 1
- 4804 1
- 4878 1
- 4900 1
- 4922 1
- 4945 1
- 5018 1
- 5037 1
- 5058 1
- 5072 1
- 5140 1
- 5147 1
- 5173 1
- 5188 1
- 5273 1
- 5287 1
- 5306 1
- 5367 1
- 5381 1
- 5395 1
- 5409 1
- 5444 1
- 5462 1
- 5470 1
- 5477 1
- 5504 1
- 5508 1
- 5514 1
- 5535 1
- 5564 1
- 5572 1
- 5576 1
- 5581 1
- 5594 1
- 5600 1
- 5614 1
- 5624 1
- 5649 1
- 5657 1
- 5665 1
- 5676 1
- 5700 1
- 5708 1
- 5719 1
- 5733 1
- 5790 1
- 5802 1
- 5818 1
- 5840 1
- 5889 1
- 5903 1
- 5916 1
- 5925 1
- 5989 1
- 6007 1
- 6019 1
- 6058 1
- 6176 1
- 6236 1
- 6305 1
- 6392 1
- 6671 1
- 6770 1
- 6849 1
- 6875 1
- 7464 1
- 7558 1
- 7676 1
- 7805 1
- 8240 1
- 8332 1
- 8398 1
- 8514 1
- 8773 1
- 8847 1
- 8892 1
- 8961 1
- 9156 1
- 9183 1
- 9212 1
- 9256 1
- 9358 1
- 9382 1
- 9401 1
- 9423 1
- 9486 1
- 9512 1
- 9525 1
- 9543 1
- 9580 1
- 9584 1
- 9594 1
- 9604 1
- 9634 1
- 9639 1
- 9641 1
- 9664 1
- 9665 1
- 9669 1
- 9674 1
- 9701 1
- 9714 1
- 9723 1
- 9726 1
- 9741 1
- 9744 1
- 9757 1
- 9758 1
- 9764 1
- 9765 1
- 9778 1
- 9781 1
- 9790 1
- 9796 1
- 9812 1
- 9815 1
- 9824 1
- 9837 1
- 9862 1
- 9872 1
- 9881 1
- 9886 1
- 9908 1
- 9922 1
- 9931 1
- 9949 1
- 9975 1
- 9997 1
- 10032 1
- 10036 1
- 10091 1
- 10121 1
- 10142 1
- 10170 1
- 10189 1
state 1
- Virginia · 789 ✖
fips 1
- 51199 · 789 ✖
county 1
- York 789
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502642 | 2502642 | 2022-05-13 | York | Virginia | 51199 | 10189 | 109 |
2499384 | 2499384 | 2022-05-12 | York | Virginia | 51199 | 10170 | 109 |
2496126 | 2496126 | 2022-05-11 | York | Virginia | 51199 | 10142 | 109 |
2492868 | 2492868 | 2022-05-10 | York | Virginia | 51199 | 10121 | 109 |
2489610 | 2489610 | 2022-05-09 | York | Virginia | 51199 | 10091 | 109 |
2486353 | 2486353 | 2022-05-08 | York | Virginia | 51199 | 10048 | 109 |
2483095 | 2483095 | 2022-05-07 | York | Virginia | 51199 | 10048 | 109 |
2479837 | 2479837 | 2022-05-06 | York | Virginia | 51199 | 10048 | 109 |
2476579 | 2476579 | 2022-05-05 | York | Virginia | 51199 | 10036 | 109 |
2473321 | 2473321 | 2022-05-04 | York | Virginia | 51199 | 10032 | 109 |
2470065 | 2470065 | 2022-05-03 | York | Virginia | 51199 | 9997 | 109 |
2466809 | 2466809 | 2022-05-02 | York | Virginia | 51199 | 9975 | 109 |
2463554 | 2463554 | 2022-05-01 | York | Virginia | 51199 | 9956 | 109 |
2460298 | 2460298 | 2022-04-30 | York | Virginia | 51199 | 9956 | 109 |
2457042 | 2457042 | 2022-04-29 | York | Virginia | 51199 | 9956 | 109 |
2453786 | 2453786 | 2022-04-28 | York | Virginia | 51199 | 9949 | 109 |
2450530 | 2450530 | 2022-04-27 | York | Virginia | 51199 | 9931 | 109 |
2447274 | 2447274 | 2022-04-26 | York | Virginia | 51199 | 9922 | 108 |
2444018 | 2444018 | 2022-04-25 | York | Virginia | 51199 | 9908 | 108 |
2440762 | 2440762 | 2022-04-24 | York | Virginia | 51199 | 9894 | 108 |
2437506 | 2437506 | 2022-04-23 | York | Virginia | 51199 | 9894 | 108 |
2434250 | 2434250 | 2022-04-22 | York | Virginia | 51199 | 9894 | 108 |
2430994 | 2430994 | 2022-04-21 | York | Virginia | 51199 | 9886 | 108 |
2427738 | 2427738 | 2022-04-20 | York | Virginia | 51199 | 9881 | 108 |
2424482 | 2424482 | 2022-04-19 | York | Virginia | 51199 | 9872 | 108 |
2421226 | 2421226 | 2022-04-18 | York | Virginia | 51199 | 9862 | 107 |
2417970 | 2417970 | 2022-04-17 | York | Virginia | 51199 | 9845 | 106 |
2414714 | 2414714 | 2022-04-16 | York | Virginia | 51199 | 9845 | 106 |
2411458 | 2411458 | 2022-04-15 | York | Virginia | 51199 | 9845 | 106 |
2408202 | 2408202 | 2022-04-14 | York | Virginia | 51199 | 9837 | 106 |
2404946 | 2404946 | 2022-04-13 | York | Virginia | 51199 | 9824 | 105 |
2401691 | 2401691 | 2022-04-12 | York | Virginia | 51199 | 9815 | 105 |
2398436 | 2398436 | 2022-04-11 | York | Virginia | 51199 | 9812 | 105 |
2395181 | 2395181 | 2022-04-10 | York | Virginia | 51199 | 9801 | 105 |
2391925 | 2391925 | 2022-04-09 | York | Virginia | 51199 | 9801 | 105 |
2388669 | 2388669 | 2022-04-08 | York | Virginia | 51199 | 9801 | 105 |
2385414 | 2385414 | 2022-04-07 | York | Virginia | 51199 | 9796 | 105 |
2382159 | 2382159 | 2022-04-06 | York | Virginia | 51199 | 9790 | 105 |
2378904 | 2378904 | 2022-04-05 | York | Virginia | 51199 | 9781 | 105 |
2375650 | 2375650 | 2022-04-04 | York | Virginia | 51199 | 9778 | 105 |
2372398 | 2372398 | 2022-04-03 | York | Virginia | 51199 | 9770 | 105 |
2369145 | 2369145 | 2022-04-02 | York | Virginia | 51199 | 9770 | 105 |
2365892 | 2365892 | 2022-04-01 | York | Virginia | 51199 | 9770 | 105 |
2362639 | 2362639 | 2022-03-31 | York | Virginia | 51199 | 9765 | 105 |
2359385 | 2359385 | 2022-03-30 | York | Virginia | 51199 | 9764 | 105 |
2356131 | 2356131 | 2022-03-29 | York | Virginia | 51199 | 9757 | 105 |
2352878 | 2352878 | 2022-03-28 | York | Virginia | 51199 | 9758 | 105 |
2349626 | 2349626 | 2022-03-27 | York | Virginia | 51199 | 9745 | 105 |
2346373 | 2346373 | 2022-03-26 | York | Virginia | 51199 | 9745 | 105 |
2343120 | 2343120 | 2022-03-25 | York | Virginia | 51199 | 9745 | 105 |
2339867 | 2339867 | 2022-03-24 | York | Virginia | 51199 | 9744 | 105 |
2336614 | 2336614 | 2022-03-23 | York | Virginia | 51199 | 9741 | 104 |
2333360 | 2333360 | 2022-03-22 | York | Virginia | 51199 | 9734 | 104 |
2330106 | 2330106 | 2022-03-21 | York | Virginia | 51199 | 9734 | 104 |
2326854 | 2326854 | 2022-03-20 | York | Virginia | 51199 | 9728 | 104 |
2323601 | 2323601 | 2022-03-19 | York | Virginia | 51199 | 9728 | 104 |
2320347 | 2320347 | 2022-03-18 | York | Virginia | 51199 | 9728 | 104 |
2317093 | 2317093 | 2022-03-17 | York | Virginia | 51199 | 9726 | 104 |
2313840 | 2313840 | 2022-03-16 | York | Virginia | 51199 | 9723 | 104 |
2310587 | 2310587 | 2022-03-15 | York | Virginia | 51199 | 9714 | 104 |
2307334 | 2307334 | 2022-03-14 | York | Virginia | 51199 | 9701 | 104 |
2304083 | 2304083 | 2022-03-13 | York | Virginia | 51199 | 9685 | 104 |
2300831 | 2300831 | 2022-03-12 | York | Virginia | 51199 | 9685 | 104 |
2297579 | 2297579 | 2022-03-11 | York | Virginia | 51199 | 9685 | 104 |
2294327 | 2294327 | 2022-03-10 | York | Virginia | 51199 | 9674 | 104 |
2291075 | 2291075 | 2022-03-09 | York | Virginia | 51199 | 9669 | 105 |
2287823 | 2287823 | 2022-03-08 | York | Virginia | 51199 | 9664 | 105 |
2284571 | 2284571 | 2022-03-07 | York | Virginia | 51199 | 9665 | 105 |
2281319 | 2281319 | 2022-03-06 | York | Virginia | 51199 | 9651 | 105 |
2278066 | 2278066 | 2022-03-05 | York | Virginia | 51199 | 9651 | 105 |
2274813 | 2274813 | 2022-03-04 | York | Virginia | 51199 | 9651 | 105 |
2271560 | 2271560 | 2022-03-03 | York | Virginia | 51199 | 9651 | 105 |
2268308 | 2268308 | 2022-03-02 | York | Virginia | 51199 | 9641 | 104 |
2265055 | 2265055 | 2022-03-01 | York | Virginia | 51199 | 9639 | 103 |
2261805 | 2261805 | 2022-02-28 | York | Virginia | 51199 | 9634 | 103 |
2258554 | 2258554 | 2022-02-27 | York | Virginia | 51199 | 9618 | 102 |
2255303 | 2255303 | 2022-02-26 | York | Virginia | 51199 | 9618 | 102 |
2252052 | 2252052 | 2022-02-25 | York | Virginia | 51199 | 9618 | 102 |
2248801 | 2248801 | 2022-02-24 | York | Virginia | 51199 | 9604 | 102 |
2245550 | 2245550 | 2022-02-23 | York | Virginia | 51199 | 9594 | 101 |
2242299 | 2242299 | 2022-02-22 | York | Virginia | 51199 | 9584 | 101 |
2239048 | 2239048 | 2022-02-21 | York | Virginia | 51199 | 9580 | 100 |
2235797 | 2235797 | 2022-02-20 | York | Virginia | 51199 | 9549 | 100 |
2232546 | 2232546 | 2022-02-19 | York | Virginia | 51199 | 9549 | 100 |
2229295 | 2229295 | 2022-02-18 | York | Virginia | 51199 | 9549 | 100 |
2226044 | 2226044 | 2022-02-17 | York | Virginia | 51199 | 9543 | 98 |
2222793 | 2222793 | 2022-02-16 | York | Virginia | 51199 | 9525 | 97 |
2219542 | 2219542 | 2022-02-15 | York | Virginia | 51199 | 9512 | 97 |
2216292 | 2216292 | 2022-02-14 | York | Virginia | 51199 | 9486 | 96 |
2213041 | 2213041 | 2022-02-13 | York | Virginia | 51199 | 9439 | 95 |
2209788 | 2209788 | 2022-02-12 | York | Virginia | 51199 | 9439 | 95 |
2206535 | 2206535 | 2022-02-11 | York | Virginia | 51199 | 9439 | 95 |
2203282 | 2203282 | 2022-02-10 | York | Virginia | 51199 | 9423 | 95 |
2200028 | 2200028 | 2022-02-09 | York | Virginia | 51199 | 9401 | 95 |
2196774 | 2196774 | 2022-02-08 | York | Virginia | 51199 | 9382 | 95 |
2193519 | 2193519 | 2022-02-07 | York | Virginia | 51199 | 9358 | 95 |
2190266 | 2190266 | 2022-02-06 | York | Virginia | 51199 | 9290 | 90 |
2187013 | 2187013 | 2022-02-05 | York | Virginia | 51199 | 9290 | 90 |
2183760 | 2183760 | 2022-02-04 | York | Virginia | 51199 | 9290 | 90 |
2180508 | 2180508 | 2022-02-03 | York | Virginia | 51199 | 9256 | 89 |
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);