ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where cases = 54 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 |
---|---|---|---|---|---|---|---|
767808 | 767808 | 2020-11-25 | Webster | West Virginia | 54101 | 54 | 0 |
764563 | 764563 | 2020-11-24 | Webster | West Virginia | 54101 | 54 | 0 |
728845 | 728845 | 2020-11-13 | Pleasants | West Virginia | 54073 | 54 | 3 |
628255 | 628255 | 2020-10-13 | Gilmer | West Virginia | 54021 | 54 | 0 |
612068 | 612068 | 2020-10-08 | Pendleton | West Virginia | 54071 | 54 | 1 |
608826 | 608826 | 2020-10-07 | Pendleton | West Virginia | 54071 | 54 | 1 |
576421 | 576421 | 2020-09-27 | Summers | West Virginia | 54089 | 54 | 0 |
573177 | 573177 | 2020-09-26 | Summers | West Virginia | 54089 | 54 | 0 |
573184 | 573184 | 2020-09-26 | Wetzel | West Virginia | 54103 | 54 | 0 |
414773 | 414773 | 2020-08-08 | Mason | West Virginia | 54053 | 54 | 1 |
411553 | 411553 | 2020-08-07 | Mason | West Virginia | 54053 | 54 | 1 |
405104 | 405104 | 2020-08-05 | Hardy | West Virginia | 54031 | 54 | 0 |
401886 | 401886 | 2020-08-04 | Hardy | West Virginia | 54031 | 54 | 0 |
398670 | 398670 | 2020-08-03 | Hardy | West Virginia | 54031 | 54 | 0 |
395454 | 395454 | 2020-08-02 | Hardy | West Virginia | 54031 | 54 | 0 |
392238 | 392238 | 2020-08-01 | Hardy | West Virginia | 54031 | 54 | 0 |
389021 | 389021 | 2020-07-31 | Hardy | West Virginia | 54031 | 54 | 0 |
385793 | 385793 | 2020-07-30 | Brooke | West Virginia | 54009 | 54 | 1 |
385804 | 385804 | 2020-07-30 | Hardy | West Virginia | 54031 | 54 | 0 |
382575 | 382575 | 2020-07-29 | Brooke | West Virginia | 54009 | 54 | 1 |
379375 | 379375 | 2020-07-28 | Lincoln | West Virginia | 54043 | 54 | 0 |
363308 | 363308 | 2020-07-23 | Hampshire | West Virginia | 54027 | 54 | 1 |
347292 | 347292 | 2020-07-18 | Hancock | West Virginia | 54029 | 54 | 0 |
344092 | 344092 | 2020-07-17 | Hancock | West Virginia | 54029 | 54 | 0 |
296428 | 296428 | 2020-07-02 | Raleigh | West Virginia | 54081 | 54 | 0 |
277518 | 277518 | 2020-06-26 | Mineral | West Virginia | 54057 | 54 | 3 |
274370 | 274370 | 2020-06-25 | Mineral | West Virginia | 54057 | 54 | 3 |
271225 | 271225 | 2020-06-24 | Marion | West Virginia | 54049 | 54 | 2 |
271230 | 271230 | 2020-06-24 | Mineral | West Virginia | 54057 | 54 | 3 |
268096 | 268096 | 2020-06-23 | Mineral | West Virginia | 54057 | 54 | 3 |
249331 | 249331 | 2020-06-17 | Fayette | West Virginia | 54019 | 54 | 4 |
246219 | 246219 | 2020-06-16 | Fayette | West Virginia | 54019 | 54 | 4 |
243106 | 243106 | 2020-06-15 | Fayette | West Virginia | 54019 | 54 | 4 |
239995 | 239995 | 2020-06-14 | Fayette | West Virginia | 54019 | 54 | 4 |
240009 | 240009 | 2020-06-14 | Marion | West Virginia | 54049 | 54 | 2 |
236887 | 236887 | 2020-06-13 | Fayette | West Virginia | 54019 | 54 | 4 |
236901 | 236901 | 2020-06-13 | Marion | West Virginia | 54049 | 54 | 2 |
236912 | 236912 | 2020-06-13 | Ohio | West Virginia | 54069 | 54 | 1 |
233780 | 233780 | 2020-06-12 | Fayette | West Virginia | 54019 | 54 | 4 |
230675 | 230675 | 2020-06-11 | Fayette | West Virginia | 54019 | 54 | 4 |
227571 | 227571 | 2020-06-10 | Fayette | West Virginia | 54019 | 54 | 4 |
227614 | 227614 | 2020-06-10 | Wood | West Virginia | 54107 | 54 | 2 |
224471 | 224471 | 2020-06-09 | Fayette | West Virginia | 54019 | 54 | 4 |
224514 | 224514 | 2020-06-09 | Wood | West Virginia | 54107 | 54 | 2 |
221375 | 221375 | 2020-06-08 | Fayette | West Virginia | 54019 | 54 | 4 |
218283 | 218283 | 2020-06-07 | Fayette | West Virginia | 54019 | 54 | 4 |
218326 | 218326 | 2020-06-07 | Wood | West Virginia | 54107 | 54 | 2 |
215193 | 215193 | 2020-06-06 | Fayette | West Virginia | 54019 | 54 | 4 |
215236 | 215236 | 2020-06-06 | Wood | West Virginia | 54107 | 54 | 2 |
212106 | 212106 | 2020-06-05 | Fayette | West Virginia | 54019 | 54 | 4 |
187554 | 187554 | 2020-05-28 | Wood | West Virginia | 54107 | 54 | 2 |
184497 | 184497 | 2020-05-27 | Wood | West Virginia | 54107 | 54 | 2 |
59045 | 59045 | 2020-04-14 | Jefferson | West Virginia | 54037 | 54 | 0 |
37975 | 37975 | 2020-04-06 | Berkeley | West Virginia | 54003 | 54 | 0 |
35491 | 35491 | 2020-04-05 | Berkeley | West Virginia | 54003 | 54 | 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);