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 party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21461 | 21461 | Camilo Osias O000118 | rep | PI | 1933-03-09 | 1935-01-03 | 0 | ||||||||||||||
21795 | 21795 | Pedro Guevara G000518 | rep | PI | 1933-03-09 | 1935-01-03 | 0 | ||||||||||||||
22632 | 22632 | Santiago Iglesias I000002 | rep | PR | 1933-03-09 | 1935-01-03 | Coalitionist | 0 | |||||||||||||
19668 | 19668 | Clarence Dill D000345 | sen | WA | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
19996 | 19996 | Hubert Stephens S000857 | sen | MS | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21072 | 21072 | Charles Abernethy A000015 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21073 | 21073 | Wilbur Adams A000050 | rep | DE | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21079 | 21079 | Miles Allgood A000156 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21089 | 21089 | Edward Almon A000162 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21095 | 21095 | Oscar Auf Der Heide A000338 | rep | NJ | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
21104 | 21104 | William Ayres A000354 | rep | KS | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21106 | 21106 | Joseph Bailey B000045 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21126 | 21126 | Loring Black B000505 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21141 | 21141 | Charles Brand B000767 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
21149 | 21149 | Clay Briggs B000826 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21162 | 21162 | John Brown B000934 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21168 | 21168 | Gordon Browning B000959 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21178 | 21178 | John Burke B001094 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 18 | |||||||||||||
21184 | 21184 | Thomas Busby B001163 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21185 | 21185 | Claude Cady C000013 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21189 | 21189 | Patrick Carley C000149 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21190 | 21190 | Terry Carpenter C000172 | rep | NE | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21198 | 21198 | Denver Church C000387 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21210 | 21210 | Thomas Coffin C000592 | rep | ID | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21219 | 21219 | Edward Crump C000955 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21233 | 21233 | Clement Dickinson D000316 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21240 | 21240 | John Douglass D000459 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
21242 | 21242 | George Durgan D000570 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21251 | 21251 | Lawrence Ellzey E000152 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21253 | 21253 | John Erickson E000202 | sen | MT | 1933-03-13 | 1935-01-03 | 2 | Democrat | appointment | ||||||||||||
21258 | 21258 | John Fitzgibbons F000171 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21269 | 21269 | George Foulkes F000317 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21296 | 21296 | John Garner G000074 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | -1 | |||||||||||||
21297 | 21297 | James Gillespie G000197 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
21300 | 21300 | David Glover G000243 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21304 | 21304 | Finley Hamilton H000109 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21305 | 21305 | Michael Hart H000290 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21314 | 21314 | William Hastings H000333 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21315 | 21315 | Charles Henney H000501 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21316 | 21316 | Einar Hoidale H000706 | rep | MN | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21323 | 21323 | Lynn Hornor H000792 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21329 | 21329 | Edgar Howard H000836 | rep | NE | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21330 | 21330 | James Hughes H000925 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21347 | 21347 | Lamar Jeffers J000068 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21364 | 21364 | Bolivar Kemp K000085 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21371 | 21371 | Frank Lee L000191 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21372 | 21372 | John Lehr L000228 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21378 | 21378 | George Lindsay L000325 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21389 | 21389 | Ralph Lozier L000489 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21393 | 21393 | James Major M000073 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 21 | |||||||||||||
21394 | 21394 | Ernest Marland M000138 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21396 | 21396 | Charles Martin M000173 | rep | OR | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21398 | 21398 | Lincoln McCandless M000307 | rep | HI | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21408 | 21408 | James McClintic M000338 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21430 | 21430 | Thomas McKeown M000511 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21437 | 21437 | Jacob Milligan M000766 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21443 | 21443 | John Morehead M000939 | rep | NE | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
21447 | 21447 | Harry Musselwhite M001122 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21448 | 21448 | Walter Nesbit N000048 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21452 | 21452 | Kathryn O’Loughlin McCarthy O000081 | rep | KS | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21458 | 21458 | Frank Oliver O000072 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 23 | |||||||||||||
21463 | 21463 | Homer Parker P000056 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
21498 | 21498 | Edward Pou P000474 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21504 | 21504 | Anning Prall P000495 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
21510 | 21510 | Heartsill Ragon R000009 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21525 | 21525 | Henry Rainey R000014 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 20 | |||||||||||||
21532 | 21532 | James Ruffin R000498 | 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 | |||||||||||||
21570 | 21570 | Sterling Strong S001019 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21571 | 21571 | Elmer Studley S001041 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21577 | 21577 | Fletcher Swank S001089 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21582 | 21582 | George Terrell T000129 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21583 | 21583 | William Thompson T000225 | sen | NE | 1933-05-24 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
21585 | 21585 | John Utterback U000037 | rep | ME | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21597 | 21597 | Carl Weideman W000254 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
21599 | 21599 | Charles West W000301 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
21603 | 21603 | Albert Willford W000485 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21604 | 21604 | Richard Hunter H000987 | sen | NE | 1934-01-01 | 1935-01-03 | 1 | Democrat | |||||||||||||
21605 | 21605 | Jackson Adair A000025 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
21620 | 21620 | William Arnold A000300 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 23 | |||||||||||||
21625 | 21625 | Henry Ashurst A000319 | sen | AZ | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21627 | 21627 | Roy Ayers A000352 | rep | MT | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21641 | 21641 | William Berlin B000409 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 28 | |||||||||||||
21651 | 21651 | Thomas Blanton B000549 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
21653 | 21653 | Martin Brennan B000799 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21655 | 21655 | Joshua Brooks B000882 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 30 | |||||||||||||
21659 | 21659 | William Brunner B000981 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21666 | 21666 | Edward Burke B001089 | rep | NE | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21682 | 21682 | Joseph Byrns B001217 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21685 | 21685 | Cap Carden C000140 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21687 | 21687 | Archibald Carmichael C000159 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21689 | 21689 | William Carpenter C000173 | rep | KS | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21692 | 21692 | Glover Cary C000214 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21695 | 21695 | Bryant Castellow C000240 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21702 | 21702 | James Claiborne C000402 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21708 | 21708 | Francis Condon C000673 | rep | RI | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
21722 | 21722 | Royal Copeland C000769 | sen | NY | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21729 | 21729 | Parker Corning C000785 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 28 | |||||||||||||
21733 | 21733 | Oliver Cross C000931 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
21735 | 21735 | Cleveland Dear D000177 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 8 |
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);