legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
489 rows where "end" is on date 1963-01-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27593 | 27593 | Herbert Zelenko Z000003 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 21 | |||||||||||||
33197 | 33197 | Clement Zablocki Z000001 | rep | WI | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29092 | 29092 | Jesse Younger Y000060 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
31404 | 31404 | Milton Young Y000047 | sen | ND | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
31904 | 31904 | John Young Y000043 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
36454 | 36454 | Sidney Yates Y000013 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
34145 | 34145 | James Wright W000763 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
28292 | 28292 | William Winstead W000641 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
32402 | 32402 | Robert Wilson W000610 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 30 | |||||||||||||
28281 | 28281 | Earl Wilson W000572 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
29084 | 29084 | Edwin Willis W000559 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29074 | 29074 | John Williams W000517 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
26670 | 26670 | Alexander Wiley W000465 | sen | WI | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
30754 | 30754 | William Widnall W000445 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
28270 | 28270 | Victor Wickersham W000439 | rep | OK | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
35652 | 35652 | Jamie Whitten W000428 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29063 | 29063 | Basil Whitener W000410 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
28261 | 28261 | James Wharton W000323 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 29 | |||||||||||||
30129 | 30129 | John Whalley W000320 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 18 | |||||||||||||
28254 | 28254 | Alfred Westland W000310 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27589 | 27589 | Jessica Weis W000256 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 38 | |||||||||||||
27587 | 27587 | Phillip Weaver W000228 | rep | NE | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
30122 | 30122 | John Watts W000212 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28246 | 28246 | Francis Walter W000108 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 15 | |||||||||||||
28230 | 28230 | George Wallhauser W000089 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 12 | |||||||||||||
31869 | 31869 | Joseph Waggonner W000018 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28227 | 28227 | Carl Vinson V000105 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27583 | 27583 | James Van Zandt V000069 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 20 | |||||||||||||
28201 | 28201 | William Van Pelt V000051 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
32379 | 32379 | Charles Vanik V000047 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 21 | |||||||||||||
29494 | 29494 | James Utt U000034 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 28 | |||||||||||||
32357 | 32357 | Albert Ullman U000004 | rep | OR | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27572 | 27572 | Stewart Udall U000002 | rep | AZ | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
35013 | 35013 | Morris Udall U000001 | rep | AZ | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28727 | 28727 | Stanley Tupper T000411 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29055 | 29055 | William Tuck T000395 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28724 | 28724 | James Trimble T000373 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28194 | 28194 | Thor Tollefson T000298 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
28713 | 28713 | Herman Toll T000297 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28185 | 28185 | William Thornberry T000237 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 10 | |||||||||||||
30726 | 30726 | Vernon Thomson T000233 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
28708 | 28708 | Theo Thompson T000218 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
32334 | 32334 | Frank Thompson T000200 | rep | NJ | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28701 | 28701 | Clark Thompson T000198 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
28689 | 28689 | Albert Thomas T000156 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
31854 | 31854 | Olin Teague T000110 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
30719 | 30719 | Charles Teague T000109 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 13 | |||||||||||||
31386 | 31386 | Roy Taylor T000099 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
31381 | 31381 | Herman Talmadge T000035 | sen | GA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27568 | 27568 | John Taber T000001 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 36 | |||||||||||||
31362 | 31362 | Leonor Sullivan S001057 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30709 | 30709 | Frank Stubblefield S001037 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
33763 | 33763 | Samuel Stratton S000997 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 32 | |||||||||||||
31342 | 31342 | Robert Stephens S000860 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 10 | |||||||||||||
32320 | 32320 | Thomas Steed S000829 | rep | OK | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
32304 | 32304 | Harley Staggers S000778 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
33146 | 33146 | Robert Stafford S000776 | rep | VT | 1961-01-03 | 1963-01-03 | Republican | 0 | |||||||||||||
28175 | 28175 | Katharine St. George S000764 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 28 | |||||||||||||
33748 | 33748 | Fernand St. Germain S000762 | rep | RI | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
30095 | 30095 | William Springer S000756 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 22 | |||||||||||||
27548 | 27548 | Brent Spence S000717 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
35583 | 35583 | Neal Smith S000596 | rep | IA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28672 | 28672 | Howard Smith S000554 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
30084 | 30084 | H. Smith S000545 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 20 | |||||||||||||
27532 | 27532 | Frank Smith S000533 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27060 | 27060 | Benjamin Smith S000517 | sen | MA | 1960-12-27 | 1963-01-03 | 1 | Democrat | appointment | ||||||||||||
28166 | 28166 | George Smathers S000505 | sen | FL | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
32284 | 32284 | John Slack S000473 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
31822 | 31822 | Bernice Sisk S000454 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
28161 | 28161 | Eugene Siler S000408 | rep | KY | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
31810 | 31810 | Robert Sikes S000406 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28156 | 28156 | Abner Sibal S000395 | rep | CT | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
31324 | 31324 | Garner Shriver S000388 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
28154 | 28154 | Don Short S000378 | rep | ND | 1961-01-03 | 1963-01-03 | Republican | 0 | |||||||||||||
31791 | 31791 | George Shipley S000367 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 23 | |||||||||||||
28151 | 28151 | Harry Sheppard S000335 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 27 | |||||||||||||
28137 | 28137 | John Shelley S000327 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
29035 | 29035 | Armistead Selden S000232 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27526 | 27526 | Horace Seely-Brown S000224 | rep | CT | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27520 | 27520 | William Scranton S000193 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
28640 | 28640 | Ralph Scott S000184 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
30066 | 30066 | Frederick Schwengel S000161 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
31318 | 31318 | Richard Schweiker S000159 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 13 | |||||||||||||
31310 | 31310 | Herman Schneebeli S000135 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 17 | |||||||||||||
27516 | 27516 | Gordon Scherer S000120 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
28129 | 28129 | Paul Schenck S000117 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
29481 | 29481 | Henry Schadeberg S000108 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
30672 | 30672 | John Saylor S000102 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 22 | |||||||||||||
27511 | 27511 | Dalip Saund S000075 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 29 | |||||||||||||
27508 | 27508 | Alfred Santangelo S000057 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 18 | |||||||||||||
30055 | 30055 | William Ryan R000562 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 20 | |||||||||||||
28122 | 28122 | Harold Ryan R000556 | rep | MI | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
27501 | 27501 | J. Rutherford R000547 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 16 | |||||||||||||
32843 | 32843 | John Rousselot R000469 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 25 | |||||||||||||
31302 | 31302 | John Roush R000467 | rep | IN | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
29471 | 29471 | Richard Roudebush R000464 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
35535 | 35535 | Daniel Rostenkowski R000458 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
33127 | 33127 | Benjamin Rosenthal R000442 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28632 | 28632 | James Roosevelt R000426 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 26 | |||||||||||||
30650 | 30650 | John Rooney R000424 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 14 |
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);