ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 51193 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1095504 | 1095504 | 2021-03-06 | Westmoreland | Virginia | 51193 | 1124 | 21 |
1092258 | 1092258 | 2021-03-05 | Westmoreland | Virginia | 51193 | 1122 | 21 |
1089012 | 1089012 | 2021-03-04 | Westmoreland | Virginia | 51193 | 1120 | 21 |
1085767 | 1085767 | 2021-03-03 | Westmoreland | Virginia | 51193 | 1117 | 21 |
1082521 | 1082521 | 2021-03-02 | Westmoreland | Virginia | 51193 | 1115 | 21 |
1079275 | 1079275 | 2021-03-01 | Westmoreland | Virginia | 51193 | 1114 | 20 |
1076030 | 1076030 | 2021-02-28 | Westmoreland | Virginia | 51193 | 1110 | 17 |
1072784 | 1072784 | 2021-02-27 | Westmoreland | Virginia | 51193 | 1107 | 17 |
1069538 | 1069538 | 2021-02-26 | Westmoreland | Virginia | 51193 | 1106 | 17 |
1066293 | 1066293 | 2021-02-25 | Westmoreland | Virginia | 51193 | 1105 | 17 |
1063048 | 1063048 | 2021-02-24 | Westmoreland | Virginia | 51193 | 1104 | 17 |
1059803 | 1059803 | 2021-02-23 | Westmoreland | Virginia | 51193 | 1099 | 16 |
1056557 | 1056557 | 2021-02-22 | Westmoreland | Virginia | 51193 | 1098 | 16 |
1053311 | 1053311 | 2021-02-21 | Westmoreland | Virginia | 51193 | 1098 | 16 |
1050064 | 1050064 | 2021-02-20 | Westmoreland | Virginia | 51193 | 1096 | 16 |
1046817 | 1046817 | 2021-02-19 | Westmoreland | Virginia | 51193 | 1097 | 16 |
1043572 | 1043572 | 2021-02-18 | Westmoreland | Virginia | 51193 | 1094 | 16 |
1040327 | 1040327 | 2021-02-17 | Westmoreland | Virginia | 51193 | 1090 | 16 |
1037082 | 1037082 | 2021-02-16 | Westmoreland | Virginia | 51193 | 1089 | 16 |
1033837 | 1033837 | 2021-02-15 | Westmoreland | Virginia | 51193 | 1086 | 16 |
1030591 | 1030591 | 2021-02-14 | Westmoreland | Virginia | 51193 | 1086 | 16 |
1027344 | 1027344 | 2021-02-13 | Westmoreland | Virginia | 51193 | 1086 | 16 |
1024099 | 1024099 | 2021-02-12 | Westmoreland | Virginia | 51193 | 1069 | 16 |
1020854 | 1020854 | 2021-02-11 | Westmoreland | Virginia | 51193 | 1067 | 16 |
1017609 | 1017609 | 2021-02-10 | Westmoreland | Virginia | 51193 | 1056 | 16 |
1014364 | 1014364 | 2021-02-09 | Westmoreland | Virginia | 51193 | 1055 | 16 |
1011119 | 1011119 | 2021-02-08 | Westmoreland | Virginia | 51193 | 1052 | 16 |
1007873 | 1007873 | 2021-02-07 | Westmoreland | Virginia | 51193 | 1051 | 16 |
1004627 | 1004627 | 2021-02-06 | Westmoreland | Virginia | 51193 | 1047 | 16 |
1001381 | 1001381 | 2021-02-05 | Westmoreland | Virginia | 51193 | 1040 | 16 |
998135 | 998135 | 2021-02-04 | Westmoreland | Virginia | 51193 | 1030 | 16 |
994889 | 994889 | 2021-02-03 | Westmoreland | Virginia | 51193 | 1029 | 16 |
991643 | 991643 | 2021-02-02 | Westmoreland | Virginia | 51193 | 1024 | 16 |
988397 | 988397 | 2021-02-01 | Westmoreland | Virginia | 51193 | 1019 | 16 |
985150 | 985150 | 2021-01-31 | Westmoreland | Virginia | 51193 | 1018 | 16 |
981903 | 981903 | 2021-01-30 | Westmoreland | Virginia | 51193 | 1014 | 16 |
978657 | 978657 | 2021-01-29 | Westmoreland | Virginia | 51193 | 1002 | 16 |
975412 | 975412 | 2021-01-28 | Westmoreland | Virginia | 51193 | 984 | 16 |
972167 | 972167 | 2021-01-27 | Westmoreland | Virginia | 51193 | 971 | 16 |
968922 | 968922 | 2021-01-26 | Westmoreland | Virginia | 51193 | 966 | 16 |
965678 | 965678 | 2021-01-25 | Westmoreland | Virginia | 51193 | 960 | 14 |
962433 | 962433 | 2021-01-24 | Westmoreland | Virginia | 51193 | 944 | 14 |
959188 | 959188 | 2021-01-23 | Westmoreland | Virginia | 51193 | 931 | 14 |
955942 | 955942 | 2021-01-22 | Westmoreland | Virginia | 51193 | 920 | 14 |
952697 | 952697 | 2021-01-21 | Westmoreland | Virginia | 51193 | 913 | 14 |
949452 | 949452 | 2021-01-20 | Westmoreland | Virginia | 51193 | 899 | 13 |
946206 | 946206 | 2021-01-19 | Westmoreland | Virginia | 51193 | 892 | 12 |
942959 | 942959 | 2021-01-18 | Westmoreland | Virginia | 51193 | 885 | 12 |
939714 | 939714 | 2021-01-17 | Westmoreland | Virginia | 51193 | 874 | 12 |
936469 | 936469 | 2021-01-16 | Westmoreland | Virginia | 51193 | 862 | 12 |
933224 | 933224 | 2021-01-15 | Westmoreland | Virginia | 51193 | 852 | 12 |
929979 | 929979 | 2021-01-14 | Westmoreland | Virginia | 51193 | 846 | 12 |
926734 | 926734 | 2021-01-13 | Westmoreland | Virginia | 51193 | 827 | 11 |
923488 | 923488 | 2021-01-12 | Westmoreland | Virginia | 51193 | 811 | 11 |
920243 | 920243 | 2021-01-11 | Westmoreland | Virginia | 51193 | 796 | 11 |
916998 | 916998 | 2021-01-10 | Westmoreland | Virginia | 51193 | 786 | 11 |
913753 | 913753 | 2021-01-09 | Westmoreland | Virginia | 51193 | 780 | 11 |
910508 | 910508 | 2021-01-08 | Westmoreland | Virginia | 51193 | 772 | 11 |
907263 | 907263 | 2021-01-07 | Westmoreland | Virginia | 51193 | 762 | 11 |
904017 | 904017 | 2021-01-06 | Westmoreland | Virginia | 51193 | 735 | 10 |
900772 | 900772 | 2021-01-05 | Westmoreland | Virginia | 51193 | 724 | 10 |
897527 | 897527 | 2021-01-04 | Westmoreland | Virginia | 51193 | 714 | 9 |
894281 | 894281 | 2021-01-03 | Westmoreland | Virginia | 51193 | 711 | 9 |
891035 | 891035 | 2021-01-02 | Westmoreland | Virginia | 51193 | 707 | 9 |
887788 | 887788 | 2021-01-01 | Westmoreland | Virginia | 51193 | 699 | 9 |
884543 | 884543 | 2020-12-31 | Westmoreland | Virginia | 51193 | 692 | 9 |
881298 | 881298 | 2020-12-30 | Westmoreland | Virginia | 51193 | 692 | 9 |
878053 | 878053 | 2020-12-29 | Westmoreland | Virginia | 51193 | 685 | 9 |
874808 | 874808 | 2020-12-28 | Westmoreland | Virginia | 51193 | 674 | 9 |
871563 | 871563 | 2020-12-27 | Westmoreland | Virginia | 51193 | 671 | 9 |
868318 | 868318 | 2020-12-26 | Westmoreland | Virginia | 51193 | 669 | 9 |
865073 | 865073 | 2020-12-25 | Westmoreland | Virginia | 51193 | 667 | 9 |
861828 | 861828 | 2020-12-24 | Westmoreland | Virginia | 51193 | 661 | 9 |
858583 | 858583 | 2020-12-23 | Westmoreland | Virginia | 51193 | 653 | 9 |
855338 | 855338 | 2020-12-22 | Westmoreland | Virginia | 51193 | 630 | 9 |
852093 | 852093 | 2020-12-21 | Westmoreland | Virginia | 51193 | 620 | 9 |
848848 | 848848 | 2020-12-20 | Westmoreland | Virginia | 51193 | 612 | 9 |
845603 | 845603 | 2020-12-19 | Westmoreland | Virginia | 51193 | 604 | 9 |
842357 | 842357 | 2020-12-18 | Westmoreland | Virginia | 51193 | 599 | 9 |
839112 | 839112 | 2020-12-17 | Westmoreland | Virginia | 51193 | 593 | 9 |
835866 | 835866 | 2020-12-16 | Westmoreland | Virginia | 51193 | 589 | 9 |
832620 | 832620 | 2020-12-15 | Westmoreland | Virginia | 51193 | 582 | 9 |
829373 | 829373 | 2020-12-14 | Westmoreland | Virginia | 51193 | 579 | 9 |
826127 | 826127 | 2020-12-13 | Westmoreland | Virginia | 51193 | 553 | 8 |
822880 | 822880 | 2020-12-12 | Westmoreland | Virginia | 51193 | 549 | 8 |
819634 | 819634 | 2020-12-11 | Westmoreland | Virginia | 51193 | 532 | 8 |
816388 | 816388 | 2020-12-10 | Westmoreland | Virginia | 51193 | 530 | 8 |
813142 | 813142 | 2020-12-09 | Westmoreland | Virginia | 51193 | 515 | 8 |
809898 | 809898 | 2020-12-08 | Westmoreland | Virginia | 51193 | 498 | 8 |
806653 | 806653 | 2020-12-07 | Westmoreland | Virginia | 51193 | 488 | 8 |
803408 | 803408 | 2020-12-06 | Westmoreland | Virginia | 51193 | 488 | 8 |
800163 | 800163 | 2020-12-05 | Westmoreland | Virginia | 51193 | 480 | 8 |
796918 | 796918 | 2020-12-04 | Westmoreland | Virginia | 51193 | 455 | 8 |
793673 | 793673 | 2020-12-03 | Westmoreland | Virginia | 51193 | 450 | 8 |
790428 | 790428 | 2020-12-02 | Westmoreland | Virginia | 51193 | 445 | 8 |
787183 | 787183 | 2020-12-01 | Westmoreland | Virginia | 51193 | 443 | 8 |
783939 | 783939 | 2020-11-30 | Westmoreland | Virginia | 51193 | 427 | 7 |
780694 | 780694 | 2020-11-29 | Westmoreland | Virginia | 51193 | 425 | 7 |
777448 | 777448 | 2020-11-28 | Westmoreland | Virginia | 51193 | 419 | 7 |
774203 | 774203 | 2020-11-27 | Westmoreland | Virginia | 51193 | 414 | 7 |
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);