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 303
- 54055 302
- 54093 302
- 54061 301
- 54035 300
- 54039 300
- 54051 299
- 54079 299
- 54107 297
- 54003 296
- 54033 296
- 54077 296
- 54045 295
- 54049 295
- 54069 295
- 54081 295
- 54097 295
- 54053 294
- 54025 293
- 54029 293
- 54073 293
- 54103 292
- 54105 292
- 54011 291
- 54065 291
- 54083 290
- 54087 290
- 54031 289
- 54001 288
- 54071 287
- …
county >30
- Jefferson 303
- Mercer 302
- Tucker 302
- Monongalia 301
- Jackson 300
- Kanawha 300
- Marshall 299
- Putnam 299
- Wood 297
- Berkeley 296
- Harrison 296
- Preston 296
- Logan 295
- Marion 295
- Ohio 295
- Raleigh 295
- Upshur 295
- Mason 294
- Greenbrier 293
- Hancock 293
- Pleasants 293
- Wetzel 292
- Wirt 292
- Cabell 291
- Morgan 291
- Randolph 290
- Roane 290
- Hardy 289
- Barbour 288
- Pendleton 287
- …
state 1
- West Virginia · 15,571 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930069 | 930069 | 2021-01-14 | Taylor | West Virginia | 54091 | 875 | 13 |
930070 | 930070 | 2021-01-14 | Tucker | West Virginia | 54093 | 405 | 4 |
930071 | 930071 | 2021-01-14 | Tyler | West Virginia | 54095 | 459 | 3 |
930072 | 930072 | 2021-01-14 | Upshur | West Virginia | 54097 | 1215 | 14 |
930073 | 930073 | 2021-01-14 | Wayne | West Virginia | 54099 | 2041 | 25 |
930074 | 930074 | 2021-01-14 | Webster | West Virginia | 54101 | 215 | 0 |
930075 | 930075 | 2021-01-14 | Wetzel | West Virginia | 54103 | 853 | 16 |
930076 | 930076 | 2021-01-14 | Wirt | West Virginia | 54105 | 272 | 1 |
930077 | 930077 | 2021-01-14 | Wood | West Virginia | 54107 | 5939 | 70 |
930078 | 930078 | 2021-01-14 | Wyoming | West Virginia | 54109 | 1363 | 24 |
926779 | 926779 | 2021-01-13 | Barbour | West Virginia | 54001 | 1129 | 14 |
926780 | 926780 | 2021-01-13 | Berkeley | West Virginia | 54003 | 7688 | 63 |
926781 | 926781 | 2021-01-13 | Boone | West Virginia | 54005 | 1239 | 27 |
926782 | 926782 | 2021-01-13 | Braxton | West Virginia | 54007 | 643 | 1 |
926783 | 926783 | 2021-01-13 | Brooke | West Virginia | 54009 | 1680 | 41 |
926784 | 926784 | 2021-01-13 | Cabell | West Virginia | 54011 | 6184 | 123 |
926785 | 926785 | 2021-01-13 | Calhoun | West Virginia | 54013 | 178 | 0 |
926786 | 926786 | 2021-01-13 | Clay | West Virginia | 54015 | 289 | 4 |
926787 | 926787 | 2021-01-13 | Doddridge | West Virginia | 54017 | 325 | 3 |
926788 | 926788 | 2021-01-13 | Fayette | West Virginia | 54019 | 2079 | 55 |
926789 | 926789 | 2021-01-13 | Gilmer | West Virginia | 54021 | 510 | 5 |
926790 | 926790 | 2021-01-13 | Grant | West Virginia | 54023 | 896 | 19 |
926791 | 926791 | 2021-01-13 | Greenbrier | West Virginia | 54025 | 1936 | 43 |
926792 | 926792 | 2021-01-13 | Hampshire | West Virginia | 54027 | 1188 | 24 |
926793 | 926793 | 2021-01-13 | Hancock | West Virginia | 54029 | 2228 | 66 |
926794 | 926794 | 2021-01-13 | Hardy | West Virginia | 54031 | 1015 | 12 |
926795 | 926795 | 2021-01-13 | Harrison | West Virginia | 54033 | 3789 | 39 |
926796 | 926796 | 2021-01-13 | Jackson | West Virginia | 54035 | 1425 | 39 |
926797 | 926797 | 2021-01-13 | Jefferson | West Virginia | 54037 | 2861 | 28 |
926798 | 926798 | 2021-01-13 | Kanawha | West Virginia | 54039 | 9933 | 232 |
926799 | 926799 | 2021-01-13 | Lewis | West Virginia | 54041 | 677 | 9 |
926800 | 926800 | 2021-01-13 | Lincoln | West Virginia | 54043 | 962 | 9 |
926801 | 926801 | 2021-01-13 | Logan | West Virginia | 54045 | 2018 | 64 |
926802 | 926802 | 2021-01-13 | Marion | West Virginia | 54049 | 2612 | 20 |
926803 | 926803 | 2021-01-13 | Marshall | West Virginia | 54051 | 2454 | 57 |
926804 | 926804 | 2021-01-13 | Mason | West Virginia | 54053 | 1250 | 25 |
926805 | 926805 | 2021-01-13 | McDowell | West Virginia | 54047 | 1102 | 7 |
926806 | 926806 | 2021-01-13 | Mercer | West Virginia | 54055 | 3559 | 67 |
926807 | 926807 | 2021-01-13 | Mineral | West Virginia | 54057 | 2270 | 72 |
926808 | 926808 | 2021-01-13 | Mingo | West Virginia | 54059 | 1678 | 20 |
926809 | 926809 | 2021-01-13 | Monongalia | West Virginia | 54061 | 6217 | 49 |
926810 | 926810 | 2021-01-13 | Monroe | West Virginia | 54063 | 759 | 11 |
926811 | 926811 | 2021-01-13 | Morgan | West Virginia | 54065 | 790 | 9 |
926812 | 926812 | 2021-01-13 | Nicholas | West Virginia | 54067 | 869 | 9 |
926813 | 926813 | 2021-01-13 | Ohio | West Virginia | 54069 | 2931 | 52 |
926814 | 926814 | 2021-01-13 | Pendleton | West Virginia | 54071 | 413 | 3 |
926815 | 926815 | 2021-01-13 | Pleasants | West Virginia | 54073 | 698 | 9 |
926816 | 926816 | 2021-01-13 | Pocahontas | West Virginia | 54075 | 438 | 9 |
926817 | 926817 | 2021-01-13 | Preston | West Virginia | 54077 | 2083 | 34 |
926818 | 926818 | 2021-01-13 | Putnam | West Virginia | 54079 | 3399 | 61 |
926819 | 926819 | 2021-01-13 | Raleigh | West Virginia | 54081 | 3400 | 34 |
926820 | 926820 | 2021-01-13 | Randolph | West Virginia | 54083 | 1639 | 8 |
926821 | 926821 | 2021-01-13 | Ritchie | West Virginia | 54085 | 469 | 8 |
926822 | 926822 | 2021-01-13 | Roane | West Virginia | 54087 | 375 | 6 |
926823 | 926823 | 2021-01-13 | Summers | West Virginia | 54089 | 589 | 18 |
926824 | 926824 | 2021-01-13 | Taylor | West Virginia | 54091 | 861 | 13 |
926825 | 926825 | 2021-01-13 | Tucker | West Virginia | 54093 | 405 | 4 |
926826 | 926826 | 2021-01-13 | Tyler | West Virginia | 54095 | 455 | 3 |
926827 | 926827 | 2021-01-13 | Upshur | West Virginia | 54097 | 1203 | 13 |
926828 | 926828 | 2021-01-13 | Wayne | West Virginia | 54099 | 2025 | 25 |
926829 | 926829 | 2021-01-13 | Webster | West Virginia | 54101 | 201 | 0 |
926830 | 926830 | 2021-01-13 | Wetzel | West Virginia | 54103 | 848 | 16 |
926831 | 926831 | 2021-01-13 | Wirt | West Virginia | 54105 | 273 | 1 |
926832 | 926832 | 2021-01-13 | Wood | West Virginia | 54107 | 5902 | 65 |
926833 | 926833 | 2021-01-13 | Wyoming | West Virginia | 54109 | 1353 | 23 |
923533 | 923533 | 2021-01-12 | Barbour | West Virginia | 54001 | 1088 | 14 |
923534 | 923534 | 2021-01-12 | Berkeley | West Virginia | 54003 | 7597 | 60 |
923535 | 923535 | 2021-01-12 | Boone | West Virginia | 54005 | 1228 | 25 |
923536 | 923536 | 2021-01-12 | Braxton | West Virginia | 54007 | 633 | 1 |
923537 | 923537 | 2021-01-12 | Brooke | West Virginia | 54009 | 1654 | 40 |
923538 | 923538 | 2021-01-12 | Cabell | West Virginia | 54011 | 6101 | 121 |
923539 | 923539 | 2021-01-12 | Calhoun | West Virginia | 54013 | 177 | 0 |
923540 | 923540 | 2021-01-12 | Clay | West Virginia | 54015 | 288 | 4 |
923541 | 923541 | 2021-01-12 | Doddridge | West Virginia | 54017 | 320 | 3 |
923542 | 923542 | 2021-01-12 | Fayette | West Virginia | 54019 | 2063 | 55 |
923543 | 923543 | 2021-01-12 | Gilmer | West Virginia | 54021 | 506 | 5 |
923544 | 923544 | 2021-01-12 | Grant | West Virginia | 54023 | 882 | 19 |
923545 | 923545 | 2021-01-12 | Greenbrier | West Virginia | 54025 | 1914 | 43 |
923546 | 923546 | 2021-01-12 | Hampshire | West Virginia | 54027 | 1175 | 23 |
923547 | 923547 | 2021-01-12 | Hancock | West Virginia | 54029 | 2200 | 61 |
923548 | 923548 | 2021-01-12 | Hardy | West Virginia | 54031 | 1011 | 11 |
923549 | 923549 | 2021-01-12 | Harrison | West Virginia | 54033 | 3742 | 39 |
923550 | 923550 | 2021-01-12 | Jackson | West Virginia | 54035 | 1411 | 39 |
923551 | 923551 | 2021-01-12 | Jefferson | West Virginia | 54037 | 2828 | 28 |
923552 | 923552 | 2021-01-12 | Kanawha | West Virginia | 54039 | 9853 | 227 |
923553 | 923553 | 2021-01-12 | Lewis | West Virginia | 54041 | 663 | 8 |
923554 | 923554 | 2021-01-12 | Lincoln | West Virginia | 54043 | 954 | 9 |
923555 | 923555 | 2021-01-12 | Logan | West Virginia | 54045 | 1992 | 63 |
923556 | 923556 | 2021-01-12 | Marion | West Virginia | 54049 | 2580 | 19 |
923557 | 923557 | 2021-01-12 | Marshall | West Virginia | 54051 | 2433 | 57 |
923558 | 923558 | 2021-01-12 | Mason | West Virginia | 54053 | 1232 | 24 |
923559 | 923559 | 2021-01-12 | McDowell | West Virginia | 54047 | 1095 | 7 |
923560 | 923560 | 2021-01-12 | Mercer | West Virginia | 54055 | 3534 | 67 |
923561 | 923561 | 2021-01-12 | Mineral | West Virginia | 54057 | 2264 | 71 |
923562 | 923562 | 2021-01-12 | Mingo | West Virginia | 54059 | 1666 | 20 |
923563 | 923563 | 2021-01-12 | Monongalia | West Virginia | 54061 | 6157 | 49 |
923564 | 923564 | 2021-01-12 | Monroe | West Virginia | 54063 | 757 | 11 |
923565 | 923565 | 2021-01-12 | Morgan | West Virginia | 54065 | 784 | 9 |
923566 | 923566 | 2021-01-12 | Nicholas | West Virginia | 54067 | 856 | 9 |
923567 | 923567 | 2021-01-12 | Ohio | West Virginia | 54069 | 2906 | 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);