ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2020-12-20" 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 |
---|---|---|---|---|---|---|---|
848893 | 848893 | 2020-12-20 | Barbour | West Virginia | 54001 | 608 | 8 |
848894 | 848894 | 2020-12-20 | Berkeley | West Virginia | 54003 | 5193 | 46 |
848895 | 848895 | 2020-12-20 | Boone | West Virginia | 54005 | 911 | 19 |
848896 | 848896 | 2020-12-20 | Braxton | West Virginia | 54007 | 223 | 1 |
848897 | 848897 | 2020-12-20 | Brooke | West Virginia | 54009 | 1169 | 19 |
848898 | 848898 | 2020-12-20 | Cabell | West Virginia | 54011 | 4451 | 80 |
848899 | 848899 | 2020-12-20 | Calhoun | West Virginia | 54013 | 115 | 0 |
848900 | 848900 | 2020-12-20 | Clay | West Virginia | 54015 | 230 | 3 |
848901 | 848901 | 2020-12-20 | Doddridge | West Virginia | 54017 | 203 | 3 |
848902 | 848902 | 2020-12-20 | Fayette | West Virginia | 54019 | 1495 | 42 |
848903 | 848903 | 2020-12-20 | Gilmer | West Virginia | 54021 | 272 | 1 |
848904 | 848904 | 2020-12-20 | Grant | West Virginia | 54023 | 651 | 16 |
848905 | 848905 | 2020-12-20 | Greenbrier | West Virginia | 54025 | 1131 | 22 |
848906 | 848906 | 2020-12-20 | Hampshire | West Virginia | 54027 | 810 | 8 |
848907 | 848907 | 2020-12-20 | Hancock | West Virginia | 54029 | 1546 | 20 |
848908 | 848908 | 2020-12-20 | Hardy | West Virginia | 54031 | 622 | 6 |
848909 | 848909 | 2020-12-20 | Harrison | West Virginia | 54033 | 2377 | 30 |
848910 | 848910 | 2020-12-20 | Jackson | West Virginia | 54035 | 1007 | 28 |
848911 | 848911 | 2020-12-20 | Jefferson | West Virginia | 54037 | 2054 | 22 |
848912 | 848912 | 2020-12-20 | Kanawha | West Virginia | 54039 | 7666 | 183 |
848913 | 848913 | 2020-12-20 | Lewis | West Virginia | 54041 | 398 | 3 |
848914 | 848914 | 2020-12-20 | Lincoln | West Virginia | 54043 | 641 | 7 |
848915 | 848915 | 2020-12-20 | Logan | West Virginia | 54045 | 1389 | 54 |
848916 | 848916 | 2020-12-20 | Marion | West Virginia | 54049 | 1443 | 10 |
848917 | 848917 | 2020-12-20 | Marshall | West Virginia | 54051 | 1781 | 48 |
848918 | 848918 | 2020-12-20 | Mason | West Virginia | 54053 | 897 | 12 |
848919 | 848919 | 2020-12-20 | McDowell | West Virginia | 54047 | 809 | 4 |
848920 | 848920 | 2020-12-20 | Mercer | West Virginia | 54055 | 2177 | 49 |
848921 | 848921 | 2020-12-20 | Mineral | West Virginia | 54057 | 1989 | 55 |
848922 | 848922 | 2020-12-20 | Mingo | West Virginia | 54059 | 1214 | 20 |
848923 | 848923 | 2020-12-20 | Monongalia | West Virginia | 54061 | 4668 | 13 |
848924 | 848924 | 2020-12-20 | Monroe | West Virginia | 54063 | 542 | 11 |
848925 | 848925 | 2020-12-20 | Morgan | West Virginia | 54065 | 534 | 8 |
848926 | 848926 | 2020-12-20 | Nicholas | West Virginia | 54067 | 566 | 6 |
848927 | 848927 | 2020-12-20 | Ohio | West Virginia | 54069 | 2214 | 31 |
848928 | 848928 | 2020-12-20 | Pendleton | West Virginia | 54071 | 221 | 1 |
848929 | 848929 | 2020-12-20 | Pleasants | West Virginia | 54073 | 285 | 5 |
848930 | 848930 | 2020-12-20 | Pocahontas | West Virginia | 54075 | 315 | 5 |
848931 | 848931 | 2020-12-20 | Preston | West Virginia | 54077 | 1296 | 19 |
848932 | 848932 | 2020-12-20 | Putnam | West Virginia | 54079 | 2643 | 52 |
848933 | 848933 | 2020-12-20 | Raleigh | West Virginia | 54081 | 2327 | 25 |
848934 | 848934 | 2020-12-20 | Randolph | West Virginia | 54083 | 983 | 4 |
848935 | 848935 | 2020-12-20 | Ritchie | West Virginia | 54085 | 287 | 6 |
848936 | 848936 | 2020-12-20 | Roane | West Virginia | 54087 | 253 | 5 |
848937 | 848937 | 2020-12-20 | Summers | West Virginia | 54089 | 358 | 12 |
848938 | 848938 | 2020-12-20 | Taylor | West Virginia | 54091 | 572 | 11 |
848939 | 848939 | 2020-12-20 | Tucker | West Virginia | 54093 | 271 | 1 |
848940 | 848940 | 2020-12-20 | Tyler | West Virginia | 54095 | 282 | 2 |
848941 | 848941 | 2020-12-20 | Upshur | West Virginia | 54097 | 710 | 4 |
848942 | 848942 | 2020-12-20 | Wayne | West Virginia | 54099 | 1481 | 18 |
848943 | 848943 | 2020-12-20 | Webster | West Virginia | 54101 | 121 | 0 |
848944 | 848944 | 2020-12-20 | Wetzel | West Virginia | 54103 | 588 | 16 |
848945 | 848945 | 2020-12-20 | Wirt | West Virginia | 54105 | 175 | 1 |
848946 | 848946 | 2020-12-20 | Wood | West Virginia | 54107 | 4163 | 37 |
848947 | 848947 | 2020-12-20 | Wyoming | West Virginia | 54109 | 1015 | 16 |
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);