ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where cases = 17 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638029 | 638029 | 2020-10-16 | Webster | West Virginia | 54101 | 17 | 0 |
608838 | 608838 | 2020-10-07 | Tyler | West Virginia | 54095 | 17 | 0 |
605595 | 605595 | 2020-10-06 | Tyler | West Virginia | 54095 | 17 | 0 |
602353 | 602353 | 2020-10-05 | Tyler | West Virginia | 54095 | 17 | 0 |
599110 | 599110 | 2020-10-04 | Tyler | West Virginia | 54095 | 17 | 0 |
595867 | 595867 | 2020-10-03 | Tyler | West Virginia | 54095 | 17 | 0 |
579654 | 579654 | 2020-09-28 | Pleasants | West Virginia | 54073 | 17 | 3 |
576413 | 576413 | 2020-09-27 | Pleasants | West Virginia | 54073 | 17 | 3 |
573169 | 573169 | 2020-09-26 | Pleasants | West Virginia | 54073 | 17 | 3 |
569927 | 569927 | 2020-09-25 | Pleasants | West Virginia | 54073 | 17 | 3 |
566696 | 566696 | 2020-09-24 | Tucker | West Virginia | 54093 | 17 | 0 |
563455 | 563455 | 2020-09-23 | Tucker | West Virginia | 54093 | 17 | 0 |
560216 | 560216 | 2020-09-22 | Tucker | West Virginia | 54093 | 17 | 0 |
556970 | 556970 | 2020-09-21 | Pleasants | West Virginia | 54073 | 17 | 2 |
553733 | 553733 | 2020-09-20 | Pleasants | West Virginia | 54073 | 17 | 2 |
547227 | 547227 | 2020-09-18 | Doddridge | West Virginia | 54017 | 17 | 0 |
543990 | 543990 | 2020-09-17 | Doddridge | West Virginia | 54017 | 17 | 0 |
540754 | 540754 | 2020-09-16 | Doddridge | West Virginia | 54017 | 17 | 0 |
537517 | 537517 | 2020-09-15 | Doddridge | West Virginia | 54017 | 17 | 0 |
534281 | 534281 | 2020-09-14 | Doddridge | West Virginia | 54017 | 17 | 0 |
531046 | 531046 | 2020-09-13 | Doddridge | West Virginia | 54017 | 17 | 0 |
527809 | 527809 | 2020-09-12 | Doddridge | West Virginia | 54017 | 17 | 0 |
508397 | 508397 | 2020-09-06 | Calhoun | West Virginia | 54013 | 17 | 0 |
434132 | 434132 | 2020-08-14 | Summers | West Virginia | 54089 | 17 | 0 |
430873 | 430873 | 2020-08-13 | Gilmer | West Virginia | 54021 | 17 | 0 |
427645 | 427645 | 2020-08-12 | Gilmer | West Virginia | 54021 | 17 | 0 |
424421 | 424421 | 2020-08-11 | Gilmer | West Virginia | 54021 | 17 | 0 |
421200 | 421200 | 2020-08-10 | Gilmer | West Virginia | 54021 | 17 | 0 |
398662 | 398662 | 2020-08-03 | Clay | West Virginia | 54015 | 17 | 1 |
395446 | 395446 | 2020-08-02 | Clay | West Virginia | 54015 | 17 | 1 |
392230 | 392230 | 2020-08-01 | Clay | West Virginia | 54015 | 17 | 1 |
389013 | 389013 | 2020-07-31 | Clay | West Virginia | 54015 | 17 | 1 |
385796 | 385796 | 2020-07-30 | Clay | West Virginia | 54015 | 17 | 1 |
382578 | 382578 | 2020-07-29 | Clay | West Virginia | 54015 | 17 | 1 |
379361 | 379361 | 2020-07-28 | Clay | West Virginia | 54015 | 17 | 1 |
379408 | 379408 | 2020-07-28 | Wyoming | West Virginia | 54109 | 17 | 1 |
376145 | 376145 | 2020-07-27 | Clay | West Virginia | 54015 | 17 | 1 |
376164 | 376164 | 2020-07-27 | McDowell | West Virginia | 54047 | 17 | 0 |
376192 | 376192 | 2020-07-27 | Wyoming | West Virginia | 54109 | 17 | 1 |
372931 | 372931 | 2020-07-26 | Clay | West Virginia | 54015 | 17 | 1 |
369719 | 369719 | 2020-07-25 | Clay | West Virginia | 54015 | 17 | 1 |
366510 | 366510 | 2020-07-24 | Clay | West Virginia | 54015 | 17 | 1 |
363303 | 363303 | 2020-07-23 | Clay | West Virginia | 54015 | 17 | 1 |
360097 | 360097 | 2020-07-22 | Clay | West Virginia | 54015 | 17 | 1 |
356892 | 356892 | 2020-07-21 | Clay | West Virginia | 54015 | 17 | 1 |
356915 | 356915 | 2020-07-21 | Monroe | West Virginia | 54063 | 17 | 0 |
353689 | 353689 | 2020-07-20 | Clay | West Virginia | 54015 | 17 | 1 |
353712 | 353712 | 2020-07-20 | Monroe | West Virginia | 54063 | 17 | 0 |
350510 | 350510 | 2020-07-19 | Monroe | West Virginia | 54063 | 17 | 0 |
347309 | 347309 | 2020-07-18 | Monroe | West Virginia | 54063 | 17 | 0 |
334523 | 334523 | 2020-07-14 | Pendleton | West Virginia | 54071 | 17 | 1 |
318564 | 318564 | 2020-07-09 | Barbour | West Virginia | 54001 | 17 | 1 |
315391 | 315391 | 2020-07-08 | Barbour | West Virginia | 54001 | 17 | 1 |
312216 | 312216 | 2020-07-07 | Barbour | West Virginia | 54001 | 17 | 1 |
309047 | 309047 | 2020-07-06 | Barbour | West Virginia | 54001 | 17 | 1 |
309091 | 309091 | 2020-07-06 | Taylor | West Virginia | 54091 | 17 | 0 |
305923 | 305923 | 2020-07-05 | Taylor | West Virginia | 54091 | 17 | 0 |
299595 | 299595 | 2020-07-03 | Taylor | West Virginia | 54091 | 17 | 0 |
286950 | 286950 | 2020-06-29 | Lewis | West Virginia | 54041 | 17 | 2 |
286955 | 286955 | 2020-06-29 | Mason | West Virginia | 54053 | 17 | 0 |
283804 | 283804 | 2020-06-28 | Lewis | West Virginia | 54041 | 17 | 2 |
283813 | 283813 | 2020-06-28 | Mingo | West Virginia | 54059 | 17 | 2 |
280667 | 280667 | 2020-06-27 | Mingo | West Virginia | 54059 | 17 | 2 |
239989 | 239989 | 2020-06-14 | Boone | West Virginia | 54005 | 17 | 0 |
236881 | 236881 | 2020-06-13 | Boone | West Virginia | 54005 | 17 | 0 |
233774 | 233774 | 2020-06-12 | Boone | West Virginia | 54005 | 17 | 0 |
230669 | 230669 | 2020-06-11 | Boone | West Virginia | 54005 | 17 | 0 |
215224 | 215224 | 2020-06-06 | Raleigh | West Virginia | 54081 | 17 | 0 |
212137 | 212137 | 2020-06-05 | Raleigh | West Virginia | 54081 | 17 | 0 |
209052 | 209052 | 2020-06-04 | Raleigh | West Virginia | 54081 | 17 | 0 |
205970 | 205970 | 2020-06-03 | Raleigh | West Virginia | 54081 | 17 | 0 |
202873 | 202873 | 2020-06-02 | Logan | West Virginia | 54045 | 17 | 1 |
199797 | 199797 | 2020-06-01 | Logan | West Virginia | 54045 | 17 | 1 |
196724 | 196724 | 2020-05-31 | Logan | West Virginia | 54045 | 17 | 1 |
193654 | 193654 | 2020-05-30 | Logan | West Virginia | 54045 | 17 | 1 |
190588 | 190588 | 2020-05-29 | Logan | West Virginia | 54045 | 17 | 1 |
187516 | 187516 | 2020-05-28 | Hancock | West Virginia | 54029 | 17 | 0 |
187524 | 187524 | 2020-05-28 | Logan | West Virginia | 54045 | 17 | 1 |
184459 | 184459 | 2020-05-27 | Hancock | West Virginia | 54029 | 17 | 0 |
184482 | 184482 | 2020-05-27 | Pocahontas | West Virginia | 54075 | 17 | 0 |
175318 | 175318 | 2020-05-24 | Hampshire | West Virginia | 54027 | 17 | 1 |
175337 | 175337 | 2020-05-24 | Morgan | West Virginia | 54065 | 17 | 0 |
172294 | 172294 | 2020-05-23 | Morgan | West Virginia | 54065 | 17 | 0 |
169235 | 169235 | 2020-05-22 | Hancock | West Virginia | 54029 | 17 | 0 |
169253 | 169253 | 2020-05-22 | Morgan | West Virginia | 54065 | 17 | 0 |
166217 | 166217 | 2020-05-21 | Morgan | West Virginia | 54065 | 17 | 0 |
163188 | 163188 | 2020-05-20 | Morgan | West Virginia | 54065 | 17 | 0 |
160160 | 160160 | 2020-05-19 | Morgan | West Virginia | 54065 | 17 | 0 |
157136 | 157136 | 2020-05-18 | Morgan | West Virginia | 54065 | 17 | 0 |
154119 | 154119 | 2020-05-17 | Morgan | West Virginia | 54065 | 17 | 0 |
151108 | 151108 | 2020-05-16 | Morgan | West Virginia | 54065 | 17 | 0 |
148099 | 148099 | 2020-05-15 | Morgan | West Virginia | 54065 | 17 | 0 |
145096 | 145096 | 2020-05-14 | Morgan | West Virginia | 54065 | 17 | 0 |
142099 | 142099 | 2020-05-13 | Morgan | West Virginia | 54065 | 17 | 0 |
139086 | 139086 | 2020-05-12 | Hardy | West Virginia | 54031 | 17 | 0 |
139103 | 139103 | 2020-05-12 | Morgan | West Virginia | 54065 | 17 | 0 |
136095 | 136095 | 2020-05-11 | Hardy | West Virginia | 54031 | 17 | 0 |
136112 | 136112 | 2020-05-11 | Morgan | West Virginia | 54065 | 17 | 0 |
124157 | 124157 | 2020-05-07 | Morgan | West Virginia | 54065 | 17 | 0 |
103759 | 103759 | 2020-04-30 | Mineral | West Virginia | 54057 | 17 | 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);