legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,731 rows where state = "TX"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12386 | 12386 | Roger Mills M000777 | rep | TX | 1891-12-07 | 1892-03-29 | Democrat | 9 | |||||||||||||
12387 | 12387 | Roger Mills M000777 | sen | TX | 1892-03-30 | 1893-03-03 | 1 | Democrat | |||||||||||||
12388 | 12388 | Roger Mills M000777 | sen | TX | 1893-03-04 | 1899-03-03 | 1 | Democrat | |||||||||||||
12587 | 12587 | Walter Gresham G000452 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12653 | 12653 | Constantine Kilgore K000173 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 3 | |||||||||||||
12654 | 12654 | Constantine Kilgore K000173 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12655 | 12655 | Constantine Kilgore K000173 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12656 | 12656 | Constantine Kilgore K000173 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12749 | 12749 | Thomas Paschal P000094 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
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 | |||||||||||||
12914 | 12914 | Charles Bell B000333 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12915 | 12915 | Charles Bell B000333 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
12937 | 12937 | Horace Chilton C000357 | sen | TX | 1891-12-07 | 1893-03-03 | 1 | Democrat | |||||||||||||
12938 | 12938 | Horace Chilton C000357 | sen | TX | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
12952 | 12952 | Jeremiah Cockrell C000577 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12953 | 12953 | Jeremiah Cockrell C000577 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 13 | |||||||||||||
12965 | 12965 | William Crain C000865 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
12966 | 12966 | William Crain C000865 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 7 | |||||||||||||
12967 | 12967 | William Crain C000865 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
12968 | 12968 | William Crain C000865 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12969 | 12969 | William Crain C000865 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 11 | |||||||||||||
12970 | 12970 | William Crain C000865 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 11 | |||||||||||||
12978 | 12978 | Miles Crowley C000944 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
12980 | 12980 | David Culberson C000964 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
12981 | 12981 | David Culberson C000964 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
12982 | 12982 | David Culberson C000964 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
12983 | 12983 | David Culberson C000964 | rep | TX | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
12984 | 12984 | David Culberson C000964 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
12985 | 12985 | David Culberson C000964 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
12986 | 12986 | David Culberson C000964 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
12987 | 12987 | David Culberson C000964 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12988 | 12988 | David Culberson C000964 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12989 | 12989 | David Culberson C000964 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12990 | 12990 | David Culberson C000964 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13040 | 13040 | Joseph Hutcheson H001007 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
13041 | 13041 | Joseph Hutcheson H001007 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
13110 | 13110 | George Noonan N000131 | rep | TX | 1895-12-02 | 1897-03-03 | Republican | 12 | |||||||||||||
13115 | 13115 | George Pendleton P000202 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
13116 | 13116 | George Pendleton P000202 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
13225 | 13225 | Charles Yoakum Y000018 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13285 | 13285 | John Cranford C000876 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13465 | 13465 | Joseph Sayers S000099 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
13466 | 13466 | Joseph Sayers S000099 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 10 | |||||||||||||
13467 | 13467 | Joseph Sayers S000099 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 10 | |||||||||||||
13468 | 13468 | Joseph Sayers S000099 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 10 | |||||||||||||
13469 | 13469 | Joseph Sayers S000099 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
13470 | 13470 | Joseph Sayers S000099 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
13471 | 13471 | Joseph Sayers S000099 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
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 | |||||||||||||
13898 | 13898 | Robert Burke B001097 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13899 | 13899 | Robert Burke B001097 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
13900 | 13900 | Robert Burke B001097 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
13932 | 13932 | Reese De Graffenreid D000194 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13933 | 13933 | Reese De Graffenreid D000194 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
13934 | 13934 | Reese De Graffenreid D000194 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14033 | 14033 | Rudolph Kleberg K000258 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 11 | |||||||||||||
14034 | 14034 | Rudolph Kleberg K000258 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 11 | |||||||||||||
14035 | 14035 | Rudolph Kleberg K000258 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 11 | |||||||||||||
14036 | 14036 | Rudolph Kleberg K000258 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 11 | |||||||||||||
14041 | 14041 | Samuel Lanham L000078 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 11 | |||||||||||||
14042 | 14042 | Samuel Lanham L000078 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 11 | |||||||||||||
14043 | 14043 | Samuel Lanham L000078 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 11 | |||||||||||||
14044 | 14044 | Samuel Lanham L000078 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 11 | |||||||||||||
14045 | 14045 | Samuel Lanham L000078 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 11 | |||||||||||||
14046 | 14046 | Samuel Lanham L000078 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
14047 | 14047 | Samuel Lanham L000078 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
14048 | 14048 | Samuel Lanham L000078 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
14165 | 14165 | John Sheppard S000336 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
14166 | 14166 | John Sheppard S000336 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14220 | 14220 | Dudley Wooten W000740 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
14590 | 14590 | Moses Broocks B000870 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
14652 | 14652 | Scott Field F000107 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14653 | 14653 | Scott Field F000107 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
14863 | 14863 | John Pinckney P000356 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
14864 | 14864 | John Pinckney P000356 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
15035 | 15035 | Samuel Cooper C000761 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
15036 | 15036 | Samuel Cooper C000761 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
15037 | 15037 | Samuel Cooper C000761 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
15038 | 15038 | Samuel Cooper C000761 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
15039 | 15039 | Samuel Cooper C000761 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
15040 | 15040 | Samuel Cooper C000761 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15041 | 15041 | Samuel Cooper C000761 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15482 | 15482 | Oscar Gillespie G000198 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
15483 | 15483 | Oscar Gillespie G000198 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 12 |
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);