legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by party_affiliations descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, how, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41591 | 41591 | Paul Mitchell M001201 | rep | MI | 2019-01-03 | 2021-01-03 | Independent | 10 | [ { "start": "2019-01-03", "end": "2020-12-13", "party": "Republican" }, { "start": "2020-12-14", "end": "2021-01-03", "party": "Independent" } ] |
https://mitchell.house.gov | 211 Cannon House Office Building Washington DC 20515-2210 | 202-225-2106 | 211 Cannon House Office Building | ||||||||
44350 | 44350 | Jefferson Van Drew V000133 | rep | NJ | 2019-01-03 | 2021-01-03 | Republican | 2 | [ { "start": "2019-01-03", "end": "2019-12-18", "party": "Democrat" }, { "start": "2019-12-19", "end": "2021-01-03", "party": "Republican" } ] |
https://vandrew.house.gov | 331 Cannon House Office Building Washington DC 20515-3002 | 202-225-6572 | 331 Cannon House Office Building | ||||||||
41289 | 41289 | Justin Amash A000367 | rep | MI | 2019-01-03 | 2021-01-03 | Libertarian | 3 | [ { "start": "2019-01-03", "end": "2019-07-03", "party": "Republican" }, { "start": "2019-07-04", "end": "2020-04-30", "party": "Independent" }, { "start": "2020-05-01", "end": "2021-01-03", "party": "Libertarian" } ] |
https://amash.house.gov | 106 Cannon House Office Building Washington DC 20515-2203 | 202-225-3831 | 106 Cannon House Office Building | http://amash.house.gov/rss.xml | |||||||
38568 | 38568 | Parker Griffith G000557 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 5 | [ { "start": "2009-01-06", "end": "2009-12-22", "party": "Democrat" }, { "start": "2009-12-22", "end": "2011-01-03", "party": "Republican" } ] |
http://griffith.house.gov | |||||||||||
43233 | 43233 | Gregorio Sablan S001177 | rep | MP | 2009-01-06 | 2011-01-03 | Democrat | 0 | [ { "start": "2009-01-06", "end": "2009-02-23", "party": "Independent" }, { "start": "2009-02-23", "end": "2011-01-03", "party": "Democrat" } ] |
http://sablan.house.gov | |||||||||||
37887 | 37887 | Arlen Specter S000709 | sen | PA | 2005-01-04 | 2011-01-03 | 3 | Democrat | [ { "start": "2005-01-04", "end": "2009-04-30", "party": "Republican" }, { "start": "2009-04-30", "end": "2011-01-03", "party": "Democrat" } ] |
http://specter.senate.gov/ | |||||||||||
39616 | 39616 | Rodney Alexander A000361 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 5 | [ { "start": "2003-01-07", "end": "2004-08-09", "party": "Democrat" }, { "start": "2004-08-09", "end": "2005-01-03", "party": "Republican" } ] |
http://www.house.gov/alexander/ | |||||||||||
39867 | 39867 | Ralph Hall H000067 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 4 | [ { "start": "2003-01-07", "end": "2004-01-05", "party": "Democrat" }, { "start": "2004-01-05", "end": "2005-01-03", "party": "Republican" } ] |
http://www.house.gov/ralphhall | |||||||||||
38074 | 38074 | Virgil Goode G000280 | rep | VA | 2001-01-03 | 2003-01-03 | Republican | 5 | [ { "start": "2001-01-03", "end": "2002-08-01", "party": "Independent" }, { "start": "2002-08-01", "end": "2003-01-03", "party": "Republican" } ] |
||||||||||||
36985 | 36985 | James Jeffords J000072 | sen | VT | 2001-01-03 | 2007-01-03 | 1 | Independent | [ { "start": "2001-01-03", "end": "2001-06-06", "party": "Republican" }, { "start": "2001-06-06", "end": "2007-01-03", "party": "Independent", "caucus": "Democrat" } ] |
http://jeffords.senate.gov/ | Democrat | ||||||||||
36695 | 36695 | Matthew Martínez M000206 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 31 | [ { "start": "1999-01-06", "end": "2000-07-27", "party": "Democrat" }, { "start": "2000-07-27", "end": "2001-01-03", "party": "Republican" } ] |
||||||||||||
38073 | 38073 | Virgil Goode G000280 | rep | VA | 1999-01-06 | 2001-01-03 | Independent | 5 | [ { "start": "1999-01-06", "end": "2000-01-27", "party": "Democrat" }, { "start": "2000-01-27", "end": "2001-01-03", "party": "Independent" } ] |
||||||||||||
36612 | 36612 | Michael Forbes F000257 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 1 | [ { "start": "1999-01-06", "end": "1999-07-17", "party": "Republican" }, { "start": "1999-07-17", "end": "2001-01-03", "party": "Democrat" } ] |
||||||||||||
39589 | 39589 | Jo Ann Emerson E000172 | rep | MO | 1997-01-07 | 1999-01-03 | Republican | 8 | [ { "start": "1997-01-07", "end": "1997-01-08", "party": "Independent" }, { "start": "1997-01-08", "end": "1999-01-03", "party": "Republican" } ] |
||||||||||||
35859 | 35859 | James Hayes H000390 | rep | LA | 1995-01-04 | 1997-01-03 | Republican | 7 | [ { "start": "1995-01-04", "end": "1995-12-01", "party": "Democrat" }, { "start": "1995-12-01", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
36327 | 36327 | Michael Parker P000066 | rep | MS | 1995-01-04 | 1997-01-03 | Republican | 4 | [ { "start": "1995-01-04", "end": "1995-11-10", "party": "Democrat" }, { "start": "1995-11-10", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
37499 | 37499 | William Tauzin T000058 | rep | LA | 1995-01-04 | 1997-01-03 | Republican | 3 | [ { "start": "1995-01-04", "end": "1995-08-08", "party": "Democrat" }, { "start": "1995-08-08", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
35887 | 35887 | Gregory Laughlin L000119 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 14 | [ { "start": "1995-01-04", "end": "1995-06-26", "party": "Democrat" }, { "start": "1995-06-26", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
38500 | 38500 | Nathan Deal D000168 | rep | GA | 1995-01-04 | 1997-01-03 | Republican | 9 | [ { "start": "1995-01-04", "end": "1995-04-10", "party": "Democrat" }, { "start": "1995-04-10", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
36543 | 36543 | Ben Campbell C000077 | sen | CO | 1993-01-05 | 1999-01-03 | 3 | Republican | [ { "start": "1993-01-05", "end": "1995-03-03", "party": "Democrat" }, { "start": "1995-03-03", "end": "1999-01-03", "party": "Republican" } ] |
||||||||||||
43351 | 43351 | Richard Shelby S000320 | sen | AL | 1993-01-05 | 1999-01-03 | 3 | Republican | [ { "start": "1993-01-05", "end": "1994-11-09", "party": "Democrat" }, { "start": "1994-11-09", "end": "2005-01-03", "party": "Republican" } ] |
||||||||||||
34073 | 34073 | Tommy Robinson R000354 | rep | AR | 1989-01-03 | 1991-01-03 | Republican | 2 | [ { "start": "1989-01-03", "end": "1989-07-28", "party": "Democrat" }, { "start": "1989-07-28", "end": "1991-01-03", "party": "Republican" } ] |
||||||||||||
33932 | 33932 | James Grant G000382 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 2 | [ { "start": "1989-01-03", "end": "1989-02-21", "party": "Democrat" }, { "start": "1989-02-21", "end": "1991-01-03", "party": "Republican" } ] |
||||||||||||
31065 | 31065 | John Jarman J000057 | rep | OK | 1975-01-14 | 1977-01-03 | Republican | 5 | [ { "start": "1975-01-14", "end": "1975-01-24", "party": "Democrat" }, { "start": "1975-01-24", "end": "1977-01-03", "party": "Republican" } ] |
||||||||||||
30629 | 30629 | Ogden Reid R000150 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 26 | [ { "start": "1971-01-21", "end": "1972-03-22", "party": "Republican" }, { "start": "1972-03-22", "end": "1973-01-03", "party": "Democrat" } ] |
||||||||||||
36421 | 36421 | J. Thurmond T000254 | sen | SC | 1961-01-03 | 1967-01-03 | 2 | Republican | [ { "start": "1961-01-03", "end": "1964-09-16", "party": "Democrat" }, { "start": "1964-09-16", "end": "1967-01-03", "party": "Republican" } ] |
||||||||||||
1 | 1 | Richard Bassett B000226 | sen | DE | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
2 | 2 | Theodorick Bland B000546 | rep | VA | 1789-03-04 | 1791-03-03 | 9 | ||||||||||||||
3 | 3 | Aedanus Burke B001086 | rep | SC | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
4 | 4 | Daniel Carroll C000187 | rep | MD | 1789-03-04 | 1791-03-03 | 6 | ||||||||||||||
5 | 5 | George Clymer C000538 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
6 | 6 | Benjamin Contee C000710 | rep | MD | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
7 | 7 | Tristram Dalton D000013 | sen | MA | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
8 | 8 | Jonathan Elmer E000155 | sen | NJ | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
9 | 9 | William Few F000100 | sen | GA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
10 | 10 | William Floyd F000224 | rep | NY | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
11 | 11 | George Gale G000012 | rep | MD | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
12 | 12 | William Grayson G000403 | sen | VA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
13 | 13 | Jonathan Grout G000500 | rep | MA | 1789-03-04 | 1791-03-03 | 8 | ||||||||||||||
14 | 14 | Benjamin Hawkins H000368 | sen | NC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
15 | 15 | Benjamin Huntington H000995 | rep | CT | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
16 | 16 | Ralph Izard I000053 | sen | SC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
17 | 17 | William Johnson J000182 | sen | CT | 1789-03-04 | 1791-12-31 | 3 | Pro-Administration | |||||||||||||
18 | 18 | Samuel Johnston J000198 | sen | NC | 1789-03-04 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
19 | 19 | Richard Lee L000201 | sen | VA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
20 | 20 | William Maclay M000031 | sen | PA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
21 | 21 | George Mathews M000234 | rep | GA | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
22 | 22 | Robert Morris M000985 | sen | PA | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
23 | 23 | George Partridge P000092 | rep | MA | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
24 | 24 | William Paterson P000102 | sen | NJ | 1789-03-04 | 1791-03-03 | 2 | Pro-Administration | |||||||||||||
25 | 25 | William Smith S000624 | rep | MD | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
26 | 26 | Michael Stone S000961 | rep | MD | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
27 | 27 | Jeremiah Van Rensselaer V000053 | rep | NY | 1789-03-04 | 1791-03-03 | 6 | ||||||||||||||
28 | 28 | Henry Wynkoop W000783 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
29 | 29 | Philemon Dickinson D000324 | sen | NJ | 1790-01-01 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
30 | 30 | John Walker W000059 | sen | VA | 1790-01-01 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
31 | 31 | John Ashe A000307 | rep | NC | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
32 | 32 | John Ashe A000307 | rep | NC | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
33 | 33 | Robert Barnwell B000167 | rep | SC | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
34 | 34 | Aaron Burr B001133 | sen | NY | 1791-10-24 | 1797-03-03 | 1 | Republican | |||||||||||||
35 | 35 | George Cabot C000009 | sen | MA | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
36 | 36 | Charles Carroll C000185 | sen | MD | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
37 | 37 | Charles Carroll C000185 | sen | MD | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
38 | 38 | Oliver Ellsworth E000147 | sen | CT | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
39 | 39 | Oliver Ellsworth E000147 | sen | CT | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
40 | 40 | Elbridge Gerry G000139 | rep | MA | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
41 | 41 | Elbridge Gerry G000139 | rep | MA | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
42 | 42 | Daniel Huger H000916 | rep | SC | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
43 | 43 | Daniel Huger H000916 | rep | SC | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
44 | 44 | Israel Jacobs J000036 | rep | PA | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
45 | 45 | Philip Key K000158 | rep | MD | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
46 | 46 | George Read R000091 | sen | DE | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
47 | 47 | George Read R000091 | sen | DE | 1791-10-24 | 1793-12-31 | 1 | ||||||||||||||
48 | 48 | Moses Robinson R000350 | sen | VT | 1791-10-24 | 1796-10-15 | 1 | Anti-Administration | |||||||||||||
49 | 49 | Cornelius Schoonmaker S000140 | rep | NY | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
50 | 50 | Joshua Seney S000242 | rep | MD | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
51 | 51 | Joshua Seney S000242 | rep | MD | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
52 | 52 | Upton Sheredine S000340 | rep | MD | 1791-10-24 | 1793-03-03 | 6 | ||||||||||||||
53 | 53 | Roger Sherman S000349 | rep | CT | 1789-03-04 | 1791-03-03 | Pro-Administration | -1 | |||||||||||||
54 | 54 | Roger Sherman S000349 | sen | CT | 1791-10-24 | 1793-12-31 | 3 | Pro-Administration | |||||||||||||
55 | 55 | Peter Silvester S000412 | rep | NY | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
56 | 56 | Peter Silvester S000412 | rep | NY | 1791-10-24 | 1793-03-03 | 5 | ||||||||||||||
57 | 57 | John Steele S000832 | rep | NC | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
58 | 58 | John Steele S000832 | rep | NC | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
59 | 59 | Samuel Sterett S000866 | rep | MD | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
60 | 60 | Jonathan Sturges S001047 | rep | CT | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
61 | 61 | Jonathan Sturges S001047 | rep | CT | 1791-10-24 | 1793-03-03 | -1 | ||||||||||||||
62 | 62 | Thomas Tucker T000403 | rep | SC | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
63 | 63 | Thomas Tucker T000403 | rep | SC | 1791-10-24 | 1793-03-03 | 5 | ||||||||||||||
64 | 64 | Anthony Wayne W000216 | rep | GA | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
65 | 65 | Alexander White W000352 | rep | VA | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
66 | 66 | Alexander White W000352 | rep | VA | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
67 | 67 | Hugh Williamson W000551 | rep | NC | 1789-03-04 | 1791-03-03 | Federalist | 2 | |||||||||||||
68 | 68 | Hugh Williamson W000551 | rep | NC | 1791-10-24 | 1793-03-03 | Federalist | 4 | |||||||||||||
69 | 69 | Francis Willis W000560 | rep | GA | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
70 | 70 | John Edwards E000075 | sen | KY | 1792-01-01 | 1795-03-03 | 3 | Anti-Administration | |||||||||||||
71 | 71 | Richard Potts P000473 | sen | MD | 1793-01-10 | 1796-10-14 | 1 | Federalist | |||||||||||||
72 | 72 | James Armstrong A000280 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
73 | 73 | John Beatty B000282 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
74 | 74 | Elias Boudinot B000661 | rep | NJ | 1789-03-04 | 1791-03-03 | -1 |
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);