legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
474 rows where "end" is on date 1995-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: start, class, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44429 | 44429 | Kweisi Mfume M000687 | rep | MD | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
43636 | 43636 | Ron Wyden W000779 | rep | OR | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
43570 | 43570 | Maxine Waters W000187 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 35 | |||||||||||||
43538 | 43538 | Nydia Velázquez V000081 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 12 | |||||||||||||
43515 | 43515 | Fred Upton U000031 | rep | MI | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
43450 | 43450 | Bennie Thompson T000193 | rep | MS | 1993-04-13 | 1995-01-03 | Democrat | 2 | |||||||||||||
43417 | 43417 | Christopher Smith S000522 | rep | NJ | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
43321 | 43321 | Robert Scott S000185 | rep | VA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
43292 | 43292 | Charles Schumer S000148 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
43208 | 43208 | Bobby Rush R000515 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
43181 | 43181 | Lucille Roybal-Allard R000486 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 33 | |||||||||||||
43156 | 43156 | Harold Rogers R000395 | rep | KY | 1993-01-05 | 1995-01-03 | Republican | 5 | |||||||||||||
43129 | 43129 | David Price P000523 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
43110 | 43110 | Robert Portman P000449 | rep | OH | 1993-05-04 | 1995-01-03 | Republican | 2 | |||||||||||||
43075 | 43075 | Nancy Pelosi P000197 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
43042 | 43042 | Frank Pallone P000034 | rep | NJ | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
43018 | 43018 | Eleanor Norton N000147 | rep | DC | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
43002 | 43002 | Richard Neal N000015 | rep | MA | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
42973 | 42973 | Jerrold Nadler N000002 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
42824 | 42824 | Edward Markey M000133 | rep | MA | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
42800 | 42800 | Carolyn Maloney M000087 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 14 | |||||||||||||
42760 | 42760 | Frank Lucas L000491 | rep | OK | 1993-05-10 | 1995-01-03 | Republican | 6 | |||||||||||||
42617 | 42617 | Marcy Kaptur K000009 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
42579 | 42579 | Eddie Johnson J000126 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 30 | |||||||||||||
42538 | 42538 | Steny Hoyer H000874 | rep | MD | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
42363 | 42363 | Anna Eshoo E000215 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 14 | |||||||||||||
42298 | 42298 | Rosa DeLauro D000216 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
42269 | 42269 | Peter DeFazio D000191 | rep | OR | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
42231 | 42231 | Michael Crapo C000880 | rep | ID | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
42203 | 42203 | Jim Cooper C000754 | rep | TN | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
42158 | 42158 | James Clyburn C000537 | rep | SC | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
42060 | 42060 | Ken Calvert C000059 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 43 | |||||||||||||
41943 | 41943 | Sanford Bishop B000490 | rep | GA | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
41877 | 41877 | John Reed R000122 | rep | RI | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
41841 | 41841 | Richard Durbin D000563 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 20 | |||||||||||||
41791 | 41791 | Bernard Sanders S000033 | rep | VT | 1993-01-05 | 1995-01-03 | Independent | 0 | Democrat | ||||||||||||
41779 | 41779 | Robert Menendez M000639 | rep | NJ | 1993-01-05 | 1995-01-03 | Democrat | 13 | |||||||||||||
41770 | 41770 | Dianne Feinstein F000062 | sen | CA | 1992-11-10 | 1995-01-03 | 1 | Democrat | |||||||||||||
41748 | 41748 | Benjamin Cardin C000141 | rep | MD | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
41740 | 41740 | Maria Cantwell C000127 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
41730 | 41730 | Sherrod Brown B000944 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 13 | |||||||||||||
41674 | 41674 | Don Young Y000033 | rep | AK | 1993-01-05 | 1995-01-03 | Republican | 0 | |||||||||||||
41631 | 41631 | Alcee Hastings H000324 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 23 | |||||||||||||
41516 | 41516 | Peter Visclosky V000108 | rep | IN | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
41468 | 41468 | José Serrano S000248 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 16 | |||||||||||||
41452 | 41452 | F. Sensenbrenner S000244 | rep | WI | 1993-01-05 | 1995-01-03 | Republican | 9 | |||||||||||||
41420 | 41420 | Collin Peterson P000258 | rep | MN | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
41391 | 41391 | Nita Lowey L000480 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 18 | |||||||||||||
41351 | 41351 | Peter King K000210 | rep | NY | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
41329 | 41329 | Eliot Engel E000179 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 17 | |||||||||||||
41272 | 41272 | Pat Roberts R000307 | rep | KS | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
41232 | 41232 | John Lewis L000287 | rep | GA | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
41058 | 41058 | Lamar Smith S000583 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 21 | |||||||||||||
41023 | 41023 | Edward Royce R000487 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 39 | |||||||||||||
41000 | 41000 | Ileana Ros-Lehtinen R000435 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 18 | |||||||||||||
40976 | 40976 | Dana Rohrabacher R000409 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 45 | |||||||||||||
40910 | 40910 | Sander Levin L000263 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 12 | |||||||||||||
40883 | 40883 | Sam Johnson J000174 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
40847 | 40847 | Luis Gutiérrez G000535 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
40834 | 40834 | Gene Green G000410 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 29 | |||||||||||||
40817 | 40817 | Bob Goodlatte G000289 | rep | VA | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
40779 | 40779 | John Duncan D000533 | rep | TN | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
40698 | 40698 | Joe Barton B000213 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
40674 | 40674 | Orrin Hatch H000338 | sen | UT | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
40662 | 40662 | Jon Kyl K000352 | rep | AZ | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
40605 | 40605 | Louise Slaughter S000480 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 28 | |||||||||||||
40569 | 40569 | John Conyers C000714 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 14 | |||||||||||||
40512 | 40512 | Xavier Becerra B000287 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 30 | |||||||||||||
40449 | 40449 | Charles Rangel R000053 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
40396 | 40396 | John Mica M000689 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 7 | |||||||||||||
40384 | 40384 | Jim McDermott M000404 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
40296 | 40296 | Sam Farr F000030 | rep | CA | 1993-06-08 | 1995-01-03 | Democrat | 17 | |||||||||||||
40255 | 40255 | Corrine Brown B000911 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
40155 | 40155 | John Boehner B000589 | rep | OH | 1993-01-05 | 1995-01-03 | Republican | 8 | |||||||||||||
40135 | 40135 | Howard Coble C000556 | rep | NC | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
40105 | 40105 | Frank Wolf W000672 | rep | VA | 1993-01-05 | 1995-01-03 | Republican | 10 | |||||||||||||
40088 | 40088 | Henry Waxman W000215 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 29 | |||||||||||||
40035 | 40035 | Nick Rahall R000011 | rep | WV | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
40016 | 40016 | Thomas Petri P000265 | rep | WI | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
39998 | 39998 | Ed Pastor P000099 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
39983 | 39983 | James Moran M000933 | rep | VA | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
39971 | 39971 | George Miller M000725 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
39937 | 39937 | Howard McKeon M000508 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 25 | |||||||||||||
39891 | 39891 | Jack Kingston K000220 | rep | GA | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
39862 | 39862 | Ralph Hall H000067 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
39831 | 39831 | Eni Faleomavaega F000010 | rep | AS | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
39818 | 39818 | John Dingell D000355 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 16 | |||||||||||||
39769 | 39769 | Dave Camp C000071 | rep | MI | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
39738 | 39738 | Spencer Bachus B000013 | rep | AL | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
39707 | 39707 | Tim Johnson J000177 | rep | SD | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
39668 | 39668 | Robert Andrews A000210 | rep | NJ | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
39645 | 39645 | Melvin Watt W000207 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 12 | |||||||||||||
39633 | 39633 | C. Young Y000031 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 10 | |||||||||||||
39605 | 39605 | Frank Lautenberg L000123 | sen | NJ | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
39571 | 39571 | Lynn Woolsey W000738 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
39559 | 39559 | Edolphus Towns T000326 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 10 | |||||||||||||
39535 | 39535 | Clifford Stearns S000822 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
39523 | 39523 | Fortney Stark S000810 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 13 | |||||||||||||
39438 | 39438 | John Olver O000085 | rep | MA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
39413 | 39413 | Donald Manzullo M001138 | rep | IL | 1993-01-05 | 1995-01-03 | Republican | 16 |
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);