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-26 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1261159 | 1261159 | 2021-04-26 | Barbour | West Virginia | 54001 | 1374 | 26 |
1261160 | 1261160 | 2021-04-26 | Berkeley | West Virginia | 54003 | 11914 | 126 |
1261161 | 1261161 | 2021-04-26 | Boone | West Virginia | 54005 | 1933 | 40 |
1261162 | 1261162 | 2021-04-26 | Braxton | West Virginia | 54007 | 886 | 3 |
1261163 | 1261163 | 2021-04-26 | Brooke | West Virginia | 54009 | 2140 | 62 |
1261164 | 1261164 | 2021-04-26 | Cabell | West Virginia | 54011 | 8681 | 182 |
1261165 | 1261165 | 2021-04-26 | Calhoun | West Virginia | 54013 | 278 | 0 |
1261166 | 1261166 | 2021-04-26 | Clay | West Virginia | 54015 | 467 | 9 |
1261167 | 1261167 | 2021-04-26 | Doddridge | West Virginia | 54017 | 561 | 6 |
1261168 | 1261168 | 2021-04-26 | Fayette | West Virginia | 54019 | 3340 | 79 |
1261169 | 1261169 | 2021-04-26 | Gilmer | West Virginia | 54021 | 745 | 8 |
1261170 | 1261170 | 2021-04-26 | Grant | West Virginia | 54023 | 1248 | 29 |
1261171 | 1261171 | 2021-04-26 | Greenbrier | West Virginia | 54025 | 2697 | 65 |
1261172 | 1261172 | 2021-04-26 | Hampshire | West Virginia | 54027 | 1742 | 33 |
1261173 | 1261173 | 2021-04-26 | Hancock | West Virginia | 54029 | 2733 | 98 |
1261174 | 1261174 | 2021-04-26 | Hardy | West Virginia | 54031 | 1467 | 24 |
1261175 | 1261175 | 2021-04-26 | Harrison | West Virginia | 54033 | 5512 | 85 |
1261176 | 1261176 | 2021-04-26 | Jackson | West Virginia | 54035 | 1962 | 63 |
1261177 | 1261177 | 2021-04-26 | Jefferson | West Virginia | 54037 | 4457 | 50 |
1261178 | 1261178 | 2021-04-26 | Kanawha | West Virginia | 54039 | 14424 | 348 |
1261179 | 1261179 | 2021-04-26 | Lewis | West Virginia | 54041 | 1147 | 20 |
1261180 | 1261180 | 2021-04-26 | Lincoln | West Virginia | 54043 | 1423 | 22 |
1261181 | 1261181 | 2021-04-26 | Logan | West Virginia | 54045 | 2996 | 91 |
1261182 | 1261182 | 2021-04-26 | Marion | West Virginia | 54049 | 4260 | 50 |
1261183 | 1261183 | 2021-04-26 | Marshall | West Virginia | 54051 | 3327 | 77 |
1261184 | 1261184 | 2021-04-26 | Mason | West Virginia | 54053 | 1948 | 40 |
1261185 | 1261185 | 2021-04-26 | McDowell | West Virginia | 54047 | 1531 | 22 |
1261186 | 1261186 | 2021-04-26 | Mercer | West Virginia | 54055 | 4637 | 125 |
1261187 | 1261187 | 2021-04-26 | Mineral | West Virginia | 54057 | 2799 | 82 |
1261188 | 1261188 | 2021-04-26 | Mingo | West Virginia | 54059 | 2463 | 39 |
1261189 | 1261189 | 2021-04-26 | Monongalia | West Virginia | 54061 | 9034 | 88 |
1261190 | 1261190 | 2021-04-26 | Monroe | West Virginia | 54063 | 1096 | 17 |
1261191 | 1261191 | 2021-04-26 | Morgan | West Virginia | 54065 | 1105 | 20 |
1261192 | 1261192 | 2021-04-26 | Nicholas | West Virginia | 54067 | 1550 | 20 |
1261193 | 1261193 | 2021-04-26 | Ohio | West Virginia | 54069 | 4106 | 86 |
1261194 | 1261194 | 2021-04-26 | Pendleton | West Virginia | 54071 | 695 | 9 |
1261195 | 1261195 | 2021-04-26 | Pleasants | West Virginia | 54073 | 847 | 17 |
1261196 | 1261196 | 2021-04-26 | Pocahontas | West Virginia | 54075 | 657 | 10 |
1261197 | 1261197 | 2021-04-26 | Preston | West Virginia | 54077 | 2835 | 47 |
1261198 | 1261198 | 2021-04-26 | Putnam | West Virginia | 54079 | 4913 | 100 |
1261199 | 1261199 | 2021-04-26 | Raleigh | West Virginia | 54081 | 6411 | 82 |
1261200 | 1261200 | 2021-04-26 | Randolph | West Virginia | 54083 | 2510 | 13 |
1261201 | 1261201 | 2021-04-26 | Ritchie | West Virginia | 54085 | 674 | 11 |
1261202 | 1261202 | 2021-04-26 | Roane | West Virginia | 54087 | 593 | 8 |
1261203 | 1261203 | 2021-04-26 | Summers | West Virginia | 54089 | 775 | 23 |
1261204 | 1261204 | 2021-04-26 | Taylor | West Virginia | 54091 | 1206 | 23 |
1261205 | 1261205 | 2021-04-26 | Tucker | West Virginia | 54093 | 524 | 10 |
1261206 | 1261206 | 2021-04-26 | Tyler | West Virginia | 54095 | 677 | 9 |
1261207 | 1261207 | 2021-04-26 | Upshur | West Virginia | 54097 | 1834 | 35 |
1261208 | 1261208 | 2021-04-26 | Wayne | West Virginia | 54099 | 2854 | 39 |
1261209 | 1261209 | 2021-04-26 | Webster | West Virginia | 54101 | 463 | 7 |
1261210 | 1261210 | 2021-04-26 | Wetzel | West Virginia | 54103 | 1247 | 29 |
1261211 | 1261211 | 2021-04-26 | Wirt | West Virginia | 54105 | 385 | 3 |
1261212 | 1261212 | 2021-04-26 | Wood | West Virginia | 54107 | 7635 | 168 |
1261213 | 1261213 | 2021-04-26 | Wyoming | West Virginia | 54109 | 1953 | 43 |
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);