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-27 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 |
---|---|---|---|---|---|---|---|
376138 | 376138 | 2020-07-27 | Barbour | West Virginia | 54001 | 28 | 1 |
376139 | 376139 | 2020-07-27 | Berkeley | West Virginia | 54003 | 620 | 10 |
376140 | 376140 | 2020-07-27 | Boone | West Virginia | 54005 | 68 | 0 |
376141 | 376141 | 2020-07-27 | Braxton | West Virginia | 54007 | 8 | 0 |
376142 | 376142 | 2020-07-27 | Brooke | West Virginia | 54009 | 50 | 1 |
376143 | 376143 | 2020-07-27 | Cabell | West Virginia | 54011 | 286 | 2 |
376144 | 376144 | 2020-07-27 | Calhoun | West Virginia | 54013 | 6 | 0 |
376145 | 376145 | 2020-07-27 | Clay | West Virginia | 54015 | 17 | 1 |
376146 | 376146 | 2020-07-27 | Doddridge | West Virginia | 54017 | 2 | 0 |
376147 | 376147 | 2020-07-27 | Fayette | West Virginia | 54019 | 118 | 5 |
376148 | 376148 | 2020-07-27 | Gilmer | West Virginia | 54021 | 14 | 0 |
376149 | 376149 | 2020-07-27 | Grant | West Virginia | 54023 | 43 | 0 |
376150 | 376150 | 2020-07-27 | Greenbrier | West Virginia | 54025 | 82 | 3 |
376151 | 376151 | 2020-07-27 | Hampshire | West Virginia | 54027 | 64 | 1 |
376152 | 376152 | 2020-07-27 | Hancock | West Virginia | 54029 | 89 | 0 |
376153 | 376153 | 2020-07-27 | Hardy | West Virginia | 54031 | 51 | 0 |
376154 | 376154 | 2020-07-27 | Harrison | West Virginia | 54033 | 164 | 1 |
376155 | 376155 | 2020-07-27 | Jackson | West Virginia | 54035 | 153 | 19 |
376156 | 376156 | 2020-07-27 | Jefferson | West Virginia | 54037 | 284 | 4 |
376157 | 376157 | 2020-07-27 | Kanawha | West Virginia | 54039 | 707 | 20 |
376158 | 376158 | 2020-07-27 | Lewis | West Virginia | 54041 | 25 | 2 |
376159 | 376159 | 2020-07-27 | Lincoln | West Virginia | 54043 | 52 | 0 |
376160 | 376160 | 2020-07-27 | Logan | West Virginia | 54045 | 92 | 1 |
376161 | 376161 | 2020-07-27 | Marion | West Virginia | 54049 | 159 | 2 |
376162 | 376162 | 2020-07-27 | Marshall | West Virginia | 54051 | 109 | 0 |
376163 | 376163 | 2020-07-27 | Mason | West Virginia | 54053 | 41 | 1 |
376164 | 376164 | 2020-07-27 | McDowell | West Virginia | 54047 | 17 | 0 |
376165 | 376165 | 2020-07-27 | Mercer | West Virginia | 54055 | 91 | 0 |
376166 | 376166 | 2020-07-27 | Mineral | West Virginia | 54057 | 98 | 4 |
376167 | 376167 | 2020-07-27 | Mingo | West Virginia | 54059 | 104 | 2 |
376168 | 376168 | 2020-07-27 | Monongalia | West Virginia | 54061 | 838 | 5 |
376169 | 376169 | 2020-07-27 | Monroe | West Virginia | 54063 | 19 | 0 |
376170 | 376170 | 2020-07-27 | Morgan | West Virginia | 54065 | 25 | 0 |
376171 | 376171 | 2020-07-27 | Nicholas | West Virginia | 54067 | 27 | 1 |
376172 | 376172 | 2020-07-27 | Ohio | West Virginia | 54069 | 229 | 3 |
376173 | 376173 | 2020-07-27 | Pendleton | West Virginia | 54071 | 28 | 1 |
376174 | 376174 | 2020-07-27 | Pleasants | West Virginia | 54073 | 7 | 0 |
376175 | 376175 | 2020-07-27 | Pocahontas | West Virginia | 54075 | 40 | 0 |
376176 | 376176 | 2020-07-27 | Preston | West Virginia | 54077 | 120 | 2 |
376177 | 376177 | 2020-07-27 | Putnam | West Virginia | 54079 | 150 | 0 |
376178 | 376178 | 2020-07-27 | Raleigh | West Virginia | 54081 | 136 | 0 |
376179 | 376179 | 2020-07-27 | Randolph | West Virginia | 54083 | 206 | 0 |
376180 | 376180 | 2020-07-27 | Ritchie | West Virginia | 54085 | 3 | 0 |
376181 | 376181 | 2020-07-27 | Roane | West Virginia | 54087 | 14 | 1 |
376182 | 376182 | 2020-07-27 | Summers | West Virginia | 54089 | 5 | 0 |
376183 | 376183 | 2020-07-27 | Taylor | West Virginia | 54091 | 39 | 0 |
376184 | 376184 | 2020-07-27 | Tucker | West Virginia | 54093 | 8 | 0 |
376185 | 376185 | 2020-07-27 | Tyler | West Virginia | 54095 | 11 | 0 |
376186 | 376186 | 2020-07-27 | Upshur | West Virginia | 54097 | 36 | 0 |
376187 | 376187 | 2020-07-27 | Wayne | West Virginia | 54099 | 176 | 9 |
376188 | 376188 | 2020-07-27 | Webster | West Virginia | 54101 | 3 | 0 |
376189 | 376189 | 2020-07-27 | Wetzel | West Virginia | 54103 | 40 | 0 |
376190 | 376190 | 2020-07-27 | Wirt | West Virginia | 54105 | 6 | 0 |
376191 | 376191 | 2020-07-27 | Wood | West Virginia | 54107 | 229 | 3 |
376192 | 376192 | 2020-07-27 | Wyoming | West Virginia | 54109 | 17 | 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);