legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
477 rows where "end" is on date 1985-01-03 sorted by caucus
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31945 | 31945 | Howard Baker B000063 | sen | TN | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32115 | 32115 | Walter Huddleston H000905 | sen | KY | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
32130 | 32130 | Roger Jepsen J000101 | sen | IA | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32234 | 32234 | Charles Percy P000222 | sen | IL | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32252 | 32252 | Jennings Randolph R000046 | sen | WV | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
32347 | 32347 | John Tower T000322 | sen | TX | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32354 | 32354 | Paul Tsongas T000393 | sen | MA | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
32897 | 32897 | Donald Albosta A000076 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
32903 | 32903 | Ike Andrews A000207 | rep | NC | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
32906 | 32906 | Edwin Bethune B000422 | rep | AR | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
32907 | 32907 | Charles Britt B000845 | rep | NC | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
32931 | 32931 | Barber Conable C000666 | rep | NY | 1983-01-03 | 1985-01-03 | Republican | 30 | |||||||||||||
32935 | 32935 | Thomas Corcoran C000773 | rep | IL | 1983-01-03 | 1985-01-03 | Republican | 14 | |||||||||||||
32939 | 32939 | Baltasar Corrada-del Río C000788 | rep | PR | 1983-01-03 | 1985-01-03 | New Progressive | 0 | |||||||||||||
32942 | 32942 | Daniel Crane C000871 | rep | IL | 1983-01-03 | 1985-01-03 | Republican | 19 | |||||||||||||
32947 | 32947 | Norman D’Amours D000017 | rep | NH | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
32957 | 32957 | William Edwards E000084 | rep | AL | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
32967 | 32967 | John Erlenborn E000204 | rep | IL | 1983-01-03 | 1985-01-03 | Republican | 13 | |||||||||||||
32971 | 32971 | Geraldine Ferraro F000088 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 9 | |||||||||||||
32981 | 32981 | Katie Hall H000058 | rep | IN | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
32984 | 32984 | Kent Hance H000144 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 19 | |||||||||||||
32991 | 32991 | George Hansen H000171 | rep | ID | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
32992 | 32992 | Frank Harrison H000269 | rep | PA | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
32998 | 32998 | Jack Hightower H000582 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 13 | |||||||||||||
33019 | 33019 | Abraham Kazen K000025 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 23 | |||||||||||||
33022 | 33022 | Raymond Kogovsek K000304 | rep | CO | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33027 | 33027 | Elliott Levitas L000265 | rep | GA | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33038 | 33038 | Clarence Long L000413 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33042 | 33042 | David Marriott M000143 | rep | UT | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
33048 | 33048 | James Martin M000183 | rep | NC | 1983-01-03 | 1985-01-03 | Republican | 9 | |||||||||||||
33053 | 33053 | Lawrence McDonald M000413 | rep | GA | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33054 | 33054 | James McNulty M000589 | rep | AZ | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33071 | 33071 | Joseph Minish M000796 | rep | NJ | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
33079 | 33079 | Richard Ottinger O000134 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 20 | |||||||||||||
33081 | 33081 | William Patman P000104 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 14 | |||||||||||||
33086 | 33086 | Jerry Patterson P000121 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 38 | |||||||||||||
33104 | 33104 | Carl Perkins P000230 | rep | KY | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33110 | 33110 | Joel Pritchard P000546 | rep | WA | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
33119 | 33119 | William Ratchford R000067 | rep | CT | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33126 | 33126 | James Robinson R000337 | rep | VA | 1983-01-03 | 1985-01-03 | Republican | 7 | |||||||||||||
33138 | 33138 | Benjamin Rosenthal R000442 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33142 | 33142 | Harold Sawyer S000087 | rep | MI | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
33145 | 33145 | James Shannon S000286 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33166 | 33166 | Tommy Vandergriff V000026 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 26 | |||||||||||||
33168 | 33168 | Harold Washington W000180 | rep | IL | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33175 | 33175 | Lyle Williams W000528 | rep | OH | 1983-01-03 | 1985-01-03 | Republican | 17 | |||||||||||||
33184 | 33184 | Edward Winn W000636 | rep | KS | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
33190 | 33190 | Antonio Won Pat W000686 | rep | GU | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
33223 | 33223 | Joseph Addabbo A000052 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
33228 | 33228 | William Armstrong A000219 | sen | CO | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
33232 | 33232 | Michael Barnes B000160 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
33238 | 33238 | Berkley Bedell B000298 | rep | IA | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
33241 | 33241 | Rudolph Boschwitz B000647 | sen | MN | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
33245 | 33245 | Carroll Campbell C000079 | rep | SC | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
33249 | 33249 | William Carney C000165 | rep | NY | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
33252 | 33252 | Eugene Chappie C000322 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
33260 | 33260 | Robert Edgar E000043 | rep | PA | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33263 | 33263 | Thomas Evans E000259 | rep | IA | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
33266 | 33266 | Bobbi Fiedler F000102 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 21 | |||||||||||||
33268 | 33268 | William Franklin F000347 | rep | MS | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
33280 | 33280 | Don Fuqua F000430 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33287 | 33287 | Sam Hall H000070 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33290 | 33290 | Thomas Hartnett H000302 | rep | SC | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
33295 | 33295 | Cecil Heftel H000449 | rep | HI | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33305 | 33305 | Elwood Hillis H000624 | rep | IN | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
33312 | 33312 | Marjorie Holt H000747 | rep | MD | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
33314 | 33314 | Gordon Humphrey H000951 | sen | NH | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
33321 | 33321 | James Jones J000232 | rep | OK | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33327 | 33327 | Thomas Kindness K000190 | rep | OH | 1983-01-03 | 1985-01-03 | Republican | 8 | |||||||||||||
33331 | 33331 | Kenneth Kramer K000322 | rep | CO | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
33335 | 33335 | Thomas Loeffler L000396 | rep | TX | 1983-01-03 | 1985-01-03 | Republican | 21 | |||||||||||||
33344 | 33344 | Gillis Long L000417 | rep | LA | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
33350 | 33350 | Stanley Lundine L000516 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 34 | |||||||||||||
33356 | 33356 | James McClure M000346 | sen | ID | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
33358 | 33358 | John McKernan M000512 | rep | ME | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
33366 | 33366 | Parren Mitchell M000826 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33373 | 33373 | William Moore M000923 | rep | LA | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
33380 | 33380 | George O’Brien O000010 | rep | IL | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
33397 | 33397 | Thomas O’Neill O000098 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
33402 | 33402 | Eldon Rudd R000495 | rep | AZ | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
33410 | 33410 | John Seiberling S000230 | rep | OH | 1983-01-03 | 1985-01-03 | Democrat | 14 | |||||||||||||
33413 | 33413 | Mark Siljander S000409 | rep | MI | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
33424 | 33424 | Marion Snyder S000669 | rep | KY | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
33432 | 33432 | James Weaver W000227 | rep | OR | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33441 | 33441 | George Whitehurst W000406 | rep | VA | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
33446 | 33446 | Charles Whitley W000419 | rep | NC | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33451 | 33451 | Robert Young Y000051 | rep | MO | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33453 | 33453 | Edwin Zschau Z000014 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 12 | |||||||||||||
33467 | 33467 | James Broyhill B000966 | rep | NC | 1983-01-03 | 1985-01-03 | Republican | 10 | |||||||||||||
33481 | 33481 | Robert Badham B000024 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 40 | |||||||||||||
33491 | 33491 | Mario Biaggi B000432 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 19 | |||||||||||||
33509 | 33509 | Edward Boland B000600 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33514 | 33514 | William Boner B000615 | rep | TN | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33521 | 33521 | Don Bonker B000620 | rep | WA | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33526 | 33526 | Sala Burton B001158 | rep | CA | 1983-06-21 | 1985-01-03 | Democrat | 5 | |||||||||||||
33536 | 33536 | William Chappell C000321 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33550 | 33550 | Wilbur Daniel D000038 | rep | VA | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33554 | 33554 | Harold Daub D000065 | rep | NE | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
33563 | 33563 | Charles Dowdy D000466 | rep | MS | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33575 | 33575 | John Duncan D000534 | rep | TN | 1983-01-03 | 1985-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);