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-12-22 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 |
---|---|---|---|---|---|---|---|
855383 | 855383 | 2020-12-22 | Barbour | West Virginia | 54001 | 624 | 8 |
855384 | 855384 | 2020-12-22 | Berkeley | West Virginia | 54003 | 5348 | 46 |
855385 | 855385 | 2020-12-22 | Boone | West Virginia | 54005 | 942 | 19 |
855386 | 855386 | 2020-12-22 | Braxton | West Virginia | 54007 | 227 | 1 |
855387 | 855387 | 2020-12-22 | Brooke | West Virginia | 54009 | 1213 | 19 |
855388 | 855388 | 2020-12-22 | Cabell | West Virginia | 54011 | 4593 | 85 |
855389 | 855389 | 2020-12-22 | Calhoun | West Virginia | 54013 | 116 | 0 |
855390 | 855390 | 2020-12-22 | Clay | West Virginia | 54015 | 236 | 3 |
855391 | 855391 | 2020-12-22 | Doddridge | West Virginia | 54017 | 212 | 3 |
855392 | 855392 | 2020-12-22 | Fayette | West Virginia | 54019 | 1536 | 44 |
855393 | 855393 | 2020-12-22 | Gilmer | West Virginia | 54021 | 295 | 1 |
855394 | 855394 | 2020-12-22 | Grant | West Virginia | 54023 | 683 | 17 |
855395 | 855395 | 2020-12-22 | Greenbrier | West Virginia | 54025 | 1194 | 23 |
855396 | 855396 | 2020-12-22 | Hampshire | West Virginia | 54027 | 832 | 9 |
855397 | 855397 | 2020-12-22 | Hancock | West Virginia | 54029 | 1609 | 23 |
855398 | 855398 | 2020-12-22 | Hardy | West Virginia | 54031 | 661 | 6 |
855399 | 855399 | 2020-12-22 | Harrison | West Virginia | 54033 | 2478 | 31 |
855400 | 855400 | 2020-12-22 | Jackson | West Virginia | 54035 | 1027 | 28 |
855401 | 855401 | 2020-12-22 | Jefferson | West Virginia | 54037 | 2108 | 22 |
855402 | 855402 | 2020-12-22 | Kanawha | West Virginia | 54039 | 7904 | 184 |
855403 | 855403 | 2020-12-22 | Lewis | West Virginia | 54041 | 421 | 3 |
855404 | 855404 | 2020-12-22 | Lincoln | West Virginia | 54043 | 671 | 8 |
855405 | 855405 | 2020-12-22 | Logan | West Virginia | 54045 | 1449 | 55 |
855406 | 855406 | 2020-12-22 | Marion | West Virginia | 54049 | 1510 | 10 |
855407 | 855407 | 2020-12-22 | Marshall | West Virginia | 54051 | 1801 | 48 |
855408 | 855408 | 2020-12-22 | Mason | West Virginia | 54053 | 906 | 12 |
855409 | 855409 | 2020-12-22 | McDowell | West Virginia | 54047 | 830 | 4 |
855410 | 855410 | 2020-12-22 | Mercer | West Virginia | 54055 | 2303 | 51 |
855411 | 855411 | 2020-12-22 | Mineral | West Virginia | 54057 | 2000 | 58 |
855412 | 855412 | 2020-12-22 | Mingo | West Virginia | 54059 | 1261 | 20 |
855413 | 855413 | 2020-12-22 | Monongalia | West Virginia | 54061 | 4778 | 22 |
855414 | 855414 | 2020-12-22 | Monroe | West Virginia | 54063 | 556 | 11 |
855415 | 855415 | 2020-12-22 | Morgan | West Virginia | 54065 | 560 | 8 |
855416 | 855416 | 2020-12-22 | Nicholas | West Virginia | 54067 | 576 | 7 |
855417 | 855417 | 2020-12-22 | Ohio | West Virginia | 54069 | 2282 | 31 |
855418 | 855418 | 2020-12-22 | Pendleton | West Virginia | 54071 | 235 | 1 |
855419 | 855419 | 2020-12-22 | Pleasants | West Virginia | 54073 | 303 | 5 |
855420 | 855420 | 2020-12-22 | Pocahontas | West Virginia | 54075 | 319 | 5 |
855421 | 855421 | 2020-12-22 | Preston | West Virginia | 54077 | 1352 | 25 |
855422 | 855422 | 2020-12-22 | Putnam | West Virginia | 54079 | 2725 | 52 |
855423 | 855423 | 2020-12-22 | Raleigh | West Virginia | 54081 | 2408 | 26 |
855424 | 855424 | 2020-12-22 | Randolph | West Virginia | 54083 | 1007 | 4 |
855425 | 855425 | 2020-12-22 | Ritchie | West Virginia | 54085 | 301 | 6 |
855426 | 855426 | 2020-12-22 | Roane | West Virginia | 54087 | 264 | 5 |
855427 | 855427 | 2020-12-22 | Summers | West Virginia | 54089 | 374 | 13 |
855428 | 855428 | 2020-12-22 | Taylor | West Virginia | 54091 | 593 | 11 |
855429 | 855429 | 2020-12-22 | Tucker | West Virginia | 54093 | 276 | 1 |
855430 | 855430 | 2020-12-22 | Tyler | West Virginia | 54095 | 290 | 2 |
855431 | 855431 | 2020-12-22 | Upshur | West Virginia | 54097 | 739 | 4 |
855432 | 855432 | 2020-12-22 | Wayne | West Virginia | 54099 | 1526 | 19 |
855433 | 855433 | 2020-12-22 | Webster | West Virginia | 54101 | 121 | 0 |
855434 | 855434 | 2020-12-22 | Wetzel | West Virginia | 54103 | 601 | 16 |
855435 | 855435 | 2020-12-22 | Wirt | West Virginia | 54105 | 185 | 1 |
855436 | 855436 | 2020-12-22 | Wood | West Virginia | 54107 | 4336 | 39 |
855437 | 855437 | 2020-12-22 | Wyoming | West Virginia | 54109 | 1040 | 16 |
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);