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 district
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25109 | 25109 | Earle Clements C000506 | sen | KY | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25234 | 25234 | James Duff D000516 | sen | PA | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
25389 | 25389 | Eugene Millikin M000771 | sen | CO | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
25539 | 25539 | Herman Welker W000269 | sen | ID | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
25739 | 25739 | Harley Kilgore K000176 | sen | WV | 1953-01-03 | 1957-01-03 | 1 | Democrat | |||||||||||||
25853 | 25853 | George Bender B000356 | sen | OH | 1954-01-01 | 1957-01-03 | 3 | Republican | |||||||||||||
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 | ||||||||||||
26199 | 26199 | Prescott Bush B001167 | sen | CT | 1952-01-01 | 1957-01-03 | 3 | Republican | |||||||||||||
26201 | 26201 | John Butler B001180 | sen | MD | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26205 | 26205 | Homer Capehart C000128 | sen | IN | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26221 | 26221 | Francis Case C000221 | sen | SD | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26381 | 26381 | Thomas Hennings H000502 | sen | MO | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
26669 | 26669 | Alexander Wiley W000465 | sen | WI | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
27707 | 27707 | Frank Carlson C000154 | sen | KS | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
27750 | 27750 | Everett Dirksen D000360 | sen | IL | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
27855 | 27855 | Carl Hayden H000385 | sen | AZ | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
27868 | 27868 | Bourke Hickenlooper H000559 | sen | IA | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
27882 | 27882 | Joseph Hill H000598 | sen | AL | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
27940 | 27940 | Olin Johnston J000195 | sen | SC | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
27974 | 27974 | Thomas Kuchel K000335 | sen | CA | 1953-01-03 | 1957-01-03 | 3 | Republican | appointment | ||||||||||||
28029 | 28029 | Almer Monroney M000859 | sen | OK | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
28033 | 28033 | Wayne Morse M001014 | sen | OR | 1951-01-03 | 1957-01-03 | 3 | Independent | |||||||||||||
28165 | 28165 | George Smathers S000505 | sen | FL | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
29115 | 29115 | George Aiken A000062 | sen | VT | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
29145 | 29145 | Wallace Bennett B000384 | sen | UT | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
29159 | 29159 | Alan Bible B000436 | sen | NV | 1954-12-02 | 1957-01-03 | 3 | Democrat | |||||||||||||
29224 | 29224 | Samuel Ervin E000211 | sen | NC | 1954-06-05 | 1957-01-03 | 3 | Democrat | appointment | ||||||||||||
29282 | 29282 | James Fulbright F000401 | sen | AR | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
30881 | 30881 | Norris Cotton C000802 | sen | NH | 1954-11-08 | 1957-01-03 | 3 | Republican | |||||||||||||
31166 | 31166 | Warren Magnuson M000053 | sen | WA | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
31403 | 31403 | Milton Young Y000047 | sen | ND | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
32734 | 32734 | Russell Long L000428 | sen | LA | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25952 | 25952 | Mary Farrington F000035 | rep | HI | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26150 | 26150 | Clarence Young Y000032 | rep | NV | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26197 | 26197 | Usher Burdick B001079 | rep | ND | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
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 | |||||||||||||
26467 | 26467 | Otto Krueger K000332 | rep | ND | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26577 | 26577 | Antoni Sadlak S000009 | rep | CT | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
27032 | 27032 | Edwin Thomson T000229 | rep | WY | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
27776 | 27776 | Antonio Fernós-Isern F000087 | rep | PR | 1955-01-05 | 1957-01-03 | Popular Democrat | 0 | |||||||||||||
28564 | 28564 | Harris McDowell M000418 | rep | DE | 1955-01-05 | 1957-01-03 | Democrat | 0 | |||||||||||||
28611 | 28611 | Winston Prouty P000552 | rep | VT | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
28777 | 28777 | Edward Bartlett B000201 | rep | AK | 1955-01-05 | 1957-01-03 | Democrat | 0 | |||||||||||||
26047 | 26047 | Harold Lovre L000468 | rep | SD | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26176 | 26176 | August Andresen A000239 | rep | MN | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26343 | 26343 | Noble Gregory G000447 | rep | KY | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
26358 | 26358 | Robert Hale H000036 | rep | ME | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26388 | 26388 | John Heselton H000549 | rep | MA | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26531 | 26531 | Edward Miller M000724 | rep | MD | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26568 | 26568 | Edward Robeson R000329 | rep | VA | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
26590 | 26590 | Hubert Scudder S000198 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26618 | 26618 | Lawrence Smith S000585 | rep | WI | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26689 | 26689 | Charles Wolverton W000683 | rep | NJ | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26813 | 26813 | Henry Dixon D000368 | rep | UT | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26857 | 26857 | Aime Forand F000255 | rep | RI | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
26944 | 26944 | Prince Preston P000516 | rep | GA | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
27036 | 27036 | Stuyvesant Wainwright W000024 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
27120 | 27120 | Frank Boykin B000725 | rep | AL | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
27320 | 27320 | Thaddeus Machrowicz M000014 | rep | MI | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
27376 | 27376 | Chester Merrow M000664 | rep | NH | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
27412 | 27412 | Gracie Pfost P000287 | rep | ID | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
27473 | 27473 | Brazilla Reece R000108 | rep | TN | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
27513 | 27513 | Gordon Scherer S000120 | rep | OH | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
27584 | 27584 | Phillip Weaver W000228 | rep | NE | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
27619 | 27619 | William Avery A000228 | rep | KS | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
28046 | 28046 | Albin Norblad N000133 | rep | OR | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
28337 | 28337 | Herbert Bonner B000621 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
28415 | 28415 | Thomas Dodd D000390 | rep | CT | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
28853 | 28853 | Ezekiel Gathings G000098 | rep | AR | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
28925 | 28925 | Frank Karsten K000013 | rep | MO | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
29183 | 29183 | William Cramer C000869 | rep | FL | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
29210 | 29210 | William Dawson D000158 | rep | IL | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
29450 | 29450 | Lucius Rivers R000280 | rep | SC | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
29460 | 29460 | Byron Rogers R000389 | rep | CO | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
29530 | 29530 | Thomas Abernethy A000016 | rep | MS | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
29586 | 29586 | Page Belcher B000323 | rep | OK | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
30011 | 30011 | Thomas Pelly P000196 | rep | WA | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
30063 | 30063 | Frederick Schwengel S000161 | rep | IA | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
30576 | 30576 | Lee Metcalf M000671 | rep | MT | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
30824 | 30824 | William Barrett B000178 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
31042 | 31042 | Felix Hébert H000437 | rep | LA | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
31149 | 31149 | Ray Madden M000039 | rep | IN | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
31265 | 31265 | John Patman P000103 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
32782 | 32782 | Robert Mollohan M000845 | rep | WV | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
32824 | 32824 | John Rhodes R000188 | rep | AZ | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
25895 | 25895 | Jackson Chase C000327 | rep | NE | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
25901 | 25901 | Samuel Coon C000743 | rep | OR | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
25963 | 25963 | Orvin Fjare F000179 | rep | MT | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
25982 | 25982 | William Granahan G000369 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
25992 | 25992 | Thomas Hand H000154 | rep | NJ | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26076 | 26076 | Charles Nelson N000031 | rep | ME | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26285 | 26285 | William Dawson D000155 | rep | UT | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26298 | 26298 | James Devereux D000278 | rep | MD | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26397 | 26397 | William Hill H000613 | rep | CO | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26553 | 26553 | Joseph O’Hara O000056 | rep | MN | 1955-01-05 | 1957-01-03 | Republican | 2 |
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);