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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32241 | 32241 | Jennings Randolph R000046 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
31254 | 31254 | John Patman P000103 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
29696 | 29696 | William Colmer C000645 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
29676 | 29676 | Emanuel Celler C000264 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
29367 | 29367 | John McCormack M000364 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
28746 | 28746 | Stephen Young Y000053 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
28693 | 28693 | Clark Thompson T000198 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
28658 | 28658 | Howard Smith S000554 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
28643 | 28643 | Robert Secrest S000219 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
28533 | 28533 | Joseph Martin M000191 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 14 | |||||||||||||
28373 | 28373 | Harold Cooley C000736 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
28232 | 28232 | Francis Walter W000108 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 21 | |||||||||||||
28213 | 28213 | Carl Vinson V000105 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
28053 | 28053 | Thomas O’Brien O000016 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
27876 | 27876 | Joseph Hill H000598 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
27742 | 27742 | Everett Dirksen D000360 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 16 | |||||||||||||
27684 | 27684 | Clarence Cannon C000117 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
27554 | 27554 | John Taber T000001 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 36 | |||||||||||||
27534 | 27534 | Brent Spence S000717 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
27487 | 27487 | Absalom Robertson R000317 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
27464 | 27464 | Brazilla Reece R000108 | rep | TN | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
27444 | 27444 | Samuel Rayburn R000082 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
27047 | 27047 | Gardner Withrow W000663 | rep | WI | 1933-03-09 | 1935-01-03 | Republican | 3 | |||||||||||||
26987 | 26987 | Edith Rogers R000392 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
26957 | 26957 | Daniel Reed R000113 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 43 | |||||||||||||
26928 | 26928 | James Polk P000408 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
26869 | 26869 | William Hess H000550 | rep | OH | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
26801 | 26801 | Dennis Chavez C000338 | rep | NM | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
26775 | 26775 | Harry Byrd B001208 | sen | VA | 1933-03-09 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
26748 | 26748 | Paul Brown B000940 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
26692 | 26692 | Leo Allen A000138 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
26678 | 26678 | Charles Wolverton W000683 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
26654 | 26654 | Richard Wigglesworth W000450 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
26423 | 26423 | Thomas Jenkins J000088 | rep | OH | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
26301 | 26301 | Martin Dies D000338 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
26252 | 26252 | Jere Cooper C000755 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
26137 | 26137 | Jesse Wolcott W000668 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
26104 | 26104 | James Richards R000214 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
26010 | 26010 | Clifford Hope H000768 | rep | KS | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
25929 | 25929 | George Dondero D000411 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 17 | |||||||||||||
25911 | 25911 | John Dingell D000354 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
25858 | 25858 | Joseph O’Mahoney O000088 | sen | WY | 1933-12-18 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
25647 | 25647 | Robert Crosser C000932 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 21 | |||||||||||||
25559 | 25559 | Roy Woodruff W000718 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
25546 | 25546 | John Wood W000699 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
25520 | 25520 | Charles Tobey T000289 | rep | NH | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
25467 | 25467 | Adolph Sabath S000001 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
25439 | 25439 | John Rankin R000056 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
25427 | 25427 | Robert Ramsay R000025 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
25353 | 25353 | John Kerr K000138 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
25338 | 25338 | John Kee K000039 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
25239 | 25239 | Charles Eaton E000023 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
25224 | 25224 | Robert Doughton D000448 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
25193 | 25193 | Edward Cox C000831 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
25089 | 25089 | William Whittington W000430 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
25077 | 25077 | Compton White W000361 | rep | ID | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
25065 | 25065 | Richard Welch W000265 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
25050 | 25050 | James Wadsworth W000012 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 39 | |||||||||||||
25031 | 25031 | Andrew Somers S000676 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
25011 | 25011 | George Sadowski S000011 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
25003 | 25003 | Robert Rich R000209 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 16 | |||||||||||||
24992 | 24992 | Charles Plumley P000395 | rep | VT | 1933-03-09 | 1935-01-03 | Republican | 0 | |||||||||||||
24972 | 24972 | James Peterson P000261 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
24955 | 24955 | Mary Norton N000153 | rep | NJ | 1933-03-09 | 1935-01-03 | Democrat | 13 | |||||||||||||
24889 | 24889 | John Lesinski L000251 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
24881 | 24881 | William Lemke L000238 | rep | ND | 1933-03-09 | 1935-01-03 | Republican | 0 | |||||||||||||
24832 | 24832 | Guy Gillette G000205 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
24794 | 24794 | Virgil Chapman C000317 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
24780 | 24780 | Alfred Bulwinkle B001056 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
24764 | 24764 | Sol Bloom B000565 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 19 | |||||||||||||
24750 | 24750 | Schuyler Bland B000545 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
24712 | 24712 | Milton West W000304 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
24708 | 24708 | Arthur Vandenberg V000025 | sen | MI | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
24693 | 24693 | Robert Thomason T000189 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
24609 | 24609 | Kenneth McKellar M000499 | sen | TN | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
24585 | 24585 | Joseph Mansfield M000112 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
24562 | 24562 | Louis Ludlow L000501 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
24543 | 24543 | Clarence Lea L000163 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
24522 | 24522 | Harold Knutson K000301 | rep | MN | 1933-03-09 | 1935-01-03 | Republican | 0 | |||||||||||||
24462 | 24462 | Fred Hartley H000298 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
24419 | 24419 | Charles Gifford G000169 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 15 | |||||||||||||
24382 | 24382 | John Flannagan F000191 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
24361 | 24361 | Patrick Drewry D000496 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
24341 | 24341 | John Delaney D000212 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
24319 | 24319 | Thomas Connally C000684 | sen | TX | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
24296 | 24296 | Jerome Clark C000439 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
24253 | 24253 | Walter Andrews A000250 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 40 | |||||||||||||
24246 | 24246 | William Umstead U000005 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
24234 | 24234 | Thomas Burch B001069 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
24222 | 24222 | Clifton Woodrum W000720 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
24210 | 24210 | James Wolfenden W000678 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 8 | |||||||||||||
24193 | 24193 | Zebulon Weaver W000230 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
24144 | 24144 | William Thom T000155 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
24136 | 24136 | Malcolm Tarver T000045 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
24123 | 24123 | Hatton Sumners S001072 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
24098 | 24098 | John Snyder S000668 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 24 | |||||||||||||
24063 | 24063 | James Robinson R000341 | rep | UT | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
24053 | 24053 | Robert Ramspeck R000032 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
24042 | 24042 | David Powers P000488 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 4 | |||||||||||||
23993 | 23993 | James Mott M001040 | rep | OR | 1933-03-09 | 1935-01-03 | Republican | 1 |
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);