ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2020-09-26" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
573133 | 573133 | 2020-09-26 | Barbour | West Virginia | 54001 | 56 | 1 |
573134 | 573134 | 2020-09-26 | Berkeley | West Virginia | 54003 | 987 | 13 |
573135 | 573135 | 2020-09-26 | Boone | West Virginia | 54005 | 216 | 1 |
573136 | 573136 | 2020-09-26 | Braxton | West Virginia | 54007 | 13 | 0 |
573137 | 573137 | 2020-09-26 | Brooke | West Virginia | 54009 | 113 | 1 |
573138 | 573138 | 2020-09-26 | Cabell | West Virginia | 54011 | 791 | 10 |
573139 | 573139 | 2020-09-26 | Calhoun | West Virginia | 54013 | 25 | 0 |
573140 | 573140 | 2020-09-26 | Clay | West Virginia | 54015 | 34 | 2 |
573141 | 573141 | 2020-09-26 | Doddridge | West Virginia | 54017 | 23 | 1 |
573142 | 573142 | 2020-09-26 | Fayette | West Virginia | 54019 | 608 | 13 |
573143 | 573143 | 2020-09-26 | Gilmer | West Virginia | 54021 | 46 | 0 |
573144 | 573144 | 2020-09-26 | Grant | West Virginia | 54023 | 160 | 7 |
573145 | 573145 | 2020-09-26 | Greenbrier | West Virginia | 54025 | 126 | 3 |
573146 | 573146 | 2020-09-26 | Hampshire | West Virginia | 54027 | 106 | 1 |
573147 | 573147 | 2020-09-26 | Hancock | West Virginia | 54029 | 148 | 0 |
573148 | 573148 | 2020-09-26 | Hardy | West Virginia | 54031 | 89 | 1 |
573149 | 573149 | 2020-09-26 | Harrison | West Virginia | 54033 | 354 | 9 |
573150 | 573150 | 2020-09-26 | Jackson | West Virginia | 54035 | 259 | 23 |
573151 | 573151 | 2020-09-26 | Jefferson | West Virginia | 54037 | 429 | 4 |
573152 | 573152 | 2020-09-26 | Kanawha | West Virginia | 54039 | 2603 | 76 |
573153 | 573153 | 2020-09-26 | Lewis | West Virginia | 54041 | 38 | 2 |
573154 | 573154 | 2020-09-26 | Lincoln | West Virginia | 54043 | 164 | 2 |
573155 | 573155 | 2020-09-26 | Logan | West Virginia | 54045 | 610 | 41 |
573156 | 573156 | 2020-09-26 | Marion | West Virginia | 54049 | 267 | 3 |
573157 | 573157 | 2020-09-26 | Marshall | West Virginia | 54051 | 172 | 1 |
573158 | 573158 | 2020-09-26 | Mason | West Virginia | 54053 | 141 | 6 |
573159 | 573159 | 2020-09-26 | McDowell | West Virginia | 54047 | 81 | 0 |
573160 | 573160 | 2020-09-26 | Mercer | West Virginia | 54055 | 412 | 28 |
573161 | 573161 | 2020-09-26 | Mineral | West Virginia | 54057 | 172 | 4 |
573162 | 573162 | 2020-09-26 | Mingo | West Virginia | 54059 | 376 | 9 |
573163 | 573163 | 2020-09-26 | Monongalia | West Virginia | 54061 | 1992 | 5 |
573164 | 573164 | 2020-09-26 | Monroe | West Virginia | 54063 | 149 | 7 |
573165 | 573165 | 2020-09-26 | Morgan | West Virginia | 54065 | 55 | 0 |
573166 | 573166 | 2020-09-26 | Nicholas | West Virginia | 54067 | 100 | 3 |
573167 | 573167 | 2020-09-26 | Ohio | West Virginia | 54069 | 368 | 6 |
573168 | 573168 | 2020-09-26 | Pendleton | West Virginia | 54071 | 53 | 1 |
573169 | 573169 | 2020-09-26 | Pleasants | West Virginia | 54073 | 17 | 3 |
573170 | 573170 | 2020-09-26 | Pocahontas | West Virginia | 54075 | 59 | 0 |
573171 | 573171 | 2020-09-26 | Preston | West Virginia | 54077 | 153 | 4 |
573172 | 573172 | 2020-09-26 | Putnam | West Virginia | 54079 | 550 | 5 |
573173 | 573173 | 2020-09-26 | Raleigh | West Virginia | 54081 | 510 | 8 |
573174 | 573174 | 2020-09-26 | Randolph | West Virginia | 54083 | 242 | 1 |
573175 | 573175 | 2020-09-26 | Ritchie | West Virginia | 54085 | 12 | 0 |
573176 | 573176 | 2020-09-26 | Roane | West Virginia | 54087 | 49 | 2 |
573177 | 573177 | 2020-09-26 | Summers | West Virginia | 54089 | 54 | 0 |
573178 | 573178 | 2020-09-26 | Taylor | West Virginia | 54091 | 124 | 6 |
573179 | 573179 | 2020-09-26 | Tucker | West Virginia | 54093 | 23 | 0 |
573180 | 573180 | 2020-09-26 | Tyler | West Virginia | 54095 | 16 | 0 |
573181 | 573181 | 2020-09-26 | Upshur | West Virginia | 54097 | 71 | 0 |
573182 | 573182 | 2020-09-26 | Wayne | West Virginia | 54099 | 392 | 10 |
573183 | 573183 | 2020-09-26 | Webster | West Virginia | 54101 | 8 | 0 |
573184 | 573184 | 2020-09-26 | Wetzel | West Virginia | 54103 | 54 | 0 |
573185 | 573185 | 2020-09-26 | Wirt | West Virginia | 54105 | 12 | 0 |
573186 | 573186 | 2020-09-26 | Wood | West Virginia | 54107 | 362 | 6 |
573187 | 573187 | 2020-09-26 | Wyoming | West Virginia | 54109 | 114 | 3 |
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);