legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
486 rows where "end" is on date 1953-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26471 | 26471 | Henderson Lanham L000077 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
26566 | 26566 | Edward Robeson R000329 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26599 | 26599 | Alfred Sieminski S000405 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
26716 | 26716 | Graham Barden B000139 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
26757 | 26757 | Paul Brown B000940 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
26778 | 26778 | Harry Byrd B001208 | sen | VA | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
26794 | 26794 | Albert Carnahan C000162 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
26804 | 26804 | Dennis Chavez C000338 | sen | NM | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
26817 | 26817 | Isidore Dollinger D000402 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 24 | |||||||||||||
26832 | 26832 | Carl Durham D000571 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26842 | 26842 | Clair Engle E000181 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
26855 | 26855 | Aime Forand F000255 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26920 | 26920 | Toby Morris M000991 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26933 | 26933 | James Polk P000408 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26942 | 26942 | Prince Preston P000516 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
27041 | 27041 | Roy Wier W000446 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27062 | 27062 | Hugh Addonizio A000054 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
27087 | 27087 | Victor Anfuso A000255 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
27094 | 27094 | Cleveland Bailey B000035 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27118 | 27118 | Frank Boykin B000725 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
27134 | 27134 | Overton Brooks B000884 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27172 | 27172 | James Davis D000109 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27205 | 27205 | James Frazier F000353 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27219 | 27219 | Burr Harrison H000264 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27250 | 27250 | Frank Ikard I000007 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
27293 | 27293 | Paul Kilday K000171 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
27309 | 27309 | Thomas Lane L000065 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27318 | 27318 | Thaddeus Machrowicz M000014 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
27325 | 27325 | Peter Mack M000020 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
27337 | 27337 | Fred Marshall M000152 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
27384 | 27384 | Morgan Moulder M001045 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27404 | 27404 | William Norrell N000137 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
27423 | 27423 | Louis Rabaut R000001 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
27453 | 27453 | Samuel Rayburn R000082 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27481 | 27481 | John Riley R000260 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27527 | 27527 | Frank Smith S000533 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27543 | 27543 | Brent Spence S000717 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27596 | 27596 | John Kennedy K000107 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
27671 | 27671 | Charles Buckley B001024 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 25 | |||||||||||||
27693 | 27693 | Clarence Cannon C000117 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
27729 | 27729 | Clifford Davis D000094 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
27755 | 27755 | Clyde Doyle D000481 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
27764 | 27764 | Carl Elliott E000120 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27783 | 27783 | Elijah Forrester F000283 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27793 | 27793 | Julian Gary G000091 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27823 | 27823 | George Grant G000381 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27832 | 27832 | William Green G000421 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27943 | 27943 | Maude Kee K000040 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27984 | 27984 | John Lesinski L000252 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 16 | |||||||||||||
28060 | 28060 | Thomas O’Brien O000016 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
28098 | 28098 | Albert Rains R000018 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
28115 | 28115 | Kenneth Roberts R000314 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28132 | 28132 | John Shelley S000327 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
28146 | 28146 | Harry Sheppard S000335 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
28180 | 28180 | William Thornberry T000237 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
28222 | 28222 | Carl Vinson V000105 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
28241 | 28241 | Francis Walter W000108 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
28267 | 28267 | Victor Wickersham W000439 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
28287 | 28287 | William Winstead W000641 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
28323 | 28323 | Lindley Beckworth B000296 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28335 | 28335 | Herbert Bonner B000621 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
28364 | 28364 | Frank Chelf C000342 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28382 | 28382 | Harold Cooley C000736 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28407 | 28407 | Winfield Denton D000260 | rep | IN | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28431 | 28431 | Albert Gore G000320 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28452 | 28452 | Oren Harris H000249 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
28470 | 28470 | Spessard Holland H000720 | sen | FL | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
28484 | 28484 | Paul Jones J000246 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
28500 | 28500 | Eugene Keogh K000130 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
28558 | 28558 | Eugene McCarthy M000311 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28578 | 28578 | James Morrison M000995 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
28591 | 28591 | Thomas Murray M001114 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28599 | 28599 | Leo O’Brien O000015 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 32 | |||||||||||||
28621 | 28621 | Walter Rogers R000404 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
28649 | 28649 | Robert Secrest S000219 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
28667 | 28667 | Howard Smith S000554 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28684 | 28684 | Albert Thomas T000156 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28696 | 28696 | Clark Thompson T000198 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
28719 | 28719 | James Trimble T000373 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28775 | 28775 | Edward Bartlett B000201 | rep | AK | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
28835 | 28835 | John Fogarty F000233 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
28851 | 28851 | Ezekiel Gathings G000098 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
28879 | 28879 | Porter Hardy H000197 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
28896 | 28896 | Albert Herlong H000530 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
28923 | 28923 | Frank Karsten K000013 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
28933 | 28933 | Edna Kelly K000070 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
28947 | 28947 | Cecil King K000196 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 17 | |||||||||||||
28979 | 28979 | Abraham Multer M001074 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
29015 | 29015 | George Rhodes R000187 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
29069 | 29069 | John Williams W000517 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
29079 | 29079 | Edwin Willis W000559 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29208 | 29208 | William Dawson D000158 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
29238 | 29238 | George Fallon F000012 | rep | MD | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29259 | 29259 | Michael Feighan F000060 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
29309 | 29309 | Michael Kirwan K000244 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
29376 | 29376 | John McCormack M000364 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 12 | |||||||||||||
29410 | 29410 | Philip Philbin P000303 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29425 | 29425 | Adam Powell P000477 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 22 | |||||||||||||
29448 | 29448 | Lucius Rivers R000280 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
29458 | 29458 | Byron Rogers R000389 | rep | CO | 1951-01-03 | 1953-01-03 | Democrat | 1 |
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);