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-15 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 |
---|---|---|---|---|---|---|---|
735300 | 735300 | 2020-11-15 | Barbour | West Virginia | 54001 | 263 | 3 |
735301 | 735301 | 2020-11-15 | Berkeley | West Virginia | 54003 | 2209 | 20 |
735302 | 735302 | 2020-11-15 | Boone | West Virginia | 54005 | 505 | 10 |
735303 | 735303 | 2020-11-15 | Braxton | West Virginia | 54007 | 94 | 0 |
735304 | 735304 | 2020-11-15 | Brooke | West Virginia | 54009 | 377 | 7 |
735305 | 735305 | 2020-11-15 | Cabell | West Virginia | 54011 | 2162 | 44 |
735306 | 735306 | 2020-11-15 | Calhoun | West Virginia | 54013 | 43 | 0 |
735307 | 735307 | 2020-11-15 | Clay | West Virginia | 54015 | 94 | 3 |
735308 | 735308 | 2020-11-15 | Doddridge | West Virginia | 54017 | 87 | 1 |
735309 | 735309 | 2020-11-15 | Fayette | West Virginia | 54019 | 950 | 30 |
735310 | 735310 | 2020-11-15 | Gilmer | West Virginia | 54021 | 175 | 0 |
735311 | 735311 | 2020-11-15 | Grant | West Virginia | 54023 | 235 | 9 |
735312 | 735312 | 2020-11-15 | Greenbrier | West Virginia | 54025 | 308 | 6 |
735313 | 735313 | 2020-11-15 | Hampshire | West Virginia | 54027 | 206 | 1 |
735314 | 735314 | 2020-11-15 | Hancock | West Virginia | 54029 | 366 | 4 |
735315 | 735315 | 2020-11-15 | Hardy | West Virginia | 54031 | 150 | 1 |
735316 | 735316 | 2020-11-15 | Harrison | West Virginia | 54033 | 872 | 14 |
735317 | 735317 | 2020-11-15 | Jackson | West Virginia | 54035 | 538 | 24 |
735318 | 735318 | 2020-11-15 | Jefferson | West Virginia | 54037 | 947 | 11 |
735319 | 735319 | 2020-11-15 | Kanawha | West Virginia | 54039 | 4652 | 125 |
735320 | 735320 | 2020-11-15 | Lewis | West Virginia | 54041 | 197 | 2 |
735321 | 735321 | 2020-11-15 | Lincoln | West Virginia | 54043 | 342 | 2 |
735322 | 735322 | 2020-11-15 | Logan | West Virginia | 54045 | 919 | 48 |
735323 | 735323 | 2020-11-15 | Marion | West Virginia | 54049 | 585 | 5 |
735324 | 735324 | 2020-11-15 | Marshall | West Virginia | 54051 | 790 | 9 |
735325 | 735325 | 2020-11-15 | Mason | West Virginia | 54053 | 251 | 6 |
735326 | 735326 | 2020-11-15 | McDowell | West Virginia | 54047 | 292 | 1 |
735327 | 735327 | 2020-11-15 | Mercer | West Virginia | 54055 | 1045 | 36 |
735328 | 735328 | 2020-11-15 | Mineral | West Virginia | 54057 | 590 | 4 |
735329 | 735329 | 2020-11-15 | Mingo | West Virginia | 54059 | 831 | 13 |
735330 | 735330 | 2020-11-15 | Monongalia | West Virginia | 54061 | 2754 | 7 |
735331 | 735331 | 2020-11-15 | Monroe | West Virginia | 54063 | 290 | 8 |
735332 | 735332 | 2020-11-15 | Morgan | West Virginia | 54065 | 206 | 0 |
735333 | 735333 | 2020-11-15 | Nicholas | West Virginia | 54067 | 255 | 3 |
735334 | 735334 | 2020-11-15 | Ohio | West Virginia | 54069 | 997 | 12 |
735335 | 735335 | 2020-11-15 | Pendleton | West Virginia | 54071 | 84 | 1 |
735336 | 735336 | 2020-11-15 | Pleasants | West Virginia | 54073 | 55 | 3 |
735337 | 735337 | 2020-11-15 | Pocahontas | West Virginia | 54075 | 81 | 0 |
735338 | 735338 | 2020-11-15 | Preston | West Virginia | 54077 | 337 | 6 |
735339 | 735339 | 2020-11-15 | Putnam | West Virginia | 54079 | 1377 | 25 |
735340 | 735340 | 2020-11-15 | Raleigh | West Virginia | 54081 | 1110 | 15 |
735341 | 735341 | 2020-11-15 | Randolph | West Virginia | 54083 | 547 | 2 |
735342 | 735342 | 2020-11-15 | Ritchie | West Virginia | 54085 | 92 | 1 |
735343 | 735343 | 2020-11-15 | Roane | West Virginia | 54087 | 132 | 2 |
735344 | 735344 | 2020-11-15 | Summers | West Virginia | 54089 | 201 | 5 |
735345 | 735345 | 2020-11-15 | Taylor | West Virginia | 54091 | 218 | 8 |
735346 | 735346 | 2020-11-15 | Tucker | West Virginia | 54093 | 75 | 0 |
735347 | 735347 | 2020-11-15 | Tyler | West Virginia | 54095 | 106 | 0 |
735348 | 735348 | 2020-11-15 | Upshur | West Virginia | 54097 | 359 | 4 |
735349 | 735349 | 2020-11-15 | Wayne | West Virginia | 54099 | 795 | 13 |
735350 | 735350 | 2020-11-15 | Webster | West Virginia | 54101 | 47 | 0 |
735351 | 735351 | 2020-11-15 | Wetzel | West Virginia | 54103 | 319 | 11 |
735352 | 735352 | 2020-11-15 | Wirt | West Virginia | 54105 | 66 | 1 |
735353 | 735353 | 2020-11-15 | Wood | West Virginia | 54107 | 1565 | 10 |
735354 | 735354 | 2020-11-15 | Wyoming | West Virginia | 54109 | 516 | 6 |
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);