legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
479 rows where "end" is on date 1975-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41664 | 41664 | Don Young Y000033 | rep | AK | 1973-03-06 | 1975-01-03 | Republican | 0 | |||||||||||||
40618 | 40618 | Thad Cochran C000567 | rep | MS | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
40559 | 40559 | John Conyers C000714 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
40439 | 40439 | Charles Rangel R000053 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 19 | |||||||||||||
39808 | 39808 | John Dingell D000355 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 16 | |||||||||||||
39623 | 39623 | C. Young Y000031 | rep | FL | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
39513 | 39513 | Fortney Stark S000810 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
39022 | 39022 | Daniel Inouye I000025 | sen | HI | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
38732 | 38732 | David Obey O000007 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
38692 | 38692 | John Murtha M001120 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 12 | |||||||||||||
38293 | 38293 | Ralph Regula R000141 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 16 | |||||||||||||
38202 | 38202 | Trent Lott L000447 | rep | MS | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
37284 | 37284 | Philip Crane C000873 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 12 | |||||||||||||
37155 | 37155 | Floyd Spence S000718 | rep | SC | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
37118 | 37118 | Elmer Shuster S000394 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
37094 | 37094 | Paul Sarbanes S000064 | rep | MD | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
37040 | 37040 | John Moakley M000834 | rep | MA | 1973-01-03 | 1975-01-03 | Ind. Democrat | 9 | |||||||||||||
37031 | 37031 | Patsy Mink M000797 | rep | HI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
36920 | 36920 | Benjamin Gilman G000212 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 26 | |||||||||||||
36650 | 36650 | Ernest Hollings H000725 | sen | SC | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
36559 | 36559 | William Clay C000488 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
36526 | 36526 | George Brown B000918 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 38 | |||||||||||||
36512 | 36512 | John Breaux B000780 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
36473 | 36473 | Bill Archer A000215 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
36459 | 36459 | Sidney Yates Y000013 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
36400 | 36400 | Louis Stokes S000948 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
36300 | 36300 | Joseph McDade M000399 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
36232 | 36232 | Lee Hamilton H000114 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
36209 | 36209 | Henry González G000272 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
36143 | 36143 | Ronald Dellums D000222 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
36120 | 36120 | Eligio de la Garza D000203 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 15 | |||||||||||||
36098 | 36098 | Charles Wilson W000570 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
36050 | 36050 | Raymond Thornton T000243 | rep | AR | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
36037 | 36037 | Gerry Studds S001040 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 12 | |||||||||||||
36024 | 36024 | Patricia Schroeder S000142 | rep | CO | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
35996 | 35996 | Charles Rose R000436 | rep | NC | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
35980 | 35980 | James Quillen Q000013 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
35952 | 35952 | John Myers M001130 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
35933 | 35933 | Carlos Moorhead M000926 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 20 | |||||||||||||
35921 | 35921 | Gillespie Montgomery M000865 | rep | MS | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
35826 | 35826 | Sam Gibbons G000153 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
35758 | 35758 | Cardiss Collins C000634 | rep | IL | 1973-06-05 | 1975-01-03 | Democrat | 7 | |||||||||||||
35696 | 35696 | Tom Bevill B000431 | rep | AL | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
35669 | 35669 | Ron de Lugo D000209 | rep | VI | 1973-01-03 | 1975-01-03 | Democrat | 0 | |||||||||||||
35658 | 35658 | Jamie Whitten W000428 | rep | MS | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
35589 | 35589 | Neal Smith S000596 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
35541 | 35541 | Daniel Rostenkowski R000458 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
35513 | 35513 | James Pickle P000328 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 10 | |||||||||||||
35488 | 35488 | Robert Packwood P000009 | sen | OR | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
35467 | 35467 | William Natcher N000009 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
35436 | 35436 | Robert Michel M000692 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 18 | |||||||||||||
35393 | 35393 | Romano Mazzoli M000291 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
35285 | 35285 | John Glenn G000236 | sen | OH | 1974-12-24 | 1975-01-03 | 3 | Democrat | |||||||||||||
35269 | 35269 | William Ford F000270 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 15 | |||||||||||||
35260 | 35260 | Wendell Ford F000268 | sen | KY | 1974-12-28 | 1975-01-03 | 3 | Democrat | |||||||||||||
35249 | 35249 | Thomas Foley F000239 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
35234 | 35234 | Hamilton Fish F000141 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 25 | |||||||||||||
35204 | 35204 | William Edwards E000064 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
35194 | 35194 | Robert Dole D000401 | sen | KS | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
35145 | 35145 | Jack Brooks B000880 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
35109 | 35109 | Leslie Aspin A000224 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
35080 | 35080 | Gus Yatron Y000014 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
35068 | 35068 | Chalmers Wylie W000781 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 15 | |||||||||||||
35033 | 35033 | Guy Vander Jagt V000027 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
35019 | 35019 | Morris Udall U000001 | rep | AZ | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
35003 | 35003 | Jerome Traxler T000356 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
34903 | 34903 | Edward Roybal R000485 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 30 | |||||||||||||
34888 | 34888 | Robert Roe R000383 | rep | NJ | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
34869 | 34869 | Matthew Rinaldo R000262 | rep | NJ | 1973-01-03 | 1975-01-03 | Republican | 12 | |||||||||||||
34815 | 34815 | Douglas Owens O000156 | rep | UT | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
34754 | 34754 | Clarence Miller M000718 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
34696 | 34696 | Edward Madigan M000041 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 21 | |||||||||||||
34674 | 34674 | Norman Lent L000243 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
34663 | 34663 | William Lehman L000226 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 13 | |||||||||||||
34653 | 34653 | Robert Lagomarsino L000020 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 13 | |||||||||||||
34624 | 34624 | Walter Jones J000256 | rep | NC | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
34568 | 34568 | Frank Horton H000797 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 34 | |||||||||||||
34514 | 34514 | John Hammerschmidt H000124 | rep | AR | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
34473 | 34473 | Joseph Gaydos G000105 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
34451 | 34451 | Dante Fascell F000041 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 15 | |||||||||||||
34373 | 34373 | William Dickinson D000326 | rep | AL | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
34344 | 34344 | Robert Coughlin C000807 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 13 | |||||||||||||
34332 | 34332 | Silvio Conte C000709 | rep | MA | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
34309 | 34309 | William Cohen C000598 | rep | ME | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
34273 | 34273 | William Broomfield B000890 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 19 | |||||||||||||
34245 | 34245 | Charles Bennett B000371 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
34190 | 34190 | Frank Annunzio A000212 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
34176 | 34176 | Glenn Anderson A000189 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 35 | |||||||||||||
34164 | 34164 | William Alexander A000103 | rep | AR | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
34151 | 34151 | James Wright W000763 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 12 | |||||||||||||
34066 | 34066 | Donald Riegle R000249 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
34054 | 34054 | Claude Pepper P000218 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
34034 | 34034 | Stanford Parris P000080 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
34008 | 34008 | Spark Matsunaga M000250 | rep | HI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
33986 | 33986 | Thomas Luken L000508 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
33965 | 33965 | Robert Kastenmeier K000020 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
33948 | 33948 | Henry Heinz H000456 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 18 | |||||||||||||
33938 | 33938 | Augustus Hawkins H000367 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
33915 | 33915 | William Frenzel F000380 | rep | MN | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
33890 | 33890 | Walter Fauntroy F000046 | rep | DC | 1973-01-03 | 1975-01-03 | Democrat | 0 |
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);