ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
747 rows where fips = 54075 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 |
---|---|---|---|---|---|---|---|
1196244 | 1196244 | 2021-04-06 | Pocahontas | West Virginia | 54075 | 622 | 10 |
1192996 | 1192996 | 2021-04-05 | Pocahontas | West Virginia | 54075 | 621 | 10 |
1189746 | 1189746 | 2021-04-04 | Pocahontas | West Virginia | 54075 | 621 | 10 |
1186499 | 1186499 | 2021-04-03 | Pocahontas | West Virginia | 54075 | 621 | 10 |
1183252 | 1183252 | 2021-04-02 | Pocahontas | West Virginia | 54075 | 620 | 10 |
1180005 | 1180005 | 2021-04-01 | Pocahontas | West Virginia | 54075 | 618 | 10 |
1176758 | 1176758 | 2021-03-31 | Pocahontas | West Virginia | 54075 | 616 | 10 |
1173511 | 1173511 | 2021-03-30 | Pocahontas | West Virginia | 54075 | 616 | 9 |
1170264 | 1170264 | 2021-03-29 | Pocahontas | West Virginia | 54075 | 615 | 9 |
1167016 | 1167016 | 2021-03-28 | Pocahontas | West Virginia | 54075 | 615 | 9 |
1163768 | 1163768 | 2021-03-27 | Pocahontas | West Virginia | 54075 | 615 | 9 |
1160520 | 1160520 | 2021-03-26 | Pocahontas | West Virginia | 54075 | 611 | 9 |
1157272 | 1157272 | 2021-03-25 | Pocahontas | West Virginia | 54075 | 611 | 9 |
1154025 | 1154025 | 2021-03-24 | Pocahontas | West Virginia | 54075 | 609 | 9 |
1150778 | 1150778 | 2021-03-23 | Pocahontas | West Virginia | 54075 | 607 | 9 |
1147531 | 1147531 | 2021-03-22 | Pocahontas | West Virginia | 54075 | 607 | 9 |
1144284 | 1144284 | 2021-03-21 | Pocahontas | West Virginia | 54075 | 607 | 9 |
1141037 | 1141037 | 2021-03-20 | Pocahontas | West Virginia | 54075 | 606 | 9 |
1137791 | 1137791 | 2021-03-19 | Pocahontas | West Virginia | 54075 | 603 | 9 |
1134545 | 1134545 | 2021-03-18 | Pocahontas | West Virginia | 54075 | 602 | 9 |
1131297 | 1131297 | 2021-03-17 | Pocahontas | West Virginia | 54075 | 602 | 9 |
1128050 | 1128050 | 2021-03-16 | Pocahontas | West Virginia | 54075 | 601 | 9 |
1124804 | 1124804 | 2021-03-15 | Pocahontas | West Virginia | 54075 | 601 | 9 |
1121558 | 1121558 | 2021-03-14 | Pocahontas | West Virginia | 54075 | 601 | 9 |
1118311 | 1118311 | 2021-03-13 | Pocahontas | West Virginia | 54075 | 601 | 9 |
1115064 | 1115064 | 2021-03-12 | Pocahontas | West Virginia | 54075 | 599 | 9 |
1111818 | 1111818 | 2021-03-11 | Pocahontas | West Virginia | 54075 | 599 | 9 |
1108572 | 1108572 | 2021-03-10 | Pocahontas | West Virginia | 54075 | 597 | 9 |
1105326 | 1105326 | 2021-03-09 | Pocahontas | West Virginia | 54075 | 597 | 9 |
1102080 | 1102080 | 2021-03-08 | Pocahontas | West Virginia | 54075 | 597 | 9 |
1098834 | 1098834 | 2021-03-07 | Pocahontas | West Virginia | 54075 | 597 | 9 |
1095586 | 1095586 | 2021-03-06 | Pocahontas | West Virginia | 54075 | 597 | 9 |
1092340 | 1092340 | 2021-03-05 | Pocahontas | West Virginia | 54075 | 596 | 9 |
1089094 | 1089094 | 2021-03-04 | Pocahontas | West Virginia | 54075 | 596 | 9 |
1085849 | 1085849 | 2021-03-03 | Pocahontas | West Virginia | 54075 | 596 | 9 |
1082603 | 1082603 | 2021-03-02 | Pocahontas | West Virginia | 54075 | 596 | 9 |
1079357 | 1079357 | 2021-03-01 | Pocahontas | West Virginia | 54075 | 595 | 9 |
1076112 | 1076112 | 2021-02-28 | Pocahontas | West Virginia | 54075 | 595 | 9 |
1072866 | 1072866 | 2021-02-27 | Pocahontas | West Virginia | 54075 | 593 | 9 |
1069620 | 1069620 | 2021-02-26 | Pocahontas | West Virginia | 54075 | 589 | 9 |
1066375 | 1066375 | 2021-02-25 | Pocahontas | West Virginia | 54075 | 589 | 9 |
1063130 | 1063130 | 2021-02-24 | Pocahontas | West Virginia | 54075 | 584 | 9 |
1059885 | 1059885 | 2021-02-23 | Pocahontas | West Virginia | 54075 | 582 | 9 |
1056639 | 1056639 | 2021-02-22 | Pocahontas | West Virginia | 54075 | 582 | 9 |
1053393 | 1053393 | 2021-02-21 | Pocahontas | West Virginia | 54075 | 581 | 9 |
1050146 | 1050146 | 2021-02-20 | Pocahontas | West Virginia | 54075 | 581 | 9 |
1046899 | 1046899 | 2021-02-19 | Pocahontas | West Virginia | 54075 | 580 | 9 |
1043654 | 1043654 | 2021-02-18 | Pocahontas | West Virginia | 54075 | 578 | 9 |
1040409 | 1040409 | 2021-02-17 | Pocahontas | West Virginia | 54075 | 577 | 9 |
1037164 | 1037164 | 2021-02-16 | Pocahontas | West Virginia | 54075 | 576 | 9 |
1033919 | 1033919 | 2021-02-15 | Pocahontas | West Virginia | 54075 | 576 | 9 |
1030673 | 1030673 | 2021-02-14 | Pocahontas | West Virginia | 54075 | 575 | 9 |
1027426 | 1027426 | 2021-02-13 | Pocahontas | West Virginia | 54075 | 575 | 9 |
1024181 | 1024181 | 2021-02-12 | Pocahontas | West Virginia | 54075 | 574 | 9 |
1020936 | 1020936 | 2021-02-11 | Pocahontas | West Virginia | 54075 | 574 | 9 |
1017691 | 1017691 | 2021-02-10 | Pocahontas | West Virginia | 54075 | 572 | 9 |
1014446 | 1014446 | 2021-02-09 | Pocahontas | West Virginia | 54075 | 570 | 9 |
1011201 | 1011201 | 2021-02-08 | Pocahontas | West Virginia | 54075 | 569 | 9 |
1007955 | 1007955 | 2021-02-07 | Pocahontas | West Virginia | 54075 | 568 | 9 |
1004709 | 1004709 | 2021-02-06 | Pocahontas | West Virginia | 54075 | 568 | 9 |
1001463 | 1001463 | 2021-02-05 | Pocahontas | West Virginia | 54075 | 564 | 9 |
998217 | 998217 | 2021-02-04 | Pocahontas | West Virginia | 54075 | 564 | 9 |
994971 | 994971 | 2021-02-03 | Pocahontas | West Virginia | 54075 | 563 | 9 |
991725 | 991725 | 2021-02-02 | Pocahontas | West Virginia | 54075 | 561 | 9 |
988479 | 988479 | 2021-02-01 | Pocahontas | West Virginia | 54075 | 556 | 9 |
985232 | 985232 | 2021-01-31 | Pocahontas | West Virginia | 54075 | 556 | 9 |
981985 | 981985 | 2021-01-30 | Pocahontas | West Virginia | 54075 | 556 | 9 |
978739 | 978739 | 2021-01-29 | Pocahontas | West Virginia | 54075 | 555 | 9 |
975494 | 975494 | 2021-01-28 | Pocahontas | West Virginia | 54075 | 554 | 9 |
972249 | 972249 | 2021-01-27 | Pocahontas | West Virginia | 54075 | 548 | 9 |
969004 | 969004 | 2021-01-26 | Pocahontas | West Virginia | 54075 | 548 | 9 |
965760 | 965760 | 2021-01-25 | Pocahontas | West Virginia | 54075 | 547 | 9 |
962515 | 962515 | 2021-01-24 | Pocahontas | West Virginia | 54075 | 545 | 9 |
959270 | 959270 | 2021-01-23 | Pocahontas | West Virginia | 54075 | 545 | 9 |
956024 | 956024 | 2021-01-22 | Pocahontas | West Virginia | 54075 | 531 | 9 |
952779 | 952779 | 2021-01-21 | Pocahontas | West Virginia | 54075 | 529 | 9 |
949534 | 949534 | 2021-01-20 | Pocahontas | West Virginia | 54075 | 521 | 9 |
946288 | 946288 | 2021-01-19 | Pocahontas | West Virginia | 54075 | 516 | 9 |
943041 | 943041 | 2021-01-18 | Pocahontas | West Virginia | 54075 | 511 | 9 |
939796 | 939796 | 2021-01-17 | Pocahontas | West Virginia | 54075 | 509 | 9 |
936551 | 936551 | 2021-01-16 | Pocahontas | West Virginia | 54075 | 501 | 9 |
933306 | 933306 | 2021-01-15 | Pocahontas | West Virginia | 54075 | 464 | 9 |
930061 | 930061 | 2021-01-14 | Pocahontas | West Virginia | 54075 | 451 | 9 |
926816 | 926816 | 2021-01-13 | Pocahontas | West Virginia | 54075 | 438 | 9 |
923570 | 923570 | 2021-01-12 | Pocahontas | West Virginia | 54075 | 425 | 9 |
920325 | 920325 | 2021-01-11 | Pocahontas | West Virginia | 54075 | 419 | 9 |
917080 | 917080 | 2021-01-10 | Pocahontas | West Virginia | 54075 | 418 | 9 |
913835 | 913835 | 2021-01-09 | Pocahontas | West Virginia | 54075 | 416 | 9 |
910590 | 910590 | 2021-01-08 | Pocahontas | West Virginia | 54075 | 405 | 9 |
907345 | 907345 | 2021-01-07 | Pocahontas | West Virginia | 54075 | 397 | 9 |
904099 | 904099 | 2021-01-06 | Pocahontas | West Virginia | 54075 | 385 | 9 |
900854 | 900854 | 2021-01-05 | Pocahontas | West Virginia | 54075 | 374 | 9 |
897609 | 897609 | 2021-01-04 | Pocahontas | West Virginia | 54075 | 368 | 9 |
894363 | 894363 | 2021-01-03 | Pocahontas | West Virginia | 54075 | 367 | 9 |
891117 | 891117 | 2021-01-02 | Pocahontas | West Virginia | 54075 | 364 | 9 |
887870 | 887870 | 2021-01-01 | Pocahontas | West Virginia | 54075 | 360 | 9 |
884625 | 884625 | 2020-12-31 | Pocahontas | West Virginia | 54075 | 356 | 9 |
881380 | 881380 | 2020-12-30 | Pocahontas | West Virginia | 54075 | 351 | 9 |
878135 | 878135 | 2020-12-29 | Pocahontas | West Virginia | 54075 | 344 | 9 |
874890 | 874890 | 2020-12-28 | Pocahontas | West Virginia | 54075 | 338 | 9 |
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);