ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 39 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 |
---|---|---|---|---|---|---|---|
706155 | 706155 | 2020-11-06 | Webster | West Virginia | 54101 | 39 | 0 |
612041 | 612041 | 2020-10-08 | Doddridge | West Virginia | 54017 | 39 | 1 |
595866 | 595866 | 2020-10-03 | Tucker | West Virginia | 54093 | 39 | 0 |
592624 | 592624 | 2020-10-02 | Tucker | West Virginia | 54093 | 39 | 0 |
566660 | 566660 | 2020-09-24 | Gilmer | West Virginia | 54021 | 39 | 0 |
540746 | 540746 | 2020-09-16 | Barbour | West Virginia | 54001 | 39 | 1 |
527844 | 527844 | 2020-09-12 | Roane | West Virginia | 54087 | 39 | 1 |
443814 | 443814 | 2020-08-17 | Upshur | West Virginia | 54097 | 39 | 0 |
440573 | 440573 | 2020-08-16 | Nicholas | West Virginia | 54067 | 39 | 1 |
437347 | 437347 | 2020-08-15 | Nicholas | West Virginia | 54067 | 39 | 1 |
430896 | 430896 | 2020-08-13 | Nicholas | West Virginia | 54067 | 39 | 1 |
414783 | 414783 | 2020-08-08 | Pendleton | West Virginia | 54071 | 39 | 1 |
414796 | 414796 | 2020-08-08 | Upshur | West Virginia | 54097 | 39 | 0 |
411576 | 411576 | 2020-08-07 | Upshur | West Virginia | 54097 | 39 | 0 |
408357 | 408357 | 2020-08-06 | Upshur | West Virginia | 54097 | 39 | 0 |
405137 | 405137 | 2020-08-05 | Upshur | West Virginia | 54097 | 39 | 0 |
401919 | 401919 | 2020-08-04 | Upshur | West Virginia | 54097 | 39 | 0 |
376183 | 376183 | 2020-07-27 | Taylor | West Virginia | 54091 | 39 | 0 |
369723 | 369723 | 2020-07-25 | Grant | West Virginia | 54023 | 39 | 0 |
369757 | 369757 | 2020-07-25 | Taylor | West Virginia | 54091 | 39 | 0 |
353686 | 353686 | 2020-07-20 | Brooke | West Virginia | 54009 | 39 | 0 |
353718 | 353718 | 2020-07-20 | Pocahontas | West Virginia | 54075 | 39 | 0 |
350484 | 350484 | 2020-07-19 | Brooke | West Virginia | 54009 | 39 | 0 |
334510 | 334510 | 2020-07-14 | Logan | West Virginia | 54045 | 39 | 1 |
331317 | 331317 | 2020-07-13 | Logan | West Virginia | 54045 | 39 | 1 |
290107 | 290107 | 2020-06-30 | Mercer | West Virginia | 54055 | 39 | 0 |
274366 | 274366 | 2020-06-25 | Marshall | West Virginia | 54051 | 39 | 0 |
271226 | 271226 | 2020-06-24 | Marshall | West Virginia | 54051 | 39 | 0 |
268092 | 268092 | 2020-06-23 | Marshall | West Virginia | 54051 | 39 | 0 |
264963 | 264963 | 2020-06-22 | Marshall | West Virginia | 54051 | 39 | 0 |
243110 | 243110 | 2020-06-15 | Hampshire | West Virginia | 54027 | 39 | 1 |
239999 | 239999 | 2020-06-14 | Hampshire | West Virginia | 54027 | 39 | 1 |
236891 | 236891 | 2020-06-13 | Hampshire | West Virginia | 54027 | 39 | 1 |
218313 | 218313 | 2020-06-07 | Putnam | West Virginia | 54079 | 39 | 0 |
215223 | 215223 | 2020-06-06 | Putnam | West Virginia | 54079 | 39 | 0 |
209027 | 209027 | 2020-06-04 | Hardy | West Virginia | 54031 | 39 | 0 |
205945 | 205945 | 2020-06-03 | Hardy | West Virginia | 54031 | 39 | 0 |
202866 | 202866 | 2020-06-02 | Hardy | West Virginia | 54031 | 39 | 0 |
199790 | 199790 | 2020-06-01 | Hardy | West Virginia | 54031 | 39 | 0 |
196717 | 196717 | 2020-05-31 | Hardy | West Virginia | 54031 | 39 | 0 |
193647 | 193647 | 2020-05-30 | Hardy | West Virginia | 54031 | 39 | 0 |
190581 | 190581 | 2020-05-29 | Hardy | West Virginia | 54031 | 39 | 0 |
178366 | 178366 | 2020-05-25 | Harrison | West Virginia | 54033 | 39 | 1 |
175339 | 175339 | 2020-05-24 | Ohio | West Virginia | 54069 | 39 | 1 |
172278 | 172278 | 2020-05-23 | Harrison | West Virginia | 54033 | 39 | 1 |
169237 | 169237 | 2020-05-22 | Harrison | West Virginia | 54033 | 39 | 1 |
166194 | 166194 | 2020-05-21 | Fayette | West Virginia | 54019 | 39 | 3 |
163165 | 163165 | 2020-05-20 | Fayette | West Virginia | 54019 | 39 | 3 |
100927 | 100927 | 2020-04-29 | Wood | West Virginia | 54107 | 39 | 2 |
98077 | 98077 | 2020-04-28 | Wood | West Virginia | 54107 | 39 | 2 |
64502 | 64502 | 2020-04-16 | Marion | West Virginia | 54049 | 39 | 2 |
59050 | 59050 | 2020-04-14 | Marion | West Virginia | 54049 | 39 | 2 |
28307 | 28307 | 2020-04-02 | Kanawha | West Virginia | 54039 | 39 | 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);