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 legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21729 | 21729 | Parker Corning C000785 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 28 | |||||||||||||
25193 | 25193 | Edward Cox C000831 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22529 | 22529 | William Cravens C000886 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22103 | 22103 | Charles Crosby C000928 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 29 | |||||||||||||
21733 | 21733 | Oliver Cross C000931 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
25647 | 25647 | Robert Crosser C000932 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 21 | |||||||||||||
22534 | 22534 | Eugene Crowe C000940 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22952 | 22952 | Frank Crowther C000948 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 30 | |||||||||||||
21219 | 21219 | Edward Crump C000955 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
23388 | 23388 | Francis Culkin C000968 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 32 | |||||||||||||
23401 | 23401 | Thomas Cullen C000970 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22538 | 22538 | Fred Cummings C000985 | rep | CO | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
19647 | 19647 | Bronson Cutting C001028 | sen | NM | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
22957 | 22957 | Colgate Darden D000050 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22558 | 22558 | George Darrow D000063 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
21735 | 21735 | Cleveland Dear D000177 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22107 | 22107 | Braswell Deen D000187 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
24341 | 24341 | John Delaney D000212 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21222 | 21222 | Oscar De Priest D000263 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
22567 | 22567 | René De Rouen D000265 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21233 | 21233 | Clement Dickinson D000316 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23831 | 23831 | Samuel Dickstein D000335 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
26301 | 26301 | Martin Dies D000338 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
19668 | 19668 | Clarence Dill D000345 | sen | WA | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
23412 | 23412 | Anthony Dimond D000353 | rep | AK | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
25911 | 25911 | John Dingell D000354 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
27742 | 27742 | Everett Dirksen D000360 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 16 | |||||||||||||
23419 | 23419 | Wesley Disney D000362 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23425 | 23425 | John Ditter D000363 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 17 | |||||||||||||
21739 | 21739 | Donald Dobbins D000382 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 19 | |||||||||||||
22111 | 22111 | John Dockweiler D000387 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
25929 | 25929 | George Dondero D000411 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 17 | |||||||||||||
25224 | 25224 | Robert Doughton D000448 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21240 | 21240 | John Douglass D000459 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
21745 | 21745 | Isaac Doutrich D000460 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 19 | |||||||||||||
22580 | 22580 | Cassius Dowell D000468 | rep | IA | 1933-03-09 | 1935-01-03 | Republican | 6 | |||||||||||||
22965 | 22965 | Wall Doxey D000480 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
24361 | 24361 | Patrick Drewry D000496 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22123 | 22123 | William Driver D000503 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
21748 | 21748 | Warren Duffey D000517 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22970 | 22970 | Richard Duncan D000536 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22583 | 22583 | Matthew Dunn D000551 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 34 | |||||||||||||
21242 | 21242 | George Durgan D000570 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21757 | 21757 | Joe Eagle E000003 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
25239 | 25239 | Charles Eaton E000023 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
22977 | 22977 | Andrew Edmiston E000051 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21249 | 21249 | George Edmonds E000053 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
21251 | 21251 | Lawrence Ellzey E000152 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21252 | 21252 | Ralph Eltse E000162 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
23445 | 23445 | Harry Englebright E000182 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
21253 | 21253 | John Erickson E000202 | sen | MT | 1933-03-13 | 1935-01-03 | 2 | Democrat | appointment | ||||||||||||
21257 | 21257 | William Evans E000261 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 11 | |||||||||||||
22985 | 22985 | Charles Faddis F000001 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 25 | |||||||||||||
22134 | 22134 | James Farley F000019 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22595 | 22595 | Joachim Fernández F000086 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
19702 | 19702 | Simeon Fess F000096 | sen | OH | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21763 | 21763 | William Fiesinger F000114 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 13 | |||||||||||||
23460 | 23460 | Hamilton Fish F000142 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 26 | |||||||||||||
21258 | 21258 | John Fitzgibbons F000171 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23469 | 23469 | James Fitzpatrick F000175 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 24 | |||||||||||||
24382 | 24382 | John Flannagan F000191 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22140 | 22140 | Thomas Fletcher F000205 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22150 | 22150 | Benjamin Focht F000230 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 18 | |||||||||||||
23475 | 23475 | Thomas Ford F000267 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
21268 | 21268 | Frank Foss F000294 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 3 | |||||||||||||
21269 | 21269 | George Foulkes F000317 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21766 | 21766 | Lynn Frazier F000354 | sen | ND | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21280 | 21280 | James Frear F000355 | rep | WI | 1933-03-09 | 1935-01-03 | Republican | 9 | |||||||||||||
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 | |||||||||||||
23487 | 23487 | Hampton Fulmer F000417 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22166 | 22166 | Stephen Gambrill G000035 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21296 | 21296 | John Garner G000074 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | -1 | |||||||||||||
22174 | 22174 | Allard Gasque G000092 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
23499 | 23499 | Joseph Gavagan G000101 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 21 | |||||||||||||
24419 | 24419 | Charles Gifford G000169 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 15 | |||||||||||||
23506 | 23506 | Fred Gilchrist G000181 | rep | IA | 1933-03-09 | 1935-01-03 | Republican | 8 | |||||||||||||
21297 | 21297 | James Gillespie G000197 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
24832 | 24832 | Guy Gillette G000205 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21300 | 21300 | David Glover G000243 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
19732 | 19732 | Phillips Goldsborough G000262 | sen | MD | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
22619 | 22619 | Thomas Goldsborough G000265 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22182 | 22182 | Philip Goodwin G000302 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 27 | |||||||||||||
21303 | 21303 | Edward Goss G000334 | rep | CT | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
21771 | 21771 | William Granfield G000372 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22189 | 22189 | Finly Gray G000395 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
23530 | 23530 | Robert Green G000415 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21773 | 21773 | Isabella Greenway G000435 | rep | AZ | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22199 | 22199 | Arthur Greenwood G000437 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
22205 | 22205 | Glenn Griswold G000483 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21795 | 21795 | Pedro Guevara G000518 | rep | PI | 1933-03-09 | 1935-01-03 | 0 | ||||||||||||||
23540 | 23540 | Ulysses Guyer G000538 | rep | KS | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
23020 | 23020 | Harry Haines H000026 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 22 | |||||||||||||
21799 | 21799 | Frederick Hale H000031 | sen | ME | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21304 | 21304 | Finley Hamilton H000109 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23858 | 23858 | Clarence Hancock H000146 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 35 |
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);