ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42,238 rows where state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 54037 311
- 54055 310
- 54061 309
- 54093 309
- 54035 308
- 54039 308
- 54051 307
- 54079 307
- 54003 304
- 54033 304
- 54077 304
- 54107 304
- 54045 303
- 54049 303
- 54069 303
- 54081 303
- 54053 302
- 54097 302
- 54025 301
- 54029 301
- 54073 301
- 54011 299
- 54065 299
- 54103 299
- 54105 299
- 54083 298
- 54087 298
- 54031 297
- 54001 296
- 54071 295
- …
county >30
- Jefferson 311
- Mercer 310
- Monongalia 309
- Tucker 309
- Jackson 308
- Kanawha 308
- Marshall 307
- Putnam 307
- Berkeley 304
- Harrison 304
- Preston 304
- Wood 304
- Logan 303
- Marion 303
- Ohio 303
- Raleigh 303
- Mason 302
- Upshur 302
- Greenbrier 301
- Hancock 301
- Pleasants 301
- Cabell 299
- Morgan 299
- Wetzel 299
- Wirt 299
- Randolph 298
- Roane 298
- Hardy 297
- Barbour 296
- Pendleton 295
- …
state 1
- West Virginia · 16,001 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
952742 | 952742 | 2021-01-21 | Barbour | West Virginia | 54001 | 1030 | 15 |
952743 | 952743 | 2021-01-21 | Berkeley | West Virginia | 54003 | 8289 | 73 |
952744 | 952744 | 2021-01-21 | Boone | West Virginia | 54005 | 1338 | 28 |
952745 | 952745 | 2021-01-21 | Braxton | West Virginia | 54007 | 718 | 1 |
952746 | 952746 | 2021-01-21 | Brooke | West Virginia | 54009 | 1811 | 47 |
952747 | 952747 | 2021-01-21 | Cabell | West Virginia | 54011 | 6604 | 135 |
952748 | 952748 | 2021-01-21 | Calhoun | West Virginia | 54013 | 194 | 0 |
952749 | 952749 | 2021-01-21 | Clay | West Virginia | 54015 | 310 | 4 |
952750 | 952750 | 2021-01-21 | Doddridge | West Virginia | 54017 | 375 | 5 |
952751 | 952751 | 2021-01-21 | Fayette | West Virginia | 54019 | 2218 | 61 |
952752 | 952752 | 2021-01-21 | Gilmer | West Virginia | 54021 | 542 | 6 |
952753 | 952753 | 2021-01-21 | Grant | West Virginia | 54023 | 936 | 19 |
952754 | 952754 | 2021-01-21 | Greenbrier | West Virginia | 54025 | 2100 | 47 |
952755 | 952755 | 2021-01-21 | Hampshire | West Virginia | 54027 | 1278 | 24 |
952756 | 952756 | 2021-01-21 | Hancock | West Virginia | 54029 | 2360 | 77 |
952757 | 952757 | 2021-01-21 | Hardy | West Virginia | 54031 | 1119 | 14 |
952758 | 952758 | 2021-01-21 | Harrison | West Virginia | 54033 | 4157 | 45 |
952759 | 952759 | 2021-01-21 | Jackson | West Virginia | 54035 | 1526 | 43 |
952760 | 952760 | 2021-01-21 | Jefferson | West Virginia | 54037 | 3072 | 31 |
952761 | 952761 | 2021-01-21 | Kanawha | West Virginia | 54039 | 10483 | 248 |
952762 | 952762 | 2021-01-21 | Lewis | West Virginia | 54041 | 746 | 11 |
952763 | 952763 | 2021-01-21 | Lincoln | West Virginia | 54043 | 1065 | 9 |
952764 | 952764 | 2021-01-21 | Logan | West Virginia | 54045 | 2169 | 66 |
952765 | 952765 | 2021-01-21 | Marion | West Virginia | 54049 | 3023 | 24 |
952766 | 952766 | 2021-01-21 | Marshall | West Virginia | 54051 | 2612 | 60 |
952767 | 952767 | 2021-01-21 | Mason | West Virginia | 54053 | 1432 | 26 |
952768 | 952768 | 2021-01-21 | McDowell | West Virginia | 54047 | 1166 | 8 |
952769 | 952769 | 2021-01-21 | Mercer | West Virginia | 54055 | 3754 | 78 |
952770 | 952770 | 2021-01-21 | Mineral | West Virginia | 54057 | 2337 | 73 |
952771 | 952771 | 2021-01-21 | Mingo | West Virginia | 54059 | 1803 | 20 |
952772 | 952772 | 2021-01-21 | Monongalia | West Virginia | 54061 | 6648 | 54 |
952773 | 952773 | 2021-01-21 | Monroe | West Virginia | 54063 | 839 | 11 |
952774 | 952774 | 2021-01-21 | Morgan | West Virginia | 54065 | 833 | 10 |
952775 | 952775 | 2021-01-21 | Nicholas | West Virginia | 54067 | 966 | 9 |
952776 | 952776 | 2021-01-21 | Ohio | West Virginia | 54069 | 3180 | 57 |
952777 | 952777 | 2021-01-21 | Pendleton | West Virginia | 54071 | 505 | 3 |
952778 | 952778 | 2021-01-21 | Pleasants | West Virginia | 54073 | 734 | 12 |
952779 | 952779 | 2021-01-21 | Pocahontas | West Virginia | 54075 | 529 | 9 |
952780 | 952780 | 2021-01-21 | Preston | West Virginia | 54077 | 2305 | 35 |
952781 | 952781 | 2021-01-21 | Putnam | West Virginia | 54079 | 3588 | 67 |
952782 | 952782 | 2021-01-21 | Raleigh | West Virginia | 54081 | 3797 | 40 |
952783 | 952783 | 2021-01-21 | Randolph | West Virginia | 54083 | 2032 | 8 |
952784 | 952784 | 2021-01-21 | Ritchie | West Virginia | 54085 | 516 | 8 |
952785 | 952785 | 2021-01-21 | Roane | West Virginia | 54087 | 421 | 6 |
952786 | 952786 | 2021-01-21 | Summers | West Virginia | 54089 | 642 | 19 |
952787 | 952787 | 2021-01-21 | Taylor | West Virginia | 54091 | 932 | 15 |
952788 | 952788 | 2021-01-21 | Tucker | West Virginia | 54093 | 427 | 7 |
952789 | 952789 | 2021-01-21 | Tyler | West Virginia | 54095 | 522 | 3 |
952790 | 952790 | 2021-01-21 | Upshur | West Virginia | 54097 | 1333 | 20 |
952791 | 952791 | 2021-01-21 | Wayne | West Virginia | 54099 | 2157 | 26 |
952792 | 952792 | 2021-01-21 | Webster | West Virginia | 54101 | 225 | 0 |
952793 | 952793 | 2021-01-21 | Wetzel | West Virginia | 54103 | 930 | 18 |
952794 | 952794 | 2021-01-21 | Wirt | West Virginia | 54105 | 305 | 1 |
952795 | 952795 | 2021-01-21 | Wood | West Virginia | 54107 | 6227 | 87 |
952796 | 952796 | 2021-01-21 | Wyoming | West Virginia | 54109 | 1457 | 26 |
949497 | 949497 | 2021-01-20 | Barbour | West Virginia | 54001 | 1018 | 15 |
949498 | 949498 | 2021-01-20 | Berkeley | West Virginia | 54003 | 8227 | 73 |
949499 | 949499 | 2021-01-20 | Boone | West Virginia | 54005 | 1315 | 28 |
949500 | 949500 | 2021-01-20 | Braxton | West Virginia | 54007 | 694 | 1 |
949501 | 949501 | 2021-01-20 | Brooke | West Virginia | 54009 | 1801 | 47 |
949502 | 949502 | 2021-01-20 | Cabell | West Virginia | 54011 | 6556 | 133 |
949503 | 949503 | 2021-01-20 | Calhoun | West Virginia | 54013 | 191 | 0 |
949504 | 949504 | 2021-01-20 | Clay | West Virginia | 54015 | 306 | 4 |
949505 | 949505 | 2021-01-20 | Doddridge | West Virginia | 54017 | 369 | 4 |
949506 | 949506 | 2021-01-20 | Fayette | West Virginia | 54019 | 2204 | 61 |
949507 | 949507 | 2021-01-20 | Gilmer | West Virginia | 54021 | 539 | 6 |
949508 | 949508 | 2021-01-20 | Grant | West Virginia | 54023 | 932 | 19 |
949509 | 949509 | 2021-01-20 | Greenbrier | West Virginia | 54025 | 2083 | 47 |
949510 | 949510 | 2021-01-20 | Hampshire | West Virginia | 54027 | 1257 | 24 |
949511 | 949511 | 2021-01-20 | Hancock | West Virginia | 54029 | 2344 | 76 |
949512 | 949512 | 2021-01-20 | Hardy | West Virginia | 54031 | 1107 | 14 |
949513 | 949513 | 2021-01-20 | Harrison | West Virginia | 54033 | 4114 | 44 |
949514 | 949514 | 2021-01-20 | Jackson | West Virginia | 54035 | 1510 | 43 |
949515 | 949515 | 2021-01-20 | Jefferson | West Virginia | 54037 | 3059 | 31 |
949516 | 949516 | 2021-01-20 | Kanawha | West Virginia | 54039 | 10439 | 243 |
949517 | 949517 | 2021-01-20 | Lewis | West Virginia | 54041 | 737 | 11 |
949518 | 949518 | 2021-01-20 | Lincoln | West Virginia | 54043 | 1054 | 9 |
949519 | 949519 | 2021-01-20 | Logan | West Virginia | 54045 | 2160 | 66 |
949520 | 949520 | 2021-01-20 | Marion | West Virginia | 54049 | 2977 | 24 |
949521 | 949521 | 2021-01-20 | Marshall | West Virginia | 54051 | 2593 | 60 |
949522 | 949522 | 2021-01-20 | Mason | West Virginia | 54053 | 1405 | 26 |
949523 | 949523 | 2021-01-20 | McDowell | West Virginia | 54047 | 1145 | 8 |
949524 | 949524 | 2021-01-20 | Mercer | West Virginia | 54055 | 3737 | 77 |
949525 | 949525 | 2021-01-20 | Mineral | West Virginia | 54057 | 2331 | 73 |
949526 | 949526 | 2021-01-20 | Mingo | West Virginia | 54059 | 1795 | 20 |
949527 | 949527 | 2021-01-20 | Monongalia | West Virginia | 54061 | 6574 | 54 |
949528 | 949528 | 2021-01-20 | Monroe | West Virginia | 54063 | 834 | 11 |
949529 | 949529 | 2021-01-20 | Morgan | West Virginia | 54065 | 830 | 10 |
949530 | 949530 | 2021-01-20 | Nicholas | West Virginia | 54067 | 957 | 9 |
949531 | 949531 | 2021-01-20 | Ohio | West Virginia | 54069 | 3154 | 57 |
949532 | 949532 | 2021-01-20 | Pendleton | West Virginia | 54071 | 492 | 3 |
949533 | 949533 | 2021-01-20 | Pleasants | West Virginia | 54073 | 732 | 13 |
949534 | 949534 | 2021-01-20 | Pocahontas | West Virginia | 54075 | 521 | 9 |
949535 | 949535 | 2021-01-20 | Preston | West Virginia | 54077 | 2266 | 35 |
949536 | 949536 | 2021-01-20 | Putnam | West Virginia | 54079 | 3578 | 67 |
949537 | 949537 | 2021-01-20 | Raleigh | West Virginia | 54081 | 3769 | 40 |
949538 | 949538 | 2021-01-20 | Randolph | West Virginia | 54083 | 2008 | 8 |
949539 | 949539 | 2021-01-20 | Ritchie | West Virginia | 54085 | 508 | 8 |
949540 | 949540 | 2021-01-20 | Roane | West Virginia | 54087 | 410 | 6 |
949541 | 949541 | 2021-01-20 | Summers | West Virginia | 54089 | 641 | 19 |
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);