legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
487 rows where "start" is on date 1943-01-06 sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: end (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 | |||||||||||||
25585 | 25585 | Frank Barrett B000176 | rep | WY | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23665 | 23665 | Andrew Schiffler S000126 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23680 | 23680 | Joseph Smith S000580 | rep | WV | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24376 | 24376 | Hubert Ellis E000135 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24668 | 24668 | Edward Rohrbough R000410 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25343 | 25343 | John Kee K000039 | rep | WV | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
26153 | 26153 | William Revercomb R000167 | sen | WV | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
32246 | 32246 | Jennings Randolph R000046 | rep | WV | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23411 | 23411 | LaVern Dilweg D000349 | rep | WI | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
23604 | 23604 | Howard McMurray M000579 | rep | WI | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23661 | 23661 | Harry Sauthoff S000079 | rep | WI | 1943-01-06 | 1945-01-03 | Progressive | 2 | |||||||||||||
24184 | 24184 | Thaddeus Wasielewski W000183 | rep | WI | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24684 | 24684 | William Stevenson S000896 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24871 | 24871 | Frank Keefe K000041 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
25406 | 25406 | Reid Murray M001112 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
25718 | 25718 | Merlin Hull H000943 | rep | WI | 1943-01-06 | 1945-01-03 | Progressive | 9 | |||||||||||||
26612 | 26612 | Lawrence Smith S000585 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
29990 | 29990 | Alvin O’Konski O000058 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
23817 | 23817 | John Coffee C000584 | rep | WA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24622 | 24622 | Fred Norman N000135 | rep | WA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26403 | 26403 | Otis Holmes H000740 | rep | WA | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
27899 | 27899 | Walter Horan H000786 | rep | WA | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
33000 | 33000 | Henry Jackson J000013 | rep | WA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24997 | 24997 | Charles Plumley P000395 | rep | VT | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23525 | 23525 | Carter Glass G000232 | sen | VA | 1943-01-06 | 1946-05-28 | 2 | Democrat | |||||||||||||
23547 | 23547 | Winder Harris H000260 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23823 | 23823 | Ralph Daughton D000067 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24088 | 24088 | Dave Satterfield S000069 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24227 | 24227 | Clifton Woodrum W000720 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24239 | 24239 | Thomas Burch B001069 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24366 | 24366 | Patrick Drewry D000496 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24387 | 24387 | John Flannagan F000191 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
24755 | 24755 | Schuyler Bland B000545 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27492 | 27492 | Absalom Robertson R000317 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
28663 | 28663 | Howard Smith S000554 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
24068 | 24068 | James Robinson R000341 | rep | UT | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25286 | 25286 | Walter Granger G000379 | rep | UT | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23570 | 23570 | Richard Kleberg K000257 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
23637 | 23637 | Wilbert O’Daniel O000034 | sen | TX | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
23650 | 23650 | Nat Patton P000142 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
23921 | 23921 | Luther Johnson J000159 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
23958 | 23958 | Fritz Lanham L000076 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
24082 | 24082 | Sam Russell R000538 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 17 | |||||||||||||
24128 | 24128 | Hatton Sumners S001072 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24590 | 24590 | Joseph Mansfield M000112 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
24698 | 24698 | Robert Thomason T000189 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
24717 | 24717 | Milton West W000304 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
25102 | 25102 | Francis Worley W000744 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 18 | |||||||||||||
25280 | 25280 | Ed Gossett G000338 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
26306 | 26306 | Martin Dies D000338 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
27289 | 27289 | Paul Kilday K000171 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 20 | |||||||||||||
27449 | 27449 | Samuel Rayburn R000082 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
28297 | 28297 | Lyndon Johnson J000160 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
28319 | 28319 | Lindley Beckworth B000296 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
28680 | 28680 | Albert Thomas T000156 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
30344 | 30344 | Ovie Fisher F000152 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
31259 | 31259 | John Patman P000103 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
31625 | 31625 | George Mahon M000065 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
31721 | 31721 | William Poage P000398 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
23593 | 23593 | Jim McCord M000360 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23706 | 23706 | Arthur Stewart S000901 | sen | TN | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24325 | 24325 | William Courtney C000810 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24861 | 24861 | John Jennings J000096 | rep | TN | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26086 | 26086 | James Priest P000536 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
26257 | 26257 | Jere Cooper C000755 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
27278 | 27278 | Carey Kefauver K000044 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
27469 | 27469 | Brazilla Reece R000108 | rep | TN | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
27725 | 27725 | Clifford Davis D000094 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
28427 | 28427 | Albert Gore G000320 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
28587 | 28587 | Thomas Murray M001114 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
23353 | 23353 | Harlan Bushfield B001168 | sen | SD | 1943-01-06 | 1948-09-27 | 2 | Republican | |||||||||||||
26217 | 26217 | Francis Case C000221 | rep | SD | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
28990 | 28990 | Karl Mundt M001078 | rep | SD | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23492 | 23492 | Hampton Fulmer F000417 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23493 | 23493 | Willa Fulmer F000418 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23871 | 23871 | Butler Hare H000200 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24920 | 24920 | Burnet Maybank M000279 | sen | SC | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
25610 | 25610 | Joseph Bryson B000999 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
26109 | 26109 | James Richards R000214 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
29444 | 29444 | Lucius Rivers R000280 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
29933 | 29933 | John McMillan M000568 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
25984 | 25984 | Theodore Green G000418 | sen | RI | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
26851 | 26851 | Aime Forand F000255 | rep | RI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
28831 | 28831 | John Fogarty F000233 | rep | RI | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23645 | 23645 | Bolívar Pagán P000013 | rep | PR | 1943-01-06 | 1945-01-03 | Coalitionist | 0 | |||||||||||||
23438 | 23438 | Joaquin Elizalde E000108 | rep | PI | 1943-01-06 | 1945-01-03 | 0 | ||||||||||||||
24077 | 24077 | Carlos Romulo R000419 | rep | PI | 1943-01-06 | 1945-01-03 | 0 | ||||||||||||||
23430 | 23430 | John Ditter D000363 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
23494 | 23494 | Robert Furlong F000432 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 25 | |||||||||||||
23597 | 23597 | James McGranery M000454 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23620 | 23620 | Thomas Miller M000756 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 12 | |||||||||||||
23651 | 23651 | Charles Pracht P000494 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
23652 | 23652 | Joseph Pratt P000503 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23663 | 23663 | Thomas Scanlon S000105 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
23727 | 23727 | William Troutman T000384 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23760 | 23760 | James Wright W000762 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 32 | |||||||||||||
23785 | 23785 | Michael Bradley B000743 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23788 | 23788 | David Brumbaugh B000976 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
23879 | 23879 | Daniel Hoch H000668 | rep | PA | 1943-01-06 | 1945-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);