legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
483 rows where "end" is on date 1961-01-03 sorted by party
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27797 | 27797 | Julian Gary G000091 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
27827 | 27827 | George Grant G000381 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
27836 | 27836 | William Green G000421 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27860 | 27860 | James Healey H000424 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 22 | |||||||||||||
27864 | 27864 | Robert Hemphill H000471 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27912 | 27912 | George Huddleston H000904 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
27936 | 27936 | Lester Johnson J000158 | rep | WI | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
27947 | 27947 | Maude Kee K000040 | rep | WV | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27965 | 27965 | Joe Kilgore K000177 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 15 | |||||||||||||
27979 | 27979 | Richard Lankford L000081 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27988 | 27988 | John Lesinski L000252 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 16 | |||||||||||||
27992 | 27992 | Roland Libonati L000299 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
28064 | 28064 | Thomas O’Brien O000016 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28086 | 28086 | John Pilcher P000349 | rep | GA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
28102 | 28102 | Albert Rains R000018 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28119 | 28119 | Kenneth Roberts R000314 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28136 | 28136 | John Shelley S000327 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28150 | 28150 | Harry Sheppard S000335 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 27 | |||||||||||||
28184 | 28184 | William Thornberry T000237 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
28226 | 28226 | Carl Vinson V000105 | rep | GA | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28245 | 28245 | Francis Walter W000108 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 15 | |||||||||||||
28291 | 28291 | William Winstead W000641 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28301 | 28301 | Lyndon Johnson J000160 | sen | TX | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
28304 | 28304 | Ross Bass B000223 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28325 | 28325 | Lindley Beckworth B000296 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
28339 | 28339 | Herbert Bonner B000621 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
28368 | 28368 | Frank Chelf C000342 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28386 | 28386 | Harold Cooley C000736 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28410 | 28410 | Winfield Denton D000260 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
28442 | 28442 | Harlan Hagen H000013 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
28456 | 28456 | Oren Harris H000249 | rep | AR | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28477 | 28477 | William Jennings J000098 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
28488 | 28488 | Paul Jones J000246 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
28504 | 28504 | Eugene Keogh K000130 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
28508 | 28508 | David King K000199 | rep | UT | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
28553 | 28553 | Donald Matthews M000253 | rep | FL | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
28565 | 28565 | Harris McDowell M000418 | rep | DE | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
28571 | 28571 | Walter Moeller M000836 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
28582 | 28582 | James Morrison M000995 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28595 | 28595 | Thomas Murray M001114 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
28603 | 28603 | Leo O’Brien O000015 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 30 | |||||||||||||
28617 | 28617 | Ralph Rivers R000282 | rep | AK | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
28625 | 28625 | Walter Rogers R000404 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 18 | |||||||||||||
28631 | 28631 | James Roosevelt R000426 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 26 | |||||||||||||
28639 | 28639 | Ralph Scott S000184 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28671 | 28671 | Howard Smith S000554 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
28688 | 28688 | Albert Thomas T000156 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
28700 | 28700 | Clark Thompson T000198 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
28707 | 28707 | Theo Thompson T000218 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
28712 | 28712 | Herman Toll T000297 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28723 | 28723 | James Trimble T000373 | rep | AR | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
28761 | 28761 | Clinton Anderson A000186 | sen | NM | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
28767 | 28767 | Robert Ashmore A000223 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28779 | 28779 | Edward Bartlett B000201 | sen | AK | 1959-01-07 | 1961-01-03 | 2 | Democrat | |||||||||||||
28819 | 28819 | Allen Ellender E000112 | sen | LA | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
28839 | 28839 | John Fogarty F000233 | rep | RI | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
28855 | 28855 | Ezekiel Gathings G000098 | rep | AR | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
28883 | 28883 | Porter Hardy H000197 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
28900 | 28900 | Albert Herlong H000530 | rep | FL | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28908 | 28908 | Elmer Holland H000717 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 30 | |||||||||||||
28913 | 28913 | Donald Irwin I000039 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28916 | 28916 | Benjamin Jordan J000267 | sen | NC | 1958-04-19 | 1961-01-03 | 2 | Democrat | appointment | ||||||||||||
28927 | 28927 | Frank Karsten K000013 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
28937 | 28937 | Edna Kelly K000070 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
28951 | 28951 | Cecil King K000196 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 17 | |||||||||||||
28972 | 28972 | Thomas Morris M000990 | rep | NM | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
28983 | 28983 | Abraham Multer M001074 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 13 | |||||||||||||
29002 | 29002 | Barratt O’Hara O000053 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
29019 | 29019 | George Rhodes R000187 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
29028 | 29028 | Richard Russell R000536 | sen | GA | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
29034 | 29034 | Armistead Selden S000232 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
29054 | 29054 | William Tuck T000395 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
29062 | 29062 | Basil Whitener W000410 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
29073 | 29073 | John Williams W000517 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29083 | 29083 | Edwin Willis W000559 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29175 | 29175 | Jeffery Cohelan C000596 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29198 | 29198 | Emilio Daddario D000001 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29212 | 29212 | William Dawson D000158 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29229 | 29229 | Robert Everett E000266 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
29242 | 29242 | George Fallon F000012 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29249 | 29249 | Leonard Farbstein F000015 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 19 | |||||||||||||
29263 | 29263 | Michael Feighan F000060 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 20 | |||||||||||||
29274 | 29274 | Samuel Friedel F000384 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29286 | 29286 | Jacob Gilbert G000175 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 23 | |||||||||||||
29313 | 29313 | Michael Kirwan K000244 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 19 | |||||||||||||
29380 | 29380 | John McCormack M000364 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 12 | |||||||||||||
29392 | 29392 | William Murphy M001104 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29414 | 29414 | Philip Philbin P000303 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29429 | 29429 | Adam Powell P000477 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 16 | |||||||||||||
29452 | 29452 | Lucius Rivers R000280 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29462 | 29462 | Byron Rogers R000389 | rep | CO | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29517 | 29517 | Watkins Abbitt A000002 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29532 | 29532 | Thomas Abernethy A000016 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29552 | 29552 | George Andrews A000206 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29564 | 29564 | Wayne Aspinall A000225 | rep | CO | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29574 | 29574 | Walter Baring B000141 | rep | NV | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
29616 | 29616 | Thomas Boggs B000594 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
29643 | 29643 | James Byrne B001212 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29689 | 29689 | Emanuel Celler C000264 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
29709 | 29709 | William Colmer C000645 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 6 |
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);