legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "end" is on date 1987-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43632 | 43632 | Ron Wyden W000779 | rep | OR | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
43413 | 43413 | Christopher Smith S000522 | rep | NJ | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
43349 | 43349 | Richard Shelby S000320 | rep | AL | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
43288 | 43288 | Charles Schumer S000148 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 10 | |||||||||||||
43152 | 43152 | Harold Rogers R000395 | rep | KY | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
42820 | 42820 | Edward Markey M000133 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
42718 | 42718 | Patrick Leahy L000174 | sen | VT | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
42613 | 42613 | Marcy Kaptur K000009 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 9 | |||||||||||||
42534 | 42534 | Steny Hoyer H000874 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
42437 | 42437 | Charles Grassley G000386 | sen | IA | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
42199 | 42199 | Jim Cooper C000754 | rep | TN | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
41837 | 41837 | Richard Durbin D000563 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 20 | |||||||||||||
41759 | 41759 | Thomas Carper C000174 | rep | DE | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
41670 | 41670 | Don Young Y000033 | rep | AK | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
41512 | 41512 | Peter Visclosky V000108 | rep | IN | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
41448 | 41448 | F. Sensenbrenner S000244 | rep | WI | 1985-01-03 | 1987-01-03 | Republican | 9 | |||||||||||||
41268 | 41268 | Pat Roberts R000307 | rep | KS | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
40906 | 40906 | Sander Levin L000263 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 17 | |||||||||||||
40694 | 40694 | Joe Barton B000213 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
40684 | 40684 | Bill Nelson N000032 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 11 | |||||||||||||
40647 | 40647 | John McCain M000303 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
40565 | 40565 | John Conyers C000714 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
40445 | 40445 | Charles Rangel R000053 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 16 | |||||||||||||
40235 | 40235 | Harry Reid R000146 | rep | NV | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
40228 | 40228 | Barbara Mikulski M000702 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
40212 | 40212 | Daniel Coats C000542 | rep | IN | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
40202 | 40202 | Barbara Boxer B000711 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
40131 | 40131 | Howard Coble C000556 | rep | NC | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
40101 | 40101 | Frank Wolf W000672 | rep | VA | 1985-01-03 | 1987-01-03 | Republican | 10 | |||||||||||||
40084 | 40084 | Henry Waxman W000215 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 24 | |||||||||||||
40031 | 40031 | Nick Rahall R000011 | rep | WV | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
40012 | 40012 | Thomas Petri P000265 | rep | WI | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
39967 | 39967 | George Miller M000725 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
39858 | 39858 | Ralph Hall H000067 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
39814 | 39814 | John Dingell D000355 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 16 | |||||||||||||
39629 | 39629 | C. Young Y000031 | rep | FL | 1985-01-03 | 1987-01-03 | Republican | 8 | |||||||||||||
39555 | 39555 | Edolphus Towns T000326 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 11 | |||||||||||||
39519 | 39519 | Fortney Stark S000810 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 9 | |||||||||||||
39403 | 39403 | Daniel Lungren L000517 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 42 | |||||||||||||
39386 | 39386 | Jerry Lewis L000274 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 35 | |||||||||||||
39349 | 39349 | Dale Kildee K000172 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
39271 | 39271 | Barney Frank F000339 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
39255 | 39255 | David Dreier D000492 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 33 | |||||||||||||
39239 | 39239 | Norman Dicks D000327 | rep | WA | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
39194 | 39194 | Dan Burton B001149 | rep | IN | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
39144 | 39144 | Howard Berman B000410 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 26 | |||||||||||||
39085 | 39085 | Gary Ackerman A000022 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
39074 | 39074 | Olympia Snowe S000663 | rep | ME | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
39034 | 39034 | Daniel Akaka A000069 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
39024 | 39024 | Daniel Inouye I000025 | sen | HI | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
38848 | 38848 | John Spratt S000749 | rep | SC | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
38812 | 38812 | Ike Skelton S000465 | rep | MO | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
38752 | 38752 | Solomon Ortiz O000107 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 27 | |||||||||||||
38738 | 38738 | David Obey O000007 | rep | WI | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
38717 | 38717 | James Oberstar O000006 | rep | MN | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
38698 | 38698 | John Murtha M001120 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 12 | |||||||||||||
38671 | 38671 | Alan Mollohan M000844 | rep | WV | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
38602 | 38602 | Paul Kanjorski K000008 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 11 | |||||||||||||
38555 | 38555 | Barton Gordon G000309 | rep | TN | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
38437 | 38437 | Frederick Boucher B000657 | rep | VA | 1985-01-03 | 1987-01-03 | Democrat | 9 | |||||||||||||
38394 | 38394 | Neil Abercrombie A000014 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
38321 | 38321 | H. Saxton S000097 | rep | NJ | 1985-01-03 | 1987-01-03 | Republican | 13 | |||||||||||||
38299 | 38299 | Ralph Regula R000141 | rep | OH | 1985-01-03 | 1987-01-03 | Republican | 16 | |||||||||||||
38208 | 38208 | Trent Lott L000447 | rep | MS | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
38182 | 38182 | Tom Lantos L000090 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 11 | |||||||||||||
38117 | 38117 | Duncan Hunter H000981 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 45 | |||||||||||||
37909 | 37909 | William Thomas T000188 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 20 | |||||||||||||
37883 | 37883 | Arlen Specter S000709 | sen | PA | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
37864 | 37864 | E. Shaw S000303 | rep | FL | 1985-01-03 | 1987-01-03 | Republican | 15 | |||||||||||||
37849 | 37849 | Martin Sabo S000005 | rep | MN | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
37822 | 37822 | Michael Oxley O000163 | rep | OH | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
37809 | 37809 | Major Owens O000159 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 12 | |||||||||||||
37761 | 37761 | James Leach L000169 | rep | IA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
37746 | 37746 | James Kolbe K000306 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
37726 | 37726 | Nancy Johnson J000163 | rep | CT | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
37702 | 37702 | Henry Hyde H001022 | rep | IL | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
37659 | 37659 | Judd Gregg G000445 | rep | NH | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
37623 | 37623 | Lane Evans E000250 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 17 | |||||||||||||
37614 | 37614 | Byron Dorgan D000432 | rep | ND | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
37607 | 37607 | Christopher Dodd D000388 | sen | CT | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
37593 | 37593 | Thomas DeLay D000217 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 22 | |||||||||||||
37533 | 37533 | Sherwood Boehlert B000586 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 25 | |||||||||||||
37521 | 37521 | Michael Bilirakis B000463 | rep | FL | 1985-01-03 | 1987-01-03 | Republican | 9 | |||||||||||||
37494 | 37494 | William Tauzin T000058 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
37470 | 37470 | Charles Stenholm S000851 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 17 | |||||||||||||
37418 | 37418 | Robert Matsui M000249 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
37401 | 37401 | William Lipinski L000342 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
37390 | 37390 | Gerald Kleczka K000259 | rep | WI | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
37346 | 37346 | Richard Gephardt G000132 | rep | MO | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
37332 | 37332 | Jonas Frost F000392 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 24 | |||||||||||||
37290 | 37290 | Philip Crane C000873 | rep | IL | 1985-01-03 | 1987-01-03 | Republican | 12 | |||||||||||||
37276 | 37276 | Larry Craig C000858 | rep | ID | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
37264 | 37264 | Larry Combest C000653 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 19 | |||||||||||||
37244 | 37244 | Douglas Bereuter B000403 | rep | NE | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
37230 | 37230 | Cass Ballenger B000104 | rep | NC | 1986-11-04 | 1987-01-03 | Republican | 10 | |||||||||||||
37206 | 37206 | Wes Watkins W000194 | rep | OK | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
37188 | 37188 | James Traficant T000350 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 17 | |||||||||||||
37174 | 37174 | Robert Stump S001044 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
37161 | 37161 | Floyd Spence S000718 | rep | SC | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
37145 | 37145 | Joseph Skeen S000463 | rep | NM | 1985-01-03 | 1987-01-03 | Republican | 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);