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

18,256 rows where state = "West Virginia" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

state

  • West Virginia · 18,256 ✖
Link rowid date ▲ county state fips cases deaths
1085812 1085812 2021-03-03 Barbour West Virginia 54001 1235 21
1085813 1085813 2021-03-03 Berkeley West Virginia 54003 9722 100
1085814 1085814 2021-03-03 Boone West Virginia 54005 1587 32
1085815 1085815 2021-03-03 Braxton West Virginia 54007 779 1
1085816 1085816 2021-03-03 Brooke West Virginia 54009 2015 50
1085817 1085817 2021-03-03 Cabell West Virginia 54011 7849 160
1085818 1085818 2021-03-03 Calhoun West Virginia 54013 230 0
1085819 1085819 2021-03-03 Clay West Virginia 54015 378 5
1085820 1085820 2021-03-03 Doddridge West Virginia 54017 468 6
1085821 1085821 2021-03-03 Fayette West Virginia 54019 2684 70
1085822 1085822 2021-03-03 Gilmer West Virginia 54021 715 8
1085823 1085823 2021-03-03 Grant West Virginia 54023 1073 26
1085824 1085824 2021-03-03 Greenbrier West Virginia 54025 2413 52
1085825 1085825 2021-03-03 Hampshire West Virginia 54027 1546 28
1085826 1085826 2021-03-03 Hancock West Virginia 54029 2599 86
1085827 1085827 2021-03-03 Hardy West Virginia 54031 1273 20
1085828 1085828 2021-03-03 Harrison West Virginia 54033 4854 70
1085829 1085829 2021-03-03 Jackson West Virginia 54035 1669 50
1085830 1085830 2021-03-03 Jefferson West Virginia 54037 3649 37
1085831 1085831 2021-03-03 Kanawha West Virginia 54039 12153 286
1085832 1085832 2021-03-03 Lewis West Virginia 54041 1046 18
1085833 1085833 2021-03-03 Lincoln West Virginia 54043 1230 13
1085834 1085834 2021-03-03 Logan West Virginia 54045 2707 76
1085835 1085835 2021-03-03 Marion West Virginia 54049 3689 34
1085836 1085836 2021-03-03 Marshall West Virginia 54051 3016 66
1085837 1085837 2021-03-03 Mason West Virginia 54053 1775 37
1085838 1085838 2021-03-03 McDowell West Virginia 54047 1351 20
1085839 1085839 2021-03-03 Mercer West Virginia 54055 4229 112
1085840 1085840 2021-03-03 Mineral West Virginia 54057 2594 77
1085841 1085841 2021-03-03 Mingo West Virginia 54059 2136 34
1085842 1085842 2021-03-03 Monongalia West Virginia 54061 8073 71
1085843 1085843 2021-03-03 Monroe West Virginia 54063 951 12
1085844 1085844 2021-03-03 Morgan West Virginia 54065 934 13
1085845 1085845 2021-03-03 Nicholas West Virginia 54067 1186 12
1085846 1085846 2021-03-03 Ohio West Virginia 54069 3652 67
1085847 1085847 2021-03-03 Pendleton West Virginia 54071 621 5
1085848 1085848 2021-03-03 Pleasants West Virginia 54073 802 17
1085849 1085849 2021-03-03 Pocahontas West Virginia 54075 596 9
1085850 1085850 2021-03-03 Preston West Virginia 54077 2548 43
1085851 1085851 2021-03-03 Putnam West Virginia 54079 4236 74
1085852 1085852 2021-03-03 Raleigh West Virginia 54081 4769 58
1085853 1085853 2021-03-03 Randolph West Virginia 54083 2398 10
1085854 1085854 2021-03-03 Ritchie West Virginia 54085 624 9
1085855 1085855 2021-03-03 Roane West Virginia 54087 500 7
1085856 1085856 2021-03-03 Summers West Virginia 54089 704 23
1085857 1085857 2021-03-03 Taylor West Virginia 54091 1093 21
1085858 1085858 2021-03-03 Tucker West Virginia 54093 503 9
1085859 1085859 2021-03-03 Tyler West Virginia 54095 619 4
1085860 1085860 2021-03-03 Upshur West Virginia 54097 1693 30
1085861 1085861 2021-03-03 Wayne West Virginia 54099 2624 31
1085862 1085862 2021-03-03 Webster West Virginia 54101 324 3
1085863 1085863 2021-03-03 Wetzel West Virginia 54103 1097 19
1085864 1085864 2021-03-03 Wirt West Virginia 54105 360 2
1085865 1085865 2021-03-03 Wood West Virginia 54107 7099 131
1085866 1085866 2021-03-03 Wyoming West Virginia 54109 1746 34
1082566 1082566 2021-03-02 Barbour West Virginia 54001 1227 21
1082567 1082567 2021-03-02 Berkeley West Virginia 54003 9699 99
1082568 1082568 2021-03-02 Boone West Virginia 54005 1583 31
1082569 1082569 2021-03-02 Braxton West Virginia 54007 777 1
1082570 1082570 2021-03-02 Brooke West Virginia 54009 2012 50
1082571 1082571 2021-03-02 Cabell West Virginia 54011 7825 160
1082572 1082572 2021-03-02 Calhoun West Virginia 54013 230 0
1082573 1082573 2021-03-02 Clay West Virginia 54015 376 5
1082574 1082574 2021-03-02 Doddridge West Virginia 54017 467 6
1082575 1082575 2021-03-02 Fayette West Virginia 54019 2677 70
1082576 1082576 2021-03-02 Gilmer West Virginia 54021 714 8
1082577 1082577 2021-03-02 Grant West Virginia 54023 1071 26
1082578 1082578 2021-03-02 Greenbrier West Virginia 54025 2434 52
1082579 1082579 2021-03-02 Hampshire West Virginia 54027 1538 28
1082580 1082580 2021-03-02 Hancock West Virginia 54029 2598 86
1082581 1082581 2021-03-02 Hardy West Virginia 54031 1270 20
1082582 1082582 2021-03-02 Harrison West Virginia 54033 4846 70
1082583 1082583 2021-03-02 Jackson West Virginia 54035 1669 50
1082584 1082584 2021-03-02 Jefferson West Virginia 54037 3638 37
1082585 1082585 2021-03-02 Kanawha West Virginia 54039 12134 285
1082586 1082586 2021-03-02 Lewis West Virginia 54041 1042 17
1082587 1082587 2021-03-02 Lincoln West Virginia 54043 1227 13
1082588 1082588 2021-03-02 Logan West Virginia 54045 2704 76
1082589 1082589 2021-03-02 Marion West Virginia 54049 3682 33
1082590 1082590 2021-03-02 Marshall West Virginia 54051 3016 66
1082591 1082591 2021-03-02 Mason West Virginia 54053 1770 36
1082592 1082592 2021-03-02 McDowell West Virginia 54047 1350 20
1082593 1082593 2021-03-02 Mercer West Virginia 54055 4228 112
1082594 1082594 2021-03-02 Mineral West Virginia 54057 2585 77
1082595 1082595 2021-03-02 Mingo West Virginia 54059 2132 34
1082596 1082596 2021-03-02 Monongalia West Virginia 54061 8054 70
1082597 1082597 2021-03-02 Monroe West Virginia 54063 951 12
1082598 1082598 2021-03-02 Morgan West Virginia 54065 933 13
1082599 1082599 2021-03-02 Nicholas West Virginia 54067 1183 12
1082600 1082600 2021-03-02 Ohio West Virginia 54069 3640 67
1082601 1082601 2021-03-02 Pendleton West Virginia 54071 621 5
1082602 1082602 2021-03-02 Pleasants West Virginia 54073 803 17
1082603 1082603 2021-03-02 Pocahontas West Virginia 54075 596 9
1082604 1082604 2021-03-02 Preston West Virginia 54077 2544 43
1082605 1082605 2021-03-02 Putnam West Virginia 54079 4228 74
1082606 1082606 2021-03-02 Raleigh West Virginia 54081 4717 58
1082607 1082607 2021-03-02 Randolph West Virginia 54083 2395 10
1082608 1082608 2021-03-02 Ritchie West Virginia 54085 622 9
1082609 1082609 2021-03-02 Roane West Virginia 54087 549 7
1082610 1082610 2021-03-02 Summers West Virginia 54089 703 23

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);