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 legislator_id 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24724 | 24724 | Orville Zimmerman Z000009 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 10 | |||||||||||||
23331 | 23331 | Oscar Youngdahl Y000059 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
28748 | 28748 | Stephen Young Y000053 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
23759 | 23759 | James Wright W000762 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 34 | |||||||||||||
25101 | 25101 | Francis Worley W000744 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 18 | |||||||||||||
24226 | 24226 | Clifton Woodrum W000720 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
25563 | 25563 | Roy Woodruff W000718 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
26682 | 26682 | Charles Wolverton W000683 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
24214 | 24214 | James Wolfenden W000678 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
26141 | 26141 | Jesse Wolcott W000668 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
24204 | 24204 | Thomas Winter W000645 | rep | KS | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
28272 | 28272 | Earl Wilson W000572 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
23328 | 23328 | Clyde Williams W000494 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
26658 | 26658 | Richard Wigglesworth W000450 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 13 | |||||||||||||
28263 | 28263 | Victor Wickersham W000439 | rep | OK | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
25093 | 25093 | William Whittington W000430 | rep | MS | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
35642 | 35642 | Jamie Whitten W000428 | rep | MS | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23755 | 23755 | Wallace White W000396 | sen | ME | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
25081 | 25081 | Compton White W000361 | rep | ID | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23745 | 23745 | Benjamin Whelchel W000343 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
23740 | 23740 | William Wheat W000327 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 19 | |||||||||||||
24716 | 24716 | Milton West W000304 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
23737 | 23737 | Elmer Wene W000294 | rep | NJ | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
25069 | 25069 | Richard Welch W000265 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
24200 | 24200 | Samuel Weiss W000257 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 31 | |||||||||||||
24197 | 24197 | Zebulon Weaver W000230 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
24183 | 24183 | Thaddeus Wasielewski W000183 | rep | WI | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23734 | 23734 | David Ward W000130 | rep | MD | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
28236 | 28236 | Francis Walter W000108 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
25054 | 25054 | James Wadsworth W000012 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 39 | |||||||||||||
23312 | 23312 | Albert Vreeland V000121 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 11 | |||||||||||||
26634 | 26634 | John Vorys V000119 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 12 | |||||||||||||
24176 | 24176 | Horace Voorhis V000118 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 12 | |||||||||||||
28217 | 28217 | Carl Vinson V000105 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23730 | 23730 | Beverly Vincent V000100 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
27574 | 27574 | James Van Zandt V000069 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 23 | |||||||||||||
23725 | 23725 | Allen Treadway T000358 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
24166 | 24166 | Philip Traynor T000357 | rep | DE | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
24161 | 24161 | John Tolan T000295 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
23309 | 23309 | George Tinkham T000283 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
24702 | 24702 | Harve Tibbott T000263 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 27 | |||||||||||||
24697 | 24697 | Robert Thomason T000189 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 16 | |||||||||||||
25043 | 25043 | John Thomas T000175 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
23709 | 23709 | John Thomas T000172 | sen | ID | 1940-01-27 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
28679 | 28679 | Albert Thomas T000156 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
24147 | 24147 | William Thom T000155 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 16 | |||||||||||||
23295 | 23295 | Lewis Thill T000153 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
23293 | 23293 | David Terry T000133 | rep | AR | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23288 | 23288 | Rudolph Tenerowicz T000124 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23286 | 23286 | Edward Taylor T000072 | rep | CO | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
24140 | 24140 | Malcolm Tarver T000045 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
26623 | 26623 | Henry Talle T000028 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
24130 | 24130 | Joseph Talbot T000018 | rep | CT | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
27558 | 27558 | John Taber T000001 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 36 | |||||||||||||
23269 | 23269 | Martin Sweeney S001102 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 20 | |||||||||||||
23263 | 23263 | William Sutphin S001086 | rep | NJ | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
24127 | 24127 | Hatton Sumners S001072 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
24110 | 24110 | Jessie Sumner S001071 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 18 | |||||||||||||
25511 | 25511 | John Sullivan S001056 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
24687 | 24687 | William Stratton S000998 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
23705 | 23705 | Arthur Stewart S000901 | sen | TN | 1939-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
24683 | 24683 | William Stevenson S000896 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
25495 | 25495 | Karl Stefan S000845 | rep | NE | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
23703 | 23703 | Foster Stearns S000823 | rep | NH | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
23700 | 23700 | Henry Steagall S000820 | rep | AL | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23685 | 23685 | Joe Starnes S000816 | rep | AL | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
24679 | 24679 | Raymond Springer S000755 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
23257 | 23257 | George Spencer S000724 | sen | AR | 1941-04-01 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
27538 | 27538 | Brent Spence S000717 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
30696 | 30696 | John Sparkman S000701 | rep | AL | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
23256 | 23256 | Charles South S000683 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
25035 | 25035 | Andrew Somers S000676 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
24102 | 24102 | John Snyder S000668 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 24 | |||||||||||||
23252 | 23252 | Martin Smith S000591 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
29041 | 29041 | Margaret Smith S000590 | rep | ME | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
26611 | 26611 | Lawrence Smith S000585 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23679 | 23679 | Joseph Smith S000580 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23247 | 23247 | John Smith S000572 | rep | CT | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
28662 | 28662 | Howard Smith S000554 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
25022 | 25022 | Frederick Smith S000536 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
23243 | 23243 | Francis Smith S000532 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
22414 | 22414 | William Smathers S000506 | sen | NJ | 1937-04-15 | 1943-01-03 | 2 | Democrat | |||||||||||||
27004 | 27004 | Richard Simpson S000436 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 18 | |||||||||||||
23242 | 23242 | Kenneth Simpson S000433 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
31800 | 31800 | Robert Sikes S000406 | rep | FL | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23340 | 23340 | Hugh Shott S000381 | sen | WV | 1942-01-01 | 1943-01-03 | 2 | Republican | |||||||||||||
26120 | 26120 | Dewey Short S000377 | rep | MO | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
24093 | 24093 | John Sheridan S000342 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
28141 | 28141 | Harry Sheppard S000335 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 19 | |||||||||||||
23237 | 23237 | Joseph Shannon S000287 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23231 | 23231 | James Shanley S000285 | rep | CT | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
25801 | 25801 | Paul Shafer S000277 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
28647 | 28647 | Robert Secrest S000219 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
30071 | 30071 | Hugh Scott S000174 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 7 | |||||||||||||
23227 | 23227 | Pius Schwert S000162 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 42 | |||||||||||||
22401 | 22401 | Henry Schwartz S000157 | sen | WY | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23225 | 23225 | William Schulte S000145 | rep | IN | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23671 | 23671 | Leonard Schuetz S000144 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
23220 | 23220 | Edwin Schaefer S000110 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 22 | |||||||||||||
23662 | 23662 | Thomas Scanlon S000105 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 30 |
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);