legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1989-01-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41672 | 41672 | Don Young Y000033 | rep | AK | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
39631 | 39631 | C. Young Y000031 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
35088 | 35088 | Gus Yatron Y000014 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
36467 | 36467 | Sidney Yates Y000013 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
35076 | 35076 | Chalmers Wylie W000781 | rep | OH | 1989-01-03 | 1991-01-03 | Republican | 15 | |||||||||||||
43634 | 43634 | Ron Wyden W000779 | rep | OR | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34159 | 34159 | James Wright W000763 | rep | TX | 1989-01-03 | 1989-06-30 | Democrat | 12 | |||||||||||||
35063 | 35063 | Howard Wolpe W000682 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
40103 | 40103 | Frank Wolf W000672 | rep | VA | 1989-01-03 | 1991-01-03 | Republican | 10 | |||||||||||||
36772 | 36772 | Robert Wise W000654 | rep | WV | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34141 | 34141 | Pete Wilson W000607 | sen | CA | 1989-01-03 | 1991-12-31 | 1 | Republican | |||||||||||||
36106 | 36106 | Charles Wilson W000570 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
36094 | 36094 | John Williams W000520 | rep | MT | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
35666 | 35666 | Jamie Whitten W000428 | rep | MS | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34139 | 34139 | Robert Whittaker W000426 | rep | KS | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
35639 | 35639 | Alan Wheat W000326 | rep | MO | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
37923 | 37923 | W. Weldon W000268 | rep | PA | 1989-01-03 | 1991-01-03 | Republican | 7 | |||||||||||||
35055 | 35055 | Theodore Weiss W000258 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 17 | |||||||||||||
35047 | 35047 | John Weber W000237 | rep | MN | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
40086 | 40086 | Henry Waxman W000215 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 24 | |||||||||||||
37208 | 37208 | Wes Watkins W000194 | rep | OK | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
35633 | 35633 | Craig Washington W000177 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 18 | |||||||||||||
38355 | 38355 | James Walsh W000099 | rep | NY | 1989-01-03 | 1991-01-03 | Republican | 27 | |||||||||||||
34133 | 34133 | Malcolm Wallop W000092 | sen | WY | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
36084 | 36084 | Robert Walker W000068 | rep | PA | 1989-01-03 | 1991-01-03 | Republican | 16 | |||||||||||||
34130 | 34130 | Douglas Walgren W000044 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 18 | |||||||||||||
36073 | 36073 | Barbara Vucanovich V000124 | rep | NV | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
36066 | 36066 | Harold Volkmer V000112 | rep | MO | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
41514 | 41514 | Peter Visclosky V000108 | rep | IN | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
36761 | 36761 | Bruce Vento V000087 | rep | MN | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
35041 | 35041 | Guy Vander Jagt V000027 | rep | MI | 1989-01-03 | 1991-01-03 | Republican | 9 | |||||||||||||
35630 | 35630 | Itimous Valentine V000006 | rep | NC | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
43513 | 43513 | Fred Upton U000031 | rep | MI | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
35624 | 35624 | Jolene Unsoeld U000017 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
35027 | 35027 | Morris Udall U000001 | rep | AZ | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
35011 | 35011 | Jerome Traxler T000356 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
37190 | 37190 | James Traficant T000350 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 17 | |||||||||||||
39557 | 39557 | Edolphus Towns T000326 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
36439 | 36439 | Robert Torricelli T000317 | rep | NJ | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
36431 | 36431 | Esteban Torres T000316 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 34 | |||||||||||||
37911 | 37911 | William Thomas T000188 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 20 | |||||||||||||
35001 | 35001 | Robert Thomas T000184 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
38349 | 38349 | Craig Thomas T000162 | rep | WY | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
38888 | 38888 | Gene Taylor T000074 | rep | MS | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
37496 | 37496 | William Tauzin T000058 | rep | LA | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34123 | 34123 | Thomas Tauke T000053 | rep | IA | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
38870 | 38870 | John Tanner T000038 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
34996 | 34996 | Robert Tallon T000034 | rep | SC | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
38334 | 38334 | Christopher Shays S001144 | rep | CT | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
35621 | 35621 | Michael Synar S001139 | rep | OK | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
35613 | 35613 | Allan Swift S001115 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
35603 | 35603 | Donald Sundquist S001075 | rep | TN | 1989-01-03 | 1991-01-03 | Republican | 7 | |||||||||||||
37176 | 37176 | Robert Stump S001044 | rep | AZ | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
36045 | 36045 | Gerry Studds S001040 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 10 | |||||||||||||
36408 | 36408 | Louis Stokes S000948 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 21 | |||||||||||||
37472 | 37472 | Charles Stenholm S000851 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 17 | |||||||||||||
39533 | 39533 | Clifford Stearns S000822 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
39521 | 39521 | Fortney Stark S000810 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
34117 | 34117 | Arlan Stangeland S000795 | rep | MN | 1989-01-03 | 1991-01-03 | Republican | 7 | |||||||||||||
34991 | 34991 | Richard Stallings S000785 | rep | ID | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34987 | 34987 | Harley Staggers S000779 | rep | WV | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
38850 | 38850 | John Spratt S000749 | rep | SC | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
37163 | 37163 | Floyd Spence S000718 | rep | SC | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
36393 | 36393 | Gerald Solomon S000675 | rep | NY | 1989-01-03 | 1991-01-03 | Republican | 24 | |||||||||||||
34982 | 34982 | Stephen Solarz S000673 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 13 | |||||||||||||
39076 | 39076 | Olympia Snowe S000663 | rep | ME | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
34110 | 34110 | Virginia Smith S000622 | rep | NE | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
36383 | 36383 | Robert Smith S000607 | rep | OR | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
36374 | 36374 | Robert Smith S000606 | rep | NH | 1989-01-03 | 1990-12-07 | Republican | 1 | |||||||||||||
34102 | 34102 | Peter Smith S000601 | rep | VT | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
35597 | 35597 | Neal Smith S000596 | rep | IA | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34973 | 34973 | Lawrence Smith S000586 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 16 | |||||||||||||
34101 | 34101 | Larkin Smith S000584 | rep | MS | 1989-01-03 | 1989-08-13 | Republican | 5 | |||||||||||||
41056 | 41056 | Lamar Smith S000583 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 21 | |||||||||||||
34100 | 34100 | Dennis Smith S000527 | rep | OR | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
43415 | 43415 | Christopher Smith S000522 | rep | NJ | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
40603 | 40603 | Louise Slaughter S000480 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 30 | |||||||||||||
34968 | 34968 | Daniel Slaughter S000479 | rep | VA | 1989-01-03 | 1991-01-03 | Republican | 7 | |||||||||||||
35579 | 35579 | James Slattery S000477 | rep | KS | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
38814 | 38814 | Ike Skelton S000465 | rep | MO | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
37147 | 37147 | Joseph Skeen S000463 | rep | NM | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
36367 | 36367 | David Skaggs S000462 | rep | CO | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
37136 | 37136 | Norman Sisisky S000453 | rep | VA | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34954 | 34954 | Gerald Sikorski S000407 | rep | MN | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
37126 | 37126 | Elmer Shuster S000394 | rep | PA | 1989-01-03 | 1991-01-03 | Republican | 9 | |||||||||||||
34095 | 34095 | Norman Shumway S000393 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 14 | |||||||||||||
37866 | 37866 | E. Shaw S000303 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 15 | |||||||||||||
35572 | 35572 | Philip Sharp S000294 | rep | IN | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
41466 | 41466 | José Serrano S000248 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 18 | |||||||||||||
41450 | 41450 | F. Sensenbrenner S000244 | rep | WI | 1989-01-03 | 1991-01-03 | Republican | 9 | |||||||||||||
43290 | 43290 | Charles Schumer S000148 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 10 | |||||||||||||
34948 | 34948 | Richard Schulze S000146 | rep | PA | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
34089 | 34089 | Bill Schuette S000143 | rep | MI | 1989-01-03 | 1991-01-03 | Republican | 10 | |||||||||||||
36032 | 36032 | Patricia Schroeder S000142 | rep | CO | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34086 | 34086 | Claudine Schneider S000136 | rep | RI | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
36361 | 36361 | Steven Schiff S000125 | rep | NM | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
34939 | 34939 | James Scheuer S000124 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
36356 | 36356 | Daniel Schaefer S000109 | rep | CO | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
38323 | 38323 | H. Saxton S000097 | rep | NJ | 1989-01-03 | 1991-01-03 | Republican | 13 | |||||||||||||
37102 | 37102 | Thomas Sawyer S000094 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 14 |
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);