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 fips descending
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 | |
154135 | 154135 | 2020-05-17 | Unknown | West Virginia | 2 | 0 | |
1683306 | 1683306 | 2021-09-03 | Unknown | West Virginia | 2 | 0 | |
1702801 | 1702801 | 2021-09-09 | Unknown | West Virginia | 1 | 0 | |
40547 | 40547 | 2020-04-07 | Wyoming | West Virginia | 54109 | 1 | 0 |
43119 | 43119 | 2020-04-08 | Wyoming | West Virginia | 54109 | 1 | 0 |
45716 | 45716 | 2020-04-09 | Wyoming | West Virginia | 54109 | 1 | 0 |
48344 | 48344 | 2020-04-10 | Wyoming | West Virginia | 54109 | 1 | 0 |
51004 | 51004 | 2020-04-11 | Wyoming | West Virginia | 54109 | 1 | 0 |
53681 | 53681 | 2020-04-12 | Wyoming | West Virginia | 54109 | 1 | 0 |
56371 | 56371 | 2020-04-13 | Wyoming | West Virginia | 54109 | 1 | 0 |
59078 | 59078 | 2020-04-14 | Wyoming | West Virginia | 54109 | 1 | 0 |
61797 | 61797 | 2020-04-15 | Wyoming | West Virginia | 54109 | 1 | 0 |
64530 | 64530 | 2020-04-16 | Wyoming | West Virginia | 54109 | 1 | 0 |
67278 | 67278 | 2020-04-17 | Wyoming | West Virginia | 54109 | 1 | 0 |
70040 | 70040 | 2020-04-18 | Wyoming | West Virginia | 54109 | 1 | 0 |
72809 | 72809 | 2020-04-19 | Wyoming | West Virginia | 54109 | 1 | 0 |
75585 | 75585 | 2020-04-20 | Wyoming | West Virginia | 54109 | 1 | 0 |
78368 | 78368 | 2020-04-21 | Wyoming | West Virginia | 54109 | 1 | 0 |
81161 | 81161 | 2020-04-22 | Wyoming | West Virginia | 54109 | 1 | 0 |
83962 | 83962 | 2020-04-23 | Wyoming | West Virginia | 54109 | 1 | 0 |
86769 | 86769 | 2020-04-24 | Wyoming | West Virginia | 54109 | 1 | 0 |
89585 | 89585 | 2020-04-25 | Wyoming | West Virginia | 54109 | 1 | 0 |
92403 | 92403 | 2020-04-26 | Wyoming | West Virginia | 54109 | 1 | 0 |
95233 | 95233 | 2020-04-27 | Wyoming | West Virginia | 54109 | 1 | 0 |
98078 | 98078 | 2020-04-28 | Wyoming | West Virginia | 54109 | 1 | 0 |
100928 | 100928 | 2020-04-29 | Wyoming | West Virginia | 54109 | 1 | 0 |
103783 | 103783 | 2020-04-30 | Wyoming | West Virginia | 54109 | 1 | 0 |
106647 | 106647 | 2020-05-01 | Wyoming | West Virginia | 54109 | 1 | 0 |
109516 | 109516 | 2020-05-02 | Wyoming | West Virginia | 54109 | 1 | 0 |
112391 | 112391 | 2020-05-03 | Wyoming | West Virginia | 54109 | 1 | 0 |
115274 | 115274 | 2020-05-04 | Wyoming | West Virginia | 54109 | 1 | 0 |
118233 | 118233 | 2020-05-05 | Wyoming | West Virginia | 54109 | 1 | 0 |
121198 | 121198 | 2020-05-06 | Wyoming | West Virginia | 54109 | 1 | 0 |
124178 | 124178 | 2020-05-07 | Wyoming | West Virginia | 54109 | 1 | 0 |
127163 | 127163 | 2020-05-08 | Wyoming | West Virginia | 54109 | 1 | 0 |
130153 | 130153 | 2020-05-09 | Wyoming | West Virginia | 54109 | 1 | 0 |
133143 | 133143 | 2020-05-10 | Wyoming | West Virginia | 54109 | 1 | 0 |
136133 | 136133 | 2020-05-11 | Wyoming | West Virginia | 54109 | 1 | 0 |
139124 | 139124 | 2020-05-12 | Wyoming | West Virginia | 54109 | 1 | 0 |
142120 | 142120 | 2020-05-13 | Wyoming | West Virginia | 54109 | 1 | 0 |
145117 | 145117 | 2020-05-14 | Wyoming | West Virginia | 54109 | 1 | 0 |
148120 | 148120 | 2020-05-15 | Wyoming | West Virginia | 54109 | 2 | 0 |
151129 | 151129 | 2020-05-16 | Wyoming | West Virginia | 54109 | 2 | 0 |
154141 | 154141 | 2020-05-17 | Wyoming | West Virginia | 54109 | 2 | 0 |
157157 | 157157 | 2020-05-18 | Wyoming | West Virginia | 54109 | 3 | 0 |
160181 | 160181 | 2020-05-19 | Wyoming | West Virginia | 54109 | 3 | 0 |
163209 | 163209 | 2020-05-20 | Wyoming | West Virginia | 54109 | 3 | 0 |
166238 | 166238 | 2020-05-21 | Wyoming | West Virginia | 54109 | 3 | 0 |
169274 | 169274 | 2020-05-22 | Wyoming | West Virginia | 54109 | 3 | 0 |
172315 | 172315 | 2020-05-23 | Wyoming | West Virginia | 54109 | 3 | 0 |
175358 | 175358 | 2020-05-24 | Wyoming | West Virginia | 54109 | 3 | 0 |
178403 | 178403 | 2020-05-25 | Wyoming | West Virginia | 54109 | 3 | 0 |
181447 | 181447 | 2020-05-26 | Wyoming | West Virginia | 54109 | 3 | 0 |
184498 | 184498 | 2020-05-27 | Wyoming | West Virginia | 54109 | 3 | 0 |
187555 | 187555 | 2020-05-28 | Wyoming | West Virginia | 54109 | 3 | 0 |
190619 | 190619 | 2020-05-29 | Wyoming | West Virginia | 54109 | 3 | 0 |
193685 | 193685 | 2020-05-30 | Wyoming | West Virginia | 54109 | 3 | 0 |
196755 | 196755 | 2020-05-31 | Wyoming | West Virginia | 54109 | 3 | 0 |
199828 | 199828 | 2020-06-01 | Wyoming | West Virginia | 54109 | 3 | 0 |
202904 | 202904 | 2020-06-02 | Wyoming | West Virginia | 54109 | 2 | 0 |
205983 | 205983 | 2020-06-03 | Wyoming | West Virginia | 54109 | 2 | 0 |
209065 | 209065 | 2020-06-04 | Wyoming | West Virginia | 54109 | 2 | 0 |
212150 | 212150 | 2020-06-05 | Wyoming | West Virginia | 54109 | 2 | 0 |
215237 | 215237 | 2020-06-06 | Wyoming | West Virginia | 54109 | 2 | 0 |
218327 | 218327 | 2020-06-07 | Wyoming | West Virginia | 54109 | 3 | 0 |
221419 | 221419 | 2020-06-08 | Wyoming | West Virginia | 54109 | 3 | 0 |
224515 | 224515 | 2020-06-09 | Wyoming | West Virginia | 54109 | 3 | 0 |
227615 | 227615 | 2020-06-10 | Wyoming | West Virginia | 54109 | 3 | 0 |
230719 | 230719 | 2020-06-11 | Wyoming | West Virginia | 54109 | 5 | 0 |
233824 | 233824 | 2020-06-12 | Wyoming | West Virginia | 54109 | 5 | 0 |
236931 | 236931 | 2020-06-13 | Wyoming | West Virginia | 54109 | 5 | 0 |
240039 | 240039 | 2020-06-14 | Wyoming | West Virginia | 54109 | 5 | 0 |
243150 | 243150 | 2020-06-15 | Wyoming | West Virginia | 54109 | 5 | 0 |
246263 | 246263 | 2020-06-16 | Wyoming | West Virginia | 54109 | 5 | 0 |
249375 | 249375 | 2020-06-17 | Wyoming | West Virginia | 54109 | 5 | 0 |
252490 | 252490 | 2020-06-18 | Wyoming | West Virginia | 54109 | 6 | 0 |
255609 | 255609 | 2020-06-19 | Wyoming | West Virginia | 54109 | 7 | 0 |
258736 | 258736 | 2020-06-20 | Wyoming | West Virginia | 54109 | 7 | 0 |
261863 | 261863 | 2020-06-21 | Wyoming | West Virginia | 54109 | 7 | 0 |
264992 | 264992 | 2020-06-22 | Wyoming | West Virginia | 54109 | 7 | 0 |
268121 | 268121 | 2020-06-23 | Wyoming | West Virginia | 54109 | 7 | 0 |
271255 | 271255 | 2020-06-24 | Wyoming | West Virginia | 54109 | 7 | 0 |
274395 | 274395 | 2020-06-25 | Wyoming | West Virginia | 54109 | 7 | 0 |
277543 | 277543 | 2020-06-26 | Wyoming | West Virginia | 54109 | 7 | 0 |
280691 | 280691 | 2020-06-27 | Wyoming | West Virginia | 54109 | 7 | 0 |
283837 | 283837 | 2020-06-28 | Wyoming | West Virginia | 54109 | 7 | 0 |
286983 | 286983 | 2020-06-29 | Wyoming | West Virginia | 54109 | 7 | 0 |
290133 | 290133 | 2020-06-30 | Wyoming | West Virginia | 54109 | 7 | 0 |
293286 | 293286 | 2020-07-01 | Wyoming | West Virginia | 54109 | 7 | 0 |
296441 | 296441 | 2020-07-02 | Wyoming | West Virginia | 54109 | 7 | 0 |
299603 | 299603 | 2020-07-03 | Wyoming | West Virginia | 54109 | 7 | 0 |
302767 | 302767 | 2020-07-04 | Wyoming | West Virginia | 54109 | 7 | 0 |
305931 | 305931 | 2020-07-05 | Wyoming | West Virginia | 54109 | 7 | 0 |
309100 | 309100 | 2020-07-06 | Wyoming | West Virginia | 54109 | 7 | 0 |
312269 | 312269 | 2020-07-07 | Wyoming | West Virginia | 54109 | 7 | 0 |
315444 | 315444 | 2020-07-08 | Wyoming | West Virginia | 54109 | 7 | 0 |
318617 | 318617 | 2020-07-09 | Wyoming | West Virginia | 54109 | 7 | 0 |
321796 | 321796 | 2020-07-10 | Wyoming | West Virginia | 54109 | 7 | 0 |
324977 | 324977 | 2020-07-11 | Wyoming | West Virginia | 54109 | 7 | 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);