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-07-07 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 |
---|---|---|---|---|---|---|---|
1494880 | 1494880 | 2021-07-07 | Barbour | West Virginia | 54001 | 1515 | 32 |
1494881 | 1494881 | 2021-07-07 | Berkeley | West Virginia | 54003 | 12864 | 132 |
1494882 | 1494882 | 2021-07-07 | Boone | West Virginia | 54005 | 2180 | 36 |
1494883 | 1494883 | 2021-07-07 | Braxton | West Virginia | 54007 | 1020 | 4 |
1494884 | 1494884 | 2021-07-07 | Brooke | West Virginia | 54009 | 2249 | 60 |
1494885 | 1494885 | 2021-07-07 | Cabell | West Virginia | 54011 | 8894 | 178 |
1494886 | 1494886 | 2021-07-07 | Calhoun | West Virginia | 54013 | 396 | 1 |
1494887 | 1494887 | 2021-07-07 | Clay | West Virginia | 54015 | 543 | 11 |
1494888 | 1494888 | 2021-07-07 | Doddridge | West Virginia | 54017 | 646 | 6 |
1494889 | 1494889 | 2021-07-07 | Fayette | West Virginia | 54019 | 3560 | 80 |
1494890 | 1494890 | 2021-07-07 | Gilmer | West Virginia | 54021 | 888 | 7 |
1494891 | 1494891 | 2021-07-07 | Grant | West Virginia | 54023 | 1317 | 28 |
1494892 | 1494892 | 2021-07-07 | Greenbrier | West Virginia | 54025 | 2903 | 64 |
1494893 | 1494893 | 2021-07-07 | Hampshire | West Virginia | 54027 | 1928 | 36 |
1494894 | 1494894 | 2021-07-07 | Hancock | West Virginia | 54029 | 2845 | 89 |
1494895 | 1494895 | 2021-07-07 | Hardy | West Virginia | 54031 | 1587 | 24 |
1494896 | 1494896 | 2021-07-07 | Harrison | West Virginia | 54033 | 6211 | 81 |
1494897 | 1494897 | 2021-07-07 | Jackson | West Virginia | 54035 | 2265 | 61 |
1494898 | 1494898 | 2021-07-07 | Jefferson | West Virginia | 54037 | 4806 | 59 |
1494899 | 1494899 | 2021-07-07 | Kanawha | West Virginia | 54039 | 15507 | 358 |
1494900 | 1494900 | 2021-07-07 | Lewis | West Virginia | 54041 | 1301 | 22 |
1494901 | 1494901 | 2021-07-07 | Lincoln | West Virginia | 54043 | 1607 | 24 |
1494902 | 1494902 | 2021-07-07 | Logan | West Virginia | 54045 | 3305 | 96 |
1494903 | 1494903 | 2021-07-07 | Marion | West Virginia | 54049 | 4660 | 52 |
1494904 | 1494904 | 2021-07-07 | Marshall | West Virginia | 54051 | 3540 | 79 |
1494905 | 1494905 | 2021-07-07 | Mason | West Virginia | 54053 | 2064 | 37 |
1494906 | 1494906 | 2021-07-07 | McDowell | West Virginia | 54047 | 1616 | 26 |
1494907 | 1494907 | 2021-07-07 | Mercer | West Virginia | 54055 | 5201 | 128 |
1494908 | 1494908 | 2021-07-07 | Mineral | West Virginia | 54057 | 2993 | 92 |
1494909 | 1494909 | 2021-07-07 | Mingo | West Virginia | 54059 | 2774 | 43 |
1494910 | 1494910 | 2021-07-07 | Monongalia | West Virginia | 54061 | 9400 | 90 |
1494911 | 1494911 | 2021-07-07 | Monroe | West Virginia | 54063 | 1226 | 17 |
1494912 | 1494912 | 2021-07-07 | Morgan | West Virginia | 54065 | 1231 | 23 |
1494913 | 1494913 | 2021-07-07 | Nicholas | West Virginia | 54067 | 1908 | 22 |
1494914 | 1494914 | 2021-07-07 | Ohio | West Virginia | 54069 | 4319 | 87 |
1494915 | 1494915 | 2021-07-07 | Pendleton | West Virginia | 54071 | 725 | 11 |
1494916 | 1494916 | 2021-07-07 | Pleasants | West Virginia | 54073 | 959 | 12 |
1494917 | 1494917 | 2021-07-07 | Pocahontas | West Virginia | 54075 | 683 | 12 |
1494918 | 1494918 | 2021-07-07 | Preston | West Virginia | 54077 | 2965 | 46 |
1494919 | 1494919 | 2021-07-07 | Putnam | West Virginia | 54079 | 5336 | 93 |
1494920 | 1494920 | 2021-07-07 | Raleigh | West Virginia | 54081 | 7103 | 98 |
1494921 | 1494921 | 2021-07-07 | Randolph | West Virginia | 54083 | 2863 | 15 |
1494922 | 1494922 | 2021-07-07 | Ritchie | West Virginia | 54085 | 762 | 11 |
1494923 | 1494923 | 2021-07-07 | Roane | West Virginia | 54087 | 665 | 9 |
1494924 | 1494924 | 2021-07-07 | Summers | West Virginia | 54089 | 865 | 22 |
1494925 | 1494925 | 2021-07-07 | Taylor | West Virginia | 54091 | 1285 | 25 |
1494926 | 1494926 | 2021-07-07 | Tucker | West Virginia | 54093 | 547 | 10 |
1494927 | 1494927 | 2021-07-07 | Tyler | West Virginia | 54095 | 749 | 13 |
1494928 | 1494928 | 2021-07-07 | Upshur | West Virginia | 54097 | 1975 | 34 |
1494929 | 1494929 | 2021-07-07 | Wayne | West Virginia | 54099 | 3183 | 44 |
1494930 | 1494930 | 2021-07-07 | Webster | West Virginia | 54101 | 547 | 8 |
1494931 | 1494931 | 2021-07-07 | Wetzel | West Virginia | 54103 | 1394 | 32 |
1494932 | 1494932 | 2021-07-07 | Wirt | West Virginia | 54105 | 457 | 4 |
1494933 | 1494933 | 2021-07-07 | Wood | West Virginia | 54107 | 7954 | 176 |
1494934 | 1494934 | 2021-07-07 | Wyoming | West Virginia | 54109 | 2060 | 41 |
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);