ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42,238 rows where state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 54037 788
- 54055 787
- 54061 786
- 54093 786
- 54035 785
- 54039 785
- 54051 784
- 54079 784
- 54003 781
- 54033 781
- 54077 781
- 54107 781
- 54045 780
- 54049 780
- 54069 780
- 54081 780
- 54053 779
- 54097 779
- 54025 778
- 54029 778
- 54073 778
- 54011 776
- 54065 776
- 54103 776
- 54105 776
- 54083 775
- 54087 775
- 54031 774
- 54001 773
- 54071 772
- …
county >30
- Jefferson 788
- Mercer 787
- Monongalia 786
- Tucker 786
- Jackson 785
- Kanawha 785
- Marshall 784
- Putnam 784
- Berkeley 781
- Harrison 781
- Preston 781
- Wood 781
- Logan 780
- Marion 780
- Ohio 780
- Raleigh 780
- Mason 779
- Upshur 779
- Greenbrier 778
- Hancock 778
- Pleasants 778
- Cabell 776
- Morgan 776
- Wetzel 776
- Wirt 776
- Randolph 775
- Roane 775
- Hardy 774
- Barbour 773
- Pendleton 772
- …
state 1
- West Virginia · 42,238 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 2502683 | 2502683 | 2022-05-13 | Barbour | West Virginia | 54001 | 4838 | 73 |
| 2502684 | 2502684 | 2022-05-13 | Berkeley | West Virginia | 54003 | 36247 | 295 |
| 2502685 | 2502685 | 2022-05-13 | Boone | West Virginia | 54005 | 6660 | 75 |
| 2502686 | 2502686 | 2022-05-13 | Braxton | West Virginia | 54007 | 3940 | 43 |
| 2502687 | 2502687 | 2022-05-13 | Brooke | West Virginia | 54009 | 5082 | 104 |
| 2502688 | 2502688 | 2022-05-13 | Cabell | West Virginia | 54011 | 27842 | 375 |
| 2502689 | 2502689 | 2022-05-13 | Calhoun | West Virginia | 54013 | 1887 | 15 |
| 2502690 | 2502690 | 2022-05-13 | Clay | West Virginia | 54015 | 2351 | 41 |
| 2502691 | 2502691 | 2022-05-13 | Doddridge | West Virginia | 54017 | 2162 | 18 |
| 2502692 | 2502692 | 2022-05-13 | Fayette | West Virginia | 54019 | 13217 | 205 |
| 2502693 | 2502693 | 2022-05-13 | Gilmer | West Virginia | 54021 | 2101 | 19 |
| 2502694 | 2502694 | 2022-05-13 | Grant | West Virginia | 54023 | 3786 | 56 |
| 2502695 | 2502695 | 2022-05-13 | Greenbrier | West Virginia | 54025 | 9763 | 160 |
| 2502696 | 2502696 | 2022-05-13 | Hampshire | West Virginia | 54027 | 5906 | 73 |
| 2502697 | 2502697 | 2022-05-13 | Hancock | West Virginia | 54029 | 6809 | 142 |
| 2502698 | 2502698 | 2022-05-13 | Hardy | West Virginia | 54031 | 4202 | 49 |
| 2502699 | 2502699 | 2022-05-13 | Harrison | West Virginia | 54033 | 20062 | 253 |
| 2502700 | 2502700 | 2022-05-13 | Jackson | West Virginia | 54035 | 6926 | 132 |
| 2502701 | 2502701 | 2022-05-13 | Jefferson | West Virginia | 54037 | 14513 | 132 |
| 2502702 | 2502702 | 2022-05-13 | Kanawha | West Virginia | 54039 | 47739 | 724 |
| 2502703 | 2502703 | 2022-05-13 | Lewis | West Virginia | 54041 | 5359 | 86 |
| 2502704 | 2502704 | 2022-05-13 | Lincoln | West Virginia | 54043 | 5606 | 82 |
| 2502705 | 2502705 | 2022-05-13 | Logan | West Virginia | 54045 | 9747 | 186 |
| 2502706 | 2502706 | 2022-05-13 | Marion | West Virginia | 54049 | 15266 | 179 |
| 2502707 | 2502707 | 2022-05-13 | Marshall | West Virginia | 54051 | 9085 | 155 |
| 2502708 | 2502708 | 2022-05-13 | Mason | West Virginia | 54053 | 6703 | 93 |
| 2502709 | 2502709 | 2022-05-13 | McDowell | West Virginia | 54047 | 5662 | 75 |
| 2502710 | 2502710 | 2022-05-13 | Mercer | West Virginia | 54055 | 17177 | 266 |
| 2502711 | 2502711 | 2022-05-13 | Mineral | West Virginia | 54057 | 7914 | 156 |
| 2502712 | 2502712 | 2022-05-13 | Mingo | West Virginia | 54059 | 7968 | 123 |
| 2502713 | 2502713 | 2022-05-13 | Monongalia | West Virginia | 54061 | 25092 | 196 |
| 2502714 | 2502714 | 2022-05-13 | Monroe | West Virginia | 54063 | 4260 | 46 |
| 2502715 | 2502715 | 2022-05-13 | Morgan | West Virginia | 54065 | 4307 | 69 |
| 2502716 | 2502716 | 2022-05-13 | Nicholas | West Virginia | 54067 | 7378 | 97 |
| 2502717 | 2502717 | 2022-05-13 | Ohio | West Virginia | 54069 | 11335 | 167 |
| 2502718 | 2502718 | 2022-05-13 | Pendleton | West Virginia | 54071 | 2001 | 22 |
| 2502719 | 2502719 | 2022-05-13 | Pleasants | West Virginia | 54073 | 2077 | 36 |
| 2502720 | 2502720 | 2022-05-13 | Pocahontas | West Virginia | 54075 | 2077 | 32 |
| 2502721 | 2502721 | 2022-05-13 | Preston | West Virginia | 54077 | 9367 | 137 |
| 2502722 | 2502722 | 2022-05-13 | Putnam | West Virginia | 54079 | 16889 | 178 |
| 2502723 | 2502723 | 2022-05-13 | Raleigh | West Virginia | 54081 | 23094 | 349 |
| 2502724 | 2502724 | 2022-05-13 | Randolph | West Virginia | 54083 | 9533 | 89 |
| 2502725 | 2502725 | 2022-05-13 | Ritchie | West Virginia | 54085 | 2462 | 31 |
| 2502726 | 2502726 | 2022-05-13 | Roane | West Virginia | 54087 | 3187 | 36 |
| 2502727 | 2502727 | 2022-05-13 | Summers | West Virginia | 54089 | 2831 | 54 |
| 2502728 | 2502728 | 2022-05-13 | Taylor | West Virginia | 54091 | 4585 | 73 |
| 2502729 | 2502729 | 2022-05-13 | Tucker | West Virginia | 54093 | 2024 | 38 |
| 2502730 | 2502730 | 2022-05-13 | Tyler | West Virginia | 54095 | 2214 | 32 |
| 2502731 | 2502731 | 2022-05-13 | Upshur | West Virginia | 54097 | 6928 | 95 |
| 2502732 | 2502732 | 2022-05-13 | Wayne | West Virginia | 54099 | 9915 | 125 |
| 2502733 | 2502733 | 2022-05-13 | Webster | West Virginia | 54101 | 2274 | 33 |
| 2502734 | 2502734 | 2022-05-13 | Wetzel | West Virginia | 54103 | 4367 | 86 |
| 2502735 | 2502735 | 2022-05-13 | Wirt | West Virginia | 54105 | 1455 | 25 |
| 2502736 | 2502736 | 2022-05-13 | Wood | West Virginia | 54107 | 22312 | 346 |
| 2502737 | 2502737 | 2022-05-13 | Wyoming | West Virginia | 54109 | 7044 | 116 |
| 2499425 | 2499425 | 2022-05-12 | Barbour | West Virginia | 54001 | 4835 | 73 |
| 2499426 | 2499426 | 2022-05-12 | Berkeley | West Virginia | 54003 | 36218 | 295 |
| 2499427 | 2499427 | 2022-05-12 | Boone | West Virginia | 54005 | 6655 | 75 |
| 2499428 | 2499428 | 2022-05-12 | Braxton | West Virginia | 54007 | 3937 | 43 |
| 2499429 | 2499429 | 2022-05-12 | Brooke | West Virginia | 54009 | 5080 | 104 |
| 2499430 | 2499430 | 2022-05-12 | Cabell | West Virginia | 54011 | 27808 | 375 |
| 2499431 | 2499431 | 2022-05-12 | Calhoun | West Virginia | 54013 | 1885 | 15 |
| 2499432 | 2499432 | 2022-05-12 | Clay | West Virginia | 54015 | 2348 | 41 |
| 2499433 | 2499433 | 2022-05-12 | Doddridge | West Virginia | 54017 | 2162 | 18 |
| 2499434 | 2499434 | 2022-05-12 | Fayette | West Virginia | 54019 | 13207 | 205 |
| 2499435 | 2499435 | 2022-05-12 | Gilmer | West Virginia | 54021 | 2101 | 19 |
| 2499436 | 2499436 | 2022-05-12 | Grant | West Virginia | 54023 | 3786 | 56 |
| 2499437 | 2499437 | 2022-05-12 | Greenbrier | West Virginia | 54025 | 9749 | 160 |
| 2499438 | 2499438 | 2022-05-12 | Hampshire | West Virginia | 54027 | 5904 | 73 |
| 2499439 | 2499439 | 2022-05-12 | Hancock | West Virginia | 54029 | 6805 | 142 |
| 2499440 | 2499440 | 2022-05-12 | Hardy | West Virginia | 54031 | 4201 | 49 |
| 2499441 | 2499441 | 2022-05-12 | Harrison | West Virginia | 54033 | 20039 | 253 |
| 2499442 | 2499442 | 2022-05-12 | Jackson | West Virginia | 54035 | 6920 | 132 |
| 2499443 | 2499443 | 2022-05-12 | Jefferson | West Virginia | 54037 | 14491 | 132 |
| 2499444 | 2499444 | 2022-05-12 | Kanawha | West Virginia | 54039 | 47672 | 724 |
| 2499445 | 2499445 | 2022-05-12 | Lewis | West Virginia | 54041 | 5355 | 86 |
| 2499446 | 2499446 | 2022-05-12 | Lincoln | West Virginia | 54043 | 5601 | 82 |
| 2499447 | 2499447 | 2022-05-12 | Logan | West Virginia | 54045 | 9737 | 186 |
| 2499448 | 2499448 | 2022-05-12 | Marion | West Virginia | 54049 | 15243 | 179 |
| 2499449 | 2499449 | 2022-05-12 | Marshall | West Virginia | 54051 | 9075 | 155 |
| 2499450 | 2499450 | 2022-05-12 | Mason | West Virginia | 54053 | 6695 | 93 |
| 2499451 | 2499451 | 2022-05-12 | McDowell | West Virginia | 54047 | 5663 | 75 |
| 2499452 | 2499452 | 2022-05-12 | Mercer | West Virginia | 54055 | 17166 | 266 |
| 2499453 | 2499453 | 2022-05-12 | Mineral | West Virginia | 54057 | 7912 | 156 |
| 2499454 | 2499454 | 2022-05-12 | Mingo | West Virginia | 54059 | 7967 | 123 |
| 2499455 | 2499455 | 2022-05-12 | Monongalia | West Virginia | 54061 | 25046 | 196 |
| 2499456 | 2499456 | 2022-05-12 | Monroe | West Virginia | 54063 | 4247 | 46 |
| 2499457 | 2499457 | 2022-05-12 | Morgan | West Virginia | 54065 | 4303 | 69 |
| 2499458 | 2499458 | 2022-05-12 | Nicholas | West Virginia | 54067 | 7376 | 97 |
| 2499459 | 2499459 | 2022-05-12 | Ohio | West Virginia | 54069 | 11321 | 167 |
| 2499460 | 2499460 | 2022-05-12 | Pendleton | West Virginia | 54071 | 1998 | 22 |
| 2499461 | 2499461 | 2022-05-12 | Pleasants | West Virginia | 54073 | 2077 | 36 |
| 2499462 | 2499462 | 2022-05-12 | Pocahontas | West Virginia | 54075 | 2077 | 32 |
| 2499463 | 2499463 | 2022-05-12 | Preston | West Virginia | 54077 | 9362 | 137 |
| 2499464 | 2499464 | 2022-05-12 | Putnam | West Virginia | 54079 | 16875 | 178 |
| 2499465 | 2499465 | 2022-05-12 | Raleigh | West Virginia | 54081 | 23063 | 349 |
| 2499466 | 2499466 | 2022-05-12 | Randolph | West Virginia | 54083 | 9526 | 89 |
| 2499467 | 2499467 | 2022-05-12 | Ritchie | West Virginia | 54085 | 2460 | 31 |
| 2499468 | 2499468 | 2022-05-12 | Roane | West Virginia | 54087 | 3186 | 36 |
| 2499469 | 2499469 | 2022-05-12 | Summers | West Virginia | 54089 | 2830 | 54 |
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);