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 district
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33456 | 33456 | James Sanford S000055 | sen | NC | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33477 | 33477 | Brockman Adams A000031 | sen | WA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33542 | 33542 | Alan Cranston C000877 | sen | CA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33561 | 33561 | Alan Dixon D000366 | sen | IL | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33583 | 33583 | Wyche Fowler F000329 | sen | GA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33587 | 33587 | Edwin Garn G000072 | sen | UT | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33626 | 33626 | Robert Kasten K000019 | sen | WI | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33747 | 33747 | Warren Rudman R000497 | sen | NH | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33790 | 33790 | Steven Symms S001138 | sen | ID | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33805 | 33805 | Timothy Wirth W000647 | sen | CO | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
34950 | 34950 | John Seymour S000269 | sen | CA | 1991-01-07 | 1993-01-03 | 1 | Republican | appointment | ||||||||||||
35158 | 35158 | Dale Bumpers B001057 | sen | AR | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35172 | 35172 | Alfonse D’Amato D000018 | sen | NY | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
35197 | 35197 | Robert Dole D000401 | sen | KS | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
35263 | 35263 | Wendell Ford F000268 | sen | KY | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35288 | 35288 | John Glenn G000236 | sen | OH | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35491 | 35491 | Robert Packwood P000009 | sen | OR | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
36519 | 36519 | John Breaux B000780 | sen | LA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
36585 | 36585 | Thomas Daschle D000064 | sen | SD | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
36644 | 36644 | Bob Graham G000352 | sen | FL | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
36653 | 36653 | Ernest Hollings H000725 | sen | SC | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
36717 | 36717 | Frank Murkowski M001085 | sen | AK | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
36721 | 36721 | Don Nickles N000102 | sen | OK | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
37544 | 37544 | Christopher Bond B000611 | sen | MO | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
37608 | 37608 | Christopher Dodd D000388 | sen | CT | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
37618 | 37618 | Byron Dorgan D000432 | sen | ND | 1992-12-15 | 1993-01-03 | 3 | Democrat | |||||||||||||
37884 | 37884 | Arlen Specter S000709 | sen | PA | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
39025 | 39025 | Daniel Inouye I000025 | sen | HI | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
40214 | 40214 | Daniel Coats C000542 | sen | IN | 1989-01-03 | 1993-01-03 | 3 | Republican | appointment | ||||||||||||
40229 | 40229 | Barbara Mikulski M000702 | sen | MD | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
40236 | 40236 | Harry Reid R000146 | sen | NV | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
40648 | 40648 | John McCain M000303 | sen | AZ | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
42438 | 42438 | Charles Grassley G000386 | sen | IA | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
42719 | 42719 | Patrick Leahy L000174 | sen | VT | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
43350 | 43350 | Richard Shelby S000320 | sen | AL | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
36857 | 36857 | Eva Clayton C000494 | rep | NC | 1992-11-03 | 1993-01-03 | Democrat | 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 | |||||||||||||
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 | |||||||||||||
34992 | 34992 | Richard Stallings S000785 | rep | ID | 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);