legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
240 rows where state = "AZ" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: party, district, phone, fax, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8021 | 8021 | Charles Poston P000458 | rep | AZ | 1863-12-07 | 1865-03-03 | Republican | 0 | |||||||||||||
8119 | 8119 | John Goodwin G000301 | rep | AZ | 1865-12-04 | 1867-03-03 | Republican | 0 | |||||||||||||
8261 | 8261 | Coles Bashford B000219 | rep | AZ | 1867-03-04 | 1869-03-03 | Independent | 0 | |||||||||||||
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 | |||||||||||||
10968 | 10968 | Curtis Bean B000278 | rep | AZ | 1885-12-07 | 1887-03-03 | Republican | 0 | |||||||||||||
13077 | 13077 | Richard McCormick M000371 | rep | AZ | 1869-03-04 | 1871-03-03 | Unionist | 0 | |||||||||||||
13078 | 13078 | Richard McCormick M000371 | rep | AZ | 1871-03-04 | 1873-03-03 | Unionist | 0 | |||||||||||||
13079 | 13079 | Richard McCormick M000371 | rep | AZ | 1873-12-01 | 1875-03-03 | Unionist | 0 | |||||||||||||
13105 | 13105 | Nathan Murphy M001102 | rep | AZ | 1895-12-02 | 1897-03-03 | Republican | 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 | |||||||||||||
18080 | 18080 | Ralph Cameron C000066 | rep | AZ | 1909-03-15 | 1911-03-03 | Republican | 0 | |||||||||||||
18081 | 18081 | Ralph Cameron C000066 | rep | AZ | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
30876 | 30876 | John Conlan C000682 | rep | AZ | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
30877 | 30877 | John Conlan C000682 | rep | AZ | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
31337 | 31337 | Sam Steiger S000846 | rep | AZ | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
31338 | 31338 | Sam Steiger S000846 | rep | AZ | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
31339 | 31339 | Sam Steiger S000846 | rep | AZ | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
31340 | 31340 | Sam Steiger S000846 | rep | AZ | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
31341 | 31341 | Sam Steiger S000846 | rep | AZ | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
32823 | 32823 | John Rhodes R000188 | rep | AZ | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
32824 | 32824 | John Rhodes R000188 | rep | AZ | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
32825 | 32825 | John Rhodes R000188 | rep | AZ | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
32826 | 32826 | John Rhodes R000188 | rep | AZ | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
32827 | 32827 | John Rhodes R000188 | rep | AZ | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
32828 | 32828 | John Rhodes R000188 | rep | AZ | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
32829 | 32829 | John Rhodes R000188 | rep | AZ | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
32830 | 32830 | John Rhodes R000188 | rep | AZ | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
32831 | 32831 | John Rhodes R000188 | rep | AZ | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32832 | 32832 | John Rhodes R000188 | rep | AZ | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
32833 | 32833 | John Rhodes R000188 | rep | AZ | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
32834 | 32834 | John Rhodes R000188 | rep | AZ | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
32835 | 32835 | John Rhodes R000188 | rep | AZ | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
32836 | 32836 | John Rhodes R000188 | rep | AZ | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32837 | 32837 | John Rhodes R000188 | rep | AZ | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
33054 | 33054 | James McNulty M000589 | rep | AZ | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33399 | 33399 | Eldon Rudd R000495 | rep | AZ | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
33400 | 33400 | Eldon Rudd R000495 | rep | AZ | 1979-01-15 | 1981-01-03 | Republican | 4 | |||||||||||||
33401 | 33401 | Eldon Rudd R000495 | rep | AZ | 1981-01-05 | 1983-01-03 | Republican | 4 | |||||||||||||
33402 | 33402 | Eldon Rudd R000495 | rep | AZ | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
33403 | 33403 | Eldon Rudd R000495 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
34866 | 34866 | John Rhodes R000189 | rep | AZ | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
34867 | 34867 | John Rhodes R000189 | rep | AZ | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
34868 | 34868 | John Rhodes R000189 | rep | AZ | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
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 |
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);