legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
42 rows where party = "Republican", state = "ID" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: class, url, address, fax, office, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12063 | 12063 | William McConnell M000357 | sen | ID | 1890-01-01 | 1891-03-03 | 3 | Republican | |||||||||||||
13160 | 13160 | George Shoup S000382 | sen | ID | 1890-01-01 | 1895-03-03 | 2 | Republican | |||||||||||||
13161 | 13161 | George Shoup S000382 | sen | ID | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13938 | 13938 | Fred Dubois D000509 | sen | ID | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
15516 | 15516 | Weldon Heyburn H000554 | sen | ID | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
15517 | 15517 | Weldon Heyburn H000554 | sen | ID | 1909-03-15 | 1913-03-03 | 3 | Republican | |||||||||||||
16694 | 16694 | James Brady B000753 | sen | ID | 1913-04-07 | 1915-03-03 | 3 | Republican | |||||||||||||
16695 | 16695 | James Brady B000753 | sen | ID | 1915-12-06 | 1919-03-03 | 3 | Republican | |||||||||||||
19331 | 19331 | Frank Gooding G000288 | sen | ID | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19332 | 19332 | Frank Gooding G000288 | sen | ID | 1927-12-05 | 1929-03-03 | 3 | Republican | |||||||||||||
22047 | 22047 | William Borah B000634 | sen | ID | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
22048 | 22048 | William Borah B000634 | sen | ID | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
22049 | 22049 | William Borah B000634 | sen | ID | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
22050 | 22050 | William Borah B000634 | sen | ID | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
22051 | 22051 | William Borah B000634 | sen | ID | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
22052 | 22052 | William Borah B000634 | sen | ID | 1937-01-05 | 1941-01-03 | 2 | Republican | |||||||||||||
23708 | 23708 | John Thomas T000172 | sen | ID | 1928-06-30 | 1933-03-03 | 3 | Republican | appointment | ||||||||||||
23709 | 23709 | John Thomas T000172 | sen | ID | 1940-01-27 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
23710 | 23710 | John Thomas T000172 | sen | ID | 1943-01-06 | 1945-12-31 | 2 | Republican | |||||||||||||
25539 | 25539 | Herman Welker W000269 | sen | ID | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
27188 | 27188 | Henry Dworshak D000585 | sen | ID | 1946-01-01 | 1949-01-03 | 2 | Republican | |||||||||||||
27189 | 27189 | Henry Dworshak D000585 | sen | ID | 1949-10-14 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
27190 | 27190 | Henry Dworshak D000585 | sen | ID | 1955-01-05 | 1961-01-03 | 2 | Republican | |||||||||||||
27191 | 27191 | Henry Dworshak D000585 | sen | ID | 1961-01-03 | 1963-01-03 | 2 | Republican | |||||||||||||
28919 | 28919 | Leonard Jordan J000269 | sen | ID | 1962-08-06 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
28920 | 28920 | Leonard Jordan J000269 | sen | ID | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
33355 | 33355 | James McClure M000346 | sen | ID | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
33356 | 33356 | James McClure M000346 | sen | ID | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
33357 | 33357 | James McClure M000346 | sen | ID | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
33789 | 33789 | Steven Symms S001138 | sen | ID | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
33790 | 33790 | Steven Symms S001138 | sen | ID | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
35346 | 35346 | Dirk Kempthorne K000088 | sen | ID | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
37279 | 37279 | Larry Craig C000858 | sen | ID | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
37280 | 37280 | Larry Craig C000858 | sen | ID | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37281 | 37281 | Larry Craig C000858 | sen | ID | 2003-01-07 | 2009-01-03 | 2 | Republican | http://craig.senate.gov | ||||||||||||
41884 | 41884 | James Risch R000584 | sen | ID | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.risch.senate.gov | 483 Russell Senate Office Building Washington DC 20510 | 202-224-2752 | 202-224-2573 | http://www.risch.senate.gov/public/index.cfm?p=Email | 483 Russell Senate Office Building | junior | ||||||
41885 | 41885 | James Risch R000584 | sen | ID | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.risch.senate.gov | 483 Russell Senate Office Building Washington DC 20510 | 202-224-2752 | 202-224-2573 | http://www.risch.senate.gov/public/index.cfm?p=Email | 483 Russell Senate Office Building | junior | ||||||
41886 | 41886 | James Risch R000584 | sen | ID | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.risch.senate.gov | 483 Russell Senate Office Building Washington DC 20510 | 202-224-2752 | https://www.risch.senate.gov/public/index.cfm?p=Email | 483 Russell Senate Office Building | junior | |||||||
42234 | 42234 | Michael Crapo C000880 | sen | ID | 1999-01-06 | 2005-01-03 | 3 | Republican | http://crapo.senate.gov/ | ||||||||||||
42235 | 42235 | Michael Crapo C000880 | sen | ID | 2005-01-04 | 2011-01-03 | 3 | Republican | http://crapo.senate.gov | ||||||||||||
42236 | 42236 | Michael Crapo C000880 | sen | ID | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.crapo.senate.gov | 239 Dirksen Senate Office Building Washington DC 20510 | 202-224-6142 | 202-228-1375 | http://www.crapo.senate.gov/contact/email.cfm | 239 Dirksen Senate Office Building | senior | ||||||
42237 | 42237 | Michael Crapo C000880 | sen | ID | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.crapo.senate.gov | 239 Dirksen Senate Office Building Washington DC 20510 | 202-224-6142 | 202-228-1375 | https://www.crapo.senate.gov/contact | 239 Dirksen Senate Office Building | senior |
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);