legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
39 rows where class = 2 and state = "AR"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, party, url, address, contact_form, office, 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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
8495 | 8495 | Alexander McDonald M000408 | sen | AR | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8858 | 8858 | Powell Clayton C000498 | sen | AR | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
23257 | 23257 | George Spencer S000724 | sen | AR | 1941-04-01 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
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 | |||||||||||||
36264 | 36264 | Tim Hutchinson H001015 | sen | AR | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
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 | |||||
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);