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 state descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23653 | 23653 | Edward Robertson R000320 | sen | WY | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
25587 | 25587 | Frank Barrett B000176 | rep | WY | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24378 | 24378 | Hubert Ellis E000135 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24559 | 24559 | Francis Love L000454 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24669 | 24669 | Edward Rohrbough R000410 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24677 | 24677 | Melvin Snyder S000670 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25313 | 25313 | Erland Hedrick H000442 | rep | WV | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25345 | 25345 | John Kee K000039 | rep | WV | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
26153 | 26153 | William Revercomb R000167 | sen | WV | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24286 | 24286 | John Brophy B000891 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24686 | 24686 | William Stevenson S000896 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24873 | 24873 | Frank Keefe K000041 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
25408 | 25408 | Reid Murray M001112 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
25720 | 25720 | Merlin Hull H000943 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
25734 | 25734 | Charles Kersten K000150 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26614 | 26614 | Lawrence Smith S000585 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
29651 | 29651 | John Byrnes B001216 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
29992 | 29992 | Alvin O’Konski O000058 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
30276 | 30276 | Glenn Davis D000102 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24502 | 24502 | Homer Jones J000225 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24623 | 24623 | Fred Norman N000135 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26405 | 26405 | Otis Holmes H000740 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26906 | 26906 | Russell Mack M000021 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
27901 | 27901 | Walter Horan H000786 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
28187 | 28187 | Thor Tollefson T000298 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
33002 | 33002 | Henry Jackson J000013 | rep | WA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24999 | 24999 | Charles Plumley P000395 | rep | VT | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24251 | 24251 | James Almond A000163 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
24368 | 24368 | Patrick Drewry D000496 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24389 | 24389 | John Flannagan F000191 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
24757 | 24757 | Schuyler Bland B000545 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25163 | 25163 | Clarence Burton B001148 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25813 | 25813 | Thomas Stanley S000797 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
27217 | 27217 | Burr Harrison H000264 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
27494 | 27494 | Absalom Robertson R000317 | sen | VA | 1946-11-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
27791 | 27791 | Julian Gary G000091 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
28665 | 28665 | Howard Smith S000554 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
28877 | 28877 | Porter Hardy H000197 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
29511 | 29511 | Watkins Abbitt A000002 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25288 | 25288 | Walter Granger G000379 | rep | UT | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26283 | 26283 | William Dawson D000155 | rep | UT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
23637 | 23637 | Wilbert O’Daniel O000034 | sen | TX | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24592 | 24592 | Joseph Mansfield M000112 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
24700 | 24700 | Robert Thomason T000189 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 16 | |||||||||||||
24719 | 24719 | Milton West W000304 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
25104 | 25104 | Francis Worley W000744 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 18 | |||||||||||||
25186 | 25186 | Jesse Combs C000655 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25282 | 25282 | Ed Gossett G000338 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 13 | |||||||||||||
25422 | 25422 | Thomas Pickett P000327 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
25749 | 25749 | Wingate Lucas L000496 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 12 | |||||||||||||
25754 | 25754 | John Lyle L000525 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
25787 | 25787 | Kenneth Regan R000140 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 16 | |||||||||||||
25837 | 25837 | Joseph Wilson W000604 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
27291 | 27291 | Paul Kilday K000171 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 20 | |||||||||||||
27451 | 27451 | Samuel Rayburn R000082 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28299 | 28299 | Lyndon Johnson J000160 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
28321 | 28321 | Lindley Beckworth B000296 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
28682 | 28682 | Albert Thomas T000156 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
28694 | 28694 | Clark Thompson T000198 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
30346 | 30346 | Ovie Fisher F000152 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
31261 | 31261 | John Patman P000103 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
31453 | 31453 | Omar Burleson B001111 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 17 | |||||||||||||
31627 | 31627 | George Mahon M000065 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 19 | |||||||||||||
31723 | 31723 | William Poage P000398 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 11 | |||||||||||||
31847 | 31847 | Olin Teague T000110 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
33814 | 33814 | Lloyd Bentsen B000401 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
23706 | 23706 | Arthur Stewart S000901 | sen | TN | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24327 | 24327 | William Courtney C000810 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
24863 | 24863 | John Jennings J000096 | rep | TN | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24990 | 24990 | Dayton Phillips P000306 | rep | TN | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26088 | 26088 | James Priest P000536 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
26259 | 26259 | Jere Cooper C000755 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
27280 | 27280 | Carey Kefauver K000044 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
27727 | 27727 | Clifford Davis D000094 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
28429 | 28429 | Albert Gore G000320 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28589 | 28589 | Thomas Murray M001114 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
30921 | 30921 | Joseph Evins E000273 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
26219 | 26219 | Francis Case C000221 | rep | SD | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
28993 | 28993 | Karl Mundt M001078 | sen | SD | 1948-12-31 | 1949-01-03 | 2 | Republican | |||||||||||||
24920 | 24920 | Burnet Maybank M000279 | sen | SC | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
25612 | 25612 | Joseph Bryson B000999 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
26111 | 26111 | James Richards R000214 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
27480 | 27480 | John Riley R000260 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
29446 | 29446 | Lucius Rivers R000280 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
29935 | 29935 | John McMillan M000568 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
30316 | 30316 | William Dorn D000434 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25984 | 25984 | Theodore Green G000418 | sen | RI | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
26853 | 26853 | Aime Forand F000255 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
28833 | 28833 | John Fogarty F000233 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
27772 | 27772 | Antonio Fernós-Isern F000087 | rep | PR | 1947-01-03 | 1949-01-03 | Popular Democrat | 0 | |||||||||||||
24293 | 24293 | E. Chadwick C000268 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
24333 | 24333 | William Crow C000939 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 23 | |||||||||||||
24400 | 24400 | James Gallagher G000017 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24412 | 24412 | Charles Gerlach G000135 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
24444 | 24444 | Chester Gross G000493 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 21 | |||||||||||||
24487 | 24487 | Mitchell Jenkins J000086 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
24572 | 24572 | Franklin Maloney M000089 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24599 | 24599 | John McDowell M000422 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 29 | |||||||||||||
24602 | 24602 | Robert McGarvey M000442 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24620 | 24620 | Frederick Muhlenberg M001062 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 13 |
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);