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 2020-10-09 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 |
---|---|---|---|---|---|---|---|
615274 | 615274 | 2020-10-09 | Barbour | West Virginia | 54001 | 130 | 1 |
615275 | 615275 | 2020-10-09 | Berkeley | West Virginia | 54003 | 1187 | 16 |
615276 | 615276 | 2020-10-09 | Boone | West Virginia | 54005 | 267 | 2 |
615277 | 615277 | 2020-10-09 | Braxton | West Virginia | 54007 | 16 | 0 |
615278 | 615278 | 2020-10-09 | Brooke | West Virginia | 54009 | 128 | 1 |
615279 | 615279 | 2020-10-09 | Cabell | West Virginia | 54011 | 978 | 13 |
615280 | 615280 | 2020-10-09 | Calhoun | West Virginia | 54013 | 29 | 0 |
615281 | 615281 | 2020-10-09 | Clay | West Virginia | 54015 | 48 | 2 |
615282 | 615282 | 2020-10-09 | Doddridge | West Virginia | 54017 | 40 | 1 |
615283 | 615283 | 2020-10-09 | Fayette | West Virginia | 54019 | 678 | 17 |
615284 | 615284 | 2020-10-09 | Gilmer | West Virginia | 54021 | 50 | 0 |
615285 | 615285 | 2020-10-09 | Grant | West Virginia | 54023 | 169 | 7 |
615286 | 615286 | 2020-10-09 | Greenbrier | West Virginia | 54025 | 142 | 3 |
615287 | 615287 | 2020-10-09 | Hampshire | West Virginia | 54027 | 115 | 1 |
615288 | 615288 | 2020-10-09 | Hancock | West Virginia | 54029 | 165 | 0 |
615289 | 615289 | 2020-10-09 | Hardy | West Virginia | 54031 | 98 | 1 |
615290 | 615290 | 2020-10-09 | Harrison | West Virginia | 54033 | 498 | 10 |
615291 | 615291 | 2020-10-09 | Jackson | West Virginia | 54035 | 311 | 24 |
615292 | 615292 | 2020-10-09 | Jefferson | West Virginia | 54037 | 470 | 4 |
615293 | 615293 | 2020-10-09 | Kanawha | West Virginia | 54039 | 3054 | 91 |
615294 | 615294 | 2020-10-09 | Lewis | West Virginia | 54041 | 47 | 2 |
615295 | 615295 | 2020-10-09 | Lincoln | West Virginia | 54043 | 195 | 2 |
615296 | 615296 | 2020-10-09 | Logan | West Virginia | 54045 | 688 | 43 |
615297 | 615297 | 2020-10-09 | Marion | West Virginia | 54049 | 318 | 5 |
615298 | 615298 | 2020-10-09 | Marshall | West Virginia | 54051 | 196 | 1 |
615299 | 615299 | 2020-10-09 | Mason | West Virginia | 54053 | 154 | 6 |
615300 | 615300 | 2020-10-09 | McDowell | West Virginia | 54047 | 96 | 0 |
615301 | 615301 | 2020-10-09 | Mercer | West Virginia | 54055 | 450 | 28 |
615302 | 615302 | 2020-10-09 | Mineral | West Virginia | 54057 | 181 | 4 |
615303 | 615303 | 2020-10-09 | Mingo | West Virginia | 54059 | 427 | 9 |
615304 | 615304 | 2020-10-09 | Monongalia | West Virginia | 54061 | 2135 | 5 |
615305 | 615305 | 2020-10-09 | Monroe | West Virginia | 54063 | 166 | 8 |
615306 | 615306 | 2020-10-09 | Morgan | West Virginia | 54065 | 73 | 0 |
615307 | 615307 | 2020-10-09 | Nicholas | West Virginia | 54067 | 136 | 3 |
615308 | 615308 | 2020-10-09 | Ohio | West Virginia | 54069 | 408 | 7 |
615309 | 615309 | 2020-10-09 | Pendleton | West Virginia | 54071 | 55 | 1 |
615310 | 615310 | 2020-10-09 | Pleasants | West Virginia | 54073 | 20 | 3 |
615311 | 615311 | 2020-10-09 | Pocahontas | West Virginia | 54075 | 60 | 0 |
615312 | 615312 | 2020-10-09 | Preston | West Virginia | 54077 | 168 | 4 |
615313 | 615313 | 2020-10-09 | Putnam | West Virginia | 54079 | 675 | 10 |
615314 | 615314 | 2020-10-09 | Raleigh | West Virginia | 54081 | 596 | 8 |
615315 | 615315 | 2020-10-09 | Randolph | West Virginia | 54083 | 303 | 1 |
615316 | 615316 | 2020-10-09 | Ritchie | West Virginia | 54085 | 18 | 0 |
615317 | 615317 | 2020-10-09 | Roane | West Virginia | 54087 | 65 | 2 |
615318 | 615318 | 2020-10-09 | Summers | West Virginia | 54089 | 62 | 0 |
615319 | 615319 | 2020-10-09 | Taylor | West Virginia | 54091 | 151 | 8 |
615320 | 615320 | 2020-10-09 | Tucker | West Virginia | 54093 | 44 | 0 |
615321 | 615321 | 2020-10-09 | Tyler | West Virginia | 54095 | 20 | 0 |
615322 | 615322 | 2020-10-09 | Upshur | West Virginia | 54097 | 168 | 0 |
615323 | 615323 | 2020-10-09 | Wayne | West Virginia | 54099 | 428 | 11 |
615324 | 615324 | 2020-10-09 | Webster | West Virginia | 54101 | 9 | 0 |
615325 | 615325 | 2020-10-09 | Wetzel | West Virginia | 54103 | 67 | 0 |
615326 | 615326 | 2020-10-09 | Wirt | West Virginia | 54105 | 19 | 0 |
615327 | 615327 | 2020-10-09 | Wood | West Virginia | 54107 | 401 | 6 |
615328 | 615328 | 2020-10-09 | Wyoming | West Virginia | 54109 | 135 | 5 |
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);