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-09-20 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 |
---|---|---|---|---|---|---|---|
553697 | 553697 | 2020-09-20 | Barbour | West Virginia | 54001 | 44 | 1 |
553698 | 553698 | 2020-09-20 | Berkeley | West Virginia | 54003 | 944 | 12 |
553699 | 553699 | 2020-09-20 | Boone | West Virginia | 54005 | 197 | 1 |
553700 | 553700 | 2020-09-20 | Braxton | West Virginia | 54007 | 10 | 0 |
553701 | 553701 | 2020-09-20 | Brooke | West Virginia | 54009 | 107 | 1 |
553702 | 553702 | 2020-09-20 | Cabell | West Virginia | 54011 | 718 | 10 |
553703 | 553703 | 2020-09-20 | Calhoun | West Virginia | 54013 | 24 | 0 |
553704 | 553704 | 2020-09-20 | Clay | West Virginia | 54015 | 35 | 2 |
553705 | 553705 | 2020-09-20 | Doddridge | West Virginia | 54017 | 18 | 0 |
553706 | 553706 | 2020-09-20 | Fayette | West Virginia | 54019 | 564 | 10 |
553707 | 553707 | 2020-09-20 | Gilmer | West Virginia | 54021 | 27 | 0 |
553708 | 553708 | 2020-09-20 | Grant | West Virginia | 54023 | 152 | 7 |
553709 | 553709 | 2020-09-20 | Greenbrier | West Virginia | 54025 | 120 | 3 |
553710 | 553710 | 2020-09-20 | Hampshire | West Virginia | 54027 | 100 | 1 |
553711 | 553711 | 2020-09-20 | Hancock | West Virginia | 54029 | 141 | 0 |
553712 | 553712 | 2020-09-20 | Hardy | West Virginia | 54031 | 81 | 1 |
553713 | 553713 | 2020-09-20 | Harrison | West Virginia | 54033 | 339 | 7 |
553714 | 553714 | 2020-09-20 | Jackson | West Virginia | 54035 | 247 | 23 |
553715 | 553715 | 2020-09-20 | Jefferson | West Virginia | 54037 | 419 | 4 |
553716 | 553716 | 2020-09-20 | Kanawha | West Virginia | 54039 | 2297 | 67 |
553717 | 553717 | 2020-09-20 | Lewis | West Virginia | 54041 | 38 | 2 |
553718 | 553718 | 2020-09-20 | Lincoln | West Virginia | 54043 | 155 | 2 |
553719 | 553719 | 2020-09-20 | Logan | West Virginia | 54045 | 572 | 39 |
553720 | 553720 | 2020-09-20 | Marion | West Virginia | 54049 | 254 | 3 |
553721 | 553721 | 2020-09-20 | Marshall | West Virginia | 54051 | 158 | 1 |
553722 | 553722 | 2020-09-20 | Mason | West Virginia | 54053 | 136 | 5 |
553723 | 553723 | 2020-09-20 | McDowell | West Virginia | 54047 | 80 | 0 |
553724 | 553724 | 2020-09-20 | Mercer | West Virginia | 54055 | 399 | 26 |
553725 | 553725 | 2020-09-20 | Mineral | West Virginia | 54057 | 164 | 4 |
553726 | 553726 | 2020-09-20 | Mingo | West Virginia | 54059 | 354 | 9 |
553727 | 553727 | 2020-09-20 | Monongalia | West Virginia | 54061 | 1876 | 5 |
553728 | 553728 | 2020-09-20 | Monroe | West Virginia | 54063 | 148 | 7 |
553729 | 553729 | 2020-09-20 | Morgan | West Virginia | 54065 | 51 | 0 |
553730 | 553730 | 2020-09-20 | Nicholas | West Virginia | 54067 | 87 | 3 |
553731 | 553731 | 2020-09-20 | Ohio | West Virginia | 54069 | 351 | 6 |
553732 | 553732 | 2020-09-20 | Pendleton | West Virginia | 54071 | 52 | 1 |
553733 | 553733 | 2020-09-20 | Pleasants | West Virginia | 54073 | 17 | 2 |
553734 | 553734 | 2020-09-20 | Pocahontas | West Virginia | 54075 | 59 | 0 |
553735 | 553735 | 2020-09-20 | Preston | West Virginia | 54077 | 149 | 4 |
553736 | 553736 | 2020-09-20 | Putnam | West Virginia | 54079 | 496 | 5 |
553737 | 553737 | 2020-09-20 | Raleigh | West Virginia | 54081 | 472 | 8 |
553738 | 553738 | 2020-09-20 | Randolph | West Virginia | 54083 | 234 | 1 |
553739 | 553739 | 2020-09-20 | Ritchie | West Virginia | 54085 | 10 | 0 |
553740 | 553740 | 2020-09-20 | Roane | West Virginia | 54087 | 49 | 2 |
553741 | 553741 | 2020-09-20 | Summers | West Virginia | 54089 | 41 | 0 |
553742 | 553742 | 2020-09-20 | Taylor | West Virginia | 54091 | 117 | 6 |
553743 | 553743 | 2020-09-20 | Tucker | West Virginia | 54093 | 15 | 0 |
553744 | 553744 | 2020-09-20 | Tyler | West Virginia | 54095 | 15 | 0 |
553745 | 553745 | 2020-09-20 | Upshur | West Virginia | 54097 | 60 | 0 |
553746 | 553746 | 2020-09-20 | Wayne | West Virginia | 54099 | 346 | 10 |
553747 | 553747 | 2020-09-20 | Webster | West Virginia | 54101 | 7 | 0 |
553748 | 553748 | 2020-09-20 | Wetzel | West Virginia | 54103 | 49 | 0 |
553749 | 553749 | 2020-09-20 | Wirt | West Virginia | 54105 | 10 | 0 |
553750 | 553750 | 2020-09-20 | Wood | West Virginia | 54107 | 348 | 6 |
553751 | 553751 | 2020-09-20 | Wyoming | West Virginia | 54109 | 101 | 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);