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 state descending
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25861 | 25861 | Joseph O’Mahoney O000088 | sen | WY | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
28890 | 28890 | William Harrison H000278 | rep | WY | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25315 | 25315 | Erland Hedrick H000442 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25347 | 25347 | John Kee K000039 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25432 | 25432 | Robert Ramsay R000025 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25738 | 25738 | Harley Kilgore K000176 | sen | WV | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25889 | 25889 | Maurice Burnside B001131 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27094 | 27094 | Cleveland Bailey B000035 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27943 | 27943 | Maude Kee K000040 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
32299 | 32299 | Harley Staggers S000778 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25410 | 25410 | Reid Murray M001112 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
25722 | 25722 | Merlin Hull H000943 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25735 | 25735 | Charles Kersten K000150 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25762 | 25762 | Joseph McCarthy M000315 | sen | WI | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
26616 | 26616 | Lawrence Smith S000585 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
27051 | 27051 | Gardner Withrow W000663 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
28196 | 28196 | William Van Pelt V000051 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
29653 | 29653 | John Byrnes B001216 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
29994 | 29994 | Alvin O’Konski O000058 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
30278 | 30278 | Glenn Davis D000102 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
33192 | 33192 | Clement Zablocki Z000001 | rep | WI | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
24243 | 24243 | Harry Cain C000021 | sen | WA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25392 | 25392 | Hugh Mitchell M000814 | rep | WA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26407 | 26407 | Otis Holmes H000740 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26908 | 26908 | Russell Mack M000021 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27903 | 27903 | Walter Horan H000786 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
28189 | 28189 | Thor Tollefson T000298 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
33004 | 33004 | Henry Jackson J000013 | rep | WA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25671 | 25671 | Ralph Flanders F000190 | sen | VT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
28609 | 28609 | Winston Prouty P000552 | rep | VT | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25165 | 25165 | Clarence Burton B001148 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25263 | 25263 | Thomas Fugate F000399 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
25815 | 25815 | Thomas Stanley S000797 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
26566 | 26566 | Edward Robeson R000329 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26778 | 26778 | Harry Byrd B001208 | sen | VA | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
27219 | 27219 | Burr Harrison H000264 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27793 | 27793 | Julian Gary G000091 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28667 | 28667 | Howard Smith S000554 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28879 | 28879 | Porter Hardy H000197 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
29513 | 29513 | Watkins Abbitt A000002 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25147 | 25147 | Reva Bosone B000649 | rep | UT | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25290 | 25290 | Walter Granger G000379 | rep | UT | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25825 | 25825 | Arthur Watkins W000190 | sen | UT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24322 | 24322 | Thomas Connally C000684 | sen | TX | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25188 | 25188 | Jesse Combs C000655 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25284 | 25284 | Ed Gossett G000338 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
25424 | 25424 | Thomas Pickett P000327 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
25789 | 25789 | Kenneth Regan R000140 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 16 | |||||||||||||
25839 | 25839 | Joseph Wilson W000604 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
27453 | 27453 | Samuel Rayburn R000082 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28180 | 28180 | William Thornberry T000237 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
28323 | 28323 | Lindley Beckworth B000296 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28621 | 28621 | Walter Rogers R000404 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
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 | |||||||||||||
29738 | 29738 | John Dowdy D000467 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
30348 | 30348 | Ovie Fisher F000152 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
31263 | 31263 | John Patman P000103 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
31455 | 31455 | Omar Burleson B001111 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 17 | |||||||||||||
31629 | 31629 | George Mahon M000065 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
31725 | 31725 | William Poage P000398 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
31849 | 31849 | Olin Teague T000110 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
33816 | 33816 | Lloyd Bentsen B000401 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
24612 | 24612 | Kenneth McKellar M000499 | sen | TN | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25819 | 25819 | James Sutton S001087 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
26090 | 26090 | James Priest P000536 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26261 | 26261 | Jere Cooper C000755 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
27205 | 27205 | James Frazier F000353 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27471 | 27471 | Brazilla Reece R000108 | rep | TN | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
27624 | 27624 | Howard Baker B000062 | rep | TN | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
27729 | 27729 | Clifford Davis D000094 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
28431 | 28431 | Albert Gore G000320 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28591 | 28591 | Thomas Murray M001114 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
30923 | 30923 | Joseph Evins E000273 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
26045 | 26045 | Harold Lovre L000468 | rep | SD | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
29149 | 29149 | Ellis Berry B000416 | rep | SD | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25614 | 25614 | Joseph Bryson B000999 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
26113 | 26113 | James Richards R000214 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27481 | 27481 | John Riley R000260 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
29448 | 29448 | Lucius Rivers R000280 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
29937 | 29937 | John McMillan M000568 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
30317 | 30317 | William Dorn D000434 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
26855 | 26855 | Aime Forand F000255 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
28835 | 28835 | John Fogarty F000233 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
30005 | 30005 | John Pastore P000100 | sen | RI | 1950-12-19 | 1953-01-03 | 1 | Democrat | |||||||||||||
27774 | 27774 | Antonio Fernós-Isern F000087 | rep | PR | 1951-01-03 | 1953-01-03 | Popular Democrat | 0 | |||||||||||||
25158 | 25158 | Frank Buchanan B001002 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 33 | |||||||||||||
25212 | 25212 | Harmar Denny D000249 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 29 | |||||||||||||
25277 | 25277 | Wilson Gillette G000206 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
25371 | 25371 | James Lind L000318 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
25412 | 25412 | Harry O’Neill O000095 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
25489 | 25489 | Hardie Scott S000172 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25491 | 25491 | Edward Sittler S000461 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 23 | |||||||||||||
25536 | 25536 | Albert Vaughn V000077 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25688 | 25688 | Louis Graham G000360 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 25 | |||||||||||||
25760 | 25760 | Edward Martin M000177 | sen | PA | 1947-01-03 | 1953-01-03 | 1 | Republican |
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);