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 party
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24917 | 24917 | Vito Marcantonio M000122 | rep | NY | 1949-01-03 | 1951-01-03 | American Labor | 18 | |||||||||||||
23841 | 23841 | Sheridan Downey D000469 | sen | CA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
24842 | 24842 | Frank Graham G000353 | sen | NC | 1949-03-29 | 1951-01-03 | 2 | Democrat | appointment | ||||||||||||
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 | |||||||||||||
24868 | 24868 | Raymond Karst K000012 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 12 | |||||||||||||
24875 | 24875 | Edward Kruse K000334 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24897 | 24897 | John Lesinski L000251 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
24900 | 24900 | Neil Linehan L000332 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
24908 | 24908 | Walter Lynch L000537 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 23 | |||||||||||||
24918 | 24918 | John Marsalis M000144 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
24930 | 24930 | John McSweeney M000606 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
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 | |||||||||||||
25017 | 25017 | George Sadowski S000011 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25020 | 25020 | Hugo Sims S000439 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
25108 | 25108 | Earle Clements C000506 | sen | KY | 1950-11-27 | 1951-01-03 | 3 | Democrat | |||||||||||||
25118 | 25118 | Asa Allen A000114 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25136 | 25136 | Joseph Bates B000237 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
25232 | 25232 | Robert Doughton D000448 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 |
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);