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 2021-04-30 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1274147 | 1274147 | 2021-04-30 | Barbour | West Virginia | 54001 | 1396 | 26 |
1274148 | 1274148 | 2021-04-30 | Berkeley | West Virginia | 54003 | 12046 | 121 |
1274149 | 1274149 | 2021-04-30 | Boone | West Virginia | 54005 | 1953 | 33 |
1274150 | 1274150 | 2021-04-30 | Braxton | West Virginia | 54007 | 892 | 3 |
1274151 | 1274151 | 2021-04-30 | Brooke | West Virginia | 54009 | 2158 | 59 |
1274152 | 1274152 | 2021-04-30 | Cabell | West Virginia | 54011 | 8580 | 170 |
1274153 | 1274153 | 2021-04-30 | Calhoun | West Virginia | 54013 | 284 | 0 |
1274154 | 1274154 | 2021-04-30 | Clay | West Virginia | 54015 | 470 | 9 |
1274155 | 1274155 | 2021-04-30 | Doddridge | West Virginia | 54017 | 570 | 6 |
1274156 | 1274156 | 2021-04-30 | Fayette | West Virginia | 54019 | 3353 | 75 |
1274157 | 1274157 | 2021-04-30 | Gilmer | West Virginia | 54021 | 765 | 5 |
1274158 | 1274158 | 2021-04-30 | Grant | West Virginia | 54023 | 1261 | 27 |
1274159 | 1274159 | 2021-04-30 | Greenbrier | West Virginia | 54025 | 2736 | 62 |
1274160 | 1274160 | 2021-04-30 | Hampshire | West Virginia | 54027 | 1752 | 33 |
1274161 | 1274161 | 2021-04-30 | Hancock | West Virginia | 54029 | 2753 | 88 |
1274162 | 1274162 | 2021-04-30 | Hardy | West Virginia | 54031 | 1498 | 24 |
1274163 | 1274163 | 2021-04-30 | Harrison | West Virginia | 54033 | 5556 | 74 |
1274164 | 1274164 | 2021-04-30 | Jackson | West Virginia | 54035 | 1997 | 59 |
1274165 | 1274165 | 2021-04-30 | Jefferson | West Virginia | 54037 | 4507 | 48 |
1274166 | 1274166 | 2021-04-30 | Kanawha | West Virginia | 54039 | 14584 | 331 |
1274167 | 1274167 | 2021-04-30 | Lewis | West Virginia | 54041 | 1153 | 20 |
1274168 | 1274168 | 2021-04-30 | Lincoln | West Virginia | 54043 | 1435 | 21 |
1274169 | 1274169 | 2021-04-30 | Logan | West Virginia | 54045 | 3019 | 92 |
1274170 | 1274170 | 2021-04-30 | Marion | West Virginia | 54049 | 4306 | 45 |
1274171 | 1274171 | 2021-04-30 | Marshall | West Virginia | 54051 | 3359 | 76 |
1274172 | 1274172 | 2021-04-30 | Mason | West Virginia | 54053 | 1974 | 36 |
1274173 | 1274173 | 2021-04-30 | McDowell | West Virginia | 54047 | 1535 | 21 |
1274174 | 1274174 | 2021-04-30 | Mercer | West Virginia | 54055 | 4682 | 116 |
1274175 | 1274175 | 2021-04-30 | Mineral | West Virginia | 54057 | 2813 | 84 |
1274176 | 1274176 | 2021-04-30 | Mingo | West Virginia | 54059 | 2492 | 39 |
1274177 | 1274177 | 2021-04-30 | Monongalia | West Virginia | 54061 | 9085 | 82 |
1274178 | 1274178 | 2021-04-30 | Monroe | West Virginia | 54063 | 1106 | 17 |
1274179 | 1274179 | 2021-04-30 | Morgan | West Virginia | 54065 | 1124 | 20 |
1274180 | 1274180 | 2021-04-30 | Nicholas | West Virginia | 54067 | 1577 | 18 |
1274181 | 1274181 | 2021-04-30 | Ohio | West Virginia | 54069 | 4128 | 81 |
1274182 | 1274182 | 2021-04-30 | Pendleton | West Virginia | 54071 | 697 | 9 |
1274183 | 1274183 | 2021-04-30 | Pleasants | West Virginia | 54073 | 857 | 11 |
1274184 | 1274184 | 2021-04-30 | Pocahontas | West Virginia | 54075 | 662 | 10 |
1274185 | 1274185 | 2021-04-30 | Preston | West Virginia | 54077 | 2844 | 46 |
1274186 | 1274186 | 2021-04-30 | Putnam | West Virginia | 54079 | 4985 | 90 |
1274187 | 1274187 | 2021-04-30 | Raleigh | West Virginia | 54081 | 6565 | 82 |
1274188 | 1274188 | 2021-04-30 | Randolph | West Virginia | 54083 | 2526 | 12 |
1274189 | 1274189 | 2021-04-30 | Ritchie | West Virginia | 54085 | 679 | 11 |
1274190 | 1274190 | 2021-04-30 | Roane | West Virginia | 54087 | 597 | 8 |
1274191 | 1274191 | 2021-04-30 | Summers | West Virginia | 54089 | 793 | 21 |
1274192 | 1274192 | 2021-04-30 | Taylor | West Virginia | 54091 | 1209 | 23 |
1274193 | 1274193 | 2021-04-30 | Tucker | West Virginia | 54093 | 523 | 10 |
1274194 | 1274194 | 2021-04-30 | Tyler | West Virginia | 54095 | 683 | 9 |
1274195 | 1274195 | 2021-04-30 | Upshur | West Virginia | 54097 | 1842 | 33 |
1274196 | 1274196 | 2021-04-30 | Wayne | West Virginia | 54099 | 2993 | 40 |
1274197 | 1274197 | 2021-04-30 | Webster | West Virginia | 54101 | 469 | 7 |
1274198 | 1274198 | 2021-04-30 | Wetzel | West Virginia | 54103 | 1278 | 29 |
1274199 | 1274199 | 2021-04-30 | Wirt | West Virginia | 54105 | 397 | 3 |
1274200 | 1274200 | 2021-04-30 | Wood | West Virginia | 54107 | 7669 | 165 |
1274201 | 1274201 | 2021-04-30 | Wyoming | West Virginia | 54109 | 1961 | 39 |
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);