ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

31,128 rows where state = "West Virginia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • West Virginia · 31,128 ✖
Link rowid date ▲ county state fips cases deaths
1845706 1845706 2021-10-23 Barbour West Virginia 54001 2648 44
1845707 1845707 2021-10-23 Berkeley West Virginia 54003 18338 178
1845708 1845708 2021-10-23 Boone West Virginia 54005 3516 52
1845709 1845709 2021-10-23 Braxton West Virginia 54007 2113 18
1845710 1845710 2021-10-23 Brooke West Virginia 54009 3024 71
1845711 1845711 2021-10-23 Cabell West Virginia 54011 14799 261
1845712 1845712 2021-10-23 Calhoun West Virginia 54013 916 4
1845713 1845713 2021-10-23 Clay West Virginia 54015 1211 19
1845714 1845714 2021-10-23 Doddridge West Virginia 54017 1201 10
1845715 1845715 2021-10-23 Fayette West Virginia 54019 6068 120
1845716 1845716 2021-10-23 Gilmer West Virginia 54021 1344 9
1845717 1845717 2021-10-23 Grant West Virginia 54023 2130 33
1845718 1845718 2021-10-23 Greenbrier West Virginia 54025 4850 90
1845719 1845719 2021-10-23 Hampshire West Virginia 54027 3150 47
1845720 1845720 2021-10-23 Hancock West Virginia 54029 4135 112
1845721 1845721 2021-10-23 Hardy West Virginia 54031 2377 29
1845722 1845722 2021-10-23 Harrison West Virginia 54033 10993 140
1845723 1845723 2021-10-23 Jackson West Virginia 54035 3906 83
1845724 1845724 2021-10-23 Jefferson West Virginia 54037 6728 84
1845725 1845725 2021-10-23 Kanawha West Virginia 54039 24264 467
1845726 1845726 2021-10-23 Lewis West Virginia 54041 2990 50
1845727 1845727 2021-10-23 Lincoln West Virginia 54043 2751 42
1845728 1845728 2021-10-23 Logan West Virginia 54045 5267 134
1845729 1845729 2021-10-23 Marion West Virginia 54049 7964 101
1845730 1845730 2021-10-23 Marshall West Virginia 54051 5249 110
1845731 1845731 2021-10-23 Mason West Virginia 54053 3587 53
1845732 1845732 2021-10-23 McDowell West Virginia 54047 2879 47
1845733 1845733 2021-10-23 Mercer West Virginia 54055 8563 174
1845734 1845734 2021-10-23 Mineral West Virginia 54057 4557 111
1845735 1845735 2021-10-23 Mingo West Virginia 54059 4549 79
1845736 1845736 2021-10-23 Monongalia West Virginia 54061 12961 134
1845737 1845737 2021-10-23 Monroe West Virginia 54063 2069 25
1845738 1845738 2021-10-23 Morgan West Virginia 54065 2075 41
1845739 1845739 2021-10-23 Nicholas West Virginia 54067 3599 44
1845740 1845740 2021-10-23 Ohio West Virginia 54069 6041 103
1845741 1845741 2021-10-23 Pendleton West Virginia 54071 1088 14
1845742 1845742 2021-10-23 Pleasants West Virginia 54073 1393 30
1845743 1845743 2021-10-23 Pocahontas West Virginia 54075 1134 18
1845744 1845744 2021-10-23 Preston West Virginia 54077 5090 82
1845745 1845745 2021-10-23 Putnam West Virginia 54079 8651 121
1845746 1845746 2021-10-23 Raleigh West Virginia 54081 11223 168
1845747 1845747 2021-10-23 Randolph West Virginia 54083 5025 47
1845748 1845748 2021-10-23 Ritchie West Virginia 54085 1452 18
1845749 1845749 2021-10-23 Roane West Virginia 54087 1465 18
1845750 1845750 2021-10-23 Summers West Virginia 54089 1402 30
1845751 1845751 2021-10-23 Taylor West Virginia 54091 2197 38
1845752 1845752 2021-10-23 Tucker West Virginia 54093 1080 25
1845753 1845753 2021-10-23 Tyler West Virginia 54095 1352 18
1845754 1845754 2021-10-23 Upshur West Virginia 54097 3917 62
1845755 1845755 2021-10-23 Wayne West Virginia 54099 5589 76
1845756 1845756 2021-10-23 Webster West Virginia 54101 1134 17
1845757 1845757 2021-10-23 Wetzel West Virginia 54103 2522 50
1845758 1845758 2021-10-23 Wirt West Virginia 54105 835 13
1845759 1845759 2021-10-23 Wood West Virginia 54107 12935 240
1845760 1845760 2021-10-23 Wyoming West Virginia 54109 3583 59
1842456 1842456 2021-10-22 Barbour West Virginia 54001 2635 44
1842457 1842457 2021-10-22 Berkeley West Virginia 54003 18283 178
1842458 1842458 2021-10-22 Boone West Virginia 54005 3502 52
1842459 1842459 2021-10-22 Braxton West Virginia 54007 2108 18
1842460 1842460 2021-10-22 Brooke West Virginia 54009 3019 71
1842461 1842461 2021-10-22 Cabell West Virginia 54011 14760 261
1842462 1842462 2021-10-22 Calhoun West Virginia 54013 908 4
1842463 1842463 2021-10-22 Clay West Virginia 54015 1206 19
1842464 1842464 2021-10-22 Doddridge West Virginia 54017 1200 10
1842465 1842465 2021-10-22 Fayette West Virginia 54019 6049 120
1842466 1842466 2021-10-22 Gilmer West Virginia 54021 1341 9
1842467 1842467 2021-10-22 Grant West Virginia 54023 2124 33
1842468 1842468 2021-10-22 Greenbrier West Virginia 54025 4833 90
1842469 1842469 2021-10-22 Hampshire West Virginia 54027 3142 47
1842470 1842470 2021-10-22 Hancock West Virginia 54029 4126 112
1842471 1842471 2021-10-22 Hardy West Virginia 54031 2370 29
1842472 1842472 2021-10-22 Harrison West Virginia 54033 10939 140
1842473 1842473 2021-10-22 Jackson West Virginia 54035 3886 83
1842474 1842474 2021-10-22 Jefferson West Virginia 54037 6714 84
1842475 1842475 2021-10-22 Kanawha West Virginia 54039 24182 467
1842476 1842476 2021-10-22 Lewis West Virginia 54041 2973 50
1842477 1842477 2021-10-22 Lincoln West Virginia 54043 2734 42
1842478 1842478 2021-10-22 Logan West Virginia 54045 5256 134
1842479 1842479 2021-10-22 Marion West Virginia 54049 7935 101
1842480 1842480 2021-10-22 Marshall West Virginia 54051 5237 110
1842481 1842481 2021-10-22 Mason West Virginia 54053 3586 53
1842482 1842482 2021-10-22 McDowell West Virginia 54047 2870 47
1842483 1842483 2021-10-22 Mercer West Virginia 54055 8543 174
1842484 1842484 2021-10-22 Mineral West Virginia 54057 4544 111
1842485 1842485 2021-10-22 Mingo West Virginia 54059 4531 79
1842486 1842486 2021-10-22 Monongalia West Virginia 54061 12892 134
1842487 1842487 2021-10-22 Monroe West Virginia 54063 2067 25
1842488 1842488 2021-10-22 Morgan West Virginia 54065 2073 41
1842489 1842489 2021-10-22 Nicholas West Virginia 54067 3580 44
1842490 1842490 2021-10-22 Ohio West Virginia 54069 6037 103
1842491 1842491 2021-10-22 Pendleton West Virginia 54071 1087 14
1842492 1842492 2021-10-22 Pleasants West Virginia 54073 1394 30
1842493 1842493 2021-10-22 Pocahontas West Virginia 54075 1136 18
1842494 1842494 2021-10-22 Preston West Virginia 54077 5061 82
1842495 1842495 2021-10-22 Putnam West Virginia 54079 8634 121
1842496 1842496 2021-10-22 Raleigh West Virginia 54081 11177 168
1842497 1842497 2021-10-22 Randolph West Virginia 54083 5015 47
1842498 1842498 2021-10-22 Ritchie West Virginia 54085 1449 18
1842499 1842499 2021-10-22 Roane West Virginia 54087 1458 18
1842500 1842500 2021-10-22 Summers West Virginia 54089 1398 30

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);