legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
166 rows where party = "Democrat" and state = "OR"
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, url, address, phone, contact_form, office, rss_url, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6149 | 6149 | Samuel Thurston T000258 | rep | OR | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
7475 | 7475 | Joseph Lane L000062 | rep | OR | 1851-12-01 | 1853-03-03 | Democrat | -1 | |||||||||||||
7476 | 7476 | Joseph Lane L000062 | rep | OR | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
7477 | 7477 | Joseph Lane L000062 | rep | OR | 1855-12-03 | 1857-03-03 | Democrat | -1 | |||||||||||||
7478 | 7478 | Joseph Lane L000062 | rep | OR | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
7479 | 7479 | Joseph Lane L000062 | sen | OR | 1859-12-05 | 1861-03-03 | 3 | Democrat | |||||||||||||
7568 | 7568 | Delazon Smith S000526 | sen | OR | 1859-12-05 | 1859-12-31 | 2 | Democrat | |||||||||||||
7593 | 7593 | Lansing Stout S000981 | rep | OR | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7850 | 7850 | George Shiel S000358 | rep | OR | 1861-07-04 | 1863-03-03 | Democrat | 1 | |||||||||||||
7856 | 7856 | Benjamin Stark S000809 | sen | OR | 1861-07-04 | 1863-03-03 | 2 | Democrat | |||||||||||||
7859 | 7859 | Andrew Thayer T000144 | rep | OR | 1861-07-04 | 1863-03-03 | Democrat | 1 | |||||||||||||
7896 | 7896 | Benjamin Harding H000189 | sen | OR | 1862-01-01 | 1865-03-03 | 2 | Democrat | |||||||||||||
8720 | 8720 | Joseph Smith S000581 | rep | OR | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8940 | 8940 | James Kelly K000074 | sen | OR | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9287 | 9287 | James Nesmith N000050 | sen | OR | 1861-07-04 | 1867-03-03 | 3 | Democrat | |||||||||||||
9288 | 9288 | James Nesmith N000050 | rep | OR | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9562 | 9562 | George La Dow L000002 | rep | OR | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9564 | 9564 | La Lane L000064 | rep | OR | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9828 | 9828 | La Grover G000505 | rep | OR | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
9829 | 9829 | La Grover G000505 | sen | OR | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
10191 | 10191 | James Slater S000476 | rep | OR | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
10192 | 10192 | James Slater S000476 | sen | OR | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10220 | 10220 | John Whiteaker W000399 | rep | OR | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
14667 | 14667 | John Gearin G000112 | sen | OR | 1905-12-04 | 1907-03-03 | 2 | Democrat | |||||||||||||
16439 | 16439 | Harry Lane L000059 | sen | OR | 1913-04-07 | 1917-12-31 | 2 | Democrat | |||||||||||||
16726 | 16726 | George Chamberlain C000277 | sen | OR | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
16727 | 16727 | George Chamberlain C000277 | sen | OR | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18883 | 18883 | Elton Watkins W000191 | rep | OR | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
21395 | 21395 | Charles Martin M000173 | rep | OR | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21396 | 21396 | Charles Martin M000173 | rep | OR | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22234 | 22234 | Nan Honeyman H000754 | rep | OR | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22466 | 22466 | Alfred Reames R000099 | sen | OR | 1938-02-01 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
23176 | 23176 | Walter Pierce P000339 | rep | OR | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
23177 | 23177 | Walter Pierce P000339 | rep | OR | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23178 | 23178 | Walter Pierce P000339 | rep | OR | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23179 | 23179 | Walter Pierce P000339 | rep | OR | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23180 | 23180 | Walter Pierce P000339 | rep | OR | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
26077 | 26077 | Richard Neuberger N000053 | sen | OR | 1955-01-05 | 1960-03-09 | 2 | Democrat | |||||||||||||
26938 | 26938 | Charles Porter P000439 | rep | OR | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26939 | 26939 | Charles Porter P000439 | rep | OR | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
27057 | 27057 | Hall Lusk L000520 | sen | OR | 1960-03-16 | 1961-01-03 | 2 | Democrat | appointment | ||||||||||||
27058 | 27058 | Maurine Neuberger N000052 | sen | OR | 1960-11-09 | 1961-01-03 | 2 | Democrat | |||||||||||||
27059 | 27059 | Maurine Neuberger N000052 | sen | OR | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28034 | 28034 | Wayne Morse M001014 | sen | OR | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
28035 | 28035 | Wayne Morse M001014 | sen | OR | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30386 | 30386 | Edith Green G000407 | rep | OR | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
30387 | 30387 | Edith Green G000407 | rep | OR | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
30388 | 30388 | Edith Green G000407 | rep | OR | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
30389 | 30389 | Edith Green G000407 | rep | OR | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30390 | 30390 | Edith Green G000407 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30391 | 30391 | Edith Green G000407 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30392 | 30392 | Edith Green G000407 | rep | OR | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
30393 | 30393 | Edith Green G000407 | rep | OR | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30394 | 30394 | Edith Green G000407 | rep | OR | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30395 | 30395 | Edith Green G000407 | rep | OR | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
32044 | 32044 | Robert Duncan D000537 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
32045 | 32045 | Robert Duncan D000537 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32046 | 32046 | Robert Duncan D000537 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32047 | 32047 | Robert Duncan D000537 | rep | OR | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
32048 | 32048 | Robert Duncan D000537 | rep | OR | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
32355 | 32355 | Albert Ullman U000004 | rep | OR | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
32356 | 32356 | Albert Ullman U000004 | rep | OR | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
32357 | 32357 | Albert Ullman U000004 | rep | OR | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
32358 | 32358 | Albert Ullman U000004 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32359 | 32359 | Albert Ullman U000004 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32360 | 32360 | Albert Ullman U000004 | rep | OR | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
32361 | 32361 | Albert Ullman U000004 | rep | OR | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32362 | 32362 | Albert Ullman U000004 | rep | OR | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32363 | 32363 | Albert Ullman U000004 | rep | OR | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
32364 | 32364 | Albert Ullman U000004 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32365 | 32365 | Albert Ullman U000004 | rep | OR | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
32366 | 32366 | Albert Ullman U000004 | rep | OR | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
33428 | 33428 | James Weaver W000227 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33429 | 33429 | James Weaver W000227 | rep | OR | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
33430 | 33430 | James Weaver W000227 | rep | OR | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
33431 | 33431 | James Weaver W000227 | rep | OR | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
33432 | 33432 | James Weaver W000227 | rep | OR | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33433 | 33433 | James Weaver W000227 | rep | OR | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
34211 | 34211 | Les AuCoin A000337 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34212 | 34212 | Les AuCoin A000337 | rep | OR | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34213 | 34213 | Les AuCoin A000337 | rep | OR | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34214 | 34214 | Les AuCoin A000337 | rep | OR | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
34215 | 34215 | Les AuCoin A000337 | rep | OR | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34216 | 34216 | Les AuCoin A000337 | rep | OR | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34217 | 34217 | Les AuCoin A000337 | rep | OR | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
34218 | 34218 | Les AuCoin A000337 | rep | OR | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34219 | 34219 | Les AuCoin A000337 | rep | OR | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35348 | 35348 | Michael Kopetski K000312 | rep | OR | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
35349 | 35349 | Michael Kopetski K000312 | rep | OR | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
36190 | 36190 | Elizabeth Furse F000434 | rep | OR | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36191 | 36191 | Elizabeth Furse F000434 | rep | OR | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36192 | 36192 | Elizabeth Furse F000434 | rep | OR | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
38103 | 38103 | Darlene Hooley H000762 | rep | OR | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
38104 | 38104 | Darlene Hooley H000762 | rep | OR | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
38105 | 38105 | Darlene Hooley H000762 | rep | OR | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
38106 | 38106 | Darlene Hooley H000762 | rep | OR | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/hooley | ||||||||||||
38107 | 38107 | Darlene Hooley H000762 | rep | OR | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/hooley | ||||||||||||
38108 | 38108 | Darlene Hooley H000762 | rep | OR | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/hooley | ||||||||||||
38992 | 38992 | David Wu W000793 | rep | OR | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
38993 | 38993 | David Wu W000793 | rep | OR | 2001-01-03 | 2003-01-03 | Democrat | 1 |
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);