ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where "date" is on date 2020-03-26 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 |
---|---|---|---|---|---|---|---|
13959 | 13959 | 2020-03-26 | Berkeley | West Virginia | 54003 | 4 | 0 |
13960 | 13960 | 2020-03-26 | Harrison | West Virginia | 54033 | 4 | 0 |
13961 | 13961 | 2020-03-26 | Jackson | West Virginia | 54035 | 5 | 0 |
13962 | 13962 | 2020-03-26 | Jefferson | West Virginia | 54037 | 4 | 0 |
13963 | 13963 | 2020-03-26 | Kanawha | West Virginia | 54039 | 15 | 0 |
13964 | 13964 | 2020-03-26 | Logan | West Virginia | 54045 | 1 | 0 |
13965 | 13965 | 2020-03-26 | Marion | West Virginia | 54049 | 2 | 0 |
13966 | 13966 | 2020-03-26 | Marshall | West Virginia | 54051 | 3 | 0 |
13967 | 13967 | 2020-03-26 | Mason | West Virginia | 54053 | 1 | 0 |
13968 | 13968 | 2020-03-26 | Mercer | West Virginia | 54055 | 2 | 0 |
13969 | 13969 | 2020-03-26 | Monongalia | West Virginia | 54061 | 24 | 0 |
13970 | 13970 | 2020-03-26 | Ohio | West Virginia | 54069 | 1 | 0 |
13971 | 13971 | 2020-03-26 | Preston | West Virginia | 54077 | 1 | 0 |
13972 | 13972 | 2020-03-26 | Putnam | West Virginia | 54079 | 2 | 0 |
13973 | 13973 | 2020-03-26 | Raleigh | West Virginia | 54081 | 2 | 0 |
13974 | 13974 | 2020-03-26 | Tucker | West Virginia | 54093 | 2 | 0 |
13975 | 13975 | 2020-03-26 | Upshur | West Virginia | 54097 | 1 | 0 |
13976 | 13976 | 2020-03-26 | Wood | West Virginia | 54107 | 2 | 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);