ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2021-09-30" 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 |
---|---|---|---|---|---|---|---|
1770975 | 1770975 | 2021-09-30 | Barbour | West Virginia | 54001 | 2417 | 40 |
1770976 | 1770976 | 2021-09-30 | Berkeley | West Virginia | 54003 | 16695 | 158 |
1770977 | 1770977 | 2021-09-30 | Boone | West Virginia | 54005 | 3147 | 41 |
1770978 | 1770978 | 2021-09-30 | Braxton | West Virginia | 54007 | 1901 | 12 |
1770979 | 1770979 | 2021-09-30 | Brooke | West Virginia | 54009 | 2859 | 67 |
1770980 | 1770980 | 2021-09-30 | Cabell | West Virginia | 54011 | 13583 | 226 |
1770981 | 1770981 | 2021-09-30 | Calhoun | West Virginia | 54013 | 812 | 4 |
1770982 | 1770982 | 2021-09-30 | Clay | West Virginia | 54015 | 1049 | 16 |
1770983 | 1770983 | 2021-09-30 | Doddridge | West Virginia | 54017 | 1044 | 8 |
1770984 | 1770984 | 2021-09-30 | Fayette | West Virginia | 54019 | 5417 | 102 |
1770985 | 1770985 | 2021-09-30 | Gilmer | West Virginia | 54021 | 1211 | 8 |
1770986 | 1770986 | 2021-09-30 | Grant | West Virginia | 54023 | 1919 | 31 |
1770987 | 1770987 | 2021-09-30 | Greenbrier | West Virginia | 54025 | 4472 | 79 |
1770988 | 1770988 | 2021-09-30 | Hampshire | West Virginia | 54027 | 2785 | 43 |
1770989 | 1770989 | 2021-09-30 | Hancock | West Virginia | 54029 | 3751 | 99 |
1770990 | 1770990 | 2021-09-30 | Hardy | West Virginia | 54031 | 2183 | 27 |
1770991 | 1770991 | 2021-09-30 | Harrison | West Virginia | 54033 | 9425 | 115 |
1770992 | 1770992 | 2021-09-30 | Jackson | West Virginia | 54035 | 3414 | 71 |
1770993 | 1770993 | 2021-09-30 | Jefferson | West Virginia | 54037 | 6274 | 75 |
1770994 | 1770994 | 2021-09-30 | Kanawha | West Virginia | 54039 | 21912 | 423 |
1770995 | 1770995 | 2021-09-30 | Lewis | West Virginia | 54041 | 2618 | 36 |
1770996 | 1770996 | 2021-09-30 | Lincoln | West Virginia | 54043 | 2429 | 34 |
1770997 | 1770997 | 2021-09-30 | Logan | West Virginia | 54045 | 4881 | 121 |
1770998 | 1770998 | 2021-09-30 | Marion | West Virginia | 54049 | 6891 | 74 |
1770999 | 1770999 | 2021-09-30 | Marshall | West Virginia | 54051 | 4899 | 98 |
1771000 | 1771000 | 2021-09-30 | Mason | West Virginia | 54053 | 3271 | 48 |
1771001 | 1771001 | 2021-09-30 | McDowell | West Virginia | 54047 | 2587 | 39 |
1771002 | 1771002 | 2021-09-30 | Mercer | West Virginia | 54055 | 7842 | 156 |
1771003 | 1771003 | 2021-09-30 | Mineral | West Virginia | 54057 | 4175 | 104 |
1771004 | 1771004 | 2021-09-30 | Mingo | West Virginia | 54059 | 4190 | 63 |
1771005 | 1771005 | 2021-09-30 | Monongalia | West Virginia | 54061 | 11704 | 116 |
1771006 | 1771006 | 2021-09-30 | Monroe | West Virginia | 54063 | 1937 | 24 |
1771007 | 1771007 | 2021-09-30 | Morgan | West Virginia | 54065 | 1837 | 34 |
1771008 | 1771008 | 2021-09-30 | Nicholas | West Virginia | 54067 | 3128 | 34 |
1771009 | 1771009 | 2021-09-30 | Ohio | West Virginia | 54069 | 5647 | 95 |
1771010 | 1771010 | 2021-09-30 | Pendleton | West Virginia | 54071 | 1042 | 12 |
1771011 | 1771011 | 2021-09-30 | Pleasants | West Virginia | 54073 | 1317 | 22 |
1771012 | 1771012 | 2021-09-30 | Pocahontas | West Virginia | 54075 | 1025 | 16 |
1771013 | 1771013 | 2021-09-30 | Preston | West Virginia | 54077 | 4381 | 60 |
1771014 | 1771014 | 2021-09-30 | Putnam | West Virginia | 54079 | 7825 | 109 |
1771015 | 1771015 | 2021-09-30 | Raleigh | West Virginia | 54081 | 10251 | 137 |
1771016 | 1771016 | 2021-09-30 | Randolph | West Virginia | 54083 | 4678 | 31 |
1771017 | 1771017 | 2021-09-30 | Ritchie | West Virginia | 54085 | 1298 | 15 |
1771018 | 1771018 | 2021-09-30 | Roane | West Virginia | 54087 | 1238 | 14 |
1771019 | 1771019 | 2021-09-30 | Summers | West Virginia | 54089 | 1308 | 26 |
1771020 | 1771020 | 2021-09-30 | Taylor | West Virginia | 54091 | 1961 | 33 |
1771021 | 1771021 | 2021-09-30 | Tucker | West Virginia | 54093 | 941 | 16 |
1771022 | 1771022 | 2021-09-30 | Tyler | West Virginia | 54095 | 1265 | 18 |
1771023 | 1771023 | 2021-09-30 | Upshur | West Virginia | 54097 | 3555 | 56 |
1771024 | 1771024 | 2021-09-30 | Wayne | West Virginia | 54099 | 5077 | 60 |
1771025 | 1771025 | 2021-09-30 | Webster | West Virginia | 54101 | 971 | 14 |
1771026 | 1771026 | 2021-09-30 | Wetzel | West Virginia | 54103 | 2282 | 44 |
1771027 | 1771027 | 2021-09-30 | Wirt | West Virginia | 54105 | 741 | 10 |
1771028 | 1771028 | 2021-09-30 | Wood | West Virginia | 54107 | 11735 | 207 |
1771029 | 1771029 | 2021-09-30 | Wyoming | West Virginia | 54109 | 3262 | 49 |
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);