ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2020-10-23 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
660698 | 660698 | 2020-10-23 | Barbour | West Virginia | 54001 | 165 | 1 |
660699 | 660699 | 2020-10-23 | Berkeley | West Virginia | 54003 | 1497 | 17 |
660700 | 660700 | 2020-10-23 | Boone | West Virginia | 54005 | 325 | 3 |
660701 | 660701 | 2020-10-23 | Braxton | West Virginia | 54007 | 56 | 0 |
660702 | 660702 | 2020-10-23 | Brooke | West Virginia | 54009 | 201 | 4 |
660703 | 660703 | 2020-10-23 | Cabell | West Virginia | 54011 | 1293 | 20 |
660704 | 660704 | 2020-10-23 | Calhoun | West Virginia | 54013 | 33 | 0 |
660705 | 660705 | 2020-10-23 | Clay | West Virginia | 54015 | 58 | 3 |
660706 | 660706 | 2020-10-23 | Doddridge | West Virginia | 54017 | 69 | 1 |
660707 | 660707 | 2020-10-23 | Fayette | West Virginia | 54019 | 745 | 20 |
660708 | 660708 | 2020-10-23 | Gilmer | West Virginia | 54021 | 64 | 0 |
660709 | 660709 | 2020-10-23 | Grant | West Virginia | 54023 | 179 | 8 |
660710 | 660710 | 2020-10-23 | Greenbrier | West Virginia | 54025 | 167 | 4 |
660711 | 660711 | 2020-10-23 | Hampshire | West Virginia | 54027 | 123 | 1 |
660712 | 660712 | 2020-10-23 | Hancock | West Virginia | 54029 | 207 | 1 |
660713 | 660713 | 2020-10-23 | Hardy | West Virginia | 54031 | 102 | 1 |
660714 | 660714 | 2020-10-23 | Harrison | West Virginia | 54033 | 632 | 12 |
660715 | 660715 | 2020-10-23 | Jackson | West Virginia | 54035 | 368 | 24 |
660716 | 660716 | 2020-10-23 | Jefferson | West Virginia | 54037 | 554 | 4 |
660717 | 660717 | 2020-10-23 | Kanawha | West Virginia | 54039 | 3459 | 101 |
660718 | 660718 | 2020-10-23 | Lewis | West Virginia | 54041 | 72 | 2 |
660719 | 660719 | 2020-10-23 | Lincoln | West Virginia | 54043 | 225 | 2 |
660720 | 660720 | 2020-10-23 | Logan | West Virginia | 54045 | 738 | 45 |
660721 | 660721 | 2020-10-23 | Marion | West Virginia | 54049 | 367 | 5 |
660722 | 660722 | 2020-10-23 | Marshall | West Virginia | 54051 | 274 | 3 |
660723 | 660723 | 2020-10-23 | Mason | West Virginia | 54053 | 170 | 6 |
660724 | 660724 | 2020-10-23 | McDowell | West Virginia | 54047 | 112 | 0 |
660725 | 660725 | 2020-10-23 | Mercer | West Virginia | 54055 | 644 | 30 |
660726 | 660726 | 2020-10-23 | Mineral | West Virginia | 54057 | 207 | 4 |
660727 | 660727 | 2020-10-23 | Mingo | West Virginia | 54059 | 546 | 10 |
660728 | 660728 | 2020-10-23 | Monongalia | West Virginia | 54061 | 2259 | 5 |
660729 | 660729 | 2020-10-23 | Monroe | West Virginia | 54063 | 223 | 8 |
660730 | 660730 | 2020-10-23 | Morgan | West Virginia | 54065 | 123 | 0 |
660731 | 660731 | 2020-10-23 | Nicholas | West Virginia | 54067 | 180 | 3 |
660732 | 660732 | 2020-10-23 | Ohio | West Virginia | 54069 | 487 | 8 |
660733 | 660733 | 2020-10-23 | Pendleton | West Virginia | 54071 | 75 | 1 |
660734 | 660734 | 2020-10-23 | Pleasants | West Virginia | 54073 | 23 | 3 |
660735 | 660735 | 2020-10-23 | Pocahontas | West Virginia | 54075 | 68 | 0 |
660736 | 660736 | 2020-10-23 | Preston | West Virginia | 54077 | 192 | 4 |
660737 | 660737 | 2020-10-23 | Putnam | West Virginia | 54079 | 827 | 13 |
660738 | 660738 | 2020-10-23 | Raleigh | West Virginia | 54081 | 712 | 8 |
660739 | 660739 | 2020-10-23 | Randolph | West Virginia | 54083 | 399 | 1 |
660740 | 660740 | 2020-10-23 | Ritchie | West Virginia | 54085 | 34 | 0 |
660741 | 660741 | 2020-10-23 | Roane | West Virginia | 54087 | 94 | 2 |
660742 | 660742 | 2020-10-23 | Summers | West Virginia | 54089 | 92 | 1 |
660743 | 660743 | 2020-10-23 | Taylor | West Virginia | 54091 | 165 | 8 |
660744 | 660744 | 2020-10-23 | Tucker | West Virginia | 54093 | 61 | 0 |
660745 | 660745 | 2020-10-23 | Tyler | West Virginia | 54095 | 30 | 0 |
660746 | 660746 | 2020-10-23 | Upshur | West Virginia | 54097 | 234 | 2 |
660747 | 660747 | 2020-10-23 | Wayne | West Virginia | 54099 | 531 | 11 |
660748 | 660748 | 2020-10-23 | Webster | West Virginia | 54101 | 25 | 0 |
660749 | 660749 | 2020-10-23 | Wetzel | West Virginia | 54103 | 134 | 1 |
660750 | 660750 | 2020-10-23 | Wirt | West Virginia | 54105 | 37 | 0 |
660751 | 660751 | 2020-10-23 | Wood | West Virginia | 54107 | 519 | 6 |
660752 | 660752 | 2020-10-23 | Wyoming | West Virginia | 54109 | 216 | 5 |
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);