legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
488 rows where "end" is on date 1947-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35644 | 35644 | Jamie Whitten W000428 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
33695 | 33695 | Charles Price P000522 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 22 | |||||||||||||
33001 | 33001 | Henry Jackson J000013 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
32247 | 32247 | Jennings Randolph R000046 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
32060 | 32060 | Daniel Flood F000209 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
31846 | 31846 | Olin Teague T000110 | rep | TX | 1946-08-24 | 1947-01-03 | Democrat | 6 | |||||||||||||
31802 | 31802 | Robert Sikes S000406 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
31722 | 31722 | William Poage P000398 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
31626 | 31626 | George Mahon M000065 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
31511 | 31511 | James Delaney D000211 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
31260 | 31260 | John Patman P000103 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
31201 | 31201 | Thomas Morgan M000958 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 24 | |||||||||||||
31184 | 31184 | Wilbur Mills M000778 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
31144 | 31144 | Ray Madden M000039 | rep | IN | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
31037 | 31037 | Felix Hébert H000437 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
30820 | 30820 | William Barrett B000178 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
30642 | 30642 | John Rooney R000424 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 12 | |||||||||||||
30482 | 30482 | Chester Holifield H000713 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
30345 | 30345 | Ovie Fisher F000152 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
30267 | 30267 | Carl Curtis C001006 | rep | NE | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
30223 | 30223 | Clifford Case C000220 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
30143 | 30143 | Leslie Arends A000216 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
29991 | 29991 | Alvin O’Konski O000058 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
29948 | 29948 | George Miller M000727 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
29934 | 29934 | John McMillan M000568 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
29903 | 29903 | Michael Mansfield M000113 | rep | MT | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
29776 | 29776 | James Fulton F000422 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 31 | |||||||||||||
29718 | 29718 | Robert Corbett C000772 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 30 | |||||||||||||
29702 | 29702 | William Colmer C000645 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
29682 | 29682 | Emanuel Celler C000264 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
29650 | 29650 | John Byrnes B001216 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
29545 | 29545 | George Andrews A000206 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
29525 | 29525 | Thomas Abernethy A000016 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
29445 | 29445 | Lucius Rivers R000280 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
29422 | 29422 | Adam Powell P000477 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 22 | |||||||||||||
29407 | 29407 | Philip Philbin P000303 | rep | MA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
29373 | 29373 | John McCormack M000364 | rep | MA | 1945-01-03 | 1947-01-03 | Democrat | 12 | |||||||||||||
29306 | 29306 | Michael Kirwan K000244 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
29256 | 29256 | Michael Feighan F000060 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
29235 | 29235 | George Fallon F000012 | rep | MD | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
29223 | 29223 | Samuel Ervin E000211 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
29205 | 29205 | William Dawson D000158 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
29043 | 29043 | Margaret Smith S000590 | rep | ME | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
28991 | 28991 | Karl Mundt M001078 | rep | SD | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
28944 | 28944 | Cecil King K000196 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 17 | |||||||||||||
28865 | 28865 | Charles Halleck H000081 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
28848 | 28848 | Ezekiel Gathings G000098 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
28832 | 28832 | John Fogarty F000233 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
28790 | 28790 | Frances Bolton B000607 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 22 | |||||||||||||
28772 | 28772 | Edward Bartlett B000201 | rep | AK | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
28716 | 28716 | James Trimble T000373 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
28681 | 28681 | Albert Thomas T000156 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
28664 | 28664 | Howard Smith S000554 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
28588 | 28588 | Thomas Murray M001114 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
28575 | 28575 | James Morrison M000995 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
28539 | 28539 | Joseph Martin M000191 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 14 | |||||||||||||
28515 | 28515 | John Kunkel K000341 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 18 | |||||||||||||
28497 | 28497 | Eugene Keogh K000130 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
28469 | 28469 | Spessard Holland H000720 | sen | FL | 1946-09-25 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
28449 | 28449 | Oren Harris H000249 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
28428 | 28428 | Albert Gore G000320 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
28379 | 28379 | Harold Cooley C000736 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
28361 | 28361 | Frank Chelf C000342 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
28346 | 28346 | Clarence Brown B000909 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
28332 | 28332 | Herbert Bonner B000621 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
28320 | 28320 | Lindley Beckworth B000296 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
28298 | 28298 | Lyndon Johnson J000160 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
28284 | 28284 | William Winstead W000641 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
28274 | 28274 | Earl Wilson W000572 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
28265 | 28265 | Victor Wickersham W000439 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
28238 | 28238 | Francis Walter W000108 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
28219 | 28219 | Carl Vinson V000105 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
28143 | 28143 | Harry Sheppard S000335 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
28095 | 28095 | Albert Rains R000018 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
28057 | 28057 | Thomas O’Brien O000016 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
28041 | 28041 | Albin Norblad N000133 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
28026 | 28026 | Almer Monroney M000859 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
27953 | 27953 | Clarence Kilburn K000170 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 34 | |||||||||||||
27918 | 27918 | Benton Jensen J000100 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
27900 | 27900 | Walter Horan H000786 | rep | WA | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
27886 | 27886 | Charles Hoeven H000678 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
27830 | 27830 | William Green G000421 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
27820 | 27820 | George Grant G000381 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
27801 | 27801 | Leon Gavin G000102 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 19 | |||||||||||||
27790 | 27790 | Julian Gary G000091 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27771 | 27771 | Antonio Fernós-Isern F000087 | rep | PR | 1945-01-03 | 1947-01-03 | Popular Democrat | 0 | |||||||||||||
27753 | 27753 | Clyde Doyle D000481 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 18 | |||||||||||||
27748 | 27748 | Everett Dirksen D000360 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 16 | |||||||||||||
27726 | 27726 | Clifford Davis D000094 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
27712 | 27712 | John Chenoweth C000346 | rep | CO | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
27705 | 27705 | Frank Carlson C000154 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
27690 | 27690 | Clarence Cannon C000117 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
27668 | 27668 | Charles Buckley B001024 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 25 | |||||||||||||
27609 | 27609 | James Auchincloss A000227 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
27560 | 27560 | John Taber T000001 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 38 | |||||||||||||
27540 | 27540 | Brent Spence S000717 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
27479 | 27479 | John Riley R000260 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
27470 | 27470 | Brazilla Reece R000108 | rep | TN | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
27450 | 27450 | Samuel Rayburn R000082 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
27421 | 27421 | Louis Rabaut R000001 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 14 |
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);