legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows
This data as json, copyable, CSV (advanced)
end (date) >30 ✖
- 1963-01-03 489
- 1971-01-03 483
- 1965-01-03 482
- 1983-01-03 481
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- 1981-01-03 479
- 1987-01-03 478
- 1961-01-03 477
- 1973-01-03 477
- 1979-01-03 477
- 1985-01-03 477
- 2015-01-03 476
- 1989-01-03 475
- 1993-01-03 475
- 1969-01-03 474
- 1995-01-03 474
- 1991-01-03 473
- 1999-01-03 473
- 2001-01-03 473
- 2011-01-03 473
- 2017-01-03 473
- 1997-01-03 472
- 2005-01-03 472
- 2009-01-03 472
- 2023-01-03 472
- 2003-01-03 471
- 2007-01-03 471
- 2013-01-03 470
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26072 | 26072 | Matthew Neely N000023 | sen | WV | 1955-01-05 | 1958-01-18 | 2 | Democrat | |||||||||||||
26073 | 26073 | Charles Nelson N000031 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26074 | 26074 | Charles Nelson N000031 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26075 | 26075 | Charles Nelson N000031 | rep | ME | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26076 | 26076 | Charles Nelson N000031 | rep | ME | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26077 | 26077 | Richard Neuberger N000053 | sen | OR | 1955-01-05 | 1960-03-09 | 2 | Democrat | |||||||||||||
26078 | 26078 | John Phillips P000309 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
26079 | 26079 | John Phillips P000309 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 22 | |||||||||||||
26080 | 26080 | John Phillips P000309 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 22 | |||||||||||||
26081 | 26081 | John Phillips P000309 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
26082 | 26082 | John Phillips P000309 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
26083 | 26083 | John Phillips P000309 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 29 | |||||||||||||
26084 | 26084 | John Phillips P000309 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 29 | |||||||||||||
26085 | 26085 | James Priest P000536 | rep | TN | 1941-01-03 | 1943-01-03 | Ind. Democrat | 5 | |||||||||||||
26086 | 26086 | James Priest P000536 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
26087 | 26087 | James Priest P000536 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
26088 | 26088 | James Priest P000536 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
26089 | 26089 | James Priest P000536 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26090 | 26090 | James Priest P000536 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26091 | 26091 | James Priest P000536 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26092 | 26092 | James Priest P000536 | rep | TN | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
26093 | 26093 | Chauncey Reed R000111 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 11 | |||||||||||||
26094 | 26094 | Chauncey Reed R000111 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 11 | |||||||||||||
26095 | 26095 | Chauncey Reed R000111 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 11 | |||||||||||||
26096 | 26096 | Chauncey Reed R000111 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 11 | |||||||||||||
26097 | 26097 | Chauncey Reed R000111 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
26098 | 26098 | Chauncey Reed R000111 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 11 | |||||||||||||
26099 | 26099 | Chauncey Reed R000111 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
26100 | 26100 | Chauncey Reed R000111 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
26101 | 26101 | Chauncey Reed R000111 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
26102 | 26102 | Chauncey Reed R000111 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 14 | |||||||||||||
26103 | 26103 | Chauncey Reed R000111 | rep | IL | 1955-01-05 | 1957-01-03 | Republican | 14 | |||||||||||||
26104 | 26104 | James Richards R000214 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
26105 | 26105 | James Richards R000214 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
26106 | 26106 | James Richards R000214 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
26107 | 26107 | James Richards R000214 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
26108 | 26108 | James Richards R000214 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
26109 | 26109 | James Richards R000214 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
26110 | 26110 | James Richards R000214 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
26111 | 26111 | James Richards R000214 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
26112 | 26112 | James Richards R000214 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
26113 | 26113 | James Richards R000214 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
26114 | 26114 | James Richards R000214 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26115 | 26115 | James Richards R000214 | rep | SC | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
26116 | 26116 | Dewey Short S000377 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
26117 | 26117 | Dewey Short S000377 | rep | MO | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
26118 | 26118 | Dewey Short S000377 | rep | MO | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
26119 | 26119 | Dewey Short S000377 | rep | MO | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
26120 | 26120 | Dewey Short S000377 | rep | MO | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
26121 | 26121 | Dewey Short S000377 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
26122 | 26122 | Dewey Short S000377 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
26123 | 26123 | Dewey Short S000377 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
26124 | 26124 | Dewey Short S000377 | rep | MO | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26125 | 26125 | Dewey Short S000377 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26126 | 26126 | Dewey Short S000377 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
26127 | 26127 | Dewey Short S000377 | rep | MO | 1955-01-05 | 1957-01-03 | Republican | 7 | |||||||||||||
26128 | 26128 | Ruth Thompson T000216 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
26129 | 26129 | Ruth Thompson T000216 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
26130 | 26130 | Ruth Thompson T000216 | rep | MI | 1955-01-05 | 1957-01-03 | Republican | 9 | |||||||||||||
26131 | 26131 | Thomas Tumulty T000408 | rep | NJ | 1955-01-05 | 1957-01-03 | Democrat | 14 | |||||||||||||
26132 | 26132 | Harold Velde V000082 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
26133 | 26133 | Harold Velde V000082 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 18 | |||||||||||||
26134 | 26134 | Harold Velde V000082 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 18 | |||||||||||||
26135 | 26135 | Harold Velde V000082 | rep | IL | 1955-01-05 | 1957-01-03 | Republican | 18 | |||||||||||||
26136 | 26136 | Jesse Wolcott W000668 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
26137 | 26137 | Jesse Wolcott W000668 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
26138 | 26138 | Jesse Wolcott W000668 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
26139 | 26139 | Jesse Wolcott W000668 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
26140 | 26140 | Jesse Wolcott W000668 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
26141 | 26141 | Jesse Wolcott W000668 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
26142 | 26142 | Jesse Wolcott W000668 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
26143 | 26143 | Jesse Wolcott W000668 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
26144 | 26144 | Jesse Wolcott W000668 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
26145 | 26145 | Jesse Wolcott W000668 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26146 | 26146 | Jesse Wolcott W000668 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26147 | 26147 | Jesse Wolcott W000668 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
26148 | 26148 | Jesse Wolcott W000668 | rep | MI | 1955-01-05 | 1957-01-03 | Republican | 7 | |||||||||||||
26149 | 26149 | Clarence Young Y000032 | rep | NV | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26150 | 26150 | Clarence Young Y000032 | rep | NV | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26151 | 26151 | Robert Humphreys H000963 | sen | KY | 1956-06-21 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
26152 | 26152 | William Laird L000025 | sen | WV | 1956-03-13 | 1957-01-03 | 1 | Democrat | appointment | ||||||||||||
26153 | 26153 | William Revercomb R000167 | sen | WV | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
26154 | 26154 | William Revercomb R000167 | sen | WV | 1956-01-01 | 1959-01-03 | 1 | Republican | |||||||||||||
26155 | 26155 | Thomas Wofford W000666 | sen | SC | 1956-04-05 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
26156 | 26156 | John Allen A000133 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
26157 | 26157 | John Allen A000133 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26158 | 26158 | John Allen A000133 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26159 | 26159 | John Allen A000133 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
26160 | 26160 | John Allen A000133 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 7 | |||||||||||||
26161 | 26161 | John Allen A000133 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26162 | 26162 | August Andresen A000239 | rep | MN | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
26163 | 26163 | August Andresen A000239 | rep | MN | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
26164 | 26164 | August Andresen A000239 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
26165 | 26165 | August Andresen A000239 | rep | MN | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
26166 | 26166 | August Andresen A000239 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
26167 | 26167 | August Andresen A000239 | rep | MN | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
26168 | 26168 | August Andresen A000239 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
26169 | 26169 | August Andresen A000239 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
26170 | 26170 | August Andresen A000239 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
26171 | 26171 | August Andresen A000239 | rep | MN | 1945-01-03 | 1947-01-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);