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-08-18 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 |
---|---|---|---|---|---|---|---|
446993 | 446993 | 2020-08-18 | Barbour | West Virginia | 54001 | 33 | 1 |
446994 | 446994 | 2020-08-18 | Berkeley | West Virginia | 54003 | 745 | 11 |
446995 | 446995 | 2020-08-18 | Boone | West Virginia | 54005 | 123 | 0 |
446996 | 446996 | 2020-08-18 | Braxton | West Virginia | 54007 | 8 | 0 |
446997 | 446997 | 2020-08-18 | Brooke | West Virginia | 54009 | 79 | 1 |
446998 | 446998 | 2020-08-18 | Cabell | West Virginia | 54011 | 466 | 3 |
446999 | 446999 | 2020-08-18 | Calhoun | West Virginia | 54013 | 7 | 0 |
447000 | 447000 | 2020-08-18 | Clay | West Virginia | 54015 | 18 | 1 |
447001 | 447001 | 2020-08-18 | Doddridge | West Virginia | 54017 | 6 | 0 |
447002 | 447002 | 2020-08-18 | Fayette | West Virginia | 54019 | 175 | 7 |
447003 | 447003 | 2020-08-18 | Gilmer | West Virginia | 54021 | 18 | 0 |
447004 | 447004 | 2020-08-18 | Grant | West Virginia | 54023 | 131 | 4 |
447005 | 447005 | 2020-08-18 | Greenbrier | West Virginia | 54025 | 96 | 4 |
447006 | 447006 | 2020-08-18 | Hampshire | West Virginia | 54027 | 90 | 1 |
447007 | 447007 | 2020-08-18 | Hancock | West Virginia | 54029 | 113 | 0 |
447008 | 447008 | 2020-08-18 | Hardy | West Virginia | 54031 | 64 | 0 |
447009 | 447009 | 2020-08-18 | Harrison | West Virginia | 54033 | 245 | 1 |
447010 | 447010 | 2020-08-18 | Jackson | West Virginia | 54035 | 169 | 19 |
447011 | 447011 | 2020-08-18 | Jefferson | West Virginia | 54037 | 310 | 4 |
447012 | 447012 | 2020-08-18 | Kanawha | West Virginia | 54039 | 1113 | 25 |
447013 | 447013 | 2020-08-18 | Lewis | West Virginia | 54041 | 28 | 2 |
447014 | 447014 | 2020-08-18 | Lincoln | West Virginia | 54043 | 110 | 0 |
447015 | 447015 | 2020-08-18 | Logan | West Virginia | 54045 | 374 | 12 |
447016 | 447016 | 2020-08-18 | Marion | West Virginia | 54049 | 202 | 2 |
447017 | 447017 | 2020-08-18 | Marshall | West Virginia | 54051 | 130 | 1 |
447018 | 447018 | 2020-08-18 | Mason | West Virginia | 54053 | 75 | 1 |
447019 | 447019 | 2020-08-18 | McDowell | West Virginia | 54047 | 66 | 0 |
447020 | 447020 | 2020-08-18 | Mercer | West Virginia | 54055 | 244 | 18 |
447021 | 447021 | 2020-08-18 | Mineral | West Virginia | 54057 | 129 | 4 |
447022 | 447022 | 2020-08-18 | Mingo | West Virginia | 54059 | 204 | 5 |
447023 | 447023 | 2020-08-18 | Monongalia | West Virginia | 54061 | 1001 | 5 |
447024 | 447024 | 2020-08-18 | Monroe | West Virginia | 54063 | 20 | 0 |
447025 | 447025 | 2020-08-18 | Morgan | West Virginia | 54065 | 33 | 0 |
447026 | 447026 | 2020-08-18 | Nicholas | West Virginia | 54067 | 40 | 1 |
447027 | 447027 | 2020-08-18 | Ohio | West Virginia | 54069 | 285 | 4 |
447028 | 447028 | 2020-08-18 | Pendleton | West Virginia | 54071 | 43 | 1 |
447029 | 447029 | 2020-08-18 | Pleasants | West Virginia | 54073 | 14 | 2 |
447030 | 447030 | 2020-08-18 | Pocahontas | West Virginia | 54075 | 42 | 0 |
447031 | 447031 | 2020-08-18 | Preston | West Virginia | 54077 | 131 | 4 |
447032 | 447032 | 2020-08-18 | Putnam | West Virginia | 54079 | 227 | 0 |
447033 | 447033 | 2020-08-18 | Raleigh | West Virginia | 54081 | 306 | 2 |
447034 | 447034 | 2020-08-18 | Randolph | West Virginia | 54083 | 217 | 0 |
447035 | 447035 | 2020-08-18 | Ritchie | West Virginia | 54085 | 3 | 0 |
447036 | 447036 | 2020-08-18 | Roane | West Virginia | 54087 | 20 | 1 |
447037 | 447037 | 2020-08-18 | Summers | West Virginia | 54089 | 19 | 0 |
447038 | 447038 | 2020-08-18 | Taylor | West Virginia | 54091 | 84 | 1 |
447039 | 447039 | 2020-08-18 | Tucker | West Virginia | 54093 | 11 | 0 |
447040 | 447040 | 2020-08-18 | Tyler | West Virginia | 54095 | 15 | 0 |
447041 | 447041 | 2020-08-18 | Upshur | West Virginia | 54097 | 40 | 0 |
447042 | 447042 | 2020-08-18 | Wayne | West Virginia | 54099 | 220 | 9 |
447043 | 447043 | 2020-08-18 | Webster | West Virginia | 54101 | 6 | 0 |
447044 | 447044 | 2020-08-18 | Wetzel | West Virginia | 54103 | 44 | 0 |
447045 | 447045 | 2020-08-18 | Wirt | West Virginia | 54105 | 7 | 0 |
447046 | 447046 | 2020-08-18 | Wood | West Virginia | 54107 | 285 | 5 |
447047 | 447047 | 2020-08-18 | Wyoming | West Virginia | 54109 | 47 | 2 |
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);