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 class
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25490 | 25490 | Frederick Seaton S000214 | sen | NE | 1951-12-10 | 1953-01-03 | 2 | Republican | appointment | ||||||||||||
25533 | 25533 | Thomas Underwood U000015 | sen | KY | 1951-03-19 | 1952-11-04 | 2 | Democrat | appointment | ||||||||||||
25854 | 25854 | Eva Bowring B000709 | sen | NE | 1954-04-16 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25856 | 25856 | Edward Crippa C000906 | sen | WY | 1954-06-24 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25857 | 25857 | Charles Daniel D000031 | sen | SC | 1954-09-06 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
26151 | 26151 | Robert Humphreys H000963 | sen | KY | 1956-06-21 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
26155 | 26155 | Thomas Wofford W000666 | sen | SC | 1956-04-05 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
26691 | 26691 | John Hoblitzell H000665 | sen | WV | 1958-01-25 | 1959-01-03 | 2 | Republican | appointment | ||||||||||||
27057 | 27057 | Hall Lusk L000520 | sen | OR | 1960-03-16 | 1961-01-03 | 2 | Democrat | appointment | ||||||||||||
27105 | 27105 | William Blakley B000536 | sen | TX | 1961-01-03 | 1961-12-31 | 2 | Democrat | appointment | ||||||||||||
27189 | 27189 | Henry Dworshak D000585 | sen | ID | 1949-10-14 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
27225 | 27225 | John Hickey H000561 | sen | WY | 1961-01-03 | 1963-01-03 | 2 | Democrat | appointment | ||||||||||||
27396 | 27396 | Maurice Murphy M001100 | sen | NH | 1961-12-07 | 1963-01-03 | 2 | Republican | appointment | ||||||||||||
27762 | 27762 | James Edmondson E000055 | sen | OK | 1963-01-09 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
28248 | 28248 | Herbert Walters W000110 | sen | TN | 1963-08-20 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
28916 | 28916 | Benjamin Jordan J000267 | sen | NC | 1958-04-19 | 1961-01-03 | 2 | Democrat | appointment | ||||||||||||
28919 | 28919 | Leonard Jordan J000269 | sen | ID | 1962-08-06 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
29800 | 29800 | David Gambrell G000034 | sen | GA | 1971-02-01 | 1973-01-03 | 2 | Democrat | appointment | ||||||||||||
29884 | 29884 | Alton Lennon L000240 | sen | NC | 1953-07-10 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
30135 | 30135 | Elaine Edwards E000068 | sen | LA | 1972-08-01 | 1972-11-13 | 2 | Democrat | appointment | ||||||||||||
30337 | 30337 | James Eastland E000018 | sen | MS | 1941-06-30 | 1941-12-31 | 2 | Democrat | appointment | ||||||||||||
30401 | 30401 | Robert Griffin G000465 | sen | MI | 1966-05-11 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
30597 | 30597 | Walter Mondale M000851 | sen | MN | 1964-12-30 | 1967-01-03 | 2 | Democrat | appointment | ||||||||||||
30608 | 30608 | James Pearson P000166 | sen | KS | 1962-01-31 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
31411 | 31411 | Wendell Anderson A000202 | sen | MN | 1976-12-30 | 1978-12-29 | 2 | Democrat | appointment | ||||||||||||
31591 | 31591 | Kaneaster Hodges H000675 | sen | AR | 1977-12-10 | 1979-01-03 | 2 | Democrat | appointment | ||||||||||||
31914 | 31914 | Paul Hatfield H000344 | sen | MT | 1978-01-22 | 1978-12-14 | 2 | Democrat | appointment | ||||||||||||
35391 | 35391 | Harlan Mathews M000236 | sen | TN | 1993-01-05 | 1995-01-03 | 2 | Democrat | appointment | ||||||||||||
37216 | 37216 | Dean Barkley B001237 | sen | MN | 2002-11-05 | 2003-01-03 | 2 | Independent | appointment | ||||||||||||
37480 | 37480 | Ted Stevens S000888 | sen | AK | 1968-12-24 | 1973-01-03 | 2 | Republican | appointment | ||||||||||||
38931 | 38931 | Edward Kaufman K000373 | sen | DE | 2009-01-16 | 2010-11-15 | 2 | Democrat | appointment | http://kaufman.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 | ||||||
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 | |||||
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 | ||||||
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 | ||||||
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 | |||||
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 | |||||
16652 | 16652 | Johnson Camden C000063 | sen | KY | 1914-06-16 | 1915-03-03 | 3 | Democrat | appointment | ||||||||||||
17043 | 17043 | Thomas Taggart T000013 | sen | IN | 1916-03-20 | 1917-03-03 | 3 | Democrat | appointment | ||||||||||||
17522 | 17522 | Irving Drew D000495 | sen | NH | 1918-09-02 | 1919-03-03 | 3 | Republican | appointment | ||||||||||||
17524 | 17524 | Walter Guion G000522 | sen | LA | 1918-04-22 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
17525 | 17525 | Charles Henderson H000477 | sen | NV | 1918-01-12 | 1921-03-03 | 3 | Democrat | appointment | ||||||||||||
17529 | 17529 | John Nugent N000169 | sen | ID | 1918-01-22 | 1921-03-03 | 3 | Democrat | appointment | ||||||||||||
17531 | 17531 | Xenophon Wilfley W000471 | sen | MO | 1918-04-30 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
18560 | 18560 | Rebecca Felton F000069 | sen | GA | 1922-10-03 | 1923-03-03 | 3 | Democrat | appointment | ||||||||||||
18561 | 18561 | George Pepper P000219 | sen | PA | 1922-01-09 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
19166 | 19166 | George Williams W000499 | sen | MO | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
19186 | 19186 | David Stewart S000906 | sen | IA | 1926-08-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
19570 | 19570 | Cyrus Locher L000386 | sen | OH | 1928-04-04 | 1929-03-03 | 3 | Democrat | appointment | ||||||||||||
19571 | 19571 | Henry Allen A000126 | sen | KS | 1929-04-15 | 1931-03-03 | 3 | Republican | appointment | ||||||||||||
19752 | 19752 | Joseph Grundy G000510 | sen | PA | 1929-12-11 | 1931-03-03 | 3 | Republican | appointment | ||||||||||||
19870 | 19870 | Roscoe McCulloch M000392 | sen | OH | 1929-11-05 | 1931-03-03 | 3 | Republican | appointment | ||||||||||||
21062 | 21062 | Elijah Grammer G000366 | sen | WA | 1932-11-22 | 1933-03-03 | 3 | Republican | appointment | ||||||||||||
21065 | 21065 | Walter Walker W000069 | sen | CO | 1932-09-26 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
22015 | 22015 | William Hill H000612 | sen | FL | 1936-07-01 | 1937-01-03 | 3 | Democrat | appointment | ||||||||||||
22016 | 22016 | Herbert Hitchcock H000646 | sen | SD | 1936-12-29 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
22185 | 22185 | Dixie Graves G000391 | sen | AL | 1937-08-20 | 1938-01-10 | 3 | Democrat | appointment | ||||||||||||
22466 | 22466 | Alfred Reames R000099 | sen | OR | 1938-02-01 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
22467 | 22467 | Thomas Storke S000973 | sen | CA | 1938-11-09 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
22468 | 22468 | Alva Adams A000028 | sen | CO | 1923-12-03 | 1925-03-03 | 3 | Democrat | appointment | ||||||||||||
22515 | 22515 | Hattie Caraway C000138 | sen | AR | 1931-12-07 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
22611 | 22611 | Ernest Gibson G000158 | sen | VT | 1933-11-21 | 1939-01-03 | 3 | Republican | appointment | ||||||||||||
22734 | 22734 | Gerald Nye N000176 | sen | ND | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
22840 | 22840 | Ernest Gibson G000159 | sen | VT | 1940-06-24 | 1941-12-31 | 3 | Republican | appointment | ||||||||||||
23624 | 23624 | Cameron Morrison M000993 | sen | NC | 1930-12-13 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
23708 | 23708 | John Thomas T000172 | sen | ID | 1928-06-30 | 1933-03-03 | 3 | Republican | appointment | ||||||||||||
23761 | 23761 | Wilton Hall H000080 | sen | SC | 1944-11-20 | 1945-01-03 | 3 | Democrat | appointment | ||||||||||||
23762 | 23762 | Samuel Jackson J000026 | sen | IN | 1944-01-28 | 1945-01-03 | 3 | Democrat | appointment | ||||||||||||
24731 | 24731 | William Feazel F000057 | sen | LA | 1948-05-18 | 1949-01-03 | 3 | Democrat | appointment | ||||||||||||
24815 | 24815 | Harry Darby D000048 | sen | KS | 1949-12-02 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
24821 | 24821 | John Dulles D000522 | sen | NY | 1949-07-07 | 1949-12-31 | 3 | Republican | appointment | ||||||||||||
25387 | 25387 | Eugene Millikin M000771 | sen | CO | 1941-12-20 | 1945-01-03 | 3 | Republican | appointment | ||||||||||||
25616 | 25616 | Thomas Burke B001099 | sen | OH | 1953-10-13 | 1955-01-03 | 3 | Democrat | appointment | ||||||||||||
25783 | 25783 | William Purtell P000575 | sen | CT | 1952-08-29 | 1953-01-03 | 3 | Republican | appointment | ||||||||||||
25823 | 25823 | Robert Upton U000032 | sen | NH | 1953-08-14 | 1955-01-03 | 3 | Republican | appointment | ||||||||||||
25841 | 25841 | Garrett Withers W000658 | sen | KY | 1949-01-20 | 1950-11-26 | 3 | Democrat | appointment | ||||||||||||
25855 | 25855 | Ernest Brown B000913 | sen | NV | 1954-10-01 | 1955-01-03 | 3 | Republican | appointment | ||||||||||||
27599 | 27599 | Joseph Bottum B000656 | sen | SD | 1962-07-09 | 1963-01-03 | 3 | Republican | appointment | ||||||||||||
27879 | 27879 | Joseph Hill H000598 | sen | AL | 1938-01-11 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
27974 | 27974 | Thomas Kuchel K000335 | sen | CA | 1953-01-03 | 1957-01-03 | 3 | Republican | appointment | ||||||||||||
27995 | 27995 | Edward Long L000415 | sen | MO | 1960-09-23 | 1963-01-03 | 3 | Democrat | appointment | ||||||||||||
28635 | 28635 | Donald Russell R000525 | sen | SC | 1965-04-22 | 1967-01-03 | 3 | Democrat | appointment | ||||||||||||
29224 | 29224 | Samuel Ervin E000211 | sen | NC | 1954-06-05 | 1957-01-03 | 3 | Democrat | appointment | ||||||||||||
29485 | 29485 | Ralph Smith S000602 | sen | IL | 1969-09-17 | 1971-01-03 | 3 | Republican | appointment | ||||||||||||
30786 | 30786 | Louis Wyman W000782 | sen | NH | 1974-12-31 | 1975-01-03 | 3 | Republican | appointment | ||||||||||||
30885 | 30885 | Norris Cotton C000802 | sen | NH | 1975-08-08 | 1975-09-18 | 3 | Republican | appointment | ||||||||||||
31402 | 31402 | Milton Young Y000047 | sen | ND | 1945-03-12 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
31913 | 31913 | Maryon Allen A000139 | sen | AL | 1978-06-08 | 1978-11-07 | 3 | Democrat | appointment | ||||||||||||
33469 | 33469 | James Broyhill B000966 | sen | NC | 1986-07-14 | 1986-11-04 | 3 | Republican | appointment | ||||||||||||
34013 | 34013 | Howard Metzenbaum M000678 | sen | OH | 1974-01-04 | 1974-12-23 | 3 | Democrat | appointment | ||||||||||||
36132 | 36132 | Sheila Frahm F000438 | sen | KS | 1996-06-11 | 1996-11-05 | 3 | Republican | appointment | ||||||||||||
36778 | 36778 | Zell Miller M001141 | sen | GA | 2000-07-24 | 2005-01-03 | 3 | Democrat | appointment | http://miller.senate.gov/ | |||||||||||
38930 | 38930 | Roland Burris B001266 | sen | IL | 2009-01-15 | 2010-11-29 | 3 | Democrat | appointment | http://burris.senate.gov/ | |||||||||||
38933 | 38933 | George LeMieux L000572 | sen | FL | 2009-09-10 | 2011-01-03 | 3 | Republican | appointment | http://lemieux.senate.gov/ | |||||||||||
40214 | 40214 | Daniel Coats C000542 | sen | IN | 1989-01-03 | 1993-01-03 | 3 | Republican | 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 | |||||
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 | |||||
41932 | 41932 | Michael Bennet B001267 | sen | CO | 2009-01-22 | 2011-01-03 | 3 | Democrat | appointment | http://bennet.senate.gov/ | |||||||||||
42958 | 42958 | Lisa Murkowski M001153 | sen | AK | 2003-01-07 | 2005-01-03 | 3 | Republican | appointment | http://murkowski.senate.gov/ |
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);