legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,277 rows where class = 1 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5591 | 5591 | John Adams A000041 | sen | MA | 1803-10-17 | 1809-03-03 | 1 | Federalist | |||||||||||||
6467 | 6467 | Stephen Adams A000048 | sen | MS | 1852-01-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
39037 | 39037 | Daniel Akaka A000069 | sen | HI | 1990-05-16 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
39038 | 39038 | Daniel Akaka A000069 | sen | HI | 1995-01-04 | 2001-01-03 | 1 | Democrat | |||||||||||||
39039 | 39039 | Daniel Akaka A000069 | sen | HI | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://akaka.senate.gov | ||||||||||||
39040 | 39040 | Daniel Akaka A000069 | sen | HI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://akaka.senate.gov | 141 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6361 | 202-224-2126 | http://www.akaka.senate.gov/email-senator-akaka.cfm | 141 Hart Senate Office Building | |||||||
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 | |||||||||||||
14561 | 14561 | Nelson Aldrich A000083 | sen | RI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
36780 | 36780 | George Allen A000121 | sen | VA | 2001-01-03 | 2007-01-03 | 1 | Republican | http://allen.senate.gov | ||||||||||||
11562 | 11562 | John Allen A000130 | sen | WA | 1889-11-19 | 1893-03-03 | 1 | Republican | |||||||||||||
13556 | 13556 | William Allen A000153 | sen | NE | 1893-08-07 | 1899-03-03 | 1 | Populist | |||||||||||||
13557 | 13557 | William Allen A000153 | sen | NE | 1899-12-04 | 1901-12-31 | 1 | Populist | |||||||||||||
8790 | 8790 | Adelbert Ames A000172 | sen | MS | 1870-01-01 | 1875-03-03 | 1 | Republican | |||||||||||||
941 | 941 | Joseph Anderson A000197 | sen | TN | 1799-12-02 | 1803-03-03 | 1 | Republican | |||||||||||||
942 | 942 | Joseph Anderson A000197 | sen | TN | 1803-10-17 | 1809-03-03 | 1 | Republican | |||||||||||||
943 | 943 | Joseph Anderson A000197 | sen | TN | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
22847 | 22847 | Charles Andrews A000244 | sen | FL | 1936-11-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22848 | 22848 | Charles Andrews A000244 | sen | FL | 1941-01-03 | 1946-09-18 | 1 | Democrat | |||||||||||||
643 | 643 | John Armstrong A000282 | sen | NY | 1804-02-25 | 1804-06-30 | 1 | Republican | |||||||||||||
7894 | 7894 | Samuel Arnold A000295 | sen | RI | 1862-01-01 | 1863-03-03 | 1 | Republican | |||||||||||||
1778 | 1778 | Eli Ashmun A000317 | sen | MA | 1816-01-01 | 1819-03-03 | 1 | Federalist | |||||||||||||
21622 | 21622 | Henry Ashurst A000319 | sen | AZ | 1912-03-27 | 1917-03-03 | 1 | Democrat | |||||||||||||
21623 | 21623 | Henry Ashurst A000319 | sen | AZ | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21624 | 21624 | Henry Ashurst A000319 | sen | AZ | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
21625 | 21625 | Henry Ashurst A000319 | sen | AZ | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21626 | 21626 | Henry Ashurst A000319 | sen | AZ | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22852 | 22852 | Warren Austin A000342 | sen | VT | 1931-12-07 | 1935-01-03 | 1 | Republican | |||||||||||||
22853 | 22853 | Warren Austin A000342 | sen | VT | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
22854 | 22854 | Warren Austin A000342 | sen | VT | 1941-01-03 | 1946-08-02 | 1 | Republican | |||||||||||||
35679 | 35679 | Spencer Abraham A000355 | sen | MI | 1995-01-04 | 2001-01-03 | 1 | Republican | |||||||||||||
35680 | 35680 | John Ashcroft A000356 | sen | MO | 1995-01-04 | 2001-01-03 | 1 | Republican | |||||||||||||
9733 | 9733 | James Bailey B000039 | sen | TN | 1877-10-15 | 1881-03-03 | 1 | Democrat | |||||||||||||
557 | 557 | Theodorus Bailey B000049 | sen | NY | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
10000 | 10000 | Henry Baldwin B000089 | sen | MI | 1879-03-18 | 1881-03-03 | 1 | Republican | |||||||||||||
24231 | 24231 | Raymond Baldwin B000095 | sen | CT | 1946-12-27 | 1947-01-03 | 1 | Republican | |||||||||||||
24232 | 24232 | Raymond Baldwin B000095 | sen | CT | 1947-01-03 | 1949-12-16 | 1 | Republican | |||||||||||||
5606 | 5606 | Roger Baldwin B000096 | sen | CT | 1847-12-06 | 1851-03-03 | 1 | Whig | |||||||||||||
17544 | 17544 | Lewis Ball B000100 | sen | DE | 1903-11-09 | 1905-03-03 | 1 | Republican | |||||||||||||
2193 | 2193 | James Barbour B000127 | sen | VA | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2194 | 2194 | James Barbour B000127 | sen | VA | 1821-12-03 | 1825-12-31 | 1 | Republican | |||||||||||||
22857 | 22857 | William Barbour B000132 | sen | NJ | 1938-01-01 | 1941-01-03 | 1 | Republican | |||||||||||||
22858 | 22858 | William Barbour B000132 | sen | NJ | 1941-01-03 | 1943-12-31 | 1 | Republican | |||||||||||||
13842 | 13842 | Thomas Bard B000138 | sen | CA | 1900-01-01 | 1905-03-03 | 1 | Republican | |||||||||||||
2775 | 2775 | Isaac Barnard B000154 | sen | PA | 1827-12-03 | 1831-12-31 | 1 | Jackson | |||||||||||||
25589 | 25589 | Frank Barrett B000176 | sen | WY | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
13569 | 13569 | William Bate B000227 | sen | TN | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
13570 | 13570 | William Bate B000227 | sen | TN | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13571 | 13571 | William Bate B000227 | sen | TN | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
2748 | 2748 | Ephraim Bateman B000228 | sen | NJ | 1826-11-09 | 1827-03-03 | 1 | Adams | |||||||||||||
2749 | 2749 | Ephraim Bateman B000228 | sen | NJ | 1827-12-03 | 1829-01-12 | 1 | Adams | |||||||||||||
8262 | 8262 | James Bayard B000248 | sen | DE | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
8263 | 8263 | James Bayard B000248 | sen | DE | 1857-12-07 | 1863-03-03 | 1 | Democrat | |||||||||||||
8264 | 8264 | James Bayard B000248 | sen | DE | 1863-12-07 | 1865-03-03 | 1 | Democrat | |||||||||||||
8265 | 8265 | James Bayard B000248 | sen | DE | 1867-03-04 | 1869-03-03 | 1 | Democrat | |||||||||||||
4692 | 4692 | Richard Bayard B000251 | sen | DE | 1836-06-17 | 1839-03-03 | 1 | Whig | |||||||||||||
4693 | 4693 | Richard Bayard B000251 | sen | DE | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
18558 | 18558 | Thomas Bayard B000252 | sen | DE | 1922-11-08 | 1923-03-03 | 1 | Democrat | |||||||||||||
18559 | 18559 | Thomas Bayard B000252 | sen | DE | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
10264 | 10264 | Thomas Bayard B000253 | sen | DE | 1869-03-04 | 1875-03-03 | 1 | Democrat | |||||||||||||
10265 | 10265 | Thomas Bayard B000253 | sen | DE | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10266 | 10266 | Thomas Bayard B000253 | sen | DE | 1881-12-05 | 1885-12-31 | 1 | Democrat | |||||||||||||
26731 | 26731 | James Beall B000271 | sen | MD | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
26732 | 26732 | James Beall B000271 | sen | MD | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
29582 | 29582 | John Beall B000272 | sen | MD | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
6512 | 6512 | Thomas Benton B000398 | sen | MO | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
6513 | 6513 | Thomas Benton B000398 | sen | MO | 1827-12-03 | 1833-03-03 | 1 | Jackson | |||||||||||||
6514 | 6514 | Thomas Benton B000398 | sen | MO | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
6515 | 6515 | Thomas Benton B000398 | sen | MO | 1839-12-02 | 1845-03-03 | 1 | Democrat | |||||||||||||
6516 | 6516 | Thomas Benton B000398 | sen | MO | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
24739 | 24739 | William Benton B000399 | sen | CT | 1949-12-17 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
33818 | 33818 | Lloyd Bentsen B000401 | sen | TX | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
33819 | 33819 | Lloyd Bentsen B000401 | sen | TX | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
33820 | 33820 | Lloyd Bentsen B000401 | sen | TX | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33821 | 33821 | Lloyd Bentsen B000401 | sen | TX | 1989-01-03 | 1993-12-31 | 1 | Democrat | |||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
14573 | 14573 | Albert Beveridge B000429 | sen | IN | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14574 | 14574 | Albert Beveridge B000429 | sen | IN | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
22872 | 22872 | Theodore Bilbo B000460 | sen | MS | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22873 | 22873 | Theodore Bilbo B000460 | sen | MS | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
39041 | 39041 | Jeff Bingaman B000468 | sen | NM | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
39042 | 39042 | Jeff Bingaman B000468 | sen | NM | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
39043 | 39043 | Jeff Bingaman B000468 | sen | NM | 1995-01-04 | 2001-01-03 | 1 | Democrat | |||||||||||||
39044 | 39044 | Jeff Bingaman B000468 | sen | NM | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://bingaman.senate.gov | ||||||||||||
39045 | 39045 | Jeff Bingaman B000468 | sen | NM | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://bingaman.senate.gov | 703 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5521 | 202-224-2852 | http://www.bingaman.senate.gov/contact/ | 703 Hart Senate Office Building | |||||||
3590 | 3590 | John Black B000503 | sen | MS | 1832-11-12 | 1833-03-03 | 1 | Jackson | |||||||||||||
3591 | 3591 | John Black B000503 | sen | MS | 1833-11-22 | 1838-01-22 | 1 | Whig | |||||||||||||
27104 | 27104 | William Blakley B000536 | sen | TX | 1957-01-15 | 1957-12-31 | 1 | Democrat | appointment | ||||||||||||
11299 | 11299 | Rufus Blodgett B000562 | sen | NJ | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
2204 | 2204 | Elijah Boardman B000577 | sen | CT | 1821-12-03 | 1823-12-31 | 1 | Republican | |||||||||||||
9452 | 9452 | Newton Booth B000630 | sen | CA | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
8527 | 8527 | Arthur Boreman B000638 | sen | WV | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
7920 | 7920 | Lemuel Bowden B000678 | sen | VA | 1863-12-07 | 1865-03-03 | 1 | Unionist | |||||||||||||
32894 | 32894 | Nicholas Brady B000756 | sen | NJ | 1982-04-12 | 1982-12-27 | 1 | Republican | appointment | ||||||||||||
948 | 948 | Richard Brent B000802 | sen | VA | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
24284 | 24284 | Ralph Brewster B000816 | sen | ME | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
24285 | 24285 | Ralph Brewster B000816 | sen | ME | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25606 | 25606 | John Bricker B000820 | sen | OH | 1947-01-03 | 1953-01-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);