ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Upshur" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1085860 | 1085860 | 2021-03-03 | Upshur | West Virginia | 54097 | 1693 | 30 |
1082614 | 1082614 | 2021-03-02 | Upshur | West Virginia | 54097 | 1690 | 30 |
1079368 | 1079368 | 2021-03-01 | Upshur | West Virginia | 54097 | 1684 | 30 |
1076123 | 1076123 | 2021-02-28 | Upshur | West Virginia | 54097 | 1683 | 30 |
1072877 | 1072877 | 2021-02-27 | Upshur | West Virginia | 54097 | 1679 | 30 |
1069631 | 1069631 | 2021-02-26 | Upshur | West Virginia | 54097 | 1678 | 30 |
1066386 | 1066386 | 2021-02-25 | Upshur | West Virginia | 54097 | 1668 | 30 |
1063141 | 1063141 | 2021-02-24 | Upshur | West Virginia | 54097 | 1660 | 30 |
1059896 | 1059896 | 2021-02-23 | Upshur | West Virginia | 54097 | 1658 | 30 |
1056650 | 1056650 | 2021-02-22 | Upshur | West Virginia | 54097 | 1655 | 30 |
1053404 | 1053404 | 2021-02-21 | Upshur | West Virginia | 54097 | 1652 | 30 |
1050157 | 1050157 | 2021-02-20 | Upshur | West Virginia | 54097 | 1651 | 30 |
1046910 | 1046910 | 2021-02-19 | Upshur | West Virginia | 54097 | 1640 | 30 |
1043665 | 1043665 | 2021-02-18 | Upshur | West Virginia | 54097 | 1634 | 30 |
1040420 | 1040420 | 2021-02-17 | Upshur | West Virginia | 54097 | 1626 | 29 |
1037175 | 1037175 | 2021-02-16 | Upshur | West Virginia | 54097 | 1623 | 29 |
1033930 | 1033930 | 2021-02-15 | Upshur | West Virginia | 54097 | 1620 | 29 |
1030684 | 1030684 | 2021-02-14 | Upshur | West Virginia | 54097 | 1614 | 29 |
1027437 | 1027437 | 2021-02-13 | Upshur | West Virginia | 54097 | 1613 | 29 |
1024192 | 1024192 | 2021-02-12 | Upshur | West Virginia | 54097 | 1611 | 29 |
1020947 | 1020947 | 2021-02-11 | Upshur | West Virginia | 54097 | 1605 | 29 |
1017702 | 1017702 | 2021-02-10 | Upshur | West Virginia | 54097 | 1600 | 29 |
1014457 | 1014457 | 2021-02-09 | Upshur | West Virginia | 54097 | 1585 | 27 |
1011212 | 1011212 | 2021-02-08 | Upshur | West Virginia | 54097 | 1578 | 27 |
1007966 | 1007966 | 2021-02-07 | Upshur | West Virginia | 54097 | 1570 | 27 |
1004720 | 1004720 | 2021-02-06 | Upshur | West Virginia | 54097 | 1569 | 26 |
1001474 | 1001474 | 2021-02-05 | Upshur | West Virginia | 54097 | 1551 | 25 |
998228 | 998228 | 2021-02-04 | Upshur | West Virginia | 54097 | 1534 | 25 |
994982 | 994982 | 2021-02-03 | Upshur | West Virginia | 54097 | 1517 | 25 |
991736 | 991736 | 2021-02-02 | Upshur | West Virginia | 54097 | 1506 | 23 |
988490 | 988490 | 2021-02-01 | Upshur | West Virginia | 54097 | 1497 | 23 |
985243 | 985243 | 2021-01-31 | Upshur | West Virginia | 54097 | 1492 | 23 |
981996 | 981996 | 2021-01-30 | Upshur | West Virginia | 54097 | 1483 | 23 |
978750 | 978750 | 2021-01-29 | Upshur | West Virginia | 54097 | 1471 | 23 |
975505 | 975505 | 2021-01-28 | Upshur | West Virginia | 54097 | 1462 | 23 |
972260 | 972260 | 2021-01-27 | Upshur | West Virginia | 54097 | 1451 | 20 |
969015 | 969015 | 2021-01-26 | Upshur | West Virginia | 54097 | 1435 | 19 |
965771 | 965771 | 2021-01-25 | Upshur | West Virginia | 54097 | 1420 | 19 |
962526 | 962526 | 2021-01-24 | Upshur | West Virginia | 54097 | 1417 | 19 |
959281 | 959281 | 2021-01-23 | Upshur | West Virginia | 54097 | 1406 | 19 |
956035 | 956035 | 2021-01-22 | Upshur | West Virginia | 54097 | 1358 | 20 |
952790 | 952790 | 2021-01-21 | Upshur | West Virginia | 54097 | 1333 | 20 |
949545 | 949545 | 2021-01-20 | Upshur | West Virginia | 54097 | 1307 | 20 |
946299 | 946299 | 2021-01-19 | Upshur | West Virginia | 54097 | 1290 | 19 |
943052 | 943052 | 2021-01-18 | Upshur | West Virginia | 54097 | 1274 | 19 |
939807 | 939807 | 2021-01-17 | Upshur | West Virginia | 54097 | 1268 | 17 |
936562 | 936562 | 2021-01-16 | Upshur | West Virginia | 54097 | 1260 | 16 |
933317 | 933317 | 2021-01-15 | Upshur | West Virginia | 54097 | 1237 | 15 |
930072 | 930072 | 2021-01-14 | Upshur | West Virginia | 54097 | 1215 | 14 |
926827 | 926827 | 2021-01-13 | Upshur | West Virginia | 54097 | 1203 | 13 |
923581 | 923581 | 2021-01-12 | Upshur | West Virginia | 54097 | 1188 | 12 |
920336 | 920336 | 2021-01-11 | Upshur | West Virginia | 54097 | 1180 | 11 |
917091 | 917091 | 2021-01-10 | Upshur | West Virginia | 54097 | 1173 | 11 |
913846 | 913846 | 2021-01-09 | Upshur | West Virginia | 54097 | 1165 | 9 |
910601 | 910601 | 2021-01-08 | Upshur | West Virginia | 54097 | 1153 | 7 |
907356 | 907356 | 2021-01-07 | Upshur | West Virginia | 54097 | 1098 | 7 |
904110 | 904110 | 2021-01-06 | Upshur | West Virginia | 54097 | 1080 | 6 |
900865 | 900865 | 2021-01-05 | Upshur | West Virginia | 54097 | 1057 | 5 |
897620 | 897620 | 2021-01-04 | Upshur | West Virginia | 54097 | 1026 | 5 |
894374 | 894374 | 2021-01-03 | Upshur | West Virginia | 54097 | 999 | 5 |
891128 | 891128 | 2021-01-02 | Upshur | West Virginia | 54097 | 970 | 5 |
887881 | 887881 | 2021-01-01 | Upshur | West Virginia | 54097 | 964 | 4 |
884636 | 884636 | 2020-12-31 | Upshur | West Virginia | 54097 | 922 | 4 |
881391 | 881391 | 2020-12-30 | Upshur | West Virginia | 54097 | 900 | 4 |
878146 | 878146 | 2020-12-29 | Upshur | West Virginia | 54097 | 870 | 4 |
874901 | 874901 | 2020-12-28 | Upshur | West Virginia | 54097 | 836 | 4 |
871656 | 871656 | 2020-12-27 | Upshur | West Virginia | 54097 | 827 | 4 |
868411 | 868411 | 2020-12-26 | Upshur | West Virginia | 54097 | 811 | 4 |
865166 | 865166 | 2020-12-25 | Upshur | West Virginia | 54097 | 805 | 4 |
861921 | 861921 | 2020-12-24 | Upshur | West Virginia | 54097 | 773 | 4 |
858676 | 858676 | 2020-12-23 | Upshur | West Virginia | 54097 | 756 | 4 |
855431 | 855431 | 2020-12-22 | Upshur | West Virginia | 54097 | 739 | 4 |
852186 | 852186 | 2020-12-21 | Upshur | West Virginia | 54097 | 710 | 4 |
848941 | 848941 | 2020-12-20 | Upshur | West Virginia | 54097 | 710 | 4 |
845696 | 845696 | 2020-12-19 | Upshur | West Virginia | 54097 | 699 | 4 |
842450 | 842450 | 2020-12-18 | Upshur | West Virginia | 54097 | 683 | 4 |
839205 | 839205 | 2020-12-17 | Upshur | West Virginia | 54097 | 675 | 4 |
835960 | 835960 | 2020-12-16 | Upshur | West Virginia | 54097 | 661 | 4 |
832714 | 832714 | 2020-12-15 | Upshur | West Virginia | 54097 | 644 | 4 |
829467 | 829467 | 2020-12-14 | Upshur | West Virginia | 54097 | 639 | 4 |
826221 | 826221 | 2020-12-13 | Upshur | West Virginia | 54097 | 623 | 4 |
822974 | 822974 | 2020-12-12 | Upshur | West Virginia | 54097 | 618 | 4 |
819728 | 819728 | 2020-12-11 | Upshur | West Virginia | 54097 | 605 | 4 |
816482 | 816482 | 2020-12-10 | Upshur | West Virginia | 54097 | 591 | 4 |
813236 | 813236 | 2020-12-09 | Upshur | West Virginia | 54097 | 587 | 4 |
809992 | 809992 | 2020-12-08 | Upshur | West Virginia | 54097 | 579 | 4 |
806747 | 806747 | 2020-12-07 | Upshur | West Virginia | 54097 | 573 | 4 |
803502 | 803502 | 2020-12-06 | Upshur | West Virginia | 54097 | 567 | 4 |
800257 | 800257 | 2020-12-05 | Upshur | West Virginia | 54097 | 561 | 4 |
797012 | 797012 | 2020-12-04 | Upshur | West Virginia | 54097 | 551 | 4 |
793767 | 793767 | 2020-12-03 | Upshur | West Virginia | 54097 | 534 | 4 |
790522 | 790522 | 2020-12-02 | Upshur | West Virginia | 54097 | 527 | 4 |
787277 | 787277 | 2020-12-01 | Upshur | West Virginia | 54097 | 523 | 4 |
784033 | 784033 | 2020-11-30 | Upshur | West Virginia | 54097 | 514 | 4 |
780788 | 780788 | 2020-11-29 | Upshur | West Virginia | 54097 | 508 | 4 |
777542 | 777542 | 2020-11-28 | Upshur | West Virginia | 54097 | 494 | 4 |
774297 | 774297 | 2020-11-27 | Upshur | West Virginia | 54097 | 477 | 4 |
771052 | 771052 | 2020-11-26 | Upshur | West Virginia | 54097 | 471 | 4 |
767806 | 767806 | 2020-11-25 | Upshur | West Virginia | 54097 | 462 | 4 |
764561 | 764561 | 2020-11-24 | Upshur | West Virginia | 54097 | 454 | 4 |
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);