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 county
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 |
---|---|---|---|---|---|---|---|
26006 | 26006 | 2020-04-01 | Barbour | West Virginia | 54001 | 1 | 0 |
28298 | 28298 | 2020-04-02 | Barbour | West Virginia | 54001 | 1 | 0 |
30651 | 30651 | 2020-04-03 | Barbour | West Virginia | 54001 | 1 | 0 |
33052 | 33052 | 2020-04-04 | Barbour | West Virginia | 54001 | 2 | 0 |
35490 | 35490 | 2020-04-05 | Barbour | West Virginia | 54001 | 3 | 0 |
37974 | 37974 | 2020-04-06 | Barbour | West Virginia | 54001 | 4 | 0 |
40509 | 40509 | 2020-04-07 | Barbour | West Virginia | 54001 | 4 | 0 |
43078 | 43078 | 2020-04-08 | Barbour | West Virginia | 54001 | 4 | 0 |
45674 | 45674 | 2020-04-09 | Barbour | West Virginia | 54001 | 5 | 0 |
48302 | 48302 | 2020-04-10 | Barbour | West Virginia | 54001 | 5 | 0 |
50960 | 50960 | 2020-04-11 | Barbour | West Virginia | 54001 | 4 | 0 |
53635 | 53635 | 2020-04-12 | Barbour | West Virginia | 54001 | 8 | 0 |
56325 | 56325 | 2020-04-13 | Barbour | West Virginia | 54001 | 9 | 0 |
59031 | 59031 | 2020-04-14 | Barbour | West Virginia | 54001 | 4 | 0 |
61750 | 61750 | 2020-04-15 | Barbour | West Virginia | 54001 | 4 | 0 |
64483 | 64483 | 2020-04-16 | Barbour | West Virginia | 54001 | 4 | 0 |
67231 | 67231 | 2020-04-17 | Barbour | West Virginia | 54001 | 4 | 0 |
69993 | 69993 | 2020-04-18 | Barbour | West Virginia | 54001 | 4 | 0 |
72762 | 72762 | 2020-04-19 | Barbour | West Virginia | 54001 | 4 | 0 |
75538 | 75538 | 2020-04-20 | Barbour | West Virginia | 54001 | 4 | 0 |
78321 | 78321 | 2020-04-21 | Barbour | West Virginia | 54001 | 4 | 0 |
81114 | 81114 | 2020-04-22 | Barbour | West Virginia | 54001 | 4 | 0 |
83915 | 83915 | 2020-04-23 | Barbour | West Virginia | 54001 | 4 | 1 |
86722 | 86722 | 2020-04-24 | Barbour | West Virginia | 54001 | 4 | 1 |
89537 | 89537 | 2020-04-25 | Barbour | West Virginia | 54001 | 4 | 1 |
92354 | 92354 | 2020-04-26 | Barbour | West Virginia | 54001 | 4 | 1 |
95183 | 95183 | 2020-04-27 | Barbour | West Virginia | 54001 | 4 | 1 |
98028 | 98028 | 2020-04-28 | Barbour | West Virginia | 54001 | 4 | 1 |
100878 | 100878 | 2020-04-29 | Barbour | West Virginia | 54001 | 4 | 1 |
103733 | 103733 | 2020-04-30 | Barbour | West Virginia | 54001 | 5 | 1 |
106597 | 106597 | 2020-05-01 | Barbour | West Virginia | 54001 | 5 | 1 |
109466 | 109466 | 2020-05-02 | Barbour | West Virginia | 54001 | 5 | 1 |
112340 | 112340 | 2020-05-03 | Barbour | West Virginia | 54001 | 5 | 1 |
115223 | 115223 | 2020-05-04 | Barbour | West Virginia | 54001 | 5 | 1 |
118182 | 118182 | 2020-05-05 | Barbour | West Virginia | 54001 | 6 | 1 |
121146 | 121146 | 2020-05-06 | Barbour | West Virginia | 54001 | 6 | 1 |
124126 | 124126 | 2020-05-07 | Barbour | West Virginia | 54001 | 6 | 1 |
127111 | 127111 | 2020-05-08 | Barbour | West Virginia | 54001 | 7 | 1 |
130101 | 130101 | 2020-05-09 | Barbour | West Virginia | 54001 | 7 | 1 |
133091 | 133091 | 2020-05-10 | Barbour | West Virginia | 54001 | 7 | 1 |
136081 | 136081 | 2020-05-11 | Barbour | West Virginia | 54001 | 7 | 1 |
139072 | 139072 | 2020-05-12 | Barbour | West Virginia | 54001 | 7 | 1 |
142068 | 142068 | 2020-05-13 | Barbour | West Virginia | 54001 | 7 | 1 |
145065 | 145065 | 2020-05-14 | Barbour | West Virginia | 54001 | 7 | 1 |
148068 | 148068 | 2020-05-15 | Barbour | West Virginia | 54001 | 7 | 1 |
151077 | 151077 | 2020-05-16 | Barbour | West Virginia | 54001 | 7 | 1 |
154088 | 154088 | 2020-05-17 | Barbour | West Virginia | 54001 | 7 | 1 |
157105 | 157105 | 2020-05-18 | Barbour | West Virginia | 54001 | 7 | 1 |
160129 | 160129 | 2020-05-19 | Barbour | West Virginia | 54001 | 7 | 1 |
163157 | 163157 | 2020-05-20 | Barbour | West Virginia | 54001 | 7 | 1 |
166186 | 166186 | 2020-05-21 | Barbour | West Virginia | 54001 | 7 | 1 |
169222 | 169222 | 2020-05-22 | Barbour | West Virginia | 54001 | 7 | 1 |
172263 | 172263 | 2020-05-23 | Barbour | West Virginia | 54001 | 7 | 1 |
175306 | 175306 | 2020-05-24 | Barbour | West Virginia | 54001 | 7 | 1 |
178351 | 178351 | 2020-05-25 | Barbour | West Virginia | 54001 | 7 | 1 |
181395 | 181395 | 2020-05-26 | Barbour | West Virginia | 54001 | 9 | 1 |
184446 | 184446 | 2020-05-27 | Barbour | West Virginia | 54001 | 9 | 1 |
187503 | 187503 | 2020-05-28 | Barbour | West Virginia | 54001 | 9 | 1 |
190567 | 190567 | 2020-05-29 | Barbour | West Virginia | 54001 | 9 | 1 |
193633 | 193633 | 2020-05-30 | Barbour | West Virginia | 54001 | 9 | 1 |
196703 | 196703 | 2020-05-31 | Barbour | West Virginia | 54001 | 9 | 1 |
199776 | 199776 | 2020-06-01 | Barbour | West Virginia | 54001 | 9 | 1 |
202852 | 202852 | 2020-06-02 | Barbour | West Virginia | 54001 | 9 | 1 |
205931 | 205931 | 2020-06-03 | Barbour | West Virginia | 54001 | 8 | 1 |
209013 | 209013 | 2020-06-04 | Barbour | West Virginia | 54001 | 8 | 1 |
212098 | 212098 | 2020-06-05 | Barbour | West Virginia | 54001 | 8 | 1 |
215185 | 215185 | 2020-06-06 | Barbour | West Virginia | 54001 | 8 | 1 |
218275 | 218275 | 2020-06-07 | Barbour | West Virginia | 54001 | 8 | 1 |
221367 | 221367 | 2020-06-08 | Barbour | West Virginia | 54001 | 8 | 1 |
224463 | 224463 | 2020-06-09 | Barbour | West Virginia | 54001 | 9 | 1 |
227563 | 227563 | 2020-06-10 | Barbour | West Virginia | 54001 | 9 | 1 |
230667 | 230667 | 2020-06-11 | Barbour | West Virginia | 54001 | 10 | 1 |
233772 | 233772 | 2020-06-12 | Barbour | West Virginia | 54001 | 10 | 1 |
236879 | 236879 | 2020-06-13 | Barbour | West Virginia | 54001 | 10 | 1 |
239987 | 239987 | 2020-06-14 | Barbour | West Virginia | 54001 | 10 | 1 |
243098 | 243098 | 2020-06-15 | Barbour | West Virginia | 54001 | 10 | 1 |
246211 | 246211 | 2020-06-16 | Barbour | West Virginia | 54001 | 10 | 1 |
249323 | 249323 | 2020-06-17 | Barbour | West Virginia | 54001 | 11 | 1 |
252438 | 252438 | 2020-06-18 | Barbour | West Virginia | 54001 | 11 | 1 |
255557 | 255557 | 2020-06-19 | Barbour | West Virginia | 54001 | 11 | 1 |
258684 | 258684 | 2020-06-20 | Barbour | West Virginia | 54001 | 11 | 1 |
261811 | 261811 | 2020-06-21 | Barbour | West Virginia | 54001 | 12 | 1 |
264940 | 264940 | 2020-06-22 | Barbour | West Virginia | 54001 | 13 | 1 |
268069 | 268069 | 2020-06-23 | Barbour | West Virginia | 54001 | 15 | 1 |
271203 | 271203 | 2020-06-24 | Barbour | West Virginia | 54001 | 15 | 1 |
274343 | 274343 | 2020-06-25 | Barbour | West Virginia | 54001 | 15 | 1 |
277491 | 277491 | 2020-06-26 | Barbour | West Virginia | 54001 | 15 | 1 |
280639 | 280639 | 2020-06-27 | Barbour | West Virginia | 54001 | 15 | 1 |
283785 | 283785 | 2020-06-28 | Barbour | West Virginia | 54001 | 15 | 1 |
286931 | 286931 | 2020-06-29 | Barbour | West Virginia | 54001 | 15 | 1 |
290081 | 290081 | 2020-06-30 | Barbour | West Virginia | 54001 | 15 | 1 |
293234 | 293234 | 2020-07-01 | Barbour | West Virginia | 54001 | 15 | 1 |
296389 | 296389 | 2020-07-02 | Barbour | West Virginia | 54001 | 15 | 1 |
299551 | 299551 | 2020-07-03 | Barbour | West Virginia | 54001 | 15 | 1 |
302715 | 302715 | 2020-07-04 | Barbour | West Virginia | 54001 | 15 | 1 |
305879 | 305879 | 2020-07-05 | Barbour | West Virginia | 54001 | 16 | 1 |
309047 | 309047 | 2020-07-06 | Barbour | West Virginia | 54001 | 17 | 1 |
312216 | 312216 | 2020-07-07 | Barbour | West Virginia | 54001 | 17 | 1 |
315391 | 315391 | 2020-07-08 | Barbour | West Virginia | 54001 | 17 | 1 |
318564 | 318564 | 2020-07-09 | Barbour | West Virginia | 54001 | 17 | 1 |
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);