legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "end" is on date 1983-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36213 | 36213 | Henry González G000272 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 20 | |||||||||||||
36194 | 36194 | Newton Gingrich G000225 | rep | GA | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
36179 | 36179 | Thomas Foglietta F000235 | rep | PA | 1981-01-05 | 1983-01-03 | Independent | 1 | |||||||||||||
36164 | 36164 | Victor Fazio F000053 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
36147 | 36147 | Ronald Dellums D000222 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 8 | |||||||||||||
36124 | 36124 | Eligio de la Garza D000203 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 15 | |||||||||||||
36102 | 36102 | Charles Wilson W000570 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
36090 | 36090 | John Williams W000520 | rep | MT | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
36080 | 36080 | Robert Walker W000068 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 16 | |||||||||||||
36062 | 36062 | Harold Volkmer V000112 | rep | MO | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
36041 | 36041 | Gerry Studds S001040 | rep | MA | 1981-01-05 | 1983-01-03 | Democrat | 12 | |||||||||||||
36028 | 36028 | Patricia Schroeder S000142 | rep | CO | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
36020 | 36020 | William Roth R000460 | sen | DE | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
36009 | 36009 | Toby Roth R000459 | rep | WI | 1981-01-05 | 1983-01-03 | Republican | 8 | |||||||||||||
36000 | 36000 | Charles Rose R000436 | rep | NC | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
35984 | 35984 | James Quillen Q000013 | rep | TN | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
35956 | 35956 | John Myers M001130 | rep | IN | 1981-01-05 | 1983-01-03 | Republican | 7 | |||||||||||||
35945 | 35945 | Daniel Moynihan M001054 | sen | NY | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
35937 | 35937 | Carlos Moorhead M000926 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 22 | |||||||||||||
35925 | 35925 | Gillespie Montgomery M000865 | rep | MS | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
35910 | 35910 | Norman Mineta M000794 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 13 | |||||||||||||
35870 | 35870 | Andrew Jacobs J000033 | rep | IN | 1981-01-05 | 1983-01-03 | Democrat | 11 | |||||||||||||
35843 | 35843 | Steven Gunderson G000524 | rep | WI | 1981-01-05 | 1983-01-03 | Republican | 3 | |||||||||||||
35830 | 35830 | Sam Gibbons G000153 | rep | FL | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
35803 | 35803 | Harold Ford F000261 | rep | TN | 1981-01-05 | 1983-01-03 | Democrat | 8 | |||||||||||||
35791 | 35791 | Jack Fields F000111 | rep | TX | 1981-01-05 | 1983-01-03 | Republican | 8 | |||||||||||||
35781 | 35781 | Norvell Emerson E000174 | rep | MO | 1981-01-05 | 1983-01-03 | Republican | 10 | |||||||||||||
35774 | 35774 | Robert Dornan D000435 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 27 | |||||||||||||
35762 | 35762 | Cardiss Collins C000634 | rep | IL | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
35740 | 35740 | William Clinger C000523 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 23 | |||||||||||||
35728 | 35728 | John Chafee C000269 | sen | RI | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
35700 | 35700 | Tom Bevill B000431 | rep | AL | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
35685 | 35685 | Anthony Beilenson B000318 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 23 | |||||||||||||
35672 | 35672 | Ron de Lugo D000209 | rep | VI | 1981-01-05 | 1983-01-03 | Democrat | 0 | |||||||||||||
35662 | 35662 | Jamie Whitten W000428 | rep | MS | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
35617 | 35617 | Michael Synar S001139 | rep | OK | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
35609 | 35609 | Allan Swift S001115 | rep | WA | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
35593 | 35593 | Neal Smith S000596 | rep | IA | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
35568 | 35568 | Philip Sharp S000294 | rep | IN | 1981-01-05 | 1983-01-03 | Democrat | 10 | |||||||||||||
35545 | 35545 | Daniel Rostenkowski R000458 | rep | IL | 1981-01-05 | 1983-01-03 | Democrat | 8 | |||||||||||||
35517 | 35517 | James Pickle P000328 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 10 | |||||||||||||
35495 | 35495 | Leon Panetta P000047 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 16 | |||||||||||||
35481 | 35481 | Stephen Neal N000016 | rep | NC | 1981-01-05 | 1983-01-03 | Democrat | 5 | |||||||||||||
35471 | 35471 | William Natcher N000009 | rep | KY | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
35450 | 35450 | Austin Murphy M001088 | rep | PA | 1981-01-05 | 1983-01-03 | Democrat | 22 | |||||||||||||
35440 | 35440 | Robert Michel M000692 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 18 | |||||||||||||
35416 | 35416 | David McCurdy M000398 | rep | OK | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
35397 | 35397 | Romano Mazzoli M000291 | rep | KY | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
35376 | 35376 | Marilyn Lloyd L000381 | rep | TN | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
35338 | 35338 | Earl Hutto H001018 | rep | FL | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
35330 | 35330 | William Hughes H000930 | rep | NJ | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
35302 | 35302 | Willis Gradison G000349 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
35292 | 35292 | Daniel Glickman G000240 | rep | KS | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
35273 | 35273 | William Ford F000270 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 15 | |||||||||||||
35253 | 35253 | Thomas Foley F000239 | rep | WA | 1981-01-05 | 1983-01-03 | Democrat | 5 | |||||||||||||
35238 | 35238 | Hamilton Fish F000141 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 25 | |||||||||||||
35218 | 35218 | Glenn English E000184 | rep | OK | 1981-01-05 | 1983-01-03 | Democrat | 6 | |||||||||||||
35208 | 35208 | William Edwards E000064 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 10 | |||||||||||||
35183 | 35183 | Butler Derrick D000267 | rep | SC | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
35149 | 35149 | Jack Brooks B000880 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
35113 | 35113 | Leslie Aspin A000224 | rep | WI | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
35101 | 35101 | Douglas Applegate A000214 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 18 | |||||||||||||
35084 | 35084 | Gus Yatron Y000014 | rep | PA | 1981-01-05 | 1983-01-03 | Democrat | 6 | |||||||||||||
35072 | 35072 | Chalmers Wylie W000781 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 15 | |||||||||||||
35059 | 35059 | Howard Wolpe W000682 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
35051 | 35051 | Theodore Weiss W000258 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 20 | |||||||||||||
35043 | 35043 | John Weber W000237 | rep | MN | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
35037 | 35037 | Guy Vander Jagt V000027 | rep | MI | 1981-01-05 | 1983-01-03 | Republican | 9 | |||||||||||||
35023 | 35023 | Morris Udall U000001 | rep | AZ | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
35007 | 35007 | Jerome Traxler T000356 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 8 | |||||||||||||
34978 | 34978 | Stephen Solarz S000673 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 13 | |||||||||||||
34959 | 34959 | Paul Simon S000423 | rep | IL | 1981-01-05 | 1983-01-03 | Democrat | 24 | |||||||||||||
34944 | 34944 | Richard Schulze S000146 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 5 | |||||||||||||
34935 | 34935 | James Scheuer S000124 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 11 | |||||||||||||
34922 | 34922 | Gus Savage S000081 | rep | IL | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
34916 | 34916 | Martin Russo R000543 | rep | IL | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
34907 | 34907 | Edward Roybal R000485 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 25 | |||||||||||||
34892 | 34892 | Robert Roe R000383 | rep | NJ | 1981-01-05 | 1983-01-03 | Democrat | 8 | |||||||||||||
34880 | 34880 | Donald Ritter R000277 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 15 | |||||||||||||
34873 | 34873 | Matthew Rinaldo R000262 | rep | NJ | 1981-01-05 | 1983-01-03 | Republican | 12 | |||||||||||||
34855 | 34855 | Carl Pursell P000574 | rep | MI | 1981-01-05 | 1983-01-03 | Republican | 2 | |||||||||||||
34824 | 34824 | Donald Pease P000170 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 13 | |||||||||||||
34804 | 34804 | Mary Oakar O000001 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 20 | |||||||||||||
34791 | 34791 | Henry Nowak N000163 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 37 | |||||||||||||
34773 | 34773 | Sidney Morrison M000999 | rep | WA | 1981-01-05 | 1983-01-03 | Republican | 4 | |||||||||||||
34758 | 34758 | Clarence Miller M000718 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 10 | |||||||||||||
34742 | 34742 | Matthew McHugh M000473 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 27 | |||||||||||||
34733 | 34733 | Raymond McGrath M000458 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 5 | |||||||||||||
34727 | 34727 | Bob McEwen M000432 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
34721 | 34721 | Nicholas Mavroules M000264 | rep | MA | 1981-01-05 | 1983-01-03 | Democrat | 6 | |||||||||||||
34714 | 34714 | David Martin M000174 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 30 | |||||||||||||
34708 | 34708 | Ronald Marlenee M000139 | rep | MT | 1981-01-05 | 1983-01-03 | Republican | 2 | |||||||||||||
34700 | 34700 | Edward Madigan M000041 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 21 | |||||||||||||
34689 | 34689 | William Lowery L000479 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 41 | |||||||||||||
34678 | 34678 | Norman Lent L000243 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 4 | |||||||||||||
34667 | 34667 | William Lehman L000226 | rep | FL | 1981-01-05 | 1983-01-03 | Democrat | 13 | |||||||||||||
34657 | 34657 | Robert Lagomarsino L000020 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 19 | |||||||||||||
34628 | 34628 | Walter Jones J000256 | rep | NC | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
34607 | 34607 | Edgar Jenkins J000083 | rep | GA | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
34597 | 34597 | Andrew Ireland I000029 | rep | FL | 1981-01-05 | 1983-01-03 | Democrat | 8 |
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);