legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
92 rows where state = "AL" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: class, party, url, address, fax, contact_form, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2167 | 2167 | John Walker W000061 | sen | AL | 1819-12-06 | 1823-03-03 | 3 | Republican | |||||||||||||
2360 | 2360 | William Kelly K000079 | sen | AL | 1822-01-01 | 1825-03-03 | 3 | Republican | |||||||||||||
2575 | 2575 | Henry Chambers C000284 | sen | AL | 1825-12-05 | 1827-03-03 | 3 | Jackson | |||||||||||||
2754 | 2754 | Israel Pickens P000322 | sen | AL | 1826-01-01 | 1827-03-03 | 3 | Jackson | |||||||||||||
3495 | 3495 | Gabriel Moore M000898 | sen | AL | 1831-12-05 | 1837-03-03 | 3 | Jackson | |||||||||||||
4175 | 4175 | Clement Clay C000481 | sen | AL | 1837-09-04 | 1841-12-31 | 3 | Democrat | |||||||||||||
4282 | 4282 | John McKinley M000519 | sen | AL | 1826-01-01 | 1831-03-03 | 3 | Jackson | |||||||||||||
4284 | 4284 | John McKinley M000519 | sen | AL | 1837-09-04 | 1837-12-31 | 3 | Democrat | |||||||||||||
5118 | 5118 | Arthur Bagby B000030 | sen | AL | 1841-05-31 | 1843-03-03 | 3 | Democrat | |||||||||||||
5119 | 5119 | Arthur Bagby B000030 | sen | AL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5763 | 5763 | Dixon Lewis L000278 | sen | AL | 1844-04-22 | 1847-03-03 | 2 | Democrat | |||||||||||||
5764 | 5764 | Dixon Lewis L000278 | sen | AL | 1847-12-06 | 1848-10-25 | 2 | Democrat | |||||||||||||
5873 | 5873 | William King K000217 | sen | AL | 1819-12-14 | 1823-03-03 | 2 | Republican | |||||||||||||
5874 | 5874 | William King K000217 | sen | AL | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
5875 | 5875 | William King K000217 | sen | AL | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
5876 | 5876 | William King K000217 | sen | AL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5877 | 5877 | William King K000217 | sen | AL | 1841-05-31 | 1844-04-15 | 2 | Democrat | |||||||||||||
5878 | 5878 | William King K000217 | sen | AL | 1848-07-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5879 | 5879 | William King K000217 | sen | AL | 1849-03-05 | 1852-12-20 | 3 | Democrat | |||||||||||||
5940 | 5940 | Jeremiah Clemens C000501 | sen | AL | 1849-12-03 | 1853-03-03 | 2 | Democrat | |||||||||||||
6812 | 6812 | Benjamin Fitzpatrick F000174 | sen | AL | 1848-01-01 | 1849-12-31 | 2 | Democrat | |||||||||||||
6813 | 6813 | Benjamin Fitzpatrick F000174 | sen | AL | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6814 | 6814 | Benjamin Fitzpatrick F000174 | sen | AL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7341 | 7341 | Clement Clay C000480 | sen | AL | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7342 | 7342 | Clement Clay C000480 | sen | AL | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
8501 | 8501 | Willard Warner W000159 | sen | AL | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8911 | 8911 | George Goldthwaite G000266 | sen | AL | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9379 | 9379 | George Spencer S000723 | sen | AL | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
9380 | 9380 | George Spencer S000723 | sen | AL | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
10116 | 10116 | George Houston H000822 | sen | AL | 1879-03-18 | 1879-12-31 | 3 | Democrat | |||||||||||||
10850 | 10850 | Luke Pryor P000557 | sen | AL | 1880-01-01 | 1881-03-03 | 3 | Democrat | |||||||||||||
12272 | 12272 | James Pugh P000561 | sen | AL | 1880-01-01 | 1885-03-03 | 3 | Democrat | |||||||||||||
12273 | 12273 | James Pugh P000561 | sen | AL | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12274 | 12274 | James Pugh P000561 | sen | AL | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
14092 | 14092 | John Morgan M000954 | sen | AL | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
14093 | 14093 | John Morgan M000954 | sen | AL | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
14094 | 14094 | John Morgan M000954 | sen | AL | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
14095 | 14095 | John Morgan M000954 | sen | AL | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
14096 | 14096 | John Morgan M000954 | sen | AL | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14424 | 14424 | Edmund Pettus P000279 | sen | AL | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
14425 | 14425 | Edmund Pettus P000279 | sen | AL | 1903-11-09 | 1907-12-31 | 3 | Democrat | |||||||||||||
15563 | 15563 | Joseph Johnston J000193 | sen | AL | 1907-12-02 | 1909-03-03 | 3 | Democrat | |||||||||||||
15564 | 15564 | Joseph Johnston J000193 | sen | AL | 1909-03-15 | 1913-12-31 | 3 | Democrat | |||||||||||||
16661 | 16661 | Francis White W000368 | sen | AL | 1914-01-01 | 1915-03-03 | 3 | Democrat | |||||||||||||
17556 | 17556 | John Bankhead B000110 | sen | AL | 1907-12-02 | 1913-03-03 | 2 | Democrat | |||||||||||||
17557 | 17557 | John Bankhead B000110 | sen | AL | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17558 | 17558 | John Bankhead B000110 | sen | AL | 1919-05-19 | 1921-03-03 | 2 | Democrat | |||||||||||||
18031 | 18031 | Braxton Comer C000657 | sen | AL | 1920-03-05 | 1921-03-03 | 2 | Democrat | appointment | ||||||||||||
18534 | 18534 | Oscar Underwood U000013 | sen | AL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18535 | 18535 | Oscar Underwood U000013 | sen | AL | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
18988 | 18988 | James Heflin H000446 | sen | AL | 1920-11-03 | 1925-03-03 | 2 | Democrat | |||||||||||||
18989 | 18989 | James Heflin H000446 | sen | AL | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
21119 | 21119 | Hugo Black B000499 | sen | AL | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
21120 | 21120 | Hugo Black B000499 | sen | AL | 1933-03-09 | 1937-08-19 | 3 | Democrat | |||||||||||||
22185 | 22185 | Dixie Graves G000391 | sen | AL | 1937-08-20 | 1938-01-10 | 3 | Democrat | appointment | ||||||||||||
23346 | 23346 | John Bankhead B000111 | sen | AL | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
23347 | 23347 | John Bankhead B000111 | sen | AL | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23348 | 23348 | John Bankhead B000111 | sen | AL | 1943-01-06 | 1947-01-03 | 2 | Democrat | |||||||||||||
24244 | 24244 | George Swift S001117 | sen | AL | 1946-06-15 | 1947-01-03 | 2 | Democrat | appointment | ||||||||||||
27879 | 27879 | Joseph Hill H000598 | sen | AL | 1938-01-11 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
27880 | 27880 | Joseph Hill H000598 | sen | AL | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
27881 | 27881 | Joseph Hill H000598 | sen | AL | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27882 | 27882 | Joseph Hill H000598 | sen | AL | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
27883 | 27883 | Joseph Hill H000598 | sen | AL | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27884 | 27884 | Joseph Hill H000598 | sen | AL | 1963-01-09 | 1969-01-02 | 3 | Democrat | |||||||||||||
30699 | 30699 | John Sparkman S000701 | sen | AL | 1946-11-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
30700 | 30700 | John Sparkman S000701 | sen | AL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30701 | 30701 | John Sparkman S000701 | sen | AL | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
30702 | 30702 | John Sparkman S000701 | sen | AL | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30703 | 30703 | John Sparkman S000701 | sen | AL | 1967-01-10 | 1973-01-03 | 2 | Democrat | |||||||||||||
30704 | 30704 | John Sparkman S000701 | sen | AL | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30818 | 30818 | James Allen A000127 | sen | AL | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30819 | 30819 | James Allen A000127 | sen | AL | 1975-01-14 | 1978-06-01 | 3 | Democrat | |||||||||||||
31913 | 31913 | Maryon Allen A000139 | sen | AL | 1978-06-08 | 1978-11-07 | 3 | Democrat | appointment | ||||||||||||
31916 | 31916 | Donald Stewart S000907 | sen | AL | 1978-11-08 | 1981-01-03 | 3 | Democrat | |||||||||||||
32595 | 32595 | Jeremiah Denton D000259 | sen | AL | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
34543 | 34543 | Howell Heflin H000445 | sen | AL | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34544 | 34544 | Howell Heflin H000445 | sen | AL | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
34545 | 34545 | Howell Heflin H000445 | sen | AL | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
40525 | 40525 | Jefferson Sessions S001141 | sen | AL | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
40526 | 40526 | Jefferson Sessions S001141 | sen | AL | 2003-01-07 | 2009-01-03 | 2 | Republican | http://sessions.senate.gov/ | ||||||||||||
40527 | 40527 | Jefferson Sessions S001141 | sen | AL | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.sessions.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | 202-224-3149 | http://www.sessions.senate.gov/public/index.cfm/contact-jeff | 326 Russell Senate Office Building | junior | http://www.sessions.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
40528 | 40528 | Jefferson Sessions S001141 | sen | AL | 2015-01-06 | 2017-02-08 | 2 | Republican | http://www.sessions.senate.gov/public | 326 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | 202-224-3149 | http://www.sessions.senate.gov/public/index.cfm/contact-jeff | 326 Russell Senate Office Building | junior | http://www.sessions.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
40592 | 40592 | Luther Strange S001202 | sen | AL | 2017-02-09 | 2018-01-03 | 2 | Republican | appointment | https://www.strange.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.strange.senate.gov/content/contact-senator | 326 Russell Senate Office Building | junior | ||||||
41594 | 41594 | Doug Jones J000300 | sen | AL | 2018-01-03 | 2021-01-03 | 2 | Democrat | https://www.jones.senate.gov | 330 Hart Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.jones.senate.gov/content/contact-senator | 330 Hart Senate Office Building | junior | |||||||
43350 | 43350 | Richard Shelby S000320 | sen | AL | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
43351 | 43351 | Richard Shelby S000320 | sen | AL | 1993-01-05 | 1999-01-03 | 3 | Republican | [ { "start": "1993-01-05", "end": "1994-11-09", "party": "Democrat" }, { "start": "1994-11-09", "end": "2005-01-03", "party": "Republican" } ] |
||||||||||||
43352 | 43352 | Richard Shelby S000320 | sen | AL | 1999-01-06 | 2005-01-03 | 3 | Republican | http://shelby.senate.gov/ | ||||||||||||
43353 | 43353 | Richard Shelby S000320 | sen | AL | 2005-01-04 | 2011-01-03 | 3 | Republican | http://shelby.senate.gov/ | ||||||||||||
43354 | 43354 | Richard Shelby S000320 | sen | AL | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.shelby.senate.gov | 304 Russell Senate Office Building Washington DC 20510 | 202-224-5744 | 202-224-3416 | http://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby | 304 Russell Senate Office Building | senior | http://www.shelby.senate.gov/public/index.cfm/rss/feed | |||||
43355 | 43355 | Richard Shelby S000320 | sen | AL | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.shelby.senate.gov | 304 Russell Senate Office Building Washington DC 20510 | 202-224-5744 | 202-224-3416 | https://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby | 304 Russell Senate Office Building | senior | http://www.shelby.senate.gov/public/index.cfm/rss/feed | |||||
44471 | 44471 | Tommy Tuberville T000278 | sen | AL | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.tuberville.senate.gov | 142 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.tuberville.senate.gov/contact/contact-form/ | 142 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);