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 state descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33851 | 33851 | Richard Cheney C000344 | rep | WY | 1989-01-03 | 1990-03-17 | Republican | 0 | |||||||||||||
34133 | 34133 | Malcolm Wallop W000092 | sen | WY | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
38349 | 38349 | Craig Thomas T000162 | rep | WY | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
34987 | 34987 | Harley Staggers S000779 | rep | WV | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
36772 | 36772 | Robert Wise W000654 | rep | WV | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
37959 | 37959 | Robert Byrd B001210 | sen | WV | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
38673 | 38673 | Alan Mollohan M000844 | rep | WV | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
40033 | 40033 | Nick Rahall R000011 | rep | WV | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
33973 | 33973 | Robert Kastenmeier K000020 | rep | WI | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34771 | 34771 | Jim Moody M000881 | rep | WI | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
35117 | 35117 | Leslie Aspin A000224 | rep | WI | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
35847 | 35847 | Steven Gunderson G000524 | rep | WI | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
36013 | 36013 | Toby Roth R000459 | rep | WI | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
37392 | 37392 | Gerald Kleczka K000259 | rep | WI | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
38740 | 38740 | David Obey O000007 | rep | WI | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
39055 | 39055 | Herbert Kohl K000305 | sen | WI | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
40014 | 40014 | Thomas Petri P000265 | rep | WI | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
41450 | 41450 | F. Sensenbrenner S000244 | rep | WI | 1989-01-03 | 1991-01-03 | Republican | 9 | |||||||||||||
34307 | 34307 | Rodney Chandler C000293 | rep | WA | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
34766 | 34766 | John Miller M000736 | rep | WA | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
34777 | 34777 | Sidney Morrison M000999 | rep | WA | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
35257 | 35257 | Thomas Foley F000239 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
35613 | 35613 | Allan Swift S001115 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
35624 | 35624 | Jolene Unsoeld U000017 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
35839 | 35839 | T. Gorton G000333 | sen | WA | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
39241 | 39241 | Norman Dicks D000327 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
40382 | 40382 | Jim McDermott M000404 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
34102 | 34102 | Peter Smith S000601 | rep | VT | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
36983 | 36983 | James Jeffords J000072 | sen | VT | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
35676 | 35676 | Ron de Lugo D000209 | rep | VI | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
34039 | 34039 | Stanford Parris P000080 | rep | VA | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
34813 | 34813 | James Olin O000069 | rep | VA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34968 | 34968 | Daniel Slaughter S000479 | rep | VA | 1989-01-03 | 1991-01-03 | Republican | 7 | |||||||||||||
35968 | 35968 | Lewis Payne P000152 | rep | VA | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
35994 | 35994 | Charles Robb R000295 | sen | VA | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
36495 | 36495 | Herbert Bateman B000229 | rep | VA | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
36505 | 36505 | Tom Bliley B000556 | rep | VA | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
36736 | 36736 | Owen Pickett P000326 | rep | VA | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
37136 | 37136 | Norman Sisisky S000453 | rep | VA | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
38439 | 38439 | Frederick Boucher B000657 | rep | VA | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
40103 | 40103 | Frank Wolf W000672 | rep | VA | 1989-01-03 | 1991-01-03 | Republican | 10 | |||||||||||||
34033 | 34033 | Howard Nielson N000106 | rep | UT | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
34817 | 34817 | Douglas Owens O000156 | rep | UT | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
36952 | 36952 | James Hansen H000172 | rep | UT | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
40674 | 40674 | Orrin Hatch H000338 | sen | UT | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
33821 | 33821 | Lloyd Bentsen B000401 | sen | TX | 1989-01-03 | 1993-12-31 | 1 | Democrat | |||||||||||||
33979 | 33979 | James Leath L000180 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
33985 | 33985 | George Leland L000237 | rep | TX | 1989-01-03 | 1989-08-07 | Democrat | 18 | |||||||||||||
34159 | 34159 | James Wright W000763 | rep | TX | 1989-01-03 | 1989-06-30 | Democrat | 12 | |||||||||||||
34231 | 34231 | Harry Bartlett B000204 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
34295 | 34295 | Albert Bustamante B001172 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 23 | |||||||||||||
35094 | 35094 | Michael Andrews A000209 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 25 | |||||||||||||
35153 | 35153 | Jack Brooks B000880 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
35521 | 35521 | James Pickle P000328 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 10 | |||||||||||||
35561 | 35561 | William Sarpalius S000066 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 13 | |||||||||||||
35633 | 35633 | Craig Washington W000177 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 18 | |||||||||||||
35722 | 35722 | John Bryant B000997 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
35734 | 35734 | Jim Chapman C000312 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
35751 | 35751 | Ronald Coleman C000621 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 16 | |||||||||||||
35795 | 35795 | Jack Fields F000111 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
35817 | 35817 | Preston Geren G000134 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 12 | |||||||||||||
35884 | 35884 | Gregory Laughlin L000119 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 14 | |||||||||||||
36106 | 36106 | Charles Wilson W000570 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
36128 | 36128 | Eligio de la Garza D000203 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 15 | |||||||||||||
36217 | 36217 | Henry González G000272 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 20 | |||||||||||||
36481 | 36481 | Bill Archer A000215 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 7 | |||||||||||||
36783 | 36783 | Richard Armey A000217 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 26 | |||||||||||||
37266 | 37266 | Larry Combest C000653 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 19 | |||||||||||||
37334 | 37334 | Jonas Frost F000392 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 24 | |||||||||||||
37472 | 37472 | Charles Stenholm S000851 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 17 | |||||||||||||
37595 | 37595 | Thomas DeLay D000217 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 22 | |||||||||||||
38754 | 38754 | Solomon Ortiz O000107 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 27 | |||||||||||||
39860 | 39860 | Ralph Hall H000067 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
40696 | 40696 | Joe Barton B000213 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
41056 | 41056 | Lamar Smith S000583 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 21 | |||||||||||||
34081 | 34081 | James Sasser S000068 | sen | TN | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
35380 | 35380 | Marilyn Lloyd L000381 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
35603 | 35603 | Donald Sundquist S001075 | rep | TN | 1989-01-03 | 1991-01-03 | Republican | 7 | |||||||||||||
35807 | 35807 | Harold Ford F000261 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
35988 | 35988 | James Quillen Q000013 | rep | TN | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
36864 | 36864 | Robert Clement C000503 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
38557 | 38557 | Barton Gordon G000309 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
38870 | 38870 | John Tanner T000038 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
40777 | 40777 | John Duncan D000533 | rep | TN | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
42201 | 42201 | Jim Cooper C000754 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
39705 | 39705 | Tim Johnson J000177 | rep | SD | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34820 | 34820 | Elizabeth Patterson P000112 | rep | SC | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34996 | 34996 | Robert Tallon T000034 | rep | SC | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
35187 | 35187 | Butler Derrick D000267 | rep | SC | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
35525 | 35525 | Arthur Ravenel R000072 | rep | SC | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
37163 | 37163 | Floyd Spence S000718 | rep | SC | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
38850 | 38850 | John Spratt S000749 | rep | SC | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
34086 | 34086 | Claudine Schneider S000136 | rep | RI | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
35386 | 35386 | Ronald Machtley M000015 | rep | RI | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
35730 | 35730 | John Chafee C000269 | sen | RI | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
34468 | 34468 | Jaime Fuster F000435 | rep | PR | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
33952 | 33952 | Henry Heinz H000456 | sen | PA | 1989-01-03 | 1991-12-31 | 1 | Republican | |||||||||||||
34130 | 34130 | Douglas Walgren W000044 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 18 | |||||||||||||
34352 | 34352 | Robert Coughlin C000807 | rep | PA | 1989-01-03 | 1991-01-03 | Republican | 13 | |||||||||||||
34481 | 34481 | Joseph Gaydos G000105 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 20 |
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);