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 116
- 54055 115
- 54061 114
- 54093 114
- 54035 113
- 54039 113
- 54051 112
- 54079 112
- 54003 109
- 54033 109
- 54077 109
- 54107 109
- 54045 108
- 54049 108
- 54069 108
- 54081 108
- 54053 107
- 54097 107
- 54025 106
- 54029 106
- 54073 106
- 54011 104
- 54065 104
- 54103 104
- 54105 104
- 54083 103
- 54087 103
- 54031 102
- 54001 101
- 54071 100
- …
county >30
- Jefferson 116
- Mercer 115
- Monongalia 114
- Tucker 114
- Jackson 113
- Kanawha 113
- Marshall 112
- Putnam 112
- Berkeley 109
- Harrison 109
- Preston 109
- Wood 109
- Logan 108
- Marion 108
- Ohio 108
- Raleigh 108
- Mason 107
- Upshur 107
- Greenbrier 106
- Hancock 106
- Pleasants 106
- Cabell 104
- Morgan 104
- Wetzel 104
- Wirt 104
- Randolph 103
- Roane 103
- Hardy 102
- Barbour 101
- Pendleton 100
- …
state 1
- West Virginia · 5,290 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
321743 | 321743 | 2020-07-10 | Barbour | West Virginia | 54001 | 18 | 1 |
321744 | 321744 | 2020-07-10 | Berkeley | West Virginia | 54003 | 523 | 10 |
321745 | 321745 | 2020-07-10 | Boone | West Virginia | 54005 | 31 | 0 |
321746 | 321746 | 2020-07-10 | Braxton | West Virginia | 54007 | 4 | 0 |
321747 | 321747 | 2020-07-10 | Brooke | West Virginia | 54009 | 25 | 0 |
321748 | 321748 | 2020-07-10 | Cabell | West Virginia | 54011 | 194 | 0 |
321749 | 321749 | 2020-07-10 | Calhoun | West Virginia | 54013 | 4 | 0 |
321750 | 321750 | 2020-07-10 | Clay | West Virginia | 54015 | 11 | 1 |
321751 | 321751 | 2020-07-10 | Fayette | West Virginia | 54019 | 79 | 4 |
321752 | 321752 | 2020-07-10 | Gilmer | West Virginia | 54021 | 13 | 0 |
321753 | 321753 | 2020-07-10 | Grant | West Virginia | 54023 | 19 | 0 |
321754 | 321754 | 2020-07-10 | Greenbrier | West Virginia | 54025 | 69 | 3 |
321755 | 321755 | 2020-07-10 | Hampshire | West Virginia | 54027 | 42 | 1 |
321756 | 321756 | 2020-07-10 | Hancock | West Virginia | 54029 | 38 | 0 |
321757 | 321757 | 2020-07-10 | Hardy | West Virginia | 54031 | 46 | 0 |
321758 | 321758 | 2020-07-10 | Harrison | West Virginia | 54033 | 109 | 1 |
321759 | 321759 | 2020-07-10 | Jackson | West Virginia | 54035 | 148 | 18 |
321760 | 321760 | 2020-07-10 | Jefferson | West Virginia | 54037 | 253 | 4 |
321761 | 321761 | 2020-07-10 | Kanawha | West Virginia | 54039 | 393 | 20 |
321762 | 321762 | 2020-07-10 | Lewis | West Virginia | 54041 | 20 | 2 |
321763 | 321763 | 2020-07-10 | Lincoln | West Virginia | 54043 | 10 | 0 |
321764 | 321764 | 2020-07-10 | Logan | West Virginia | 54045 | 35 | 1 |
321765 | 321765 | 2020-07-10 | Marion | West Virginia | 54049 | 98 | 2 |
321766 | 321766 | 2020-07-10 | Marshall | West Virginia | 54051 | 58 | 0 |
321767 | 321767 | 2020-07-10 | Mason | West Virginia | 54053 | 23 | 0 |
321768 | 321768 | 2020-07-10 | McDowell | West Virginia | 54047 | 8 | 0 |
321769 | 321769 | 2020-07-10 | Mercer | West Virginia | 54055 | 62 | 0 |
321770 | 321770 | 2020-07-10 | Mineral | West Virginia | 54057 | 64 | 3 |
321771 | 321771 | 2020-07-10 | Mingo | West Virginia | 54059 | 29 | 2 |
321772 | 321772 | 2020-07-10 | Monongalia | West Virginia | 54061 | 468 | 5 |
321773 | 321773 | 2020-07-10 | Monroe | West Virginia | 54063 | 15 | 0 |
321774 | 321774 | 2020-07-10 | Morgan | West Virginia | 54065 | 20 | 0 |
321775 | 321775 | 2020-07-10 | Nicholas | West Virginia | 54067 | 16 | 1 |
321776 | 321776 | 2020-07-10 | Ohio | West Virginia | 54069 | 138 | 1 |
321777 | 321777 | 2020-07-10 | Pendleton | West Virginia | 54071 | 16 | 1 |
321778 | 321778 | 2020-07-10 | Pleasants | West Virginia | 54073 | 5 | 0 |
321779 | 321779 | 2020-07-10 | Pocahontas | West Virginia | 54075 | 37 | 0 |
321780 | 321780 | 2020-07-10 | Preston | West Virginia | 54077 | 95 | 2 |
321781 | 321781 | 2020-07-10 | Putnam | West Virginia | 54079 | 79 | 0 |
321782 | 321782 | 2020-07-10 | Raleigh | West Virginia | 54081 | 71 | 0 |
321783 | 321783 | 2020-07-10 | Randolph | West Virginia | 54083 | 186 | 0 |
321784 | 321784 | 2020-07-10 | Ritchie | West Virginia | 54085 | 2 | 0 |
321785 | 321785 | 2020-07-10 | Roane | West Virginia | 54087 | 12 | 1 |
321786 | 321786 | 2020-07-10 | Summers | West Virginia | 54089 | 2 | 0 |
321787 | 321787 | 2020-07-10 | Taylor | West Virginia | 54091 | 23 | 0 |
321788 | 321788 | 2020-07-10 | Tucker | West Virginia | 54093 | 6 | 0 |
321789 | 321789 | 2020-07-10 | Tyler | West Virginia | 54095 | 9 | 0 |
321790 | 321790 | 2020-07-10 | Upshur | West Virginia | 54097 | 23 | 0 |
321791 | 321791 | 2020-07-10 | Wayne | West Virginia | 54099 | 122 | 9 |
321792 | 321792 | 2020-07-10 | Webster | West Virginia | 54101 | 1 | 0 |
321793 | 321793 | 2020-07-10 | Wetzel | West Virginia | 54103 | 30 | 0 |
321794 | 321794 | 2020-07-10 | Wirt | West Virginia | 54105 | 6 | 0 |
321795 | 321795 | 2020-07-10 | Wood | West Virginia | 54107 | 168 | 2 |
321796 | 321796 | 2020-07-10 | Wyoming | West Virginia | 54109 | 7 | 0 |
318564 | 318564 | 2020-07-09 | Barbour | West Virginia | 54001 | 17 | 1 |
318565 | 318565 | 2020-07-09 | Berkeley | West Virginia | 54003 | 517 | 10 |
318566 | 318566 | 2020-07-09 | Boone | West Virginia | 54005 | 29 | 0 |
318567 | 318567 | 2020-07-09 | Braxton | West Virginia | 54007 | 3 | 0 |
318568 | 318568 | 2020-07-09 | Brooke | West Virginia | 54009 | 19 | 0 |
318569 | 318569 | 2020-07-09 | Cabell | West Virginia | 54011 | 186 | 0 |
318570 | 318570 | 2020-07-09 | Calhoun | West Virginia | 54013 | 4 | 0 |
318571 | 318571 | 2020-07-09 | Clay | West Virginia | 54015 | 11 | 1 |
318572 | 318572 | 2020-07-09 | Fayette | West Virginia | 54019 | 79 | 4 |
318573 | 318573 | 2020-07-09 | Gilmer | West Virginia | 54021 | 13 | 0 |
318574 | 318574 | 2020-07-09 | Grant | West Virginia | 54023 | 16 | 0 |
318575 | 318575 | 2020-07-09 | Greenbrier | West Virginia | 54025 | 68 | 3 |
318576 | 318576 | 2020-07-09 | Hampshire | West Virginia | 54027 | 42 | 1 |
318577 | 318577 | 2020-07-09 | Hancock | West Virginia | 54029 | 35 | 0 |
318578 | 318578 | 2020-07-09 | Hardy | West Virginia | 54031 | 46 | 0 |
318579 | 318579 | 2020-07-09 | Harrison | West Virginia | 54033 | 104 | 1 |
318580 | 318580 | 2020-07-09 | Jackson | West Virginia | 54035 | 149 | 18 |
318581 | 318581 | 2020-07-09 | Jefferson | West Virginia | 54037 | 252 | 4 |
318582 | 318582 | 2020-07-09 | Kanawha | West Virginia | 54039 | 384 | 20 |
318583 | 318583 | 2020-07-09 | Lewis | West Virginia | 54041 | 20 | 2 |
318584 | 318584 | 2020-07-09 | Lincoln | West Virginia | 54043 | 10 | 0 |
318585 | 318585 | 2020-07-09 | Logan | West Virginia | 54045 | 31 | 1 |
318586 | 318586 | 2020-07-09 | Marion | West Virginia | 54049 | 96 | 2 |
318587 | 318587 | 2020-07-09 | Marshall | West Virginia | 54051 | 55 | 0 |
318588 | 318588 | 2020-07-09 | Mason | West Virginia | 54053 | 23 | 0 |
318589 | 318589 | 2020-07-09 | McDowell | West Virginia | 54047 | 8 | 0 |
318590 | 318590 | 2020-07-09 | Mercer | West Virginia | 54055 | 61 | 0 |
318591 | 318591 | 2020-07-09 | Mineral | West Virginia | 54057 | 62 | 3 |
318592 | 318592 | 2020-07-09 | Mingo | West Virginia | 54059 | 27 | 2 |
318593 | 318593 | 2020-07-09 | Monongalia | West Virginia | 54061 | 419 | 5 |
318594 | 318594 | 2020-07-09 | Monroe | West Virginia | 54063 | 15 | 0 |
318595 | 318595 | 2020-07-09 | Morgan | West Virginia | 54065 | 20 | 0 |
318596 | 318596 | 2020-07-09 | Nicholas | West Virginia | 54067 | 16 | 1 |
318597 | 318597 | 2020-07-09 | Ohio | West Virginia | 54069 | 122 | 1 |
318598 | 318598 | 2020-07-09 | Pendleton | West Virginia | 54071 | 14 | 1 |
318599 | 318599 | 2020-07-09 | Pleasants | West Virginia | 54073 | 6 | 0 |
318600 | 318600 | 2020-07-09 | Pocahontas | West Virginia | 54075 | 37 | 0 |
318601 | 318601 | 2020-07-09 | Preston | West Virginia | 54077 | 94 | 2 |
318602 | 318602 | 2020-07-09 | Putnam | West Virginia | 54079 | 78 | 0 |
318603 | 318603 | 2020-07-09 | Raleigh | West Virginia | 54081 | 68 | 0 |
318604 | 318604 | 2020-07-09 | Randolph | West Virginia | 54083 | 176 | 0 |
318605 | 318605 | 2020-07-09 | Ritchie | West Virginia | 54085 | 2 | 0 |
318606 | 318606 | 2020-07-09 | Roane | West Virginia | 54087 | 12 | 1 |
318607 | 318607 | 2020-07-09 | Summers | West Virginia | 54089 | 2 | 0 |
318608 | 318608 | 2020-07-09 | Taylor | West Virginia | 54091 | 20 | 0 |
318609 | 318609 | 2020-07-09 | Tucker | West Virginia | 54093 | 6 | 0 |
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);