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-12 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
725566 | 725566 | 2020-11-12 | Barbour | West Virginia | 54001 | 246 | 2 |
725567 | 725567 | 2020-11-12 | Berkeley | West Virginia | 54003 | 2062 | 19 |
725568 | 725568 | 2020-11-12 | Boone | West Virginia | 54005 | 477 | 10 |
725569 | 725569 | 2020-11-12 | Braxton | West Virginia | 54007 | 92 | 0 |
725570 | 725570 | 2020-11-12 | Brooke | West Virginia | 54009 | 326 | 6 |
725571 | 725571 | 2020-11-12 | Cabell | West Virginia | 54011 | 1948 | 41 |
725572 | 725572 | 2020-11-12 | Calhoun | West Virginia | 54013 | 41 | 0 |
725573 | 725573 | 2020-11-12 | Clay | West Virginia | 54015 | 92 | 3 |
725574 | 725574 | 2020-11-12 | Doddridge | West Virginia | 54017 | 83 | 1 |
725575 | 725575 | 2020-11-12 | Fayette | West Virginia | 54019 | 893 | 29 |
725576 | 725576 | 2020-11-12 | Gilmer | West Virginia | 54021 | 166 | 0 |
725577 | 725577 | 2020-11-12 | Grant | West Virginia | 54023 | 222 | 9 |
725578 | 725578 | 2020-11-12 | Greenbrier | West Virginia | 54025 | 278 | 5 |
725579 | 725579 | 2020-11-12 | Hampshire | West Virginia | 54027 | 193 | 1 |
725580 | 725580 | 2020-11-12 | Hancock | West Virginia | 54029 | 326 | 2 |
725581 | 725581 | 2020-11-12 | Hardy | West Virginia | 54031 | 136 | 1 |
725582 | 725582 | 2020-11-12 | Harrison | West Virginia | 54033 | 816 | 14 |
725583 | 725583 | 2020-11-12 | Jackson | West Virginia | 54035 | 482 | 24 |
725584 | 725584 | 2020-11-12 | Jefferson | West Virginia | 54037 | 822 | 11 |
725585 | 725585 | 2020-11-12 | Kanawha | West Virginia | 54039 | 4401 | 121 |
725586 | 725586 | 2020-11-12 | Lewis | West Virginia | 54041 | 182 | 2 |
725587 | 725587 | 2020-11-12 | Lincoln | West Virginia | 54043 | 332 | 2 |
725588 | 725588 | 2020-11-12 | Logan | West Virginia | 54045 | 866 | 47 |
725589 | 725589 | 2020-11-12 | Marion | West Virginia | 54049 | 530 | 5 |
725590 | 725590 | 2020-11-12 | Marshall | West Virginia | 54051 | 659 | 7 |
725591 | 725591 | 2020-11-12 | Mason | West Virginia | 54053 | 218 | 6 |
725592 | 725592 | 2020-11-12 | McDowell | West Virginia | 54047 | 232 | 0 |
725593 | 725593 | 2020-11-12 | Mercer | West Virginia | 54055 | 975 | 35 |
725594 | 725594 | 2020-11-12 | Mineral | West Virginia | 54057 | 463 | 4 |
725595 | 725595 | 2020-11-12 | Mingo | West Virginia | 54059 | 797 | 12 |
725596 | 725596 | 2020-11-12 | Monongalia | West Virginia | 54061 | 2625 | 7 |
725597 | 725597 | 2020-11-12 | Monroe | West Virginia | 54063 | 290 | 8 |
725598 | 725598 | 2020-11-12 | Morgan | West Virginia | 54065 | 191 | 0 |
725599 | 725599 | 2020-11-12 | Nicholas | West Virginia | 54067 | 238 | 4 |
725600 | 725600 | 2020-11-12 | Ohio | West Virginia | 54069 | 898 | 10 |
725601 | 725601 | 2020-11-12 | Pendleton | West Virginia | 54071 | 80 | 1 |
725602 | 725602 | 2020-11-12 | Pleasants | West Virginia | 54073 | 50 | 3 |
725603 | 725603 | 2020-11-12 | Pocahontas | West Virginia | 54075 | 79 | 0 |
725604 | 725604 | 2020-11-12 | Preston | West Virginia | 54077 | 293 | 7 |
725605 | 725605 | 2020-11-12 | Putnam | West Virginia | 54079 | 1260 | 21 |
725606 | 725606 | 2020-11-12 | Raleigh | West Virginia | 54081 | 1049 | 15 |
725607 | 725607 | 2020-11-12 | Randolph | West Virginia | 54083 | 515 | 2 |
725608 | 725608 | 2020-11-12 | Ritchie | West Virginia | 54085 | 79 | 0 |
725609 | 725609 | 2020-11-12 | Roane | West Virginia | 54087 | 127 | 2 |
725610 | 725610 | 2020-11-12 | Summers | West Virginia | 54089 | 195 | 4 |
725611 | 725611 | 2020-11-12 | Taylor | West Virginia | 54091 | 199 | 8 |
725612 | 725612 | 2020-11-12 | Tucker | West Virginia | 54093 | 72 | 0 |
725613 | 725613 | 2020-11-12 | Tyler | West Virginia | 54095 | 95 | 0 |
725614 | 725614 | 2020-11-12 | Upshur | West Virginia | 54097 | 336 | 4 |
725615 | 725615 | 2020-11-12 | Wayne | West Virginia | 54099 | 723 | 12 |
725616 | 725616 | 2020-11-12 | Webster | West Virginia | 54101 | 43 | 0 |
725617 | 725617 | 2020-11-12 | Wetzel | West Virginia | 54103 | 288 | 11 |
725618 | 725618 | 2020-11-12 | Wirt | West Virginia | 54105 | 63 | 1 |
725619 | 725619 | 2020-11-12 | Wood | West Virginia | 54107 | 1285 | 10 |
725620 | 725620 | 2020-11-12 | Wyoming | West Virginia | 54109 | 468 | 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);