ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Pendleton" 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 |
---|---|---|---|---|---|---|---|
933304 | 933304 | 2021-01-15 | Pendleton | West Virginia | 54071 | 430 | 3 |
930059 | 930059 | 2021-01-14 | Pendleton | West Virginia | 54071 | 418 | 3 |
926814 | 926814 | 2021-01-13 | Pendleton | West Virginia | 54071 | 413 | 3 |
923568 | 923568 | 2021-01-12 | Pendleton | West Virginia | 54071 | 410 | 2 |
920323 | 920323 | 2021-01-11 | Pendleton | West Virginia | 54071 | 405 | 2 |
917078 | 917078 | 2021-01-10 | Pendleton | West Virginia | 54071 | 392 | 2 |
913833 | 913833 | 2021-01-09 | Pendleton | West Virginia | 54071 | 388 | 2 |
910588 | 910588 | 2021-01-08 | Pendleton | West Virginia | 54071 | 384 | 2 |
907343 | 907343 | 2021-01-07 | Pendleton | West Virginia | 54071 | 365 | 2 |
904097 | 904097 | 2021-01-06 | Pendleton | West Virginia | 54071 | 351 | 2 |
900852 | 900852 | 2021-01-05 | Pendleton | West Virginia | 54071 | 344 | 2 |
897607 | 897607 | 2021-01-04 | Pendleton | West Virginia | 54071 | 331 | 2 |
894361 | 894361 | 2021-01-03 | Pendleton | West Virginia | 54071 | 328 | 2 |
891115 | 891115 | 2021-01-02 | Pendleton | West Virginia | 54071 | 318 | 2 |
887868 | 887868 | 2021-01-01 | Pendleton | West Virginia | 54071 | 313 | 2 |
884623 | 884623 | 2020-12-31 | Pendleton | West Virginia | 54071 | 293 | 2 |
881378 | 881378 | 2020-12-30 | Pendleton | West Virginia | 54071 | 284 | 2 |
878133 | 878133 | 2020-12-29 | Pendleton | West Virginia | 54071 | 283 | 2 |
874888 | 874888 | 2020-12-28 | Pendleton | West Virginia | 54071 | 276 | 1 |
871643 | 871643 | 2020-12-27 | Pendleton | West Virginia | 54071 | 274 | 1 |
868398 | 868398 | 2020-12-26 | Pendleton | West Virginia | 54071 | 268 | 1 |
865153 | 865153 | 2020-12-25 | Pendleton | West Virginia | 54071 | 262 | 1 |
861908 | 861908 | 2020-12-24 | Pendleton | West Virginia | 54071 | 253 | 1 |
858663 | 858663 | 2020-12-23 | Pendleton | West Virginia | 54071 | 241 | 1 |
855418 | 855418 | 2020-12-22 | Pendleton | West Virginia | 54071 | 235 | 1 |
852173 | 852173 | 2020-12-21 | Pendleton | West Virginia | 54071 | 225 | 1 |
848928 | 848928 | 2020-12-20 | Pendleton | West Virginia | 54071 | 221 | 1 |
845683 | 845683 | 2020-12-19 | Pendleton | West Virginia | 54071 | 214 | 1 |
842437 | 842437 | 2020-12-18 | Pendleton | West Virginia | 54071 | 209 | 1 |
839192 | 839192 | 2020-12-17 | Pendleton | West Virginia | 54071 | 202 | 1 |
835947 | 835947 | 2020-12-16 | Pendleton | West Virginia | 54071 | 193 | 1 |
832701 | 832701 | 2020-12-15 | Pendleton | West Virginia | 54071 | 188 | 1 |
829454 | 829454 | 2020-12-14 | Pendleton | West Virginia | 54071 | 182 | 1 |
826208 | 826208 | 2020-12-13 | Pendleton | West Virginia | 54071 | 173 | 1 |
822961 | 822961 | 2020-12-12 | Pendleton | West Virginia | 54071 | 165 | 1 |
819715 | 819715 | 2020-12-11 | Pendleton | West Virginia | 54071 | 161 | 1 |
816469 | 816469 | 2020-12-10 | Pendleton | West Virginia | 54071 | 153 | 1 |
813223 | 813223 | 2020-12-09 | Pendleton | West Virginia | 54071 | 147 | 1 |
809979 | 809979 | 2020-12-08 | Pendleton | West Virginia | 54071 | 139 | 1 |
806734 | 806734 | 2020-12-07 | Pendleton | West Virginia | 54071 | 137 | 1 |
803489 | 803489 | 2020-12-06 | Pendleton | West Virginia | 54071 | 130 | 1 |
800244 | 800244 | 2020-12-05 | Pendleton | West Virginia | 54071 | 125 | 1 |
796999 | 796999 | 2020-12-04 | Pendleton | West Virginia | 54071 | 121 | 1 |
793754 | 793754 | 2020-12-03 | Pendleton | West Virginia | 54071 | 115 | 1 |
790509 | 790509 | 2020-12-02 | Pendleton | West Virginia | 54071 | 111 | 1 |
787264 | 787264 | 2020-12-01 | Pendleton | West Virginia | 54071 | 109 | 1 |
784020 | 784020 | 2020-11-30 | Pendleton | West Virginia | 54071 | 105 | 1 |
780775 | 780775 | 2020-11-29 | Pendleton | West Virginia | 54071 | 104 | 1 |
777529 | 777529 | 2020-11-28 | Pendleton | West Virginia | 54071 | 103 | 1 |
774284 | 774284 | 2020-11-27 | Pendleton | West Virginia | 54071 | 103 | 1 |
771039 | 771039 | 2020-11-26 | Pendleton | West Virginia | 54071 | 102 | 1 |
767793 | 767793 | 2020-11-25 | Pendleton | West Virginia | 54071 | 101 | 1 |
764548 | 764548 | 2020-11-24 | Pendleton | West Virginia | 54071 | 100 | 1 |
761303 | 761303 | 2020-11-23 | Pendleton | West Virginia | 54071 | 97 | 1 |
758058 | 758058 | 2020-11-22 | Pendleton | West Virginia | 54071 | 96 | 1 |
754811 | 754811 | 2020-11-21 | Pendleton | West Virginia | 54071 | 93 | 1 |
751565 | 751565 | 2020-11-20 | Pendleton | West Virginia | 54071 | 90 | 1 |
748319 | 748319 | 2020-11-19 | Pendleton | West Virginia | 54071 | 88 | 1 |
745073 | 745073 | 2020-11-18 | Pendleton | West Virginia | 54071 | 88 | 1 |
741826 | 741826 | 2020-11-17 | Pendleton | West Virginia | 54071 | 86 | 1 |
738579 | 738579 | 2020-11-16 | Pendleton | West Virginia | 54071 | 86 | 1 |
735335 | 735335 | 2020-11-15 | Pendleton | West Virginia | 54071 | 84 | 1 |
732089 | 732089 | 2020-11-14 | Pendleton | West Virginia | 54071 | 83 | 1 |
728844 | 728844 | 2020-11-13 | Pendleton | West Virginia | 54071 | 80 | 1 |
725601 | 725601 | 2020-11-12 | Pendleton | West Virginia | 54071 | 80 | 1 |
722358 | 722358 | 2020-11-11 | Pendleton | West Virginia | 54071 | 80 | 1 |
719115 | 719115 | 2020-11-10 | Pendleton | West Virginia | 54071 | 80 | 1 |
715872 | 715872 | 2020-11-09 | Pendleton | West Virginia | 54071 | 80 | 1 |
712628 | 712628 | 2020-11-08 | Pendleton | West Virginia | 54071 | 80 | 1 |
709384 | 709384 | 2020-11-07 | Pendleton | West Virginia | 54071 | 79 | 1 |
706140 | 706140 | 2020-11-06 | Pendleton | West Virginia | 54071 | 79 | 1 |
702897 | 702897 | 2020-11-05 | Pendleton | West Virginia | 54071 | 79 | 1 |
699654 | 699654 | 2020-11-04 | Pendleton | West Virginia | 54071 | 79 | 1 |
696410 | 696410 | 2020-11-03 | Pendleton | West Virginia | 54071 | 79 | 1 |
693168 | 693168 | 2020-11-02 | Pendleton | West Virginia | 54071 | 79 | 1 |
689924 | 689924 | 2020-11-01 | Pendleton | West Virginia | 54071 | 79 | 1 |
686679 | 686679 | 2020-10-31 | Pendleton | West Virginia | 54071 | 77 | 1 |
683436 | 683436 | 2020-10-30 | Pendleton | West Virginia | 54071 | 77 | 1 |
680193 | 680193 | 2020-10-29 | Pendleton | West Virginia | 54071 | 77 | 1 |
676950 | 676950 | 2020-10-28 | Pendleton | West Virginia | 54071 | 76 | 1 |
673707 | 673707 | 2020-10-27 | Pendleton | West Virginia | 54071 | 74 | 1 |
670465 | 670465 | 2020-10-26 | Pendleton | West Virginia | 54071 | 74 | 1 |
667222 | 667222 | 2020-10-25 | Pendleton | West Virginia | 54071 | 74 | 1 |
663977 | 663977 | 2020-10-24 | Pendleton | West Virginia | 54071 | 74 | 1 |
660733 | 660733 | 2020-10-23 | Pendleton | West Virginia | 54071 | 75 | 1 |
657489 | 657489 | 2020-10-22 | Pendleton | West Virginia | 54071 | 73 | 1 |
654244 | 654244 | 2020-10-21 | Pendleton | West Virginia | 54071 | 73 | 1 |
650999 | 650999 | 2020-10-20 | Pendleton | West Virginia | 54071 | 72 | 1 |
647755 | 647755 | 2020-10-19 | Pendleton | West Virginia | 54071 | 70 | 1 |
644509 | 644509 | 2020-10-18 | Pendleton | West Virginia | 54071 | 68 | 1 |
641261 | 641261 | 2020-10-17 | Pendleton | West Virginia | 54071 | 65 | 1 |
638014 | 638014 | 2020-10-16 | Pendleton | West Virginia | 54071 | 65 | 1 |
634769 | 634769 | 2020-10-15 | Pendleton | West Virginia | 54071 | 63 | 1 |
631524 | 631524 | 2020-10-14 | Pendleton | West Virginia | 54071 | 62 | 1 |
628280 | 628280 | 2020-10-13 | Pendleton | West Virginia | 54071 | 59 | 1 |
625037 | 625037 | 2020-10-12 | Pendleton | West Virginia | 54071 | 57 | 1 |
621794 | 621794 | 2020-10-11 | Pendleton | West Virginia | 54071 | 57 | 1 |
618551 | 618551 | 2020-10-10 | Pendleton | West Virginia | 54071 | 56 | 1 |
615309 | 615309 | 2020-10-09 | Pendleton | West Virginia | 54071 | 55 | 1 |
612068 | 612068 | 2020-10-08 | Pendleton | West Virginia | 54071 | 54 | 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);