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 137
- 54055 136
- 54061 135
- 54093 135
- 54035 134
- 54039 134
- 54051 133
- 54079 133
- 54003 130
- 54033 130
- 54077 130
- 54107 130
- 54045 129
- 54049 129
- 54069 129
- 54081 129
- 54053 128
- 54097 128
- 54025 127
- 54029 127
- 54073 127
- 54011 125
- 54065 125
- 54103 125
- 54105 125
- 54083 124
- 54087 124
- 54031 123
- 54001 122
- 54071 121
- …
county >30
- Jefferson 137
- Mercer 136
- Monongalia 135
- Tucker 135
- Jackson 134
- Kanawha 134
- Marshall 133
- Putnam 133
- Berkeley 130
- Harrison 130
- Preston 130
- Wood 130
- Logan 129
- Marion 129
- Ohio 129
- Raleigh 129
- Mason 128
- Upshur 128
- Greenbrier 127
- Hancock 127
- Pleasants 127
- Cabell 125
- Morgan 125
- Wetzel 125
- Wirt 125
- Randolph 124
- Roane 124
- Hardy 123
- Barbour 122
- Pendleton 121
- …
state 1
- West Virginia · 6,431 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389006 | 389006 | 2020-07-31 | Barbour | West Virginia | 54001 | 29 | 1 |
389007 | 389007 | 2020-07-31 | Berkeley | West Virginia | 54003 | 645 | 11 |
389008 | 389008 | 2020-07-31 | Boone | West Virginia | 54005 | 76 | 0 |
389009 | 389009 | 2020-07-31 | Braxton | West Virginia | 54007 | 8 | 0 |
389010 | 389010 | 2020-07-31 | Brooke | West Virginia | 54009 | 60 | 1 |
389011 | 389011 | 2020-07-31 | Cabell | West Virginia | 54011 | 315 | 2 |
389012 | 389012 | 2020-07-31 | Calhoun | West Virginia | 54013 | 6 | 0 |
389013 | 389013 | 2020-07-31 | Clay | West Virginia | 54015 | 17 | 1 |
389014 | 389014 | 2020-07-31 | Doddridge | West Virginia | 54017 | 4 | 0 |
389015 | 389015 | 2020-07-31 | Fayette | West Virginia | 54019 | 126 | 5 |
389016 | 389016 | 2020-07-31 | Gilmer | West Virginia | 54021 | 16 | 0 |
389017 | 389017 | 2020-07-31 | Grant | West Virginia | 54023 | 68 | 0 |
389018 | 389018 | 2020-07-31 | Greenbrier | West Virginia | 54025 | 85 | 3 |
389019 | 389019 | 2020-07-31 | Hampshire | West Virginia | 54027 | 73 | 1 |
389020 | 389020 | 2020-07-31 | Hancock | West Virginia | 54029 | 97 | 0 |
389021 | 389021 | 2020-07-31 | Hardy | West Virginia | 54031 | 54 | 0 |
389022 | 389022 | 2020-07-31 | Harrison | West Virginia | 54033 | 183 | 1 |
389023 | 389023 | 2020-07-31 | Jackson | West Virginia | 54035 | 157 | 19 |
389024 | 389024 | 2020-07-31 | Jefferson | West Virginia | 54037 | 288 | 4 |
389025 | 389025 | 2020-07-31 | Kanawha | West Virginia | 54039 | 798 | 20 |
389026 | 389026 | 2020-07-31 | Lewis | West Virginia | 54041 | 26 | 2 |
389027 | 389027 | 2020-07-31 | Lincoln | West Virginia | 54043 | 61 | 0 |
389028 | 389028 | 2020-07-31 | Logan | West Virginia | 54045 | 133 | 3 |
389029 | 389029 | 2020-07-31 | Marion | West Virginia | 54049 | 170 | 2 |
389030 | 389030 | 2020-07-31 | Marshall | West Virginia | 54051 | 124 | 0 |
389031 | 389031 | 2020-07-31 | Mason | West Virginia | 54053 | 45 | 1 |
389032 | 389032 | 2020-07-31 | McDowell | West Virginia | 54047 | 26 | 0 |
389033 | 389033 | 2020-07-31 | Mercer | West Virginia | 54055 | 138 | 3 |
389034 | 389034 | 2020-07-31 | Mineral | West Virginia | 54057 | 109 | 4 |
389035 | 389035 | 2020-07-31 | Mingo | West Virginia | 54059 | 121 | 2 |
389036 | 389036 | 2020-07-31 | Monongalia | West Virginia | 54061 | 896 | 5 |
389037 | 389037 | 2020-07-31 | Monroe | West Virginia | 54063 | 19 | 0 |
389038 | 389038 | 2020-07-31 | Morgan | West Virginia | 54065 | 26 | 0 |
389039 | 389039 | 2020-07-31 | Nicholas | West Virginia | 54067 | 31 | 1 |
389040 | 389040 | 2020-07-31 | Ohio | West Virginia | 54069 | 248 | 4 |
389041 | 389041 | 2020-07-31 | Pendleton | West Virginia | 54071 | 37 | 1 |
389042 | 389042 | 2020-07-31 | Pleasants | West Virginia | 54073 | 8 | 0 |
389043 | 389043 | 2020-07-31 | Pocahontas | West Virginia | 54075 | 41 | 0 |
389044 | 389044 | 2020-07-31 | Preston | West Virginia | 54077 | 122 | 3 |
389045 | 389045 | 2020-07-31 | Putnam | West Virginia | 54079 | 159 | 0 |
389046 | 389046 | 2020-07-31 | Raleigh | West Virginia | 54081 | 172 | 1 |
389047 | 389047 | 2020-07-31 | Randolph | West Virginia | 54083 | 207 | 0 |
389048 | 389048 | 2020-07-31 | Ritchie | West Virginia | 54085 | 3 | 0 |
389049 | 389049 | 2020-07-31 | Roane | West Virginia | 54087 | 14 | 1 |
389050 | 389050 | 2020-07-31 | Summers | West Virginia | 54089 | 6 | 0 |
389051 | 389051 | 2020-07-31 | Taylor | West Virginia | 54091 | 52 | 0 |
389052 | 389052 | 2020-07-31 | Tucker | West Virginia | 54093 | 9 | 0 |
389053 | 389053 | 2020-07-31 | Tyler | West Virginia | 54095 | 12 | 0 |
389054 | 389054 | 2020-07-31 | Upshur | West Virginia | 54097 | 38 | 0 |
389055 | 389055 | 2020-07-31 | Wayne | West Virginia | 54099 | 182 | 9 |
389056 | 389056 | 2020-07-31 | Webster | West Virginia | 54101 | 3 | 0 |
389057 | 389057 | 2020-07-31 | Wetzel | West Virginia | 54103 | 40 | 0 |
389058 | 389058 | 2020-07-31 | Wirt | West Virginia | 54105 | 6 | 0 |
389059 | 389059 | 2020-07-31 | Wood | West Virginia | 54107 | 233 | 4 |
389060 | 389060 | 2020-07-31 | Wyoming | West Virginia | 54109 | 20 | 1 |
385789 | 385789 | 2020-07-30 | Barbour | West Virginia | 54001 | 29 | 1 |
385790 | 385790 | 2020-07-30 | Berkeley | West Virginia | 54003 | 637 | 11 |
385791 | 385791 | 2020-07-30 | Boone | West Virginia | 54005 | 71 | 0 |
385792 | 385792 | 2020-07-30 | Braxton | West Virginia | 54007 | 8 | 0 |
385793 | 385793 | 2020-07-30 | Brooke | West Virginia | 54009 | 54 | 1 |
385794 | 385794 | 2020-07-30 | Cabell | West Virginia | 54011 | 309 | 2 |
385795 | 385795 | 2020-07-30 | Calhoun | West Virginia | 54013 | 6 | 0 |
385796 | 385796 | 2020-07-30 | Clay | West Virginia | 54015 | 17 | 1 |
385797 | 385797 | 2020-07-30 | Doddridge | West Virginia | 54017 | 4 | 0 |
385798 | 385798 | 2020-07-30 | Fayette | West Virginia | 54019 | 124 | 5 |
385799 | 385799 | 2020-07-30 | Gilmer | West Virginia | 54021 | 16 | 0 |
385800 | 385800 | 2020-07-30 | Grant | West Virginia | 54023 | 66 | 0 |
385801 | 385801 | 2020-07-30 | Greenbrier | West Virginia | 54025 | 84 | 3 |
385802 | 385802 | 2020-07-30 | Hampshire | West Virginia | 54027 | 70 | 1 |
385803 | 385803 | 2020-07-30 | Hancock | West Virginia | 54029 | 92 | 0 |
385804 | 385804 | 2020-07-30 | Hardy | West Virginia | 54031 | 54 | 0 |
385805 | 385805 | 2020-07-30 | Harrison | West Virginia | 54033 | 176 | 1 |
385806 | 385806 | 2020-07-30 | Jackson | West Virginia | 54035 | 157 | 19 |
385807 | 385807 | 2020-07-30 | Jefferson | West Virginia | 54037 | 286 | 4 |
385808 | 385808 | 2020-07-30 | Kanawha | West Virginia | 54039 | 756 | 20 |
385809 | 385809 | 2020-07-30 | Lewis | West Virginia | 54041 | 26 | 2 |
385810 | 385810 | 2020-07-30 | Lincoln | West Virginia | 54043 | 56 | 0 |
385811 | 385811 | 2020-07-30 | Logan | West Virginia | 54045 | 112 | 3 |
385812 | 385812 | 2020-07-30 | Marion | West Virginia | 54049 | 170 | 2 |
385813 | 385813 | 2020-07-30 | Marshall | West Virginia | 54051 | 121 | 0 |
385814 | 385814 | 2020-07-30 | Mason | West Virginia | 54053 | 45 | 1 |
385815 | 385815 | 2020-07-30 | McDowell | West Virginia | 54047 | 21 | 0 |
385816 | 385816 | 2020-07-30 | Mercer | West Virginia | 54055 | 128 | 3 |
385817 | 385817 | 2020-07-30 | Mineral | West Virginia | 54057 | 104 | 4 |
385818 | 385818 | 2020-07-30 | Mingo | West Virginia | 54059 | 113 | 2 |
385819 | 385819 | 2020-07-30 | Monongalia | West Virginia | 54061 | 869 | 5 |
385820 | 385820 | 2020-07-30 | Monroe | West Virginia | 54063 | 19 | 0 |
385821 | 385821 | 2020-07-30 | Morgan | West Virginia | 54065 | 25 | 0 |
385822 | 385822 | 2020-07-30 | Nicholas | West Virginia | 54067 | 30 | 1 |
385823 | 385823 | 2020-07-30 | Ohio | West Virginia | 54069 | 244 | 4 |
385824 | 385824 | 2020-07-30 | Pendleton | West Virginia | 54071 | 37 | 1 |
385825 | 385825 | 2020-07-30 | Pleasants | West Virginia | 54073 | 7 | 0 |
385826 | 385826 | 2020-07-30 | Pocahontas | West Virginia | 54075 | 41 | 0 |
385827 | 385827 | 2020-07-30 | Preston | West Virginia | 54077 | 120 | 3 |
385828 | 385828 | 2020-07-30 | Putnam | West Virginia | 54079 | 152 | 0 |
385829 | 385829 | 2020-07-30 | Raleigh | West Virginia | 54081 | 156 | 0 |
385830 | 385830 | 2020-07-30 | Randolph | West Virginia | 54083 | 206 | 0 |
385831 | 385831 | 2020-07-30 | Ritchie | West Virginia | 54085 | 3 | 0 |
385832 | 385832 | 2020-07-30 | Roane | West Virginia | 54087 | 14 | 1 |
385833 | 385833 | 2020-07-30 | Summers | West Virginia | 54089 | 5 | 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);