ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2020-07-31 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 |
---|---|---|---|---|---|---|---|
389006 | 389006 | 2020-07-31 | Barbour | West Virginia | 54001 | 29 | 1 |
389007 | 389007 | 2020-07-31 | Berkeley | West Virginia | 54003 | 645 | 11 |
389008 | 389008 | 2020-07-31 | Boone | West Virginia | 54005 | 76 | 0 |
389009 | 389009 | 2020-07-31 | Braxton | West Virginia | 54007 | 8 | 0 |
389010 | 389010 | 2020-07-31 | Brooke | West Virginia | 54009 | 60 | 1 |
389011 | 389011 | 2020-07-31 | Cabell | West Virginia | 54011 | 315 | 2 |
389012 | 389012 | 2020-07-31 | Calhoun | West Virginia | 54013 | 6 | 0 |
389013 | 389013 | 2020-07-31 | Clay | West Virginia | 54015 | 17 | 1 |
389014 | 389014 | 2020-07-31 | Doddridge | West Virginia | 54017 | 4 | 0 |
389015 | 389015 | 2020-07-31 | Fayette | West Virginia | 54019 | 126 | 5 |
389016 | 389016 | 2020-07-31 | Gilmer | West Virginia | 54021 | 16 | 0 |
389017 | 389017 | 2020-07-31 | Grant | West Virginia | 54023 | 68 | 0 |
389018 | 389018 | 2020-07-31 | Greenbrier | West Virginia | 54025 | 85 | 3 |
389019 | 389019 | 2020-07-31 | Hampshire | West Virginia | 54027 | 73 | 1 |
389020 | 389020 | 2020-07-31 | Hancock | West Virginia | 54029 | 97 | 0 |
389021 | 389021 | 2020-07-31 | Hardy | West Virginia | 54031 | 54 | 0 |
389022 | 389022 | 2020-07-31 | Harrison | West Virginia | 54033 | 183 | 1 |
389023 | 389023 | 2020-07-31 | Jackson | West Virginia | 54035 | 157 | 19 |
389024 | 389024 | 2020-07-31 | Jefferson | West Virginia | 54037 | 288 | 4 |
389025 | 389025 | 2020-07-31 | Kanawha | West Virginia | 54039 | 798 | 20 |
389026 | 389026 | 2020-07-31 | Lewis | West Virginia | 54041 | 26 | 2 |
389027 | 389027 | 2020-07-31 | Lincoln | West Virginia | 54043 | 61 | 0 |
389028 | 389028 | 2020-07-31 | Logan | West Virginia | 54045 | 133 | 3 |
389029 | 389029 | 2020-07-31 | Marion | West Virginia | 54049 | 170 | 2 |
389030 | 389030 | 2020-07-31 | Marshall | West Virginia | 54051 | 124 | 0 |
389031 | 389031 | 2020-07-31 | Mason | West Virginia | 54053 | 45 | 1 |
389032 | 389032 | 2020-07-31 | McDowell | West Virginia | 54047 | 26 | 0 |
389033 | 389033 | 2020-07-31 | Mercer | West Virginia | 54055 | 138 | 3 |
389034 | 389034 | 2020-07-31 | Mineral | West Virginia | 54057 | 109 | 4 |
389035 | 389035 | 2020-07-31 | Mingo | West Virginia | 54059 | 121 | 2 |
389036 | 389036 | 2020-07-31 | Monongalia | West Virginia | 54061 | 896 | 5 |
389037 | 389037 | 2020-07-31 | Monroe | West Virginia | 54063 | 19 | 0 |
389038 | 389038 | 2020-07-31 | Morgan | West Virginia | 54065 | 26 | 0 |
389039 | 389039 | 2020-07-31 | Nicholas | West Virginia | 54067 | 31 | 1 |
389040 | 389040 | 2020-07-31 | Ohio | West Virginia | 54069 | 248 | 4 |
389041 | 389041 | 2020-07-31 | Pendleton | West Virginia | 54071 | 37 | 1 |
389042 | 389042 | 2020-07-31 | Pleasants | West Virginia | 54073 | 8 | 0 |
389043 | 389043 | 2020-07-31 | Pocahontas | West Virginia | 54075 | 41 | 0 |
389044 | 389044 | 2020-07-31 | Preston | West Virginia | 54077 | 122 | 3 |
389045 | 389045 | 2020-07-31 | Putnam | West Virginia | 54079 | 159 | 0 |
389046 | 389046 | 2020-07-31 | Raleigh | West Virginia | 54081 | 172 | 1 |
389047 | 389047 | 2020-07-31 | Randolph | West Virginia | 54083 | 207 | 0 |
389048 | 389048 | 2020-07-31 | Ritchie | West Virginia | 54085 | 3 | 0 |
389049 | 389049 | 2020-07-31 | Roane | West Virginia | 54087 | 14 | 1 |
389050 | 389050 | 2020-07-31 | Summers | West Virginia | 54089 | 6 | 0 |
389051 | 389051 | 2020-07-31 | Taylor | West Virginia | 54091 | 52 | 0 |
389052 | 389052 | 2020-07-31 | Tucker | West Virginia | 54093 | 9 | 0 |
389053 | 389053 | 2020-07-31 | Tyler | West Virginia | 54095 | 12 | 0 |
389054 | 389054 | 2020-07-31 | Upshur | West Virginia | 54097 | 38 | 0 |
389055 | 389055 | 2020-07-31 | Wayne | West Virginia | 54099 | 182 | 9 |
389056 | 389056 | 2020-07-31 | Webster | West Virginia | 54101 | 3 | 0 |
389057 | 389057 | 2020-07-31 | Wetzel | West Virginia | 54103 | 40 | 0 |
389058 | 389058 | 2020-07-31 | Wirt | West Virginia | 54105 | 6 | 0 |
389059 | 389059 | 2020-07-31 | Wood | West Virginia | 54107 | 233 | 4 |
389060 | 389060 | 2020-07-31 | Wyoming | West Virginia | 54109 | 20 | 1 |
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);