ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Pleasants" 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 |
---|---|---|---|---|---|---|---|
933305 | 933305 | 2021-01-15 | Pleasants | West Virginia | 54073 | 704 | 11 |
930060 | 930060 | 2021-01-14 | Pleasants | West Virginia | 54073 | 701 | 9 |
926815 | 926815 | 2021-01-13 | Pleasants | West Virginia | 54073 | 698 | 9 |
923569 | 923569 | 2021-01-12 | Pleasants | West Virginia | 54073 | 692 | 7 |
920324 | 920324 | 2021-01-11 | Pleasants | West Virginia | 54073 | 690 | 6 |
917079 | 917079 | 2021-01-10 | Pleasants | West Virginia | 54073 | 689 | 6 |
913834 | 913834 | 2021-01-09 | Pleasants | West Virginia | 54073 | 685 | 6 |
910589 | 910589 | 2021-01-08 | Pleasants | West Virginia | 54073 | 676 | 6 |
907344 | 907344 | 2021-01-07 | Pleasants | West Virginia | 54073 | 615 | 6 |
904098 | 904098 | 2021-01-06 | Pleasants | West Virginia | 54073 | 607 | 6 |
900853 | 900853 | 2021-01-05 | Pleasants | West Virginia | 54073 | 600 | 6 |
897608 | 897608 | 2021-01-04 | Pleasants | West Virginia | 54073 | 595 | 6 |
894362 | 894362 | 2021-01-03 | Pleasants | West Virginia | 54073 | 591 | 5 |
891116 | 891116 | 2021-01-02 | Pleasants | West Virginia | 54073 | 580 | 5 |
887869 | 887869 | 2021-01-01 | Pleasants | West Virginia | 54073 | 574 | 5 |
884624 | 884624 | 2020-12-31 | Pleasants | West Virginia | 54073 | 569 | 5 |
881379 | 881379 | 2020-12-30 | Pleasants | West Virginia | 54073 | 564 | 5 |
878134 | 878134 | 2020-12-29 | Pleasants | West Virginia | 54073 | 556 | 5 |
874889 | 874889 | 2020-12-28 | Pleasants | West Virginia | 54073 | 547 | 5 |
871644 | 871644 | 2020-12-27 | Pleasants | West Virginia | 54073 | 531 | 5 |
868399 | 868399 | 2020-12-26 | Pleasants | West Virginia | 54073 | 516 | 5 |
865154 | 865154 | 2020-12-25 | Pleasants | West Virginia | 54073 | 495 | 5 |
861909 | 861909 | 2020-12-24 | Pleasants | West Virginia | 54073 | 330 | 5 |
858664 | 858664 | 2020-12-23 | Pleasants | West Virginia | 54073 | 317 | 5 |
855419 | 855419 | 2020-12-22 | Pleasants | West Virginia | 54073 | 303 | 5 |
852174 | 852174 | 2020-12-21 | Pleasants | West Virginia | 54073 | 288 | 5 |
848929 | 848929 | 2020-12-20 | Pleasants | West Virginia | 54073 | 285 | 5 |
845684 | 845684 | 2020-12-19 | Pleasants | West Virginia | 54073 | 277 | 5 |
842438 | 842438 | 2020-12-18 | Pleasants | West Virginia | 54073 | 234 | 5 |
839193 | 839193 | 2020-12-17 | Pleasants | West Virginia | 54073 | 228 | 5 |
835948 | 835948 | 2020-12-16 | Pleasants | West Virginia | 54073 | 219 | 5 |
832702 | 832702 | 2020-12-15 | Pleasants | West Virginia | 54073 | 211 | 5 |
829455 | 829455 | 2020-12-14 | Pleasants | West Virginia | 54073 | 209 | 4 |
826209 | 826209 | 2020-12-13 | Pleasants | West Virginia | 54073 | 171 | 4 |
822962 | 822962 | 2020-12-12 | Pleasants | West Virginia | 54073 | 168 | 4 |
819716 | 819716 | 2020-12-11 | Pleasants | West Virginia | 54073 | 154 | 4 |
816470 | 816470 | 2020-12-10 | Pleasants | West Virginia | 54073 | 141 | 4 |
813224 | 813224 | 2020-12-09 | Pleasants | West Virginia | 54073 | 139 | 4 |
809980 | 809980 | 2020-12-08 | Pleasants | West Virginia | 54073 | 136 | 4 |
806735 | 806735 | 2020-12-07 | Pleasants | West Virginia | 54073 | 129 | 4 |
803490 | 803490 | 2020-12-06 | Pleasants | West Virginia | 54073 | 123 | 4 |
800245 | 800245 | 2020-12-05 | Pleasants | West Virginia | 54073 | 120 | 4 |
797000 | 797000 | 2020-12-04 | Pleasants | West Virginia | 54073 | 118 | 4 |
793755 | 793755 | 2020-12-03 | Pleasants | West Virginia | 54073 | 111 | 4 |
790510 | 790510 | 2020-12-02 | Pleasants | West Virginia | 54073 | 104 | 4 |
787265 | 787265 | 2020-12-01 | Pleasants | West Virginia | 54073 | 101 | 4 |
784021 | 784021 | 2020-11-30 | Pleasants | West Virginia | 54073 | 98 | 4 |
780776 | 780776 | 2020-11-29 | Pleasants | West Virginia | 54073 | 93 | 4 |
777530 | 777530 | 2020-11-28 | Pleasants | West Virginia | 54073 | 89 | 4 |
774285 | 774285 | 2020-11-27 | Pleasants | West Virginia | 54073 | 87 | 4 |
771040 | 771040 | 2020-11-26 | Pleasants | West Virginia | 54073 | 86 | 4 |
767794 | 767794 | 2020-11-25 | Pleasants | West Virginia | 54073 | 84 | 4 |
764549 | 764549 | 2020-11-24 | Pleasants | West Virginia | 54073 | 76 | 4 |
761304 | 761304 | 2020-11-23 | Pleasants | West Virginia | 54073 | 73 | 4 |
758059 | 758059 | 2020-11-22 | Pleasants | West Virginia | 54073 | 72 | 4 |
754812 | 754812 | 2020-11-21 | Pleasants | West Virginia | 54073 | 69 | 4 |
751566 | 751566 | 2020-11-20 | Pleasants | West Virginia | 54073 | 66 | 4 |
748320 | 748320 | 2020-11-19 | Pleasants | West Virginia | 54073 | 65 | 3 |
745074 | 745074 | 2020-11-18 | Pleasants | West Virginia | 54073 | 64 | 3 |
741827 | 741827 | 2020-11-17 | Pleasants | West Virginia | 54073 | 62 | 3 |
738580 | 738580 | 2020-11-16 | Pleasants | West Virginia | 54073 | 57 | 3 |
735336 | 735336 | 2020-11-15 | Pleasants | West Virginia | 54073 | 55 | 3 |
732090 | 732090 | 2020-11-14 | Pleasants | West Virginia | 54073 | 55 | 3 |
728845 | 728845 | 2020-11-13 | Pleasants | West Virginia | 54073 | 54 | 3 |
725602 | 725602 | 2020-11-12 | Pleasants | West Virginia | 54073 | 50 | 3 |
722359 | 722359 | 2020-11-11 | Pleasants | West Virginia | 54073 | 49 | 3 |
719116 | 719116 | 2020-11-10 | Pleasants | West Virginia | 54073 | 47 | 3 |
715873 | 715873 | 2020-11-09 | Pleasants | West Virginia | 54073 | 45 | 3 |
712629 | 712629 | 2020-11-08 | Pleasants | West Virginia | 54073 | 45 | 3 |
709385 | 709385 | 2020-11-07 | Pleasants | West Virginia | 54073 | 45 | 3 |
706141 | 706141 | 2020-11-06 | Pleasants | West Virginia | 54073 | 43 | 3 |
702898 | 702898 | 2020-11-05 | Pleasants | West Virginia | 54073 | 40 | 3 |
699655 | 699655 | 2020-11-04 | Pleasants | West Virginia | 54073 | 37 | 3 |
696411 | 696411 | 2020-11-03 | Pleasants | West Virginia | 54073 | 36 | 3 |
693169 | 693169 | 2020-11-02 | Pleasants | West Virginia | 54073 | 36 | 3 |
689925 | 689925 | 2020-11-01 | Pleasants | West Virginia | 54073 | 34 | 3 |
686680 | 686680 | 2020-10-31 | Pleasants | West Virginia | 54073 | 34 | 3 |
683437 | 683437 | 2020-10-30 | Pleasants | West Virginia | 54073 | 33 | 3 |
680194 | 680194 | 2020-10-29 | Pleasants | West Virginia | 54073 | 30 | 3 |
676951 | 676951 | 2020-10-28 | Pleasants | West Virginia | 54073 | 29 | 3 |
673708 | 673708 | 2020-10-27 | Pleasants | West Virginia | 54073 | 27 | 3 |
670466 | 670466 | 2020-10-26 | Pleasants | West Virginia | 54073 | 25 | 3 |
667223 | 667223 | 2020-10-25 | Pleasants | West Virginia | 54073 | 24 | 3 |
663978 | 663978 | 2020-10-24 | Pleasants | West Virginia | 54073 | 24 | 3 |
660734 | 660734 | 2020-10-23 | Pleasants | West Virginia | 54073 | 23 | 3 |
657490 | 657490 | 2020-10-22 | Pleasants | West Virginia | 54073 | 23 | 3 |
654245 | 654245 | 2020-10-21 | Pleasants | West Virginia | 54073 | 23 | 3 |
651000 | 651000 | 2020-10-20 | Pleasants | West Virginia | 54073 | 23 | 3 |
647756 | 647756 | 2020-10-19 | Pleasants | West Virginia | 54073 | 23 | 3 |
644510 | 644510 | 2020-10-18 | Pleasants | West Virginia | 54073 | 23 | 3 |
641262 | 641262 | 2020-10-17 | Pleasants | West Virginia | 54073 | 22 | 3 |
638015 | 638015 | 2020-10-16 | Pleasants | West Virginia | 54073 | 22 | 3 |
634770 | 634770 | 2020-10-15 | Pleasants | West Virginia | 54073 | 21 | 3 |
631525 | 631525 | 2020-10-14 | Pleasants | West Virginia | 54073 | 21 | 3 |
628281 | 628281 | 2020-10-13 | Pleasants | West Virginia | 54073 | 21 | 3 |
625038 | 625038 | 2020-10-12 | Pleasants | West Virginia | 54073 | 21 | 3 |
621795 | 621795 | 2020-10-11 | Pleasants | West Virginia | 54073 | 20 | 3 |
618552 | 618552 | 2020-10-10 | Pleasants | West Virginia | 54073 | 20 | 3 |
615310 | 615310 | 2020-10-09 | Pleasants | West Virginia | 54073 | 20 | 3 |
612069 | 612069 | 2020-10-08 | Pleasants | West Virginia | 54073 | 20 | 3 |
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);