legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1935-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type
party 5 ✖
- Democrat 351
- Republican 114
- Progressive 8
- Farmer-Labor 3
- Coalitionist 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21737 | 21737 | Francisco Delgado D000218 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
21796 | 21796 | Pedro Guevara G000518 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
22362 | 22362 | Quintin Paredes P000050 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
22633 | 22633 | Santiago Iglesias I000002 | rep | PR | 1935-01-03 | 1937-01-03 | Coalitionist | 0 | |||||||||||||
21606 | 21606 | Jackson Adair A000025 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21621 | 21621 | William Arnold A000300 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
21626 | 21626 | Henry Ashurst A000319 | sen | AZ | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21628 | 21628 | Roy Ayers A000352 | rep | MT | 1935-01-03 | 1937-01-03 | Democrat | 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 | |||||||||||||
21667 | 21667 | Edward Burke B001089 | sen | NE | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
21703 | 21703 | James Claiborne C000402 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
21709 | 21709 | Francis Condon C000673 | rep | RI | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21723 | 21723 | Royal Copeland C000769 | sen | NY | 1935-01-03 | 1939-01-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
21741 | 21741 | Alvin Donahey D000410 | sen | OH | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
21817 | 21817 | Rush Holt H000749 | sen | WV | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
21845 | 21845 | William King K000216 | sen | UT | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21858 | 21858 | Wesley Lloyd L000383 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
21889 | 21889 | Sherman Minton M000800 | sen | IN | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
21896 | 21896 | Arthur Moore M000893 | sen | NJ | 1935-01-03 | 1939-01-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
21931 | 21931 | Key Pittman P000372 | sen | NV | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
21959 | 21959 | Lewis Schwellenbach S000160 | sen | WA | 1935-01-03 | 1940-12-16 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
21974 | 21974 | Richard Tonry T000311 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
21980 | 21980 | Park Trammell T000353 | sen | FL | 1935-01-03 | 1936-05-08 | 1 | Democrat | |||||||||||||
21982 | 21982 | Charles Truax T000386 | rep | OH | 1935-01-03 | 1935-08-09 | Democrat | 0 | |||||||||||||
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 | |||||||||||||
22010 | 22010 | Marion Zioncheck Z000011 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22012 | 22012 | Prentiss Brown B000941 | rep | MI | 1935-01-03 | 1936-11-18 | Democrat | 11 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
22101 | 22101 | William Connery C000694 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22104 | 22104 | Charles Crosby C000928 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 29 | |||||||||||||
22108 | 22108 | Braswell Deen D000187 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22112 | 22112 | John Dockweiler D000387 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
22114 | 22114 | Frank Dorsey D000438 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22124 | 22124 | William Driver D000503 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22126 | 22126 | Charles Eckert E000032 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 26 | |||||||||||||
22129 | 22129 | Edward Eicher E000094 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22132 | 22132 | Henry Ellenbogen E000111 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 33 | |||||||||||||
22135 | 22135 | James Farley F000019 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22141 | 22141 | Thomas Fletcher F000205 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22154 | 22154 | Oliver Frey F000382 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22159 | 22159 | Claude Fuller F000408 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22167 | 22167 | Stephen Gambrill G000035 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 5 |
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);