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-22 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
657454 | 657454 | 2020-10-22 | Barbour | West Virginia | 54001 | 166 | 1 |
657455 | 657455 | 2020-10-22 | Berkeley | West Virginia | 54003 | 1473 | 17 |
657456 | 657456 | 2020-10-22 | Boone | West Virginia | 54005 | 318 | 3 |
657457 | 657457 | 2020-10-22 | Braxton | West Virginia | 54007 | 51 | 0 |
657458 | 657458 | 2020-10-22 | Brooke | West Virginia | 54009 | 199 | 3 |
657459 | 657459 | 2020-10-22 | Cabell | West Virginia | 54011 | 1266 | 20 |
657460 | 657460 | 2020-10-22 | Calhoun | West Virginia | 54013 | 33 | 0 |
657461 | 657461 | 2020-10-22 | Clay | West Virginia | 54015 | 56 | 3 |
657462 | 657462 | 2020-10-22 | Doddridge | West Virginia | 54017 | 67 | 1 |
657463 | 657463 | 2020-10-22 | Fayette | West Virginia | 54019 | 739 | 20 |
657464 | 657464 | 2020-10-22 | Gilmer | West Virginia | 54021 | 64 | 0 |
657465 | 657465 | 2020-10-22 | Grant | West Virginia | 54023 | 179 | 8 |
657466 | 657466 | 2020-10-22 | Greenbrier | West Virginia | 54025 | 165 | 4 |
657467 | 657467 | 2020-10-22 | Hampshire | West Virginia | 54027 | 122 | 1 |
657468 | 657468 | 2020-10-22 | Hancock | West Virginia | 54029 | 198 | 1 |
657469 | 657469 | 2020-10-22 | Hardy | West Virginia | 54031 | 102 | 1 |
657470 | 657470 | 2020-10-22 | Harrison | West Virginia | 54033 | 629 | 12 |
657471 | 657471 | 2020-10-22 | Jackson | West Virginia | 54035 | 363 | 24 |
657472 | 657472 | 2020-10-22 | Jefferson | West Virginia | 54037 | 545 | 4 |
657473 | 657473 | 2020-10-22 | Kanawha | West Virginia | 54039 | 3426 | 101 |
657474 | 657474 | 2020-10-22 | Lewis | West Virginia | 54041 | 70 | 2 |
657475 | 657475 | 2020-10-22 | Lincoln | West Virginia | 54043 | 221 | 2 |
657476 | 657476 | 2020-10-22 | Logan | West Virginia | 54045 | 727 | 45 |
657477 | 657477 | 2020-10-22 | Marion | West Virginia | 54049 | 366 | 5 |
657478 | 657478 | 2020-10-22 | Marshall | West Virginia | 54051 | 267 | 3 |
657479 | 657479 | 2020-10-22 | Mason | West Virginia | 54053 | 168 | 6 |
657480 | 657480 | 2020-10-22 | McDowell | West Virginia | 54047 | 107 | 0 |
657481 | 657481 | 2020-10-22 | Mercer | West Virginia | 54055 | 625 | 30 |
657482 | 657482 | 2020-10-22 | Mineral | West Virginia | 54057 | 204 | 4 |
657483 | 657483 | 2020-10-22 | Mingo | West Virginia | 54059 | 538 | 10 |
657484 | 657484 | 2020-10-22 | Monongalia | West Virginia | 54061 | 2248 | 5 |
657485 | 657485 | 2020-10-22 | Monroe | West Virginia | 54063 | 214 | 8 |
657486 | 657486 | 2020-10-22 | Morgan | West Virginia | 54065 | 114 | 0 |
657487 | 657487 | 2020-10-22 | Nicholas | West Virginia | 54067 | 179 | 3 |
657488 | 657488 | 2020-10-22 | Ohio | West Virginia | 54069 | 485 | 8 |
657489 | 657489 | 2020-10-22 | Pendleton | West Virginia | 54071 | 73 | 1 |
657490 | 657490 | 2020-10-22 | Pleasants | West Virginia | 54073 | 23 | 3 |
657491 | 657491 | 2020-10-22 | Pocahontas | West Virginia | 54075 | 66 | 0 |
657492 | 657492 | 2020-10-22 | Preston | West Virginia | 54077 | 186 | 4 |
657493 | 657493 | 2020-10-22 | Putnam | West Virginia | 54079 | 810 | 10 |
657494 | 657494 | 2020-10-22 | Raleigh | West Virginia | 54081 | 702 | 8 |
657495 | 657495 | 2020-10-22 | Randolph | West Virginia | 54083 | 395 | 1 |
657496 | 657496 | 2020-10-22 | Ritchie | West Virginia | 54085 | 33 | 0 |
657497 | 657497 | 2020-10-22 | Roane | West Virginia | 54087 | 92 | 2 |
657498 | 657498 | 2020-10-22 | Summers | West Virginia | 54089 | 88 | 1 |
657499 | 657499 | 2020-10-22 | Taylor | West Virginia | 54091 | 164 | 8 |
657500 | 657500 | 2020-10-22 | Tucker | West Virginia | 54093 | 60 | 0 |
657501 | 657501 | 2020-10-22 | Tyler | West Virginia | 54095 | 28 | 0 |
657502 | 657502 | 2020-10-22 | Upshur | West Virginia | 54097 | 233 | 2 |
657503 | 657503 | 2020-10-22 | Wayne | West Virginia | 54099 | 523 | 11 |
657504 | 657504 | 2020-10-22 | Webster | West Virginia | 54101 | 25 | 0 |
657505 | 657505 | 2020-10-22 | Wetzel | West Virginia | 54103 | 112 | 1 |
657506 | 657506 | 2020-10-22 | Wirt | West Virginia | 54105 | 35 | 0 |
657507 | 657507 | 2020-10-22 | Wood | West Virginia | 54107 | 513 | 6 |
657508 | 657508 | 2020-10-22 | Wyoming | West Virginia | 54109 | 202 | 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);