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)
Suggested facets: class, party, address, phone, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18140 | 18140 | William Crow C000938 | sen | PA | 1921-10-17 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
18907 | 18907 | William Butler B001196 | sen | MA | 1924-11-13 | 1927-03-04 | 1 | Republican | appointment | ||||||||||||
19176 | 19176 | Thomas du Pont D000560 | sen | DE | 1921-07-07 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
19646 | 19646 | Bronson Cutting C001028 | sen | NM | 1927-12-29 | 1928-12-06 | 1 | Republican | appointment | ||||||||||||
19940 | 19940 | David Reed R000114 | sen | PA | 1922-08-08 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
19944 | 19944 | Arthur Robinson R000332 | sen | IN | 1925-12-07 | 1929-03-03 | 1 | Republican | appointment | ||||||||||||
20071 | 20071 | Frank Partridge P000091 | sen | VT | 1930-12-23 | 1931-12-31 | 1 | Republican | appointment | ||||||||||||
21583 | 21583 | William Thompson T000225 | sen | NE | 1933-05-24 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
22018 | 22018 | Scott Loftin L000400 | sen | FL | 1936-05-26 | 1937-01-03 | 1 | Democrat | appointment | ||||||||||||
22464 | 22464 | John Milton M000787 | sen | NJ | 1938-01-18 | 1939-01-03 | 1 | Democrat | appointment | ||||||||||||
23732 | 23732 | Arthur Walsh W000096 | sen | NJ | 1943-11-26 | 1945-01-03 | 1 | Democrat | appointment | ||||||||||||
23787 | 23787 | Frank Briggs B000828 | sen | MO | 1945-01-18 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
23790 | 23790 | Berkeley Bunker B001061 | sen | NV | 1940-11-27 | 1941-01-03 | 1 | Democrat | appointment | ||||||||||||
23802 | 23802 | Edward Carville C000211 | sen | NV | 1945-07-25 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
23873 | 23873 | Thomas Hart H000293 | sen | CT | 1945-02-15 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
23895 | 23895 | James Huffman H000913 | sen | OH | 1945-10-08 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
24707 | 24707 | Arthur Vandenberg V000025 | sen | MI | 1928-03-31 | 1929-01-03 | 1 | Republican | appointment | ||||||||||||
24739 | 24739 | William Benton B000399 | sen | CT | 1949-12-17 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
24880 | 24880 | Edward Leahy L000173 | sen | RI | 1949-08-24 | 1950-12-18 | 1 | Democrat | appointment | ||||||||||||
25390 | 25390 | Hugh Mitchell M000814 | sen | WA | 1945-01-10 | 1946-12-25 | 1 | Democrat | appointment | ||||||||||||
25393 | 25393 | Arthur Moody M000878 | sen | MI | 1951-04-23 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
25670 | 25670 | Ralph Flanders F000190 | sen | VT | 1946-11-01 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
25740 | 25740 | William Knowland K000292 | sen | CA | 1945-08-14 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
25858 | 25858 | Joseph O’Mahoney O000088 | sen | WY | 1933-12-18 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
25864 | 25864 | Samuel Reynolds R000180 | sen | NE | 1954-07-03 | 1955-01-03 | 1 | Republican | appointment | ||||||||||||
26152 | 26152 | William Laird L000025 | sen | WV | 1956-03-13 | 1957-01-03 | 1 | Democrat | appointment | ||||||||||||
26762 | 26762 | Clarence Brunsdale B000982 | sen | ND | 1959-11-19 | 1961-01-03 | 1 | Republican | appointment | ||||||||||||
26775 | 26775 | Harry Byrd B001208 | sen | VA | 1933-03-09 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
26802 | 26802 | Dennis Chavez C000338 | sen | NM | 1935-05-11 | 1941-01-03 | 1 | Democrat | appointment | ||||||||||||
27060 | 27060 | Benjamin Smith S000517 | sen | MA | 1960-12-27 | 1963-01-03 | 1 | Democrat | appointment | ||||||||||||
27104 | 27104 | William Blakley B000536 | sen | TX | 1957-01-15 | 1957-12-31 | 1 | Democrat | appointment | ||||||||||||
27600 | 27600 | Edwin Mechem M000623 | sen | NM | 1962-11-30 | 1965-01-03 | 1 | Republican | appointment | ||||||||||||
28308 | 28308 | Pierre Salinger S000016 | sen | CA | 1964-08-04 | 1965-01-03 | 1 | Democrat | appointment | ||||||||||||
28469 | 28469 | Spessard Holland H000720 | sen | FL | 1946-09-25 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
29102 | 29102 | Charles Goodell G000282 | sen | NY | 1968-09-10 | 1971-01-03 | 1 | Republican | appointment | ||||||||||||
31469 | 31469 | Harry Byrd B001209 | sen | VA | 1965-11-12 | 1971-01-03 | 1 | Democrat | appointment | ||||||||||||
31915 | 31915 | Muriel Humphrey H000956 | sen | MN | 1978-01-25 | 1978-11-07 | 1 | Democrat | appointment | ||||||||||||
32894 | 32894 | Nicholas Brady B000756 | sen | NJ | 1982-04-12 | 1982-12-27 | 1 | Republican | appointment | ||||||||||||
32968 | 32968 | Daniel Evans E000236 | sen | WA | 1983-09-08 | 1989-01-03 | 1 | Republican | appointment | ||||||||||||
33152 | 33152 | Robert Stafford S000776 | sen | VT | 1971-09-16 | 1977-01-03 | 1 | Republican | appointment | ||||||||||||
33622 | 33622 | David Karnes K000011 | sen | NE | 1987-03-11 | 1989-01-03 | 1 | Republican | appointment | ||||||||||||
34018 | 34018 | George Mitchell M000811 | sen | ME | 1980-05-17 | 1983-01-03 | 1 | Democrat | appointment | ||||||||||||
34950 | 34950 | John Seymour S000269 | sen | CA | 1991-01-07 | 1993-01-03 | 1 | Republican | appointment | ||||||||||||
35057 | 35057 | Harris Wofford W000665 | sen | PA | 1991-05-08 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
35090 | 35090 | Jocelyn Burdick B001076 | sen | ND | 1992-09-16 | 1992-12-14 | 1 | Democrat | appointment | ||||||||||||
35353 | 35353 | Robert Krueger K000333 | sen | TX | 1993-01-21 | 1993-12-31 | 1 | Democrat | appointment | ||||||||||||
36854 | 36854 | Jean Carnahan C001043 | sen | MO | 2001-01-03 | 2003-01-03 | 1 | Democrat | appointment | ||||||||||||
36855 | 36855 | Lincoln Chafee C001040 | sen | RI | 1999-11-02 | 2001-01-03 | 1 | Republican | appointment | ||||||||||||
38934 | 38934 | Paul Kirk K000374 | sen | MA | 2009-09-25 | 2010-02-04 | 1 | Democrat | appointment | http://kirk.senate.gov/ | |||||||||||
38936 | 38936 | Carte Goodwin G000561 | sen | WV | 2010-07-20 | 2010-11-14 | 1 | Democrat | appointment | ||||||||||||
39037 | 39037 | Daniel Akaka A000069 | sen | HI | 1990-05-16 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
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 | |||||||
41786 | 41786 | Robert Menendez M000639 | sen | NJ | 2006-01-18 | 2007-01-03 | 1 | Democrat | appointment | http://menendez.senate.gov/ | |||||||||||
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 | ||||||
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 | ||||||
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 | ||||||
16397 | 16397 | John Heiskell H000457 | sen | AR | 1913-04-07 | 1913-12-31 | 2 | Democrat | appointment | ||||||||||||
16417 | 16417 | Rienzi Johnston J000196 | sen | TX | 1913-04-07 | 1913-12-31 | 2 | Democrat | appointment | ||||||||||||
16660 | 16660 | William West W000305 | sen | GA | 1914-03-02 | 1915-03-03 | 2 | Democrat | appointment | ||||||||||||
17520 | 17520 | David Baird B000052 | sen | NJ | 1918-02-23 | 1919-03-03 | 2 | Republican | appointment | ||||||||||||
17521 | 17521 | Christie Benet B000360 | sen | SC | 1918-07-06 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
17526 | 17526 | George Martin M000181 | sen | KY | 1918-09-07 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
18031 | 18031 | Braxton Comer C000657 | sen | AL | 1920-03-05 | 1921-03-03 | 2 | Democrat | appointment | ||||||||||||
18079 | 18079 | Holm Bursum B001144 | sen | NM | 1921-04-11 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
18562 | 18562 | Charles Rawson R000075 | sen | IA | 1922-02-24 | 1923-03-03 | 2 | Republican | appointment | ||||||||||||
19572 | 19572 | David Baird B000053 | sen | NJ | 1929-11-30 | 1931-03-03 | 2 | Republican | appointment | ||||||||||||
19597 | 19597 | William Brock B000850 | sen | TN | 1929-09-02 | 1931-03-03 | 2 | Democrat | appointment | ||||||||||||
20001 | 20001 | Patrick Sullivan S001060 | sen | WY | 1929-12-05 | 1930-11-20 | 2 | Republican | appointment | ||||||||||||
20251 | 20251 | James Couzens C000812 | sen | MI | 1922-11-29 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
20478 | 20478 | Daniel Hastings H000325 | sen | DE | 1928-12-10 | 1931-03-03 | 2 | Republican | appointment | ||||||||||||
21061 | 21061 | John Cohen C000597 | sen | GA | 1932-04-25 | 1933-12-31 | 2 | Democrat | appointment | ||||||||||||
21105 | 21105 | Nathan Bachman B000010 | sen | TN | 1933-03-09 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
21253 | 21253 | John Erickson E000202 | sen | MT | 1933-03-13 | 1935-01-03 | 2 | Democrat | appointment | ||||||||||||
21640 | 21640 | Elmer Benson B000389 | sen | MN | 1935-12-27 | 1937-01-03 | 2 | Farmer-Labor | appointment | ||||||||||||
22019 | 22019 | Rose Long L000427 | sen | LA | 1936-01-31 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
22036 | 22036 | George Berry B000417 | sen | TN | 1937-05-06 | 1939-01-03 | 2 | Democrat | appointment | ||||||||||||
22782 | 22782 | James Slattery S000478 | sen | IL | 1939-04-14 | 1941-01-03 | 2 | Democrat | appointment | ||||||||||||
22856 | 22856 | William Barbour B000132 | sen | NJ | 1931-12-07 | 1937-01-03 | 2 | Republican | appointment | ||||||||||||
23043 | 23043 | Andrew Houston H000821 | sen | TX | 1941-04-21 | 1941-12-31 | 2 | Democrat | appointment | ||||||||||||
23106 | 23106 | Alva Lumpkin L000510 | sen | SC | 1941-07-17 | 1941-12-31 | 2 | Democrat | appointment | ||||||||||||
23170 | 23170 | Roger Peace P000159 | sen | SC | 1941-08-05 | 1941-12-31 | 2 | Democrat | appointment | ||||||||||||
23206 | 23206 | Joseph Rosier R000443 | sen | WV | 1941-01-13 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23257 | 23257 | George Spencer S000724 | sen | AR | 1941-04-01 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23344 | 23344 | Joseph Ball B000099 | sen | MN | 1940-10-14 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
23372 | 23372 | Albert Chandler C000290 | sen | KY | 1939-10-10 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23521 | 23521 | Carter Glass G000232 | sen | VA | 1920-02-20 | 1925-03-03 | 2 | Democrat | appointment | ||||||||||||
23548 | 23548 | Carl Hatch H000334 | sen | NM | 1933-10-10 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
23605 | 23605 | Charles McNary M000583 | sen | OR | 1917-05-29 | 1918-11-05 | 2 | Republican | appointment | ||||||||||||
23606 | 23606 | Charles McNary M000583 | sen | OR | 1918-12-18 | 1919-03-03 | 2 | Republican | appointment | ||||||||||||
23709 | 23709 | John Thomas T000172 | sen | ID | 1940-01-27 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
23763 | 23763 | Sinclair Weeks W000248 | sen | MA | 1944-02-08 | 1945-01-03 | 2 | Republican | appointment | ||||||||||||
23852 | 23852 | Charles Gossett G000337 | sen | ID | 1945-11-17 | 1947-01-03 | 2 | Democrat | appointment | ||||||||||||
24105 | 24105 | William Stanfill S000792 | sen | KY | 1945-11-19 | 1947-01-03 | 2 | Republican | appointment | ||||||||||||
24241 | 24241 | Thomas Burch B001069 | sen | VA | 1946-05-31 | 1946-11-05 | 2 | Democrat | appointment | ||||||||||||
24244 | 24244 | George Swift S001117 | sen | AL | 1946-06-15 | 1947-01-03 | 2 | Democrat | appointment | ||||||||||||
24249 | 24249 | William Umstead U000005 | sen | NC | 1946-12-18 | 1949-01-03 | 2 | Democrat | appointment | ||||||||||||
24656 | 24656 | John Robsion R000358 | sen | KY | 1930-01-11 | 1930-11-30 | 2 | Republican | appointment | ||||||||||||
24730 | 24730 | Vera Bushfield B001169 | sen | SD | 1948-10-06 | 1948-12-26 | 2 | Republican | appointment | ||||||||||||
24812 | 24812 | Guy Cordon C000774 | sen | OR | 1944-03-04 | 1949-01-03 | 2 | Republican | appointment | ||||||||||||
24842 | 24842 | Frank Graham G000353 | sen | NC | 1949-03-29 | 1951-01-03 | 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);