legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
75 rows where state = "AR" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: class, party, url, address, phone, fax, contact_form, office, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4797 | 4797 | William Fulton F000425 | sen | AR | 1836-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4798 | 4798 | William Fulton F000425 | sen | AR | 1841-05-31 | 1845-03-03 | 2 | Democrat | |||||||||||||
5294 | 5294 | Ambrose Sevier S000256 | sen | AR | 1836-09-18 | 1837-03-03 | 3 | Democrat | |||||||||||||
5295 | 5295 | Ambrose Sevier S000256 | sen | AR | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5296 | 5296 | Ambrose Sevier S000256 | sen | AR | 1843-12-04 | 1848-03-15 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
6848 | 6848 | Robert Johnson J000172 | sen | AR | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6849 | 6849 | Robert Johnson J000172 | sen | AR | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7564 | 7564 | William Sebastian S000216 | sen | AR | 1848-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
7565 | 7565 | William Sebastian S000216 | sen | AR | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7566 | 7566 | William Sebastian S000216 | sen | AR | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
7804 | 7804 | Charles Mitchel M000801 | sen | AR | 1861-07-04 | 1861-12-31 | 3 | Democrat | |||||||||||||
8495 | 8495 | Alexander McDonald M000408 | sen | AR | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8498 | 8498 | Benjamin Rice R000195 | sen | AR | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
8858 | 8858 | Powell Clayton C000498 | sen | AR | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9154 | 9154 | Stephen Dorsey D000441 | sen | AR | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
10212 | 10212 | James Walker W000057 | sen | AR | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10723 | 10723 | Augustus Garland G000065 | sen | AR | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
10724 | 10724 | Augustus Garland G000065 | sen | AR | 1883-12-03 | 1885-12-31 | 2 | Democrat | |||||||||||||
13364 | 13364 | James Jones J000231 | sen | AR | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
13365 | 13365 | James Jones J000231 | sen | AR | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
13366 | 13366 | James Jones J000231 | sen | AR | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
15075 | 15075 | Jeff Davis D000112 | sen | AR | 1907-12-02 | 1913-03-03 | 2 | Democrat | |||||||||||||
16397 | 16397 | John Heiskell H000457 | sen | AR | 1913-04-07 | 1913-12-31 | 2 | Democrat | appointment | ||||||||||||
16418 | 16418 | William Kavanaugh K000023 | sen | AR | 1913-04-07 | 1913-12-31 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
17042 | 17042 | William Kirby K000233 | sen | AR | 1916-01-01 | 1921-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
20812 | 20812 | Joseph Robinson R000347 | sen | AR | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
20813 | 20813 | Joseph Robinson R000347 | sen | AR | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20814 | 20814 | Joseph Robinson R000347 | sen | AR | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
20815 | 20815 | Joseph Robinson R000347 | sen | AR | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22311 | 22311 | John Miller M000738 | sen | AR | 1937-01-05 | 1941-12-31 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
23257 | 23257 | George Spencer S000724 | sen | AR | 1941-04-01 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
29281 | 29281 | James Fulbright F000401 | sen | AR | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
29282 | 29282 | James Fulbright F000401 | sen | AR | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
29283 | 29283 | James Fulbright F000401 | sen | AR | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29284 | 29284 | James Fulbright F000401 | sen | AR | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29285 | 29285 | James Fulbright F000401 | sen | AR | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30565 | 30565 | John McClellan M000332 | sen | AR | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
30566 | 30566 | John McClellan M000332 | sen | AR | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30567 | 30567 | John McClellan M000332 | sen | AR | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
30568 | 30568 | John McClellan M000332 | sen | AR | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30569 | 30569 | John McClellan M000332 | sen | AR | 1967-01-10 | 1973-01-03 | 2 | Democrat | |||||||||||||
30570 | 30570 | John McClellan M000332 | sen | AR | 1973-01-03 | 1977-12-31 | 2 | Democrat | |||||||||||||
31591 | 31591 | Kaneaster Hodges H000675 | sen | AR | 1977-12-10 | 1979-01-03 | 2 | Democrat | appointment | ||||||||||||
34850 | 34850 | David Pryor P000556 | sen | AR | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34851 | 34851 | David Pryor P000556 | sen | AR | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
34852 | 34852 | David Pryor P000556 | sen | AR | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
36264 | 36264 | Tim Hutchinson H001015 | sen | AR | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37774 | 37774 | Blanche Lincoln L000035 | sen | AR | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://lincoln.senate.gov/ | ||||||||||||
37775 | 37775 | Blanche Lincoln L000035 | sen | AR | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://lincoln.senate.gov/ | ||||||||||||
39721 | 39721 | Mark Pryor P000590 | sen | AR | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://pryor.senate.gov | ||||||||||||
39722 | 39722 | Mark Pryor P000590 | sen | AR | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.pryor.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2353 | 202-228-0908 | http://www.pryor.senate.gov/contact/form | 255 Dirksen Senate Office Building | senior | http://www.pryor.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||
43702 | 43702 | Tom Cotton C001095 | sen | AR | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.cotton.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-2353 | https://www.cotton.senate.gov/contact/contact-tom | 326 Russell Senate Office Building | junior | |||||||
43703 | 43703 | Tom Cotton C001095 | sen | AR | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.cotton.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-2353 | https://www.cotton.senate.gov/contact/contact-tom | 326 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);