legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,350 rows where class = 2 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: party, state_rank, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8493 | 8493 | Joseph Abbott A000006 | sen | NC | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
25846 | 25846 | Hazel Abel A000010 | sen | NE | 1954-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
30137 | 30137 | James Abourezk A000017 | sen | SD | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
3277 | 3277 | Robert Adams A000043 | sen | MS | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
8799 | 8799 | James Alcorn A000079 | sen | MS | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
14224 | 14224 | Russell Alger A000107 | sen | MI | 1902-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
37227 | 37227 | Wayne Allard A000109 | sen | CO | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37228 | 37228 | Wayne Allard A000109 | sen | CO | 2003-01-07 | 2009-01-03 | 2 | Republican | http://allard.senate.gov | ||||||||||||
14226 | 14226 | James Allee A000110 | sen | DE | 1903-11-09 | 1907-03-03 | 2 | Republican | |||||||||||||
6488 | 6488 | Philip Allen A000141 | sen | RI | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
28754 | 28754 | Gordon Allott A000161 | sen | CO | 1955-01-05 | 1961-01-03 | 2 | Republican | |||||||||||||
28755 | 28755 | Gordon Allott A000161 | sen | CO | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28756 | 28756 | Gordon Allott A000161 | sen | CO | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
4646 | 4646 | Alexander Anderson A000181 | sen | TN | 1840-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
28760 | 28760 | Clinton Anderson A000186 | sen | NM | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28761 | 28761 | Clinton Anderson A000186 | sen | NM | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
28762 | 28762 | Clinton Anderson A000186 | sen | NM | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28763 | 28763 | Clinton Anderson A000186 | sen | NM | 1967-01-10 | 1973-01-03 | 2 | Democrat | |||||||||||||
940 | 940 | Joseph Anderson A000197 | sen | TN | 1797-05-15 | 1799-03-03 | 2 | Republican | |||||||||||||
31411 | 31411 | Wendell Anderson A000202 | sen | MN | 1976-12-30 | 1978-12-29 | 2 | Democrat | appointment | ||||||||||||
33228 | 33228 | William Armstrong A000219 | sen | CO | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
33229 | 33229 | William Armstrong A000219 | sen | CO | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
10624 | 10624 | Henry Anthony A000262 | sen | RI | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
10625 | 10625 | Henry Anthony A000262 | sen | RI | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
10626 | 10626 | Henry Anthony A000262 | sen | RI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10627 | 10627 | Henry Anthony A000262 | sen | RI | 1877-10-15 | 1883-03-03 | 2 | Republican | |||||||||||||
10628 | 10628 | Henry Anthony A000262 | sen | RI | 1883-12-03 | 1885-03-03 | 2 | Republican | |||||||||||||
4675 | 4675 | William Archer A000275 | sen | VA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5601 | 5601 | Chester Ashley A000311 | sen | AR | 1844-01-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5602 | 5602 | Chester Ashley A000311 | sen | AR | 1847-12-06 | 1849-03-03 | 2 | Democrat | |||||||||||||
6498 | 6498 | Charles Atherton A000323 | sen | NH | 1853-12-05 | 1853-12-31 | 2 | Democrat | |||||||||||||
41259 | 41259 | Lamar Alexander A000360 | sen | TN | 2003-01-07 | 2009-01-03 | 2 | Republican | http://alexander.senate.gov/ | ||||||||||||
41260 | 41260 | Lamar Alexander A000360 | sen | TN | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.alexander.senate.gov | 455 Dirksen Senate Office Building Washington DC 20510 | 202-224-4944 | 202-228-3398 | http://www.alexander.senate.gov/public/index.cfm?p=Email | 455 Dirksen Senate Office Building | senior | http://www.alexander.senate.gov/public/?a=rss.feed | |||||
41261 | 41261 | Lamar Alexander A000360 | sen | TN | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.alexander.senate.gov/public | 455 Dirksen Senate Office Building Washington DC 20510 | 202-224-4944 | 202-228-3398 | http://www.alexander.senate.gov/public/index.cfm?p=Email | 455 Dirksen Senate Office Building | senior | http://www.alexander.senate.gov/public/?a=rss.feed | |||||
21105 | 21105 | Nathan Bachman B000010 | sen | TN | 1933-03-09 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
16256 | 16256 | Augustus Bacon B000014 | sen | GA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
16257 | 16257 | Augustus Bacon B000014 | sen | GA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16258 | 16258 | Augustus Bacon B000014 | sen | GA | 1907-12-02 | 1913-03-03 | 2 | Democrat | |||||||||||||
16259 | 16259 | Augustus Bacon B000014 | sen | GA | 1913-04-07 | 1915-03-03 | 2 | Democrat | |||||||||||||
14974 | 14974 | Joseph Bailey B000044 | sen | TX | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14975 | 14975 | Joseph Bailey B000044 | sen | TX | 1907-12-02 | 1913-03-03 | 2 | Democrat | |||||||||||||
23341 | 23341 | Josiah Bailey B000046 | sen | NC | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
23342 | 23342 | Josiah Bailey B000046 | sen | NC | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23343 | 23343 | Josiah Bailey B000046 | sen | NC | 1943-01-06 | 1947-01-03 | 2 | Democrat | |||||||||||||
17520 | 17520 | David Baird B000052 | sen | NJ | 1918-02-23 | 1919-03-03 | 2 | Republican | appointment | ||||||||||||
19572 | 19572 | David Baird B000053 | sen | NJ | 1929-11-30 | 1931-03-03 | 2 | Republican | appointment | ||||||||||||
3278 | 3278 | David Baker B000058 | sen | IL | 1830-01-01 | 1831-03-03 | 2 | Jackson | |||||||||||||
7644 | 7644 | Edward Baker B000059 | sen | OR | 1860-01-01 | 1861-12-31 | 2 | Republican | |||||||||||||
31943 | 31943 | Howard Baker B000063 | sen | TN | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
31944 | 31944 | Howard Baker B000063 | sen | TN | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
31945 | 31945 | Howard Baker B000063 | sen | TN | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
12908 | 12908 | Lucien Baker B000070 | sen | KS | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
661 | 661 | Abraham Baldwin B000084 | sen | GA | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
662 | 662 | Abraham Baldwin B000084 | sen | GA | 1805-12-02 | 1807-03-04 | 2 | Republican | |||||||||||||
23344 | 23344 | Joseph Ball B000099 | sen | MN | 1940-10-14 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
23345 | 23345 | Joseph Ball B000099 | sen | MN | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
17545 | 17545 | Lewis Ball B000100 | sen | DE | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17556 | 17556 | John Bankhead B000110 | sen | AL | 1907-12-02 | 1913-03-03 | 2 | Democrat | |||||||||||||
17557 | 17557 | John Bankhead B000110 | sen | AL | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17558 | 17558 | John Bankhead B000110 | sen | AL | 1919-05-19 | 1921-03-03 | 2 | Democrat | |||||||||||||
23346 | 23346 | John Bankhead B000111 | sen | AL | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
23347 | 23347 | John Bankhead B000111 | sen | AL | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23348 | 23348 | John Bankhead B000111 | sen | AL | 1943-01-06 | 1947-01-03 | 2 | Democrat | |||||||||||||
11588 | 11588 | John Barbour B000129 | sen | VA | 1889-12-02 | 1893-03-03 | 2 | Democrat | |||||||||||||
22856 | 22856 | William Barbour B000132 | sen | NJ | 1931-12-07 | 1937-01-03 | 2 | Republican | appointment | ||||||||||||
25878 | 25878 | Alben Barkley B000145 | sen | KY | 1955-01-05 | 1956-04-30 | 2 | Democrat | |||||||||||||
6182 | 6182 | Robert Barnwell B000168 | sen | SC | 1850-01-01 | 1851-03-03 | 2 | Democrat | |||||||||||||
4685 | 4685 | Alexander Barrow B000183 | sen | LA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
10620 | 10620 | Middleton Barrow B000184 | sen | GA | 1882-01-01 | 1883-03-03 | 2 | Democrat | |||||||||||||
1435 | 1435 | William Barry B000192 | sen | KY | 1814-01-01 | 1817-03-03 | 2 | Republican | |||||||||||||
30160 | 30160 | Dewey Bartlett B000200 | sen | OK | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
28779 | 28779 | Edward Bartlett B000201 | sen | AK | 1959-01-07 | 1961-01-03 | 2 | Democrat | |||||||||||||
28780 | 28780 | Edward Bartlett B000201 | sen | AK | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28781 | 28781 | Edward Bartlett B000201 | sen | AK | 1967-01-10 | 1968-12-11 | 2 | Democrat | |||||||||||||
28307 | 28307 | Ross Bass B000223 | sen | TN | 1964-11-04 | 1967-01-03 | 2 | Democrat | |||||||||||||
1 | 1 | Richard Bassett B000226 | sen | DE | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
4691 | 4691 | Isaac Bates B000233 | sen | MA | 1841-05-31 | 1845-12-31 | 2 | Whig | |||||||||||||
6975 | 6975 | Martin Bates B000238 | sen | DE | 1857-12-07 | 1859-03-03 | 2 | Democrat | |||||||||||||
39659 | 39659 | Max Baucus B000243 | sen | MT | 1978-12-15 | 1979-01-03 | 2 | Democrat | |||||||||||||
39660 | 39660 | Max Baucus B000243 | sen | MT | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
39661 | 39661 | Max Baucus B000243 | sen | MT | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
39662 | 39662 | Max Baucus B000243 | sen | MT | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
39663 | 39663 | Max Baucus B000243 | sen | MT | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
39664 | 39664 | Max Baucus B000243 | sen | MT | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://baucus.senate.gov | ||||||||||||
39665 | 39665 | Max Baucus B000243 | sen | MT | 2009-01-06 | 2014-02-06 | 2 | Democrat | http://www.baucus.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-2651 | 202-224-0515 | http://www.baucus.senate.gov/contact/emailForm.cfm?subj=issue | 511 Hart Senate Office Building | senior | http://baucus.senate.gov/rss/?p=news | |||||
1104 | 1104 | James Bayard B000249 | sen | DE | 1804-11-13 | 1805-03-03 | 2 | Federalist | |||||||||||||
1105 | 1105 | James Bayard B000249 | sen | DE | 1805-03-04 | 1811-03-03 | 2 | Federalist | |||||||||||||
1106 | 1106 | James Bayard B000249 | sen | DE | 1811-11-04 | 1813-03-03 | 2 | Federalist | |||||||||||||
11603 | 11603 | James Beck B000289 | sen | KY | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
11604 | 11604 | James Beck B000289 | sen | KY | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11605 | 11605 | James Beck B000289 | sen | KY | 1889-12-02 | 1891-03-03 | 2 | Democrat | |||||||||||||
6510 | 6510 | John Bell B000340 | sen | TN | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
6511 | 6511 | John Bell B000340 | sen | TN | 1853-12-05 | 1859-03-03 | 2 | American | |||||||||||||
3053 | 3053 | Samuel Bell B000345 | sen | NH | 1823-12-01 | 1829-03-03 | 2 | Adams | |||||||||||||
3054 | 3054 | Samuel Bell B000345 | sen | NH | 1829-12-07 | 1835-03-03 | 2 | ||||||||||||||
17521 | 17521 | Christie Benet B000360 | sen | SC | 1918-07-06 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
7290 | 7290 | Judah Benjamin B000365 | sen | LA | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7291 | 7291 | Judah Benjamin B000365 | sen | LA | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
14958 | 14958 | Alfred Benson B000386 | sen | KS | 1906-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
21640 | 21640 | Elmer Benson B000389 | sen | MN | 1935-12-27 | 1937-01-03 | 2 | Farmer-Labor | appointment |
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);