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 state descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25586 | 25586 | Frank Barrett B000176 | rep | WY | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
25860 | 25860 | Joseph O’Mahoney O000088 | sen | WY | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
24377 | 24377 | Hubert Ellis E000135 | rep | WV | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
25312 | 25312 | Erland Hedrick H000442 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
25344 | 25344 | John Kee K000039 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
25737 | 25737 | Harley Kilgore K000176 | sen | WV | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
26070 | 26070 | Matthew Neely N000023 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
27092 | 27092 | Cleveland Bailey B000035 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
32247 | 32247 | Jennings Randolph R000046 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
23096 | 23096 | Robert La Follette L000005 | sen | WI | 1941-01-03 | 1947-01-03 | 1 | Progressive | |||||||||||||
23878 | 23878 | Robert Henry H000515 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
24185 | 24185 | Thaddeus Wasielewski W000183 | rep | WI | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24685 | 24685 | William Stevenson S000896 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
24740 | 24740 | Andrew Biemiller B000448 | rep | WI | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
24872 | 24872 | Frank Keefe K000041 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
25407 | 25407 | Reid Murray M001112 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
25719 | 25719 | Merlin Hull H000943 | rep | WI | 1945-01-03 | 1947-01-03 | Progressive | 9 | |||||||||||||
26613 | 26613 | Lawrence Smith S000585 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
29650 | 29650 | John Byrnes B001216 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
29991 | 29991 | Alvin O’Konski O000058 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
23818 | 23818 | John Coffee C000584 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
23825 | 23825 | Emerson De Lacy D000206 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
24090 | 24090 | Charles Savage S000080 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24242 | 24242 | Harry Cain C000021 | sen | WA | 1946-12-31 | 1947-01-03 | 1 | Republican | |||||||||||||
26404 | 26404 | Otis Holmes H000740 | rep | WA | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
27900 | 27900 | Walter Horan H000786 | rep | WA | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
33001 | 33001 | Henry Jackson J000013 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24998 | 24998 | Charles Plumley P000395 | rep | VT | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
25670 | 25670 | Ralph Flanders F000190 | sen | VT | 1946-11-01 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
23824 | 23824 | Ralph Daughton D000067 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24089 | 24089 | Dave Satterfield S000069 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24228 | 24228 | Clifton Woodrum W000720 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
24250 | 24250 | James Almond A000163 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
24367 | 24367 | Patrick Drewry D000496 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24388 | 24388 | John Flannagan F000191 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
24756 | 24756 | Schuyler Bland B000545 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25812 | 25812 | Thomas Stanley S000797 | rep | VA | 1946-11-05 | 1947-01-03 | Democrat | 5 | |||||||||||||
26777 | 26777 | Harry Byrd B001208 | sen | VA | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
27216 | 27216 | Burr Harrison H000264 | rep | VA | 1946-11-05 | 1947-01-03 | Democrat | 7 | |||||||||||||
27790 | 27790 | Julian Gary G000091 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
28664 | 28664 | Howard Smith S000554 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
23154 | 23154 | Orrice Murdock M001082 | sen | UT | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
24069 | 24069 | James Robinson R000341 | rep | UT | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25287 | 25287 | Walter Granger G000379 | rep | UT | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
23959 | 23959 | Fritz Lanham L000076 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 12 | |||||||||||||
24083 | 24083 | Sam Russell R000538 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 17 | |||||||||||||
24129 | 24129 | Hatton Sumners S001072 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
24321 | 24321 | Thomas Connally C000684 | sen | TX | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
24591 | 24591 | Joseph Mansfield M000112 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
24699 | 24699 | Robert Thomason T000189 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 16 | |||||||||||||
24718 | 24718 | Milton West W000304 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
25103 | 25103 | Francis Worley W000744 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 18 | |||||||||||||
25185 | 25185 | Jesse Combs C000655 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25281 | 25281 | Ed Gossett G000338 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
25421 | 25421 | Thomas Pickett P000327 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
25753 | 25753 | John Lyle L000525 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
27290 | 27290 | Paul Kilday K000171 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
27450 | 27450 | Samuel Rayburn R000082 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
28298 | 28298 | Lyndon Johnson J000160 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
28320 | 28320 | Lindley Beckworth B000296 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
28681 | 28681 | Albert Thomas T000156 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
30345 | 30345 | Ovie Fisher F000152 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
31260 | 31260 | John Patman P000103 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
31626 | 31626 | George Mahon M000065 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
31722 | 31722 | William Poage P000398 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
31846 | 31846 | Olin Teague T000110 | rep | TX | 1946-08-24 | 1947-01-03 | Democrat | 6 | |||||||||||||
23842 | 23842 | Harold Earthman E000016 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
24326 | 24326 | William Courtney C000810 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
24611 | 24611 | Kenneth McKellar M000499 | sen | TN | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
24862 | 24862 | John Jennings J000096 | rep | TN | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26087 | 26087 | James Priest P000536 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
26258 | 26258 | Jere Cooper C000755 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
27279 | 27279 | Carey Kefauver K000044 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27470 | 27470 | Brazilla Reece R000108 | rep | TN | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
27726 | 27726 | Clifford Davis D000094 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
28428 | 28428 | Albert Gore G000320 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
28588 | 28588 | Thomas Murray M001114 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
26218 | 26218 | Francis Case C000221 | rep | SD | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
28991 | 28991 | Karl Mundt M001078 | rep | SD | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
23872 | 23872 | Butler Hare H000200 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25611 | 25611 | Joseph Bryson B000999 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
26110 | 26110 | James Richards R000214 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
27479 | 27479 | John Riley R000260 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
29445 | 29445 | Lucius Rivers R000280 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
29934 | 29934 | John McMillan M000568 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
23014 | 23014 | Peter Gerry G000141 | sen | RI | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
26852 | 26852 | Aime Forand F000255 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
28832 | 28832 | John Fogarty F000233 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24041 | 24041 | Jesús Piñero P000361 | rep | PR | 1945-01-03 | 1947-01-03 | Popular Democrat | 0 | |||||||||||||
27771 | 27771 | Antonio Fernós-Isern F000087 | rep | PR | 1945-01-03 | 1947-01-03 | Popular Democrat | 0 | |||||||||||||
24078 | 24078 | Carlos Romulo R000419 | rep | PI | 1945-01-03 | 1947-01-03 | 0 | ||||||||||||||
23018 | 23018 | Joseph Guffey G000519 | sen | PA | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
23786 | 23786 | Michael Bradley B000743 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23789 | 23789 | David Brumbaugh B000976 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 22 | |||||||||||||
23797 | 23797 | Howard Campbell C000085 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 29 | |||||||||||||
23880 | 23880 | Daniel Hoch H000668 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
23881 | 23881 | Carl Hoffman H000682 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 23 | |||||||||||||
23938 | 23938 | John Kinzer K000231 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
23989 | 23989 | Herbert McGlinchey M000451 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
24073 | 24073 | Robert Rodgers R000373 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 28 |
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);