legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
477 rows where "start" is on date 1979-01-15 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31945 | 31945 | Howard Baker B000063 | sen | TN | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32115 | 32115 | Walter Huddleston H000905 | sen | KY | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
32130 | 32130 | Roger Jepsen J000101 | sen | IA | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32234 | 32234 | Charles Percy P000222 | sen | IL | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32252 | 32252 | Jennings Randolph R000046 | sen | WV | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
32347 | 32347 | John Tower T000322 | sen | TX | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32354 | 32354 | Paul Tsongas T000393 | sen | MA | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
33228 | 33228 | William Armstrong A000219 | sen | CO | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
33241 | 33241 | Rudolph Boschwitz B000647 | sen | MN | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
33314 | 33314 | Gordon Humphrey H000951 | sen | NH | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
33356 | 33356 | James McClure M000346 | sen | ID | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
34259 | 34259 | David Boren B000639 | sen | OK | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34262 | 34262 | William Bradley B001225 | sen | NJ | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34312 | 34312 | William Cohen C000598 | sen | ME | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
34439 | 34439 | J. Exon E000284 | sen | NE | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34535 | 34535 | Mark Hatfield H000343 | sen | OR | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
34543 | 34543 | Howell Heflin H000445 | sen | AL | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34615 | 34615 | John Johnston J000189 | sen | LA | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34638 | 34638 | Nancy Kassebaum K000017 | sen | KS | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
34799 | 34799 | Samuel Nunn N000171 | sen | GA | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34833 | 34833 | Claiborne Pell P000193 | sen | RI | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34843 | 34843 | Larry Pressler P000513 | sen | SD | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
34850 | 34850 | David Pryor P000556 | sen | AR | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34963 | 34963 | Alan Simpson S000429 | sen | WY | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
36258 | 36258 | Jesse Helms H000463 | sen | NC | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
36424 | 36424 | J. Thurmond T000254 | sen | SC | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
37308 | 37308 | Pete Domenici D000407 | sen | NM | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
37482 | 37482 | Ted Stevens S000888 | sen | AK | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
37508 | 37508 | John Warner W000154 | sen | VA | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
38429 | 38429 | Joseph Biden B000444 | sen | DE | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
39660 | 39660 | Max Baucus B000243 | sen | MT | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
39715 | 39715 | Carl Levin L000261 | sen | MI | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
40621 | 40621 | Thad Cochran C000567 | sen | MS | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32056 | 32056 | Melvin Evans E000254 | rep | VI | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
32443 | 32443 | Mark Andrews A000208 | rep | ND | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
32633 | 32633 | Thomas Evans E000258 | rep | DE | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
32853 | 32853 | James Santini S000058 | rep | NV | 1979-01-15 | 1981-01-03 | Democrat | 0 | |||||||||||||
32937 | 32937 | Baltasar Corrada-del Río C000788 | rep | PR | 1979-01-15 | 1981-01-03 | New Progressive | 0 | |||||||||||||
33188 | 33188 | Antonio Won Pat W000686 | rep | GU | 1979-01-15 | 1981-01-03 | Democrat | 0 | |||||||||||||
33846 | 33846 | Richard Cheney C000344 | rep | WY | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
33893 | 33893 | Walter Fauntroy F000046 | rep | DC | 1979-01-15 | 1981-01-03 | Democrat | 0 | |||||||||||||
36978 | 36978 | James Jeffords J000072 | rep | VT | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
41667 | 41667 | Don Young Y000033 | rep | AK | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
31952 | 31952 | Robert Bauman B000244 | rep | MD | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32014 | 32014 | Mendel Davis D000125 | rep | SC | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32141 | 32141 | Harold Johnson J000135 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32178 | 32178 | Koln McKay M000490 | rep | UT | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32212 | 32212 | Michael Myers M001132 | rep | PA | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32282 | 32282 | Keith Sebelius S000217 | rep | KS | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32330 | 32330 | Bennett Stewart S000902 | rep | IL | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32474 | 32474 | Adam Benjamin B000363 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32578 | 32578 | William Cotter C000799 | rep | CT | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32618 | 32618 | David Emery E000175 | rep | ME | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32620 | 32620 | Arlen Erdahl E000198 | rep | MN | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32676 | 32676 | Ronald Ginn G000226 | rep | GA | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32788 | 32788 | Robert Mollohan M000845 | rep | WV | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32836 | 32836 | John Rhodes R000188 | rep | AZ | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32945 | 32945 | Norman D’Amours D000017 | rep | NH | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32955 | 32955 | William Edwards E000084 | rep | AL | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
33108 | 33108 | Joel Pritchard P000546 | rep | WA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
33163 | 33163 | Paul Trible T000367 | rep | VA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
33247 | 33247 | William Carney C000165 | rep | NY | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
33285 | 33285 | Sam Hall H000070 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
33293 | 33293 | Cecil Heftel H000449 | rep | HI | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
33319 | 33319 | James Jones J000232 | rep | OK | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
33662 | 33662 | Manuel Luján L000506 | rep | NM | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
33757 | 33757 | Fernand St. Germain S000762 | rep | RI | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
33788 | 33788 | Steven Symms S001138 | rep | ID | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
33908 | 33908 | James Florio F000215 | rep | NJ | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34167 | 34167 | William Alexander A000103 | rep | AR | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34213 | 34213 | Les AuCoin A000337 | rep | OR | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34335 | 34335 | Silvio Conte C000709 | rep | MA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
34580 | 34580 | Carroll Hubbard H000878 | rep | KY | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34627 | 34627 | Walter Jones J000256 | rep | NC | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
35112 | 35112 | Leslie Aspin A000224 | rep | WI | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
35301 | 35301 | Willis Gradison G000349 | rep | OH | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
35337 | 35337 | Earl Hutto H001018 | rep | FL | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
35661 | 35661 | Jamie Whitten W000428 | rep | MS | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
35983 | 35983 | James Quillen Q000013 | rep | TN | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
36027 | 36027 | Patricia Schroeder S000142 | rep | CO | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
36089 | 36089 | John Williams W000520 | rep | MT | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
36562 | 36562 | William Clay C000488 | rep | MO | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
36581 | 36581 | Thomas Daschle D000064 | rep | SD | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
36675 | 36675 | Robert Livingston L000371 | rep | LA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
37241 | 37241 | Douglas Bereuter B000403 | rep | NE | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
37758 | 37758 | James Leach L000169 | rep | IA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
40562 | 40562 | John Conyers C000714 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
31955 | 31955 | Edward Beard B000279 | rep | RI | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
31990 | 31990 | John Cavanaugh C000261 | rep | NE | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
31999 | 31999 | James Cleveland C000512 | rep | NH | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32160 | 32160 | Marvin Mathis M000244 | rep | GA | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32208 | 32208 | Morgan Murphy M001101 | rep | IL | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32268 | 32268 | Harold Runnels R000510 | rep | NM | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32313 | 32313 | Harley Staggers S000778 | rep | WV | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32366 | 32366 | Albert Ullman U000004 | rep | OR | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32433 | 32433 | James Abdnor A000009 | rep | SD | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32509 | 32509 | David Bowen B000682 | rep | MS | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32564 | 32564 | Donald Clausen C000475 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32656 | 32656 | Floyd Fithian F000161 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32671 | 32671 | Lawrence Fountain F000319 | rep | NC | 1979-01-15 | 1981-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);