legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "start" is on date 1991-01-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34261 | 34261 | David Boren B000639 | sen | OK | 1991-01-03 | 1995-01-03 | 2 | Democrat | |||||||||||||
34264 | 34264 | William Bradley B001225 | sen | NJ | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34288 | 34288 | George Brown B000919 | sen | CO | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
34314 | 34314 | William Cohen C000598 | sen | ME | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
34441 | 34441 | J. Exon E000284 | sen | NE | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34488 | 34488 | Albert Gore G000321 | sen | TN | 1991-01-03 | 1993-01-02 | 2 | Democrat | |||||||||||||
34537 | 34537 | Mark Hatfield H000343 | sen | OR | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
34545 | 34545 | Howell Heflin H000445 | sen | AL | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34617 | 34617 | John Johnston J000189 | sen | LA | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34640 | 34640 | Nancy Kassebaum K000017 | sen | KS | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
34801 | 34801 | Samuel Nunn N000171 | sen | GA | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34835 | 34835 | Claiborne Pell P000193 | sen | RI | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34845 | 34845 | Larry Pressler P000513 | sen | SD | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
34852 | 34852 | David Pryor P000556 | sen | AR | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34962 | 34962 | Paul Simon S000423 | sen | IL | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34965 | 34965 | Alan Simpson S000429 | sen | WY | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
36226 | 36226 | Phil Gramm G000365 | sen | TX | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
36260 | 36260 | Jesse Helms H000463 | sen | NC | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
36376 | 36376 | Robert Smith S000606 | sen | NH | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
36426 | 36426 | J. Thurmond T000254 | sen | SC | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
36444 | 36444 | Paul Wellstone W000288 | sen | MN | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
37279 | 37279 | Larry Craig C000858 | sen | ID | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
37310 | 37310 | Pete Domenici D000407 | sen | NM | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
37484 | 37484 | Ted Stevens S000888 | sen | AK | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
37510 | 37510 | John Warner W000154 | sen | VA | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
38431 | 38431 | Joseph Biden B000444 | sen | DE | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
39599 | 39599 | John Kerry K000148 | sen | MA | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
39662 | 39662 | Max Baucus B000243 | sen | MT | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
39700 | 39700 | Thomas Harkin H000206 | sen | IA | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
39717 | 39717 | Carl Levin L000261 | sen | MI | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
39724 | 39724 | John Rockefeller R000361 | sen | WV | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
40623 | 40623 | Thad Cochran C000567 | sen | MS | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
41867 | 41867 | Mitch McConnell M000355 | sen | KY | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
34258 | 34258 | Ben Blaz B000551 | rep | GU | 1991-01-03 | 1993-01-03 | Republican | 0 | |||||||||||||
34324 | 34324 | Antonio Colorado C000646 | rep | PR | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
34469 | 34469 | Jaime Fuster F000435 | rep | PR | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
35677 | 35677 | Ron de Lugo D000209 | rep | VI | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
37617 | 37617 | Byron Dorgan D000432 | rep | ND | 1991-01-03 | 1992-12-14 | Democrat | 0 | |||||||||||||
38350 | 38350 | Craig Thomas T000162 | rep | WY | 1991-01-03 | 1993-01-03 | Republican | 0 | |||||||||||||
39830 | 39830 | Eni Faleomavaega F000010 | rep | AS | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
41673 | 41673 | Don Young Y000033 | rep | AK | 1991-01-03 | 1993-01-03 | Republican | 0 | |||||||||||||
41762 | 41762 | Thomas Carper C000174 | rep | DE | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
41790 | 41790 | Bernard Sanders S000033 | rep | VT | 1991-01-03 | 1993-01-03 | Independent | 0 | Democrat | ||||||||||||
43017 | 43017 | Eleanor Norton N000147 | rep | DC | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
34173 | 34173 | William Alexander A000103 | rep | AR | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34219 | 34219 | Les AuCoin A000337 | rep | OR | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34341 | 34341 | Silvio Conte C000709 | rep | MA | 1991-01-03 | 1991-02-08 | Republican | 1 | |||||||||||||
34542 | 34542 | Charles Hayes H000388 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34586 | 34586 | Carroll Hubbard H000878 | rep | KY | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34633 | 34633 | Walter Jones J000256 | rep | NC | 1991-01-03 | 1992-09-15 | Democrat | 1 | |||||||||||||
34695 | 34695 | Charles Luken L000507 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34767 | 34767 | John Miller M000736 | rep | WA | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
34868 | 34868 | John Rhodes R000189 | rep | AZ | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
35002 | 35002 | Robert Thomas T000184 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35097 | 35097 | Thomas Andrews A000211 | rep | ME | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35118 | 35118 | Leslie Aspin A000224 | rep | WI | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35131 | 35131 | James Bilbray B000462 | rep | NV | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35324 | 35324 | George Hochbrueckner H000670 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35343 | 35343 | Earl Hutto H001018 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35354 | 35354 | Larry LaRocco L000098 | rep | ID | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35387 | 35387 | Ronald Machtley M000015 | rep | RI | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
35506 | 35506 | Timothy Penny P000215 | rep | MN | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35526 | 35526 | Arthur Ravenel R000072 | rep | SC | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
35667 | 35667 | Jamie Whitten W000428 | rep | MS | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35735 | 35735 | Jim Chapman C000312 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35989 | 35989 | James Quillen Q000013 | rep | TN | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36033 | 36033 | Patricia Schroeder S000142 | rep | CO | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
36095 | 36095 | John Williams W000520 | rep | MT | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
36110 | 36110 | William Zeliff Z000004 | rep | NH | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36184 | 36184 | Thomas Foglietta F000235 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
36277 | 36277 | Barbara Kennelly K000118 | rep | CT | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
36348 | 36348 | Frank Riggs R000252 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36362 | 36362 | Steven Schiff S000125 | rep | NM | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36496 | 36496 | Herbert Bateman B000229 | rep | VA | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36568 | 36568 | William Clay C000488 | rep | MO | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
36681 | 36681 | Robert Livingston L000371 | rep | LA | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36848 | 36848 | H. Callahan C000052 | rep | AL | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36953 | 36953 | James Hansen H000172 | rep | UT | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
37247 | 37247 | Douglas Bereuter B000403 | rep | NE | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
37764 | 37764 | James Leach L000169 | rep | IA | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
38053 | 38053 | Wayne Gilchrest G000180 | rep | MD | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
38395 | 38395 | Neil Abercrombie A000014 | rep | HI | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
38674 | 38674 | Alan Mollohan M000844 | rep | WV | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
39437 | 39437 | John Olver O000085 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
39667 | 39667 | Robert Andrews A000210 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
39706 | 39706 | Tim Johnson J000177 | rep | SD | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
40568 | 40568 | John Conyers C000714 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
41271 | 41271 | Pat Roberts R000307 | rep | KS | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
41515 | 41515 | Peter Visclosky V000108 | rep | IN | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
41858 | 41858 | James Inhofe I000024 | rep | OK | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
34382 | 34382 | William Dickinson D000326 | rep | AL | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
34398 | 34398 | Thomas Downey D000471 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34495 | 34495 | William Gray G000402 | rep | PA | 1991-01-03 | 1991-09-11 | Democrat | 2 | |||||||||||||
34532 | 34532 | Charles Hatcher H000340 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34562 | 34562 | Joan Horn H000788 | rep | MO | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34713 | 34713 | Ronald Marlenee M000139 | rep | MT | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
34818 | 34818 | Douglas Owens O000156 | rep | UT | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34860 | 34860 | Carl Pursell P000574 | rep | MI | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
34927 | 34927 | Gus Savage S000081 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34988 | 34988 | Harley Staggers S000779 | rep | WV | 1991-01-03 | 1993-01-03 | Democrat | 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);