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 |
---|---|---|---|---|---|---|---|
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 |
761316 | 761316 | 2020-11-23 | Upshur | West Virginia | 54097 | 444 | 4 |
758071 | 758071 | 2020-11-22 | Upshur | West Virginia | 54097 | 437 | 4 |
754824 | 754824 | 2020-11-21 | Upshur | West Virginia | 54097 | 422 | 4 |
751578 | 751578 | 2020-11-20 | Upshur | West Virginia | 54097 | 410 | 4 |
748332 | 748332 | 2020-11-19 | Upshur | West Virginia | 54097 | 397 | 4 |
745086 | 745086 | 2020-11-18 | Upshur | West Virginia | 54097 | 386 | 4 |
741839 | 741839 | 2020-11-17 | Upshur | West Virginia | 54097 | 372 | 4 |
738592 | 738592 | 2020-11-16 | Upshur | West Virginia | 54097 | 361 | 4 |
735348 | 735348 | 2020-11-15 | Upshur | West Virginia | 54097 | 359 | 4 |
732102 | 732102 | 2020-11-14 | Upshur | West Virginia | 54097 | 350 | 4 |
728857 | 728857 | 2020-11-13 | Upshur | West Virginia | 54097 | 345 | 4 |
725614 | 725614 | 2020-11-12 | Upshur | West Virginia | 54097 | 336 | 4 |
722371 | 722371 | 2020-11-11 | Upshur | West Virginia | 54097 | 330 | 4 |
719128 | 719128 | 2020-11-10 | Upshur | West Virginia | 54097 | 314 | 4 |
715885 | 715885 | 2020-11-09 | Upshur | West Virginia | 54097 | 311 | 4 |
712641 | 712641 | 2020-11-08 | Upshur | West Virginia | 54097 | 310 | 4 |
709397 | 709397 | 2020-11-07 | Upshur | West Virginia | 54097 | 300 | 4 |
706153 | 706153 | 2020-11-06 | Upshur | West Virginia | 54097 | 295 | 4 |
702910 | 702910 | 2020-11-05 | Upshur | West Virginia | 54097 | 293 | 4 |
699667 | 699667 | 2020-11-04 | Upshur | West Virginia | 54097 | 293 | 4 |
696423 | 696423 | 2020-11-03 | Upshur | West Virginia | 54097 | 284 | 4 |
693181 | 693181 | 2020-11-02 | Upshur | West Virginia | 54097 | 279 | 4 |
689937 | 689937 | 2020-11-01 | Upshur | West Virginia | 54097 | 277 | 4 |
686692 | 686692 | 2020-10-31 | Upshur | West Virginia | 54097 | 276 | 4 |
683449 | 683449 | 2020-10-30 | Upshur | West Virginia | 54097 | 268 | 4 |
680206 | 680206 | 2020-10-29 | Upshur | West Virginia | 54097 | 265 | 4 |
676963 | 676963 | 2020-10-28 | Upshur | West Virginia | 54097 | 263 | 4 |
673720 | 673720 | 2020-10-27 | Upshur | West Virginia | 54097 | 257 | 3 |
670478 | 670478 | 2020-10-26 | Upshur | West Virginia | 54097 | 243 | 2 |
667235 | 667235 | 2020-10-25 | Upshur | West Virginia | 54097 | 238 | 2 |
663990 | 663990 | 2020-10-24 | Upshur | West Virginia | 54097 | 238 | 2 |
660746 | 660746 | 2020-10-23 | Upshur | West Virginia | 54097 | 234 | 2 |
657502 | 657502 | 2020-10-22 | Upshur | West Virginia | 54097 | 233 | 2 |
654257 | 654257 | 2020-10-21 | Upshur | West Virginia | 54097 | 228 | 1 |
651012 | 651012 | 2020-10-20 | Upshur | West Virginia | 54097 | 226 | 0 |
647768 | 647768 | 2020-10-19 | Upshur | West Virginia | 54097 | 225 | 0 |
644522 | 644522 | 2020-10-18 | Upshur | West Virginia | 54097 | 222 | 0 |
641274 | 641274 | 2020-10-17 | Upshur | West Virginia | 54097 | 216 | 0 |
638027 | 638027 | 2020-10-16 | Upshur | West Virginia | 54097 | 210 | 0 |
634782 | 634782 | 2020-10-15 | Upshur | West Virginia | 54097 | 203 | 0 |
631537 | 631537 | 2020-10-14 | Upshur | West Virginia | 54097 | 191 | 0 |
628293 | 628293 | 2020-10-13 | Upshur | West Virginia | 54097 | 182 | 0 |
625050 | 625050 | 2020-10-12 | Upshur | West Virginia | 54097 | 183 | 0 |
621807 | 621807 | 2020-10-11 | Upshur | West Virginia | 54097 | 179 | 0 |
618564 | 618564 | 2020-10-10 | Upshur | West Virginia | 54097 | 175 | 0 |
615322 | 615322 | 2020-10-09 | Upshur | West Virginia | 54097 | 168 | 0 |
612081 | 612081 | 2020-10-08 | Upshur | West Virginia | 54097 | 150 | 0 |
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);