legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "end" is on date 1951-01-03
This data as json, copyable, CSV (advanced)
start (date) 7 ✖
- 1949-01-03 359
- 1945-01-03 18
- 1945-03-12 1
- 1948-01-01 1
- 1949-05-17 1
- 1950-11-29 1
- 1950-12-01 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25254 | 25254 | Charles Elston E000160 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25260 | 25260 | Frank Fellows F000066 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25262 | 25262 | Thomas Fugate F000399 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25264 | 25264 | John Furcolo F000431 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25270 | 25270 | Walter George G000131 | sen | GA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25276 | 25276 | Wilson Gillette G000206 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
25283 | 25283 | Ed Gossett G000338 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
25289 | 25289 | Walter Granger G000379 | rep | UT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25297 | 25297 | Edwin Hall H000050 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 37 | |||||||||||||
25304 | 25304 | Leonard Hall H000060 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25310 | 25310 | Franck Havenner H000356 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25314 | 25314 | Erland Hedrick H000442 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25320 | 25320 | James Heffernan H000443 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
25325 | 25325 | Christian Herter H000548 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25328 | 25328 | Clyde Hoey H000679 | sen | NC | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25330 | 25330 | Theodore Irving I000037 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25333 | 25333 | Edward Jenison J000080 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 23 | |||||||||||||
25336 | 25336 | Hamilton Jones J000224 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
25346 | 25346 | John Kee K000039 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25361 | 25361 | John Kerr K000138 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25366 | 25366 | Henry Larcade L000095 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25368 | 25368 | Herbert Lehman L000224 | sen | NY | 1949-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25370 | 25370 | James Lind L000318 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
25372 | 25372 | Clare Magee M000045 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25376 | 25376 | Patrick McCarran M000308 | sen | NV | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25378 | 25378 | Christopher McGrath M000455 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 26 | |||||||||||||
25380 | 25380 | John McGuire M000465 | rep | CT | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25382 | 25382 | Clinton McKinnon M000528 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 23 | |||||||||||||
25384 | 25384 | Brien McMahon M000559 | sen | CT | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25388 | 25388 | Eugene Millikin M000771 | sen | CO | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
25391 | 25391 | Hugh Mitchell M000814 | rep | WA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25400 | 25400 | John Murdock M001081 | rep | AZ | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25402 | 25402 | James Murphy M001094 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
25409 | 25409 | Reid Murray M001112 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
25411 | 25411 | Harry O’Neill O000095 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
25419 | 25419 | Donald O’Toole O000133 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
25423 | 25423 | Thomas Pickett P000327 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25425 | 25425 | Thomas Quinn Q000021 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25431 | 25431 | Robert Ramsay R000025 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25447 | 25447 | John Rankin R000056 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25450 | 25450 | Monroe Redden R000104 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 12 | |||||||||||||
25475 | 25475 | Adolph Sabath S000001 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25482 | 25482 | Lansdale Sasscer S000067 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25488 | 25488 | Hardie Scott S000172 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25499 | 25499 | Karl Stefan S000845 | rep | NE | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25504 | 25504 | William Stigler S000923 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25509 | 25509 | Lowell Stockman S000936 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25513 | 25513 | John Sullivan S001056 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
25515 | 25515 | Boyd Tackett T000005 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25518 | 25518 | Robert Taft T000009 | sen | OH | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
25524 | 25524 | Charles Tobey T000289 | sen | NH | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
25529 | 25529 | Harry Towe T000320 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25531 | 25531 | Thomas Underwood U000015 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25537 | 25537 | Philip Welch W000264 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25540 | 25540 | Thomas Werdel W000298 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25543 | 25543 | John Whitaker W000348 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25549 | 25549 | John Wood W000699 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25567 | 25567 | Roy Woodruff W000718 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25569 | 25569 | Edward deGraffenried D000198 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25573 | 25573 | Charles Potter P000460 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 11 | |||||||||||||
25582 | 25582 | Homer Angell A000257 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25588 | 25588 | Frank Barrett B000176 | rep | WY | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25591 | 25591 | Laurie Battle B000242 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25598 | 25598 | Cecil Bishop B000486 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 26 | |||||||||||||
25603 | 25603 | Ernest Bramblett B000762 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 11 | |||||||||||||
25613 | 25613 | Joseph Bryson B000999 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25629 | 25629 | Albert Camp C000070 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25655 | 25655 | Robert Crosser C000932 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
25660 | 25660 | Wesley D’Ewart D000281 | rep | MT | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25667 | 25667 | Joseph Farrington F000034 | rep | HI | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25673 | 25673 | James Golden G000258 | rep | KY | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25679 | 25679 | Angier Goodwin G000297 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25687 | 25687 | Louis Graham G000360 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 25 | |||||||||||||
25693 | 25693 | Harold Hagen H000014 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25703 | 25703 | Edward Hart H000284 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
25706 | 25706 | Louis Heller H000460 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25710 | 25710 | Charles Howell H000858 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25721 | 25721 | Merlin Hull H000943 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25731 | 25731 | Edgar Jonas J000207 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
25750 | 25750 | Wingate Lucas L000496 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 12 | |||||||||||||
25755 | 25755 | John Lyle L000525 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
25770 | 25770 | George O’Brien O000009 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
25774 | 25774 | Harold Patten P000107 | rep | AZ | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25780 | 25780 | C. Poulson P000475 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
25788 | 25788 | Kenneth Regan R000140 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
25793 | 25793 | Dwight Rogers R000391 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25796 | 25796 | Franklin Roosevelt R000425 | rep | NY | 1949-05-17 | 1951-01-03 | Liberal | 20 | |||||||||||||
25805 | 25805 | Paul Shafer S000277 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25814 | 25814 | Thomas Stanley S000797 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25818 | 25818 | James Sutton S001087 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25830 | 25830 | Alvin Weichel W000252 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
25834 | 25834 | William Wheeler W000342 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25838 | 25838 | Joseph Wilson W000604 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25888 | 25888 | Maurice Burnside B001131 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25891 | 25891 | Frank Carlyle C000156 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25896 | 25896 | Richard Chatham C000336 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25907 | 25907 | Charles Deane D000175 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25919 | 25919 | John Dingell D000354 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
25925 | 25925 | James Dolliver D000403 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25937 | 25937 | George Dondero D000411 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 17 |
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);