legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,731 rows where state = "TX" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, party, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12886 | 12886 | Jo Abbott A000005 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 6 | |||||||||||||
12887 | 12887 | Jo Abbott A000005 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
12888 | 12888 | Jo Abbott A000005 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12889 | 12889 | Jo Abbott A000005 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12890 | 12890 | Jo Abbott A000005 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
27603 | 27603 | Bruce Alger A000106 | rep | TX | 1955-01-05 | 1957-01-03 | Republican | 5 | |||||||||||||
27604 | 27604 | Bruce Alger A000106 | rep | TX | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27605 | 27605 | Bruce Alger A000106 | rep | TX | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
27606 | 27606 | Bruce Alger A000106 | rep | TX | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
27607 | 27607 | Bruce Alger A000106 | rep | TX | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
35091 | 35091 | Michael Andrews A000209 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 25 | |||||||||||||
35092 | 35092 | Michael Andrews A000209 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 25 | |||||||||||||
35093 | 35093 | Michael Andrews A000209 | rep | TX | 1987-01-06 | 1989-01-03 | Democrat | 25 | |||||||||||||
35094 | 35094 | Michael Andrews A000209 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 25 | |||||||||||||
35095 | 35095 | Michael Andrews A000209 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 25 | |||||||||||||
35096 | 35096 | Michael Andrews A000209 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 25 | |||||||||||||
36472 | 36472 | Bill Archer A000215 | rep | TX | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
36473 | 36473 | Bill Archer A000215 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
36474 | 36474 | Bill Archer A000215 | rep | TX | 1975-01-14 | 1977-01-03 | Republican | 7 | |||||||||||||
36475 | 36475 | Bill Archer A000215 | rep | TX | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
36476 | 36476 | Bill Archer A000215 | rep | TX | 1979-01-15 | 1981-01-03 | Republican | 7 | |||||||||||||
36477 | 36477 | Bill Archer A000215 | rep | TX | 1981-01-05 | 1983-01-03 | Republican | 7 | |||||||||||||
36478 | 36478 | Bill Archer A000215 | rep | TX | 1983-01-03 | 1985-01-03 | Republican | 7 | |||||||||||||
36479 | 36479 | Bill Archer A000215 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 7 | |||||||||||||
36480 | 36480 | Bill Archer A000215 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 7 | |||||||||||||
36481 | 36481 | Bill Archer A000215 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 7 | |||||||||||||
36482 | 36482 | Bill Archer A000215 | rep | TX | 1991-01-03 | 1993-01-03 | Republican | 7 | |||||||||||||
36483 | 36483 | Bill Archer A000215 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 7 | |||||||||||||
36484 | 36484 | Bill Archer A000215 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 7 | |||||||||||||
36485 | 36485 | Bill Archer A000215 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
36486 | 36486 | Bill Archer A000215 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 7 | |||||||||||||
36781 | 36781 | Richard Armey A000217 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 26 | |||||||||||||
36782 | 36782 | Richard Armey A000217 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 26 | |||||||||||||
36783 | 36783 | Richard Armey A000217 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 26 | |||||||||||||
36784 | 36784 | Richard Armey A000217 | rep | TX | 1991-01-03 | 1993-01-03 | Republican | 26 | |||||||||||||
36785 | 36785 | Richard Armey A000217 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 26 | |||||||||||||
36786 | 36786 | Richard Armey A000217 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 26 | |||||||||||||
36787 | 36787 | Richard Armey A000217 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 26 | |||||||||||||
36788 | 36788 | Richard Armey A000217 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 26 | |||||||||||||
36789 | 36789 | Richard Armey A000217 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 26 | |||||||||||||
12069 | 12069 | Edwin Antony A000264 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
44218 | 44218 | Jodey Arrington A000375 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 19 | https://arrington.house.gov | 1029 Longworth House Office Building; Washington DC 20515-4319 | 202-225-4005 | 1029 Longworth House Office Building | |||||||||
44219 | 44219 | Jodey Arrington A000375 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 19 | https://arrington.house.gov | 1029 Longworth House Office Building Washington DC 20515-4319 | 202-225-4005 | 1029 Longworth House Office Building | |||||||||
44220 | 44220 | Jodey Arrington A000375 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 19 | https://arrington.house.gov | 1107 Longworth House Office Building Washington DC 20515-4319 | 202-225-4005 | 1107 Longworth House Office Building | |||||||||
44398 | 44398 | Colin Allred A000376 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 32 | https://allred.house.gov | 328 Cannon House Office Building Washington DC 20515-4332 | 202-225-2231 | 328 Cannon House Office Building | |||||||||
44399 | 44399 | Colin Allred A000376 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 32 | https://allred.house.gov | 114 Cannon House Office Building Washington DC 20515-4332 | 202-225-2231 | 114 Cannon House Office Building | |||||||||
14969 | 14969 | Joseph Bailey B000044 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
14970 | 14970 | Joseph Bailey B000044 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
14971 | 14971 | Joseph Bailey B000044 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
14972 | 14972 | Joseph Bailey B000044 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
14973 | 14973 | Joseph Bailey B000044 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
14974 | 14974 | Joseph Bailey B000044 | sen | TX | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14975 | 14975 | Joseph Bailey B000044 | sen | TX | 1907-12-02 | 1913-03-03 | 2 | Democrat | |||||||||||||
21106 | 21106 | Joseph Bailey B000045 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
14240 | 14240 | Thomas Ball B000101 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
14241 | 14241 | Thomas Ball B000101 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
14242 | 14242 | Thomas Ball B000101 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14243 | 14243 | Thomas Ball B000101 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
34228 | 34228 | Harry Bartlett B000204 | rep | TX | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
34229 | 34229 | Harry Bartlett B000204 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
34230 | 34230 | Harry Bartlett B000204 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 3 | |||||||||||||
34231 | 34231 | Harry Bartlett B000204 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
34232 | 34232 | Harry Bartlett B000204 | rep | TX | 1991-01-03 | 1991-03-11 | Republican | 3 | |||||||||||||
40694 | 40694 | Joe Barton B000213 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
40695 | 40695 | Joe Barton B000213 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 6 | |||||||||||||
40696 | 40696 | Joe Barton B000213 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
40697 | 40697 | Joe Barton B000213 | rep | TX | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
40698 | 40698 | Joe Barton B000213 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
40699 | 40699 | Joe Barton B000213 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
40700 | 40700 | Joe Barton B000213 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
40701 | 40701 | Joe Barton B000213 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
40702 | 40702 | Joe Barton B000213 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
40703 | 40703 | Joe Barton B000213 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/barton | ||||||||||||
40704 | 40704 | Joe Barton B000213 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/barton | ||||||||||||
40705 | 40705 | Joe Barton B000213 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 6 | http://joebarton.house.gov | ||||||||||||
40706 | 40706 | Joe Barton B000213 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 6 | http://joebarton.house.gov | ||||||||||||
40707 | 40707 | Joe Barton B000213 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 6 | http://joebarton.house.gov | 2109 Rayburn HOB; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | http://joebarton.house.gov/ContactJoe.aspx?Type=Email | 2109 Rayburn House Office Building | |||||||
40708 | 40708 | Joe Barton B000213 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 6 | http://joebarton.house.gov | 2107 Rayburn HOB; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | https://joebarton.house.gov/contact1/ | 2107 Rayburn House Office Building | http://joebarton.house.gov/index.php?format=feed&type=rss | ||||||
40709 | 40709 | Joe Barton B000213 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 6 | http://joebarton.house.gov | 2107 Rayburn HOB; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | https://joebarton.house.gov/contact1/ | 2107 Rayburn House Office Building | http://joebarton.house.gov/index.php?format=feed&type=rss | ||||||
40710 | 40710 | Joe Barton B000213 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 6 | https://joebarton.house.gov | 2107 Rayburn House Office Building; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | 2107 Rayburn House Office Building | http://joebarton.house.gov/index.php?format=feed&type=rss | |||||||
16284 | 16284 | James Beall B000270 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
16285 | 16285 | James Beall B000270 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
16286 | 16286 | James Beall B000270 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
16287 | 16287 | James Beall B000270 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
16288 | 16288 | James Beall B000270 | rep | TX | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
16289 | 16289 | James Beall B000270 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
28317 | 28317 | Lindley Beckworth B000296 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
28318 | 28318 | Lindley Beckworth B000296 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
28319 | 28319 | Lindley Beckworth B000296 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
28320 | 28320 | Lindley Beckworth B000296 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
28321 | 28321 | Lindley Beckworth B000296 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
28322 | 28322 | Lindley Beckworth B000296 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
28323 | 28323 | Lindley Beckworth B000296 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28324 | 28324 | Lindley Beckworth B000296 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28325 | 28325 | Lindley Beckworth B000296 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
28326 | 28326 | Lindley Beckworth B000296 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28327 | 28327 | Lindley Beckworth B000296 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28328 | 28328 | Lindley Beckworth B000296 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
17559 | 17559 | Carlos Bee B000303 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
12914 | 12914 | Charles Bell B000333 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 8 |
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);