legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1937-01-03 sorted by class
This data as json, copyable, CSV (advanced)
Suggested facets: start (date)
start 12 ✖
- 1935-01-03 446
- 1931-12-07 25
- 1933-03-09 5
- 1933-10-10 1
- 1934-01-01 1
- 1935-12-27 1
- 1936-01-01 1
- 1936-01-31 1
- 1936-05-26 1
- 1936-07-01 1
- 1936-11-03 1
- 1936-11-19 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21606 | 21606 | Jackson Adair A000025 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21614 | 21614 | Abram Andrew A000240 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
21621 | 21621 | William Arnold A000300 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
21628 | 21628 | Roy Ayers A000352 | rep | MT | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21639 | 21639 | Isaac Bacharach B000009 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
21642 | 21642 | William Berlin B000409 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 28 | |||||||||||||
21652 | 21652 | Thomas Blanton B000549 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
21654 | 21654 | Martin Brennan B000799 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
21656 | 21656 | Joshua Brooks B000882 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 30 | |||||||||||||
21660 | 21660 | William Brunner B000981 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21665 | 21665 | John Buckbee B001020 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 12 | |||||||||||||
21669 | 21669 | George Burnham B001124 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 20 | |||||||||||||
21683 | 21683 | Joseph Byrns B001217 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
21686 | 21686 | Cap Carden C000140 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21688 | 21688 | Archibald Carmichael C000159 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
21690 | 21690 | William Carpenter C000173 | rep | KS | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21693 | 21693 | Glover Cary C000214 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21696 | 21696 | Bryant Castellow C000240 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
21699 | 21699 | Peter Cavicchia C000262 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 11 | |||||||||||||
21701 | 21701 | Theodore Christianson C000381 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
21703 | 21703 | James Claiborne C000402 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
21705 | 21705 | Samuel Collins C000643 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21709 | 21709 | Francis Condon C000673 | rep | RI | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21720 | 21720 | John Cooper C000757 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21730 | 21730 | Parker Corning C000785 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 28 | |||||||||||||
21734 | 21734 | Oliver Cross C000931 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
21736 | 21736 | Cleveland Dear D000177 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
21737 | 21737 | Francisco Delgado D000218 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
21738 | 21738 | Charles Dietrich D000340 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21740 | 21740 | Donald Dobbins D000382 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
21746 | 21746 | Isaac Doutrich D000460 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21747 | 21747 | Denis Driscoll D000501 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
21749 | 21749 | Warren Duffey D000517 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
21750 | 21750 | James Duffy D000519 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 38 | |||||||||||||
21751 | 21751 | Aubert Dunn D000545 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
21758 | 21758 | Joe Eagle E000003 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
21759 | 21759 | Daniel Earhart E000006 | rep | OH | 1936-11-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
21760 | 21760 | William Ekwall E000098 | rep | OR | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21761 | 21761 | Clare Fenerty F000071 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21764 | 21764 | William Fiesinger F000114 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
21768 | 21768 | Percy Gassaway G000094 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21772 | 21772 | William Granfield G000372 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21774 | 21774 | Isabella Greenway G000435 | rep | AZ | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
21779 | 21779 | William Gregory G000448 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21789 | 21789 | Anthony Griffin G000457 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
21796 | 21796 | Pedro Guevara G000518 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
21801 | 21801 | Simon Hamlin H000122 | rep | ME | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21802 | 21802 | Peter Hammond H000131 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
21804 | 21804 | William Higgins H000580 | rep | CT | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
21811 | 21811 | Samuel Hill H000607 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
21813 | 21813 | John Hoeppel H000677 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
21816 | 21816 | John Hollister H000728 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
21828 | 21828 | George Huddleston H000903 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
21829 | 21829 | Michael Igoe I000004 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
21832 | 21832 | Bernhard Jacobsen J000038 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21838 | 21838 | Florence Kahn K000002 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
21839 | 21839 | Henry Kimball K000183 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21856 | 21856 | Frederick Lehlbach L000222 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 12 | |||||||||||||
21858 | 21858 | Wesley Lloyd L000383 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21859 | 21859 | Verner Main M000071 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21861 | 21861 | Leroy Marshall M000158 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
21862 | 21862 | Harry Mason M000214 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
21871 | 21871 | John McDuffie M000427 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21879 | 21879 | John McSwain M000604 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21888 | 21888 | Schuyler Merritt M000663 | rep | CT | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
21891 | 21891 | Joseph Monaghan M000848 | rep | MT | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21895 | 21895 | Numa Montet M000862 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
21898 | 21898 | Edward Moran M000932 | rep | ME | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21899 | 21899 | Theodore Moritz M000962 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 32 | |||||||||||||
21910 | 21910 | William Oliver O000077 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21918 | 21918 | Tilman Parks P000075 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
21926 | 21926 | Randolph Perkins P000237 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
21940 | 21940 | Harry Ransley R000061 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
21942 | 21942 | William Richardson R000230 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
21946 | 21946 | William Rogers R000408 | rep | NH | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21949 | 21949 | Stephen Rudd R000496 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
21950 | 21950 | Richard Russell R000537 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
21958 | 21958 | John Sandlin S000043 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21968 | 21968 | William Sears S000211 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | -1 | |||||||||||||
21970 | 21970 | Frederick Sisson S000455 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 33 | |||||||||||||
21971 | 21971 | John Stewart S000915 | rep | DE | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
21973 | 21973 | William Thomas T000187 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 29 | |||||||||||||
21974 | 21974 | Richard Tonry T000311 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
21986 | 21986 | Charles Turpin T000433 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 12 | |||||||||||||
21993 | 21993 | Mell Underwood U000012 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
21994 | 21994 | Hubert Utterback U000036 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21996 | 21996 | Theodore Werner W000299 | rep | SD | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22007 | 22007 | Riley Wilson W000608 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22008 | 22008 | William Wilson W000622 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22010 | 22010 | Marion Zioncheck Z000011 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22024 | 22024 | Thomas Amlie A000176 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 1 | |||||||||||||
22033 | 22033 | Robert Bacon B000019 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
22038 | 22038 | Frederick Biermann B000449 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22041 | 22041 | Charles Binderup B000466 | rep | NE | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22045 | 22045 | Gerald Boileau B000598 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 7 | |||||||||||||
22060 | 22060 | John Boylan B000726 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
22073 | 22073 | James Buchanan B001006 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22087 | 22087 | Raymond Cannon C000124 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22090 | 22090 | William Citron C000397 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
22093 | 22093 | Charles Colden C000605 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 17 |
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);