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 state
This data as json, copyable, CSV (advanced)
Suggested facets: party, address, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37480 | 37480 | Ted Stevens S000888 | sen | AK | 1968-12-24 | 1973-01-03 | 2 | Republican | appointment | ||||||||||||
42958 | 42958 | Lisa Murkowski M001153 | sen | AK | 2003-01-07 | 2005-01-03 | 3 | Republican | appointment | http://murkowski.senate.gov/ | |||||||||||
18031 | 18031 | Braxton Comer C000657 | sen | AL | 1920-03-05 | 1921-03-03 | 2 | Democrat | appointment | ||||||||||||
22185 | 22185 | Dixie Graves G000391 | sen | AL | 1937-08-20 | 1938-01-10 | 3 | Democrat | appointment | ||||||||||||
24244 | 24244 | George Swift S001117 | sen | AL | 1946-06-15 | 1947-01-03 | 2 | Democrat | appointment | ||||||||||||
27879 | 27879 | Joseph Hill H000598 | sen | AL | 1938-01-11 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
31913 | 31913 | Maryon Allen A000139 | sen | AL | 1978-06-08 | 1978-11-07 | 3 | Democrat | appointment | ||||||||||||
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 | ||||||
16397 | 16397 | John Heiskell H000457 | sen | AR | 1913-04-07 | 1913-12-31 | 2 | Democrat | appointment | ||||||||||||
22515 | 22515 | Hattie Caraway C000138 | sen | AR | 1931-12-07 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
23257 | 23257 | George Spencer S000724 | sen | AR | 1941-04-01 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
31591 | 31591 | Kaneaster Hodges H000675 | sen | AR | 1977-12-10 | 1979-01-03 | 2 | Democrat | appointment | ||||||||||||
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 | |||||
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 | |||||
22467 | 22467 | Thomas Storke S000973 | sen | CA | 1938-11-09 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
25740 | 25740 | William Knowland K000292 | sen | CA | 1945-08-14 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
27974 | 27974 | Thomas Kuchel K000335 | sen | CA | 1953-01-03 | 1957-01-03 | 3 | Republican | appointment | ||||||||||||
28308 | 28308 | Pierre Salinger S000016 | sen | CA | 1964-08-04 | 1965-01-03 | 1 | Democrat | appointment | ||||||||||||
34950 | 34950 | John Seymour S000269 | sen | CA | 1991-01-07 | 1993-01-03 | 1 | Republican | appointment | ||||||||||||
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 | ||||||
21065 | 21065 | Walter Walker W000069 | sen | CO | 1932-09-26 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
22468 | 22468 | Alva Adams A000028 | sen | CO | 1923-12-03 | 1925-03-03 | 3 | Democrat | appointment | ||||||||||||
25387 | 25387 | Eugene Millikin M000771 | sen | CO | 1941-12-20 | 1945-01-03 | 3 | Republican | appointment | ||||||||||||
41932 | 41932 | Michael Bennet B001267 | sen | CO | 2009-01-22 | 2011-01-03 | 3 | Democrat | appointment | http://bennet.senate.gov/ | |||||||||||
23873 | 23873 | Thomas Hart H000293 | sen | CT | 1945-02-15 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
24739 | 24739 | William Benton B000399 | sen | CT | 1949-12-17 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
25783 | 25783 | William Purtell P000575 | sen | CT | 1952-08-29 | 1953-01-03 | 3 | Republican | appointment | ||||||||||||
19176 | 19176 | Thomas du Pont D000560 | sen | DE | 1921-07-07 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
20478 | 20478 | Daniel Hastings H000325 | sen | DE | 1928-12-10 | 1931-03-03 | 2 | Republican | appointment | ||||||||||||
38931 | 38931 | Edward Kaufman K000373 | sen | DE | 2009-01-16 | 2010-11-15 | 2 | Democrat | appointment | http://kaufman.senate.gov/ | |||||||||||
22015 | 22015 | William Hill H000612 | sen | FL | 1936-07-01 | 1937-01-03 | 3 | Democrat | appointment | ||||||||||||
22018 | 22018 | Scott Loftin L000400 | sen | FL | 1936-05-26 | 1937-01-03 | 1 | Democrat | appointment | ||||||||||||
28469 | 28469 | Spessard Holland H000720 | sen | FL | 1946-09-25 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
38933 | 38933 | George LeMieux L000572 | sen | FL | 2009-09-10 | 2011-01-03 | 3 | Republican | appointment | http://lemieux.senate.gov/ | |||||||||||
16660 | 16660 | William West W000305 | sen | GA | 1914-03-02 | 1915-03-03 | 2 | Democrat | appointment | ||||||||||||
18560 | 18560 | Rebecca Felton F000069 | sen | GA | 1922-10-03 | 1923-03-03 | 3 | Democrat | appointment | ||||||||||||
21061 | 21061 | John Cohen C000597 | sen | GA | 1932-04-25 | 1933-12-31 | 2 | Democrat | appointment | ||||||||||||
29800 | 29800 | David Gambrell G000034 | sen | GA | 1971-02-01 | 1973-01-03 | 2 | Democrat | appointment | ||||||||||||
36778 | 36778 | Zell Miller M001141 | sen | GA | 2000-07-24 | 2005-01-03 | 3 | Democrat | appointment | http://miller.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 | |||||
39037 | 39037 | Daniel Akaka A000069 | sen | HI | 1990-05-16 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
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 | |||||
18562 | 18562 | Charles Rawson R000075 | sen | IA | 1922-02-24 | 1923-03-03 | 2 | Republican | appointment | ||||||||||||
19186 | 19186 | David Stewart S000906 | sen | IA | 1926-08-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
17529 | 17529 | John Nugent N000169 | sen | ID | 1918-01-22 | 1921-03-03 | 3 | Democrat | appointment | ||||||||||||
23708 | 23708 | John Thomas T000172 | sen | ID | 1928-06-30 | 1933-03-03 | 3 | Republican | appointment | ||||||||||||
23709 | 23709 | John Thomas T000172 | sen | ID | 1940-01-27 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
23852 | 23852 | Charles Gossett G000337 | sen | ID | 1945-11-17 | 1947-01-03 | 2 | Democrat | appointment | ||||||||||||
27189 | 27189 | Henry Dworshak D000585 | sen | ID | 1949-10-14 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
28919 | 28919 | Leonard Jordan J000269 | sen | ID | 1962-08-06 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
22782 | 22782 | James Slattery S000478 | sen | IL | 1939-04-14 | 1941-01-03 | 2 | Democrat | appointment | ||||||||||||
29485 | 29485 | Ralph Smith S000602 | sen | IL | 1969-09-17 | 1971-01-03 | 3 | Republican | appointment | ||||||||||||
38930 | 38930 | Roland Burris B001266 | sen | IL | 2009-01-15 | 2010-11-29 | 3 | Democrat | appointment | http://burris.senate.gov/ | |||||||||||
17043 | 17043 | Thomas Taggart T000013 | sen | IN | 1916-03-20 | 1917-03-03 | 3 | Democrat | appointment | ||||||||||||
19944 | 19944 | Arthur Robinson R000332 | sen | IN | 1925-12-07 | 1929-03-03 | 1 | Republican | appointment | ||||||||||||
23762 | 23762 | Samuel Jackson J000026 | sen | IN | 1944-01-28 | 1945-01-03 | 3 | Democrat | appointment | ||||||||||||
40214 | 40214 | Daniel Coats C000542 | sen | IN | 1989-01-03 | 1993-01-03 | 3 | Republican | appointment | ||||||||||||
19571 | 19571 | Henry Allen A000126 | sen | KS | 1929-04-15 | 1931-03-03 | 3 | Republican | appointment | ||||||||||||
24815 | 24815 | Harry Darby D000048 | sen | KS | 1949-12-02 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
30608 | 30608 | James Pearson P000166 | sen | KS | 1962-01-31 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
36132 | 36132 | Sheila Frahm F000438 | sen | KS | 1996-06-11 | 1996-11-05 | 3 | Republican | appointment | ||||||||||||
16652 | 16652 | Johnson Camden C000063 | sen | KY | 1914-06-16 | 1915-03-03 | 3 | Democrat | appointment | ||||||||||||
17526 | 17526 | George Martin M000181 | sen | KY | 1918-09-07 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
23372 | 23372 | Albert Chandler C000290 | sen | KY | 1939-10-10 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
24105 | 24105 | William Stanfill S000792 | sen | KY | 1945-11-19 | 1947-01-03 | 2 | Republican | appointment | ||||||||||||
24656 | 24656 | John Robsion R000358 | sen | KY | 1930-01-11 | 1930-11-30 | 2 | Republican | appointment | ||||||||||||
25533 | 25533 | Thomas Underwood U000015 | sen | KY | 1951-03-19 | 1952-11-04 | 2 | Democrat | appointment | ||||||||||||
25841 | 25841 | Garrett Withers W000658 | sen | KY | 1949-01-20 | 1950-11-26 | 3 | Democrat | appointment | ||||||||||||
26151 | 26151 | Robert Humphreys H000963 | sen | KY | 1956-06-21 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
17524 | 17524 | Walter Guion G000522 | sen | LA | 1918-04-22 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
22019 | 22019 | Rose Long L000427 | sen | LA | 1936-01-31 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
24731 | 24731 | William Feazel F000057 | sen | LA | 1948-05-18 | 1949-01-03 | 3 | Democrat | appointment | ||||||||||||
30135 | 30135 | Elaine Edwards E000068 | sen | LA | 1972-08-01 | 1972-11-13 | 2 | Democrat | appointment | ||||||||||||
18907 | 18907 | William Butler B001196 | sen | MA | 1924-11-13 | 1927-03-04 | 1 | Republican | appointment | ||||||||||||
23763 | 23763 | Sinclair Weeks W000248 | sen | MA | 1944-02-08 | 1945-01-03 | 2 | Republican | appointment | ||||||||||||
27060 | 27060 | Benjamin Smith S000517 | sen | MA | 1960-12-27 | 1963-01-03 | 1 | Democrat | appointment | ||||||||||||
38934 | 38934 | Paul Kirk K000374 | sen | MA | 2009-09-25 | 2010-02-04 | 1 | Democrat | appointment | http://kirk.senate.gov/ | |||||||||||
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 | ||||||
34018 | 34018 | George Mitchell M000811 | sen | ME | 1980-05-17 | 1983-01-03 | 1 | Democrat | appointment | ||||||||||||
20251 | 20251 | James Couzens C000812 | sen | MI | 1922-11-29 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
24707 | 24707 | Arthur Vandenberg V000025 | sen | MI | 1928-03-31 | 1929-01-03 | 1 | Republican | appointment | ||||||||||||
25393 | 25393 | Arthur Moody M000878 | sen | MI | 1951-04-23 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
30401 | 30401 | Robert Griffin G000465 | sen | MI | 1966-05-11 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
21640 | 21640 | Elmer Benson B000389 | sen | MN | 1935-12-27 | 1937-01-03 | 2 | Farmer-Labor | appointment | ||||||||||||
23344 | 23344 | Joseph Ball B000099 | sen | MN | 1940-10-14 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
30597 | 30597 | Walter Mondale M000851 | sen | MN | 1964-12-30 | 1967-01-03 | 2 | Democrat | appointment | ||||||||||||
31411 | 31411 | Wendell Anderson A000202 | sen | MN | 1976-12-30 | 1978-12-29 | 2 | Democrat | appointment | ||||||||||||
31915 | 31915 | Muriel Humphrey H000956 | sen | MN | 1978-01-25 | 1978-11-07 | 1 | Democrat | appointment | ||||||||||||
37216 | 37216 | Dean Barkley B001237 | sen | MN | 2002-11-05 | 2003-01-03 | 2 | Independent | appointment | ||||||||||||
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 | |||||
17531 | 17531 | Xenophon Wilfley W000471 | sen | MO | 1918-04-30 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
19166 | 19166 | George Williams W000499 | sen | MO | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
23787 | 23787 | Frank Briggs B000828 | sen | MO | 1945-01-18 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
27995 | 27995 | Edward Long L000415 | sen | MO | 1960-09-23 | 1963-01-03 | 3 | Democrat | appointment | ||||||||||||
36854 | 36854 | Jean Carnahan C001043 | sen | MO | 2001-01-03 | 2003-01-03 | 1 | Democrat | appointment | ||||||||||||
30337 | 30337 | James Eastland E000018 | sen | MS | 1941-06-30 | 1941-12-31 | 2 | Democrat | appointment | ||||||||||||
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 | ||||||
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 | |||||
21253 | 21253 | John Erickson E000202 | sen | MT | 1933-03-13 | 1935-01-03 | 2 | Democrat | appointment | ||||||||||||
31914 | 31914 | Paul Hatfield H000344 | sen | MT | 1978-01-22 | 1978-12-14 | 2 | Democrat | 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);