ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 87 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
774285 | 774285 | 2020-11-27 | Pleasants | West Virginia | 54073 | 87 | 4 |
735308 | 735308 | 2020-11-15 | Doddridge | West Virginia | 54017 | 87 | 1 |
706115 | 706115 | 2020-11-06 | Gilmer | West Virginia | 54021 | 87 | 0 |
676935 | 676935 | 2020-10-28 | Lewis | West Virginia | 54041 | 87 | 2 |
586123 | 586123 | 2020-09-30 | McDowell | West Virginia | 54047 | 87 | 0 |
586145 | 586145 | 2020-09-30 | Upshur | West Virginia | 54097 | 87 | 0 |
582883 | 582883 | 2020-09-29 | McDowell | West Virginia | 54047 | 87 | 0 |
566665 | 566665 | 2020-09-24 | Hardy | West Virginia | 54031 | 87 | 1 |
553730 | 553730 | 2020-09-20 | Nicholas | West Virginia | 54067 | 87 | 3 |
453494 | 453494 | 2020-08-20 | Taylor | West Virginia | 54091 | 87 | 1 |
421211 | 421211 | 2020-08-10 | Lincoln | West Virginia | 54043 | 87 | 0 |
417990 | 417990 | 2020-08-09 | Lincoln | West Virginia | 54043 | 87 | 0 |
401883 | 401883 | 2020-08-04 | Greenbrier | West Virginia | 54025 | 87 | 3 |
398667 | 398667 | 2020-08-03 | Greenbrier | West Virginia | 54025 | 87 | 3 |
395451 | 395451 | 2020-08-02 | Greenbrier | West Virginia | 54025 | 87 | 3 |
369741 | 369741 | 2020-07-25 | Mingo | West Virginia | 54059 | 87 | 2 |
363323 | 363323 | 2020-07-23 | Mineral | West Virginia | 54057 | 87 | 3 |
293285 | 293285 | 2020-07-01 | Wood | West Virginia | 54107 | 87 | 2 |
283818 | 283818 | 2020-06-28 | Ohio | West Virginia | 54069 | 87 | 1 |
127128 | 127128 | 2020-05-08 | Jefferson | West Virginia | 54037 | 87 | 1 |
72788 | 72788 | 2020-04-19 | Monongalia | West Virginia | 54061 | 87 | 4 |
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);