legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by district descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43751 | 43751 | Alan Lowenthal L000579 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 47 | https://lowenthal.house.gov | 108 Cannon House Office Building Washington DC 20515-0547 | 202-225-7924 | 108 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||||
43752 | 43752 | Alan Lowenthal L000579 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 47 | https://lowenthal.house.gov | 108 Cannon House Office Building Washington DC 20515-0547 | 202-225-7924 | 108 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||||
35779 | 35779 | Robert Dornan D000435 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 46 | |||||||||||||
35780 | 35780 | Robert Dornan D000435 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 46 | |||||||||||||
40467 | 40467 | Loretta Sanchez S000030 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 46 | |||||||||||||
40468 | 40468 | Loretta Sanchez S000030 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 46 | |||||||||||||
40469 | 40469 | Loretta Sanchez S000030 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 46 | |||||||||||||
40475 | 40475 | Loretta Sanchez S000030 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 46 | http://lorettasanchez.house.gov | 1114 Longworth HOB; Washington DC 20515-0546 | 202-225-2965 | 202-225-5859 | https://lorettasanchez.house.gov/contact-me/email-me | 1114 Longworth House Office Building | http://lorettasanchez.house.gov/rss.xml | ||||||
40476 | 40476 | Loretta Sanchez S000030 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 46 | http://lorettasanchez.house.gov | 1211 Longworth HOB; Washington DC 20515-0546 | 202-225-2965 | 202-225-5859 | https://lorettasanchez.house.gov/contact-me/email-me | 1211 Longworth House Office Building | http://lorettasanchez.house.gov/rss.xml | ||||||
40981 | 40981 | Dana Rohrabacher R000409 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | ||||||||||||
40982 | 40982 | Dana Rohrabacher R000409 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | ||||||||||||
40983 | 40983 | Dana Rohrabacher R000409 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | ||||||||||||
40984 | 40984 | Dana Rohrabacher R000409 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | ||||||||||||
40985 | 40985 | Dana Rohrabacher R000409 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | 2300 Rayburn HOB; Washington DC 20515-0546 | 202-225-2415 | 202-225-0145 | http://rohrabacher.house.gov/Contact/Zip.htm | 2300 Rayburn House Office Building | |||||||
44127 | 44127 | J. Correa C001110 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 46 | https://correa.house.gov | 1039 Longworth House Office Building; Washington DC 20515-0546 | 202-225-2965 | 1039 Longworth House Office Building | |||||||||
44128 | 44128 | J. Correa C001110 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 46 | https://correa.house.gov | 1039 Longworth House Office Building Washington DC 20515-0546 | 202-225-2965 | 1039 Longworth House Office Building | |||||||||
44129 | 44129 | J. Correa C001110 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 46 | https://correa.house.gov | 2301 Rayburn House Office Building Washington DC 20515-0546 | 202-225-2965 | 2301 Rayburn House Office Building | |||||||||
26963 | 26963 | Daniel Reed R000113 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 45 | |||||||||||||
26964 | 26964 | Daniel Reed R000113 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 45 | |||||||||||||
26965 | 26965 | Daniel Reed R000113 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 45 | |||||||||||||
26966 | 26966 | Daniel Reed R000113 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 45 | |||||||||||||
38116 | 38116 | Duncan Hunter H000981 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 45 | |||||||||||||
38117 | 38117 | Duncan Hunter H000981 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 45 | |||||||||||||
38118 | 38118 | Duncan Hunter H000981 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 45 | |||||||||||||
38119 | 38119 | Duncan Hunter H000981 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 45 | |||||||||||||
38120 | 38120 | Duncan Hunter H000981 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 45 | |||||||||||||
39175 | 39175 | Mary Bono Mack B001228 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 45 | http://www.house.gov/bono | ||||||||||||
39176 | 39176 | Mary Bono Mack B001228 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 45 | http://www.house.gov/bono | ||||||||||||
39177 | 39177 | Mary Bono Mack B001228 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
39178 | 39178 | Mary Bono Mack B001228 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
39179 | 39179 | Mary Bono Mack B001228 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 45 | http://bono.house.gov | 104 Cannon HOB; Washington DC 20515-0545 | 202-225-5330 | 202-225-2961 | http://www.house.gov/formbono/issue.htm | 104 Cannon House Office Building | |||||||
39784 | 39784 | John Campbell C001064 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 45 | http://www.campbell.house.gov | 2331 Rayburn HOB; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | https://campbell.house.gov/email-me | 2331 Rayburn House Office Building | http://www.campbell.house.gov/rss/press1.xml | ||||||
40976 | 40976 | Dana Rohrabacher R000409 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 45 | |||||||||||||
40977 | 40977 | Dana Rohrabacher R000409 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 45 | |||||||||||||
40978 | 40978 | Dana Rohrabacher R000409 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 45 | |||||||||||||
40979 | 40979 | Dana Rohrabacher R000409 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 45 | |||||||||||||
40980 | 40980 | Dana Rohrabacher R000409 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 45 | |||||||||||||
41128 | 41128 | Mimi Walters W000820 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 45 | https://walters.house.gov | 236 Cannon HOB; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | 236 Cannon House Office Building | ||||||||
41129 | 41129 | Mimi Walters W000820 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 45 | https://walters.house.gov | 215 Cannon House Office Building; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | 215 Cannon House Office Building | ||||||||
44288 | 44288 | Katie Porter P000618 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 45 | https://porter.house.gov | 1117 Longworth House Office Building Washington DC 20515-0545 | 202-225-5611 | 1117 Longworth House Office Building | |||||||||
44289 | 44289 | Katie Porter P000618 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 45 | https://porter.house.gov | 1117 Longworth House Office Building Washington DC 20515-0545 | 202-225-5611 | 1117 Longworth House Office Building | |||||||||
24837 | 24837 | Chester Gorski G000331 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 44 | |||||||||||||
25168 | 25168 | John Butler B001179 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 44 | |||||||||||||
25169 | 25169 | John Butler B001179 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 44 | |||||||||||||
25170 | 25170 | John Butler B001179 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 44 | |||||||||||||
33810 | 33810 | Jim Bates B000236 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 44 | |||||||||||||
33811 | 33811 | Jim Bates B000236 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 44 | |||||||||||||
33812 | 33812 | Jim Bates B000236 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 44 | |||||||||||||
33813 | 33813 | Jim Bates B000236 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 44 | |||||||||||||
35409 | 35409 | Alfred McCandless M000306 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 44 | |||||||||||||
36136 | 36136 | Sonny Bono B000622 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 44 | |||||||||||||
36137 | 36137 | Sonny Bono B000622 | rep | CA | 1997-01-07 | 1998-01-05 | Republican | 44 | |||||||||||||
37580 | 37580 | Randall Cunningham C000994 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 44 | |||||||||||||
39172 | 39172 | Mary Bono Mack B001228 | rep | CA | 1998-04-07 | 1999-01-03 | Republican | 44 | |||||||||||||
39173 | 39173 | Mary Bono Mack B001228 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 44 | |||||||||||||
39174 | 39174 | Mary Bono Mack B001228 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 44 | |||||||||||||
40191 | 40191 | Janice Hahn H001063 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 44 | http://hahn.house.gov | 404 Cannon HOB; Washington DC 20515-0544 | 202-225-8220 | 202-226-7290 | https://hahn.house.gov/contact-me/email-me | 404 Cannon House Office Building | http://hahn.house.gov/rss.xml | ||||||
40192 | 40192 | Janice Hahn H001063 | rep | CA | 2015-01-06 | 2016-12-04 | Democrat | 44 | http://hahn.house.gov | 404 Cannon HOB; Washington DC 20515-0544 | 202-225-8220 | 202-226-7290 | https://hahn.house.gov/contact-me/email-me | 404 Cannon House Office Building | http://hahn.house.gov/rss.xml | ||||||
42065 | 42065 | Ken Calvert C000059 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 44 | http://www.house.gov/calvert | ||||||||||||
42066 | 42066 | Ken Calvert C000059 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 44 | http://www.house.gov/calvert | ||||||||||||
42067 | 42067 | Ken Calvert C000059 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 44 | http://calvert.house.gov | ||||||||||||
42068 | 42068 | Ken Calvert C000059 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 44 | http://calvert.house.gov | ||||||||||||
42069 | 42069 | Ken Calvert C000059 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 44 | http://calvert.house.gov | 2269 Rayburn HOB; Washington DC 20515-0544 | 202-225-1986 | 202-225-2004 | http://calvert.house.gov/awenhnjafe.asp | 2269 Rayburn House Office Building | |||||||
44124 | 44124 | Nanette Barragán B001300 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 44 | https://barragan.house.gov | 1320 Longworth House Office Building; Washington DC 20515-0544 | 202-225-8220 | 1320 Longworth House Office Building | |||||||||
44125 | 44125 | Nanette Barragán B001300 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 44 | https://barragan.house.gov | 1030 Longworth House Office Building Washington DC 20515-0544 | 202-225-8220 | 1030 Longworth House Office Building | |||||||||
44126 | 44126 | Nanette Barragán B001300 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 44 | https://barragan.house.gov | 2246 Rayburn House Office Building Washington DC 20515-0544 | 202-225-8220 | 2246 Rayburn House Office Building | |||||||||
17242 | 17242 | Charles Hamilton H000104 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 43 | |||||||||||||
17243 | 17243 | Charles Hamilton H000104 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 43 | |||||||||||||
17244 | 17244 | Charles Hamilton H000104 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 43 | |||||||||||||
24379 | 24379 | Edward Elsaesser E000159 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 43 | |||||||||||||
24380 | 24380 | Edward Elsaesser E000159 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 43 | |||||||||||||
25040 | 25040 | Anthony Tauriello T000056 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 43 | |||||||||||||
26561 | 26561 | Edmund Radwan R000008 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 43 | |||||||||||||
26950 | 26950 | Daniel Reed R000113 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 43 | |||||||||||||
26951 | 26951 | Daniel Reed R000113 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 43 | |||||||||||||
26952 | 26952 | Daniel Reed R000113 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 43 | |||||||||||||
26953 | 26953 | Daniel Reed R000113 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 43 | |||||||||||||
26954 | 26954 | Daniel Reed R000113 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 43 | |||||||||||||
26955 | 26955 | Daniel Reed R000113 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 43 | |||||||||||||
26956 | 26956 | Daniel Reed R000113 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 43 | |||||||||||||
26957 | 26957 | Daniel Reed R000113 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 43 | |||||||||||||
26958 | 26958 | Daniel Reed R000113 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 43 | |||||||||||||
26959 | 26959 | Daniel Reed R000113 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 43 | |||||||||||||
26960 | 26960 | Daniel Reed R000113 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 43 | |||||||||||||
26961 | 26961 | Daniel Reed R000113 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 43 | |||||||||||||
26962 | 26962 | Daniel Reed R000113 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 43 | |||||||||||||
26967 | 26967 | Daniel Reed R000113 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 43 | |||||||||||||
26968 | 26968 | Daniel Reed R000113 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 43 | |||||||||||||
26969 | 26969 | Daniel Reed R000113 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 43 | |||||||||||||
26970 | 26970 | Daniel Reed R000113 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 43 | |||||||||||||
29098 | 29098 | Charles Goodell G000282 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 43 | |||||||||||||
29099 | 29099 | Charles Goodell G000282 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 43 | |||||||||||||
30739 | 30739 | Victor Veysey V000093 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 43 | |||||||||||||
32533 | 32533 | Clair Burgener B001080 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 43 | |||||||||||||
32534 | 32534 | Clair Burgener B001080 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 43 | |||||||||||||
32535 | 32535 | Clair Burgener B001080 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 43 | |||||||||||||
32536 | 32536 | Clair Burgener B001080 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 43 | |||||||||||||
36724 | 36724 | Ron Packard P000005 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 43 | |||||||||||||
36725 | 36725 | Ron Packard P000005 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 43 | |||||||||||||
36726 | 36726 | Ron Packard P000005 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 43 |
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);