ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51085 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
952626 | 952626 | 2021-01-21 | Hanover | Virginia | 51085 | 5299 | 91 |
949381 | 949381 | 2021-01-20 | Hanover | Virginia | 51085 | 5271 | 88 |
946135 | 946135 | 2021-01-19 | Hanover | Virginia | 51085 | 5235 | 83 |
942888 | 942888 | 2021-01-18 | Hanover | Virginia | 51085 | 5171 | 83 |
939643 | 939643 | 2021-01-17 | Hanover | Virginia | 51085 | 5079 | 83 |
936398 | 936398 | 2021-01-16 | Hanover | Virginia | 51085 | 4947 | 83 |
933153 | 933153 | 2021-01-15 | Hanover | Virginia | 51085 | 4921 | 83 |
929908 | 929908 | 2021-01-14 | Hanover | Virginia | 51085 | 4906 | 83 |
926663 | 926663 | 2021-01-13 | Hanover | Virginia | 51085 | 4863 | 82 |
923417 | 923417 | 2021-01-12 | Hanover | Virginia | 51085 | 4830 | 80 |
920172 | 920172 | 2021-01-11 | Hanover | Virginia | 51085 | 4780 | 79 |
916927 | 916927 | 2021-01-10 | Hanover | Virginia | 51085 | 4663 | 79 |
913682 | 913682 | 2021-01-09 | Hanover | Virginia | 51085 | 4506 | 79 |
910437 | 910437 | 2021-01-08 | Hanover | Virginia | 51085 | 4405 | 79 |
907192 | 907192 | 2021-01-07 | Hanover | Virginia | 51085 | 4372 | 78 |
903946 | 903946 | 2021-01-06 | Hanover | Virginia | 51085 | 4321 | 78 |
900701 | 900701 | 2021-01-05 | Hanover | Virginia | 51085 | 4262 | 78 |
897456 | 897456 | 2021-01-04 | Hanover | Virginia | 51085 | 4088 | 77 |
894210 | 894210 | 2021-01-03 | Hanover | Virginia | 51085 | 4055 | 77 |
890964 | 890964 | 2021-01-02 | Hanover | Virginia | 51085 | 4001 | 77 |
887717 | 887717 | 2021-01-01 | Hanover | Virginia | 51085 | 3910 | 74 |
884472 | 884472 | 2020-12-31 | Hanover | Virginia | 51085 | 3828 | 72 |
881227 | 881227 | 2020-12-30 | Hanover | Virginia | 51085 | 3721 | 71 |
877982 | 877982 | 2020-12-29 | Hanover | Virginia | 51085 | 3678 | 71 |
874737 | 874737 | 2020-12-28 | Hanover | Virginia | 51085 | 3655 | 69 |
871492 | 871492 | 2020-12-27 | Hanover | Virginia | 51085 | 3634 | 69 |
868247 | 868247 | 2020-12-26 | Hanover | Virginia | 51085 | 3589 | 69 |
865002 | 865002 | 2020-12-25 | Hanover | Virginia | 51085 | 3523 | 69 |
861757 | 861757 | 2020-12-24 | Hanover | Virginia | 51085 | 3488 | 69 |
858512 | 858512 | 2020-12-23 | Hanover | Virginia | 51085 | 3468 | 67 |
855267 | 855267 | 2020-12-22 | Hanover | Virginia | 51085 | 3382 | 67 |
852022 | 852022 | 2020-12-21 | Hanover | Virginia | 51085 | 3314 | 65 |
848777 | 848777 | 2020-12-20 | Hanover | Virginia | 51085 | 3207 | 65 |
845532 | 845532 | 2020-12-19 | Hanover | Virginia | 51085 | 3162 | 65 |
842286 | 842286 | 2020-12-18 | Hanover | Virginia | 51085 | 3128 | 64 |
839041 | 839041 | 2020-12-17 | Hanover | Virginia | 51085 | 3085 | 64 |
835795 | 835795 | 2020-12-16 | Hanover | Virginia | 51085 | 3062 | 61 |
832549 | 832549 | 2020-12-15 | Hanover | Virginia | 51085 | 3018 | 61 |
829302 | 829302 | 2020-12-14 | Hanover | Virginia | 51085 | 2981 | 60 |
826056 | 826056 | 2020-12-13 | Hanover | Virginia | 51085 | 2967 | 60 |
822809 | 822809 | 2020-12-12 | Hanover | Virginia | 51085 | 2945 | 60 |
819563 | 819563 | 2020-12-11 | Hanover | Virginia | 51085 | 2902 | 59 |
816317 | 816317 | 2020-12-10 | Hanover | Virginia | 51085 | 2864 | 59 |
813071 | 813071 | 2020-12-09 | Hanover | Virginia | 51085 | 2820 | 58 |
809827 | 809827 | 2020-12-08 | Hanover | Virginia | 51085 | 2770 | 58 |
806582 | 806582 | 2020-12-07 | Hanover | Virginia | 51085 | 2733 | 56 |
803337 | 803337 | 2020-12-06 | Hanover | Virginia | 51085 | 2671 | 56 |
800092 | 800092 | 2020-12-05 | Hanover | Virginia | 51085 | 2622 | 56 |
796847 | 796847 | 2020-12-04 | Hanover | Virginia | 51085 | 2583 | 56 |
793602 | 793602 | 2020-12-03 | Hanover | Virginia | 51085 | 2534 | 54 |
790357 | 790357 | 2020-12-02 | Hanover | Virginia | 51085 | 2494 | 54 |
787112 | 787112 | 2020-12-01 | Hanover | Virginia | 51085 | 2473 | 54 |
783868 | 783868 | 2020-11-30 | Hanover | Virginia | 51085 | 2442 | 54 |
780623 | 780623 | 2020-11-29 | Hanover | Virginia | 51085 | 2412 | 54 |
777377 | 777377 | 2020-11-28 | Hanover | Virginia | 51085 | 2394 | 54 |
774132 | 774132 | 2020-11-27 | Hanover | Virginia | 51085 | 2377 | 54 |
770887 | 770887 | 2020-11-26 | Hanover | Virginia | 51085 | 2341 | 53 |
767641 | 767641 | 2020-11-25 | Hanover | Virginia | 51085 | 2312 | 52 |
764396 | 764396 | 2020-11-24 | Hanover | Virginia | 51085 | 2268 | 51 |
761151 | 761151 | 2020-11-23 | Hanover | Virginia | 51085 | 2244 | 51 |
757906 | 757906 | 2020-11-22 | Hanover | Virginia | 51085 | 2202 | 51 |
754659 | 754659 | 2020-11-21 | Hanover | Virginia | 51085 | 2163 | 51 |
751413 | 751413 | 2020-11-20 | Hanover | Virginia | 51085 | 2139 | 49 |
748167 | 748167 | 2020-11-19 | Hanover | Virginia | 51085 | 2090 | 48 |
744921 | 744921 | 2020-11-18 | Hanover | Virginia | 51085 | 2068 | 48 |
741674 | 741674 | 2020-11-17 | Hanover | Virginia | 51085 | 2050 | 48 |
738427 | 738427 | 2020-11-16 | Hanover | Virginia | 51085 | 2032 | 48 |
735183 | 735183 | 2020-11-15 | Hanover | Virginia | 51085 | 1969 | 48 |
731937 | 731937 | 2020-11-14 | Hanover | Virginia | 51085 | 1961 | 48 |
728692 | 728692 | 2020-11-13 | Hanover | Virginia | 51085 | 1944 | 47 |
725449 | 725449 | 2020-11-12 | Hanover | Virginia | 51085 | 1930 | 47 |
722206 | 722206 | 2020-11-11 | Hanover | Virginia | 51085 | 1915 | 47 |
718963 | 718963 | 2020-11-10 | Hanover | Virginia | 51085 | 1893 | 46 |
715720 | 715720 | 2020-11-09 | Hanover | Virginia | 51085 | 1864 | 46 |
712476 | 712476 | 2020-11-08 | Hanover | Virginia | 51085 | 1859 | 46 |
709232 | 709232 | 2020-11-07 | Hanover | Virginia | 51085 | 1842 | 46 |
705988 | 705988 | 2020-11-06 | Hanover | Virginia | 51085 | 1802 | 45 |
702745 | 702745 | 2020-11-05 | Hanover | Virginia | 51085 | 1780 | 45 |
699502 | 699502 | 2020-11-04 | Hanover | Virginia | 51085 | 1766 | 45 |
696258 | 696258 | 2020-11-03 | Hanover | Virginia | 51085 | 1747 | 44 |
693016 | 693016 | 2020-11-02 | Hanover | Virginia | 51085 | 1736 | 44 |
689772 | 689772 | 2020-11-01 | Hanover | Virginia | 51085 | 1721 | 44 |
686527 | 686527 | 2020-10-31 | Hanover | Virginia | 51085 | 1705 | 44 |
683284 | 683284 | 2020-10-30 | Hanover | Virginia | 51085 | 1672 | 44 |
680041 | 680041 | 2020-10-29 | Hanover | Virginia | 51085 | 1666 | 44 |
676798 | 676798 | 2020-10-28 | Hanover | Virginia | 51085 | 1642 | 44 |
673555 | 673555 | 2020-10-27 | Hanover | Virginia | 51085 | 1629 | 43 |
670313 | 670313 | 2020-10-26 | Hanover | Virginia | 51085 | 1612 | 42 |
667070 | 667070 | 2020-10-25 | Hanover | Virginia | 51085 | 1603 | 42 |
663825 | 663825 | 2020-10-24 | Hanover | Virginia | 51085 | 1591 | 42 |
660581 | 660581 | 2020-10-23 | Hanover | Virginia | 51085 | 1580 | 42 |
657337 | 657337 | 2020-10-22 | Hanover | Virginia | 51085 | 1571 | 42 |
654092 | 654092 | 2020-10-21 | Hanover | Virginia | 51085 | 1554 | 42 |
650847 | 650847 | 2020-10-20 | Hanover | Virginia | 51085 | 1545 | 41 |
647603 | 647603 | 2020-10-19 | Hanover | Virginia | 51085 | 1537 | 41 |
644357 | 644357 | 2020-10-18 | Hanover | Virginia | 51085 | 1531 | 40 |
641109 | 641109 | 2020-10-17 | Hanover | Virginia | 51085 | 1521 | 40 |
637862 | 637862 | 2020-10-16 | Hanover | Virginia | 51085 | 1507 | 40 |
634617 | 634617 | 2020-10-15 | Hanover | Virginia | 51085 | 1495 | 40 |
631372 | 631372 | 2020-10-14 | Hanover | Virginia | 51085 | 1475 | 40 |
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);