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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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
- …
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 |
---|---|---|---|---|---|---|---|
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 |
5140 | 5140 | 2020-03-19 | Tucker | West Virginia | 54093 | 2 | 0 |
6041 | 6041 | 2020-03-20 | Jackson | West Virginia | 54035 | 1 | 0 |
6042 | 6042 | 2020-03-20 | Jefferson | West Virginia | 54037 | 2 | 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 |
6046 | 6046 | 2020-03-20 | Tucker | West Virginia | 54093 | 2 | 0 |
7072 | 7072 | 2020-03-21 | Jackson | West Virginia | 54035 | 1 | 0 |
7073 | 7073 | 2020-03-21 | Jefferson | West Virginia | 54037 | 2 | 0 |
7074 | 7074 | 2020-03-21 | Kanawha | West Virginia | 54039 | 1 | 0 |
7075 | 7075 | 2020-03-21 | Marshall | West Virginia | 54051 | 2 | 0 |
7076 | 7076 | 2020-03-21 | Mercer | West Virginia | 54055 | 2 | 0 |
7077 | 7077 | 2020-03-21 | Monongalia | West Virginia | 54061 | 1 | 0 |
7078 | 7078 | 2020-03-21 | Putnam | West Virginia | 54079 | 1 | 0 |
7079 | 7079 | 2020-03-21 | Tucker | West Virginia | 54093 | 2 | 0 |
8210 | 8210 | 2020-03-22 | Jackson | West Virginia | 54035 | 1 | 0 |
8211 | 8211 | 2020-03-22 | Jefferson | West Virginia | 54037 | 3 | 0 |
8212 | 8212 | 2020-03-22 | Kanawha | West Virginia | 54039 | 3 | 0 |
8213 | 8213 | 2020-03-22 | Marshall | West Virginia | 54051 | 2 | 0 |
8214 | 8214 | 2020-03-22 | Mercer | West Virginia | 54055 | 2 | 0 |
8215 | 8215 | 2020-03-22 | Monongalia | West Virginia | 54061 | 2 | 0 |
8216 | 8216 | 2020-03-22 | Putnam | West Virginia | 54079 | 1 | 0 |
8217 | 8217 | 2020-03-22 | Tucker | West Virginia | 54093 | 2 | 0 |
9435 | 9435 | 2020-03-23 | Jackson | West Virginia | 54035 | 1 | 0 |
9436 | 9436 | 2020-03-23 | Jefferson | West Virginia | 54037 | 3 | 0 |
9437 | 9437 | 2020-03-23 | Kanawha | West Virginia | 54039 | 3 | 0 |
9438 | 9438 | 2020-03-23 | Marshall | West Virginia | 54051 | 2 | 0 |
9439 | 9439 | 2020-03-23 | Mercer | West Virginia | 54055 | 2 | 0 |
9440 | 9440 | 2020-03-23 | Monongalia | West Virginia | 54061 | 2 | 0 |
9441 | 9441 | 2020-03-23 | Putnam | West Virginia | 54079 | 1 | 0 |
9442 | 9442 | 2020-03-23 | Tucker | West Virginia | 54093 | 2 | 0 |
10785 | 10785 | 2020-03-24 | Berkeley | West Virginia | 54003 | 2 | 0 |
10786 | 10786 | 2020-03-24 | Harrison | West Virginia | 54033 | 3 | 0 |
10787 | 10787 | 2020-03-24 | Jackson | West Virginia | 54035 | 2 | 0 |
10788 | 10788 | 2020-03-24 | Jefferson | West Virginia | 54037 | 3 | 0 |
10789 | 10789 | 2020-03-24 | Kanawha | West Virginia | 54039 | 4 | 0 |
10790 | 10790 | 2020-03-24 | Marshall | West Virginia | 54051 | 2 | 0 |
10791 | 10791 | 2020-03-24 | Mercer | West Virginia | 54055 | 2 | 0 |
10792 | 10792 | 2020-03-24 | Monongalia | West Virginia | 54061 | 16 | 0 |
10793 | 10793 | 2020-03-24 | Preston | West Virginia | 54077 | 1 | 0 |
10794 | 10794 | 2020-03-24 | Putnam | West Virginia | 54079 | 1 | 0 |
10795 | 10795 | 2020-03-24 | Tucker | West Virginia | 54093 | 2 | 0 |
10796 | 10796 | 2020-03-24 | Wood | West Virginia | 54107 | 1 | 0 |
12308 | 12308 | 2020-03-25 | Berkeley | West Virginia | 54003 | 2 | 0 |
12309 | 12309 | 2020-03-25 | Harrison | West Virginia | 54033 | 3 | 0 |
12310 | 12310 | 2020-03-25 | Jackson | West Virginia | 54035 | 4 | 0 |
12311 | 12311 | 2020-03-25 | Jefferson | West Virginia | 54037 | 3 | 0 |
12312 | 12312 | 2020-03-25 | Kanawha | West Virginia | 54039 | 5 | 0 |
12313 | 12313 | 2020-03-25 | Logan | West Virginia | 54045 | 1 | 0 |
12314 | 12314 | 2020-03-25 | Marion | West Virginia | 54049 | 1 | 0 |
12315 | 12315 | 2020-03-25 | Marshall | West Virginia | 54051 | 2 | 0 |
12316 | 12316 | 2020-03-25 | Mercer | West Virginia | 54055 | 2 | 0 |
12317 | 12317 | 2020-03-25 | Monongalia | West Virginia | 54061 | 18 | 0 |
12318 | 12318 | 2020-03-25 | Ohio | West Virginia | 54069 | 2 | 0 |
12319 | 12319 | 2020-03-25 | Preston | West Virginia | 54077 | 2 | 0 |
12320 | 12320 | 2020-03-25 | Putnam | West Virginia | 54079 | 2 | 0 |
12321 | 12321 | 2020-03-25 | Raleigh | West Virginia | 54081 | 1 | 0 |
12322 | 12322 | 2020-03-25 | Tucker | West Virginia | 54093 | 2 | 0 |
12323 | 12323 | 2020-03-25 | Wood | West Virginia | 54107 | 1 | 0 |
13959 | 13959 | 2020-03-26 | Berkeley | West Virginia | 54003 | 4 | 0 |
13960 | 13960 | 2020-03-26 | Harrison | West Virginia | 54033 | 4 | 0 |
13961 | 13961 | 2020-03-26 | Jackson | West Virginia | 54035 | 5 | 0 |
13962 | 13962 | 2020-03-26 | Jefferson | West Virginia | 54037 | 4 | 0 |
13963 | 13963 | 2020-03-26 | Kanawha | West Virginia | 54039 | 15 | 0 |
13964 | 13964 | 2020-03-26 | Logan | West Virginia | 54045 | 1 | 0 |
13965 | 13965 | 2020-03-26 | Marion | West Virginia | 54049 | 2 | 0 |
13966 | 13966 | 2020-03-26 | Marshall | West Virginia | 54051 | 3 | 0 |
13967 | 13967 | 2020-03-26 | Mason | West Virginia | 54053 | 1 | 0 |
13968 | 13968 | 2020-03-26 | Mercer | West Virginia | 54055 | 2 | 0 |
13969 | 13969 | 2020-03-26 | Monongalia | West Virginia | 54061 | 24 | 0 |
13970 | 13970 | 2020-03-26 | Ohio | West Virginia | 54069 | 1 | 0 |
13971 | 13971 | 2020-03-26 | Preston | West Virginia | 54077 | 1 | 0 |
13972 | 13972 | 2020-03-26 | Putnam | West Virginia | 54079 | 2 | 0 |
13973 | 13973 | 2020-03-26 | Raleigh | West Virginia | 54081 | 2 | 0 |
13974 | 13974 | 2020-03-26 | Tucker | West Virginia | 54093 | 2 | 0 |
13975 | 13975 | 2020-03-26 | Upshur | West Virginia | 54097 | 1 | 0 |
13976 | 13976 | 2020-03-26 | Wood | West Virginia | 54107 | 2 | 0 |
15728 | 15728 | 2020-03-27 | Berkeley | West Virginia | 54003 | 9 | 0 |
15729 | 15729 | 2020-03-27 | Greenbrier | West Virginia | 54025 | 1 | 0 |
15730 | 15730 | 2020-03-27 | Hancock | West Virginia | 54029 | 1 | 0 |
15731 | 15731 | 2020-03-27 | Harrison | West Virginia | 54033 | 4 | 0 |
15732 | 15732 | 2020-03-27 | Jackson | West Virginia | 54035 | 6 | 0 |
15733 | 15733 | 2020-03-27 | Jefferson | West Virginia | 54037 | 4 | 0 |
15734 | 15734 | 2020-03-27 | Kanawha | West Virginia | 54039 | 17 | 0 |
15735 | 15735 | 2020-03-27 | Logan | West Virginia | 54045 | 1 | 0 |
15736 | 15736 | 2020-03-27 | Marion | West Virginia | 54049 | 3 | 0 |
15737 | 15737 | 2020-03-27 | Marshall | West Virginia | 54051 | 3 | 0 |
15738 | 15738 | 2020-03-27 | Mason | West Virginia | 54053 | 3 | 0 |
15739 | 15739 | 2020-03-27 | Mercer | West Virginia | 54055 | 2 | 0 |
15740 | 15740 | 2020-03-27 | Monongalia | West Virginia | 54061 | 23 | 0 |
15741 | 15741 | 2020-03-27 | Ohio | West Virginia | 54069 | 6 | 0 |
15742 | 15742 | 2020-03-27 | Pleasants | West Virginia | 54073 | 1 | 0 |
15743 | 15743 | 2020-03-27 | Preston | West Virginia | 54077 | 1 | 0 |
15744 | 15744 | 2020-03-27 | Putnam | West Virginia | 54079 | 3 | 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);