ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2020-10-30" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
683401 | 683401 | 2020-10-30 | Barbour | West Virginia | 54001 | 187 | 1 |
683402 | 683402 | 2020-10-30 | Berkeley | West Virginia | 54003 | 1650 | 18 |
683403 | 683403 | 2020-10-30 | Boone | West Virginia | 54005 | 380 | 3 |
683404 | 683404 | 2020-10-30 | Braxton | West Virginia | 54007 | 69 | 0 |
683405 | 683405 | 2020-10-30 | Brooke | West Virginia | 54009 | 239 | 4 |
683406 | 683406 | 2020-10-30 | Cabell | West Virginia | 54011 | 1494 | 27 |
683407 | 683407 | 2020-10-30 | Calhoun | West Virginia | 54013 | 36 | 0 |
683408 | 683408 | 2020-10-30 | Clay | West Virginia | 54015 | 63 | 3 |
683409 | 683409 | 2020-10-30 | Doddridge | West Virginia | 54017 | 71 | 1 |
683410 | 683410 | 2020-10-30 | Fayette | West Virginia | 54019 | 787 | 23 |
683411 | 683411 | 2020-10-30 | Gilmer | West Virginia | 54021 | 64 | 0 |
683412 | 683412 | 2020-10-30 | Grant | West Virginia | 54023 | 198 | 8 |
683413 | 683413 | 2020-10-30 | Greenbrier | West Virginia | 54025 | 204 | 4 |
683414 | 683414 | 2020-10-30 | Hampshire | West Virginia | 54027 | 140 | 1 |
683415 | 683415 | 2020-10-30 | Hancock | West Virginia | 54029 | 230 | 1 |
683416 | 683416 | 2020-10-30 | Hardy | West Virginia | 54031 | 107 | 1 |
683417 | 683417 | 2020-10-30 | Harrison | West Virginia | 54033 | 673 | 12 |
683418 | 683418 | 2020-10-30 | Jackson | West Virginia | 54035 | 406 | 24 |
683419 | 683419 | 2020-10-30 | Jefferson | West Virginia | 54037 | 614 | 5 |
683420 | 683420 | 2020-10-30 | Kanawha | West Virginia | 54039 | 3732 | 105 |
683421 | 683421 | 2020-10-30 | Lewis | West Virginia | 54041 | 101 | 2 |
683422 | 683422 | 2020-10-30 | Lincoln | West Virginia | 54043 | 258 | 2 |
683423 | 683423 | 2020-10-30 | Logan | West Virginia | 54045 | 785 | 45 |
683424 | 683424 | 2020-10-30 | Marion | West Virginia | 54049 | 405 | 5 |
683425 | 683425 | 2020-10-30 | Marshall | West Virginia | 54051 | 358 | 4 |
683426 | 683426 | 2020-10-30 | Mason | West Virginia | 54053 | 179 | 6 |
683427 | 683427 | 2020-10-30 | McDowell | West Virginia | 54047 | 126 | 0 |
683428 | 683428 | 2020-10-30 | Mercer | West Virginia | 54055 | 781 | 31 |
683429 | 683429 | 2020-10-30 | Mineral | West Virginia | 54057 | 232 | 4 |
683430 | 683430 | 2020-10-30 | Mingo | West Virginia | 54059 | 632 | 10 |
683431 | 683431 | 2020-10-30 | Monongalia | West Virginia | 54061 | 2329 | 7 |
683432 | 683432 | 2020-10-30 | Monroe | West Virginia | 54063 | 260 | 8 |
683433 | 683433 | 2020-10-30 | Morgan | West Virginia | 54065 | 154 | 0 |
683434 | 683434 | 2020-10-30 | Nicholas | West Virginia | 54067 | 190 | 3 |
683435 | 683435 | 2020-10-30 | Ohio | West Virginia | 54069 | 585 | 9 |
683436 | 683436 | 2020-10-30 | Pendleton | West Virginia | 54071 | 77 | 1 |
683437 | 683437 | 2020-10-30 | Pleasants | West Virginia | 54073 | 33 | 3 |
683438 | 683438 | 2020-10-30 | Pocahontas | West Virginia | 54075 | 72 | 0 |
683439 | 683439 | 2020-10-30 | Preston | West Virginia | 54077 | 208 | 4 |
683440 | 683440 | 2020-10-30 | Putnam | West Virginia | 54079 | 926 | 13 |
683441 | 683441 | 2020-10-30 | Raleigh | West Virginia | 54081 | 834 | 9 |
683442 | 683442 | 2020-10-30 | Randolph | West Virginia | 54083 | 419 | 1 |
683443 | 683443 | 2020-10-30 | Ritchie | West Virginia | 54085 | 46 | 0 |
683444 | 683444 | 2020-10-30 | Roane | West Virginia | 54087 | 114 | 2 |
683445 | 683445 | 2020-10-30 | Summers | West Virginia | 54089 | 131 | 1 |
683446 | 683446 | 2020-10-30 | Taylor | West Virginia | 54091 | 170 | 8 |
683447 | 683447 | 2020-10-30 | Tucker | West Virginia | 54093 | 65 | 0 |
683448 | 683448 | 2020-10-30 | Tyler | West Virginia | 54095 | 43 | 0 |
683449 | 683449 | 2020-10-30 | Upshur | West Virginia | 54097 | 268 | 4 |
683450 | 683450 | 2020-10-30 | Wayne | West Virginia | 54099 | 605 | 11 |
683451 | 683451 | 2020-10-30 | Webster | West Virginia | 54101 | 35 | 0 |
683452 | 683452 | 2020-10-30 | Wetzel | West Virginia | 54103 | 202 | 6 |
683453 | 683453 | 2020-10-30 | Wirt | West Virginia | 54105 | 55 | 0 |
683454 | 683454 | 2020-10-30 | Wood | West Virginia | 54107 | 647 | 6 |
683455 | 683455 | 2020-10-30 | Wyoming | West Virginia | 54109 | 321 | 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);