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-10-01 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 |
---|---|---|---|---|---|---|---|
1774225 | 1774225 | 2021-10-01 | Barbour | West Virginia | 54001 | 2439 | 41 |
1774226 | 1774226 | 2021-10-01 | Berkeley | West Virginia | 54003 | 16777 | 158 |
1774227 | 1774227 | 2021-10-01 | Boone | West Virginia | 54005 | 3171 | 42 |
1774228 | 1774228 | 2021-10-01 | Braxton | West Virginia | 54007 | 1915 | 14 |
1774229 | 1774229 | 2021-10-01 | Brooke | West Virginia | 54009 | 2876 | 67 |
1774230 | 1774230 | 2021-10-01 | Cabell | West Virginia | 54011 | 13683 | 228 |
1774231 | 1774231 | 2021-10-01 | Calhoun | West Virginia | 54013 | 820 | 4 |
1774232 | 1774232 | 2021-10-01 | Clay | West Virginia | 54015 | 1055 | 16 |
1774233 | 1774233 | 2021-10-01 | Doddridge | West Virginia | 54017 | 1047 | 8 |
1774234 | 1774234 | 2021-10-01 | Fayette | West Virginia | 54019 | 5475 | 104 |
1774235 | 1774235 | 2021-10-01 | Gilmer | West Virginia | 54021 | 1222 | 8 |
1774236 | 1774236 | 2021-10-01 | Grant | West Virginia | 54023 | 1929 | 31 |
1774237 | 1774237 | 2021-10-01 | Greenbrier | West Virginia | 54025 | 4499 | 80 |
1774238 | 1774238 | 2021-10-01 | Hampshire | West Virginia | 54027 | 2804 | 43 |
1774239 | 1774239 | 2021-10-01 | Hancock | West Virginia | 54029 | 3773 | 99 |
1774240 | 1774240 | 2021-10-01 | Hardy | West Virginia | 54031 | 2205 | 27 |
1774241 | 1774241 | 2021-10-01 | Harrison | West Virginia | 54033 | 9534 | 118 |
1774242 | 1774242 | 2021-10-01 | Jackson | West Virginia | 54035 | 3449 | 72 |
1774243 | 1774243 | 2021-10-01 | Jefferson | West Virginia | 54037 | 6302 | 75 |
1774244 | 1774244 | 2021-10-01 | Kanawha | West Virginia | 54039 | 22057 | 425 |
1774245 | 1774245 | 2021-10-01 | Lewis | West Virginia | 54041 | 2647 | 36 |
1774246 | 1774246 | 2021-10-01 | Lincoln | West Virginia | 54043 | 2444 | 35 |
1774247 | 1774247 | 2021-10-01 | Logan | West Virginia | 54045 | 4905 | 122 |
1774248 | 1774248 | 2021-10-01 | Marion | West Virginia | 54049 | 6961 | 76 |
1774249 | 1774249 | 2021-10-01 | Marshall | West Virginia | 54051 | 4929 | 99 |
1774250 | 1774250 | 2021-10-01 | Mason | West Virginia | 54053 | 3296 | 49 |
1774251 | 1774251 | 2021-10-01 | McDowell | West Virginia | 54047 | 2607 | 39 |
1774252 | 1774252 | 2021-10-01 | Mercer | West Virginia | 54055 | 7885 | 159 |
1774253 | 1774253 | 2021-10-01 | Mineral | West Virginia | 54057 | 4193 | 104 |
1774254 | 1774254 | 2021-10-01 | Mingo | West Virginia | 54059 | 4207 | 65 |
1774255 | 1774255 | 2021-10-01 | Monongalia | West Virginia | 54061 | 11737 | 119 |
1774256 | 1774256 | 2021-10-01 | Monroe | West Virginia | 54063 | 1945 | 25 |
1774257 | 1774257 | 2021-10-01 | Morgan | West Virginia | 54065 | 1860 | 36 |
1774258 | 1774258 | 2021-10-01 | Nicholas | West Virginia | 54067 | 3150 | 34 |
1774259 | 1774259 | 2021-10-01 | Ohio | West Virginia | 54069 | 5677 | 96 |
1774260 | 1774260 | 2021-10-01 | Pendleton | West Virginia | 54071 | 1044 | 12 |
1774261 | 1774261 | 2021-10-01 | Pleasants | West Virginia | 54073 | 1326 | 23 |
1774262 | 1774262 | 2021-10-01 | Pocahontas | West Virginia | 54075 | 1032 | 16 |
1774263 | 1774263 | 2021-10-01 | Preston | West Virginia | 54077 | 4454 | 60 |
1774264 | 1774264 | 2021-10-01 | Putnam | West Virginia | 54079 | 7891 | 109 |
1774265 | 1774265 | 2021-10-01 | Raleigh | West Virginia | 54081 | 10296 | 139 |
1774266 | 1774266 | 2021-10-01 | Randolph | West Virginia | 54083 | 4701 | 34 |
1774267 | 1774267 | 2021-10-01 | Ritchie | West Virginia | 54085 | 1309 | 17 |
1774268 | 1774268 | 2021-10-01 | Roane | West Virginia | 54087 | 1259 | 15 |
1774269 | 1774269 | 2021-10-01 | Summers | West Virginia | 54089 | 1323 | 27 |
1774270 | 1774270 | 2021-10-01 | Taylor | West Virginia | 54091 | 1974 | 35 |
1774271 | 1774271 | 2021-10-01 | Tucker | West Virginia | 54093 | 946 | 17 |
1774272 | 1774272 | 2021-10-01 | Tyler | West Virginia | 54095 | 1272 | 18 |
1774273 | 1774273 | 2021-10-01 | Upshur | West Virginia | 54097 | 3580 | 56 |
1774274 | 1774274 | 2021-10-01 | Wayne | West Virginia | 54099 | 5102 | 60 |
1774275 | 1774275 | 2021-10-01 | Webster | West Virginia | 54101 | 976 | 14 |
1774276 | 1774276 | 2021-10-01 | Wetzel | West Virginia | 54103 | 2302 | 46 |
1774277 | 1774277 | 2021-10-01 | Wirt | West Virginia | 54105 | 743 | 10 |
1774278 | 1774278 | 2021-10-01 | Wood | West Virginia | 54107 | 11824 | 209 |
1774279 | 1774279 | 2021-10-01 | Wyoming | West Virginia | 54109 | 3275 | 51 |
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);