legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
477 rows where "end" is on date 1957-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25109 | 25109 | Earle Clements C000506 | sen | KY | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25271 | 25271 | Walter George G000131 | sen | GA | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25369 | 25369 | Herbert Lehman L000224 | sen | NY | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25739 | 25739 | Harley Kilgore K000176 | sen | WV | 1953-01-03 | 1957-01-03 | 1 | Democrat | |||||||||||||
25879 | 25879 | John Bell B000342 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 14 | |||||||||||||
25887 | 25887 | Vera Buchanan B001009 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 30 | |||||||||||||
25890 | 25890 | Maurice Burnside B001131 | rep | WV | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
25894 | 25894 | Frank Carlyle C000156 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
25899 | 25899 | Richard Chatham C000336 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
25905 | 25905 | Irwin Davidson D000083 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 20 | |||||||||||||
25910 | 25910 | Charles Deane D000175 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
25922 | 25922 | John Dingell D000354 | rep | MI | 1955-01-05 | 1957-01-03 | Democrat | 15 | |||||||||||||
25943 | 25943 | James Donovan D000421 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 18 | |||||||||||||
25962 | 25962 | Sidney Fine F000126 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 22 | |||||||||||||
25977 | 25977 | Brady Gentry G000124 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
25982 | 25982 | William Granahan G000369 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
25993 | 25993 | Donald Hayworth H000412 | rep | MI | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
26032 | 26032 | Woodrow Jones J000263 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 11 | |||||||||||||
26043 | 26043 | Arthur Klein K000261 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 19 | |||||||||||||
26057 | 26057 | James Murray M001107 | rep | IL | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
26092 | 26092 | James Priest P000536 | rep | TN | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
26115 | 26115 | James Richards R000214 | rep | SC | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
26131 | 26131 | Thomas Tumulty T000408 | rep | NJ | 1955-01-05 | 1957-01-03 | Democrat | 14 | |||||||||||||
26151 | 26151 | Robert Humphreys H000963 | sen | KY | 1956-06-21 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
26152 | 26152 | William Laird L000025 | sen | WV | 1956-03-13 | 1957-01-03 | 1 | Democrat | appointment | ||||||||||||
26155 | 26155 | Thomas Wofford W000666 | sen | SC | 1956-04-05 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
26183 | 26183 | James Bowler B000698 | rep | IL | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
26226 | 26226 | Earl Chudoff C000386 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
26263 | 26263 | Jere Cooper C000755 | rep | TN | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
26293 | 26293 | John Dempsey D000228 | rep | NM | 1955-01-05 | 1957-01-03 | Democrat | 0 | |||||||||||||
26308 | 26308 | Martin Dies D000338 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 0 | |||||||||||||
26319 | 26319 | Herman Eberharter E000029 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 28 | |||||||||||||
26332 | 26332 | Thomas Gordon G000316 | rep | IL | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
26343 | 26343 | Noble Gregory G000447 | rep | KY | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
26376 | 26376 | Lawrence Hays H000405 | rep | AR | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
26381 | 26381 | Thomas Hennings H000502 | sen | MO | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
26462 | 26462 | Augustine Kelley K000058 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 21 | |||||||||||||
26464 | 26464 | Coya Knutson K000300 | rep | MN | 1955-01-05 | 1957-01-03 | Democrat | 9 | |||||||||||||
26473 | 26473 | Henderson Lanham L000077 | rep | GA | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
26493 | 26493 | George Long L000416 | rep | LA | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
26568 | 26568 | Edward Robeson R000329 | rep | VA | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
26597 | 26597 | George Shuford S000390 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 12 | |||||||||||||
26601 | 26601 | Alfred Sieminski S000405 | rep | NJ | 1955-01-05 | 1957-01-03 | Democrat | 13 | |||||||||||||
26718 | 26718 | Graham Barden B000139 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
26742 | 26742 | Charles Boyle B000727 | rep | IL | 1955-01-05 | 1957-01-03 | Democrat | 12 | |||||||||||||
26759 | 26759 | Paul Brown B000940 | rep | GA | 1955-01-05 | 1957-01-03 | Democrat | 10 | |||||||||||||
26796 | 26796 | Albert Carnahan C000162 | rep | MO | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
26808 | 26808 | George Christopher C000383 | rep | MO | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
26819 | 26819 | Isidore Dollinger D000402 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 23 | |||||||||||||
26834 | 26834 | Carl Durham D000571 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
26844 | 26844 | Clair Engle E000181 | rep | CA | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
26857 | 26857 | Aime Forand F000255 | rep | RI | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
26935 | 26935 | James Polk P000408 | rep | OH | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
26944 | 26944 | Prince Preston P000516 | rep | GA | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
26948 | 26948 | James Quigley Q000012 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 19 | |||||||||||||
27043 | 27043 | Roy Wier W000446 | rep | MN | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
27064 | 27064 | Hugh Addonizio A000054 | rep | NJ | 1955-01-05 | 1957-01-03 | Democrat | 11 | |||||||||||||
27069 | 27069 | Hugh Alexander A000094 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 9 | |||||||||||||
27088 | 27088 | Victor Anfuso A000255 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
27096 | 27096 | Cleveland Bailey B000035 | rep | WV | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
27106 | 27106 | Iris Blitch B000561 | rep | GA | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
27120 | 27120 | Frank Boykin B000725 | rep | AL | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
27136 | 27136 | Overton Brooks B000884 | rep | LA | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
27174 | 27174 | James Davis D000109 | rep | GA | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
27207 | 27207 | James Frazier F000353 | rep | TN | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
27212 | 27212 | Kathryn Granahan G000368 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
27221 | 27221 | Burr Harrison H000264 | rep | VA | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
27246 | 27246 | Lester Holtzman H000753 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
27252 | 27252 | Frank Ikard I000007 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 13 | |||||||||||||
27295 | 27295 | Paul Kilday K000171 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 20 | |||||||||||||
27311 | 27311 | Thomas Lane L000065 | rep | MA | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
27320 | 27320 | Thaddeus Machrowicz M000014 | rep | MI | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
27327 | 27327 | Peter Mack M000020 | rep | IL | 1955-01-05 | 1957-01-03 | Democrat | 21 | |||||||||||||
27332 | 27332 | Donald Magnuson M000052 | rep | WA | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
27339 | 27339 | Fred Marshall M000152 | rep | MN | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
27386 | 27386 | Morgan Moulder M001045 | rep | MO | 1955-01-05 | 1957-01-03 | Democrat | 11 | |||||||||||||
27406 | 27406 | William Norrell N000137 | rep | AR | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
27412 | 27412 | Gracie Pfost P000287 | rep | ID | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
27425 | 27425 | Louis Rabaut R000001 | rep | MI | 1955-01-05 | 1957-01-03 | Democrat | 14 | |||||||||||||
27455 | 27455 | Samuel Rayburn R000082 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
27483 | 27483 | John Riley R000260 | rep | SC | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
27498 | 27498 | J. Rutherford R000547 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 16 | |||||||||||||
27529 | 27529 | Frank Smith S000533 | rep | MS | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
27545 | 27545 | Brent Spence S000717 | rep | KY | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
27569 | 27569 | Stewart Udall U000002 | rep | AZ | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
27590 | 27590 | Herbert Zelenko Z000003 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 21 | |||||||||||||
27673 | 27673 | Charles Buckley B001024 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 24 | |||||||||||||
27695 | 27695 | Clarence Cannon C000117 | rep | MO | 1955-01-05 | 1957-01-03 | Democrat | 9 | |||||||||||||
27731 | 27731 | Clifford Davis D000094 | rep | TN | 1955-01-05 | 1957-01-03 | Democrat | 9 | |||||||||||||
27757 | 27757 | Clyde Doyle D000481 | rep | CA | 1955-01-05 | 1957-01-03 | Democrat | 23 | |||||||||||||
27766 | 27766 | Carl Elliott E000120 | rep | AL | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
27785 | 27785 | Elijah Forrester F000283 | rep | GA | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
27795 | 27795 | Julian Gary G000091 | rep | VA | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
27825 | 27825 | George Grant G000381 | rep | AL | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
27834 | 27834 | William Green G000421 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
27855 | 27855 | Carl Hayden H000385 | sen | AZ | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
27858 | 27858 | James Healey H000424 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 22 | |||||||||||||
27882 | 27882 | Joseph Hill H000598 | sen | AL | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
27910 | 27910 | George Huddleston H000904 | rep | AL | 1955-01-05 | 1957-01-03 | Democrat | 9 | |||||||||||||
27934 | 27934 | Lester Johnson J000158 | rep | WI | 1955-01-05 | 1957-01-03 | Democrat | 9 |
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);