legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "start" is on date 1977-01-04 sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31768 | 31768 | Teno Roncalio R000421 | rep | WY | 1977-01-04 | 1979-01-03 | Democrat | 0 | |||||||||||||
34131 | 34131 | Malcolm Wallop W000092 | sen | WY | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
32292 | 32292 | John Slack S000473 | rep | WV | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
32312 | 32312 | Harley Staggers S000778 | rep | WV | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
32787 | 32787 | Robert Mollohan M000845 | rep | WV | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
37957 | 37957 | Robert Byrd B001210 | sen | WV | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
40027 | 40027 | Nick Rahall R000011 | rep | WV | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
31508 | 31508 | Robert Cornell C000782 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
31845 | 31845 | William Steiger S000847 | rep | WI | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
31947 | 31947 | Alvin Baldus B000083 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
32820 | 32820 | Henry Reuss R000165 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
33115 | 33115 | William Proxmire P000553 | sen | WI | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
33205 | 33205 | Clement Zablocki Z000001 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
33624 | 33624 | Robert Kasten K000019 | rep | WI | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
33967 | 33967 | Robert Kastenmeier K000020 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
35111 | 35111 | Leslie Aspin A000224 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
38734 | 38734 | David Obey O000007 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
31510 | 31510 | John Cunningham C000992 | rep | WA | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
31665 | 31665 | Lloyd Meeds M000626 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
32164 | 32164 | Mike McCormack M000365 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
33009 | 33009 | Henry Jackson J000013 | sen | WA | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
33107 | 33107 | Joel Pritchard P000546 | rep | WA | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
33476 | 33476 | Brockman Adams A000031 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
33518 | 33518 | Don Bonker B000620 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
35251 | 35251 | Thomas Foley F000239 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
39235 | 39235 | Norman Dicks D000327 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
33153 | 33153 | Robert Stafford S000776 | sen | VT | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
36977 | 36977 | James Jeffords J000072 | rep | VT | 1977-01-04 | 1979-01-03 | Republican | 0 | |||||||||||||
35671 | 35671 | Ron de Lugo D000209 | rep | VI | 1977-01-04 | 1979-01-03 | Democrat | 0 | |||||||||||||
31471 | 31471 | Harry Byrd B001209 | sen | VA | 1977-01-04 | 1983-01-03 | 1 | Independent | |||||||||||||
32058 | 32058 | Joseph Fisher F000151 | rep | VA | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
32098 | 32098 | Herbert Harris H000241 | rep | VA | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
32275 | 32275 | David Satterfield S000070 | rep | VA | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
32545 | 32545 | Manley Butler B001182 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
32583 | 32583 | Robert Daniel D000037 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
32877 | 32877 | William Wampler W000121 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
33123 | 33123 | James Robinson R000337 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
33162 | 33162 | Paul Trible T000367 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
33438 | 33438 | George Whitehurst W000406 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
33547 | 33547 | Wilbur Daniel D000038 | rep | VA | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
32177 | 32177 | Koln McKay M000490 | rep | UT | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
33039 | 33039 | David Marriott M000143 | rep | UT | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
40672 | 40672 | Orrin Hatch H000338 | sen | UT | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
31468 | 31468 | Omar Burleson B001111 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 17 | |||||||||||||
31582 | 31582 | Robert Gammage G000036 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 22 | |||||||||||||
31599 | 31599 | Barbara Jordan J000266 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
31642 | 31642 | George Mahon M000065 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 19 | |||||||||||||
31674 | 31674 | Dale Milford M000708 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 24 | |||||||||||||
31738 | 31738 | William Poage P000398 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 11 | |||||||||||||
31862 | 31862 | Olin Teague T000110 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
31912 | 31912 | John Young Y000043 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 14 | |||||||||||||
32054 | 32054 | Robert Eckhardt E000035 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
32261 | 32261 | Herbert Roberts R000312 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
32571 | 32571 | James Collins C000638 | rep | TX | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
32751 | 32751 | James Mattox M000260 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
32887 | 32887 | Richard White W000390 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 16 | |||||||||||||
32995 | 32995 | Jack Hightower H000582 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 13 | |||||||||||||
33016 | 33016 | Abraham Kazen K000025 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
33284 | 33284 | Sam Hall H000070 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
33819 | 33819 | Lloyd Bentsen B000401 | sen | TX | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
34153 | 34153 | James Wright W000763 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 12 | |||||||||||||
35147 | 35147 | Jack Brooks B000880 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
35352 | 35352 | Robert Krueger K000333 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
35515 | 35515 | James Pickle P000328 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
36100 | 36100 | Charles Wilson W000570 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
36122 | 36122 | Eligio de la Garza D000203 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 15 | |||||||||||||
36211 | 36211 | Henry González G000272 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 20 | |||||||||||||
36475 | 36475 | Bill Archer A000215 | rep | TX | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
31413 | 31413 | Clifford Allen A000118 | rep | TN | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
32469 | 32469 | Robin Beard B000280 | rep | TN | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
33572 | 33572 | John Duncan D000534 | rep | TN | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
33616 | 33616 | Ed Jones J000216 | rep | TN | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
34079 | 34079 | James Sasser S000068 | sen | TN | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
34483 | 34483 | Albert Gore G000321 | rep | TN | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
35374 | 35374 | Marilyn Lloyd L000381 | rep | TN | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
35801 | 35801 | Harold Ford F000261 | rep | TN | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
35982 | 35982 | James Quillen Q000013 | rep | TN | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
32432 | 32432 | James Abdnor A000009 | rep | SD | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
34842 | 34842 | Larry Pressler P000513 | rep | SD | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
31647 | 31647 | James Mann M000105 | rep | SC | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
32013 | 32013 | Mendel Davis D000125 | rep | SC | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
32128 | 32128 | John Jenrette J000099 | rep | SC | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
32715 | 32715 | Kenneth Holland H000719 | rep | SC | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
35181 | 35181 | Butler Derrick D000267 | rep | SC | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
37157 | 37157 | Floyd Spence S000718 | rep | SC | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
31954 | 31954 | Edward Beard B000279 | rep | RI | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
33756 | 33756 | Fernand St. Germain S000762 | rep | RI | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
35728 | 35728 | John Chafee C000269 | sen | RI | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
32936 | 32936 | Baltasar Corrada-del Río C000788 | rep | PR | 1977-01-04 | 1979-01-03 | New Progressive | 0 | |||||||||||||
31414 | 31414 | Joseph Ammerman A000177 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
31537 | 31537 | John Dent D000255 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
31543 | 31543 | Joshua Eilberg E000096 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
31693 | 31693 | Gary Myers M001128 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 25 | |||||||||||||
31704 | 31704 | Robert Nix N000113 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
31776 | 31776 | Frederick Rooney R000423 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 15 | |||||||||||||
32074 | 32074 | Daniel Flood F000209 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 11 | |||||||||||||
32193 | 32193 | William Moorhead M000930 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 14 | |||||||||||||
32211 | 32211 | Michael Myers M001132 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
32622 | 32622 | Allen Ertel E000208 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 17 | |||||||||||||
32728 | 32728 | Raymond Lederer L000187 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 3 |
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);