ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2020-09-02" 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 |
---|---|---|---|---|---|---|---|
495458 | 495458 | 2020-09-02 | Barbour | West Virginia | 54001 | 34 | 1 |
495459 | 495459 | 2020-09-02 | Berkeley | West Virginia | 54003 | 808 | 11 |
495460 | 495460 | 2020-09-02 | Boone | West Virginia | 54005 | 143 | 0 |
495461 | 495461 | 2020-09-02 | Braxton | West Virginia | 54007 | 9 | 0 |
495462 | 495462 | 2020-09-02 | Brooke | West Virginia | 54009 | 95 | 1 |
495463 | 495463 | 2020-09-02 | Cabell | West Virginia | 54011 | 555 | 8 |
495464 | 495464 | 2020-09-02 | Calhoun | West Virginia | 54013 | 10 | 0 |
495465 | 495465 | 2020-09-02 | Clay | West Virginia | 54015 | 27 | 2 |
495466 | 495466 | 2020-09-02 | Doddridge | West Virginia | 54017 | 6 | 0 |
495467 | 495467 | 2020-09-02 | Fayette | West Virginia | 54019 | 365 | 10 |
495468 | 495468 | 2020-09-02 | Gilmer | West Virginia | 54021 | 19 | 0 |
495469 | 495469 | 2020-09-02 | Grant | West Virginia | 54023 | 141 | 6 |
495470 | 495470 | 2020-09-02 | Greenbrier | West Virginia | 54025 | 105 | 3 |
495471 | 495471 | 2020-09-02 | Hampshire | West Virginia | 54027 | 92 | 1 |
495472 | 495472 | 2020-09-02 | Hancock | West Virginia | 54029 | 121 | 0 |
495473 | 495473 | 2020-09-02 | Hardy | West Virginia | 54031 | 75 | 0 |
495474 | 495474 | 2020-09-02 | Harrison | West Virginia | 54033 | 272 | 2 |
495475 | 495475 | 2020-09-02 | Jackson | West Virginia | 54035 | 204 | 20 |
495476 | 495476 | 2020-09-02 | Jefferson | West Virginia | 54037 | 365 | 4 |
495477 | 495477 | 2020-09-02 | Kanawha | West Virginia | 54039 | 1515 | 36 |
495478 | 495478 | 2020-09-02 | Lewis | West Virginia | 54041 | 33 | 2 |
495479 | 495479 | 2020-09-02 | Lincoln | West Virginia | 54043 | 123 | 1 |
495480 | 495480 | 2020-09-02 | Logan | West Virginia | 54045 | 501 | 30 |
495481 | 495481 | 2020-09-02 | Marion | West Virginia | 54049 | 219 | 2 |
495482 | 495482 | 2020-09-02 | Marshall | West Virginia | 54051 | 133 | 1 |
495483 | 495483 | 2020-09-02 | Mason | West Virginia | 54053 | 109 | 1 |
495484 | 495484 | 2020-09-02 | McDowell | West Virginia | 54047 | 71 | 0 |
495485 | 495485 | 2020-09-02 | Mercer | West Virginia | 54055 | 318 | 23 |
495486 | 495486 | 2020-09-02 | Mineral | West Virginia | 54057 | 144 | 4 |
495487 | 495487 | 2020-09-02 | Mingo | West Virginia | 54059 | 250 | 6 |
495488 | 495488 | 2020-09-02 | Monongalia | West Virginia | 54061 | 1209 | 5 |
495489 | 495489 | 2020-09-02 | Monroe | West Virginia | 54063 | 126 | 5 |
495490 | 495490 | 2020-09-02 | Morgan | West Virginia | 54065 | 37 | 0 |
495491 | 495491 | 2020-09-02 | Nicholas | West Virginia | 54067 | 53 | 3 |
495492 | 495492 | 2020-09-02 | Ohio | West Virginia | 54069 | 289 | 6 |
495493 | 495493 | 2020-09-02 | Pendleton | West Virginia | 54071 | 45 | 1 |
495494 | 495494 | 2020-09-02 | Pleasants | West Virginia | 54073 | 15 | 2 |
495495 | 495495 | 2020-09-02 | Pocahontas | West Virginia | 54075 | 43 | 0 |
495496 | 495496 | 2020-09-02 | Preston | West Virginia | 54077 | 140 | 4 |
495497 | 495497 | 2020-09-02 | Putnam | West Virginia | 54079 | 294 | 0 |
495498 | 495498 | 2020-09-02 | Raleigh | West Virginia | 54081 | 372 | 4 |
495499 | 495499 | 2020-09-02 | Randolph | West Virginia | 54083 | 227 | 0 |
495500 | 495500 | 2020-09-02 | Ritchie | West Virginia | 54085 | 5 | 0 |
495501 | 495501 | 2020-09-02 | Roane | West Virginia | 54087 | 33 | 1 |
495502 | 495502 | 2020-09-02 | Summers | West Virginia | 54089 | 19 | 0 |
495503 | 495503 | 2020-09-02 | Taylor | West Virginia | 54091 | 106 | 6 |
495504 | 495504 | 2020-09-02 | Tucker | West Virginia | 54093 | 11 | 0 |
495505 | 495505 | 2020-09-02 | Tyler | West Virginia | 54095 | 15 | 0 |
495506 | 495506 | 2020-09-02 | Upshur | West Virginia | 54097 | 45 | 0 |
495507 | 495507 | 2020-09-02 | Wayne | West Virginia | 54099 | 259 | 10 |
495508 | 495508 | 2020-09-02 | Webster | West Virginia | 54101 | 7 | 0 |
495509 | 495509 | 2020-09-02 | Wetzel | West Virginia | 54103 | 46 | 0 |
495510 | 495510 | 2020-09-02 | Wirt | West Virginia | 54105 | 8 | 0 |
495511 | 495511 | 2020-09-02 | Wood | West Virginia | 54107 | 309 | 5 |
495512 | 495512 | 2020-09-02 | Wyoming | West Virginia | 54109 | 67 | 3 |
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);