legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
35 rows where "end" is on date 1995-01-03 and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: start
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 |
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);