legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
137 rows where party = "Democrat" and state = "AZ"
This data as json, copyable, CSV (advanced)
Suggested facets: type, url, address, phone, fax, office, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9943 | 9943 | Hiram Stevens S000880 | rep | AZ | 1875-12-06 | 1877-03-03 | Democrat | 0 | |||||||||||||
9944 | 9944 | Hiram Stevens S000880 | rep | AZ | 1877-10-15 | 1879-03-03 | Democrat | 0 | |||||||||||||
10024 | 10024 | John Campbell C000092 | rep | AZ | 1879-03-18 | 1881-03-03 | Democrat | 0 | |||||||||||||
10828 | 10828 | Granville Oury O000135 | rep | AZ | 1881-12-05 | 1883-03-03 | Democrat | 0 | |||||||||||||
10829 | 10829 | Granville Oury O000135 | rep | AZ | 1883-12-03 | 1885-03-03 | Democrat | 0 | |||||||||||||
14534 | 14534 | John Wilson W000599 | rep | AZ | 1899-12-04 | 1901-03-03 | Democrat | 0 | |||||||||||||
14535 | 14535 | John Wilson W000599 | rep | AZ | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
16970 | 16970 | Marcus Smith S000589 | rep | AZ | 1887-12-05 | 1889-03-03 | Democrat | 0 | |||||||||||||
16971 | 16971 | Marcus Smith S000589 | rep | AZ | 1889-12-02 | 1891-03-03 | Democrat | 0 | |||||||||||||
16972 | 16972 | Marcus Smith S000589 | rep | AZ | 1891-12-07 | 1893-03-03 | Democrat | 0 | |||||||||||||
16973 | 16973 | Marcus Smith S000589 | rep | AZ | 1893-08-07 | 1895-03-03 | Democrat | 0 | |||||||||||||
16974 | 16974 | Marcus Smith S000589 | rep | AZ | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
16975 | 16975 | Marcus Smith S000589 | rep | AZ | 1901-12-02 | 1903-03-03 | Democrat | 0 | |||||||||||||
16976 | 16976 | Marcus Smith S000589 | rep | AZ | 1905-12-04 | 1907-03-03 | Democrat | 0 | |||||||||||||
16977 | 16977 | Marcus Smith S000589 | rep | AZ | 1907-12-02 | 1909-03-03 | Democrat | 0 | |||||||||||||
16978 | 16978 | Marcus Smith S000589 | sen | AZ | 1912-01-01 | 1915-03-03 | 3 | Democrat | |||||||||||||
16979 | 16979 | Marcus Smith S000589 | sen | AZ | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
20308 | 20308 | Lewis Douglas D000455 | rep | AZ | 1927-12-05 | 1929-03-03 | Democrat | 0 | |||||||||||||
20309 | 20309 | Lewis Douglas D000455 | rep | AZ | 1929-04-15 | 1931-03-03 | Democrat | 0 | |||||||||||||
20310 | 20310 | Lewis Douglas D000455 | rep | AZ | 1931-12-07 | 1933-03-03 | Democrat | 0 | |||||||||||||
21622 | 21622 | Henry Ashurst A000319 | sen | AZ | 1912-03-27 | 1917-03-03 | 1 | Democrat | |||||||||||||
21623 | 21623 | Henry Ashurst A000319 | sen | AZ | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21624 | 21624 | Henry Ashurst A000319 | sen | AZ | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
21625 | 21625 | Henry Ashurst A000319 | sen | AZ | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21626 | 21626 | Henry Ashurst A000319 | sen | AZ | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21773 | 21773 | Isabella Greenway G000435 | rep | AZ | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21774 | 21774 | Isabella Greenway G000435 | rep | AZ | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
24452 | 24452 | Richard Harless H000212 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
24453 | 24453 | Richard Harless H000212 | rep | AZ | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
24454 | 24454 | Richard Harless H000212 | rep | AZ | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
24600 | 24600 | Ernest McFarland M000438 | sen | AZ | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
24601 | 24601 | Ernest McFarland M000438 | sen | AZ | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25394 | 25394 | John Murdock M001081 | rep | AZ | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
25395 | 25395 | John Murdock M001081 | rep | AZ | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
25396 | 25396 | John Murdock M001081 | rep | AZ | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
25397 | 25397 | John Murdock M001081 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
25398 | 25398 | John Murdock M001081 | rep | AZ | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
25399 | 25399 | John Murdock M001081 | rep | AZ | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
25400 | 25400 | John Murdock M001081 | rep | AZ | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25401 | 25401 | John Murdock M001081 | rep | AZ | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25774 | 25774 | Harold Patten P000107 | rep | AZ | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25775 | 25775 | Harold Patten P000107 | rep | AZ | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25776 | 25776 | Harold Patten P000107 | rep | AZ | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
27569 | 27569 | Stewart Udall U000002 | rep | AZ | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
27570 | 27570 | Stewart Udall U000002 | rep | AZ | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27571 | 27571 | Stewart Udall U000002 | rep | AZ | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
27572 | 27572 | Stewart Udall U000002 | rep | AZ | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27843 | 27843 | Carl Hayden H000385 | rep | AZ | 1911-04-04 | 1913-03-03 | Democrat | 0 | |||||||||||||
27844 | 27844 | Carl Hayden H000385 | rep | AZ | 1913-04-07 | 1915-03-03 | Democrat | 0 | |||||||||||||
27845 | 27845 | Carl Hayden H000385 | rep | AZ | 1915-12-06 | 1917-03-03 | Democrat | 0 | |||||||||||||
27846 | 27846 | Carl Hayden H000385 | rep | AZ | 1917-04-02 | 1919-03-03 | Democrat | 0 | |||||||||||||
27847 | 27847 | Carl Hayden H000385 | rep | AZ | 1919-05-19 | 1921-03-03 | Democrat | 0 | |||||||||||||
27848 | 27848 | Carl Hayden H000385 | rep | AZ | 1921-04-11 | 1923-03-03 | Democrat | 0 | |||||||||||||
27849 | 27849 | Carl Hayden H000385 | rep | AZ | 1923-12-03 | 1925-03-03 | Democrat | 0 | |||||||||||||
27850 | 27850 | Carl Hayden H000385 | rep | AZ | 1925-12-07 | 1927-03-04 | Democrat | 0 | |||||||||||||
27851 | 27851 | Carl Hayden H000385 | sen | AZ | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
27852 | 27852 | Carl Hayden H000385 | sen | AZ | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
27853 | 27853 | Carl Hayden H000385 | sen | AZ | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
27854 | 27854 | Carl Hayden H000385 | sen | AZ | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27855 | 27855 | Carl Hayden H000385 | sen | AZ | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
27856 | 27856 | Carl Hayden H000385 | sen | AZ | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27857 | 27857 | Carl Hayden H000385 | sen | AZ | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28653 | 28653 | George Senner S000243 | rep | AZ | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28654 | 28654 | George Senner S000243 | rep | AZ | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
33054 | 33054 | James McNulty M000589 | rep | AZ | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33877 | 33877 | Dennis DeConcini D000185 | sen | AZ | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
33878 | 33878 | Dennis DeConcini D000185 | sen | AZ | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33879 | 33879 | Dennis DeConcini D000185 | sen | AZ | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
35013 | 35013 | Morris Udall U000001 | rep | AZ | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
35014 | 35014 | Morris Udall U000001 | rep | AZ | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35015 | 35015 | Morris Udall U000001 | rep | AZ | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35016 | 35016 | Morris Udall U000001 | rep | AZ | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
35017 | 35017 | Morris Udall U000001 | rep | AZ | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
35018 | 35018 | Morris Udall U000001 | rep | AZ | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
35019 | 35019 | Morris Udall U000001 | rep | AZ | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
35020 | 35020 | Morris Udall U000001 | rep | AZ | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
35021 | 35021 | Morris Udall U000001 | rep | AZ | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
35022 | 35022 | Morris Udall U000001 | rep | AZ | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
35023 | 35023 | Morris Udall U000001 | rep | AZ | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
35024 | 35024 | Morris Udall U000001 | rep | AZ | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
35025 | 35025 | Morris Udall U000001 | rep | AZ | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
35026 | 35026 | Morris Udall U000001 | rep | AZ | 1987-01-06 | 1989-01-03 | Democrat | 2 | |||||||||||||
35027 | 35027 | Morris Udall U000001 | rep | AZ | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
35028 | 35028 | Morris Udall U000001 | rep | AZ | 1991-01-03 | 1991-05-04 | Democrat | 2 | |||||||||||||
35170 | 35170 | Samuel Coppersmith C000767 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35225 | 35225 | Karan English E000186 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
37170 | 37170 | Robert Stump S001044 | rep | AZ | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
37171 | 37171 | Robert Stump S001044 | rep | AZ | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
37172 | 37172 | Robert Stump S001044 | rep | AZ | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
38668 | 38668 | Harry Mitchell M001167 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://mitchell.house.gov | ||||||||||||
38669 | 38669 | Harry Mitchell M001167 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://mitchell.house.gov | ||||||||||||
38946 | 38946 | Gabrielle Giffords G000554 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://giffords.house.gov | ||||||||||||
38947 | 38947 | Gabrielle Giffords G000554 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://giffords.house.gov | ||||||||||||
38948 | 38948 | Gabrielle Giffords G000554 | rep | AZ | 2011-01-05 | 2012-01-25 | Democrat | 8 | http://giffords.house.gov | 1030 Longworth House Office Building; 20515-0308 | |||||||||||
39997 | 39997 | Ed Pastor P000099 | rep | AZ | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
39998 | 39998 | Ed Pastor P000099 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
39999 | 39999 | Ed Pastor P000099 | rep | AZ | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
40000 | 40000 | Ed Pastor P000099 | rep | AZ | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
40001 | 40001 | Ed Pastor P000099 | rep | AZ | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
40002 | 40002 | Ed Pastor P000099 | rep | AZ | 2001-01-03 | 2003-01-03 | Democrat | 2 |
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);