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 party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, start (date), end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
20230 | 20230 | Marcus Coolidge C000740 | sen | MA | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
20250 | 20250 | Edward Costigan C000797 | sen | CO | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
20433 | 20433 | Thomas Gore G000323 | sen | OK | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
20815 | 20815 | Joseph Robinson R000347 | sen | AR | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
21105 | 21105 | Nathan Bachman B000010 | sen | TN | 1933-03-09 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
21263 | 21263 | Duncan Fletcher F000200 | sen | FL | 1933-03-09 | 1937-01-03 | 3 | Democrat | |||||||||||||
21446 | 21446 | Richard Murphy M001103 | sen | IA | 1933-03-09 | 1937-01-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
21974 | 21974 | Richard Tonry T000311 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
22013 | 22013 | Prentiss Brown B000941 | sen | MI | 1936-11-19 | 1937-01-03 | 2 | Democrat | |||||||||||||
22015 | 22015 | William Hill H000612 | sen | FL | 1936-07-01 | 1937-01-03 | 3 | Democrat | appointment | ||||||||||||
22018 | 22018 | Scott Loftin L000400 | sen | FL | 1936-05-26 | 1937-01-03 | 1 | Democrat | appointment | ||||||||||||
22019 | 22019 | Rose Long L000427 | sen | LA | 1936-01-31 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
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 | |||||||||||||
22075 | 22075 | William Bulow B001055 | sen | SD | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22084 | 22084 | James Byrnes B001215 | sen | SC | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
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 |
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);