ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 27 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 |
---|---|---|---|---|---|---|---|
673708 | 673708 | 2020-10-27 | Pleasants | West Virginia | 54073 | 27 | 3 |
647762 | 647762 | 2020-10-19 | Ritchie | West Virginia | 54085 | 27 | 0 |
602312 | 602312 | 2020-10-05 | Calhoun | West Virginia | 54013 | 27 | 0 |
599069 | 599069 | 2020-10-04 | Calhoun | West Virginia | 54013 | 27 | 0 |
595826 | 595826 | 2020-10-03 | Calhoun | West Virginia | 54013 | 27 | 0 |
592584 | 592584 | 2020-10-02 | Calhoun | West Virginia | 54013 | 27 | 0 |
586105 | 586105 | 2020-09-30 | Doddridge | West Virginia | 54017 | 27 | 1 |
553707 | 553707 | 2020-09-20 | Gilmer | West Virginia | 54021 | 27 | 0 |
501932 | 501932 | 2020-09-04 | Clay | West Virginia | 54015 | 27 | 2 |
498698 | 498698 | 2020-09-03 | Clay | West Virginia | 54015 | 27 | 2 |
495465 | 495465 | 2020-09-02 | Clay | West Virginia | 54015 | 27 | 2 |
492231 | 492231 | 2020-09-01 | Clay | West Virginia | 54015 | 27 | 2 |
488998 | 488998 | 2020-08-31 | Clay | West Virginia | 54015 | 27 | 2 |
453480 | 453480 | 2020-08-20 | Monroe | West Virginia | 54063 | 27 | 0 |
401891 | 401891 | 2020-08-04 | Lewis | West Virginia | 54041 | 27 | 2 |
398675 | 398675 | 2020-08-03 | Lewis | West Virginia | 54041 | 27 | 2 |
395459 | 395459 | 2020-08-02 | Lewis | West Virginia | 54041 | 27 | 2 |
379387 | 379387 | 2020-07-28 | Nicholas | West Virginia | 54067 | 27 | 1 |
376171 | 376171 | 2020-07-27 | Nicholas | West Virginia | 54067 | 27 | 1 |
363296 | 363296 | 2020-07-23 | Barbour | West Virginia | 54001 | 27 | 1 |
360090 | 360090 | 2020-07-22 | Barbour | West Virginia | 54001 | 27 | 1 |
350504 | 350504 | 2020-07-19 | Mason | West Virginia | 54053 | 27 | 0 |
347303 | 347303 | 2020-07-18 | Mason | West Virginia | 54053 | 27 | 0 |
344123 | 344123 | 2020-07-17 | Taylor | West Virginia | 54091 | 27 | 0 |
340924 | 340924 | 2020-07-16 | Taylor | West Virginia | 54091 | 27 | 0 |
328114 | 328114 | 2020-07-12 | Brooke | West Virginia | 54009 | 27 | 0 |
318592 | 318592 | 2020-07-09 | Mingo | West Virginia | 54059 | 27 | 2 |
315393 | 315393 | 2020-07-08 | Boone | West Virginia | 54005 | 27 | 0 |
271229 | 271229 | 2020-06-24 | Mercer | West Virginia | 54055 | 27 | 0 |
252477 | 252477 | 2020-06-18 | Raleigh | West Virginia | 54081 | 27 | 0 |
249362 | 249362 | 2020-06-17 | Raleigh | West Virginia | 54081 | 27 | 0 |
178374 | 178374 | 2020-05-25 | Marshall | West Virginia | 54051 | 27 | 0 |
175329 | 175329 | 2020-05-24 | Marshall | West Virginia | 54051 | 27 | 0 |
172286 | 172286 | 2020-05-23 | Marshall | West Virginia | 54051 | 27 | 0 |
169245 | 169245 | 2020-05-22 | Marshall | West Virginia | 54051 | 27 | 0 |
166209 | 166209 | 2020-05-21 | Marshall | West Virginia | 54051 | 27 | 0 |
151104 | 151104 | 2020-05-16 | Mineral | West Virginia | 54057 | 27 | 0 |
133129 | 133129 | 2020-05-10 | Putnam | West Virginia | 54079 | 27 | 0 |
130139 | 130139 | 2020-05-09 | Putnam | West Virginia | 54079 | 27 | 0 |
127149 | 127149 | 2020-05-08 | Putnam | West Virginia | 54079 | 27 | 0 |
124134 | 124134 | 2020-05-07 | Fayette | West Virginia | 54019 | 27 | 0 |
124164 | 124164 | 2020-05-07 | Putnam | West Virginia | 54079 | 27 | 0 |
121154 | 121154 | 2020-05-06 | Fayette | West Virginia | 54019 | 27 | 0 |
121184 | 121184 | 2020-05-06 | Putnam | West Virginia | 54079 | 27 | 0 |
118219 | 118219 | 2020-05-05 | Putnam | West Virginia | 54079 | 27 | 0 |
109503 | 109503 | 2020-05-02 | Putnam | West Virginia | 54079 | 27 | 0 |
106634 | 106634 | 2020-05-01 | Putnam | West Virginia | 54079 | 27 | 1 |
103765 | 103765 | 2020-04-30 | Ohio | West Virginia | 54069 | 27 | 1 |
100910 | 100910 | 2020-04-29 | Ohio | West Virginia | 54069 | 27 | 1 |
64529 | 64529 | 2020-04-16 | Wood | West Virginia | 54107 | 27 | 0 |
53648 | 53648 | 2020-04-12 | Jackson | West Virginia | 54035 | 27 | 1 |
28299 | 28299 | 2020-04-02 | Berkeley | West Virginia | 54003 | 27 | 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);