legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
45 rows where class = 3 and state = "LA"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, party, start (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 | |||||||||||||
1342 | 1342 | Eligius Fromentin F000389 | sen | LA | 1813-05-24 | 1819-03-03 | 3 | Republican | |||||||||||||
1977 | 1977 | James Brown B000921 | sen | LA | 1819-12-06 | 1823-12-31 | 3 | Republican | |||||||||||||
3438 | 3438 | Josiah Johnston J000194 | sen | LA | 1824-01-15 | 1825-03-03 | 3 | Adams | |||||||||||||
3439 | 3439 | Josiah Johnston J000194 | sen | LA | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
3440 | 3440 | Josiah Johnston J000194 | sen | LA | 1831-12-05 | 1833-05-19 | 3 | ||||||||||||||
3772 | 3772 | Alexander Porter P000436 | sen | LA | 1833-12-02 | 1837-03-03 | 3 | Anti-Jacksonian | |||||||||||||
4296 | 4296 | Alexander Mouton M001050 | sen | LA | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5347 | 5347 | Henry Johnson J000137 | sen | LA | 1844-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5944 | 5944 | Charles Conrad C000703 | sen | LA | 1842-01-01 | 1843-03-03 | 3 | Whig | |||||||||||||
6131 | 6131 | Pierre Soulé S000682 | sen | LA | 1849-12-03 | 1853-12-31 | 3 | Democrat | |||||||||||||
6922 | 6922 | John Slidell S000487 | sen | LA | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6923 | 6923 | John Slidell S000487 | sen | LA | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
10121 | 10121 | Benjamin Jonas J000204 | sen | LA | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10779 | 10779 | William Kellogg K000069 | sen | LA | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
11030 | 11030 | James Eustis E000229 | sen | LA | 1876-01-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
11031 | 11031 | James Eustis E000229 | sen | LA | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12356 | 12356 | Edward White W000366 | sen | LA | 1891-12-07 | 1894-03-12 | 3 | Democrat | |||||||||||||
12882 | 12882 | Newton Blanchard B000541 | sen | LA | 1894-01-01 | 1897-03-03 | 3 | Democrat | |||||||||||||
15635 | 15635 | Samuel McEnery M000429 | sen | LA | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
15636 | 15636 | Samuel McEnery M000429 | sen | LA | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15637 | 15637 | Samuel McEnery M000429 | sen | LA | 1909-03-15 | 1911-03-03 | 3 | Democrat | |||||||||||||
15829 | 15829 | John Thornton T000241 | sen | LA | 1910-01-01 | 1915-03-03 | 3 | Democrat | |||||||||||||
16705 | 16705 | Robert Broussard B000896 | sen | LA | 1915-12-06 | 1919-03-03 | 3 | Democrat | |||||||||||||
17523 | 17523 | Edward Gay G000104 | sen | LA | 1918-01-01 | 1921-03-03 | 3 | Democrat | |||||||||||||
17524 | 17524 | Walter Guion G000522 | sen | LA | 1918-04-22 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
19237 | 19237 | Edwin Broussard B000895 | sen | LA | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19238 | 19238 | Edwin Broussard B000895 | sen | LA | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
24020 | 24020 | John Overton O000146 | sen | LA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
24021 | 24021 | John Overton O000146 | sen | LA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24022 | 24022 | John Overton O000146 | sen | LA | 1945-01-03 | 1949-01-03 | 3 | Democrat | |||||||||||||
24731 | 24731 | William Feazel F000057 | sen | LA | 1948-05-18 | 1949-01-03 | 3 | Democrat | appointment | ||||||||||||
32733 | 32733 | Russell Long L000428 | sen | LA | 1948-01-01 | 1951-01-03 | 3 | Democrat | |||||||||||||
32734 | 32734 | Russell Long L000428 | sen | LA | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
32735 | 32735 | Russell Long L000428 | sen | LA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
32736 | 32736 | Russell Long L000428 | sen | LA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
32737 | 32737 | Russell Long L000428 | sen | LA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
32738 | 32738 | Russell Long L000428 | sen | LA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32739 | 32739 | Russell Long L000428 | sen | LA | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
36519 | 36519 | John Breaux B000780 | sen | LA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
36520 | 36520 | John Breaux B000780 | sen | LA | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36521 | 36521 | John Breaux B000780 | sen | LA | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://breaux.senate.gov/ | ||||||||||||
40244 | 40244 | David Vitter V000127 | sen | LA | 2005-01-04 | 2011-01-03 | 3 | Republican | http://vitter.senate.gov/ | ||||||||||||
40245 | 40245 | David Vitter V000127 | sen | LA | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.vitter.senate.gov | 516 Hart Senate Office Building Washington DC 20510 | 202-224-4623 | 202-228-5061 | http://www.vitter.senate.gov/contact/email-senator-vitter | 516 Hart Senate Office Building | senior | http://www.vitter.senate.gov/rss/feeds/?type=all | |||||
44102 | 44102 | John Kennedy K000393 | sen | LA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.kennedy.senate.gov/public | 416 Russell Senate Office Building Washington DC 20510 | 202-224-4623 | https://www.kennedy.senate.gov/public/email-me | 416 Russell Senate Office Building | junior |
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);