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 2021-12-23 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 |
---|---|---|---|---|---|---|---|
2043962 | 2043962 | 2021-12-23 | Barbour | West Virginia | 54001 | 3185 | 55 |
2043963 | 2043963 | 2021-12-23 | Berkeley | West Virginia | 54003 | 23000 | 209 |
2043964 | 2043964 | 2021-12-23 | Boone | West Virginia | 54005 | 4215 | 62 |
2043965 | 2043965 | 2021-12-23 | Braxton | West Virginia | 54007 | 2613 | 29 |
2043966 | 2043966 | 2021-12-23 | Brooke | West Virginia | 54009 | 3605 | 86 |
2043967 | 2043967 | 2021-12-23 | Cabell | West Virginia | 54011 | 17113 | 295 |
2043968 | 2043968 | 2021-12-23 | Calhoun | West Virginia | 54013 | 1205 | 9 |
2043969 | 2043969 | 2021-12-23 | Clay | West Virginia | 54015 | 1587 | 25 |
2043970 | 2043970 | 2021-12-23 | Doddridge | West Virginia | 54017 | 1523 | 13 |
2043971 | 2043971 | 2021-12-23 | Fayette | West Virginia | 54019 | 7502 | 147 |
2043972 | 2043972 | 2021-12-23 | Gilmer | West Virginia | 54021 | 1562 | 15 |
2043973 | 2043973 | 2021-12-23 | Grant | West Virginia | 54023 | 2666 | 46 |
2043974 | 2043974 | 2021-12-23 | Greenbrier | West Virginia | 54025 | 5672 | 116 |
2043975 | 2043975 | 2021-12-23 | Hampshire | West Virginia | 54027 | 4010 | 55 |
2043976 | 2043976 | 2021-12-23 | Hancock | West Virginia | 54029 | 4911 | 124 |
2043977 | 2043977 | 2021-12-23 | Hardy | West Virginia | 54031 | 2888 | 39 |
2043978 | 2043978 | 2021-12-23 | Harrison | West Virginia | 54033 | 13134 | 199 |
2043979 | 2043979 | 2021-12-23 | Jackson | West Virginia | 54035 | 4506 | 108 |
2043980 | 2043980 | 2021-12-23 | Jefferson | West Virginia | 54037 | 8570 | 97 |
2043981 | 2043981 | 2021-12-23 | Kanawha | West Virginia | 54039 | 28292 | 566 |
2043982 | 2043982 | 2021-12-23 | Lewis | West Virginia | 54041 | 3585 | 64 |
2043983 | 2043983 | 2021-12-23 | Lincoln | West Virginia | 54043 | 3456 | 54 |
2043984 | 2043984 | 2021-12-23 | Logan | West Virginia | 54045 | 6155 | 153 |
2043985 | 2043985 | 2021-12-23 | Marion | West Virginia | 54049 | 9623 | 140 |
2043986 | 2043986 | 2021-12-23 | Marshall | West Virginia | 54051 | 6014 | 132 |
2043987 | 2043987 | 2021-12-23 | Mason | West Virginia | 54053 | 4256 | 65 |
2043988 | 2043988 | 2021-12-23 | McDowell | West Virginia | 54047 | 3428 | 56 |
2043989 | 2043989 | 2021-12-23 | Mercer | West Virginia | 54055 | 10770 | 196 |
2043990 | 2043990 | 2021-12-23 | Mineral | West Virginia | 54057 | 5268 | 134 |
2043991 | 2043991 | 2021-12-23 | Mingo | West Virginia | 54059 | 5242 | 97 |
2043992 | 2043992 | 2021-12-23 | Monongalia | West Virginia | 54061 | 15194 | 156 |
2043993 | 2043993 | 2021-12-23 | Monroe | West Virginia | 54063 | 2529 | 30 |
2043994 | 2043994 | 2021-12-23 | Morgan | West Virginia | 54065 | 2716 | 53 |
2043995 | 2043995 | 2021-12-23 | Nicholas | West Virginia | 54067 | 4772 | 74 |
2043996 | 2043996 | 2021-12-23 | Ohio | West Virginia | 54069 | 7251 | 128 |
2043997 | 2043997 | 2021-12-23 | Pendleton | West Virginia | 54071 | 1304 | 16 |
2043998 | 2043998 | 2021-12-23 | Pleasants | West Virginia | 54073 | 1556 | 31 |
2043999 | 2043999 | 2021-12-23 | Pocahontas | West Virginia | 54075 | 1329 | 22 |
2044000 | 2044000 | 2021-12-23 | Preston | West Virginia | 54077 | 6268 | 112 |
2044001 | 2044001 | 2021-12-23 | Putnam | West Virginia | 54079 | 10401 | 146 |
2044002 | 2044002 | 2021-12-23 | Raleigh | West Virginia | 54081 | 13605 | 214 |
2044003 | 2044003 | 2021-12-23 | Randolph | West Virginia | 54083 | 5821 | 63 |
2044004 | 2044004 | 2021-12-23 | Ritchie | West Virginia | 54085 | 1670 | 24 |
2044005 | 2044005 | 2021-12-23 | Roane | West Virginia | 54087 | 1996 | 27 |
2044006 | 2044006 | 2021-12-23 | Summers | West Virginia | 54089 | 1666 | 37 |
2044007 | 2044007 | 2021-12-23 | Taylor | West Virginia | 54091 | 2857 | 50 |
2044008 | 2044008 | 2021-12-23 | Tucker | West Virginia | 54093 | 1307 | 31 |
2044009 | 2044009 | 2021-12-23 | Tyler | West Virginia | 54095 | 1499 | 25 |
2044010 | 2044010 | 2021-12-23 | Upshur | West Virginia | 54097 | 4705 | 73 |
2044011 | 2044011 | 2021-12-23 | Wayne | West Virginia | 54099 | 6411 | 93 |
2044012 | 2044012 | 2021-12-23 | Webster | West Virginia | 54101 | 1506 | 26 |
2044013 | 2044013 | 2021-12-23 | Wetzel | West Virginia | 54103 | 2928 | 67 |
2044014 | 2044014 | 2021-12-23 | Wirt | West Virginia | 54105 | 992 | 17 |
2044015 | 2044015 | 2021-12-23 | Wood | West Virginia | 54107 | 15043 | 274 |
2044016 | 2044016 | 2021-12-23 | Wyoming | West Virginia | 54109 | 4153 | 76 |
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);