legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "end" is on date 1965-01-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33198 | 33198 | Clement Zablocki Z000001 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29093 | 29093 | Jesse Younger Y000060 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
28750 | 28750 | Stephen Young Y000053 | sen | OH | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
31905 | 31905 | John Young Y000043 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
28744 | 28744 | Ralph Yarborough Y000006 | sen | TX | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
30781 | 30781 | Louis Wyman W000782 | rep | NH | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
32421 | 32421 | John Wydler W000780 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
30765 | 30765 | Wendell Wyatt W000778 | rep | OR | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
34146 | 34146 | James Wright W000763 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 12 | |||||||||||||
28293 | 28293 | William Winstead W000641 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
32403 | 32403 | Robert Wilson W000610 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 36 | |||||||||||||
28282 | 28282 | Earl Wilson W000572 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
32389 | 32389 | Charles Wilson W000571 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 31 | |||||||||||||
29085 | 29085 | Edwin Willis W000559 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28741 | 28741 | John Williams W000518 | sen | DE | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
29075 | 29075 | John Williams W000517 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
31895 | 31895 | Harrison Williams W000502 | sen | NJ | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
30755 | 30755 | William Widnall W000445 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
28271 | 28271 | Victor Wickersham W000439 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
35653 | 35653 | Jamie Whitten W000428 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29064 | 29064 | Basil Whitener W000410 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
28737 | 28737 | Compton White W000362 | rep | ID | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28262 | 28262 | James Wharton W000323 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 28 | |||||||||||||
30130 | 30130 | John Whalley W000320 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
28255 | 28255 | Alfred Westland W000310 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28735 | 28735 | Charles Weltner W000290 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28249 | 28249 | James Weaver W000226 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
30123 | 30123 | John Watts W000212 | rep | KY | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
29502 | 29502 | Albert Watson W000197 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28248 | 28248 | Herbert Walters W000110 | sen | TN | 1963-08-20 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
28247 | 28247 | Francis Walter W000108 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
28231 | 28231 | George Wallhauser W000089 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
31870 | 31870 | Joseph Waggonner W000018 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28228 | 28228 | Carl Vinson V000105 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
28202 | 28202 | William Van Pelt V000051 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
32380 | 32380 | Charles Vanik V000047 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
32367 | 32367 | Lionel Van Deerlin V000024 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 37 | |||||||||||||
29495 | 29495 | James Utt U000034 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 35 | |||||||||||||
32358 | 32358 | Albert Ullman U000004 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35014 | 35014 | Morris Udall U000001 | rep | AZ | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28730 | 28730 | James Tuten T000436 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
28728 | 28728 | Stanley Tupper T000411 | rep | ME | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29056 | 29056 | William Tuck T000395 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28725 | 28725 | James Trimble T000373 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28195 | 28195 | Thor Tollefson T000298 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
28714 | 28714 | Herman Toll T000297 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28186 | 28186 | William Thornberry T000237 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
30727 | 30727 | Vernon Thomson T000233 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
28709 | 28709 | Theo Thompson T000218 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
32335 | 32335 | Frank Thompson T000200 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28702 | 28702 | Clark Thompson T000198 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
28690 | 28690 | Albert Thomas T000156 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
31855 | 31855 | Olin Teague T000110 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
30720 | 30720 | Charles Teague T000109 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 13 | |||||||||||||
31387 | 31387 | Roy Taylor T000099 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
31374 | 31374 | Burt Talcott T000022 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
30105 | 30105 | Robert Taft T000010 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
30102 | 30102 | William Symington S001136 | sen | MO | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
31363 | 31363 | Leonor Sullivan S001057 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30710 | 30710 | Frank Stubblefield S001037 | rep | KY | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
33764 | 33764 | Samuel Stratton S000997 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 35 | |||||||||||||
28178 | 28178 | K. Stinson S000928 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
31343 | 31343 | Robert Stephens S000860 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
33157 | 33157 | John Stennis S000852 | sen | MS | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
32321 | 32321 | Thomas Steed S000829 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
32305 | 32305 | Harley Staggers S000778 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
33147 | 33147 | Robert Stafford S000776 | rep | VT | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
28177 | 28177 | Neil Staebler S000775 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29486 | 29486 | William St. Onge S000769 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28176 | 28176 | Katharine St. George S000764 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 27 | |||||||||||||
33749 | 33749 | Fernand St. Germain S000762 | rep | RI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
30096 | 30096 | William Springer S000756 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 22 | |||||||||||||
33415 | 33415 | Marion Snyder S000669 | rep | KY | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
35584 | 35584 | Neal Smith S000596 | rep | IA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28673 | 28673 | Howard Smith S000554 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
30085 | 30085 | H. Smith S000545 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 20 | |||||||||||||
32285 | 32285 | John Slack S000473 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
31831 | 31831 | Joe Skubitz S000472 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
31823 | 31823 | Bernice Sisk S000454 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 16 | |||||||||||||
28162 | 28162 | Eugene Siler S000408 | rep | KY | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
31811 | 31811 | Robert Sikes S000406 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28655 | 28655 | Carlton Sickles S000401 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28157 | 28157 | Abner Sibal S000395 | rep | CT | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
31325 | 31325 | Garner Shriver S000388 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
28155 | 28155 | Don Short S000378 | rep | ND | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
31792 | 31792 | George Shipley S000367 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 23 | |||||||||||||
28152 | 28152 | Harry Sheppard S000335 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 33 | |||||||||||||
28138 | 28138 | John Shelley S000327 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28653 | 28653 | George Senner S000243 | rep | AZ | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29036 | 29036 | Armistead Selden S000232 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28651 | 28651 | Robert Secrest S000219 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
28641 | 28641 | Ralph Scott S000184 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
30079 | 30079 | Hugh Scott S000174 | sen | PA | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
30067 | 30067 | Frederick Schwengel S000161 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
31319 | 31319 | Richard Schweiker S000159 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 13 | |||||||||||||
31311 | 31311 | Herman Schneebeli S000135 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 17 | |||||||||||||
28130 | 28130 | Paul Schenck S000117 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
29482 | 29482 | Henry Schadeberg S000108 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30673 | 30673 | John Saylor S000102 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 22 | |||||||||||||
28308 | 28308 | Pierre Salinger S000016 | sen | CA | 1964-08-04 | 1965-01-03 | 1 | Democrat | appointment |
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);