ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 54011 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 |
---|---|---|---|---|---|---|---|
1056607 | 1056607 | 2021-02-22 | Cabell | West Virginia | 54011 | 7689 | 160 |
1053361 | 1053361 | 2021-02-21 | Cabell | West Virginia | 54011 | 7683 | 160 |
1050114 | 1050114 | 2021-02-20 | Cabell | West Virginia | 54011 | 7679 | 159 |
1046867 | 1046867 | 2021-02-19 | Cabell | West Virginia | 54011 | 7646 | 158 |
1043622 | 1043622 | 2021-02-18 | Cabell | West Virginia | 54011 | 7655 | 158 |
1040377 | 1040377 | 2021-02-17 | Cabell | West Virginia | 54011 | 7591 | 158 |
1037132 | 1037132 | 2021-02-16 | Cabell | West Virginia | 54011 | 7545 | 158 |
1033887 | 1033887 | 2021-02-15 | Cabell | West Virginia | 54011 | 7529 | 158 |
1030641 | 1030641 | 2021-02-14 | Cabell | West Virginia | 54011 | 7517 | 158 |
1027394 | 1027394 | 2021-02-13 | Cabell | West Virginia | 54011 | 7508 | 156 |
1024149 | 1024149 | 2021-02-12 | Cabell | West Virginia | 54011 | 7471 | 156 |
1020904 | 1020904 | 2021-02-11 | Cabell | West Virginia | 54011 | 7420 | 156 |
1017659 | 1017659 | 2021-02-10 | Cabell | West Virginia | 54011 | 7381 | 154 |
1014414 | 1014414 | 2021-02-09 | Cabell | West Virginia | 54011 | 7365 | 152 |
1011169 | 1011169 | 2021-02-08 | Cabell | West Virginia | 54011 | 7312 | 150 |
1007923 | 1007923 | 2021-02-07 | Cabell | West Virginia | 54011 | 7298 | 149 |
1004677 | 1004677 | 2021-02-06 | Cabell | West Virginia | 54011 | 7263 | 149 |
1001431 | 1001431 | 2021-02-05 | Cabell | West Virginia | 54011 | 7256 | 149 |
998185 | 998185 | 2021-02-04 | Cabell | West Virginia | 54011 | 7218 | 148 |
994939 | 994939 | 2021-02-03 | Cabell | West Virginia | 54011 | 7201 | 147 |
991693 | 991693 | 2021-02-02 | Cabell | West Virginia | 54011 | 7167 | 146 |
988447 | 988447 | 2021-02-01 | Cabell | West Virginia | 54011 | 7119 | 146 |
985200 | 985200 | 2021-01-31 | Cabell | West Virginia | 54011 | 7100 | 145 |
981953 | 981953 | 2021-01-30 | Cabell | West Virginia | 54011 | 7038 | 145 |
978707 | 978707 | 2021-01-29 | Cabell | West Virginia | 54011 | 6999 | 144 |
975462 | 975462 | 2021-01-28 | Cabell | West Virginia | 54011 | 6936 | 143 |
972217 | 972217 | 2021-01-27 | Cabell | West Virginia | 54011 | 6899 | 141 |
968972 | 968972 | 2021-01-26 | Cabell | West Virginia | 54011 | 6849 | 138 |
965728 | 965728 | 2021-01-25 | Cabell | West Virginia | 54011 | 6782 | 138 |
962483 | 962483 | 2021-01-24 | Cabell | West Virginia | 54011 | 6744 | 137 |
959238 | 959238 | 2021-01-23 | Cabell | West Virginia | 54011 | 6728 | 137 |
955992 | 955992 | 2021-01-22 | Cabell | West Virginia | 54011 | 6666 | 136 |
952747 | 952747 | 2021-01-21 | Cabell | West Virginia | 54011 | 6604 | 135 |
949502 | 949502 | 2021-01-20 | Cabell | West Virginia | 54011 | 6556 | 133 |
946256 | 946256 | 2021-01-19 | Cabell | West Virginia | 54011 | 6495 | 132 |
943009 | 943009 | 2021-01-18 | Cabell | West Virginia | 54011 | 6458 | 130 |
939764 | 939764 | 2021-01-17 | Cabell | West Virginia | 54011 | 6410 | 130 |
936519 | 936519 | 2021-01-16 | Cabell | West Virginia | 54011 | 6383 | 130 |
933274 | 933274 | 2021-01-15 | Cabell | West Virginia | 54011 | 6319 | 128 |
930029 | 930029 | 2021-01-14 | Cabell | West Virginia | 54011 | 6220 | 126 |
926784 | 926784 | 2021-01-13 | Cabell | West Virginia | 54011 | 6184 | 123 |
923538 | 923538 | 2021-01-12 | Cabell | West Virginia | 54011 | 6101 | 121 |
920293 | 920293 | 2021-01-11 | Cabell | West Virginia | 54011 | 6066 | 119 |
917048 | 917048 | 2021-01-10 | Cabell | West Virginia | 54011 | 6025 | 117 |
913803 | 913803 | 2021-01-09 | Cabell | West Virginia | 54011 | 5976 | 117 |
910558 | 910558 | 2021-01-08 | Cabell | West Virginia | 54011 | 5879 | 116 |
907313 | 907313 | 2021-01-07 | Cabell | West Virginia | 54011 | 5801 | 114 |
904067 | 904067 | 2021-01-06 | Cabell | West Virginia | 54011 | 5721 | 112 |
900822 | 900822 | 2021-01-05 | Cabell | West Virginia | 54011 | 5600 | 107 |
897577 | 897577 | 2021-01-04 | Cabell | West Virginia | 54011 | 5522 | 104 |
894331 | 894331 | 2021-01-03 | Cabell | West Virginia | 54011 | 5491 | 101 |
891085 | 891085 | 2021-01-02 | Cabell | West Virginia | 54011 | 5424 | 101 |
887838 | 887838 | 2021-01-01 | Cabell | West Virginia | 54011 | 5373 | 101 |
884593 | 884593 | 2020-12-31 | Cabell | West Virginia | 54011 | 5232 | 101 |
881348 | 881348 | 2020-12-30 | Cabell | West Virginia | 54011 | 5111 | 99 |
878103 | 878103 | 2020-12-29 | Cabell | West Virginia | 54011 | 5034 | 97 |
874858 | 874858 | 2020-12-28 | Cabell | West Virginia | 54011 | 4945 | 95 |
871613 | 871613 | 2020-12-27 | Cabell | West Virginia | 54011 | 4924 | 92 |
868368 | 868368 | 2020-12-26 | Cabell | West Virginia | 54011 | 4923 | 92 |
865123 | 865123 | 2020-12-25 | Cabell | West Virginia | 54011 | 4828 | 88 |
861878 | 861878 | 2020-12-24 | Cabell | West Virginia | 54011 | 4770 | 87 |
858633 | 858633 | 2020-12-23 | Cabell | West Virginia | 54011 | 4683 | 87 |
855388 | 855388 | 2020-12-22 | Cabell | West Virginia | 54011 | 4593 | 85 |
852143 | 852143 | 2020-12-21 | Cabell | West Virginia | 54011 | 4481 | 81 |
848898 | 848898 | 2020-12-20 | Cabell | West Virginia | 54011 | 4451 | 80 |
845653 | 845653 | 2020-12-19 | Cabell | West Virginia | 54011 | 4390 | 79 |
842407 | 842407 | 2020-12-18 | Cabell | West Virginia | 54011 | 4306 | 78 |
839162 | 839162 | 2020-12-17 | Cabell | West Virginia | 54011 | 4221 | 77 |
835917 | 835917 | 2020-12-16 | Cabell | West Virginia | 54011 | 4134 | 77 |
832671 | 832671 | 2020-12-15 | Cabell | West Virginia | 54011 | 4047 | 75 |
829424 | 829424 | 2020-12-14 | Cabell | West Virginia | 54011 | 3962 | 72 |
826178 | 826178 | 2020-12-13 | Cabell | West Virginia | 54011 | 3898 | 72 |
822931 | 822931 | 2020-12-12 | Cabell | West Virginia | 54011 | 3845 | 71 |
819685 | 819685 | 2020-12-11 | Cabell | West Virginia | 54011 | 3719 | 69 |
816439 | 816439 | 2020-12-10 | Cabell | West Virginia | 54011 | 3661 | 68 |
813193 | 813193 | 2020-12-09 | Cabell | West Virginia | 54011 | 3581 | 65 |
809949 | 809949 | 2020-12-08 | Cabell | West Virginia | 54011 | 3470 | 64 |
806704 | 806704 | 2020-12-07 | Cabell | West Virginia | 54011 | 3414 | 62 |
803459 | 803459 | 2020-12-06 | Cabell | West Virginia | 54011 | 3366 | 62 |
800214 | 800214 | 2020-12-05 | Cabell | West Virginia | 54011 | 3276 | 62 |
796969 | 796969 | 2020-12-04 | Cabell | West Virginia | 54011 | 3177 | 61 |
793724 | 793724 | 2020-12-03 | Cabell | West Virginia | 54011 | 3119 | 61 |
790479 | 790479 | 2020-12-02 | Cabell | West Virginia | 54011 | 3056 | 60 |
787234 | 787234 | 2020-12-01 | Cabell | West Virginia | 54011 | 2956 | 59 |
783990 | 783990 | 2020-11-30 | Cabell | West Virginia | 54011 | 2905 | 58 |
780745 | 780745 | 2020-11-29 | Cabell | West Virginia | 54011 | 2881 | 57 |
777499 | 777499 | 2020-11-28 | Cabell | West Virginia | 54011 | 2829 | 56 |
774254 | 774254 | 2020-11-27 | Cabell | West Virginia | 54011 | 2787 | 55 |
771009 | 771009 | 2020-11-26 | Cabell | West Virginia | 54011 | 2756 | 55 |
767763 | 767763 | 2020-11-25 | Cabell | West Virginia | 54011 | 2695 | 52 |
764518 | 764518 | 2020-11-24 | Cabell | West Virginia | 54011 | 2640 | 51 |
761273 | 761273 | 2020-11-23 | Cabell | West Virginia | 54011 | 2575 | 50 |
758028 | 758028 | 2020-11-22 | Cabell | West Virginia | 54011 | 2550 | 50 |
754781 | 754781 | 2020-11-21 | Cabell | West Virginia | 54011 | 2508 | 50 |
751535 | 751535 | 2020-11-20 | Cabell | West Virginia | 54011 | 2421 | 47 |
748289 | 748289 | 2020-11-19 | Cabell | West Virginia | 54011 | 2349 | 47 |
745043 | 745043 | 2020-11-18 | Cabell | West Virginia | 54011 | 2303 | 46 |
741796 | 741796 | 2020-11-17 | Cabell | West Virginia | 54011 | 2229 | 45 |
738549 | 738549 | 2020-11-16 | Cabell | West Virginia | 54011 | 2192 | 45 |
735305 | 735305 | 2020-11-15 | Cabell | West Virginia | 54011 | 2162 | 44 |
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);