ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Hardy" 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 |
---|---|---|---|---|---|---|---|
933284 | 933284 | 2021-01-15 | Hardy | West Virginia | 54031 | 1048 | 12 |
930039 | 930039 | 2021-01-14 | Hardy | West Virginia | 54031 | 1017 | 12 |
926794 | 926794 | 2021-01-13 | Hardy | West Virginia | 54031 | 1015 | 12 |
923548 | 923548 | 2021-01-12 | Hardy | West Virginia | 54031 | 1011 | 11 |
920303 | 920303 | 2021-01-11 | Hardy | West Virginia | 54031 | 995 | 11 |
917058 | 917058 | 2021-01-10 | Hardy | West Virginia | 54031 | 986 | 11 |
913813 | 913813 | 2021-01-09 | Hardy | West Virginia | 54031 | 921 | 10 |
910568 | 910568 | 2021-01-08 | Hardy | West Virginia | 54031 | 903 | 10 |
907323 | 907323 | 2021-01-07 | Hardy | West Virginia | 54031 | 882 | 10 |
904077 | 904077 | 2021-01-06 | Hardy | West Virginia | 54031 | 875 | 9 |
900832 | 900832 | 2021-01-05 | Hardy | West Virginia | 54031 | 845 | 8 |
897587 | 897587 | 2021-01-04 | Hardy | West Virginia | 54031 | 834 | 8 |
894341 | 894341 | 2021-01-03 | Hardy | West Virginia | 54031 | 826 | 8 |
891095 | 891095 | 2021-01-02 | Hardy | West Virginia | 54031 | 809 | 8 |
887848 | 887848 | 2021-01-01 | Hardy | West Virginia | 54031 | 799 | 8 |
884603 | 884603 | 2020-12-31 | Hardy | West Virginia | 54031 | 775 | 7 |
881358 | 881358 | 2020-12-30 | Hardy | West Virginia | 54031 | 761 | 7 |
878113 | 878113 | 2020-12-29 | Hardy | West Virginia | 54031 | 751 | 6 |
874868 | 874868 | 2020-12-28 | Hardy | West Virginia | 54031 | 734 | 6 |
871623 | 871623 | 2020-12-27 | Hardy | West Virginia | 54031 | 726 | 6 |
868378 | 868378 | 2020-12-26 | Hardy | West Virginia | 54031 | 711 | 6 |
865133 | 865133 | 2020-12-25 | Hardy | West Virginia | 54031 | 699 | 6 |
861888 | 861888 | 2020-12-24 | Hardy | West Virginia | 54031 | 689 | 6 |
858643 | 858643 | 2020-12-23 | Hardy | West Virginia | 54031 | 677 | 6 |
855398 | 855398 | 2020-12-22 | Hardy | West Virginia | 54031 | 661 | 6 |
852153 | 852153 | 2020-12-21 | Hardy | West Virginia | 54031 | 635 | 6 |
848908 | 848908 | 2020-12-20 | Hardy | West Virginia | 54031 | 622 | 6 |
845663 | 845663 | 2020-12-19 | Hardy | West Virginia | 54031 | 614 | 6 |
842417 | 842417 | 2020-12-18 | Hardy | West Virginia | 54031 | 585 | 6 |
839172 | 839172 | 2020-12-17 | Hardy | West Virginia | 54031 | 578 | 6 |
835927 | 835927 | 2020-12-16 | Hardy | West Virginia | 54031 | 553 | 5 |
832681 | 832681 | 2020-12-15 | Hardy | West Virginia | 54031 | 548 | 4 |
829434 | 829434 | 2020-12-14 | Hardy | West Virginia | 54031 | 524 | 2 |
826188 | 826188 | 2020-12-13 | Hardy | West Virginia | 54031 | 503 | 2 |
822941 | 822941 | 2020-12-12 | Hardy | West Virginia | 54031 | 493 | 2 |
819695 | 819695 | 2020-12-11 | Hardy | West Virginia | 54031 | 471 | 2 |
816449 | 816449 | 2020-12-10 | Hardy | West Virginia | 54031 | 456 | 2 |
813203 | 813203 | 2020-12-09 | Hardy | West Virginia | 54031 | 441 | 2 |
809959 | 809959 | 2020-12-08 | Hardy | West Virginia | 54031 | 420 | 1 |
806714 | 806714 | 2020-12-07 | Hardy | West Virginia | 54031 | 399 | 1 |
803469 | 803469 | 2020-12-06 | Hardy | West Virginia | 54031 | 388 | 1 |
800224 | 800224 | 2020-12-05 | Hardy | West Virginia | 54031 | 377 | 1 |
796979 | 796979 | 2020-12-04 | Hardy | West Virginia | 54031 | 347 | 1 |
793734 | 793734 | 2020-12-03 | Hardy | West Virginia | 54031 | 339 | 1 |
790489 | 790489 | 2020-12-02 | Hardy | West Virginia | 54031 | 300 | 1 |
787244 | 787244 | 2020-12-01 | Hardy | West Virginia | 54031 | 295 | 1 |
784000 | 784000 | 2020-11-30 | Hardy | West Virginia | 54031 | 282 | 1 |
780755 | 780755 | 2020-11-29 | Hardy | West Virginia | 54031 | 276 | 1 |
777509 | 777509 | 2020-11-28 | Hardy | West Virginia | 54031 | 258 | 1 |
774264 | 774264 | 2020-11-27 | Hardy | West Virginia | 54031 | 250 | 1 |
771019 | 771019 | 2020-11-26 | Hardy | West Virginia | 54031 | 240 | 1 |
767773 | 767773 | 2020-11-25 | Hardy | West Virginia | 54031 | 227 | 1 |
764528 | 764528 | 2020-11-24 | Hardy | West Virginia | 54031 | 212 | 1 |
761283 | 761283 | 2020-11-23 | Hardy | West Virginia | 54031 | 203 | 1 |
758038 | 758038 | 2020-11-22 | Hardy | West Virginia | 54031 | 202 | 1 |
754791 | 754791 | 2020-11-21 | Hardy | West Virginia | 54031 | 192 | 1 |
751545 | 751545 | 2020-11-20 | Hardy | West Virginia | 54031 | 181 | 1 |
748299 | 748299 | 2020-11-19 | Hardy | West Virginia | 54031 | 177 | 1 |
745053 | 745053 | 2020-11-18 | Hardy | West Virginia | 54031 | 170 | 1 |
741806 | 741806 | 2020-11-17 | Hardy | West Virginia | 54031 | 168 | 1 |
738559 | 738559 | 2020-11-16 | Hardy | West Virginia | 54031 | 157 | 1 |
735315 | 735315 | 2020-11-15 | Hardy | West Virginia | 54031 | 150 | 1 |
732069 | 732069 | 2020-11-14 | Hardy | West Virginia | 54031 | 144 | 1 |
728824 | 728824 | 2020-11-13 | Hardy | West Virginia | 54031 | 140 | 1 |
725581 | 725581 | 2020-11-12 | Hardy | West Virginia | 54031 | 136 | 1 |
722338 | 722338 | 2020-11-11 | Hardy | West Virginia | 54031 | 136 | 1 |
719095 | 719095 | 2020-11-10 | Hardy | West Virginia | 54031 | 125 | 1 |
715852 | 715852 | 2020-11-09 | Hardy | West Virginia | 54031 | 120 | 1 |
712608 | 712608 | 2020-11-08 | Hardy | West Virginia | 54031 | 119 | 1 |
709364 | 709364 | 2020-11-07 | Hardy | West Virginia | 54031 | 117 | 1 |
706120 | 706120 | 2020-11-06 | Hardy | West Virginia | 54031 | 114 | 1 |
702877 | 702877 | 2020-11-05 | Hardy | West Virginia | 54031 | 113 | 1 |
699634 | 699634 | 2020-11-04 | Hardy | West Virginia | 54031 | 110 | 1 |
696390 | 696390 | 2020-11-03 | Hardy | West Virginia | 54031 | 110 | 1 |
693148 | 693148 | 2020-11-02 | Hardy | West Virginia | 54031 | 109 | 1 |
689904 | 689904 | 2020-11-01 | Hardy | West Virginia | 54031 | 108 | 1 |
686659 | 686659 | 2020-10-31 | Hardy | West Virginia | 54031 | 108 | 1 |
683416 | 683416 | 2020-10-30 | Hardy | West Virginia | 54031 | 107 | 1 |
680173 | 680173 | 2020-10-29 | Hardy | West Virginia | 54031 | 107 | 1 |
676930 | 676930 | 2020-10-28 | Hardy | West Virginia | 54031 | 107 | 1 |
673687 | 673687 | 2020-10-27 | Hardy | West Virginia | 54031 | 106 | 1 |
670445 | 670445 | 2020-10-26 | Hardy | West Virginia | 54031 | 105 | 1 |
667202 | 667202 | 2020-10-25 | Hardy | West Virginia | 54031 | 103 | 1 |
663957 | 663957 | 2020-10-24 | Hardy | West Virginia | 54031 | 103 | 1 |
660713 | 660713 | 2020-10-23 | Hardy | West Virginia | 54031 | 102 | 1 |
657469 | 657469 | 2020-10-22 | Hardy | West Virginia | 54031 | 102 | 1 |
654224 | 654224 | 2020-10-21 | Hardy | West Virginia | 54031 | 102 | 1 |
650979 | 650979 | 2020-10-20 | Hardy | West Virginia | 54031 | 102 | 1 |
647735 | 647735 | 2020-10-19 | Hardy | West Virginia | 54031 | 101 | 1 |
644489 | 644489 | 2020-10-18 | Hardy | West Virginia | 54031 | 101 | 1 |
641241 | 641241 | 2020-10-17 | Hardy | West Virginia | 54031 | 101 | 1 |
637994 | 637994 | 2020-10-16 | Hardy | West Virginia | 54031 | 101 | 1 |
634749 | 634749 | 2020-10-15 | Hardy | West Virginia | 54031 | 100 | 1 |
631504 | 631504 | 2020-10-14 | Hardy | West Virginia | 54031 | 99 | 1 |
628260 | 628260 | 2020-10-13 | Hardy | West Virginia | 54031 | 98 | 1 |
625017 | 625017 | 2020-10-12 | Hardy | West Virginia | 54031 | 98 | 1 |
621774 | 621774 | 2020-10-11 | Hardy | West Virginia | 54031 | 99 | 1 |
618531 | 618531 | 2020-10-10 | Hardy | West Virginia | 54031 | 98 | 1 |
615289 | 615289 | 2020-10-09 | Hardy | West Virginia | 54031 | 98 | 1 |
612048 | 612048 | 2020-10-08 | Hardy | West Virginia | 54031 | 95 | 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);