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-09 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 |
---|---|---|---|---|---|---|---|
913798 | 913798 | 2021-01-09 | Barbour | West Virginia | 54001 | 1158 | 14 |
913799 | 913799 | 2021-01-09 | Berkeley | West Virginia | 54003 | 7283 | 59 |
913800 | 913800 | 2021-01-09 | Boone | West Virginia | 54005 | 1190 | 22 |
913801 | 913801 | 2021-01-09 | Braxton | West Virginia | 54007 | 615 | 1 |
913802 | 913802 | 2021-01-09 | Brooke | West Virginia | 54009 | 1615 | 39 |
913803 | 913803 | 2021-01-09 | Cabell | West Virginia | 54011 | 5976 | 117 |
913804 | 913804 | 2021-01-09 | Calhoun | West Virginia | 54013 | 168 | 0 |
913805 | 913805 | 2021-01-09 | Clay | West Virginia | 54015 | 283 | 4 |
913806 | 913806 | 2021-01-09 | Doddridge | West Virginia | 54017 | 304 | 3 |
913807 | 913807 | 2021-01-09 | Fayette | West Virginia | 54019 | 2008 | 53 |
913808 | 913808 | 2021-01-09 | Gilmer | West Virginia | 54021 | 475 | 3 |
913809 | 913809 | 2021-01-09 | Grant | West Virginia | 54023 | 868 | 18 |
913810 | 913810 | 2021-01-09 | Greenbrier | West Virginia | 54025 | 1790 | 43 |
913811 | 913811 | 2021-01-09 | Hampshire | West Virginia | 54027 | 1129 | 22 |
913812 | 913812 | 2021-01-09 | Hancock | West Virginia | 54029 | 2143 | 57 |
913813 | 913813 | 2021-01-09 | Hardy | West Virginia | 54031 | 921 | 10 |
913814 | 913814 | 2021-01-09 | Harrison | West Virginia | 54033 | 3587 | 37 |
913815 | 913815 | 2021-01-09 | Jackson | West Virginia | 54035 | 1373 | 33 |
913816 | 913816 | 2021-01-09 | Jefferson | West Virginia | 54037 | 2737 | 27 |
913817 | 913817 | 2021-01-09 | Kanawha | West Virginia | 54039 | 9590 | 226 |
913818 | 913818 | 2021-01-09 | Lewis | West Virginia | 54041 | 641 | 5 |
913819 | 913819 | 2021-01-09 | Lincoln | West Virginia | 54043 | 908 | 9 |
913820 | 913820 | 2021-01-09 | Logan | West Virginia | 54045 | 1915 | 62 |
913821 | 913821 | 2021-01-09 | Marion | West Virginia | 54049 | 2420 | 16 |
913822 | 913822 | 2021-01-09 | Marshall | West Virginia | 54051 | 2347 | 57 |
913823 | 913823 | 2021-01-09 | Mason | West Virginia | 54053 | 1190 | 22 |
913824 | 913824 | 2021-01-09 | McDowell | West Virginia | 54047 | 1078 | 6 |
913825 | 913825 | 2021-01-09 | Mercer | West Virginia | 54055 | 3418 | 64 |
913826 | 913826 | 2021-01-09 | Mineral | West Virginia | 54057 | 2246 | 71 |
913827 | 913827 | 2021-01-09 | Mingo | West Virginia | 54059 | 1622 | 20 |
913828 | 913828 | 2021-01-09 | Monongalia | West Virginia | 54061 | 5989 | 45 |
913829 | 913829 | 2021-01-09 | Monroe | West Virginia | 54063 | 740 | 11 |
913830 | 913830 | 2021-01-09 | Morgan | West Virginia | 54065 | 748 | 9 |
913831 | 913831 | 2021-01-09 | Nicholas | West Virginia | 54067 | 804 | 9 |
913832 | 913832 | 2021-01-09 | Ohio | West Virginia | 54069 | 2820 | 50 |
913833 | 913833 | 2021-01-09 | Pendleton | West Virginia | 54071 | 388 | 2 |
913834 | 913834 | 2021-01-09 | Pleasants | West Virginia | 54073 | 685 | 6 |
913835 | 913835 | 2021-01-09 | Pocahontas | West Virginia | 54075 | 416 | 9 |
913836 | 913836 | 2021-01-09 | Preston | West Virginia | 54077 | 1970 | 34 |
913837 | 913837 | 2021-01-09 | Putnam | West Virginia | 54079 | 3282 | 60 |
913838 | 913838 | 2021-01-09 | Raleigh | West Virginia | 54081 | 3209 | 32 |
913839 | 913839 | 2021-01-09 | Randolph | West Virginia | 54083 | 1393 | 6 |
913840 | 913840 | 2021-01-09 | Ritchie | West Virginia | 54085 | 439 | 7 |
913841 | 913841 | 2021-01-09 | Roane | West Virginia | 54087 | 355 | 6 |
913842 | 913842 | 2021-01-09 | Summers | West Virginia | 54089 | 546 | 17 |
913843 | 913843 | 2021-01-09 | Taylor | West Virginia | 54091 | 834 | 13 |
913844 | 913844 | 2021-01-09 | Tucker | West Virginia | 54093 | 401 | 4 |
913845 | 913845 | 2021-01-09 | Tyler | West Virginia | 54095 | 439 | 2 |
913846 | 913846 | 2021-01-09 | Upshur | West Virginia | 54097 | 1165 | 9 |
913847 | 913847 | 2021-01-09 | Wayne | West Virginia | 54099 | 1935 | 22 |
913848 | 913848 | 2021-01-09 | Webster | West Virginia | 54101 | 190 | 0 |
913849 | 913849 | 2021-01-09 | Wetzel | West Virginia | 54103 | 806 | 16 |
913850 | 913850 | 2021-01-09 | Wirt | West Virginia | 54105 | 256 | 1 |
913851 | 913851 | 2021-01-09 | Wood | West Virginia | 54107 | 5662 | 58 |
913852 | 913852 | 2021-01-09 | Wyoming | West Virginia | 54109 | 1308 | 22 |
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);