legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
269 rows where party = "Democrat" and state = "WV"
This data as json, copyable, CSV (advanced)
Suggested facets: district, url, address, phone, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9148 | 9148 | John Davis D000119 | rep | WV | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9478 | 9478 | Allen Caperton C000130 | sen | WV | 1875-12-06 | 1877-03-03 | 1 | Democrat | |||||||||||||
9726 | 9726 | Samuel Price P000530 | sen | WV | 1876-01-01 | 1877-12-31 | 1 | Democrat | |||||||||||||
9782 | 9782 | Henry Davis D000103 | sen | WV | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9783 | 9783 | Henry Davis D000103 | sen | WV | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
9846 | 9846 | Frank Hereford H000527 | rep | WV | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9847 | 9847 | Frank Hereford H000527 | rep | WV | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9848 | 9848 | Frank Hereford H000527 | rep | WV | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9849 | 9849 | Frank Hereford H000527 | sen | WV | 1877-10-15 | 1881-03-03 | 1 | Democrat | |||||||||||||
10139 | 10139 | Benjamin Martin M000169 | rep | WV | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10140 | 10140 | Benjamin Martin M000169 | rep | WV | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10387 | 10387 | John Hoge H000696 | rep | WV | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
10597 | 10597 | Benjamin Wilson W000569 | rep | WV | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
10598 | 10598 | Benjamin Wilson W000569 | rep | WV | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10599 | 10599 | Benjamin Wilson W000569 | rep | WV | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10600 | 10600 | Benjamin Wilson W000569 | rep | WV | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
11048 | 11048 | Eustace Gibson G000160 | rep | WV | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
11049 | 11049 | Eustace Gibson G000160 | rep | WV | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11402 | 11402 | Charles Hogg H000701 | rep | WV | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
11511 | 11511 | Charles Snyder S000665 | rep | WV | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
11512 | 11512 | Charles Snyder S000665 | rep | WV | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11513 | 11513 | Charles Snyder S000665 | rep | WV | 1887-12-05 | 1889-03-03 | Democrat | 3 | |||||||||||||
11782 | 11782 | James Jackson J000018 | rep | WV | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
11799 | 11799 | John Kenna K000099 | rep | WV | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
11800 | 11800 | John Kenna K000099 | rep | WV | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
11801 | 11801 | John Kenna K000099 | rep | WV | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
11802 | 11802 | John Kenna K000099 | sen | WV | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11803 | 11803 | John Kenna K000099 | sen | WV | 1889-12-02 | 1893-12-31 | 2 | Democrat | |||||||||||||
12395 | 12395 | John Alderson A000080 | rep | WV | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12396 | 12396 | John Alderson A000080 | rep | WV | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12397 | 12397 | John Alderson A000080 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12467 | 12467 | Johnson Camden C000062 | sen | WV | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
12468 | 12468 | Johnson Camden C000062 | sen | WV | 1893-08-07 | 1895-03-03 | 2 | Democrat | |||||||||||||
12476 | 12476 | James Capehart C000129 | rep | WV | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12477 | 12477 | James Capehart C000129 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12541 | 12541 | Charles Faulkner F000045 | sen | WV | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12542 | 12542 | Charles Faulkner F000045 | sen | WV | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12755 | 12755 | John Pendleton P000205 | rep | WV | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12756 | 12756 | John Pendleton P000205 | rep | WV | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12757 | 12757 | John Pendleton P000205 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12858 | 12858 | William Wilson W000623 | rep | WV | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
12859 | 12859 | William Wilson W000623 | rep | WV | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
12860 | 12860 | William Wilson W000623 | rep | WV | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
12861 | 12861 | William Wilson W000623 | rep | WV | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12862 | 12862 | William Wilson W000623 | rep | WV | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12863 | 12863 | William Wilson W000623 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
13718 | 13718 | David Johnston J000186 | rep | WV | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
14631 | 14631 | Thomas Davis D000137 | rep | WV | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15889 | 15889 | William Chilton C000360 | sen | WV | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
15990 | 15990 | John Hamilton H000112 | rep | WV | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
16227 | 16227 | Clarence Watson W000198 | sen | WV | 1911-04-04 | 1913-03-03 | 2 | Democrat | |||||||||||||
16341 | 16341 | John Davis D000121 | rep | WV | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
16342 | 16342 | John Davis D000121 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16706 | 16706 | William Brown B000949 | rep | WV | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
16707 | 16707 | William Brown B000949 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16708 | 16708 | William Brown B000949 | rep | WV | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17338 | 17338 | Adam Littlepage L000358 | rep | WV | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
17339 | 17339 | Adam Littlepage L000358 | rep | WV | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17340 | 17340 | Adam Littlepage L000358 | rep | WV | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18563 | 18563 | Robert Allen A000144 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
18730 | 18730 | Thomas Lilly L000311 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
19119 | 19119 | James Taylor T000082 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19120 | 19120 | James Taylor T000082 | rep | WV | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
19442 | 19442 | William O’Brien O000018 | rep | WV | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
21322 | 21322 | Lynn Hornor H000792 | rep | WV | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21323 | 21323 | Lynn Hornor H000792 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21817 | 21817 | Rush Holt H000749 | sen | WV | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22977 | 22977 | Andrew Edmiston E000051 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22978 | 22978 | Andrew Edmiston E000051 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22979 | 22979 | Andrew Edmiston E000051 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22980 | 22980 | Andrew Edmiston E000051 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22981 | 22981 | Andrew Edmiston E000051 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23066 | 23066 | George Johnson J000132 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
23067 | 23067 | George Johnson J000132 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23068 | 23068 | George Johnson J000132 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23069 | 23069 | George Johnson J000132 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23070 | 23070 | George Johnson J000132 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23071 | 23071 | George Johnson J000132 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23206 | 23206 | Joseph Rosier R000443 | sen | WV | 1941-01-13 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23673 | 23673 | Joseph Smith S000580 | rep | WV | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
23674 | 23674 | Joseph Smith S000580 | rep | WV | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23675 | 23675 | Joseph Smith S000580 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
23676 | 23676 | Joseph Smith S000580 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
23677 | 23677 | Joseph Smith S000580 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23678 | 23678 | Joseph Smith S000580 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23679 | 23679 | Joseph Smith S000580 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23680 | 23680 | Joseph Smith S000580 | rep | WV | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
25312 | 25312 | Erland Hedrick H000442 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
25313 | 25313 | Erland Hedrick H000442 | rep | WV | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25314 | 25314 | Erland Hedrick H000442 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25315 | 25315 | Erland Hedrick H000442 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25338 | 25338 | John Kee K000039 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
25339 | 25339 | John Kee K000039 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
25340 | 25340 | John Kee K000039 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
25341 | 25341 | John Kee K000039 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
25342 | 25342 | John Kee K000039 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
25343 | 25343 | John Kee K000039 | rep | WV | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25344 | 25344 | John Kee K000039 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
25345 | 25345 | John Kee K000039 | rep | WV | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25346 | 25346 | John Kee K000039 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 5 |
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);