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)
Suggested facets: class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23838 | 23838 | Forrest Donnell D000414 | sen | MO | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
23841 | 23841 | Sheridan Downey D000469 | sen | CA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
23854 | 23854 | John Gurney G000532 | sen | SD | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
23964 | 23964 | Scott Lucas L000493 | sen | IL | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24005 | 24005 | Francis Myers M001127 | sen | PA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24143 | 24143 | Glen Taylor T000079 | sen | ID | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24151 | 24151 | Elbert Thomas T000164 | sen | UT | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24157 | 24157 | John Thomas T000177 | sen | OK | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24173 | 24173 | Millard Tydings T000446 | sen | MD | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25270 | 25270 | Walter George G000131 | sen | GA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25328 | 25328 | Clyde Hoey H000679 | sen | NC | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
26204 | 26204 | Homer Capehart C000128 | sen | IN | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
26668 | 26668 | Alexander Wiley W000465 | sen | WI | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
27854 | 27854 | Carl Hayden H000385 | sen | AZ | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27867 | 27867 | Bourke Hickenlooper H000559 | sen | IA | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
27881 | 27881 | Joseph Hill H000598 | sen | AL | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27939 | 27939 | Olin Johnston J000195 | sen | SC | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
28032 | 28032 | Wayne Morse M001014 | sen | OR | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
29114 | 29114 | George Aiken A000062 | sen | VT | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
29281 | 29281 | James Fulbright F000401 | sen | AR | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
31165 | 31165 | Warren Magnuson M000053 | sen | WA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
34048 | 34048 | Claude Pepper P000218 | sen | FL | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
31402 | 31402 | Milton Young Y000047 | sen | ND | 1945-03-12 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
32733 | 32733 | Russell Long L000428 | sen | LA | 1948-01-01 | 1951-01-03 | 3 | Democrat | |||||||||||||
24738 | 24738 | George Bates B000232 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
24741 | 24741 | Andrew Biemiller B000448 | rep | WI | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
24758 | 24758 | Schuyler Bland B000545 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
24772 | 24772 | Sol Bloom B000565 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
24773 | 24773 | William Bolton B000609 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
24774 | 24774 | James Buckley B001028 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24788 | 24788 | Alfred Bulwinkle B001056 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
24789 | 24789 | Thomas Burke B001100 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
24790 | 24790 | Anthony Cavalcante C000259 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 23 | |||||||||||||
24803 | 24803 | Chester Chesney C000347 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
24810 | 24810 | Ralph Church C000390 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
24811 | 24811 | Robert Coffey C000586 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 26 | |||||||||||||
24814 | 24814 | Thurman Crook C000926 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
24816 | 24816 | Harry Davenport D000071 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 29 | |||||||||||||
24817 | 24817 | John Davies D000089 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 35 | |||||||||||||
24820 | 24820 | Helen Douglas D000454 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
24829 | 24829 | Albert Engel E000178 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
24836 | 24836 | William Gilmer G000219 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
24837 | 24837 | Chester Gorski G000331 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 44 | |||||||||||||
24841 | 24841 | Martin Gorski G000332 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
24843 | 24843 | Ben Guill G000521 | rep | TX | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
24844 | 24844 | James Hare H000202 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
24853 | 24853 | Samuel Hobbs H000663 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24856 | 24856 | Walter Huber H000898 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
24858 | 24858 | Andrew Jacobs J000034 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
24864 | 24864 | John Jennings J000096 | rep | TN | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
24868 | 24868 | Raymond Karst K000012 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 12 | |||||||||||||
24874 | 24874 | Frank Keefe K000041 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
24875 | 24875 | Edward Kruse K000334 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24879 | 24879 | Jay Le Fevre L000161 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 30 | |||||||||||||
24888 | 24888 | William Lemke L000238 | rep | ND | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
24897 | 24897 | John Lesinski L000251 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
24899 | 24899 | Franklin Lichtenwalter L000301 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
24900 | 24900 | Neil Linehan L000332 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
24902 | 24902 | John Lodge L000395 | rep | CT | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
24908 | 24908 | Walter Lynch L000537 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 23 | |||||||||||||
24910 | 24910 | William Macy M000037 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
24917 | 24917 | Vito Marcantonio M000122 | rep | NY | 1949-01-03 | 1951-01-03 | American Labor | 18 | |||||||||||||
24918 | 24918 | John Marsalis M000144 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
24925 | 24925 | Rolla McMillen M000574 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
24930 | 24930 | John McSweeney M000606 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
24932 | 24932 | Herbert Meyer M000680 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
24947 | 24947 | Earl Michener M000693 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
24948 | 24948 | John Miles M000705 | rep | NM | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
24950 | 24950 | James Noland N000129 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
24963 | 24963 | Mary Norton N000153 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
24964 | 24964 | Eugene O’Sullivan O000122 | rep | NE | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
24971 | 24971 | Stephen Pace P000002 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
24980 | 24980 | James Peterson P000261 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
24988 | 24988 | Joseph Pfeifer P000285 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
24989 | 24989 | William Pfeiffer P000286 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 42 | |||||||||||||
24991 | 24991 | Dayton Phillips P000306 | rep | TN | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25000 | 25000 | Charles Plumley P000395 | rep | VT | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25010 | 25010 | Robert Rich R000209 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
25017 | 25017 | George Sadowski S000011 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25019 | 25019 | John Sanborn S000029 | rep | ID | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25020 | 25020 | Hugo Sims S000439 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25026 | 25026 | Frederick Smith S000536 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25039 | 25039 | Andrew Somers S000676 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
25040 | 25040 | Anthony Tauriello T000056 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 43 | |||||||||||||
25047 | 25047 | John Thomas T000175 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
25058 | 25058 | James Wadsworth W000012 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 41 | |||||||||||||
25059 | 25059 | Earl Wagner W000019 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25060 | 25060 | John Walsh W000100 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25073 | 25073 | Richard Welch W000265 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
25076 | 25076 | Cecil White W000359 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25084 | 25084 | Compton White W000361 | rep | ID | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25097 | 25097 | William Whittington W000430 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25098 | 25098 | George Wilson W000582 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25100 | 25100 | Chase Woodhouse W000714 | rep | CT | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25105 | 25105 | Francis Worley W000744 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 18 |
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);