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 2022-03-20 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 |
---|---|---|---|---|---|---|---|
2326894 | 2326894 | 2022-03-20 | Barbour | West Virginia | 54001 | 4777 | 75 |
2326895 | 2326895 | 2022-03-20 | Berkeley | West Virginia | 54003 | 35545 | 278 |
2326896 | 2326896 | 2022-03-20 | Boone | West Virginia | 54005 | 6551 | 75 |
2326897 | 2326897 | 2022-03-20 | Braxton | West Virginia | 54007 | 3880 | 42 |
2326898 | 2326898 | 2022-03-20 | Brooke | West Virginia | 54009 | 4996 | 104 |
2326899 | 2326899 | 2022-03-20 | Cabell | West Virginia | 54011 | 27291 | 371 |
2326900 | 2326900 | 2022-03-20 | Calhoun | West Virginia | 54013 | 1826 | 13 |
2326901 | 2326901 | 2022-03-20 | Clay | West Virginia | 54015 | 2334 | 40 |
2326902 | 2326902 | 2022-03-20 | Doddridge | West Virginia | 54017 | 2143 | 18 |
2326903 | 2326903 | 2022-03-20 | Fayette | West Virginia | 54019 | 13016 | 191 |
2326904 | 2326904 | 2022-03-20 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2326905 | 2326905 | 2022-03-20 | Grant | West Virginia | 54023 | 3760 | 56 |
2326906 | 2326906 | 2022-03-20 | Greenbrier | West Virginia | 54025 | 9438 | 150 |
2326907 | 2326907 | 2022-03-20 | Hampshire | West Virginia | 54027 | 5803 | 70 |
2326908 | 2326908 | 2022-03-20 | Hancock | West Virginia | 54029 | 6674 | 140 |
2326909 | 2326909 | 2022-03-20 | Hardy | West Virginia | 54031 | 4171 | 49 |
2326910 | 2326910 | 2022-03-20 | Harrison | West Virginia | 54033 | 19730 | 246 |
2326911 | 2326911 | 2022-03-20 | Jackson | West Virginia | 54035 | 6851 | 133 |
2326912 | 2326912 | 2022-03-20 | Jefferson | West Virginia | 54037 | 14147 | 133 |
2326913 | 2326913 | 2022-03-20 | Kanawha | West Virginia | 54039 | 46991 | 700 |
2326914 | 2326914 | 2022-03-20 | Lewis | West Virginia | 54041 | 5293 | 87 |
2326915 | 2326915 | 2022-03-20 | Lincoln | West Virginia | 54043 | 5495 | 76 |
2326916 | 2326916 | 2022-03-20 | Logan | West Virginia | 54045 | 9548 | 181 |
2326917 | 2326917 | 2022-03-20 | Marion | West Virginia | 54049 | 14887 | 175 |
2326918 | 2326918 | 2022-03-20 | Marshall | West Virginia | 54051 | 8909 | 153 |
2326919 | 2326919 | 2022-03-20 | Mason | West Virginia | 54053 | 6625 | 91 |
2326920 | 2326920 | 2022-03-20 | McDowell | West Virginia | 54047 | 5568 | 67 |
2326921 | 2326921 | 2022-03-20 | Mercer | West Virginia | 54055 | 16849 | 256 |
2326922 | 2326922 | 2022-03-20 | Mineral | West Virginia | 54057 | 7822 | 155 |
2326923 | 2326923 | 2022-03-20 | Mingo | West Virginia | 54059 | 7905 | 119 |
2326924 | 2326924 | 2022-03-20 | Monongalia | West Virginia | 54061 | 24475 | 195 |
2326925 | 2326925 | 2022-03-20 | Monroe | West Virginia | 54063 | 4173 | 42 |
2326926 | 2326926 | 2022-03-20 | Morgan | West Virginia | 54065 | 4223 | 68 |
2326927 | 2326927 | 2022-03-20 | Nicholas | West Virginia | 54067 | 7273 | 92 |
2326928 | 2326928 | 2022-03-20 | Ohio | West Virginia | 54069 | 11015 | 160 |
2326929 | 2326929 | 2022-03-20 | Pendleton | West Virginia | 54071 | 1932 | 17 |
2326930 | 2326930 | 2022-03-20 | Pleasants | West Virginia | 54073 | 2060 | 34 |
2326931 | 2326931 | 2022-03-20 | Pocahontas | West Virginia | 54075 | 2004 | 28 |
2326932 | 2326932 | 2022-03-20 | Preston | West Virginia | 54077 | 9206 | 132 |
2326933 | 2326933 | 2022-03-20 | Putnam | West Virginia | 54079 | 16567 | 173 |
2326934 | 2326934 | 2022-03-20 | Raleigh | West Virginia | 54081 | 22598 | 327 |
2326935 | 2326935 | 2022-03-20 | Randolph | West Virginia | 54083 | 9344 | 81 |
2326936 | 2326936 | 2022-03-20 | Ritchie | West Virginia | 54085 | 2425 | 31 |
2326937 | 2326937 | 2022-03-20 | Roane | West Virginia | 54087 | 3134 | 37 |
2326938 | 2326938 | 2022-03-20 | Summers | West Virginia | 54089 | 2791 | 50 |
2326939 | 2326939 | 2022-03-20 | Taylor | West Virginia | 54091 | 4492 | 70 |
2326940 | 2326940 | 2022-03-20 | Tucker | West Virginia | 54093 | 1973 | 34 |
2326941 | 2326941 | 2022-03-20 | Tyler | West Virginia | 54095 | 2193 | 31 |
2326942 | 2326942 | 2022-03-20 | Upshur | West Virginia | 54097 | 6793 | 89 |
2326943 | 2326943 | 2022-03-20 | Wayne | West Virginia | 54099 | 9789 | 117 |
2326944 | 2326944 | 2022-03-20 | Webster | West Virginia | 54101 | 2247 | 29 |
2326945 | 2326945 | 2022-03-20 | Wetzel | West Virginia | 54103 | 4313 | 81 |
2326946 | 2326946 | 2022-03-20 | Wirt | West Virginia | 54105 | 1434 | 23 |
2326947 | 2326947 | 2022-03-20 | Wood | West Virginia | 54107 | 22094 | 338 |
2326948 | 2326948 | 2022-03-20 | Wyoming | West Virginia | 54109 | 6948 | 105 |
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);