legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
203 rows where how = "appointment" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: party, address, phone, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44531 | 44531 | Alejandro Padilla P000145 | sen | CA | 2021-01-20 | 2022-11-08 | 3 | Democrat | appointment | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44245 | 44245 | Cindy Hyde-Smith H001079 | sen | MS | 2018-04-09 | 2018-11-27 | 2 | Republican | appointment | https://www.hydesmith.senate.gov | G12 Dirksen Senate Office Building Washington DC 20510 | 202-224-5054 | https://www.hydesmith.senate.gov/content/contact-senator | G12 Dirksen Senate Office Building | junior | special-election | |||||
44242 | 44242 | Tina Smith S001203 | sen | MN | 2018-01-03 | 2018-11-06 | 2 | Democrat | appointment | https://www.smith.senate.gov | 309 Hart Senate Office Building Washington DC 20510 | 202-224-5641 | https://www.smith.senate.gov/content/contact-senator | 309 Hart Senate Office Building | junior | special-election | |||||
43685 | 43685 | Brian Schatz S001194 | sen | HI | 2012-12-27 | 2015-01-03 | 3 | Democrat | appointment | http://www.schatz.senate.gov | 722 Hart Senate Office Building Washington DC 20510 | 202-224-3934 | 202-228-1153 | http://www.schatz.senate.gov/contact | 722 Hart Senate Office Building | senior | |||||
43337 | 43337 | Tim Scott S001184 | sen | SC | 2013-01-03 | 2015-01-03 | 3 | Republican | appointment | http://www.scott.senate.gov | 167 Russell Senate Office Building Washington DC 20510 | 202-224-6121 | 202-225-3407 | http://www.scott.senate.gov/contact/email-me | 167 Russell Senate Office Building | junior | http://www.scott.senate.gov/rss.xml | ||||
42958 | 42958 | Lisa Murkowski M001153 | sen | AK | 2003-01-07 | 2005-01-03 | 3 | Republican | appointment | http://murkowski.senate.gov/ | |||||||||||
41932 | 41932 | Michael Bennet B001267 | sen | CO | 2009-01-22 | 2011-01-03 | 3 | Democrat | appointment | http://bennet.senate.gov/ | |||||||||||
41895 | 41895 | Kirsten Gillibrand G000555 | sen | NY | 2009-01-27 | 2013-01-03 | 1 | Democrat | appointment | http://gillibrand.senate.gov | 478 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4451 | 202-228-0282 | http://www.gillibrand.senate.gov/contact/ | 478 Russell Senate Office Building | ||||||
41823 | 41823 | Roger Wicker W000437 | sen | MS | 2007-12-31 | 2013-01-03 | 1 | Republican | appointment | http://wicker.senate.gov | 555 DIRKSEN SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6253 | 202-228-0378 | http://www.wicker.senate.gov/public/index.cfm?FuseAction=Contact.EMailSenatorWicker | 555 Dirksen Senate Office Building | ||||||
41813 | 41813 | John Barrasso B001261 | sen | WY | 2007-06-25 | 2013-01-03 | 1 | Republican | appointment | http://barrasso.senate.gov | 307 DIRKSEN SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6441 | 202-224-1724 | http://www.barrasso.senate.gov/public/index.cfm?FuseAction=ContactUs.ContactForm | 307 Dirksen Senate Office Building | ||||||
41786 | 41786 | Robert Menendez M000639 | sen | NJ | 2006-01-18 | 2007-01-03 | 1 | Democrat | appointment | http://menendez.senate.gov/ | |||||||||||
41618 | 41618 | Kelly Loeffler L000594 | sen | GA | 2020-01-06 | 2021-01-20 | 3 | Republican | appointment | https://www.loeffler.senate.gov | 131 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | https://www.loeffler.senate.gov/connect/email-kelly | 131 Russell Senate Office Building | junior | special-election | |||||
41254 | 41254 | Martha McSally M001197 | sen | AZ | 2019-01-03 | 2020-12-02 | 3 | Republican | appointment | https://www.mcsally.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-2235 | https://www.mcsally.senate.gov/contact_martha | 404 Russell Senate Office Building | junior | special-election | |||||
41090 | 41090 | Dean Heller H001041 | sen | NV | 2011-05-09 | 2013-01-03 | 1 | Republican | appointment | http://heller.senate.gov/ | 361A RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6244 | http://www.heller.senate.gov/public/index.cfm/contact-form | 361a Russell Senate Office Building | |||||||
40666 | 40666 | Jon Kyl K000352 | sen | AZ | 2018-09-05 | 2018-12-31 | 3 | Republican | appointment | https://www.kyl.senate.gov | G12 Dirksen Senate Office Building Washington DC 20510 | 202-224-2235 | 202-228-2862 | https://www.kyl.senate.gov/content/contact-senator-kyl | G12 Dirksen Senate Office Building | junior | |||||
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 | ||||||
40214 | 40214 | Daniel Coats C000542 | sen | IN | 1989-01-03 | 1993-01-03 | 3 | Republican | appointment | ||||||||||||
40128 | 40128 | John Walsh W000818 | sen | MT | 2014-02-11 | 2015-01-03 | 2 | Democrat | appointment | http://www.walsh.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-2651 | http://www.walsh.senate.gov/contact.cfm | 511 Hart Senate Office Building | junior | ||||||
39644 | 39644 | Jeffrey Chiesa C001100 | sen | NJ | 2013-06-10 | 2013-10-31 | 2 | Republican | appointment | http://www.chiesa.senate.gov | 141 HART WASHINGTON DC 20510 | 202-224-3224 | 202-224-7981 | http://www.chiesa.senate.gov/contact.cfm | 141 Hart | junior | |||||
39609 | 39609 | William Cowan C001099 | sen | MA | 2013-02-06 | 2013-07-16 | 2 | Democrat | appointment | http://www.cowan.senate.gov | 218 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2742 | http://www.cowan.senate.gov/contact | 218 Russell Senate Office Building | junior | ||||||
39037 | 39037 | Daniel Akaka A000069 | sen | HI | 1990-05-16 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
38936 | 38936 | Carte Goodwin G000561 | sen | WV | 2010-07-20 | 2010-11-14 | 1 | Democrat | appointment | ||||||||||||
38934 | 38934 | Paul Kirk K000374 | sen | MA | 2009-09-25 | 2010-02-04 | 1 | Democrat | appointment | http://kirk.senate.gov/ | |||||||||||
38933 | 38933 | George LeMieux L000572 | sen | FL | 2009-09-10 | 2011-01-03 | 3 | Republican | appointment | http://lemieux.senate.gov/ | |||||||||||
38931 | 38931 | Edward Kaufman K000373 | sen | DE | 2009-01-16 | 2010-11-15 | 2 | Democrat | appointment | http://kaufman.senate.gov/ | |||||||||||
38930 | 38930 | Roland Burris B001266 | sen | IL | 2009-01-15 | 2010-11-29 | 3 | Democrat | appointment | http://burris.senate.gov/ | |||||||||||
37480 | 37480 | Ted Stevens S000888 | sen | AK | 1968-12-24 | 1973-01-03 | 2 | Republican | appointment | ||||||||||||
37216 | 37216 | Dean Barkley B001237 | sen | MN | 2002-11-05 | 2003-01-03 | 2 | Independent | appointment | ||||||||||||
36855 | 36855 | Lincoln Chafee C001040 | sen | RI | 1999-11-02 | 2001-01-03 | 1 | Republican | appointment | ||||||||||||
36854 | 36854 | Jean Carnahan C001043 | sen | MO | 2001-01-03 | 2003-01-03 | 1 | Democrat | appointment | ||||||||||||
36778 | 36778 | Zell Miller M001141 | sen | GA | 2000-07-24 | 2005-01-03 | 3 | Democrat | appointment | http://miller.senate.gov/ | |||||||||||
36132 | 36132 | Sheila Frahm F000438 | sen | KS | 1996-06-11 | 1996-11-05 | 3 | Republican | appointment | ||||||||||||
35391 | 35391 | Harlan Mathews M000236 | sen | TN | 1993-01-05 | 1995-01-03 | 2 | Democrat | appointment | ||||||||||||
35353 | 35353 | Robert Krueger K000333 | sen | TX | 1993-01-21 | 1993-12-31 | 1 | Democrat | appointment | ||||||||||||
35090 | 35090 | Jocelyn Burdick B001076 | sen | ND | 1992-09-16 | 1992-12-14 | 1 | Democrat | appointment | ||||||||||||
35057 | 35057 | Harris Wofford W000665 | sen | PA | 1991-05-08 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
34950 | 34950 | John Seymour S000269 | sen | CA | 1991-01-07 | 1993-01-03 | 1 | Republican | appointment | ||||||||||||
34018 | 34018 | George Mitchell M000811 | sen | ME | 1980-05-17 | 1983-01-03 | 1 | Democrat | appointment | ||||||||||||
34013 | 34013 | Howard Metzenbaum M000678 | sen | OH | 1974-01-04 | 1974-12-23 | 3 | Democrat | appointment | ||||||||||||
33622 | 33622 | David Karnes K000011 | sen | NE | 1987-03-11 | 1989-01-03 | 1 | Republican | appointment | ||||||||||||
33469 | 33469 | James Broyhill B000966 | sen | NC | 1986-07-14 | 1986-11-04 | 3 | Republican | appointment | ||||||||||||
33152 | 33152 | Robert Stafford S000776 | sen | VT | 1971-09-16 | 1977-01-03 | 1 | Republican | appointment | ||||||||||||
32968 | 32968 | Daniel Evans E000236 | sen | WA | 1983-09-08 | 1989-01-03 | 1 | Republican | appointment | ||||||||||||
32894 | 32894 | Nicholas Brady B000756 | sen | NJ | 1982-04-12 | 1982-12-27 | 1 | Republican | appointment | ||||||||||||
31915 | 31915 | Muriel Humphrey H000956 | sen | MN | 1978-01-25 | 1978-11-07 | 1 | Democrat | appointment | ||||||||||||
31914 | 31914 | Paul Hatfield H000344 | sen | MT | 1978-01-22 | 1978-12-14 | 2 | Democrat | appointment | ||||||||||||
31913 | 31913 | Maryon Allen A000139 | sen | AL | 1978-06-08 | 1978-11-07 | 3 | Democrat | appointment | ||||||||||||
31591 | 31591 | Kaneaster Hodges H000675 | sen | AR | 1977-12-10 | 1979-01-03 | 2 | Democrat | appointment | ||||||||||||
31469 | 31469 | Harry Byrd B001209 | sen | VA | 1965-11-12 | 1971-01-03 | 1 | Democrat | appointment | ||||||||||||
31411 | 31411 | Wendell Anderson A000202 | sen | MN | 1976-12-30 | 1978-12-29 | 2 | Democrat | appointment | ||||||||||||
31402 | 31402 | Milton Young Y000047 | sen | ND | 1945-03-12 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
30885 | 30885 | Norris Cotton C000802 | sen | NH | 1975-08-08 | 1975-09-18 | 3 | Republican | appointment | ||||||||||||
30786 | 30786 | Louis Wyman W000782 | sen | NH | 1974-12-31 | 1975-01-03 | 3 | Republican | appointment | ||||||||||||
30608 | 30608 | James Pearson P000166 | sen | KS | 1962-01-31 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
30597 | 30597 | Walter Mondale M000851 | sen | MN | 1964-12-30 | 1967-01-03 | 2 | Democrat | appointment | ||||||||||||
30401 | 30401 | Robert Griffin G000465 | sen | MI | 1966-05-11 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
30337 | 30337 | James Eastland E000018 | sen | MS | 1941-06-30 | 1941-12-31 | 2 | Democrat | appointment | ||||||||||||
30135 | 30135 | Elaine Edwards E000068 | sen | LA | 1972-08-01 | 1972-11-13 | 2 | Democrat | appointment | ||||||||||||
29884 | 29884 | Alton Lennon L000240 | sen | NC | 1953-07-10 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
29800 | 29800 | David Gambrell G000034 | sen | GA | 1971-02-01 | 1973-01-03 | 2 | Democrat | appointment | ||||||||||||
29485 | 29485 | Ralph Smith S000602 | sen | IL | 1969-09-17 | 1971-01-03 | 3 | Republican | appointment | ||||||||||||
29224 | 29224 | Samuel Ervin E000211 | sen | NC | 1954-06-05 | 1957-01-03 | 3 | Democrat | appointment | ||||||||||||
29102 | 29102 | Charles Goodell G000282 | sen | NY | 1968-09-10 | 1971-01-03 | 1 | Republican | appointment | ||||||||||||
28919 | 28919 | Leonard Jordan J000269 | sen | ID | 1962-08-06 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
28916 | 28916 | Benjamin Jordan J000267 | sen | NC | 1958-04-19 | 1961-01-03 | 2 | Democrat | appointment | ||||||||||||
28635 | 28635 | Donald Russell R000525 | sen | SC | 1965-04-22 | 1967-01-03 | 3 | Democrat | appointment | ||||||||||||
28469 | 28469 | Spessard Holland H000720 | sen | FL | 1946-09-25 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
28308 | 28308 | Pierre Salinger S000016 | sen | CA | 1964-08-04 | 1965-01-03 | 1 | Democrat | appointment | ||||||||||||
28248 | 28248 | Herbert Walters W000110 | sen | TN | 1963-08-20 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
27995 | 27995 | Edward Long L000415 | sen | MO | 1960-09-23 | 1963-01-03 | 3 | Democrat | appointment | ||||||||||||
27974 | 27974 | Thomas Kuchel K000335 | sen | CA | 1953-01-03 | 1957-01-03 | 3 | Republican | appointment | ||||||||||||
27879 | 27879 | Joseph Hill H000598 | sen | AL | 1938-01-11 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
27762 | 27762 | James Edmondson E000055 | sen | OK | 1963-01-09 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
27600 | 27600 | Edwin Mechem M000623 | sen | NM | 1962-11-30 | 1965-01-03 | 1 | Republican | appointment | ||||||||||||
27599 | 27599 | Joseph Bottum B000656 | sen | SD | 1962-07-09 | 1963-01-03 | 3 | Republican | appointment | ||||||||||||
27396 | 27396 | Maurice Murphy M001100 | sen | NH | 1961-12-07 | 1963-01-03 | 2 | Republican | appointment | ||||||||||||
27225 | 27225 | John Hickey H000561 | sen | WY | 1961-01-03 | 1963-01-03 | 2 | Democrat | appointment | ||||||||||||
27189 | 27189 | Henry Dworshak D000585 | sen | ID | 1949-10-14 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
27105 | 27105 | William Blakley B000536 | sen | TX | 1961-01-03 | 1961-12-31 | 2 | Democrat | appointment | ||||||||||||
27104 | 27104 | William Blakley B000536 | sen | TX | 1957-01-15 | 1957-12-31 | 1 | Democrat | appointment | ||||||||||||
27060 | 27060 | Benjamin Smith S000517 | sen | MA | 1960-12-27 | 1963-01-03 | 1 | Democrat | appointment | ||||||||||||
27057 | 27057 | Hall Lusk L000520 | sen | OR | 1960-03-16 | 1961-01-03 | 2 | Democrat | appointment | ||||||||||||
26802 | 26802 | Dennis Chavez C000338 | sen | NM | 1935-05-11 | 1941-01-03 | 1 | Democrat | appointment | ||||||||||||
26775 | 26775 | Harry Byrd B001208 | sen | VA | 1933-03-09 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
26762 | 26762 | Clarence Brunsdale B000982 | sen | ND | 1959-11-19 | 1961-01-03 | 1 | Republican | appointment | ||||||||||||
26691 | 26691 | John Hoblitzell H000665 | sen | WV | 1958-01-25 | 1959-01-03 | 2 | Republican | appointment | ||||||||||||
26155 | 26155 | Thomas Wofford W000666 | sen | SC | 1956-04-05 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
26152 | 26152 | William Laird L000025 | sen | WV | 1956-03-13 | 1957-01-03 | 1 | Democrat | appointment | ||||||||||||
26151 | 26151 | Robert Humphreys H000963 | sen | KY | 1956-06-21 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
25864 | 25864 | Samuel Reynolds R000180 | sen | NE | 1954-07-03 | 1955-01-03 | 1 | Republican | appointment | ||||||||||||
25858 | 25858 | Joseph O’Mahoney O000088 | sen | WY | 1933-12-18 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
25857 | 25857 | Charles Daniel D000031 | sen | SC | 1954-09-06 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
25856 | 25856 | Edward Crippa C000906 | sen | WY | 1954-06-24 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25855 | 25855 | Ernest Brown B000913 | sen | NV | 1954-10-01 | 1955-01-03 | 3 | Republican | appointment | ||||||||||||
25854 | 25854 | Eva Bowring B000709 | sen | NE | 1954-04-16 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25841 | 25841 | Garrett Withers W000658 | sen | KY | 1949-01-20 | 1950-11-26 | 3 | Democrat | appointment | ||||||||||||
25823 | 25823 | Robert Upton U000032 | sen | NH | 1953-08-14 | 1955-01-03 | 3 | Republican | appointment | ||||||||||||
25783 | 25783 | William Purtell P000575 | sen | CT | 1952-08-29 | 1953-01-03 | 3 | Republican | appointment | ||||||||||||
25740 | 25740 | William Knowland K000292 | sen | CA | 1945-08-14 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
25670 | 25670 | Ralph Flanders F000190 | sen | VT | 1946-11-01 | 1947-01-03 | 1 | Republican | 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);