ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2020-12-28" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
874853 | 874853 | 2020-12-28 | Barbour | West Virginia | 54001 | 699 | 9 |
874854 | 874854 | 2020-12-28 | Berkeley | West Virginia | 54003 | 5964 | 49 |
874855 | 874855 | 2020-12-28 | Boone | West Virginia | 54005 | 1019 | 20 |
874856 | 874856 | 2020-12-28 | Braxton | West Virginia | 54007 | 275 | 1 |
874857 | 874857 | 2020-12-28 | Brooke | West Virginia | 54009 | 1312 | 22 |
874858 | 874858 | 2020-12-28 | Cabell | West Virginia | 54011 | 4945 | 95 |
874859 | 874859 | 2020-12-28 | Calhoun | West Virginia | 54013 | 124 | 0 |
874860 | 874860 | 2020-12-28 | Clay | West Virginia | 54015 | 252 | 4 |
874861 | 874861 | 2020-12-28 | Doddridge | West Virginia | 54017 | 236 | 3 |
874862 | 874862 | 2020-12-28 | Fayette | West Virginia | 54019 | 1673 | 47 |
874863 | 874863 | 2020-12-28 | Gilmer | West Virginia | 54021 | 375 | 1 |
874864 | 874864 | 2020-12-28 | Grant | West Virginia | 54023 | 739 | 17 |
874865 | 874865 | 2020-12-28 | Greenbrier | West Virginia | 54025 | 1368 | 28 |
874866 | 874866 | 2020-12-28 | Hampshire | West Virginia | 54027 | 926 | 11 |
874867 | 874867 | 2020-12-28 | Hancock | West Virginia | 54029 | 1740 | 33 |
874868 | 874868 | 2020-12-28 | Hardy | West Virginia | 54031 | 734 | 6 |
874869 | 874869 | 2020-12-28 | Harrison | West Virginia | 54033 | 2786 | 31 |
874870 | 874870 | 2020-12-28 | Jackson | West Virginia | 54035 | 1110 | 29 |
874871 | 874871 | 2020-12-28 | Jefferson | West Virginia | 54037 | 2249 | 25 |
874872 | 874872 | 2020-12-28 | Kanawha | West Virginia | 54039 | 8360 | 196 |
874873 | 874873 | 2020-12-28 | Lewis | West Virginia | 54041 | 471 | 3 |
874874 | 874874 | 2020-12-28 | Lincoln | West Virginia | 54043 | 723 | 8 |
874875 | 874875 | 2020-12-28 | Logan | West Virginia | 54045 | 1577 | 55 |
874876 | 874876 | 2020-12-28 | Marion | West Virginia | 54049 | 1676 | 12 |
874877 | 874877 | 2020-12-28 | Marshall | West Virginia | 54051 | 1891 | 51 |
874878 | 874878 | 2020-12-28 | Mason | West Virginia | 54053 | 980 | 14 |
874879 | 874879 | 2020-12-28 | McDowell | West Virginia | 54047 | 926 | 4 |
874880 | 874880 | 2020-12-28 | Mercer | West Virginia | 54055 | 2622 | 51 |
874881 | 874881 | 2020-12-28 | Mineral | West Virginia | 54057 | 2058 | 62 |
874882 | 874882 | 2020-12-28 | Mingo | West Virginia | 54059 | 1379 | 20 |
874883 | 874883 | 2020-12-28 | Monongalia | West Virginia | 54061 | 5110 | 26 |
874884 | 874884 | 2020-12-28 | Monroe | West Virginia | 54063 | 607 | 11 |
874885 | 874885 | 2020-12-28 | Morgan | West Virginia | 54065 | 629 | 8 |
874886 | 874886 | 2020-12-28 | Nicholas | West Virginia | 54067 | 628 | 7 |
874887 | 874887 | 2020-12-28 | Ohio | West Virginia | 54069 | 2417 | 33 |
874888 | 874888 | 2020-12-28 | Pendleton | West Virginia | 54071 | 276 | 1 |
874889 | 874889 | 2020-12-28 | Pleasants | West Virginia | 54073 | 547 | 5 |
874890 | 874890 | 2020-12-28 | Pocahontas | West Virginia | 54075 | 338 | 9 |
874891 | 874891 | 2020-12-28 | Preston | West Virginia | 54077 | 1586 | 27 |
874892 | 874892 | 2020-12-28 | Putnam | West Virginia | 54079 | 2880 | 54 |
874893 | 874893 | 2020-12-28 | Raleigh | West Virginia | 54081 | 2562 | 28 |
874894 | 874894 | 2020-12-28 | Randolph | West Virginia | 54083 | 1054 | 6 |
874895 | 874895 | 2020-12-28 | Ritchie | West Virginia | 54085 | 328 | 7 |
874896 | 874896 | 2020-12-28 | Roane | West Virginia | 54087 | 283 | 5 |
874897 | 874897 | 2020-12-28 | Summers | West Virginia | 54089 | 406 | 15 |
874898 | 874898 | 2020-12-28 | Taylor | West Virginia | 54091 | 656 | 13 |
874899 | 874899 | 2020-12-28 | Tucker | West Virginia | 54093 | 303 | 1 |
874900 | 874900 | 2020-12-28 | Tyler | West Virginia | 54095 | 332 | 2 |
874901 | 874901 | 2020-12-28 | Upshur | West Virginia | 54097 | 836 | 4 |
874902 | 874902 | 2020-12-28 | Wayne | West Virginia | 54099 | 1627 | 19 |
874903 | 874903 | 2020-12-28 | Webster | West Virginia | 54101 | 134 | 0 |
874904 | 874904 | 2020-12-28 | Wetzel | West Virginia | 54103 | 657 | 16 |
874905 | 874905 | 2020-12-28 | Wirt | West Virginia | 54105 | 210 | 1 |
874906 | 874906 | 2020-12-28 | Wood | West Virginia | 54107 | 4735 | 41 |
874907 | 874907 | 2020-12-28 | Wyoming | West Virginia | 54109 | 1106 | 17 |
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);