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-12-15 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 |
---|---|---|---|---|---|---|---|
832666 | 832666 | 2020-12-15 | Barbour | West Virginia | 54001 | 564 | 5 |
832667 | 832667 | 2020-12-15 | Berkeley | West Virginia | 54003 | 4652 | 42 |
832668 | 832668 | 2020-12-15 | Boone | West Virginia | 54005 | 820 | 17 |
832669 | 832669 | 2020-12-15 | Braxton | West Virginia | 54007 | 178 | 1 |
832670 | 832670 | 2020-12-15 | Brooke | West Virginia | 54009 | 1045 | 14 |
832671 | 832671 | 2020-12-15 | Cabell | West Virginia | 54011 | 4047 | 75 |
832672 | 832672 | 2020-12-15 | Calhoun | West Virginia | 54013 | 112 | 0 |
832673 | 832673 | 2020-12-15 | Clay | West Virginia | 54015 | 200 | 3 |
832674 | 832674 | 2020-12-15 | Doddridge | West Virginia | 54017 | 175 | 3 |
832675 | 832675 | 2020-12-15 | Fayette | West Virginia | 54019 | 1399 | 40 |
832676 | 832676 | 2020-12-15 | Gilmer | West Virginia | 54021 | 256 | 0 |
832677 | 832677 | 2020-12-15 | Grant | West Virginia | 54023 | 600 | 13 |
832678 | 832678 | 2020-12-15 | Greenbrier | West Virginia | 54025 | 945 | 17 |
832679 | 832679 | 2020-12-15 | Hampshire | West Virginia | 54027 | 664 | 6 |
832680 | 832680 | 2020-12-15 | Hancock | West Virginia | 54029 | 1337 | 16 |
832681 | 832681 | 2020-12-15 | Hardy | West Virginia | 54031 | 548 | 4 |
832682 | 832682 | 2020-12-15 | Harrison | West Virginia | 54033 | 2076 | 26 |
832683 | 832683 | 2020-12-15 | Jackson | West Virginia | 54035 | 920 | 28 |
832684 | 832684 | 2020-12-15 | Jefferson | West Virginia | 54037 | 1874 | 19 |
832685 | 832685 | 2020-12-15 | Kanawha | West Virginia | 54039 | 7213 | 171 |
832686 | 832686 | 2020-12-15 | Lewis | West Virginia | 54041 | 347 | 3 |
832687 | 832687 | 2020-12-15 | Lincoln | West Virginia | 54043 | 564 | 7 |
832688 | 832688 | 2020-12-15 | Logan | West Virginia | 54045 | 1236 | 54 |
832689 | 832689 | 2020-12-15 | Marion | West Virginia | 54049 | 1286 | 8 |
832690 | 832690 | 2020-12-15 | Marshall | West Virginia | 54051 | 1693 | 38 |
832691 | 832691 | 2020-12-15 | Mason | West Virginia | 54053 | 815 | 12 |
832692 | 832692 | 2020-12-15 | McDowell | West Virginia | 54047 | 752 | 3 |
832693 | 832693 | 2020-12-15 | Mercer | West Virginia | 54055 | 1905 | 46 |
832694 | 832694 | 2020-12-15 | Mineral | West Virginia | 54057 | 1857 | 52 |
832695 | 832695 | 2020-12-15 | Mingo | West Virginia | 54059 | 1143 | 19 |
832696 | 832696 | 2020-12-15 | Monongalia | West Virginia | 54061 | 4256 | 9 |
832697 | 832697 | 2020-12-15 | Monroe | West Virginia | 54063 | 485 | 11 |
832698 | 832698 | 2020-12-15 | Morgan | West Virginia | 54065 | 476 | 3 |
832699 | 832699 | 2020-12-15 | Nicholas | West Virginia | 54067 | 512 | 6 |
832700 | 832700 | 2020-12-15 | Ohio | West Virginia | 54069 | 2043 | 27 |
832701 | 832701 | 2020-12-15 | Pendleton | West Virginia | 54071 | 188 | 1 |
832702 | 832702 | 2020-12-15 | Pleasants | West Virginia | 54073 | 211 | 5 |
832703 | 832703 | 2020-12-15 | Pocahontas | West Virginia | 54075 | 300 | 2 |
832704 | 832704 | 2020-12-15 | Preston | West Virginia | 54077 | 1111 | 18 |
832705 | 832705 | 2020-12-15 | Putnam | West Virginia | 54079 | 2505 | 50 |
832706 | 832706 | 2020-12-15 | Raleigh | West Virginia | 54081 | 2104 | 20 |
832707 | 832707 | 2020-12-15 | Randolph | West Virginia | 54083 | 927 | 3 |
832708 | 832708 | 2020-12-15 | Ritchie | West Virginia | 54085 | 262 | 7 |
832709 | 832709 | 2020-12-15 | Roane | West Virginia | 54087 | 243 | 5 |
832710 | 832710 | 2020-12-15 | Summers | West Virginia | 54089 | 331 | 13 |
832711 | 832711 | 2020-12-15 | Taylor | West Virginia | 54091 | 507 | 9 |
832712 | 832712 | 2020-12-15 | Tucker | West Virginia | 54093 | 242 | 0 |
832713 | 832713 | 2020-12-15 | Tyler | West Virginia | 54095 | 242 | 2 |
832714 | 832714 | 2020-12-15 | Upshur | West Virginia | 54097 | 644 | 4 |
832715 | 832715 | 2020-12-15 | Wayne | West Virginia | 54099 | 1358 | 18 |
832716 | 832716 | 2020-12-15 | Webster | West Virginia | 54101 | 112 | 0 |
832717 | 832717 | 2020-12-15 | Wetzel | West Virginia | 54103 | 533 | 14 |
832718 | 832718 | 2020-12-15 | Wirt | West Virginia | 54105 | 161 | 1 |
832719 | 832719 | 2020-12-15 | Wood | West Virginia | 54107 | 3761 | 29 |
832720 | 832720 | 2020-12-15 | Wyoming | West Virginia | 54109 | 971 | 13 |
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);