⚠️ 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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

19,009 rows where province_or_state = "West Virginia" sorted by day descending

View and edit SQL

province_or_state

  • West Virginia · 19,009

country_or_region

  • US 19,009
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
956783 2021-03-05 US West Virginia Barbour 54001 1240 21 0 1219 39.1307219 -80.00350858 2021-03-06 04:23:41 Barbour, West Virginia, US
956784 2021-03-05 US West Virginia Berkeley 54003 9751 100 0 9651 39.46704621 -78.02414609 2021-03-06 04:23:41 Berkeley, West Virginia, US
956785 2021-03-05 US West Virginia Boone 54005 1599 32 0 1567 38.01974191 -81.69888019 2021-03-06 04:23:41 Boone, West Virginia, US
956786 2021-03-05 US West Virginia Braxton 54007 780 1 0 779 38.70036159 -80.72011184 2021-03-06 04:23:41 Braxton, West Virginia, US
956787 2021-03-05 US West Virginia Brooke 54009 2021 50 0 1971 40.27367263 -80.57915332 2021-03-06 04:23:41 Brooke, West Virginia, US
956788 2021-03-05 US West Virginia Cabell 54011 7880 160 0 7720 38.42424062 -82.23855912 2021-03-06 04:23:41 Cabell, West Virginia, US
956789 2021-03-05 US West Virginia Calhoun 54013 231 0 0 231 38.84315422 -81.11934872 2021-03-06 04:23:41 Calhoun, West Virginia, US
956790 2021-03-05 US West Virginia Clay 54015 382 5 0 377 38.46231092 -81.07652217 2021-03-06 04:23:41 Clay, West Virginia, US
956791 2021-03-05 US West Virginia Doddridge 54017 469 6 0 463 39.27057157 -80.70671527 2021-03-06 04:23:41 Doddridge, West Virginia, US
956792 2021-03-05 US West Virginia Fayette 54019 2710 70 0 2640 38.02974928 -81.08286634 2021-03-06 04:23:41 Fayette, West Virginia, US
956793 2021-03-05 US West Virginia Gilmer 54021 720 8 0 712 38.9251277 -80.85952723 2021-03-06 04:23:41 Gilmer, West Virginia, US
956794 2021-03-05 US West Virginia Grant 54023 1081 26 0 1055 39.10314817 -79.19440518 2021-03-06 04:23:41 Grant, West Virginia, US
956795 2021-03-05 US West Virginia Greenbrier 54025 2422 52 0 2370 37.9463652 -80.45335881 2021-03-06 04:23:41 Greenbrier, West Virginia, US
956796 2021-03-05 US West Virginia Hampshire 54027 1551 28 0 1523 39.32103553 -78.60826476 2021-03-06 04:23:41 Hampshire, West Virginia, US
956797 2021-03-05 US West Virginia Hancock 54029 2603 86 0 2517 40.51943859 -80.57461608 2021-03-06 04:23:41 Hancock, West Virginia, US
956798 2021-03-05 US West Virginia Hardy 54031 1277 20 0 1257 39.00683177 -78.85855301 2021-03-06 04:23:41 Hardy, West Virginia, US
956799 2021-03-05 US West Virginia Harrison 54033 4866 70 0 4796 39.2853852 -80.37919577 2021-03-06 04:23:41 Harrison, West Virginia, US
956800 2021-03-05 US West Virginia Jackson 54035 1674 50 0 1624 38.84263974 -81.68148753 2021-03-06 04:23:41 Jackson, West Virginia, US
956801 2021-03-05 US West Virginia Jefferson 54037 3666 39 0 3627 39.30776166 -77.86014147 2021-03-06 04:23:41 Jefferson, West Virginia, US
956802 2021-03-05 US West Virginia Kanawha 54039 12201 286 0 11915 38.33860077 -81.52857054 2021-03-06 04:23:41 Kanawha, West Virginia, US
956803 2021-03-05 US West Virginia Lewis 54041 1050 18 0 1032 38.9947249 -80.49988181 2021-03-06 04:23:41 Lewis, West Virginia, US
956804 2021-03-05 US West Virginia Lincoln 54043 1236 13 0 1223 38.172154 -82.07017953 2021-03-06 04:23:41 Lincoln, West Virginia, US
956805 2021-03-05 US West Virginia Logan 54045 2722 77 0 2645 37.8299889 -81.93528571 2021-03-06 04:23:41 Logan, West Virginia, US
956806 2021-03-05 US West Virginia Marion 54049 3705 34 0 3671 39.50984542 -80.24244659 2021-03-06 04:23:41 Marion, West Virginia, US
956807 2021-03-05 US West Virginia Marshall 54051 3029 66 0 2963 39.86064362 -80.66591062 2021-03-06 04:23:41 Marshall, West Virginia, US
956808 2021-03-05 US West Virginia Mason 54053 1780 37 0 1743 38.77071799 -82.02524219 2021-03-06 04:23:41 Mason, West Virginia, US
956809 2021-03-05 US West Virginia McDowell 54047 1361 20 0 1341 37.38002939 -81.65083669 2021-03-06 04:23:41 McDowell, West Virginia, US
956810 2021-03-05 US West Virginia Mercer 54055 4241 112 0 4129 37.40481169 -81.11023142 2021-03-06 04:23:41 Mercer, West Virginia, US
956811 2021-03-05 US West Virginia Mineral 54057 2595 77 0 2518 39.41561583 -78.94104895 2021-03-06 04:23:41 Mineral, West Virginia, US
956812 2021-03-05 US West Virginia Mingo 54059 2143 34 0 2109 37.73048351 -82.13338365 2021-03-06 04:23:41 Mingo, West Virginia, US
956813 2021-03-05 US West Virginia Monongalia 54061 8129 71 0 8058 39.63218457 -80.04766838 2021-03-06 04:23:41 Monongalia, West Virginia, US
956814 2021-03-05 US West Virginia Monroe 54063 956 14 0 942 37.56274716 -80.54577965 2021-03-06 04:23:41 Monroe, West Virginia, US
956815 2021-03-05 US West Virginia Morgan 54065 936 13 0 923 39.55439028 -78.26311676 2021-03-06 04:23:41 Morgan, West Virginia, US
956816 2021-03-05 US West Virginia Nicholas 54067 1192 12 0 1180 38.29617706 -80.79759588 2021-03-06 04:23:41 Nicholas, West Virginia, US
956817 2021-03-05 US West Virginia Ohio 54069 3666 67 0 3599 40.0955451 -80.62203992 2021-03-06 04:23:41 Ohio, West Virginia, US
956818 2021-03-05 US West Virginia Pendleton 54071 622 5 0 617 38.68314479 -79.35084086 2021-03-06 04:23:41 Pendleton, West Virginia, US
956819 2021-03-05 US West Virginia Pleasants 54073 802 17 0 785 39.37091679 -81.16771771 2021-03-06 04:23:41 Pleasants, West Virginia, US
956820 2021-03-05 US West Virginia Pocahontas 54075 596 9 0 587 38.32758728 -80.00993811 2021-03-06 04:23:41 Pocahontas, West Virginia, US
956821 2021-03-05 US West Virginia Preston 54077 2561 43 0 2518 39.46770987 -79.66712803 2021-03-06 04:23:41 Preston, West Virginia, US
956822 2021-03-05 US West Virginia Putnam 54079 4253 74 0 4179 38.50782345 -81.9082131 2021-03-06 04:23:41 Putnam, West Virginia, US
956823 2021-03-05 US West Virginia Raleigh 54081 4797 59 0 4738 37.76936795 -81.2456041 2021-03-06 04:23:41 Raleigh, West Virginia, US
956824 2021-03-05 US West Virginia Randolph 54083 2409 10 0 2399 38.769899 -79.87919615 2021-03-06 04:23:41 Randolph, West Virginia, US
956825 2021-03-05 US West Virginia Ritchie 54085 625 9 0 616 39.18094587 -81.06356878 2021-03-06 04:23:41 Ritchie, West Virginia, US
956826 2021-03-05 US West Virginia Roane 54087 500 7 0 493 38.71622686 -81.35243568 2021-03-06 04:23:41 Roane, West Virginia, US
956827 2021-03-05 US West Virginia Summers 54089 707 23 0 684 37.65390597 -80.86009693 2021-03-06 04:23:41 Summers, West Virginia, US
956828 2021-03-05 US West Virginia Taylor 54091 1095 21 0 1074 39.33602617 -80.0421439 2021-03-06 04:23:41 Taylor, West Virginia, US
956829 2021-03-05 US West Virginia Tucker 54093 507 9 0 498 39.11240885 -79.57053576 2021-03-06 04:23:41 Tucker, West Virginia, US
956830 2021-03-05 US West Virginia Tyler 54095 619 4 0 615 39.46811972 -80.88772676 2021-03-06 04:23:41 Tyler, West Virginia, US
956831 2021-03-05 US West Virginia Unassigned 90054 0 0 0 0 40.51943859 -82.42287994 2021-03-06 04:23:41 Unassigned, West Virginia, US
956832 2021-03-05 US West Virginia Upshur 54097 1707 30 0 1677 38.89285061 -80.23689136 2021-03-06 04:23:41 Upshur, West Virginia, US
956833 2021-03-05 US West Virginia Wayne 54099 2634 31 0 2603 38.14901357 -82.42287994 2021-03-06 04:23:41 Wayne, West Virginia, US
956834 2021-03-05 US West Virginia Webster 54101 325 4 0 321 38.49370949 -80.4202023 2021-03-06 04:23:41 Webster, West Virginia, US
956835 2021-03-05 US West Virginia Wetzel 54103 1100 19 0 1081 39.6065771 -80.64016540000001 2021-03-06 04:23:41 Wetzel, West Virginia, US
956836 2021-03-05 US West Virginia Wirt 54105 360 2 0 358 39.02775007 -81.37473928 2021-03-06 04:23:41 Wirt, West Virginia, US
956837 2021-03-05 US West Virginia Wood 54107 7129 132 0 6997 39.20967886 -81.5162836 2021-03-06 04:23:41 Wood, West Virginia, US
956838 2021-03-05 US West Virginia Wyoming 54109 1751 35 0 1716 37.612327 -81.54511071 2021-03-06 04:23:41 Wyoming, West Virginia, US
904143 2021-03-04 US West Virginia Barbour 54001 1234 21 0 1213 39.1307219 -80.00350858 2021-03-05 05:26:29 Barbour, West Virginia, US
904144 2021-03-04 US West Virginia Berkeley 54003 9741 100 0 9641 39.46704621 -78.02414609 2021-03-05 05:26:29 Berkeley, West Virginia, US
904145 2021-03-04 US West Virginia Boone 54005 1595 32 0 1563 38.01974191 -81.69888019 2021-03-05 05:26:29 Boone, West Virginia, US
904146 2021-03-04 US West Virginia Braxton 54007 781 1 0 780 38.70036159 -80.72011184 2021-03-05 05:26:29 Braxton, West Virginia, US
904147 2021-03-04 US West Virginia Brooke 54009 2016 50 0 1966 40.27367263 -80.57915332 2021-03-05 05:26:29 Brooke, West Virginia, US
904148 2021-03-04 US West Virginia Cabell 54011 7861 160 0 7701 38.42424062 -82.23855912 2021-03-05 05:26:29 Cabell, West Virginia, US
904149 2021-03-04 US West Virginia Calhoun 54013 231 0 0 231 38.84315422 -81.11934872 2021-03-05 05:26:29 Calhoun, West Virginia, US
904150 2021-03-04 US West Virginia Clay 54015 379 5 0 374 38.46231092 -81.07652217 2021-03-05 05:26:29 Clay, West Virginia, US
904151 2021-03-04 US West Virginia Doddridge 54017 468 6 0 462 39.27057157 -80.70671527 2021-03-05 05:26:29 Doddridge, West Virginia, US
904152 2021-03-04 US West Virginia Fayette 54019 2692 70 0 2622 38.02974928 -81.08286634 2021-03-05 05:26:29 Fayette, West Virginia, US
904153 2021-03-04 US West Virginia Gilmer 54021 718 8 0 710 38.9251277 -80.85952723 2021-03-05 05:26:29 Gilmer, West Virginia, US
904154 2021-03-04 US West Virginia Grant 54023 1077 26 0 1051 39.10314817 -79.19440518 2021-03-05 05:26:29 Grant, West Virginia, US
904155 2021-03-04 US West Virginia Greenbrier 54025 2416 52 0 2364 37.9463652 -80.45335881 2021-03-05 05:26:29 Greenbrier, West Virginia, US
904156 2021-03-04 US West Virginia Hampshire 54027 1548 28 0 1520 39.32103553 -78.60826476 2021-03-05 05:26:29 Hampshire, West Virginia, US
904157 2021-03-04 US West Virginia Hancock 54029 2601 86 0 2515 40.51943859 -80.57461608 2021-03-05 05:26:29 Hancock, West Virginia, US
904158 2021-03-04 US West Virginia Hardy 54031 1274 20 0 1254 39.00683177 -78.85855301 2021-03-05 05:26:29 Hardy, West Virginia, US
904159 2021-03-04 US West Virginia Harrison 54033 4862 70 0 4792 39.2853852 -80.37919577 2021-03-05 05:26:29 Harrison, West Virginia, US
904160 2021-03-04 US West Virginia Jackson 54035 1673 50 0 1623 38.84263974 -81.68148753 2021-03-05 05:26:29 Jackson, West Virginia, US
904161 2021-03-04 US West Virginia Jefferson 54037 3656 37 0 3619 39.30776166 -77.86014147 2021-03-05 05:26:29 Jefferson, West Virginia, US
904162 2021-03-04 US West Virginia Kanawha 54039 12176 286 0 11890 38.33860077 -81.52857054 2021-03-05 05:26:29 Kanawha, West Virginia, US
904163 2021-03-04 US West Virginia Lewis 54041 1048 18 0 1030 38.9947249 -80.49988181 2021-03-05 05:26:29 Lewis, West Virginia, US
904164 2021-03-04 US West Virginia Lincoln 54043 1233 13 0 1220 38.172154 -82.07017953 2021-03-05 05:26:29 Lincoln, West Virginia, US
904165 2021-03-04 US West Virginia Logan 54045 2711 76 0 2635 37.8299889 -81.93528571 2021-03-05 05:26:29 Logan, West Virginia, US
904166 2021-03-04 US West Virginia Marion 54049 3696 34 0 3662 39.50984542 -80.24244659 2021-03-05 05:26:29 Marion, West Virginia, US
904167 2021-03-04 US West Virginia Marshall 54051 3025 66 0 2959 39.86064362 -80.66591062 2021-03-05 05:26:29 Marshall, West Virginia, US
904168 2021-03-04 US West Virginia Mason 54053 1778 37 0 1741 38.77071799 -82.02524219 2021-03-05 05:26:29 Mason, West Virginia, US
904169 2021-03-04 US West Virginia McDowell 54047 1354 20 0 1334 37.38002939 -81.65083669 2021-03-05 05:26:29 McDowell, West Virginia, US
904170 2021-03-04 US West Virginia Mercer 54055 4232 112 0 4120 37.40481169 -81.11023142 2021-03-05 05:26:29 Mercer, West Virginia, US
904171 2021-03-04 US West Virginia Mineral 54057 2594 77 0 2517 39.41561583 -78.94104895 2021-03-05 05:26:29 Mineral, West Virginia, US
904172 2021-03-04 US West Virginia Mingo 54059 2140 34 0 2106 37.73048351 -82.13338365 2021-03-05 05:26:29 Mingo, West Virginia, US
904173 2021-03-04 US West Virginia Monongalia 54061 8106 71 0 8035 39.63218457 -80.04766838 2021-03-05 05:26:29 Monongalia, West Virginia, US
904174 2021-03-04 US West Virginia Monroe 54063 955 12 0 943 37.56274716 -80.54577965 2021-03-05 05:26:29 Monroe, West Virginia, US
904175 2021-03-04 US West Virginia Morgan 54065 934 13 0 921 39.55439028 -78.26311676 2021-03-05 05:26:29 Morgan, West Virginia, US
904176 2021-03-04 US West Virginia Nicholas 54067 1191 12 0 1179 38.29617706 -80.79759588 2021-03-05 05:26:29 Nicholas, West Virginia, US
904177 2021-03-04 US West Virginia Ohio 54069 3662 67 0 3595 40.0955451 -80.62203992 2021-03-05 05:26:29 Ohio, West Virginia, US
904178 2021-03-04 US West Virginia Pendleton 54071 622 5 0 617 38.68314479 -79.35084086 2021-03-05 05:26:29 Pendleton, West Virginia, US
904179 2021-03-04 US West Virginia Pleasants 54073 802 17 0 785 39.37091679 -81.16771771 2021-03-05 05:26:29 Pleasants, West Virginia, US
904180 2021-03-04 US West Virginia Pocahontas 54075 596 9 0 587 38.32758728 -80.00993811 2021-03-05 05:26:29 Pocahontas, West Virginia, US
904181 2021-03-04 US West Virginia Preston 54077 2553 43 0 2510 39.46770987 -79.66712803 2021-03-05 05:26:29 Preston, West Virginia, US
904182 2021-03-04 US West Virginia Putnam 54079 4243 74 0 4169 38.50782345 -81.9082131 2021-03-05 05:26:29 Putnam, West Virginia, US
904183 2021-03-04 US West Virginia Raleigh 54081 4776 58 0 4718 37.76936795 -81.2456041 2021-03-05 05:26:29 Raleigh, West Virginia, US
904184 2021-03-04 US West Virginia Randolph 54083 2403 10 0 2393 38.769899 -79.87919615 2021-03-05 05:26:29 Randolph, West Virginia, US
904185 2021-03-04 US West Virginia Ritchie 54085 624 9 0 615 39.18094587 -81.06356878 2021-03-05 05:26:29 Ritchie, West Virginia, US
904186 2021-03-04 US West Virginia Roane 54087 499 7 0 492 38.71622686 -81.35243568 2021-03-05 05:26:29 Roane, West Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);