legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
486 rows where "end" is on date 1949-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35645 | 35645 | Jamie Whitten W000428 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
33814 | 33814 | Lloyd Bentsen B000401 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
33696 | 33696 | Charles Price P000522 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 22 | |||||||||||||
33002 | 33002 | Henry Jackson J000013 | rep | WA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
31847 | 31847 | Olin Teague T000110 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
31803 | 31803 | Robert Sikes S000406 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
31723 | 31723 | William Poage P000398 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 11 | |||||||||||||
31627 | 31627 | George Mahon M000065 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 19 | |||||||||||||
31453 | 31453 | Omar Burleson B001111 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 17 | |||||||||||||
31261 | 31261 | John Patman P000103 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
31237 | 31237 | Otto Passman P000098 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
31202 | 31202 | Thomas Morgan M000958 | rep | PA | 1947-01-03 | 1949-01-03 | Democrat | 24 | |||||||||||||
31185 | 31185 | Wilbur Mills M000778 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
31145 | 31145 | Ray Madden M000039 | rep | IN | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
31081 | 31081 | Robert Jones J000248 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
31066 | 31066 | Jacob Javits J000064 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 21 | |||||||||||||
31038 | 31038 | Felix Hébert H000437 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
30921 | 30921 | Joseph Evins E000273 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
30878 | 30878 | Norris Cotton C000802 | rep | NH | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
30803 | 30803 | Carl Albert A000073 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
30699 | 30699 | John Sparkman S000701 | sen | AL | 1946-11-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
30643 | 30643 | John Rooney R000424 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 12 | |||||||||||||
30565 | 30565 | John McClellan M000332 | sen | AR | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
30483 | 30483 | Chester Holifield H000713 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 19 | |||||||||||||
30346 | 30346 | Ovie Fisher F000152 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
30338 | 30338 | James Eastland E000018 | sen | MS | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
30316 | 30316 | William Dorn D000434 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
30302 | 30302 | Harold Donohue D000419 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
30276 | 30276 | Glenn Davis D000102 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
30268 | 30268 | Carl Curtis C001006 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
30224 | 30224 | Clifford Case C000220 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
30165 | 30165 | John Blatnik B000550 | rep | MN | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
30144 | 30144 | Leslie Arends A000216 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
30073 | 30073 | Hugh Scott S000174 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
29992 | 29992 | Alvin O’Konski O000058 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
29949 | 29949 | George Miller M000727 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
29935 | 29935 | John McMillan M000568 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
29911 | 29911 | William McCulloch M000393 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
29904 | 29904 | Michael Mansfield M000113 | rep | MT | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
29801 | 29801 | Edward Garmatz G000071 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
29777 | 29777 | James Fulton F000422 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 31 | |||||||||||||
29719 | 29719 | Robert Corbett C000772 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 30 | |||||||||||||
29703 | 29703 | William Colmer C000645 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
29683 | 29683 | Emanuel Celler C000264 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
29651 | 29651 | John Byrnes B001216 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
29610 | 29610 | Thomas Boggs B000594 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
29546 | 29546 | George Andrews A000206 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
29526 | 29526 | Thomas Abernethy A000016 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29511 | 29511 | Watkins Abbitt A000002 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29507 | 29507 | Richard Nixon N000116 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
29446 | 29446 | Lucius Rivers R000280 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
29423 | 29423 | Adam Powell P000477 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 22 | |||||||||||||
29408 | 29408 | Philip Philbin P000303 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
29374 | 29374 | John McCormack M000364 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 12 | |||||||||||||
29307 | 29307 | Michael Kirwan K000244 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 19 | |||||||||||||
29257 | 29257 | Michael Feighan F000060 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 20 | |||||||||||||
29236 | 29236 | George Fallon F000012 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29206 | 29206 | William Dawson D000158 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
29067 | 29067 | John Williams W000517 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
29044 | 29044 | Margaret Smith S000590 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
29026 | 29026 | Richard Russell R000536 | sen | GA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
28993 | 28993 | Karl Mundt M001078 | sen | SD | 1948-12-31 | 1949-01-03 | 2 | Republican | |||||||||||||
28977 | 28977 | Abraham Multer M001074 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
28945 | 28945 | Cecil King K000196 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 17 | |||||||||||||
28921 | 28921 | Frank Karsten K000013 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 13 | |||||||||||||
28877 | 28877 | Porter Hardy H000197 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
28866 | 28866 | Charles Halleck H000081 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
28849 | 28849 | Ezekiel Gathings G000098 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
28833 | 28833 | John Fogarty F000233 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
28817 | 28817 | Allen Ellender E000112 | sen | LA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
28802 | 28802 | John Cooper C000758 | sen | KY | 1946-01-01 | 1949-01-03 | 2 | Republican | |||||||||||||
28791 | 28791 | Frances Bolton B000607 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 22 | |||||||||||||
28782 | 28782 | James Boggs B000593 | rep | DE | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
28773 | 28773 | Edward Bartlett B000201 | rep | AK | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
28717 | 28717 | James Trimble T000373 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
28694 | 28694 | Clark Thompson T000198 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
28682 | 28682 | Albert Thomas T000156 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
28665 | 28665 | Howard Smith S000554 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
28589 | 28589 | Thomas Murray M001114 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
28576 | 28576 | James Morrison M000995 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
28540 | 28540 | Joseph Martin M000191 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 14 | |||||||||||||
28516 | 28516 | John Kunkel K000341 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 18 | |||||||||||||
28498 | 28498 | Eugene Keogh K000130 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
28482 | 28482 | Paul Jones J000246 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
28460 | 28460 | Ralph Harvey H000310 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
28450 | 28450 | Oren Harris H000249 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
28429 | 28429 | Albert Gore G000320 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28396 | 28396 | Paul Dague D000004 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
28380 | 28380 | Harold Cooley C000736 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28362 | 28362 | Frank Chelf C000342 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28347 | 28347 | Clarence Brown B000909 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
28333 | 28333 | Herbert Bonner B000621 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
28321 | 28321 | Lindley Beckworth B000296 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
28299 | 28299 | Lyndon Johnson J000160 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
28285 | 28285 | William Winstead W000641 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
28275 | 28275 | Earl Wilson W000572 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
28239 | 28239 | Francis Walter W000108 | rep | PA | 1947-01-03 | 1949-01-03 | Democrat | 20 | |||||||||||||
28220 | 28220 | Carl Vinson V000105 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
28187 | 28187 | Thor Tollefson T000298 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
28168 | 28168 | Katharine St. George S000764 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 29 |
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);