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 1945-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24969 | 24969 | Stephen Pace P000002 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24978 | 24978 | James Peterson P000261 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
24986 | 24986 | Joseph Pfeifer P000285 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
24998 | 24998 | Charles Plumley P000395 | rep | VT | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
25008 | 25008 | Robert Rich R000209 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 15 | |||||||||||||
25015 | 25015 | George Sadowski S000011 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25024 | 25024 | Frederick Smith S000536 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
25037 | 25037 | Andrew Somers S000676 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
25045 | 25045 | John Thomas T000175 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
25056 | 25056 | James Wadsworth W000012 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 41 | |||||||||||||
25071 | 25071 | Richard Welch W000265 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
25083 | 25083 | Compton White W000361 | rep | ID | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25095 | 25095 | William Whittington W000430 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25099 | 25099 | Chase Woodhouse W000714 | rep | CT | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25103 | 25103 | Francis Worley W000744 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 18 | |||||||||||||
25106 | 25106 | Earle Clements C000506 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25116 | 25116 | Asa Allen A000114 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
25123 | 25123 | John Anderson A000196 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
25134 | 25134 | Joseph Bates B000237 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
25142 | 25142 | William Blackney B000515 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
25151 | 25151 | Walter Brehm B000794 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 11 | |||||||||||||
25155 | 25155 | Frank Buchanan B001002 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 33 | |||||||||||||
25160 | 25160 | Howard Buffett B001039 | rep | NE | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25168 | 25168 | John Butler B001179 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 44 | |||||||||||||
25175 | 25175 | William Byrne B001214 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 32 | |||||||||||||
25181 | 25181 | Albert Cole C000606 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
25185 | 25185 | Jesse Combs C000655 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25199 | 25199 | Edward Cox C000831 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25208 | 25208 | Fred Crawford C000889 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
25230 | 25230 | Robert Doughton D000448 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
25245 | 25245 | Charles Eaton E000023 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
25252 | 25252 | Charles Elston E000160 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
25258 | 25258 | Frank Fellows F000066 | rep | ME | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25270 | 25270 | Walter George G000131 | sen | GA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25274 | 25274 | Wilson Gillette G000206 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 14 | |||||||||||||
25281 | 25281 | Ed Gossett G000338 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
25287 | 25287 | Walter Granger G000379 | rep | UT | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25295 | 25295 | Edwin Hall H000050 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 37 | |||||||||||||
25302 | 25302 | Leonard Hall H000060 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25308 | 25308 | Franck Havenner H000356 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25312 | 25312 | Erland Hedrick H000442 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
25318 | 25318 | James Heffernan H000443 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
25323 | 25323 | Christian Herter H000548 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
25328 | 25328 | Clyde Hoey H000679 | sen | NC | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25344 | 25344 | John Kee K000039 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
25359 | 25359 | John Kerr K000138 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25364 | 25364 | Henry Larcade L000095 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
25376 | 25376 | Patrick McCarran M000308 | sen | NV | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
25398 | 25398 | John Murdock M001081 | rep | AZ | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
25407 | 25407 | Reid Murray M001112 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
25417 | 25417 | Donald O’Toole O000133 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
25421 | 25421 | Thomas Pickett P000327 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
25445 | 25445 | John Rankin R000056 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25473 | 25473 | Adolph Sabath S000001 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
25480 | 25480 | Lansdale Sasscer S000067 | rep | MD | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
25484 | 25484 | George Schwabe S000155 | rep | OK | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
25497 | 25497 | Karl Stefan S000845 | rep | NE | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25502 | 25502 | William Stigler S000923 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25507 | 25507 | Lowell Stockman S000936 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25512 | 25512 | John Sullivan S001056 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
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 | |||||||||||||
25527 | 25527 | Harry Towe T000320 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
25547 | 25547 | John Wood W000699 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
25565 | 25565 | Roy Woodruff W000718 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
25580 | 25580 | Homer Angell A000257 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25586 | 25586 | Frank Barrett B000176 | rep | WY | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
25596 | 25596 | Cecil Bishop B000486 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 25 | |||||||||||||
25611 | 25611 | Joseph Bryson B000999 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25627 | 25627 | Albert Camp C000070 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25635 | 25635 | William Cole C000614 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25653 | 25653 | Robert Crosser C000932 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
25658 | 25658 | Wesley D’Ewart D000281 | rep | MT | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25665 | 25665 | Joseph Farrington F000034 | rep | HI | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
25677 | 25677 | Angier Goodwin G000297 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
25685 | 25685 | Louis Graham G000360 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 25 | |||||||||||||
25691 | 25691 | Harold Hagen H000014 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
25701 | 25701 | Edward Hart H000284 | rep | NJ | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
25719 | 25719 | Merlin Hull H000943 | rep | WI | 1945-01-03 | 1947-01-03 | Progressive | 9 | |||||||||||||
25753 | 25753 | John Lyle L000525 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
25769 | 25769 | George O’Brien O000009 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
25791 | 25791 | Dwight Rogers R000391 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
25803 | 25803 | Paul Shafer S000277 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25828 | 25828 | Alvin Weichel W000252 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 13 | |||||||||||||
25850 | 25850 | George Bender B000356 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
25877 | 25877 | Alben Barkley B000145 | sen | KY | 1945-01-03 | 1949-01-19 | 3 | Democrat | |||||||||||||
25917 | 25917 | John Dingell D000354 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
25923 | 25923 | James Dolliver D000403 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
25935 | 25935 | George Dondero D000411 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
25945 | 25945 | Mathew Ellsworth E000146 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
25954 | 25954 | Antonio Fernández F000085 | rep | NM | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
25970 | 25970 | Ralph Gamble G000031 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 28 | |||||||||||||
25978 | 25978 | William Granahan G000369 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25987 | 25987 | Thomas Hand H000154 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25997 | 25997 | John Hinshaw H000640 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 20 | |||||||||||||
26016 | 26016 | Clifford Hope H000768 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
26023 | 26023 | Justin Johnson J000157 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
26038 | 26038 | Arthur Klein K000261 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 19 |
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);