legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
51 rows where district = 42
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, state, party, url, address, phone, fax, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16751 | 16751 | Daniel Driscoll D000500 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 42 | |||||||||||||
16752 | 16752 | Daniel Driscoll D000500 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 42 | |||||||||||||
17496 | 17496 | William Waldow W000039 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 42 | |||||||||||||
23128 | 23128 | James Mead M000615 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 42 | |||||||||||||
23129 | 23129 | James Mead M000615 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 42 | |||||||||||||
23130 | 23130 | James Mead M000615 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 42 | |||||||||||||
23131 | 23131 | James Mead M000615 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 42 | |||||||||||||
23132 | 23132 | James Mead M000615 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 42 | |||||||||||||
23133 | 23133 | James Mead M000615 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 42 | |||||||||||||
23134 | 23134 | James Mead M000615 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 42 | |||||||||||||
23135 | 23135 | James Mead M000615 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 42 | |||||||||||||
23136 | 23136 | James Mead M000615 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 42 | |||||||||||||
23226 | 23226 | Pius Schwert S000162 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 42 | |||||||||||||
23227 | 23227 | Pius Schwert S000162 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 42 | |||||||||||||
24259 | 24259 | Walter Andrews A000250 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 42 | |||||||||||||
24260 | 24260 | Walter Andrews A000250 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 42 | |||||||||||||
24989 | 24989 | William Pfeiffer P000286 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 42 | |||||||||||||
25166 | 25166 | John Butler B001179 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 42 | |||||||||||||
25167 | 25167 | John Butler B001179 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 42 | |||||||||||||
28013 | 28013 | William Miller M000762 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 42 | |||||||||||||
28089 | 28089 | John Pillion P000352 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 42 | |||||||||||||
28090 | 28090 | John Pillion P000352 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 42 | |||||||||||||
28091 | 28091 | John Pillion P000352 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 42 | |||||||||||||
28092 | 28092 | John Pillion P000352 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 42 | |||||||||||||
28093 | 28093 | John Pillion P000352 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 42 | |||||||||||||
32373 | 32373 | Lionel Van Deerlin V000024 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 42 | |||||||||||||
32374 | 32374 | Lionel Van Deerlin V000024 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 42 | |||||||||||||
32375 | 32375 | Lionel Van Deerlin V000024 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 42 | |||||||||||||
32532 | 32532 | Clair Burgener B001080 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 42 | |||||||||||||
36536 | 36536 | George Brown B000918 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 42 | |||||||||||||
36537 | 36537 | George Brown B000918 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 42 | |||||||||||||
36538 | 36538 | George Brown B000918 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 42 | |||||||||||||
36539 | 36539 | George Brown B000918 | rep | CA | 1999-01-06 | 1999-07-15 | Democrat | 42 | |||||||||||||
38115 | 38115 | Duncan Hunter H000981 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 42 | |||||||||||||
39111 | 39111 | Joe Baca B001234 | rep | CA | 1999-11-06 | 2001-01-03 | Democrat | 42 | |||||||||||||
39112 | 39112 | Joe Baca B001234 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 42 | |||||||||||||
39402 | 39402 | Daniel Lungren L000517 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 42 | |||||||||||||
39403 | 39403 | Daniel Lungren L000517 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 42 | |||||||||||||
39404 | 39404 | Daniel Lungren L000517 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 42 | |||||||||||||
39956 | 39956 | Gary Miller M001139 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 42 | http://www.house.gov/garymiller | ||||||||||||
39957 | 39957 | Gary Miller M001139 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 42 | http://www.house.gov/garymiller | ||||||||||||
39958 | 39958 | Gary Miller M001139 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 42 | http://www.house.gov/garymiller | ||||||||||||
39959 | 39959 | Gary Miller M001139 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 42 | http://www.house.gov/garymiller | ||||||||||||
39960 | 39960 | Gary Miller M001139 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 42 | http://www.house.gov/garymiller | 2349 Rayburn HOB; Washington DC 20515-0542 | 202-225-3201 | 202-226-6962 | http://garymiller.house.gov/Contact/ | 2349 Rayburn House Office Building | |||||||
40974 | 40974 | Dana Rohrabacher R000409 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 42 | |||||||||||||
40975 | 40975 | Dana Rohrabacher R000409 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 42 | |||||||||||||
42070 | 42070 | Ken Calvert C000059 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 42 | http://calvert.house.gov | 2269 Rayburn HOB; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | https://calvert.house.gov/contactform/ | 2269 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||
42071 | 42071 | Ken Calvert C000059 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 42 | http://calvert.house.gov | 2205 Rayburn HOB; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | https://calvert.house.gov/contactform/ | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||
42072 | 42072 | Ken Calvert C000059 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 42 | https://calvert.house.gov | 2205 Rayburn House Office Building; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | |||||||
42073 | 42073 | Ken Calvert C000059 | rep | CA | 2019-01-03 | 2021-01-03 | Republican | 42 | https://calvert.house.gov | 2205 Rayburn House Office Building Washington DC 20515-0542 | 202-225-1986 | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||||
42074 | 42074 | Ken Calvert C000059 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 42 | https://calvert.house.gov | 2205 Rayburn House Office Building Washington DC 20515-0542 | 202-225-1986 | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx |
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);