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-06 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 |
---|---|---|---|---|---|---|---|
408309 | 408309 | 2020-08-06 | Barbour | West Virginia | 54001 | 29 | 1 |
408310 | 408310 | 2020-08-06 | Berkeley | West Virginia | 54003 | 675 | 11 |
408311 | 408311 | 2020-08-06 | Boone | West Virginia | 54005 | 95 | 0 |
408312 | 408312 | 2020-08-06 | Braxton | West Virginia | 54007 | 8 | 0 |
408313 | 408313 | 2020-08-06 | Brooke | West Virginia | 54009 | 61 | 1 |
408314 | 408314 | 2020-08-06 | Cabell | West Virginia | 54011 | 367 | 2 |
408315 | 408315 | 2020-08-06 | Calhoun | West Virginia | 54013 | 6 | 0 |
408316 | 408316 | 2020-08-06 | Clay | West Virginia | 54015 | 18 | 1 |
408317 | 408317 | 2020-08-06 | Doddridge | West Virginia | 54017 | 5 | 0 |
408318 | 408318 | 2020-08-06 | Fayette | West Virginia | 54019 | 137 | 5 |
408319 | 408319 | 2020-08-06 | Gilmer | West Virginia | 54021 | 16 | 0 |
408320 | 408320 | 2020-08-06 | Grant | West Virginia | 54023 | 97 | 1 |
408321 | 408321 | 2020-08-06 | Greenbrier | West Virginia | 54025 | 88 | 3 |
408322 | 408322 | 2020-08-06 | Hampshire | West Virginia | 54027 | 76 | 1 |
408323 | 408323 | 2020-08-06 | Hancock | West Virginia | 54029 | 107 | 0 |
408324 | 408324 | 2020-08-06 | Hardy | West Virginia | 54031 | 57 | 0 |
408325 | 408325 | 2020-08-06 | Harrison | West Virginia | 54033 | 207 | 1 |
408326 | 408326 | 2020-08-06 | Jackson | West Virginia | 54035 | 160 | 19 |
408327 | 408327 | 2020-08-06 | Jefferson | West Virginia | 54037 | 294 | 4 |
408328 | 408328 | 2020-08-06 | Kanawha | West Virginia | 54039 | 876 | 22 |
408329 | 408329 | 2020-08-06 | Lewis | West Virginia | 54041 | 28 | 2 |
408330 | 408330 | 2020-08-06 | Lincoln | West Virginia | 54043 | 79 | 0 |
408331 | 408331 | 2020-08-06 | Logan | West Virginia | 54045 | 176 | 3 |
408332 | 408332 | 2020-08-06 | Marion | West Virginia | 54049 | 179 | 2 |
408333 | 408333 | 2020-08-06 | Marshall | West Virginia | 54051 | 128 | 1 |
408334 | 408334 | 2020-08-06 | Mason | West Virginia | 54053 | 53 | 1 |
408335 | 408335 | 2020-08-06 | McDowell | West Virginia | 54047 | 49 | 0 |
408336 | 408336 | 2020-08-06 | Mercer | West Virginia | 54055 | 174 | 3 |
408337 | 408337 | 2020-08-06 | Mineral | West Virginia | 54057 | 116 | 4 |
408338 | 408338 | 2020-08-06 | Mingo | West Virginia | 54059 | 156 | 3 |
408339 | 408339 | 2020-08-06 | Monongalia | West Virginia | 54061 | 929 | 5 |
408340 | 408340 | 2020-08-06 | Monroe | West Virginia | 54063 | 19 | 0 |
408341 | 408341 | 2020-08-06 | Morgan | West Virginia | 54065 | 26 | 0 |
408342 | 408342 | 2020-08-06 | Nicholas | West Virginia | 54067 | 35 | 1 |
408343 | 408343 | 2020-08-06 | Ohio | West Virginia | 54069 | 265 | 4 |
408344 | 408344 | 2020-08-06 | Pendleton | West Virginia | 54071 | 58 | 1 |
408345 | 408345 | 2020-08-06 | Pleasants | West Virginia | 54073 | 10 | 0 |
408346 | 408346 | 2020-08-06 | Pocahontas | West Virginia | 54075 | 41 | 0 |
408347 | 408347 | 2020-08-06 | Preston | West Virginia | 54077 | 123 | 4 |
408348 | 408348 | 2020-08-06 | Putnam | West Virginia | 54079 | 178 | 0 |
408349 | 408349 | 2020-08-06 | Raleigh | West Virginia | 54081 | 210 | 1 |
408350 | 408350 | 2020-08-06 | Randolph | West Virginia | 54083 | 206 | 0 |
408351 | 408351 | 2020-08-06 | Ritchie | West Virginia | 54085 | 3 | 0 |
408352 | 408352 | 2020-08-06 | Roane | West Virginia | 54087 | 14 | 1 |
408353 | 408353 | 2020-08-06 | Summers | West Virginia | 54089 | 7 | 0 |
408354 | 408354 | 2020-08-06 | Taylor | West Virginia | 54091 | 56 | 1 |
408355 | 408355 | 2020-08-06 | Tucker | West Virginia | 54093 | 11 | 0 |
408356 | 408356 | 2020-08-06 | Tyler | West Virginia | 54095 | 13 | 0 |
408357 | 408357 | 2020-08-06 | Upshur | West Virginia | 54097 | 39 | 0 |
408358 | 408358 | 2020-08-06 | Wayne | West Virginia | 54099 | 196 | 9 |
408359 | 408359 | 2020-08-06 | Webster | West Virginia | 54101 | 4 | 0 |
408360 | 408360 | 2020-08-06 | Wetzel | West Virginia | 54103 | 40 | 0 |
408361 | 408361 | 2020-08-06 | Wirt | West Virginia | 54105 | 6 | 0 |
408362 | 408362 | 2020-08-06 | Wood | West Virginia | 54107 | 242 | 5 |
408363 | 408363 | 2020-08-06 | Wyoming | West Virginia | 54109 | 29 | 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);