ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Mercer" 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 |
---|---|---|---|---|---|---|---|
933296 | 933296 | 2021-01-15 | Mercer | West Virginia | 54055 | 3616 | 71 |
930051 | 930051 | 2021-01-14 | Mercer | West Virginia | 54055 | 3595 | 69 |
926806 | 926806 | 2021-01-13 | Mercer | West Virginia | 54055 | 3559 | 67 |
923560 | 923560 | 2021-01-12 | Mercer | West Virginia | 54055 | 3534 | 67 |
920315 | 920315 | 2021-01-11 | Mercer | West Virginia | 54055 | 3508 | 64 |
917070 | 917070 | 2021-01-10 | Mercer | West Virginia | 54055 | 3474 | 64 |
913825 | 913825 | 2021-01-09 | Mercer | West Virginia | 54055 | 3418 | 64 |
910580 | 910580 | 2021-01-08 | Mercer | West Virginia | 54055 | 3316 | 64 |
907335 | 907335 | 2021-01-07 | Mercer | West Virginia | 54055 | 3254 | 62 |
904089 | 904089 | 2021-01-06 | Mercer | West Virginia | 54055 | 3209 | 61 |
900844 | 900844 | 2021-01-05 | Mercer | West Virginia | 54055 | 3170 | 58 |
897599 | 897599 | 2021-01-04 | Mercer | West Virginia | 54055 | 3111 | 54 |
894353 | 894353 | 2021-01-03 | Mercer | West Virginia | 54055 | 3081 | 54 |
891107 | 891107 | 2021-01-02 | Mercer | West Virginia | 54055 | 3003 | 54 |
887860 | 887860 | 2021-01-01 | Mercer | West Virginia | 54055 | 2885 | 54 |
884615 | 884615 | 2020-12-31 | Mercer | West Virginia | 54055 | 2783 | 54 |
881370 | 881370 | 2020-12-30 | Mercer | West Virginia | 54055 | 2713 | 52 |
878125 | 878125 | 2020-12-29 | Mercer | West Virginia | 54055 | 2669 | 51 |
874880 | 874880 | 2020-12-28 | Mercer | West Virginia | 54055 | 2622 | 51 |
871635 | 871635 | 2020-12-27 | Mercer | West Virginia | 54055 | 2574 | 51 |
868390 | 868390 | 2020-12-26 | Mercer | West Virginia | 54055 | 2561 | 51 |
865145 | 865145 | 2020-12-25 | Mercer | West Virginia | 54055 | 2486 | 51 |
861900 | 861900 | 2020-12-24 | Mercer | West Virginia | 54055 | 2410 | 51 |
858655 | 858655 | 2020-12-23 | Mercer | West Virginia | 54055 | 2353 | 51 |
855410 | 855410 | 2020-12-22 | Mercer | West Virginia | 54055 | 2303 | 51 |
852165 | 852165 | 2020-12-21 | Mercer | West Virginia | 54055 | 2243 | 49 |
848920 | 848920 | 2020-12-20 | Mercer | West Virginia | 54055 | 2177 | 49 |
845675 | 845675 | 2020-12-19 | Mercer | West Virginia | 54055 | 2114 | 49 |
842429 | 842429 | 2020-12-18 | Mercer | West Virginia | 54055 | 2060 | 49 |
839184 | 839184 | 2020-12-17 | Mercer | West Virginia | 54055 | 2006 | 49 |
835939 | 835939 | 2020-12-16 | Mercer | West Virginia | 54055 | 1935 | 47 |
832693 | 832693 | 2020-12-15 | Mercer | West Virginia | 54055 | 1905 | 46 |
829446 | 829446 | 2020-12-14 | Mercer | West Virginia | 54055 | 1834 | 45 |
826200 | 826200 | 2020-12-13 | Mercer | West Virginia | 54055 | 1781 | 45 |
822953 | 822953 | 2020-12-12 | Mercer | West Virginia | 54055 | 1732 | 45 |
819707 | 819707 | 2020-12-11 | Mercer | West Virginia | 54055 | 1670 | 45 |
816461 | 816461 | 2020-12-10 | Mercer | West Virginia | 54055 | 1652 | 45 |
813215 | 813215 | 2020-12-09 | Mercer | West Virginia | 54055 | 1617 | 45 |
809971 | 809971 | 2020-12-08 | Mercer | West Virginia | 54055 | 1581 | 41 |
806726 | 806726 | 2020-12-07 | Mercer | West Virginia | 54055 | 1542 | 41 |
803481 | 803481 | 2020-12-06 | Mercer | West Virginia | 54055 | 1495 | 41 |
800236 | 800236 | 2020-12-05 | Mercer | West Virginia | 54055 | 1465 | 41 |
796991 | 796991 | 2020-12-04 | Mercer | West Virginia | 54055 | 1423 | 39 |
793746 | 793746 | 2020-12-03 | Mercer | West Virginia | 54055 | 1401 | 39 |
790501 | 790501 | 2020-12-02 | Mercer | West Virginia | 54055 | 1383 | 39 |
787256 | 787256 | 2020-12-01 | Mercer | West Virginia | 54055 | 1374 | 39 |
784012 | 784012 | 2020-11-30 | Mercer | West Virginia | 54055 | 1360 | 37 |
780767 | 780767 | 2020-11-29 | Mercer | West Virginia | 54055 | 1330 | 37 |
777521 | 777521 | 2020-11-28 | Mercer | West Virginia | 54055 | 1317 | 37 |
774276 | 774276 | 2020-11-27 | Mercer | West Virginia | 54055 | 1307 | 37 |
771031 | 771031 | 2020-11-26 | Mercer | West Virginia | 54055 | 1286 | 37 |
767785 | 767785 | 2020-11-25 | Mercer | West Virginia | 54055 | 1264 | 37 |
764540 | 764540 | 2020-11-24 | Mercer | West Virginia | 54055 | 1252 | 37 |
761295 | 761295 | 2020-11-23 | Mercer | West Virginia | 54055 | 1227 | 37 |
758050 | 758050 | 2020-11-22 | Mercer | West Virginia | 54055 | 1203 | 37 |
754803 | 754803 | 2020-11-21 | Mercer | West Virginia | 54055 | 1194 | 37 |
751557 | 751557 | 2020-11-20 | Mercer | West Virginia | 54055 | 1163 | 37 |
748311 | 748311 | 2020-11-19 | Mercer | West Virginia | 54055 | 1125 | 37 |
745065 | 745065 | 2020-11-18 | Mercer | West Virginia | 54055 | 1108 | 37 |
741818 | 741818 | 2020-11-17 | Mercer | West Virginia | 54055 | 1083 | 36 |
738571 | 738571 | 2020-11-16 | Mercer | West Virginia | 54055 | 1062 | 36 |
735327 | 735327 | 2020-11-15 | Mercer | West Virginia | 54055 | 1045 | 36 |
732081 | 732081 | 2020-11-14 | Mercer | West Virginia | 54055 | 1024 | 36 |
728836 | 728836 | 2020-11-13 | Mercer | West Virginia | 54055 | 990 | 36 |
725593 | 725593 | 2020-11-12 | Mercer | West Virginia | 54055 | 975 | 35 |
722350 | 722350 | 2020-11-11 | Mercer | West Virginia | 54055 | 951 | 35 |
719107 | 719107 | 2020-11-10 | Mercer | West Virginia | 54055 | 931 | 35 |
715864 | 715864 | 2020-11-09 | Mercer | West Virginia | 54055 | 922 | 35 |
712620 | 712620 | 2020-11-08 | Mercer | West Virginia | 54055 | 912 | 35 |
709376 | 709376 | 2020-11-07 | Mercer | West Virginia | 54055 | 896 | 35 |
706132 | 706132 | 2020-11-06 | Mercer | West Virginia | 54055 | 871 | 34 |
702889 | 702889 | 2020-11-05 | Mercer | West Virginia | 54055 | 850 | 34 |
699646 | 699646 | 2020-11-04 | Mercer | West Virginia | 54055 | 838 | 31 |
696402 | 696402 | 2020-11-03 | Mercer | West Virginia | 54055 | 824 | 31 |
693160 | 693160 | 2020-11-02 | Mercer | West Virginia | 54055 | 816 | 31 |
689916 | 689916 | 2020-11-01 | Mercer | West Virginia | 54055 | 803 | 31 |
686671 | 686671 | 2020-10-31 | Mercer | West Virginia | 54055 | 794 | 31 |
683428 | 683428 | 2020-10-30 | Mercer | West Virginia | 54055 | 781 | 31 |
680185 | 680185 | 2020-10-29 | Mercer | West Virginia | 54055 | 762 | 31 |
676942 | 676942 | 2020-10-28 | Mercer | West Virginia | 54055 | 748 | 31 |
673699 | 673699 | 2020-10-27 | Mercer | West Virginia | 54055 | 732 | 30 |
670457 | 670457 | 2020-10-26 | Mercer | West Virginia | 54055 | 704 | 30 |
667214 | 667214 | 2020-10-25 | Mercer | West Virginia | 54055 | 680 | 30 |
663969 | 663969 | 2020-10-24 | Mercer | West Virginia | 54055 | 667 | 30 |
660725 | 660725 | 2020-10-23 | Mercer | West Virginia | 54055 | 644 | 30 |
657481 | 657481 | 2020-10-22 | Mercer | West Virginia | 54055 | 625 | 30 |
654236 | 654236 | 2020-10-21 | Mercer | West Virginia | 54055 | 606 | 30 |
650991 | 650991 | 2020-10-20 | Mercer | West Virginia | 54055 | 588 | 30 |
647747 | 647747 | 2020-10-19 | Mercer | West Virginia | 54055 | 578 | 30 |
644501 | 644501 | 2020-10-18 | Mercer | West Virginia | 54055 | 568 | 30 |
641253 | 641253 | 2020-10-17 | Mercer | West Virginia | 54055 | 550 | 30 |
638006 | 638006 | 2020-10-16 | Mercer | West Virginia | 54055 | 535 | 30 |
634761 | 634761 | 2020-10-15 | Mercer | West Virginia | 54055 | 494 | 29 |
631516 | 631516 | 2020-10-14 | Mercer | West Virginia | 54055 | 488 | 29 |
628272 | 628272 | 2020-10-13 | Mercer | West Virginia | 54055 | 478 | 29 |
625029 | 625029 | 2020-10-12 | Mercer | West Virginia | 54055 | 470 | 29 |
621786 | 621786 | 2020-10-11 | Mercer | West Virginia | 54055 | 467 | 29 |
618543 | 618543 | 2020-10-10 | Mercer | West Virginia | 54055 | 456 | 29 |
615301 | 615301 | 2020-10-09 | Mercer | West Virginia | 54055 | 450 | 28 |
612060 | 612060 | 2020-10-08 | Mercer | West Virginia | 54055 | 445 | 28 |
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);