legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
140 rows where party = "Republican" and state = "AZ"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, type, class, district, url, phone, fax, office, state_rank, rss_url, start (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 | |||||||||||||
10968 | 10968 | Curtis Bean B000278 | rep | AZ | 1885-12-07 | 1887-03-03 | Republican | 0 | |||||||||||||
13105 | 13105 | Nathan Murphy M001102 | rep | AZ | 1895-12-02 | 1897-03-03 | Republican | 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 | |||||||||||||
18082 | 18082 | Ralph Cameron C000066 | sen | AZ | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
29771 | 29771 | Paul Fannin F000013 | sen | AZ | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
29772 | 29772 | Paul Fannin F000013 | sen | AZ | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
32678 | 32678 | Barry Goldwater G000267 | sen | AZ | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
32679 | 32679 | Barry Goldwater G000267 | sen | AZ | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
32680 | 32680 | Barry Goldwater G000267 | sen | AZ | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
32681 | 32681 | Barry Goldwater G000267 | sen | AZ | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
32682 | 32682 | Barry Goldwater G000267 | sen | AZ | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
37173 | 37173 | Robert Stump S001044 | rep | AZ | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
37174 | 37174 | Robert Stump S001044 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
37175 | 37175 | Robert Stump S001044 | rep | AZ | 1987-01-06 | 1989-01-03 | Republican | 3 | |||||||||||||
37176 | 37176 | Robert Stump S001044 | rep | AZ | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
37177 | 37177 | Robert Stump S001044 | rep | AZ | 1991-01-03 | 1993-01-03 | Republican | 3 | |||||||||||||
37178 | 37178 | Robert Stump S001044 | rep | AZ | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
37179 | 37179 | Robert Stump S001044 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
37180 | 37180 | Robert Stump S001044 | rep | AZ | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
37181 | 37181 | Robert Stump S001044 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37182 | 37182 | Robert Stump S001044 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37675 | 37675 | John Hayworth H000413 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
37676 | 37676 | John Hayworth H000413 | rep | AZ | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
37677 | 37677 | John Hayworth H000413 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
37678 | 37678 | John Hayworth H000413 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37679 | 37679 | John Hayworth H000413 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/hayworth | ||||||||||||
37680 | 37680 | John Hayworth H000413 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/hayworth | ||||||||||||
37746 | 37746 | James Kolbe K000306 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
37747 | 37747 | James Kolbe K000306 | rep | AZ | 1987-01-06 | 1989-01-03 | Republican | 5 | |||||||||||||
37748 | 37748 | James Kolbe K000306 | rep | AZ | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
37749 | 37749 | James Kolbe K000306 | rep | AZ | 1991-01-03 | 1993-01-03 | Republican | 5 | |||||||||||||
37750 | 37750 | James Kolbe K000306 | rep | AZ | 1993-01-05 | 1995-01-03 | Republican | 5 | |||||||||||||
37751 | 37751 | James Kolbe K000306 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
37752 | 37752 | James Kolbe K000306 | rep | AZ | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
37753 | 37753 | James Kolbe K000306 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
37754 | 37754 | James Kolbe K000306 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
37755 | 37755 | James Kolbe K000306 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/kolbe | ||||||||||||
37756 | 37756 | James Kolbe K000306 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/kolbe | ||||||||||||
38311 | 38311 | Rick Renzi R000574 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38312 | 38312 | Rick Renzi R000574 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38313 | 38313 | Rick Renzi R000574 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38800 | 38800 | John Shadegg S000275 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
38801 | 38801 | John Shadegg S000275 | rep | AZ | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
38802 | 38802 | John Shadegg S000275 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
38803 | 38803 | John Shadegg S000275 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
38804 | 38804 | John Shadegg S000275 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/shadegg | ||||||||||||
38805 | 38805 | John Shadegg S000275 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/shadegg | ||||||||||||
38806 | 38806 | John Shadegg S000275 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 3 | http://johnshadegg.house.gov | ||||||||||||
38807 | 38807 | John Shadegg S000275 | rep | AZ | 2009-01-06 | 2011-01-03 | Republican | 3 | http://johnshadegg.house.gov | ||||||||||||
39472 | 39472 | Ben Quayle Q000024 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 3 | http://quayle.house.gov/ | 1419 Longworth HOB; Washington DC 20515-0303 | 202-225-3361 | 202-225-3462 | 1419 Longworth House Office Building | ||||||||
40487 | 40487 | Matt Salmon S000018 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
40488 | 40488 | Matt Salmon S000018 | rep | AZ | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
40489 | 40489 | Matt Salmon S000018 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
40490 | 40490 | Matt Salmon S000018 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 5 | http://salmon.house.gov | 2349 Rayburn HOB; Washington DC 20515-0305 | 202-225-2635 | 202-226-4386 | https://salmon.house.gov/contact/email-me | 2349 Rayburn House Office Building | http://salmon.house.gov/rss.xml | ||||||
40491 | 40491 | Matt Salmon S000018 | rep | AZ | 2015-01-06 | 2017-01-03 | Republican | 5 | http://salmon.house.gov | 2349 Rayburn HOB; Washington DC 20515-0305 | 202-225-2635 | 202-226-4386 | https://salmon.house.gov/contact/email-me | 2349 Rayburn House Office Building | http://salmon.house.gov/rss.xml | ||||||
40582 | 40582 | Trent Franks F000448 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/franks | ||||||||||||
40583 | 40583 | Trent Franks F000448 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/franks | ||||||||||||
40584 | 40584 | Trent Franks F000448 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/franks | ||||||||||||
40585 | 40585 | Trent Franks F000448 | rep | AZ | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/franks | ||||||||||||
40586 | 40586 | Trent Franks F000448 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 2 | http://www.house.gov/franks | 2435 Rayburn HOB; Washington DC 20515-0302 | 202-225-4576 | 202-225-6328 | https://forms.house.gov/franks/email_zipcheck.shtml | 2435 Rayburn House Office Building | |||||||
40587 | 40587 | Trent Franks F000448 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 8 | http://franks.house.gov | 2435 Rayburn HOB; Washington DC 20515-0308 | 202-225-4576 | 202-225-6328 | https://franks.house.gov/contact-me/email-me | 2435 Rayburn House Office Building | http://franks.house.gov/rss.xml | ||||||
40588 | 40588 | Trent Franks F000448 | rep | AZ | 2015-01-06 | 2017-01-03 | Republican | 8 | http://franks.house.gov | 2435 Rayburn HOB; Washington DC 20515-0308 | 202-225-4576 | 202-225-6328 | https://franks.house.gov/contact-me/email-me | 2435 Rayburn House Office Building | http://franks.house.gov/rss.xml | ||||||
40589 | 40589 | Trent Franks F000448 | rep | AZ | 2017-01-03 | 2017-12-08 | Republican | 8 | https://franks.house.gov | 2435 Rayburn HOB; Washington DC 20515-0308 | 202-225-4576 | 202-225-6328 | 2435 Rayburn House Office Building | http://franks.house.gov/rss.xml | |||||||
40646 | 40646 | John McCain M000303 | rep | AZ | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
40647 | 40647 | John McCain M000303 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
40648 | 40648 | John McCain M000303 | sen | AZ | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
40649 | 40649 | John McCain M000303 | sen | AZ | 1993-01-05 | 1999-01-03 | 3 | Republican |
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);