ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 54033 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 |
---|---|---|---|---|---|---|---|
923549 | 923549 | 2021-01-12 | Harrison | West Virginia | 54033 | 3742 | 39 |
920304 | 920304 | 2021-01-11 | Harrison | West Virginia | 54033 | 3681 | 38 |
917059 | 917059 | 2021-01-10 | Harrison | West Virginia | 54033 | 3655 | 38 |
913814 | 913814 | 2021-01-09 | Harrison | West Virginia | 54033 | 3587 | 37 |
910569 | 910569 | 2021-01-08 | Harrison | West Virginia | 54033 | 3513 | 37 |
907324 | 907324 | 2021-01-07 | Harrison | West Virginia | 54033 | 3438 | 36 |
904078 | 904078 | 2021-01-06 | Harrison | West Virginia | 54033 | 3348 | 36 |
900833 | 900833 | 2021-01-05 | Harrison | West Virginia | 54033 | 3275 | 35 |
897588 | 897588 | 2021-01-04 | Harrison | West Virginia | 54033 | 3195 | 34 |
894342 | 894342 | 2021-01-03 | Harrison | West Virginia | 54033 | 3152 | 33 |
891096 | 891096 | 2021-01-02 | Harrison | West Virginia | 54033 | 3098 | 33 |
887849 | 887849 | 2021-01-01 | Harrison | West Virginia | 54033 | 3042 | 33 |
884604 | 884604 | 2020-12-31 | Harrison | West Virginia | 54033 | 2949 | 33 |
881359 | 881359 | 2020-12-30 | Harrison | West Virginia | 54033 | 2898 | 32 |
878114 | 878114 | 2020-12-29 | Harrison | West Virginia | 54033 | 2844 | 32 |
874869 | 874869 | 2020-12-28 | Harrison | West Virginia | 54033 | 2786 | 31 |
871624 | 871624 | 2020-12-27 | Harrison | West Virginia | 54033 | 2746 | 31 |
868379 | 868379 | 2020-12-26 | Harrison | West Virginia | 54033 | 2715 | 31 |
865134 | 865134 | 2020-12-25 | Harrison | West Virginia | 54033 | 2666 | 31 |
861889 | 861889 | 2020-12-24 | Harrison | West Virginia | 54033 | 2614 | 31 |
858644 | 858644 | 2020-12-23 | Harrison | West Virginia | 54033 | 2545 | 31 |
855399 | 855399 | 2020-12-22 | Harrison | West Virginia | 54033 | 2478 | 31 |
852154 | 852154 | 2020-12-21 | Harrison | West Virginia | 54033 | 2422 | 30 |
848909 | 848909 | 2020-12-20 | Harrison | West Virginia | 54033 | 2377 | 30 |
845664 | 845664 | 2020-12-19 | Harrison | West Virginia | 54033 | 2323 | 29 |
842418 | 842418 | 2020-12-18 | Harrison | West Virginia | 54033 | 2269 | 29 |
839173 | 839173 | 2020-12-17 | Harrison | West Virginia | 54033 | 2205 | 29 |
835928 | 835928 | 2020-12-16 | Harrison | West Virginia | 54033 | 2123 | 27 |
832682 | 832682 | 2020-12-15 | Harrison | West Virginia | 54033 | 2076 | 26 |
829435 | 829435 | 2020-12-14 | Harrison | West Virginia | 54033 | 2012 | 25 |
826189 | 826189 | 2020-12-13 | Harrison | West Virginia | 54033 | 1957 | 25 |
822942 | 822942 | 2020-12-12 | Harrison | West Virginia | 54033 | 1920 | 25 |
819696 | 819696 | 2020-12-11 | Harrison | West Virginia | 54033 | 1871 | 25 |
816450 | 816450 | 2020-12-10 | Harrison | West Virginia | 54033 | 1835 | 25 |
813204 | 813204 | 2020-12-09 | Harrison | West Virginia | 54033 | 1794 | 25 |
809960 | 809960 | 2020-12-08 | Harrison | West Virginia | 54033 | 1747 | 25 |
806715 | 806715 | 2020-12-07 | Harrison | West Virginia | 54033 | 1726 | 24 |
803470 | 803470 | 2020-12-06 | Harrison | West Virginia | 54033 | 1682 | 24 |
800225 | 800225 | 2020-12-05 | Harrison | West Virginia | 54033 | 1623 | 24 |
796980 | 796980 | 2020-12-04 | Harrison | West Virginia | 54033 | 1581 | 24 |
793735 | 793735 | 2020-12-03 | Harrison | West Virginia | 54033 | 1563 | 24 |
790490 | 790490 | 2020-12-02 | Harrison | West Virginia | 54033 | 1527 | 24 |
787245 | 787245 | 2020-12-01 | Harrison | West Virginia | 54033 | 1463 | 24 |
784001 | 784001 | 2020-11-30 | Harrison | West Virginia | 54033 | 1417 | 21 |
780756 | 780756 | 2020-11-29 | Harrison | West Virginia | 54033 | 1387 | 21 |
777510 | 777510 | 2020-11-28 | Harrison | West Virginia | 54033 | 1320 | 20 |
774265 | 774265 | 2020-11-27 | Harrison | West Virginia | 54033 | 1279 | 19 |
771020 | 771020 | 2020-11-26 | Harrison | West Virginia | 54033 | 1259 | 19 |
767774 | 767774 | 2020-11-25 | Harrison | West Virginia | 54033 | 1200 | 19 |
764529 | 764529 | 2020-11-24 | Harrison | West Virginia | 54033 | 1156 | 18 |
761284 | 761284 | 2020-11-23 | Harrison | West Virginia | 54033 | 1096 | 17 |
758039 | 758039 | 2020-11-22 | Harrison | West Virginia | 54033 | 1081 | 18 |
754792 | 754792 | 2020-11-21 | Harrison | West Virginia | 54033 | 1052 | 18 |
751546 | 751546 | 2020-11-20 | Harrison | West Virginia | 54033 | 1019 | 15 |
748300 | 748300 | 2020-11-19 | Harrison | West Virginia | 54033 | 977 | 15 |
745054 | 745054 | 2020-11-18 | Harrison | West Virginia | 54033 | 919 | 15 |
741807 | 741807 | 2020-11-17 | Harrison | West Virginia | 54033 | 905 | 14 |
738560 | 738560 | 2020-11-16 | Harrison | West Virginia | 54033 | 878 | 14 |
735316 | 735316 | 2020-11-15 | Harrison | West Virginia | 54033 | 872 | 14 |
732070 | 732070 | 2020-11-14 | Harrison | West Virginia | 54033 | 853 | 14 |
728825 | 728825 | 2020-11-13 | Harrison | West Virginia | 54033 | 828 | 14 |
725582 | 725582 | 2020-11-12 | Harrison | West Virginia | 54033 | 816 | 14 |
722339 | 722339 | 2020-11-11 | Harrison | West Virginia | 54033 | 811 | 14 |
719096 | 719096 | 2020-11-10 | Harrison | West Virginia | 54033 | 786 | 14 |
715853 | 715853 | 2020-11-09 | Harrison | West Virginia | 54033 | 763 | 14 |
712609 | 712609 | 2020-11-08 | Harrison | West Virginia | 54033 | 757 | 13 |
709365 | 709365 | 2020-11-07 | Harrison | West Virginia | 54033 | 731 | 13 |
706121 | 706121 | 2020-11-06 | Harrison | West Virginia | 54033 | 718 | 13 |
702878 | 702878 | 2020-11-05 | Harrison | West Virginia | 54033 | 711 | 13 |
699635 | 699635 | 2020-11-04 | Harrison | West Virginia | 54033 | 700 | 13 |
696391 | 696391 | 2020-11-03 | Harrison | West Virginia | 54033 | 691 | 13 |
693149 | 693149 | 2020-11-02 | Harrison | West Virginia | 54033 | 688 | 12 |
689905 | 689905 | 2020-11-01 | Harrison | West Virginia | 54033 | 682 | 12 |
686660 | 686660 | 2020-10-31 | Harrison | West Virginia | 54033 | 680 | 12 |
683417 | 683417 | 2020-10-30 | Harrison | West Virginia | 54033 | 673 | 12 |
680174 | 680174 | 2020-10-29 | Harrison | West Virginia | 54033 | 660 | 12 |
676931 | 676931 | 2020-10-28 | Harrison | West Virginia | 54033 | 649 | 12 |
673688 | 673688 | 2020-10-27 | Harrison | West Virginia | 54033 | 648 | 12 |
670446 | 670446 | 2020-10-26 | Harrison | West Virginia | 54033 | 644 | 12 |
667203 | 667203 | 2020-10-25 | Harrison | West Virginia | 54033 | 638 | 12 |
663958 | 663958 | 2020-10-24 | Harrison | West Virginia | 54033 | 634 | 12 |
660714 | 660714 | 2020-10-23 | Harrison | West Virginia | 54033 | 632 | 12 |
657470 | 657470 | 2020-10-22 | Harrison | West Virginia | 54033 | 629 | 12 |
654225 | 654225 | 2020-10-21 | Harrison | West Virginia | 54033 | 624 | 12 |
650980 | 650980 | 2020-10-20 | Harrison | West Virginia | 54033 | 624 | 11 |
647736 | 647736 | 2020-10-19 | Harrison | West Virginia | 54033 | 625 | 10 |
644490 | 644490 | 2020-10-18 | Harrison | West Virginia | 54033 | 623 | 10 |
641242 | 641242 | 2020-10-17 | Harrison | West Virginia | 54033 | 619 | 10 |
637995 | 637995 | 2020-10-16 | Harrison | West Virginia | 54033 | 616 | 10 |
634750 | 634750 | 2020-10-15 | Harrison | West Virginia | 54033 | 588 | 10 |
631505 | 631505 | 2020-10-14 | Harrison | West Virginia | 54033 | 573 | 10 |
628261 | 628261 | 2020-10-13 | Harrison | West Virginia | 54033 | 564 | 10 |
625018 | 625018 | 2020-10-12 | Harrison | West Virginia | 54033 | 552 | 10 |
621775 | 621775 | 2020-10-11 | Harrison | West Virginia | 54033 | 528 | 10 |
618532 | 618532 | 2020-10-10 | Harrison | West Virginia | 54033 | 510 | 10 |
615290 | 615290 | 2020-10-09 | Harrison | West Virginia | 54033 | 498 | 10 |
612049 | 612049 | 2020-10-08 | Harrison | West Virginia | 54033 | 486 | 10 |
608807 | 608807 | 2020-10-07 | Harrison | West Virginia | 54033 | 473 | 10 |
605564 | 605564 | 2020-10-06 | Harrison | West Virginia | 54033 | 464 | 9 |
602322 | 602322 | 2020-10-05 | Harrison | West Virginia | 54033 | 451 | 9 |
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);