legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1955-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27528 | 27528 | Frank Smith S000533 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27544 | 27544 | Brent Spence S000717 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
27672 | 27672 | Charles Buckley B001024 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 24 | |||||||||||||
27694 | 27694 | Clarence Cannon C000117 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
27730 | 27730 | Clifford Davis D000094 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
27756 | 27756 | Clyde Doyle D000481 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 23 | |||||||||||||
27765 | 27765 | Carl Elliott E000120 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27784 | 27784 | Elijah Forrester F000283 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27794 | 27794 | Julian Gary G000091 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27824 | 27824 | George Grant G000381 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
27833 | 27833 | William Green G000421 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
27933 | 27933 | Lester Johnson J000158 | rep | WI | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
27944 | 27944 | Maude Kee K000040 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
27985 | 27985 | John Lesinski L000252 | rep | MI | 1953-01-03 | 1955-01-03 | Democrat | 16 | |||||||||||||
28061 | 28061 | Thomas O’Brien O000016 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
28083 | 28083 | John Pilcher P000349 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28099 | 28099 | Albert Rains R000018 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28116 | 28116 | Kenneth Roberts R000314 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28133 | 28133 | John Shelley S000327 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28147 | 28147 | Harry Sheppard S000335 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 27 | |||||||||||||
28181 | 28181 | William Thornberry T000237 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
28223 | 28223 | Carl Vinson V000105 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
28242 | 28242 | Francis Walter W000108 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 15 | |||||||||||||
28268 | 28268 | Victor Wickersham W000439 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
28288 | 28288 | William Winstead W000641 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28300 | 28300 | Lyndon Johnson J000160 | sen | TX | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28336 | 28336 | Herbert Bonner B000621 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28365 | 28365 | Frank Chelf C000342 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28383 | 28383 | Harold Cooley C000736 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28414 | 28414 | Thomas Dodd D000390 | rep | CT | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28439 | 28439 | Harlan Hagen H000013 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
28453 | 28453 | Oren Harris H000249 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28485 | 28485 | Paul Jones J000246 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
28501 | 28501 | Eugene Keogh K000130 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
28550 | 28550 | Donald Matthews M000253 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
28559 | 28559 | Eugene McCarthy M000311 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28579 | 28579 | James Morrison M000995 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
28592 | 28592 | Thomas Murray M001114 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
28600 | 28600 | Leo O’Brien O000015 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 30 | |||||||||||||
28622 | 28622 | Walter Rogers R000404 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 18 | |||||||||||||
28650 | 28650 | Robert Secrest S000219 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 15 | |||||||||||||
28668 | 28668 | Howard Smith S000554 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
28685 | 28685 | Albert Thomas T000156 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
28697 | 28697 | Clark Thompson T000198 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
28704 | 28704 | Theo Thompson T000218 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
28720 | 28720 | James Trimble T000373 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
28760 | 28760 | Clinton Anderson A000186 | sen | NM | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28764 | 28764 | Robert Ashmore A000223 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28776 | 28776 | Edward Bartlett B000201 | rep | AK | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
28818 | 28818 | Allen Ellender E000112 | sen | LA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28836 | 28836 | John Fogarty F000233 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28852 | 28852 | Ezekiel Gathings G000098 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28880 | 28880 | Porter Hardy H000197 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28897 | 28897 | Albert Herlong H000530 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28924 | 28924 | Frank Karsten K000013 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28934 | 28934 | Edna Kelly K000070 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
28948 | 28948 | Cecil King K000196 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 17 | |||||||||||||
28980 | 28980 | Abraham Multer M001074 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 13 | |||||||||||||
28999 | 28999 | Barratt O’Hara O000053 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
29016 | 29016 | George Rhodes R000187 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
29027 | 29027 | Richard Russell R000536 | sen | GA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
29031 | 29031 | Armistead Selden S000232 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
29051 | 29051 | William Tuck T000395 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
29070 | 29070 | John Williams W000517 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29080 | 29080 | Edwin Willis W000559 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29209 | 29209 | William Dawson D000158 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29239 | 29239 | George Fallon F000012 | rep | MD | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29260 | 29260 | Michael Feighan F000060 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 20 | |||||||||||||
29271 | 29271 | Samuel Friedel F000384 | rep | MD | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
29310 | 29310 | Michael Kirwan K000244 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 19 | |||||||||||||
29377 | 29377 | John McCormack M000364 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 12 | |||||||||||||
29411 | 29411 | Philip Philbin P000303 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29426 | 29426 | Adam Powell P000477 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 16 | |||||||||||||
29449 | 29449 | Lucius Rivers R000280 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29459 | 29459 | Byron Rogers R000389 | rep | CO | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29514 | 29514 | Watkins Abbitt A000002 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29529 | 29529 | Thomas Abernethy A000016 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29549 | 29549 | George Andrews A000206 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29561 | 29561 | Wayne Aspinall A000225 | rep | CO | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29613 | 29613 | Thomas Boggs B000594 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
29640 | 29640 | James Byrne B001212 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29686 | 29686 | Emanuel Celler C000264 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 11 | |||||||||||||
29706 | 29706 | William Colmer C000645 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
29739 | 29739 | John Dowdy D000467 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
29757 | 29757 | Edmond Edmondson E000054 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
29804 | 29804 | Edward Garmatz G000071 | rep | MD | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29884 | 29884 | Alton Lennon L000240 | sen | NC | 1953-07-10 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
29938 | 29938 | John McMillan M000568 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
29952 | 29952 | George Miller M000727 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
30118 | 30118 | John Watts W000212 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
30168 | 30168 | John Blatnik B000550 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
30305 | 30305 | Harold Donohue D000419 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
30318 | 30318 | William Dorn D000434 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30339 | 30339 | James Eastland E000018 | sen | MS | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30349 | 30349 | Ovie Fisher F000152 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
30486 | 30486 | Chester Holifield H000713 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 19 | |||||||||||||
30566 | 30566 | John McClellan M000332 | sen | AR | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30575 | 30575 | Lee Metcalf M000671 | rep | MT | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
30646 | 30646 | John Rooney R000424 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
30700 | 30700 | John Sparkman S000701 | sen | AL | 1949-01-03 | 1955-01-03 | 2 | Democrat |
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);