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)
Suggested facets: party, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43630 | 43630 | Ron Wyden W000779 | rep | OR | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
43411 | 43411 | Christopher Smith S000522 | rep | NJ | 1981-01-05 | 1983-01-03 | Republican | 4 | |||||||||||||
43347 | 43347 | Richard Shelby S000320 | rep | AL | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
43286 | 43286 | Charles Schumer S000148 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 16 | |||||||||||||
43150 | 43150 | Harold Rogers R000395 | rep | KY | 1981-01-05 | 1983-01-03 | Republican | 5 | |||||||||||||
42818 | 42818 | Edward Markey M000133 | rep | MA | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
42532 | 42532 | Steny Hoyer H000874 | rep | MD | 1981-01-05 | 1983-01-03 | Democrat | 5 | |||||||||||||
41668 | 41668 | Don Young Y000033 | rep | AK | 1981-01-05 | 1983-01-03 | Republican | 0 | |||||||||||||
41446 | 41446 | F. Sensenbrenner S000244 | rep | WI | 1981-01-05 | 1983-01-03 | Republican | 9 | |||||||||||||
41266 | 41266 | Pat Roberts R000307 | rep | KS | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
40682 | 40682 | Bill Nelson N000032 | rep | FL | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
40672 | 40672 | Orrin Hatch H000338 | sen | UT | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
40563 | 40563 | John Conyers C000714 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
40443 | 40443 | Charles Rangel R000053 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 19 | |||||||||||||
40226 | 40226 | Barbara Mikulski M000702 | rep | MD | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
40210 | 40210 | Daniel Coats C000542 | rep | IN | 1981-01-05 | 1983-01-03 | Republican | 4 | |||||||||||||
40099 | 40099 | Frank Wolf W000672 | rep | VA | 1981-01-05 | 1983-01-03 | Republican | 10 | |||||||||||||
40082 | 40082 | Henry Waxman W000215 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 24 | |||||||||||||
40029 | 40029 | Nick Rahall R000011 | rep | WV | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
40010 | 40010 | Thomas Petri P000265 | rep | WI | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
39965 | 39965 | George Miller M000725 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
39856 | 39856 | Ralph Hall H000067 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
39812 | 39812 | John Dingell D000355 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 16 | |||||||||||||
39697 | 39697 | Thomas Harkin H000206 | rep | IA | 1981-01-05 | 1983-01-03 | Democrat | 5 | |||||||||||||
39627 | 39627 | C. Young Y000031 | rep | FL | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
39603 | 39603 | Frank Lautenberg L000123 | sen | NJ | 1982-12-27 | 1983-01-03 | 1 | Democrat | |||||||||||||
39517 | 39517 | Fortney Stark S000810 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
39450 | 39450 | Ronald Paul P000583 | rep | TX | 1981-01-05 | 1983-01-03 | Republican | 22 | |||||||||||||
39401 | 39401 | Daniel Lungren L000517 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 34 | |||||||||||||
39384 | 39384 | Jerry Lewis L000274 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 37 | |||||||||||||
39347 | 39347 | Dale Kildee K000172 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
39269 | 39269 | Barney Frank F000339 | rep | MA | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
39253 | 39253 | David Dreier D000492 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 35 | |||||||||||||
39237 | 39237 | Norman Dicks D000327 | rep | WA | 1981-01-05 | 1983-01-03 | Democrat | 6 | |||||||||||||
39072 | 39072 | Olympia Snowe S000663 | rep | ME | 1981-01-05 | 1983-01-03 | Republican | 2 | |||||||||||||
39063 | 39063 | Richard Lugar L000504 | sen | IN | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
39032 | 39032 | Daniel Akaka A000069 | rep | HI | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
38810 | 38810 | Ike Skelton S000465 | rep | MO | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
38736 | 38736 | David Obey O000007 | rep | WI | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
38715 | 38715 | James Oberstar O000006 | rep | MN | 1981-01-05 | 1983-01-03 | Democrat | 8 | |||||||||||||
38696 | 38696 | John Murtha M001120 | rep | PA | 1981-01-05 | 1983-01-03 | Democrat | 12 | |||||||||||||
38297 | 38297 | Ralph Regula R000141 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 16 | |||||||||||||
38206 | 38206 | Trent Lott L000447 | rep | MS | 1981-01-05 | 1983-01-03 | Republican | 5 | |||||||||||||
38180 | 38180 | Tom Lantos L000090 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 11 | |||||||||||||
38152 | 38152 | Edward Kennedy K000105 | sen | MA | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
38115 | 38115 | Duncan Hunter H000981 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 42 | |||||||||||||
37957 | 37957 | Robert Byrd B001210 | sen | WV | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
37907 | 37907 | William Thomas T000188 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 18 | |||||||||||||
37862 | 37862 | E. Shaw S000303 | rep | FL | 1981-01-05 | 1983-01-03 | Republican | 12 | |||||||||||||
37847 | 37847 | Martin Sabo S000005 | rep | MN | 1981-01-05 | 1983-01-03 | Democrat | 5 | |||||||||||||
37820 | 37820 | Michael Oxley O000163 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 4 | |||||||||||||
37759 | 37759 | James Leach L000169 | rep | IA | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
37700 | 37700 | Henry Hyde H001022 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
37657 | 37657 | Judd Gregg G000445 | rep | NH | 1981-01-05 | 1983-01-03 | Republican | 2 | |||||||||||||
37612 | 37612 | Byron Dorgan D000432 | rep | ND | 1981-01-05 | 1983-01-03 | Democrat | 0 | |||||||||||||
37492 | 37492 | William Tauzin T000058 | rep | LA | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
37468 | 37468 | Charles Stenholm S000851 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 17 | |||||||||||||
37416 | 37416 | Robert Matsui M000249 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
37344 | 37344 | Richard Gephardt G000132 | rep | MO | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
37330 | 37330 | Jonas Frost F000392 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 24 | |||||||||||||
37288 | 37288 | Philip Crane C000873 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 12 | |||||||||||||
37274 | 37274 | Larry Craig C000858 | rep | ID | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
37242 | 37242 | Douglas Bereuter B000403 | rep | NE | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
37204 | 37204 | Wes Watkins W000194 | rep | OK | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
37172 | 37172 | Robert Stump S001044 | rep | AZ | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
37159 | 37159 | Floyd Spence S000718 | rep | SC | 1981-01-05 | 1983-01-03 | Republican | 2 | |||||||||||||
37143 | 37143 | Joseph Skeen S000463 | rep | NM | 1981-01-05 | 1983-01-03 | Republican | 2 | |||||||||||||
37122 | 37122 | Elmer Shuster S000394 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 9 | |||||||||||||
37096 | 37096 | Paul Sarbanes S000064 | sen | MD | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
37078 | 37078 | Marge Roukema R000465 | rep | NJ | 1981-01-05 | 1983-01-03 | Republican | 7 | |||||||||||||
37044 | 37044 | John Moakley M000834 | rep | MA | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
36990 | 36990 | John LaFalce L000556 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 36 | |||||||||||||
36979 | 36979 | James Jeffords J000072 | rep | VT | 1981-01-05 | 1983-01-03 | Republican | 0 | |||||||||||||
36948 | 36948 | James Hansen H000172 | rep | UT | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
36937 | 36937 | Tony Hall H000074 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
36924 | 36924 | Benjamin Gilman G000212 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 26 | |||||||||||||
36882 | 36882 | William Coyne C000846 | rep | PA | 1981-01-05 | 1983-01-03 | Democrat | 14 | |||||||||||||
36817 | 36817 | David Bonior B000619 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 12 | |||||||||||||
36757 | 36757 | Bruce Vento V000087 | rep | MN | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
36743 | 36743 | John Porter P000444 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 10 | |||||||||||||
36696 | 36696 | Bill McCollum M000350 | rep | FL | 1981-01-05 | 1983-01-03 | Republican | 5 | |||||||||||||
36686 | 36686 | Matthew Martínez M000206 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 30 | |||||||||||||
36676 | 36676 | Robert Livingston L000371 | rep | LA | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
36634 | 36634 | William Goodling G000291 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 19 | |||||||||||||
36621 | 36621 | Sam Gejdenson G000120 | rep | CT | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
36593 | 36593 | Julian Dixon D000373 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 28 | |||||||||||||
36582 | 36582 | Thomas Daschle D000064 | rep | SD | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
36563 | 36563 | William Clay C000488 | rep | MO | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
36530 | 36530 | George Brown B000918 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 36 | |||||||||||||
36516 | 36516 | John Breaux B000780 | rep | LA | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
36501 | 36501 | Tom Bliley B000556 | rep | VA | 1981-01-05 | 1983-01-03 | Republican | 3 | |||||||||||||
36477 | 36477 | Bill Archer A000215 | rep | TX | 1981-01-05 | 1983-01-03 | Republican | 7 | |||||||||||||
36463 | 36463 | Sidney Yates Y000013 | rep | IL | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
36404 | 36404 | Louis Stokes S000948 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 21 | |||||||||||||
36389 | 36389 | Gerald Solomon S000675 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 29 | |||||||||||||
36304 | 36304 | Joseph McDade M000399 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 10 | |||||||||||||
36272 | 36272 | Barbara Kennelly K000118 | rep | CT | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
36248 | 36248 | Willie Hefner H000448 | rep | NC | 1981-01-05 | 1983-01-03 | Democrat | 8 | |||||||||||||
36236 | 36236 | Lee Hamilton H000114 | rep | IN | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
36223 | 36223 | Phil Gramm G000365 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 6 |
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);