johns_hopkins_csse_daily_reports

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

32,001 rows where province_or_state = "West Virginia" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

province_or_state

  • West Virginia · 32,001 ✖

country_or_region

  • US 32,001
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
35752 35752 2021-10-23 US West Virginia Barbour 54001 2648 44 0   39.1307219 -80.00350858 2021-10-24 04:21:22 Barbour, West Virginia, US
35753 35753 2021-10-23 US West Virginia Berkeley 54003 18338 178 0   39.46704621 -78.02414609 2021-10-24 04:21:22 Berkeley, West Virginia, US
35754 35754 2021-10-23 US West Virginia Boone 54005 3516 52 0   38.01974191 -81.69888019 2021-10-24 04:21:22 Boone, West Virginia, US
35755 35755 2021-10-23 US West Virginia Braxton 54007 2113 18 0   38.70036159 -80.72011184 2021-10-24 04:21:22 Braxton, West Virginia, US
35756 35756 2021-10-23 US West Virginia Brooke 54009 3024 71 0   40.27367263 -80.57915332 2021-10-24 04:21:22 Brooke, West Virginia, US
35757 35757 2021-10-23 US West Virginia Cabell 54011 14799 261 0   38.42424062 -82.23855912 2021-10-24 04:21:22 Cabell, West Virginia, US
35758 35758 2021-10-23 US West Virginia Calhoun 54013 916 4 0   38.84315422 -81.11934872 2021-10-24 04:21:22 Calhoun, West Virginia, US
35759 35759 2021-10-23 US West Virginia Clay 54015 1211 19 0   38.46231092 -81.07652217 2021-10-24 04:21:22 Clay, West Virginia, US
35760 35760 2021-10-23 US West Virginia Doddridge 54017 1201 10 0   39.27057157 -80.70671527 2021-10-24 04:21:22 Doddridge, West Virginia, US
35761 35761 2021-10-23 US West Virginia Fayette 54019 6068 120 0   38.02974928 -81.08286634 2021-10-24 04:21:22 Fayette, West Virginia, US
35762 35762 2021-10-23 US West Virginia Gilmer 54021 1344 9 0   38.9251277 -80.85952723 2021-10-24 04:21:22 Gilmer, West Virginia, US
35763 35763 2021-10-23 US West Virginia Grant 54023 2130 33 0   39.10314817 -79.19440518 2021-10-24 04:21:22 Grant, West Virginia, US
35764 35764 2021-10-23 US West Virginia Greenbrier 54025 4850 90 0   37.9463652 -80.45335881 2021-10-24 04:21:22 Greenbrier, West Virginia, US
35765 35765 2021-10-23 US West Virginia Hampshire 54027 3150 47 0   39.32103553 -78.60826476 2021-10-24 04:21:22 Hampshire, West Virginia, US
35766 35766 2021-10-23 US West Virginia Hancock 54029 4135 112 0   40.51943859 -80.57461608 2021-10-24 04:21:22 Hancock, West Virginia, US
35767 35767 2021-10-23 US West Virginia Hardy 54031 2377 29 0   39.00683177 -78.85855301 2021-10-24 04:21:22 Hardy, West Virginia, US
35768 35768 2021-10-23 US West Virginia Harrison 54033 10993 140 0   39.2853852 -80.37919577 2021-10-24 04:21:22 Harrison, West Virginia, US
35769 35769 2021-10-23 US West Virginia Jackson 54035 3906 83 0   38.84263974 -81.68148753 2021-10-24 04:21:22 Jackson, West Virginia, US
35770 35770 2021-10-23 US West Virginia Jefferson 54037 6728 84 0   39.30776166 -77.86014147 2021-10-24 04:21:22 Jefferson, West Virginia, US
35771 35771 2021-10-23 US West Virginia Kanawha 54039 24264 467 0   38.33860077 -81.52857054 2021-10-24 04:21:22 Kanawha, West Virginia, US
35772 35772 2021-10-23 US West Virginia Lewis 54041 2990 50 0   38.9947249 -80.49988181 2021-10-24 04:21:22 Lewis, West Virginia, US
35773 35773 2021-10-23 US West Virginia Lincoln 54043 2751 42 0   38.172154 -82.07017953 2021-10-24 04:21:22 Lincoln, West Virginia, US
35774 35774 2021-10-23 US West Virginia Logan 54045 5267 134 0   37.8299889 -81.93528571 2021-10-24 04:21:22 Logan, West Virginia, US
35775 35775 2021-10-23 US West Virginia Marion 54049 7964 101 0   39.50984542 -80.24244659 2021-10-24 04:21:22 Marion, West Virginia, US
35776 35776 2021-10-23 US West Virginia Marshall 54051 5249 110 0   39.86064362 -80.66591062 2021-10-24 04:21:22 Marshall, West Virginia, US
35777 35777 2021-10-23 US West Virginia Mason 54053 3587 53 0   38.77071799 -82.02524219 2021-10-24 04:21:22 Mason, West Virginia, US
35778 35778 2021-10-23 US West Virginia McDowell 54047 2879 47 0   37.38002939 -81.65083669 2021-10-24 04:21:22 McDowell, West Virginia, US
35779 35779 2021-10-23 US West Virginia Mercer 54055 8563 174 0   37.40481169 -81.11023142 2021-10-24 04:21:22 Mercer, West Virginia, US
35780 35780 2021-10-23 US West Virginia Mineral 54057 4557 111 0   39.41561583 -78.94104895 2021-10-24 04:21:22 Mineral, West Virginia, US
35781 35781 2021-10-23 US West Virginia Mingo 54059 4549 79 0   37.73048351 -82.13338365 2021-10-24 04:21:22 Mingo, West Virginia, US
35782 35782 2021-10-23 US West Virginia Monongalia 54061 12961 134 0   39.63218457 -80.04766838 2021-10-24 04:21:22 Monongalia, West Virginia, US
35783 35783 2021-10-23 US West Virginia Monroe 54063 2069 25 0   37.56274716 -80.54577965 2021-10-24 04:21:22 Monroe, West Virginia, US
35784 35784 2021-10-23 US West Virginia Morgan 54065 2075 41 0   39.55439028 -78.26311676 2021-10-24 04:21:22 Morgan, West Virginia, US
35785 35785 2021-10-23 US West Virginia Nicholas 54067 3599 44 0   38.29617706 -80.79759588 2021-10-24 04:21:22 Nicholas, West Virginia, US
35786 35786 2021-10-23 US West Virginia Ohio 54069 6041 103 0   40.0955451 -80.62203992 2021-10-24 04:21:22 Ohio, West Virginia, US
35787 35787 2021-10-23 US West Virginia Pendleton 54071 1088 14 0   38.68314479 -79.35084086 2021-10-24 04:21:22 Pendleton, West Virginia, US
35788 35788 2021-10-23 US West Virginia Pleasants 54073 1393 30 0   39.37091679 -81.16771771 2021-10-24 04:21:22 Pleasants, West Virginia, US
35789 35789 2021-10-23 US West Virginia Pocahontas 54075 1134 18 0   38.32758728 -80.00993811 2021-10-24 04:21:22 Pocahontas, West Virginia, US
35790 35790 2021-10-23 US West Virginia Preston 54077 5090 82 0   39.46770987 -79.66712803 2021-10-24 04:21:22 Preston, West Virginia, US
35791 35791 2021-10-23 US West Virginia Putnam 54079 8651 121 0   38.50782345 -81.9082131 2021-10-24 04:21:22 Putnam, West Virginia, US
35792 35792 2021-10-23 US West Virginia Raleigh 54081 11223 168 0   37.76936795 -81.2456041 2021-10-24 04:21:22 Raleigh, West Virginia, US
35793 35793 2021-10-23 US West Virginia Randolph 54083 5025 47 0   38.769899 -79.87919615 2021-10-24 04:21:22 Randolph, West Virginia, US
35794 35794 2021-10-23 US West Virginia Ritchie 54085 1452 18 0   39.18094587 -81.06356878 2021-10-24 04:21:22 Ritchie, West Virginia, US
35795 35795 2021-10-23 US West Virginia Roane 54087 1465 18 0   38.71622686 -81.35243568 2021-10-24 04:21:22 Roane, West Virginia, US
35796 35796 2021-10-23 US West Virginia Summers 54089 1402 30 0   37.65390597 -80.86009693 2021-10-24 04:21:22 Summers, West Virginia, US
35797 35797 2021-10-23 US West Virginia Taylor 54091 2197 38 0   39.33602617 -80.0421439 2021-10-24 04:21:22 Taylor, West Virginia, US
35798 35798 2021-10-23 US West Virginia Tucker 54093 1080 25 0   39.11240885 -79.57053576 2021-10-24 04:21:22 Tucker, West Virginia, US
35799 35799 2021-10-23 US West Virginia Tyler 54095 1352 18 0   39.46811972 -80.88772676 2021-10-24 04:21:22 Tyler, West Virginia, US
35800 35800 2021-10-23 US West Virginia Unassigned 90054 0 0 0   40.51943859 -82.42287994 2021-07-31 23:21:38 Unassigned, West Virginia, US
35801 35801 2021-10-23 US West Virginia Upshur 54097 3917 62 0   38.89285061 -80.23689136 2021-10-24 04:21:22 Upshur, West Virginia, US
35802 35802 2021-10-23 US West Virginia Wayne 54099 5589 76 0   38.14901357 -82.42287994 2021-10-24 04:21:22 Wayne, West Virginia, US
35803 35803 2021-10-23 US West Virginia Webster 54101 1134 17 0   38.49370949 -80.4202023 2021-10-24 04:21:22 Webster, West Virginia, US
35804 35804 2021-10-23 US West Virginia Wetzel 54103 2522 50 0   39.6065771 -80.64016540000001 2021-10-24 04:21:22 Wetzel, West Virginia, US
35805 35805 2021-10-23 US West Virginia Wirt 54105 835 13 0   39.02775007 -81.37473928 2021-10-24 04:21:22 Wirt, West Virginia, US
35806 35806 2021-10-23 US West Virginia Wood 54107 12935 240 0   39.20967886 -81.5162836 2021-10-24 04:21:22 Wood, West Virginia, US
35807 35807 2021-10-23 US West Virginia Wyoming 54109 3583 59 0   37.612327 -81.54511071 2021-10-24 04:21:22 Wyoming, West Virginia, US
316236 316236 2021-10-22 US West Virginia Barbour 54001 2635 44 0   39.1307219 -80.00350858 2021-10-23 04:21:32 Barbour, West Virginia, US
316237 316237 2021-10-22 US West Virginia Berkeley 54003 18283 178 0   39.46704621 -78.02414609 2021-10-23 04:21:32 Berkeley, West Virginia, US
316238 316238 2021-10-22 US West Virginia Boone 54005 3502 52 0   38.01974191 -81.69888019 2021-10-23 04:21:32 Boone, West Virginia, US
316239 316239 2021-10-22 US West Virginia Braxton 54007 2108 18 0   38.70036159 -80.72011184 2021-10-23 04:21:32 Braxton, West Virginia, US
316240 316240 2021-10-22 US West Virginia Brooke 54009 3019 71 0   40.27367263 -80.57915332 2021-10-23 04:21:32 Brooke, West Virginia, US
316241 316241 2021-10-22 US West Virginia Cabell 54011 14760 261 0   38.42424062 -82.23855912 2021-10-23 04:21:32 Cabell, West Virginia, US
316242 316242 2021-10-22 US West Virginia Calhoun 54013 908 4 0   38.84315422 -81.11934872 2021-10-23 04:21:32 Calhoun, West Virginia, US
316243 316243 2021-10-22 US West Virginia Clay 54015 1206 19 0   38.46231092 -81.07652217 2021-10-23 04:21:32 Clay, West Virginia, US
316244 316244 2021-10-22 US West Virginia Doddridge 54017 1200 10 0   39.27057157 -80.70671527 2021-10-23 04:21:32 Doddridge, West Virginia, US
316245 316245 2021-10-22 US West Virginia Fayette 54019 6049 120 0   38.02974928 -81.08286634 2021-10-23 04:21:32 Fayette, West Virginia, US
316246 316246 2021-10-22 US West Virginia Gilmer 54021 1341 9 0   38.9251277 -80.85952723 2021-10-23 04:21:32 Gilmer, West Virginia, US
316247 316247 2021-10-22 US West Virginia Grant 54023 2124 33 0   39.10314817 -79.19440518 2021-10-23 04:21:32 Grant, West Virginia, US
316248 316248 2021-10-22 US West Virginia Greenbrier 54025 4833 90 0   37.9463652 -80.45335881 2021-10-23 04:21:32 Greenbrier, West Virginia, US
316249 316249 2021-10-22 US West Virginia Hampshire 54027 3142 47 0   39.32103553 -78.60826476 2021-10-23 04:21:32 Hampshire, West Virginia, US
316250 316250 2021-10-22 US West Virginia Hancock 54029 4126 112 0   40.51943859 -80.57461608 2021-10-23 04:21:32 Hancock, West Virginia, US
316251 316251 2021-10-22 US West Virginia Hardy 54031 2370 29 0   39.00683177 -78.85855301 2021-10-23 04:21:32 Hardy, West Virginia, US
316252 316252 2021-10-22 US West Virginia Harrison 54033 10939 140 0   39.2853852 -80.37919577 2021-10-23 04:21:32 Harrison, West Virginia, US
316253 316253 2021-10-22 US West Virginia Jackson 54035 3886 83 0   38.84263974 -81.68148753 2021-10-23 04:21:32 Jackson, West Virginia, US
316254 316254 2021-10-22 US West Virginia Jefferson 54037 6714 84 0   39.30776166 -77.86014147 2021-10-23 04:21:32 Jefferson, West Virginia, US
316255 316255 2021-10-22 US West Virginia Kanawha 54039 24182 467 0   38.33860077 -81.52857054 2021-10-23 04:21:32 Kanawha, West Virginia, US
316256 316256 2021-10-22 US West Virginia Lewis 54041 2973 50 0   38.9947249 -80.49988181 2021-10-23 04:21:32 Lewis, West Virginia, US
316257 316257 2021-10-22 US West Virginia Lincoln 54043 2734 42 0   38.172154 -82.07017953 2021-10-23 04:21:32 Lincoln, West Virginia, US
316258 316258 2021-10-22 US West Virginia Logan 54045 5256 134 0   37.8299889 -81.93528571 2021-10-23 04:21:32 Logan, West Virginia, US
316259 316259 2021-10-22 US West Virginia Marion 54049 7935 101 0   39.50984542 -80.24244659 2021-10-23 04:21:32 Marion, West Virginia, US
316260 316260 2021-10-22 US West Virginia Marshall 54051 5237 110 0   39.86064362 -80.66591062 2021-10-23 04:21:32 Marshall, West Virginia, US
316261 316261 2021-10-22 US West Virginia Mason 54053 3586 53 0   38.77071799 -82.02524219 2021-10-23 04:21:32 Mason, West Virginia, US
316262 316262 2021-10-22 US West Virginia McDowell 54047 2870 47 0   37.38002939 -81.65083669 2021-10-23 04:21:32 McDowell, West Virginia, US
316263 316263 2021-10-22 US West Virginia Mercer 54055 8543 174 0   37.40481169 -81.11023142 2021-10-23 04:21:32 Mercer, West Virginia, US
316264 316264 2021-10-22 US West Virginia Mineral 54057 4544 111 0   39.41561583 -78.94104895 2021-10-23 04:21:32 Mineral, West Virginia, US
316265 316265 2021-10-22 US West Virginia Mingo 54059 4531 79 0   37.73048351 -82.13338365 2021-10-23 04:21:32 Mingo, West Virginia, US
316266 316266 2021-10-22 US West Virginia Monongalia 54061 12892 134 0   39.63218457 -80.04766838 2021-10-23 04:21:32 Monongalia, West Virginia, US
316267 316267 2021-10-22 US West Virginia Monroe 54063 2067 25 0   37.56274716 -80.54577965 2021-10-23 04:21:32 Monroe, West Virginia, US
316268 316268 2021-10-22 US West Virginia Morgan 54065 2073 41 0   39.55439028 -78.26311676 2021-10-23 04:21:32 Morgan, West Virginia, US
316269 316269 2021-10-22 US West Virginia Nicholas 54067 3580 44 0   38.29617706 -80.79759588 2021-10-23 04:21:32 Nicholas, West Virginia, US
316270 316270 2021-10-22 US West Virginia Ohio 54069 6037 103 0   40.0955451 -80.62203992 2021-10-23 04:21:32 Ohio, West Virginia, US
316271 316271 2021-10-22 US West Virginia Pendleton 54071 1087 14 0   38.68314479 -79.35084086 2021-10-23 04:21:32 Pendleton, West Virginia, US
316272 316272 2021-10-22 US West Virginia Pleasants 54073 1394 30 0   39.37091679 -81.16771771 2021-10-23 04:21:32 Pleasants, West Virginia, US
316273 316273 2021-10-22 US West Virginia Pocahontas 54075 1136 18 0   38.32758728 -80.00993811 2021-10-23 04:21:32 Pocahontas, West Virginia, US
316274 316274 2021-10-22 US West Virginia Preston 54077 5061 82 0   39.46770987 -79.66712803 2021-10-23 04:21:32 Preston, West Virginia, US
316275 316275 2021-10-22 US West Virginia Putnam 54079 8634 121 0   38.50782345 -81.9082131 2021-10-23 04:21:32 Putnam, West Virginia, US
316276 316276 2021-10-22 US West Virginia Raleigh 54081 11177 168 0   37.76936795 -81.2456041 2021-10-23 04:21:32 Raleigh, West Virginia, US
316277 316277 2021-10-22 US West Virginia Randolph 54083 5015 47 0   38.769899 -79.87919615 2021-10-23 04:21:32 Randolph, West Virginia, US
316278 316278 2021-10-22 US West Virginia Ritchie 54085 1449 18 0   39.18094587 -81.06356878 2021-10-23 04:21:32 Ritchie, West Virginia, US
316279 316279 2021-10-22 US West Virginia Roane 54087 1458 18 0   38.71622686 -81.35243568 2021-10-23 04:21:32 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]);