legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
156 rows where party = "Republican" and state = "WV"
This data as json, copyable, CSV (advanced)
Suggested facets: district, url, address, fax, contact_form, office, rss_url, start (date), end (date)
Link | rowid ▼ | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8051 | 8051 | Peter Van Winkle V000066 | sen | WV | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8235 | 8235 | Waitman Willey W000484 | sen | WV | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8363 | 8363 | Chester Hubbard H000879 | rep | WV | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8374 | 8374 | Bethuel Kitchen K000247 | rep | WV | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8428 | 8428 | Daniel Polsley P000418 | rep | WV | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8527 | 8527 | Arthur Boreman B000638 | sen | WV | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
8583 | 8583 | Isaac Duval D000576 | rep | WV | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8786 | 8786 | John Witcher W000656 | rep | WV | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8956 | 8956 | James McGrew M000461 | rep | WV | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8957 | 8957 | James McGrew M000461 | rep | WV | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9184 | 9184 | John Hagans H000011 | rep | WV | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
11571 | 11571 | George Atkinson A000330 | rep | WV | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11964 | 11964 | Charles Smith S000521 | rep | WV | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
13039 | 13039 | James Huling H000938 | rep | WV | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
13298 | 13298 | Charles Dorr D000436 | rep | WV | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13412 | 13412 | Warren Miller M000761 | rep | WV | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
13413 | 13413 | Warren Miller M000761 | rep | WV | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13668 | 13668 | Romeo Freer F000367 | rep | WV | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
14632 | 14632 | Alston Dayton D000163 | rep | WV | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
14633 | 14633 | Alston Dayton D000163 | rep | WV | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
14634 | 14634 | Alston Dayton D000163 | rep | WV | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14635 | 14635 | Alston Dayton D000163 | rep | WV | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14636 | 14636 | Alston Dayton D000163 | rep | WV | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14637 | 14637 | Alston Dayton D000163 | rep | WV | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14644 | 14644 | Blackburn Dovener D000461 | rep | WV | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
14645 | 14645 | Blackburn Dovener D000461 | rep | WV | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
14646 | 14646 | Blackburn Dovener D000461 | rep | WV | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14647 | 14647 | Blackburn Dovener D000461 | rep | WV | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14648 | 14648 | Blackburn Dovener D000461 | rep | WV | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14649 | 14649 | Blackburn Dovener D000461 | rep | WV | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14887 | 14887 | Nathan Scott S000182 | sen | WV | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14888 | 14888 | Nathan Scott S000182 | sen | WV | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15095 | 15095 | Stephen Elkins E000110 | sen | WV | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15096 | 15096 | Stephen Elkins E000110 | sen | WV | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15097 | 15097 | Stephen Elkins E000110 | sen | WV | 1907-12-02 | 1911-12-31 | 2 | Republican | |||||||||||||
15467 | 15467 | Joseph Gaines G000008 | rep | WV | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
15468 | 15468 | Joseph Gaines G000008 | rep | WV | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
15469 | 15469 | Joseph Gaines G000008 | rep | WV | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
15470 | 15470 | Joseph Gaines G000008 | rep | WV | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15471 | 15471 | Joseph Gaines G000008 | rep | WV | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
15537 | 15537 | William Hubbard H000891 | rep | WV | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15538 | 15538 | William Hubbard H000891 | rep | WV | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15766 | 15766 | George Sturgiss S001049 | rep | WV | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15767 | 15767 | George Sturgiss S001049 | rep | WV | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
16255 | 16255 | Samuel Avis A000348 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
16374 | 16374 | Nathan Goff G000255 | rep | WV | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
16375 | 16375 | Nathan Goff G000255 | rep | WV | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
16376 | 16376 | Nathan Goff G000255 | rep | WV | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
16377 | 16377 | Nathan Goff G000255 | sen | WV | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16896 | 16896 | Hunter Moss M001034 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
16897 | 16897 | Hunter Moss M001034 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17117 | 17117 | Edward Cooper C000748 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17118 | 17118 | Edward Cooper C000748 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17468 | 17468 | Howard Sutherland S001081 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
17469 | 17469 | Howard Sutherland S001081 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
17470 | 17470 | Howard Sutherland S001081 | sen | WV | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17656 | 17656 | Davis Elkins E000109 | sen | WV | 1911-04-04 | 1911-12-31 | 2 | Republican | |||||||||||||
17657 | 17657 | Davis Elkins E000109 | sen | WV | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18055 | 18055 | George Bowers B000690 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18056 | 18056 | George Bowers B000690 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18057 | 18057 | George Bowers B000690 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18058 | 18058 | George Bowers B000690 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18158 | 18158 | Leonard Echols E000030 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18159 | 18159 | Leonard Echols E000030 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18201 | 18201 | Wells Goodykoontz G000308 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18202 | 18202 | Wells Goodykoontz G000308 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18813 | 18813 | Stuart Reed R000127 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18814 | 18814 | Stuart Reed R000127 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18815 | 18815 | Stuart Reed R000127 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18816 | 18816 | Stuart Reed R000127 | rep | WV | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
18831 | 18831 | Benjamin Rosenbloom R000441 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18832 | 18832 | Benjamin Rosenbloom R000441 | rep | WV | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
18976 | 18976 | Guy Goff G000254 | sen | WV | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
19167 | 19167 | Harry Woodyard W000737 | rep | WV | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
19168 | 19168 | Harry Woodyard W000737 | rep | WV | 1905-12-04 | 1907-03-03 | Republican | 4 | |||||||||||||
19169 | 19169 | Harry Woodyard W000737 | rep | WV | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
19170 | 19170 | Harry Woodyard W000737 | rep | WV | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
19171 | 19171 | Harry Woodyard W000737 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
19172 | 19172 | Harry Woodyard W000737 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
19173 | 19173 | Harry Woodyard W000737 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
19174 | 19174 | Harry Woodyard W000737 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
19175 | 19175 | Harry Woodyard W000737 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19295 | 19295 | Edward England E000180 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19498 | 19498 | James Strother S001024 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
19499 | 19499 | James Strother S001024 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
19762 | 19762 | Henry Hatfield H000342 | sen | WV | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
19784 | 19784 | James Hughes H000924 | rep | WV | 1901-12-02 | 1903-03-03 | Republican | 4 | |||||||||||||
19785 | 19785 | James Hughes H000924 | rep | WV | 1903-11-09 | 1905-03-03 | Republican | 5 | |||||||||||||
19786 | 19786 | James Hughes H000924 | rep | WV | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
19787 | 19787 | James Hughes H000924 | rep | WV | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
19788 | 19788 | James Hughes H000924 | rep | WV | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
19789 | 19789 | James Hughes H000924 | rep | WV | 1911-04-04 | 1913-03-03 | Republican | 5 | |||||||||||||
19790 | 19790 | James Hughes H000924 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
19791 | 19791 | James Hughes H000924 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19792 | 19792 | James Hughes H000924 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20059 | 20059 | John Wolverton W000684 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20060 | 20060 | John Wolverton W000684 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20108 | 20108 | Carl Bachmann B000012 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20109 | 20109 | Carl Bachmann B000012 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20110 | 20110 | Carl Bachmann B000012 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);