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 state 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31766 | 31766 | Teno Roncalio R000421 | rep | WY | 1973-01-03 | 1975-01-03 | Democrat | 0 | |||||||||||||
30996 | 30996 | Kenneth Hechler H000438 | rep | WV | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
32290 | 32290 | John Slack S000473 | rep | WV | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
32310 | 32310 | Harley Staggers S000778 | rep | WV | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
32785 | 32785 | Robert Mollohan M000845 | rep | WV | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30285 | 30285 | Glenn Davis D000102 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
30371 | 30371 | Harold Froehlich F000388 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30732 | 30732 | Vernon Thomson T000233 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
31226 | 31226 | Gaylord Nelson N000033 | sen | WI | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31843 | 31843 | William Steiger S000847 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
32818 | 32818 | Henry Reuss R000165 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
33203 | 33203 | Clement Zablocki Z000001 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
33965 | 33965 | Robert Kastenmeier K000020 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
35109 | 35109 | Leslie Aspin A000224 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
38732 | 38732 | David Obey O000007 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
30461 | 30461 | Julia Hansen H000174 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31016 | 31016 | Floyd Hicks H000563 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31169 | 31169 | Warren Magnuson M000053 | sen | WA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31663 | 31663 | Lloyd Meeds M000626 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
32162 | 32162 | Mike McCormack M000365 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
33105 | 33105 | Joel Pritchard P000546 | rep | WA | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
33474 | 33474 | Brockman Adams A000031 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
35249 | 35249 | Thomas Foley F000239 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
29118 | 29118 | George Aiken A000062 | sen | VT | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
30546 | 30546 | Richard Mallary M000078 | rep | VT | 1973-01-03 | 1975-01-03 | Republican | 0 | |||||||||||||
35669 | 35669 | Ron de Lugo D000209 | rep | VI | 1973-01-03 | 1975-01-03 | Democrat | 0 | |||||||||||||
30212 | 30212 | Joel Broyhill B000967 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
30908 | 30908 | Thomas Downing D000474 | rep | VA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
32273 | 32273 | David Satterfield S000070 | rep | VA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
32543 | 32543 | Manley Butler B001182 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
32581 | 32581 | Robert Daniel D000037 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
32875 | 32875 | William Wampler W000121 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
33121 | 33121 | James Robinson R000337 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
33436 | 33436 | George Whitehurst W000406 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
33545 | 33545 | Wilbur Daniel D000038 | rep | VA | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
34034 | 34034 | Stanford Parris P000080 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
32175 | 32175 | Koln McKay M000490 | rep | UT | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
33584 | 33584 | Edwin Garn G000072 | sen | UT | 1974-12-21 | 1975-01-03 | 3 | Republican | |||||||||||||
34815 | 34815 | Douglas Owens O000156 | rep | UT | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30359 | 30359 | Ovie Fisher F000152 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
30620 | 30620 | Robert Price P000528 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 13 | |||||||||||||
30862 | 30862 | Robert Casey C000228 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
31274 | 31274 | John Patman P000103 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31335 | 31335 | Alan Steelman S000841 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
31466 | 31466 | Omar Burleson B001111 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 17 | |||||||||||||
31597 | 31597 | Barbara Jordan J000266 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 18 | |||||||||||||
31640 | 31640 | George Mahon M000065 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 19 | |||||||||||||
31672 | 31672 | Dale Milford M000708 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 24 | |||||||||||||
31736 | 31736 | William Poage P000398 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
31860 | 31860 | Olin Teague T000110 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31910 | 31910 | John Young Y000043 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
32052 | 32052 | Robert Eckhardt E000035 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
32259 | 32259 | Herbert Roberts R000312 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
32569 | 32569 | James Collins C000638 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
32885 | 32885 | Richard White W000390 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 16 | |||||||||||||
33014 | 33014 | Abraham Kazen K000025 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 23 | |||||||||||||
34151 | 34151 | James Wright W000763 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 12 | |||||||||||||
35145 | 35145 | Jack Brooks B000880 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
35513 | 35513 | James Pickle P000328 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 10 | |||||||||||||
36098 | 36098 | Charles Wilson W000570 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
36120 | 36120 | Eligio de la Garza D000203 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 15 | |||||||||||||
36209 | 36209 | Henry González G000272 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
36473 | 36473 | Bill Archer A000215 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
30159 | 30159 | LaMar Baker B000069 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30526 | 30526 | Dan Kuykendall K000348 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30934 | 30934 | Joseph Evins E000273 | rep | TN | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
30941 | 30941 | Richard Fulton F000424 | rep | TN | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
32467 | 32467 | Robin Beard B000280 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
33570 | 33570 | John Duncan D000534 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
33614 | 33614 | Ed Jones J000216 | rep | TN | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
35980 | 35980 | James Quillen Q000013 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
30298 | 30298 | Frank Denholm D000234 | rep | SD | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31177 | 31177 | George McGovern M000452 | sen | SD | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
32430 | 32430 | James Abdnor A000009 | rep | SD | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30328 | 30328 | William Dorn D000434 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30377 | 30377 | Thomas Gettys G000144 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
30771 | 30771 | Edward Young Y000035 | rep | SC | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
31645 | 31645 | James Mann M000105 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
32011 | 32011 | Mendel Davis D000125 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
36650 | 36650 | Ernest Hollings H000725 | sen | SC | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
37155 | 37155 | Floyd Spence S000718 | rep | SC | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30736 | 30736 | Robert Tiernan T000265 | rep | RI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
33754 | 33754 | Fernand St. Germain S000762 | rep | RI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30848 | 30848 | Jaime Benítez B000362 | rep | PR | 1973-01-03 | 1975-01-03 | Popular Democrat | 0 | |||||||||||||
30250 | 30250 | Frank Clark C000431 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 25 | |||||||||||||
30383 | 30383 | George Goodling G000290 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 19 | |||||||||||||
30678 | 30678 | John Saylor S000102 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 12 | |||||||||||||
30747 | 30747 | John Ware W000147 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30764 | 30764 | Lawrence Williams W000525 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
30833 | 30833 | William Barrett B000178 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30853 | 30853 | Edward Biester B000451 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30919 | 30919 | Edwin Eshleman E000214 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 16 | |||||||||||||
30950 | 30950 | William Green G000420 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31079 | 31079 | Albert Johnson J000115 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 23 | |||||||||||||
31215 | 31215 | Thomas Morgan M000958 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
31316 | 31316 | Herman Schneebeli S000135 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 17 | |||||||||||||
31322 | 31322 | Richard Schweiker S000159 | sen | PA | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
31400 | 31400 | Joseph Vigorito V000098 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 24 | |||||||||||||
31535 | 31535 | John Dent D000255 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
31541 | 31541 | Joshua Eilberg E000096 | rep | PA | 1973-01-03 | 1975-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);