ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 54029 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 |
---|---|---|---|---|---|---|---|
923547 | 923547 | 2021-01-12 | Hancock | West Virginia | 54029 | 2200 | 61 |
920302 | 920302 | 2021-01-11 | Hancock | West Virginia | 54029 | 2173 | 61 |
917057 | 917057 | 2021-01-10 | Hancock | West Virginia | 54029 | 2162 | 57 |
913812 | 913812 | 2021-01-09 | Hancock | West Virginia | 54029 | 2143 | 57 |
910567 | 910567 | 2021-01-08 | Hancock | West Virginia | 54029 | 2126 | 56 |
907322 | 907322 | 2021-01-07 | Hancock | West Virginia | 54029 | 2083 | 55 |
904076 | 904076 | 2021-01-06 | Hancock | West Virginia | 54029 | 2060 | 52 |
900831 | 900831 | 2021-01-05 | Hancock | West Virginia | 54029 | 2031 | 49 |
897586 | 897586 | 2021-01-04 | Hancock | West Virginia | 54029 | 1997 | 43 |
894340 | 894340 | 2021-01-03 | Hancock | West Virginia | 54029 | 1996 | 42 |
891094 | 891094 | 2021-01-02 | Hancock | West Virginia | 54029 | 1973 | 42 |
887847 | 887847 | 2021-01-01 | Hancock | West Virginia | 54029 | 1922 | 42 |
884602 | 884602 | 2020-12-31 | Hancock | West Virginia | 54029 | 1837 | 41 |
881357 | 881357 | 2020-12-30 | Hancock | West Virginia | 54029 | 1821 | 40 |
878112 | 878112 | 2020-12-29 | Hancock | West Virginia | 54029 | 1801 | 36 |
874867 | 874867 | 2020-12-28 | Hancock | West Virginia | 54029 | 1740 | 33 |
871622 | 871622 | 2020-12-27 | Hancock | West Virginia | 54029 | 1740 | 33 |
868377 | 868377 | 2020-12-26 | Hancock | West Virginia | 54029 | 1732 | 33 |
865132 | 865132 | 2020-12-25 | Hancock | West Virginia | 54029 | 1686 | 33 |
861887 | 861887 | 2020-12-24 | Hancock | West Virginia | 54029 | 1650 | 30 |
858642 | 858642 | 2020-12-23 | Hancock | West Virginia | 54029 | 1631 | 24 |
855397 | 855397 | 2020-12-22 | Hancock | West Virginia | 54029 | 1609 | 23 |
852152 | 852152 | 2020-12-21 | Hancock | West Virginia | 54029 | 1567 | 20 |
848907 | 848907 | 2020-12-20 | Hancock | West Virginia | 54029 | 1546 | 20 |
845662 | 845662 | 2020-12-19 | Hancock | West Virginia | 54029 | 1529 | 20 |
842416 | 842416 | 2020-12-18 | Hancock | West Virginia | 54029 | 1477 | 17 |
839171 | 839171 | 2020-12-17 | Hancock | West Virginia | 54029 | 1441 | 16 |
835926 | 835926 | 2020-12-16 | Hancock | West Virginia | 54029 | 1378 | 18 |
832680 | 832680 | 2020-12-15 | Hancock | West Virginia | 54029 | 1337 | 16 |
829433 | 829433 | 2020-12-14 | Hancock | West Virginia | 54029 | 1292 | 12 |
826187 | 826187 | 2020-12-13 | Hancock | West Virginia | 54029 | 1265 | 12 |
822940 | 822940 | 2020-12-12 | Hancock | West Virginia | 54029 | 1235 | 12 |
819694 | 819694 | 2020-12-11 | Hancock | West Virginia | 54029 | 1188 | 12 |
816448 | 816448 | 2020-12-10 | Hancock | West Virginia | 54029 | 1139 | 12 |
813202 | 813202 | 2020-12-09 | Hancock | West Virginia | 54029 | 1085 | 11 |
809958 | 809958 | 2020-12-08 | Hancock | West Virginia | 54029 | 1035 | 10 |
806713 | 806713 | 2020-12-07 | Hancock | West Virginia | 54029 | 996 | 7 |
803468 | 803468 | 2020-12-06 | Hancock | West Virginia | 54029 | 966 | 7 |
800223 | 800223 | 2020-12-05 | Hancock | West Virginia | 54029 | 910 | 6 |
796978 | 796978 | 2020-12-04 | Hancock | West Virginia | 54029 | 851 | 6 |
793733 | 793733 | 2020-12-03 | Hancock | West Virginia | 54029 | 825 | 5 |
790488 | 790488 | 2020-12-02 | Hancock | West Virginia | 54029 | 787 | 5 |
787243 | 787243 | 2020-12-01 | Hancock | West Virginia | 54029 | 753 | 5 |
783999 | 783999 | 2020-11-30 | Hancock | West Virginia | 54029 | 708 | 4 |
780754 | 780754 | 2020-11-29 | Hancock | West Virginia | 54029 | 694 | 4 |
777508 | 777508 | 2020-11-28 | Hancock | West Virginia | 54029 | 663 | 4 |
774263 | 774263 | 2020-11-27 | Hancock | West Virginia | 54029 | 640 | 4 |
771018 | 771018 | 2020-11-26 | Hancock | West Virginia | 54029 | 620 | 4 |
767772 | 767772 | 2020-11-25 | Hancock | West Virginia | 54029 | 591 | 4 |
764527 | 764527 | 2020-11-24 | Hancock | West Virginia | 54029 | 569 | 4 |
761282 | 761282 | 2020-11-23 | Hancock | West Virginia | 54029 | 528 | 4 |
758037 | 758037 | 2020-11-22 | Hancock | West Virginia | 54029 | 519 | 4 |
754790 | 754790 | 2020-11-21 | Hancock | West Virginia | 54029 | 494 | 4 |
751544 | 751544 | 2020-11-20 | Hancock | West Virginia | 54029 | 474 | 4 |
748298 | 748298 | 2020-11-19 | Hancock | West Virginia | 54029 | 459 | 4 |
745052 | 745052 | 2020-11-18 | Hancock | West Virginia | 54029 | 432 | 4 |
741805 | 741805 | 2020-11-17 | Hancock | West Virginia | 54029 | 407 | 4 |
738558 | 738558 | 2020-11-16 | Hancock | West Virginia | 54029 | 380 | 4 |
735314 | 735314 | 2020-11-15 | Hancock | West Virginia | 54029 | 366 | 4 |
732068 | 732068 | 2020-11-14 | Hancock | West Virginia | 54029 | 356 | 3 |
728823 | 728823 | 2020-11-13 | Hancock | West Virginia | 54029 | 332 | 3 |
725580 | 725580 | 2020-11-12 | Hancock | West Virginia | 54029 | 326 | 2 |
722337 | 722337 | 2020-11-11 | Hancock | West Virginia | 54029 | 306 | 2 |
719094 | 719094 | 2020-11-10 | Hancock | West Virginia | 54029 | 296 | 2 |
715851 | 715851 | 2020-11-09 | Hancock | West Virginia | 54029 | 284 | 1 |
712607 | 712607 | 2020-11-08 | Hancock | West Virginia | 54029 | 277 | 1 |
709363 | 709363 | 2020-11-07 | Hancock | West Virginia | 54029 | 272 | 1 |
706119 | 706119 | 2020-11-06 | Hancock | West Virginia | 54029 | 261 | 1 |
702876 | 702876 | 2020-11-05 | Hancock | West Virginia | 54029 | 253 | 1 |
699633 | 699633 | 2020-11-04 | Hancock | West Virginia | 54029 | 251 | 1 |
696389 | 696389 | 2020-11-03 | Hancock | West Virginia | 54029 | 249 | 1 |
693147 | 693147 | 2020-11-02 | Hancock | West Virginia | 54029 | 244 | 1 |
689903 | 689903 | 2020-11-01 | Hancock | West Virginia | 54029 | 242 | 1 |
686658 | 686658 | 2020-10-31 | Hancock | West Virginia | 54029 | 234 | 1 |
683415 | 683415 | 2020-10-30 | Hancock | West Virginia | 54029 | 230 | 1 |
680172 | 680172 | 2020-10-29 | Hancock | West Virginia | 54029 | 224 | 1 |
676929 | 676929 | 2020-10-28 | Hancock | West Virginia | 54029 | 224 | 1 |
673686 | 673686 | 2020-10-27 | Hancock | West Virginia | 54029 | 219 | 1 |
670444 | 670444 | 2020-10-26 | Hancock | West Virginia | 54029 | 214 | 1 |
667201 | 667201 | 2020-10-25 | Hancock | West Virginia | 54029 | 213 | 1 |
663956 | 663956 | 2020-10-24 | Hancock | West Virginia | 54029 | 210 | 1 |
660712 | 660712 | 2020-10-23 | Hancock | West Virginia | 54029 | 207 | 1 |
657468 | 657468 | 2020-10-22 | Hancock | West Virginia | 54029 | 198 | 1 |
654223 | 654223 | 2020-10-21 | Hancock | West Virginia | 54029 | 195 | 0 |
650978 | 650978 | 2020-10-20 | Hancock | West Virginia | 54029 | 194 | 0 |
647734 | 647734 | 2020-10-19 | Hancock | West Virginia | 54029 | 191 | 0 |
644488 | 644488 | 2020-10-18 | Hancock | West Virginia | 54029 | 191 | 0 |
641240 | 641240 | 2020-10-17 | Hancock | West Virginia | 54029 | 185 | 0 |
637993 | 637993 | 2020-10-16 | Hancock | West Virginia | 54029 | 182 | 0 |
634748 | 634748 | 2020-10-15 | Hancock | West Virginia | 54029 | 188 | 0 |
631503 | 631503 | 2020-10-14 | Hancock | West Virginia | 54029 | 185 | 0 |
628259 | 628259 | 2020-10-13 | Hancock | West Virginia | 54029 | 177 | 0 |
625016 | 625016 | 2020-10-12 | Hancock | West Virginia | 54029 | 173 | 0 |
621773 | 621773 | 2020-10-11 | Hancock | West Virginia | 54029 | 172 | 0 |
618530 | 618530 | 2020-10-10 | Hancock | West Virginia | 54029 | 170 | 0 |
615288 | 615288 | 2020-10-09 | Hancock | West Virginia | 54029 | 165 | 0 |
612047 | 612047 | 2020-10-08 | Hancock | West Virginia | 54029 | 160 | 0 |
608805 | 608805 | 2020-10-07 | Hancock | West Virginia | 54029 | 160 | 0 |
605562 | 605562 | 2020-10-06 | Hancock | West Virginia | 54029 | 155 | 0 |
602320 | 602320 | 2020-10-05 | Hancock | West Virginia | 54029 | 154 | 0 |
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);