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)
start (date) >30 ✖
- 1969-01-03 482
- 1981-01-05 482
- 1989-01-03 481
- 1975-01-14 480
- 1971-01-21 478
- 1977-01-04 478
- 1983-01-03 478
- 1991-01-03 478
- 1973-01-03 477
- 1979-01-15 477
- 1985-01-03 477
- 1987-01-06 477
- 1965-01-04 476
- 1993-01-05 476
- 1997-01-07 475
- 2015-01-06 475
- 2003-01-07 474
- 2011-01-05 474
- 2017-01-03 474
- 1967-01-10 473
- 1999-01-06 473
- 2005-01-04 473
- 2007-01-04 473
- 2013-01-03 473
- 1995-01-04 472
- 2001-01-03 472
- 2009-01-06 472
- 2019-01-03 471
- 2021-01-03 471
- 1963-01-09 381
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28263 | 28263 | Victor Wickersham W000439 | rep | OK | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
28264 | 28264 | Victor Wickersham W000439 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
28265 | 28265 | Victor Wickersham W000439 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
28266 | 28266 | Victor Wickersham W000439 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
28267 | 28267 | Victor Wickersham W000439 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
28268 | 28268 | Victor Wickersham W000439 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
28269 | 28269 | Victor Wickersham W000439 | rep | OK | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
28270 | 28270 | Victor Wickersham W000439 | rep | OK | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28271 | 28271 | Victor Wickersham W000439 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
28272 | 28272 | Earl Wilson W000572 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
28273 | 28273 | Earl Wilson W000572 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
28274 | 28274 | Earl Wilson W000572 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
28275 | 28275 | Earl Wilson W000572 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
28276 | 28276 | Earl Wilson W000572 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
28277 | 28277 | Earl Wilson W000572 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
28278 | 28278 | Earl Wilson W000572 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
28279 | 28279 | Earl Wilson W000572 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 9 | |||||||||||||
28280 | 28280 | Earl Wilson W000572 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
28281 | 28281 | Earl Wilson W000572 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
28282 | 28282 | Earl Wilson W000572 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
28283 | 28283 | William Winstead W000641 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
28284 | 28284 | William Winstead W000641 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
28285 | 28285 | William Winstead W000641 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
28286 | 28286 | William Winstead W000641 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28287 | 28287 | William Winstead W000641 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
28288 | 28288 | William Winstead W000641 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28289 | 28289 | William Winstead W000641 | rep | MS | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
28290 | 28290 | William Winstead W000641 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28291 | 28291 | William Winstead W000641 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28292 | 28292 | William Winstead W000641 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28293 | 28293 | William Winstead W000641 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28294 | 28294 | Lyndon Johnson J000160 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
28295 | 28295 | Lyndon Johnson J000160 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
28296 | 28296 | Lyndon Johnson J000160 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 10 | |||||||||||||
28297 | 28297 | Lyndon Johnson J000160 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
28298 | 28298 | Lyndon Johnson J000160 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
28299 | 28299 | Lyndon Johnson J000160 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
28300 | 28300 | Lyndon Johnson J000160 | sen | TX | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28301 | 28301 | Lyndon Johnson J000160 | sen | TX | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
28302 | 28302 | Ross Bass B000223 | rep | TN | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
28303 | 28303 | Ross Bass B000223 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28304 | 28304 | Ross Bass B000223 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28305 | 28305 | Ross Bass B000223 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28306 | 28306 | Ross Bass B000223 | rep | TN | 1963-01-09 | 1964-11-03 | Democrat | 6 | |||||||||||||
28307 | 28307 | Ross Bass B000223 | sen | TN | 1964-11-04 | 1967-01-03 | 2 | Democrat | |||||||||||||
28308 | 28308 | Pierre Salinger S000016 | sen | CA | 1964-08-04 | 1965-01-03 | 1 | Democrat | appointment | ||||||||||||
28309 | 28309 | Arthur Andrews A000204 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
28310 | 28310 | John Baldwin B000092 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 6 | |||||||||||||
28311 | 28311 | John Baldwin B000092 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
28312 | 28312 | John Baldwin B000092 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
28313 | 28313 | John Baldwin B000092 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
28314 | 28314 | John Baldwin B000092 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 14 | |||||||||||||
28315 | 28315 | John Baldwin B000092 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 14 | |||||||||||||
28316 | 28316 | Bert Bandstra B000108 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28317 | 28317 | Lindley Beckworth B000296 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
28318 | 28318 | Lindley Beckworth B000296 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
28319 | 28319 | Lindley Beckworth B000296 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
28320 | 28320 | Lindley Beckworth B000296 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
28321 | 28321 | Lindley Beckworth B000296 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
28322 | 28322 | Lindley Beckworth B000296 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
28323 | 28323 | Lindley Beckworth B000296 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28324 | 28324 | Lindley Beckworth B000296 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28325 | 28325 | Lindley Beckworth B000296 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
28326 | 28326 | Lindley Beckworth B000296 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28327 | 28327 | Lindley Beckworth B000296 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28328 | 28328 | Lindley Beckworth B000296 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28329 | 28329 | Herbert Bonner B000621 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
28330 | 28330 | Herbert Bonner B000621 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
28331 | 28331 | Herbert Bonner B000621 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
28332 | 28332 | Herbert Bonner B000621 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
28333 | 28333 | Herbert Bonner B000621 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
28334 | 28334 | Herbert Bonner B000621 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
28335 | 28335 | Herbert Bonner B000621 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
28336 | 28336 | Herbert Bonner B000621 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28337 | 28337 | Herbert Bonner B000621 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
28338 | 28338 | Herbert Bonner B000621 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
28339 | 28339 | Herbert Bonner B000621 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
28340 | 28340 | Herbert Bonner B000621 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
28341 | 28341 | Herbert Bonner B000621 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28342 | 28342 | Herbert Bonner B000621 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28343 | 28343 | Clarence Brown B000909 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
28344 | 28344 | Clarence Brown B000909 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
28345 | 28345 | Clarence Brown B000909 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
28346 | 28346 | Clarence Brown B000909 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
28347 | 28347 | Clarence Brown B000909 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
28348 | 28348 | Clarence Brown B000909 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
28349 | 28349 | Clarence Brown B000909 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
28350 | 28350 | Clarence Brown B000909 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
28351 | 28351 | Clarence Brown B000909 | rep | OH | 1955-01-05 | 1957-01-03 | Republican | 7 | |||||||||||||
28352 | 28352 | Clarence Brown B000909 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
28353 | 28353 | Clarence Brown B000909 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 7 | |||||||||||||
28354 | 28354 | Clarence Brown B000909 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
28355 | 28355 | Clarence Brown B000909 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
28356 | 28356 | Clarence Brown B000909 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
28357 | 28357 | Clair Callan C000054 | rep | NE | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28358 | 28358 | Howard Callaway C000055 | rep | GA | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
28359 | 28359 | Ronald Cameron C000067 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 25 | |||||||||||||
28360 | 28360 | Ronald Cameron C000067 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 25 | |||||||||||||
28361 | 28361 | Frank Chelf C000342 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
28362 | 28362 | Frank Chelf C000342 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 4 |
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);