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 sorted by start
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25118 | 25118 | Asa Allen A000114 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25125 | 25125 | John Anderson A000196 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25136 | 25136 | Joseph Bates B000237 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25144 | 25144 | William Blackney B000515 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25146 | 25146 | Reva Bosone B000649 | rep | UT | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25148 | 25148 | Edward Breen B000792 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25153 | 25153 | Walter Brehm B000794 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 11 | |||||||||||||
25157 | 25157 | Frank Buchanan B001002 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 33 | |||||||||||||
25164 | 25164 | Clarence Burton B001148 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25177 | 25177 | William Byrne B001214 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 32 | |||||||||||||
25179 | 25179 | Louis Clemente C000504 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25183 | 25183 | Albert Cole C000606 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25187 | 25187 | Jesse Combs C000655 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25201 | 25201 | Edward Cox C000831 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25210 | 25210 | Fred Crawford C000889 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25232 | 25232 | Robert Doughton D000448 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25247 | 25247 | Charles Eaton E000023 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 |
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);