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 district
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24813 | 24813 | Guy Cordon C000774 | sen | OR | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
24831 | 24831 | Homer Ferguson F000081 | sen | MI | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
24835 | 24835 | Guy Gillette G000205 | sen | IA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
24845 | 24845 | Robert Hendrickson H000495 | sen | NJ | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
24867 | 24867 | Edwin Johnson J000127 | sen | CO | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
24921 | 24921 | Burnet Maybank M000279 | sen | SC | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25329 | 25329 | Clyde Hoey H000679 | sen | NC | 1951-01-03 | 1955-01-03 | 3 | Democrat | |||||||||||||
25571 | 25571 | Dwight Griswold G000481 | sen | NE | 1952-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
25616 | 25616 | Thomas Burke B001099 | sen | OH | 1953-10-13 | 1955-01-03 | 3 | Democrat | appointment | ||||||||||||
25823 | 25823 | Robert Upton U000032 | sen | NH | 1953-08-14 | 1955-01-03 | 3 | Republican | appointment | ||||||||||||
25846 | 25846 | Hazel Abel A000010 | sen | NE | 1954-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
25854 | 25854 | Eva Bowring B000709 | sen | NE | 1954-04-16 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25855 | 25855 | Ernest Brown B000913 | sen | NV | 1954-10-01 | 1955-01-03 | 3 | Republican | appointment | ||||||||||||
25856 | 25856 | Edward Crippa C000906 | sen | WY | 1954-06-24 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25857 | 25857 | Charles Daniel D000031 | sen | SC | 1954-09-06 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
25862 | 25862 | Joseph O’Mahoney O000088 | sen | WY | 1954-11-29 | 1955-01-03 | 2 | Democrat | |||||||||||||
25864 | 25864 | Samuel Reynolds R000180 | sen | NE | 1954-07-03 | 1955-01-03 | 1 | Republican | appointment | ||||||||||||
25865 | 25865 | William Scott S000187 | sen | NC | 1954-11-29 | 1955-01-03 | 2 | Democrat | |||||||||||||
25882 | 25882 | Henry Bridges B000823 | sen | NH | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
25964 | 25964 | Joseph Frear F000356 | sen | DE | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25985 | 25985 | Theodore Green G000418 | sen | RI | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26061 | 26061 | James Murray M001108 | sen | MT | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26071 | 26071 | Matthew Neely N000023 | sen | WV | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27181 | 27181 | Paul Douglas D000456 | sen | IL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27189 | 27189 | Henry Dworshak D000585 | sen | ID | 1949-10-14 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
27281 | 27281 | Carey Kefauver K000044 | sen | TN | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27284 | 27284 | Robert Kerr K000144 | sen | OK | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27495 | 27495 | Absalom Robertson R000317 | sen | VA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27503 | 27503 | Leverett Saltonstall S000021 | sen | MA | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
27517 | 27517 | Andrew Schoeppel S000138 | sen | KS | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
28300 | 28300 | Lyndon Johnson J000160 | sen | TX | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28760 | 28760 | Clinton Anderson A000186 | sen | NM | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28803 | 28803 | John Cooper C000758 | sen | KY | 1952-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
28818 | 28818 | Allen Ellender E000112 | sen | LA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28994 | 28994 | Karl Mundt M001078 | sen | SD | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
29027 | 29027 | Richard Russell R000536 | sen | GA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
29045 | 29045 | Margaret Smith S000590 | sen | ME | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
29884 | 29884 | Alton Lennon L000240 | sen | NC | 1953-07-10 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
30339 | 30339 | James Eastland E000018 | sen | MS | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30566 | 30566 | John McClellan M000332 | sen | AR | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30700 | 30700 | John Sparkman S000701 | sen | AL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
31592 | 31592 | Hubert Humphrey H000953 | sen | MN | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
36418 | 36418 | J. Thurmond T000254 | sen | SC | 1954-12-24 | 1955-01-03 | 2 | Democrat | |||||||||||||
25669 | 25669 | Joseph Farrington F000034 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25824 | 25824 | Herbert Warburton W000123 | rep | DE | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25951 | 25951 | Mary Farrington F000035 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25958 | 25958 | Antonio Fernández F000085 | rep | NM | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
26149 | 26149 | Clarence Young Y000032 | rep | NV | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26196 | 26196 | Usher Burdick B001079 | rep | ND | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26292 | 26292 | John Dempsey D000228 | rep | NM | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
26307 | 26307 | Martin Dies D000338 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
26466 | 26466 | Otto Krueger K000332 | rep | ND | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26576 | 26576 | Antoni Sadlak S000009 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
27775 | 27775 | Antonio Fernós-Isern F000087 | rep | PR | 1953-01-03 | 1955-01-03 | Popular Democrat | 0 | |||||||||||||
28610 | 28610 | Winston Prouty P000552 | rep | VT | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
28776 | 28776 | Edward Bartlett B000201 | rep | AK | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
28891 | 28891 | William Harrison H000278 | rep | WY | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25632 | 25632 | Courtney Campbell C000080 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25765 | 25765 | Howard Miller M000729 | rep | KS | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25817 | 25817 | Douglas Stringfellow S001006 | rep | UT | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26046 | 26046 | Harold Lovre L000468 | rep | SD | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26055 | 26055 | Thomas Martin M000199 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26175 | 26175 | August Andresen A000239 | rep | MN | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26342 | 26342 | Noble Gregory G000447 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26357 | 26357 | Robert Hale H000036 | rep | ME | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26387 | 26387 | John Heselton H000549 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26530 | 26530 | Edward Miller M000724 | rep | MD | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26567 | 26567 | Edward Robeson R000329 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26589 | 26589 | Hubert Scudder S000198 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26617 | 26617 | Lawrence Smith S000585 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26688 | 26688 | Charles Wolverton W000683 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26856 | 26856 | Aime Forand F000255 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26943 | 26943 | Prince Preston P000516 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27035 | 27035 | Stuyvesant Wainwright W000024 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
27119 | 27119 | Frank Boykin B000725 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27319 | 27319 | Thaddeus Machrowicz M000014 | rep | MI | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27375 | 27375 | Chester Merrow M000664 | rep | NH | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
27411 | 27411 | Gracie Pfost P000287 | rep | ID | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27472 | 27472 | Brazilla Reece R000108 | rep | TN | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
27512 | 27512 | Gordon Scherer S000120 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
28045 | 28045 | Albin Norblad N000133 | rep | OR | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
28336 | 28336 | Herbert Bonner B000621 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28414 | 28414 | Thomas Dodd D000390 | rep | CT | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28852 | 28852 | Ezekiel Gathings G000098 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28924 | 28924 | Frank Karsten K000013 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29209 | 29209 | William Dawson D000158 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
29529 | 29529 | Thomas Abernethy A000016 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29585 | 29585 | Page Belcher B000323 | rep | OK | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
30010 | 30010 | Thomas Pelly P000196 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
30271 | 30271 | Carl Curtis C001006 | rep | NE | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
30575 | 30575 | Lee Metcalf M000671 | rep | MT | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
30823 | 30823 | William Barrett B000178 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
31041 | 31041 | Felix Hébert H000437 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
31148 | 31148 | Ray Madden M000039 | rep | IN | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
31264 | 31264 | John Patman P000103 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
32781 | 32781 | Robert Mollohan M000845 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
32823 | 32823 | John Rhodes R000188 | rep | AZ | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
25662 | 25662 | Wesley D’Ewart D000281 | rep | MT | 1953-01-03 | 1955-01-03 | Republican | 2 |
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);