legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1933-03-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31253 | 31253 | John Patman P000103 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
29675 | 29675 | Emanuel Celler C000264 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
29366 | 29366 | John McCormack M000364 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
28657 | 28657 | Howard Smith S000554 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
28532 | 28532 | Joseph Martin M000191 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 15 | |||||||||||||
28212 | 28212 | Carl Vinson V000105 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
27875 | 27875 | Joseph Hill H000598 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
27851 | 27851 | Carl Hayden H000385 | sen | AZ | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
27683 | 27683 | Clarence Cannon C000117 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
27553 | 27553 | John Taber T000001 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 36 | |||||||||||||
27533 | 27533 | Brent Spence S000717 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
27443 | 27443 | Samuel Rayburn R000082 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
27046 | 27046 | Gardner Withrow W000663 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
26986 | 26986 | Edith Rogers R000392 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
26956 | 26956 | Daniel Reed R000113 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 43 | |||||||||||||
26927 | 26927 | James Polk P000408 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
26868 | 26868 | William Hess H000550 | rep | OH | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
26800 | 26800 | Dennis Chavez C000338 | rep | NM | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
26677 | 26677 | Charles Wolverton W000683 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
26653 | 26653 | Richard Wigglesworth W000450 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 14 | |||||||||||||
26422 | 26422 | Thomas Jenkins J000088 | rep | OH | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
26300 | 26300 | Martin Dies D000338 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
26251 | 26251 | Jere Cooper C000755 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
26165 | 26165 | August Andresen A000239 | rep | MN | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
26136 | 26136 | Jesse Wolcott W000668 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
26009 | 26009 | Clifford Hope H000768 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
25874 | 25874 | Alben Barkley B000145 | sen | KY | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
25646 | 25646 | Robert Crosser C000932 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 21 | |||||||||||||
25558 | 25558 | Roy Woodruff W000718 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
25545 | 25545 | John Wood W000699 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
25466 | 25466 | Adolph Sabath S000001 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
25438 | 25438 | John Rankin R000056 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
25352 | 25352 | John Kerr K000138 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
25267 | 25267 | Walter George G000131 | sen | GA | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
25238 | 25238 | Charles Eaton E000023 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
25223 | 25223 | Robert Doughton D000448 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
25192 | 25192 | Edward Cox C000831 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
25088 | 25088 | William Whittington W000430 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
25064 | 25064 | Richard Welch W000265 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
25030 | 25030 | Andrew Somers S000676 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
25002 | 25002 | Robert Rich R000209 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 16 | |||||||||||||
24954 | 24954 | Mary Norton N000153 | rep | NJ | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
24939 | 24939 | Earl Michener M000693 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
24793 | 24793 | Virgil Chapman C000317 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
24779 | 24779 | Alfred Bulwinkle B001056 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
24763 | 24763 | Sol Bloom B000565 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 19 | |||||||||||||
24749 | 24749 | Schuyler Bland B000545 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
24692 | 24692 | Robert Thomason T000189 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 16 | |||||||||||||
24584 | 24584 | Joseph Mansfield M000112 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
24561 | 24561 | Louis Ludlow L000501 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
24542 | 24542 | Clarence Lea L000163 | rep | CA | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
24521 | 24521 | Harold Knutson K000301 | rep | MN | 1931-12-07 | 1933-03-03 | Republican | 6 | |||||||||||||
24461 | 24461 | Fred Hartley H000298 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
24418 | 24418 | Charles Gifford G000169 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 16 | |||||||||||||
24381 | 24381 | John Flannagan F000191 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
24360 | 24360 | Patrick Drewry D000496 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
24340 | 24340 | John Delaney D000212 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
24295 | 24295 | Jerome Clark C000439 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
24252 | 24252 | Walter Andrews A000250 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 40 | |||||||||||||
24233 | 24233 | Thomas Burch B001069 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
24221 | 24221 | Clifton Woodrum W000720 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
24209 | 24209 | James Wolfenden W000678 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
24192 | 24192 | Zebulon Weaver W000230 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
24179 | 24179 | Robert Wagner W000021 | sen | NY | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
24170 | 24170 | Millard Tydings T000446 | sen | MD | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
24154 | 24154 | John Thomas T000177 | sen | OK | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
24135 | 24135 | Malcolm Tarver T000045 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
24122 | 24122 | Hatton Sumners S001072 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
24052 | 24052 | Robert Ramspeck R000032 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
24035 | 24035 | William Pittenger P000371 | rep | MN | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
24019 | 24019 | John Overton O000146 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
23975 | 23975 | Andrew May M000272 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
23967 | 23967 | Paul Maloney M000091 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23952 | 23952 | Fritz Lanham L000076 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
23931 | 23931 | John Kinzer K000231 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
23923 | 23923 | Edward Kelly K000071 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23915 | 23915 | Luther Johnson J000159 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23903 | 23903 | Jed Johnson J000150 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23882 | 23882 | Pehr Holmes H000741 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
23868 | 23868 | Butler Hare H000200 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23857 | 23857 | Clarence Hancock H000146 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 35 | |||||||||||||
23830 | 23830 | Samuel Dickstein D000335 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
23806 | 23806 | John Cochran C000565 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
23720 | 23720 | Allen Treadway T000358 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
23708 | 23708 | John Thomas T000172 | sen | ID | 1928-06-30 | 1933-03-03 | 3 | Republican | appointment | ||||||||||||
23695 | 23695 | Henry Steagall S000820 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23674 | 23674 | Joseph Smith S000580 | rep | WV | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23666 | 23666 | Leonard Schuetz S000144 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
23624 | 23624 | Cameron Morrison M000993 | sen | NC | 1930-12-13 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
23587 | 23587 | Melvin Maas M000001 | rep | MN | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
23572 | 23572 | William Lambertson L000037 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
23564 | 23564 | Richard Kleberg K000257 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 14 | |||||||||||||
23557 | 23557 | Martin Kennedy K000111 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 18 | |||||||||||||
23539 | 23539 | Ulysses Guyer G000538 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
23529 | 23529 | Robert Green G000415 | rep | FL | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23505 | 23505 | Fred Gilchrist G000181 | rep | IA | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
23498 | 23498 | Joseph Gavagan G000101 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 21 | |||||||||||||
23486 | 23486 | Hampton Fulmer F000417 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
23468 | 23468 | James Fitzpatrick F000175 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 24 | |||||||||||||
23459 | 23459 | Hamilton Fish F000142 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 26 |
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);