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 party
This data as json, copyable, CSV (advanced)
Suggested facets: party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25866 | 25866 | William Scott S000187 | sen | NC | 1955-01-03 | 1959-01-03 | 2 | Democrat | |||||||||||||
26184 | 26184 | James Bowler B000698 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26227 | 26227 | Earl Chudoff C000386 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26264 | 26264 | Jere Cooper C000755 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
26377 | 26377 | Lawrence Hays H000405 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
26474 | 26474 | Henderson Lanham L000077 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26494 | 26494 | George Long L000416 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26569 | 26569 | Edward Robeson R000329 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
26706 | 26706 | LeRoy Anderson A000200 | rep | MT | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26719 | 26719 | Graham Barden B000139 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
26743 | 26743 | Charles Boyle B000727 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
26746 | 26746 | Charles Brown B000908 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26760 | 26760 | Paul Brown B000940 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
26768 | 26768 | John Burns B001127 | rep | HI | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
26779 | 26779 | Harry Byrd B001208 | sen | VA | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
26797 | 26797 | Albert Carnahan C000162 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26805 | 26805 | Dennis Chavez C000338 | sen | NM | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
26809 | 26809 | George Christopher C000383 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26811 | 26811 | Frank Coffin C000589 | rep | ME | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26820 | 26820 | Isidore Dollinger D000402 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 23 | |||||||||||||
26835 | 26835 | Carl Durham D000571 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
26845 | 26845 | Clair Engle E000181 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26858 | 26858 | Aime Forand F000255 | rep | RI | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26916 | 26916 | Harlan Mitchell M000812 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26921 | 26921 | Toby Morris M000991 | rep | OK | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
26936 | 26936 | James Polk P000408 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
26938 | 26938 | Charles Porter P000439 | rep | OR | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26945 | 26945 | Prince Preston P000516 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27030 | 27030 | Ludwig Teller T000118 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
27044 | 27044 | Roy Wier W000446 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27065 | 27065 | Hugh Addonizio A000054 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
27070 | 27070 | Hugh Alexander A000094 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27089 | 27089 | Victor Anfuso A000255 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27097 | 27097 | Cleveland Bailey B000035 | rep | WV | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27107 | 27107 | Iris Blitch B000561 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27121 | 27121 | Frank Boykin B000725 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27124 | 27124 | James Breeding B000791 | rep | KS | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27137 | 27137 | Overton Brooks B000884 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
27160 | 27160 | Merwin Coad C000540 | rep | IA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27175 | 27175 | James Davis D000109 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27208 | 27208 | James Frazier F000353 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27213 | 27213 | Kathryn Granahan G000368 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27222 | 27222 | Burr Harrison H000264 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27247 | 27247 | Lester Holtzman H000753 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27253 | 27253 | Frank Ikard I000007 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 13 | |||||||||||||
27296 | 27296 | Paul Kilday K000171 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
27299 | 27299 | Alvin Kitchin K000249 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27312 | 27312 | Thomas Lane L000065 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27315 | 27315 | Joseph Loser L000446 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27321 | 27321 | Thaddeus Machrowicz M000014 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27328 | 27328 | Peter Mack M000020 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
27333 | 27333 | Donald Magnuson M000052 | rep | WA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27340 | 27340 | Fred Marshall M000152 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27387 | 27387 | Morgan Moulder M001045 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
27407 | 27407 | William Norrell N000137 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27413 | 27413 | Gracie Pfost P000287 | rep | ID | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27426 | 27426 | Louis Rabaut R000001 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
27456 | 27456 | Samuel Rayburn R000082 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
27484 | 27484 | John Riley R000260 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27499 | 27499 | J. Rutherford R000547 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 16 | |||||||||||||
27506 | 27506 | Alfred Santangelo S000057 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
27509 | 27509 | Dalip Saund S000075 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 29 | |||||||||||||
27530 | 27530 | Frank Smith S000533 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27546 | 27546 | Brent Spence S000717 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27570 | 27570 | Stewart Udall U000002 | rep | AZ | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27591 | 27591 | Herbert Zelenko Z000003 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
27597 | 27597 | John Kennedy K000107 | sen | MA | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
27674 | 27674 | Charles Buckley B001024 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 24 | |||||||||||||
27696 | 27696 | Clarence Cannon C000117 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27732 | 27732 | Clifford Davis D000094 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27758 | 27758 | Clyde Doyle D000481 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 23 | |||||||||||||
27767 | 27767 | Carl Elliott E000120 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27786 | 27786 | Elijah Forrester F000283 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27796 | 27796 | Julian Gary G000091 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27826 | 27826 | George Grant G000381 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27835 | 27835 | William Green G000421 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27859 | 27859 | James Healey H000424 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 22 | |||||||||||||
27863 | 27863 | Robert Hemphill H000471 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27911 | 27911 | George Huddleston H000904 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27935 | 27935 | Lester Johnson J000158 | rep | WI | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27946 | 27946 | Maude Kee K000040 | rep | WV | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27964 | 27964 | Joe Kilgore K000177 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 15 | |||||||||||||
27978 | 27978 | Richard Lankford L000081 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27987 | 27987 | John Lesinski L000252 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 16 | |||||||||||||
27991 | 27991 | Roland Libonati L000299 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
28063 | 28063 | Thomas O’Brien O000016 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28085 | 28085 | John Pilcher P000349 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28101 | 28101 | Albert Rains R000018 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28118 | 28118 | Kenneth Roberts R000314 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28135 | 28135 | John Shelley S000327 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 5 |
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);