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-01-07 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 |
---|---|---|---|---|---|---|---|
907308 | 907308 | 2021-01-07 | Barbour | West Virginia | 54001 | 931 | 14 |
907309 | 907309 | 2021-01-07 | Berkeley | West Virginia | 54003 | 6999 | 57 |
907310 | 907310 | 2021-01-07 | Boone | West Virginia | 54005 | 1150 | 22 |
907311 | 907311 | 2021-01-07 | Braxton | West Virginia | 54007 | 599 | 1 |
907312 | 907312 | 2021-01-07 | Brooke | West Virginia | 54009 | 1574 | 31 |
907313 | 907313 | 2021-01-07 | Cabell | West Virginia | 54011 | 5801 | 114 |
907314 | 907314 | 2021-01-07 | Calhoun | West Virginia | 54013 | 160 | 0 |
907315 | 907315 | 2021-01-07 | Clay | West Virginia | 54015 | 271 | 4 |
907316 | 907316 | 2021-01-07 | Doddridge | West Virginia | 54017 | 284 | 3 |
907317 | 907317 | 2021-01-07 | Fayette | West Virginia | 54019 | 1941 | 53 |
907318 | 907318 | 2021-01-07 | Gilmer | West Virginia | 54021 | 457 | 1 |
907319 | 907319 | 2021-01-07 | Grant | West Virginia | 54023 | 835 | 18 |
907320 | 907320 | 2021-01-07 | Greenbrier | West Virginia | 54025 | 1711 | 41 |
907321 | 907321 | 2021-01-07 | Hampshire | West Virginia | 54027 | 1094 | 20 |
907322 | 907322 | 2021-01-07 | Hancock | West Virginia | 54029 | 2083 | 55 |
907323 | 907323 | 2021-01-07 | Hardy | West Virginia | 54031 | 882 | 10 |
907324 | 907324 | 2021-01-07 | Harrison | West Virginia | 54033 | 3438 | 36 |
907325 | 907325 | 2021-01-07 | Jackson | West Virginia | 54035 | 1310 | 33 |
907326 | 907326 | 2021-01-07 | Jefferson | West Virginia | 54037 | 2627 | 27 |
907327 | 907327 | 2021-01-07 | Kanawha | West Virginia | 54039 | 9345 | 223 |
907328 | 907328 | 2021-01-07 | Lewis | West Virginia | 54041 | 622 | 4 |
907329 | 907329 | 2021-01-07 | Lincoln | West Virginia | 54043 | 871 | 9 |
907330 | 907330 | 2021-01-07 | Logan | West Virginia | 54045 | 1854 | 59 |
907331 | 907331 | 2021-01-07 | Marion | West Virginia | 54049 | 2252 | 16 |
907332 | 907332 | 2021-01-07 | Marshall | West Virginia | 54051 | 2290 | 55 |
907333 | 907333 | 2021-01-07 | Mason | West Virginia | 54053 | 1145 | 20 |
907334 | 907334 | 2021-01-07 | McDowell | West Virginia | 54047 | 1049 | 6 |
907335 | 907335 | 2021-01-07 | Mercer | West Virginia | 54055 | 3254 | 62 |
907336 | 907336 | 2021-01-07 | Mineral | West Virginia | 54057 | 2207 | 70 |
907337 | 907337 | 2021-01-07 | Mingo | West Virginia | 54059 | 1582 | 20 |
907338 | 907338 | 2021-01-07 | Monongalia | West Virginia | 54061 | 5823 | 44 |
907339 | 907339 | 2021-01-07 | Monroe | West Virginia | 54063 | 713 | 11 |
907340 | 907340 | 2021-01-07 | Morgan | West Virginia | 54065 | 720 | 9 |
907341 | 907341 | 2021-01-07 | Nicholas | West Virginia | 54067 | 781 | 9 |
907342 | 907342 | 2021-01-07 | Ohio | West Virginia | 54069 | 2721 | 45 |
907343 | 907343 | 2021-01-07 | Pendleton | West Virginia | 54071 | 365 | 2 |
907344 | 907344 | 2021-01-07 | Pleasants | West Virginia | 54073 | 615 | 6 |
907345 | 907345 | 2021-01-07 | Pocahontas | West Virginia | 54075 | 397 | 9 |
907346 | 907346 | 2021-01-07 | Preston | West Virginia | 54077 | 1882 | 31 |
907347 | 907347 | 2021-01-07 | Putnam | West Virginia | 54079 | 3220 | 58 |
907348 | 907348 | 2021-01-07 | Raleigh | West Virginia | 54081 | 3048 | 31 |
907349 | 907349 | 2021-01-07 | Randolph | West Virginia | 54083 | 1328 | 6 |
907350 | 907350 | 2021-01-07 | Ritchie | West Virginia | 54085 | 403 | 7 |
907351 | 907351 | 2021-01-07 | Roane | West Virginia | 54087 | 340 | 6 |
907352 | 907352 | 2021-01-07 | Summers | West Virginia | 54089 | 514 | 17 |
907353 | 907353 | 2021-01-07 | Taylor | West Virginia | 54091 | 786 | 13 |
907354 | 907354 | 2021-01-07 | Tucker | West Virginia | 54093 | 386 | 4 |
907355 | 907355 | 2021-01-07 | Tyler | West Virginia | 54095 | 415 | 2 |
907356 | 907356 | 2021-01-07 | Upshur | West Virginia | 54097 | 1098 | 7 |
907357 | 907357 | 2021-01-07 | Wayne | West Virginia | 54099 | 1879 | 22 |
907358 | 907358 | 2021-01-07 | Webster | West Virginia | 54101 | 181 | 0 |
907359 | 907359 | 2021-01-07 | Wetzel | West Virginia | 54103 | 777 | 16 |
907360 | 907360 | 2021-01-07 | Wirt | West Virginia | 54105 | 249 | 1 |
907361 | 907361 | 2021-01-07 | Wood | West Virginia | 54107 | 5471 | 56 |
907362 | 907362 | 2021-01-07 | Wyoming | West Virginia | 54109 | 1272 | 22 |
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);