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 district
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33876 | 33876 | John Danforth D000030 | sen | MO | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
33879 | 33879 | Dennis DeConcini D000185 | sen | AZ | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
33883 | 33883 | David Durenberger D000566 | sen | MN | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
34017 | 34017 | Howard Metzenbaum M000678 | sen | OH | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
34020 | 34020 | George Mitchell M000811 | sen | ME | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
34070 | 34070 | Donald Riegle R000249 | sen | MI | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
34081 | 34081 | James Sasser S000068 | sen | TN | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
34133 | 34133 | Malcolm Wallop W000092 | sen | WY | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
34261 | 34261 | David Boren B000639 | sen | OK | 1991-01-03 | 1995-01-03 | 2 | Democrat | |||||||||||||
35057 | 35057 | Harris Wofford W000665 | sen | PA | 1991-05-08 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
35391 | 35391 | Harlan Mathews M000236 | sen | TN | 1993-01-05 | 1995-01-03 | 2 | Democrat | appointment | ||||||||||||
35717 | 35717 | Richard Bryan B000993 | sen | NV | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
35730 | 35730 | John Chafee C000269 | sen | RI | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
35839 | 35839 | T. Gorton G000333 | sen | WA | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
35882 | 35882 | J. Kerrey K000146 | sen | NE | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
35898 | 35898 | Connie Mack M000019 | sen | FL | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
35947 | 35947 | Daniel Moynihan M001054 | sen | NY | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
35994 | 35994 | Charles Robb R000295 | sen | VA | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
36022 | 36022 | William Roth R000460 | sen | DE | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
36842 | 36842 | Conrad Burns B001126 | sen | MT | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
36983 | 36983 | James Jeffords J000072 | sen | VT | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
37098 | 37098 | Paul Sarbanes S000064 | sen | MD | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
37959 | 37959 | Robert Byrd B001210 | sen | WV | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
38154 | 38154 | Edward Kennedy K000105 | sen | MA | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
38210 | 38210 | Trent Lott L000447 | sen | MS | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
39037 | 39037 | Daniel Akaka A000069 | sen | HI | 1990-05-16 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
39042 | 39042 | Jeff Bingaman B000468 | sen | NM | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
39047 | 39047 | Kent Conrad C000705 | sen | ND | 1992-12-14 | 1995-01-03 | 1 | Democrat | |||||||||||||
39051 | 39051 | Kay Hutchison H001016 | sen | TX | 1993-01-05 | 1995-01-03 | 1 | Republican | |||||||||||||
39055 | 39055 | Herbert Kohl K000305 | sen | WI | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
39059 | 39059 | Joseph Lieberman L000304 | sen | CT | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
39065 | 39065 | Richard Lugar L000504 | sen | IN | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
39605 | 39605 | Frank Lautenberg L000123 | sen | NJ | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
40674 | 40674 | Orrin Hatch H000338 | sen | UT | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
41770 | 41770 | Dianne Feinstein F000062 | sen | CA | 1992-11-10 | 1995-01-03 | 1 | Democrat | |||||||||||||
35678 | 35678 | Ron de Lugo D000209 | rep | VI | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
37197 | 37197 | Robert Underwood U000014 | rep | GU | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
38351 | 38351 | Craig Thomas T000162 | rep | WY | 1993-01-05 | 1995-01-03 | Republican | 0 | |||||||||||||
38479 | 38479 | Michael Castle C000243 | rep | DE | 1993-01-05 | 1995-01-03 | Republican | 0 | |||||||||||||
38766 | 38766 | Earl Pomeroy P000422 | rep | ND | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
39707 | 39707 | Tim Johnson J000177 | rep | SD | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
39831 | 39831 | Eni Faleomavaega F000010 | rep | AS | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
41674 | 41674 | Don Young Y000033 | rep | AK | 1993-01-05 | 1995-01-03 | Republican | 0 | |||||||||||||
41791 | 41791 | Bernard Sanders S000033 | rep | VT | 1993-01-05 | 1995-01-03 | Independent | 0 | Democrat | ||||||||||||
43018 | 43018 | Eleanor Norton N000147 | rep | DC | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
35098 | 35098 | Thomas Andrews A000211 | rep | ME | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35122 | 35122 | Peter Barca B001226 | rep | WI | 1993-05-04 | 1995-01-03 | Democrat | 1 | |||||||||||||
35123 | 35123 | Thomas Barlow B000151 | rep | KY | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35132 | 35132 | James Bilbray B000462 | rep | NV | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35170 | 35170 | Samuel Coppersmith C000767 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35313 | 35313 | Daniel Hamburg H000096 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35325 | 35325 | George Hochbrueckner H000670 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35344 | 35344 | Earl Hutto H001018 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35355 | 35355 | Larry LaRocco L000098 | rep | ID | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35388 | 35388 | Ronald Machtley M000015 | rep | RI | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
35389 | 35389 | David Mann M000100 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35507 | 35507 | Timothy Penny P000215 | rep | MN | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35527 | 35527 | Arthur Ravenel R000072 | rep | SC | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
35668 | 35668 | Jamie Whitten W000428 | rep | MS | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35736 | 35736 | Jim Chapman C000312 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35990 | 35990 | James Quillen Q000013 | rep | TN | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36034 | 36034 | Patricia Schroeder S000142 | rep | CO | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36096 | 36096 | John Williams W000520 | rep | MT | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36111 | 36111 | William Zeliff Z000004 | rep | NH | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36185 | 36185 | Thomas Foglietta F000235 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36190 | 36190 | Elizabeth Furse F000434 | rep | OR | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36278 | 36278 | Barbara Kennelly K000118 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36363 | 36363 | Steven Schiff S000125 | rep | NM | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36497 | 36497 | Herbert Bateman B000229 | rep | VA | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36569 | 36569 | William Clay C000488 | rep | MO | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36682 | 36682 | Robert Livingston L000371 | rep | LA | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36849 | 36849 | H. Callahan C000052 | rep | AL | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36858 | 36858 | Eva Clayton C000494 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36954 | 36954 | James Hansen H000172 | rep | UT | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
37001 | 37001 | Steve Largent L000096 | rep | OK | 1994-11-29 | 1995-01-03 | Republican | 1 | |||||||||||||
37248 | 37248 | Douglas Bereuter B000403 | rep | NE | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
37765 | 37765 | James Leach L000169 | rep | IA | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
37772 | 37772 | Blanche Lincoln L000035 | rep | AR | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
38054 | 38054 | Wayne Gilchrest G000180 | rep | MD | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
38396 | 38396 | Neil Abercrombie A000014 | rep | HI | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
38675 | 38675 | Alan Mollohan M000844 | rep | WV | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
38861 | 38861 | Bart Stupak S001045 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
39438 | 39438 | John Olver O000085 | rep | MA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
39668 | 39668 | Robert Andrews A000210 | rep | NJ | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
39891 | 39891 | Jack Kingston K000220 | rep | GA | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
41272 | 41272 | Pat Roberts R000307 | rep | KS | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
41516 | 41516 | Peter Visclosky V000108 | rep | IN | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
41740 | 41740 | Maria Cantwell C000127 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
43208 | 43208 | Bobby Rush R000515 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35128 | 35128 | Helen Bentley B000392 | rep | MD | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
35134 | 35134 | Lucien Blackwell B000517 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35321 | 35321 | Peter Hoagland H000652 | rep | NE | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35336 | 35336 | William Hughes H000930 | rep | NJ | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35574 | 35574 | Philip Sharp S000294 | rep | IN | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35575 | 35575 | Karen Shepherd S000332 | rep | UT | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35581 | 35581 | James Slattery S000477 | rep | KS | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35607 | 35607 | Richard Swett S001113 | rep | NH | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35615 | 35615 | Allan Swift S001115 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35623 | 35623 | Michael Synar S001139 | rep | OK | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35632 | 35632 | Itimous Valentine V000006 | rep | NC | 1993-01-05 | 1995-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);