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-11-11 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 |
---|---|---|---|---|---|---|---|
722323 | 722323 | 2020-11-11 | Barbour | West Virginia | 54001 | 243 | 2 |
722324 | 722324 | 2020-11-11 | Berkeley | West Virginia | 54003 | 2026 | 19 |
722325 | 722325 | 2020-11-11 | Boone | West Virginia | 54005 | 474 | 10 |
722326 | 722326 | 2020-11-11 | Braxton | West Virginia | 54007 | 92 | 0 |
722327 | 722327 | 2020-11-11 | Brooke | West Virginia | 54009 | 318 | 6 |
722328 | 722328 | 2020-11-11 | Cabell | West Virginia | 54011 | 1908 | 40 |
722329 | 722329 | 2020-11-11 | Calhoun | West Virginia | 54013 | 41 | 0 |
722330 | 722330 | 2020-11-11 | Clay | West Virginia | 54015 | 81 | 3 |
722331 | 722331 | 2020-11-11 | Doddridge | West Virginia | 54017 | 83 | 1 |
722332 | 722332 | 2020-11-11 | Fayette | West Virginia | 54019 | 879 | 29 |
722333 | 722333 | 2020-11-11 | Gilmer | West Virginia | 54021 | 166 | 0 |
722334 | 722334 | 2020-11-11 | Grant | West Virginia | 54023 | 218 | 9 |
722335 | 722335 | 2020-11-11 | Greenbrier | West Virginia | 54025 | 272 | 5 |
722336 | 722336 | 2020-11-11 | Hampshire | West Virginia | 54027 | 188 | 1 |
722337 | 722337 | 2020-11-11 | Hancock | West Virginia | 54029 | 306 | 2 |
722338 | 722338 | 2020-11-11 | Hardy | West Virginia | 54031 | 136 | 1 |
722339 | 722339 | 2020-11-11 | Harrison | West Virginia | 54033 | 811 | 14 |
722340 | 722340 | 2020-11-11 | Jackson | West Virginia | 54035 | 478 | 24 |
722341 | 722341 | 2020-11-11 | Jefferson | West Virginia | 54037 | 800 | 11 |
722342 | 722342 | 2020-11-11 | Kanawha | West Virginia | 54039 | 4324 | 121 |
722343 | 722343 | 2020-11-11 | Lewis | West Virginia | 54041 | 178 | 2 |
722344 | 722344 | 2020-11-11 | Lincoln | West Virginia | 54043 | 322 | 2 |
722345 | 722345 | 2020-11-11 | Logan | West Virginia | 54045 | 864 | 47 |
722346 | 722346 | 2020-11-11 | Marion | West Virginia | 54049 | 512 | 5 |
722347 | 722347 | 2020-11-11 | Marshall | West Virginia | 54051 | 634 | 6 |
722348 | 722348 | 2020-11-11 | Mason | West Virginia | 54053 | 214 | 6 |
722349 | 722349 | 2020-11-11 | McDowell | West Virginia | 54047 | 186 | 0 |
722350 | 722350 | 2020-11-11 | Mercer | West Virginia | 54055 | 951 | 35 |
722351 | 722351 | 2020-11-11 | Mineral | West Virginia | 54057 | 426 | 4 |
722352 | 722352 | 2020-11-11 | Mingo | West Virginia | 54059 | 786 | 12 |
722353 | 722353 | 2020-11-11 | Monongalia | West Virginia | 54061 | 2595 | 7 |
722354 | 722354 | 2020-11-11 | Monroe | West Virginia | 54063 | 284 | 8 |
722355 | 722355 | 2020-11-11 | Morgan | West Virginia | 54065 | 185 | 0 |
722356 | 722356 | 2020-11-11 | Nicholas | West Virginia | 54067 | 230 | 4 |
722357 | 722357 | 2020-11-11 | Ohio | West Virginia | 54069 | 863 | 10 |
722358 | 722358 | 2020-11-11 | Pendleton | West Virginia | 54071 | 80 | 1 |
722359 | 722359 | 2020-11-11 | Pleasants | West Virginia | 54073 | 49 | 3 |
722360 | 722360 | 2020-11-11 | Pocahontas | West Virginia | 54075 | 77 | 0 |
722361 | 722361 | 2020-11-11 | Preston | West Virginia | 54077 | 287 | 7 |
722362 | 722362 | 2020-11-11 | Putnam | West Virginia | 54079 | 1241 | 22 |
722363 | 722363 | 2020-11-11 | Raleigh | West Virginia | 54081 | 1016 | 15 |
722364 | 722364 | 2020-11-11 | Randolph | West Virginia | 54083 | 511 | 2 |
722365 | 722365 | 2020-11-11 | Ritchie | West Virginia | 54085 | 77 | 0 |
722366 | 722366 | 2020-11-11 | Roane | West Virginia | 54087 | 125 | 2 |
722367 | 722367 | 2020-11-11 | Summers | West Virginia | 54089 | 184 | 4 |
722368 | 722368 | 2020-11-11 | Taylor | West Virginia | 54091 | 196 | 8 |
722369 | 722369 | 2020-11-11 | Tucker | West Virginia | 54093 | 71 | 0 |
722370 | 722370 | 2020-11-11 | Tyler | West Virginia | 54095 | 94 | 0 |
722371 | 722371 | 2020-11-11 | Upshur | West Virginia | 54097 | 330 | 4 |
722372 | 722372 | 2020-11-11 | Wayne | West Virginia | 54099 | 713 | 12 |
722373 | 722373 | 2020-11-11 | Webster | West Virginia | 54101 | 43 | 0 |
722374 | 722374 | 2020-11-11 | Wetzel | West Virginia | 54103 | 281 | 11 |
722375 | 722375 | 2020-11-11 | Wirt | West Virginia | 54105 | 61 | 1 |
722376 | 722376 | 2020-11-11 | Wood | West Virginia | 54107 | 1233 | 9 |
722377 | 722377 | 2020-11-11 | Wyoming | West Virginia | 54109 | 458 | 6 |
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);