legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "start" is on date 1951-01-03 sorted by party
This data as json, copyable, CSV (advanced)
end (date) 8 ✖
- 1953-01-03 450
- 1957-01-03 26
- 1953-12-31 3
- 1951-03-17 1
- 1951-12-15 1
- 1952-11-04 1
- 1954-08-28 1
- 1955-01-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25109 | 25109 | Earle Clements C000506 | sen | KY | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25119 | 25119 | Asa Allen A000114 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
25137 | 25137 | Joseph Bates B000237 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
25147 | 25147 | Reva Bosone B000649 | rep | UT | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25149 | 25149 | Edward Breen B000792 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25158 | 25158 | Frank Buchanan B001002 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 33 | |||||||||||||
25165 | 25165 | Clarence Burton B001148 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25178 | 25178 | William Byrne B001214 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 32 | |||||||||||||
25180 | 25180 | Louis Clemente C000504 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25188 | 25188 | Jesse Combs C000655 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25202 | 25202 | Edward Cox C000831 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25233 | 25233 | Robert Doughton D000448 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
25263 | 25263 | Thomas Fugate F000399 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
25265 | 25265 | John Furcolo F000431 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25271 | 25271 | Walter George G000131 | sen | GA | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25284 | 25284 | Ed Gossett G000338 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
25290 | 25290 | Walter Granger G000379 | rep | UT | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25291 | 25291 | Ernest Greenwood G000438 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25311 | 25311 | Franck Havenner H000356 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25315 | 25315 | Erland Hedrick H000442 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25321 | 25321 | James Heffernan H000443 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
25329 | 25329 | Clyde Hoey H000679 | sen | NC | 1951-01-03 | 1955-01-03 | 3 | Democrat | |||||||||||||
25331 | 25331 | Theodore Irving I000037 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25337 | 25337 | Hamilton Jones J000224 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
25347 | 25347 | John Kee K000039 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25362 | 25362 | John Kerr K000138 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25367 | 25367 | Henry Larcade L000095 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25369 | 25369 | Herbert Lehman L000224 | sen | NY | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25371 | 25371 | James Lind L000318 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
25373 | 25373 | Clare Magee M000045 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25377 | 25377 | Patrick McCarran M000308 | sen | NV | 1951-01-03 | 1954-08-28 | 3 | Democrat | |||||||||||||
25379 | 25379 | Christopher McGrath M000455 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 26 | |||||||||||||
25381 | 25381 | John McGuire M000465 | rep | CT | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25383 | 25383 | Clinton McKinnon M000528 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 23 | |||||||||||||
25385 | 25385 | Brien McMahon M000559 | sen | CT | 1951-01-03 | 1953-01-03 | 3 | Democrat | |||||||||||||
25386 | 25386 | Chester McMullen M000577 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25392 | 25392 | Hugh Mitchell M000814 | rep | WA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25401 | 25401 | John Murdock M001081 | rep | AZ | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25403 | 25403 | James Murphy M001094 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 16 | |||||||||||||
25412 | 25412 | Harry O’Neill O000095 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
25420 | 25420 | Donald O’Toole O000133 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
25424 | 25424 | Thomas Pickett P000327 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25426 | 25426 | Thomas Quinn Q000021 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25432 | 25432 | Robert Ramsay R000025 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25448 | 25448 | John Rankin R000056 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25451 | 25451 | Monroe Redden R000104 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 12 | |||||||||||||
25476 | 25476 | Adolph Sabath S000001 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25483 | 25483 | Lansdale Sasscer S000067 | rep | MD | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25505 | 25505 | William Stigler S000923 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25514 | 25514 | John Sullivan S001056 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
25516 | 25516 | Boyd Tackett T000005 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25532 | 25532 | Thomas Underwood U000015 | rep | KY | 1951-01-03 | 1951-03-17 | Democrat | 6 | |||||||||||||
25538 | 25538 | Philip Welch W000264 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25544 | 25544 | John Whitaker W000348 | rep | KY | 1951-01-03 | 1951-12-15 | Democrat | 2 | |||||||||||||
25550 | 25550 | John Wood W000699 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
25570 | 25570 | Edward deGraffenried D000198 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25592 | 25592 | Laurie Battle B000242 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
25614 | 25614 | Joseph Bryson B000999 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25630 | 25630 | Albert Camp C000070 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25656 | 25656 | Robert Crosser C000932 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
25704 | 25704 | Edward Hart H000284 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
25707 | 25707 | Louis Heller H000460 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25711 | 25711 | Charles Howell H000858 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25747 | 25747 | William Lantaff L000089 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25751 | 25751 | Wingate Lucas L000496 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 12 | |||||||||||||
25756 | 25756 | John Lyle L000525 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
25771 | 25771 | George O’Brien O000009 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
25775 | 25775 | Harold Patten P000107 | rep | AZ | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25789 | 25789 | Kenneth Regan R000140 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 16 | |||||||||||||
25794 | 25794 | Dwight Rogers R000391 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25797 | 25797 | Franklin Roosevelt R000425 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
25815 | 25815 | Thomas Stanley S000797 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25819 | 25819 | James Sutton S001087 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25835 | 25835 | William Wheeler W000342 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
25839 | 25839 | Joseph Wilson W000604 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25844 | 25844 | Samuel Yorty Y000024 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
25885 | 25885 | Vera Buchanan B001009 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 33 | |||||||||||||
25889 | 25889 | Maurice Burnside B001131 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25892 | 25892 | Frank Carlyle C000156 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25897 | 25897 | Richard Chatham C000336 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25908 | 25908 | Charles Deane D000175 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
25920 | 25920 | John Dingell D000354 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
25941 | 25941 | James Donovan D000421 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
25957 | 25957 | Antonio Fernández F000085 | rep | NM | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
25960 | 25960 | Sidney Fine F000126 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 23 | |||||||||||||
25980 | 25980 | William Granahan G000369 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
26030 | 26030 | Woodrow Jones J000263 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
26041 | 26041 | Arthur Klein K000261 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
26090 | 26090 | James Priest P000536 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26113 | 26113 | James Richards R000214 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
26224 | 26224 | Earl Chudoff C000386 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
26261 | 26261 | Jere Cooper C000755 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
26291 | 26291 | John Dempsey D000228 | rep | NM | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
26317 | 26317 | Herman Eberharter E000029 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 32 | |||||||||||||
26330 | 26330 | Thomas Gordon G000316 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
26341 | 26341 | Noble Gregory G000447 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26374 | 26374 | Lawrence Hays H000405 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
26381 | 26381 | Thomas Hennings H000502 | sen | MO | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
26460 | 26460 | Augustine Kelley K000058 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 27 | |||||||||||||
26471 | 26471 | Henderson Lanham L000077 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 7 |
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);