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-08-17 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 |
---|---|---|---|---|---|---|---|
443766 | 443766 | 2020-08-17 | Barbour | West Virginia | 54001 | 33 | 1 |
443767 | 443767 | 2020-08-17 | Berkeley | West Virginia | 54003 | 738 | 11 |
443768 | 443768 | 2020-08-17 | Boone | West Virginia | 54005 | 120 | 0 |
443769 | 443769 | 2020-08-17 | Braxton | West Virginia | 54007 | 8 | 0 |
443770 | 443770 | 2020-08-17 | Brooke | West Virginia | 54009 | 77 | 1 |
443771 | 443771 | 2020-08-17 | Cabell | West Virginia | 54011 | 459 | 3 |
443772 | 443772 | 2020-08-17 | Calhoun | West Virginia | 54013 | 7 | 0 |
443773 | 443773 | 2020-08-17 | Clay | West Virginia | 54015 | 18 | 1 |
443774 | 443774 | 2020-08-17 | Doddridge | West Virginia | 54017 | 6 | 0 |
443775 | 443775 | 2020-08-17 | Fayette | West Virginia | 54019 | 168 | 7 |
443776 | 443776 | 2020-08-17 | Gilmer | West Virginia | 54021 | 18 | 0 |
443777 | 443777 | 2020-08-17 | Grant | West Virginia | 54023 | 131 | 4 |
443778 | 443778 | 2020-08-17 | Greenbrier | West Virginia | 54025 | 96 | 3 |
443779 | 443779 | 2020-08-17 | Hampshire | West Virginia | 54027 | 89 | 1 |
443780 | 443780 | 2020-08-17 | Hancock | West Virginia | 54029 | 114 | 0 |
443781 | 443781 | 2020-08-17 | Hardy | West Virginia | 54031 | 63 | 0 |
443782 | 443782 | 2020-08-17 | Harrison | West Virginia | 54033 | 245 | 1 |
443783 | 443783 | 2020-08-17 | Jackson | West Virginia | 54035 | 168 | 19 |
443784 | 443784 | 2020-08-17 | Jefferson | West Virginia | 54037 | 305 | 4 |
443785 | 443785 | 2020-08-17 | Kanawha | West Virginia | 54039 | 1095 | 24 |
443786 | 443786 | 2020-08-17 | Lewis | West Virginia | 54041 | 28 | 2 |
443787 | 443787 | 2020-08-17 | Lincoln | West Virginia | 54043 | 108 | 0 |
443788 | 443788 | 2020-08-17 | Logan | West Virginia | 54045 | 362 | 11 |
443789 | 443789 | 2020-08-17 | Marion | West Virginia | 54049 | 199 | 2 |
443790 | 443790 | 2020-08-17 | Marshall | West Virginia | 54051 | 130 | 1 |
443791 | 443791 | 2020-08-17 | Mason | West Virginia | 54053 | 74 | 1 |
443792 | 443792 | 2020-08-17 | McDowell | West Virginia | 54047 | 67 | 0 |
443793 | 443793 | 2020-08-17 | Mercer | West Virginia | 54055 | 243 | 18 |
443794 | 443794 | 2020-08-17 | Mineral | West Virginia | 54057 | 127 | 4 |
443795 | 443795 | 2020-08-17 | Mingo | West Virginia | 54059 | 202 | 5 |
443796 | 443796 | 2020-08-17 | Monongalia | West Virginia | 54061 | 992 | 5 |
443797 | 443797 | 2020-08-17 | Monroe | West Virginia | 54063 | 20 | 0 |
443798 | 443798 | 2020-08-17 | Morgan | West Virginia | 54065 | 33 | 0 |
443799 | 443799 | 2020-08-17 | Nicholas | West Virginia | 54067 | 40 | 1 |
443800 | 443800 | 2020-08-17 | Ohio | West Virginia | 54069 | 283 | 4 |
443801 | 443801 | 2020-08-17 | Pendleton | West Virginia | 54071 | 43 | 1 |
443802 | 443802 | 2020-08-17 | Pleasants | West Virginia | 54073 | 14 | 2 |
443803 | 443803 | 2020-08-17 | Pocahontas | West Virginia | 54075 | 42 | 0 |
443804 | 443804 | 2020-08-17 | Preston | West Virginia | 54077 | 130 | 4 |
443805 | 443805 | 2020-08-17 | Putnam | West Virginia | 54079 | 225 | 0 |
443806 | 443806 | 2020-08-17 | Raleigh | West Virginia | 54081 | 304 | 1 |
443807 | 443807 | 2020-08-17 | Randolph | West Virginia | 54083 | 213 | 0 |
443808 | 443808 | 2020-08-17 | Ritchie | West Virginia | 54085 | 3 | 0 |
443809 | 443809 | 2020-08-17 | Roane | West Virginia | 54087 | 20 | 1 |
443810 | 443810 | 2020-08-17 | Summers | West Virginia | 54089 | 19 | 0 |
443811 | 443811 | 2020-08-17 | Taylor | West Virginia | 54091 | 81 | 1 |
443812 | 443812 | 2020-08-17 | Tucker | West Virginia | 54093 | 11 | 0 |
443813 | 443813 | 2020-08-17 | Tyler | West Virginia | 54095 | 15 | 0 |
443814 | 443814 | 2020-08-17 | Upshur | West Virginia | 54097 | 39 | 0 |
443815 | 443815 | 2020-08-17 | Wayne | West Virginia | 54099 | 221 | 9 |
443816 | 443816 | 2020-08-17 | Webster | West Virginia | 54101 | 4 | 0 |
443817 | 443817 | 2020-08-17 | Wetzel | West Virginia | 54103 | 44 | 0 |
443818 | 443818 | 2020-08-17 | Wirt | West Virginia | 54105 | 7 | 0 |
443819 | 443819 | 2020-08-17 | Wood | West Virginia | 54107 | 283 | 5 |
443820 | 443820 | 2020-08-17 | Wyoming | West Virginia | 54109 | 48 | 2 |
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);