legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
479 rows where "end" is on date 1981-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: start
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43346 | 43346 | Richard Shelby S000320 | rep | AL | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
42817 | 42817 | Edward Markey M000133 | rep | MA | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
42717 | 42717 | Patrick Leahy L000174 | sen | VT | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
42436 | 42436 | Charles Grassley G000386 | rep | IA | 1979-01-15 | 1981-01-03 | Republican | 3 | |||||||||||||
41667 | 41667 | Don Young Y000033 | rep | AK | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
41445 | 41445 | F. Sensenbrenner S000244 | rep | WI | 1979-01-15 | 1981-01-03 | Republican | 9 | |||||||||||||
41103 | 41103 | Richard Nolan N000127 | rep | MN | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
40681 | 40681 | Bill Nelson N000032 | rep | FL | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
40562 | 40562 | John Conyers C000714 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
40442 | 40442 | Charles Rangel R000053 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 19 | |||||||||||||
40225 | 40225 | Barbara Mikulski M000702 | rep | MD | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
40081 | 40081 | Henry Waxman W000215 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 24 | |||||||||||||
40028 | 40028 | Nick Rahall R000011 | rep | WV | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
40009 | 40009 | Thomas Petri P000265 | rep | WI | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
39964 | 39964 | George Miller M000725 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
39811 | 39811 | John Dingell D000355 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 16 | |||||||||||||
39696 | 39696 | Thomas Harkin H000206 | rep | IA | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
39626 | 39626 | C. Young Y000031 | rep | FL | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
39516 | 39516 | Fortney Stark S000810 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
39449 | 39449 | Ronald Paul P000583 | rep | TX | 1979-01-15 | 1981-01-03 | Republican | 22 | |||||||||||||
39400 | 39400 | Daniel Lungren L000517 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 34 | |||||||||||||
39383 | 39383 | Jerry Lewis L000274 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 37 | |||||||||||||
39346 | 39346 | Dale Kildee K000172 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
39236 | 39236 | Norman Dicks D000327 | rep | WA | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
39071 | 39071 | Olympia Snowe S000663 | rep | ME | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
39031 | 39031 | Daniel Akaka A000069 | rep | HI | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
39023 | 39023 | Daniel Inouye I000025 | sen | HI | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
38809 | 38809 | Ike Skelton S000465 | rep | MO | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
38735 | 38735 | David Obey O000007 | rep | WI | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
38714 | 38714 | James Oberstar O000006 | rep | MN | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
38695 | 38695 | John Murtha M001120 | rep | PA | 1979-01-15 | 1981-01-03 | Democrat | 12 | |||||||||||||
38296 | 38296 | Ralph Regula R000141 | rep | OH | 1979-01-15 | 1981-01-03 | Republican | 16 | |||||||||||||
38205 | 38205 | Trent Lott L000447 | rep | MS | 1979-01-15 | 1981-01-03 | Republican | 5 | |||||||||||||
37906 | 37906 | William Thomas T000188 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 18 | |||||||||||||
37846 | 37846 | Martin Sabo S000005 | rep | MN | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
37758 | 37758 | James Leach L000169 | rep | IA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
37699 | 37699 | Henry Hyde H001022 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
37606 | 37606 | Christopher Dodd D000388 | rep | CT | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
37491 | 37491 | William Tauzin T000058 | rep | LA | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
37467 | 37467 | Charles Stenholm S000851 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 17 | |||||||||||||
37415 | 37415 | Robert Matsui M000249 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
37343 | 37343 | Richard Gephardt G000132 | rep | MO | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
37329 | 37329 | Jonas Frost F000392 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 24 | |||||||||||||
37287 | 37287 | Philip Crane C000873 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 12 | |||||||||||||
37241 | 37241 | Douglas Bereuter B000403 | rep | NE | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
37203 | 37203 | Wes Watkins W000194 | rep | OK | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
37171 | 37171 | Robert Stump S001044 | rep | AZ | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
37158 | 37158 | Floyd Spence S000718 | rep | SC | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
37121 | 37121 | Elmer Shuster S000394 | rep | PA | 1979-01-15 | 1981-01-03 | Republican | 9 | |||||||||||||
37043 | 37043 | John Moakley M000834 | rep | MA | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
36989 | 36989 | John LaFalce L000556 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 36 | |||||||||||||
36978 | 36978 | James Jeffords J000072 | rep | VT | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
36936 | 36936 | Tony Hall H000074 | rep | OH | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
36923 | 36923 | Benjamin Gilman G000212 | rep | NY | 1979-01-15 | 1981-01-03 | Republican | 26 | |||||||||||||
36816 | 36816 | David Bonior B000619 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 12 | |||||||||||||
36756 | 36756 | Bruce Vento V000087 | rep | MN | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
36742 | 36742 | John Porter P000444 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 10 | |||||||||||||
36675 | 36675 | Robert Livingston L000371 | rep | LA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
36651 | 36651 | Ernest Hollings H000725 | sen | SC | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
36633 | 36633 | William Goodling G000291 | rep | PA | 1979-01-15 | 1981-01-03 | Republican | 19 | |||||||||||||
36592 | 36592 | Julian Dixon D000373 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 28 | |||||||||||||
36581 | 36581 | Thomas Daschle D000064 | rep | SD | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
36562 | 36562 | William Clay C000488 | rep | MO | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
36529 | 36529 | George Brown B000918 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 36 | |||||||||||||
36515 | 36515 | John Breaux B000780 | rep | LA | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
36476 | 36476 | Bill Archer A000215 | rep | TX | 1979-01-15 | 1981-01-03 | Republican | 7 | |||||||||||||
36462 | 36462 | Sidney Yates Y000013 | rep | IL | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
36403 | 36403 | Louis Stokes S000948 | rep | OH | 1979-01-15 | 1981-01-03 | Democrat | 21 | |||||||||||||
36388 | 36388 | Gerald Solomon S000675 | rep | NY | 1979-01-15 | 1981-01-03 | Republican | 29 | |||||||||||||
36303 | 36303 | Joseph McDade M000399 | rep | PA | 1979-01-15 | 1981-01-03 | Republican | 10 | |||||||||||||
36247 | 36247 | Willie Hefner H000448 | rep | NC | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
36235 | 36235 | Lee Hamilton H000114 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
36222 | 36222 | Phil Gramm G000365 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
36212 | 36212 | Henry González G000272 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 20 | |||||||||||||
36193 | 36193 | Newton Gingrich G000225 | rep | GA | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
36163 | 36163 | Victor Fazio F000053 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
36146 | 36146 | Ronald Dellums D000222 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
36123 | 36123 | Eligio de la Garza D000203 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 15 | |||||||||||||
36101 | 36101 | Charles Wilson W000570 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
36089 | 36089 | John Williams W000520 | rep | MT | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
36079 | 36079 | Robert Walker W000068 | rep | PA | 1979-01-15 | 1981-01-03 | Republican | 16 | |||||||||||||
36061 | 36061 | Harold Volkmer V000112 | rep | MO | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
36040 | 36040 | Gerry Studds S001040 | rep | MA | 1979-01-15 | 1981-01-03 | Democrat | 12 | |||||||||||||
36027 | 36027 | Patricia Schroeder S000142 | rep | CO | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
36008 | 36008 | Toby Roth R000459 | rep | WI | 1979-01-15 | 1981-01-03 | Republican | 8 | |||||||||||||
35999 | 35999 | Charles Rose R000436 | rep | NC | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
35983 | 35983 | James Quillen Q000013 | rep | TN | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
35955 | 35955 | John Myers M001130 | rep | IN | 1979-01-15 | 1981-01-03 | Republican | 7 | |||||||||||||
35936 | 35936 | Carlos Moorhead M000926 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 22 | |||||||||||||
35924 | 35924 | Gillespie Montgomery M000865 | rep | MS | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
35909 | 35909 | Norman Mineta M000794 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 13 | |||||||||||||
35869 | 35869 | Andrew Jacobs J000033 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 11 | |||||||||||||
35829 | 35829 | Sam Gibbons G000153 | rep | FL | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
35802 | 35802 | Harold Ford F000261 | rep | TN | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
35773 | 35773 | Robert Dornan D000435 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 27 | |||||||||||||
35761 | 35761 | Cardiss Collins C000634 | rep | IL | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
35739 | 35739 | William Clinger C000523 | rep | PA | 1979-01-15 | 1981-01-03 | Republican | 23 | |||||||||||||
35699 | 35699 | Tom Bevill B000431 | rep | AL | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
35684 | 35684 | Anthony Beilenson B000318 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 23 | |||||||||||||
35661 | 35661 | Jamie Whitten W000428 | rep | MS | 1979-01-15 | 1981-01-03 | Democrat | 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);