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)
fips >30
- 54037 574
- 54055 573
- 54093 573
- 54061 572
- 54035 571
- 54039 571
- 54051 570
- 54079 570
- 54107 568
- 54003 567
- 54033 567
- 54077 567
- 54045 566
- 54049 566
- 54069 566
- 54081 566
- 54097 566
- 54053 565
- 54025 564
- 54029 564
- 54073 564
- 54103 563
- 54105 563
- 54011 562
- 54065 562
- 54083 561
- 54087 561
- 54031 560
- 54001 559
- 54071 558
- …
county >30
- Jefferson 574
- Mercer 573
- Tucker 573
- Monongalia 572
- Jackson 571
- Kanawha 571
- Marshall 570
- Putnam 570
- Wood 568
- Berkeley 567
- Harrison 567
- Preston 567
- Logan 566
- Marion 566
- Ohio 566
- Raleigh 566
- Upshur 566
- Mason 565
- Greenbrier 564
- Hancock 564
- Pleasants 564
- Wetzel 563
- Wirt 563
- Cabell 562
- Morgan 562
- Randolph 561
- Roane 561
- Hardy 560
- Barbour 559
- Pendleton 558
- …
state 1
- West Virginia · 30,478 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810012 | 1810012 | 2021-10-12 | Taylor | West Virginia | 54091 | 2089 | 36 |
1810013 | 1810013 | 2021-10-12 | Tucker | West Virginia | 54093 | 1021 | 20 |
1810014 | 1810014 | 2021-10-12 | Tyler | West Virginia | 54095 | 1323 | 18 |
1810015 | 1810015 | 2021-10-12 | Upshur | West Virginia | 54097 | 3749 | 57 |
1810016 | 1810016 | 2021-10-12 | Wayne | West Virginia | 54099 | 5430 | 69 |
1810017 | 1810017 | 2021-10-12 | Webster | West Virginia | 54101 | 1061 | 16 |
1810018 | 1810018 | 2021-10-12 | Wetzel | West Virginia | 54103 | 2416 | 46 |
1810019 | 1810019 | 2021-10-12 | Wirt | West Virginia | 54105 | 784 | 12 |
1810020 | 1810020 | 2021-10-12 | Wood | West Virginia | 54107 | 12440 | 225 |
1810021 | 1810021 | 2021-10-12 | Wyoming | West Virginia | 54109 | 3432 | 56 |
1806718 | 1806718 | 2021-10-11 | Barbour | West Virginia | 54001 | 2526 | 43 |
1806719 | 1806719 | 2021-10-11 | Berkeley | West Virginia | 54003 | 17527 | 167 |
1806720 | 1806720 | 2021-10-11 | Boone | West Virginia | 54005 | 3334 | 47 |
1806721 | 1806721 | 2021-10-11 | Braxton | West Virginia | 54007 | 2014 | 15 |
1806722 | 1806722 | 2021-10-11 | Brooke | West Virginia | 54009 | 2948 | 67 |
1806723 | 1806723 | 2021-10-11 | Cabell | West Virginia | 54011 | 14227 | 247 |
1806724 | 1806724 | 2021-10-11 | Calhoun | West Virginia | 54013 | 847 | 4 |
1806725 | 1806725 | 2021-10-11 | Clay | West Virginia | 54015 | 1123 | 17 |
1806726 | 1806726 | 2021-10-11 | Doddridge | West Virginia | 54017 | 1148 | 9 |
1806727 | 1806727 | 2021-10-11 | Fayette | West Virginia | 54019 | 5779 | 111 |
1806728 | 1806728 | 2021-10-11 | Gilmer | West Virginia | 54021 | 1290 | 8 |
1806729 | 1806729 | 2021-10-11 | Grant | West Virginia | 54023 | 2039 | 32 |
1806730 | 1806730 | 2021-10-11 | Greenbrier | West Virginia | 54025 | 4667 | 84 |
1806731 | 1806731 | 2021-10-11 | Hampshire | West Virginia | 54027 | 2974 | 47 |
1806732 | 1806732 | 2021-10-11 | Hancock | West Virginia | 54029 | 3941 | 103 |
1806733 | 1806733 | 2021-10-11 | Hardy | West Virginia | 54031 | 2284 | 28 |
1806734 | 1806734 | 2021-10-11 | Harrison | West Virginia | 54033 | 10307 | 130 |
1806735 | 1806735 | 2021-10-11 | Jackson | West Virginia | 54035 | 3695 | 76 |
1806736 | 1806736 | 2021-10-11 | Jefferson | West Virginia | 54037 | 6515 | 80 |
1806737 | 1806737 | 2021-10-11 | Kanawha | West Virginia | 54039 | 23137 | 437 |
1806738 | 1806738 | 2021-10-11 | Lewis | West Virginia | 54041 | 2844 | 42 |
1806739 | 1806739 | 2021-10-11 | Lincoln | West Virginia | 54043 | 2608 | 41 |
1806740 | 1806740 | 2021-10-11 | Logan | West Virginia | 54045 | 5103 | 130 |
1806741 | 1806741 | 2021-10-11 | Marion | West Virginia | 54049 | 7478 | 89 |
1806742 | 1806742 | 2021-10-11 | Marshall | West Virginia | 54051 | 5109 | 106 |
1806743 | 1806743 | 2021-10-11 | Mason | West Virginia | 54053 | 3454 | 50 |
1806744 | 1806744 | 2021-10-11 | McDowell | West Virginia | 54047 | 2784 | 43 |
1806745 | 1806745 | 2021-10-11 | Mercer | West Virginia | 54055 | 8266 | 171 |
1806746 | 1806746 | 2021-10-11 | Mineral | West Virginia | 54057 | 4375 | 106 |
1806747 | 1806747 | 2021-10-11 | Mingo | West Virginia | 54059 | 4349 | 70 |
1806748 | 1806748 | 2021-10-11 | Monongalia | West Virginia | 54061 | 12135 | 124 |
1806749 | 1806749 | 2021-10-11 | Monroe | West Virginia | 54063 | 1999 | 25 |
1806750 | 1806750 | 2021-10-11 | Morgan | West Virginia | 54065 | 1963 | 40 |
1806751 | 1806751 | 2021-10-11 | Nicholas | West Virginia | 54067 | 3338 | 38 |
1806752 | 1806752 | 2021-10-11 | Ohio | West Virginia | 54069 | 5859 | 101 |
1806753 | 1806753 | 2021-10-11 | Pendleton | West Virginia | 54071 | 1065 | 12 |
1806754 | 1806754 | 2021-10-11 | Pleasants | West Virginia | 54073 | 1355 | 27 |
1806755 | 1806755 | 2021-10-11 | Pocahontas | West Virginia | 54075 | 1079 | 17 |
1806756 | 1806756 | 2021-10-11 | Preston | West Virginia | 54077 | 4786 | 69 |
1806757 | 1806757 | 2021-10-11 | Putnam | West Virginia | 54079 | 8298 | 111 |
1806758 | 1806758 | 2021-10-11 | Raleigh | West Virginia | 54081 | 10687 | 158 |
1806759 | 1806759 | 2021-10-11 | Randolph | West Virginia | 54083 | 4878 | 40 |
1806760 | 1806760 | 2021-10-11 | Ritchie | West Virginia | 54085 | 1392 | 17 |
1806761 | 1806761 | 2021-10-11 | Roane | West Virginia | 54087 | 1365 | 16 |
1806762 | 1806762 | 2021-10-11 | Summers | West Virginia | 54089 | 1355 | 29 |
1806763 | 1806763 | 2021-10-11 | Taylor | West Virginia | 54091 | 2082 | 36 |
1806764 | 1806764 | 2021-10-11 | Tucker | West Virginia | 54093 | 1020 | 20 |
1806765 | 1806765 | 2021-10-11 | Tyler | West Virginia | 54095 | 1321 | 18 |
1806766 | 1806766 | 2021-10-11 | Upshur | West Virginia | 54097 | 3736 | 57 |
1806767 | 1806767 | 2021-10-11 | Wayne | West Virginia | 54099 | 5410 | 69 |
1806768 | 1806768 | 2021-10-11 | Webster | West Virginia | 54101 | 1057 | 16 |
1806769 | 1806769 | 2021-10-11 | Wetzel | West Virginia | 54103 | 2415 | 46 |
1806770 | 1806770 | 2021-10-11 | Wirt | West Virginia | 54105 | 778 | 12 |
1806771 | 1806771 | 2021-10-11 | Wood | West Virginia | 54107 | 12406 | 224 |
1806772 | 1806772 | 2021-10-11 | Wyoming | West Virginia | 54109 | 3424 | 54 |
1803467 | 1803467 | 2021-10-10 | Barbour | West Virginia | 54001 | 2511 | 43 |
1803468 | 1803468 | 2021-10-10 | Berkeley | West Virginia | 54003 | 17487 | 166 |
1803469 | 1803469 | 2021-10-10 | Boone | West Virginia | 54005 | 3324 | 44 |
1803470 | 1803470 | 2021-10-10 | Braxton | West Virginia | 54007 | 2009 | 15 |
1803471 | 1803471 | 2021-10-10 | Brooke | West Virginia | 54009 | 2944 | 67 |
1803472 | 1803472 | 2021-10-10 | Cabell | West Virginia | 54011 | 14204 | 243 |
1803473 | 1803473 | 2021-10-10 | Calhoun | West Virginia | 54013 | 846 | 4 |
1803474 | 1803474 | 2021-10-10 | Clay | West Virginia | 54015 | 1119 | 17 |
1803475 | 1803475 | 2021-10-10 | Doddridge | West Virginia | 54017 | 1147 | 9 |
1803476 | 1803476 | 2021-10-10 | Fayette | West Virginia | 54019 | 5764 | 110 |
1803477 | 1803477 | 2021-10-10 | Gilmer | West Virginia | 54021 | 1289 | 8 |
1803478 | 1803478 | 2021-10-10 | Grant | West Virginia | 54023 | 2025 | 32 |
1803479 | 1803479 | 2021-10-10 | Greenbrier | West Virginia | 54025 | 4653 | 83 |
1803480 | 1803480 | 2021-10-10 | Hampshire | West Virginia | 54027 | 2963 | 46 |
1803481 | 1803481 | 2021-10-10 | Hancock | West Virginia | 54029 | 3933 | 103 |
1803482 | 1803482 | 2021-10-10 | Hardy | West Virginia | 54031 | 2282 | 28 |
1803483 | 1803483 | 2021-10-10 | Harrison | West Virginia | 54033 | 10266 | 127 |
1803484 | 1803484 | 2021-10-10 | Jackson | West Virginia | 54035 | 3680 | 74 |
1803485 | 1803485 | 2021-10-10 | Jefferson | West Virginia | 54037 | 6504 | 80 |
1803486 | 1803486 | 2021-10-10 | Kanawha | West Virginia | 54039 | 23073 | 436 |
1803487 | 1803487 | 2021-10-10 | Lewis | West Virginia | 54041 | 2827 | 42 |
1803488 | 1803488 | 2021-10-10 | Lincoln | West Virginia | 54043 | 2590 | 41 |
1803489 | 1803489 | 2021-10-10 | Logan | West Virginia | 54045 | 5074 | 130 |
1803490 | 1803490 | 2021-10-10 | Marion | West Virginia | 54049 | 7442 | 88 |
1803491 | 1803491 | 2021-10-10 | Marshall | West Virginia | 54051 | 5101 | 104 |
1803492 | 1803492 | 2021-10-10 | Mason | West Virginia | 54053 | 3451 | 49 |
1803493 | 1803493 | 2021-10-10 | McDowell | West Virginia | 54047 | 2777 | 42 |
1803494 | 1803494 | 2021-10-10 | Mercer | West Virginia | 54055 | 8234 | 171 |
1803495 | 1803495 | 2021-10-10 | Mineral | West Virginia | 54057 | 4361 | 106 |
1803496 | 1803496 | 2021-10-10 | Mingo | West Virginia | 54059 | 4334 | 70 |
1803497 | 1803497 | 2021-10-10 | Monongalia | West Virginia | 54061 | 12113 | 123 |
1803498 | 1803498 | 2021-10-10 | Monroe | West Virginia | 54063 | 1992 | 25 |
1803499 | 1803499 | 2021-10-10 | Morgan | West Virginia | 54065 | 1952 | 39 |
1803500 | 1803500 | 2021-10-10 | Nicholas | West Virginia | 54067 | 3323 | 38 |
1803501 | 1803501 | 2021-10-10 | Ohio | West Virginia | 54069 | 5854 | 100 |
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);