johns_hopkins_csse_daily_reports

⚠️ 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

7,305 rows where province_or_state = "West Virginia" sorted by day descending

View and edit SQL

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

province_or_state

  • West Virginia · 7,305

country_or_region

  • US 7,305
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391222 2020-08-08 US West Virginia Barbour 54001 29 1 0 28 39.1307219 -80.00350858 2020-08-09 04:34:54 Barbour, West Virginia, US
391285 2020-08-08 US West Virginia Berkeley 54003 693 11 0 682 39.46704621 -78.02414609 2020-08-09 04:34:54 Berkeley, West Virginia, US
391331 2020-08-08 US West Virginia Boone 54005 100 0 0 100 38.01974191 -81.69888019 2020-08-09 04:34:54 Boone, West Virginia, US
391354 2020-08-08 US West Virginia Braxton 54007 8 0 0 8 38.70036159 -80.72011184 2020-08-09 04:34:54 Braxton, West Virginia, US
391368 2020-08-08 US West Virginia Brooke 54009 62 1 0 61 40.27367263 -80.57915332 2020-08-09 04:34:54 Brooke, West Virginia, US
391425 2020-08-08 US West Virginia Cabell 54011 389 3 0 386 38.42424062 -82.23855912 2020-08-09 04:34:54 Cabell, West Virginia, US
391448 2020-08-08 US West Virginia Calhoun 54013 6 0 0 6 38.84315422 -81.11934872 2020-08-09 04:34:54 Calhoun, West Virginia, US
391653 2020-08-08 US West Virginia Clay 54015 18 1 0 17 38.46231092 -81.07652217 2020-08-09 04:34:54 Clay, West Virginia, US
391893 2020-08-08 US West Virginia Doddridge 54017 6 0 0 6 39.27057157 -80.70671527 2020-08-09 04:34:54 Doddridge, West Virginia, US
392022 2020-08-08 US West Virginia Fayette 54019 144 7 0 137 38.02974928 -81.08286634 2020-08-09 04:34:54 Fayette, West Virginia, US
392144 2020-08-08 US West Virginia Gilmer 54021 16 0 0 16 38.9251277 -80.85952723 2020-08-09 04:34:54 Gilmer, West Virginia, US
392192 2020-08-08 US West Virginia Grant 54023 119 1 0 118 39.10314817 -79.19440518 2020-08-09 04:34:54 Grant, West Virginia, US
392208 2020-08-08 US West Virginia Greenbrier 54025 92 3 0 89 37.9463652 -80.45335881 2020-08-09 04:34:54 Greenbrier, West Virginia, US
392276 2020-08-08 US West Virginia Hampshire 54027 76 1 0 75 39.32103553 -78.60826476 2020-08-09 04:34:54 Hampshire, West Virginia, US
392288 2020-08-08 US West Virginia Hancock 54029 111 0 0 111 40.51943859 -80.57461608 2020-08-09 04:34:54 Hancock, West Virginia, US
392304 2020-08-08 US West Virginia Hardy 54031 58 0 0 58 39.00683177 -78.85855301 2020-08-09 04:34:54 Hardy, West Virginia, US
392322 2020-08-08 US West Virginia Harrison 54033 219 1 0 218 39.2853852 -80.37919577 2020-08-09 04:34:54 Harrison, West Virginia, US
392490 2020-08-08 US West Virginia Jackson 54035 162 19 0 143 38.84263974 -81.68148753 2020-08-09 04:34:54 Jackson, West Virginia, US
392529 2020-08-08 US West Virginia Jefferson 54037 294 4 0 290 39.30776166 -77.86014147 2020-08-09 04:34:54 Jefferson, West Virginia, US
392573 2020-08-08 US West Virginia Kanawha 54039 911 23 0 888 38.33860077 -81.52857054 2020-08-09 04:34:54 Kanawha, West Virginia, US
392757 2020-08-08 US West Virginia Lewis 54041 29 2 0 27 38.9947249 -80.49988181 2020-08-09 04:34:54 Lewis, West Virginia, US
392789 2020-08-08 US West Virginia Lincoln 54043 88 0 0 88 38.172154 -82.07017953 2020-08-09 04:34:54 Lincoln, West Virginia, US
392816 2020-08-08 US West Virginia Logan 54045 221 3 0 218 37.8299889 -81.93528571 2020-08-09 04:34:54 Logan, West Virginia, US
392916 2020-08-08 US West Virginia Marion 54049 186 2 0 184 39.50984542 -80.24244659 2020-08-09 04:34:54 Marion, West Virginia, US
392932 2020-08-08 US West Virginia Marshall 54051 131 1 0 130 39.86064362 -80.66591062 2020-08-09 04:34:54 Marshall, West Virginia, US
392945 2020-08-08 US West Virginia Mason 54053 54 1 0 53 38.77071799 -82.02524219 2020-08-09 04:34:54 Mason, West Virginia, US
392967 2020-08-08 US West Virginia McDowell 54047 58 0 0 58 37.38002939 -81.65083669 2020-08-09 04:34:54 McDowell, West Virginia, US
393015 2020-08-08 US West Virginia Mercer 54055 182 3 0 179 37.40481169 -81.11023142 2020-08-09 04:34:54 Mercer, West Virginia, US
393044 2020-08-08 US West Virginia Mineral 54057 120 4 0 116 39.41561583 -78.94104895 2020-08-09 04:34:54 Mineral, West Virginia, US
393045 2020-08-08 US West Virginia Mingo 54059 172 5 0 167 37.73048351 -82.13338365 2020-08-09 04:34:54 Mingo, West Virginia, US
393066 2020-08-08 US West Virginia Monongalia 54061 938 5 0 933 39.63218457 -80.04766838 2020-08-09 04:34:54 Monongalia, West Virginia, US
393082 2020-08-08 US West Virginia Monroe 54063 21 0 0 21 37.56274716 -80.54577965 2020-08-09 04:34:54 Monroe, West Virginia, US
393124 2020-08-08 US West Virginia Morgan 54065 26 0 0 26 39.55439028 -78.26311676 2020-08-09 04:34:54 Morgan, West Virginia, US
393192 2020-08-08 US West Virginia Nicholas 54067 37 1 0 36 38.29617706 -80.79759588 2020-08-09 04:34:54 Nicholas, West Virginia, US
393235 2020-08-08 US West Virginia Ohio 54069 266 4 0 262 40.0955451 -80.62203992 2020-08-09 04:34:54 Ohio, West Virginia, US
393343 2020-08-08 US West Virginia Pendleton 54071 39 1 0 38 38.68314479 -79.35084086 2020-08-09 04:34:54 Pendleton, West Virginia, US
393411 2020-08-08 US West Virginia Pleasants 54073 12 1 0 11 39.37091679 -81.16771771 2020-08-09 04:34:54 Pleasants, West Virginia, US
393416 2020-08-08 US West Virginia Pocahontas 54075 41 0 0 41 38.32758728 -80.00993811 2020-08-09 04:34:54 Pocahontas, West Virginia, US
393463 2020-08-08 US West Virginia Preston 54077 124 4 0 120 39.46770987 -79.66712803 2020-08-09 04:34:54 Preston, West Virginia, US
393489 2020-08-08 US West Virginia Putnam 54079 193 0 0 193 38.50782345 -81.9082131 2020-08-09 04:34:54 Putnam, West Virginia, US
393499 2020-08-08 US West Virginia Raleigh 54081 227 1 0 226 37.76936795 -81.2456041 2020-08-09 04:34:54 Raleigh, West Virginia, US
393511 2020-08-08 US West Virginia Randolph 54083 208 0 0 208 38.769899 -79.87919615 2020-08-09 04:34:54 Randolph, West Virginia, US
393557 2020-08-08 US West Virginia Ritchie 54085 3 0 0 3 39.18094587 -81.06356878 2020-08-09 04:34:54 Ritchie, West Virginia, US
393560 2020-08-08 US West Virginia Roane 54087 15 1 0 14 38.71622686 -81.35243568 2020-08-09 04:34:54 Roane, West Virginia, US
393854 2020-08-08 US West Virginia Summers 54089 10 0 0 10 37.65390597 -80.86009693 2020-08-09 04:34:54 Summers, West Virginia, US
393898 2020-08-08 US West Virginia Taylor 54091 56 1 0 55 39.33602617 -80.0421439 2020-08-09 04:34:54 Taylor, West Virginia, US
393965 2020-08-08 US West Virginia Tucker 54093 10 0 0 10 39.11240885 -79.57053576 2020-08-09 04:34:54 Tucker, West Virginia, US
393978 2020-08-08 US West Virginia Tyler 54095 13 0 0 13 39.46811972 -80.88772676 2020-08-09 04:34:54 Tyler, West Virginia, US
394028 2020-08-08 US West Virginia Unassigned 90054 0 0 0 0 40.51943859 -82.42287994 2020-08-09 04:34:54 Unassigned, West Virginia, US
394051 2020-08-08 US West Virginia Upshur 54097 39 0 0 39 38.89285061 -80.23689136 2020-08-09 04:34:54 Upshur, West Virginia, US
394187 2020-08-08 US West Virginia Wayne 54099 203 9 0 194 38.14901357 -82.42287994 2020-08-09 04:34:54 Wayne, West Virginia, US
394199 2020-08-08 US West Virginia Webster 54101 4 0 0 4 38.49370949 -80.4202023 2020-08-09 04:34:54 Webster, West Virginia, US
394210 2020-08-08 US West Virginia Wetzel 54103 42 0 0 42 39.6065771 -80.64016540000001 2020-08-09 04:34:54 Wetzel, West Virginia, US
394267 2020-08-08 US West Virginia Wirt 54105 6 0 0 6 39.02775007 -81.37473928 2020-08-09 04:34:54 Wirt, West Virginia, US
394273 2020-08-08 US West Virginia Wood 54107 245 5 0 240 39.20967886 -81.5162836 2020-08-09 04:34:54 Wood, West Virginia, US
394295 2020-08-08 US West Virginia Wyoming 54109 31 1 0 30 37.612327 -81.54511071 2020-08-09 04:34:54 Wyoming, West Virginia, US
281786 2020-08-07 US West Virginia Barbour 54001 29 1 0 28 39.1307219 -80.00350858 2020-08-08 04:34:53 Barbour, West Virginia, US
281849 2020-08-07 US West Virginia Berkeley 54003 686 11 0 675 39.46704621 -78.02414609 2020-08-08 04:34:53 Berkeley, West Virginia, US
281895 2020-08-07 US West Virginia Boone 54005 97 0 0 97 38.01974191 -81.69888019 2020-08-08 04:34:53 Boone, West Virginia, US
281918 2020-08-07 US West Virginia Braxton 54007 8 0 0 8 38.70036159 -80.72011184 2020-08-08 04:34:53 Braxton, West Virginia, US
281932 2020-08-07 US West Virginia Brooke 54009 62 1 0 61 40.27367263 -80.57915332 2020-08-08 04:34:53 Brooke, West Virginia, US
281989 2020-08-07 US West Virginia Cabell 54011 373 2 0 371 38.42424062 -82.23855912 2020-08-08 04:34:53 Cabell, West Virginia, US
282012 2020-08-07 US West Virginia Calhoun 54013 6 0 0 6 38.84315422 -81.11934872 2020-08-08 04:34:53 Calhoun, West Virginia, US
282217 2020-08-07 US West Virginia Clay 54015 18 1 0 17 38.46231092 -81.07652217 2020-08-08 04:34:53 Clay, West Virginia, US
282457 2020-08-07 US West Virginia Doddridge 54017 5 0 0 5 39.27057157 -80.70671527 2020-08-08 04:34:53 Doddridge, West Virginia, US
282586 2020-08-07 US West Virginia Fayette 54019 140 5 0 135 38.02974928 -81.08286634 2020-08-08 04:34:53 Fayette, West Virginia, US
282708 2020-08-07 US West Virginia Gilmer 54021 16 0 0 16 38.9251277 -80.85952723 2020-08-08 04:34:53 Gilmer, West Virginia, US
282756 2020-08-07 US West Virginia Grant 54023 117 1 0 116 39.10314817 -79.19440518 2020-08-08 04:34:53 Grant, West Virginia, US
282772 2020-08-07 US West Virginia Greenbrier 54025 91 3 0 88 37.9463652 -80.45335881 2020-08-08 04:34:53 Greenbrier, West Virginia, US
282840 2020-08-07 US West Virginia Hampshire 54027 76 1 0 75 39.32103553 -78.60826476 2020-08-08 04:34:53 Hampshire, West Virginia, US
282852 2020-08-07 US West Virginia Hancock 54029 109 0 0 109 40.51943859 -80.57461608 2020-08-08 04:34:53 Hancock, West Virginia, US
282868 2020-08-07 US West Virginia Hardy 54031 58 0 0 58 39.00683177 -78.85855301 2020-08-08 04:34:53 Hardy, West Virginia, US
282886 2020-08-07 US West Virginia Harrison 54033 214 1 0 213 39.2853852 -80.37919577 2020-08-08 04:34:53 Harrison, West Virginia, US
283054 2020-08-07 US West Virginia Jackson 54035 162 19 0 143 38.84263974 -81.68148753 2020-08-08 04:34:53 Jackson, West Virginia, US
283093 2020-08-07 US West Virginia Jefferson 54037 294 4 0 290 39.30776166 -77.86014147 2020-08-08 04:34:53 Jefferson, West Virginia, US
283137 2020-08-07 US West Virginia Kanawha 54039 898 22 0 876 38.33860077 -81.52857054 2020-08-08 04:34:53 Kanawha, West Virginia, US
283321 2020-08-07 US West Virginia Lewis 54041 29 2 0 27 38.9947249 -80.49988181 2020-08-08 04:34:53 Lewis, West Virginia, US
283353 2020-08-07 US West Virginia Lincoln 54043 81 0 0 81 38.172154 -82.07017953 2020-08-08 04:34:53 Lincoln, West Virginia, US
283380 2020-08-07 US West Virginia Logan 54045 209 3 0 206 37.8299889 -81.93528571 2020-08-08 04:34:53 Logan, West Virginia, US
283480 2020-08-07 US West Virginia Marion 54049 183 2 0 181 39.50984542 -80.24244659 2020-08-08 04:34:53 Marion, West Virginia, US
283496 2020-08-07 US West Virginia Marshall 54051 130 1 0 129 39.86064362 -80.66591062 2020-08-08 04:34:53 Marshall, West Virginia, US
283509 2020-08-07 US West Virginia Mason 54053 54 1 0 53 38.77071799 -82.02524219 2020-08-08 04:34:53 Mason, West Virginia, US
283531 2020-08-07 US West Virginia McDowell 54047 58 0 0 58 37.38002939 -81.65083669 2020-08-08 04:34:53 McDowell, West Virginia, US
283579 2020-08-07 US West Virginia Mercer 54055 177 3 0 174 37.40481169 -81.11023142 2020-08-08 04:34:53 Mercer, West Virginia, US
283608 2020-08-07 US West Virginia Mineral 54057 117 4 0 113 39.41561583 -78.94104895 2020-08-08 04:34:53 Mineral, West Virginia, US
283609 2020-08-07 US West Virginia Mingo 54059 158 5 0 153 37.73048351 -82.13338365 2020-08-08 04:34:53 Mingo, West Virginia, US
283630 2020-08-07 US West Virginia Monongalia 54061 935 5 0 930 39.63218457 -80.04766838 2020-08-08 04:34:53 Monongalia, West Virginia, US
283646 2020-08-07 US West Virginia Monroe 54063 21 0 0 21 37.56274716 -80.54577965 2020-08-08 04:34:53 Monroe, West Virginia, US
283688 2020-08-07 US West Virginia Morgan 54065 26 0 0 26 39.55439028 -78.26311676 2020-08-08 04:34:53 Morgan, West Virginia, US
283756 2020-08-07 US West Virginia Nicholas 54067 36 1 0 35 38.29617706 -80.79759588 2020-08-08 04:34:53 Nicholas, West Virginia, US
283799 2020-08-07 US West Virginia Ohio 54069 266 4 0 262 40.0955451 -80.62203992 2020-08-08 04:34:53 Ohio, West Virginia, US
283907 2020-08-07 US West Virginia Pendleton 54071 58 1 0 57 38.68314479 -79.35084086 2020-08-08 04:34:53 Pendleton, West Virginia, US
283975 2020-08-07 US West Virginia Pleasants 54073 12 1 0 11 39.37091679 -81.16771771 2020-08-08 04:34:53 Pleasants, West Virginia, US
283980 2020-08-07 US West Virginia Pocahontas 54075 41 0 0 41 38.32758728 -80.00993811 2020-08-08 04:34:53 Pocahontas, West Virginia, US
284027 2020-08-07 US West Virginia Preston 54077 123 4 0 119 39.46770987 -79.66712803 2020-08-08 04:34:53 Preston, West Virginia, US
284053 2020-08-07 US West Virginia Putnam 54079 186 0 0 186 38.50782345 -81.9082131 2020-08-08 04:34:53 Putnam, West Virginia, US
284063 2020-08-07 US West Virginia Raleigh 54081 215 1 0 214 37.76936795 -81.2456041 2020-08-08 04:34:53 Raleigh, West Virginia, US
284075 2020-08-07 US West Virginia Randolph 54083 208 0 0 208 38.769899 -79.87919615 2020-08-08 04:34:53 Randolph, West Virginia, US
284121 2020-08-07 US West Virginia Ritchie 54085 3 0 0 3 39.18094587 -81.06356878 2020-08-08 04:34:53 Ritchie, West Virginia, US
284124 2020-08-07 US West Virginia Roane 54087 15 1 0 14 38.71622686 -81.35243568 2020-08-08 04:34:53 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]);
Powered by Datasette · Query took 1610.39ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette