ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
400 rows where cases = 1 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Summers 75
- Ritchie 38
- Wyoming 38
- Pleasants 24
- Grant 22
- Calhoun 21
- Braxton 17
- Pendleton 17
- Lincoln 16
- Upshur 13
- Wirt 13
- Webster 11
- Boone 8
- Morgan 7
- Logan 5
- Monroe 5
- Preston 5
- Cabell 4
- Fayette 4
- Jackson 4
- Lewis 4
- Mingo 4
- Putnam 4
- Barbour 3
- Jefferson 3
- Mercer 3
- Monongalia 3
- Randolph 3
- Wetzel 3
- Brooke 2
- …
state 1
- West Virginia · 400 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1702801 | 1702801 | 2021-09-09 | Unknown | West Virginia | 1 | 0 | |
369720 | 369720 | 2020-07-25 | Doddridge | West Virginia | 54017 | 1 | 0 |
340929 | 340929 | 2020-07-16 | Webster | West Virginia | 54101 | 1 | 0 |
337733 | 337733 | 2020-07-15 | Webster | West Virginia | 54101 | 1 | 0 |
334538 | 334538 | 2020-07-14 | Webster | West Virginia | 54101 | 1 | 0 |
331345 | 331345 | 2020-07-13 | Webster | West Virginia | 54101 | 1 | 0 |
328159 | 328159 | 2020-07-12 | Webster | West Virginia | 54101 | 1 | 0 |
324973 | 324973 | 2020-07-11 | Webster | West Virginia | 54101 | 1 | 0 |
321792 | 321792 | 2020-07-10 | Webster | West Virginia | 54101 | 1 | 0 |
318613 | 318613 | 2020-07-09 | Webster | West Virginia | 54101 | 1 | 0 |
315440 | 315440 | 2020-07-08 | Webster | West Virginia | 54101 | 1 | 0 |
312265 | 312265 | 2020-07-07 | Webster | West Virginia | 54101 | 1 | 0 |
309096 | 309096 | 2020-07-06 | Webster | West Virginia | 54101 | 1 | 0 |
280682 | 280682 | 2020-06-27 | Summers | West Virginia | 54089 | 1 | 0 |
277534 | 277534 | 2020-06-26 | Summers | West Virginia | 54089 | 1 | 0 |
274386 | 274386 | 2020-06-25 | Summers | West Virginia | 54089 | 1 | 0 |
271246 | 271246 | 2020-06-24 | Summers | West Virginia | 54089 | 1 | 0 |
268112 | 268112 | 2020-06-23 | Summers | West Virginia | 54089 | 1 | 0 |
264983 | 264983 | 2020-06-22 | Summers | West Virginia | 54089 | 1 | 0 |
261854 | 261854 | 2020-06-21 | Summers | West Virginia | 54089 | 1 | 0 |
258727 | 258727 | 2020-06-20 | Summers | West Virginia | 54089 | 1 | 0 |
255600 | 255600 | 2020-06-19 | Summers | West Virginia | 54089 | 1 | 0 |
252481 | 252481 | 2020-06-18 | Summers | West Virginia | 54089 | 1 | 0 |
249366 | 249366 | 2020-06-17 | Summers | West Virginia | 54089 | 1 | 0 |
246254 | 246254 | 2020-06-16 | Summers | West Virginia | 54089 | 1 | 0 |
243141 | 243141 | 2020-06-15 | Summers | West Virginia | 54089 | 1 | 0 |
240030 | 240030 | 2020-06-14 | Summers | West Virginia | 54089 | 1 | 0 |
236922 | 236922 | 2020-06-13 | Summers | West Virginia | 54089 | 1 | 0 |
233815 | 233815 | 2020-06-12 | Summers | West Virginia | 54089 | 1 | 0 |
230710 | 230710 | 2020-06-11 | Summers | West Virginia | 54089 | 1 | 0 |
227606 | 227606 | 2020-06-10 | Summers | West Virginia | 54089 | 1 | 0 |
224504 | 224504 | 2020-06-09 | Ritchie | West Virginia | 54085 | 1 | 0 |
224506 | 224506 | 2020-06-09 | Summers | West Virginia | 54089 | 1 | 0 |
221408 | 221408 | 2020-06-08 | Ritchie | West Virginia | 54085 | 1 | 0 |
221410 | 221410 | 2020-06-08 | Summers | West Virginia | 54089 | 1 | 0 |
218316 | 218316 | 2020-06-07 | Ritchie | West Virginia | 54085 | 1 | 0 |
218318 | 218318 | 2020-06-07 | Summers | West Virginia | 54089 | 1 | 0 |
215226 | 215226 | 2020-06-06 | Ritchie | West Virginia | 54085 | 1 | 0 |
215228 | 215228 | 2020-06-06 | Summers | West Virginia | 54089 | 1 | 0 |
212139 | 212139 | 2020-06-05 | Ritchie | West Virginia | 54085 | 1 | 0 |
212141 | 212141 | 2020-06-05 | Summers | West Virginia | 54089 | 1 | 0 |
209054 | 209054 | 2020-06-04 | Ritchie | West Virginia | 54085 | 1 | 0 |
209056 | 209056 | 2020-06-04 | Summers | West Virginia | 54089 | 1 | 0 |
205972 | 205972 | 2020-06-03 | Ritchie | West Virginia | 54085 | 1 | 0 |
205974 | 205974 | 2020-06-03 | Summers | West Virginia | 54089 | 1 | 0 |
202893 | 202893 | 2020-06-02 | Ritchie | West Virginia | 54085 | 1 | 0 |
202895 | 202895 | 2020-06-02 | Summers | West Virginia | 54089 | 1 | 0 |
199817 | 199817 | 2020-06-01 | Ritchie | West Virginia | 54085 | 1 | 0 |
199819 | 199819 | 2020-06-01 | Summers | West Virginia | 54089 | 1 | 0 |
196744 | 196744 | 2020-05-31 | Ritchie | West Virginia | 54085 | 1 | 0 |
196746 | 196746 | 2020-05-31 | Summers | West Virginia | 54089 | 1 | 0 |
193674 | 193674 | 2020-05-30 | Ritchie | West Virginia | 54085 | 1 | 0 |
193676 | 193676 | 2020-05-30 | Summers | West Virginia | 54089 | 1 | 0 |
190608 | 190608 | 2020-05-29 | Ritchie | West Virginia | 54085 | 1 | 0 |
190610 | 190610 | 2020-05-29 | Summers | West Virginia | 54089 | 1 | 0 |
187544 | 187544 | 2020-05-28 | Ritchie | West Virginia | 54085 | 1 | 0 |
187546 | 187546 | 2020-05-28 | Summers | West Virginia | 54089 | 1 | 0 |
184487 | 184487 | 2020-05-27 | Ritchie | West Virginia | 54085 | 1 | 0 |
184489 | 184489 | 2020-05-27 | Summers | West Virginia | 54089 | 1 | 0 |
181436 | 181436 | 2020-05-26 | Ritchie | West Virginia | 54085 | 1 | 0 |
181438 | 181438 | 2020-05-26 | Summers | West Virginia | 54089 | 1 | 0 |
178392 | 178392 | 2020-05-25 | Ritchie | West Virginia | 54085 | 1 | 0 |
178394 | 178394 | 2020-05-25 | Summers | West Virginia | 54089 | 1 | 0 |
175347 | 175347 | 2020-05-24 | Ritchie | West Virginia | 54085 | 1 | 0 |
172304 | 172304 | 2020-05-23 | Ritchie | West Virginia | 54085 | 1 | 0 |
169263 | 169263 | 2020-05-22 | Ritchie | West Virginia | 54085 | 1 | 0 |
166227 | 166227 | 2020-05-21 | Ritchie | West Virginia | 54085 | 1 | 0 |
166229 | 166229 | 2020-05-21 | Summers | West Virginia | 54089 | 1 | 0 |
163198 | 163198 | 2020-05-20 | Ritchie | West Virginia | 54085 | 1 | 0 |
163200 | 163200 | 2020-05-20 | Summers | West Virginia | 54089 | 1 | 0 |
160170 | 160170 | 2020-05-19 | Ritchie | West Virginia | 54085 | 1 | 0 |
160172 | 160172 | 2020-05-19 | Summers | West Virginia | 54089 | 1 | 0 |
157146 | 157146 | 2020-05-18 | Ritchie | West Virginia | 54085 | 1 | 0 |
157148 | 157148 | 2020-05-18 | Summers | West Virginia | 54089 | 1 | 0 |
154129 | 154129 | 2020-05-17 | Ritchie | West Virginia | 54085 | 1 | 0 |
154131 | 154131 | 2020-05-17 | Summers | West Virginia | 54089 | 1 | 0 |
151083 | 151083 | 2020-05-16 | Calhoun | West Virginia | 54013 | 1 | 0 |
151118 | 151118 | 2020-05-16 | Ritchie | West Virginia | 54085 | 1 | 0 |
151120 | 151120 | 2020-05-16 | Summers | West Virginia | 54089 | 1 | 0 |
148074 | 148074 | 2020-05-15 | Calhoun | West Virginia | 54013 | 1 | 0 |
148109 | 148109 | 2020-05-15 | Ritchie | West Virginia | 54085 | 1 | 0 |
148111 | 148111 | 2020-05-15 | Summers | West Virginia | 54089 | 1 | 0 |
145071 | 145071 | 2020-05-14 | Calhoun | West Virginia | 54013 | 1 | 0 |
145106 | 145106 | 2020-05-14 | Ritchie | West Virginia | 54085 | 1 | 0 |
145108 | 145108 | 2020-05-14 | Summers | West Virginia | 54089 | 1 | 0 |
145117 | 145117 | 2020-05-14 | Wyoming | West Virginia | 54109 | 1 | 0 |
142074 | 142074 | 2020-05-13 | Calhoun | West Virginia | 54013 | 1 | 0 |
142109 | 142109 | 2020-05-13 | Ritchie | West Virginia | 54085 | 1 | 0 |
142111 | 142111 | 2020-05-13 | Summers | West Virginia | 54089 | 1 | 0 |
142120 | 142120 | 2020-05-13 | Wyoming | West Virginia | 54109 | 1 | 0 |
139078 | 139078 | 2020-05-12 | Calhoun | West Virginia | 54013 | 1 | 0 |
139113 | 139113 | 2020-05-12 | Ritchie | West Virginia | 54085 | 1 | 0 |
139115 | 139115 | 2020-05-12 | Summers | West Virginia | 54089 | 1 | 0 |
139124 | 139124 | 2020-05-12 | Wyoming | West Virginia | 54109 | 1 | 0 |
136087 | 136087 | 2020-05-11 | Calhoun | West Virginia | 54013 | 1 | 0 |
136122 | 136122 | 2020-05-11 | Ritchie | West Virginia | 54085 | 1 | 0 |
136124 | 136124 | 2020-05-11 | Summers | West Virginia | 54089 | 1 | 0 |
136133 | 136133 | 2020-05-11 | Wyoming | West Virginia | 54109 | 1 | 0 |
133097 | 133097 | 2020-05-10 | Calhoun | West Virginia | 54013 | 1 | 0 |
133132 | 133132 | 2020-05-10 | Ritchie | West Virginia | 54085 | 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);