ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 182 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
829454 | 829454 | 2020-12-14 | Pendleton | West Virginia | 54071 | 182 | 1 |
806746 | 806746 | 2020-12-07 | Tyler | West Virginia | 54095 | 182 | 2 |
803501 | 803501 | 2020-12-06 | Tyler | West Virginia | 54095 | 182 | 2 |
787271 | 787271 | 2020-12-01 | Ritchie | West Virginia | 54085 | 182 | 4 |
754786 | 754786 | 2020-11-21 | Gilmer | West Virginia | 54021 | 182 | 0 |
725586 | 725586 | 2020-11-12 | Lewis | West Virginia | 54041 | 182 | 2 |
719112 | 719112 | 2020-11-10 | Morgan | West Virginia | 54065 | 182 | 0 |
715869 | 715869 | 2020-11-09 | Morgan | West Virginia | 54065 | 182 | 0 |
709394 | 709394 | 2020-11-07 | Taylor | West Virginia | 54091 | 182 | 8 |
706150 | 706150 | 2020-11-06 | Taylor | West Virginia | 54091 | 182 | 8 |
689914 | 689914 | 2020-11-01 | Mason | West Virginia | 54053 | 182 | 6 |
673672 | 673672 | 2020-10-27 | Barbour | West Virginia | 54001 | 182 | 1 |
673705 | 673705 | 2020-10-27 | Nicholas | West Virginia | 54067 | 182 | 3 |
663953 | 663953 | 2020-10-24 | Grant | West Virginia | 54023 | 182 | 8 |
637993 | 637993 | 2020-10-16 | Hancock | West Virginia | 54029 | 182 | 0 |
628293 | 628293 | 2020-10-13 | Upshur | West Virginia | 54097 | 182 | 0 |
618544 | 618544 | 2020-10-10 | Mineral | West Virginia | 54057 | 182 | 4 |
592599 | 592599 | 2020-10-02 | Lincoln | West Virginia | 54043 | 182 | 2 |
589362 | 589362 | 2020-10-01 | Marshall | West Virginia | 54051 | 182 | 1 |
537511 | 537511 | 2020-09-15 | Boone | West Virginia | 54005 | 182 | 0 |
456694 | 456694 | 2020-08-21 | Jackson | West Virginia | 54035 | 182 | 19 |
424440 | 424440 | 2020-08-11 | Mingo | West Virginia | 54059 | 182 | 5 |
414775 | 414775 | 2020-08-08 | Mercer | West Virginia | 54055 | 182 | 3 |
392263 | 392263 | 2020-08-01 | Raleigh | West Virginia | 54081 | 182 | 1 |
392272 | 392272 | 2020-08-01 | Wayne | West Virginia | 54099 | 182 | 9 |
389055 | 389055 | 2020-07-31 | Wayne | West Virginia | 54099 | 182 | 9 |
196720 | 196720 | 2020-05-31 | Jefferson | West Virginia | 54037 | 182 | 1 |
130119 | 130119 | 2020-05-09 | Kanawha | West Virginia | 54039 | 182 | 11 |
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);