legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
526 rows where state = "AR" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, url, address, fax, contact_form, state_rank, rss_url, start (date), end (date)
party 8 ✖
- Democrat 435
- Republican 74
- Jacksonian 5
- Ind. Democrat 2
- Liberal Republican 2
- Jackson 1
- Union Labor 1
- Whig 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34162 | 34162 | William Alexander A000103 | rep | AR | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
34163 | 34163 | William Alexander A000103 | rep | AR | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
34164 | 34164 | William Alexander A000103 | rep | AR | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
34165 | 34165 | William Alexander A000103 | rep | AR | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34166 | 34166 | William Alexander A000103 | rep | AR | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34167 | 34167 | William Alexander A000103 | rep | AR | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34168 | 34168 | William Alexander A000103 | rep | AR | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
34169 | 34169 | William Alexander A000103 | rep | AR | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34170 | 34170 | William Alexander A000103 | rep | AR | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34171 | 34171 | William Alexander A000103 | rep | AR | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
34172 | 34172 | William Alexander A000103 | rep | AR | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34173 | 34173 | William Alexander A000103 | rep | AR | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
27073 | 27073 | Thomas Alford A000105 | rep | AR | 1959-01-07 | 1961-01-03 | Ind. Democrat | 5 | |||||||||||||
27074 | 27074 | Thomas Alford A000105 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
34200 | 34200 | Beryl Anthony A000213 | rep | AR | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
34201 | 34201 | Beryl Anthony A000213 | rep | AR | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
34202 | 34202 | Beryl Anthony A000213 | rep | AR | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
34203 | 34203 | Beryl Anthony A000213 | rep | AR | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
34204 | 34204 | Beryl Anthony A000213 | rep | AR | 1987-01-06 | 1989-01-03 | Democrat | 4 | |||||||||||||
34205 | 34205 | Beryl Anthony A000213 | rep | AR | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34206 | 34206 | Beryl Anthony A000213 | rep | AR | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
5601 | 5601 | Chester Ashley A000311 | sen | AR | 1844-01-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5602 | 5602 | Chester Ashley A000311 | sen | AR | 1847-12-06 | 1849-03-03 | 2 | Democrat | |||||||||||||
2196 | 2196 | James Bates B000235 | rep | AR | 1819-12-06 | 1821-03-03 | -1 | ||||||||||||||
2197 | 2197 | James Bates B000235 | rep | AR | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
13858 | 13858 | James Berry B000418 | sen | AR | 1885-12-07 | 1889-03-03 | 2 | Democrat | |||||||||||||
13859 | 13859 | James Berry B000418 | sen | AR | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
13860 | 13860 | James Berry B000418 | sen | AR | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13861 | 13861 | James Berry B000418 | sen | AR | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
38421 | 38421 | Robert Berry B000420 | rep | AR | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
38422 | 38422 | Robert Berry B000420 | rep | AR | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
38423 | 38423 | Robert Berry B000420 | rep | AR | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38424 | 38424 | Robert Berry B000420 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38425 | 38425 | Robert Berry B000420 | rep | AR | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38426 | 38426 | Robert Berry B000420 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38427 | 38427 | Robert Berry B000420 | rep | AR | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/berry/ | ||||||||||||
32904 | 32904 | Edwin Bethune B000422 | rep | AR | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32905 | 32905 | Edwin Bethune B000422 | rep | AR | 1981-01-05 | 1983-01-03 | Republican | 2 | |||||||||||||
32906 | 32906 | Edwin Bethune B000422 | rep | AR | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
8835 | 8835 | Thomas Boles B000603 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8836 | 8836 | Thomas Boles B000603 | rep | AR | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8837 | 8837 | Thomas Boles B000603 | rep | AR | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
5860 | 5860 | Solon Borland B000642 | sen | AR | 1848-03-30 | 1849-03-03 | 3 | Democrat | |||||||||||||
5861 | 5861 | Solon Borland B000642 | sen | AR | 1849-03-05 | 1853-04-11 | 3 | Democrat | |||||||||||||
12425 | 12425 | Clifton Breckinridge B000784 | rep | AR | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
12426 | 12426 | Clifton Breckinridge B000784 | rep | AR | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
12427 | 12427 | Clifton Breckinridge B000784 | rep | AR | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
12428 | 12428 | Clifton Breckinridge B000784 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12429 | 12429 | Clifton Breckinridge B000784 | rep | AR | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12430 | 12430 | Clifton Breckinridge B000784 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
15006 | 15006 | Stephen Brundidge B000979 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
15007 | 15007 | Stephen Brundidge B000979 | rep | AR | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
15008 | 15008 | Stephen Brundidge B000979 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
15009 | 15009 | Stephen Brundidge B000979 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15010 | 15010 | Stephen Brundidge B000979 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15011 | 15011 | Stephen Brundidge B000979 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
35156 | 35156 | Dale Bumpers B001057 | sen | AR | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
35157 | 35157 | Dale Bumpers B001057 | sen | AR | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
35158 | 35158 | Dale Bumpers B001057 | sen | AR | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35159 | 35159 | Dale Bumpers B001057 | sen | AR | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
41992 | 41992 | John Boozman B001236 | rep | AR | 2001-11-29 | 2003-01-03 | Republican | 3 | |||||||||||||
41993 | 41993 | John Boozman B001236 | rep | AR | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
41994 | 41994 | John Boozman B001236 | rep | AR | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
41995 | 41995 | John Boozman B001236 | rep | AR | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
41996 | 41996 | John Boozman B001236 | rep | AR | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.boozman.house.gov/ | ||||||||||||
41997 | 41997 | John Boozman B001236 | sen | AR | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.boozman.senate.gov | 141 Hart Senate Office Building Washington DC 20510 | 202-224-4843 | 202-228-1371 | http://www.boozman.senate.gov/public/index.cfm/e-mail-me | 141 Hart Senate Office Building | senior | http://www.boozman.senate.gov/public/index.cfm/rss/feed | |||||
41998 | 41998 | John Boozman B001236 | sen | AR | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.boozman.senate.gov/public | 141 Hart Senate Office Building Washington DC 20510 | 202-224-4843 | 202-228-1371 | https://www.boozman.senate.gov/public/index.cfm/contact | 141 Hart Senate Office Building | senior | http://www.boozman.senate.gov/public/index.cfm/rss/feed | |||||
22515 | 22515 | Hattie Caraway C000138 | sen | AR | 1931-12-07 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
22516 | 22516 | Hattie Caraway C000138 | sen | AR | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22517 | 22517 | Hattie Caraway C000138 | sen | AR | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
19256 | 19256 | Thaddeus Caraway C000139 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
19257 | 19257 | Thaddeus Caraway C000139 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
19258 | 19258 | Thaddeus Caraway C000139 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19259 | 19259 | Thaddeus Caraway C000139 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19260 | 19260 | Thaddeus Caraway C000139 | sen | AR | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19261 | 19261 | Thaddeus Caraway C000139 | sen | AR | 1927-12-05 | 1931-12-31 | 3 | Democrat | |||||||||||||
12131 | 12131 | William Cate C000249 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12132 | 12132 | William Cate C000249 | rep | AR | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
16729 | 16729 | James Clarke C000463 | sen | AR | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
16730 | 16730 | James Clarke C000463 | sen | AR | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
16731 | 16731 | James Clarke C000463 | sen | AR | 1915-12-06 | 1917-03-03 | 3 | Democrat | |||||||||||||
8858 | 8858 | Powell Clayton C000498 | sen | AR | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
2820 | 2820 | Henry Conway C000712 | rep | AR | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2821 | 2821 | Henry Conway C000712 | rep | AR | 1825-12-05 | 1827-03-03 | -1 | ||||||||||||||
2822 | 2822 | Henry Conway C000712 | rep | AR | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
10317 | 10317 | Jordan Cravens C000885 | rep | AR | 1877-10-15 | 1879-03-03 | Ind. Democrat | 3 | |||||||||||||
10318 | 10318 | Jordan Cravens C000885 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10319 | 10319 | Jordan Cravens C000885 | rep | AR | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
22526 | 22526 | William Cravens C000886 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
22527 | 22527 | William Cravens C000886 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
22528 | 22528 | William Cravens C000886 | rep | AR | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
22529 | 22529 | William Cravens C000886 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22530 | 22530 | William Cravens C000886 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22531 | 22531 | William Cravens C000886 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22532 | 22532 | William Cravens C000886 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24328 | 24328 | William Cravens C000887 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24329 | 24329 | William Cravens C000887 | rep | AR | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
24330 | 24330 | William Cravens C000887 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24331 | 24331 | William Cravens C000887 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24332 | 24332 | William Cravens C000887 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 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);