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 2022-01-10 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 |
---|---|---|---|---|---|---|---|
2102476 | 2102476 | 2022-01-10 | Barbour | West Virginia | 54001 | 3419 | 56 |
2102477 | 2102477 | 2022-01-10 | Berkeley | West Virginia | 54003 | 28892 | 221 |
2102478 | 2102478 | 2022-01-10 | Boone | West Virginia | 54005 | 4584 | 62 |
2102479 | 2102479 | 2022-01-10 | Braxton | West Virginia | 54007 | 2939 | 32 |
2102480 | 2102480 | 2022-01-10 | Brooke | West Virginia | 54009 | 3989 | 87 |
2102481 | 2102481 | 2022-01-10 | Cabell | West Virginia | 54011 | 19532 | 308 |
2102482 | 2102482 | 2022-01-10 | Calhoun | West Virginia | 54013 | 1299 | 9 |
2102483 | 2102483 | 2022-01-10 | Clay | West Virginia | 54015 | 1760 | 28 |
2102484 | 2102484 | 2022-01-10 | Doddridge | West Virginia | 54017 | 1606 | 15 |
2102485 | 2102485 | 2022-01-10 | Fayette | West Virginia | 54019 | 8319 | 152 |
2102486 | 2102486 | 2022-01-10 | Gilmer | West Virginia | 54021 | 1642 | 16 |
2102487 | 2102487 | 2022-01-10 | Grant | West Virginia | 54023 | 2919 | 49 |
2102488 | 2102488 | 2022-01-10 | Greenbrier | West Virginia | 54025 | 6352 | 123 |
2102489 | 2102489 | 2022-01-10 | Hampshire | West Virginia | 54027 | 4492 | 60 |
2102490 | 2102490 | 2022-01-10 | Hancock | West Virginia | 54029 | 5505 | 126 |
2102491 | 2102491 | 2022-01-10 | Hardy | West Virginia | 54031 | 3293 | 41 |
2102492 | 2102492 | 2022-01-10 | Harrison | West Virginia | 54033 | 14393 | 204 |
2102493 | 2102493 | 2022-01-10 | Jackson | West Virginia | 54035 | 4953 | 111 |
2102494 | 2102494 | 2022-01-10 | Jefferson | West Virginia | 54037 | 11152 | 100 |
2102495 | 2102495 | 2022-01-10 | Kanawha | West Virginia | 54039 | 32322 | 583 |
2102496 | 2102496 | 2022-01-10 | Lewis | West Virginia | 54041 | 3881 | 67 |
2102497 | 2102497 | 2022-01-10 | Lincoln | West Virginia | 54043 | 3771 | 58 |
2102498 | 2102498 | 2022-01-10 | Logan | West Virginia | 54045 | 6672 | 155 |
2102499 | 2102499 | 2022-01-10 | Marion | West Virginia | 54049 | 10718 | 140 |
2102500 | 2102500 | 2022-01-10 | Marshall | West Virginia | 54051 | 6621 | 134 |
2102501 | 2102501 | 2022-01-10 | Mason | West Virginia | 54053 | 4600 | 73 |
2102502 | 2102502 | 2022-01-10 | McDowell | West Virginia | 54047 | 3699 | 56 |
2102503 | 2102503 | 2022-01-10 | Mercer | West Virginia | 54055 | 11829 | 210 |
2102504 | 2102504 | 2022-01-10 | Mineral | West Virginia | 54057 | 6043 | 138 |
2102505 | 2102505 | 2022-01-10 | Mingo | West Virginia | 54059 | 5588 | 101 |
2102506 | 2102506 | 2022-01-10 | Monongalia | West Virginia | 54061 | 17897 | 160 |
2102507 | 2102507 | 2022-01-10 | Monroe | West Virginia | 54063 | 2813 | 32 |
2102508 | 2102508 | 2022-01-10 | Morgan | West Virginia | 54065 | 3274 | 57 |
2102509 | 2102509 | 2022-01-10 | Nicholas | West Virginia | 54067 | 5163 | 75 |
2102510 | 2102510 | 2022-01-10 | Ohio | West Virginia | 54069 | 8448 | 132 |
2102511 | 2102511 | 2022-01-10 | Pendleton | West Virginia | 54071 | 1419 | 16 |
2102512 | 2102512 | 2022-01-10 | Pleasants | West Virginia | 54073 | 1681 | 31 |
2102513 | 2102513 | 2022-01-10 | Pocahontas | West Virginia | 54075 | 1464 | 23 |
2102514 | 2102514 | 2022-01-10 | Preston | West Virginia | 54077 | 6932 | 112 |
2102515 | 2102515 | 2022-01-10 | Putnam | West Virginia | 54079 | 11718 | 147 |
2102516 | 2102516 | 2022-01-10 | Raleigh | West Virginia | 54081 | 15042 | 233 |
2102517 | 2102517 | 2022-01-10 | Randolph | West Virginia | 54083 | 6384 | 64 |
2102518 | 2102518 | 2022-01-10 | Ritchie | West Virginia | 54085 | 1794 | 26 |
2102519 | 2102519 | 2022-01-10 | Roane | West Virginia | 54087 | 2195 | 29 |
2102520 | 2102520 | 2022-01-10 | Summers | West Virginia | 54089 | 1850 | 41 |
2102521 | 2102521 | 2022-01-10 | Taylor | West Virginia | 54091 | 3180 | 53 |
2102522 | 2102522 | 2022-01-10 | Tucker | West Virginia | 54093 | 1418 | 32 |
2102523 | 2102523 | 2022-01-10 | Tyler | West Virginia | 54095 | 1591 | 26 |
2102524 | 2102524 | 2022-01-10 | Upshur | West Virginia | 54097 | 5062 | 76 |
2102525 | 2102525 | 2022-01-10 | Wayne | West Virginia | 54099 | 6968 | 96 |
2102526 | 2102526 | 2022-01-10 | Webster | West Virginia | 54101 | 1587 | 27 |
2102527 | 2102527 | 2022-01-10 | Wetzel | West Virginia | 54103 | 3216 | 68 |
2102528 | 2102528 | 2022-01-10 | Wirt | West Virginia | 54105 | 1066 | 19 |
2102529 | 2102529 | 2022-01-10 | Wood | West Virginia | 54107 | 16790 | 278 |
2102530 | 2102530 | 2022-01-10 | Wyoming | West Virginia | 54109 | 4533 | 77 |
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);