legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "end" is on date 1959-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27591 | 27591 | Herbert Zelenko Z000003 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
33195 | 33195 | Clement Zablocki Z000001 | rep | WI | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29090 | 29090 | Jesse Younger Y000060 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
31902 | 31902 | John Young Y000043 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
36452 | 36452 | Sidney Yates Y000013 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28743 | 28743 | Ralph Yarborough Y000006 | sen | TX | 1957-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
34143 | 34143 | James Wright W000763 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
26690 | 26690 | Charles Wolverton W000683 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
27054 | 27054 | Gardner Withrow W000663 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
28290 | 28290 | William Winstead W000641 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
32400 | 32400 | Robert Wilson W000610 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 30 | |||||||||||||
28280 | 28280 | Earl Wilson W000572 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
29082 | 29082 | Edwin Willis W000559 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
26674 | 26674 | William Williams W000549 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 34 | |||||||||||||
28740 | 28740 | John Williams W000518 | sen | DE | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
29072 | 29072 | John Williams W000517 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26666 | 26666 | Richard Wigglesworth W000450 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
27044 | 27044 | Roy Wier W000446 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
30752 | 30752 | William Widnall W000445 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
35650 | 35650 | Jamie Whitten W000428 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
29061 | 29061 | Basil Whitener W000410 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
28259 | 28259 | James Wharton W000323 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 29 | |||||||||||||
28252 | 28252 | Alfred Westland W000310 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27585 | 27585 | Phillip Weaver W000228 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
30120 | 30120 | John Watts W000212 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
25826 | 25826 | Arthur Watkins W000190 | sen | UT | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
28244 | 28244 | Francis Walter W000108 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 15 | |||||||||||||
27037 | 27037 | Stuyvesant Wainwright W000024 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26650 | 26650 | Charles Vursell V000125 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 23 | |||||||||||||
26642 | 26642 | John Vorys V000119 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
28225 | 28225 | Carl Vinson V000105 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27581 | 27581 | James Van Zandt V000069 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
28199 | 28199 | William Van Pelt V000051 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
32377 | 32377 | Charles Vanik V000047 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
29492 | 29492 | James Utt U000034 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 28 | |||||||||||||
32355 | 32355 | Albert Ullman U000004 | rep | OR | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27570 | 27570 | Stewart Udall U000002 | rep | AZ | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
29053 | 29053 | William Tuck T000395 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28722 | 28722 | James Trimble T000373 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28192 | 28192 | Thor Tollefson T000298 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
25822 | 25822 | Edward Thye T000259 | sen | MN | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
28183 | 28183 | William Thornberry T000237 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
27033 | 27033 | Edwin Thomson T000229 | rep | WY | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
28706 | 28706 | Theo Thompson T000218 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
32332 | 32332 | Frank Thompson T000200 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28699 | 28699 | Clark Thompson T000198 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28687 | 28687 | Albert Thomas T000156 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26632 | 26632 | Donald Tewes T000139 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27030 | 27030 | Ludwig Teller T000118 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
31852 | 31852 | Olin Teague T000110 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
30717 | 30717 | Charles Teague T000109 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
27028 | 27028 | Dean Taylor T000070 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 31 | |||||||||||||
26631 | 26631 | Henry Talle T000028 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27566 | 27566 | John Taber T000001 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 36 | |||||||||||||
30101 | 30101 | William Symington S001136 | sen | MO | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
31360 | 31360 | Leonor Sullivan S001057 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
33156 | 33156 | John Stennis S000852 | sen | MS | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
32318 | 32318 | Thomas Steed S000829 | rep | OK | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26621 | 26621 | Simon Stauffer S000819 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 19 | |||||||||||||
32302 | 32302 | Harley Staggers S000778 | rep | WV | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28173 | 28173 | Katharine St. George S000764 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 28 | |||||||||||||
30093 | 30093 | William Springer S000756 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
27546 | 27546 | Brent Spence S000717 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27019 | 27019 | Wint Smith S000640 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26619 | 26619 | Lawrence Smith S000585 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
28670 | 28670 | Howard Smith S000554 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
25811 | 25811 | Howard Smith S000553 | sen | NJ | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
30082 | 30082 | H. Smith S000545 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
27530 | 27530 | Frank Smith S000533 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
31820 | 31820 | Bernice Sisk S000454 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
26610 | 26610 | Sidney Simpson S000437 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
27012 | 27012 | Richard Simpson S000436 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 18 | |||||||||||||
28159 | 28159 | Eugene Siler S000408 | rep | KY | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
31808 | 31808 | Robert Sikes S000406 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
26602 | 26602 | Alfred Sieminski S000405 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 13 | |||||||||||||
26598 | 26598 | George Shuford S000390 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
28149 | 28149 | Harry Sheppard S000335 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 27 | |||||||||||||
28135 | 28135 | John Shelley S000327 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
26595 | 26595 | Timothy Sheehan S000315 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
29033 | 29033 | Armistead Selden S000232 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27525 | 27525 | Horace Seely-Brown S000224 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26591 | 26591 | Hubert Scudder S000198 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26586 | 26586 | Errett Scrivner S000194 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
25866 | 25866 | William Scott S000187 | sen | NC | 1955-01-03 | 1959-01-03 | 2 | Democrat | |||||||||||||
28638 | 28638 | Ralph Scott S000184 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
30078 | 30078 | Hugh Scott S000174 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
30064 | 30064 | Frederick Schwengel S000161 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
27514 | 27514 | Gordon Scherer S000120 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
28127 | 28127 | Paul Schenck S000117 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
30670 | 30670 | John Saylor S000102 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
27509 | 27509 | Dalip Saund S000075 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 29 | |||||||||||||
27506 | 27506 | Alfred Santangelo S000057 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
26578 | 26578 | Antoni Sadlak S000009 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
27499 | 27499 | J. Rutherford R000547 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 16 | |||||||||||||
28630 | 28630 | James Roosevelt R000426 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 26 | |||||||||||||
30648 | 30648 | John Rooney R000424 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
28624 | 28624 | Walter Rogers R000404 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
31753 | 31753 | Paul Rogers R000401 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
26999 | 26999 | Edith Rogers R000392 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
29461 | 29461 | Byron Rogers R000389 | rep | CO | 1957-01-03 | 1959-01-03 | Democrat | 1 |
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);