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 2021-01-21 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 |
---|---|---|---|---|---|---|---|
952742 | 952742 | 2021-01-21 | Barbour | West Virginia | 54001 | 1030 | 15 |
952743 | 952743 | 2021-01-21 | Berkeley | West Virginia | 54003 | 8289 | 73 |
952744 | 952744 | 2021-01-21 | Boone | West Virginia | 54005 | 1338 | 28 |
952745 | 952745 | 2021-01-21 | Braxton | West Virginia | 54007 | 718 | 1 |
952746 | 952746 | 2021-01-21 | Brooke | West Virginia | 54009 | 1811 | 47 |
952747 | 952747 | 2021-01-21 | Cabell | West Virginia | 54011 | 6604 | 135 |
952748 | 952748 | 2021-01-21 | Calhoun | West Virginia | 54013 | 194 | 0 |
952749 | 952749 | 2021-01-21 | Clay | West Virginia | 54015 | 310 | 4 |
952750 | 952750 | 2021-01-21 | Doddridge | West Virginia | 54017 | 375 | 5 |
952751 | 952751 | 2021-01-21 | Fayette | West Virginia | 54019 | 2218 | 61 |
952752 | 952752 | 2021-01-21 | Gilmer | West Virginia | 54021 | 542 | 6 |
952753 | 952753 | 2021-01-21 | Grant | West Virginia | 54023 | 936 | 19 |
952754 | 952754 | 2021-01-21 | Greenbrier | West Virginia | 54025 | 2100 | 47 |
952755 | 952755 | 2021-01-21 | Hampshire | West Virginia | 54027 | 1278 | 24 |
952756 | 952756 | 2021-01-21 | Hancock | West Virginia | 54029 | 2360 | 77 |
952757 | 952757 | 2021-01-21 | Hardy | West Virginia | 54031 | 1119 | 14 |
952758 | 952758 | 2021-01-21 | Harrison | West Virginia | 54033 | 4157 | 45 |
952759 | 952759 | 2021-01-21 | Jackson | West Virginia | 54035 | 1526 | 43 |
952760 | 952760 | 2021-01-21 | Jefferson | West Virginia | 54037 | 3072 | 31 |
952761 | 952761 | 2021-01-21 | Kanawha | West Virginia | 54039 | 10483 | 248 |
952762 | 952762 | 2021-01-21 | Lewis | West Virginia | 54041 | 746 | 11 |
952763 | 952763 | 2021-01-21 | Lincoln | West Virginia | 54043 | 1065 | 9 |
952764 | 952764 | 2021-01-21 | Logan | West Virginia | 54045 | 2169 | 66 |
952765 | 952765 | 2021-01-21 | Marion | West Virginia | 54049 | 3023 | 24 |
952766 | 952766 | 2021-01-21 | Marshall | West Virginia | 54051 | 2612 | 60 |
952767 | 952767 | 2021-01-21 | Mason | West Virginia | 54053 | 1432 | 26 |
952768 | 952768 | 2021-01-21 | McDowell | West Virginia | 54047 | 1166 | 8 |
952769 | 952769 | 2021-01-21 | Mercer | West Virginia | 54055 | 3754 | 78 |
952770 | 952770 | 2021-01-21 | Mineral | West Virginia | 54057 | 2337 | 73 |
952771 | 952771 | 2021-01-21 | Mingo | West Virginia | 54059 | 1803 | 20 |
952772 | 952772 | 2021-01-21 | Monongalia | West Virginia | 54061 | 6648 | 54 |
952773 | 952773 | 2021-01-21 | Monroe | West Virginia | 54063 | 839 | 11 |
952774 | 952774 | 2021-01-21 | Morgan | West Virginia | 54065 | 833 | 10 |
952775 | 952775 | 2021-01-21 | Nicholas | West Virginia | 54067 | 966 | 9 |
952776 | 952776 | 2021-01-21 | Ohio | West Virginia | 54069 | 3180 | 57 |
952777 | 952777 | 2021-01-21 | Pendleton | West Virginia | 54071 | 505 | 3 |
952778 | 952778 | 2021-01-21 | Pleasants | West Virginia | 54073 | 734 | 12 |
952779 | 952779 | 2021-01-21 | Pocahontas | West Virginia | 54075 | 529 | 9 |
952780 | 952780 | 2021-01-21 | Preston | West Virginia | 54077 | 2305 | 35 |
952781 | 952781 | 2021-01-21 | Putnam | West Virginia | 54079 | 3588 | 67 |
952782 | 952782 | 2021-01-21 | Raleigh | West Virginia | 54081 | 3797 | 40 |
952783 | 952783 | 2021-01-21 | Randolph | West Virginia | 54083 | 2032 | 8 |
952784 | 952784 | 2021-01-21 | Ritchie | West Virginia | 54085 | 516 | 8 |
952785 | 952785 | 2021-01-21 | Roane | West Virginia | 54087 | 421 | 6 |
952786 | 952786 | 2021-01-21 | Summers | West Virginia | 54089 | 642 | 19 |
952787 | 952787 | 2021-01-21 | Taylor | West Virginia | 54091 | 932 | 15 |
952788 | 952788 | 2021-01-21 | Tucker | West Virginia | 54093 | 427 | 7 |
952789 | 952789 | 2021-01-21 | Tyler | West Virginia | 54095 | 522 | 3 |
952790 | 952790 | 2021-01-21 | Upshur | West Virginia | 54097 | 1333 | 20 |
952791 | 952791 | 2021-01-21 | Wayne | West Virginia | 54099 | 2157 | 26 |
952792 | 952792 | 2021-01-21 | Webster | West Virginia | 54101 | 225 | 0 |
952793 | 952793 | 2021-01-21 | Wetzel | West Virginia | 54103 | 930 | 18 |
952794 | 952794 | 2021-01-21 | Wirt | West Virginia | 54105 | 305 | 1 |
952795 | 952795 | 2021-01-21 | Wood | West Virginia | 54107 | 6227 | 87 |
952796 | 952796 | 2021-01-21 | Wyoming | West Virginia | 54109 | 1457 | 26 |
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);