legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
204 rows where "end" is on date 1987-01-03 and party = "Republican"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 | |||||||||||||
32682 | 32682 | Barry Goldwater G000267 | sen | AZ | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
33282 | 33282 | John Grotberg G000499 | rep | IL | 1985-01-03 | 1987-01-03 | Republican | 14 | |||||||||||||
33291 | 33291 | Thomas Hartnett H000302 | rep | SC | 1985-01-03 | 1987-01-03 | Republican | 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 | |||||||||||||
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 | |||||||||||||
33359 | 33359 | John McKernan M000512 | rep | ME | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
33403 | 33403 | Eldon Rudd R000495 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
33442 | 33442 | George Whitehurst W000406 | rep | VA | 1985-01-03 | 1987-01-03 | Republican | 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 | |||||||||||||
33524 | 33524 | Eldon Boulter B000666 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 13 | |||||||||||||
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 | |||||||||||||
33576 | 33576 | John Duncan D000534 | rep | TN | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
33665 | 33665 | Manuel Luján L000506 | rep | NM | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33677 | 33677 | Stewart McKinney M000527 | rep | CT | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
33781 | 33781 | David Sweeney S001101 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 14 | |||||||||||||
33783 | 33783 | Patrick Swindall S001122 | rep | GA | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33789 | 33789 | Steven Symms S001138 | sen | ID | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
33797 | 33797 | Gene Taylor T000075 | rep | MO | 1985-01-03 | 1987-01-03 | Republican | 7 | |||||||||||||
33808 | 33808 | George Wortley W000752 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 27 | |||||||||||||
33849 | 33849 | Richard Cheney C000344 | rep | WY | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
33864 | 33864 | James Courter C000809 | rep | NJ | 1985-01-03 | 1987-01-03 | Republican | 12 | |||||||||||||
33921 | 33921 | William Frenzel F000380 | rep | MN | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
33955 | 33955 | John Hiler H000586 | rep | IN | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
34000 | 34000 | Lynn Martin M000195 | rep | IL | 1985-01-03 | 1987-01-03 | Republican | 16 | |||||||||||||
34023 | 34023 | Guy Molinari M000842 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 14 | |||||||||||||
34031 | 34031 | Howard Nielson N000106 | rep | UT | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
34037 | 34037 | Stanford Parris P000080 | rep | VA | 1985-01-03 | 1987-01-03 | Republican | 8 | |||||||||||||
34043 | 34043 | Charles Pashayan P000097 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 17 | |||||||||||||
34074 | 34074 | John Rowland R000482 | rep | CT | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
34084 | 34084 | Claudine Schneider S000136 | rep | RI | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
34087 | 34087 | Bill Schuette S000143 | rep | MI | 1985-01-03 | 1987-01-03 | Republican | 10 | |||||||||||||
34093 | 34093 | Norman Shumway S000393 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 14 | |||||||||||||
34098 | 34098 | Dennis Smith S000527 | rep | OR | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
34108 | 34108 | Virginia Smith S000622 | rep | NE | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
34115 | 34115 | Arlan Stangeland S000795 | rep | MN | 1985-01-03 | 1987-01-03 | Republican | 7 | |||||||||||||
34121 | 34121 | Thomas Tauke T000053 | rep | IA | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
34137 | 34137 | Robert Whittaker W000426 | rep | KS | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
34229 | 34229 | Harry Bartlett B000204 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
34255 | 34255 | Ben Blaz B000551 | rep | GU | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
34279 | 34279 | William Broomfield B000890 | rep | MI | 1985-01-03 | 1987-01-03 | Republican | 18 | |||||||||||||
34285 | 34285 | George Brown B000919 | rep | CO | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
34305 | 34305 | Rodney Chandler C000293 | rep | WA | 1985-01-03 | 1987-01-03 | Republican | 8 | |||||||||||||
34320 | 34320 | Earl Coleman C000618 | rep | MO | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
34338 | 34338 | Silvio Conte C000709 | rep | MA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
34350 | 34350 | Robert Coughlin C000807 | rep | PA | 1985-01-03 | 1987-01-03 | Republican | 13 | |||||||||||||
34358 | 34358 | William Dannemeyer D000044 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 39 | |||||||||||||
34365 | 34365 | Robert Davis D000131 | rep | MI | 1985-01-03 | 1987-01-03 | Republican | 11 | |||||||||||||
34379 | 34379 | William Dickinson D000326 | rep | AL | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
34430 | 34430 | Marvin Edwards E000077 | rep | OK | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
34500 | 34500 | Sedgwick Green G000417 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 15 | |||||||||||||
34520 | 34520 | John Hammerschmidt H000124 | rep | AR | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
34558 | 34558 | Larry Hopkins H000776 | rep | KY | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
34574 | 34574 | Frank Horton H000797 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 29 | |||||||||||||
34599 | 34599 | Andrew Ireland I000029 | rep | FL | 1985-01-03 | 1987-01-03 | Republican | 10 | |||||||||||||
34659 | 34659 | Robert Lagomarsino L000020 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 19 | |||||||||||||
34680 | 34680 | Norman Lent L000243 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
34691 | 34691 | William Lowery L000479 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 41 | |||||||||||||
34702 | 34702 | Edward Madigan M000041 | rep | IL | 1985-01-03 | 1987-01-03 | Republican | 15 | |||||||||||||
34710 | 34710 | Ronald Marlenee M000139 | rep | MT | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
34716 | 34716 | David Martin M000174 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 26 | |||||||||||||
34729 | 34729 | Bob McEwen M000432 | rep | OH | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
34735 | 34735 | Raymond McGrath M000458 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
34760 | 34760 | Clarence Miller M000718 | rep | OH | 1985-01-03 | 1987-01-03 | Republican | 10 | |||||||||||||
34764 | 34764 | John Miller M000736 | rep | WA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
34775 | 34775 | Sidney Morrison M000999 | rep | WA | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
34857 | 34857 | Carl Pursell P000574 | rep | MI | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
34875 | 34875 | Matthew Rinaldo R000262 | rep | NJ | 1985-01-03 | 1987-01-03 | Republican | 7 |
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);