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 state descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25856 | 25856 | Edward Crippa C000906 | sen | WY | 1954-06-24 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25862 | 25862 | Joseph O’Mahoney O000088 | sen | WY | 1954-11-29 | 1955-01-03 | 2 | Democrat | |||||||||||||
28891 | 28891 | William Harrison H000278 | rep | WY | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26071 | 26071 | Matthew Neely N000023 | sen | WV | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26537 | 26537 | William Neal N000017 | rep | WV | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
27095 | 27095 | Cleveland Bailey B000035 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27944 | 27944 | Maude Kee K000040 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
32300 | 32300 | Harley Staggers S000778 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
32781 | 32781 | Robert Mollohan M000845 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
37951 | 37951 | Robert Byrd B001210 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
25723 | 25723 | Merlin Hull H000943 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
25736 | 25736 | Charles Kersten K000150 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
26617 | 26617 | Lawrence Smith S000585 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
27052 | 27052 | Gardner Withrow W000663 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
27933 | 27933 | Lester Johnson J000158 | rep | WI | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
28197 | 28197 | William Van Pelt V000051 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
29321 | 29321 | Melvin Laird L000024 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
29654 | 29654 | John Byrnes B001216 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
29995 | 29995 | Alvin O’Konski O000058 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
30279 | 30279 | Glenn Davis D000102 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
33193 | 33193 | Clement Zablocki Z000001 | rep | WI | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
26408 | 26408 | Otis Holmes H000740 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26909 | 26909 | Russell Mack M000021 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
27331 | 27331 | Donald Magnuson M000052 | rep | WA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27904 | 27904 | Walter Horan H000786 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
28190 | 28190 | Thor Tollefson T000298 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
28250 | 28250 | Alfred Westland W000310 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
30010 | 30010 | Thomas Pelly P000196 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
28610 | 28610 | Winston Prouty P000552 | rep | VT | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25816 | 25816 | Thomas Stanley S000797 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26567 | 26567 | Edward Robeson R000329 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27220 | 27220 | Burr Harrison H000264 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27495 | 27495 | Absalom Robertson R000317 | sen | VA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27794 | 27794 | Julian Gary G000091 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
28668 | 28668 | Howard Smith S000554 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
28880 | 28880 | Porter Hardy H000197 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
29051 | 29051 | William Tuck T000395 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
29514 | 29514 | Watkins Abbitt A000002 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
30027 | 30027 | Richard Poff P000401 | rep | VA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
30202 | 30202 | Joel Broyhill B000967 | rep | VA | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
32871 | 32871 | William Wampler W000121 | rep | VA | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
25817 | 25817 | Douglas Stringfellow S001006 | rep | UT | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26284 | 26284 | William Dawson D000155 | rep | UT | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
25752 | 25752 | Wingate Lucas L000496 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 12 | |||||||||||||
25757 | 25757 | John Lyle L000525 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
25790 | 25790 | Kenneth Regan R000140 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 16 | |||||||||||||
25840 | 25840 | Joseph Wilson W000604 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
25976 | 25976 | Brady Gentry G000124 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
26307 | 26307 | Martin Dies D000338 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
27251 | 27251 | Frank Ikard I000007 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 13 | |||||||||||||
27294 | 27294 | Paul Kilday K000171 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 20 | |||||||||||||
27454 | 27454 | Samuel Rayburn R000082 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28181 | 28181 | William Thornberry T000237 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
28300 | 28300 | Lyndon Johnson J000160 | sen | TX | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28622 | 28622 | Walter Rogers R000404 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 18 | |||||||||||||
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 | |||||||||||||
29739 | 29739 | John Dowdy D000467 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
30349 | 30349 | Ovie Fisher F000152 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
31264 | 31264 | John Patman P000103 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
31456 | 31456 | Omar Burleson B001111 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 17 | |||||||||||||
31630 | 31630 | George Mahon M000065 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 19 | |||||||||||||
31726 | 31726 | William Poage P000398 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 11 | |||||||||||||
31850 | 31850 | Olin Teague T000110 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
33817 | 33817 | Lloyd Bentsen B000401 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 15 | |||||||||||||
35135 | 35135 | Jack Brooks B000880 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
25820 | 25820 | James Sutton S001087 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
26091 | 26091 | James Priest P000536 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26262 | 26262 | Jere Cooper C000755 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
27206 | 27206 | James Frazier F000353 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27281 | 27281 | Carey Kefauver K000044 | sen | TN | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27472 | 27472 | Brazilla Reece R000108 | rep | TN | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
27625 | 27625 | Howard Baker B000062 | rep | TN | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
27730 | 27730 | Clifford Davis D000094 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
28592 | 28592 | Thomas Murray M001114 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
30924 | 30924 | Joseph Evins E000273 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
26046 | 26046 | Harold Lovre L000468 | rep | SD | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
28994 | 28994 | Karl Mundt M001078 | sen | SD | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
29150 | 29150 | Ellis Berry B000416 | rep | SD | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
24921 | 24921 | Burnet Maybank M000279 | sen | SC | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25615 | 25615 | Joseph Bryson B000999 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25857 | 25857 | Charles Daniel D000031 | sen | SC | 1954-09-06 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
26114 | 26114 | James Richards R000214 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
27482 | 27482 | John Riley R000260 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28764 | 28764 | Robert Ashmore A000223 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29449 | 29449 | Lucius Rivers R000280 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29938 | 29938 | John McMillan M000568 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
30318 | 30318 | William Dorn D000434 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
36418 | 36418 | J. Thurmond T000254 | sen | SC | 1954-12-24 | 1955-01-03 | 2 | Democrat | |||||||||||||
25985 | 25985 | Theodore Green G000418 | sen | RI | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26856 | 26856 | Aime Forand F000255 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28836 | 28836 | John Fogarty F000233 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
27775 | 27775 | Antonio Fernós-Isern F000087 | rep | PR | 1953-01-03 | 1955-01-03 | Popular Democrat | 0 | |||||||||||||
25601 | 25601 | Edward Bonin B000618 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 11 | |||||||||||||
25689 | 25689 | Louis Graham G000360 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 25 | |||||||||||||
25886 | 25886 | Vera Buchanan B001009 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 30 | |||||||||||||
25981 | 25981 | William Granahan G000369 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
26034 | 26034 | Karl King K000208 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
26208 | 26208 | Joseph Carrigg C000182 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
26225 | 26225 | Earl Chudoff C000386 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 4 |
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);