ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 54083 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 |
---|---|---|---|---|---|---|---|
923574 | 923574 | 2021-01-12 | Randolph | West Virginia | 54083 | 1589 | 8 |
920329 | 920329 | 2021-01-11 | Randolph | West Virginia | 54083 | 1565 | 6 |
917084 | 917084 | 2021-01-10 | Randolph | West Virginia | 54083 | 1516 | 6 |
913839 | 913839 | 2021-01-09 | Randolph | West Virginia | 54083 | 1393 | 6 |
910594 | 910594 | 2021-01-08 | Randolph | West Virginia | 54083 | 1365 | 6 |
907349 | 907349 | 2021-01-07 | Randolph | West Virginia | 54083 | 1328 | 6 |
904103 | 904103 | 2021-01-06 | Randolph | West Virginia | 54083 | 1313 | 6 |
900858 | 900858 | 2021-01-05 | Randolph | West Virginia | 54083 | 1263 | 6 |
897613 | 897613 | 2021-01-04 | Randolph | West Virginia | 54083 | 1233 | 6 |
894367 | 894367 | 2021-01-03 | Randolph | West Virginia | 54083 | 1224 | 6 |
891121 | 891121 | 2021-01-02 | Randolph | West Virginia | 54083 | 1211 | 6 |
887874 | 887874 | 2021-01-01 | Randolph | West Virginia | 54083 | 1205 | 6 |
884629 | 884629 | 2020-12-31 | Randolph | West Virginia | 54083 | 1138 | 6 |
881384 | 881384 | 2020-12-30 | Randolph | West Virginia | 54083 | 1131 | 6 |
878139 | 878139 | 2020-12-29 | Randolph | West Virginia | 54083 | 1104 | 6 |
874894 | 874894 | 2020-12-28 | Randolph | West Virginia | 54083 | 1054 | 6 |
871649 | 871649 | 2020-12-27 | Randolph | West Virginia | 54083 | 1059 | 6 |
868404 | 868404 | 2020-12-26 | Randolph | West Virginia | 54083 | 1060 | 6 |
865159 | 865159 | 2020-12-25 | Randolph | West Virginia | 54083 | 1055 | 6 |
861914 | 861914 | 2020-12-24 | Randolph | West Virginia | 54083 | 1035 | 6 |
858669 | 858669 | 2020-12-23 | Randolph | West Virginia | 54083 | 1028 | 5 |
855424 | 855424 | 2020-12-22 | Randolph | West Virginia | 54083 | 1007 | 4 |
852179 | 852179 | 2020-12-21 | Randolph | West Virginia | 54083 | 992 | 4 |
848934 | 848934 | 2020-12-20 | Randolph | West Virginia | 54083 | 983 | 4 |
845689 | 845689 | 2020-12-19 | Randolph | West Virginia | 54083 | 983 | 4 |
842443 | 842443 | 2020-12-18 | Randolph | West Virginia | 54083 | 977 | 4 |
839198 | 839198 | 2020-12-17 | Randolph | West Virginia | 54083 | 969 | 3 |
835953 | 835953 | 2020-12-16 | Randolph | West Virginia | 54083 | 947 | 3 |
832707 | 832707 | 2020-12-15 | Randolph | West Virginia | 54083 | 927 | 3 |
829460 | 829460 | 2020-12-14 | Randolph | West Virginia | 54083 | 905 | 3 |
826214 | 826214 | 2020-12-13 | Randolph | West Virginia | 54083 | 895 | 3 |
822967 | 822967 | 2020-12-12 | Randolph | West Virginia | 54083 | 892 | 3 |
819721 | 819721 | 2020-12-11 | Randolph | West Virginia | 54083 | 867 | 3 |
816475 | 816475 | 2020-12-10 | Randolph | West Virginia | 54083 | 852 | 3 |
813229 | 813229 | 2020-12-09 | Randolph | West Virginia | 54083 | 837 | 3 |
809985 | 809985 | 2020-12-08 | Randolph | West Virginia | 54083 | 808 | 3 |
806740 | 806740 | 2020-12-07 | Randolph | West Virginia | 54083 | 798 | 2 |
803495 | 803495 | 2020-12-06 | Randolph | West Virginia | 54083 | 785 | 2 |
800250 | 800250 | 2020-12-05 | Randolph | West Virginia | 54083 | 779 | 2 |
797005 | 797005 | 2020-12-04 | Randolph | West Virginia | 54083 | 777 | 2 |
793760 | 793760 | 2020-12-03 | Randolph | West Virginia | 54083 | 762 | 2 |
790515 | 790515 | 2020-12-02 | Randolph | West Virginia | 54083 | 751 | 2 |
787270 | 787270 | 2020-12-01 | Randolph | West Virginia | 54083 | 718 | 2 |
784026 | 784026 | 2020-11-30 | Randolph | West Virginia | 54083 | 693 | 2 |
780781 | 780781 | 2020-11-29 | Randolph | West Virginia | 54083 | 689 | 2 |
777535 | 777535 | 2020-11-28 | Randolph | West Virginia | 54083 | 682 | 2 |
774290 | 774290 | 2020-11-27 | Randolph | West Virginia | 54083 | 679 | 2 |
771045 | 771045 | 2020-11-26 | Randolph | West Virginia | 54083 | 677 | 2 |
767799 | 767799 | 2020-11-25 | Randolph | West Virginia | 54083 | 660 | 2 |
764554 | 764554 | 2020-11-24 | Randolph | West Virginia | 54083 | 646 | 2 |
761309 | 761309 | 2020-11-23 | Randolph | West Virginia | 54083 | 629 | 2 |
758064 | 758064 | 2020-11-22 | Randolph | West Virginia | 54083 | 622 | 2 |
754817 | 754817 | 2020-11-21 | Randolph | West Virginia | 54083 | 617 | 2 |
751571 | 751571 | 2020-11-20 | Randolph | West Virginia | 54083 | 599 | 2 |
748325 | 748325 | 2020-11-19 | Randolph | West Virginia | 54083 | 592 | 2 |
745079 | 745079 | 2020-11-18 | Randolph | West Virginia | 54083 | 584 | 2 |
741832 | 741832 | 2020-11-17 | Randolph | West Virginia | 54083 | 579 | 2 |
738585 | 738585 | 2020-11-16 | Randolph | West Virginia | 54083 | 556 | 2 |
735341 | 735341 | 2020-11-15 | Randolph | West Virginia | 54083 | 547 | 2 |
732095 | 732095 | 2020-11-14 | Randolph | West Virginia | 54083 | 535 | 2 |
728850 | 728850 | 2020-11-13 | Randolph | West Virginia | 54083 | 526 | 2 |
725607 | 725607 | 2020-11-12 | Randolph | West Virginia | 54083 | 515 | 2 |
722364 | 722364 | 2020-11-11 | Randolph | West Virginia | 54083 | 511 | 2 |
719121 | 719121 | 2020-11-10 | Randolph | West Virginia | 54083 | 500 | 2 |
715878 | 715878 | 2020-11-09 | Randolph | West Virginia | 54083 | 487 | 2 |
712634 | 712634 | 2020-11-08 | Randolph | West Virginia | 54083 | 480 | 2 |
709390 | 709390 | 2020-11-07 | Randolph | West Virginia | 54083 | 480 | 2 |
706146 | 706146 | 2020-11-06 | Randolph | West Virginia | 54083 | 460 | 2 |
702903 | 702903 | 2020-11-05 | Randolph | West Virginia | 54083 | 452 | 2 |
699660 | 699660 | 2020-11-04 | Randolph | West Virginia | 54083 | 449 | 2 |
696416 | 696416 | 2020-11-03 | Randolph | West Virginia | 54083 | 436 | 2 |
693174 | 693174 | 2020-11-02 | Randolph | West Virginia | 54083 | 431 | 1 |
689930 | 689930 | 2020-11-01 | Randolph | West Virginia | 54083 | 429 | 1 |
686685 | 686685 | 2020-10-31 | Randolph | West Virginia | 54083 | 425 | 1 |
683442 | 683442 | 2020-10-30 | Randolph | West Virginia | 54083 | 419 | 1 |
680199 | 680199 | 2020-10-29 | Randolph | West Virginia | 54083 | 419 | 1 |
676956 | 676956 | 2020-10-28 | Randolph | West Virginia | 54083 | 416 | 1 |
673713 | 673713 | 2020-10-27 | Randolph | West Virginia | 54083 | 412 | 1 |
670471 | 670471 | 2020-10-26 | Randolph | West Virginia | 54083 | 410 | 1 |
667228 | 667228 | 2020-10-25 | Randolph | West Virginia | 54083 | 408 | 1 |
663983 | 663983 | 2020-10-24 | Randolph | West Virginia | 54083 | 408 | 1 |
660739 | 660739 | 2020-10-23 | Randolph | West Virginia | 54083 | 399 | 1 |
657495 | 657495 | 2020-10-22 | Randolph | West Virginia | 54083 | 395 | 1 |
654250 | 654250 | 2020-10-21 | Randolph | West Virginia | 54083 | 389 | 1 |
651005 | 651005 | 2020-10-20 | Randolph | West Virginia | 54083 | 380 | 1 |
647761 | 647761 | 2020-10-19 | Randolph | West Virginia | 54083 | 378 | 1 |
644515 | 644515 | 2020-10-18 | Randolph | West Virginia | 54083 | 375 | 1 |
641267 | 641267 | 2020-10-17 | Randolph | West Virginia | 54083 | 372 | 1 |
638020 | 638020 | 2020-10-16 | Randolph | West Virginia | 54083 | 368 | 1 |
634775 | 634775 | 2020-10-15 | Randolph | West Virginia | 54083 | 360 | 1 |
631530 | 631530 | 2020-10-14 | Randolph | West Virginia | 54083 | 351 | 1 |
628286 | 628286 | 2020-10-13 | Randolph | West Virginia | 54083 | 338 | 1 |
625043 | 625043 | 2020-10-12 | Randolph | West Virginia | 54083 | 323 | 1 |
621800 | 621800 | 2020-10-11 | Randolph | West Virginia | 54083 | 321 | 1 |
618557 | 618557 | 2020-10-10 | Randolph | West Virginia | 54083 | 312 | 1 |
615315 | 615315 | 2020-10-09 | Randolph | West Virginia | 54083 | 303 | 1 |
612074 | 612074 | 2020-10-08 | Randolph | West Virginia | 54083 | 284 | 1 |
608832 | 608832 | 2020-10-07 | Randolph | West Virginia | 54083 | 281 | 1 |
605589 | 605589 | 2020-10-06 | Randolph | West Virginia | 54083 | 280 | 1 |
602347 | 602347 | 2020-10-05 | Randolph | West Virginia | 54083 | 270 | 1 |
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);