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 1935-01-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22009 | 22009 | Marion Zioncheck Z000011 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
28746 | 28746 | Stephen Young Y000053 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
24222 | 24222 | Clifton Woodrum W000720 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
25559 | 25559 | Roy Woodruff W000718 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
22836 | 22836 | Reuben Wood W000702 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
25546 | 25546 | John Wood W000699 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
26678 | 26678 | Charles Wolverton W000683 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
24210 | 24210 | James Wolfenden W000678 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 8 | |||||||||||||
26137 | 26137 | Jesse Wolcott W000668 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
27047 | 27047 | Gardner Withrow W000663 | rep | WI | 1933-03-09 | 1935-01-03 | Republican | 3 | |||||||||||||
22006 | 22006 | Riley Wilson W000608 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
23324 | 23324 | Clyde Williams W000494 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21603 | 21603 | Albert Willford W000485 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22460 | 22460 | James Wilcox W000455 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
26654 | 26654 | Richard Wigglesworth W000450 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
25089 | 25089 | William Whittington W000430 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21602 | 21602 | James Whitley W000420 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 38 | |||||||||||||
25077 | 25077 | Compton White W000361 | rep | ID | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23319 | 23319 | Burton Wheeler W000330 | sen | MT | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
24712 | 24712 | Milton West W000304 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
21599 | 21599 | Charles West W000301 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
21995 | 21995 | Theodore Werner W000299 | rep | SD | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
25065 | 25065 | Richard Welch W000265 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
21597 | 21597 | Carl Weideman W000254 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
24193 | 24193 | Zebulon Weaver W000230 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
22457 | 22457 | Otha Wearin W000221 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21596 | 21596 | Henry Watson W000201 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 9 | |||||||||||||
22828 | 22828 | Lindsay Warren W000166 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
28232 | 28232 | Francis Walter W000108 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 21 | |||||||||||||
23315 | 23315 | David Walsh W000097 | sen | MA | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
22841 | 22841 | Monrad Wallgren W000088 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21586 | 21586 | Alfred Waldron W000040 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 3 | |||||||||||||
20029 | 20029 | Frederic Walcott W000032 | sen | CT | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
25050 | 25050 | James Wadsworth W000012 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 39 | |||||||||||||
22454 | 22454 | Frederick Vinson V000106 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
28213 | 28213 | Carl Vinson V000105 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
24708 | 24708 | Arthur Vandenberg V000025 | sen | MI | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21585 | 21585 | John Utterback U000037 | rep | ME | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21992 | 21992 | Mell Underwood U000012 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
24246 | 24246 | William Umstead U000005 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21985 | 21985 | Charles Turpin T000433 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 12 | |||||||||||||
22818 | 22818 | Clarence Turner T000417 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21981 | 21981 | Charles Truax T000386 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23721 | 23721 | Allen Treadway T000358 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
21979 | 21979 | Park Trammell T000353 | sen | FL | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21584 | 21584 | William Traeger T000349 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 15 | |||||||||||||
21975 | 21975 | John Townsend T000335 | sen | DE | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
25520 | 25520 | Charles Tobey T000289 | rep | NH | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
23305 | 23305 | George Tinkham T000283 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
22445 | 22445 | Lloyd Thurston T000257 | rep | IA | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
21583 | 21583 | William Thompson T000225 | sen | NE | 1933-05-24 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
28693 | 28693 | Clark Thompson T000198 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22438 | 22438 | Chester Thompson T000197 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
24693 | 24693 | Robert Thomason T000189 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
21972 | 21972 | William Thomas T000187 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 29 | |||||||||||||
24144 | 24144 | William Thom T000155 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
23289 | 23289 | David Terry T000133 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21582 | 21582 | George Terrell T000129 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22434 | 22434 | John Taylor T000087 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22812 | 22812 | James Taylor T000083 | rep | TN | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
23282 | 23282 | Edward Taylor T000072 | rep | CO | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
24136 | 24136 | Malcolm Tarver T000045 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
27554 | 27554 | John Taber T000001 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 36 | |||||||||||||
21581 | 21581 | Jesse Swick S001114 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 26 | |||||||||||||
23265 | 23265 | Martin Sweeney S001102 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 20 | |||||||||||||
21577 | 21577 | Fletcher Swank S001089 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
23259 | 23259 | William Sutphin S001086 | rep | NJ | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
24123 | 24123 | Hatton Sumners S001072 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22800 | 22800 | Christopher Sullivan S001051 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 13 | |||||||||||||
21571 | 21571 | Elmer Studley S001041 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22430 | 22430 | Henry Stubbs S001038 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
21570 | 21570 | Sterling Strong S001019 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21569 | 21569 | Nathan Strong S001015 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 27 | |||||||||||||
21560 | 21560 | Edward Stokes S000946 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 6 | |||||||||||||
19996 | 19996 | Hubert Stephens S000857 | sen | MS | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
23696 | 23696 | Henry Steagall S000820 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21556 | 21556 | Gale Stalker S000783 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 37 | |||||||||||||
27534 | 27534 | Brent Spence S000717 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
25031 | 25031 | Andrew Somers S000676 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
24098 | 24098 | John Snyder S000668 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 24 | |||||||||||||
22425 | 22425 | Bertrand Snell S000652 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 31 | |||||||||||||
23248 | 23248 | Martin Smith S000591 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
23675 | 23675 | Joseph Smith S000580 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
28658 | 28658 | Howard Smith S000554 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21969 | 21969 | Frederick Sisson S000455 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 33 | |||||||||||||
22778 | 22778 | William Sirovich S000452 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
21550 | 21550 | James Sinclair S000442 | rep | ND | 1933-03-09 | 1935-01-03 | Republican | -1 | |||||||||||||
21542 | 21542 | James Simpson S000431 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
21541 | 21541 | Francis Shoemaker S000374 | rep | MN | 1933-03-09 | 1935-01-03 | Farmer-Labor | 0 | |||||||||||||
23239 | 23239 | Henrik Shipstead S000369 | sen | MN | 1929-04-15 | 1935-01-03 | 1 | Farmer-Labor | |||||||||||||
23233 | 23233 | Joseph Shannon S000287 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21540 | 21540 | Ashton Shallenberger S000280 | rep | NE | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22771 | 22771 | George Seger S000228 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 8 | |||||||||||||
28643 | 28643 | Robert Secrest S000219 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
21967 | 21967 | William Sears S000211 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | -1 | |||||||||||||
23333 | 23333 | James Scrugham S000196 | rep | NV | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23221 | 23221 | William Schulte S000145 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23667 | 23667 | Leonard Schuetz S000144 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
23216 | 23216 | Edwin Schaefer S000110 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 22 | |||||||||||||
21957 | 21957 | John Sandlin S000043 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 4 |
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);