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-07-29 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 |
---|---|---|---|---|---|---|---|
382571 | 382571 | 2020-07-29 | Barbour | West Virginia | 54001 | 29 | 1 |
382572 | 382572 | 2020-07-29 | Berkeley | West Virginia | 54003 | 631 | 11 |
382573 | 382573 | 2020-07-29 | Boone | West Virginia | 54005 | 69 | 0 |
382574 | 382574 | 2020-07-29 | Braxton | West Virginia | 54007 | 8 | 0 |
382575 | 382575 | 2020-07-29 | Brooke | West Virginia | 54009 | 54 | 1 |
382576 | 382576 | 2020-07-29 | Cabell | West Virginia | 54011 | 297 | 2 |
382577 | 382577 | 2020-07-29 | Calhoun | West Virginia | 54013 | 6 | 0 |
382578 | 382578 | 2020-07-29 | Clay | West Virginia | 54015 | 17 | 1 |
382579 | 382579 | 2020-07-29 | Doddridge | West Virginia | 54017 | 4 | 0 |
382580 | 382580 | 2020-07-29 | Fayette | West Virginia | 54019 | 124 | 5 |
382581 | 382581 | 2020-07-29 | Gilmer | West Virginia | 54021 | 14 | 0 |
382582 | 382582 | 2020-07-29 | Grant | West Virginia | 54023 | 66 | 0 |
382583 | 382583 | 2020-07-29 | Greenbrier | West Virginia | 54025 | 83 | 3 |
382584 | 382584 | 2020-07-29 | Hampshire | West Virginia | 54027 | 68 | 1 |
382585 | 382585 | 2020-07-29 | Hancock | West Virginia | 54029 | 92 | 0 |
382586 | 382586 | 2020-07-29 | Hardy | West Virginia | 54031 | 52 | 0 |
382587 | 382587 | 2020-07-29 | Harrison | West Virginia | 54033 | 176 | 1 |
382588 | 382588 | 2020-07-29 | Jackson | West Virginia | 54035 | 157 | 19 |
382589 | 382589 | 2020-07-29 | Jefferson | West Virginia | 54037 | 285 | 4 |
382590 | 382590 | 2020-07-29 | Kanawha | West Virginia | 54039 | 729 | 20 |
382591 | 382591 | 2020-07-29 | Lewis | West Virginia | 54041 | 25 | 2 |
382592 | 382592 | 2020-07-29 | Lincoln | West Virginia | 54043 | 56 | 0 |
382593 | 382593 | 2020-07-29 | Logan | West Virginia | 54045 | 106 | 1 |
382594 | 382594 | 2020-07-29 | Marion | West Virginia | 54049 | 167 | 2 |
382595 | 382595 | 2020-07-29 | Marshall | West Virginia | 54051 | 118 | 0 |
382596 | 382596 | 2020-07-29 | Mason | West Virginia | 54053 | 45 | 1 |
382597 | 382597 | 2020-07-29 | McDowell | West Virginia | 54047 | 20 | 0 |
382598 | 382598 | 2020-07-29 | Mercer | West Virginia | 54055 | 126 | 3 |
382599 | 382599 | 2020-07-29 | Mineral | West Virginia | 54057 | 102 | 4 |
382600 | 382600 | 2020-07-29 | Mingo | West Virginia | 54059 | 111 | 2 |
382601 | 382601 | 2020-07-29 | Monongalia | West Virginia | 54061 | 866 | 5 |
382602 | 382602 | 2020-07-29 | Monroe | West Virginia | 54063 | 19 | 0 |
382603 | 382603 | 2020-07-29 | Morgan | West Virginia | 54065 | 25 | 0 |
382604 | 382604 | 2020-07-29 | Nicholas | West Virginia | 54067 | 29 | 1 |
382605 | 382605 | 2020-07-29 | Ohio | West Virginia | 54069 | 243 | 3 |
382606 | 382606 | 2020-07-29 | Pendleton | West Virginia | 54071 | 36 | 1 |
382607 | 382607 | 2020-07-29 | Pleasants | West Virginia | 54073 | 7 | 0 |
382608 | 382608 | 2020-07-29 | Pocahontas | West Virginia | 54075 | 41 | 0 |
382609 | 382609 | 2020-07-29 | Preston | West Virginia | 54077 | 119 | 3 |
382610 | 382610 | 2020-07-29 | Putnam | West Virginia | 54079 | 147 | 0 |
382611 | 382611 | 2020-07-29 | Raleigh | West Virginia | 54081 | 153 | 0 |
382612 | 382612 | 2020-07-29 | Randolph | West Virginia | 54083 | 206 | 0 |
382613 | 382613 | 2020-07-29 | Ritchie | West Virginia | 54085 | 3 | 0 |
382614 | 382614 | 2020-07-29 | Roane | West Virginia | 54087 | 14 | 1 |
382615 | 382615 | 2020-07-29 | Summers | West Virginia | 54089 | 5 | 0 |
382616 | 382616 | 2020-07-29 | Taylor | West Virginia | 54091 | 43 | 0 |
382617 | 382617 | 2020-07-29 | Tucker | West Virginia | 54093 | 9 | 0 |
382618 | 382618 | 2020-07-29 | Tyler | West Virginia | 54095 | 11 | 0 |
382619 | 382619 | 2020-07-29 | Upshur | West Virginia | 54097 | 38 | 0 |
382620 | 382620 | 2020-07-29 | Wayne | West Virginia | 54099 | 178 | 9 |
382621 | 382621 | 2020-07-29 | Webster | West Virginia | 54101 | 3 | 0 |
382622 | 382622 | 2020-07-29 | Wetzel | West Virginia | 54103 | 40 | 0 |
382623 | 382623 | 2020-07-29 | Wirt | West Virginia | 54105 | 6 | 0 |
382624 | 382624 | 2020-07-29 | Wood | West Virginia | 54107 | 230 | 4 |
382625 | 382625 | 2020-07-29 | Wyoming | West Virginia | 54109 | 18 | 1 |
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);