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-10-26 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 |
---|---|---|---|---|---|---|---|
670430 | 670430 | 2020-10-26 | Barbour | West Virginia | 54001 | 175 | 1 |
670431 | 670431 | 2020-10-26 | Berkeley | West Virginia | 54003 | 1534 | 17 |
670432 | 670432 | 2020-10-26 | Boone | West Virginia | 54005 | 339 | 3 |
670433 | 670433 | 2020-10-26 | Braxton | West Virginia | 54007 | 62 | 0 |
670434 | 670434 | 2020-10-26 | Brooke | West Virginia | 54009 | 214 | 4 |
670435 | 670435 | 2020-10-26 | Cabell | West Virginia | 54011 | 1354 | 21 |
670436 | 670436 | 2020-10-26 | Calhoun | West Virginia | 54013 | 34 | 0 |
670437 | 670437 | 2020-10-26 | Clay | West Virginia | 54015 | 60 | 3 |
670438 | 670438 | 2020-10-26 | Doddridge | West Virginia | 54017 | 70 | 1 |
670439 | 670439 | 2020-10-26 | Fayette | West Virginia | 54019 | 762 | 20 |
670440 | 670440 | 2020-10-26 | Gilmer | West Virginia | 54021 | 64 | 0 |
670441 | 670441 | 2020-10-26 | Grant | West Virginia | 54023 | 188 | 8 |
670442 | 670442 | 2020-10-26 | Greenbrier | West Virginia | 54025 | 181 | 4 |
670443 | 670443 | 2020-10-26 | Hampshire | West Virginia | 54027 | 125 | 1 |
670444 | 670444 | 2020-10-26 | Hancock | West Virginia | 54029 | 214 | 1 |
670445 | 670445 | 2020-10-26 | Hardy | West Virginia | 54031 | 105 | 1 |
670446 | 670446 | 2020-10-26 | Harrison | West Virginia | 54033 | 644 | 12 |
670447 | 670447 | 2020-10-26 | Jackson | West Virginia | 54035 | 378 | 24 |
670448 | 670448 | 2020-10-26 | Jefferson | West Virginia | 54037 | 567 | 4 |
670449 | 670449 | 2020-10-26 | Kanawha | West Virginia | 54039 | 3564 | 101 |
670450 | 670450 | 2020-10-26 | Lewis | West Virginia | 54041 | 79 | 2 |
670451 | 670451 | 2020-10-26 | Lincoln | West Virginia | 54043 | 236 | 2 |
670452 | 670452 | 2020-10-26 | Logan | West Virginia | 54045 | 748 | 45 |
670453 | 670453 | 2020-10-26 | Marion | West Virginia | 54049 | 371 | 5 |
670454 | 670454 | 2020-10-26 | Marshall | West Virginia | 54051 | 290 | 4 |
670455 | 670455 | 2020-10-26 | Mason | West Virginia | 54053 | 174 | 6 |
670456 | 670456 | 2020-10-26 | McDowell | West Virginia | 54047 | 117 | 0 |
670457 | 670457 | 2020-10-26 | Mercer | West Virginia | 54055 | 704 | 30 |
670458 | 670458 | 2020-10-26 | Mineral | West Virginia | 54057 | 212 | 4 |
670459 | 670459 | 2020-10-26 | Mingo | West Virginia | 54059 | 564 | 10 |
670460 | 670460 | 2020-10-26 | Monongalia | West Virginia | 54061 | 2290 | 5 |
670461 | 670461 | 2020-10-26 | Monroe | West Virginia | 54063 | 241 | 8 |
670462 | 670462 | 2020-10-26 | Morgan | West Virginia | 54065 | 141 | 0 |
670463 | 670463 | 2020-10-26 | Nicholas | West Virginia | 54067 | 185 | 3 |
670464 | 670464 | 2020-10-26 | Ohio | West Virginia | 54069 | 514 | 8 |
670465 | 670465 | 2020-10-26 | Pendleton | West Virginia | 54071 | 74 | 1 |
670466 | 670466 | 2020-10-26 | Pleasants | West Virginia | 54073 | 25 | 3 |
670467 | 670467 | 2020-10-26 | Pocahontas | West Virginia | 54075 | 68 | 0 |
670468 | 670468 | 2020-10-26 | Preston | West Virginia | 54077 | 199 | 4 |
670469 | 670469 | 2020-10-26 | Putnam | West Virginia | 54079 | 842 | 13 |
670470 | 670470 | 2020-10-26 | Raleigh | West Virginia | 54081 | 761 | 8 |
670471 | 670471 | 2020-10-26 | Randolph | West Virginia | 54083 | 410 | 1 |
670472 | 670472 | 2020-10-26 | Ritchie | West Virginia | 54085 | 36 | 0 |
670473 | 670473 | 2020-10-26 | Roane | West Virginia | 54087 | 100 | 2 |
670474 | 670474 | 2020-10-26 | Summers | West Virginia | 54089 | 103 | 1 |
670475 | 670475 | 2020-10-26 | Taylor | West Virginia | 54091 | 166 | 8 |
670476 | 670476 | 2020-10-26 | Tucker | West Virginia | 54093 | 63 | 0 |
670477 | 670477 | 2020-10-26 | Tyler | West Virginia | 54095 | 32 | 0 |
670478 | 670478 | 2020-10-26 | Upshur | West Virginia | 54097 | 243 | 2 |
670479 | 670479 | 2020-10-26 | Wayne | West Virginia | 54099 | 562 | 11 |
670480 | 670480 | 2020-10-26 | Webster | West Virginia | 54101 | 29 | 0 |
670481 | 670481 | 2020-10-26 | Wetzel | West Virginia | 54103 | 171 | 1 |
670482 | 670482 | 2020-10-26 | Wirt | West Virginia | 54105 | 45 | 0 |
670483 | 670483 | 2020-10-26 | Wood | West Virginia | 54107 | 543 | 6 |
670484 | 670484 | 2020-10-26 | Wyoming | West Virginia | 54109 | 251 | 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);