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-13 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 |
---|---|---|---|---|---|---|---|
430863 | 430863 | 2020-08-13 | Barbour | West Virginia | 54001 | 29 | 1 |
430864 | 430864 | 2020-08-13 | Berkeley | West Virginia | 54003 | 720 | 11 |
430865 | 430865 | 2020-08-13 | Boone | West Virginia | 54005 | 112 | 0 |
430866 | 430866 | 2020-08-13 | Braxton | West Virginia | 54007 | 8 | 0 |
430867 | 430867 | 2020-08-13 | Brooke | West Virginia | 54009 | 70 | 1 |
430868 | 430868 | 2020-08-13 | Cabell | West Virginia | 54011 | 431 | 3 |
430869 | 430869 | 2020-08-13 | Calhoun | West Virginia | 54013 | 6 | 0 |
430870 | 430870 | 2020-08-13 | Clay | West Virginia | 54015 | 18 | 1 |
430871 | 430871 | 2020-08-13 | Doddridge | West Virginia | 54017 | 6 | 0 |
430872 | 430872 | 2020-08-13 | Fayette | West Virginia | 54019 | 160 | 7 |
430873 | 430873 | 2020-08-13 | Gilmer | West Virginia | 54021 | 17 | 0 |
430874 | 430874 | 2020-08-13 | Grant | West Virginia | 54023 | 131 | 4 |
430875 | 430875 | 2020-08-13 | Greenbrier | West Virginia | 54025 | 92 | 3 |
430876 | 430876 | 2020-08-13 | Hampshire | West Virginia | 54027 | 84 | 1 |
430877 | 430877 | 2020-08-13 | Hancock | West Virginia | 54029 | 112 | 0 |
430878 | 430878 | 2020-08-13 | Hardy | West Virginia | 54031 | 62 | 0 |
430879 | 430879 | 2020-08-13 | Harrison | West Virginia | 54033 | 238 | 1 |
430880 | 430880 | 2020-08-13 | Jackson | West Virginia | 54035 | 165 | 19 |
430881 | 430881 | 2020-08-13 | Jefferson | West Virginia | 54037 | 302 | 4 |
430882 | 430882 | 2020-08-13 | Kanawha | West Virginia | 54039 | 1020 | 24 |
430883 | 430883 | 2020-08-13 | Lewis | West Virginia | 54041 | 28 | 2 |
430884 | 430884 | 2020-08-13 | Lincoln | West Virginia | 54043 | 96 | 0 |
430885 | 430885 | 2020-08-13 | Logan | West Virginia | 54045 | 276 | 7 |
430886 | 430886 | 2020-08-13 | Marion | West Virginia | 54049 | 195 | 2 |
430887 | 430887 | 2020-08-13 | Marshall | West Virginia | 54051 | 130 | 1 |
430888 | 430888 | 2020-08-13 | Mason | West Virginia | 54053 | 67 | 1 |
430889 | 430889 | 2020-08-13 | McDowell | West Virginia | 54047 | 62 | 0 |
430890 | 430890 | 2020-08-13 | Mercer | West Virginia | 54055 | 216 | 16 |
430891 | 430891 | 2020-08-13 | Mineral | West Virginia | 54057 | 125 | 4 |
430892 | 430892 | 2020-08-13 | Mingo | West Virginia | 54059 | 195 | 5 |
430893 | 430893 | 2020-08-13 | Monongalia | West Virginia | 54061 | 962 | 5 |
430894 | 430894 | 2020-08-13 | Monroe | West Virginia | 54063 | 20 | 0 |
430895 | 430895 | 2020-08-13 | Morgan | West Virginia | 54065 | 31 | 0 |
430896 | 430896 | 2020-08-13 | Nicholas | West Virginia | 54067 | 39 | 1 |
430897 | 430897 | 2020-08-13 | Ohio | West Virginia | 54069 | 271 | 4 |
430898 | 430898 | 2020-08-13 | Pendleton | West Virginia | 54071 | 42 | 1 |
430899 | 430899 | 2020-08-13 | Pleasants | West Virginia | 54073 | 14 | 1 |
430900 | 430900 | 2020-08-13 | Pocahontas | West Virginia | 54075 | 42 | 0 |
430901 | 430901 | 2020-08-13 | Preston | West Virginia | 54077 | 125 | 4 |
430902 | 430902 | 2020-08-13 | Putnam | West Virginia | 54079 | 204 | 0 |
430903 | 430903 | 2020-08-13 | Raleigh | West Virginia | 54081 | 276 | 1 |
430904 | 430904 | 2020-08-13 | Randolph | West Virginia | 54083 | 212 | 0 |
430905 | 430905 | 2020-08-13 | Ritchie | West Virginia | 54085 | 3 | 0 |
430906 | 430906 | 2020-08-13 | Roane | West Virginia | 54087 | 19 | 1 |
430907 | 430907 | 2020-08-13 | Summers | West Virginia | 54089 | 16 | 0 |
430908 | 430908 | 2020-08-13 | Taylor | West Virginia | 54091 | 60 | 1 |
430909 | 430909 | 2020-08-13 | Tucker | West Virginia | 54093 | 11 | 0 |
430910 | 430910 | 2020-08-13 | Tyler | West Virginia | 54095 | 15 | 0 |
430911 | 430911 | 2020-08-13 | Upshur | West Virginia | 54097 | 38 | 0 |
430912 | 430912 | 2020-08-13 | Wayne | West Virginia | 54099 | 214 | 9 |
430913 | 430913 | 2020-08-13 | Webster | West Virginia | 54101 | 4 | 0 |
430914 | 430914 | 2020-08-13 | Wetzel | West Virginia | 54103 | 44 | 0 |
430915 | 430915 | 2020-08-13 | Wirt | West Virginia | 54105 | 7 | 0 |
430916 | 430916 | 2020-08-13 | Wood | West Virginia | 54107 | 266 | 5 |
430917 | 430917 | 2020-08-13 | Wyoming | West Virginia | 54109 | 43 | 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);