ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 144 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
state 1
- West Virginia · 27 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2200092 | 2200092 | 2022-02-09 | Marshall | West Virginia | 54051 | 8318 | 144 |
2034222 | 2034222 | 2021-12-20 | Fayette | West Virginia | 54019 | 7416 | 144 |
2034252 | 2034252 | 2021-12-20 | Putnam | West Virginia | 54079 | 10289 | 144 |
2030972 | 2030972 | 2021-12-19 | Fayette | West Virginia | 54019 | 7387 | 144 |
2031002 | 2031002 | 2021-12-19 | Putnam | West Virginia | 54079 | 10263 | 144 |
2027721 | 2027721 | 2021-12-18 | Fayette | West Virginia | 54019 | 7339 | 144 |
2027751 | 2027751 | 2021-12-18 | Putnam | West Virginia | 54079 | 10239 | 144 |
2024470 | 2024470 | 2021-12-17 | Fayette | West Virginia | 54019 | 7309 | 144 |
2024500 | 2024500 | 2021-12-17 | Putnam | West Virginia | 54079 | 10202 | 144 |
2021219 | 2021219 | 2021-12-16 | Fayette | West Virginia | 54019 | 7277 | 144 |
2021249 | 2021249 | 2021-12-16 | Putnam | West Virginia | 54079 | 10172 | 144 |
2017968 | 2017968 | 2021-12-15 | Fayette | West Virginia | 54019 | 7234 | 144 |
2017998 | 2017998 | 2021-12-15 | Putnam | West Virginia | 54079 | 10145 | 144 |
2014718 | 2014718 | 2021-12-14 | Fayette | West Virginia | 54019 | 7181 | 144 |
2014748 | 2014748 | 2021-12-14 | Putnam | West Virginia | 54079 | 10124 | 144 |
2011497 | 2011497 | 2021-12-13 | Putnam | West Virginia | 54079 | 10094 | 144 |
2008246 | 2008246 | 2021-12-12 | Putnam | West Virginia | 54079 | 10074 | 144 |
2004995 | 2004995 | 2021-12-11 | Putnam | West Virginia | 54079 | 10047 | 144 |
2001744 | 2001744 | 2021-12-10 | Putnam | West Virginia | 54079 | 10005 | 144 |
1962723 | 1962723 | 2021-11-28 | Logan | West Virginia | 54045 | 5656 | 144 |
1959472 | 1959472 | 2021-11-27 | Logan | West Virginia | 54045 | 5656 | 144 |
1956221 | 1956221 | 2021-11-26 | Logan | West Virginia | 54045 | 5656 | 144 |
1952970 | 1952970 | 2021-11-25 | Logan | West Virginia | 54045 | 5656 | 144 |
1949719 | 1949719 | 2021-11-24 | Logan | West Virginia | 54045 | 5656 | 144 |
1904226 | 1904226 | 2021-11-10 | Monongalia | West Virginia | 54061 | 13796 | 144 |
1855471 | 1855471 | 2021-10-26 | Harrison | West Virginia | 54033 | 11076 | 144 |
978707 | 978707 | 2021-01-29 | Cabell | West Virginia | 54011 | 6999 | 144 |
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);