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 1943-01-03 sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22401 | 22401 | Henry Schwartz S000157 | sen | WY | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23119 | 23119 | John McIntyre M000484 | rep | WY | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
22981 | 22981 | Andrew Edmiston E000051 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23071 | 23071 | George Johnson J000132 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23206 | 23206 | Joseph Rosier R000443 | sen | WV | 1941-01-13 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23340 | 23340 | Hugh Shott S000381 | sen | WV | 1942-01-01 | 1943-01-03 | 2 | Republican | |||||||||||||
23679 | 23679 | Joseph Smith S000580 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
25342 | 25342 | John Kee K000039 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
25430 | 25430 | Robert Ramsay R000025 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
32245 | 32245 | Jennings Randolph R000046 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
22888 | 22888 | Stephen Bolles B000604 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23009 | 23009 | Bernard Gehrmann G000118 | rep | WI | 1941-01-03 | 1943-01-03 | Progressive | 10 | |||||||||||||
23065 | 23065 | Joshua Johns J000111 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
23295 | 23295 | Lewis Thill T000153 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
23660 | 23660 | Harry Sauthoff S000079 | rep | WI | 1941-01-03 | 1943-01-03 | Progressive | 2 | |||||||||||||
24183 | 24183 | Thaddeus Wasielewski W000183 | rep | WI | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
24683 | 24683 | William Stevenson S000896 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
24870 | 24870 | Frank Keefe K000041 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
25405 | 25405 | Reid Murray M001112 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
25717 | 25717 | Merlin Hull H000943 | rep | WI | 1941-01-03 | 1943-01-03 | Progressive | 9 | |||||||||||||
26611 | 26611 | Lawrence Smith S000585 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23041 | 23041 | Knute Hill H000600 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23105 | 23105 | Charles Leavy L000185 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23252 | 23252 | Martin Smith S000591 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23816 | 23816 | John Coffee C000584 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
31162 | 31162 | Warren Magnuson M000053 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
32999 | 32999 | Henry Jackson J000013 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
24996 | 24996 | Charles Plumley P000395 | rep | VT | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
22960 | 22960 | Colgate Darden D000050 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23524 | 23524 | Carter Glass G000232 | sen | VA | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23546 | 23546 | Winder Harris H000260 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
24087 | 24087 | Dave Satterfield S000069 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
24226 | 24226 | Clifton Woodrum W000720 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
24238 | 24238 | Thomas Burch B001069 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
24365 | 24365 | Patrick Drewry D000496 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
24386 | 24386 | John Flannagan F000191 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
24754 | 24754 | Schuyler Bland B000545 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
27491 | 27491 | Absalom Robertson R000317 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
28662 | 28662 | Howard Smith S000554 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
24067 | 24067 | James Robinson R000341 | rep | UT | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
25285 | 25285 | Walter Granger G000379 | rep | UT | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23256 | 23256 | Charles South S000683 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
23569 | 23569 | Richard Kleberg K000257 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
23636 | 23636 | Wilbert O’Daniel O000034 | sen | TX | 1941-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
23649 | 23649 | Nat Patton P000142 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
23920 | 23920 | Luther Johnson J000159 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23957 | 23957 | Fritz Lanham L000076 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 12 | |||||||||||||
24081 | 24081 | Sam Russell R000538 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 17 | |||||||||||||
24127 | 24127 | Hatton Sumners S001072 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
24589 | 24589 | Joseph Mansfield M000112 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
24697 | 24697 | Robert Thomason T000189 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 16 | |||||||||||||
24716 | 24716 | Milton West W000304 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
25101 | 25101 | Francis Worley W000744 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 18 | |||||||||||||
25279 | 25279 | Ed Gossett G000338 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
26305 | 26305 | Martin Dies D000338 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
27288 | 27288 | Paul Kilday K000171 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 20 | |||||||||||||
27448 | 27448 | Samuel Rayburn R000082 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
28296 | 28296 | Lyndon Johnson J000160 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 10 | |||||||||||||
28318 | 28318 | Lindley Beckworth B000296 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
28679 | 28679 | Albert Thomas T000156 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
31258 | 31258 | John Patman P000103 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
31624 | 31624 | George Mahon M000065 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 19 | |||||||||||||
31720 | 31720 | William Poage P000398 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
23174 | 23174 | Herron Pearson P000165 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
23705 | 23705 | Arthur Stewart S000901 | sen | TN | 1939-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
24324 | 24324 | William Courtney C000810 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
24860 | 24860 | John Jennings J000096 | rep | TN | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
26085 | 26085 | James Priest P000536 | rep | TN | 1941-01-03 | 1943-01-03 | Ind. Democrat | 5 | |||||||||||||
26256 | 26256 | Jere Cooper C000755 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
27277 | 27277 | Carey Kefauver K000044 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
27468 | 27468 | Brazilla Reece R000108 | rep | TN | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
27724 | 27724 | Clifford Davis D000094 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
28426 | 28426 | Albert Gore G000320 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
22076 | 22076 | William Bulow B001055 | sen | SD | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
26216 | 26216 | Francis Case C000221 | rep | SD | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
28989 | 28989 | Karl Mundt M001078 | rep | SD | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23491 | 23491 | Hampton Fulmer F000417 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23870 | 23870 | Butler Hare H000200 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
24919 | 24919 | Burnet Maybank M000279 | sen | SC | 1941-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
25609 | 25609 | Joseph Bryson B000999 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
26108 | 26108 | James Richards R000214 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
29443 | 29443 | Lucius Rivers R000280 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
29932 | 29932 | John McMillan M000568 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
25983 | 25983 | Theodore Green G000418 | sen | RI | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
26850 | 26850 | Aime Forand F000255 | rep | RI | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
28830 | 28830 | John Fogarty F000233 | rep | RI | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23644 | 23644 | Bolívar Pagán P000013 | rep | PR | 1941-01-03 | 1943-01-03 | Coalitionist | 0 | |||||||||||||
23437 | 23437 | Joaquin Elizalde E000108 | rep | PI | 1941-01-03 | 1943-01-03 | 0 | ||||||||||||||
22885 | 22885 | Patrick Boland B000601 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
22886 | 22886 | Veronica Boland B000602 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
22989 | 22989 | Charles Faddis F000001 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 25 | |||||||||||||
22997 | 22997 | John Flannery F000192 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 12 | |||||||||||||
23023 | 23023 | Harry Haines H000026 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 22 | |||||||||||||
23060 | 23060 | Benjamin Jarrett J000060 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 20 | |||||||||||||
23118 | 23118 | Joseph McArdle M000297 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 33 | |||||||||||||
23149 | 23149 | Guy Moser M001026 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
23209 | 23209 | Albert Rutherford R000546 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
23212 | 23212 | Leon Sacks S000008 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23243 | 23243 | Francis Smith S000532 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23429 | 23429 | John Ditter D000363 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 17 |
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);