legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1955-01-03 sorted by legislator_id 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33193 | 33193 | Clement Zablocki Z000001 | rep | WI | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29088 | 29088 | Jesse Younger Y000060 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
26149 | 26149 | Clarence Young Y000032 | rep | NV | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25845 | 25845 | Samuel Yorty Y000024 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 26 | |||||||||||||
36450 | 36450 | Sidney Yates Y000013 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
26688 | 26688 | Charles Wolverton W000683 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26147 | 26147 | Jesse Wolcott W000668 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
27052 | 27052 | Gardner Withrow W000663 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
28288 | 28288 | William Winstead W000641 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
32398 | 32398 | Robert Wilson W000610 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 30 | |||||||||||||
25840 | 25840 | Joseph Wilson W000604 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28278 | 28278 | Earl Wilson W000572 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
29080 | 29080 | Edwin Willis W000559 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
26672 | 26672 | William Williams W000549 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 34 | |||||||||||||
29070 | 29070 | John Williams W000517 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
31893 | 31893 | Harrison Williams W000502 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
26664 | 26664 | Richard Wigglesworth W000450 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 13 | |||||||||||||
27042 | 27042 | Roy Wier W000446 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30750 | 30750 | William Widnall W000445 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
28268 | 28268 | Victor Wickersham W000439 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
35648 | 35648 | Jamie Whitten W000428 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
25836 | 25836 | William Wheeler W000342 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
28257 | 28257 | James Wharton W000323 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 29 | |||||||||||||
28250 | 28250 | Alfred Westland W000310 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
25832 | 25832 | Alvin Weichel W000252 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 13 | |||||||||||||
30118 | 30118 | John Watts W000212 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
25824 | 25824 | Herbert Warburton W000123 | rep | DE | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
32871 | 32871 | William Wampler W000121 | rep | VA | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
28242 | 28242 | Francis Walter W000108 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 15 | |||||||||||||
27035 | 27035 | Stuyvesant Wainwright W000024 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26648 | 26648 | Charles Vursell V000125 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 23 | |||||||||||||
26640 | 26640 | John Vorys V000119 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
28223 | 28223 | Carl Vinson V000105 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
26134 | 26134 | Harold Velde V000082 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 18 | |||||||||||||
27579 | 27579 | James Van Zandt V000069 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 20 | |||||||||||||
28197 | 28197 | William Van Pelt V000051 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
29490 | 29490 | James Utt U000034 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 28 | |||||||||||||
25823 | 25823 | Robert Upton U000032 | sen | NH | 1953-08-14 | 1955-01-03 | 3 | Republican | appointment | ||||||||||||
29051 | 29051 | William Tuck T000395 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28720 | 28720 | James Trimble T000373 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
28190 | 28190 | Thor Tollefson T000298 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
36418 | 36418 | J. Thurmond T000254 | sen | SC | 1954-12-24 | 1955-01-03 | 2 | Democrat | |||||||||||||
28181 | 28181 | William Thornberry T000237 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
28704 | 28704 | Theo Thompson T000218 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
26129 | 26129 | Ruth Thompson T000216 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
28697 | 28697 | Clark Thompson T000198 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
28685 | 28685 | Albert Thomas T000156 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
31850 | 31850 | Olin Teague T000110 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
27026 | 27026 | Dean Taylor T000070 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 31 | |||||||||||||
26629 | 26629 | Henry Talle T000028 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
27564 | 27564 | John Taber T000001 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 36 | |||||||||||||
25820 | 25820 | James Sutton S001087 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
31358 | 31358 | Leonor Sullivan S001057 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
25817 | 25817 | Douglas Stringfellow S001006 | rep | UT | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
32316 | 32316 | Thomas Steed S000829 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
26620 | 26620 | Simon Stauffer S000819 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 19 | |||||||||||||
25816 | 25816 | Thomas Stanley S000797 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
32300 | 32300 | Harley Staggers S000778 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28171 | 28171 | Katharine St. George S000764 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 28 | |||||||||||||
30091 | 30091 | William Springer S000756 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 22 | |||||||||||||
27544 | 27544 | Brent Spence S000717 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
30700 | 30700 | John Sparkman S000701 | sen | AL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27017 | 27017 | Wint Smith S000640 | rep | KS | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
29045 | 29045 | Margaret Smith S000590 | sen | ME | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
26617 | 26617 | Lawrence Smith S000585 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
28668 | 28668 | Howard Smith S000554 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
27528 | 27528 | Frank Smith S000533 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
25808 | 25808 | Frank Small S000499 | rep | MD | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
26608 | 26608 | Sidney Simpson S000437 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 20 | |||||||||||||
27010 | 27010 | Richard Simpson S000436 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 18 | |||||||||||||
31806 | 31806 | Robert Sikes S000406 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
26600 | 26600 | Alfred Sieminski S000405 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 13 | |||||||||||||
26596 | 26596 | George Shuford S000390 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 12 | |||||||||||||
26126 | 26126 | Dewey Short S000377 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
28147 | 28147 | Harry Sheppard S000335 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 27 | |||||||||||||
28133 | 28133 | John Shelley S000327 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26593 | 26593 | Timothy Sheehan S000315 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 11 | |||||||||||||
25807 | 25807 | Paul Shafer S000277 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
29031 | 29031 | Armistead Selden S000232 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
27523 | 27523 | Horace Seely-Brown S000224 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
28650 | 28650 | Robert Secrest S000219 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 15 | |||||||||||||
26589 | 26589 | Hubert Scudder S000198 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26584 | 26584 | Errett Scrivner S000194 | rep | KS | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
25865 | 25865 | William Scott S000187 | sen | NC | 1954-11-29 | 1955-01-03 | 2 | Democrat | |||||||||||||
30076 | 30076 | Hugh Scott S000174 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
27517 | 27517 | Andrew Schoeppel S000138 | sen | KS | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
27512 | 27512 | Gordon Scherer S000120 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
28125 | 28125 | Paul Schenck S000117 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
30668 | 30668 | John Saylor S000102 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 22 | |||||||||||||
27503 | 27503 | Leverett Saltonstall S000021 | sen | MA | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
26576 | 26576 | Antoni Sadlak S000009 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
29027 | 29027 | Richard Russell R000536 | sen | GA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25798 | 25798 | Franklin Roosevelt R000425 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 20 | |||||||||||||
30646 | 30646 | John Rooney R000424 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
28622 | 28622 | Walter Rogers R000404 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 18 | |||||||||||||
26997 | 26997 | Edith Rogers R000392 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
25795 | 25795 | Dwight Rogers R000391 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
29459 | 29459 | Byron Rogers R000389 | rep | CO | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
33723 | 33723 | Peter Rodino R000374 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
26570 | 26570 | John Robsion R000359 | rep | KY | 1953-01-03 | 1955-01-03 | Republican | 3 |
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);