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 state
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
37480 | 37480 | Ted Stevens S000888 | sen | AK | 1968-12-24 | 1973-01-03 | 2 | Republican | appointment | ||||||||||||
37481 | 37481 | Ted Stevens S000888 | sen | AK | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
37482 | 37482 | Ted Stevens S000888 | sen | AK | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
37483 | 37483 | Ted Stevens S000888 | sen | AK | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
37484 | 37484 | Ted Stevens S000888 | sen | AK | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
37485 | 37485 | Ted Stevens S000888 | sen | AK | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37486 | 37486 | Ted Stevens S000888 | sen | AK | 2003-01-07 | 2009-01-03 | 2 | Republican | http://stevens.senate.gov/ | ||||||||||||
39686 | 39686 | Mark Begich B001265 | sen | AK | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.begich.senate.gov | 111 Russell Senate Office Building Washington DC 20510 | 202-224-3004 | 202-224-2354 | http://www.begich.senate.gov/public/index.cfm?p=EmailSenator | 111 Russell Senate Office Building | junior | http://www.begich.senate.gov/public/?a=rss.feed | |||||
44072 | 44072 | Dan Sullivan S001198 | sen | AK | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.sullivan.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3004 | https://www.sullivan.senate.gov/contact/email | 302 Hart Senate Office Building | junior | |||||||
44073 | 44073 | Dan Sullivan S001198 | sen | AK | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.sullivan.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3004 | https://www.sullivan.senate.gov/contact/email | 302 Hart Senate Office Building | junior | |||||||
5763 | 5763 | Dixon Lewis L000278 | sen | AL | 1844-04-22 | 1847-03-03 | 2 | Democrat | |||||||||||||
5764 | 5764 | Dixon Lewis L000278 | sen | AL | 1847-12-06 | 1848-10-25 | 2 | Democrat | |||||||||||||
5873 | 5873 | William King K000217 | sen | AL | 1819-12-14 | 1823-03-03 | 2 | Republican | |||||||||||||
5874 | 5874 | William King K000217 | sen | AL | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
5875 | 5875 | William King K000217 | sen | AL | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
5876 | 5876 | William King K000217 | sen | AL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5877 | 5877 | William King K000217 | sen | AL | 1841-05-31 | 1844-04-15 | 2 | Democrat | |||||||||||||
5940 | 5940 | Jeremiah Clemens C000501 | sen | AL | 1849-12-03 | 1853-03-03 | 2 | Democrat | |||||||||||||
6812 | 6812 | Benjamin Fitzpatrick F000174 | sen | AL | 1848-01-01 | 1849-12-31 | 2 | Democrat | |||||||||||||
7341 | 7341 | Clement Clay C000480 | sen | AL | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7342 | 7342 | Clement Clay C000480 | sen | AL | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
8501 | 8501 | Willard Warner W000159 | sen | AL | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8911 | 8911 | George Goldthwaite G000266 | sen | AL | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
14092 | 14092 | John Morgan M000954 | sen | AL | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
14093 | 14093 | John Morgan M000954 | sen | AL | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
14094 | 14094 | John Morgan M000954 | sen | AL | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
14095 | 14095 | John Morgan M000954 | sen | AL | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
14096 | 14096 | John Morgan M000954 | sen | AL | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
18031 | 18031 | Braxton Comer C000657 | sen | AL | 1920-03-05 | 1921-03-03 | 2 | Democrat | appointment | ||||||||||||
18988 | 18988 | James Heflin H000446 | sen | AL | 1920-11-03 | 1925-03-03 | 2 | Democrat | |||||||||||||
18989 | 18989 | James Heflin H000446 | sen | AL | 1925-12-07 | 1931-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 | |||||||||||||
24244 | 24244 | George Swift S001117 | sen | AL | 1946-06-15 | 1947-01-03 | 2 | Democrat | appointment | ||||||||||||
30699 | 30699 | John Sparkman S000701 | sen | AL | 1946-11-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
30700 | 30700 | John Sparkman S000701 | sen | AL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30701 | 30701 | John Sparkman S000701 | sen | AL | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
30702 | 30702 | John Sparkman S000701 | sen | AL | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30703 | 30703 | John Sparkman S000701 | sen | AL | 1967-01-10 | 1973-01-03 | 2 | Democrat | |||||||||||||
30704 | 30704 | John Sparkman S000701 | sen | AL | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
34543 | 34543 | Howell Heflin H000445 | sen | AL | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34544 | 34544 | Howell Heflin H000445 | sen | AL | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
34545 | 34545 | Howell Heflin H000445 | sen | AL | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
40525 | 40525 | Jefferson Sessions S001141 | sen | AL | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
40526 | 40526 | Jefferson Sessions S001141 | sen | AL | 2003-01-07 | 2009-01-03 | 2 | Republican | http://sessions.senate.gov/ | ||||||||||||
40527 | 40527 | Jefferson Sessions S001141 | sen | AL | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.sessions.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | 202-224-3149 | http://www.sessions.senate.gov/public/index.cfm/contact-jeff | 326 Russell Senate Office Building | junior | http://www.sessions.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
40528 | 40528 | Jefferson Sessions S001141 | sen | AL | 2015-01-06 | 2017-02-08 | 2 | Republican | http://www.sessions.senate.gov/public | 326 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | 202-224-3149 | http://www.sessions.senate.gov/public/index.cfm/contact-jeff | 326 Russell Senate Office Building | junior | http://www.sessions.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
40592 | 40592 | Luther Strange S001202 | sen | AL | 2017-02-09 | 2018-01-03 | 2 | Republican | appointment | https://www.strange.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.strange.senate.gov/content/contact-senator | 326 Russell Senate Office Building | junior | ||||||
41594 | 41594 | Doug Jones J000300 | sen | AL | 2018-01-03 | 2021-01-03 | 2 | Democrat | https://www.jones.senate.gov | 330 Hart Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.jones.senate.gov/content/contact-senator | 330 Hart Senate Office Building | junior | |||||||
44471 | 44471 | Tommy Tuberville T000278 | sen | AL | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.tuberville.senate.gov | 142 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.tuberville.senate.gov/contact/contact-form/ | 142 Russell Senate Office Building | junior | |||||||
4797 | 4797 | William Fulton F000425 | sen | AR | 1836-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4798 | 4798 | William Fulton F000425 | sen | AR | 1841-05-31 | 1845-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
7564 | 7564 | William Sebastian S000216 | sen | AR | 1848-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
7565 | 7565 | William Sebastian S000216 | sen | AR | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7566 | 7566 | William Sebastian S000216 | sen | AR | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
8495 | 8495 | Alexander McDonald M000408 | sen | AR | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8858 | 8858 | Powell Clayton C000498 | sen | AR | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10723 | 10723 | Augustus Garland G000065 | sen | AR | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
10724 | 10724 | Augustus Garland G000065 | sen | AR | 1883-12-03 | 1885-12-31 | 2 | Democrat | |||||||||||||
13858 | 13858 | James Berry B000418 | sen | AR | 1885-12-07 | 1889-03-03 | 2 | Democrat | |||||||||||||
13859 | 13859 | James Berry B000418 | sen | AR | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
13860 | 13860 | James Berry B000418 | sen | AR | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13861 | 13861 | James Berry B000418 | sen | AR | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
15075 | 15075 | Jeff Davis D000112 | sen | AR | 1907-12-02 | 1913-03-03 | 2 | Democrat | |||||||||||||
16397 | 16397 | John Heiskell H000457 | sen | AR | 1913-04-07 | 1913-12-31 | 2 | Democrat | appointment | ||||||||||||
16418 | 16418 | William Kavanaugh K000023 | sen | AR | 1913-04-07 | 1913-12-31 | 2 | Democrat | |||||||||||||
20812 | 20812 | Joseph Robinson R000347 | sen | AR | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
20813 | 20813 | Joseph Robinson R000347 | sen | AR | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20814 | 20814 | Joseph Robinson R000347 | sen | AR | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
20815 | 20815 | Joseph Robinson R000347 | sen | AR | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22311 | 22311 | John Miller M000738 | sen | AR | 1937-01-05 | 1941-12-31 | 2 | Democrat | |||||||||||||
23257 | 23257 | George Spencer S000724 | sen | AR | 1941-04-01 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
30565 | 30565 | John McClellan M000332 | sen | AR | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
30566 | 30566 | John McClellan M000332 | sen | AR | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30567 | 30567 | John McClellan M000332 | sen | AR | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
30568 | 30568 | John McClellan M000332 | sen | AR | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30569 | 30569 | John McClellan M000332 | sen | AR | 1967-01-10 | 1973-01-03 | 2 | Democrat | |||||||||||||
30570 | 30570 | John McClellan M000332 | sen | AR | 1973-01-03 | 1977-12-31 | 2 | Democrat | |||||||||||||
31591 | 31591 | Kaneaster Hodges H000675 | sen | AR | 1977-12-10 | 1979-01-03 | 2 | Democrat | appointment | ||||||||||||
34850 | 34850 | David Pryor P000556 | sen | AR | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34851 | 34851 | David Pryor P000556 | sen | AR | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
34852 | 34852 | David Pryor P000556 | sen | AR | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
36264 | 36264 | Tim Hutchinson H001015 | sen | AR | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
39721 | 39721 | Mark Pryor P000590 | sen | AR | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://pryor.senate.gov | ||||||||||||
39722 | 39722 | Mark Pryor P000590 | sen | AR | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.pryor.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2353 | 202-228-0908 | http://www.pryor.senate.gov/contact/form | 255 Dirksen Senate Office Building | senior | http://www.pryor.senate.gov/public/index.cfm/rss/feed | |||||
43702 | 43702 | Tom Cotton C001095 | sen | AR | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.cotton.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-2353 | https://www.cotton.senate.gov/contact/contact-tom | 326 Russell Senate Office Building | junior | |||||||
43703 | 43703 | Tom Cotton C001095 | sen | AR | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.cotton.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-2353 | https://www.cotton.senate.gov/contact/contact-tom | 326 Russell Senate Office Building | junior | |||||||
10622 | 10622 | George Chilcott C000352 | sen | CO | 1882-01-01 | 1883-03-03 | 2 | Republican | |||||||||||||
10642 | 10642 | Thomas Bowen B000686 | sen | CO | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
10907 | 10907 | Horace Tabor T000004 | sen | CO | 1883-12-03 | 1883-12-31 | 2 | Republican | |||||||||||||
13217 | 13217 | Edward Wolcott W000667 | sen | CO | 1889-12-02 | 1895-03-03 | 2 | 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);