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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 54081 778
- 54093 778
- 54097 778
- 54107 778
- 54003 777
- 54025 777
- 54029 777
- 54033 777
- 54035 777
- 54037 777
- 54039 777
- 54045 777
- 54049 777
- 54051 777
- 54053 777
- 54055 777
- 54061 777
- 54069 777
- 54073 777
- 54077 777
- 54079 777
- 54011 776
- 54065 776
- 54103 776
- 54105 776
- 54083 775
- 54087 775
- 54031 774
- 54001 773
- 54071 772
- …
county >30
- Raleigh 778
- Tucker 778
- Upshur 778
- Wood 778
- Berkeley 777
- Greenbrier 777
- Hancock 777
- Harrison 777
- Jackson 777
- Jefferson 777
- Kanawha 777
- Logan 777
- Marion 777
- Marshall 777
- Mason 777
- Mercer 777
- Monongalia 777
- Ohio 777
- Pleasants 777
- Preston 777
- Putnam 777
- Cabell 776
- Morgan 776
- Wetzel 776
- Wirt 776
- Randolph 775
- Roane 775
- Hardy 774
- Barbour 773
- Pendleton 772
- …
state 1
- West Virginia · 42,138 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
15745 | 15745 | 2020-03-27 | Raleigh | West Virginia | 54081 | 3 | 0 |
15746 | 15746 | 2020-03-27 | Tucker | West Virginia | 54093 | 2 | 0 |
15747 | 15747 | 2020-03-27 | Upshur | West Virginia | 54097 | 1 | 0 |
15748 | 15748 | 2020-03-27 | Wood | West Virginia | 54107 | 2 | 0 |
17608 | 17608 | 2020-03-28 | Berkeley | West Virginia | 54003 | 10 | 0 |
17609 | 17609 | 2020-03-28 | Greenbrier | West Virginia | 54025 | 2 | 0 |
17610 | 17610 | 2020-03-28 | Hancock | West Virginia | 54029 | 3 | 0 |
17611 | 17611 | 2020-03-28 | Harrison | West Virginia | 54033 | 5 | 0 |
17612 | 17612 | 2020-03-28 | Jackson | West Virginia | 54035 | 7 | 0 |
17613 | 17613 | 2020-03-28 | Jefferson | West Virginia | 54037 | 4 | 0 |
17614 | 17614 | 2020-03-28 | Kanawha | West Virginia | 54039 | 19 | 0 |
17615 | 17615 | 2020-03-28 | Logan | West Virginia | 54045 | 1 | 0 |
17616 | 17616 | 2020-03-28 | Marion | West Virginia | 54049 | 5 | 0 |
17617 | 17617 | 2020-03-28 | Marshall | West Virginia | 54051 | 4 | 0 |
17618 | 17618 | 2020-03-28 | Mason | West Virginia | 54053 | 3 | 0 |
17619 | 17619 | 2020-03-28 | Mercer | West Virginia | 54055 | 2 | 0 |
17620 | 17620 | 2020-03-28 | Monongalia | West Virginia | 54061 | 29 | 0 |
17621 | 17621 | 2020-03-28 | Ohio | West Virginia | 54069 | 6 | 0 |
17622 | 17622 | 2020-03-28 | Pleasants | West Virginia | 54073 | 1 | 0 |
17623 | 17623 | 2020-03-28 | Preston | West Virginia | 54077 | 1 | 0 |
17624 | 17624 | 2020-03-28 | Putnam | West Virginia | 54079 | 3 | 0 |
17625 | 17625 | 2020-03-28 | Raleigh | West Virginia | 54081 | 3 | 0 |
17626 | 17626 | 2020-03-28 | Tucker | West Virginia | 54093 | 2 | 0 |
17627 | 17627 | 2020-03-28 | Upshur | West Virginia | 54097 | 1 | 0 |
17628 | 17628 | 2020-03-28 | Wood | West Virginia | 54107 | 2 | 0 |
19573 | 19573 | 2020-03-29 | Berkeley | West Virginia | 54003 | 10 | 0 |
19574 | 19574 | 2020-03-29 | Cabell | West Virginia | 54011 | 1 | 0 |
19575 | 19575 | 2020-03-29 | Greenbrier | West Virginia | 54025 | 2 | 0 |
19576 | 19576 | 2020-03-29 | Hancock | West Virginia | 54029 | 3 | 0 |
19577 | 19577 | 2020-03-29 | Harrison | West Virginia | 54033 | 7 | 0 |
19578 | 19578 | 2020-03-29 | Jackson | West Virginia | 54035 | 8 | 0 |
19579 | 19579 | 2020-03-29 | Jefferson | West Virginia | 54037 | 5 | 0 |
19580 | 19580 | 2020-03-29 | Kanawha | West Virginia | 54039 | 19 | 0 |
19581 | 19581 | 2020-03-29 | Logan | West Virginia | 54045 | 1 | 0 |
19583 | 19583 | 2020-03-29 | Marshall | West Virginia | 54051 | 4 | 0 |
19584 | 19584 | 2020-03-29 | Mason | West Virginia | 54053 | 3 | 0 |
19585 | 19585 | 2020-03-29 | Mercer | West Virginia | 54055 | 2 | 0 |
19586 | 19586 | 2020-03-29 | Monongalia | West Virginia | 54061 | 30 | 0 |
19587 | 19587 | 2020-03-29 | Morgan | West Virginia | 54065 | 1 | 0 |
19588 | 19588 | 2020-03-29 | Ohio | West Virginia | 54069 | 7 | 0 |
19589 | 19589 | 2020-03-29 | Pleasants | West Virginia | 54073 | 1 | 0 |
19590 | 19590 | 2020-03-29 | Preston | West Virginia | 54077 | 1 | 0 |
19591 | 19591 | 2020-03-29 | Putnam | West Virginia | 54079 | 3 | 0 |
19592 | 19592 | 2020-03-29 | Raleigh | West Virginia | 54081 | 4 | 0 |
19593 | 19593 | 2020-03-29 | Tucker | West Virginia | 54093 | 2 | 0 |
19594 | 19594 | 2020-03-29 | Upshur | West Virginia | 54097 | 1 | 0 |
19595 | 19595 | 2020-03-29 | Wetzel | West Virginia | 54103 | 1 | 0 |
19596 | 19596 | 2020-03-29 | Wirt | West Virginia | 54105 | 1 | 0 |
19597 | 19597 | 2020-03-29 | Wood | West Virginia | 54107 | 2 | 0 |
21640 | 21640 | 2020-03-30 | Berkeley | West Virginia | 54003 | 14 | 0 |
21641 | 21641 | 2020-03-30 | Cabell | West Virginia | 54011 | 1 | 0 |
21642 | 21642 | 2020-03-30 | Greenbrier | West Virginia | 54025 | 3 | 0 |
21643 | 21643 | 2020-03-30 | Hancock | West Virginia | 54029 | 3 | 0 |
21644 | 21644 | 2020-03-30 | Harrison | West Virginia | 54033 | 10 | 0 |
21645 | 21645 | 2020-03-30 | Jackson | West Virginia | 54035 | 8 | 0 |
21646 | 21646 | 2020-03-30 | Jefferson | West Virginia | 54037 | 6 | 0 |
21647 | 21647 | 2020-03-30 | Kanawha | West Virginia | 54039 | 23 | 0 |
21648 | 21648 | 2020-03-30 | Logan | West Virginia | 54045 | 2 | 0 |
21650 | 21650 | 2020-03-30 | Marshall | West Virginia | 54051 | 4 | 0 |
21651 | 21651 | 2020-03-30 | Mason | West Virginia | 54053 | 3 | 0 |
21652 | 21652 | 2020-03-30 | Mercer | West Virginia | 54055 | 2 | 0 |
21653 | 21653 | 2020-03-30 | Monongalia | West Virginia | 54061 | 31 | 0 |
21654 | 21654 | 2020-03-30 | Morgan | West Virginia | 54065 | 1 | 0 |
21655 | 21655 | 2020-03-30 | Ohio | West Virginia | 54069 | 9 | 0 |
21656 | 21656 | 2020-03-30 | Pleasants | West Virginia | 54073 | 1 | 0 |
21657 | 21657 | 2020-03-30 | Preston | West Virginia | 54077 | 2 | 0 |
21658 | 21658 | 2020-03-30 | Putnam | West Virginia | 54079 | 4 | 0 |
21659 | 21659 | 2020-03-30 | Raleigh | West Virginia | 54081 | 3 | 0 |
21660 | 21660 | 2020-03-30 | Randolph | West Virginia | 54083 | 1 | 0 |
21661 | 21661 | 2020-03-30 | Roane | West Virginia | 54087 | 2 | 0 |
21662 | 21662 | 2020-03-30 | Tucker | West Virginia | 54093 | 2 | 0 |
21663 | 21663 | 2020-03-30 | Upshur | West Virginia | 54097 | 1 | 0 |
21664 | 21664 | 2020-03-30 | Wetzel | West Virginia | 54103 | 1 | 0 |
21665 | 21665 | 2020-03-30 | Wirt | West Virginia | 54105 | 1 | 0 |
21666 | 21666 | 2020-03-30 | Wood | West Virginia | 54107 | 2 | 0 |
23789 | 23789 | 2020-03-31 | Berkeley | West Virginia | 54003 | 16 | 0 |
23790 | 23790 | 2020-03-31 | Cabell | West Virginia | 54011 | 1 | 0 |
23791 | 23791 | 2020-03-31 | Greenbrier | West Virginia | 54025 | 3 | 0 |
23792 | 23792 | 2020-03-31 | Hancock | West Virginia | 54029 | 3 | 0 |
23793 | 23793 | 2020-03-31 | Hardy | West Virginia | 54031 | 1 | 0 |
23794 | 23794 | 2020-03-31 | Harrison | West Virginia | 54033 | 11 | 0 |
23795 | 23795 | 2020-03-31 | Jackson | West Virginia | 54035 | 9 | 0 |
23796 | 23796 | 2020-03-31 | Jefferson | West Virginia | 54037 | 8 | 0 |
23797 | 23797 | 2020-03-31 | Kanawha | West Virginia | 54039 | 31 | 0 |
23798 | 23798 | 2020-03-31 | Logan | West Virginia | 54045 | 2 | 0 |
23800 | 23800 | 2020-03-31 | Marshall | West Virginia | 54051 | 4 | 0 |
23801 | 23801 | 2020-03-31 | Mason | West Virginia | 54053 | 3 | 0 |
23802 | 23802 | 2020-03-31 | Mercer | West Virginia | 54055 | 2 | 0 |
23803 | 23803 | 2020-03-31 | Monongalia | West Virginia | 54061 | 31 | 0 |
23804 | 23804 | 2020-03-31 | Morgan | West Virginia | 54065 | 1 | 0 |
23805 | 23805 | 2020-03-31 | Ohio | West Virginia | 54069 | 10 | 0 |
23806 | 23806 | 2020-03-31 | Pleasants | West Virginia | 54073 | 1 | 0 |
23807 | 23807 | 2020-03-31 | Preston | West Virginia | 54077 | 3 | 0 |
23808 | 23808 | 2020-03-31 | Putnam | West Virginia | 54079 | 4 | 0 |
23809 | 23809 | 2020-03-31 | Raleigh | West Virginia | 54081 | 3 | 0 |
23810 | 23810 | 2020-03-31 | Randolph | West Virginia | 54083 | 1 | 0 |
23811 | 23811 | 2020-03-31 | Roane | West Virginia | 54087 | 2 | 0 |
23812 | 23812 | 2020-03-31 | Tucker | West Virginia | 54093 | 2 | 0 |
23813 | 23813 | 2020-03-31 | Upshur | West Virginia | 54097 | 1 | 0 |
23814 | 23814 | 2020-03-31 | Wetzel | West Virginia | 54103 | 1 | 0 |
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);