ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

15,781 rows where state = "West Virginia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • West Virginia · 15,781 ✖
Link rowid date ▲ county state fips cases deaths
939839 939839 2021-01-17 Barbour West Virginia 54001 998 15
939840 939840 2021-01-17 Berkeley West Virginia 54003 7982 67
939841 939841 2021-01-17 Boone West Virginia 54005 1285 28
939842 939842 2021-01-17 Braxton West Virginia 54007 686 1
939843 939843 2021-01-17 Brooke West Virginia 54009 1741 45
939844 939844 2021-01-17 Cabell West Virginia 54011 6410 130
939845 939845 2021-01-17 Calhoun West Virginia 54013 188 0
939846 939846 2021-01-17 Clay West Virginia 54015 299 4
939847 939847 2021-01-17 Doddridge West Virginia 54017 363 4
939848 939848 2021-01-17 Fayette West Virginia 54019 2151 57
939849 939849 2021-01-17 Gilmer West Virginia 54021 532 6
939850 939850 2021-01-17 Grant West Virginia 54023 919 19
939851 939851 2021-01-17 Greenbrier West Virginia 54025 2037 45
939852 939852 2021-01-17 Hampshire West Virginia 54027 1228 24
939853 939853 2021-01-17 Hancock West Virginia 54029 2317 74
939854 939854 2021-01-17 Hardy West Virginia 54031 1083 14
939855 939855 2021-01-17 Harrison West Virginia 54033 3971 43
939856 939856 2021-01-17 Jackson West Virginia 54035 1467 42
939857 939857 2021-01-17 Jefferson West Virginia 54037 2981 29
939858 939858 2021-01-17 Kanawha West Virginia 54039 10239 240
939859 939859 2021-01-17 Lewis West Virginia 54041 719 11
939860 939860 2021-01-17 Lincoln West Virginia 54043 1021 9
939861 939861 2021-01-17 Logan West Virginia 54045 2111 65
939862 939862 2021-01-17 Marion West Virginia 54049 2843 23
939863 939863 2021-01-17 Marshall West Virginia 54051 2538 59
939864 939864 2021-01-17 Mason West Virginia 54053 1325 26
939865 939865 2021-01-17 McDowell West Virginia 54047 1135 8
939866 939866 2021-01-17 Mercer West Virginia 54055 3675 72
939867 939867 2021-01-17 Mineral West Virginia 54057 2313 72
939868 939868 2021-01-17 Mingo West Virginia 54059 1757 20
939869 939869 2021-01-17 Monongalia West Virginia 54061 6432 53
939870 939870 2021-01-17 Monroe West Virginia 54063 796 11
939871 939871 2021-01-17 Morgan West Virginia 54065 813 9
939872 939872 2021-01-17 Nicholas West Virginia 54067 935 9
939873 939873 2021-01-17 Ohio West Virginia 54069 3037 57
939874 939874 2021-01-17 Pendleton West Virginia 54071 459 3
939875 939875 2021-01-17 Pleasants West Virginia 54073 710 11
939876 939876 2021-01-17 Pocahontas West Virginia 54075 509 9
939877 939877 2021-01-17 Preston West Virginia 54077 2213 34
939878 939878 2021-01-17 Putnam West Virginia 54079 3496 63
939879 939879 2021-01-17 Raleigh West Virginia 54081 3611 38
939880 939880 2021-01-17 Randolph West Virginia 54083 1929 8
939881 939881 2021-01-17 Ritchie West Virginia 54085 494 8
939882 939882 2021-01-17 Roane West Virginia 54087 399 6
939883 939883 2021-01-17 Summers West Virginia 54089 629 19
939884 939884 2021-01-17 Taylor West Virginia 54091 891 13
939885 939885 2021-01-17 Tucker West Virginia 54093 417 6
939886 939886 2021-01-17 Tyler West Virginia 54095 488 3
939887 939887 2021-01-17 Upshur West Virginia 54097 1268 17
939888 939888 2021-01-17 Wayne West Virginia 54099 2100 26
939889 939889 2021-01-17 Webster West Virginia 54101 219 0
939890 939890 2021-01-17 Wetzel West Virginia 54103 881 17
939891 939891 2021-01-17 Wirt West Virginia 54105 291 1
939892 939892 2021-01-17 Wood West Virginia 54107 6070 79
939893 939893 2021-01-17 Wyoming West Virginia 54109 1420 24
936594 936594 2021-01-16 Barbour West Virginia 54001 987 15
936595 936595 2021-01-16 Berkeley West Virginia 54003 7920 66
936596 936596 2021-01-16 Boone West Virginia 54005 1282 28
936597 936597 2021-01-16 Braxton West Virginia 54007 674 1
936598 936598 2021-01-16 Brooke West Virginia 54009 1735 43
936599 936599 2021-01-16 Cabell West Virginia 54011 6383 130
936600 936600 2021-01-16 Calhoun West Virginia 54013 187 0
936601 936601 2021-01-16 Clay West Virginia 54015 300 4
936602 936602 2021-01-16 Doddridge West Virginia 54017 342 4
936603 936603 2021-01-16 Fayette West Virginia 54019 2143 56
936604 936604 2021-01-16 Gilmer West Virginia 54021 531 6
936605 936605 2021-01-16 Grant West Virginia 54023 916 19
936606 936606 2021-01-16 Greenbrier West Virginia 54025 2024 45
936607 936607 2021-01-16 Hampshire West Virginia 54027 1217 24
936608 936608 2021-01-16 Hancock West Virginia 54029 2291 74
936609 936609 2021-01-16 Hardy West Virginia 54031 1078 12
936610 936610 2021-01-16 Harrison West Virginia 54033 3935 43
936611 936611 2021-01-16 Jackson West Virginia 54035 1452 42
936612 936612 2021-01-16 Jefferson West Virginia 54037 2964 29
936613 936613 2021-01-16 Kanawha West Virginia 54039 10176 240
936614 936614 2021-01-16 Lewis West Virginia 54041 714 10
936615 936615 2021-01-16 Lincoln West Virginia 54043 1015 9
936616 936616 2021-01-16 Logan West Virginia 54045 2104 65
936617 936617 2021-01-16 Marion West Virginia 54049 2801 23
936618 936618 2021-01-16 Marshall West Virginia 54051 2534 57
936619 936619 2021-01-16 Mason West Virginia 54053 1316 26
936620 936620 2021-01-16 McDowell West Virginia 54047 1131 8
936621 936621 2021-01-16 Mercer West Virginia 54055 3663 72
936622 936622 2021-01-16 Mineral West Virginia 54057 2305 72
936623 936623 2021-01-16 Mingo West Virginia 54059 1735 20
936624 936624 2021-01-16 Monongalia West Virginia 54061 6401 52
936625 936625 2021-01-16 Monroe West Virginia 54063 793 11
936626 936626 2021-01-16 Morgan West Virginia 54065 811 9
936627 936627 2021-01-16 Nicholas West Virginia 54067 925 9
936628 936628 2021-01-16 Ohio West Virginia 54069 3025 56
936629 936629 2021-01-16 Pendleton West Virginia 54071 450 3
936630 936630 2021-01-16 Pleasants West Virginia 54073 710 11
936631 936631 2021-01-16 Pocahontas West Virginia 54075 501 9
936632 936632 2021-01-16 Preston West Virginia 54077 2206 34
936633 936633 2021-01-16 Putnam West Virginia 54079 3475 63
936634 936634 2021-01-16 Raleigh West Virginia 54081 3594 37
936635 936635 2021-01-16 Randolph West Virginia 54083 1921 8
936636 936636 2021-01-16 Ritchie West Virginia 54085 492 8
936637 936637 2021-01-16 Roane West Virginia 54087 393 6
936638 936638 2021-01-16 Summers West Virginia 54089 625 19

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);