legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
396 rows where party = "Republican" and state = "TX"
This data as json, copyable, CSV (advanced)
Suggested facets: type, district, phone, state_rank, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8570 | 8570 | Edward Degener D000195 | rep | TX | 1869-03-04 | 1871-03-03 | Republican | 4 | |||||||||||||
8779 | 8779 | George Whitmore W000424 | rep | TX | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8791 | 8791 | James Flanagan F000186 | sen | TX | 1870-01-01 | 1875-03-03 | 1 | Republican | |||||||||||||
8792 | 8792 | Morgan Hamilton H000115 | sen | TX | 1870-03-31 | 1871-03-03 | 2 | Republican | |||||||||||||
8793 | 8793 | Morgan Hamilton H000115 | sen | TX | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8856 | 8856 | William Clark C000455 | rep | TX | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8857 | 8857 | William Clark C000455 | rep | TX | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
13110 | 13110 | George Noonan N000131 | rep | TX | 1895-12-02 | 1897-03-03 | Republican | 12 | |||||||||||||
13706 | 13706 | Robert Hawley H000378 | rep | TX | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
13707 | 13707 | Robert Hawley H000378 | rep | TX | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
21039 | 21039 | Harry Wurzbach W000775 | rep | TX | 1921-04-11 | 1923-03-03 | Republican | 14 | |||||||||||||
21040 | 21040 | Harry Wurzbach W000775 | rep | TX | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
21041 | 21041 | Harry Wurzbach W000775 | rep | TX | 1925-12-07 | 1927-03-04 | Republican | 14 | |||||||||||||
21042 | 21042 | Harry Wurzbach W000775 | rep | TX | 1927-12-05 | 1929-03-03 | Republican | 14 | |||||||||||||
21043 | 21043 | Harry Wurzbach W000775 | rep | TX | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
21044 | 21044 | Harry Wurzbach W000775 | rep | TX | 1931-12-07 | 1933-03-03 | Republican | 14 | |||||||||||||
24843 | 24843 | Ben Guill G000521 | rep | TX | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
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 | |||||||||||||
29269 | 29269 | Edgar Foreman F000272 | rep | TX | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
30617 | 30617 | Robert Price P000528 | rep | TX | 1967-01-10 | 1969-01-03 | Republican | 18 | |||||||||||||
30618 | 30618 | Robert Price P000528 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
30619 | 30619 | Robert Price P000528 | rep | TX | 1971-01-21 | 1973-01-03 | Republican | 18 | |||||||||||||
30620 | 30620 | Robert Price P000528 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 13 | |||||||||||||
31335 | 31335 | Alan Steelman S000841 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
31336 | 31336 | Alan Steelman S000841 | rep | TX | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
32344 | 32344 | John Tower T000322 | sen | TX | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
32345 | 32345 | John Tower T000322 | sen | TX | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
32346 | 32346 | John Tower T000322 | sen | TX | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
32347 | 32347 | John Tower T000322 | sen | TX | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32566 | 32566 | James Collins C000638 | rep | TX | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
32567 | 32567 | James Collins C000638 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
32568 | 32568 | James Collins C000638 | rep | TX | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
32569 | 32569 | James Collins C000638 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
32570 | 32570 | James Collins C000638 | rep | TX | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
32571 | 32571 | James Collins C000638 | rep | TX | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
32572 | 32572 | James Collins C000638 | rep | TX | 1979-01-15 | 1981-01-03 | Republican | 3 | |||||||||||||
32573 | 32573 | James Collins C000638 | rep | TX | 1981-01-05 | 1983-01-03 | Republican | 3 | |||||||||||||
33333 | 33333 | Thomas Loeffler L000396 | rep | TX | 1979-01-15 | 1981-01-03 | Republican | 21 | |||||||||||||
33334 | 33334 | Thomas Loeffler L000396 | rep | TX | 1981-01-05 | 1983-01-03 | Republican | 21 | |||||||||||||
33335 | 33335 | Thomas Loeffler L000396 | rep | TX | 1983-01-03 | 1985-01-03 | Republican | 21 | |||||||||||||
33336 | 33336 | Thomas Loeffler L000396 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 21 | |||||||||||||
33524 | 33524 | Eldon Boulter B000666 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 13 | |||||||||||||
33525 | 33525 | Eldon Boulter B000666 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 13 | |||||||||||||
33781 | 33781 | David Sweeney S001101 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 14 | |||||||||||||
33782 | 33782 | David Sweeney S001101 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 14 | |||||||||||||
34160 | 34160 | George Bush B001166 | rep | TX | 1967-01-10 | 1969-01-03 | Republican | 7 | |||||||||||||
34161 | 34161 | George Bush B001166 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
35791 | 35791 | Jack Fields F000111 | rep | TX | 1981-01-05 | 1983-01-03 | Republican | 8 | |||||||||||||
35792 | 35792 | Jack Fields F000111 | rep | TX | 1983-01-03 | 1985-01-03 | Republican | 8 | |||||||||||||
35793 | 35793 | Jack Fields F000111 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 8 | |||||||||||||
35794 | 35794 | Jack Fields F000111 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 8 | |||||||||||||
35795 | 35795 | Jack Fields F000111 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
35796 | 35796 | Jack Fields F000111 | rep | TX | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
35797 | 35797 | Jack Fields F000111 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 8 | |||||||||||||
35798 | 35798 | Jack Fields F000111 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
35887 | 35887 | Gregory Laughlin L000119 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 14 | [ { "start": "1995-01-04", "end": "1995-06-26", "party": "Democrat" }, { "start": "1995-06-26", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
36224 | 36224 | Phil Gramm G000365 | rep | TX | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
36225 | 36225 | Phil Gramm G000365 | sen | TX | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
36226 | 36226 | Phil Gramm G000365 | sen | TX | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
36227 | 36227 | Phil Gramm G000365 | sen | TX | 1997-01-07 | 2002-11-29 | 2 | Republican | |||||||||||||
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 | |||||||||||||
37264 | 37264 | Larry Combest C000653 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 19 | |||||||||||||
37265 | 37265 | Larry Combest C000653 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 19 | |||||||||||||
37266 | 37266 | Larry Combest C000653 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 19 | |||||||||||||
37267 | 37267 | Larry Combest C000653 | rep | TX | 1991-01-03 | 1993-01-03 | Republican | 19 | |||||||||||||
37268 | 37268 | Larry Combest C000653 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 19 | |||||||||||||
37269 | 37269 | Larry Combest C000653 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 19 | |||||||||||||
37270 | 37270 | Larry Combest C000653 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 19 |
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);