ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 49 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 |
---|---|---|---|---|---|---|---|
748290 | 748290 | 2020-11-19 | Calhoun | West Virginia | 54013 | 49 | 0 |
745088 | 745088 | 2020-11-18 | Webster | West Virginia | 54101 | 49 | 0 |
741841 | 741841 | 2020-11-17 | Webster | West Virginia | 54101 | 49 | 0 |
722359 | 722359 | 2020-11-11 | Pleasants | West Virginia | 54073 | 49 | 3 |
631535 | 631535 | 2020-10-14 | Tucker | West Virginia | 54093 | 49 | 0 |
625009 | 625009 | 2020-10-12 | Clay | West Virginia | 54015 | 49 | 2 |
625022 | 625022 | 2020-10-12 | Lewis | West Virginia | 54041 | 49 | 2 |
621766 | 621766 | 2020-10-11 | Clay | West Virginia | 54015 | 49 | 2 |
618524 | 618524 | 2020-10-10 | Doddridge | West Virginia | 54017 | 49 | 1 |
608801 | 608801 | 2020-10-07 | Gilmer | West Virginia | 54021 | 49 | 0 |
605558 | 605558 | 2020-10-06 | Gilmer | West Virginia | 54021 | 49 | 0 |
602316 | 602316 | 2020-10-05 | Gilmer | West Virginia | 54021 | 49 | 0 |
599073 | 599073 | 2020-10-04 | Gilmer | West Virginia | 54021 | 49 | 0 |
595830 | 595830 | 2020-10-03 | Gilmer | West Virginia | 54021 | 49 | 0 |
576420 | 576420 | 2020-09-27 | Roane | West Virginia | 54087 | 49 | 2 |
573176 | 573176 | 2020-09-26 | Roane | West Virginia | 54087 | 49 | 2 |
569934 | 569934 | 2020-09-25 | Roane | West Virginia | 54087 | 49 | 2 |
569935 | 569935 | 2020-09-25 | Summers | West Virginia | 54089 | 49 | 0 |
566693 | 566693 | 2020-09-24 | Roane | West Virginia | 54087 | 49 | 2 |
563452 | 563452 | 2020-09-23 | Roane | West Virginia | 54087 | 49 | 2 |
556977 | 556977 | 2020-09-21 | Roane | West Virginia | 54087 | 49 | 2 |
556985 | 556985 | 2020-09-21 | Wetzel | West Virginia | 54103 | 49 | 0 |
553740 | 553740 | 2020-09-20 | Roane | West Virginia | 54087 | 49 | 2 |
553748 | 553748 | 2020-09-20 | Wetzel | West Virginia | 54103 | 49 | 0 |
550509 | 550509 | 2020-09-19 | Wetzel | West Virginia | 54103 | 49 | 0 |
547251 | 547251 | 2020-09-18 | Morgan | West Virginia | 54065 | 49 | 0 |
547270 | 547270 | 2020-09-18 | Wetzel | West Virginia | 54103 | 49 | 0 |
544033 | 544033 | 2020-09-17 | Wetzel | West Virginia | 54103 | 49 | 0 |
408335 | 408335 | 2020-08-06 | McDowell | West Virginia | 54047 | 49 | 0 |
398680 | 398680 | 2020-08-03 | Mason | West Virginia | 54053 | 49 | 1 |
372945 | 372945 | 2020-07-26 | Lincoln | West Virginia | 54043 | 49 | 0 |
356906 | 356906 | 2020-07-21 | Logan | West Virginia | 54045 | 49 | 1 |
353696 | 353696 | 2020-07-20 | Hardy | West Virginia | 54031 | 49 | 0 |
350494 | 350494 | 2020-07-19 | Hardy | West Virginia | 54031 | 49 | 0 |
347293 | 347293 | 2020-07-18 | Hardy | West Virginia | 54031 | 49 | 0 |
344093 | 344093 | 2020-07-17 | Hardy | West Virginia | 54031 | 49 | 0 |
340894 | 340894 | 2020-07-16 | Hardy | West Virginia | 54031 | 49 | 0 |
315414 | 315414 | 2020-07-08 | Marshall | West Virginia | 54051 | 49 | 0 |
258699 | 258699 | 2020-06-20 | Harrison | West Virginia | 54033 | 49 | 1 |
255572 | 255572 | 2020-06-19 | Harrison | West Virginia | 54033 | 49 | 1 |
252453 | 252453 | 2020-06-18 | Harrison | West Virginia | 54033 | 49 | 1 |
249338 | 249338 | 2020-06-17 | Harrison | West Virginia | 54033 | 49 | 1 |
246226 | 246226 | 2020-06-16 | Harrison | West Virginia | 54033 | 49 | 1 |
243113 | 243113 | 2020-06-15 | Harrison | West Virginia | 54033 | 49 | 1 |
53649 | 53649 | 2020-04-12 | Jefferson | West Virginia | 54037 | 49 | 0 |
35506 | 35506 | 2020-04-05 | Monongalia | West Virginia | 54061 | 49 | 1 |
33053 | 33053 | 2020-04-04 | Berkeley | West Virginia | 54003 | 49 | 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);