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 party_affiliations
This data as json, copyable, CSV (advanced)
Suggested facets: class, state_rank, start (date), end (date)
party 6 ✖
- Democrat 1,329
- Republican 396
- American 2
- National Greenbacker 2
- Ind. Democrat 1
- Independent 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5803 | 5803 | Timothy Pilsbury P000353 | rep | TX | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5804 | 5804 | Timothy Pilsbury P000353 | rep | TX | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6022 | 6022 | David Kaufman K000021 | rep | TX | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6023 | 6023 | David Kaufman K000021 | rep | TX | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6024 | 6024 | David Kaufman K000021 | rep | TX | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6332 | 6332 | Volney Howard H000845 | rep | TX | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6333 | 6333 | Volney Howard H000845 | rep | TX | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6399 | 6399 | Thomas Rusk R000518 | sen | TX | 1846-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6400 | 6400 | Thomas Rusk R000518 | sen | TX | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
6411 | 6411 | Richardson Scurry S000207 | rep | TX | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6617 | 6617 | Samuel Houston H000827 | sen | TX | 1846-02-21 | 1847-03-03 | 2 | Democrat | |||||||||||||
6618 | 6618 | Samuel Houston H000827 | sen | TX | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
6619 | 6619 | Samuel Houston H000827 | sen | TX | 1853-12-05 | 1859-03-03 | 2 | American | |||||||||||||
6693 | 6693 | George Smyth S000647 | rep | TX | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6770 | 6770 | Peter Bell B000344 | rep | TX | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6771 | 6771 | Peter Bell B000344 | rep | TX | 1855-12-03 | 1857-03-03 | Democrat | 2 | |||||||||||||
6811 | 6811 | Lemuel Evans E000251 | rep | TX | 1855-12-03 | 1857-03-03 | American | 1 | |||||||||||||
6998 | 6998 | Guy Bryan B000985 | rep | TX | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
7088 | 7088 | James Henderson H000481 | sen | TX | 1857-12-07 | 1859-03-03 | 1 | Democrat | |||||||||||||
7271 | 7271 | Matthias Ward W000138 | sen | TX | 1858-01-01 | 1859-12-31 | 1 | Democrat | |||||||||||||
7431 | 7431 | Andrew Hamilton H000103 | rep | TX | 1859-12-05 | 1861-03-03 | Ind. Democrat | 2 | |||||||||||||
7442 | 7442 | John Hemphill H000468 | sen | TX | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
7628 | 7628 | Louis Wigfall W000447 | sen | TX | 1859-12-05 | 1861-12-31 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
8860 | 8860 | John Conner C000691 | rep | TX | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8861 | 8861 | John Conner C000691 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
9198 | 9198 | William Herndon H000535 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9199 | 9199 | William Herndon H000535 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9270 | 9270 | William McLean M000553 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9421 | 9421 | Asa Willie W000555 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9822 | 9822 | De Giddings G000166 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9823 | 9823 | De Giddings G000166 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9824 | 9824 | De Giddings G000166 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10185 | 10185 | Gustave Schleicher S000129 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
10186 | 10186 | Gustave Schleicher S000129 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10187 | 10187 | Gustave Schleicher S000129 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | -1 | |||||||||||||
10406 | 10406 | George Jones J000223 | rep | TX | 1879-03-18 | 1881-03-03 | National Greenbacker | 5 | |||||||||||||
10407 | 10407 | George Jones J000223 | rep | TX | 1881-12-05 | 1883-03-03 | National Greenbacker | 5 | |||||||||||||
10446 | 10446 | Samuel Maxey M000265 | sen | TX | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10447 | 10447 | Samuel Maxey M000265 | sen | TX | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
10571 | 10571 | Christopher Upson U000028 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10572 | 10572 | Christopher Upson U000028 | rep | TX | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
10731 | 10731 | John Hancock H000150 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
10732 | 10732 | John Hancock H000150 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
10733 | 10733 | John Hancock H000150 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
10734 | 10734 | John Hancock H000150 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 10 | |||||||||||||
10827 | 10827 | Thomas Ochiltree O000021 | rep | TX | 1883-12-03 | 1885-03-03 | Independent | 7 | |||||||||||||
11094 | 11094 | James Jones J000230 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
11095 | 11095 | James Jones J000230 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11130 | 11130 | James Miller M000732 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
11131 | 11131 | James Miller M000732 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11227 | 11227 | James Throckmorton T000246 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
11228 | 11228 | James Throckmorton T000246 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
11229 | 11229 | James Throckmorton T000246 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
11230 | 11230 | James Throckmorton T000246 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11261 | 11261 | Olin Wellborn W000272 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
11262 | 11262 | Olin Wellborn W000272 | rep | TX | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
11263 | 11263 | Olin Wellborn W000272 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
11264 | 11264 | Olin Wellborn W000272 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11481 | 11481 | John Reagan R000098 | rep | TX | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
11482 | 11482 | John Reagan R000098 | rep | TX | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
11483 | 11483 | John Reagan R000098 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
11484 | 11484 | John Reagan R000098 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
11485 | 11485 | John Reagan R000098 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11486 | 11486 | John Reagan R000098 | rep | TX | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
11487 | 11487 | John Reagan R000098 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
11488 | 11488 | John Reagan R000098 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11489 | 11489 | John Reagan R000098 | sen | TX | 1887-12-05 | 1891-12-31 | 1 | Democrat | |||||||||||||
11674 | 11674 | Richard Coke C000601 | sen | TX | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
11675 | 11675 | Richard Coke C000601 | sen | TX | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11676 | 11676 | Richard Coke C000601 | sen | TX | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
11777 | 11777 | Silas Hare H000203 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 5 | |||||||||||||
11778 | 11778 | Silas Hare H000203 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11836 | 11836 | William Martin M000203 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
11837 | 11837 | William Martin M000203 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12069 | 12069 | Edwin Antony A000264 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12231 | 12231 | John Long L000422 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12245 | 12245 | Littleton Moore M000908 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 8 | |||||||||||||
12246 | 12246 | Littleton Moore M000908 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
12247 | 12247 | Littleton Moore M000908 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12306 | 12306 | Charles Stewart S000904 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
12307 | 12307 | Charles Stewart S000904 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
12308 | 12308 | Charles Stewart S000904 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
12309 | 12309 | Charles Stewart S000904 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12310 | 12310 | Charles Stewart S000904 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12377 | 12377 | Roger Mills M000777 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
12378 | 12378 | Roger Mills M000777 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
12379 | 12379 | Roger Mills M000777 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
12380 | 12380 | Roger Mills M000777 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
12381 | 12381 | Roger Mills M000777 | rep | TX | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
12382 | 12382 | Roger Mills M000777 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 9 | |||||||||||||
12383 | 12383 | Roger Mills M000777 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
12384 | 12384 | Roger Mills M000777 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 9 | |||||||||||||
12385 | 12385 | Roger Mills M000777 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 9 |
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);