legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
475 rows where "end" is on date 1993-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44428 | 44428 | Kweisi Mfume M000687 | rep | MD | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
43635 | 43635 | Ron Wyden W000779 | rep | OR | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
43569 | 43569 | Maxine Waters W000187 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 29 | |||||||||||||
43514 | 43514 | Fred Upton U000031 | rep | MI | 1991-01-03 | 1993-01-03 | Republican | 4 | |||||||||||||
43416 | 43416 | Christopher Smith S000522 | rep | NJ | 1991-01-03 | 1993-01-03 | Republican | 4 | |||||||||||||
43350 | 43350 | Richard Shelby S000320 | sen | AL | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
43291 | 43291 | Charles Schumer S000148 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 10 | |||||||||||||
43155 | 43155 | Harold Rogers R000395 | rep | KY | 1991-01-03 | 1993-01-03 | Republican | 5 | |||||||||||||
43128 | 43128 | David Price P000523 | rep | NC | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
43074 | 43074 | Nancy Pelosi P000197 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
43041 | 43041 | Frank Pallone P000034 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
43017 | 43017 | Eleanor Norton N000147 | rep | DC | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
43001 | 43001 | Richard Neal N000015 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
42972 | 42972 | Jerrold Nadler N000002 | rep | NY | 1992-11-03 | 1993-01-03 | Democrat | 17 | |||||||||||||
42823 | 42823 | Edward Markey M000133 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
42719 | 42719 | Patrick Leahy L000174 | sen | VT | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
42616 | 42616 | Marcy Kaptur K000009 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 9 | |||||||||||||
42537 | 42537 | Steny Hoyer H000874 | rep | MD | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
42438 | 42438 | Charles Grassley G000386 | sen | IA | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
42297 | 42297 | Rosa DeLauro D000216 | rep | CT | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
42268 | 42268 | Peter DeFazio D000191 | rep | OR | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
42202 | 42202 | Jim Cooper C000754 | rep | TN | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
41876 | 41876 | John Reed R000122 | rep | RI | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
41858 | 41858 | James Inhofe I000024 | rep | OK | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
41840 | 41840 | Richard Durbin D000563 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 20 | |||||||||||||
41790 | 41790 | Bernard Sanders S000033 | rep | VT | 1991-01-03 | 1993-01-03 | Independent | 0 | Democrat | ||||||||||||
41762 | 41762 | Thomas Carper C000174 | rep | DE | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
41747 | 41747 | Benjamin Cardin C000141 | rep | MD | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
41673 | 41673 | Don Young Y000033 | rep | AK | 1991-01-03 | 1993-01-03 | Republican | 0 | |||||||||||||
41515 | 41515 | Peter Visclosky V000108 | rep | IN | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
41467 | 41467 | José Serrano S000248 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 18 | |||||||||||||
41451 | 41451 | F. Sensenbrenner S000244 | rep | WI | 1991-01-03 | 1993-01-03 | Republican | 9 | |||||||||||||
41419 | 41419 | Collin Peterson P000258 | rep | MN | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
41390 | 41390 | Nita Lowey L000480 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 20 | |||||||||||||
41328 | 41328 | Eliot Engel E000179 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 19 | |||||||||||||
41271 | 41271 | Pat Roberts R000307 | rep | KS | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
41231 | 41231 | John Lewis L000287 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
41057 | 41057 | Lamar Smith S000583 | rep | TX | 1991-01-03 | 1993-01-03 | Republican | 21 | |||||||||||||
40999 | 40999 | Ileana Ros-Lehtinen R000435 | rep | FL | 1991-01-03 | 1993-01-03 | Republican | 18 | |||||||||||||
40975 | 40975 | Dana Rohrabacher R000409 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 42 | |||||||||||||
40909 | 40909 | Sander Levin L000263 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 17 | |||||||||||||
40882 | 40882 | Sam Johnson J000174 | rep | TX | 1991-01-03 | 1993-01-03 | Republican | 3 | |||||||||||||
40778 | 40778 | John Duncan D000533 | rep | TN | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
40697 | 40697 | Joe Barton B000213 | rep | TX | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
40661 | 40661 | Jon Kyl K000352 | rep | AZ | 1991-01-03 | 1993-01-03 | Republican | 4 | |||||||||||||
40648 | 40648 | John McCain M000303 | sen | AZ | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
40604 | 40604 | Louise Slaughter S000480 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 30 | |||||||||||||
40568 | 40568 | John Conyers C000714 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
40448 | 40448 | Charles Rangel R000053 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 16 | |||||||||||||
40383 | 40383 | Jim McDermott M000404 | rep | WA | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
40236 | 40236 | Harry Reid R000146 | sen | NV | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
40229 | 40229 | Barbara Mikulski M000702 | sen | MD | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
40214 | 40214 | Daniel Coats C000542 | sen | IN | 1989-01-03 | 1993-01-03 | 3 | Republican | appointment | ||||||||||||
40205 | 40205 | Barbara Boxer B000711 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
40154 | 40154 | John Boehner B000589 | rep | OH | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
40134 | 40134 | Howard Coble C000556 | rep | NC | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
40104 | 40104 | Frank Wolf W000672 | rep | VA | 1991-01-03 | 1993-01-03 | Republican | 10 | |||||||||||||
40087 | 40087 | Henry Waxman W000215 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 24 | |||||||||||||
40034 | 40034 | Nick Rahall R000011 | rep | WV | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
40015 | 40015 | Thomas Petri P000265 | rep | WI | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
39997 | 39997 | Ed Pastor P000099 | rep | AZ | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
39982 | 39982 | James Moran M000933 | rep | VA | 1991-01-03 | 1993-01-03 | Democrat | 8 | |||||||||||||
39970 | 39970 | George Miller M000725 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
39861 | 39861 | Ralph Hall H000067 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
39830 | 39830 | Eni Faleomavaega F000010 | rep | AS | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
39817 | 39817 | John Dingell D000355 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 16 | |||||||||||||
39768 | 39768 | Dave Camp C000071 | rep | MI | 1991-01-03 | 1993-01-03 | Republican | 10 | |||||||||||||
39706 | 39706 | Tim Johnson J000177 | rep | SD | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
39667 | 39667 | Robert Andrews A000210 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
39632 | 39632 | C. Young Y000031 | rep | FL | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
39558 | 39558 | Edolphus Towns T000326 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 11 | |||||||||||||
39534 | 39534 | Clifford Stearns S000822 | rep | FL | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
39522 | 39522 | Fortney Stark S000810 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 9 | |||||||||||||
39437 | 39437 | John Olver O000085 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
39389 | 39389 | Jerry Lewis L000274 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 35 | |||||||||||||
39352 | 39352 | Dale Kildee K000172 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
39308 | 39308 | Walter Herger H000528 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
39287 | 39287 | Elton Gallegly G000021 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 21 | |||||||||||||
39274 | 39274 | Barney Frank F000339 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
39258 | 39258 | David Dreier D000492 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 33 | |||||||||||||
39242 | 39242 | Norman Dicks D000327 | rep | WA | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
39221 | 39221 | Jerry Costello C000794 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 21 | |||||||||||||
39197 | 39197 | Dan Burton B001149 | rep | IN | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
39147 | 39147 | Howard Berman B000410 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 26 | |||||||||||||
39088 | 39088 | Gary Ackerman A000022 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
39077 | 39077 | Olympia Snowe S000663 | rep | ME | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
39025 | 39025 | Daniel Inouye I000025 | sen | HI | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
38974 | 38974 | Donald Payne P000149 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 10 | |||||||||||||
38889 | 38889 | Gene Taylor T000074 | rep | MS | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
38871 | 38871 | John Tanner T000038 | rep | TN | 1991-01-03 | 1993-01-03 | Democrat | 8 | |||||||||||||
38851 | 38851 | John Spratt S000749 | rep | SC | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
38815 | 38815 | Ike Skelton S000465 | rep | MO | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
38755 | 38755 | Solomon Ortiz O000107 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 27 | |||||||||||||
38741 | 38741 | David Obey O000007 | rep | WI | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
38720 | 38720 | James Oberstar O000006 | rep | MN | 1991-01-03 | 1993-01-03 | Democrat | 8 | |||||||||||||
38701 | 38701 | John Murtha M001120 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 12 | |||||||||||||
38674 | 38674 | Alan Mollohan M000844 | rep | WV | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
38605 | 38605 | Paul Kanjorski K000008 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 11 | |||||||||||||
38558 | 38558 | Barton Gordon G000309 | rep | TN | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
38525 | 38525 | Thomas Edwards E000063 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 11 |
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);