legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
348 rows where state = "OR"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, start, class, district, address, phone, contact_form, office, state_rank, 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 | |||||||||||||
7644 | 7644 | Edward Baker B000059 | sen | OR | 1860-01-01 | 1861-12-31 | 2 | Republican | |||||||||||||
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 | |||||||||||||
7997 | 7997 | John McBride M000301 | rep | OR | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8138 | 8138 | James Henderson H000480 | rep | OR | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8236 | 8236 | George Williams W000498 | sen | OR | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8297 | 8297 | Henry Corbett C000771 | sen | OR | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8381 | 8381 | Rufus Mallory M000083 | rep | OR | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
9424 | 9424 | Joseph Wilson W000605 | rep | OR | 1873-12-01 | 1875-03-03 | Republican | 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 | |||||||||||||
9987 | 9987 | Richard Williams W000533 | rep | OR | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
10727 | 10727 | Melvin George G000128 | rep | OR | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
10728 | 10728 | Melvin George G000128 | rep | OR | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
11735 | 11735 | Joseph Dolph D000405 | sen | OR | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
11736 | 11736 | Joseph Dolph D000405 | sen | OR | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13073 | 13073 | George McBride M000300 | sen | OR | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13542 | 13542 | Joseph Simon S000422 | sen | OR | 1898-01-01 | 1903-03-03 | 3 | Republican | |||||||||||||
14081 | 14081 | John Mitchell M000818 | sen | OR | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
14082 | 14082 | John Mitchell M000818 | sen | OR | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
14083 | 14083 | John Mitchell M000818 | sen | OR | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
14084 | 14084 | John Mitchell M000818 | sen | OR | 1901-12-02 | 1905-12-31 | 2 | Republican | |||||||||||||
14086 | 14086 | Malcolm Moody M000882 | rep | OR | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14087 | 14087 | Malcolm Moody M000882 | rep | OR | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14316 | 14316 | Charles Fulton F000420 | sen | OR | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14506 | 14506 | Thomas Tongue T000309 | rep | OR | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
14507 | 14507 | Thomas Tongue T000309 | rep | OR | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14508 | 14508 | Thomas Tongue T000309 | rep | OR | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14509 | 14509 | Thomas Tongue T000309 | rep | OR | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14667 | 14667 | John Gearin G000112 | sen | OR | 1905-12-04 | 1907-03-03 | 2 | Democrat | |||||||||||||
14707 | 14707 | Binger Hermann H000531 | rep | OR | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
14708 | 14708 | Binger Hermann H000531 | rep | OR | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
14709 | 14709 | Binger Hermann H000531 | rep | OR | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14710 | 14710 | Binger Hermann H000531 | rep | OR | 1891-12-07 | 1893-03-03 | Republican | 1 | |||||||||||||
14711 | 14711 | Binger Hermann H000531 | rep | OR | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
14712 | 14712 | Binger Hermann H000531 | rep | OR | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
14713 | 14713 | Binger Hermann H000531 | rep | OR | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14714 | 14714 | Binger Hermann H000531 | rep | OR | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14950 | 14950 | John Williamson W000552 | rep | OR | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14951 | 14951 | John Williamson W000552 | rep | OR | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14988 | 14988 | Jonathan Bourne B000670 | sen | OR | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
15441 | 15441 | William Ellis E000138 | rep | OR | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
15442 | 15442 | William Ellis E000138 | rep | OR | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
15443 | 15443 | William Ellis E000138 | rep | OR | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
15444 | 15444 | William Ellis E000138 | rep | OR | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15445 | 15445 | William Ellis E000138 | rep | OR | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
16437 | 16437 | Abraham Lafferty L000015 | rep | OR | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
16438 | 16438 | Abraham Lafferty L000015 | rep | OR | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
17527 | 17527 | Frederick Mulkey M001069 | sen | OR | 1907-12-02 | 1907-12-31 | 2 | Republican | |||||||||||||
17528 | 17528 | Frederick Mulkey M001069 | sen | OR | 1918-01-01 | 1919-03-03 | 2 | Republican | |||||||||||||
18341 | 18341 | Clifton McArthur M000298 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18342 | 18342 | Clifton McArthur M000298 | rep | OR | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18343 | 18343 | Clifton McArthur M000298 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18344 | 18344 | Clifton McArthur M000298 | rep | OR | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18493 | 18493 | Robert Stanfield S000791 | sen | OR | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18883 | 18883 | Elton Watkins W000191 | rep | OR | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19267 | 19267 | Maurice Crumpacker C000959 | rep | OR | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19268 | 19268 | Maurice Crumpacker C000959 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19480 | 19480 | Nicholas Sinnott S000450 | rep | OR | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
19481 | 19481 | Nicholas Sinnott S000450 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19482 | 19482 | Nicholas Sinnott S000450 | rep | OR | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
19483 | 19483 | Nicholas Sinnott S000450 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19484 | 19484 | Nicholas Sinnott S000450 | rep | OR | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19485 | 19485 | Nicholas Sinnott S000450 | rep | OR | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19486 | 19486 | Nicholas Sinnott S000450 | rep | OR | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19487 | 19487 | Nicholas Sinnott S000450 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19833 | 19833 | Franklin Korell K000317 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19834 | 19834 | Franklin Korell K000317 | rep | OR | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20150 | 20150 | Robert Butler B001187 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20151 | 20151 | Robert Butler B001187 | rep | OR | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20152 | 20152 | Robert Butler B001187 | rep | OR | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20497 | 20497 | Willis Hawley H000379 | rep | OR | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
20498 | 20498 | Willis Hawley H000379 | rep | OR | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
20499 | 20499 | Willis Hawley H000379 | rep | OR | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
20500 | 20500 | Willis Hawley H000379 | rep | OR | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
20501 | 20501 | Willis Hawley H000379 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
20502 | 20502 | Willis Hawley H000379 | rep | OR | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
20503 | 20503 | Willis Hawley H000379 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 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);