legislator_terms

Table actions Table actions

1,810 rows where state = "TX"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, class, party, district, start (date), end (date)

Link rowid ▼ legislator_id type state start end class party district how party_affiliations caucus url address phone fax contact_form office state_rank rss_url end-type
5803 5803 P000353 rep TX 1845-12-01 1847-03-03   Democrat 2                        
5804 5804 P000353 rep TX 1847-12-06 1849-03-03   Democrat 2                        
6022 6022 K000021 rep TX 1845-12-01 1847-03-03   Democrat 1                        
6023 6023 K000021 rep TX 1847-12-06 1849-03-03   Democrat 1                        
6024 6024 K000021 rep TX 1849-12-03 1851-03-03   Democrat 1                        
6332 6332 H000845 rep TX 1849-12-03 1851-03-03   Democrat 2                        
6333 6333 H000845 rep TX 1851-12-01 1853-03-03   Democrat 2                        
6399 6399 R000518 sen TX 1846-01-01 1851-03-03 1 Democrat                          
6400 6400 R000518 sen TX 1851-12-01 1857-03-03 1 Democrat                          
6411 6411 S000207 rep TX 1851-12-01 1853-03-03   Democrat 1                        
6617 6617 H000827 sen TX 1846-02-21 1847-03-03 2 Democrat                          
6618 6618 H000827 sen TX 1847-12-06 1853-03-03 2 Democrat                          
6619 6619 H000827 sen TX 1853-12-05 1859-03-03 2 American                          
6693 6693 S000647 rep TX 1853-12-05 1855-03-03   Democrat 1                        
6770 6770 B000344 rep TX 1853-12-05 1855-03-03   Democrat 2                        
6771 6771 B000344 rep TX 1855-12-03 1857-03-03   Democrat 2                        
6811 6811 E000251 rep TX 1855-12-03 1857-03-03   American 1                        
6998 6998 B000985 rep TX 1857-12-07 1859-03-03   Democrat 2                        
7088 7088 H000481 sen TX 1857-12-07 1859-03-03 1 Democrat                          
7271 7271 W000138 sen TX 1858-01-01 1859-12-31 1 Democrat                          
7431 7431 H000103 rep TX 1859-12-05 1861-03-03   Ind. Democrat 2                        
7442 7442 H000468 sen TX 1859-12-05 1861-12-31 2 Democrat                          
7628 7628 W000447 sen TX 1859-12-05 1861-12-31 1 Democrat                          
8570 8570 D000195 rep TX 1869-03-04 1871-03-03   Republican 4                        
8779 8779 W000424 rep TX 1869-03-04 1871-03-03   Republican 1                        
8791 8791 F000186 sen TX 1870-01-01 1875-03-03 1 Republican                          
8792 8792 H000115 sen TX 1870-03-31 1871-03-03 2 Republican                          
8793 8793 H000115 sen TX 1871-03-04 1877-03-03 2 Republican                          
8856 8856 C000455 rep TX 1869-03-04 1871-03-03   Republican 3                        
8857 8857 C000455 rep TX 1871-03-04 1873-03-03   Republican 3                        
8860 8860 C000691 rep TX 1869-03-04 1871-03-03   Democrat 2                        
8861 8861 C000691 rep TX 1871-03-04 1873-03-03   Democrat 2                        
9198 9198 H000535 rep TX 1871-03-04 1873-03-03   Democrat 1                        
9199 9199 H000535 rep TX 1873-12-01 1875-03-03   Democrat 1                        
9270 9270 M000553 rep TX 1873-12-01 1875-03-03   Democrat 2                        
9421 9421 W000555 rep TX 1873-12-01 1875-03-03   Democrat -1                        
9822 9822 G000166 rep TX 1871-03-04 1873-03-03   Democrat 3                        
9823 9823 G000166 rep TX 1873-12-01 1875-03-03   Democrat 3                        
9824 9824 G000166 rep TX 1877-10-15 1879-03-03   Democrat 5                        
10185 10185 S000129 rep TX 1875-12-06 1877-03-03   Democrat 6                        
10186 10186 S000129 rep TX 1877-10-15 1879-03-03   Democrat 6                        
10187 10187 S000129 rep TX 1879-03-18 1881-03-03   Democrat -1                        
10406 10406 J000223 rep TX 1879-03-18 1881-03-03   National Greenbacker 5                        
10407 10407 J000223 rep TX 1881-12-05 1883-03-03   National Greenbacker 5                        
10446 10446 M000265 sen TX 1875-12-06 1881-03-03 1 Democrat                          
10447 10447 M000265 sen TX 1881-12-05 1887-03-03 1 Democrat                          
10571 10571 U000028 rep TX 1879-03-18 1881-03-03   Democrat 6                        
10572 10572 U000028 rep TX 1881-12-05 1883-03-03   Democrat 6                        
10731 10731 H000150 rep TX 1871-03-04 1873-03-03   Democrat 4                        
10732 10732 H000150 rep TX 1873-12-01 1875-03-03   Democrat 4                        
10733 10733 H000150 rep TX 1875-12-06 1877-03-03   Democrat 5                        
10734 10734 H000150 rep TX 1883-12-03 1885-03-03   Democrat 10                        
10827 10827 O000021 rep TX 1883-12-03 1885-03-03   Independent 7                        
11094 11094 J000230 rep TX 1883-12-03 1885-03-03   Democrat 3                        
11095 11095 J000230 rep TX 1885-12-07 1887-03-03   Democrat 3                        
11130 11130 M000732 rep TX 1883-12-03 1885-03-03   Democrat 8                        
11131 11131 M000732 rep TX 1885-12-07 1887-03-03   Democrat 8                        
11227 11227 T000246 rep TX 1875-12-06 1877-03-03   Democrat 3                        
11228 11228 T000246 rep TX 1877-10-15 1879-03-03   Democrat 3                        
11229 11229 T000246 rep TX 1883-12-03 1885-03-03   Democrat 5                        
11230 11230 T000246 rep TX 1885-12-07 1887-03-03   Democrat 5                        
11261 11261 W000272 rep TX 1879-03-18 1881-03-03   Democrat 3                        
11262 11262 W000272 rep TX 1881-12-05 1883-03-03   Democrat 3                        
11263 11263 W000272 rep TX 1883-12-03 1885-03-03   Democrat 6                        
11264 11264 W000272 rep TX 1885-12-07 1887-03-03   Democrat 6                        
11481 11481 R000098 rep TX 1857-12-07 1859-03-03   Democrat 1                        
11482 11482 R000098 rep TX 1859-12-05 1861-03-03   Democrat 1                        
11483 11483 R000098 rep TX 1875-12-06 1877-03-03   Democrat 1                        
11484 11484 R000098 rep TX 1877-10-15 1879-03-03   Democrat 1                        
11485 11485 R000098 rep TX 1879-03-18 1881-03-03   Democrat 1                        
11486 11486 R000098 rep TX 1881-12-05 1883-03-03   Democrat 1                        
11487 11487 R000098 rep TX 1883-12-03 1885-03-03   Democrat 2                        
11488 11488 R000098 rep TX 1885-12-07 1887-03-03   Democrat 2                        
11489 11489 R000098 sen TX 1887-12-05 1891-12-31 1 Democrat                          
11674 11674 C000601 sen TX 1877-10-15 1883-03-03 2 Democrat                          
11675 11675 C000601 sen TX 1883-12-03 1889-03-03 2 Democrat                          
11676 11676 C000601 sen TX 1889-12-02 1895-03-03 2 Democrat                          
11777 11777 H000203 rep TX 1887-12-05 1889-03-03   Democrat 5                        
11778 11778 H000203 rep TX 1889-12-02 1891-03-03   Democrat 5                        
11836 11836 M000203 rep TX 1887-12-05 1889-03-03   Democrat 2                        
11837 11837 M000203 rep TX 1889-12-02 1891-03-03   Democrat 2                        
12069 12069 A000264 rep TX 1891-12-07 1893-03-03   Democrat 9                        
12231 12231 L000422 rep TX 1891-12-07 1893-03-03   Democrat 2                        
12245 12245 M000908 rep TX 1887-12-05 1889-03-03   Democrat 8                        
12246 12246 M000908 rep TX 1889-12-02 1891-03-03   Democrat 8                        
12247 12247 M000908 rep TX 1891-12-07 1893-03-03   Democrat 8                        
12306 12306 S000904 rep TX 1883-12-03 1885-03-03   Democrat 1                        
12307 12307 S000904 rep TX 1885-12-07 1887-03-03   Democrat 1                        
12308 12308 S000904 rep TX 1887-12-05 1889-03-03   Democrat 1                        
12309 12309 S000904 rep TX 1889-12-02 1891-03-03   Democrat 1                        
12310 12310 S000904 rep TX 1891-12-07 1893-03-03   Democrat 1                        
12377 12377 M000777 rep TX 1873-12-01 1875-03-03   Democrat -1                        
12378 12378 M000777 rep TX 1875-12-06 1877-03-03   Democrat 4                        
12379 12379 M000777 rep TX 1877-10-15 1879-03-03   Democrat 4                        
12380 12380 M000777 rep TX 1879-03-18 1881-03-03   Democrat 4                        
12381 12381 M000777 rep TX 1881-12-05 1883-03-03   Democrat 4                        
12382 12382 M000777 rep TX 1883-12-03 1885-03-03   Democrat 9                        
12383 12383 M000777 rep TX 1885-12-07 1887-03-03   Democrat 9                        
12384 12384 M000777 rep TX 1887-12-05 1889-03-03   Democrat 9                        
12385 12385 M000777 rep TX 1889-12-02 1891-03-03   Democrat 9                        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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, [caucus] TEXT, [url] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);