legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
136 rows where state = "ID" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: party, district, url, address, phone, fax, contact_form, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8057 | 8057 | William Wallace W000086 | rep | ID | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8356 | 8356 | Edward Holbrook H000710 | rep | ID | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
8357 | 8357 | Edward Holbrook H000710 | rep | ID | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8717 | 8717 | Jacob Shafer S000276 | rep | ID | 1869-03-04 | 1871-03-03 | Democrat | -1 | |||||||||||||
8968 | 8968 | Samuel Merritt M000662 | rep | ID | 1871-03-04 | 1873-03-03 | Democrat | -1 | |||||||||||||
9451 | 9451 | Thomas Bennett B000383 | rep | ID | 1875-12-06 | 1877-03-03 | Independent | -1 | |||||||||||||
9800 | 9800 | Stephen Fenn F000073 | rep | ID | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
9801 | 9801 | Stephen Fenn F000073 | rep | ID | 1877-10-15 | 1879-03-03 | Democrat | -1 | |||||||||||||
10248 | 10248 | George Ainslie A000066 | rep | ID | 1879-03-18 | 1881-03-03 | Democrat | -1 | |||||||||||||
10249 | 10249 | George Ainslie A000066 | rep | ID | 1881-12-05 | 1883-03-03 | Democrat | -1 | |||||||||||||
10889 | 10889 | Theodore Singiser S000443 | rep | ID | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
11056 | 11056 | John Hailey H000023 | rep | ID | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
11057 | 11057 | John Hailey H000023 | rep | ID | 1885-12-07 | 1887-03-03 | Democrat | -1 | |||||||||||||
12822 | 12822 | Willis Sweet S001110 | rep | ID | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12823 | 12823 | Willis Sweet S001110 | rep | ID | 1891-12-07 | 1893-03-03 | Republican | 1 | |||||||||||||
12824 | 12824 | Willis Sweet S001110 | rep | ID | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
13312 | 13312 | James Gunn G000525 | rep | ID | 1897-03-15 | 1899-03-03 | Populist | 1 | |||||||||||||
13832 | 13832 | Edgar Wilson W000573 | rep | ID | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
13833 | 13833 | Edgar Wilson W000573 | rep | ID | 1899-12-04 | 1901-03-03 | Silver Republican | 1 | |||||||||||||
13936 | 13936 | Fred Dubois D000509 | rep | ID | 1887-12-05 | 1889-03-03 | Republican | -1 | |||||||||||||
13937 | 13937 | Fred Dubois D000509 | rep | ID | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
13967 | 13967 | Thomas Glenn G000239 | rep | ID | 1901-12-02 | 1903-03-03 | Populist | 1 | |||||||||||||
15514 | 15514 | Thomas Hamer H000098 | rep | ID | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
16875 | 16875 | Robert McCracken M000378 | rep | ID | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
20387 | 20387 | Burton French F000375 | rep | ID | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
20388 | 20388 | Burton French F000375 | rep | ID | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
20389 | 20389 | Burton French F000375 | rep | ID | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
20390 | 20390 | Burton French F000375 | rep | ID | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
20391 | 20391 | Burton French F000375 | rep | ID | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
20392 | 20392 | Burton French F000375 | rep | ID | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
20393 | 20393 | Burton French F000375 | rep | ID | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20394 | 20394 | Burton French F000375 | rep | ID | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20395 | 20395 | Burton French F000375 | rep | ID | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20396 | 20396 | Burton French F000375 | rep | ID | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20397 | 20397 | Burton French F000375 | rep | ID | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20398 | 20398 | Burton French F000375 | rep | ID | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20399 | 20399 | Burton French F000375 | rep | ID | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20858 | 20858 | Addison Smith S000511 | rep | ID | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
20859 | 20859 | Addison Smith S000511 | rep | ID | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
20860 | 20860 | Addison Smith S000511 | rep | ID | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
20861 | 20861 | Addison Smith S000511 | rep | ID | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20862 | 20862 | Addison Smith S000511 | rep | ID | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20863 | 20863 | Addison Smith S000511 | rep | ID | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20864 | 20864 | Addison Smith S000511 | rep | ID | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20865 | 20865 | Addison Smith S000511 | rep | ID | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20866 | 20866 | Addison Smith S000511 | rep | ID | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20867 | 20867 | Addison Smith S000511 | rep | ID | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21210 | 21210 | Thomas Coffin C000592 | rep | ID | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22521 | 22521 | David Clark C000428 | rep | ID | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22522 | 22522 | David Clark C000428 | rep | ID | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
24432 | 24432 | Abe Goff G000253 | rep | ID | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25018 | 25018 | John Sanborn S000029 | rep | ID | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25019 | 25019 | John Sanborn S000029 | rep | ID | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25077 | 25077 | Compton White W000361 | rep | ID | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
25078 | 25078 | Compton White W000361 | rep | ID | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
25079 | 25079 | Compton White W000361 | rep | ID | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
25080 | 25080 | Compton White W000361 | rep | ID | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
25081 | 25081 | Compton White W000361 | rep | ID | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
25082 | 25082 | Compton White W000361 | rep | ID | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25083 | 25083 | Compton White W000361 | rep | ID | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25084 | 25084 | Compton White W000361 | rep | ID | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25551 | 25551 | John Wood W000700 | rep | ID | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26763 | 26763 | Hamer Budge B001035 | rep | ID | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26764 | 26764 | Hamer Budge B001035 | rep | ID | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26765 | 26765 | Hamer Budge B001035 | rep | ID | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26766 | 26766 | Hamer Budge B001035 | rep | ID | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26767 | 26767 | Hamer Budge B001035 | rep | ID | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
27185 | 27185 | Henry Dworshak D000585 | rep | ID | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
27186 | 27186 | Henry Dworshak D000585 | rep | ID | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
27187 | 27187 | Henry Dworshak D000585 | rep | ID | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
27411 | 27411 | Gracie Pfost P000287 | rep | ID | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27412 | 27412 | Gracie Pfost P000287 | rep | ID | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
27413 | 27413 | Gracie Pfost P000287 | rep | ID | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27414 | 27414 | Gracie Pfost P000287 | rep | ID | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
27415 | 27415 | Gracie Pfost P000287 | rep | ID | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27841 | 27841 | Ralph Harding H000191 | rep | ID | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27842 | 27842 | Ralph Harding H000191 | rep | ID | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28737 | 28737 | Compton White W000362 | rep | ID | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28738 | 28738 | Compton White W000362 | rep | ID | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30462 | 30462 | Orval Hansen H000175 | rep | ID | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30463 | 30463 | Orval Hansen H000175 | rep | ID | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30464 | 30464 | Orval Hansen H000175 | rep | ID | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
32985 | 32985 | George Hansen H000171 | rep | ID | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
32986 | 32986 | George Hansen H000171 | rep | ID | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
32987 | 32987 | George Hansen H000171 | rep | ID | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
32988 | 32988 | George Hansen H000171 | rep | ID | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
32989 | 32989 | George Hansen H000171 | rep | ID | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32990 | 32990 | George Hansen H000171 | rep | ID | 1981-01-05 | 1983-01-03 | Republican | 2 | |||||||||||||
32991 | 32991 | George Hansen H000171 | rep | ID | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
33352 | 33352 | James McClure M000346 | rep | ID | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
33353 | 33353 | James McClure M000346 | rep | ID | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
33354 | 33354 | James McClure M000346 | rep | ID | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
33785 | 33785 | Steven Symms S001138 | rep | ID | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
33786 | 33786 | Steven Symms S001138 | rep | ID | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
33787 | 33787 | Steven Symms S001138 | rep | ID | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
33788 | 33788 | Steven Symms S001138 | rep | ID | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
34989 | 34989 | Richard Stallings S000785 | rep | ID | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
34990 | 34990 | Richard Stallings S000785 | rep | ID | 1987-01-06 | 1989-01-03 | Democrat | 2 | |||||||||||||
34991 | 34991 | Richard Stallings S000785 | rep | ID | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34992 | 34992 | Richard Stallings S000785 | rep | ID | 1991-01-03 | 1993-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);