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)
Suggested facets: class, start (date)
start 16 ✖
- 1953-01-03 442
- 1949-01-03 27
- 1952-01-01 2
- 1954-11-29 2
- 1949-10-14 1
- 1951-01-03 1
- 1953-07-10 1
- 1953-08-14 1
- 1953-10-13 1
- 1954-01-01 1
- 1954-04-16 1
- 1954-06-24 1
- 1954-07-03 1
- 1954-09-06 1
- 1954-10-01 1
- 1954-12-24 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24835 | 24835 | Guy Gillette G000205 | sen | IA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
25593 | 25593 | Laurie Battle B000242 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
25615 | 25615 | Joseph Bryson B000999 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25616 | 25616 | Thomas Burke B001099 | sen | OH | 1953-10-13 | 1955-01-03 | 3 | Democrat | appointment | ||||||||||||
25631 | 25631 | Albert Camp C000070 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25632 | 25632 | Courtney Campbell C000080 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25638 | 25638 | Robert Condon C000674 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
25657 | 25657 | Robert Crosser C000932 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
25705 | 25705 | Edward Hart H000284 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
25708 | 25708 | Louis Heller H000460 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
25712 | 25712 | Charles Howell H000858 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25748 | 25748 | William Lantaff L000089 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
25765 | 25765 | Howard Miller M000729 | rep | KS | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25772 | 25772 | George O’Brien O000009 | rep | MI | 1953-01-03 | 1955-01-03 | Democrat | 13 | |||||||||||||
25776 | 25776 | Harold Patten P000107 | rep | AZ | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
25790 | 25790 | Kenneth Regan R000140 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 16 | |||||||||||||
25795 | 25795 | Dwight Rogers R000391 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
25798 | 25798 | Franklin Roosevelt R000425 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 20 | |||||||||||||
25816 | 25816 | Thomas Stanley S000797 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
25820 | 25820 | James Sutton S001087 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
25836 | 25836 | William Wheeler W000342 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
25840 | 25840 | Joseph Wilson W000604 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
25845 | 25845 | Samuel Yorty Y000024 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 26 | |||||||||||||
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 | |||||||||||||
25865 | 25865 | William Scott S000187 | sen | NC | 1954-11-29 | 1955-01-03 | 2 | Democrat | |||||||||||||
25886 | 25886 | Vera Buchanan B001009 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 30 | |||||||||||||
25893 | 25893 | Frank Carlyle C000156 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
25898 | 25898 | Richard Chatham C000336 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
25909 | 25909 | Charles Deane D000175 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
25921 | 25921 | John Dingell D000354 | rep | MI | 1953-01-03 | 1955-01-03 | Democrat | 15 | |||||||||||||
25942 | 25942 | James Donovan D000421 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 18 | |||||||||||||
25958 | 25958 | Antonio Fernández F000085 | rep | NM | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
25961 | 25961 | Sidney Fine F000126 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 22 | |||||||||||||
25964 | 25964 | Joseph Frear F000356 | sen | DE | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25976 | 25976 | Brady Gentry G000124 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
25981 | 25981 | William Granahan G000369 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
25985 | 25985 | Theodore Green G000418 | sen | RI | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26031 | 26031 | Woodrow Jones J000263 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 11 | |||||||||||||
26042 | 26042 | Arthur Klein K000261 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 19 | |||||||||||||
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 | |||||||||||||
26091 | 26091 | James Priest P000536 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26114 | 26114 | James Richards R000214 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26182 | 26182 | James Bowler B000698 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
26225 | 26225 | Earl Chudoff C000386 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
26262 | 26262 | Jere Cooper C000755 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
26318 | 26318 | Herman Eberharter E000029 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 28 | |||||||||||||
26331 | 26331 | Thomas Gordon G000316 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
26342 | 26342 | Noble Gregory G000447 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26375 | 26375 | Lawrence Hays H000405 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26461 | 26461 | Augustine Kelley K000058 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
26472 | 26472 | Henderson Lanham L000077 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
26492 | 26492 | George Long L000416 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
26567 | 26567 | Edward Robeson R000329 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26596 | 26596 | George Shuford S000390 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 12 | |||||||||||||
26600 | 26600 | Alfred Sieminski S000405 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 13 | |||||||||||||
26717 | 26717 | Graham Barden B000139 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
26758 | 26758 | Paul Brown B000940 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
26795 | 26795 | Albert Carnahan C000162 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
26818 | 26818 | Isidore Dollinger D000402 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 23 | |||||||||||||
26833 | 26833 | Carl Durham D000571 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
26843 | 26843 | Clair Engle E000181 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
26856 | 26856 | Aime Forand F000255 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26934 | 26934 | James Polk P000408 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
26943 | 26943 | Prince Preston P000516 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27042 | 27042 | Roy Wier W000446 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27063 | 27063 | Hugh Addonizio A000054 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 11 | |||||||||||||
27068 | 27068 | Hugh Alexander A000094 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
27095 | 27095 | Cleveland Bailey B000035 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27119 | 27119 | Frank Boykin B000725 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27135 | 27135 | Overton Brooks B000884 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
27173 | 27173 | James Davis D000109 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
27181 | 27181 | Paul Douglas D000456 | sen | IL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27206 | 27206 | James Frazier F000353 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27220 | 27220 | Burr Harrison H000264 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27245 | 27245 | Lester Holtzman H000753 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
27251 | 27251 | Frank Ikard I000007 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 13 | |||||||||||||
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 | |||||||||||||
27294 | 27294 | Paul Kilday K000171 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 20 | |||||||||||||
27310 | 27310 | Thomas Lane L000065 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27319 | 27319 | Thaddeus Machrowicz M000014 | rep | MI | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27326 | 27326 | Peter Mack M000020 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
27331 | 27331 | Donald Magnuson M000052 | rep | WA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27338 | 27338 | Fred Marshall M000152 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
27385 | 27385 | Morgan Moulder M001045 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 11 | |||||||||||||
27405 | 27405 | William Norrell N000137 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
27411 | 27411 | Gracie Pfost P000287 | rep | ID | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27424 | 27424 | Louis Rabaut R000001 | rep | MI | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
27454 | 27454 | Samuel Rayburn R000082 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
27482 | 27482 | John Riley R000260 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
27495 | 27495 | Absalom Robertson R000317 | sen | VA | 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);