ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 136 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 |
---|---|---|---|---|---|---|---|
809980 | 809980 | 2020-12-08 | Pleasants | West Virginia | 54073 | 136 | 4 |
800217 | 800217 | 2020-12-05 | Doddridge | West Virginia | 54017 | 136 | 3 |
738587 | 738587 | 2020-11-16 | Roane | West Virginia | 54087 | 136 | 2 |
725581 | 725581 | 2020-11-12 | Hardy | West Virginia | 54031 | 136 | 1 |
722338 | 722338 | 2020-11-11 | Hardy | West Virginia | 54031 | 136 | 1 |
686688 | 686688 | 2020-10-31 | Summers | West Virginia | 54089 | 136 | 1 |
663993 | 663993 | 2020-10-24 | Wetzel | West Virginia | 54103 | 136 | 1 |
618570 | 618570 | 2020-10-10 | Wyoming | West Virginia | 54109 | 136 | 5 |
615307 | 615307 | 2020-10-09 | Nicholas | West Virginia | 54067 | 136 | 3 |
556959 | 556959 | 2020-09-21 | Mason | West Virginia | 54053 | 136 | 5 |
553722 | 553722 | 2020-09-20 | Mason | West Virginia | 54053 | 136 | 5 |
537523 | 537523 | 2020-09-15 | Hancock | West Virginia | 54029 | 136 | 0 |
524579 | 524579 | 2020-09-11 | Hancock | West Virginia | 54029 | 136 | 0 |
518116 | 518116 | 2020-09-09 | Marshall | West Virginia | 54051 | 136 | 1 |
508422 | 508422 | 2020-09-06 | Monroe | West Virginia | 54063 | 136 | 6 |
476094 | 476094 | 2020-08-27 | Preston | West Virginia | 54077 | 136 | 4 |
472861 | 472861 | 2020-08-26 | Preston | West Virginia | 54077 | 136 | 4 |
469629 | 469629 | 2020-08-25 | Preston | West Virginia | 54077 | 136 | 4 |
376178 | 376178 | 2020-07-27 | Raleigh | West Virginia | 54081 | 136 | 0 |
369751 | 369751 | 2020-07-25 | Putnam | West Virginia | 54079 | 136 | 0 |
347294 | 347294 | 2020-07-18 | Harrison | West Virginia | 54033 | 136 | 1 |
312268 | 312268 | 2020-07-07 | Wood | West Virginia | 54107 | 136 | 2 |
190583 | 190583 | 2020-05-29 | Jackson | West Virginia | 54035 | 136 | 18 |
154104 | 154104 | 2020-05-17 | Jackson | West Virginia | 54035 | 136 | 17 |
151093 | 151093 | 2020-05-16 | Jackson | West Virginia | 54035 | 136 | 17 |
142084 | 142084 | 2020-05-13 | Jackson | West Virginia | 54035 | 136 | 16 |
139088 | 139088 | 2020-05-12 | Jackson | West Virginia | 54035 | 136 | 16 |
136097 | 136097 | 2020-05-11 | Jackson | West Virginia | 54035 | 136 | 16 |
133107 | 133107 | 2020-05-10 | Jackson | West Virginia | 54035 | 136 | 15 |
130117 | 130117 | 2020-05-09 | Jackson | West Virginia | 54035 | 136 | 15 |
127127 | 127127 | 2020-05-08 | Jackson | West Virginia | 54035 | 136 | 15 |
124142 | 124142 | 2020-05-07 | Jackson | West Virginia | 54035 | 136 | 15 |
121162 | 121162 | 2020-05-06 | Jackson | West Virginia | 54035 | 136 | 15 |
78336 | 78336 | 2020-04-21 | Kanawha | West Virginia | 54039 | 136 | 1 |
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);