legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "end" is on date 1987-01-03 sorted by start
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32434 | 32434 | James Abdnor A000009 | sen | SD | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
32444 | 32444 | Mark Andrews A000208 | sen | ND | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
32595 | 32595 | Jeremiah Denton D000259 | sen | AL | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
32614 | 32614 | Thomas Eagleton E000004 | sen | MO | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
32682 | 32682 | Barry Goldwater G000267 | sen | AZ | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
32702 | 32702 | Gary Hart H000287 | sen | CO | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
32703 | 32703 | Paula Hawkins H000374 | sen | FL | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
32726 | 32726 | Paul Laxalt L000148 | sen | NV | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
32739 | 32739 | Russell Long L000428 | sen | LA | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
32749 | 32749 | Charles Mathias M000241 | sen | MD | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
32750 | 32750 | Mack Mattingly M000257 | sen | GA | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
33541 | 33541 | Alan Cranston C000877 | sen | CA | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
33560 | 33560 | Alan Dixon D000366 | sen | IL | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
33586 | 33586 | Edwin Garn G000072 | sen | UT | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
33625 | 33625 | Robert Kasten K000019 | sen | WI | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
33719 | 33719 | James Quayle Q000007 | sen | IN | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
33746 | 33746 | Warren Rudman R000497 | sen | NH | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
33789 | 33789 | Steven Symms S001138 | sen | ID | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
35157 | 35157 | Dale Bumpers B001057 | sen | AR | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
35171 | 35171 | Alfonse D’Amato D000018 | sen | NY | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
35196 | 35196 | Robert Dole D000401 | sen | KS | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
35262 | 35262 | Wendell Ford F000268 | sen | KY | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
35287 | 35287 | John Glenn G000236 | sen | OH | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
35490 | 35490 | Robert Packwood P000009 | sen | OR | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
35838 | 35838 | T. Gorton G000333 | sen | WA | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
36652 | 36652 | Ernest Hollings H000725 | sen | SC | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
36716 | 36716 | Frank Murkowski M001085 | sen | AK | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
36720 | 36720 | Don Nickles N000102 | sen | OK | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
37607 | 37607 | Christopher Dodd D000388 | sen | CT | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
37883 | 37883 | Arlen Specter S000709 | sen | PA | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
39024 | 39024 | Daniel Inouye I000025 | sen | HI | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
42437 | 42437 | Charles Grassley G000386 | sen | IA | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
42718 | 42718 | Patrick Leahy L000174 | sen | VT | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
33224 | 33224 | Joseph Addabbo A000052 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
33233 | 33233 | Michael Barnes B000160 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33239 | 33239 | Berkley Bedell B000298 | rep | IA | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
33246 | 33246 | Carroll Campbell C000079 | rep | SC | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33250 | 33250 | William Carney C000165 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33253 | 33253 | Eugene Chappie C000322 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33254 | 33254 | William Cobey C000555 | rep | NC | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33255 | 33255 | Fred Eckert E000033 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 30 | |||||||||||||
33261 | 33261 | Robert Edgar E000043 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
33264 | 33264 | Thomas Evans E000259 | rep | IA | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
33267 | 33267 | Bobbi Fiedler F000102 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 21 | |||||||||||||
33269 | 33269 | William Franklin F000347 | rep | MS | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33281 | 33281 | Don Fuqua F000430 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33282 | 33282 | John Grotberg G000499 | rep | IL | 1985-01-03 | 1987-01-03 | Republican | 14 | |||||||||||||
33288 | 33288 | Sam Hall H000070 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33291 | 33291 | Thomas Hartnett H000302 | rep | SC | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33296 | 33296 | Cecil Heftel H000449 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33298 | 33298 | William Hendon H000490 | rep | NC | 1985-01-03 | 1987-01-03 | Republican | 11 | |||||||||||||
33306 | 33306 | Elwood Hillis H000624 | rep | IN | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
33313 | 33313 | Marjorie Holt H000747 | rep | MD | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33322 | 33322 | James Jones J000232 | rep | OK | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33328 | 33328 | Thomas Kindness K000190 | rep | OH | 1985-01-03 | 1987-01-03 | Republican | 8 | |||||||||||||
33332 | 33332 | Kenneth Kramer K000322 | rep | CO | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
33336 | 33336 | Thomas Loeffler L000396 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 21 | |||||||||||||
33337 | 33337 | Catherine Long L000411 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33345 | 33345 | Gillis Long L000417 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33351 | 33351 | Stanley Lundine L000516 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 34 | |||||||||||||
33359 | 33359 | John McKernan M000512 | rep | ME | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33367 | 33367 | Parren Mitchell M000826 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
33368 | 33368 | David Monson M000860 | rep | UT | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33374 | 33374 | William Moore M000923 | rep | LA | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
33381 | 33381 | George O’Brien O000010 | rep | IL | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33398 | 33398 | Thomas O’Neill O000098 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33403 | 33403 | Eldon Rudd R000495 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33411 | 33411 | John Seiberling S000230 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 14 | |||||||||||||
33414 | 33414 | Mark Siljander S000409 | rep | MI | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33425 | 33425 | Marion Snyder S000669 | rep | KY | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33426 | 33426 | Michael Strang S000991 | rep | CO | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
33427 | 33427 | Alton Waldon W000038 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
33433 | 33433 | James Weaver W000227 | rep | OR | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
33442 | 33442 | George Whitehurst W000406 | rep | VA | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33447 | 33447 | Charles Whitley W000419 | rep | NC | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
33452 | 33452 | Robert Young Y000051 | rep | MO | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33454 | 33454 | Edwin Zschau Z000014 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 12 | |||||||||||||
33482 | 33482 | Robert Badham B000024 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 40 | |||||||||||||
33492 | 33492 | Mario Biaggi B000432 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 19 | |||||||||||||
33510 | 33510 | Edward Boland B000600 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33515 | 33515 | William Boner B000615 | rep | TN | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
33522 | 33522 | Don Bonker B000620 | rep | WA | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
33524 | 33524 | Eldon Boulter B000666 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 13 | |||||||||||||
33527 | 33527 | Sala Burton B001158 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
33537 | 33537 | William Chappell C000321 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
33551 | 33551 | Wilbur Daniel D000038 | rep | VA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
33555 | 33555 | Harold Daub D000065 | rep | NE | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33558 | 33558 | Joseph DioGuardi D000359 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 20 | |||||||||||||
33564 | 33564 | Charles Dowdy D000466 | rep | MS | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
33576 | 33576 | John Duncan D000534 | rep | TN | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33582 | 33582 | Wyche Fowler F000329 | rep | GA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
33598 | 33598 | Kenneth Gray G000400 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 22 | |||||||||||||
33610 | 33610 | James Howard H000840 | rep | NJ | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
33620 | 33620 | Ed Jones J000216 | rep | TN | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33634 | 33634 | Jack Kemp K000086 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 31 | |||||||||||||
33650 | 33650 | Delbert Latta L000116 | rep | OH | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
33655 | 33655 | Michael Lowry L000486 | rep | WA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
33665 | 33665 | Manuel Luján L000506 | rep | NM | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33668 | 33668 | Kenneth MacKay M000023 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
33677 | 33677 | Stewart McKinney M000527 | rep | CT | 1985-01-03 | 1987-01-03 | Republican | 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);