legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
163 rows where party = "Republican" and state = "AL"
This data as json, copyable, CSV (advanced)
Suggested facets: district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2005 | 2005 | John Crowell C000942 | rep | AL | 1819-12-06 | 1821-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
3491 | 3491 | Gabriel Moore M000898 | rep | AL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
5873 | 5873 | William King K000217 | sen | AL | 1819-12-14 | 1823-03-03 | 2 | Republican | |||||||||||||
8280 | 8280 | John Callis C000057 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8349 | 8349 | Thomas Haughey H000352 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8373 | 8373 | Francis Kellogg K000064 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8408 | 8408 | Benjamin Norris N000138 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8420 | 8420 | Charles Pierce P000332 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8501 | 8501 | Willard Warner W000159 | sen | AL | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8535 | 8535 | Alfred Buck B001011 | rep | AL | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8625 | 8625 | Robert Heflin H000447 | rep | AL | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8841 | 8841 | Charles Buckley B001025 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8842 | 8842 | Charles Buckley B001025 | rep | AL | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8843 | 8843 | Charles Buckley B001025 | rep | AL | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9040 | 9040 | Benjamin Turner T000414 | rep | AL | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9311 | 9311 | Charles Pelham P000192 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9320 | 9320 | James Rapier R000064 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9357 | 9357 | Charles Sheats S000314 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
9407 | 9407 | Alexander White W000353 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9521 | 9521 | Jeremiah Haralson H000179 | rep | AL | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9525 | 9525 | Charles Hays H000402 | rep | AL | 1869-03-04 | 1871-03-03 | Republican | 4 | |||||||||||||
9526 | 9526 | Charles Hays H000402 | rep | AL | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
9527 | 9527 | Charles Hays H000402 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9528 | 9528 | Charles Hays H000402 | rep | AL | 1875-12-06 | 1877-03-03 | Republican | 4 | |||||||||||||
10682 | 10682 | George Craig C000855 | rep | AL | 1883-12-03 | 1885-03-03 | Republican | 4 | |||||||||||||
11849 | 11849 | John McDuffie M000428 | rep | AL | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
12895 | 12895 | Truman Aldrich A000085 | rep | AL | 1895-12-02 | 1897-03-03 | Republican | 9 | |||||||||||||
13545 | 13545 | William Aldrich A000087 | rep | AL | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
13546 | 13546 | William Aldrich A000087 | rep | AL | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13547 | 13547 | William Aldrich A000087 | rep | AL | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
28309 | 28309 | Arthur Andrews A000204 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
28528 | 28528 | James Martin M000182 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
31967 | 31967 | John Buchanan B001008 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
31968 | 31968 | John Buchanan B001008 | rep | AL | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
31969 | 31969 | John Buchanan B001008 | rep | AL | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
31970 | 31970 | John Buchanan B001008 | rep | AL | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
31971 | 31971 | John Buchanan B001008 | rep | AL | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
31972 | 31972 | John Buchanan B001008 | rep | AL | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
31973 | 31973 | John Buchanan B001008 | rep | AL | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
31974 | 31974 | John Buchanan B001008 | rep | AL | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
32595 | 32595 | Jeremiah Denton D000259 | sen | AL | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
32856 | 32856 | Albert Smith S000514 | rep | AL | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
32948 | 32948 | William Edwards E000084 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
32949 | 32949 | William Edwards E000084 | rep | AL | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
32950 | 32950 | William Edwards E000084 | rep | AL | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32951 | 32951 | William Edwards E000084 | rep | AL | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
32952 | 32952 | William Edwards E000084 | rep | AL | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
32953 | 32953 | William Edwards E000084 | rep | AL | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
32954 | 32954 | William Edwards E000084 | rep | AL | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
32955 | 32955 | William Edwards E000084 | rep | AL | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32956 | 32956 | William Edwards E000084 | rep | AL | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
32957 | 32957 | William Edwards E000084 | rep | AL | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
34369 | 34369 | William Dickinson D000326 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
34370 | 34370 | William Dickinson D000326 | rep | AL | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
34371 | 34371 | William Dickinson D000326 | rep | AL | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
34372 | 34372 | William Dickinson D000326 | rep | AL | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
34373 | 34373 | William Dickinson D000326 | rep | AL | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
34374 | 34374 | William Dickinson D000326 | rep | AL | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
34375 | 34375 | William Dickinson D000326 | rep | AL | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
34376 | 34376 | William Dickinson D000326 | rep | AL | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
34377 | 34377 | William Dickinson D000326 | rep | AL | 1981-01-05 | 1983-01-03 | Republican | 2 | |||||||||||||
34378 | 34378 | William Dickinson D000326 | rep | AL | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
34379 | 34379 | William Dickinson D000326 | rep | AL | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
34380 | 34380 | William Dickinson D000326 | rep | AL | 1987-01-06 | 1989-01-03 | Republican | 2 | |||||||||||||
34381 | 34381 | William Dickinson D000326 | rep | AL | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
34382 | 34382 | William Dickinson D000326 | rep | AL | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
36845 | 36845 | H. Callahan C000052 | rep | AL | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
36846 | 36846 | H. Callahan C000052 | rep | AL | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
36847 | 36847 | H. Callahan C000052 | rep | AL | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
36848 | 36848 | H. Callahan C000052 | rep | AL | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36849 | 36849 | H. Callahan C000052 | rep | AL | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36850 | 36850 | H. Callahan C000052 | rep | AL | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36851 | 36851 | H. Callahan C000052 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36852 | 36852 | H. Callahan C000052 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
36853 | 36853 | H. Callahan C000052 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
37065 | 37065 | Bob Riley R000258 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
37066 | 37066 | Bob Riley R000258 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37067 | 37067 | Bob Riley R000258 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
38030 | 38030 | Terry Everett E000268 | rep | AL | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
38031 | 38031 | Terry Everett E000268 | rep | AL | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
38032 | 38032 | Terry Everett E000268 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
38033 | 38033 | Terry Everett E000268 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
38034 | 38034 | Terry Everett E000268 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
38035 | 38035 | Terry Everett E000268 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/everett | ||||||||||||
38036 | 38036 | Terry Everett E000268 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/everett | ||||||||||||
38037 | 38037 | Terry Everett E000268 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.everett.house.gov | ||||||||||||
38568 | 38568 | Parker Griffith G000557 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 5 | [ { "start": "2009-01-06", "end": "2009-12-22", "party": "Democrat" }, { "start": "2009-12-22", "end": "2011-01-03", "party": "Republican" } ] |
http://griffith.house.gov | |||||||||||
39610 | 39610 | Jo Bonner B001244 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/bonner | ||||||||||||
39611 | 39611 | Jo Bonner B001244 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/bonner | ||||||||||||
39612 | 39612 | Jo Bonner B001244 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
39613 | 39613 | Jo Bonner B001244 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
39614 | 39614 | Jo Bonner B001244 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 1 | http://bonner.house.gov | 2236 Rayburn HOB; Washington DC 20515-0101 | 202-225-4931 | 202-225-0562 | https://forms.house.gov/bonner/webforms/issue_subscribe.html | 2236 Rayburn House Office Building | |||||||
39615 | 39615 | Jo Bonner B001244 | rep | AL | 2013-01-03 | 2013-08-02 | Republican | 1 | http://bonner.house.gov | 2236 Rayburn HOB; Washington DC 20515-0101 | 202-225-4931 | 202-225-0562 | https://forms.house.gov/bonner/webforms/issue_subscribe.html | 2236 Rayburn House Office Building | http://bonner.house.gov/index.php?format=feed&type=rss | ||||||
39738 | 39738 | Spencer Bachus B000013 | rep | AL | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
39739 | 39739 | Spencer Bachus B000013 | rep | AL | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
39740 | 39740 | Spencer Bachus B000013 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 6 |
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);