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 rowid descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43631 | 43631 | Ron Wyden W000779 | rep | OR | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
43412 | 43412 | Christopher Smith S000522 | rep | NJ | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
43348 | 43348 | Richard Shelby S000320 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
43287 | 43287 | Charles Schumer S000148 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
43151 | 43151 | Harold Rogers R000395 | rep | KY | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
42819 | 42819 | Edward Markey M000133 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
42612 | 42612 | Marcy Kaptur K000009 | rep | OH | 1983-01-03 | 1985-01-03 | Democrat | 9 | |||||||||||||
42533 | 42533 | Steny Hoyer H000874 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
42198 | 42198 | Jim Cooper C000754 | rep | TN | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
41836 | 41836 | Richard Durbin D000563 | rep | IL | 1983-01-03 | 1985-01-03 | Democrat | 20 | |||||||||||||
41758 | 41758 | Thomas Carper C000174 | rep | DE | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
41669 | 41669 | Don Young Y000033 | rep | AK | 1983-01-03 | 1985-01-03 | Republican | 0 | |||||||||||||
41447 | 41447 | F. Sensenbrenner S000244 | rep | WI | 1983-01-03 | 1985-01-03 | Republican | 9 | |||||||||||||
41267 | 41267 | Pat Roberts R000307 | rep | KS | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
40905 | 40905 | Sander Levin L000263 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 17 | |||||||||||||
40683 | 40683 | Bill Nelson N000032 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
40646 | 40646 | John McCain M000303 | rep | AZ | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
40621 | 40621 | Thad Cochran C000567 | sen | MS | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
40564 | 40564 | John Conyers C000714 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
40444 | 40444 | Charles Rangel R000053 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 16 | |||||||||||||
40234 | 40234 | Harry Reid R000146 | rep | NV | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
40227 | 40227 | Barbara Mikulski M000702 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
40211 | 40211 | Daniel Coats C000542 | rep | IN | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
40201 | 40201 | Barbara Boxer B000711 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
40100 | 40100 | Frank Wolf W000672 | rep | VA | 1983-01-03 | 1985-01-03 | Republican | 10 | |||||||||||||
40083 | 40083 | Henry Waxman W000215 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 24 | |||||||||||||
40030 | 40030 | Nick Rahall R000011 | rep | WV | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
40011 | 40011 | Thomas Petri P000265 | rep | WI | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
39966 | 39966 | George Miller M000725 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
39857 | 39857 | Ralph Hall H000067 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
39813 | 39813 | John Dingell D000355 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 16 | |||||||||||||
39715 | 39715 | Carl Levin L000261 | sen | MI | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
39698 | 39698 | Thomas Harkin H000206 | rep | IA | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
39660 | 39660 | Max Baucus B000243 | sen | MT | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
39628 | 39628 | C. Young Y000031 | rep | FL | 1983-01-03 | 1985-01-03 | Republican | 8 | |||||||||||||
39554 | 39554 | Edolphus Towns T000326 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
39518 | 39518 | Fortney Stark S000810 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 9 | |||||||||||||
39451 | 39451 | Ronald Paul P000583 | rep | TX | 1983-01-03 | 1985-01-03 | Republican | 22 | |||||||||||||
39402 | 39402 | Daniel Lungren L000517 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 42 | |||||||||||||
39385 | 39385 | Jerry Lewis L000274 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 35 | |||||||||||||
39348 | 39348 | Dale Kildee K000172 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
39270 | 39270 | Barney Frank F000339 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
39254 | 39254 | David Dreier D000492 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 33 | |||||||||||||
39238 | 39238 | Norman Dicks D000327 | rep | WA | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
39193 | 39193 | Dan Burton B001149 | rep | IN | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
39143 | 39143 | Howard Berman B000410 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 26 | |||||||||||||
39084 | 39084 | Gary Ackerman A000022 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
39073 | 39073 | Olympia Snowe S000663 | rep | ME | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
39033 | 39033 | Daniel Akaka A000069 | rep | HI | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
38847 | 38847 | John Spratt S000749 | rep | SC | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
38811 | 38811 | Ike Skelton S000465 | rep | MO | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
38751 | 38751 | Solomon Ortiz O000107 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 27 | |||||||||||||
38737 | 38737 | David Obey O000007 | rep | WI | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
38716 | 38716 | James Oberstar O000006 | rep | MN | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
38697 | 38697 | John Murtha M001120 | rep | PA | 1983-01-03 | 1985-01-03 | Democrat | 12 | |||||||||||||
38670 | 38670 | Alan Mollohan M000844 | rep | WV | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
38436 | 38436 | Frederick Boucher B000657 | rep | VA | 1983-01-03 | 1985-01-03 | Democrat | 9 | |||||||||||||
38429 | 38429 | Joseph Biden B000444 | sen | DE | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
38320 | 38320 | H. Saxton S000097 | rep | NJ | 1984-11-06 | 1985-01-03 | Republican | 13 | |||||||||||||
38298 | 38298 | Ralph Regula R000141 | rep | OH | 1983-01-03 | 1985-01-03 | Republican | 16 | |||||||||||||
38207 | 38207 | Trent Lott L000447 | rep | MS | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
38181 | 38181 | Tom Lantos L000090 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
38116 | 38116 | Duncan Hunter H000981 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 45 | |||||||||||||
37908 | 37908 | William Thomas T000188 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 20 | |||||||||||||
37863 | 37863 | E. Shaw S000303 | rep | FL | 1983-01-03 | 1985-01-03 | Republican | 15 | |||||||||||||
37848 | 37848 | Martin Sabo S000005 | rep | MN | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
37821 | 37821 | Michael Oxley O000163 | rep | OH | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
37808 | 37808 | Major Owens O000159 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 12 | |||||||||||||
37760 | 37760 | James Leach L000169 | rep | IA | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
37725 | 37725 | Nancy Johnson J000163 | rep | CT | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
37701 | 37701 | Henry Hyde H001022 | rep | IL | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
37658 | 37658 | Judd Gregg G000445 | rep | NH | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
37622 | 37622 | Lane Evans E000250 | rep | IL | 1983-01-03 | 1985-01-03 | Democrat | 17 | |||||||||||||
37613 | 37613 | Byron Dorgan D000432 | rep | ND | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
37532 | 37532 | Sherwood Boehlert B000586 | rep | NY | 1983-01-03 | 1985-01-03 | Republican | 25 | |||||||||||||
37520 | 37520 | Michael Bilirakis B000463 | rep | FL | 1983-01-03 | 1985-01-03 | Republican | 9 | |||||||||||||
37508 | 37508 | John Warner W000154 | sen | VA | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
37493 | 37493 | William Tauzin T000058 | rep | LA | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
37482 | 37482 | Ted Stevens S000888 | sen | AK | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
37469 | 37469 | Charles Stenholm S000851 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 17 | |||||||||||||
37417 | 37417 | Robert Matsui M000249 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
37400 | 37400 | William Lipinski L000342 | rep | IL | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
37389 | 37389 | Gerald Kleczka K000259 | rep | WI | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
37345 | 37345 | Richard Gephardt G000132 | rep | MO | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
37331 | 37331 | Jonas Frost F000392 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 24 | |||||||||||||
37308 | 37308 | Pete Domenici D000407 | sen | NM | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
37289 | 37289 | Philip Crane C000873 | rep | IL | 1983-01-03 | 1985-01-03 | Republican | 12 | |||||||||||||
37275 | 37275 | Larry Craig C000858 | rep | ID | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
37243 | 37243 | Douglas Bereuter B000403 | rep | NE | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
37205 | 37205 | Wes Watkins W000194 | rep | OK | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
37173 | 37173 | Robert Stump S001044 | rep | AZ | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
37160 | 37160 | Floyd Spence S000718 | rep | SC | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
37144 | 37144 | Joseph Skeen S000463 | rep | NM | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
37133 | 37133 | Norman Sisisky S000453 | rep | VA | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
37123 | 37123 | Elmer Shuster S000394 | rep | PA | 1983-01-03 | 1985-01-03 | Republican | 9 | |||||||||||||
37079 | 37079 | Marge Roukema R000465 | rep | NJ | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
37045 | 37045 | John Moakley M000834 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 9 | |||||||||||||
36991 | 36991 | John LaFalce L000556 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 32 | |||||||||||||
36980 | 36980 | James Jeffords J000072 | rep | VT | 1983-01-03 | 1985-01-03 | Republican | 0 | |||||||||||||
36949 | 36949 | James Hansen H000172 | rep | UT | 1983-01-03 | 1985-01-03 | Republican | 1 |
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);