legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "end" is on date 1997-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34264 | 34264 | William Bradley B001225 | sen | NJ | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34441 | 34441 | J. Exon E000284 | sen | NE | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
35692 | 35692 | Anthony Beilenson B000318 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 24 | |||||||||||||
35707 | 35707 | Tom Bevill B000431 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
35712 | 35712 | William Brewster B000817 | rep | OK | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
35716 | 35716 | John Browder B000897 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
35725 | 35725 | John Bryant B000997 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
35737 | 35737 | Jim Chapman C000312 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
35754 | 35754 | Ronald Coleman C000621 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 16 | |||||||||||||
35757 | 35757 | Barbara-Rose Collins C000633 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 15 | |||||||||||||
35769 | 35769 | Cardiss Collins C000634 | rep | IL | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
35790 | 35790 | Cleo Fields F000110 | rep | LA | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
35810 | 35810 | Harold Ford F000261 | rep | TN | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
35820 | 35820 | Preston Geren G000134 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 12 | |||||||||||||
35837 | 35837 | Sam Gibbons G000153 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 11 | |||||||||||||
35877 | 35877 | Andrew Jacobs J000033 | rep | IN | 1995-01-04 | 1997-01-03 | Democrat | 10 | |||||||||||||
35881 | 35881 | Harry Johnston J000187 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 19 | |||||||||||||
35932 | 35932 | Gillespie Montgomery M000865 | rep | MS | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
35966 | 35966 | William Orton O000108 | rep | UT | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
35971 | 35971 | Lewis Payne P000152 | rep | VA | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
35974 | 35974 | Douglas Peterson P000259 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36007 | 36007 | Charles Rose R000436 | rep | NC | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
36035 | 36035 | Patricia Schroeder S000142 | rep | CO | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36048 | 36048 | Gerry Studds S001040 | rep | MA | 1995-01-04 | 1997-01-03 | Democrat | 10 | |||||||||||||
36055 | 36055 | Raymond Thornton T000243 | rep | AR | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36069 | 36069 | Harold Volkmer V000112 | rep | MO | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
36088 | 36088 | Michael Ward W000139 | rep | KY | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36097 | 36097 | John Williams W000520 | rep | MT | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36109 | 36109 | Charles Wilson W000570 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36131 | 36131 | Eligio de la Garza D000203 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 15 | |||||||||||||
36134 | 36134 | Henry Baesler B000028 | rep | KY | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
36154 | 36154 | Ronald Dellums D000222 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
36171 | 36171 | Victor Fazio F000053 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36177 | 36177 | Floyd Flake F000184 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
36186 | 36186 | Thomas Foglietta F000235 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36191 | 36191 | Elizabeth Furse F000434 | rep | OR | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36220 | 36220 | Henry González G000272 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 20 | |||||||||||||
36243 | 36243 | Lee Hamilton H000114 | rep | IN | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
36255 | 36255 | Willie Hefner H000448 | rep | NC | 1995-01-04 | 1997-01-03 | Democrat | 8 | |||||||||||||
36270 | 36270 | Joseph Kennedy K000110 | rep | MA | 1995-01-04 | 1997-01-03 | Democrat | 8 | |||||||||||||
36279 | 36279 | Barbara Kennelly K000118 | rep | CT | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36293 | 36293 | Thomas Manton M000117 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
36314 | 36314 | Paul McHale M000466 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 15 | |||||||||||||
36337 | 36337 | Glenn Poshard P000452 | rep | IL | 1995-01-04 | 1997-01-03 | Democrat | 19 | |||||||||||||
36346 | 36346 | William Richardson R000229 | rep | NM | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36351 | 36351 | Carlos Romero-Barceló R000417 | rep | PR | 1993-01-05 | 1997-01-03 | Democrat | 0 | |||||||||||||
36370 | 36370 | David Skaggs S000462 | rep | CO | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36411 | 36411 | Louis Stokes S000948 | rep | OH | 1995-01-04 | 1997-01-03 | Democrat | 11 | |||||||||||||
36414 | 36414 | Frank Tejeda T000113 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 28 | |||||||||||||
36434 | 36434 | Esteban Torres T000316 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 34 | |||||||||||||
36442 | 36442 | Robert Torricelli T000317 | rep | NJ | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
36444 | 36444 | Paul Wellstone W000288 | sen | MN | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
36470 | 36470 | Sidney Yates Y000013 | rep | IL | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
36537 | 36537 | George Brown B000918 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 42 | |||||||||||||
36570 | 36570 | William Clay C000488 | rep | MO | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36578 | 36578 | Pat Danner D000046 | rep | MO | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
36600 | 36600 | Julian Dixon D000373 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 32 | |||||||||||||
36628 | 36628 | Sam Gejdenson G000120 | rep | CT | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36666 | 36666 | Ron Klink K000270 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
36693 | 36693 | Matthew Martínez M000206 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 31 | |||||||||||||
36713 | 36713 | David Minge M000795 | rep | MN | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36739 | 36739 | Owen Pickett P000326 | rep | VA | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36764 | 36764 | Bruce Vento V000087 | rep | MN | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
36775 | 36775 | Robert Wise W000654 | rep | WV | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36790 | 36790 | John Baldacci B000081 | rep | ME | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36795 | 36795 | James Barcia B000134 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
36804 | 36804 | Thomas Barrett B000177 | rep | WI | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
36808 | 36808 | Ken Bentsen B000400 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 25 | |||||||||||||
36824 | 36824 | David Bonior B000619 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 10 | |||||||||||||
36834 | 36834 | Robert Borski B000644 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36859 | 36859 | Eva Clayton C000494 | rep | NC | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36867 | 36867 | Robert Clement C000503 | rep | TN | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
36874 | 36874 | Gary Condit C000670 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 18 | |||||||||||||
36889 | 36889 | William Coyne C000846 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 14 | |||||||||||||
36944 | 36944 | Tony Hall H000074 | rep | OH | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36964 | 36964 | Earl Hilliard H000621 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
36997 | 36997 | John LaFalce L000556 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 29 | |||||||||||||
37006 | 37006 | William Luther L000521 | rep | MN | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
37013 | 37013 | Frank Mascara M000212 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 20 | |||||||||||||
37018 | 37018 | Carrie Meek M000628 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 17 | |||||||||||||
37036 | 37036 | Patsy Mink M000797 | rep | HI | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
37051 | 37051 | John Moakley M000834 | rep | MA | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
37068 | 37068 | Lynn Rivers R000281 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 13 | |||||||||||||
37074 | 37074 | Timothy Roemer R000385 | rep | IN | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
37105 | 37105 | Thomas Sawyer S000094 | rep | OH | 1995-01-04 | 1997-01-03 | Democrat | 14 | |||||||||||||
37139 | 37139 | Norman Sisisky S000453 | rep | VA | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
37184 | 37184 | Karen Thurman T000253 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
37193 | 37193 | James Traficant T000350 | rep | OH | 1995-01-04 | 1997-01-03 | Democrat | 17 | |||||||||||||
37198 | 37198 | Robert Underwood U000014 | rep | GU | 1995-01-04 | 1997-01-03 | Democrat | 0 | |||||||||||||
37301 | 37301 | Peter Deutsch D000275 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 20 | |||||||||||||
37315 | 37315 | Calvin Dooley D000424 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 20 | |||||||||||||
37337 | 37337 | Jonas Frost F000392 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 24 | |||||||||||||
37351 | 37351 | Richard Gephardt G000132 | rep | MO | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
37395 | 37395 | Gerald Kleczka K000259 | rep | WI | 1995-01-04 | 1997-01-03 | Democrat | 4 |
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);