ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where deaths = 185 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
state 1
- West Virginia · 13 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466871 | 2466871 | 2022-05-02 | Logan | West Virginia | 54045 | 9663 | 185 |
2463616 | 2463616 | 2022-05-01 | Logan | West Virginia | 54045 | 9642 | 185 |
2460360 | 2460360 | 2022-04-30 | Logan | West Virginia | 54045 | 9642 | 185 |
2457104 | 2457104 | 2022-04-29 | Logan | West Virginia | 54045 | 9642 | 185 |
2453848 | 2453848 | 2022-04-28 | Logan | West Virginia | 54045 | 9637 | 185 |
2450592 | 2450592 | 2022-04-27 | Logan | West Virginia | 54045 | 9626 | 185 |
2447336 | 2447336 | 2022-04-26 | Logan | West Virginia | 54045 | 9616 | 185 |
2310636 | 2310636 | 2022-03-15 | Fayette | West Virginia | 54019 | 13001 | 185 |
1972480 | 1972480 | 2021-12-01 | Mercer | West Virginia | 54055 | 9690 | 185 |
1881448 | 1881448 | 2021-11-03 | Berkeley | West Virginia | 54003 | 18805 | 185 |
1878199 | 1878199 | 2021-11-02 | Berkeley | West Virginia | 54003 | 18777 | 185 |
1702807 | 1702807 | 2021-09-09 | Wood | West Virginia | 54107 | 9882 | 185 |
1631289 | 1631289 | 2021-08-18 | Cabell | West Virginia | 54011 | 9757 | 185 |
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);