legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
441 rows where end = "1957-01-03" and "start" is on date 1955-01-05
This data as json, copyable, CSV (advanced)
Suggested facets: start (date), end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
25895 | 25895 | Jackson Chase C000327 | rep | NE | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
25899 | 25899 | Richard Chatham C000336 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
25901 | 25901 | Samuel Coon C000743 | rep | OR | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
25904 | 25904 | Shepard Crumpacker C000960 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
25928 | 25928 | James Dolliver D000403 | rep | IA | 1955-01-05 | 1957-01-03 | Republican | 6 | |||||||||||||
25940 | 25940 | George Dondero D000411 | rep | MI | 1955-01-05 | 1957-01-03 | Republican | 18 | |||||||||||||
25943 | 25943 | James Donovan D000421 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 18 | |||||||||||||
25950 | 25950 | Mathew Ellsworth E000146 | rep | OR | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
25952 | 25952 | Mary Farrington F000035 | rep | HI | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
25962 | 25962 | Sidney Fine F000126 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 22 | |||||||||||||
25963 | 25963 | Orvin Fjare F000179 | rep | MT | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
25975 | 25975 | Ralph Gamble G000031 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 26 | |||||||||||||
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 | |||||||||||||
25992 | 25992 | Thomas Hand H000154 | rep | NJ | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
25993 | 25993 | Donald Hayworth H000412 | rep | MI | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
26002 | 26002 | John Hinshaw H000640 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 20 | |||||||||||||
26006 | 26006 | Richard Hoffman H000689 | rep | IL | 1955-01-05 | 1957-01-03 | Republican | 10 | |||||||||||||
26021 | 26021 | Clifford Hope H000768 | rep | KS | 1955-01-05 | 1957-01-03 | Republican | 5 | |||||||||||||
26028 | 26028 | Justin Johnson J000157 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 11 | |||||||||||||
26032 | 26032 | Woodrow Jones J000263 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 11 | |||||||||||||
26035 | 26035 | Karl King K000208 | rep | PA | 1955-01-05 | 1957-01-03 | Republican | 8 | |||||||||||||
26043 | 26043 | Arthur Klein K000261 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 19 | |||||||||||||
26047 | 26047 | Harold Lovre L000468 | rep | SD | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26057 | 26057 | James Murray M001107 | rep | IL | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
26076 | 26076 | Charles Nelson N000031 | rep | ME | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26084 | 26084 | John Phillips P000309 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 29 | |||||||||||||
26092 | 26092 | James Priest P000536 | rep | TN | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
26103 | 26103 | Chauncey Reed R000111 | rep | IL | 1955-01-05 | 1957-01-03 | Republican | 14 | |||||||||||||
26115 | 26115 | James Richards R000214 | rep | SC | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
26127 | 26127 | Dewey Short S000377 | rep | MO | 1955-01-05 | 1957-01-03 | Republican | 7 | |||||||||||||
26130 | 26130 | Ruth Thompson T000216 | rep | MI | 1955-01-05 | 1957-01-03 | Republican | 9 | |||||||||||||
26131 | 26131 | Thomas Tumulty T000408 | rep | NJ | 1955-01-05 | 1957-01-03 | Democrat | 14 | |||||||||||||
26135 | 26135 | Harold Velde V000082 | rep | IL | 1955-01-05 | 1957-01-03 | Republican | 18 | |||||||||||||
26148 | 26148 | Jesse Wolcott W000668 | rep | MI | 1955-01-05 | 1957-01-03 | Republican | 7 | |||||||||||||
26150 | 26150 | Clarence Young Y000032 | rep | NV | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26160 | 26160 | John Allen A000133 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 7 | |||||||||||||
26176 | 26176 | August Andresen A000239 | rep | MN | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26180 | 26180 | John Beamer B000276 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 5 | |||||||||||||
26183 | 26183 | James Bowler B000698 | rep | IL | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
26187 | 26187 | Charles Brownson B000964 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 11 | |||||||||||||
26197 | 26197 | Usher Burdick B001079 | rep | ND | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26209 | 26209 | Joseph Carrigg C000182 | rep | PA | 1955-01-05 | 1957-01-03 | Republican | 10 | |||||||||||||
26226 | 26226 | Earl Chudoff C000386 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
26236 | 26236 | Cliff Clevenger C000515 | rep | OH | 1955-01-05 | 1957-01-03 | Republican | 5 | |||||||||||||
26248 | 26248 | William Cole C000617 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 37 | |||||||||||||
26263 | 26263 | Jere Cooper C000755 | rep | TN | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
26269 | 26269 | Frederic Coudert C000804 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 17 | |||||||||||||
26272 | 26272 | Albert Cretella C000905 | rep | CT | 1955-01-05 | 1957-01-03 | Republican | 3 | |||||||||||||
26281 | 26281 | Paul Cunningham C000993 | rep | IA | 1955-01-05 | 1957-01-03 | Republican | 5 | |||||||||||||
26285 | 26285 | William Dawson D000155 | rep | UT | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26293 | 26293 | John Dempsey D000228 | rep | NM | 1955-01-05 | 1957-01-03 | Democrat | 0 | |||||||||||||
26298 | 26298 | James Devereux D000278 | rep | MD | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
26324 | 26324 | Myron George G000129 | rep | KS | 1955-01-05 | 1957-01-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
26350 | 26350 | Ralph Gwinn G000541 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 27 | |||||||||||||
26358 | 26358 | Robert Hale H000036 | rep | ME | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26363 | 26363 | Cecil Harden H000182 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 6 | |||||||||||||
26367 | 26367 | Robert Harrison H000275 | rep | NE | 1955-01-05 | 1957-01-03 | Republican | 3 | |||||||||||||
26376 | 26376 | Lawrence Hays H000405 | rep | AR | 1955-01-05 | 1957-01-03 | Democrat | 5 | |||||||||||||
26388 | 26388 | John Heselton H000549 | rep | MA | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26397 | 26397 | William Hill H000613 | rep | CO | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26401 | 26401 | Patrick Hillings H000623 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 25 | |||||||||||||
26409 | 26409 | Otis Holmes H000740 | rep | WA | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
26412 | 26412 | DeWitt Hyde H001021 | rep | MD | 1955-01-05 | 1957-01-03 | Republican | 6 | |||||||||||||
26417 | 26417 | Benjamin James J000045 | rep | PA | 1955-01-05 | 1957-01-03 | Republican | 7 | |||||||||||||
26434 | 26434 | Thomas Jenkins J000088 | rep | OH | 1955-01-05 | 1957-01-03 | Republican | 10 | |||||||||||||
26444 | 26444 | Robert Kean K000029 | rep | NJ | 1955-01-05 | 1957-01-03 | Republican | 12 | |||||||||||||
26452 | 26452 | Bernard Kearney K000030 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 32 | |||||||||||||
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 | |||||||||||||
26467 | 26467 | Otto Krueger K000332 | rep | ND | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26473 | 26473 | Henderson Lanham L000077 | rep | GA | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
26480 | 26480 | Henry Latham L000108 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
26490 | 26490 | Karl Le Compte L000157 | rep | IA | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
26493 | 26493 | George Long L000416 | rep | LA | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
26502 | 26502 | Samuel McConnell M000354 | rep | PA | 1955-01-05 | 1957-01-03 | Republican | 13 | |||||||||||||
26512 | 26512 | J. McGregor M000460 | rep | OH | 1955-01-05 | 1957-01-03 | Republican | 17 | |||||||||||||
26517 | 26517 | William McVey M000609 | rep | IL | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
26525 | 26525 | Arthur Miller M000715 | rep | NE | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
26531 | 26531 | Edward Miller M000724 | rep | MD | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26535 | 26535 | Albert Morano M000935 | rep | CT | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
26543 | 26543 | Donald Nicholson N000097 | rep | MA | 1955-01-05 | 1957-01-03 | Republican | 9 | |||||||||||||
26553 | 26553 | Joseph O’Hara O000056 | rep | MN | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26559 | 26559 | James Patterson P000119 | rep | CT | 1955-01-05 | 1957-01-03 | Republican | 5 | |||||||||||||
26563 | 26563 | Edmund Radwan R000008 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 41 | |||||||||||||
26568 | 26568 | Edward Robeson R000329 | rep | VA | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
26571 | 26571 | John Robsion R000359 | rep | KY | 1955-01-05 | 1957-01-03 | Republican | 3 | |||||||||||||
26577 | 26577 | Antoni Sadlak S000009 | rep | CT | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26585 | 26585 | Errett Scrivner S000194 | rep | KS | 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);