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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42816 | 42816 | Edward Markey M000133 | rep | MA | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
42435 | 42435 | Charles Grassley G000386 | rep | IA | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
41666 | 41666 | Don Young Y000033 | rep | AK | 1977-01-04 | 1979-01-03 | Republican | 0 | |||||||||||||
41102 | 41102 | Richard Nolan N000127 | rep | MN | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
40672 | 40672 | Orrin Hatch H000338 | sen | UT | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
40620 | 40620 | Thad Cochran C000567 | rep | MS | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
40561 | 40561 | John Conyers C000714 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
40441 | 40441 | Charles Rangel R000053 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 19 | |||||||||||||
40224 | 40224 | Barbara Mikulski M000702 | rep | MD | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
40080 | 40080 | Henry Waxman W000215 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 24 | |||||||||||||
40027 | 40027 | Nick Rahall R000011 | rep | WV | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
39963 | 39963 | George Miller M000725 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
39810 | 39810 | John Dingell D000355 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 16 | |||||||||||||
39695 | 39695 | Thomas Harkin H000206 | rep | IA | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
39658 | 39658 | Max Baucus B000243 | rep | MT | 1977-01-04 | 1978-12-14 | Democrat | 1 | |||||||||||||
39625 | 39625 | C. Young Y000031 | rep | FL | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
39515 | 39515 | Fortney Stark S000810 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
39345 | 39345 | Dale Kildee K000172 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
39235 | 39235 | Norman Dicks D000327 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
39063 | 39063 | Richard Lugar L000504 | sen | IN | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
39030 | 39030 | Daniel Akaka A000069 | rep | HI | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
38808 | 38808 | Ike Skelton S000465 | rep | MO | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
38734 | 38734 | David Obey O000007 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
38713 | 38713 | James Oberstar O000006 | rep | MN | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
38694 | 38694 | John Murtha M001120 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 12 | |||||||||||||
38295 | 38295 | Ralph Regula R000141 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 16 | |||||||||||||
38204 | 38204 | Trent Lott L000447 | rep | MS | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
38152 | 38152 | Edward Kennedy K000105 | sen | MA | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
37957 | 37957 | Robert Byrd B001210 | sen | WV | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
37757 | 37757 | James Leach L000169 | rep | IA | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
37698 | 37698 | Henry Hyde H001022 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
37605 | 37605 | Christopher Dodd D000388 | rep | CT | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
37342 | 37342 | Richard Gephardt G000132 | rep | MO | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
37286 | 37286 | Philip Crane C000873 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 12 | |||||||||||||
37202 | 37202 | Wes Watkins W000194 | rep | OK | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
37170 | 37170 | Robert Stump S001044 | rep | AZ | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
37157 | 37157 | Floyd Spence S000718 | rep | SC | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
37120 | 37120 | Elmer Shuster S000394 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
37096 | 37096 | Paul Sarbanes S000064 | sen | MD | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
37042 | 37042 | John Moakley M000834 | rep | MA | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
36988 | 36988 | John LaFalce L000556 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 36 | |||||||||||||
36977 | 36977 | James Jeffords J000072 | rep | VT | 1977-01-04 | 1979-01-03 | Republican | 0 | |||||||||||||
36922 | 36922 | Benjamin Gilman G000212 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 26 | |||||||||||||
36815 | 36815 | David Bonior B000619 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 12 | |||||||||||||
36755 | 36755 | Bruce Vento V000087 | rep | MN | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
36674 | 36674 | Robert Livingston L000371 | rep | LA | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
36632 | 36632 | William Goodling G000291 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 19 | |||||||||||||
36561 | 36561 | William Clay C000488 | rep | MO | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
36528 | 36528 | George Brown B000918 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 36 | |||||||||||||
36514 | 36514 | John Breaux B000780 | rep | LA | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
36475 | 36475 | Bill Archer A000215 | rep | TX | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
36461 | 36461 | Sidney Yates Y000013 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
36402 | 36402 | Louis Stokes S000948 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
36302 | 36302 | Joseph McDade M000399 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 10 | |||||||||||||
36246 | 36246 | Willie Hefner H000448 | rep | NC | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
36234 | 36234 | Lee Hamilton H000114 | rep | IN | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
36211 | 36211 | Henry González G000272 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 20 | |||||||||||||
36145 | 36145 | Ronald Dellums D000222 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
36122 | 36122 | Eligio de la Garza D000203 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 15 | |||||||||||||
36100 | 36100 | Charles Wilson W000570 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
36078 | 36078 | Robert Walker W000068 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 16 | |||||||||||||
36060 | 36060 | Harold Volkmer V000112 | rep | MO | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
36052 | 36052 | Raymond Thornton T000243 | rep | AR | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
36039 | 36039 | Gerry Studds S001040 | rep | MA | 1977-01-04 | 1979-01-03 | Democrat | 12 | |||||||||||||
36026 | 36026 | Patricia Schroeder S000142 | rep | CO | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
36020 | 36020 | William Roth R000460 | sen | DE | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
35998 | 35998 | Charles Rose R000436 | rep | NC | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
35982 | 35982 | James Quillen Q000013 | rep | TN | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
35954 | 35954 | John Myers M001130 | rep | IN | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
35945 | 35945 | Daniel Moynihan M001054 | sen | NY | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
35935 | 35935 | Carlos Moorhead M000926 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 22 | |||||||||||||
35923 | 35923 | Gillespie Montgomery M000865 | rep | MS | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
35908 | 35908 | Norman Mineta M000794 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 13 | |||||||||||||
35868 | 35868 | Andrew Jacobs J000033 | rep | IN | 1977-01-04 | 1979-01-03 | Democrat | 11 | |||||||||||||
35828 | 35828 | Sam Gibbons G000153 | rep | FL | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
35801 | 35801 | Harold Ford F000261 | rep | TN | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
35772 | 35772 | Robert Dornan D000435 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 27 | |||||||||||||
35760 | 35760 | Cardiss Collins C000634 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
35728 | 35728 | John Chafee C000269 | sen | RI | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
35698 | 35698 | Tom Bevill B000431 | rep | AL | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
35683 | 35683 | Anthony Beilenson B000318 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
35671 | 35671 | Ron de Lugo D000209 | rep | VI | 1977-01-04 | 1979-01-03 | Democrat | 0 | |||||||||||||
35660 | 35660 | Jamie Whitten W000428 | rep | MS | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
35591 | 35591 | Neal Smith S000596 | rep | IA | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
35566 | 35566 | Philip Sharp S000294 | rep | IN | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
35543 | 35543 | Daniel Rostenkowski R000458 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
35515 | 35515 | James Pickle P000328 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
35493 | 35493 | Leon Panetta P000047 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 16 | |||||||||||||
35479 | 35479 | Stephen Neal N000016 | rep | NC | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
35469 | 35469 | William Natcher N000009 | rep | KY | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
35448 | 35448 | Austin Murphy M001088 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 22 | |||||||||||||
35438 | 35438 | Robert Michel M000692 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 18 | |||||||||||||
35395 | 35395 | Romano Mazzoli M000291 | rep | KY | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
35374 | 35374 | Marilyn Lloyd L000381 | rep | TN | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
35352 | 35352 | Robert Krueger K000333 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
35328 | 35328 | William Hughes H000930 | rep | NJ | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
35300 | 35300 | Willis Gradison G000349 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
35290 | 35290 | Daniel Glickman G000240 | rep | KS | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
35271 | 35271 | William Ford F000270 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 15 | |||||||||||||
35251 | 35251 | Thomas Foley F000239 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 5 |
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);