legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
140 rows where party = "Republican", state = "LA" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: district, url, phone, fax, office, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1906 | 1906 | Thomas Robertson R000326 | rep | LA | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
1907 | 1907 | Thomas Robertson R000326 | rep | LA | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1908 | 1908 | Thomas Robertson R000326 | rep | LA | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1909 | 1909 | Thomas Robertson R000326 | rep | LA | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
1989 | 1989 | Thomas Butler B001190 | rep | LA | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
1990 | 1990 | Thomas Butler B001190 | rep | LA | 1819-12-06 | 1821-03-03 | Republican | 1 | |||||||||||||
3437 | 3437 | Josiah Johnston J000194 | rep | LA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
8266 | 8266 | William Blackburn B000510 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8482 | 8482 | Michel Vidal V000096 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8682 | 8682 | Joseph Newsham N000072 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8683 | 8683 | Joseph Newsham N000072 | rep | LA | 1869-03-04 | 1871-03-03 | Republican | 4 | |||||||||||||
8951 | 8951 | James McCleery M000327 | rep | LA | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
9358 | 9358 | Lionel Sheldon S000322 | rep | LA | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
9359 | 9359 | Lionel Sheldon S000322 | rep | LA | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9360 | 9360 | Lionel Sheldon S000322 | rep | LA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9369 | 9369 | George Smith S000539 | rep | LA | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9389 | 9389 | Jacob Sypher S001140 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
9390 | 9390 | Jacob Sypher S001140 | rep | LA | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
9391 | 9391 | Jacob Sypher S001140 | rep | LA | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9392 | 9392 | Jacob Sypher S001140 | rep | LA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9590 | 9590 | Frank Morey M000942 | rep | LA | 1869-03-04 | 1871-03-03 | Republican | 5 | |||||||||||||
9591 | 9591 | Frank Morey M000942 | rep | LA | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
9592 | 9592 | Frank Morey M000942 | rep | LA | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9593 | 9593 | Frank Morey M000942 | rep | LA | 1875-12-06 | 1877-03-03 | Republican | 5 | |||||||||||||
9594 | 9594 | Charles Nash N000008 | rep | LA | 1875-12-06 | 1877-03-03 | Republican | 6 | |||||||||||||
9876 | 9876 | John Leonard L000247 | rep | LA | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
10322 | 10322 | Chester Darrall D000062 | rep | LA | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
10323 | 10323 | Chester Darrall D000062 | rep | LA | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
10324 | 10324 | Chester Darrall D000062 | rep | LA | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
10325 | 10325 | Chester Darrall D000062 | rep | LA | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
10326 | 10326 | Chester Darrall D000062 | rep | LA | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
10327 | 10327 | Chester Darrall D000062 | rep | LA | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
10781 | 10781 | William Kellogg K000069 | rep | LA | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
11055 | 11055 | Michael Hahn H000019 | rep | LA | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11677 | 11677 | Hamilton Coleman C000619 | rep | LA | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
32348 | 32348 | David Treen T000362 | rep | LA | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
32349 | 32349 | David Treen T000362 | rep | LA | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
32350 | 32350 | David Treen T000362 | rep | LA | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
32351 | 32351 | David Treen T000362 | rep | LA | 1979-01-15 | 1981-01-03 | Republican | 3 | |||||||||||||
33369 | 33369 | William Moore M000923 | rep | LA | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
33370 | 33370 | William Moore M000923 | rep | LA | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
33371 | 33371 | William Moore M000923 | rep | LA | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
33372 | 33372 | William Moore M000923 | rep | LA | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
33373 | 33373 | William Moore M000923 | rep | LA | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
33374 | 33374 | William Moore M000923 | rep | LA | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
34552 | 34552 | Clyde Holloway H000729 | rep | LA | 1987-01-06 | 1989-01-03 | Republican | 8 | |||||||||||||
34553 | 34553 | Clyde Holloway H000729 | rep | LA | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
34554 | 34554 | Clyde Holloway H000729 | rep | LA | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
35859 | 35859 | James Hayes H000390 | rep | LA | 1995-01-04 | 1997-01-03 | Republican | 7 | [ { "start": "1995-01-04", "end": "1995-12-01", "party": "Democrat" }, { "start": "1995-12-01", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
36674 | 36674 | Robert Livingston L000371 | rep | LA | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
36675 | 36675 | Robert Livingston L000371 | rep | LA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
36676 | 36676 | Robert Livingston L000371 | rep | LA | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
36677 | 36677 | Robert Livingston L000371 | rep | LA | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
36678 | 36678 | Robert Livingston L000371 | rep | LA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
36679 | 36679 | Robert Livingston L000371 | rep | LA | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
36680 | 36680 | Robert Livingston L000371 | rep | LA | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
36681 | 36681 | Robert Livingston L000371 | rep | LA | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36682 | 36682 | Robert Livingston L000371 | rep | LA | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36683 | 36683 | Robert Livingston L000371 | rep | LA | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36684 | 36684 | Robert Livingston L000371 | rep | LA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36685 | 36685 | Robert Livingston L000371 | rep | LA | 1999-01-06 | 1999-03-01 | Republican | 1 | |||||||||||||
36878 | 36878 | John Cooksey C000735 | rep | LA | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
36879 | 36879 | John Cooksey C000735 | rep | LA | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
36880 | 36880 | John Cooksey C000735 | rep | LA | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
37499 | 37499 | William Tauzin T000058 | rep | LA | 1995-01-04 | 1997-01-03 | Republican | 3 | [ { "start": "1995-01-04", "end": "1995-08-08", "party": "Democrat" }, { "start": "1995-08-08", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
37500 | 37500 | William Tauzin T000058 | rep | LA | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
37501 | 37501 | William Tauzin T000058 | rep | LA | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37502 | 37502 | William Tauzin T000058 | rep | LA | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37503 | 37503 | William Tauzin T000058 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/tauzin | ||||||||||||
37939 | 37939 | Richard Baker B000072 | rep | LA | 1987-01-06 | 1989-01-03 | Republican | 6 | |||||||||||||
37940 | 37940 | Richard Baker B000072 | rep | LA | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
37941 | 37941 | Richard Baker B000072 | rep | LA | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
37942 | 37942 | Richard Baker B000072 | rep | LA | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
37943 | 37943 | Richard Baker B000072 | rep | LA | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
37944 | 37944 | Richard Baker B000072 | rep | LA | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
37945 | 37945 | Richard Baker B000072 | rep | LA | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
37946 | 37946 | Richard Baker B000072 | rep | LA | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37947 | 37947 | Richard Baker B000072 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/baker | ||||||||||||
37948 | 37948 | Richard Baker B000072 | rep | LA | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/baker | ||||||||||||
37949 | 37949 | Richard Baker B000072 | rep | LA | 2007-01-04 | 2008-02-02 | Republican | 6 | http://baker.house.gov | ||||||||||||
38138 | 38138 | Bobby Jindal J000287 | rep | LA | 2005-01-04 | 2007-01-03 | Republican | 1 | |||||||||||||
38139 | 38139 | Bobby Jindal J000287 | rep | LA | 2007-01-04 | 2008-01-14 | Republican | 1 | http://www.house.gov/jindal | ||||||||||||
38215 | 38215 | James McCrery M000388 | rep | LA | 1987-01-06 | 1989-01-03 | Republican | 4 | |||||||||||||
38216 | 38216 | James McCrery M000388 | rep | LA | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
38217 | 38217 | James McCrery M000388 | rep | LA | 1991-01-03 | 1993-01-03 | Republican | 4 | |||||||||||||
38218 | 38218 | James McCrery M000388 | rep | LA | 1993-01-05 | 1995-01-03 | Republican | 5 | |||||||||||||
38219 | 38219 | James McCrery M000388 | rep | LA | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
38220 | 38220 | James McCrery M000388 | rep | LA | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
38221 | 38221 | James McCrery M000388 | rep | LA | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
38222 | 38222 | James McCrery M000388 | rep | LA | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
38223 | 38223 | James McCrery M000388 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/mccrery | ||||||||||||
38224 | 38224 | James McCrery M000388 | rep | LA | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/mccrery | ||||||||||||
38225 | 38225 | James McCrery M000388 | rep | LA | 2007-01-04 | 2009-01-03 | Republican | 4 | http://mccrery.house.gov | ||||||||||||
38476 | 38476 | Anh Cao C001079 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 2 | http://josephcao.house.gov | ||||||||||||
39382 | 39382 | Jeff Landry L000574 | rep | LA | 2011-01-05 | 2013-01-03 | Republican | 3 | http://landry.house.gov/ | 206 Cannon HOB; Washington DC 20515-1803 | 202-225-4031 | 202- 226-3944 | 206 Cannon House Office Building | ||||||||
39616 | 39616 | Rodney Alexander A000361 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 5 | [ { "start": "2003-01-07", "end": "2004-08-09", "party": "Democrat" }, { "start": "2004-08-09", "end": "2005-01-03", "party": "Republican" } ] |
http://www.house.gov/alexander/ | |||||||||||
39617 | 39617 | Rodney Alexander A000361 | rep | LA | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/alexander/ | ||||||||||||
39618 | 39618 | Rodney Alexander A000361 | rep | LA | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/alexander | ||||||||||||
39619 | 39619 | Rodney Alexander A000361 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://alexander.house.gov/ | ||||||||||||
39620 | 39620 | Rodney Alexander A000361 | rep | LA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://alexander.house.gov/ | 316 Cannon HOB; Washington DC 20515-1805 | 202-225-8490 | 202-225-5639 | http://www.house.gov/alexander/content/webform/zipauth.htm | 316 Cannon House Office Building |
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);