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 district
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, 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 | |||||||||||||
33455 | 33455 | James Sanford S000055 | sen | NC | 1986-11-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
33779 | 33779 | Fofó Sunia S001077 | rep | AS | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
33849 | 33849 | Richard Cheney C000344 | rep | WY | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
33896 | 33896 | Walter Fauntroy F000046 | rep | DC | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
34255 | 34255 | Ben Blaz B000551 | rep | GU | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
34466 | 34466 | Jaime Fuster F000435 | rep | PR | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
35674 | 35674 | Ron de Lugo D000209 | rep | VI | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
36584 | 36584 | Thomas Daschle D000064 | rep | SD | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
36981 | 36981 | James Jeffords J000072 | rep | VT | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
37614 | 37614 | Byron Dorgan D000432 | rep | ND | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
41670 | 41670 | Don Young Y000033 | rep | AK | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
41759 | 41759 | Thomas Carper C000174 | rep | DE | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
33250 | 33250 | William Carney C000165 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
33322 | 33322 | James Jones J000232 | rep | OK | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33359 | 33359 | John McKernan M000512 | rep | ME | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33665 | 33665 | Manuel Luján L000506 | rep | NM | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33760 | 33760 | Fernand St. Germain S000762 | rep | RI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33832 | 33832 | Douglas Bosco B000648 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33886 | 33886 | Royden Dyson D000593 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33911 | 33911 | James Florio F000215 | rep | NJ | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33991 | 33991 | Thomas Luken L000508 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34170 | 34170 | William Alexander A000103 | rep | AR | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34216 | 34216 | Les AuCoin A000337 | rep | OR | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34338 | 34338 | Silvio Conte C000709 | rep | MA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
34539 | 34539 | Charles Hayes H000388 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34583 | 34583 | Carroll Hubbard H000878 | rep | KY | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34630 | 34630 | Walter Jones J000256 | rep | NC | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34764 | 34764 | John Miller M000736 | rep | WA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
34999 | 34999 | Robert Thomas T000184 | rep | GA | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
35115 | 35115 | Leslie Aspin A000224 | rep | WI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
35340 | 35340 | Earl Hutto H001018 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
35503 | 35503 | Timothy Penny P000215 | rep | MN | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
35664 | 35664 | Jamie Whitten W000428 | rep | MS | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
35732 | 35732 | Jim Chapman C000312 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
35986 | 35986 | James Quillen Q000013 | rep | TN | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
36030 | 36030 | Patricia Schroeder S000142 | rep | CO | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
36092 | 36092 | John Williams W000520 | rep | MT | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
36181 | 36181 | Thomas Foglietta F000235 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
36274 | 36274 | Barbara Kennelly K000118 | rep | CT | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
36372 | 36372 | Robert Smith S000606 | rep | NH | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
36493 | 36493 | Herbert Bateman B000229 | rep | VA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
36565 | 36565 | William Clay C000488 | rep | MO | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
36678 | 36678 | Robert Livingston L000371 | rep | LA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
36845 | 36845 | H. Callahan C000052 | rep | AL | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
36950 | 36950 | James Hansen H000172 | rep | UT | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
37244 | 37244 | Douglas Bereuter B000403 | rep | NE | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
37276 | 37276 | Larry Craig C000858 | rep | ID | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
37761 | 37761 | James Leach L000169 | rep | IA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
38394 | 38394 | Neil Abercrombie A000014 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
38671 | 38671 | Alan Mollohan M000844 | rep | WV | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
40235 | 40235 | Harry Reid R000146 | rep | NV | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
40565 | 40565 | John Conyers C000714 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
40647 | 40647 | John McCain M000303 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
41268 | 41268 | Pat Roberts R000307 | rep | KS | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
41512 | 41512 | Peter Visclosky V000108 | rep | IN | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33253 | 33253 | Eugene Chappie C000322 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
33368 | 33368 | David Monson M000860 | rep | UT | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33442 | 33442 | George Whitehurst W000406 | rep | VA | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33452 | 33452 | Robert Young Y000051 | rep | MO | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33510 | 33510 | Edward Boland B000600 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33555 | 33555 | Harold Daub D000065 | rep | NE | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33576 | 33576 | John Duncan D000534 | rep | TN | 1985-01-03 | 1987-01-03 | Republican | 2 |
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);