legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1975-01-14 sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31767 | 31767 | Teno Roncalio R000421 | rep | WY | 1975-01-14 | 1977-01-03 | Democrat | 0 | |||||||||||||
30997 | 30997 | Kenneth Hechler H000438 | rep | WV | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32291 | 32291 | John Slack S000473 | rep | WV | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32311 | 32311 | Harley Staggers S000778 | rep | WV | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32786 | 32786 | Robert Mollohan M000845 | rep | WV | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
31227 | 31227 | Gaylord Nelson N000033 | sen | WI | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31507 | 31507 | Robert Cornell C000782 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
31844 | 31844 | William Steiger S000847 | rep | WI | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
31946 | 31946 | Alvin Baldus B000083 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32819 | 32819 | Henry Reuss R000165 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
33204 | 33204 | Clement Zablocki Z000001 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33623 | 33623 | Robert Kasten K000019 | rep | WI | 1975-01-14 | 1977-01-03 | Republican | 9 | |||||||||||||
33966 | 33966 | Robert Kastenmeier K000020 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
35110 | 35110 | Leslie Aspin A000224 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
38733 | 38733 | David Obey O000007 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
31017 | 31017 | Floyd Hicks H000563 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
31170 | 31170 | Warren Magnuson M000053 | sen | WA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31664 | 31664 | Lloyd Meeds M000626 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32163 | 32163 | Mike McCormack M000365 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33106 | 33106 | Joel Pritchard P000546 | rep | WA | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
33475 | 33475 | Brockman Adams A000031 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33517 | 33517 | Don Bonker B000620 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
35250 | 35250 | Thomas Foley F000239 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
36976 | 36976 | James Jeffords J000072 | rep | VT | 1975-01-14 | 1977-01-03 | Republican | 0 | |||||||||||||
42717 | 42717 | Patrick Leahy L000174 | sen | VT | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
35670 | 35670 | Ron de Lugo D000209 | rep | VI | 1975-01-14 | 1977-01-03 | Democrat | 0 | |||||||||||||
30909 | 30909 | Thomas Downing D000474 | rep | VA | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
32057 | 32057 | Joseph Fisher F000151 | rep | VA | 1975-01-14 | 1977-01-03 | Democrat | 10 | |||||||||||||
32097 | 32097 | Herbert Harris H000241 | rep | VA | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
32274 | 32274 | David Satterfield S000070 | rep | VA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32544 | 32544 | Manley Butler B001182 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
32582 | 32582 | Robert Daniel D000037 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
32876 | 32876 | William Wampler W000121 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 9 | |||||||||||||
33122 | 33122 | James Robinson R000337 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 7 | |||||||||||||
33437 | 33437 | George Whitehurst W000406 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
33546 | 33546 | Wilbur Daniel D000038 | rep | VA | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
31020 | 31020 | Allan Howe H000851 | rep | UT | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
32176 | 32176 | Koln McKay M000490 | rep | UT | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
33585 | 33585 | Edwin Garn G000072 | sen | UT | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
30863 | 30863 | Robert Casey C000228 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
31275 | 31275 | John Patman P000103 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
31336 | 31336 | Alan Steelman S000841 | rep | TX | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
31467 | 31467 | Omar Burleson B001111 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 17 | |||||||||||||
31598 | 31598 | Barbara Jordan J000266 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 18 | |||||||||||||
31641 | 31641 | George Mahon M000065 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 19 | |||||||||||||
31673 | 31673 | Dale Milford M000708 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
31737 | 31737 | William Poage P000398 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
31861 | 31861 | Olin Teague T000110 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
31911 | 31911 | John Young Y000043 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 14 | |||||||||||||
32053 | 32053 | Robert Eckhardt E000035 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
32260 | 32260 | Herbert Roberts R000312 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32570 | 32570 | James Collins C000638 | rep | TX | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
32886 | 32886 | Richard White W000390 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 16 | |||||||||||||
32994 | 32994 | Jack Hightower H000582 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 13 | |||||||||||||
33015 | 33015 | Abraham Kazen K000025 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 23 | |||||||||||||
33283 | 33283 | Sam Hall H000070 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34152 | 34152 | James Wright W000763 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 12 | |||||||||||||
35146 | 35146 | Jack Brooks B000880 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 9 | |||||||||||||
35351 | 35351 | Robert Krueger K000333 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 21 | |||||||||||||
35514 | 35514 | James Pickle P000328 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 10 | |||||||||||||
36099 | 36099 | Charles Wilson W000570 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
36121 | 36121 | Eligio de la Garza D000203 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 15 | |||||||||||||
36210 | 36210 | Henry González G000272 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
36474 | 36474 | Bill Archer A000215 | rep | TX | 1975-01-14 | 1977-01-03 | Republican | 7 | |||||||||||||
39448 | 39448 | Ronald Paul P000583 | rep | TX | 1975-01-14 | 1977-01-03 | Republican | 22 | |||||||||||||
30935 | 30935 | Joseph Evins E000273 | rep | TN | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
30942 | 30942 | Richard Fulton F000424 | rep | TN | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
31412 | 31412 | Clifford Allen A000118 | rep | TN | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
32468 | 32468 | Robin Beard B000280 | rep | TN | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
33571 | 33571 | John Duncan D000534 | rep | TN | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
33615 | 33615 | Ed Jones J000216 | rep | TN | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
35373 | 35373 | Marilyn Lloyd L000381 | rep | TN | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
35800 | 35800 | Harold Ford F000261 | rep | TN | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
35981 | 35981 | James Quillen Q000013 | rep | TN | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
31178 | 31178 | George McGovern M000452 | sen | SD | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32431 | 32431 | James Abdnor A000009 | rep | SD | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
34841 | 34841 | Larry Pressler P000513 | rep | SD | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
31646 | 31646 | James Mann M000105 | rep | SC | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32012 | 32012 | Mendel Davis D000125 | rep | SC | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
32127 | 32127 | John Jenrette J000099 | rep | SC | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
32714 | 32714 | Kenneth Holland H000719 | rep | SC | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
35180 | 35180 | Butler Derrick D000267 | rep | SC | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
36651 | 36651 | Ernest Hollings H000725 | sen | SC | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
37156 | 37156 | Floyd Spence S000718 | rep | SC | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
31953 | 31953 | Edward Beard B000279 | rep | RI | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33755 | 33755 | Fernand St. Germain S000762 | rep | RI | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
30849 | 30849 | Jaime Benítez B000362 | rep | PR | 1975-01-14 | 1977-01-03 | Popular Democrat | 0 | |||||||||||||
30834 | 30834 | William Barrett B000178 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
30854 | 30854 | Edward Biester B000451 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 8 | |||||||||||||
30920 | 30920 | Edwin Eshleman E000214 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 16 | |||||||||||||
30951 | 30951 | William Green G000420 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31080 | 31080 | Albert Johnson J000115 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 23 | |||||||||||||
31216 | 31216 | Thomas Morgan M000958 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
31317 | 31317 | Herman Schneebeli S000135 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 17 | |||||||||||||
31323 | 31323 | Richard Schweiker S000159 | sen | PA | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
31401 | 31401 | Joseph Vigorito V000098 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
31536 | 31536 | John Dent D000255 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 21 | |||||||||||||
31542 | 31542 | Joshua Eilberg E000096 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31692 | 31692 | Gary Myers M001128 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 25 | |||||||||||||
31703 | 31703 | Robert Nix N000113 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 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);