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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 54037 788
- 54055 787
- 54061 786
- 54093 786
- 54035 785
- 54039 785
- 54051 784
- 54079 784
- 54003 781
- 54033 781
- 54077 781
- 54107 781
- 54045 780
- 54049 780
- 54069 780
- 54081 780
- 54053 779
- 54097 779
- 54025 778
- 54029 778
- 54073 778
- 54011 776
- 54065 776
- 54103 776
- 54105 776
- 54083 775
- 54087 775
- 54031 774
- 54001 773
- 54071 772
- …
date (date) >30 ✖
- 2021-09-03 56
- 2021-09-09 56
- 2020-07-25 55
- 2020-07-26 55
- 2020-07-27 55
- 2020-07-28 55
- 2020-07-29 55
- 2020-07-30 55
- 2020-07-31 55
- 2020-08-01 55
- 2020-08-02 55
- 2020-08-03 55
- 2020-08-04 55
- 2020-08-05 55
- 2020-08-06 55
- 2020-08-07 55
- 2020-08-08 55
- 2020-08-09 55
- 2020-08-10 55
- 2020-08-11 55
- 2020-08-12 55
- 2020-08-13 55
- 2020-08-14 55
- 2020-08-15 55
- 2020-08-16 55
- 2020-08-17 55
- 2020-08-18 55
- 2020-08-19 55
- 2020-08-20 55
- 2020-08-21 55
- …
county >30
- Jefferson 788
- Mercer 787
- Monongalia 786
- Tucker 786
- Jackson 785
- Kanawha 785
- Marshall 784
- Putnam 784
- Berkeley 781
- Harrison 781
- Preston 781
- Wood 781
- Logan 780
- Marion 780
- Ohio 780
- Raleigh 780
- Mason 779
- Upshur 779
- Greenbrier 778
- Hancock 778
- Pleasants 778
- Cabell 776
- Morgan 776
- Wetzel 776
- Wirt 776
- Randolph 775
- Roane 775
- Hardy 774
- Barbour 773
- Pendleton 772
- …
state 1
- West Virginia · 42,238 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
26031 | 26031 | 2020-04-01 | Unknown | West Virginia | 0 | 1 | |
3745 | 3745 | 2020-03-17 | Jefferson | West Virginia | 54037 | 1 | 0 |
4380 | 4380 | 2020-03-18 | Jefferson | West Virginia | 54037 | 1 | 0 |
4381 | 4381 | 2020-03-18 | Mercer | West Virginia | 54055 | 1 | 0 |
5137 | 5137 | 2020-03-19 | Jefferson | West Virginia | 54037 | 1 | 0 |
5138 | 5138 | 2020-03-19 | Mercer | West Virginia | 54055 | 1 | 0 |
5139 | 5139 | 2020-03-19 | Monongalia | West Virginia | 54061 | 1 | 0 |
6041 | 6041 | 2020-03-20 | Jackson | West Virginia | 54035 | 1 | 0 |
6043 | 6043 | 2020-03-20 | Kanawha | West Virginia | 54039 | 1 | 0 |
6044 | 6044 | 2020-03-20 | Mercer | West Virginia | 54055 | 1 | 0 |
6045 | 6045 | 2020-03-20 | Monongalia | West Virginia | 54061 | 1 | 0 |
7072 | 7072 | 2020-03-21 | Jackson | West Virginia | 54035 | 1 | 0 |
7074 | 7074 | 2020-03-21 | Kanawha | West Virginia | 54039 | 1 | 0 |
7077 | 7077 | 2020-03-21 | Monongalia | West Virginia | 54061 | 1 | 0 |
7078 | 7078 | 2020-03-21 | Putnam | West Virginia | 54079 | 1 | 0 |
8210 | 8210 | 2020-03-22 | Jackson | West Virginia | 54035 | 1 | 0 |
8216 | 8216 | 2020-03-22 | Putnam | West Virginia | 54079 | 1 | 0 |
9435 | 9435 | 2020-03-23 | Jackson | West Virginia | 54035 | 1 | 0 |
9441 | 9441 | 2020-03-23 | Putnam | West Virginia | 54079 | 1 | 0 |
10793 | 10793 | 2020-03-24 | Preston | West Virginia | 54077 | 1 | 0 |
10794 | 10794 | 2020-03-24 | Putnam | West Virginia | 54079 | 1 | 0 |
10796 | 10796 | 2020-03-24 | Wood | West Virginia | 54107 | 1 | 0 |
12313 | 12313 | 2020-03-25 | Logan | West Virginia | 54045 | 1 | 0 |
12314 | 12314 | 2020-03-25 | Marion | West Virginia | 54049 | 1 | 0 |
12321 | 12321 | 2020-03-25 | Raleigh | West Virginia | 54081 | 1 | 0 |
12323 | 12323 | 2020-03-25 | Wood | West Virginia | 54107 | 1 | 0 |
13964 | 13964 | 2020-03-26 | Logan | West Virginia | 54045 | 1 | 0 |
13967 | 13967 | 2020-03-26 | Mason | West Virginia | 54053 | 1 | 0 |
13970 | 13970 | 2020-03-26 | Ohio | West Virginia | 54069 | 1 | 0 |
13971 | 13971 | 2020-03-26 | Preston | West Virginia | 54077 | 1 | 0 |
13975 | 13975 | 2020-03-26 | Upshur | West Virginia | 54097 | 1 | 0 |
15729 | 15729 | 2020-03-27 | Greenbrier | West Virginia | 54025 | 1 | 0 |
15730 | 15730 | 2020-03-27 | Hancock | West Virginia | 54029 | 1 | 0 |
15735 | 15735 | 2020-03-27 | Logan | West Virginia | 54045 | 1 | 0 |
15742 | 15742 | 2020-03-27 | Pleasants | West Virginia | 54073 | 1 | 0 |
15743 | 15743 | 2020-03-27 | Preston | West Virginia | 54077 | 1 | 0 |
15747 | 15747 | 2020-03-27 | Upshur | West Virginia | 54097 | 1 | 0 |
17615 | 17615 | 2020-03-28 | Logan | West Virginia | 54045 | 1 | 0 |
17622 | 17622 | 2020-03-28 | Pleasants | West Virginia | 54073 | 1 | 0 |
17623 | 17623 | 2020-03-28 | Preston | West Virginia | 54077 | 1 | 0 |
17627 | 17627 | 2020-03-28 | Upshur | West Virginia | 54097 | 1 | 0 |
19574 | 19574 | 2020-03-29 | Cabell | West Virginia | 54011 | 1 | 0 |
19581 | 19581 | 2020-03-29 | Logan | West Virginia | 54045 | 1 | 0 |
19587 | 19587 | 2020-03-29 | Morgan | West Virginia | 54065 | 1 | 0 |
19589 | 19589 | 2020-03-29 | Pleasants | West Virginia | 54073 | 1 | 0 |
19590 | 19590 | 2020-03-29 | Preston | West Virginia | 54077 | 1 | 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 |
21641 | 21641 | 2020-03-30 | Cabell | West Virginia | 54011 | 1 | 0 |
21654 | 21654 | 2020-03-30 | Morgan | West Virginia | 54065 | 1 | 0 |
21656 | 21656 | 2020-03-30 | Pleasants | West Virginia | 54073 | 1 | 0 |
21660 | 21660 | 2020-03-30 | Randolph | West Virginia | 54083 | 1 | 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 |
23790 | 23790 | 2020-03-31 | Cabell | West Virginia | 54011 | 1 | 0 |
23793 | 23793 | 2020-03-31 | Hardy | West Virginia | 54031 | 1 | 0 |
23804 | 23804 | 2020-03-31 | Morgan | West Virginia | 54065 | 1 | 0 |
23806 | 23806 | 2020-03-31 | Pleasants | West Virginia | 54073 | 1 | 0 |
23810 | 23810 | 2020-03-31 | Randolph | West Virginia | 54083 | 1 | 0 |
23813 | 23813 | 2020-03-31 | Upshur | West Virginia | 54097 | 1 | 0 |
23814 | 23814 | 2020-03-31 | Wetzel | West Virginia | 54103 | 1 | 0 |
23815 | 23815 | 2020-03-31 | Wirt | West Virginia | 54105 | 1 | 0 |
26006 | 26006 | 2020-04-01 | Barbour | West Virginia | 54001 | 1 | 0 |
26008 | 26008 | 2020-04-01 | Cabell | West Virginia | 54011 | 1 | 0 |
26011 | 26011 | 2020-04-01 | Hardy | West Virginia | 54031 | 1 | 0 |
26022 | 26022 | 2020-04-01 | Morgan | West Virginia | 54065 | 1 | 0 |
26024 | 26024 | 2020-04-01 | Pleasants | West Virginia | 54073 | 1 | 0 |
26028 | 26028 | 2020-04-01 | Randolph | West Virginia | 54083 | 1 | 0 |
26032 | 26032 | 2020-04-01 | Upshur | West Virginia | 54097 | 1 | 0 |
26034 | 26034 | 2020-04-01 | Wirt | West Virginia | 54105 | 1 | 0 |
28298 | 28298 | 2020-04-02 | Barbour | West Virginia | 54001 | 1 | 0 |
28314 | 28314 | 2020-04-02 | Morgan | West Virginia | 54065 | 1 | 0 |
28316 | 28316 | 2020-04-02 | Pendleton | West Virginia | 54071 | 1 | 0 |
28317 | 28317 | 2020-04-02 | Pleasants | West Virginia | 54073 | 1 | 0 |
28324 | 28324 | 2020-04-02 | Upshur | West Virginia | 54097 | 1 | 0 |
28326 | 28326 | 2020-04-02 | Wirt | West Virginia | 54105 | 1 | 0 |
30651 | 30651 | 2020-04-03 | Barbour | West Virginia | 54001 | 1 | 0 |
30668 | 30668 | 2020-04-03 | Morgan | West Virginia | 54065 | 1 | 0 |
30670 | 30670 | 2020-04-03 | Pendleton | West Virginia | 54071 | 1 | 0 |
30671 | 30671 | 2020-04-03 | Pleasants | West Virginia | 54073 | 1 | 0 |
30678 | 30678 | 2020-04-03 | Upshur | West Virginia | 54097 | 1 | 0 |
30680 | 30680 | 2020-04-03 | Wirt | West Virginia | 54105 | 1 | 0 |
33069 | 33069 | 2020-04-04 | Morgan | West Virginia | 54065 | 1 | 0 |
33071 | 33071 | 2020-04-04 | Pendleton | West Virginia | 54071 | 1 | 0 |
33072 | 33072 | 2020-04-04 | Pleasants | West Virginia | 54073 | 1 | 0 |
33079 | 33079 | 2020-04-04 | Upshur | West Virginia | 54097 | 1 | 0 |
33081 | 33081 | 2020-04-04 | Wirt | West Virginia | 54105 | 1 | 0 |
35509 | 35509 | 2020-04-05 | Pendleton | West Virginia | 54071 | 1 | 0 |
35510 | 35510 | 2020-04-05 | Pleasants | West Virginia | 54073 | 1 | 0 |
35517 | 35517 | 2020-04-05 | Upshur | West Virginia | 54097 | 1 | 0 |
35519 | 35519 | 2020-04-05 | Wirt | West Virginia | 54105 | 1 | 0 |
37984 | 37984 | 2020-04-06 | Lewis | West Virginia | 54041 | 1 | 0 |
37994 | 37994 | 2020-04-06 | Pendleton | West Virginia | 54071 | 1 | 0 |
37995 | 37995 | 2020-04-06 | Pleasants | West Virginia | 54073 | 1 | 0 |
38001 | 38001 | 2020-04-06 | Taylor | West Virginia | 54091 | 1 | 0 |
38003 | 38003 | 2020-04-06 | Upshur | West Virginia | 54097 | 1 | 0 |
38005 | 38005 | 2020-04-06 | Wirt | West Virginia | 54105 | 1 | 0 |
40511 | 40511 | 2020-04-07 | Brooke | West Virginia | 54009 | 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);