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-11-02 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 |
---|---|---|---|---|---|---|---|
693133 | 693133 | 2020-11-02 | Barbour | West Virginia | 54001 | 188 | 1 |
693134 | 693134 | 2020-11-02 | Berkeley | West Virginia | 54003 | 1709 | 18 |
693135 | 693135 | 2020-11-02 | Boone | West Virginia | 54005 | 415 | 3 |
693136 | 693136 | 2020-11-02 | Braxton | West Virginia | 54007 | 76 | 0 |
693137 | 693137 | 2020-11-02 | Brooke | West Virginia | 54009 | 253 | 4 |
693138 | 693138 | 2020-11-02 | Cabell | West Virginia | 54011 | 1559 | 29 |
693139 | 693139 | 2020-11-02 | Calhoun | West Virginia | 54013 | 36 | 0 |
693140 | 693140 | 2020-11-02 | Clay | West Virginia | 54015 | 65 | 3 |
693141 | 693141 | 2020-11-02 | Doddridge | West Virginia | 54017 | 72 | 1 |
693142 | 693142 | 2020-11-02 | Fayette | West Virginia | 54019 | 799 | 24 |
693143 | 693143 | 2020-11-02 | Gilmer | West Virginia | 54021 | 65 | 0 |
693144 | 693144 | 2020-11-02 | Grant | West Virginia | 54023 | 200 | 9 |
693145 | 693145 | 2020-11-02 | Greenbrier | West Virginia | 54025 | 215 | 4 |
693146 | 693146 | 2020-11-02 | Hampshire | West Virginia | 54027 | 146 | 1 |
693147 | 693147 | 2020-11-02 | Hancock | West Virginia | 54029 | 244 | 1 |
693148 | 693148 | 2020-11-02 | Hardy | West Virginia | 54031 | 109 | 1 |
693149 | 693149 | 2020-11-02 | Harrison | West Virginia | 54033 | 688 | 12 |
693150 | 693150 | 2020-11-02 | Jackson | West Virginia | 54035 | 420 | 24 |
693151 | 693151 | 2020-11-02 | Jefferson | West Virginia | 54037 | 634 | 5 |
693152 | 693152 | 2020-11-02 | Kanawha | West Virginia | 54039 | 3894 | 106 |
693153 | 693153 | 2020-11-02 | Lewis | West Virginia | 54041 | 115 | 2 |
693154 | 693154 | 2020-11-02 | Lincoln | West Virginia | 54043 | 268 | 2 |
693155 | 693155 | 2020-11-02 | Logan | West Virginia | 54045 | 805 | 46 |
693156 | 693156 | 2020-11-02 | Marion | West Virginia | 54049 | 425 | 5 |
693157 | 693157 | 2020-11-02 | Marshall | West Virginia | 54051 | 451 | 4 |
693158 | 693158 | 2020-11-02 | Mason | West Virginia | 54053 | 183 | 6 |
693159 | 693159 | 2020-11-02 | McDowell | West Virginia | 54047 | 132 | 0 |
693160 | 693160 | 2020-11-02 | Mercer | West Virginia | 54055 | 816 | 31 |
693161 | 693161 | 2020-11-02 | Mineral | West Virginia | 54057 | 250 | 4 |
693162 | 693162 | 2020-11-02 | Mingo | West Virginia | 54059 | 669 | 10 |
693163 | 693163 | 2020-11-02 | Monongalia | West Virginia | 54061 | 2378 | 7 |
693164 | 693164 | 2020-11-02 | Monroe | West Virginia | 54063 | 267 | 8 |
693165 | 693165 | 2020-11-02 | Morgan | West Virginia | 54065 | 161 | 0 |
693166 | 693166 | 2020-11-02 | Nicholas | West Virginia | 54067 | 193 | 3 |
693167 | 693167 | 2020-11-02 | Ohio | West Virginia | 54069 | 649 | 9 |
693168 | 693168 | 2020-11-02 | Pendleton | West Virginia | 54071 | 79 | 1 |
693169 | 693169 | 2020-11-02 | Pleasants | West Virginia | 54073 | 36 | 3 |
693170 | 693170 | 2020-11-02 | Pocahontas | West Virginia | 54075 | 73 | 0 |
693171 | 693171 | 2020-11-02 | Preston | West Virginia | 54077 | 227 | 4 |
693172 | 693172 | 2020-11-02 | Putnam | West Virginia | 54079 | 1001 | 13 |
693173 | 693173 | 2020-11-02 | Raleigh | West Virginia | 54081 | 880 | 10 |
693174 | 693174 | 2020-11-02 | Randolph | West Virginia | 54083 | 431 | 1 |
693175 | 693175 | 2020-11-02 | Ritchie | West Virginia | 54085 | 56 | 0 |
693176 | 693176 | 2020-11-02 | Roane | West Virginia | 54087 | 115 | 2 |
693177 | 693177 | 2020-11-02 | Summers | West Virginia | 54089 | 142 | 1 |
693178 | 693178 | 2020-11-02 | Taylor | West Virginia | 54091 | 174 | 8 |
693179 | 693179 | 2020-11-02 | Tucker | West Virginia | 54093 | 67 | 0 |
693180 | 693180 | 2020-11-02 | Tyler | West Virginia | 54095 | 58 | 0 |
693181 | 693181 | 2020-11-02 | Upshur | West Virginia | 54097 | 279 | 4 |
693182 | 693182 | 2020-11-02 | Wayne | West Virginia | 54099 | 630 | 11 |
693183 | 693183 | 2020-11-02 | Webster | West Virginia | 54101 | 38 | 0 |
693184 | 693184 | 2020-11-02 | Wetzel | West Virginia | 54103 | 232 | 6 |
693185 | 693185 | 2020-11-02 | Wirt | West Virginia | 54105 | 56 | 0 |
693186 | 693186 | 2020-11-02 | Wood | West Virginia | 54107 | 748 | 6 |
693187 | 693187 | 2020-11-02 | Wyoming | West Virginia | 54109 | 364 | 5 |
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);