legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
19,135 rows where party = "Republican" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, how, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25111 | 25111 | Fred Aandahl A000001 | rep | ND | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
2373 | 2373 | Joel Abbott A000003 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2374 | 2374 | Joel Abbott A000003 | rep | GA | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2375 | 2375 | Joel Abbott A000003 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2376 | 2376 | Joel Abbott A000003 | rep | GA | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
8493 | 8493 | Joseph Abbott A000006 | sen | NC | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
6971 | 6971 | Nehemiah Abbott A000008 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 3 | |||||||||||||
32430 | 32430 | James Abdnor A000009 | rep | SD | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
32431 | 32431 | James Abdnor A000009 | rep | SD | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
32432 | 32432 | James Abdnor A000009 | rep | SD | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
32433 | 32433 | James Abdnor A000009 | rep | SD | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32434 | 32434 | James Abdnor A000009 | sen | SD | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
25846 | 25846 | Hazel Abel A000010 | sen | NE | 1954-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
27602 | 27602 | Homer Abele A000011 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
14962 | 14962 | Ernest Acheson A000019 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 24 | |||||||||||||
14963 | 14963 | Ernest Acheson A000019 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 24 | |||||||||||||
14964 | 14964 | Ernest Acheson A000019 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
14965 | 14965 | Ernest Acheson A000019 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 24 | |||||||||||||
14966 | 14966 | Ernest Acheson A000019 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 24 | |||||||||||||
14967 | 14967 | Ernest Acheson A000019 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 24 | |||||||||||||
14968 | 14968 | Ernest Acheson A000019 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 24 | |||||||||||||
20073 | 20073 | Ernest Ackerman A000021 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
20074 | 20074 | Ernest Ackerman A000021 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
20075 | 20075 | Ernest Ackerman A000021 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20076 | 20076 | Ernest Ackerman A000021 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20077 | 20077 | Ernest Ackerman A000021 | rep | NJ | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
20078 | 20078 | Ernest Ackerman A000021 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20079 | 20079 | Ernest Ackerman A000021 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
29103 | 29103 | Edwin Adair A000024 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
29104 | 29104 | Edwin Adair A000024 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
29105 | 29105 | Edwin Adair A000024 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
29106 | 29106 | Edwin Adair A000024 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
29107 | 29107 | Edwin Adair A000024 | rep | IN | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29108 | 29108 | Edwin Adair A000024 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29109 | 29109 | Edwin Adair A000024 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29110 | 29110 | Edwin Adair A000024 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29111 | 29111 | Edwin Adair A000024 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
29112 | 29112 | Edwin Adair A000024 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
3284 | 3284 | John Adair A000026 | sen | KY | 1805-12-02 | 1807-03-03 | 3 | Republican | |||||||||||||
7648 | 7648 | Charles Adams A000032 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7649 | 7649 | Charles Adams A000032 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
9441 | 9441 | Charles Adams A000033 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 16 | |||||||||||||
11555 | 11555 | George Adams A000034 | rep | IL | 1883-12-03 | 1885-03-03 | Republican | 4 | |||||||||||||
11556 | 11556 | George Adams A000034 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
11557 | 11557 | George Adams A000034 | rep | IL | 1887-12-05 | 1889-03-03 | Republican | 4 | |||||||||||||
11558 | 11558 | George Adams A000034 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
14546 | 14546 | Henry Adams A000037 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14547 | 14547 | Henry Adams A000037 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
3592 | 3592 | John Adams A000038 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
14548 | 14548 | Robert Adams A000044 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
14549 | 14549 | Robert Adams A000044 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
14550 | 14550 | Robert Adams A000044 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
14551 | 14551 | Robert Adams A000044 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14552 | 14552 | Robert Adams A000044 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14553 | 14553 | Robert Adams A000044 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14554 | 14554 | Robert Adams A000044 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
23764 | 23764 | Sherman Adams A000046 | rep | NH | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
12394 | 12394 | Silas Adams A000047 | rep | KY | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
41904 | 41904 | Robert Aderholt A000055 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
41905 | 41905 | Robert Aderholt A000055 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
41906 | 41906 | Robert Aderholt A000055 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
41907 | 41907 | Robert Aderholt A000055 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/aderholt | ||||||||||||
41908 | 41908 | Robert Aderholt A000055 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/aderholt | ||||||||||||
41909 | 41909 | Robert Aderholt A000055 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 4 | http://aderholt.house.gov | ||||||||||||
41910 | 41910 | Robert Aderholt A000055 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 4 | http://aderholt.house.gov | ||||||||||||
41911 | 41911 | Robert Aderholt A000055 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 4 | http://aderholt.house.gov | 2264 Rayburn HOB; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | http://aderholt.house.gov/?sectionid=195&sectiontree=195 | 2264 Rayburn House Office Building | |||||||
41912 | 41912 | Robert Aderholt A000055 | rep | AL | 2013-01-03 | 2015-01-03 | Republican | 4 | http://aderholt.house.gov | 2369 Rayburn HOB; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | http://aderholt.house.gov/email-me2/ | 2369 Rayburn House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||
41913 | 41913 | Robert Aderholt A000055 | rep | AL | 2015-01-06 | 2017-01-03 | Republican | 4 | https://aderholt.house.gov | 235 Cannon HOB; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | http://aderholt.house.gov/email-me2/ | 235 Cannon House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||
41914 | 41914 | Robert Aderholt A000055 | rep | AL | 2017-01-03 | 2019-01-03 | Republican | 4 | https://aderholt.house.gov | 235 Cannon House Office Building; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | 235 Cannon House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | |||||||
41915 | 41915 | Robert Aderholt A000055 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 4 | https://aderholt.house.gov | 1203 Longworth House Office Building Washington DC 20515-0104 | 202-225-4876 | 1203 Longworth House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||||
41916 | 41916 | Robert Aderholt A000055 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 4 | https://aderholt.house.gov | 266 Cannon House Office Building Washington DC 20515-0104 | 202-225-4876 | 266 Cannon House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||||
1447 | 1447 | Asa Adgate A000056 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
20080 | 20080 | Charles Adkins A000057 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 19 | |||||||||||||
20081 | 20081 | Charles Adkins A000057 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 19 | |||||||||||||
20082 | 20082 | Charles Adkins A000057 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
20083 | 20083 | Charles Adkins A000057 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 19 | |||||||||||||
29113 | 29113 | George Aiken A000062 | sen | VT | 1941-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
29114 | 29114 | George Aiken A000062 | sen | VT | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
29115 | 29115 | George Aiken A000062 | sen | VT | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
29116 | 29116 | George Aiken A000062 | sen | VT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
29117 | 29117 | George Aiken A000062 | sen | VT | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
29118 | 29118 | George Aiken A000062 | sen | VT | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
16249 | 16249 | William Ainey A000065 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 14 | |||||||||||||
16250 | 16250 | William Ainey A000065 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 14 | |||||||||||||
12891 | 12891 | David Aitken A000068 | rep | MI | 1893-08-07 | 1895-03-03 | Republican | 6 | |||||||||||||
12892 | 12892 | David Aitken A000068 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
22020 | 22020 | Walter Albaugh A000072 | rep | OH | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
9071 | 9071 | William Albert A000074 | rep | MD | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9072 | 9072 | Charles Albright A000077 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
8799 | 8799 | James Alcorn A000079 | sen | MS | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
7650 | 7650 | Cyrus Aldrich A000081 | rep | MN | 1859-12-05 | 1861-03-03 | Republican | -1 | |||||||||||||
7651 | 7651 | Cyrus Aldrich A000081 | rep | MN | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
12893 | 12893 | James Aldrich A000082 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
12894 | 12894 | James Aldrich A000082 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
14555 | 14555 | Nelson Aldrich A000083 | rep | RI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
14556 | 14556 | Nelson Aldrich A000083 | rep | RI | 1881-03-04 | 1881-10-04 | Republican | 1 | |||||||||||||
14557 | 14557 | Nelson Aldrich A000083 | sen | RI | 1881-10-05 | 1887-03-03 | 1 | Republican | |||||||||||||
14558 | 14558 | Nelson Aldrich A000083 | sen | RI | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
14559 | 14559 | Nelson Aldrich A000083 | sen | RI | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
14560 | 14560 | Nelson Aldrich A000083 | sen | RI | 1899-12-04 | 1905-03-03 | 1 | Republican |
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);