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 1967-01-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: start, class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33199 | 33199 | Clement Zablocki Z000001 | rep | WI | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29094 | 29094 | Jesse Younger Y000060 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 11 | |||||||||||||
31906 | 31906 | John Young Y000043 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
36455 | 36455 | Sidney Yates Y000013 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
32422 | 32422 | John Wydler W000780 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
30766 | 30766 | Wendell Wyatt W000778 | rep | OR | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
34147 | 34147 | James Wright W000763 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 12 | |||||||||||||
32412 | 32412 | Lester Wolff W000680 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32404 | 32404 | Robert Wilson W000610 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 36 | |||||||||||||
32390 | 32390 | Charles Wilson W000571 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 31 | |||||||||||||
29086 | 29086 | Edwin Willis W000559 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29076 | 29076 | John Williams W000517 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30756 | 30756 | William Widnall W000445 | rep | NJ | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
35654 | 35654 | Jamie Whitten W000428 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29065 | 29065 | Basil Whitener W000410 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
32881 | 32881 | Richard White W000390 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
28738 | 28738 | Compton White W000362 | rep | ID | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30131 | 30131 | John Whalley W000320 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
28736 | 28736 | Charles Weltner W000290 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
30124 | 30124 | John Watts W000212 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
29503 | 29503 | Albert Watson W000197 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29499 | 29499 | George Watkins W000192 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
28734 | 28734 | Prentiss Walker W000065 | rep | MS | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29059 | 29059 | E. Walker W000049 | rep | NM | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
30740 | 30740 | Jerome Waldie W000035 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
31871 | 31871 | Joseph Waggonner W000018 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28733 | 28733 | Weston Vivian V000109 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31396 | 31396 | Joseph Vigorito V000098 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 24 | |||||||||||||
32381 | 32381 | Charles Vanik V000047 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
35029 | 35029 | Guy Vander Jagt V000027 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 9 | |||||||||||||
32368 | 32368 | Lionel Van Deerlin V000024 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 37 | |||||||||||||
29496 | 29496 | James Utt U000034 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 35 | |||||||||||||
32359 | 32359 | Albert Ullman U000004 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35015 | 35015 | Morris Udall U000001 | rep | AZ | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28731 | 28731 | James Tuten T000436 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28729 | 28729 | Stanley Tupper T000411 | rep | ME | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
30113 | 30113 | John Tunney T000410 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 38 | |||||||||||||
29057 | 29057 | William Tuck T000395 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
28726 | 28726 | James Trimble T000373 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32344 | 32344 | John Tower T000322 | sen | TX | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28715 | 28715 | Herman Toll T000297 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28711 | 28711 | Paul Todd T000294 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
36421 | 36421 | J. Thurmond T000254 | sen | SC | 1961-01-03 | 1967-01-03 | 2 | Republican | [ { "start": "1961-01-03", "end": "1964-09-16", "party": "Democrat" }, { "start": "1964-09-16", "end": "1967-01-03", "party": "Republican" } ] |
||||||||||||
30728 | 30728 | Vernon Thomson T000233 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
28710 | 28710 | Theo Thompson T000218 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
32336 | 32336 | Frank Thompson T000200 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28703 | 28703 | Clark Thompson T000198 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
28692 | 28692 | Lera Thomas T000178 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28691 | 28691 | Albert Thomas T000156 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
29049 | 29049 | Herbert Tenzer T000128 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31856 | 31856 | Olin Teague T000110 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
30721 | 30721 | Charles Teague T000109 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 13 | |||||||||||||
31388 | 31388 | Roy Taylor T000099 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
31375 | 31375 | Burt Talcott T000022 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
28676 | 28676 | Robert Sweeney S001103 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
31364 | 31364 | Leonor Sullivan S001057 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30711 | 30711 | Frank Stubblefield S001037 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
33765 | 33765 | Samuel Stratton S000997 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 35 | |||||||||||||
31344 | 31344 | Robert Stephens S000860 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
32322 | 32322 | Thomas Steed S000829 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32858 | 32858 | John Stanton S000804 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 11 | |||||||||||||
28675 | 28675 | Lynn Stalbaum S000782 | rep | WI | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
32306 | 32306 | Harley Staggers S000778 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
33148 | 33148 | Robert Stafford S000776 | rep | VT | 1965-01-04 | 1967-01-03 | Republican | 0 | |||||||||||||
29487 | 29487 | William St. Onge S000769 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
33750 | 33750 | Fernand St. Germain S000762 | rep | RI | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30097 | 30097 | William Springer S000756 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 22 | |||||||||||||
28752 | 28752 | William Spong S000739 | sen | VA | 1966-12-31 | 1967-01-03 | 2 | Democrat | |||||||||||||
30702 | 30702 | John Sparkman S000701 | sen | AL | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
35585 | 35585 | Neal Smith S000596 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29047 | 29047 | Margaret Smith S000590 | sen | ME | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28674 | 28674 | Howard Smith S000554 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
30689 | 30689 | Henry Smith S000548 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 40 | |||||||||||||
30086 | 30086 | H. Smith S000545 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 20 | |||||||||||||
32286 | 32286 | John Slack S000473 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31832 | 31832 | Joe Skubitz S000472 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
31824 | 31824 | Bernice Sisk S000454 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
27601 | 27601 | Milward Simpson S000434 | sen | WY | 1962-01-01 | 1967-01-03 | 2 | Republican | |||||||||||||
31812 | 31812 | Robert Sikes S000406 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28656 | 28656 | Carlton Sickles S000401 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
31326 | 31326 | Garner Shriver S000388 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
31793 | 31793 | George Shipley S000367 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 23 | |||||||||||||
28654 | 28654 | George Senner S000243 | rep | AZ | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29037 | 29037 | Armistead Selden S000232 | rep | AL | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
28652 | 28652 | Robert Secrest S000219 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
28642 | 28642 | Ralph Scott S000184 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31320 | 31320 | Richard Schweiker S000159 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 13 | |||||||||||||
31312 | 31312 | Herman Schneebeli S000135 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
28637 | 28637 | John Schmidhauser S000131 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28636 | 28636 | Darwin Schisler S000128 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
34928 | 34928 | James Scheuer S000124 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
30674 | 30674 | John Saylor S000102 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 22 | |||||||||||||
32269 | 32269 | David Satterfield S000070 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
27505 | 27505 | Leverett Saltonstall S000021 | sen | MA | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30057 | 30057 | William Ryan R000562 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
29029 | 29029 | Richard Russell R000536 | sen | GA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28635 | 28635 | Donald Russell R000525 | sen | SC | 1965-04-22 | 1967-01-03 | 3 | Democrat | appointment | ||||||||||||
29477 | 29477 | Donald Rumsfeld R000508 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 13 | |||||||||||||
34899 | 34899 | Edward Roybal R000485 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 30 | |||||||||||||
31304 | 31304 | John Roush R000467 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 5 |
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);