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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21739 | 21739 | Donald Dobbins D000382 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 19 | |||||||||||||
21748 | 21748 | Warren Duffey D000517 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21757 | 21757 | Joe Eagle E000003 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21763 | 21763 | William Fiesinger F000114 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 13 | |||||||||||||
21771 | 21771 | William Granfield G000372 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21773 | 21773 | Isabella Greenway G000435 | rep | AZ | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21778 | 21778 | William Gregory G000448 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21788 | 21788 | Anthony Griffin G000457 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 22 | |||||||||||||
21810 | 21810 | Samuel Hill H000607 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21812 | 21812 | John Hoeppel H000677 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
21827 | 21827 | George Huddleston H000903 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21831 | 21831 | Bernhard Jacobsen J000038 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21844 | 21844 | William King K000216 | sen | UT | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21857 | 21857 | Wesley Lloyd L000383 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21870 | 21870 | John McDuffie M000427 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
21878 | 21878 | John McSwain M000604 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21890 | 21890 | Joseph Monaghan M000848 | rep | MT | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
21894 | 21894 | Numa Montet M000862 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21897 | 21897 | Edward Moran M000932 | rep | ME | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21909 | 21909 | William Oliver O000077 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21917 | 21917 | Tilman Parks P000075 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21930 | 21930 | Key Pittman P000372 | sen | NV | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21941 | 21941 | William Richardson R000230 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
21945 | 21945 | William Rogers R000408 | rep | NH | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
21948 | 21948 | Stephen Rudd R000496 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21957 | 21957 | John Sandlin S000043 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21967 | 21967 | William Sears S000211 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | -1 | |||||||||||||
21969 | 21969 | Frederick Sisson S000455 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 33 | |||||||||||||
21979 | 21979 | Park Trammell T000353 | sen | FL | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21981 | 21981 | Charles Truax T000386 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21992 | 21992 | Mell Underwood U000012 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
21995 | 21995 | Theodore Werner W000299 | rep | SD | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22006 | 22006 | Riley Wilson W000608 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22009 | 22009 | Marion Zioncheck Z000011 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22011 | 22011 | Prentiss Brown B000941 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
22037 | 22037 | Frederick Biermann B000449 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22059 | 22059 | John Boylan B000726 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
22072 | 22072 | James Buchanan B001006 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
22086 | 22086 | Raymond Cannon C000124 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22092 | 22092 | Charles Colden C000605 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
22100 | 22100 | William Connery C000694 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22103 | 22103 | Charles Crosby C000928 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 29 | |||||||||||||
22107 | 22107 | Braswell Deen D000187 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22111 | 22111 | John Dockweiler D000387 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
22123 | 22123 | William Driver D000503 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22128 | 22128 | Edward Eicher E000094 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22131 | 22131 | Henry Ellenbogen E000111 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 33 | |||||||||||||
22134 | 22134 | James Farley F000019 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22140 | 22140 | Thomas Fletcher F000205 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22153 | 22153 | Oliver Frey F000382 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22158 | 22158 | Claude Fuller F000408 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22166 | 22166 | Stephen Gambrill G000035 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22174 | 22174 | Allard Gasque G000092 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22189 | 22189 | Finly Gray G000395 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
22199 | 22199 | Arthur Greenwood G000437 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22205 | 22205 | Glenn Griswold G000483 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22211 | 22211 | Franklin Hancock H000147 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22215 | 22215 | Byron Harlan H000209 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22229 | 22229 | Fred Hildebrandt H000584 | rep | SD | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22236 | 22236 | Virginia Jenckes J000077 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22241 | 22241 | Edward Kenney K000120 | rep | NJ | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22244 | 22244 | Frank Kloeb K000271 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22248 | 22248 | Frank Kniffin K000283 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22257 | 22257 | John Lambeth L000038 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22261 | 22261 | Arthur Lamneck L000040 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
22264 | 22264 | James Lanzetta L000091 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 20 | |||||||||||||
22272 | 22272 | David Lewis L000277 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22293 | 22293 | William McFarlane M000440 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 13 | |||||||||||||
22296 | 22296 | John McGrath M000457 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22301 | 22301 | James Meeks M000631 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 18 | |||||||||||||
22309 | 22309 | John Miller M000738 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22313 | 22313 | John Mitchell M000823 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22326 | 22326 | Andrew Montague M000861 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22341 | 22341 | John O’Connell O000025 | rep | RI | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22349 | 22349 | John O’Connor O000030 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
22352 | 22352 | Thomas O’Malley O000087 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22359 | 22359 | Vincent Palmisano P000046 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22367 | 22367 | Samuel Pettengill P000268 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22370 | 22370 | Theodore Peyser P000281 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
22380 | 22380 | Michael Reilly R000155 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22391 | 22391 | Morgan Sanders S000037 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22430 | 22430 | Henry Stubbs S001038 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
22434 | 22434 | John Taylor T000087 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22438 | 22438 | Chester Thompson T000197 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
22454 | 22454 | Frederick Vinson V000106 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22457 | 22457 | Otha Wearin W000221 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22460 | 22460 | James Wilcox W000455 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22496 | 22496 | William Bankhead B000113 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22511 | 22511 | Millard Caldwell C000038 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22529 | 22529 | William Cravens C000886 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22534 | 22534 | Eugene Crowe C000940 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22538 | 22538 | Fred Cummings C000985 | rep | CO | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22567 | 22567 | René De Rouen D000265 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22583 | 22583 | Matthew Dunn D000551 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 34 | |||||||||||||
22595 | 22595 | Joachim Fernández F000086 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22619 | 22619 | Thomas Goldsborough G000265 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22645 | 22645 | John Jones J000236 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 18 | |||||||||||||
22650 | 22650 | Kent Keller K000056 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 25 | |||||||||||||
22655 | 22655 | Ambrose Kennedy K000101 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22691 | 22691 | John Martin M000186 | rep | CO | 1933-03-09 | 1935-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);