legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
155 rows where party = "Republican" and state = "LA"
This data as json, copyable, CSV (advanced)
Suggested facets: class, url, address, phone, fax, contact_form, office, state_rank, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1270 | 1270 | Allan Magruder M000056 | sen | LA | 1812-01-01 | 1813-03-03 | 3 | Republican | |||||||||||||
1271 | 1271 | Thomas Posey P000450 | sen | LA | 1812-01-01 | 1813-12-31 | 2 | Republican | |||||||||||||
1342 | 1342 | Eligius Fromentin F000389 | sen | LA | 1813-05-24 | 1819-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
1976 | 1976 | James Brown B000921 | sen | LA | 1813-05-24 | 1817-03-03 | 2 | Republican | |||||||||||||
1977 | 1977 | James Brown B000921 | sen | LA | 1819-12-06 | 1823-12-31 | 3 | Republican | |||||||||||||
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 | |||||||||||||
5342 | 5342 | Henry Johnson J000137 | sen | LA | 1818-01-01 | 1823-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
8494 | 8494 | John Harris H000246 | sen | LA | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
9054 | 9054 | Joseph West W000303 | sen | LA | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
10779 | 10779 | William Kellogg K000069 | sen | LA | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
10780 | 10780 | William Kellogg K000069 | sen | LA | 1877-10-15 | 1883-03-03 | 2 | Republican | |||||||||||||
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 |
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);