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 caucus
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25576 | 25576 | Charles Potter P000460 | sen | MI | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25589 | 25589 | Frank Barrett B000176 | sen | WY | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25607 | 25607 | John Bricker B000820 | sen | OH | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25672 | 25672 | Ralph Flanders F000190 | sen | VT | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25727 | 25727 | Irving Ives I000050 | sen | NY | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25730 | 25730 | William Jenner J000093 | sen | IN | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25742 | 25742 | William Knowland K000292 | sen | CA | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25745 | 25745 | William Langer L000070 | sen | ND | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25759 | 25759 | George Malone M000086 | sen | NV | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25761 | 25761 | Edward Martin M000177 | sen | PA | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25777 | 25777 | Frederick Payne P000150 | sen | ME | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25784 | 25784 | William Purtell P000575 | sen | CT | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25811 | 25811 | Howard Smith S000553 | sen | NJ | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25822 | 25822 | Edward Thye T000259 | sen | MN | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25826 | 25826 | Arthur Watkins W000190 | sen | UT | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25866 | 25866 | William Scott S000187 | sen | NC | 1955-01-03 | 1959-01-03 | 2 | Democrat | |||||||||||||
26154 | 26154 | William Revercomb R000167 | sen | WV | 1956-01-01 | 1959-01-03 | 1 | Republican | |||||||||||||
26161 | 26161 | John Allen A000133 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26177 | 26177 | August Andresen A000239 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26181 | 26181 | John Beamer B000276 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26184 | 26184 | James Bowler B000698 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26188 | 26188 | Charles Brownson B000964 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
26198 | 26198 | Usher Burdick B001079 | rep | ND | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26203 | 26203 | Emmet Byrne B001211 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26210 | 26210 | Joseph Carrigg C000182 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
26227 | 26227 | Earl Chudoff C000386 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26237 | 26237 | Cliff Clevenger C000515 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26249 | 26249 | William Cole C000617 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 37 | |||||||||||||
26264 | 26264 | Jere Cooper C000755 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26270 | 26270 | Frederic Coudert C000804 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26273 | 26273 | Albert Cretella C000905 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26282 | 26282 | Paul Cunningham C000993 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26286 | 26286 | William Dawson D000155 | rep | UT | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26287 | 26287 | Vincent Dellay D000219 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
26294 | 26294 | John Dempsey D000228 | rep | NM | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
26295 | 26295 | David Dennison D000246 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
26299 | 26299 | James Devereux D000278 | rep | MD | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26309 | 26309 | Martin Dies D000338 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
26320 | 26320 | Herman Eberharter E000029 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 28 | |||||||||||||
26325 | 26325 | Myron George G000129 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26333 | 26333 | Thomas Gordon G000316 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26344 | 26344 | Noble Gregory G000447 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26351 | 26351 | Ralph Gwinn G000541 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 27 | |||||||||||||
26359 | 26359 | Robert Hale H000036 | rep | ME | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26364 | 26364 | Cecil Harden H000182 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26368 | 26368 | Robert Harrison H000275 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26369 | 26369 | Harry Haskell H000318 | rep | DE | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26377 | 26377 | Lawrence Hays H000405 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
26389 | 26389 | John Heselton H000549 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26398 | 26398 | William Hill H000613 | rep | CO | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26402 | 26402 | Patrick Hillings H000623 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 25 | |||||||||||||
26410 | 26410 | Otis Holmes H000740 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26413 | 26413 | DeWitt Hyde H001021 | rep | MD | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26418 | 26418 | Benjamin James J000045 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26435 | 26435 | Thomas Jenkins J000088 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
26445 | 26445 | Robert Kean K000029 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
26453 | 26453 | Bernard Kearney K000030 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 32 | |||||||||||||
26454 | 26454 | Russell Keeney K000042 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 14 | |||||||||||||
26463 | 26463 | Augustine Kelley K000058 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
26465 | 26465 | Coya Knutson K000300 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
26468 | 26468 | Otto Krueger K000332 | rep | ND | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26474 | 26474 | Henderson Lanham L000077 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26481 | 26481 | Henry Latham L000108 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26491 | 26491 | Karl Le Compte L000157 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26494 | 26494 | George Long L000416 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26495 | 26495 | Edwin May M000274 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26503 | 26503 | Samuel McConnell M000354 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26513 | 26513 | J. McGregor M000460 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26514 | 26514 | Robert McIntosh M000483 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26518 | 26518 | William McVey M000609 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26526 | 26526 | Arthur Miller M000715 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26532 | 26532 | Edward Miller M000724 | rep | MD | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26536 | 26536 | Albert Morano M000935 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26538 | 26538 | William Neal N000017 | rep | WV | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26544 | 26544 | Donald Nicholson N000097 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
26545 | 26545 | F. Nimtz N000110 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26554 | 26554 | Joseph O’Hara O000056 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26560 | 26560 | James Patterson P000119 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26564 | 26564 | Edmund Radwan R000008 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 41 | |||||||||||||
26569 | 26569 | Edward Robeson R000329 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26572 | 26572 | John Robsion R000359 | rep | KY | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26578 | 26578 | Antoni Sadlak S000009 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26586 | 26586 | Errett Scrivner S000194 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26591 | 26591 | Hubert Scudder S000198 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26595 | 26595 | Timothy Sheehan S000315 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
26598 | 26598 | George Shuford S000390 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
26602 | 26602 | Alfred Sieminski S000405 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 13 | |||||||||||||
26610 | 26610 | Sidney Simpson S000437 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
26619 | 26619 | Lawrence Smith S000585 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26621 | 26621 | Simon Stauffer S000819 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 19 | |||||||||||||
26631 | 26631 | Henry Talle T000028 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26632 | 26632 | Donald Tewes T000139 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26642 | 26642 | John Vorys V000119 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
26650 | 26650 | Charles Vursell V000125 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 23 | |||||||||||||
26666 | 26666 | Richard Wigglesworth W000450 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26674 | 26674 | William Williams W000549 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 34 | |||||||||||||
26690 | 26690 | Charles Wolverton W000683 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26691 | 26691 | John Hoblitzell H000665 | sen | WV | 1958-01-25 | 1959-01-03 | 2 | Republican | appointment | ||||||||||||
26704 | 26704 | Leo Allen A000138 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
26706 | 26706 | LeRoy Anderson A000200 | rep | MT | 1957-01-03 | 1959-01-03 | Democrat | 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);